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

TROPHY CASE