Hunter Spreadsheets -- In development - Page 101

Agreus · 02/15/08, 2:49 PM

Forgive me if this is a silly question, but I just downloaded the spreadsheet and none of the buttons seem to be working for me. I click on them and they don't change/update anything. I'm running Vista and Excel 2007, would that cause a problem with the spreadsheets? Any information would be appreciated, thanks!

Uncas · 02/15/08, 2:52 PM

Originally Posted by Cheeky

I don't model a 3:2 macro, I model a 3:2 rotation. I'm pretty sure that under Quick Shots your macro actually produces a 1:1 rotation. Plug that in and see if it matches up better.

AH, so when I see live DPS test result when using the "3:2" I should actually compare it to the spreadsheets result for a 1:1 steady rotation? Ah, I can see where you are coming for with this.

hmmm

so, to model the priority (arcane), I should use a

/cast !auto Shot
/castrandom Arcane Shot, Steady shot
(with out all the other crap)

Beovylf · 02/15/08, 2:59 PM

Originally Posted by Agreus

Forgive me if this is a silly question, but I just downloaded the spreadsheet and none of the buttons seem to be working for me. I click on them and they don't change/update anything. I'm running Vista and Excel 2007, would that cause a problem with the spreadsheets? Any information would be appreciated, thanks!

Be sure to enable macros.

Agreus · 02/15/08, 3:01 PM

Thanks, that was the problem, figured it out after finally getting through all the posts in this thread.

Pointyteeth · 02/15/08, 3:31 PM

v43: Is Shot Rotation 1.1x and Macro? Spam a valid combination?

I'm seeing huge dps number differences between castsequence and spam. Or is Spam only applicable to 3:2 ?

donsantos · 02/15/08, 3:44 PM

New Howitzer macro and 2.9 speed is new king - TKA Something

I started a thread about this on tkasomething

It does give me huge dps gains from my personal testing

Pointyteeth · 02/15/08, 4:08 PM

From your thread donsantos:

/castsequence !Auto Shot, Steady Shot
/castrandom Arcane Shot

Is that the equivalent of the spam macro to generate:

Auto Shot
Steady Shot
Arcane Shot
Auto Shot
Steady Shot
Auto Shot
Steady Shot
Arcane Shot
Auto Shot
Steady Shot
...etc

or would it be?

/cast !Auto Shot
/cast Steady Shot
/cast Arcane Shot

This would be using 2.9 speed and 5/5 IAS.

donsantos · 02/15/08, 4:33 PM

hmm

I think it does something like this

arcane
auto
steady
auto
steady
arcane
auto
steady
auto
steady
etc...

Also for some reason three different /cast dont' work for me

Zaxol · 02/15/08, 6:38 PM

Is there a reason that it says my crit chance is 26.44% when ingame it says that my crit chance is 27.03%? I have double checked everything my gear, gems, enchants, spec ect. is all correct.

Lactose · 02/15/08, 7:30 PM

The spreadsheet assumes a -0.6% crit modifier against Level 73 targets.

Kharthus · 02/15/08, 8:16 PM

Originally Posted by binky

I am on a Mac....I have never been able to get the "buttons" to work. I entered the rotations manually. I am looking at 2 different spreadsheets (one for 5/5 IAS and the other 2/5). The rotations are identical. The mana used is identical. The number of shots is identical. It is only the duration that is different. I think that means I regenerate the entire rotation. Is that what you mean?

I've also seen a lot of issues using Mac versions of Office. Some buttons don't work, some pulldowns don't activate correctly.

tarsen · 02/16/08, 7:31 AM

A further suggestion to improve the tool: looking for the item you want to put is fairly painful, as the lists are very long. Could the ilvl be added before the item name? In this way I'd know the items I want to check are in the bottom end of the list, while people in greens could still check what is their next upgrade easily.

Skalis · 02/16/08, 11:01 AM

Hi there,

I'm a bit puzzled with the stat / dps-increase table at the results tab. For instance, with my setup it says 1agi ~ 0.431dps while 1ap ~ 0.224dps. This means AP>agi for me according to this table (which, IMO, seems to be incorrect). Adding 10agi manually in the gear tab however gives more DPS than adding 20AP manually, which is what I expected. What am I missing here?

thx

krsve · 02/16/08, 11:19 AM

Yo.

I kinda suck when it comes to check dps from gear and so on but I still wanna do all that it takes to be in top of dmg all the time so I would like to ask someone to please help me.

here is my profile: The World of Warcraft Armory

Maybe shows my PVP gear but here is my stats:

[Forest Prowler's Helm] +34 Attack Power / +16 Hit Rating(Head Enchant), +12 Agility / 3% Increases Critical Damage(Meta) & +10 Agility (Red Epic Gem)
[Choker of Vile Intent]
[Shoulders of the Hidden Predator] +30 Attack Power / +10 Critical Strike Rating (Aldor Shoulder Enchant)
[Vengeance Wrap] +4 Hit Rating / +4 Agility
[Mail of Fevered Pursuit] +6 All Stats (Enchant)
[Bracers of the Pathfinder] +24 Attack Power (Enchant) & +4 Agility / +6 Stamina
[Gronnstalker's Gloves] +15 Agility (Enchant) & +10 Agility (Red Epic Gem)
[Boneweave Girdle]
[Bow-stitched Leggings] +50 Attack Power / +12 Critical Strike Rating (Epic LegEnchant), +10 Agility / +10 Critical Strike Rating / +10 Attack Power & +2mp5 (Red, Yellow & Purple Epic Gem)
[Quickstrider Moccasins] +12 Agility (Enchant), +5 Agility / +4 Hit rating & +10 Critical Strike Rating
[Ring of Lethality]
[Band of Eternity]
[Ashtongue Talisman of Swiftness]
[Darkmoon Card: Crusade]
[Halberd of Desolation] +35 Agility (Enchant)
[Vengeful Gladiator's Rifle] +28 Critical Strike Rating (Scope)

HP/MP: 8765/6703
Ranged Attack Power: 1950 (Without Hawk)
Hit Rating: 125
Crit Change: 33.40%

Any speciell pet I should use? atm I have Wind Serpent

Any Speciell macro I should use? atm I use:

#showtooltip Steady Shot
/cast !Auto shot
/castrandom [exists,target=pettarget] Kill Command
/cast Steady Shot
/castrandom [exists,target=pettarget] Lightning Breath
/script UIErrorsFrame:Clear()

so anything I should change or something?

/Krsve

Saryanne · 02/16/08, 12:16 PM

Originally Posted by Cranch

You can already do this via www.lootrank.com/wow; just plug in the attribute values you get from the spreadsheet.

The correct DPS upgrade algorithm is tricky because there are 2 variables: the dps upgrade including +hit and the dps upgrade not including +hit.

For example, I can get a higher dps by apparently lowering my dps swapping an item with +hit for one without +hit, and then swapping a second item without +hit with an item with +hit. Searching for such upgrade paths is really too much to ask of the spreadsheet, IMO. There are more important things for Cheeky to spend his time on!

I messed around with that loot rank site a lot and could never get it to work right. What exact values ere you putting in? It never seemed very accurate when I did it.

I know Cheeky is busy working on lots of stuff. I was serious when I asked if he had a paypal account so those who "wanted" could give him a donation for his time.