Gear Spreadsheet

I have made a spreadsheet that you can use to find BiS gear for your class. It supports most items and all rarities for those items. It can accomplish a similar goal to Spazou's BiSbot, albeit much more maual testing is required. This is a totally public project, so anyone can make edits and add as they wish.

How to use.

Upon first opening the Spreadsheet you will see the Home sheet where you can leave messages and see what has changed among other things.

The second sheet(BiS Checker) is where most of you will want to be to find your BiS gear. All you need to do is input your base enchant level (if using legendary gear), Character level, etc. Most of these are used for the offhand calculations. Finally select which Class + Pet Combo to use. If what you are looking for isn't listed, feel free to add it (or leave a message in the sheet) or message me(Lambodroid#6134) in discord about it and I'll see what I can do.

Once all that is input you can use the drop downs in gear set 1 & 2 for each slot. You can use this to compare single slots, full gear sets or anything in between. There is an auto-generated BiS that you can use as a base if you don't know where to start. This auto-generated BiS is not perfect, if can't detect if a lower scored piece will give a set bonus that will make it better overall. Set bonuses are calculated automatically.

The next sheet is the table for all the class scalings. This is where you can add or edit if needed.

Sheet 4 is enchant scalings for the currently selected Class + Pet. There is nothing to type here.

All the following sheets are basically the where all the item information is stored. Most people can ignore these.