Status Point Information Gathering

[Otonashi]

Changed the document to be view only after getting griefed twice at 1500 GMT. Anyone that wants to directly edit the document you can PM or post below or something, otherwise I will appreciate if you can screenshot the changes that one skill point provides.

I am gathering information to determine the formulae used to calculate how much of each stat (HP, SP, Recovery, Defenses, Affinity) is gained from adding one of the five main stats (Pow, Vit, Wis, Mnd, Dex). Be extremely careful when editing the spreadsheet. The format I have used is:

Stat: refers to the value of the main stat after adding the skill point. If you currently have 15+4 Mnd and you add 1 Mnd, the additional stats you gained should be recorded as 20, not 19, not 16, not 15.

Affinity: refers to the value shown next to the weapon icon, without any additional bonuses like Magatama or Weapons providing %Affinity. If you are using a Katana, Odachi, or Axe DO NOT EDIT THE AFFINITY VALUES. These weapons are based off Pow and I'm not 100% sure of the bonuses to affinity Pow gives every 10 points. If you are using a Spear, Bow or Twin Blades, and your Pow is less than 40 or between 50 and 60, you may edit the affinity values after:
60 > Pow ≥ 50: subtract 105 from your affinity
Pow ≥ 30: subtract 41 from your affinity
Pow ≥ 20: subtract 21 from your affinity
Pow ≥ 10: subtract 9 from your affinity
Pow < 10: your affinity is not affected by Pow.
I am refering to Total Pow, 15+5 is 20, not less than 20.
Wands and Staves are not affected by Pow.

This is the value I am looking for. The difference automatically updates so there is no need to change anything under than column.

PhysDiff & MagicDiff: change in defense per point. Do not wear percentage-based defense increasing Magatama when recording these values, such as the Taikun Magatama.

RecDiff: change in SP recovery per point.

The values which I am sure of are Critical = (Dex+Wix/2)/12, SP Recovery from Mnd = Mnd and HP Recovery from Vit = Vit/2. HP and SP do not increase in an awkward manner with regards to Pow, Vit, and Mnd, but are influenced by level. Furthermore, Wis and SP are oddly related.

Here is the spreadsheet. Ask before editing if you are unsure. Thank you for your contributions.

[Tigerruss]

I have a couple of questions:
What is the first first set of columns for? (because it doesn't have a stat header like the other sets) (Silly me, it is for affinity...)
And have we collected any data on if stat scaling varies at all on character type you chose? (Strong, Reliable, Cautious, Kind, and Daring)

Edit: So does the power affinity boost that happens every 10 POW stat points effect everything but staffs and wands, or does it effect those too?

[Otonashi]

I have a couple of questions:
What is the first first set of columns for? (because it doesn't have a stat header like the other sets) (Silly me, it is for affinity...)
And have we collected any data on if stat scaling varies at all on character type you chose? (Strong, Reliable, Cautious, Kind, and Daring)

Edit: So does the power affinity boost that happens every 10 POW stat points effect everything but staffs and wands, or does it effect those too?

The bonus stats that each character type provides are mostly documented by the JP Wiki, and since those were recorded level by level I think there is less room for error. However anyone is free to verify or update those values in the wiki, I'm not too concerned about them right now.

Yes, Staves and Wands are not affected by Pow.

Edit: Decided to hide the SPDiff column since it's affected by level. The values I have are for a level 10 character.

[Otonashi]

Added Pow Bonus Affinity, which you can calculate as (Spear / Bow / Twin Blade Affinity) - Affinity from Main Stat (Left most columns), after removing magatama that affects the affinity of the aforementioned three. Since the bonus is equal for all three, you should double check by doing the calculation from both Spear and Bow or Twin Blade and seeing that both the bonuses are equal.