Hi. I'm Pags.

I've been working on a Google Sheet document that I'm calling the ULTIMATE Voltra Quest Log (it's for anyone who dreams of collecting every item on Voltra). I'm doing this to teach myself how to use Google Sheets, but I'm completing it for fun (because I'm a nerd).

It is INCOMPLETE. I am posting it so that I can get some feedback from the people who may use it. (So please don't be concerned by any incomplete lists or repeated tables. I'll update this as I complete sections and will inform the public when its ready to use.


Features:

• Multiple tabs to neatly separate the different kinds of items. (Sets, orbs, shop items, etc.) These can be found at the bottom of the page. (I believe that the tabs can appear at the top when on mobile.)
  
• Status menu with the options: questing, bought, donated. (You need to be logged into a google account to make a copy of the file before you can use this function. File > Make a Copy)
  
• Price spent so you can keep track of how much you purchased the item for. Currently only has a volt option - would you want another column for ohms?
  
• Date received so you can keep track of when you acquired the item if you feel so inclined.

Shop items are more complicated because there are so many individual colors involved. They have the most detailed sheet. Currently, their features include:

• Collapsible columns and rows. There really is a lot going on in the shops, so I opted to make excess items (past three) and all colors collapsible. This is what it looks like when they're not collapsed - it's a lot, right?
  
  
• You can keep track of how many items total you have left to buy from each shop and how many colors left per item, as well as estimated cost and how much you've spent so far (based off of full price). I wanted to make it so that you could alter the amount you spent on each item (in the event that you purchased them at a discount), but that would seriously clutter the table. (Would you prefer that "spent so far" be "current value"?)
  

I'll be adding an option to sort the tables alphabetically, cost, and status.

Please let me know what you think. * u * And...I'm sorry if this isn't the proper place to post this. > _ >;;;

█ ▌▌✦

@Totalanimefan: It has helped me learn Google Sheets (Docs is the Word equivalent)! :D I've already been able to spruce up some other data spreads I have because of it.

@vengeance: LOL, yeah. :) It'll keep me during my winter break.

█ ▌▌✦

@vengeance: I haven't! O: Where do I find that?

█ ▌▌✦

@vengeance: Oh I see! Thanks.
The values are automatically calculated on my sheet, so I thankfully don't have to add anything up. I just enter one value and it does its thing.

█ ▌▌✦

@vengeance: I thought about adding a total shop price too. HMMM. I want to make sure it stays looking nice and not cluttered, but there really are so many values that could be added!!!

█ ▌▌✦

@Totalanimefan: Awesome! It's such a useful tool and you'll be able to put on your resume that you know how to use it. * U *