Zilla's IOU MultiCalc

[Zilla]

(04-16-2016, 09:09 AM)IndigoFerret Wrote: Many thanks for this awesome tool.

In the Optimizer tab, in regards to Expeditions, I don't know how far you can go with upgrades, but the 3rd Droid Ship at a cost of 8400 points is not accounted for.  Maybe you already have max in these, but is it possible to account for the maximum expedition upgrades possible in your next revision?

I have been manually updating the following cells:
J2 --  =if(Main!K17=3,"Max",Main!K17+1)
K2 -- =IF(J12="Max","",IF(Main!K17+1=1,800,IF(Main!K17+1=2,2400,IF(Main!K17+1=3,8400))))

Again, I am not sure whether the max is greater for the other expedition upgrades.

This upgrade isn't actually purchasable - it's a display glitch. If he ever adds it, I will absolutely update the calculator.