Hello all, I like to keep things organized when I'm opening my shop, so I created this Google Sheet to go along with the price list courtesy of Sarcastic/Trove & Levitation. My companion sheet imports the prices from the price list and will automatically sum up the values of the scrolls you enter. You can access the sheet here. Here's a quick guide for getting started with this sheet: 1. Make a copy of the Sheet so you can add in your own inventory of scrolls: 2. On the newly copied sheet, choose a category for the scroll you wish to add. For example, I want to add 2 Scrolls for Claw Attack 30%. So I will choose "Weapon" from the scroll category list: 3. Next, I will choose the "Claw" scroll type from column B in the same row. The list will automatically populate with all Weapon scrolls (It can take a second for the list to load based on the category you've chosen. After the first one it loads much faster.): 4. Now I will need to enter the percentage of the scroll I have, along with the quantity: 5. After I do that, I can see the total value of my Claw scrolls, along with the grand total of everything I have entered into the sheet so far: If I want to prioritize which scrolls to add to my shop first, I will simply sort column F from Z-A, to bring the largest total values to the top of the list. Conversely, if you want to go quality over quantity, sort by column E to get the most valuable individual scrolls: And there you have it! I hope this helps others manage their inventory of scrolls like it has for me. It's a bit time consuming to add them all to this list, but I think it's worth it. It sure helps when you have an inventory of 100 scrolls and want to sell the most valuable ones first. If you have any trouble send me a PM or reply here and I'll do my best to help.
