Quote Originally Posted by ziddyt View Post
I made a solver similar to the DRG/MNK ones floating around.
https://mega.co.nz/#!EYAxDbjJ!JBWEUm...WzmAS52L04DIzE
Humm, you have a dynamic calculation for the food stat results which means that solver won't like using Simplex LP. I overwrote them with manual values that were based on "a high gear level". There is a slight error, but not significant. I don't know how to include a dynamic food stat calculation while maintaining the linearity requirements of the Simplex LP solver.

I like the way you have the overrides set up; I might copy that for mine. You probably want to highlight cells E66:E80 with a different color to make it more blatantly obvious what users should be editing. Probably 66:76 with one color and then 77:80 with a different color.

Also, it would be helpful to add a cell after the accuracy number to indicate what the real accuracy is (item acc + 341). Most people use the "+341" number because that's what people refer to for acc caps and so on. E.g. they don't say "you need 131 acc", they say "you need 472".

Overall, nice spreadsheet.

Oh wait, do you not have DEX? You need to add that because you are mixing item levels. Specifically the crafted items are over-valued because the spreadsheet doesn't account for the difference in DEX. This would also be important if you want to add any CT items to the list.