DPS Spreadsheets

**Motenten** · 2012-12-25 11:03

Fixed food on all spreadsheets. Seems like one of the ranges got expanded, but the other didn't (except for dnc, which failed on both counts).

Updated dnc gear.

No plans on that just yet, Martel. Maybe later.

**Vyvian** · 2012-12-25 15:05

Adding to Byrth's comment, Rapidus Sax is on the DNC spreadsheet, but its THF exclusive.

**Motenten** · 2012-12-25 16:43

Removed.

**Whiteknight** · 2013-01-06 11:42

Hey, sorry for asking, but can anyone add Grandyone mail and rancorous mantle on the drg spreadsheet?
I don't have the microsoft licence, so i can't modify at all the spreadhseet, can't even put my augment on heca etc

**Motenten** · 2013-01-06 13:50

Added Grandoyne Mail to jobs that could use it, and Rancorous to drg. Should be uploaded in a few minutes.

**Foldypaws** · 2013-01-06 18:06

Originally Posted by Whiteknight

Hey, sorry for asking, but can anyone add Grandyone mail and rancorous mantle on the drg spreadsheet?
I don't have the microsoft licence, so i can't modify at all the spreadhseet, can't even put my augment on heca etc

Get LibreOffice. It's a free alternative to MS office, and will let you edit the spreadsheets.

**Ophannus** · 2013-01-06 22:20

Could you add Kudzu Aketon to DRG, as it's one of the best bodies for DRG for multihit Jump sets?

**Motenten** · 2013-01-07 02:29

Kudzu added.

**pooter01** · 2013-01-07 14:28

small note on the sam sheet regarding kaiten. in data, Set B during WS is looking to see if Set A is set to kaiten, instead of set B. spent the longest time trying to figure out why things were not adding up.

**Motenten** · 2013-01-07 14:55

Ah, woops. Thanks. Fixed.

**ssjjfar** · 2013-01-08 10:56

Does thf spreadsheet take in 60 seconds for SA and TA damage?
anyway to add in difference from one or the other of them being 5/5 and at 50seconds cd?

**Motenten** · 2013-01-08 13:35

I'm doing a revamp of the thf spreadsheet, so I'll add in handling the different timing from merits as well.

**ssjjfar** · 2013-01-08 14:19

Ah okay. Sounds good.

**Motenten** · 2013-01-09 17:16

OK, Thf2 implemented. Keeping it separate from the existing Thf spreadsheet for now.

It has a circular reference in it, so requires you to enable the iteration options. In Excel 2003, that's Tools/Options/Calculations. In Excel 2007, it's under the main menu/Excel Options/Formulas/Enable Iterative Calculation. I'm not sure offhand where the option is in LibreOffice/OpenOffice, as I uninstalled that a while back. I set a max iterations of 10, though 5 seemed to be enough.

Thf2 incorporates just about everything you're mentioning, but it can also be finicky. The optimal DPS will depend on the exact balance between TP gain rate and the SA/TA interval timers (including merits and timing overflow). Stacked SA and stacked TA may have almost no effect on DPS, but stacking both can cause a sudden jump (eg: 185 to 197) just because the overall timing is better optimized. Then add in a bit of haste and the order is completely re-jumbled.

As such I'm not sure I can consider it a completely trustworthy approach. It's better and more complete mathematically, but the results require very careful interpretation.

There are two modes for the calculation.

1) You can set a fixed wait limit.

Set "Specify Hold Time Limit" to 1, and it will use the "Hold TP For SATA" value as the maximum number of seconds it will wait past 100 TP in order for the SATA timer to become available. If the timer is more than, say, 5 seconds away, it will instead use a normal weaponskill and build up to 100 TP again to stack with SA/TA.

EG: If the limit is 5 seconds, and the SA timer is 10 seconds away, it will weaponskill. If it takes 15 seconds to build 100 TP, and the normal SATA cycle time is 60 seconds, it will bump the overall cycle time to 65 seconds to account for the extra time spent building TP.

2) You can let it pick the highest DPS option.

Set "Specify Hold Time Limit" to 0; "Hold TP For SATA" is ignored.

With this setting, it will run the calculations for both holding TP and for using the weaponskill immediately, relative to the time it would normally take for the SA/TA timer to come up. It will then use the better of those two options, and report the waiting threshhold needed if it decided to hold TP.

Note that in each case, if it decides to hold TP, that extra TP is used as a TP Bonus on the weaponskill. This is what causes the circular reference, along with the auto-chooser which selects the better of the two DPS results.

Other notes:

The SA and TA timers are handled separately. This leads to a potential issue if the recasts have different values (eg: 5 merits in SA recast, 0 in TA recast) where the time used to build TP and weaponskill will overlap over time (note: only matters when both SA and TA are stacked with weaponskills). In this case, I allowed the option of setting an interference factor.

If "Stacking interference" is set to 1, it will take the ratio of the two timers (including secondary delays that onto each) and scale the damage of the faster of the two by that value. So if SA is 20% faster than TA, SA's melee+weaponskill cycle damage will be divided by 1.2.

Mess around with it, and let me know of any issues.

**ssjjfar** · 2013-01-09 18:02

Willc heck out thf2 while at work tmrw. Let me as you a question I put in randomQs though since it is your spreadsheet I was asking about.

I know +critrate% on daggers like Lux Pugio apply to both hands.
But does that make your crit rate go up 4% overall or 8%?
I always assumed it was just a 4% overall increased rate. I ask because on spreadsheet it puts 4% automatically on each daggger, and total crit rate from gear gets totaled to 8%(+any other from gear).

I know its 4% on first swing and another 4% on second, but since its two swings shouldn't it balance out to a flat 4%?
Wasn't sure if it was actually calculating an increase of 8% in all swings or if that is just how it shows up as 8% on the gear page.

**Motenten** · 2013-01-09 18:19

It has to do with the way crit rate is summed up in the spreadsheet. For each hand, it takes the total crit rate, and then subtracts the crit rate of the other hand. So while there's an 8% total, each hand only gets 4% of that. If you added 5% from Rancor collar for 13% total, each one would get 9% of that. Etc.

**ssjjfar** · 2013-01-09 19:17

ah okay, thanks

**Stanislaus** · 2013-01-10 16:26

I think the DRK's Data.G130 and Data.H130 need a little attention, at the moment they base how many regain tics you get off 3 rounds worth of delay, regardless of actual rounds per WS.

**Motenten** · 2013-01-14 15:35

Updated Thaumas Kecks haste on the spreadsheets for the jobs that can use.

Regain won't get changed unless/until I allow for the circular references in the spreadsheets.

**Doombringer** · 2013-01-16 00:31

So I was using the RDM spreadsheet and noticed that when i swap between dusk gloves +1 and brego gloves, melee hit rate actually goes DOWN. As if I were losing accuracy by equipping the +9 acc bregos?

I went to the gear lists tab and checked, the stats on the items appear correct. Is this a bug or am I missing something?

BTW thanks for these, super handy.

Thread: DPS Spreadsheets

Thread Tools

Latest Threads

Up & Coming Threads

Hottest Threads