Hi Guys,
Sorry for the delay with getting a new version of this sheet out. However the good news is that every time I make what i deem to be a substantial addition i give it a new version number. This is Version 23, so hopefully lots of new goodies to please you (and likely some minor bugs that I missed).
Free file hosting by Savefile.com
There are lots of minor changes. Here are the major ones:-
1) Database Changes:-
A) The hidden item database has now had a makeover which should make it easier for those brave enough to mess with it to figure out how it works without creating loads of error messages.
B) When selecting items in character sheet there are now splits by plate/mail/leather etc
C) Tier 6 leather is included (hopefully tier 4/5 will come later)
D) Season 3 gladiator gear, honor gear and weapons are included
E) JC only gems and some unique dungeon dropped gems are included
2) Character Sheet Mechanics Changes - ***Big Changes***
A) There is box near the top of the sheet labelled "Spare Mana Dps (SoC)". This box assumes the fight is 10 minutes long. Based on the playstlye of JoC/SoC/CS, mana regen, and mana pool is calculates:-
i) "Mps Spare" - how much extra mana per second you have to use on consecration/exorcism
ii) "Cons (Min)" - It attributes spare mps to this ability until it would be used on cooldown and calculates the dps is provided
iii) "Exorcism - Any extra mana spare is attributed to exorcisms and it's dps calculated
iv) "Mps Left" - it then tells you if you have any mps left after using consecration and exorcism on cooldown
B) The very top "Total Dps" box now lists the SoC dps from a normal rotation, the extra dps you get as explained in 2A), and then the grand total of these two combined
C) When using the Item calc, it now compares items based on the Total Dps including consecration and exorcism, thus giving Int/Mp5 items more weight.
D) Just above the Graph Calc section is a button labelled "Str/Crit POI". This stands for the strength/crit point of intersection. This is basically a bit of fun and tells you (based on your current gear etc) what AP you need to have in order for 1 Crit rating to be more valueable than 1AP.
3) Character Sheet Additions
A) Weapon expertise has been added and is included in the graph at the end (it's the dog's)
B) Haste/Heroic/Insance Strength pots have been added. Remember you can only have one, and there is the Mana pot option in the "playstyle" section as well, so dont have 2 pots active....thats cheating
C) Mongoose and Executioner have been added. These are base on 1ppm, with 40 hits per minute (this is accurate based on SoC/JoC/CS/WF spam playstyle). However it might overvalue them slightly if you dont spam JoC etc. Having them based on actual ppm made excel run very slowly (and also is difficult to model for mongoose seeing as the haste proc will change the hits per min)
D) "Best of the Best" has been relabelled "Warrior Gear". If anyone asks "Why is Lightbringer included in 'Warrior Gear' i will personally give you the 'wow experience' and show you what an axe to the face does to your health! :p
4) Minor Changes
A) Stalker's War Bands have had blue socket removed
B) Selecting "None" for a gem slot won't give you free Int/Stam
C) Lots of minor tweaks i've probably forgotten about
5) Important Notes
A) The "Item Calculation" tool still bases dps value based on socketing all strength gems and not correct gems to get set bonus. It's more often the case that strength gems are betetr than correct gems. Whilst not always true the way item socketing it done makes it a complete pain to socket correctly per item. The end results would probably be the same just slightly different value
B)***Important*** The model still assumes that extra damage caused from JotC can be effected by % modifiers even though this is not the case. When all the dps calculations were set up this was not known and the way they were all set up makes this minor thing a major pain in the ass to change. However please note that since this is a static value then the results shown within the spreadsheet are stil all valid relative to one another, just that the overall dps might be smarginally higher than you can expect. But this is only a small difference so please dont let it dissuade you from using this tool.
Anyway, Enjoy
Bellator