BiS Dragoon set Solver

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)

OhgodIlovenyan
<3

This is awesome.
Like...Amazing.

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

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.

Quote:

---

Originally Posted by 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.

---

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).

Quote:

---

Originally Posted by Zigkid3

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 ;)

Quote:

---

Originally Posted by 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.

---

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

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.

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?

Quote:

---

Originally Posted by 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?

---

Turn 5

/10char

Quote:

---

Originally Posted by Gloulion

Turn 5

/10char

---

Thank you.

---
Still nice work on the spreadsheet.

I'll edit the coil turn drops when i get the chance, i had assumed it was the same for mnk/drg to have the like equipment drop on the same turns.

edit: Okay I updated the google doc, and the dropbox download for the turns on when each items drop.

http://xivdb.com/?wardrobe/4733/Opti...t-using-relic1

I can't hover over the items to see exact names there :-(

Quote:

---

Originally Posted by Ozpa

http://xivdb.com/?wardrobe/4733/Opti...t-using-relic1

I can't hover over the items to see exact names there :-(

---

For the relic+1 set:
Wyrm/Hero: waist, chest, ring of slaying
Allagan: boots, head, legs, gloves, bracelet maiming, choker maiming, earrings of striking, ring of striking

(viewable in the google doc)

For the Allagan weapon set:
Wyrm/Hero: waist, chest, bracelet of slaying, earrings of slaying
Allagan: boots, head, legs, gloves, choker of maiming, both rings


As said in the original post the relic+1 set wins out over the allagan weapon set, so dragoons are lucky in that regard.

As you can tell in the two sets, the main pieces are the same but the accessories vary.

So on the bottom of the first post from "rotation reborn" his coil guide for 470 acc and most dps is wrong and this is right?

Quote:

---

Originally Posted by rweezy

So on the bottom of the first post from "rotation reborn" his coil guide for 470 acc and most dps is wrong and this is right?

---

He states that 470 is not the cap (its 472) but regardless the solver came up with a very similar set. the only difference was the neck piece choice.
As a result the one in the rotation reborn thread slightly falls short of the accuracy cap but gains 5 more crit. mine reaches the accuracy cap but is 5 less crit. pick your poison, though i'd rather not have a that one attack miss. (if i was more lax on the accuracy cap, and say used a food buff for some extra needed accuracy, then the solver would come up with the rotation reborn set and swap out the neck pieces)