Hunter Spreadsheets -- In development - Page 40

Xenoborg · 08/23/07, 10:53 AM

I cant seem to find a good database of what kind of armor bosses have. I use 10k right now just because I think that gives a good approximation to what I actually do in raids. What do you guys use?

Reipin Pillage · 08/23/07, 11:11 AM

Quickstrider Moccasins have their Hit Rating points in the wrong slot. In your spreadsheet they are giving 15mp5 as opposed to 15 HR. Sorry if this has been mentioned.

Ailee · 08/23/07, 11:11 AM

It really depends on the boss. Example, though lower bosses, Aran doesn't have anywhere near the armor of Prince. I'd say try anywhere in the 20-30% reduction range on average for most bosses.

Cheeky · 08/23/07, 11:24 AM

Originally Posted by Xenoborg

I cant seem to find a good database of what kind of armor bosses have. I use 10k right now just because I think that gives a good approximation to what I actually do in raids. What do you guys use?

It different per boss, as Ailee said, and it also is effected by Sunder Armor and Fairy Fire. I haven't a clue what to put in there, so I leave it completely user configurable.

Lactose · 08/23/07, 12:05 PM

Once my ISP is fixed (making me able to raid), I'll do some testing on armor mitigation for bosses.

Norek · 08/23/07, 2:44 PM

Hi there cheeky, new to this whole spread sheet thing honestly, I ran a search for this post trying to find what I wanted to know without to much luck.

Basically from what I read this doesnt work all to great with open office, unfortunately thats the best I can get atm =p From what I gather in the postings I cant set the drop downs for the gems to gems only because of some Open Office shanangins, thats fine, but when I got into the drop down list it only shows maybe a total of 5 gems, which kinda hurts when trying to see valid stats.

If I could get a bit of help with getting this to "work" with open office thated be great, if you already have info posted about this some place else I'm sorry I missed it and will gladly read it if directed to it. Sorry for the block of text =p

Cheeky · 08/23/07, 3:00 PM

Originally Posted by Norek

Hi there cheeky, new to this whole spread sheet thing honestly, I ran a search for this post trying to find what I wanted to know without to much luck.

Basically from what I read this doesnt work all to great with open office, unfortunately thats the best I can get atm =p From what I gather in the postings I cant set the drop downs for the gems to gems only because of some Open Office shanangins, thats fine, but when I got into the drop down list it only shows maybe a total of 5 gems, which kinda hurts when trying to see valid stats.

If I could get a bit of help with getting this to "work" with open office thated be great, if you already have info posted about this some place else I'm sorry I missed it and will gladly read it if directed to it. Sorry for the block of text =p

This was posted a little previous in the thread:

Originally Posted by Cheeky

Since the Gem locations are unprotected, you can modify the Validity for the cells yourself. Select all the gem cells simultaneously and change the Validation to be =Gems (default will be =INDIRECT(xxx) - different for each cell). You should be fine doing that.

So are you saying you did that and it still doesn't show you all the gems? If so, I don't know what to tell you. I can't test every version of Open Office, and since I have Excel I take advantage of its features as much as possible to simplify development.

Lactose · 08/23/07, 7:24 PM

Right, couldn't find any armor formula with a quick search, so only percentages (should be correct to the closest 0.5%).
Sadly, only 3 minor bosses right now.

Pathaleon the Calculator (Heroic): 36.0% armor mitigation
Julianne: With 5x Sunder Armor and Faerie Fire (Feral) -- 21.5% armor mitigation
Romulo: With 5x Sunder Armor and Faerie Fire (Feral) -- 29.5% armor mitigation

KayossZero · 08/23/07, 9:43 PM

Originally Posted by Norek

Hi there cheeky, new to this whole spread sheet thing honestly, I ran a search for this post trying to find what I wanted to know without to much luck.

Basically from what I read this doesnt work all to great with open office, unfortunately thats the best I can get atm =p From what I gather in the postings I cant set the drop downs for the gems to gems only because of some Open Office shanangins, thats fine, but when I got into the drop down list it only shows maybe a total of 5 gems, which kinda hurts when trying to see valid stats.

If I could get a bit of help with getting this to "work" with open office thated be great, if you already have info posted about this some place else I'm sorry I missed it and will gladly read it if directed to it. Sorry for the block of text =p

Originally Posted by Glaurong

The Novell edition of Open Office has support for using/porting VBA.

You can get it at http://download.novell.com

This is what I'm using thanks to Glaurong's tip.

khel · 08/24/07, 7:31 AM

Originally Posted by Lactose

Right, couldn't find any armor formula with a quick search, so only percentages (should be correct to the closest 0.5%).
Sadly, only 3 minor bosses right now.

Pathaleon the Calculator (Heroic): 36.0% armor mitigation
Julianne: With 5x Sunder Armor and Faerie Fire (Feral) -- 21.5% armor mitigation
Romulo: With 5x Sunder Armor and Faerie Fire (Feral) -- 29.5% armor mitigation

This is great. Boss armor absorption plays such a big role in determining what our dps is, and it's useful for other physical dpsers as well.

I will try to take a WWS of our next SSC raid and see if I can help a bit. It would be a small sample-size for each boss, but reverse-engineering 700-800 shots per boss should give a reasonable estimate.

Lactose · 08/24/07, 7:40 AM

That won't be needed. The way I'm doing it I only need 1 non-crit to get the armor mitigation, and it'll be accurate to within 0.5% (inaccuracies due to rounding).
I just need my ISP to fix stuff, and values should be coming pretty fast.

Zedd · 08/24/07, 7:44 AM

Hello Cheeky.
I have been using your spreadsheet for a long time now and I have to thank your for doing an awsome job with it.
Now I have a question, I have "Shard-Bound Bracers" but I can not find them in the spreadsheet, as far as I know I have the latest version.
The item is linked here: Shard-bound Bracers - Items - World of Warcraft

Thank you,

Cheeky · 08/24/07, 9:44 AM

Originally Posted by Lactose

That won't be needed. The way I'm doing it I only need 1 non-crit to get the armor mitigation, and it'll be accurate to within 0.5% (inaccuracies due to rounding).
I just need my ISP to fix stuff, and values should be coming pretty fast.

Using a weapon with 0 damage range?

Originally Posted by Zedd

Hello Cheeky.
I have been using your spreadsheet for a long time now and I have to thank your for doing an awsome job with it.
Now I have a question, I have "Shard-Bound Bracers" but I can not find them in the spreadsheet, as far as I know I have the latest version.
The item is linked here: Shard-bound Bracers - Items - World of Warcraft

Thank you,

I'll make sure it is in. In the future if people can use the item tags for gear that's incorrect/missing ([Shard-Bound Bracers]) it helps, thanks!

Amrasellion · 08/24/07, 12:48 PM

Hey, really nice shreadsheet

Was testing some shot rotations, but then noticed that the mana costs displayed on the spreadsheet does not match the ones in game. I made sure i didnt have efficiency on and checked that i was using the right rank in the Settings tab, but they still didnt match.
Arcane Shot is displayed as 200 mana at rank 9 without efficiency, while in game its 230 mana,
Multishot is displayed as 239 mana, but is in game 273 mana,
Aimed Shot is displayed as 321 mana but should be 370 mana,
Steady Shot is displayed as 96 mana but should be 110 mana,
Scatter Shot is displayed as 169 mana, while its 6% of base mana which is 185 mana at lvl 70,
Silencing Shot is the same as Scatter Shot,
Rapid Fire is displayed as costing 0 mana, while it ingame costs 100 mana,
Beast Within is displayed as 325 mana but is according to the talent tab ingame 338 mana.

Would be rly cool if u can update this (or point out if ive made some nubmistake in settings that makes the mana costs display as less than they are :p )

edit: doh, forgot to remove Thrill of the Hunt (which was what reduced the mana cost). So seems like they are all accurate

except Beast Within and Rapid Fire.

Cheeky · 08/24/07, 12:50 PM

Originally Posted by Amrasellion

Hey, really nice shreadsheet

Was testing some shot rotations, but then noticed that the mana costs displayed on the spreadsheet does not match the ones in game. I made sure i didnt have efficiency on and checked that i was using the right rank in the Settings tab, but they still didnt match.
Arcane Shot is displayed as 200 mana at rank 9 without efficiency, while in game its 230 mana,
Multishot is displayed as 239 mana, but is in game 273 mana,
Aimed Shot is displayed as 321 mana but should be 370 mana,
Steady Shot is displayed as 96 mana but should be 110 mana,
Scatter Shot is displayed as 169 mana, while its 6% of base mana which is 185 mana at lvl 70,
Silencing Shot is the same as Scatter Shot,
Rapid Fire is displayed as costing 0 mana, while it ingame costs 100 mana,
Beast Within is displayed as 325 mana but is according to the talent tab ingame 338 mana.

Would be rly cool if u can update this (or point out if ive made some nubmistake in settings that makes the mana costs display as less than they are :p )

Did you have Thrill of the Hunt specified? I average that out (shouldn't apply to Beast Within or Rapid Shot though....)