BiS Dragoon set Solver

[Zigkid3]

Hello, earlier I made a BiS solver for Monk gear in the following threads:
http://forum.square-enix.com/ffxiv/t...r-A-Discussion
http://forum.square-enix.com/ffxiv/t...-Best-Monk-Set
it has even confirmed the BiS gear among other people given the same conditions.

Moving on I have decided to create another solver that finds the BiS gear for Dragoons.

Here is the google doc link if you would like to view it:
https://docs.google.com/a/csu.fuller...pdDVaWlE#gid=0
Here is the dropbox download if you would like to download it and make any changes of your own like alter the accuracy requirement, the stat weights, or add rows for weapons:
https://www.dropbox.com/s/r38whwhmxm...20-%20Copy.xls

The solver has a minimum accuracy constraint that accuracy must be >=472. The base accuracy is 341, if using relic+1 you get +37 accuracy. Thus you only need 94 accuracy from equipment. However, if you'd like to find the BiS gear for someone using the Allagan weapon then you'll need 131 accuracy from the gear and would put 131 in the orange box instead. you can also lower the accuracy requirement based on food buffs if you wish.

The weights i used were from the thread:
http://forum.square-enix.com/ffxiv/t...otation-Reborn
which determined that Dragoons prefer Det .22>Crit .16>SS .146 by EasymodeX who also helped provide me with the proper weights in the monk threads.
However, if you download the solver you can always change the weights in the orange boxes if you'd like to your content.

yellow is just a visual to show no difference between the compared gear for specific stats.

Green is the final optimal output the gear set produces. it is basically the amount of stats you've gained from the chosen gear, multiplied by their weights and added together. you can use this number to compare against other handpicked gear and taking the stats gained from the hand picked gear and multiplying those by the same weights and adding them up which unless you picked the same set, won't be as optimal.

The blue represents which gear pieces were chosen once you've ran the solver. a 0 is a no, and a 1 is the chosen gear piece.

How to run the solver if you'd like to make your own scenario's/conditions:

First make sure you have the solver add-in, you can do this by going to file>options>add-ins> select the solver addin> click Go...

Now:
1. In the orange boxes change the inputs you want for the minimum accuracy requirement and the stat weights. If you're using relic+1 you'll only need 94 from equipment, if you're using the allagan weapon you'll need 131 accuracy from equipment.

2. Click the green box where total objective is.

3. Go to the data tab, then at the right side you'll see the solver icon which looks like a question mark.

4. click the solver, then click solve.

5. now you'll see which pieces it has selected once it spits out 0's and 1's in the blue boxes.

Here is the chosen Relic+1 gear set which I have confirmed with the set given by the Dragoons: A rotation reborn thread:
http://xivdb.com/?wardrobe/4733/Opti...t-using-relic1
(its not showing the rings but they are calculated in the stats)

Here is the chosen Allagan weapon gear set:
http://xivdb.com/?wardrobe/4734/Opti...allagan-weapon

Of the two you get:
relic+1: 475 acc (3 over), 135 crit, 112, 22 ss = 135(.16)+112(.22)+22(.146) = 49.45 total objective
Allagan: 476 acc (4 over),82 crit, 138 det, 37 ss = 82(.16)+138(.22)+37(.146) = 48.88 total objective

Overall the Relic+1 set is better than the Allagan weapon set.
(which is surprising, for monks its allagan set>relic+1 set)

(only thing im not sure about is the actual turns you get the allagan weapons at)

[Sousoulsu]

OhgodIlovenyan
<3

[Sousoulsu]

This is awesome.
Like...Amazing.

It's kind of depressing tha MNK need Allagon weapon to be BiS... Hee

[ShaoLynn]

U can check the various drops per turn in this document: https://docs.google.com/spreadsheet/...XSlVDYmc#gid=0

Also, this is based on an accuracy value of 472, wich is enough for T1 to T4 but for T5 I've read it's supposed to be 482/483, but someone needs to confirm that obviously.

[Zigkid3]

U can check the various drops per turn in this document: https://docs.google.com/spreadsheet/...XSlVDYmc#gid=0

Also, this is based on an accuracy value of 472, wich is enough for T1 to T4 but for T5 I've read it's supposed to be 482/483, but someone needs to confirm that obviously.

That's what I've heard.
If you'd like to find out the best gear set needing 482 accuracy instead of 472 (or using food buffs), you can download the excel document and run it with whatever accuracy requirements you want (as well as the weights).

[ShaoLynn]

That's what I've heard.
If you'd like to find out the best gear set needing 482 accuracy instead of 472 (or using food buffs), you can download the excel document and run it with whatever accuracy requirements you want (as well as the weights).

I allready had done the math the old fashioned way, but I downloaded and altered your spreadsheet allready

[Ayvar]

U can check the various drops per turn in this document: https://docs.google.com/spreadsheet/...XSlVDYmc#gid=0

Also, this is based on an accuracy value of 472, wich is enough for T1 to T4 but for T5 I've read it's supposed to be 482/483, but someone needs to confirm that obviously.

Actually 472 seems to be fine for T5. I've been posting about this in the Rotation Reborn thread.

[Zigkid3]

Coolie doolie.
The solver confirmed the set given in that thread as BiS, but at least with this excel sheet people can play around with it.

[zeth07]

The overall Coil drop spreadsheet has the boots dropping on Turn 5, but this spreadsheet has them dropping on Turn 4. Which one is correct?

While the Coil boots are the BiS, I don't see my team beating Turn 5 any time soon so I have considered buying the Myth boots next. However we have been kinda close to beating Turn 4 and it's entirely plausible, which means I might hold off on anything that may drop from Turn 4.

Can anyone clarify which one is right?

[Gloulion]

The overall Coil drop spreadsheet has the boots dropping on Turn 5, but this spreadsheet has them dropping on Turn 4. Which one is correct?

While the Coil boots are the BiS, I don't see my team beating Turn 5 any time soon so I have considered buying the Myth boots next. However we have been kinda close to beating Turn 4 and it's entirely plausible, which means I might hold off on anything that may drop from Turn 4.


Can anyone clarify which one is right?

Turn 5

/10char