i looked last week for the fomula to calculate primary stat bonus to work a spread sheet with and sadly couldn't seem to find it anywhere.....
this i what i came up with
works for any value over 1200 i didn't test below
B = ((((log(S))-(log(1200)))/(log(1.02))*.8)+66.404
B is the bonus value
S is current primary stat
if someone else could verify that this seems right
i'm not sure what you mean for S, but it should look like this
B = [log(S/1200)/log(1.02)*.8] + 66.04
geek spirt
we are here gmbar
I had an old set of Int data I used a while ago, and a formula I calculated. Here's what I got:
B = [0.8*log(S/1200)/log(1.02)] + 66.41
where log is the natural logarithm. The fitting data was:
General model:
f(x) = a*log(x/1200)/log(1.02)+b
Coefficients (with 95% confidence bounds):
a = 0.7999 (0.7998, 0.8)
b = 66.41 (66.41, 66.41)
Goodness of fit:
SSE: 0.0005591
R-square: 1
Adjusted R-square: 1
RMSE: 0.003052
This is a good fit. The 66.41 at the end comes from the int bonus for int below the 1200 threshold. At least in my old data set, the tooltip bonus at Int=1200 was 63.25, at 1201 was 66.44, at 1202 was 66.47, so projecting backwards with the new formula, 66.41 makes sense.
only reason i had so many )( in the formula was i had already formated it for a spread sheet and was to lazy to change my copy/paste
and thanks alot Ravahn for testing it and i went w/ 66.404 since 66.41 created small errors that the minor (typo'd) tweak seemed to solve :} i wasn't expecting it to be 100% acc. but its damn close
B=1.6+.1log(S/1200)/log(1.3) was the formula I got a few years back, based on an idealized situation which was based on a dev statement. In practice its margin of error was around 2-4% I believe. Having compared your model alongside mine, and scaling to decimals accordingly, they follow a nearly identical curve with what seems to be a constant difference between the two.
Edit: link to old thread
http://www.eq2flames.com/combat-disc...ml#post1381805
I hear robots are good with math... and at this game!
Outsourced - 95 BL
Charliemurphy - 95 Warden
Debow - 95 Necro
Dethelos - 95 Coercer
Lol, I might be coming back eventually, but meh.. not now (plus I'm on AB now!)