Edison Diamond Discs in Excel Spreadsheet

Discussions on Records, Recording, & Artists
User avatar
Valecnik
Victor VI
Posts: 3857
Joined: Sat Jan 10, 2009 3:28 pm
Personal Text: Edison Records - Close your eyes and see if the artist does not actually seem to be before you.
Location: Česká Republika
Contact:

Edison Diamond Discs in Excel Spreadsheet

Post 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

User avatar
Valecnik
Victor VI
Posts: 3857
Joined: Sat Jan 10, 2009 3:28 pm
Personal Text: Edison Records - Close your eyes and see if the artist does not actually seem to be before you.
Location: Česká Republika
Contact:

Re: Edison Diamond Discs in Excel Spreadsheet

Post by Valecnik »

This is it. Thanks alot. A great resource for those of you who may not be familiar with it! Cheers, Bruce

User avatar
MordEth
Victor IV
Posts: 1154
Joined: Wed Jan 07, 2009 1:01 pm
Personal Text: Contact me for TMF tech support.
Location: Boston, MA
Contact:

Re: Edison Diamond Discs in Excel Spreadsheet

Post 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

Attachments
edison_diamond_discs.zip
Edison Diamond Disc.xls, compressed as a .zip
(1.29 MiB) Downloaded 630 times
Proudly supporting phonograph discussion boards, hosting phonograph sites and creating phonograph videos since 2007.
Need web hosting or web (or other graphic) design? Support MordEth by using BaseZen Consulting for all of your IT consulting needs.
Want more phonograph discussion? Be sure to visit The Online Edison Phonograph Discussion Board.

User avatar
MordEth
Victor IV
Posts: 1154
Joined: Wed Jan 07, 2009 1:01 pm
Personal Text: Contact me for TMF tech support.
Location: Boston, MA
Contact:

Re: Edison Diamond Discs in Excel Spreadsheet

Post 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

Attachments
edison_discs_and_cylinders.zip
Edison Discs and Cylinders.xls compressed as a .zip
(2.08 MiB) Downloaded 505 times
Proudly supporting phonograph discussion boards, hosting phonograph sites and creating phonograph videos since 2007.
Need web hosting or web (or other graphic) design? Support MordEth by using BaseZen Consulting for all of your IT consulting needs.
Want more phonograph discussion? Be sure to visit The Online Edison Phonograph Discussion Board.

crumpybumpy
Victor Jr
Posts: 8
Joined: Sun Jun 17, 2012 4:42 pm

Re: Edison Diamond Discs in Excel Spreadsheet

Post 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?

User avatar
Valecnik
Victor VI
Posts: 3857
Joined: Sat Jan 10, 2009 3:28 pm
Personal Text: Edison Records - Close your eyes and see if the artist does not actually seem to be before you.
Location: Česká Republika
Contact:

Re: Edison Diamond Discs in Excel Spreadsheet

Post 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.

User avatar
BwanaJoe
Victor II
Posts: 278
Joined: Thu Nov 13, 2014 8:54 am
Location: Central Florida

Re: Edison Diamond Discs in Excel Spreadsheet

Post 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?

User avatar
winsleydale
Victor III
Posts: 709
Joined: Wed Dec 17, 2014 1:30 am
Personal Text: To be free is to be wealthy beyond measure
Location: Metro Detroit

Re: Edison Diamond Discs in Excel Spreadsheet

Post by winsleydale »

IIRC, there were three takes done of many or all selections.
Resist the forces of evil in all their varied forms.

52089
Victor VI
Posts: 3809
Joined: Mon Oct 03, 2011 7:54 pm

Re: Edison Diamond Discs in Excel Spreadsheet

Post 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.

User avatar
BwanaJoe
Victor II
Posts: 278
Joined: Thu Nov 13, 2014 8:54 am
Location: Central Florida

Re: Edison Diamond Discs in Excel Spreadsheet

Post 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?

Post Reply