WotLK DPS spreadsheet - Page 141

Mr Tazza · 04/18/09, 11:59 AM

Possible bugs I found:

- Aimed Shot is somehow counted as 0% frequency and thus a net dps loss
- Furious Gladiator's Pendant of Triumph shows as 94 agility, making it the best dps neck, while it's 94 stamina

Ferrari_13 · 04/18/09, 12:02 PM

Originally Posted by FroggyWuLong

did that. still won't let me change name or server, all the other options are good to go.

Either

A) You have a trial/expired excel version which wont allow you fully interact.

or

B) You are not entering your name/server in the right place. Make sure you are changing the name in the formula cell only.

I don't have enough info to tell what you are doing wrong, but I am sure there is an FAQ on how to run the spread sheet in this thread already.

Nooska · 04/18/09, 1:16 PM

"Check the power is on" type question:

Where are you trying to change your server / character name? (Its on Overview, in the top left)

FroggyWuLong · 04/18/09, 1:25 PM

That is where I am at. still no luck. sadface. trying it on the roommates computer to see if its my excel.

baklava · 04/18/09, 1:31 PM

Bug Report: "Death-warmed Belt" seems have 2 slots Blue + Red but in the spreadsheet.

Tiggs · 04/18/09, 3:01 PM

"Loop of the Agile Mind" is the incorrectly named version of "Loop of the Agile"

Ferlog · 04/18/09, 4:50 PM

Hello All,

does the current spreadsheet take into account that Explosive shot crits do not reward focus to pets any longer? Anyone else reported this as a bug and seen what Blizzard has said? I haven't gotten a clear answer, but I think it's something that should be addressed (I noticed this while testing my wolf, let him charge in and move at the target casting ES, and noticing it crits several times and my pets focus remains extremely low).

Thanks.

Shandara · 04/18/09, 4:58 PM

Originally Posted by Ferlog

Hello All,

does the current spreadsheet take into account that Explosive shot crits do not reward focus to pets any longer? Anyone else reported this as a bug and seen what Blizzard has said? I haven't gotten a clear answer, but I think it's something that should be addressed (I noticed this while testing my wolf, let him charge in and move at the target casting ES, and noticing it crits several times and my pets focus remains extremely low).

Thanks.

Explosive Shot's 3 ticks are treated as 1 shot for the purposes of focus and procs (which isn't quite accurate for all cases but was the easiest way to do it).

For those for whom Aimed Shot isn't having a frequency, check the settings page, "Use Rotation Test results" setting is set to yes, so you have to turn it off or run the Rotation Test if you change the shot priority.

EDIT:
Uploaded V86f again fixing the few misnamed items, missing socket and the furious gladiator's necklace.

Ferlog · 04/18/09, 5:01 PM

none of the 3 shots causes focus to be generated, even if any/all of them crit (looking at the combat log while only afflicting ES damage to the target).

Neruse · 04/19/09, 1:56 AM

There are numerous bugs associated with ExS right now. Whether Shandara wants to alter the spreadsheet to account for them is up to him, but I'll list what is known if so.

1) Doesn't proc GFTT at all.
2) Only grants mana from the first tick under AotV (reduces mana gain to 1/3rd of 3.09's value for ExS).
3) Doesn't return mana from TotH crits.
4) Doesn't proc any stacks from FotFF (neither on first tick nor on following).

Onouris · 04/19/09, 4:28 AM

Originally Posted by Neruse

There are numerous bugs associated with ExS right now. Whether Shandara wants to alter the spreadsheet to account for them is up to him, but I'll list what is known if so.

1) Doesn't proc GFTT at all.
2) Only grants mana from the first tick under AotV (reduces mana gain to 1/3rd of 3.09's value for ExS).
3) Doesn't return mana from TotH crits.
4) Doesn't proc any stacks from FotFF (neither on first tick nor on following).

Hmm, my gut feeling that this patch was rushed seems to be right.

--

Regarding EU armory import it worked the other day when I was using it, but it got the error with enchants that you mentioned - though it said there was an error with every single enchant, it got all but boots right.

Also, importing a file from G to F caused a type mismatch but again hitting it 3 times seemed to work.

RoBoBOBR · 04/19/09, 6:14 AM

Can you include Swordguard Embroidery (Swordguard Embroidery - Thottbot: World of Warcraft) as supported back enchant? It's now working correctly for hunters.

Cactus-King · 04/19/09, 12:05 PM

Apologies if this has been discussed previously--

Is OS X supported for this spreadsheet? I'm using Excel 2004 on a Mac and none of the buttons are functional (I can see them, but they're unclickable).

The "error" begins right when I load the spreadsheet. As the sheet is loading, I get a series of Graphics Filter dialogue boxes that say "Converting: Metafile".

Searching this message on Google revealed a suggestion that sounds like the problem I'm having. According to that response, controls developed in Active X will not function on OS X, and as a result, the buttons are converted to non-functional graphics files. (See that posting at Graphics Filter Converting Metafile)

Also, to clarify, I do have macros enabled in the spreadsheet.

Is this a known issue with the spreadsheet for Mac users? Is there anything I can do to make this functional on my operating system? Or are there any plans to make this function cross-platform in the future?

If indeed the button controls are programmed using Active X, is it possible to change them to Form controls? If the gentleman in the post above is correct, these should function on both operating systems.

Regardless of the outcome, many thanks to Shandara and the rest of the community for your work on this great tool!

Shandara · 04/19/09, 12:13 PM

The sheet is not developed with Open Office nor with Excel on Mac in mind (I do not have or use either myself) so I make no guarantees about people trying the sheet on those platforms. If they work, good for you, but if not.. there isn't much I can do.

Unlike Cheeky, I've been using VBA quite intensively for all sorts of automation jobs. Pretty much all of these are purely auxiliary and shouldn't affect people using the sheet without macros. I do not use ActiveX (at least not intentionally, I'm not sure what parts of the built-in Excel functionality are ActiveX based) for anything.

Destinova · 04/19/09, 12:43 PM

Originally Posted by Cactus-King

Apologies if this has been discussed previously--
Is this a known issue with the spreadsheet for Mac users? Is there anything I can do to make this functional on my operating system? Or are there any plans to make this function cross-platform in the future?
tool!

Install Fusion or Bootcamp and install Windows XP on your Mac.