Updated DPS Sheet And LUAs - (DNC 9/27/2020)

Language: JP EN DE FR
users online
Forum » FFXI » Jobs » Dancer » Updated DPS Sheet and LUAs - (DNC 9/27/2020)
Updated DPS Sheet and LUAs - (DNC 9/27/2020)
 Asura.Cambion
Offline
Server: Asura
Game: FFXI
user: Cambion
Posts: 415
By Asura.Cambion 2020-09-27 22:17:33
Link | Quote | Reply
 
DPS Sheet

First, here is an up to date DPS sheet for anyone to copy if they like. PLEASE be aware, all of the Buff Values are based on TRUSTS. It's easier to update the buff values to whatever you want, than for me to copy over all the updated gear sets. This sheet has all current relevant gear that I'm aware of for Dnc. I eliminated a ton of stuff that was outdated to clean up the 'Gear' tab, with plenty of blanks for anyone to input whatever items (or custom augmented gear) as they desire.

You shouldn't need to request to edit. To keep the original file clean (so multiple people aren't screwing with the same sheet) go to 'File' and select 'Make Copy'. This will give you your own copy of the spreadsheet to customize, input your own Augmented gear, and do with as you please.

https://docs.google.com/spreadsheets/d/1GR2XcweDPqimAN2LqKLU1W8hfUbQNjA-foU3iPnLKec/edit?usp=sharing

** If you want to test Tauret DPS, you need to do 2 things:
1: In the 'Gear' tab, go to Cell AL20 (Custom Crit %) and input 19%. This is the average expected from 0tp to 1000tp, divided by 2, as it only works in a single hand. This is a close but rough, estimate.
2: In the 'Data' tab, go to Cell E211 (Relic Bonus) and manually force 150%.
This should give you the 50% WSD + 19% Crit Rate from a Tauret, for fairly accurate DPS calculations.

Skeleton LUA

Here is a Skeleton Dancer Lua, with nearly everything stripped down. I left a full blank gear set in, so you can see exactly what to fill IF you want. I believe all Job Abilities are in there, but left blank, so that you don't have to customize them if you don't want. They will work, and just not swap anything currently.

You can toss a TP, WS, and Idle set into this lua, and cover 90% of a Dancer's needs without touching anything else. But it has a lot more utility if you get comfortable/confident with gearswap down the road.

Gear Info (Haste Tier and DW handling)

Understand, both of these luas depend on GearInfo to work, as the old haste tiers are ineffective in today's world with so many forms of haste all around us, while still needing to juggle Dual Wield as a Dancer. The addon can be found/explained here:
https://www.ffxiah.com/forum/topic/52145/finally-releasing-this-addon-gearinfo/
 Asura.Cambion
Offline
Server: Asura
Game: FFXI
user: Cambion
Posts: 415
By Asura.Cambion 2020-09-27 22:18:26
Link | Quote | Reply
 
Full LUA

If you want the entire eye-bleeding lua, here is my current full blown gearswap for Dancer. I would only recommend this for career Dancers, or people already comfortable with GearSwap, but it has all kinds of toggles and gadgets built into it, including 4 Tiers of Dmg Taken, 4 tiers of Acc, WS Acc modes, Weapon Swaps, Step Swaps, Treasure Hunter, Warp, Capacity, Dynamis gear locks, a full blown enmity casting mode, and all kinds of sub job specifics built in.

You can steal bits and pieces from this one, as you find a need, and add them to the skeleton lua down the road.
 Ramuh.Austar
Offline
Server: Ramuh
Game: FFXI
user: Austar
Posts: 10481
By Ramuh.Austar 2020-09-27 22:28:03
Link | Quote | Reply
 
Asura.Cambion said: »
In the 'Gear' tab, go to Cell AL20 (Custom Crit %) and input 19%. This is the average expected from 0tp to 1000tp, divided by 2, as it only works in a single hand. This is a close but rough, estimate.
would be slightly more accurate to take your average tp return and your average ws instead of 0 and 1000 if wsing at 1000, especially so if you are holding to higher values
Offline
Posts: 9079
By SimonSes 2020-09-28 03:26:41
Link | Quote | Reply
 
This is not how you share link to sheet. You need to go to File>Share>GetLink change to Anyone with link - Viewer. Copy link and post.

Current link leads to page that let you ask for request to edit.

Asura.Cambion said: »
** If you want to test Tauret DPS, you need to do 2 things:
1: In the 'Gear' tab, go to Cell AL20 (Custom Crit %) and input 19%. This is the average expected from 0tp to 1000tp, divided by 2, as it only works in a single hand. This is a close but rough, estimate.
2: In the 'Data' tab, go to Cell E211 (Relic Bonus) and manually force 150%.
This should give you the 50% WSD + 19% Crit Rate from a Tauret, for fairly accurate DPS calculations.

Why not simply make it change automatically when you equip Tauret?
 Asura.Cambion
Offline
Server: Asura
Game: FFXI
user: Cambion
Posts: 415
By Asura.Cambion 2020-09-28 11:20:20
Link | Quote | Reply
 
SimonSes said: »
Current link leads to page that let you ask for request to edit.

Fixed, I think.

SimonSes said: »
Why not simply make it change automatically when you equip Tauret?

If you add the Crit % to the weapon, it will be calculated into the WS data as well, which is not accurate. Manually putting it only into the Custom line for 'TP' will prevent that, only apply the Crit % to the TP phase, and won't alter WS damage.

Adding 50% WSD to the Weapon in 'Gear List', will only add about ~1000dmg to the WS Damage. Adding it to the WS Custom line, results in the same. I don't know why, but based on everything I've read here and the Thf forums, the above method is the best work around. I asked on both Dnc and Thf forums for the best handing of Tauret and this was the answer I got.

I do not fully comprehend the back end of DPS sheets, it is my ASSumption that WSD in the sheet is only calculated to effect the first hit of a WS, whereas Tauret applies to all hits.

If you have a fix, by all means, please share.
Offline
Posts: 202
By malakef 2020-09-28 12:51:50
Link | Quote | Reply
 
I think he is saying just add some IF statements to the crit calculations. It’s very similar to how the Charis is set up and leaves it cleaner for swapping back and forth.

Also I hate how the PDif is done here and it actually won’t account for PD limit increase from malignance, or anything outside the JSE neck, if you wanted to see what it did for WS and melee damage. It’s also independently calculate 2 times when it should just reference the first time.

Pyrrhic cleos has mistakenly been added to only give 45% WSD when it’s actually 49.5% because of multiplicative properties.

Should probably be noted that the defense down on the setup page in cell N4 is outside of frailty use which is calculated later. It’s working properly but I really wouldn’t have set it up that way but to each there own.
[+]
 Asura.Cambion
Offline
Server: Asura
Game: FFXI
user: Cambion
Posts: 415
By Asura.Cambion 2020-09-28 13:03:36
Link | Quote | Reply
 
malakef said: »
I think he is saying just add some IF statements to the crit calculations. It’s very similar to how the Charis is set up and leaves it cleaner for swapping back and forth.

Also I hate how the PDif is done here and it actually won’t account for PD limit increase from malignance, or anything outside the JSE neck, if you wanted to see what it did for WS and melee damage. It’s also independently calculate 2 times when it should just reference the first time.

Pyrrhic cleos has mistakenly been added to only give 45% WSD when it’s actually 49.5% because of multiplicative properties.

Should probably be noted that the defense down on the setup page in cell N4 is outside of frailty use which is calculated later. It’s working properly but I really wouldn’t have set it up that way but to each there own.

First and foremost, thank you for the helpful insight.

Having said that, I'll be honest with you, a lot of this is over my head. I'm just trying to offer some up to date help, as the only DPS sheet you can reasonably locate for Dnc is multiple years old. People regularly ask for an updated sheet in the big thread, but no one ever answers. I didn't create this, I've just updated it, so anything on the back end, is truly beyond me. I apologize for that.

If you know how to fix/correct it, please feel free, send me the link to the new version, and I will update the OP with your link.
Offline
Posts: 202
By malakef 2020-10-15 08:53:56
Link | Quote | Reply
 
Ok so I had a bit of time a few days ago to work on it some. I really need another day or two cause I keep finding issues but it’s probably at a decent point now. Updated sheet can be found https://docs.google.com/spreadsheets/d/1I83cojrh7PCpdkF_FlJoGgYVV7MwKyt3ldGzORMcpTU/edit?usp=sharing. You will need to download a copy of it. This was done intentionally so this version doesn’t get random updates by people.

List of some changes below:

PDIF changed from base 3.25 to 3.45

PDIL now calculates for JSE Necks AND any additional gear like malignance

Smite bonus was applying when /war, however smite is only for 2 handed or H2H weapons…

Occasionally deal triple damage was still only doing *2.. someone changed the label but not the formula at some point
In addition, I have changed this to ODX (occasionally deals x ) where the x values and percent procs are now set on the gear tabs by weapon. This means besides twash, Setan (A) dagger works now and will work for future weapons that may have a similar mechanic. This also means you no longer need to manually add it in but it is currently set to the 1k value of the AM which is more likely the case anyways. It also may falsely assume you use rudra’s with twash but that seems a safe assumption for now.

Augmented Terpsichore had 2 flaws, first was it showed only 45% WSD instead of 49.5%, and second it wasn’t having mythic aftermath applied even when you selected the option. Both have been fixed.

Tauret now calculates 19% crit rate during TP phase when in MAIN hand only and zero added during WS phase. In addition the 50% bonus damage to Evisceration is now calculating. We can argue over the 19%. I don’t care it’s a simple fix for me.

Follow up Attack mechanic has been added properly (don’t get me started on how this was in there before…) and Column added to gear list for future items to have it. This means Setan (B) now works. FUA is ONLY functional main hand. I don’t think anything exist in offhand for FUA anyways but if it does I’d have to adjust.

I have reworked the formula for REMA bonus to instead of being a crap ton of nested if statements to now do look ups based on the weapon. All you the user need do is fill out the stats on the gear list, like any other stat, if we get any new weapons like these.

Building flourish was only giving the acc and/or attack boost but not the WSD from JP. This has now been fixed.

Sub DRG has been added as an option and the associated +7% WSD is functional.

Fencer build seems to be functional but I didn’t mess with it a ton.

Someone should probably take time and confirm all the stats on the gear list tab. Found a couple of mistypes and missing stats (kentarch belt didn’t have its acc listed for instance) for some items but didn’t go over them closely just a cursory glance at some things.

Bunch of other crap I stopped keeping track of. The longer I’m in the sheet the more I find and I have ran out of time for the moment. This is the problem with multiple people editing over the years with various levels of understanding both with excel and with game formulas. Just because you know how to add Cell A + cell B doesn’t mean you know excel…
[+]
 Quetzalcoatl.Langly
Offline
Server: Quetzalcoatl
Game: FFXI
user: Langly
Posts: 685
By Quetzalcoatl.Langly 2020-10-15 09:17:39
Link | Quote | Reply
 
I was going to double check some of your work but Google Sheets doesn't display some fields correctly (if at all), and when exported, Excel has a fit and says nearly ~everything~ is improperly referenced or misspelled.

Sorry. *shrugs*
Offline
Posts: 202
By malakef 2020-10-15 09:21:03
Link | Quote | Reply
 
Yeah I forget google sheets is dumb like that sometimes. Hold on a sec.

Ok this should force it as an excel file rather than a google sheets file....
https://drive.google.com/file/d/1rJBZhHnjrArveEhE2SbJU0WMiGzFNcZX/view?usp=sharing
 Ramuh.Austar
Offline
Server: Ramuh
Game: FFXI
user: Austar
Posts: 10481
By Ramuh.Austar 2020-10-15 11:01:04
Link | Quote | Reply
 
FUA is definitely wrong.
Offline
Posts: 9079
By SimonSes 2020-10-15 11:49:46
Link | Quote | Reply
 
Ramuh.Austar said: »
FUA is definitely wrong.
malakef said: »
Follow up Attack mechanic has been added properly (don’t get me started on how this was in there before…)

Maybe lets get started how it was there before lol

Why I think it was simply calculated by adding 0.5 attack per round? This implementation would be good, if you have no Quadruple attack in gear while dual wielding, because then it wouldn't properly calculate rounds with 2x QA proc. So right implementation should be fixed +0.5 attack per round, but with check added for 8hit rounds limit when you have QA.

Current implementation in sheet is totally wrong, because its based on MA proc. For example if you manually add enough DA or TA to get 100% of them, you get no increase of attack per round with 50% FUA. 50% FUA is always +0.5 attack per round, regardless of MA proc.
Offline
Posts: 202
By malakef 2020-10-15 11:56:08
Link | Quote | Reply
 
Oh then maybe it’s my misunderstanding. Based on what little info is out there it appears that FUA is checked last and if something else went off it doesn’t happen. But it seems it always gives an additional attack chance at the stated percent instead? Up until 8 hits anyways?

Edit. Ok I reverted the FUA calc mostly to how it was, at least in functionality. It still needs a tweak to check for 8 hits and then accuracy applied but I’ll get to that later.
Offline
Posts: 9079
By SimonSes 2020-10-15 16:08:54
Link | Quote | Reply
 
malakef said: »
Oh then maybe it’s my misunderstanding. Based on what little info is out there it appears that FUA is checked last and if something else went off it doesn’t happen. But it seems it always gives an additional attack chance at the stated percent instead? Up until 8 hits anyways?

Edit. Ok I reverted the FUA calc mostly to how it was, at least in functionality. It still needs a tweak to check for 8 hits and then accuracy applied but I’ll get to that later.

It's checked last, but its checked always. The only thing that blocks it is 8hit per round limit.
 Ramuh.Austar
Offline
Server: Ramuh
Game: FFXI
user: Austar
Posts: 10481
By Ramuh.Austar 2020-10-15 16:11:39
Link | Quote | Reply
 
its checked before any offhand procs, so nothing blocks it.
Offline
Posts: 9079
By SimonSes 2020-10-15 16:18:13
Link | Quote | Reply
 
Ramuh.Austar said: »
its checked before any offhand procs, so nothing blocks it.

Oh, didnt know that. That being said, there is still conflict there. QA+FOA+QA will produce 9 hits and will be cut to 8, which should be included in avg per hit calculation. DNC is still easier to handle here, than MNK or NIN with their kick attack and Daken >.>
 Ramuh.Austar
Offline
Server: Ramuh
Game: FFXI
user: Austar
Posts: 10481
By Ramuh.Austar 2020-10-15 16:20:38
Link | Quote | Reply
 
yes, but it would be easier to just add the 0.5 to mainhand and then modify the formula for offhand to account for FUA procs
Offline
Posts: 9079
By SimonSes 2020-10-15 16:35:40
Link | Quote | Reply
 
Ramuh.Austar said: »
yes, but it would be easier to just add the 0.5 to mainhand and then modify the formula for offhand to account for FUA procs

I think currently in most spreadsheets it is exactly just +0.5 to main hand, but without changing the formula for offhand. Which result in slightly better performance than it should if you have QA.
Offline
Posts: 202
By malakef 2020-10-15 17:21:58
Link | Quote | Reply
 
Yeah and the reason the spreadsheets do that is because of how they were set up ages ago. It sounds like an easy fix but there is a probability table, sort of, that is referenced for hits on a WS and it’s so baked into the formulas it’s not fun to change it around. I did a version that semi does this but if you didn’t know and just looked at the table it would be odd so I’m keeping that back for now. We are currently getting around this in the avg rounds to WS cell in the melee tab by creating a unique formula for just FUA weapons. It’s not perfect but it’s reasonable which is all we really get out of DPS spreadsheets anyways (the whole averages of averages problem).

Austar’s solution would work but requires more rework of existing formulas and logic. I can get to it eventually but depends when I get free time.
necroskull Necro Bump Detected! [212 days between previous and next post]
 Asura.Cambion
Offline
Server: Asura
Game: FFXI
user: Cambion
Posts: 415
By Asura.Cambion 2021-05-15 16:16:21
Link | Quote | Reply
 
Nvm. Had to go through some link hoops outside of Dnc forum, but Simon has an updated DPS Sheet here, with Gleti, Nyame, updated Feb 2021:
https://docs.google.com/spreadsheets/d/1gs90pbRsmja6H7CzRT2GYWAW0J9dKlgrOcumH-oaXGk/edit#gid=1448206331
Log in to post.