My mathematical skills seem to have abandoned me (temporarily I hope...).
How do I calculate what the score for a skill or art is, given the XP. I'm trying to make some autocalculations for my character sheets, and besides making a long list I simply cont get my head around it.
Does anyone have a nice formula fit for programming or a spread sheet?
If you have x experience points in an Art, the score in the Art is (SQRT(8x+1)-1)/2, rounded down.
If you have y experience points in an Ability, the score in the Ability is (SQRT(8y/5+1)-1)/2, rounded down.
It's simply the same formula but using the variable as the unknown value
I had a hard time too to figure it out but when i started to do maths with the initial formula, it just came back.
But it's been so long since Algebra that I actually had to look up the formula for the quadratic equation. My son would laugh at my face knowing that I can't even do basic maths without support literature any more
I'll just go and hide in a corner while using the formula in my little program
I would also point out that, for practical purposes, the best way to compute it (whether on a computer or by hand) is just a table look up After all, you are never going to see scores above 100 ...
Replace (x) with (x-a), where (a) is the number of aging points. Also, since you can't use the wrong (x) when buying the characteristic and since aging points themselves effectively round down, you'll want to round up. So Gerg's formula becomes:
If you have x points and a aging points in a Characteristic, the score in the Characteristic is (SQRT(8x-8a+1)-1)/2, rounded up.
Edit: You can change this to (SQRT(4[i]n/i-8a+1)-1)/2, rounded up, where n is the original number.
However, this may break down at zero. I'll have to double-check the rules on the negatives and zero.
If you're doing it in MSExcel, programming it yourself, or something similarly versatile, you could add a conditional statement to check for the zero-point, subtract to find the remaining negative points, and then apply the same formula in a positive sense, tossing a negative on it in the end. If that's not clear, I can write something more comprehensive for you later. If so, do let me know what you're using.
Now it works, even for negative! I have an spreadsheet to keep track of my character and the only piece I felt was missing was the aging. Now I am ready to adventure in the lands of magic . Thank you very much indeed!