Fire Clan IOU Multicalc

[porkbob]

(02-19-2017, 08:55 PM)Alpha12 Wrote: 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

Thanks. I thought I got all the timers switched over to the new /Day rates (much more useful imo), but it's easy to miss stuff. They're fixed now but I left the version # the same. (I imagine there are many people who never look at that, and wouldn't want to move to a new sheet just because of it.) Let me know if you find more.

(02-19-2017, 11:20 PM)Melusto Wrote: 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.

My min rarity definitely went up when I first put those changes in. Are you using whistle? If so the calc now takes into account that you'll want to use 100+nets/day in a 24 hour period. If you're using longer than a 1 day whistle, you should change Whistle Calculations to Theoretical instead of Actual.

(02-19-2017, 11:33 PM)Melusto Wrote: 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

I didn't change anything functional on the expedition sheet since jiecut first added the new version in, so I guess something happened during the import.

That whole section doesn't work for now. "Pet promoted days" is a useless metric if we don't have a system for arena in. Amount of pet food from arena plays a huge part in how long until your pet is promoted.