"What have I got, and what have I not?"
Answered
23/11/2014
Ref. my post of 01/09/14,
"What have I got, and what have I not?" A couple of weeks ago I finally 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 the database to answer the principal question of the above-mentioned post, the question which prompted me to buy the database in the first place: - How many of the tracks on six ten-CD sets I bought did I already have?
I was able to do this by: -
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.
(This sort also showed up 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 imported to 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.
11. Doing a bit of simple arithmetic (below).
I was able to do this by: -
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.
(This sort also showed up 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 imported to 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.
11. Doing a bit of simple arithmetic (below).
I found there were 85 tracks I already had.
There were also 30 tracks which appeared on more than one compilation.
I guess it's fair enough if e.g. Brenda Lee's "Jambalaya" is included in both the "Rock 'n' Roll Girls" and "Rock-a-Billy Cowboys" sets.
There were also 30 tracks which appeared on more than one compilation.
I guess it's fair enough if e.g. Brenda Lee's "Jambalaya" is included in both the "Rock 'n' Roll Girls" and "Rock-a-Billy Cowboys" sets.
The Arithmetic
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 per CD.
Since 5 boxes were 20 tracks a disc, and one was 25 a disc:
A total of 1250 tracks bought at $120 = 9.6 cents per track.
Since I already had 85, and also there were 30 duplications within the sets:
A total of 1250 - (85 + 30) = 1135 new tracks gained at $120 = 10.57 cents per track.
Or, since I paid $120 for 1250 tracks but only got 1135 new to me, 115/1250 of $120 = $11.04 I lost, or 9.2%
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 per CD.
Since 5 boxes were 20 tracks a disc, and one was 25 a disc:
A total of 1250 tracks bought at $120 = 9.6 cents per track.
Since I already had 85, and also there were 30 duplications within the sets:
A total of 1250 - (85 + 30) = 1135 new tracks gained at $120 = 10.57 cents per track.
Or, since I paid $120 for 1250 tracks but only got 1135 new to me, 115/1250 of $120 = $11.04 I lost, or 9.2%
At these prices I don't think I should be heartbroken at this massive 9.2% reduction in value to me!