https://drive.google.com/folderview?id=0B7j7MV5KFScsYTU2Nnp6SkhDaWc&usp=sharing
I made a spreadsheet for tracking stat skilling. I thought other people might find it helpful, so I polished it up a bit and put it in a share folder. This is my first time sharing something with Google Drive, so please let me know if the sharing doesn't work.
To use, fill in the yellow cells on the elf, human and/or giant sheets. There are drop down selections but for skill ranks it is faster to type it in.
Besides calculating AP cost per stat for remaining ranks / next rank for all skills, it will:
Calculate total AP used
Calculate CP
Calculate journal AP bonus, with the caveat that this is unreleased content that may not come to NA
Calculate total available stats from unranked skills and talents
total readme file, which includes more detailed information and known issues:
[SPOILER="tl;dr info"]
The data for this spreadsheet came from Mabinogi World Wiki, except for the information about the Journal Bonus AP which came from Mabination forums.
This spreadsheet can be freely distributed and modified. Credit is appreciated, but not required.
============
Directions
============
Fill in the yellow cells on the elf, human and/or giant sheets. There are drop down selections but for skill ranks it is faster to type it in.
On the character sheets, there are 3 sets of calculated columns - current, remaining, and next rank. The last column in the Next Rank section will highlight skills where the next rank has no AP cost. The skills are arranged alphabetically by skill tab, except for the Combat tab which is split into ranged / melee. Gold Strike is in with the range skills on the Human and Elf sheets but not the Giant sheets.
Underneath the skill section is the talent section, which includes a calculator for the unreleased journal AP bonus. Underneath the talent section is a list of various classes, quests, books, etc that give stats, and below that is the CP calculator.
The other sheets only have data used by the formulas. They can be viewed, and can be helpful as a quick way to lookup information on skills, but should not be edited.
If you have more than 1 character of each race you wish to track, you can make a copy of the race-appropriate sheet. If you want to track more than 5 characters while using Google Drive, you will need to create a copy of the entire spreadsheet because of Google Drive's formula complexity limit.
=============
What exactly will this spreadsheet calculate?
=============
When no skill ranks are entered, it will calculate the total stats possible for each race as well as total possible AP to use. (see note in the Known Issues section
With the yellow cells filled out, it will calculate:
Total AP used and the total AP cost for all unranked skills
Total stats from current skills, talents and misc quests, classes, etc.
Total stats available from unranked skills, talents, and misc things
Average AP cost per stat per skill for remaining ranks
Average AP cost per stat per skill for the next rank
CP
Journal AP bonus, with the caveat that this is unreleased content that may or may not come to NA and may or may not be changed if it does.
=============
Known Issues
=============
The formulas may not all work after exporting to a non-google format.
Talent levels need to be manually updated. It is much faster to update them manually than to add automatic talent calculation.
The remaining AP cost per stat calculations use the total AP cost for all skills, even when it would be more accurate not to. (For example, Bullet Slide gives 5 Stamina at r9 and then no more, but the calculation would still use the AP cost for r1.) For adjusted totals, see the pages for the specific stats you are interested in.
Mabinogi World Wiki uses stat/AP, while I use AP/stat. I find the AP/stat number more useful. To see the stat/AP numbers totals, check the pages for specific stats you are interested in, or check the wiki.
The CP calculator has not been verified.
When no skill ranks are entered, the total remaining amounts show the totals possible for the different races. Some of these do not match the amounts on the wiki's Stats and Skills page. In some cases, this is due to errors on that page. In other cases, I was unable to determine how they reached the total listed. Also I must admit that after a while I got frustrated and did not double check the remaining differences.
Capped skills do not display as completed when the final available rank is reached. Also, it will show up as a skill that has a free AP cost to rank up. All of the AP and stat amounts will calculate correctly. If you would like them to display the same as other completed skills, you can set them to r1 and they will still calculate correctly.
I accidentally added a Form to the spreadsheet, and even though I unlinked the Form several times it keeps coming back. :( Ignore anything about form responses.
This spreadsheet does not track AP received from skill quests or AP saved from completing beginner talent quests. This includes:
Potential 72 / 73(elf) in saved AP from the beginner talent quests
Potential 29 / 32(giant) in AP from non-limited skill quests
Potential 80 AP from Gunslinger Talent Event
Potential 20 AP from Hidden Skill Event[/SPOILER]