06-07-2008, 01:54 PM
Since there has been some discussion about what cast time to use in the calculations, I decided to make it an option in the spreadsheet. So now there is a place to enter what cast time to use as well as a place to enter a delay. So for FoL one can enter 1.5 for the cast speed and either 0 or 0.5 for the delay depending on what you feel is accurate. So in order to make this actually have an effect I had to go in and change the ratings from hard coded numbers to equations. In the process of this I realized some of my previous math was horrible.
First off, when I was calculationg the ratio for haste/heal I was doing it using the gain from base values. It is more accurate to use the actual HPS values for that calculation. Doing that raises haste quite a bit so that the rating is 10 heal = 9.82 haste. This is with FoL hitting for 1500, which I have also added as an adjustable value in the spreadsheet. Due to this, I don't think there is a need for penalizing the haste rating to be sure you hit the assumed heal rating. There still may be need for a mana penalty though and so I've added a field for that. Currently I just have it set at a mana penalty of 1 which brings it to 10 heal = 10.82 haste.
I also noticed that my crit conclusion was really weird. I said that heal wins at 1500 and below, but looking back at the numbers they clearly show that crit is better from 1000 on up. So I don't know what I was thinking at the time. Instead of worrying about that though, I've just switched the crit rating value over to an equation as well which is based off of the value you entered for your FoL heals. That ends up giving 10 heal = 22.54 crit.
So the ratings now stand at
10 heal = 10.82 haste = 4 mp5 = 22.54 crit = 25 stam = 30 int
With some of then being equation based and so variable based on what you enter for cast speed and etc. It should also be noted that the Insightful calculations are also based off of the value entered for cast speed/delay. I also took out the the penalty on it for having to use different gems to meet the requirement. I figure that with the comparison sheet now, one can see what using the different gemmed gear does. So having Insightful penaltized in it's own rating would cause it to be penalized twice.
So basically more things have been converted to equations for excel to calculate so as to remove human error and allow for easier adjustments.
The spreadsheet
First off, when I was calculationg the ratio for haste/heal I was doing it using the gain from base values. It is more accurate to use the actual HPS values for that calculation. Doing that raises haste quite a bit so that the rating is 10 heal = 9.82 haste. This is with FoL hitting for 1500, which I have also added as an adjustable value in the spreadsheet. Due to this, I don't think there is a need for penalizing the haste rating to be sure you hit the assumed heal rating. There still may be need for a mana penalty though and so I've added a field for that. Currently I just have it set at a mana penalty of 1 which brings it to 10 heal = 10.82 haste.
I also noticed that my crit conclusion was really weird. I said that heal wins at 1500 and below, but looking back at the numbers they clearly show that crit is better from 1000 on up. So I don't know what I was thinking at the time. Instead of worrying about that though, I've just switched the crit rating value over to an equation as well which is based off of the value you entered for your FoL heals. That ends up giving 10 heal = 22.54 crit.
So the ratings now stand at
10 heal = 10.82 haste = 4 mp5 = 22.54 crit = 25 stam = 30 int
With some of then being equation based and so variable based on what you enter for cast speed and etc. It should also be noted that the Insightful calculations are also based off of the value entered for cast speed/delay. I also took out the the penalty on it for having to use different gems to meet the requirement. I figure that with the comparison sheet now, one can see what using the different gemmed gear does. So having Insightful penaltized in it's own rating would cause it to be penalized twice.
So basically more things have been converted to equations for excel to calculate so as to remove human error and allow for easier adjustments.
The spreadsheet