Fire Clan IOU Multicalc

[porkbob]

(03-05-2017, 04:27 PM)quixorbl Wrote: And that is where I recommended the change be made...at the divide-by-10eN point. Perhaps there was some confusion because I specified the cell titles rather than the cells themselves. The cells I was referring to are: Optimizer & General Instructions S19, S20, V10, and V11.

Sorry, I misinterpreted what you were saying. My first priority is to think of what other calculations could be using that number and would be thrown off. And thus I was thinking you were saying that any calculations that used XP/Kill would be using a number that is off by 1M.

My first thought of it would be that, the sheet display would actually be closer to the real value than the game display, and this is what I would prefer. If I were a user and not a maintainer, I would probably expect a rounding difference to be the cause if it sometimes matches and sometimes is 1 higher.

But I guess since it is only a display to compare with the game and has no other purpose, it could be better to change it. Next time I am working on the sheet I will test different inf tiers to see how they compare (I've only ever gotten the exact matching number in my casual use), and consider changing it.