Sure thing.
http://www.mediafire.com/view/rb5fie...atch%202.1.xls
This is what I use to work out BiS. It's a modified version of the original BiS set Solver that was posted here a while ago. All credit goes to Zigkid3. To make it work, (must be using office '10+), go to File -> Options -> Add-Ins -> Go -> Check "Solver Add-in" -> OK.
Now, to actually use the solver, you'll want to click on the Green Box next to "Total Objective", click the tab called "Data" -> "Solver?" in the tab (far right).
In the orange boxes, those are variables you can change, so the stat weights, including the accuracy needed to reach the cap. It spits out different gear, and shows the resulting CRT, DET + SS. Remember, these stats that it spits out doesn't include the weapon, so you'll have to add the weapons stats afterwards. The choice of Weapon you want to calculate with comes as part of the Accuracy Cap needed. So if you want to reach 472 cap with Gae Bolg Zenith, input 94 for accuracy, or 131 if you want to use Allagan Spear. 463 Accuracy with Allagan Spear, we would be inputting a value of 122 in there.
After it's solved, it'll display 0's and 1's. 1 = BiS. 0 = Not for set.
Now, to calculate stat weights. It's really easy to use. Put in the total CRT + DET + SS values you got, including the weapon, into the boxes. Then if you're using food, put in the Food % boost, along with their max value. So for Buttons in Blankets HQ, it's 2% CRT 10 max, 4% DET 16 max, and you'll get your total values in the green boxes shown.
http://www.mediafire.com/view/ls7mz9...ht%20Calc.xlsx
There's two Sheets on that spreadsheet, if you want to do any comparisons with other gear sets etc. Also, "proposed accuracy" column does nothing, nor is it calculated into anything. It's just there to help me keep track of what accuracy I'm aiming for with that set.
Remember though, these are tailored for a Dragoon, not any other job, but it doesn't mean you can't change the Stat Weights to suit your Job!
Enjoy!
You running the updated Stat Weight values?
WD = 8.488
CRT = 0.184
SS = 0.152
DRT = 0.323
They're also a few pages back.