IOU spreadsheet (last update 25.12)

[drpanda]

Found some issues on the optimizer sheet:


D18 should be changed to:
=0.05*QUOTIENT(If(B13="Auto Upgrades",Upgrades!G44,Upgrades!G47)+C18,100)^2+MOD(If(B13="Auto Upgrades",Upgrades!G44,Upgrades!G47)+C18,100)/600*(0.05*((QUOTIENT(If(B13="Auto Upgrades",Upgrades!G44,Upgrades!G47)+C18,100)+1)^2-QUOTIENT(If(B13="Auto Upgrades",Upgrades!G44,Upgrades!G47)+C18,100)^2))

[all instances of Upgrades!G45 should be changed to Upgrades!G44 and all Upgrades!G48 should be Upgrades!G47]

also, a solution for E18 [orb cost]:

=10000*seriessum(10,1,1, value(rept(1,C18)))


Lastly, F18 should be changed to
=IF(B$13="Auto Upgrades",'Battle&Pets'!H6*((1+D18)/(1+Upgrades!H44)),'Battle&Pets'!H7*((1+D18)/(1+Upgrades!H47)))

as it currently calculates damage wrong as it pertains to click orb damage.