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
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