Hunter Spreadsheets -- In development - Page 53

PeterWelzien · 09/25/07, 4:30 AM

Stylin' Crimson Hat is missing.

onsi · 09/25/07, 4:52 PM

Great work Cheeky,anyone can confirm if DST modeling is up to date(v2.2)?

Cheeky · 09/25/07, 5:37 PM

Originally Posted by onsi

Great work Cheeky,anyone can confirm if DST modeling is up to date(v2.2)?

All changelogs are posted at the top of the thread:

Originally Posted by Lactose

Version 29:
- Updated model of [Dragonspine Trophy] to include a user-provisionable cooldown. Default is 20 seconds. The model had to completely change to support the internal cooldown, setting it to 0 will not generate the same numbers given previously. Please use version 28 of the spreadsheet to get numbers for 2.1 with the Dragonspine Trophy
- Provided the user the ability to select 2.1 or 2.2 Haste Rating conversion rates. (This will be removed when 2.2 goes live.)

nicat · 09/25/07, 6:02 PM

Cheeky,

I am sure you will probably pick up the changes, but figured I would get a hunter list together. It appears some of the latest items in 2.2 are missing from the spreadsheet.

All Gems are unique-equipped

Delicate Fire Ruby (12 agility)
Rigid Bladestone (12 hit rating)
Stone of Blades (12 crit rating)
Crimson Sun (24 Attack power)
Falling Star (18 stam)

Enchant

Enchant Weapon - Greater Agility (20 agility to 1h)

Lactose · 09/25/07, 6:11 PM

Missing items & enchants added to bug list.

Bikiniwax · 09/26/07, 12:57 PM

Using version 30 of the spreadsheet:

I plugged in all my talents and gear (from my Armory) but for some reason the Crit and AP on the spreadsheet are not what is on my Armoury.

AP Armoury - 1816
AP Spreadsheet - 1848

Crit % Armoury - 27.22%
Crit % Spreadsheet - 26.62%

My HP, Mana and Armour are correct.

For the life of me, I cannot figure out why the difference in Crit and Ap (32 AP diff).

I logged out only with AotH on and no other buffs.

MikeMo · 09/26/07, 1:06 PM

I know crit is typically lower since by defaul the spread sheet calculates it based on the fact that you will be fighting a level 73 boss. I am not sure why your AP is lower however.

Bikiniwax · 09/26/07, 1:35 PM

Originally Posted by MikeMo

I know crit is typically lower since by defaul the spread sheet calculates it based on the fact that you will be fighting a level 73 boss. I am not sure why your AP is lower however.

You're right! I had it set to a lvl 73 mob. Once I set it to lvl 70, my Crit jumped to 27.22% which matches my armoury. Thanks!

Unfortunately, my RAP still reports 1848 on the spreadsheet but 1816 on my Armory.

EDIT: Nevermind! I figured it out. I was looking at Total, Effective RAP which includes Procs (DST). Above that, my RAP shows 1816. Stupid brain.

Thanks again!

Cheeky · 09/26/07, 1:41 PM

Originally Posted by Bikiniwax

You're right! I had it set to a lvl 73 mob. Once I set it to lvl 70, my Crit jumped to 27.22% which matches my armoury. Thanks!

Unfortunately, my RAP still reports 1848 on the spreadsheet but 1816 on my Armory.

EDIT: Nevermind! I figured it out. I was looking at Total, Effective RAP which includes Procs (DST). Above that, my RAP shows 1816. Stupid brain.

Thanks again!

I really need to include a "Your character sheet says this" section. I get a lot of messages from people for this, especially about the crit chance.

Bikiniwax · 09/26/07, 1:48 PM

Good point!

Cheeky, what amount do suggest for plugging into the Target Armor box for your average LvL 73 boss?

Cheeky · 09/26/07, 4:04 PM

Originally Posted by Bikiniwax

Good point!

Cheeky, what amount do suggest for plugging into the Target Armor box for your average LvL 73 boss?

Well, that's the real trick, ain't it.

Lactose is in the process of tracking down armor values for different raid bosses. I hope to add a feature where you can select a boss and get an accurate armor value. I'll also provide Fairy Fire and Sunder Armor as mob debuffs. For now, I'd use 30-35% reduction, about ~5000 armor.

Bikiniwax · 09/26/07, 4:53 PM

Alright thanks!

SiRk · 09/27/07, 4:03 AM

I'm sure you guys are already working on it, but don't forget to update all the SSC/TK items that have had their item level increased with patch 2.2

Keep up the good work!

Xeno · 09/27/07, 4:34 AM

version 30 bug: There's a problem with the relentless earthstorm diamond in that if you don't have the correct gems it will remain active for the purposes of increased critical hit damage.

RED also doesn't increase the total critical hit damage for arcane shot like other shots. If you have mortal shots the critical hit damage will be 233% unlike the other shots which would be 236.9%

Mark of conquest seems to be listed as 42.8 mp5? I'm sure this is just a typo, it's closer to 32 mp5, definitely between 30-35.

Choker of Serated Blades is incorrectly listed as having 154 armor penetration when in fact it is 175.

On a different note, would it be possible to make public the calculations for attributes + 1? Specifically haste, it seems … incorrect.

edit: Calculations!D32 has a typo Ranged WeaponWeapon DPS

edit: After looking at the mark of conquest calculation it seems like the problem is that you have it as a flat chance on hit. From my testing the internal cooldown is 17 secs (very confident of that number) with a 13% chance to proc (reasonably confident of that number.)

edit: The problem with the +1 haste attribute was that I had just passed the quick shots "haste cap" effectively halving the +1 haste value.

Lactose · 09/27/07, 4:54 AM

Originally Posted by Xeno

On a different note, would it be possible to make public the calculations for attributes + 1? Specifically haste, it seems … incorrect.

The +1 part is a macro that increases the amount of the stat by 1, then runs the calculations again, storing the values and compares them at the end.

Adding the other points to the bug list. I'm sure there'll be incorrect items and such, even after the next version. If so, just post or PM me.