Fire Clan IOU Multicalc

[porkbob]

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