Ask the community for help and advice here
|
Spidey63 Posts: 100
1/30/2020
|
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.
|
|
|
0
link
|
|
aarondawe Posts: 162
1/30/2020
|
There's ways you can do this in Excel.
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
|
|
|
0
link
|
|
Spidey63 Posts: 100
1/30/2020
|
Good ideas. Thanks for your help.
|
|
|
0
link
|
|
Jayc13 Posts: 55
1/30/2020
|
what's the easiest way to download export the Excel file? I still can't get it to work properly.
|
|
|
0
link
|
|
kds_comics Posts: 686
2/3/2020
|
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
|
|
|
+1
link
|
