Tim1981 wrote:At 'Hero Power' tab you're adding building CJ upgrade level twice, firstly in H column, and again in U and W columns.
When I remove multiplier from H column, U and W calculation becomes correct
Thanks for that catch, I will have that fixed in the next release. Must have been a remnant of when I was first trying to get the formula figured out.
I still wish I could get it exact!
My current Lancaster team:
Actual Team Total: 737,628 - STB result: 738,203
Lancaster Actual: 105,521 - STB result: 105,603
Mojian Actual: 223,473 - STB result: 223,649
Clovis Actual: 118,641 - STB result: 118,729
Gauvin Actual: 103,756 - STB result: 103,837
Palash Actual: 96,541 - STB result: 96,617
Albert Actual: 89,696 - STB result: 89,767
I've already taken the upgrade building buff down to 4.5% to get my numbers this close, and I'm not sure where the rest of the discrepancies are at in the skill numbers/formulas.
I do know that Protector ! is actual 2.5% not 2%, Aura of Protection is 7.5% not 8%
Actually uploaded the fix already
For those not wanting to redownload and fix, unprotect the HeroPower tab, remove *(IF(R3<>0,1+(R3*0.25),1)) from the formula in H3 (make sure you leave the ,0) at the end), copy down (reborder if desired).