Page 1 of 2

Edison Diamond Discs in Excel Spreadsheet

Posted: Wed Feb 04, 2009 11:41 am
by Valecnik
A few years ago somebody posted to the web a large excel file containing a pretty comprehensive list of Diamond Discs you could sort by number, title and artist. I lost the link to the site when my pc crashed sometime back. Does anyone know about this and if so, know how to find it? Thanks, Bruce

Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Wed Feb 04, 2009 12:03 pm
by Valecnik
This is it. Thanks alot. A great resource for those of you who may not be familiar with it! Cheers, Bruce

Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Wed Feb 04, 2009 12:28 pm
by MordEth
I got sidetracked in the middle of replying to this, but here is that spreadsheet, with some improvements on their formatting, compressed as a .zip file.

The difference between theirs and the attached is not all that big, but it makes the information easier to read, and I wanted to try attaching something other than an image for a change. ;)

Edit: Version 2.0:

You can now use the ‘Line #’ to reset the row order after using the auto-filter option shown here:

Image

Their data could use additional clean-up (which would make filtering/sorting it more useful in some cases), but it is now easy to filter and sort, in addition to searching.

As always, if you have any questions or if I can assist you in any way, please let me know.

— MordEth


Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Thu Feb 05, 2009 6:22 am
by MordEth
Please note that the archive above has been updated...and here is a combined spreadsheet, with one tab of discs, and another of cylinders.

— MordEth


Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Sun Feb 03, 2013 1:29 pm
by crumpybumpy
WOW!!!! I had no idea this existed! I've been manually copying all of this off my discs and trying to figure out the recording date using books. How do you all use this spreadsheet to mark off the discs that you personally own?

Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Sun Feb 03, 2013 1:35 pm
by Valecnik
I've used this extensively.

I'm sure there are better ways but I've set up an excel spreadsheet and cut and paste the matching coupling numbers over. It still take a huge amount of time but I've logged about 500 discs in this manner.

Using it for cylinders is also helpful but even more of a pain. Any dubbed BA cylinders show up on the disc tab, not the cylinder tab and the numbers also do not sort properly so it can be a bit of a hunt but still a great tool.

Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Fri Jan 22, 2016 9:10 am
by BwanaJoe
MordEth wrote:I got sidetracked in the middle of replying to this, but here is that spreadsheet, with some improvements on their formatting, compressed as a .zip file.

The difference between theirs and the attached is not all that big, but it makes the information easier to read, and I wanted to try attaching something other than an image for a change. ;)

Edit: Version 2.0:

You can now use the ‘Line #’ to reset the row order after using the auto-filter option shown here:

Image

Their data could use additional clean-up (which would make filtering/sorting it more useful in some cases), but it is now easy to filter and sort, in addition to searching.

As always, if you have any questions or if I can assist you in any way, please let me know.

— MordEth

Thanks! Why the A, B, C after the numbers? Different versions or different pressings?

Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Fri Jan 22, 2016 11:08 am
by winsleydale
IIRC, there were three takes done of many or all selections.

Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Fri Jan 22, 2016 3:52 pm
by 52089
winsleydale wrote:IIRC, there were three takes done of many or all selections.
I'll pick a nit here and note that there were usually at least three released takes for most recordings. You'll find info on many more unreleased takes in the spreadsheet. Also, many had more than three released takes when the masters wore out and remakes were needed. These have higher take letters, again, usually in threes: F/G/H, J/K/L, etc.

Re: Edison Diamond Discs in Excel Spreadsheet

Posted: Fri Jan 22, 2016 4:57 pm
by BwanaJoe
52089 wrote:
winsleydale wrote:IIRC, there were three takes done of many or all selections.
I'll pick a nit here and note that there were usually at least three released takes for most recordings. You'll find info on many more unreleased takes in the spreadsheet. Also, many had more than three released takes when the masters wore out and remakes were needed. These have higher take letters, again, usually in threes: F/G/H, J/K/L, etc.
So I'm assuming an A take will be better than a B take? And the later releases sounding less good due to being dubbed from dubs? Like the last run of casting when the mold has worn out?