First and foremost, here's the link to the spreadsheet:

https://docs.google.com/spreadsheets/d/1eAMkfvE5X3jO-Ncnoc1d-CGLVH9mhbvLJS93b7fd-2o/edit?usp=sharing

This spreadsheet is a tool I created for myself in order to help me keep track of Plans I was able to complete. I also wanted it to tell me where I was able to acquire the necessary items, or find the monsters I had to defeat.

Since it worked very well for me, I thought I should share it.

I hope it helps you as it helped me! =)

Almost everything in the spreadsheet is calculated automatically, but there are a few things you should know before using it. The short version of the explanation can be found on the spreadsheet, but here's a more detailed explanation.

Go to "File > Make a copy..." before you try to use the spreadsheet! I recommend using it on Google Sheets because Excel lags A LOT when calculating the formulas, and some features might not work properly.

• Most of this spreadsheet is protected so you don't accidentally ruin it. You should receive a warning if you try to change what you shouldn't.
  
• Use the Plans tab to mark available and completed plans (columns D "Own" and F "Done").
  
• Use the Locations tab to mark unlocked storyline dungeons (column B "Unlocked", rows 2-24).
  
• Just to be safe, ALWAYS use an X to mark available and completed plans, as well as the available storyline dungeons on "Locations" tab.

• There are two main tools on Home tab used to find items and monsters you're looking for. Make sure you type the name correctly, or else it won't work. These search tools are NOT case sensitive, though.
  
• You can only find chips, materials, and some tools (ie, consumable items) this way.
  
• The list of available locations for the items you're looking for will show on the right.
  
• If an item is marked as available (blue) on "Plans" tab but doesn't show on Home tab and doesn't have any note on it, then it's available on Shop.
  
• On the left side of Home tab, you'll see a list with the plans you can complete either with the items you have, or with items that you can farm.
  
• Blue plans below are available for sure, while the grey ones depend on limited items.

• Do NOT filter/sort any of the tabs! Instead, always use "Data > Filter views" so it doesn't change the default sorting order.
  
• It's safer to close the view once you finish using it, but probably not necessary.
  
• Some views have already been created. I do not recommend creating views for the Home tab.
  
• I've included some Quick Links on Home tab for some of the filter views I have created.

• Feel free to check other tabs (Plans, Locations, Monsters, and Loot) if you want to manually search for something specifically.
  
• The Plans tab contains detailed information on the plans. It's also where you should mark available/complete plans. It also shows notes on how to find other items needed for plans, like accessories, items that are limited per playthrough, items obtained from Colosseum/Quests etc. Blue requirements are available to you, while red ones are not. The few exceptions -- the grey ones -- may or may not be available.
  
• The Locations tab will show a list of available dungeons, as well as the plans you have unlocked to alter them. It is also where you should mark unlocked storyline dungeons (column B "Unlocked", rows 2-24).
  
• The Monsters tab contains a lot of information on enemies, including XP and Credits dropped (note that "Rough" enemies require the Add Enemies plan, while Tough enemies require the Add Super Enemies plan). You can also check if they're available to fight.
  
• The Loot tab will list all Idea Chips, Tools, and Materials that you can farm in dungeons. You can also check if they're currently available.

A couple of notes for experienced spreadsheet users that plan on altering its basic structure

• There are some hidden tabs used for some formulas. If you want to change the spreadsheet, make sure you notice them.
  
• There are many hidden auxiliary columns with white text so it doesn't confuse normal users. Don't forget to change them if you need to.

Well, I hope this spreadsheet helped you complete your plans.

If you think it is a good tool, don't forget to rate this guide up! ;)