From: Spencer_Lists <lists@...>
To: Kay Gould <disklavier@yahoogroups.com>
Sent: Wednesday, September 23, 2009 1:50:26 PM
Subject: Re: [disklavier] combined spreadsheet of the 2002, 2004, 2006 ande 2009 files [1 Attachment]
[Attachment(s) from Spencer_Lists included below]
Greetings Kay,
not planning on uploading it but can. i just merged your list with mine and made the formats uniform so we both have file
name with year appended to work with my programs. i forget what yamaha did from year to year but i thought that they always
had names first, last. at some point i switched them with a perl script and hand edited the stuff that was too strange to do
automatically. when i merge the lists i see that we have virtually the same data in every field so maybe you started with
something that i gave to someone at some point and might have been posted. it looks like both of our lists are too similar to
be a coincidence. i will be switching first,last to last first in the 2009 entries either with the script, if i can find it, or just by
copying yours over to mine. for now, here is the xls as it is now. you are welcome to use the 2008 data. at some point we should agree
on a format and make both of our lists the same. now that i think of it, i think i did share my list after i had done just years 2002 to 2006
which is probably what you got and might be why you are missing 2008. in this exs my stuff is the yellow highlighted.
Wednesday, September 23, 2009, 9:46:13 AM, you wrote:
I am planning to add the 2008 files, but haven't had the opportunity and time yet. But may be I can profit from your work. So, are you planning to upload your 2008 spreadsheet?
best regards
________________________________
From: Spencer_Lists <lists@spencerseroll s.com>
To: gould2802 <disklavier@yahoogro ups.com>
Sent: Wednesday, September 23, 2009 6:26:42 PM
Subject: Re: [disklavier] combined spreadsheet of the 2002, 2004, 2006 ande 2009 files
Greetings gould2802,
what about 2008? wish i had found these files a few days ago. i separately extracted all the data from the Yamaha site and pasted it in to a spreadsheet. i also have 2008. i downloaded all the files that are still available in hi res format and added the year to the file name to distinguish some that would be ambiguous as the same performer was in more than one year of comps. my spreadsheet can be used to add MIDI keywords to the files and once converted to MP3 to play on the LX system, MP3 tags can be added.i will compare your list to mine as a check on accuracy of copying from the site. is this the way you did it? i also prefer your last, first name as opposed to the way it is on the site. i will probably convert mine as i have a script somewhere that converts first,last to last, first but it might not work with some of the hyphenated names.
is there some reason that 2008 is missing?
Wednesday, September 23, 2009, 6:52:04 AM, you wrote:
Find a combined spreadsheet of the midi files of the competitions of 2002, 2004, 2006, 2009 See in "Files > e-Competition" .
The midi files can be find here:
http://www.piano- e-competition. com/ecompetition /midi_2002. asp
http://www.piano- e-competition. com/ecompetition /midi_2004. asp
http://www.piano- e-competition. com/ecompetition /midi_2006. asp
http://www.piano- e-competition. com/ecompetition /midi_2009. asp
Downloading is quite easy using a download manager (like for instance Reget Deuxe)
--
Best regards,
Spencer_Lists Chase mailto:lists@ spencerserolls. com
67550 Bell Springs Rd.
Garberville, CA 95542 Postal service only.
Laytonville, CA 95454 UPS only.
Lists@spencerseroll s(dot)com
http://www(dot)spencerserolls .com
replace (dot) with a .
(707) 984-8356
--
Best regards,
Spencer_Lists Chase mailto:lists@ spencerserolls. com
67550 Bell Springs Rd.
Garberville, CA 95542 Postal service only.
Laytonville, CA 95454 UPS only.
Lists@spencerseroll s(dot)com
http://www(dot)spencerserolls .com
replace (dot) with a .
(707) 984-8356