08-30-2016, 01:53 AM
(08-28-2016, 05:32 AM)GameInSky Wrote: Yeah, the optimiser skips a lot of levels to lighten it a lot. The difference between the 'best' levels and slected levels should be minimal so IMO not a big issue.
As for the other concern, I don't think it's really worth the effort.
Row 26 and 27 were made to be able to easily see where you're at on all your challenges.
Did some tests. Its true, every single change adds a lot of time in calculations (if you fully extend inferno levels). Also, noticed that after lvl 59 (if not earlier) , optimizer jumps 4 levels for the calculations, for best xp, coins, etc.
59, 64, 69, etc...
Taking inf 59 as start point and copying down the sequence (59-64-69) all the way to inferno 1999, adds only 203 lines. Furthermore you get rid of sequences 60-63, 65-68, etc (all the way up to 170). Adding 200 more lines doesn't seem like sheet gets overwhelmed.
(08-29-2016, 06:08 AM)GameInSky Wrote: You can extend the tiers yourself if you want to, they're based on formulas.
I wish it were that simple.
a) Yes, we could copy modded sheet between newer versions. But if you did any changes in the optimizer, they wouldn't carry over
b) If we don't do (a), we are 'forced' to edit formulas in following ranges, each and every time you update sheet
S11:S15
S17:S22
V11-V14
V21:V22
AI71:infinity
AJ71:infinity
So, looking for a more perm solution.
If you are overwhelmed (life) , and you don't mind, you can give me (temporarily) edit access to the optimizer tab and i'll make the corrections