Elitist Jerks [Warrior] DPS Spreadsheet 2.3 and beyond

 02/11/08, 10:55 AM #601 dr_AllCOM3 Great Tiger     Döc Orc Death Knight   Blutkessel (EU) In case you want to take a look, here is my DPS addon. Just autoattacks, flurry and BT so far. That's most of the work done . Addon /script DocsWarriorMeter:Main(); 3x 10,000s of combat.
02/11/08, 12:29 PM   #602
Grim13
Piston Honda

Orc Warrior

<HoZ>
Malorne
 Originally Posted by Machinator Just brainstorming a bit on accounting for rage starvation or saturation. 1. Calculate rage by global cooldown. Determine the odds of hits that result in too much or too little rage. I am not sure how to do this for different speeds though. 2. Calculate rage by cycle, and average each permutation of hits. Seems like a lot of repetitive sheet, probably some way to simplify it but I dont know how.
That's pretty much what I was thinking. Just need to take a day and run some numbers and find out if my base assumptions match the data.

 02/11/08, 12:36 PM #603 Buanna Piston Honda   Buanna Troll Shaman   Hellscream Grim, minor bug, but Set 3 is using the Unbuffed HP value from Set 2's sheet.
 02/11/08, 7:26 PM #604 dr_AllCOM3 Great Tiger     Döc Orc Death Knight   Blutkessel (EU) Code cleaned up plus WW. I don't expect any serious help though . Addon /script DocsWarriorMeter:Main(); I need a cool name for it, including mine .
 02/11/08, 7:57 PM #605 Machinator Don Flamenco   Berserkr Troll Warrior   Aggramar What exactly does the addon do or how do you use it? I do that script, and get a DPS number but have no idea what its for or what changes it. "Information is ammunition."
02/11/08, 8:03 PM   #606
Moogul
___facing so hard right now

Pandaren Monk

Argent Dawn (EU)
 Originally Posted by Machinator What exactly does the addon do or how do you use it? I do that script, and get a DPS number but have no idea what its for or what changes it.
Judging by his earlier comments, I'd hazard a vague guess and say it runs a quick simulation with your equipped gear to generate a dps estimate.

But I might be wrong.

 02/11/08, 9:38 PM #607 dr_AllCOM3 Great Tiger     Döc Orc Death Knight   Blutkessel (EU) You should know a bit about LUA or you'll have to wait for the finished product .
 02/11/08, 10:56 PM #608 Machinator Don Flamenco   Berserkr Troll Warrior   Aggramar Well I understand what it does, I dont know why you chose to do it in wow unless you are planning to have it work by current character later. "Information is ammunition."
 02/11/08, 11:24 PM #609 dr_AllCOM3 Great Tiger     Döc Orc Death Knight   Blutkessel (EU) Something like that, but the simulation/math stuff has to be correct first. Is it even possible to do something like SEP with a simulator? I never get a good average, the results are always different .
 02/12/08, 12:28 AM #610 Machinator Don Flamenco   Berserkr Troll Warrior   Aggramar You could keep doing the sim until the average dps stopped changing by a significant amount. Thats pretty much what spreadsheets do with the iterations isnt it? I dont know how much calculation that is though. Just an idea, would it be easier/faster to dump a players stats and run the sim outside the game? "Information is ammunition."
02/12/08, 3:24 AM   #611
MaxCavalera
Glass Joe

Human Warrior

Frostmane (EU)
 Originally Posted by Grim13 I found the AP issue. When I was ripping out some of the old stuff in Warrior_DPS.xls I didn't realize that I took racial stats and base HP out of the circuit. It has been corrected and the above link is updated. For reference, I don't use the latest version of Dr_AllCOM3's v2 sheet. I just make changes to the one I'm using as we go along. The way I have the one I'm using set up, it does NOT use total B stance AP or anything like that. It uses AP from items, Race and base AP. The error was that I had it using ONLY AP from items, which was wrong. The corrected version is here: WarriorDPS_020808
Grim can you tell me why is no change in dps when i set mongoose on oh ? its a bug or not ?

 02/12/08, 9:12 AM #612 Bakatora Glass Joe   Bakatora Orc Warrior   Ner'zhul I apologize if this question is a repost, but when S3 had just come out, I ran through the warrior dps spreadsheet at the time and it showed that the Gladiator S3 Axe was an upgrade over Dragonstrike (I'm an Orc). But now, using the WarriorDPS 020808 spreadsheet, I'm getting Dragonstrike as superior by 7-13 dps depending on buffs. Did something change? Or am I just retarded I apologize for the selfish question, I'm planning on purchasing the MH next week unless Dragonstrike ends up still being superior. Thanks in advance.
 02/12/08, 9:26 AM #613 Shha King Hippo   Shha Night Elf Warrior   Scilla One thing i can think of, is if you read above - Grim reintroduced the base stats for races into equations. As a result your ap/crit went up by far, lowering value of those stat son S3, and boosting the *scaling* Dragonstrike.
02/12/08, 9:32 AM   #614
dr_AllCOM3
Great Tiger

Orc Death Knight

Blutkessel (EU)
 Originally Posted by Machinator You could keep doing the sim until the average dps stopped changing by a significant amount. Thats pretty much what spreadsheets do with the iterations isnt it? I dont know how much calculation that is though. Just an idea, would it be easier/faster to dump a players stats and run the sim outside the game?
Maybe, but didn't you always wanted to have that as an addon?

To get a steady dps value you'd have to repeat it at least 100k times. Warrior dps ist very streaky.
2000*240s seems to net <3dps difference, but it freezes the screen for 10s. When I can get the addon to run in the "background", the size of the values won't matter. I have to ask in the wowace forum maybe .

Last edited by dr_AllCOM3 : 02/12/08 at 9:58 AM.

02/12/08, 11:45 AM   #615
Machinator
Don Flamenco

Troll Warrior

Aggramar
 Originally Posted by Grim13 That's pretty much what I was thinking. Just need to take a day and run some numbers and find out if my base assumptions match the data.
You mind if I ask what you have so far? I am actually trying to write it in my personal spreadsheet as well.

For the addon, I think cartographer routes has an option for backround calculation, might want to look there. Also might be worth a new thread, other people with sims(I think shaman have one at least) might not look here that could help.

"Information is ammunition."

 Elitist Jerks [Warrior] DPS Spreadsheet 2.3 and beyond