+- Idle Online Universe RPG (https://iourpg.com/forum)
+-- Forum: General (https://iourpg.com/forum/forumdisplay.php?fid=5)
+--- Forum: Guides (https://iourpg.com/forum/forumdisplay.php?fid=7)
+--- Thread: Fire Clan IOU Multicalc (/showthread.php?tid=2233)
RE: Gameinsky's modified IOU Multicalc - jiecut - 08-27-2016
ALso one thing to point out.
Challenge damage is being affected by Farm Pet Speed and Farm Pet Damage ascension upgrades, instead of looking at the farm ascension upgrades column.
RE: Gameinsky's modified IOU Multicalc - k3rb3r05 - 08-27-2016
I noticed some discrepancy Optimizer & General Instructions
After cell B241, inferno levels are skipped and as a result, Inferno Tier Efficiency cells (S11:S15) aren't accurate. For example:
Original sheet: [attachment=212]
My sheet: [attachment=213]
----------------
The following is on a previous post, but i think it wasn't clear
Let's say 'Ascension & Challenge'!F26 contains S5D.
Is it possible to mark 'Challenge Data'!N6:N33 as "done" or "ok" or apply conditional formating on them (ie, change text color)?
thx
RE: Gameinsky's modified IOU Multicalc - GameInSky - 08-28-2016
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.
RE: Gameinsky's modified IOU Multicalc - JourneyOver - 08-28-2016
yay fun joining a group who is on an inferno level not supported by the calculator anymore :/ can't get calculations anymore unless I can get them to jump off to a diff inferno level that is supported..
http://i.imgur.com/jzJ1VuG.png
http://i.imgur.com/a0ZiTS2.png
RE: Gameinsky's modified IOU Multicalc - GameInSky - 08-29-2016
You shouldn't ever be on inferno levels that don't end with a 4 or 9.
It's either limited inferno support or 1 minute calculations on every change of the sheet.
You can extend the tiers yourself if you want to, they're based on formulas.
RE: Gameinsky's modified IOU Multicalc - k3rb3r05 - 08-30-2016
(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
RE: Gameinsky's modified IOU Multicalc - JourneyOver - 08-30-2016
(08-30-2016, 01:53 AM)k3rb3r05 Wrote:(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
I honestly don't know how people where getting "a lot of time" between calculations if the inferno tiers are expanded since I never really noticed any time added myself between when they where extended all the way to 2000 and how they are now (and the time then and now are both literally 1-3 seconds) but like I said to game yesterday I have been noticing a freeze of calculations the past week though at random intervals when ever I do update various other parts of the spreadsheet (never have it happen on the inferno calculations though..) but all of it is up to game on how he wants to do things since he is the one working on the sheet and not me.
RE: Gameinsky's modified IOU Multicalc - GameInSky - 08-30-2016
I believe I had to keep everything under 170 intact for pre asc. calculations. Though I added the multiples of 5 again, hopefully it's not too heavy.
RE: Gameinsky's modified IOU Multicalc - ExWhiteWolf - 09-04-2016
On the pet tab on Pet Points its yellow meaning we can change it however there's not an easy way to get total PP from what I understand. Is there a way to calculate the Pet points?
RE: Gameinsky's modified IOU Multicalc - GameInSky - 09-04-2016
(09-04-2016, 01:31 AM)ExWhiteWolf Wrote: On the pet tab on Pet Points its yellow meaning we can change it however there's not an easy way to get total PP from what I understand. Is there a way to calculate the Pet points?
I believe that's just the amount of PP you have available.