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.

Inertia Posted:

What is this can someone translate

Basically he made a verbose set of commands for calculating the amount of pistachio scoops awarded in a streak.

Additional wisdom.

Spot Posted:

Also, if you just want to quickly calculate how much pistachio you’re getting from 12 visits, take the visit number for the first pistachio reward, and add half.

e.g. pistachio for 40, 44 & 48 visits would be 40 * 1.5 = 60 scoops

Take 4 and divide by 2, or divide by 2 than take 2 are equivalent, and that’s in my thing. The clever part of what it does is working out what numbers you need to do that to.

What I wrote there will identify the multiples of 4 that your streak has gone through in the number of visits specified, and only work out scoops for those numbers.

and this is why I will never play the game.