03-29-2016, 05:03 PM
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.
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.
A leader of Fire Clan