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 Minmaxing tool
Have a good day.
USER GUIDE
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.
Spoiler:
Spoiler:
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:
ItemXport_1.0
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
Sullenmunk
Rydiak
Antamek
Tibdum Butmerer
DanielWinner
Jucka
Vrede