Ask the community for help and advice here
|
glennsim Posts: 33
9/12/2016
|
I've been poking around, but I can't find any way to see my collection in order of current value, or a way to export in a way that could be sorted. Like if I wanted to take additional steps to protect my most valuable comics. Is there any way to do this?
|
|
|
0
link
|
|
glennsim Posts: 33
9/13/2016
|
Well, I figured out a really crappy workaround, but just in case someone else is interested:
1. Go to your collection, where it is divided by publisher. You will have to do this separately for each publisher, or possibly copy together all of the separate spreadsheets.
2. Click on Raw to generate the download.
3. Retrieve your Excel file, open in Excel.
3.5 You may have to copy all of the data to a new sheet without formatting, to get rid of merged cells before trying to sort.
4. Add a new column down the left side. Use the Fill > Series function to number all of the rows 1 to whatever going down.
5. Now sort the columns by what should now be the "G" column, that has the individual issue values in it. Descending, if you want the highest ones at the top.
6. You may have to scroll down but you'll eventually find the highest dollar figures starting, and then they go downward.
7. For the books you are interested in, change the font color of the value field (or any number of fields on that row).
8. Go back and resort the entire list based on that first column, descending. This puts everything back in the original order.
9. Now you can scroll through and look for the items with the different font color.
3.75 (Optional) create all of your individual spreadsheets and copy paste them all into one, with each one below the other, where the fields all line up. This lets you get information from more than one publisher into one sort.
7.5 (Optional) Add a new field on the right side where you do another fill from 1 to whatever for the items that have dollar figures. Then, when you are finished, you will have a ranking of each book for its value in the collection.
CPG - if you could just do a version of the spreadsheet that repeats the title on each line, that would make this much much easier.
|
|
|
+2
link
|
|
netstuffers Administrator Posts: 239
10/3/2016
|
Thanks for the feedback, I'm passing this to the dev team!
|
|
|
+1
link
|
