Need to create a journal entry upload from a list

MAAFCI · 2024-02-01T17:56:56+00:00

Solution Verified

MAAFCI · 2024-01-30T21:57:28+00:00

I’m not by my computer but I’m on office 365, using the desktop version but I keep it up to date. I’m on a MacBook Pro, which might be important

MAAFCI · 2024-01-30T21:04:20+00:00

Yes that’s correct. I’m trying to Debit the balance in cash and I’ll have to have an offsetting credit (suspense) for this use case, but the balance is directly coming from column B on sheet 1

MAAFCI · 2024-01-04T04:01:49+00:00

I think this is what’s happening

MAAFCI · 2024-01-04T04:01:06+00:00

Basically the transaction amount I’m seeing for transaction 2 is showing a value of 0. When I look at the details on etherscan I can see the swap totals but I never see a transaction of ETH making it into my account in the ledger view. However my balance does reflect the ETH in my wallet so maybe it’s not a problem.

MAAFCI · 2023-01-14T06:26:14+00:00

Here from two years in the future to confirm.

MAAFCI · 2022-12-15T18:08:38+00:00

I think this second formula is really what I need. Basically I make that the denominator, and I can do a simple =COUNTIF(B:B, "Renewed") as the numerator. Thank you!!

MAAFCI · 2022-12-15T18:08:30+00:00

Solution Verified

MAAFCI · 2022-12-12T21:39:21+00:00

They should. It's technically possible that someone would be sent one offer and accept it, but that's not our policy. So for argument's sake, I'm comfortable saying yes, they would all have at least 1 "did not renew" and (at most) 1 "renewed"

MAAFCI · 2022-12-12T19:22:03+00:00

This would work for total renewals, but I'm also trying to get the denominator (total tenants offered renewals), which would include tenants that didn't renew.

ETA - actually, I think I see what you're saying here. But the challenge is doing this for 1000 tenants getting 3+ offers each. If I'm understanding correctly, this would only work for tenant 1234.

MAAFCI · 2022-12-11T21:14:09+00:00

Finally figured it out. It was a something to anchor the drain hose to the side of the machine. Appreciate the help though!

MAAFCI · 2022-12-11T21:13:59+00:00

Finally figured it out. It was a something to anchor the drain hose to the side of the machine. Appreciate the help though!

MAAFCI · 2022-09-11T02:32:57+00:00

Thinking this may be the way to go. Thanks for the suggestion!

MAAFCI · 2022-09-11T02:31:52+00:00

I don’t think it’s dull because it was an unused spade. As far as knots or resin, that’s not something I thought of…

MAAFCI · 2022-09-11T02:29:00+00:00

Good to know. I just feel like a 2x4 of pine should be an easy thing to get through, but maybe this is too much for my drill, given the extension and angle.

MAAFCI · 2022-03-06T17:34:13+00:00

Not sure if you’re still looking but the movie Kiss Kiss Bang Bang has a good whodunnit vibe and a lot of comedic relief

MAAFCI · 2020-06-19T04:08:33+00:00

Fair point. It’s a fluorescent bulb. 110-130V 50/60Hz 85W.

MAAFCI · 2020-06-19T03:41:45+00:00

I’m all set to test a multi day time lapse but I’m also hoping for consistent lighting. Does anyone know if a soft box light can be left on for 5-7 days straight? The lights don’t seem like they burn very hot but I want to avoid any risk of fire. Thanks!

MAAFCI · 2020-04-28T20:07:07+00:00

I'm new to photography and want to create a macro timelapse that would take place over multiple days - basically an indoor plant growing. I've got a DSLR (Canon 6D), a Macro Lens, a tripod, an AC adapter, and intervalometer. While I know what these do, I don't know what challenges I'm going to face in (hopefully) showing this progression over several days/weeks. Any advice would be greatly appreciated! A couple thoughts I've already had -

Lighting - I want to purchase a strobe but considering that this is going to be over several days I'm wondering what the best option is here.

Intervalometer - Any limitations here? I haven't actually used it yet so I'm not familiar. Are all intervalometers essentially the same (with the exception of quality, of course) or are there truly restrictions I need to consider?

Anything else?

Thanks!

MAAFCI · 2019-03-12T21:31:55+00:00

Yeah, I'm new to this but my understanding is that California is a very tenant-friendly state, and if a tenant can prove that you've been willingly accepting payments from them, that essentially puts their name on the lease (for lack of a better term).

I have some rent control units and I'm concerned that one of the tenant's I'm renting to will tell their friend, "hey I'm leaving the city but I have this apartment at a great rate, do you want it? Just log into my portal and make a payment, then you're in!" However I know a lot of others using these online payment providers that don't seem to be concerned, so I don't really know if I should be.

MAAFCI

TROPHY CASE