Ref. my post of
A couple of weeks ago I finished entering all my CDs to the database I bought.
Currently I have 251 albums totalling 393 discs.
I thought it was about time I used it to answer the above-mentioned post's principal question.
1. Setting the database view to one line per track.
2. Setting up the view with a column showing the number of discs in a set. (Ten in this case.
This allowed identification of the tracks which belonged to the six ten-CD sets I bought.)
3 Sorting the track view by Title.
5. Moving the "Number of Discs" column to sit next to the Title column.
4. Resorting to the eye-ometer method of scrolling down looking for titles with a "10" next to them,
and observing if there was another occurrence of the same title adjacent, and if so....
5. Using the "Edit on-screen" function, adding the words "Already have" to the Notes column.
Once I had noticed there were some instances of duplication within the CD sets, I kept a running total of those as well.
6. Setting up a filter to only show tracks with the words "Already have" in the Notes.
7. Using the data Export function to create a text file listing all the found titles, which could be
copied and pasted into a spreadsheet. (Microsoft Works Spreadsheet in my case.)
8. Eliminating all the unnecessary columns.
9. Taking a screen-shot of the database.
10. Posting it on THIS PAGE.
There were also 30 tracks which appeared on more than one compilation.
I guess it is fair enough if e.g. Brenda Lee's "Jambalaya" is included in both the "Rock 'n' Roll Girls" and "Rock-a-Billy Cowboys" collections.
Duplications of what I already have, initially estimated at "up to 20%", measured at only 6.8%
I bought 6x 10 CD boxes @ $20 each,
60 CDs at $120 = $2.00 each.
Since 5 boxes were 20 tracks a disc, and one was 25 a disc:
1250 tracks at $120 = 9.6 cents each.
Since I already had 85, and 30 were duplications within the sets:
1135 tracks at $120 = 10.57 cents each.
At these prices I don't think I should be heartbroken at this massive 9.2% reduction in value to me!