Combat and Mutilate Spreadsheets (Obsolete as of 4.0.x) - Page 117

Rahdik · 11/16/09, 11:43 PM

100% armor penetration - 1400 armor pen rating
85% armor penetration (Mace spec) - 1190 armor pen rating

Yes, you should be socketing for 578 with Mace spec and Grim Toll

morc · 11/17/09, 6:12 AM

Darkcube, thanks very much for the added functionality.

I'm afraid I'm having the same problem as those above. I'm running MS Office Standard Edition 2003.

I've tried my character and a few others from my realm (without awkward characters in their names), even your own details refuse to load.

I think there's some setting or module missing from my machine?

Error message:
Run-time error '-2147024882 (8007000e)':
This method or property is available only in Microsoft Office 2003 Professional.

Debugger highlights:
ActiveWorkbook.XmlMaps("TalentMap").Import URL:="http://eu.wowarmory.com/character-talents.xml?r=" & Range("ServerNameImport").Text & "&n=" & Range("CharacterName").Text & "&group=1"
ActiveWorkbook.XmlMaps("CharacterMap").Import URL:="http://eu.wowarmory.com/character-sheet.xml?r=" & Range("ServerNameImport").Text & "&n=" & Range("CharacterName").Text

darkcube · 11/17/09, 9:13 AM

Originally Posted by morc

Darkcube, thanks very much for the added functionality.

I'm afraid I'm having the same problem as those above. I'm running MS Office Standard Edition 2003.

I've tried my character and a few others from my realm (without awkward characters in their names), even your own details refuse to load.

I think there's some setting or module missing from my machine?

Error message:
Run-time error '-2147024882 (8007000e)':
This method or property is available only in Microsoft Office 2003 Professional.

Debugger highlights:
ActiveWorkbook.XmlMaps("TalentMap").Import URL:="http://eu.wowarmory.com/character-talents.xml?r=" & Range("ServerNameImport").Text & "&n=" & Range("CharacterName").Text & "&group=1"
ActiveWorkbook.XmlMaps("CharacterMap").Import URL:="http://eu.wowarmory.com/character-sheet.xml?r=" & Range("ServerNameImport").Text & "&n=" & Range("CharacterName").Text

I have found out that the XMLMap object that I used to extract data from the armory is only available in Office 2003 and Office 2007. The import feature will not work on versions of office older than that. Sorry but there's just no way around that.

EDIT: I see you're running Office 2003 standard, apparently it requires professional.

Also, if anyone has any more problems with the import not working (And is using Office 03 Pro / 07), please PM me, I don't want to hijack this thread with runtime errors.

koaschten · 11/17/09, 12:38 PM

Just create a seperate thread like others have before when modifying a sheet with unsupported stuff. That's gonna be Aldriana's words anyway when he gets to read the thread as he did with combat sheet companion sheet.

• Aldriana · 11/17/09, 12:48 PM

To be clear on Aldriana's perspective here: Aldriana has put a great deal of time and effort into making a sheet that runs easily in both Excel and OpenOffice, and thus has absolutely no interest in putting time into developing or maintaining macros which break that compatibility. So while you're welcome to make and share whatever changes you see fit, they will never be incorporated into official releases, and I have a mild preference for not having the thread deluged with macro-updated versions every time I release something new. So if it's just a one-time thing - sure, fine, whatever, I don't care. But if it's going to be a regular thing that is to be maintained through multiple releases of the base sheet, it probably wants to be moved either to the Combat Sheet Companion thread, or, if enough changes are being made, it's own thread entirely.

darkcube · 11/17/09, 1:07 PM

Originally Posted by Aldriana

To be clear on Aldriana's perspective here: Aldriana has put a great deal of time and effort into making a sheet that runs easily in both Excel and OpenOffice, and thus has absolutely no interest in putting time into developing or maintaining macros which break that compatibility. So while you're welcome to make and share whatever changes you see fit, they will never be incorporated into official releases, and I have a mild preference for not having the thread deluged with macro-updated versions every time I release something new. So if it's just a one-time thing - sure, fine, whatever, I don't care. But if it's going to be a regular thing that is to be maintained through multiple releases of the base sheet, it probably wants to be moved either to the Combat Sheet Companion thread, or, if enough changes are being made, it's own thread entirely.

Aldriana, I understand and agree entirely. I've said from my first post if you find a problem please PM me and don't post it here, I do not want this thread hijacked with macro bugs. The only reason I did not post a seperate thread is because I have no intention of adding any more features, and outside of the compatibility issues (03 and 07 only i've learned) and the lack of EU support I had originally, it "Just works". When Combat 1.4 comes out I'll probably update it with the new gear ids you add but until then, I'm done.

This was something I mostly did for my own benefit of saving time and ability to research other rogues decisions but figured others might appreciate it as well.

Let me make this clear, do not post any errors you have with this sheet in this thread, if it does not work just send me a message and I'll see if I know why.

fadedtimes · 11/18/09, 11:18 AM

Originally Posted by chiahatesyou

Hey guys I'm nubbing it up over here. My rogue is pogotheclown on Archimonde and I was using the spreadsheet and it told me the evis only rotation was the best for my gear but I am losing dps like that and had to go back to high rupture. I may be missing something. If I don't have Grim Toll so how much arpen should I stack within reason. Any help on this to clear it up would be appreciated. I have read this whole thread but I suppose I fail on comprehension hehe.

Did you adjust your glyphs and talent tree on the right hand side of the spreadsheet?
Set the proper spec/glyph for an evis only. See what it recommends for gem upgrades (change if needed) and copy down the estimated dps.
Then set the proper spec/glyph for rupture. See what it recommends for gem upgrades (change if needed) and copy down the estimated dps.
Compare the 2 results and decide how you want to spec/glyph and gem.

Averiel · 11/18/09, 11:38 AM

Originally Posted by fadedtimes

did you adjust your glyphs and talent tree on the right hand side?

set the proper spec/glyph for an evis only. See what it recommends for gem upgrades (change if needed) and copy down the estimated dps

then set the proper spec/glyph for rupture. See what it recommends for gem upgrades (change if needed) and copy down the estimated dps

Compare the 2 results and decide how you want to spec/glyph and gem.

Glyph/spec is usually one of the first places of error, such as accidentally having 4 glyphs or having extra talent points when you swapped from one gear set up to another...

But on the other hand, do you have your raid buffs set up correctly? I can see that evisc only spec would be affected by the lack of armor debuffs (sunder/ff) more than a rupture cycle. Just something minor that may be missed.

Kwil · 11/18/09, 3:43 PM

My first time posting so sorry if this has been addressed. I am using the spread sheet and while everything I have read says not to break the T8 4 piece bonus, when I plug in T9.245 gloves and T9.232 legs I am showing a DPS increase.
I there something I am missing? Possibly needing to have all BiS for not breaking T8 4 piece, or this just a case of my current gear makeup?
It does show going to a low rupture instead of high rupture cycle as well.
The increase is minor at 21 DPS but it's there.
Here is my armory:
The World of Warcraft Armory

Sharrakor · 11/18/09, 7:24 PM

Originally Posted by Kwil

My first time posting so sorry if this has been addressed. I am using the spread sheet and while everything I have read says not to break the T8 4 piece bonus, when I plug in T9.245 gloves and T9.232 legs I am showing a DPS increase.
I there something I am missing? Possibly needing to have all BiS for not breaking T8 4 piece, or this just a case of my current gear makeup?
It does show going to a low rupture instead of high rupture cycle as well.
The increase is minor at 21 DPS but it's there.
Here is my armory:
The World of Warcraft Armory

Generally you can trust your spread sheet. So if it shows a dps gain by dropping the T8 4 piece bonus, you should do it. But have you tried switching specc and glyphs to run an eviscerate only cycle? In most cases, the point where you decide to breake 4pc T8 is the one where you switch to an evis only cycle as well. A quick look at your armory shows you're quite well prepared for that step. So if you have some direct upgrades like the T9 set items you mentioned, maybe for the other T8 pieces too - pull them into your spread sheet and try an evis only cycle. Change gems if it's recommended and look at your calculated dps and see if you're comfortable with it. And even if the dps gain seems marginal or your sheet shows a small dps loss, it will most likely result in a dps gain for you - what has been discussed several times here - because, especially in ToC fights, the higher burst potential and flexibility of an evis only cycle outweigh the theoretically higher dps of a rupture-based rotation.

This is my first post as well, so if I'm mistaken in any way or messed everything up - I'm sorry. Correct me and I'll try harder next time.

Kwil · 11/18/09, 8:22 PM

Originally Posted by Kumar

Are you sure about that? The sheet by default is set to have talent setup of 3/3 Imp Evis, 0/2 Blood Splatter and 2/3 Ruthlessness. Did you change it to the normal 15/51/5 setup to see if High Rupture cycle gives you better dps?

The reason I am asking is that I don't think you are at the gear level where Evis only overtakes High Rupture cycle dps, especially with 4pcT8 still present (as per your armory).

I found this to be my issue, thanks for mentioning the evis. cycle it sent me in the right direction looking for more information.
Using the two T9 pieces I mentioned gemmed optimaly, I showed a loss from 7604 to 7475 DPS. Just switched to this sheet and left the talents set on the default.:P

Amiz · 11/19/09, 4:45 AM

I would like to know at about which level of gear mongoose becomes better than berserking because using the spreadsheet I noticed that it suggests to switch to mongoose but when I do my dps istead of growing just drop of about 1-2 dps and it suggests me again to switch to berserking.

I tried working a bit with the spreadsheet but the only thing usefull I understood was that expertise becomes valuable for combat (and it suggests me to socket exp) but i don't understand the logic behind mongoose.

Ofc we are talking about a double wound poison setup.

Valustria · 11/19/09, 7:59 AM

It does the same thing for me: when I switch one weapon to Mongoose, it recommends Berserking... when I switch to Berserking, it recommends Mongoose. It did this once before with Berserking and Accuracy. I think at such breaking points it simply becomes a matter of preference. Berserking has the benefit of additional damage via poisons from Fan of Knives due to the raw AP buff, while Mongoose has no armor penalty and can help to apply more poisons single-target. Personally, I prefer Mongoose, but I've seen rogues with better gear than me going both ways with their weapon enchants.

Yotz · 11/19/09, 3:43 PM

The enchants swapping around happens because it makes the recommendation based on how much better each one would be, while you still have the other one selected. If you could select no enchant for a weapon, then it would accurately recommend the "better" enchant. Currently the best way to see which is ideally better is to select each one, and see which has a better overall dps.

The reason they swap around is as you have more AP (say from zerking) the EP of agi and haste of mongoose go up, alternatively when you have more haste/crit (from the agi of mongoose) the value of AP goes up in comparison. If you are at the point swapping the enchant changes the recommendation, the difference must be pretty small, so if you value the added survivability of mongoose its probably the way to go.

That is how I understand it anyway.

poptya · 11/20/09, 7:11 AM

Is there a way to imput the crit gained from skinning into the spreadsheet?

Also in a question on spec. All builds except mace/dagger put a point in endurance, instead of unfair advantage. While the number of things to use an aoe that can be dodged to proc unfair advantage is minute (the trash in voa comes to mind), wouldnt this actually be best for dps? At the expense of around 275 hp of course.