How to Dragoon per Second: A DPS Paradigm

[Mantrus]

Thanks for the calculations, Jack. I've been wondering that for a while and I always felt a bit bad overriding an empowered DoT, but now I won't have to feel like that. And yeah I meant to have HT and Phl in-between the other combos, but I forgot lol. I think you missed the extra 60 potency from the TTT combo over the CT combo, but it doesn't really matter since it still comes up short in potency even ignoring auto-attacks and ranged DPS piercing damage. And yeah I meant specifically just for the opener.

[JackFross]

I think you missed the extra 60 potency from the TTT combo over the CT combo

I was comparing these two strings:

H>IDC4>P>TTT4>H>TTT4>P>IDC
H>IDC4>P>TTT4>H>IDC4>P>TTT

Stopping calculations at the point where CT would be re-applied in the first one. Since it's the same exact set of GCDs just in a different order, I got to ignore the differences in potency between the two different openers and just focus on the more minor differences (dots and disembowel).


Also, Whiskey. Yesterday, out of boredom, I spent ~7-8 hours straight updating my excel spreadsheet in preparation for 3.2. It's still not even close to finished yet. I'll put this junk under a cut since most people will be like "Ariyala exists u nerd" and my argument is "Yes, it does, but it's so ugly."

This is what the main page of it looks like:


All of the buttons are fully-functional, the radio buttons adjust dropdown menus in each of the slots, Race is fully integrated... It's set up where it CAN work for other Jobs, I just didn't care enough to fill in base stats or gear listings for anyone else, since I don't play any of the other jobs that Dervy has figured stat weights for.

O - saves the set on a new sheet
X - deletes the set's sheet, if it exists. doesn't let you delete important sheets.
PURGE - deletes all sets you've created.
Clear Gear - clears every Gear slot to blank.
Clear Materia - clears every Materia slot to blank.
Sort Gear Listing - sorts the gear listing for the Job that your set is for.

There's also sort functions for the Job page and Food page so you can add new stuff yourself and shuffle it in without much issue, using the custom sorts I've made to keep things organized properly.

Making a new Job gearset is as easy as copying the DRG Gear listing and naming it XXX Gear - where XXX is the 3-letter abbreviation for the Job. I *might* add in some other Job full functionality before calling it finished, but I think it's turning out well.

If anyone has ideas for stuff I should add, let me know! I'm slowly learning Visual Basic to program this sheet, too. C:

Currently, I'm in the process of seeing if it would be possible to have a dynamic picture on the set page that adjusts based on which Job you are...

//Edit: That was a lot easier than anticipated.

[MiniTyra]

[/HB]

That's so pretty. A lot better than mine, tbh.

I'd like to have an unofficial Dragoon companion app :3

So, a Dragoon chat app, along with gear calculation tools and push notifications would be sick.

[whiskeybravo]

Nice. I spent a couple hours the other night trying to come up with some way to visualize and arrange the various buffs, like the alignment thing that was being discussed before. Still struggling a bit with it, what I came up with was just ms paint images to scale, like HT was 240 pixels, IR 600 pixels, b4b 800 pixels, etc. But having a hard time coming up with an accurate sort of grid to plot them on.

Edit.. That's a really nice spreadsheet, totally jealous lol. I know Excel is pretty powerful, but unfortunately outside of basic math formulas I'm a total noob with it lol.

I used to code in C++ and VB many years ago, recently downloaded android studio to play around with but haven't attempted anything serious. I'd like to have an unofficial Dragoon companion app :3

[Ninjah2r]

drg app? fuck yeah count me in, I want that

[TheKingSlayer]

FYI Whiskey, Excel has a "Help" section that will take to free online courses that teaches you all the basics and even some of the more advanced techniques. Its free and they are extremely useful.

https://support.office.com/en-us/art...rs=en-US&ad=US

The 2007 Training courses are very good.

[JackFross]

So for anyone who wants to mess around with it, you can check it out here!

It's a .xlsm - macro-enabled excel file. You need to enable macros if you want it to work as best as it can. I'll ofc be updating it for 3.2 and uploading a better version then. This is more like a beta lol

As far as a visual way of arranging buffs, Excel has an incredible amount of columns and rows. You can narrow them up and treat each column as 1 second, if you wanted to, or even treat each one as 0.5 seconds. You'd be filling in blocks of them, and merge+center does wonders even when you have a shitton of columns being used.

[Ninjah2r]

Sup with multidotting in dungeons during pulls? how much difference does that give us in dps if we apply dots on every mob the tank pulled, instead of aoe'ing with RoT/DS/GK?

[whiskeybravo]

As far as a visual way of arranging buffs, Excel has an incredible amount of columns and rows. You can narrow them up and treat each column as 1 second, if you wanted to, or even treat each one as 0.5 seconds. You'd be filling in blocks of them, and merge+center does wonders even when you have a shitton of columns being used.

I did start out that way but the problem I found is you can't drag them around easily to try different arrangements. I was looking to make something more akin to a puzzle that you can piece together. Maybe there is a way but my Excel class level isn't high enough to figure it out xD

(thanks for that suggestion btw, King)

Sup with multidotting in dungeons during pulls? how much difference does that give us in dps if we apply dots on every mob the tank pulled, instead of aoe'ing with RoT/DS/GK?

The chart a few pages back breaks it down pretty well. I experimented in dungeons with a few dif things, mainly running out of TP lol. But I think in big pulls you should always start with buffed DS spam, 9 shots before you reapply HT. Will leave you with around 400+ TP. After that you can switch to a single-target rotation or HT-RoT or a few more DS depending on your feels. HT-RoT is a bit more conservative on TP than Doomspike if you need to keep aoe'ing, just make sure you get the positional buff. If it's 3 or 4 enemies just put up CT on each and GK away (unless they are about to die, then TTT4 instead). Also just wanted to add, you can't put dot's up on everything. Well, you could put them up I suppose, but after the 3rd enemy it will fall off the first so really you can only keep them up on 3 enemies.

[Sekundessounet]

Hello there !

So, I'm currently on A3S with my static, but we're struggling to end the Phase 2 because we don't meet the DPS check on Hand of Pain. Personnaly, I'm trying to have every CD up for this mechanic so I stop using them after the first Wash Away, so I can have my full opener during the mechanic (this include not using a Drac Pot and Battle Litany at the begining).
Is that okay ? Or should I do otherwise ? Everyone in the static is with the Thordan Ex weapon (DRK/WAR/WHM/SCH/DRG/NIN/BRD/SMN), and the WHM is having the DMG down debuff (while I have the vulnerability up).
We loose at like 4.2% of the gap between the two hands.

And should I stop using Dragonfire Dive and Geirskogul if the hands are packed ?