Greetings,
A few days ago I was looking at the current collection’s guide on forums and noticed it was incomplete, which also made me think that I wanted a checklist to keep an easier track of what items was I missing to complete the collections so I could easily decide which items to sell and which to keep.
Because of this, I ended up making an Excel file with all the collections that are currently available.
In this spreadsheet, I added every item needed for each collection as well as the bonus it gives and a link to the map where it can be found.
Here’s an example of how it looks
How to:
-
Basically you are supposed to fill the cell background of every item you have already obtained and added to your collections with the blue color that the first line (example line) is filled. The best way to do this for the sheet to automatically change the check box is to copy format from the “Format” tab.
-
On the “Map” column, you can find a link to the map where the collection is located. This site allows you to show on map various things, which includes the chest location by clicking a small circle to the left of it like it’s shown on the next image.
-
If you need to check if an item is needed for a collection or you can safely sell it, you can use Ctrl + F to search for it withing the sheet.
-
Sadly if you use Open Office, or anything that is not MS Excel, the sheet might show some issues on the “Check” column because it works with a macro made for Excel (I’m not really familiar with other spreadsheets so I used this). In case you are using any other program for this, you can copy and paste the check and cross symbols from the “Format” tab to manually mark each collection as complete or incomplete.
The main idea of sharing this is to receive feedback from anyone who might find it useful in case there is any error on it, and also to keep it up to date whenever a new collection is released. So I’d appreciate any comments that can help me improve it in any way.
Download the spreadsheet.
