I had some free time on my hands and I figured that I don't want to calculate stat difference between all these sets in my head.
And so here it is Veszal's minmaxing tool
As I main DoK, I have not added equipmen of other classes, as I dont need it (yet), but you can help yourself by filling Data (Player Input) and Bonuses (Player Input) sheets of document Player Input Data with sets of your particular class. I will check these weekly (or around so) and will be updating tool itself.
Have a good day.
If you try to open it on mobile device you may require google sheets app to be installed for anything but viewing. PC version should face no such impediments.
Sheet was switched to read only. If you want to use it - you will need to copy tool to your own Goodle disk, to do that you need to go File -> Make a copy -> select folder on your disk.
Functionality and usage
To use tool you will only need "TOOL" sheet, all others are there just for technical reasons.
You are only able to change value of cells, which have triangle symbol on them.
If you've chosen 2 and more pieces of same set - set bonuses will be listed in bottom table "BONUSES" and all stat related values will be transfered to "Summary of set bonus Stats" row of upper table for calculation.
TOOL was designed to make it easier for you to compare different combination of sets so when you have filled both tables (left and right) colour will be applied to filled cells based on following rules:
Red - value is lesser than same value of other table
Yellow - value is same as same value of other table
Green - value is bigger than same value of other table
Addon for data extraction
With props to Sullenmonk, behold!
Addon that provides easy and almost fully compatible extract from game:
To use it you need:
1) extract archive in Interface/addons folder of your game;
2) make ingame macro with "/script ItemXport.GetItem()";
3) link item you wish to have extract of in chat;
4) click it;
5) press macro.
Window with data will open and all that is left - copy it and paste into excel/google sheet and than:
1) in advanced paste manu choose "split text in columns";
2) chose "Semicolon" in type of separator.
Special props to