Automated and Less-Automated Character Sheets

[Aqu]

I'd consider making a manual sheet for his rules, if you'd like, but an automated sheet for a new ruleset, when I'm not done with the original, won't happen for a while.

[f1r3w4rr10r]

Aqu, if you need any help with that thing, just tell me. ^^
I already helped Mad Modd with his equipment list.

[f1r3w4rr10r]

Aqu, you need to fix your formula for critical success. It's not LCK+1 but just LCK.

[Aqu]

Done, changed.

[f1r3w4rr10r]

Something you can also remove is some unnecessary code for the maximum AP.That was used to round in steps of 5.

[f1r3w4rr10r]

I also just noticed a typo: It's "Versatility", not "Versitality".

[f1r3w4rr10r]

So, just wanted to let you guys know, I am now also working on this project. First thing I did was to implement a faster formula for level calculation. I also changed the color theme a bit to make it more consistent.

Next up will be to build a version for Mad_Modd's skill breakdown.

Oh and the changes have only been made to the Less Automated sheet, since the Fully Automated one isn't ready to use for now.

[SilverlightPony]

First thing I did was to implement a faster formula for level calculation.

I knew there had to be a better way to do it than my mountain of nested IF statements. My brain doesn't math that well, though. Thanks! *yoink*

[EDIT]
It works as intended up to lvl 30, but why not further? Surely there has to be a way to either give it a higher limit, or (preferably) let it go on forever.

[Palm]

First thing I did was to implement a faster formula for level calculation.

I knew there had to be a better way to do it than my mountain of nested IF statements. My brain doesn't math that well, though. Thanks! *yoink*

[EDIT]
It works as intended up to lvl 30, but why not further? Surely there has to be a way to either give it a higher limit, or (preferably) let it go on forever.

It does indeed work beyond level 30. Its just artificially limited with the MIN() function to replicate the old functionality.
The formula
SQRT(0.25+B5/500)+0.5
basically is
B4*(B4+1)/2*1000
in reverse.
Floor is to place the character at an exact level, rather than a fraction of a level. We don't want a character at level 3 with 4000 experience to be level 3.37228132326901.
And finally the MIN picks the lowest value between 30 and (FLOOR(SQRT(0.25+B5/500)+0.5, 1)).

So if you want you character to progress beyond level 30. Simply remove the MIN clause and only use =FLOOR(SQRT(0.25+B5/500)+0.5, 1) or change 30 to whatever max level you wish.

[SilverlightPony]

Why use Floor rather than RoundUp or RoundDown?