ComicsPriceGuide.com Forums - CPG - Questions and Answers - Download Collection to Excel - Sorting Question - Messages https://www.comicspriceguide.com/forum/messages.aspx?TopicID=13941 ComicsPriceGuide.com Forums - CPG - Questions and Answers - Download Collection to Excel - Sorting Question - Messages en-us http://blogs.law.harvard.edu/tech/rss Jitbit AspNetForum Mon, 03 Feb 2020 08:08:10 GMT Mon, 03 Feb 2020 08:08:10 GMT https://www.comicspriceguide.com/forum/messages.aspx?TopicID=13941 Message from kds_comics pukie2122 wrote:
Hello. When I download my collection to Excel, is there some way to change each grade to the numerical value? For example, change Fine to 6.0?


And is there some way to filter out books below a certain grade? For example, separate all books below 8.0?



Reason - I have a large collection which is growing. I want to keep better grade books, and complete the runs in better grade. So I'd like to generate a list - missing issues plus issues I need to buy in better grade.


And I want to sell off lower grade books. Maybe about 2,000 books. So I'd like to generate a sell-list to offer out for sale - issue number, grade, dollar value.


The information is all there on the Excel download. Can we arrange this information this way?

Thanks in advance for any advice.



The easy way to group your books is to use the "Comic Box" feature - put all of the comics you want to sell in one 'virtual' comic box.

Then they can be exported (file printed) to a PDF as one unit - then you can copy / paste the PDF and eventually get into excel or other usable format. Not a clean process.


Excel only exports by publisher. See other forum posts for discussion on that - several long running requests to export to excel in a different manor.

KDS
edited by kds_comics on 2/3/2020]]> Mon, 03 Feb 2020 08:08:10 GMT https://www.comicspriceguide.com/forum/messages.aspx?TopicID=13941 Message from Jayc13 Thu, 30 Jan 2020 16:27:38 GMT https://www.comicspriceguide.com/forum/messages.aspx?TopicID=13941 Message from Spidey63 Thu, 30 Jan 2020 16:12:14 GMT https://www.comicspriceguide.com/forum/messages.aspx?TopicID=13941 Message from aarondawe
For the grade to numerical value, you could sort the results by the grade value and then replace them with the corresponding numerical value. You can also use this sort to identify which books are under a certain grade, as they'll be sorted in grade order.

Aaron]]> Thu, 30 Jan 2020 11:08:52 GMT https://www.comicspriceguide.com/forum/messages.aspx?TopicID=13941 Message from Spidey63

And is there some way to filter out books below a certain grade? For example, separate all books below 8.0?



Reason - I have a large collection which is growing. I want to keep better grade books, and complete the runs in better grade. So I'd like to generate a list - missing issues plus issues I need to buy in better grade.


And I want to sell off lower grade books. Maybe about 2,000 books. So I'd like to generate a sell-list to offer out for sale - issue number, grade, dollar value.


The information is all there on the Excel download. Can we arrange this information this way?

Thanks in advance for any advice.]]> Thu, 30 Jan 2020 10:19:45 GMT