The Roguecraft Spreadsheet - Page 112

hawtdawg · 04/20/09, 5:20 AM

Originally Posted by Grishmaluk

I find the best glyphing for 18/51/2 to be to switch out SnD for Killing Spree and making the rotation 5/5/5. Anyone can confirm this?

I'm showing 4/5/4 to be optimal with that spec/glyph

ABUSEDGOAT · 04/20/09, 11:37 PM

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.

Long story short: Don't gem arpen as combat.

Maxipad · 04/21/09, 1:15 AM

Originally Posted by Vulajin

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.

looking forward to the new sheet.

Raymer · 04/21/09, 5:18 PM

Originally Posted by Vulajin

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!

Daarky · 04/22/09, 2:57 AM

Originally Posted by FWk

Excel Users

Combat: http://gogge.se/LC_v0.5_Combat_Ulduar_0.4.7_excel.xls

Mutilate: RapidShare: Easy Filehosting

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

trancos.jorge · 04/22/09, 4:13 PM

Originally Posted by Vulajin

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?

thanks

Calaziar · 04/24/09, 1:21 PM

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.

FWk · 04/26/09, 1:37 PM

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 see The Roguecraft Spreadsheet

Combat: http://rapidshare.com/files/22605853...duar_0.4.7.xls

Mutilate: http://rapidshare.com/files/22605853...duar_0.4.7.xls

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.

d) Boss armor value changed from 10645 to 10643.

2) Added new Ulduar drops and Furious Gladiator weapons. All trinkets are implemented except Vanquished Clutches of Yogg-Saron.

3) Reduced Imp Scorch/Winter's Chill to 5%.

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.

Nomadic · 04/26/09, 7:50 PM

Problem sorted.

Rosvall · 04/27/09, 4:56 AM

FWk; I'm getting wrong datatype (#VALUE!) error on all Envenom/Eviscerate fields. (And subsequently all Total DPS fields) in Excel.

koaschten · 04/27/09, 6:48 AM

Originally Posted by FWk

Sorry but this will only work properly with OpenOffice 3.0.

Originally Posted by Rosvall

FWk; I'm getting wrong datatype (#VALUE!) error on all Envenom/Eviscerate fields. (And subsequently all Total DPS fields) in Excel.

See quote, it wont.

Gogge · 04/27/09, 11:40 AM

The problem is hotfixed by opening the sheet in excel, unhiding the cycles/cycles1/cycles2 sheets, editing the "broken" cells and then pressing enter. It's discussed a few pages back.

Mutilate excel: LC_v0.5.3_Mutilate_Ulduar_0.4.7_excel.xls
Combat excel: LC_v0.5.3_Combat_Ulduar_0.4.7_excel.xls

xore · 04/28/09, 6:50 AM

sorry if you have answered this question before, but i couldn't find any

how/where do i get an update for this spreadsheet including 3.1 gear?

amokchen · 04/28/09, 7:12 AM

I guess many of us is looking forward to when Vulajin's guild will have everything on farm. giving him less wowtime and more spreadsheet time.
Im an excel novice myself, took me some time how to figure out how to input normal gear in Aldriana's spreadsheet.
But I have no idea how to model my trinket in, mark of norgannon, that aint on his list.

We could argue on that since Vulajin doesnt have time, Aldriana could step up and expand his gearlist to not only include the best of the best items.

Im happy with the rough estimate I have now, but an estimate thats right on target would be neat for sure.

wykedtron · 04/28/09, 4:00 PM

I am noticing in both Vulajin and the hybrid spreadsheets that are out the buffs are not working correctly. For example, Trauma has no effect when i mark it TRUE and make Mangle False. The same goes for Rampage/Leader of the pack, Expose Armor/Sunder Armor, Misery/Improved Fairy Fire and a few others. Since they apply the same buffs why would i see a DPS loss when i make the top FALSE and the ones below TRUE?