To start, I freely admit that I can be a colossal nerd when I put anything into spreadsheet form. Just bear that in mind…

If I’m playing domination at all seriously I’ll be planning out my visit use in advance, to that end I have a spreadsheet with a handful of simple formulae that I can duplicate across the page to quickly figure out how many visits I’ll have on which days. Put in how many I use on each day and it figures it all out without me doing anything tedious. Up ‘til now I was working out scoop totals by hand, but that’s boring, slow and repetitive, so I decided to make a formula for that too. Vanilla’s easy – if you play it optimally then you get (No. of visits used – 3)*8 scoops. Pistachio on the other hand is a ****, because spreadsheets don’t understand things like doing something only for the multiples of 4 within a range… unless you spell it out in IF statements.

So… if A1 is a cell with the number of visits you’ve used and A2 is a cell with the length of your streak after using those visits (bumuming you don’t break your streak halfway through), then the function for the number of scoops awarded is:

=IF(A1>=1,IF(A2/4=INT(A2/4),(A2-4)/2,0),0)+IF(A1>=2,IF((A2-1)/4=INT((A2-1)/4),(A2-5)/2,0),0)+IF(A1>=3,IF((A2-2)/4=INT((A2-2)/4),(A2-6)/2,0),0)+IF(A1>=4,IF((A2-3)/4=INT((A2-3)/4),(A2-7)/2,0),0)+IF(A1>=5,IF((A2-4)/4=INT((A2-4)/4),(A2-8)/2,0),0)+IF(A1>=6,IF((A2-5)/4=INT((A2-5)/4),(A2-9)/2,0),0)+IF(A1>=7,IF((A2-6)/4=INT((A2-6)/4),(A2-10)/2,0),0)+IF(A1>=8,IF((A2-7)/4=INT((A2-7)/4),(A2-11)/2,0),0)+IF(A1>=9,IF((A2-8)/4=INT((A2-8)/4),(A2-12)/2,0),0)+IF(A1>=10,IF((A2-9)/4=INT((A2-9)/4),(A2-13)/2,0),0)+IF(A1>=11,IF((A2-10)/4=INT((A2-10)/4),(A2-14)/2,0),0)+IF(A1>=12,IF((A2-11)/4=INT((A2-11)/4),(A2-15)/2,0),0)+IF(A2-A1<5,IF(A2>3,1,0),0)

There’s probably a shorter way than how I ended up doing it; any longer and it’d start causing error from overflowing the allowed size for formulae, but this was easy to copy/paste while I was writing it, so there. Works for any number of visits used up to 12, but will break in unexpected ways if you feed it invalid numbers. Also doesn’t account for the 100-cap on streak length.

At this point you’re either nodding and thinking “hmm, useful” or staring in disbelief and wondering who would ever need such a thing. Whatever, don’t care, I did a thing and you get to hear about it.