Kray's Powertech DPS Simulator (v1.2.6) - FULL RELEASE!

[kray]

A Personal Appeal from Spreadsheet Founder Kray:
Insert your own pensive looking headshot of me here.

My SWTOR access is currently on hiatus due to being on the road AGAIN for work. If anyone is on the PTR and can start posting some combat log files here, that's be awesome. High level preferred, but I'll take whatever I can get.

Current Version: 1.2.6
Updated 3/20/2012

• Added IMMO proccing Prototype FT stacks

Selecting "Patch 1.2" currently...

• Changes PPA proc rate
• Allows Immolate to proc Prototype Flame Thower stacks
• Gives PPA an internal cooldown of 6sec
• Gives the RB dot a chance to proc Charged Gauntlets

Using average damage values eliminates a lot of variation, and makes plenty o' sense. You can now run about half the sims you did before to get the same level of accuracy, meaning stat weights can be run at about 1000 sims per stat, etc. Be on the lookout for more streamlining updates like this in the future. Relics and IGC are on their way, but those aren't quite as high on my priority list as ensuring accuracy now that we have combat logs.

I have temporarily added display for the number of ticks remaining on a DoT in the Sim Log. On the damage line, it will say (# Left) to indicate the number of ticks remaining during the duration.

A note about stat weights:
Stat weights are currently calculated by running the sim over and over again with differing values of stats, logging the DPS, and mathing out the difference. In order to really get a useful value I strongly recommend doing at least 1000 simulations, if not more. The more sims you use, the more accurate and steady your results will be. In the future, I may have a toggle to create "semi-random" simulations that allow fewer sims with less variance, but that's a project for later on.

There are 2 weights that are output right now:

AEP - Aim Equivalence Point: This stat is what you'll typically use for weights. These numbers show how good stats are compared to Aim, and thus provide an easy to read and understand metric for prioritizing your stats. A value of 0.5 means that stat is worth 1/2 a point of Aim, and so on.

DEP - DPS Equivalence Point: This stat is what you'll use when trying to calculate how much DPS you'll gain when replacing gear. Simply multiply your stat changes by their DEPs and you will get a rough idea of how your DPS will change. For example, if you gain 100 Crit rating, with a DEP of 0.3, your DPS should go up by about 30.

Other notes:
- There is still a To Do list on the first tab that shows what features I'm going to put in. If you have more features to request, post them here.
- Relics still aren't in, nor is Ion Gas Cylinder. Sorry. Priorities, ya know.
- I've tested this to ensure it works with Excel 2007 and 2010, but it will MOST LIKELY NOT WORK with OpenOffice or Excel 97-2003. I tried to be backward-compatible where I could, but I don't know the language well enough to be sure I'm completely good. If someone with Excel 2003 would like to test, I'd be much obliged. Additionally, if someone who's pro with OpenOffice would like to work with me on an OO.Org version, please PM me.

Bug reports will ideally be made to the form I set up (linked on the first page of the workbook). Otherwise, have fun! Go nuts! Tell me where you see errors!

(File inside a .zip due to upload filetype restrictions)

[Horrowirth]

Thank you for putting this together! I don't think I've seen anyone working on one of these yet. You're a real pioneer sir.

*gets to business*

[blott]

Nice! This seems to be working very well, the fact that it is fast to setup helps a lot. The rotation/priority setup is very nice very free flowing and easy to use. The funny thing I am enjoying doing atm is hitting the sim button and see how proc based our dps really is lol. I can now just use my silly gear sheet to spit numbers at this to get dps ratings, with the amount of variation in dps levels I am wondering if everything is calcing properly though. even at some very long duration 20-30min fights it will still have as much as a 150~250 variation in dps, is this to do with rotation I am trying or maybe something else?

[frmorrison]

It is a decent start, at first I didn't see the Sim button because the Sim tab was not scrolled up.

The sim has 35% for armor which is good. Defense chance of a boss is 8%. 300 seconds is a more valid fight length.

[blott]

(02-16-2012 04:04 PM)frmorrison Wrote:  The sim has 35% for armor but the normal boss armor is 50% then the armor debuff takes 20% off, so 44.4% armor. Defense chance of a boss is 8%. 300 seconds is a more valid fight length.

Do we know this for sure yet those are the right values? From what I could gather from what they have been talking about in the game mechanics forum I thought this was all still best guess in terms of armor values and defense chance of bosses?

I do agree that the best guess at the moment are the values you are talking about. Which you can add to the Ref page if you want to use them.

Kray is there a way for burnout to be modeled properly atm in the sim? Would it be fair to say the last 90s of a 300s fight the boss is sub 30%? I dunno just spitballing here.

[kray]

(02-16-2012 04:04 PM)frmorrison Wrote:  It is a decent start, at first I didn't see the Sim button because the Sim tab was not scrolled up.

The sim has 35% for armor but the normal boss armor is 50% then the armor debuff takes 20% off, so 44.4% armor. Defense chance of a boss is 8%. 300 seconds is a more valid fight length.

Gotcha, will make sure the releases are all scrolled up. The default fight length is also something I forgot to change from a few stability tests I ran, I'll make it 300 by default.

Boss Armor is how much armor they have before debuffs -- you select that from a range I have on there including what we believe are "standard" armor values for varying enemy difficulties. Keep in mind that not all bosses have the same amount of armor, from what I've seen. Debuffs and armor penetration are factored in during the simulation depending on what you have selected in the rest of the sheet. Armor penetration is taken into account, don't worry (Attack Calcs has a whole column for it!). To test it yourself, run sims with/without the 20% checkbox and look at average numbers for our kinetic/energy attacks fluctuate. I'll include 8% in the defense chance option list... but where did you get that number from?

Also, um, 20% of 0.5 is 0.1, not .066.

blott: I ran a series of tests for 10 minutes each with a standard pyro spec and priority and was only seeing a ~10 dps variation. What spec and priority were you fooling with?

Burnout is working already (every talent is programmed in except for those noted)! It's currently modeled to affect the last 30% of the fight's time. Run a 300sec sim with a spec including Burnout and look around 210sec on the log. You'll see ticks before it hit for far less than ticks after it! And before you ask, yes partial talents do work properly, so 2/3 burnout will only give +20% elemental dot damage.

[Omegix]

Is the increased damage for Prototype Flame Thrower implemented yet? Also, I noticed if I just put in FT, it will only use it at 5 stacks, but if I use FT_5, the ability is then used every 3 seconds (so I do like 2k dps).

Edit: Just read your post above, so I assume it is working.

[blott]

@kray: Awesome news on the talents I was not sure but needed to confirm with you about it. And for spec/rotation/options

Spec : http://www.torhead.com/skill-calc#301hMhZMsZfhbbdGhMM.1 / 8,6,27
Rotation : Opener (optional) = DFA,IM,RAIL / Above HL = RAIL_FREE,RS / Below HL = IM,DFA,RAIL,RAIL_FREE,RP,FT,ED,FB
Options : Heat limit : 20 | TSO Usage : ASAP | Vent @ : 60
Sim Info : 300s / Armor % = 50% / Def Chance = 8%

what are you using where you see that very small variation, I am getting ~250 dps swings.

[Omegix]

(02-16-2012 06:07 PM)blott Wrote:  @kray: Awesome news on the talents I was not sure but needed to confirm with you about it. And for spec/rotation/options

Spec : http://www.torhead.com/skill-calc#301hMhZMsZfhbbdGhMM.1 / 8,6,27
Rotation : Opener (optional) = DFA,IM,RAIL / Above HL = RAIL_FREE,RS / Below HL = IM,DFA,RAIL,RAIL_FREE,RP,FT,ED,FB
Options : Heat limit : 20 | TSO Usage : ASAP | Vent @ : 60
Sim Info : 300s / Armor % = 50% / Def Chance = 8%

what are you using where you see that very small variation, I am getting ~250 dps swings.

Get rid of DFA and ED in your Below HL List, they cost too much heat and are pushing you above the HL every time you use them.

I have my Below HL at: IM, RAIL, RP, FB, RS and it stays around ~1500 dps. (Edit: well I still get like ~75 dps swings, but nothing like 250).

[blott]

(02-16-2012 06:16 PM)Omegix Wrote:  Get rid of DFA and ED in your Below HL List, they cost too much heat and are pushing you above the HL every time you use them.
I have my Below HL at: IM, RAIL, RP, FT, RB, RS and it stays around ~1500 dps.

Yeah was just testing things
But even using the same rotation priorities I am still getting a huge variation over 10 tests, these were the results.
1493.27 / 1474.52 / 1515.15 / 1520.04 / 1431.87 / 1483.70 / 1516.41 / 1552.85 / 1542.03 / 1465.33
Low : 1431.87
High : 1552.85
~120 difference? hmmmm....

@kray OH also any chance the steely resolve check box can do the inverse if the spec does not have SR or even just 3% or 6% ?