(03-29-2016, 05:03 PM)jiecut Wrote: Awesome! What was wrong with Gold Rate?
Okay Huge Loots is also off and I tried to debug it for you because it was weird.
-TGoldMulti seems to be fine.
-I traced N402 and E390, to understand the algo's but E402 is supposed to be slightly bigger, instead it's completely off.
Okay I think it's because everything should be referencing the M column.
N402:N405 (optimization page)
=Round(C391*(1+N401)*$D$55*$D$56)
-> =Round(C391*(1+M401)*$D$55*$D$56)
=G389*N402
-> =G389*M402
Similar changes to cells N404, N405.
E9 and F9 also need to be changed to reference M405 instead of N405.
This is a really complex spreadsheet so I'm not sure what else needs to be changed. Other column MN stuff, and other stuff that accesses N402:N404.
The joys of merging columns in Google Sheets. Thank you for reporting all of this - it is all fixed now.
Edit: When I fix this, I'm going to use proper named variables and just reference those in sheet - will make things much, much easier on everyone.
ก็็็็็็็็็็็็็ʕ•͡ᴥ•ʔ ก้้้้้้้้้้้
Leader - Eden Regenesis
Leader - Eden Regenesis