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