07-31-2016, 11:53 PM
(07-31-2016, 11:03 PM)GameInSky Wrote:(07-31-2016, 09:53 AM)k3rb3r05 Wrote: Thank you for taking the time to create an updated sheet.
There is a bug in "MAIN" - Q27. I have purchased all orbs and it tells me that the next orb to purchase is "Gold", where it should say "None"
Other "bugs"
* cell C3 in "optimizer and general instructions" is "=if(Main!G3=C42,"Max",INDEX(Data!G3:G753,match(Main!G3+1,Data!A3:A753,0))) " . should be =if(Main!G3=C42,"Max",INDEX(Data!G3:G1003,match(Main!G3+1,Data!A3:A1003,0)))
* cells C16 and C22 (same sheet) have a "+0.01" at end of formula which results in a value error when they are maxed
Fixed the bugs, hopefully. I don't really look at the complex optimiser part of the sheet because I don't use it.
(07-31-2016, 12:35 PM)JourneyOver Wrote: @ k3rb yes it's safe to import from zilla's sheet.
Is there a way to get "All Wood Collected" numbers so I can input it into the spreedsheet?
The only way to know is to go to the tree map and check your required wood for the next tree.
Ah gotcha, thanks.
