[Warrior] DPS Spreadsheet 2.3 and beyond - Page 41

dr_AllCOM3 · 02/11/08, 10:55 AM

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.

Grim13 · 02/11/08, 12:29 PM

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.

Buanna · 02/11/08, 12:36 PM

Grim, minor bug, but Set 3 is using the Unbuffed HP value from Set 2's sheet.

dr_AllCOM3 · 02/11/08, 7:26 PM

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

.

Machinator · 02/11/08, 7:57 PM

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.

Moogul · 02/11/08, 8:03 PM

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.

dr_AllCOM3 · 02/11/08, 9:38 PM

You should know a bit about LUA or you'll have to wait for the finished product

.

Machinator · 02/11/08, 10:56 PM

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.

dr_AllCOM3 · 02/11/08, 11:24 PM

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

.

Machinator · 02/12/08, 12:28 AM

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?

MaxCavalera · 02/12/08, 3:24 AM

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 ?

Bakatora · 02/12/08, 9:12 AM

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.

Shha · 02/12/08, 9:26 AM

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.

dr_AllCOM3 · 02/12/08, 9:32 AM

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

.

Machinator · 02/12/08, 11:45 AM

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.