I like the file. I did notice that the dual wield calculation for damage is slightly off from what the Damage shows in game. I fixed the calculation on the file on my end. The Problem is you can't just multiply the damage of each weapon by their adjusted swing speed because when you attack, you have to alternate swings. So really, you take 1 sec / adjusted swing speed to get the timed delay between left hand, right hand, left hand, etc. So the calculation ends up being essentially
((MH+ armor damage)*(crit variable)*(skill damage)*(stat variable)+(OH+ armor damage)*(crit variable)*(skill damage)*(stat variable))/ (1/MH speed variable + 1/OH speed variable)/ (Constant).
Where the Constant is 1.00028 as i have discovred when playing several different items to test the formula.
Here is the exact formula that i changed it to for the column C calculation, so you can copy and paste and test
=IF(((C8+C9)>0),((((1+C32)*(SUM(C3:C4,C13:C14,C15:C16,C17:C18,C19:C20)/2)*(1+(C34*C35))*(1+(C31/100)))+((1+C32)*(SUM(C8:C9,C13:C14,C15:C16,C17:C18,C19:C20)/2)*(1+(C34*C35)))*(1+(C31/100)))/(1/(C7*((1+C21)+0.15))+1/(C12*((1+C21)+0.15))))/1.00028,(SUM(C3:C4,C13:C14,C15:C16,C17:C18,C19:C20)/2)*C33*(1+C32)*(1+(C34*C35))*(1+(C31/100)))
Also, I agree with someone before about Not needing the Increases Attack Speed By & Total Weapon Attack Speed rows since the attack speed is already figured into the value listed on an item.
@Khays- For test DW vs 2H. Insted of using the Change column (D), i copied the formulas in C30:C33 over to column G, and then in column G i filled in all the 2H data i need in the required rows.
0
I like the file. I did notice that the dual wield calculation for damage is slightly off from what the Damage shows in game. I fixed the calculation on the file on my end. The Problem is you can't just multiply the damage of each weapon by their adjusted swing speed because when you attack, you have to alternate swings. So really, you take 1 sec / adjusted swing speed to get the timed delay between left hand, right hand, left hand, etc. So the calculation ends up being essentially
((MH+ armor damage)*(crit variable)*(skill damage)*(stat variable)+(OH+ armor damage)*(crit variable)*(skill damage)*(stat variable))/ (1/MH speed variable + 1/OH speed variable)/ (Constant).
Where the Constant is 1.00028 as i have discovred when playing several different items to test the formula.
Here is the exact formula that i changed it to for the column C calculation, so you can copy and paste and test
=IF(((C8+C9)>0),((((1+C32)*(SUM(C3:C4,C13:C14,C15:C16,C17:C18,C19:C20)/2)*(1+(C34*C35))*(1+(C31/100)))+((1+C32)*(SUM(C8:C9,C13:C14,C15:C16,C17:C18,C19:C20)/2)*(1+(C34*C35)))*(1+(C31/100)))/(1/(C7*((1+C21)+0.15))+1/(C12*((1+C21)+0.15))))/1.00028,(SUM(C3:C4,C13:C14,C15:C16,C17:C18,C19:C20)/2)*C33*(1+C32)*(1+(C34*C35))*(1+(C31/100)))
Also, I agree with someone before about Not needing the Increases Attack Speed By & Total Weapon Attack Speed rows since the attack speed is already figured into the value listed on an item.
@Khays- For test DW vs 2H. Insted of using the Change column (D), i copied the formulas in C30:C33 over to column G, and then in column G i filled in all the 2H data i need in the required rows.