Hello y'all, I don't know if this has been posted before (probably), but I have made and modified a spreadsheet over the years which automatically updates counts, totals, and which ones are missing. If anyone would find this useful, here is a link to the google drive doc
The "Count" column is where the magic happens. Simply input how many of a particular unit you have and the spreadsheet will do the rest. On the "Summary" tab is where all the outputs are stored. There is a "Totals" area where the totals of all inputs are checked to make sure an error did not happen. You can use the formulas tied to those cells to trace back where something may have went wrong. Feel free to reach out if something doesn't make sense.
When I update a count that I have collected something, I bold and highlight the title of the unit. This allows you to then go and filter by color to the names that you have not yet collected. I have gone through the trouble of clearing my data out ahead of time so that it is ready for use. You can filter and sort and do whatever you like and the formulas (hopefully) should not break. But, if they do, the totals will let you know
Last Edit: Oct 3, 2020 15:22:22 GMT by lclmopar426