1.3.7 Build Notes:
(Updated by -Xod- of Leafcull)

• Added the skill credit for level 150 (For when "TOD" is set to "yes").

• Updated to have salvaging skill start at 5 instead of 0.

• Fixed a bug in the optimization code introduced in version 1.3.6.

1.3.6 Build Notes:
(Updated by -Xod- of Leafcull)

• Modified the Ash tooth rewards based on the change to limit the reward to 10 million.

• Added a "TOD" toggle button. This will allow you to see how you could configure your character when the Throne of Destruction expansion comes out.

• Added the Salvaging skill.

• Fixed an existing bug with the Status on Healing (it didn't error if you put something other then train or spec as a status).

1.3.4 Build Notes:

• Fixed the a bug in the Optimization code caused by Leadership & Loyalty having no base stat.

• Now handles Imp Inventory Files.

1.3.3 Build Notes:

• Can now handle Imp Inventory Files.

• Re-wrote the Import Process.
• Large Overall Coding Change.
• Accounts for the Lack of Attribute in Leadership/Loyalty formula.
• Can now Cast Brilliance.
• Other Random Improvements I may have Forgotten :-).

1.2.5 Build Notes:

• Dynamically loading ACStats xml files.
• Goal/optimization code totally redone & now applies to ALL skills & Stats.

1.1.3 Build Notes:

• Quick Hotfix.

1.1.2 Build Notes:

• Goal code cleaned up & bugs fixed.
• Future things to do:
• More optimizations.
• Investigate ways to pull data from Plugin output or a web page.

1.0.3 Build Notes:

• Corrected the Trained Skill Table as it was off by 5 points (incorporated a new formula which has corrected the issue).

• This file is free. All that I ask is that useful changes are shared.
• I can be contacted through VNBoards as Perrinkog.
• Please keep in mind: this is an excel file, and as such is somewhat limited.
• This file contains a MACRO! See below for the code
• Suggestions are welcome.

• XP costs for stats & skills
• XP spent on stats & skills
• XP allocation suggestions (If a cell in Q4-Q9 is bold, then raising that stat is more valuable than raising skills individually).
  This takes all trained/spec'ed skills into account. So, if you want to remove something from this calc (like item enchantment which is only useful to a point) move it to untrained status and hit sort.

1. Enter your character name in cell A2 (only for aesthetics)
2. Enter your level in cell B2 - this should populate cell I1 with your total XP
3. Enter your race in cell C2. Acceptable choices are: Aluvian, Gharu'ndum, Sho (this makes racial skills cost 0 to train)
4. Find your skills in the column A
5. Choose "Train" or "Spec" from the drop down list in column B.
   
       
   
   
6. Enter your base stats in cells L4 through L9
   
       
   
   
7. Enter the number of times you have raised those stats in cells M4 through M12 (Keep an eye on column N for your actual stat level)
   
      
   
   
8. Press the blue Sort button at the top of the Skill column (this sorts the page by status & skill. Macros need to be enabled for this to work).
9. Do the same thing for your skills - enter the number of times you have raised the skill in column F (Keep an eye on column G for your actual skill level)
   
      

• insert or delete columns (the code has column names hard coded and will get messed up)
• sort the page without using the button (formulas may get messed up)

• This file contains a MACRO! See below for the code
• I found the formula for total xp in a series of posts on the boards. Sadly, I have since lost the link. If anyone can point me to the web page(s) I would love to give credit where it is due.
• To change the skill credit structure go to the skills tab (in case they change costs or add a skill)
• Thanks to Sucamarto for hosting this on Sucamarto's AC Heaven an awesome site

Code in this worksheet:
Private Sub Sort_Main_Page()
'Sort the main area by status by skill
Range("A3:H38").Sort Key1:=Range("B4"), Order1:=xlAscending, Key2:=Range("A4"), Order2:=xlAscending, Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
Dim I As Integer
For I = 4 To 38
Select Case Range("B" & I).Text
Case "" 'then it is not trained or speced - clear the formulas
Range("E" & I).Value = "=round(" & Range("T" & I).Value & ",0)"
Range("F" & I).Value = Null
Range("G" & I).Value = Null
Case "Spec" 'change to specialized formulas
Range("E" & I).Value = "=10+round(" & Range("T" & I).Value & ",0)"
Range("G" & I).Value = "=F" & I & "+E" & I
Case "Train" 'change to trained formulas
Range("E" & I).Value = "=5+round(" & Range("T" & I).Value & ",0)"
Range("G" & I).Value = "=F" & I & "+E" & I
End Select
Next I
End Sub