Hunter Spreadsheets -- In development - Page 149

Rhust · 06/23/08, 9:14 AM

Originally Posted by Kaji-Boulderfist

Time till exhaustion and Total Damage done aren't connected. Total Damage done is just calculating the damage done by those 50 shots in shot rotation table. If you want to do a quick comparison, You could calculate DPS x time till exhaustion and compare that number to the difference between PET DPS with imp mark x Length of fight and Pet DPS without imp mark. I don't think it's a fair comparison though. In a raid there's going to be multiple hunter pets, multiple tanks and multiple melee DPS taking advantage of that Imp Mark. With just a few people smacking the mob, Imp Mark is going to surpass the effectiveness of Efficiency.

I'm certainly not arguing that... esp for 25 mans. however my situation is this, I'm in a small guild where we are only doing 10 mans for now. and in those 10 mans we haven't had a rogue or a dps warrior in months... at most 1 other hunter, and a lot of casters. Much of our DPS is still in blues and greens, making the fights take much longer than they should. I'm the only DPS that puts out 1000dps+ on every boss. so when I go OOM the whole raid suffers. which is why I wanted to do the comparison. if we start running with rogues and melee dps, I'll keep mark, hands down. I just wanted to do the comparison.

oshawa03 · 06/23/08, 9:29 AM

Cheeky!

I'm a big fan of the changes in the last few versions, especially the gear planner. I was wondering though if you had any plans to add a 'mail only' and 'leather only' filter. I know with my guild, leather really wouldn't be an option for me, losing the +int would be bad with how our raid setup usually works.

Cheers, and keep on rocking the Khadgar progression!

Dondee

justbekuz · 06/23/08, 10:07 AM

Originally Posted by oshawa03

Cheeky!

I'm a big fan of the changes in the last few versions, especially the gear planner. I was wondering though if you had any plans to add a 'mail only' and 'leather only' filter. I know with my guild, leather really wouldn't be an option for me, losing the +int would be bad with how our raid setup usually works.

Cheers, and keep on rocking the Khadgar progression!

Dondee

I second this. I would love to see a filter for mail and leather, as of right now leather goes to our rogues first.

Praxx · 06/23/08, 5:49 PM

Have I missed a change in the current version? I just downloaded it and now [Bloodmoon] is now better than [The Blade of Harbingers]. The previous version had the DPS values for the two items on the gear planning tab were as follows:

The Blade of Harbingers: 107.85
Bloodmoon: 67.45

Now they are coming up as:

The Blade of Harbingers: 47.38
Bloodmoon: 48.68

note: Hit rating selection in the gear planning tab does not effect this as neither weapon has +hit.

wvbean · 06/23/08, 6:56 PM

Just redownloaded and it comes up:

The Blade of Harbringers: 100.6 DPS

Bloodmoon: 60.4 DPS

For me at least

Barradin · 06/24/08, 12:08 AM

The spreadsheet seems to be giving me an innacurate shot cycle length. My paper doll speed shows 1.96 on my character sheet and yet with everything plugged into the spreadsheet and a 1:1 steady rotation selected, it gives me a time between auto shots of 1.83 seconds, not 1.96. This isn't the quick shots tab either and I turned off hawk on the normal rotation just to be sure (nothing changed, as expected).

I didn't see an option to deselect 'averaging out Rapid fire' or something like that... also, my haste total on the gear tab is the same as on my character sheet.

Not sure what to make of this... the same problem happens if I use a 3:2 rotation as well... the time between the unclipped autos is also 1.83 exactly.

any help or explanation is appreciated.

Thanks

Rhust · 06/24/08, 9:08 AM

Originally Posted by justbekuz

I second this. I would love to see a filter for mail and leather, as of right now leather goes to our rogues first.

Absolutely agree...

the spreadsheet is amazing, but would love to opt out of leather.

Cuttooth · 06/26/08, 4:19 PM

Any plans to add Kil'jaeden loot?

[Coif of Alleria]
[Thalassian Ranger Gauntlets]
[Crux of the Apocalypse]
[Hand of the Deceiver]
[Cloak of Unforgivable Sin]

Also, will the [Thori'dal, the Stars' Fury] speed be updated to 2.70?

Amelas · 06/26/08, 6:15 PM

Originally Posted by Praxx

Have I missed a change in the current version? I just downloaded it and now [Bloodmoon] is now better than [The Blade of Harbingers].

My best guess is that you are at or near the "haste cap" that the spreadsheet calculates. Therefore, the spreadsheet ignores all the +haste on the Blade and only calculates the DPS increase from it's other stats.

Redid +1 stat calculations. This should operate much smoother. It will also generate a "haste cap" where haste is no longer beenficial, and a lookup table of haste -> DPS. This is used to more accurately judge the future value of haste.

Lakron · 06/27/08, 10:28 AM

Yea, I was also curious if we would be seeing a new update on the sheet anytime soon?

bdm · 06/29/08, 10:12 PM

I've read a lot on the forums, but cannot seem to find my answer!

How do I make the sheet show the same DPS as my character sheet?

Gearknight · 06/30/08, 9:53 AM

Originally Posted by bdm

I've read a lot on the forums, but cannot seem to find my answer!

How do I make the sheet show the same DPS as my character sheet?

If I'm understanding what you're asking, you can't. Cheeky's spreadsheet and the character sheet DPS show entirely different things.

The tooltip dps on your character sheet shows how much DPS you'd do if you fired only autoshots at a target with 0 armor and never missed or critted.

Cheeky's spreadsheet approximates how much dps a real hunter does against a real target with a real shot rotation.

Cole · 06/30/08, 2:34 PM

Hi,

Good work on the spread sheet. I got 2 suggestions too improve the speed
1) turning off autocalculations during any calculation
2) implement a "cache" from the internet that the last download is saved into memory.

Ad 1)
Excel can be improved by turning of the calculations when importing and turn it back on after you are done.

In my case my import from the EU armory went down from 60 seconds to 6 seconds.

For example change

Private Sub CommandButton1_Click()
Dim character As String, realm As String

character = range("CharacterName").value
realm = range("RealmName").value

Call ScrapeItems(character, realm)
End Sub

To

Private Sub CommandButton1_Click()
Dim character As String, realm As String

character = range("CharacterName").value
realm = range("RealmName").value

Application.Calculation = xlCalculationManual
Call ScrapeItems(character, realm)
Application.Calculation = xlCalculationAutomatic
End Sub

Ad 2)
A line like

Set Node = getsingledata(url, "//talentTab/talentTree")

Should be written as

Static Cacherealm As String
Static Cachecharacter As String
Static CacheNode As Object

If Cacherealm = realm And Cachecharacter = character Then
Set Node = CacheNode
Else
Cacherealm = realm
Cachecharacter = character
Set Node = getsingledata(url, "//talentTab/talentTree")
Set CacheNode = Node
End If

Good luck and Keep up the work

Indora · 07/01/08, 5:02 AM

<3 Cole !

That's a great idea, I just added the 2 lines to the 3:2 Button and it went down from 7 to a half second!

This will save a lot of time while playing around with the spreadsheet.
But sadly it can't be added to the CalcAttributes button.

p.s.:
What about only Calculating every 10th point of haste with the CalcAttribute-button @Cheeky?

Kwickz · 07/01/08, 3:27 PM

hello there cheeky, i have just recently downloaded your spreadsheets and they seem very helpful.

Are you gonna be updating them for Season 4 as the brutal glad stuff seems quiet nice

thanks alot