Barradin

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

Absolutely agree...

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

 

Cuttooth

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

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.

 

Lakron

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

 

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?

 

Gearknight

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

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

<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

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

 

Wraith40k

Until he releases v50, you can just use the custom gear tab...

 

Tyvena

Is there any scores for a "post wotlk"-spreadsheet? Since it took about 2 or 3 months after patch 2.0 to actually release BC, it would be great to have an idea of the best possible gear after 3.0 has been relased.
Would it maybe even possible to implementate a "no clipping"-rotation into the spreadsheet (with selectable Arcane and / or Multi-Shot)? I know that this wouldn't be a real value (because Blizzard annouced a nerf to Steady Shot), but it would give a rough idea of how haste makes up with other stats like armor penetration or agility...

 

Aborigene

Hi Guys,

I am new here so perhaps someone has already found the answer for this...
I am using Mac Leopard and OpenOffice to open up the spreadsheet...

But it seems not to be working... After pressing "Load gear from armory" for example, it shows an error message (sorry, i am at work now so don't remember quite clear the error message) and opens up a "debug" window showing where the error is...

have anyone tested in this environment (Mac-oppenoffice)?

BTW, thanks Cheeky for this wonderful informational site!

cheers.

 

gbills

Yeah, I run the same setup. I get the error too. I have to set up the spreadsheet on my PC at work and then email it to my Mac at home. There are some Windows/Microsoft specific calls in the macros that don't jive with pure OO (i.e. platform independence).

 

Aborigene

Hi,

Well, I am actually using the proper oppenoffice version(I believe is .ods extension)... But I guess it is not compatible to mac... :/ (I am not that keen to install micro$oft in my mac *grin*)

Any other idea?

 

gbills

Yes, the current OpenOffice version won't work properly with a Mac. It is mainly because of the type of object that is created. For example:

Set oMSXML = CreateObject("MSXML2.DOMDocument")

This is from the GetDataXLS() function. The MSXML2 library is being used to create an XML object of that type. Unfortunately, this library doesn't exist on a Mac. There's got to be an OpenOffice compatible XML library that it can be replaced with (especially since the OpenOffice document format is based off of XML!). I'm just not sure what it is. I'll do some digging and to see if I can find it.

 

lairpie

I put all the new pvp gear into the custom page of the v49 spread sheet to evaluate them for pve, as several of the s4 items are better for pve than anything to which most people have access. Then I can just select custom item from the drop down to use pvp gear as if it was already added. If anyone wants a copy of that instead of doing it themselves, PM me an email address and I'll either email it or if a bunch want it I'll host it somewhere.

Brewmaster of WBC (5,9,1/6)

 

Cole

Hi,

On the gear sheet add the following procedure :

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate "http://www.wowhead.com/?search=" + Target
Cancel = True
End Sub

Now if you double click on any item on the gear sheet, it will open that item in the internet explorer.

Happy Hunting

Cole the Hunter

 

Final_Rest

I feel like an idiot for asking this, since i am sure the solution will be incredibly obvious, but....

I cannot seem to get the Shot Rotation buttons on the Shot Rotation tab to work, as well as the "Export To File"/"Import From File" buttons on the settings and results tab to work.

I am assuming it's something that needs to be unlocked on the spreadsheet that i have completely overlooked, but some help would be great.

 

Pondskipper

Your Macro security is set high, set it to lower, should work fine.

 

Kris

The last update was 2 months ago. Has Cheeky abandoned developing the spreadsheet? I read he had some stuff fixed but that was more than a month ago and I haven't read anything else on the subject since.

 

Broll

I'm trying to print the shot rotation that the spreadsheet came up with... i have it open in excel and when i try to print it only prints like a couple blocks on each page any ideas?

 

germanboy3383

I was lead to believe in this thread that Adamantite Weightstone would work on our melee weapons and it would increase our dps by buffing our RAP and Crit however when i tried to put that on my Dagger of Bad Mojo it would not work. did blizzard fix this 'bug'? was forced to put the righteous and mana oil on my 2 daggers

 

wvbean

Weightstone only work on blunt weapons, which include Fist Weapons. You'll probably need Vanir's Fists to make it viable.

 

Reinforce

My knowledge about Excel isn't any good, so I need some help. Whenever I'm done putting in the gear and wants to save the profile, the next time I open Excel again I find it unsaved, even if I load the profile, it's still the same as if I never saved anything.