Fire Clan IOU Multicalc

[porkbob]

(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.