Repertoire-Grade Spreadsheet

[Torp]

I know, I know, repetoire grading as a topic has gotten the crap beat out of it on this forum, so read on.

I have spent the last several weeks going through virtually every post I could find in this forum that indicated the grades of pieces of music. (yeah, I know, my employers would be so proud)  I took this data and compiled it into an excel spreadsheet.  The spreadsheet lists the grade, composer, and title.  Along with this, there are also cells for technical comments, i.e. what is the main technical difficulty, etc., and there is a cell for general comments.

I took the liberty of copying the comments that people made about specific pieces when they were providing the grades.  In all honesty, 99.9% of all the comments and data come from Bernhard. (Bernhard, if you have any issues with me copying your comments and putting them in this spreadsheet, please let me know, I'll remove that column from "distribution")

There are approximately 1300 pieces listed.  I make no gaurantees that there aren't duplicates or errors.

Oh, I also included a sheet that has all of the Scarlatti Sonatas listed with both Kirkpatrick and Longo designations.  There is a formula that allows you to enter the K# and it will spit out the L#.  If you don't know how to use the formula, you can always just scroll down and find the reference.

The spread sheet is designed so that you can select by grade, by composer, or by both.  Anyway, it's pretty straight forward.

If anyone is interested in a copy of this spreadsheet let me know.

A couple of items:
First: I make no claims that any of the grading is my own; I just put what was already in this forum into a spreadsheet.  In other words, if you don't agree with the grading of a piece, use your number pad on your keyboard and change the cell, problem fixed.   I believe that Bernhard's source for most of the grading is ABSRM, but you'd have to check with him specifically.

Second: It's a work in process.  It has reached a point where it has enough information and is in a format that I think may be useful to people who want to further customize it to their tastes, or to simply use "as is" as a reference.

Third: If a grade was given as a "+", i.e 7+, 8+, etc., I rounded down and put it as a 7 or 8, etc.  Additionally, if I found conflicts in the grading of pieces, I kept the lower grading.

If you request a copy of this, please let me know what version of Excel you're running so I can save the file accordingly.  I have the latest version and I don't know what its backwards compatability is.

My email is posted in my profile.

Let me know if there is any interest.

Jef

[Motrax]

If you send me the file (the_tzarr@yahoo.com) I can host it and post a link here for everyone.

[Torp]

If you send me the file (the_tzarr@yahoo.com) I can host it and post a link here for everyone.

Awesome.  I'll get it to you later today.

Jef

[pseudopianist]

I love you!!

pogotrucci@gmail.com

[mikeyg]

That is awesome.  I'll take one.  I have Office 2000 premium.

mikeyg@pianomail.net

Thanks

[Torp]

I sent the file to Motrax.  It will be downloadable for everyone as soon as Motrax puts up the link.

Jef

Thanks again, Motrax.

[Motrax]

My online server space seems to be dead right now... it's been having a lot of trouble lately - I'll try to post it as soon as I can. Sorry for the delay everyone. 

[Chrysalis]

Either

Cakehole_@hotmail.com or MaartenTUmmers@gmail.com

[00range]

 

Thank you so much for your time, I'd like to get added to the mailing list...

nightcap@worldpath.net

[Torp]

My online server space seems to be dead right now... it's been having a lot of trouble lately - I'll try to post it as soon as I can. Sorry for the delay everyone. 

No worries...I've sent the file to everyone above this message.  Hopefully I can keep up!

btw...you're all welcome.  I don't really feel the thanks should come to me though, the amount information provided on this forum by other members is utterly astonishing.

Jef

[shhpf]

id like one too please!

racasti@gmail.com

[00range]

Hey, don't sell yourself short man. Sifting through all those posts alone would be amazing, organizing them all is something else. Looks great!

[Mayla]

Uh... me too please ?  Thank you   

maylafox@yahoo.com

[delpetrarca]

me too me too! thank you so much!!!!!!!

alla_marcia@hotmail.com

[musicsdarkangel]

you are awesome, seriously.


kingsha@yahoo.com or sranney@iwu.edu

[BoliverAllmon]

you are awesome, seriously.


kingsha@yahoo.com or sranney@iwu.edu

awesome and appartently full of time on your hands.

[dinosaurtales]

Can you stand to send one more?

mindy@dinosaurtales.com

[chopinisque]

Could someone just put it online so that everyone could download it themselves?

[Torp]

Could someone just put it online so that everyone could download it themselves?

Motrax is working on it.  If someone else wants to host it let me know.  I don't have that capability myself.

I believe I have sent out the file to everyone above this message.  If I somehow missed someone, let me know.

Jef

[Chrysalis]

many many thanks (Y)

[Motrax]

Well, not only is my host server apparently dead all-of-a-sudden, but the internet in my room died as well! (I'm posting from a library) So if someone else could host the file, that'd probably be easier. Apologies for making everyone wait around for me. 

[nilsjohan]

No problem, I will put it up here on our server as soon as Torp sends me the file.

[nilsjohan]

You can now nowload the file from here:

http://pianoforum.net/Graded_Pieces_All.xls

 

[Torp]

Thanks a million Johan.

Jef

[Ziggy]

Cool.

I think the Chopin 2nd sonata needs to be a 10 instead of a 7 though. 

[BoliverAllmon]

Cool.

I think the Chopin 2nd sonata needs to be a 10 instead of a 7 though. 

and let the debate wars begin. 

[Chrysalis]

and so on and so forth

reverie - 7
schumann arabesque - 7
lied ohne worte 19:1 - 7
142:2 schubert - 7
Mazurka 68:3 is more like 6/7 instead of 4

bla as he said change it yourself

hehe but its a nice list thank you very much

[Torp]

I can claim complete ignorance.  Afterall, the grading came from ABSRM via Bernhard.

Uh....yeah....it's his fault....I'm innocent!!

Jef

[Steve T]

  Thank you very, very, very much. This is sooooooo useful.
Did I say thank you? Thank you 

[goose]

Thank you, Jef. And I thought I was obsessed with organizing things in Excel! What a great resource.

And thanks, nilsjohan, for making it available.

[Torp]

You're all very welcome.  Glad I could give something back.

I wanted to add something:

I had put in a column in the spreadsheet called OrSor, this stands for original sort.  The purpose for this column was so I could always go back to the beginning if I had to.  Additionally, it attempted to serve the purpose of keeping things in order when looking at grouped pieces, i.e. Bach's French and English Suites come to mind.

In retrospect, this column may be superfluous, but I wanted to let you all know why it was there.  I would cause no problems getting rid of it that I can see.

What can I say, my AR nature is showing through.

Jef

[ujos3]

Torp:

¡¡¡¡¡¡¡¡¡¡¡THANKS!!!!!!!!!!

[Ed Marlo]

This is the best use of a Microsoft Office program I've ever seen.  Woo! 

Only thing I can spot is the numberings/namings of some of Beethoven's sonatas.  I always thought Moonlight was 14, Pastorale 15?  Not that it matters in the slightest - great job!

[Torp]

This is the best use of a Microsoft Office program I've ever seen.  Woo! 

Only thing I can spot is the numberings/namings of some of Beethoven's sonatas.  I always thought Moonlight was 14, Pastorale 15?  Not that it matters in the slightest - great job!

If I remember correctly on the Beethoven Sonatas, Bernhard had listed them in ascending order of difficulty.  I kept his numbering scheme, that way if you pulled up Grade 6, for example, you would get the Sonatas in ascending order of difficulty for that grade.

In reviewing the spread sheet after reading your post I did find that Sonata "#3" is formatted slightly different than the other Sonatas i.e. is says 3 instead of 03.  This means it will be "Out of order" in the sequence because of the way Excel sorts.

If anyone cares to fix this do the following:
1) Add a zero right before the 3
2) Select all the data in all the fields
3) Go to Data-Sort and sort by Composer (Ascending), Composition (Ascending), and OrSor (Ascending)

The above should "fix" the problem.  Man, that takes about a nanosecond to do and forever to write it out.

Jef

[beethoartok]

Is there anyway possible for me to view thisw spreadsheet without Excel? All I have is Microsoft works, and it isn't compatible 

[George K]

Allow me to join the legions of posters who have thanked you for this Herculean effort.

Simply amazing!


Thanks again,



George

[marialice]

Great work, thank you so much!

Is there anyway possible for me to view thisw spreadsheet without Excel? All I have is Microsoft works, and it isn't compatible 

There is an Excel viewer you can download from Microsoft. Just take a look here: http://www.microsoft.com/downloads/search.aspx?displaylang=en&categoryid=9 .

[galonia]

Try openoffice.org

Freeware word processing, spreadsheet and presentation software, can save things as Microsoft Office files, so you can edit (which you can't do if you just use a freeware Excel viewer)

[Hmoll]

Torp,

Thanks for all the hard work. This is a very valuable and useful spreadsheet.