Post by gandoron on Apr 19, 2010 5:06:48 GMT
Weapon analysis - my calculation of the weapon sheet
spreadsheets.google.com/pub?key=tZDomDJGeMeTufvEauRMmVg&single=true&gid=8&output=html
Analysis assumptions
spreadsheets.google.com/pub?key=txJJk03lngGcX0L7zwVDEDg&single=true&gid=0&output=html
Analysis of BAB progression on damage based on various iterations. This show # of attack break points, this is an AB agnostic graph, but based on BAB. This sheet uses the DC column from the weap comparison.
spreadsheets.google.com/pub?key=t0nEcbr8WsGZP_ojpZV-ayQ&single=true&gid=0&output=html
The above links calculate the HG critical sheet (http://spreadsheets.google.com/pub?key=pkPtUjd4yKNxPFUqYFmWsMQ) on the fly using discrete per attack analysis, not % adjustments. This is done through the damage calculation xls (link at bottom).
Here is a spreadsheet that I've been working on since December (link at bottom). This calculates all the damage from weapons with discrete per hit analysis, no % adjustments.
This sheet was really designed to ask questions like, how will my damage output change if I...
-drop my str mod and go dual weapon
-change from Str Cot with div wrath to dex monk with kamas
-if I start fighting crit-imm mobs, should I change my weapon
-how many Mortal Strikes does a dex assassin have per round compared to a str assassin
If I have a certain setup, with AC-AB=0, then dual weapon is 13% damage increase and Double is 24%.
However if AC-AB=-10, then Dual is -16% and Double is 11% damage adjustments.
The Baseline numbers (crit and non-crit) are the most subjective, but not the most useful. They treat every attack as the same, Dam crit and Dam non-crit are probably the most useful comparison values, but these use some subjective values for imms/resists/soak etc.
In light of the recent conversation, I added in all the weapons as currently proposed on Funky's sheet and created a weapons table to compare their value. Most of the numbers match up with the originally calculated numbers fairly closely, but these sheet provides some insight into how those numbers were derived. Please keep in mind that factors like AC-AB(mob AC), BAB, Str Mod, unresistable damage, subrace size (in respect to weapon size) affect these numbers and weapon comparison calculations significantly. BAB in particular affects the iteration comparison very much. When using one "configuration" I have the tables at the bottom, including an iteration table to see the direct effects of an iter change. The baseline value for the weapon table can be changed. Funky's uses the Assasin dagger as 1.00, so make sure to set up a configuration with the assassin dagger as the chosen weapon, then "reset baseline" to lock it in for comparisons. Keep in mind that no % adjustments are made for iteration, double weapon damages, etc. Everything is calculated discretely for each attack. 50% phys imm is used in general, with 20% for a double physical type weapon. The bonus to damage will vary with Str mod. Keep in mind that variations of AB can be tied to some weapons, for instance, to use a monk weapon you need at least one monk level (preferably more) so you have max BAB of 19.
There is only one macro, just designed to copy cells quickly to reset a comparison configuration "Reset Baseline".
What is included in this sheet.
All weapons, weapon feats, str mod, proper attack/ab progression for all weapon configurations (single handed, dual, double), pwr/sup crit, sizes (to the best of my ability) and big packet vs small packet damage.
Attacks are in 3 buckets, Prim (reg), Prim (bonus) and Off hand. Primary bonus always has a -5 progression and is not affected by two-weapon fighting reductions.
I had thought about actually putting every hell mob in with KV info, but instead opted for average imm values. I'm currently using. For better abyss data, you should probably use some amount of resist. Note I have NOT tried to include stuff like FW/DF
Now it's likely I made a couple errors somewhere, if you can find any, please let me know.
Kaezar, crit confirm is taken into consideration correctly in this sheet, only applied to the 2nd check.
My damage calculation sheet
rcpt.yousendit.com/855892749/99d4c18ddb714722f0d2eea62191afe4
Let me know if you have any thoughts. If you use this sheet or build upon it, please note the original source.
-Gandoron
spreadsheets.google.com/pub?key=tZDomDJGeMeTufvEauRMmVg&single=true&gid=8&output=html
Analysis assumptions
spreadsheets.google.com/pub?key=txJJk03lngGcX0L7zwVDEDg&single=true&gid=0&output=html
Analysis of BAB progression on damage based on various iterations. This show # of attack break points, this is an AB agnostic graph, but based on BAB. This sheet uses the DC column from the weap comparison.
spreadsheets.google.com/pub?key=t0nEcbr8WsGZP_ojpZV-ayQ&single=true&gid=0&output=html
The above links calculate the HG critical sheet (http://spreadsheets.google.com/pub?key=pkPtUjd4yKNxPFUqYFmWsMQ) on the fly using discrete per attack analysis, not % adjustments. This is done through the damage calculation xls (link at bottom).
Here is a spreadsheet that I've been working on since December (link at bottom). This calculates all the damage from weapons with discrete per hit analysis, no % adjustments.
This sheet was really designed to ask questions like, how will my damage output change if I...
-drop my str mod and go dual weapon
-change from Str Cot with div wrath to dex monk with kamas
-if I start fighting crit-imm mobs, should I change my weapon
-how many Mortal Strikes does a dex assassin have per round compared to a str assassin
If I have a certain setup, with AC-AB=0, then dual weapon is 13% damage increase and Double is 24%.
However if AC-AB=-10, then Dual is -16% and Double is 11% damage adjustments.
The Baseline numbers (crit and non-crit) are the most subjective, but not the most useful. They treat every attack as the same, Dam crit and Dam non-crit are probably the most useful comparison values, but these use some subjective values for imms/resists/soak etc.
In light of the recent conversation, I added in all the weapons as currently proposed on Funky's sheet and created a weapons table to compare their value. Most of the numbers match up with the originally calculated numbers fairly closely, but these sheet provides some insight into how those numbers were derived. Please keep in mind that factors like AC-AB(mob AC), BAB, Str Mod, unresistable damage, subrace size (in respect to weapon size) affect these numbers and weapon comparison calculations significantly. BAB in particular affects the iteration comparison very much. When using one "configuration" I have the tables at the bottom, including an iteration table to see the direct effects of an iter change. The baseline value for the weapon table can be changed. Funky's uses the Assasin dagger as 1.00, so make sure to set up a configuration with the assassin dagger as the chosen weapon, then "reset baseline" to lock it in for comparisons. Keep in mind that no % adjustments are made for iteration, double weapon damages, etc. Everything is calculated discretely for each attack. 50% phys imm is used in general, with 20% for a double physical type weapon. The bonus to damage will vary with Str mod. Keep in mind that variations of AB can be tied to some weapons, for instance, to use a monk weapon you need at least one monk level (preferably more) so you have max BAB of 19.
There is only one macro, just designed to copy cells quickly to reset a comparison configuration "Reset Baseline".
What is included in this sheet.
All weapons, weapon feats, str mod, proper attack/ab progression for all weapon configurations (single handed, dual, double), pwr/sup crit, sizes (to the best of my ability) and big packet vs small packet damage.
Attacks are in 3 buckets, Prim (reg), Prim (bonus) and Off hand. Primary bonus always has a -5 progression and is not affected by two-weapon fighting reductions.
I had thought about actually putting every hell mob in with KV info, but instead opted for average imm values. I'm currently using. For better abyss data, you should probably use some amount of resist. Note I have NOT tried to include stuff like FW/DF
Now it's likely I made a couple errors somewhere, if you can find any, please let me know.
Kaezar, crit confirm is taken into consideration correctly in this sheet, only applied to the 2nd check.
My damage calculation sheet
rcpt.yousendit.com/855892749/99d4c18ddb714722f0d2eea62191afe4
Let me know if you have any thoughts. If you use this sheet or build upon it, please note the original source.
-Gandoron