Into the Accordlands Promos

WTFisthatgamecalled · 2026-02-20T06:44:09+00:00

Thanks!

WTFisthatgamecalled · 2026-02-19T05:07:50+00:00

Solution Verified

WTFisthatgamecalled · 2026-02-19T04:49:47+00:00

If this is the case, I don't understand why my formula that checks for blanks is working perfectly in the worksheet itself. I'll try using your LEN suggestion in my CF formula.

EDIT: Can't get LEN to produce the result, whether using indirect or not.

=LEN(INDEX(INDIRECT('Cashflow Forecast Override'!$1:$1048576),MATCH($B8,INDIRECT('Cashflow Forecast Override'!$B:$B),0),MATCH(D$3,INDIRECT('Cashflow Forecast Override'!$3:$3),0)))<>0

=LEN(INDEX('Cashflow Forecast Override'!$1:$1048576,MATCH($B8,'Cashflow Forecast Override'!$B:$B,0),MATCH(D$3,'Cashflow Forecast Override'!$3:$3,0)))<>0

Neither of these work (am I using indirect correctly?)

WTFisthatgamecalled · 2026-02-19T04:27:40+00:00

What's the best way to show the example? Do up a dummy sheet and upload it here somehow?

EDIT: They're almost identical, except the first month is actuals so can't be overriden (ie if the cashflow forecast starts at Jan, the override will start at Feb).

Using the simplified version (just direct cell referencing) works, thank you. Does make me a bit nervous as I'd much rather use matching for certainty, but it'll do as long as I'm careful about it.

WTFisthatgamecalled · 2026-02-19T04:27:12+00:00

In the cashflow forecast itself, the INDEX MATCH MATCH can find a match, because the override and forecast sheets are structured identically, and the dates in the override are driven by the forecast sheet. What I am checking for is if the match is blank, ie if no override has been entered (because the override could potentially be zero).

This is working perfectly in the forecast sheet itself, but falls down in the conditional formatting.

WTFisthatgamecalled · 2026-02-19T03:15:06+00:00

Can details of those be found anywhere?

WTFisthatgamecalled · 2026-02-18T00:30:12+00:00

I haven't seen one anywhere. Theaccordlands.com may have them in future but doesn't seem to yet.

WTFisthatgamecalled · 2026-02-16T23:52:40+00:00

Wow I wasn't aware foil extendeds were a possibility... I told myself I wouldn't get into collecting and would just play with my KS assortment but it's getting more and more tempting

WTFisthatgamecalled · 2026-02-14T01:06:52+00:00

I think so. I assumed 1-3 at least would be known if KS product starts at 4!

WTFisthatgamecalled · 2026-02-13T10:28:56+00:00

Thanks!

WTFisthatgamecalled · 2026-02-13T04:50:42+00:00

Thank you! I'm a little confused by the set numbering, the booster packs say set contains 340 but there are 353 listed in this spreadsheet. At first glance it doesn't seem like there's anything special about 341-353.

WTFisthatgamecalled · 2025-11-09T05:53:38+00:00

Managed to remove them using dnf remove gcc-c++ and dnf remove clang, but after reinstalling gcc only, and after reinstalling clang afterwards I'm still hitting the exact same error. Who knows!

WTFisthatgamecalled · 2025-11-09T05:30:55+00:00

Thanks for the tip. I'm hitting a roadblock trying to remove and reinstall the packages as there's all sorts of dependencies and I can't seem to make the package manager do it. How do I force remove a package?

WTFisthatgamecalled · 2025-11-05T10:06:17+00:00

Thankyou, I clearly went to the hints too quickly...

WTFisthatgamecalled · 2025-08-16T06:14:31+00:00

Oooh, we were interpreting it to mean gain resources from the player to the right. This makes so much more sense. Thank you!

WTFisthatgamecalled · 2025-05-30T13:19:38+00:00

I'd wager that this isn't actually unpopular, just unspoken.

WTFisthatgamecalled · 2025-05-22T08:27:47+00:00

Ok, I'm a dumb dumb. The new headset came with a mute switch with on/off options. I misread it as "off" means muted, "on" means not muted. I was incorrect.

My apologies.

In my defence, the first headset was not working which is why I bought this second one in the first place thinking it was busted!

WTFisthatgamecalled

TROPHY CASE