PUP DPS Spreadsheet

So I'm looking over the excel sheet, and it doesn't factor in AF3+2 set bonus. Also we don't actually know how the set bonus works...
Yes yes, wiki has info on it, but it's not exact, and doesn't break down number of pieces to effectiveness and proc rate, etc.

Anyone have a better idea on this, or am I just missing something?
Also just some food for thought when using spreadsheets, they don't have everything. >.>

Gnaghbod's? wtf is that? On the pup spreadsheet, head slot.

Edit: Gnadbhod's Helm... typo in the spreadsheet.

This maybe? http://www.ffxiah.com/item/16158/gnadbhods-helm

http://www.ffxiah.com/item/16158/gnadbhods-helm

Can't get the stupid [item ] code to work for it :<

Supposed to be this.

As for it not factoring in the set proc rate, it's so low even with all 5 pieces (as far as I remember ~5%) that anything lower than 5 seems negligible. Not to mention the difficulty in showing the average damage increase from it seeing as you'd have to also factor in the average hp of the Automaton at any given time that the set effect decides to proc because simply assuming it's at 100% all the time would not give accurate results in certain situations.

In conclusion, the spreadsheets aren't perfect and they were never meant to be. Anyone who puts all their faith into them is probably going to end up with wrong information in the end. However, they are good for getting a general idea of things.