[iDarkCara]

Hello,

I started to work on a google sheet to reflect the current in-game stat system so I can see real time changes without having to start a new character or eat a fruit just to see things and how they scale.

The first issue I ran into was calculating the diminishing returns so I used a series of nested ifs in order to calculate each value past 40.

Code:

=Rounddown( IF(AND(C2 > 40,C2 < 44),((C2-40)*0.9)+40, IF(AND(C2 > 43,C2 < 47),((C2-43)*0.82)+43, IF(AND(C2 > 46,C2 < 50),((C2-46)*0.74)+46, IF(AND(C2 > 49,C2 < 53),((C2-49)*0.66)+49,  IF(AND(C2 > 52,C2 < 56),((C2-52)*0.5)+52, IF(AND(C2 > 55,C2 < 59),((C2-55)*0.42)+55, IF(AND(C2 > 58,C2 < 62),((C2-58)*0.34)+58, IF(AND(C2 > 61,C2 < 65),((C2-62)*0.26)+62, IF(AND(C2 > 64,C2 < 68),((C2-64)*0.18)+64, IF(AND(C2 > 67),((C2-67)*0.1)+67)))))))))))

each time it switches to the next three series, it removes .8 and calculates normally. The problem is @ 55. Where the value comes out mathematically to be only 50% as effective here. So, taking a base of 8 skill and getting them to a skill of 55, you'd have 55 - 52 (where the .5 percentile falls) giving you 3 *.5 = 1.5 +52 = 53.5 and then rounded down to 53. Everything up to this point is accurate in the formula, but for some reason, upon hitting 55, the formula no longer applies to the in-game values and I have no idea why.



After 55, the values get a lot more strange and I have no idea what happens. I know that once you reach around 67 total, the percentage becomes 10% effectiveness beyond that, or well should.

You said the formula is a bit more complex, but is it only 8% per 3 beyond the softcap? If so, I think there is a calculation error somewhere.

For reference, @80, you'd expect a value of (80-67= 13 *.1 = 1.3 +67) 68, but in-game, you only have 60.