+- 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 - JourneyOver - 08-20-2016
(08-20-2016, 12:45 PM)jiecut Wrote: Is it just me or does Lineage level have no effect on Challenge Damage Calcs?
Secondly though, it was weird that my Series damage was so off.
It's because of the 8.5 thing.
Ascension&Challenge!H21=(Main!H59+Main!H60)*8.5+(Main!H61+Main!H62)*(16.5+K8)+(Pets!C24*25)
Should be
Ascension&Challenge!H21=(Main!H59+Main!H60)*10+(Main!H61+Main!H62)*(15+K8)+(Pets!C24*25)
Ability time will optimistically last 10 seconds. And that means you have 15s + time freeze left for normal dps.
Also regarding the pet portion. (Pets!C24*25)
Pets!C24=Pets!D33
Pets!D33 is appearing as 0 for me.
Pets!D33=Round(C33*(1+Main!D23)*(1+E7)*(1+'Ascension & Challenge'!F11)*Main!R10*(1+Main!R9),0)
Pets!E7 is blank, not sure what's supposed to be there but that's not causing the problem.
Ascension!F11 is a magnitude too high but that's not causing the problem.
The problem is Main!R10 which is challenge orb bonus. If you have no challenge orb it'll be 0% which will make the whole thing result in 0. And even if you have a challenge orb it won't be giving a bonus to the calc.
Pet tab is being redone soonish (by indigoferret) so it probably isn't that big of a concern (hell I didn't even know there was anything on B24 and C24) for pet stuff but do think the rest should be looked into, and he has known about the challenge orb thing for a bit now but it'll require a partial rebuild to fix it, as noted on the "credits and changelog" sheet.
RE: Gameinsky's modified IOU Multicalc - k3rb3r05 - 08-22-2016
Regarding new version, v 3.4.3c, you list a minor change
Quote:Changed "Done!" to "Ok!" in challenges. (bug)
I am guessing you mean challenge data tab? I see neither "DONE" nor "OK"
RE: Gameinsky's modified IOU Multicalc - jiecut - 08-23-2016
k3rb3r05
Done is used in Ascensions&Challenges!M51:M59
It's for when you finish a challenge you would've put in Done! (F26:N26) before instead of something like G2S.
RE: Gameinsky's modified IOU Multicalc - GameInSky - 08-23-2016
Yeah, putting in "Done!" screwed up the formatting for the export code.
RE: Gameinsky's modified IOU Multicalc - IndigoFerret - 08-24-2016
In case anyone downloads version 3.5 before corrections have been made please make the following changes on your version of the spreadsheet:
Ascensions & Challenges tab - cell E11 should be =0.01*C11 and cell F11 should be =0.01*D11
Data tab - cells AF4:AF18 should contain the values 1 through 15
I will try to answer any of your questions about the functionality of the new Pets tab.
- Indigo Ferret
RE: Gameinsky's modified IOU Multicalc - JourneyOver - 08-24-2016
Honestly I'm totally confused on all of the new pet tab other than the parts that where in the old sheet :/
and AL16 to AL18 (pet tab) need to be looked at as well as they are currently broken (have already let game know on discord but he is offline)
RE: Gameinsky's modified IOU Multicalc - IndigoFerret - 08-24-2016
(08-24-2016, 10:28 AM)JourneyOver Wrote: Honestly I'm totally confused on all of the new pet tab other than the parts that where in the old sheet :/
and AL16 to AL18 need to be looked at as well as they are currently broken (have already let game know on discord but he is offline)
I am in Discord right now if you want to chat.
RE: Gameinsky's modified IOU Multicalc - JourneyOver - 08-24-2016
(08-24-2016, 10:32 AM)IndigoFerret Wrote:(08-24-2016, 10:28 AM)JourneyOver Wrote: Honestly I'm totally confused on all of the new pet tab other than the parts that where in the old sheet :/
and AL16 to AL18 need to be looked at as well as they are currently broken (have already let game know on discord but he is offline)
I am in Discord right now if you want to chat.
Sent you a message *names same on there as on here*
RE: Gameinsky's modified IOU Multicalc - JourneyOver - 08-24-2016
Going to Mark down what needs to be looked at for Pet sheet that I've noticed at least.
AL16 calculations are way off now. (it's showing that I would get a total of 3,800 pet food a day for beating up to arena 19 when in reality I'm getting 29 pet food a day for beating up to arena 19) if I throw AL15 onto AP instead of No-AP it goes down to the reasonable number of 29.
AL17 and AL18 both are calling "pets new" sheet supposedly even though there is no such sheet at all made named that along with them calling blank cells so calculations can't even be made for them (possibly calling on cells as well that are not made for these calculations)
Even though the next two are in the WIP section might as well let you know about them.
AM7 is calling on cells that are completely blank as well so nothing can be calculated for it as well as cells that I don't think are made for "Maximum Pet Arena w/o AP" calculations.
AM8 is calling on the "pets new" sheet like AL17 and AL18.
And for Node stuff
Anything to do with critical damage does not seem to be calculated for the sections under it as seen here ----
Picture
as you can see I have 10 in cell N8 but N9 (same with H27 and I27) doesn't seem to get the calculated value of DPS increase provided by the next single upgrade to that node divided by the PP cost for that upgrade.
RE: Gameinsky's modified IOU Multicalc - GameInSky - 08-24-2016
10 means activated, non-upgraded node.