+- 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 - quixorbl - 12-29-2016
Another issue I have found with the current version:
There is at least one (there may be others) error with the fish names used on the Fish tab for cells D4, E4 and F4. Currently, my F4 fish is "Sunken French" but it says "Sunke Fish".
RE: Gameinsky's modified IOU Multicalc - jiecut - 01-02-2017
Porkbob integrated the autodmg bonus. (and fish)
For estimated series damage, now considers challenge orb for pet damage. Also considers final blow to be active 67% of the time for series.
Added expedition import.
RE: Gameinsky's modified IOU Multicalc - quixorbl - 01-02-2017
Just a note about the New Year's event. It appears as though the % EXP bonus does not calculate the correct amount if you put the bonus in the Global Event Bonuses section of the Main tab. In order to get the exact EXP earned per kill, you need to multiply the functions in fields V11 and V18 on the Optimizer & General Instructions tab by the percentage. For example, if the bonus is 10% EXP, you need to multiply the functions in V11 and V18 by 1.1. Since Gold already doesn't calculate correctly I don't know whether the % Gold bonus should be put in the Global Event Bonuses section of the Main tab or whether the appropriate functions on the Optimizer & General Instructions tab should be multiplied by the percentage. My guess is the latter since that is what needs to be done for % EXP.
RE: Gameinsky's modified IOU Multicalc - Frea - 01-15-2017
Don't know if this was reported before, but there is a problem with the "Total amount of damage needed for next challenge" fields in the "Ascension & Challenge" tab. I noticed it for Gold 5 Ugh Solo, which requires 9.54T CD, but was displayed as 95.4T. The root cause for the problem seems to be numerical inaccuracy due to division of large numbers in the format string. My solution is to simply avoid that division by replacing the formula in F34-N34 with the following:
=IFERROR(if(len(F33)<=3, F33, if(len(F33)<=6, left(F33,3)/10^(6-len(F33))&"k", if(len(F33)<=9, left(F33,3)/10^(9-len(F33))&"M", if(len(F33)<=12, left(F33,3)/10^(12-len(F33))&"B", if(len(F33)<=15, left(F33,3)/10^(15-len(F33))&"T", "Only the Fed knows."))))),0)
RE: Gameinsky's modified IOU Multicalc - jiecut - 01-16-2017
@quixorbl
So you mean that'd be an issue with column O71+ of the Optimizer & General Instructions tab. Or one of the cells O71 draws it numbers from.
RE: Gameinsky's modified IOU Multicalc - quixorbl - 01-16-2017
(01-16-2017, 03:10 PM)jiecut Wrote: @quixorbl
So you mean that'd be an issue with column O71+ of the Optimizer & General Instructions tab. Or one of the cells O71 draws it numbers from.
I'm not sure there is a problem per se. It is possible Ray designed the EXP (and Gold?) bonus(es?), for this event only, to work this way. All I'm saying is that filling in the EXP bonus in the Global Event Bonuses section does not give the correct EXP. What you have to do instead, to get correct EXP, is explained in my previous post.
RE: Gameinsky's modified IOU Multicalc - jiecut - 01-16-2017
Okay found the issue quixorbl.
If you look at G49, it looks like it's using the global xp bonus multiplicatively. But if you look at column O it uses the xp rate as (1+ G49). Which means the global xp bonus isn't actually getting fully multiplied. (1+1.1x) is not equal to (1+x)*1.1
Issue probably also applies to gold but it'll be less significant because your gold bonus is bigger. Also gold seems to be slightly off even without a global bonus.
RE: Gameinsky's modified IOU Multicalc - porkbob - 01-17-2017
(01-15-2017, 02:37 AM)Frea Wrote: Don't know if this was reported before, but there is a problem with the "Total amount of damage needed for next challenge" fields in the "Ascension & Challenge" tab. I noticed it for Gold 5 Ugh Solo, which requires 9.54T CD, but was displayed as 95.4T. The root cause for the problem seems to be numerical inaccuracy due to division of large numbers in the format string. My solution is to simply avoid that division by replacing the formula in F34-N34 with the following:
=IFERROR(if(len(F33)<=3, F33, if(len(F33)<=6, left(F33,3)/10^(6-len(F33))&"k", if(len(F33)<=9, left(F33,3)/10^(9-len(F33))&"M", if(len(F33)<=12, left(F33,3)/10^(12-len(F33))&"B", if(len(F33)<=15, left(F33,3)/10^(15-len(F33))&"T", "Only the Fed knows."))))),0)
I changed it, opting for this approach:
Code:
=IFERROR(if(I33>10^18,round(I33/10^18,2)&"Qi",if(I33>10^15,round(I33/10^15,2)&"Qa",if(I33>10^12,round(I33/10^12,2)&"T",if(I33>10^9,round(I33/10^9,2)&"B",if(I33>10^6,round(I33/10^6,2)&"M",if(I33>10^3,round(I33/10^3,2)&"K",I33)))))),0)Didn't increment the version number yet, though. Figured it'd be best to wait for the changes in the next patch to be accounted for, rather than making everyone migrate twice. You can go ahead and grab it, if you want.
RE: Gameinsky's modified IOU Multicalc - Chencho - 01-24-2017
First of all, thanks for this amazing tool. I have found what it seems a minor bug on Advanced Cards tab: first row, the next cell to the right of Cards to dmg points to an incorrect tab name.
Code:
=if(E2<>0,E2,C2)/If(Cards!D5<>0,Cards!D5,A2)And it should be:
Code:
=if(E2<>0,E2,C2)/If('Cards and Timers'!D5<>0,'Cards and Timers'!D5,A2)Also, as a visual upgrade of Ascension & Challenge tab, I have added a conditional format to the challenges titles one by one (Rats, Fruits, and so on) so they change the background colour every time the Lowest theoretical incompletable challenge value changes from the one specified by the user. I have done for my own good because I found that it's hard to notice when I can jump to the next level unless it's a major change (say, from bronze to silver, or silver to gold).
Code:
Apply to F25 custom formula:
=$F26<>$F27
Select preferred BG colour.Simple but effective. Kind regards.
RE: Gameinsky's modified IOU Multicalc - porkbob - 01-25-2017
It wasn't necessarily as simple as it might seem at first, but I concocted a way to have the cell turn white with red text if you can do a higher challenge.
The advanced cards tab is protected and only Gameinsky can edit it, so he'll have to do it. Edit: He did it.
In other news we pushed a major change today, with all the new inferno tiers, and new hp/xp formulas, and the newest fish distribution; if anybody didn't notice.
Things seem alright to me, but let us know if something went wrong.