Download - 2.26 MB
Skyrim Excel Exp Calculator
This is a little Excel file I put together to assist me in determining what values I wanted to use with Ely's Uncapper mod. It allows you to play with the multipliers for skill experience contributed towards player character experience as well as the skill caps themselves. The resulting math will show you how much experience per skill is contributed to the character experience. The total amount of character experience which can be earned. It will also show you what the cap will be for the character level. You may also enter the number of perks you want to have available and you'll be given the per level average.
When you first open the excel file you'll see two sets of experience data on the left hand side. These go as high as 10000 in skill level (the max available with Ely's Uncapper mod). You do not need to do anything with these, they are necessary for calculations, tho some people may find them interesting. Just to the right of these data sets are three outlined tables. This is the important stuff. I've highlighted in blue the fields you can change which will be used as the base for all the calculations. Don't worry about accidentally changing anything you shouldn't, I've locked all cells but the editable ones highlighted in blue.
There is sample data already entered to give you an idea of how it works.
Hope this is useful to some.
--- Added "Next Level" columns to the Character Exp table and the Skill to Character Exp table. The tables were accurate for exp needed for next level, but the way the formulas were set up using the "Current Level" value meant that the calculations were slightly off. Thanks to xxxZzzZxxx for pointing that out.
If you do not have Microsoft's Excel program available to you, it may be possible to utilize the Calc utility of the free open source program OpenOffice.