+- 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 - porkbob - 02-13-2017
(02-07-2017, 04:42 PM)LaberLu Wrote: @jiecut: The problem is, that it will keep recommending these bugged Upgrades, because negative Values have the best effect/cost ratio. That makes optimize for Gold useless.
I tried to fix this. It's on the live version, but I didn't update the version number yet (it's still v3.6b) because I don't know entirely if it works right. Let me know how it is
(02-07-2017, 04:42 PM)k3rb3r05 Wrote: a boss milestone dropdown
I didn't even know about the Advanced Cards tab until somewhat recently, but I assume that was not put there already since you won't be grinding for cards on boss. There is a function in the normal Cards & Timer tab that will say which boss to use card packs on. Edit: The normal Cards & Timer has a failsafe so that you use bigger card packs on the Boss with the lowest # of cards that still gets you over the next milestone. The Advanced Cards tab doesn't calculate this thing and it'd be a headache to squeeze it in there. Today I tweaked the Cards & Timer tab so that it will default to the most optimal Boss to use packs on if this failsafe isn't triggered so please just use that.
RE: Gameinsky's modified IOU Multicalc - Melusto - 02-18-2017
0.2 tackle level per fish orb tier
I haven't noticed any fishing income (pearls/fish) increase. So I suppose there is something wrong or I need tier 5 fish orb to get extra tackle bonus?
RE: Gameinsky's modified IOU Multicalc - jiecut - 02-18-2017
@Melusto
It was listed in the patch notes for Feb 16 (actual game) but it was actually implemented on the 9th?
You don't need a tier 5 fish orb to feel the tackle bonus. You'll get extra tackle bonus even with a tier 4 orb.
---
Finally updated the expedition sheet today. It was quite a daunting challenge. But wasn't actually that bad. I had to copy stuff down to add an extra row but it didn't end up being that painful.
Added I-Matter. Had to change times for Ultimum. Fast Track fuel costs changes also accounted for (petfood is now 3x per trip, SO is 2.5x, I-Matter 6x).
RE: Gameinsky's modified IOU Multicalc - damador - 02-19-2017
on the same data entered average idel dps dropped from 220 M to 150 - something is wrong
RE: Gameinsky's modified IOU Multicalc - quixorbl - 02-19-2017
(02-19-2017, 01:22 AM)damador Wrote: on the same data entered average idel dps dropped from 220 M to 150 - something is wrong
I found the problem. On the 3.6c version, there was an equation hidden in cell I15 on the 'Ascension & Challenge' form that calculated your total bonus from your progress in the Series challenge. It was erased on the 3.6d version with the text about when you get your next 5% damage bonus. I copied the equation that was in I15 to I18 and then changed cell K49 to reference I18 instead of I15.
RE: Gameinsky's modified IOU Multicalc - Melusto - 02-19-2017
I mean increase in sheet. I updated from version 3.6b to 3.6c (now 3.6d) and in 3.6c was added "Fish Orb now gives 0.2 Tackle per Tier" and now when I compare fishing sheet v3.6b and v3.6c the fish/day, pearls/day gains are still the same so I assume there may be something missed in calculations. (same with 3.6d no increase).
Not sure if you already fixed this, but I have noticed that my pet orb damage in sheet is a bit off (tier 4 level 23) and it says 40.28% but in game it its only 35.312%.
Thanks for your reply.
RE: Gameinsky's modified IOU Multicalc - porkbob - 02-19-2017
(02-19-2017, 03:26 AM)quixorbl Wrote:(02-19-2017, 01:22 AM)damador Wrote: on the same data entered average idel dps dropped from 220 M to 150 - something is wrong
I found the problem. On the 3.6c version, there was an equation hidden in cell I15 on the 'Ascension & Challenge' form that calculated your total bonus from your progress in the Series challenge. It was erased on the 3.6d version with the text about when you get your next 5% damage bonus. I copied the equation that was in I15 to I18 and then changed cell K49 to reference I18 instead of I15.
That was a silly place for that formula to be hiding.
It's fixed now. 
(02-19-2017, 01:22 AM)Melusto Wrote: Not sure if you already fixed this, but I have noticed that my pet orb damage in sheet is a bit off (tier 4 level 23) and it says 40.28% but in game it its only 35.312%.
Thanks for your reply.
I think I fixed it, but it's possible it's a hardcoded fix for 4* orbs only. Need to test those orbs at different *s to know for sure.
(02-19-2017, 01:22 AM)Melusto Wrote: I updated from version 3.6b to 3.6c (now 3.6d) and in 3.6c was added "Fish Orb now gives 0.2 Tackle per Tier" and now when I compare fishing sheet v3.6b and v3.6c the fish/day, pearls/day gains are still the same so I assume there may be something missed in calculations. (same with 3.6d no increase).
Did you change your min rarity in the new sheet (as you would be able to do with the orb bonus to tackle)? The 0.2 tackle per orb tier is definitely plugged into the mean and variance of the normal distribution for fish spawn chances.
RE: Gameinsky's modified IOU Multicalc - Alpha12 - 02-19-2017
It seems that cell M27 in "optimzer & general instructions" give the wrong redult, at least for me.
I think that's because it says =TODAY()+(ceiling(K50/24)) where it should be =TODAY()+(ceiling(K50)) and same thing for cell K50 wich is =K49/V15/24 and should be =K49/V15
Edit : There is the same problem with cell J21. There is one /24 more than necessary
RE: Gameinsky's modified IOU Multicalc - Melusto - 02-19-2017
No I didn't change min rarity, because my are now nets/day - 63.52 and catches/day - 73,49 and thats what I mean. It was the same 73,49catches a day even before 0.2 per fishing orb /tier. With my tier 4 orb there should be a big difference with catches.
RE: Gameinsky's modified IOU Multicalc - Melusto - 02-19-2017
Upgraded to v3.6f - my pet orb tier 4 is working well, but expeditions sheet is not working now, but that may be problem with importing or I don't know.
Anyway I have found one fromula that is a bit off, it isn't that important, but I am getting annoyed of it. In pet sheet:
Pet 1 promoted(days) there should be formula =iferror(if(NY17=15,"", IF(AM10="Pet #2",CEILING(OH17/(NX27*NX28)),CEILING(OH17/((NX27*NX28)+AM15)))),"")
Pet 2 promoted(days): =iferror(if(NY18=15,"", IF(AM10="Pet #1",CEILING(OH18/(NX27*NX28)),CEILING(OH18/((NX27*NX28)+AM15)))),"")
NX27 represents training value
NX28 - number of trainings a day
currently there is instead of NX27 cell NX28 and instead of N28 cell NX29