WotLK DPS spreadsheet - Page 143

danglebombs · 04/20/09, 11:20 AM

I feel like I am confused why as a dwarf the Siren's bow is showing as a higher dps increase for me than the Giant's Bane. With the gun specialty the difference is actually that I gain more from the Giant's Bane. Am I missing something or is this an error?

Shandara · 04/20/09, 11:29 AM

Originally Posted by danglebombs

I feel like I am confused why as a dwarf the Siren's bow is showing as a higher dps increase for me than the Giant's Bane. With the gun specialty the difference is actually that I gain more from the Giant's Bane. Am I missing something or is this an error?

Are you running the 'Ranged Weapon' macro button on the gear planner page?

blejs · 04/20/09, 12:04 PM

couldnt find
[Cindershard Ring] Cindershard Ring (got this baby yday)
[Shoulders of Misfortune] Shoulders of Misfortune
in the itemlist

How is the gear list sorted btw, is it any option to get it alphabetical?
And btw is it oki to write items thats missing here, or where should i do that? If i should do it at all.

danglebombs · 04/20/09, 12:06 PM

Originally Posted by Shandara

Are you running the 'Ranged Weapon' macro button on the gear planner page?

Yeah figures I was doing something stupid, I thought I had clicked it but it turns out I just highlighted it>_< Thanks Shandara for all your work

aejax · 04/20/09, 12:44 PM

Originally Posted by blejs

couldnt find
[Cindershard Ring] Cindershard Ring (got this baby yday)
[Shoulders of Misfortune] Shoulders of Misfortune
in the itemlist

How is the gear list sorted btw, is it any option to get it alphabetical?
And btw is it oki to write items thats missing here, or where should i do that? If i should do it at all.

Both items are there on my spreadsheet.

Thelastdeadmouse · 04/20/09, 1:28 PM

I just finished a test in game that shows untalented pet focus regen to be 5 focus per second, not the 6 used in the spreadsheet.

Crab on a target dummy, no points in Bestial Discipline or GftT. Started recording at 0 focus and only casting Claw. Casted Claw 36 times in 3 minutes = 5 times per second. 25 focus per cast / 5 seconds = 5 focus per second.

This should deal a small blow to BD and noticeably improve GftT in the spreadsheet.

Edit: Ran a second test to confirm numbers. Same parameters, 60 casts in 5 minutes for a rate of 5 focus/sec.

Shamroq · 04/20/09, 4:38 PM

/delete

*edit /love you forever for the spreadsheet :p

Iroared · 04/20/09, 4:56 PM

Why can't I add blackmithing sockets? I remember I could click "No Socket 1" and select "Prismatic Socket", but I can't do it anymore.

Shandara do you know if your spreadsheet works in OpenOffice? It's supposed to be fully compatible with MS Office, and it's free. I've read several posts in different areas about people struggling with compatibility.. was curious if anyone had ever tried that. Seems like it'd pretty much eliminate the "I don't have excel" comments.

*edit /love you forever for the spreadsheet :p

I tried, it works in general but some functionality is missing. Basically the "buttons" don't work, so you can only use the spreadsheet in the basic way, by entering gear and such. Also you can't save different profiles.

Shandara · 04/20/09, 6:34 PM

Update:

- Roar of Recovery fixed
- Adjusted overview/gear tab agility reported to exclude procs to make comparison to in-game character tab easier.
- Added a How-to guide to the sheet
- Adjusted base pet focus regen to 5 per second

Cengaveraso · 04/20/09, 6:59 PM

I think there is a problem in spreadsheet about haste. When i load my gear and set everything up, it seems +1 haste rating worth +5,087 dps. After that when i go to gear planner and set it to sort items it shows 5 man gears better than mine

. Am i missing something or there is a problem?

Rezdan · 04/20/09, 11:23 PM

Once you load your gear and set everything up, did you click the Calculate Attributes button?

Ravenhaft · 04/21/09, 2:38 AM

Just a quick thing, has 16 [Avalanche] hit not 14. Took me 5 minutes to figure what was going on with my spreadsheet when I was modelling my gear, spreadsheet said I had 99.99% and actual game gave me 100.05%. I'm still using 86g but I didn't see anything about gear being fixed.

FrostmaneMaul · 04/21/09, 3:33 AM

Anyone else getting errors when you try to load gear from armory?

On a few pieces of gear I get either "server internal error 500" or "Slot. -Item #xxxx -> enchant is empty".

Anyone know how to fix that? It's pretty annoying

Zeel · 04/21/09, 4:56 AM

Originally Posted by FrostmaneMaul

Anyone else getting errors when you try to load gear from armory?

On a few pieces of gear I get either "server internal error 500" or "Slot. -Item #xxxx -> enchant is empty".

Anyone know how to fix that? It's pretty annoying

scroll back 2 pages and you find Shandara's post at: WotLK DPS spreadsheet

Originally Posted by Shandara

Ok, small update:

This is the last 'PTR' version before I release v87. I've tested the Armory import (gear and talents) on about 10 US posters from these boards and it seemed to work alright. Sometimes you will get a message box 'Slot: xxx Item #xxxxx - Enchant is empty" or similar. This means the Armory didn't work correctly and failed to fill out the XML properly. Try again.

It doesn't work for EU yet since that Armory seems to be not providing any useful XML at all (sometimes empty, sometimes half-filled) and times out a lot. I expect once they finish adjusting it it'll start working properly.

hope that helps

brokenarrow · 04/21/09, 4:59 AM

Hey is there a way to change the default gems? Everytime I try it tells me I need to turn off the sheet protection, but then it prompts me for a password. It a pain when every time I changed an item the gems become AP gems instead of AGI.

Thx.