I've had a thread on the official forums and the theorycraft forums here for a fair while now but I think the sheet is at a stage where it is mostly fleshed out and good for general use.
Note that this spreadsheet will not be functional if exported from googledocs, due to extensive usage of dropdown menus, including dynamic dropdown menus for skill selection and damage values.
What can the sheet do?
The sheet can take your current statistics, skill setup and party member abilities and tell you exactly how much damage reduction and effective health you have, both actively and passively (ie: how much you have while doing nothing at all, and how much you have when all your skills are actively working on the enemies). Moving on from this, the sheet also allows you to see the relative values of stats in increasing your damage reduction, effective health, and survivability. It allows you to enter a piece of gear (and the piece it will be replacing), and see the relative values of the gear in equivalency points terms, as well as compare the gains and losses in DR and effective health.
The sheet also has a DPS section, which allows you to compare your expected character sheet dps of up to 5 weapons that you can input. It will also tell you expected non-mitigated damage values for all dps skills, factoring in all skills currently selected for your character that may increase damage - again, both passive and active.
How to use the sheet:
All of the calculations for the sheet are based on the stats and skills you input on the second page (Character stats). Enter the stats as you see them on your character screen in game, making sure that you do not currently have any skill applied in game that affects stats. The character stats screens needs your stats WITHOUT "Seize the initiative", WITHOUT any mantras active, and so forth. When you have done this, you can then set your skills from the character stats page and the stats will be updated to reflect these skills dynamically.
To use the damage sheet, you need to enter your damage-related stats on the same page, but make sure you do so without any weapons equipped. Due to the way that the character sheet displays certain statistics (especially attack speed), the damage sheet can only be accurate by doing it this way. You can then enter your current weapon/weapons as selections on the damage screen to display your current damage values.
There are some options in the sheet that may not be obvious the first time you look, simply because there is a little bit of information overload. One thing I would point out is that in both the damage and damage reduction sheets, you have the ability to switch certain elements between PASSIVE and ACTIVE options, updating the values dynamically. Don't forget to set these cells to the correct value.
Coming next:
The next major addition to the sheet will involve heals per second and life on hit. Unfortunately, comparing these stats directly with other defensive stats moves into the realm of modelling rather than simple math, and is probably outside the scope of this sheet, but at the very least you should be able to get a rudimentary valuation on your healing stats.
What the sheet can't do:
Like I said above, modelling real time expected heals or damage is probably outside the scope of the sheet. The sheet will give good information on which skills are good to use in certain circumstances thanks to the damage per spirit cost, but it will never give an accurate real time expected damage per second, because that would require computation of dps based on certain rotations and that sort of thing. Similarly, I wouldn't expect to be modelling dynamic time to live based on incoming damage/speed that would take into account heals per second and effective health, it just requires more rotation modelling than I can really do in a spreadsheet.
Thanks for reading, hopefully you find the sheet useful in making decisions on gearing your Monks! If you have any questions or concerns, don't hesitate to contact me here or on the official forum thread.
You can find the sheet here:
https://docs.google.com/spreadsheet/ccc?key=0ApVAeMW4XRfcdHlneGhLMVdpYnFYMUM3R0IydmNFRWc#gid=0
The thread on the official forums is here:
http://us.battle.net/d3/en/forum/topic/5150759905
Note that this spreadsheet will not be functional if exported from googledocs, due to extensive usage of dropdown menus, including dynamic dropdown menus for skill selection and damage values.
What can the sheet do?
The sheet can take your current statistics, skill setup and party member abilities and tell you exactly how much damage reduction and effective health you have, both actively and passively (ie: how much you have while doing nothing at all, and how much you have when all your skills are actively working on the enemies). Moving on from this, the sheet also allows you to see the relative values of stats in increasing your damage reduction, effective health, and survivability. It allows you to enter a piece of gear (and the piece it will be replacing), and see the relative values of the gear in equivalency points terms, as well as compare the gains and losses in DR and effective health.
The sheet also has a DPS section, which allows you to compare your expected character sheet dps of up to 5 weapons that you can input. It will also tell you expected non-mitigated damage values for all dps skills, factoring in all skills currently selected for your character that may increase damage - again, both passive and active.
How to use the sheet:
All of the calculations for the sheet are based on the stats and skills you input on the second page (Character stats). Enter the stats as you see them on your character screen in game, making sure that you do not currently have any skill applied in game that affects stats. The character stats screens needs your stats WITHOUT "Seize the initiative", WITHOUT any mantras active, and so forth. When you have done this, you can then set your skills from the character stats page and the stats will be updated to reflect these skills dynamically.
To use the damage sheet, you need to enter your damage-related stats on the same page, but make sure you do so without any weapons equipped. Due to the way that the character sheet displays certain statistics (especially attack speed), the damage sheet can only be accurate by doing it this way. You can then enter your current weapon/weapons as selections on the damage screen to display your current damage values.
There are some options in the sheet that may not be obvious the first time you look, simply because there is a little bit of information overload. One thing I would point out is that in both the damage and damage reduction sheets, you have the ability to switch certain elements between PASSIVE and ACTIVE options, updating the values dynamically. Don't forget to set these cells to the correct value.
Coming next:
The next major addition to the sheet will involve heals per second and life on hit. Unfortunately, comparing these stats directly with other defensive stats moves into the realm of modelling rather than simple math, and is probably outside the scope of this sheet, but at the very least you should be able to get a rudimentary valuation on your healing stats.
What the sheet can't do:
Like I said above, modelling real time expected heals or damage is probably outside the scope of the sheet. The sheet will give good information on which skills are good to use in certain circumstances thanks to the damage per spirit cost, but it will never give an accurate real time expected damage per second, because that would require computation of dps based on certain rotations and that sort of thing. Similarly, I wouldn't expect to be modelling dynamic time to live based on incoming damage/speed that would take into account heals per second and effective health, it just requires more rotation modelling than I can really do in a spreadsheet.
Thanks for reading, hopefully you find the sheet useful in making decisions on gearing your Monks! If you have any questions or concerns, don't hesitate to contact me here or on the official forum thread.
I did, however, have one gripe: I can't enter gear data!
So, I added another sheet and a few options!
Check it out and let me know what you think.
https://docs.google....SzY1YXNiR2pWM1E