WotLK DPS spreadsheet - Page 190

Cranch · 06/12/09, 6:17 PM

The following rotation, for a survival talent build, results in a Runtime Error 13, type mismatch

Kill Shot	1	9.00	269	#DIV/0!	1.65	0.00%	51.53	#DIV/0!	5.22
Explosive Shot	2	6.00	269	#DIV/0!	1.65	26.53%	6.22	#DIV/0!	43.28
Black Arrow	3	24.00	121	#DIV/0!	1.65	6.40%	25.76	#DIV/0!	4.70
Aimed Shot	4	10.00	308	#DIV/0!	1.65	15.55%	10.61	#DIV/0!	29.00
Serpent Sting	5	21.00	454	5897	1.65	0.00%	0.00	0.00	0.00

Taking out the serpent sting "fixes" the error. Using the SS order for surv rotation ES/BA/Sp/KS/AiS/SS does not show this error. This occurs in SS 89f.

I take that back; sometimes the SS order shows the error and sometimes it does not. There are apparently two separate computation paths going on: one that updates the dps (somewhat inaccurately) when you change/update shots, and the correct one that occurs when you press "Test Rotation."

Raudo · 06/12/09, 9:29 PM

I get this error when I try to CalcAttributes in the Overview window or hit Test Rotation in the Shot Rotation window.

Run-time error '1004':

Application-defined or object-defined error

How can I fix it please? I basically can't use the spreadsheet

Cranch · 06/12/09, 10:02 PM

One other thing that does seem peculiar. Pet DPS drops when I go from my present gear to BiS gear. I didn't expect negative pet scaling from improved gear.

Profiles			     Hunter DPS	Hunter	Pet	AP	Crit	Hit	ArP	Shot Queue	Spec

Cranch MM 10 man			5321.41	4547.16	774.25	7170	46%	100%	103	Sp/CS/SilS/KS/AiS/AS/SS	7/57/7
Cranch SV 10 man			5192.90	4350.85	842.05	8160	52%	100%	103	KS/ES/BA/Sp/AiS/SS	0/16/55
Cranch MM 25 man			7303.88	6229.43	1074.46	8052	49%	100%	103	Sp/CS/SilS/KS/AiS/AS/SS	7/57/7
Cranch SV 25 man			6893.84	5723.73	1170.10	9297	55%	100%	103	KS/ES/BA/Sp/AiS/SS	0/16/55
Cranch MM BiS non Alg 10 man		6041.96	5308.18	733.78	6896	49%	100%	671	Sp/CS/SilS/KS/AiS/SS	7/57/7
Cranch SV BiS non Alg 10 man		5707.09	4895.47	811.62	8391	56%	100%	425	KS/ES/BA/Sp/AiS/SS	0/16/55
Cranch MM BiS non Alg 25 man		8144.95	7128.11	1016.84	7744	52%	100%	671	Sp/CS/SilS/KS/AiS/SS	7/57/7
Cranch SV BiS non Alg 25 man		7540.89	6412.19	1128.70	9549	59%	100%	425	KS/ES/BA/Sp/AiS/SS	0/16/55

Cattiebrie · 06/13/09, 1:11 AM

Simple enough reason: your AP is lower. DPS-wise, our pets only scale from our AP (and indirectly, crit).

Edit: Though that only explains your MM specs, not the Surv ones.

Skybluesky · 06/13/09, 1:20 AM

Originally Posted by Cranch

Pet DPS drops when I go from my present gear to BiS gear.
[/code]

Your present gear includes the 2 piece Tier 7 bonus.

Cranch · 06/13/09, 1:54 AM

Indeed, the discrepancy is explained.

Shandara · 06/13/09, 3:21 AM

Originally Posted by Cranch

The following rotation, for a survival talent build, results in a Runtime Error 13, type mismatch

Kill Shot	1	9.00	269	#DIV/0!	1.65	0.00%	51.53	#DIV/0!	5.22
Explosive Shot	2	6.00	269	#DIV/0!	1.65	26.53%	6.22	#DIV/0!	43.28
Black Arrow	3	24.00	121	#DIV/0!	1.65	6.40%	25.76	#DIV/0!	4.70
Aimed Shot	4	10.00	308	#DIV/0!	1.65	15.55%	10.61	#DIV/0!	29.00
Serpent Sting	5	21.00	454	5897	1.65	0.00%	0.00	0.00	0.00

Taking out the serpent sting "fixes" the error. Using the SS order for surv rotation ES/BA/Sp/KS/AiS/SS does not show this error. This occurs in SS 89f.

I take that back; sometimes the SS order shows the error and sometimes it does not. There are apparently two separate computation paths going on: one that updates the dps (somewhat inaccurately) when you change/update shots, and the correct one that occurs when you press "Test Rotation."

Finally managed to trace this one down, I think. It's to do with adding Serpent Sting to your rotation but while it's not been used in the rotation test yet. Its frequency is 0 and the Noxious Stings caclulations divide by 0 then.

Thelastdeadmouse · 06/13/09, 10:08 PM

I just downloaded the newest version of the spreadsheet and much to my dismay Resilience seems to have been removed as a stat for custom targets. I had hoped to be able to use the spreadsheet to fine tune my spec as far as Frenzy, Cobra Strikes and FI on reduced crit targets in PvP. If there any reason this feature was removed?

Shandara · 06/14/09, 1:27 AM

Originally Posted by Thelastdeadmouse

I just downloaded the newest version of the spreadsheet and much to my dismay Resilience seems to have been removed as a stat for custom targets. I had hoped to be able to use the spreadsheet to fine tune my spec as far as Frenzy, Cobra Strikes and FI on reduced crit targets in PvP. If there any reason this feature was removed?

The resilience code hadn't been touched since Cheeky maintained it and was still only a pure crit reduction. It didn't affect DoTs or pets. Since I was cleaning up the sheet and there are no PvE Bosses with resilience (and the sheet is for PvE really) I'd removed it.

alienangel · 06/14/09, 9:54 AM

Shandara, is there a way to apply %haste buffs to pets?

We did Thorim hard-mode with 2 MCs, so had double aura of celerity for constant 40% haste - can't say I checked but our casters assure me it very noticeably stacks both buffs. Since we were at one point considering 3 MCs for 60% haste, I was thinking that it might actually be better to try BM instead of MM/SV because constant 60% haste on a BM pet would be pretty amazing.

However I can't find a way to specify % haste buffs, and converting 60% haste to haste rating and putting it on the pet-buffs hand adjust doesn't have any effect, presumably because pets don't benefit from rating buffs, just absolute buffs (I remember haste drums didn't do anything for them at 70).

edit: also, minor bug with 89f - The Gear tab's Resilience value seems to be pulling buff info from the MP5 column - it claims I have 109.2 resilience, due to the value in Buffs!M36

kthreev · 06/14/09, 3:50 PM

I was messing around with the spreadsheet creating different profiles for different gearsets, and after using calc attributes, it caused abnormally high numbers to appear under delta on the gear planner page.

http://img522.imageshack.us/img522/1407/delta.jpg

Anyone know the cause for this?

Shandara · 06/14/09, 4:42 PM

Originally Posted by kthreev

I was messing around with the spreadsheet creating different profiles for different gearsets, and after using calc attributes, it caused abnormally high numbers to appear under delta on the gear planner page.

http://img522.imageshack.us/img522/1407/delta.jpg

Anyone know the cause for this?

I've not yet been able to pinpoint the cause of this behavior. Could you possibly upload your sheet somewhere if you are able to reproduce it consistently?

kthreev · 06/14/09, 5:11 PM

http://www.filedropper.com/hunterdps

It appears the same way on every profile, even the sample profiles I haven't tampered with.

Shandara · 06/14/09, 5:46 PM

Originally Posted by kthreev

http://www.filedropper.com/hunterdps

It appears the same way on every profile, even the sample profiles I haven't tampered with.

Thanks. Strangely enough when I hit Calculate Attributes it updates correctly (I'm assuming it doesn't for you even if you use that button multiple times). Possibly a localisation issue (US vs EU version of some Excel functions differ subtly), but it seems to occur very rarely.

I'm a bit stumped on this one, since I have so far been unable to reproduce it (and with yours that's the 3rd report of the issue I've had).

Sukandi · 06/14/09, 6:53 PM

When importing my gear, I get 'Icy Scale Boots' is not a known item for slot 'Feet', do you wish to try and load it from the Armory?

Yes, and it loads Conqueror's Scourgestalker Legguards into the slot. No, and it doesn't load anything.

I have [Boots of Living Scale] on, as you can see from my armory.

I get the calcattributes thing too, when switching from your default profile after putting my data in, but if you just hit the button again afterwards, it goes back to what it is supposed to be.