v0.4.7 still has default boss armor as 13083 new patch 3.1 boss armor is 10645.
Author of ShockAndAweEnhancement Shaman max dps addon
Please use the EnhSim by Ziff & others to simulate what gear, priorities etc are the best dps. You can use ShockAndAwe to export your paperdoll stats to EnhSim.
I'm glad that we at least have an accurate formula by which to base our decisions, although it strikes me as odd that the numbers GC gathered together come up incorrect against our own testing and formula.
No what happened was that our own testing, theorycrafting and knowledge of the prior formula allowed us to datamine a formula that fit most of the data. The formula fit the data exactly for reasonable values of armor pen, and typical armor reducing debuffs. However, it was already known that extreme cases of armor reduction were not properly modeled by that formula.
The new formula suggested by GC (to be sure he did not give an exact formula, just a hint at how to build it), provides same results as the old one within rounding for typical armor reductionde buffs. Main thing the old formula was missing was cap on armor reduction, hence poor modelling of extreme cases.
Inquiry for the math savvy: How close to the old 3.1 weighting of ArP is the new one? Before spreadsheets were saying as combat I should gem for ArP as it would be a SIGNIFICANT damage increase? Is this still true? Is it possibly only true on only low or only high armored bosses?
Inquiry for the math savvy: How close to the old 3.1 weighting of ArP is the new one? Before spreadsheets were saying as combat I should gem for ArP as it would be a SIGNIFICANT damage increase? Is this still true? Is it possibly only true on only low or only high armored bosses?
As stated here, the calculation for armor pen is pretty solid already (except in the cases of extreme armor pen). I'm puzzled that you would have a significant damage increase while gemming for ArPen, as when I switched all my gems around in Aldriana's recent spreadsheet I experienced a small dps loss.
This not being the thread for said spreadsheet, I'll assume you were inputting your gear into one of the edited versions of Vulajin's .47 sheet, and thus were most likely experiencing a mistake in modeling.
"Every time I think I have met the craziest girl in the world and I am dumb for even considering her, there's always IMANG to remind me that people get knives pulled on them." -matte
As stated here, the calculation for armor pen is pretty solid already (except in the cases of extreme armor pen). I'm puzzled that you would have a significant damage increase while gemming for ArPen, as when I switched all my gems around in Aldriana's recent spreadsheet I experienced a small dps loss.
This not being the thread for said spreadsheet, I'll assume you were inputting your gear into one of the edited versions of Vulajin's .47 sheet, and thus were most likely experiencing a mistake in modeling.
Not sure what the other poster did, but I did see a modest dps increase using ArmP gems instead of AP, for my 3 slots of JC level gems. ie.. 27armP vs. 54AP
And I did use Vulj's new modified sheet, as combat.
As posted above. The weight of your ArP is generally going to increase based on how much you have. Given that I already have ArP in several pieces of gear innately, further ArP is going to be worth slightly more than just gemming it with no previous pen.
I'm also combat which could make a difference if you are mutilate.
As posted above. The weight of your ArP is generally going to increase based on how much you have. Given that I already have ArP in several pieces of gear innately, further ArP is going to be worth slightly more than just gemming it with no previous pen.
I'm also combat which could make a difference if you are mutilate.
Edit: Though I see you are combat.
If you are using Grim Toll that can affect it too, since that proc only gets better the more static ArPen you add.
Aldriana has already posted new sheets for combat and mutilate. It may not be as intuitive or easy to read as Vulajin's, but it still has all of glyphs and most of the gear.
Aldriana has already posted new sheets for combat and mutilate. It may not be as intuitive or easy to read as Vulajin's, but it still has all of glyphs and most of the gear.
Aldriana's sheet are very nice its just some of us get used to using one thing and hate jumping to another.
Now to get back on topic.
I have been switching between Titanium Impact Band and Sealing Ring of Grobulus to see wich is better but I am still undecided. Prior to the patch SRoG was better, but with the buff to ArP I am not certain but I belive TIB maybe better depending on how it is gemed? I been holding out asking this and waiting on Vulijins spreadsheet but my guild is finally getting there act together, heading into Ulduar and I want to look my best. Any thoughts?
I appreciate if people are used to using my sheet and are really looking forward to an official 3.1 version, but between the six days I raided this week and my actual job kicking my ass for a couple months now, I've been hard-pressed to find any time for this. I do have a version that has most of the 3.1 changes in, and it's likely that I'll release this version as 0.4.8 even though it lacks the improved modeling I've been trying so hard to add in for so long. However, even this might not be coming very soon.
I can't really make any promises about specific dates, so my best recommendation right now is to try Aldriana's sheets. You can switch back to Roguecraft once I've released an updated sheet if you are that attached to the UI, but personally I've always felt that accuracy of calculations is the most important thing, and there is no question that Aldriana has always been spot on in that category.
I've spent most of today testing out arpen in the modified 3.1 VJ spreadsheet. In this SS, arpen comes out way ahead of Ap/agi. However, it's calculated incorrectly and it's too high. If you read GC's post here World of Warcraft - English (NA) Forums -> 116% Armor Pen only giving 66%!?!?!?! you'll find the formula for it. If you read the arpen tooltip, it says UP TO and that's the big kicker. If it says up to 25%, it's not 25%, it's more like 20%. I hardwire calculated the values in the spreadsheet to test if it calculates it at 100% or the correct 'UP TO' value and it's being calculated at 100%. I hope I can clear up some confusion here.
I appreciate if people are used to using my sheet and are really looking forward to an official 3.1 version, but between the six days I raided this week and my actual job kicking my ass for a couple months now, I've been hard-pressed to find any time for this. I do have a version that has most of the 3.1 changes in, and it's likely that I'll release this version as 0.4.8 even though it lacks the improved modeling I've been trying so hard to add in for so long. However, even this might not be coming very soon.
I can't really make any promises about specific dates, so my best recommendation right now is to try Aldriana's sheets. You can switch back to Roguecraft once I've released an updated sheet if you are that attached to the UI, but personally I've always felt that accuracy of calculations is the most important thing, and there is no question that Aldriana has always been spot on in that category.
Thanks dude, as a long time troll of this excellent forum (My first post) I took alot out of this sheet theory wise and its deffo the most comprehensive sheet I seen out there. I know you said your busy but can I ask if you can add Enchanted Tear and the new unique equipped gems from the Dalaran fishing dailies in the the 2 stormjewel's of use to us in the gems list at some point plz if you get time.
I appreciate if people are used to using my sheet and are really looking forward to an official 3.1 version, but between the six days I raided this week and my actual job kicking my ass for a couple months now, I've been hard-pressed to find any time for this. I do have a version that has most of the 3.1 changes in, and it's likely that I'll release this version as 0.4.8 even though it lacks the improved modeling I've been trying so hard to add in for so long. However, even this might not be coming very soon.
I can't really make any promises about specific dates, so my best recommendation right now is to try Aldriana's sheets. You can switch back to Roguecraft once I've released an updated sheet if you are that attached to the UI, but personally I've always felt that accuracy of calculations is the most important thing, and there is no question that Aldriana has always been spot on in that category.
Accuracy of calculations is obviously important for both sheets, but for spreadsheet novices like myself, your sheet can easily end up being far more accurate since I can't be completely positive I've properly changed all the hard-coded parts in Aldriana's sheet to match my needs. In the RC sheet I can oh-so-easily change things like professions and raid buffs without having to triple check everything. Obviously the best solution for me is to stop being a spreadsheet novice, and I'm working on that. In the meantime I'll be here, waiting patiently for a new RC sheet, and however long it takes, I'll be quite grateful when it's ready. Thanks for all the effort!
Tunic of the Limber Stalker is listed incorrectly in this spreadsheet, it has an additional +63 armor penetration which doesn't exist on the actual item. Just FYI, I believe some people thought that this chest was the current best offset piece, but in fact, it isn't
I appreciate if people are used to using my sheet and are really looking forward to an official 3.1 version, but between the six days I raided this week and my actual job kicking my ass for a couple months now, I've been hard-pressed to find any time for this. I do have a version that has most of the 3.1 changes in, and it's likely that I'll release this version as 0.4.8 even though it lacks the improved modeling I've been trying so hard to add in for so long. However, even this might not be coming very soon.
I can't really make any promises about specific dates, so my best recommendation right now is to try Aldriana's sheets. You can switch back to Roguecraft once I've released an updated sheet if you are that attached to the UI, but personally I've always felt that accuracy of calculations is the most important thing, and there is no question that Aldriana has always been spot on in that category.
Hey man, Its my first time posting here and I just want to say "Thank you" for your sheet... I hope we wont have to wait for a new one for so long... thanks again
One quick question...
I got errors and #VALOR in the sheet that people are posting in here... do you know anything about that?
I'm also getting a 'VALUE' error in the 'Poison DPS' cell when using the 'updated' for 3.1 Mutilate sheet posted earlier in this thread. The error comes in both Excel and Open Office versions. In the Excel version it traces back to a main spreadsheet cell that the error trace doesn't specify.
Any assistance here would be appreciated as my rogue is currently below the gear levels that seem to be required on the alternative spread sheet in a few slots.
I've made some updates to my modified sheet (v0.5.3) Sorry but this will only work properly with OpenOffice 3.0.For Excel seeThe Roguecraft Spreadsheet
1) Remodeled ArP based on new information provided by GC and Mavanas' formula located here. You'll notice that your ArP doesn't change much given the same gear but the new model has some important differences.
a) Stacking ArP, it's possible to go into negative armor which will increase damage past the base damage of your attack. This has been tested here. The easiest way to get enough ArP Rating to achieve this is with stacked Grim Toll and Mjolnir Runestone procs.
b) You'll find that the new model means replacing AP gems with ArP ones isn't viable.
c) Executioner and other BC ArP effects are no longer supported.
As always I'm open to criticisms and suggestions (please use PM for minor issues).
Edit: I've been made aware that Pyrite Infuser isn't modeled quite right, when I included it there was very limited item data from the PTRs and the internal cooldown on it is wrong, making it seem more powerful than it is. I also haven't yet changed DC:Death but rest assured it's not much of a PvE trinket.
04/18/09, 9:42 AM
Similar Threads
