You can find the tool here: EDF6 Equipment Farming Tool and Inventory Tracker[docs.google.com]


In order to work the tool, you need to make a copy of the workbook first, just select File>Make a Copy. After you do, you should be able to make changes.

• An Equipment Finder that will tell you what missions to play to find a specific piece of loot.
  
• An Inventory Tracker to tell you what missions still have uncollected loot in them.

Equipment Finder:
To use the basic Equipment finder, you simply need to fill out the dropdown menus from top to bottom. As you make your selections, the next drop-down will update based on the selection in the one above. Fill out all 4, and the sheet will work out the rest. Don't change the value in the weapon level section, as that's used for calculation.


Inventory Tracker:
To use the inventory Tracker, simply scroll down to the weapon tables, and tick next to every weapon you have already collected. There are 2 tick boxes next to each weapon. The left one is to show you own the weapon, and the right one is to show you have the max level (star) for the weapon.

There are 3 Options above the weapon tables. Difficulty, Class, and Collected vs Full Star. These options control the logic behind the Mission tables above. Simply select the options you prefer, and once you have ticked all the equip you own, the mission tables will update to show what missions are still viable for looting.

For instance the image below would allow the mission tables above to show you what weapons are left to upgrade to Full Star for Fencer in Hard mode.

Changing the last selection to 'Collected' will show you what missions have weapons you still haven't found.

Once complete, missions without loot will be struckthrough and red as below.

Another neat feature is that once any equipment has been ticked off as fully upgraded in the inventory tracker, it will no longer show up in the Equipment Finder.

Mission Loot Table Tool:
A simple tool that will allow you to select a difficulty, a class (or all classes), and a mission number. It will then present you with a list of every piece of equipment left to collect in that mission based on filter parameters. It will display results as below:

As you mark weapons as full star in the inventory tracker, they will be removed from both this loot table, and the equipment finder.

Last update was on 16/09/2024. If you're using a version with any other date on the front page, I recommend updating to the latest version.