Radaghast

03-08-2006, 08:43 PM

(This is prob'ly going to be real, REAL boring, but it's intended to help those folks leveling a druid solo to have some concept of how good their current stats are by comparison to "the norm". Also, I'm pretty good at math, but haven't been playing WoW for too incredibly long, so my methods described here might be inaccurate. Criticism welcome!)

When I started playing as a Night Elf Druid, I realized immediately that I had NO bearing on how my character's stats were measuring up as I leveled. I started asking myself these kinds of questions:

If Spirit and Intellect are crucial to a successful druid, what are "good" values for these stats as I level (NOT just for level 60)? In other words, if I have some really nice rings and trinkets which improve these stats, how do I compare my "new and improved" stats with a "normal" druid?

What about the other stuff, how does it measure up? Is there a way to compare them to what I "should" have at my current level?

What about my current armor? Just how good is it, really? Is the armor I'm making via leatherworking/skinning better or worse than the "best" stuff I could be buying&using at my current level?

What are my extended stats, like my attack power in bear or cat form, my percent reduction due to my armor, or my "mana per tick"?

So, I did some research, and created a file, DruidCalc.xls, to help answer just that. It calculates the type of comparison stats I was interested in at any given level, and also displays them graphically. This is very much a work-in-progress, and as I learn more about the rules and trends of druid leveling, I'll make adjustments to my file.

There are three parts to this excel file:

1. CHARACTER STATS

After you enter in your own current stats, the excel file calculates PREDICTED stats, based on your current level, and compares your real stats from what it predicted, in the form of a percentage. It then displays this information in the form of a bar graph.

How does it do this? I did some research (still very much ongoing), and found base stats (no buffs, armor, etc.) for a level 1 druid, and for a level 60. The excel file assumes a linear relationship as you progress (meaning, for example, your SPIRIT stat is increased by 0.4 every time you level, or something like that). This may not be "correct", but it's a good ballpark way to compare where you are with where you probably should be, and as I get more info., I'll adjust the predictions accordingly.

For example, if due to your equipment, buffs, and other things, your Spirit is at 35, and the excel file estimates that at your current level, your Spirit should only be at 21 (since it doesn't take into account buffs and equipment), then your Spirit is 67% above where a "normal" druid's would be at that level.

2. ARMOR STATS

This was the toughie. I looked up the best Hand, Wrist, Feet, legs, Waist, and Chest armor available for druids from Thottbot at levels 10, 20, 30, 40, 50, and 60. I then interpolated this data any best way I could. These calculations came out pretty good, too, assuming Thottbot's info. can be trusted. For example, my R-squared value is lowest for my "Hand armor" interpolation, at 91%. Still pretty good.

And so here in this section, the user enters in their armor values, and the excel file calculates the theoretical "best" armor you should have at this level, and compares your real druid armor stats with what it calculated (again, in the form of a percentage). I say "best", because it assumes max armor and level stats from Thottbot, so again, it's a good ballpark estimate to see where you "should be".

For example, if your Chest armor's AC is 100, and the excel file estimates that the best chest armor around for your level is 50, then you are 100% above the estimated value for chest armor. Pretty good!

This information is also summarized in a bar graph within the excel file.

(You may note that I don't have neck, back, or other armor listed. That's because when you start a druid, you don't have any of this type of armor equipped. That means I consider these items "extras" for now, and so if you do have any of these items, the way to incorporate them is to add up their total armor value, and put add this into an "other" column.)

3. EXPANDED STATS

This is the extra stuff you may want to know about your character. All the formulas came from WoWwiki (and from what I read in the discussions, they're all assumed to be accurate). The definitions are as follows:

AP (Bear form) - your attack power in bear form

AP (Cat form) - your attack power in cat form

% Reduction - the amt. of damage reduction your armor has for each attack by a mob OF YOUR LEVEL, in the form of a percent. % Reduction can only be 75% or lower.

MaxofArmor - the armor level you would need to have a % Reduction value of 75%

% of Max - how far your armor is away from the MaxofArmor value. If your armor is one half that of MaxofArmor, then this value would be "50%".

ManaPerTick - amt. of mana you receive per "tick" of time, which is about 2 seconds.

Anyway, I know this is pretty boring to most, but the intent is to help others, so if you want to take a look, I can e-mail the file to you.

When I started playing as a Night Elf Druid, I realized immediately that I had NO bearing on how my character's stats were measuring up as I leveled. I started asking myself these kinds of questions:

If Spirit and Intellect are crucial to a successful druid, what are "good" values for these stats as I level (NOT just for level 60)? In other words, if I have some really nice rings and trinkets which improve these stats, how do I compare my "new and improved" stats with a "normal" druid?

What about the other stuff, how does it measure up? Is there a way to compare them to what I "should" have at my current level?

What about my current armor? Just how good is it, really? Is the armor I'm making via leatherworking/skinning better or worse than the "best" stuff I could be buying&using at my current level?

What are my extended stats, like my attack power in bear or cat form, my percent reduction due to my armor, or my "mana per tick"?

So, I did some research, and created a file, DruidCalc.xls, to help answer just that. It calculates the type of comparison stats I was interested in at any given level, and also displays them graphically. This is very much a work-in-progress, and as I learn more about the rules and trends of druid leveling, I'll make adjustments to my file.

There are three parts to this excel file:

1. CHARACTER STATS

After you enter in your own current stats, the excel file calculates PREDICTED stats, based on your current level, and compares your real stats from what it predicted, in the form of a percentage. It then displays this information in the form of a bar graph.

How does it do this? I did some research (still very much ongoing), and found base stats (no buffs, armor, etc.) for a level 1 druid, and for a level 60. The excel file assumes a linear relationship as you progress (meaning, for example, your SPIRIT stat is increased by 0.4 every time you level, or something like that). This may not be "correct", but it's a good ballpark way to compare where you are with where you probably should be, and as I get more info., I'll adjust the predictions accordingly.

For example, if due to your equipment, buffs, and other things, your Spirit is at 35, and the excel file estimates that at your current level, your Spirit should only be at 21 (since it doesn't take into account buffs and equipment), then your Spirit is 67% above where a "normal" druid's would be at that level.

2. ARMOR STATS

This was the toughie. I looked up the best Hand, Wrist, Feet, legs, Waist, and Chest armor available for druids from Thottbot at levels 10, 20, 30, 40, 50, and 60. I then interpolated this data any best way I could. These calculations came out pretty good, too, assuming Thottbot's info. can be trusted. For example, my R-squared value is lowest for my "Hand armor" interpolation, at 91%. Still pretty good.

And so here in this section, the user enters in their armor values, and the excel file calculates the theoretical "best" armor you should have at this level, and compares your real druid armor stats with what it calculated (again, in the form of a percentage). I say "best", because it assumes max armor and level stats from Thottbot, so again, it's a good ballpark estimate to see where you "should be".

For example, if your Chest armor's AC is 100, and the excel file estimates that the best chest armor around for your level is 50, then you are 100% above the estimated value for chest armor. Pretty good!

This information is also summarized in a bar graph within the excel file.

(You may note that I don't have neck, back, or other armor listed. That's because when you start a druid, you don't have any of this type of armor equipped. That means I consider these items "extras" for now, and so if you do have any of these items, the way to incorporate them is to add up their total armor value, and put add this into an "other" column.)

3. EXPANDED STATS

This is the extra stuff you may want to know about your character. All the formulas came from WoWwiki (and from what I read in the discussions, they're all assumed to be accurate). The definitions are as follows:

AP (Bear form) - your attack power in bear form

AP (Cat form) - your attack power in cat form

% Reduction - the amt. of damage reduction your armor has for each attack by a mob OF YOUR LEVEL, in the form of a percent. % Reduction can only be 75% or lower.

MaxofArmor - the armor level you would need to have a % Reduction value of 75%

% of Max - how far your armor is away from the MaxofArmor value. If your armor is one half that of MaxofArmor, then this value would be "50%".

ManaPerTick - amt. of mana you receive per "tick" of time, which is about 2 seconds.

Anyway, I know this is pretty boring to most, but the intent is to help others, so if you want to take a look, I can e-mail the file to you.