PC version didn't have offline to avoid potential security issues which don't exist in a console version. PC will not get offline mode - don't get your hopes up.
Blizzard is a company that is now entirely driven by money. You can have an opinion either way on this; clearly it is their job and their duty to their shareholders to produce as much profit as possible. However, it isn't the roots of Blizzard, it isn't where the company came from. The rationales and decision processes behind previous releases are not the same as those of Blizzard today.
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.
I've had a thread over on the official Monk forums for a few days now but I thought I'd post this here as well now that it is more fleshed out. I've been working on a Monk-specific spreadsheet that is now capable of calculating effective DR, Health and equivalency values based on mitigation, mitigation+dodge and effective health. You can also toggle all passive and active skill-based increases dynamically and compare results in each case (with active skills enabled, and with only passives), as well as viewing the relative stat values based on active or passive skills.
It also contains a sheet to calculate character sheet DPS based on all relevant stats with the ability to compare up to 5 weapons, as well as expected pre-mitigation damage values for each of the skills, along with their damage per spirit ratios, again with the ability to dynamically enable and disable all class's damage increasing skills. The damage calculator is not as fleshed out as the DR one - it won't do any sort of real time damage calculation based on rotation or anything like that.
I'm posting it here in case anyone finds it useful, but also in the hopes that people more mathy than myself can vette the information that it is outputting to be accurate enough. The official forum thread is here: http://us.battle.net...50759905?page=1
It will not work by directly exporting to excel because it uses a lot of validation cells for drop boxes. You can manually enter the cells requiring drop boxes and it will still work, or you can recreate the drop boxes. I would recommend just making a copy in googledocs and using it there.
Simple to use instructions:
For current gear DR calculations:
Enter your stats with no skills or runes active that will modify them directly as you see them on your character sheet into the white cells on the first DR sheet.
Modify the skills you want to enable or disable.
All your DR, EH and equivalency values will be visible in either yellow or orange cells - it is simply a matter of identifying which you want to know.
To compare gear for DR purposes, go to the second DR sheet, and enter the stats of the gear you want to remove, and the gear you want to replace it with. The sheet will drag all the relevant data from the previous sheet, alter it for the gear changes, and present it all to you in the same manner as the first sheet. It will provide a comparison of the two pieces based on the equivalency points on the left, along with showing the relevant drops or gains in DR/EH.
The only skill that is not covered adequately in terms of DR is block, and that is because the effective value of block changes depending on the number and strength of incoming attacks. You can enter your block chance and value in the sheet and it will present an average blocked damage per second depending on the attacks per second you set in the TTL section, but that assumes that all blocks are full blocks and isn't really a useful stat besides interest.
For the DPS sheet you can enter up to 5 weapons/shields and switch between them. Simple enter your base stats without a weapon in the top section, enter the weapon stats in the lower section, and then select which weapon you want in your main and and which in your offhand. The dps will change to reflect your weapon choices, and the expected pre-mitigation skill damage values will update below. You can choose which rune to view next to each skill.
You can also enable or disable any and all damage-modifying skills in the table below the ability damage table.
2
Blizzard is a company that is now entirely driven by money. You can have an opinion either way on this; clearly it is their job and their duty to their shareholders to produce as much profit as possible. However, it isn't the roots of Blizzard, it isn't where the company came from. The rationales and decision processes behind previous releases are not the same as those of Blizzard today.
1
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.
4
It also contains a sheet to calculate character sheet DPS based on all relevant stats with the ability to compare up to 5 weapons, as well as expected pre-mitigation damage values for each of the skills, along with their damage per spirit ratios, again with the ability to dynamically enable and disable all class's damage increasing skills. The damage calculator is not as fleshed out as the DR one - it won't do any sort of real time damage calculation based on rotation or anything like that.
I'm posting it here in case anyone finds it useful, but also in the hopes that people more mathy than myself can vette the information that it is outputting to be accurate enough. The official forum thread is here:
http://us.battle.net...50759905?page=1
The spreadsheet is here:
It will not work by directly exporting to excel because it uses a lot of validation cells for drop boxes. You can manually enter the cells requiring drop boxes and it will still work, or you can recreate the drop boxes. I would recommend just making a copy in googledocs and using it there.
Simple to use instructions:
For current gear DR calculations:
Enter your stats with no skills or runes active that will modify them directly as you see them on your character sheet into the white cells on the first DR sheet.
Modify the skills you want to enable or disable.
All your DR, EH and equivalency values will be visible in either yellow or orange cells - it is simply a matter of identifying which you want to know.
To compare gear for DR purposes, go to the second DR sheet, and enter the stats of the gear you want to remove, and the gear you want to replace it with. The sheet will drag all the relevant data from the previous sheet, alter it for the gear changes, and present it all to you in the same manner as the first sheet. It will provide a comparison of the two pieces based on the equivalency points on the left, along with showing the relevant drops or gains in DR/EH.
The only skill that is not covered adequately in terms of DR is block, and that is because the effective value of block changes depending on the number and strength of incoming attacks. You can enter your block chance and value in the sheet and it will present an average blocked damage per second depending on the attacks per second you set in the TTL section, but that assumes that all blocks are full blocks and isn't really a useful stat besides interest.
For the DPS sheet you can enter up to 5 weapons/shields and switch between them. Simple enter your base stats without a weapon in the top section, enter the weapon stats in the lower section, and then select which weapon you want in your main and and which in your offhand. The dps will change to reflect your weapon choices, and the expected pre-mitigation skill damage values will update below. You can choose which rune to view next to each skill.
You can also enable or disable any and all damage-modifying skills in the table below the ability damage table.
Let me know what mistakes you find!