Piano Forum logo
September 23, 2017, 12:13:21 AM *
   Forum Home   Help Search  


Pianistic Legends from Buenos Aires Sharing Neurones
A recent article featured in Piano Street’s News Flash explains that four-hand piano duo partners share neurons dealing with spatial seizing while playing. That suggests that we give you readers a gem on the same topic. Watch the sample from Michael Beyer’s film production for EuroArts Music. Read more >>
Pages: [1] 2   Go Down
  Print  
Author Topic: Repertoire-Grade Spreadsheet  (Read 22169 times)
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« on: March 09, 2005, 03:34:03 PM »
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. Wink  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
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
Motrax
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 721
« Reply #1 on: March 09, 2005, 03:57:25 PM »
If you send me the file (the_tzarr@yahoo.com) I can host it and post a link here for everyone. Smiley
Do you find this post useful? Yes / No
Logged
"I always make sure that the lid over the keyboard is open before I start to play." --  Artur Schnabel, after being asked for the secret of piano playing.
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #2 on: March 09, 2005, 04:14:49 PM »
Quote from: Motrax on March 09, 2005, 03:57:25 PM
If you send me the file (the_tzarr@yahoo.com) I can host it and post a link here for everyone. Smiley

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

Jef
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
pseudopianist
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 607
« Reply #3 on: March 09, 2005, 05:07:02 PM »
I love you!!

pogotrucci@gmail.com
Do you find this post useful? Yes / No
Logged
Whisky and Messiaen
mikeyg
Guest
« Reply #4 on: March 09, 2005, 05:47:49 PM »
That is awesome.  I'll take one.  I have Office 2000 premium.

mikeyg@pianomail.net

Thanks Grin
Do you find this post useful? Yes / No
Logged
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #5 on: March 09, 2005, 09:20:25 PM »
I sent the file to Motrax.  It will be downloadable for everyone as soon as Motrax puts up the link.

Jef

Thanks again, Motrax.
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
Motrax
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 721
« Reply #6 on: March 09, 2005, 10:26:01 PM »
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.  Undecided
Do you find this post useful? Yes / No
Logged
"I always make sure that the lid over the keyboard is open before I start to play." --  Artur Schnabel, after being asked for the secret of piano playing.
Chrysalis
Full Member
***
Offline Offline

Posts: 191
« Reply #7 on: March 09, 2005, 10:59:12 PM »
Either

Cakehole_@hotmail.com or MaartenTUmmers@gmail.com
Do you find this post useful? Yes / No
Logged
Debussy Rox! Debussy Rox! Debussy Rox!
00range
PS Silver Member
Full Member
***
Offline Offline

Posts: 177
« Reply #8 on: March 09, 2005, 11:10:42 PM »
 Shocked

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

nightcap@worldpath.net
Do you find this post useful? Yes / No
Logged
'Science is interesting, and if you don't agree, you can *** off.'
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #9 on: March 09, 2005, 11:35:58 PM »
Quote from: Motrax on March 09, 2005, 10:26:01 PM
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.  Undecided

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
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
shhpf
PS Silver Member
Newbie
***
Offline Offline

Posts: 3
« Reply #10 on: March 10, 2005, 12:37:58 AM »
id like one too please!

racasti@gmail.com
Do you find this post useful? Yes / No
Logged
00range
PS Silver Member
Full Member
***
Offline Offline

Posts: 177
« Reply #11 on: March 10, 2005, 02:36:55 AM »
Hey, don't sell yourself short man. Sifting through all those posts alone would be amazing, organizing them all is something else. Looks great!
Do you find this post useful? Yes / No
Logged
'Science is interesting, and if you don't agree, you can *** off.'
Mayla
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 6638
« Reply #12 on: March 10, 2005, 02:50:09 AM »
.
Do you find this post useful? Yes / No
Logged
"The greatest thing in this world is not so much where we are, but in what direction we are moving"  ~Oliver Wendell Holmes
delpetrarca
Jr. Member
**
Offline Offline

Posts: 40
« Reply #13 on: March 10, 2005, 02:58:47 AM »
me too me too! thank you so much!!!!!!!

alla_marcia@hotmail.com
Do you find this post useful? Yes / No
Logged
musicsdarkangel
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 976
« Reply #14 on: March 10, 2005, 04:33:33 AM »
you are awesome, seriously.


kingsha@yahoo.com or sranney@iwu.edu
Do you find this post useful? Yes / No
Logged
BoliverAllmon
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 4157
« Reply #15 on: March 10, 2005, 04:46:06 AM »
Quote from: musicsdarkangel on March 10, 2005, 04:33:33 AM
you are awesome, seriously.


kingsha@yahoo.com or sranney@iwu.edu

awesome and appartently full of time on your hands.
Do you find this post useful? Yes / No
Logged
dinosaurtales
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 1139
« Reply #16 on: March 10, 2005, 06:12:37 AM »
Can you stand to send one more?

mindy@dinosaurtales.com
Do you find this post useful? Yes / No
Logged
So much music, so little time........
chopinisque
PS Silver Member
Full Member
***
Offline Offline

Posts: 227
« Reply #17 on: March 10, 2005, 07:14:14 AM »
Could someone just put it online so that everyone could download it themselves?
Do you find this post useful? Yes / No
Logged
Mad about Chopin.
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #18 on: March 10, 2005, 02:39:08 PM »
Quote from: Chopinisque on March 10, 2005, 07:14:14 AM
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. Sad

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

Jef
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
Chrysalis
Full Member
***
Offline Offline

Posts: 191
« Reply #19 on: March 10, 2005, 03:36:45 PM »
many many thanks (Y)
Do you find this post useful? Yes / No
Logged
Debussy Rox! Debussy Rox! Debussy Rox!
Motrax
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 721
« Reply #20 on: March 10, 2005, 04:53:43 PM »
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.  Sad
Do you find this post useful? Yes / No
Logged
"I always make sure that the lid over the keyboard is open before I start to play." --  Artur Schnabel, after being asked for the secret of piano playing.
nilsjohan
Administrator
Sr. Member
******
Offline Offline

Posts: 1599
« Reply #21 on: March 10, 2005, 04:57:02 PM »
No problem, I will put it up here on our server as soon as Torp sends me the file.
Do you find this post useful? Yes / No
Logged
nilsjohan
Administrator
Sr. Member
******
Offline Offline

Posts: 1599
« Reply #22 on: March 10, 2005, 05:30:58 PM »
You can now nowload the file from here:

http://pianoforum.net/Graded_Pieces_All.xls

 Smiley
Do you find this post useful? Yes / No
Logged
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #23 on: March 10, 2005, 05:36:11 PM »
Thanks a million Johan.

Jef
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
Ziggy
Jr. Member
**
Offline Offline

Posts: 66
« Reply #24 on: March 10, 2005, 08:24:06 PM »
Cool.

I think the Chopin 2nd sonata needs to be a 10 instead of a 7 though.  Grin
Do you find this post useful? Yes / No
Logged
BoliverAllmon
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 4157
« Reply #25 on: March 10, 2005, 09:14:45 PM »
Quote from: Ziggy on March 10, 2005, 08:24:06 PM
Cool.

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

and let the debate wars begin.  Grin
Do you find this post useful? Yes / No
Logged
Chrysalis
Full Member
***
Offline Offline

Posts: 191
« Reply #26 on: March 10, 2005, 09:49:11 PM »
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 Smiley

hehe but its a nice list thank you very much Smiley
Do you find this post useful? Yes / No
Logged
Debussy Rox! Debussy Rox! Debussy Rox!
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #27 on: March 10, 2005, 11:42:10 PM »
I can claim complete ignorance.  Afterall, the grading came from ABSRM via Bernhard.

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

Jef
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
Steve T
Jr. Member
**
Offline Offline

Posts: 49
« Reply #28 on: March 11, 2005, 02:16:32 AM »
 Smiley Wink Cheesy Thank you very, very, very much. This is sooooooo useful.
Did I say thank you? Thank you  Smiley Wink Cheesy
Do you find this post useful? Yes / No
Logged
goose
PS Silver Member
Full Member
***
Offline Offline

Posts: 101
« Reply #29 on: March 11, 2005, 11:03:59 AM »
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.
Do you find this post useful? Yes / No
Logged
Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes. - Jack Handey
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #30 on: March 11, 2005, 03:00:08 PM »
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. Grin

Jef
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
ujos3
Jr. Member
**
Offline Offline

Posts: 42
« Reply #31 on: March 11, 2005, 06:41:35 PM »
Torp:

¡¡¡¡¡¡¡¡¡¡¡THANKS!!!!!!!!!!
Do you find this post useful? Yes / No
Logged
Ed Marlo
Jr. Member
**
Offline Offline

Posts: 35
« Reply #32 on: March 11, 2005, 07:27:32 PM »
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!
Do you find this post useful? Yes / No
Logged
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #33 on: March 11, 2005, 08:38:33 PM »
Quote from: Ed Marlo on March 11, 2005, 07:27:32 PM
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. Tongue

Jef
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
beethoartok
Jr. Member
**
Offline Offline

Posts: 55
« Reply #34 on: March 13, 2005, 07:12:40 PM »
Is there anyway possible for me to view thisw spreadsheet without Excel? All I have is Microsoft works, and it isn't compatible  Cry
Do you find this post useful? Yes / No
Logged
gkatele
PS Silver Member
Full Member
***
Offline Offline

Posts: 210
« Reply #35 on: March 13, 2005, 09:14:44 PM »
Allow me to join the legions of posters who have thanked you for this Herculean effort.

Simply amazing!


Thanks again,



George
Do you find this post useful? Yes / No
Logged
=-=-=-=-=-=-=-=-=-=-=-=-=
"Outside of a dog, a book is man's best friend.
Inside of a dog, it's too dark to read."
=-=-=-=-=-=-=-=-=-=-=

Groucho Marx
marialice
PS Silver Member
Jr. Member
***
Offline Offline

Posts: 43
« Reply #36 on: March 14, 2005, 07:35:02 AM »
Great work, thank you so much!

Quote from: beethoartok on March 13, 2005, 07:12:40 PM
Is there anyway possible for me to view thisw spreadsheet without Excel? All I have is Microsoft works, and it isn't compatible  Cry
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 .
Do you find this post useful? Yes / No
Logged
galonia
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 472
« Reply #37 on: March 14, 2005, 07:39:05 AM »
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)
Do you find this post useful? Yes / No
Logged
Hmoll
Sr. Member
****
Offline Offline

Posts: 881
« Reply #38 on: March 14, 2005, 04:25:17 PM »
Torp,

Thanks for all the hard work. This is a very valuable and useful spreadsheet.
Do you find this post useful? Yes / No
Logged
"I am sitting in the smallest room of my house. I have your review before me. In a moment it will be behind me!" -- Max Reger
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #39 on: March 14, 2005, 10:41:01 PM »
Quote from: beethoartok on March 13, 2005, 07:12:40 PM
Is there anyway possible for me to view thisw spreadsheet without Excel? All I have is Microsoft works, and it isn't compatible  Cry

I can/have converted it to a Word file if that would help.  It certainly isn't as user friendly as in Excel, but at least you'd have it.

Send me an email, jeftorp@bc.com if this will help.

To everyone, again, you're welcome.  I'm glad I could provide something useful.

Jef
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
BoliverAllmon
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 4157
« Reply #40 on: March 15, 2005, 01:52:07 PM »
thanks for the spreadsheet for sure. I do have a question though. The gymnopecies are label level 6 or something (if I remember correctly). Is this technically or musically. To me this piece sounds, looks, and so far is extremely easy.
Do you find this post useful? Yes / No
Logged
Torp
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 785
« Reply #41 on: March 15, 2005, 02:49:13 PM »
Quote from: BoliverAllmon on March 15, 2005, 01:52:07 PM
thanks for the spreadsheet for sure. I do have a question though. The gymnopecies are label level 6 or something (if I remember correctly). Is this technically or musically. To me this piece sounds, looks, and so far is extremely easy.

You'd have to ask Berhard for sure, or possibly a search on the forum would lead you to the answer.  However, if my memory serves me, it's rated more difficult for musical rather than technical reasons.

I think the spread sheet is only a compilation of someone's ideas about a piece.  If you find the piece to be easier than indicated, change the grade to whatever you believe it should be.  This was designed as a tool and a reference to be used individually, not as "THE" reference for grades.  Once everyone starts using the spreadsheet for themselves, we may all end up with very different, very personal grades, as all the heated threads dealing with grades on this forum would suggest. Grin

Jef
Do you find this post useful? Yes / No
Logged
Don't let your music die inside you.
ujos3
Jr. Member
**
Offline Offline

Posts: 42
« Reply #42 on: March 15, 2005, 04:20:33 PM »
Quote
I think the spread sheet is only a compilation of someone's ideas about a piece.  If you find the piece to be easier than indicated, change the grade to whatever you believe it should be.  This was designed as a tool and a reference to be used individually, not as "THE" reference for grades.  Once everyone starts using the spreadsheet for themselves, we may all end up with very different, very personal grades, as all the heated threads dealing with grades on this forum would suggest.

Anyway, technically and musically I think all the Beethoven Sonatas placed in Grade 7
(Pathetique, Pastorale and so forth) should be at least in Grade 8 or 9...

I can't imagine someone levelled on Grade 7 playing the Pathetique...!!!

And the Spreadsheet you posted is so useful that it will be taken as a reference by many people here. May be we should agree in a future version 2.0 with some changes...Thanks again
Do you find this post useful? Yes / No
Logged
BoliverAllmon
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 4157
« Reply #43 on: March 15, 2005, 11:25:16 PM »
Quote from: Torp on March 15, 2005, 02:49:13 PM


You'd have to ask Berhard for sure, or possibly a search on the forum would lead you to the answer.  However, if my memory serves me, it's rated more difficult for musical rather than technical reasons.

I think the spread sheet is only a compilation of someone's ideas about a piece.  If you find the piece to be easier than indicated, change the grade to whatever you believe it should be.  This was designed as a tool and a reference to be used individually, not as "THE" reference for grades.  Once everyone starts using the spreadsheet for themselves, we may all end up with very different, very personal grades, as all the heated threads dealing with grades on this forum would suggest. Grin

Jef
the reason why I ask is that I have to play the first one at school and don't know grades really at all. I have always been curious what grade I actually am.

boliver
Do you find this post useful? Yes / No
Logged
BoliverAllmon
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 4157
« Reply #44 on: August 17, 2005, 06:46:26 PM »
bump
Do you find this post useful? Yes / No
Logged
ptmidwest
PS Silver Member
Full Member
***
Offline Offline

Posts: 216
« Reply #45 on: August 20, 2005, 03:08:24 AM »
Thanks for the bump, Boliver...if you hadn't done that I might have missed this.

THANKS, Torp.
Do you find this post useful? Yes / No
Logged
BoliverAllmon
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 4157
« Reply #46 on: August 20, 2005, 12:21:17 PM »
your welcome
Do you find this post useful? Yes / No
Logged
Mayla
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 6638
« Reply #47 on: August 08, 2006, 01:55:57 AM »
.
Do you find this post useful? Yes / No
Logged
"The greatest thing in this world is not so much where we are, but in what direction we are moving"  ~Oliver Wendell Holmes
nicco
PS Silver Member
Sr. Member
***
Offline Offline

Posts: 1191
« Reply #48 on: August 10, 2006, 10:23:55 AM »
Quote from: Mayla on August 08, 2006, 01:55:57 AM
I miss Torp  Cry

Where did he go?
Do you find this post useful? Yes / No
Logged
"Without music, life would be a mistake." - Friedrich Nietzsche
Mayla
PS Gold Member
Sr. Member
*****
Offline Offline

Posts: 6638
« Reply #49 on: August 13, 2006, 02:45:43 PM »
.
Do you find this post useful? Yes / No
Logged
"The greatest thing in this world is not so much where we are, but in what direction we are moving"  ~Oliver Wendell Holmes
Pages: [1] 2   Go Up
  Print  


Need more info or help?


Search pianostreet.com - the web's largest resource of information about piano playing:



 
Jump to:  


Most popular classical piano composers:
Bach - Beethoven - Chopin - Mozart
Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!


Piano Forum - Copyright © 2001-2013 - Op 111 Productions
o