yogi_Dealing With Rock Climb Data In Yosemite Decimal Scale Convert Raw Data Into A Format To Enable Numerical Processing

                                         Google Spreadsheet   Post  #1586
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-02-2014
post by mrl491(https://productforums.google.com/forum/#!mydiscussions/docs/gDwYzcH09qg)
Is it possible to enter a new format for numerical values?

 am creating a rock climbing log that I am going to use to log everything I climb. Please see the linked document below. 

https://docs.google.com/spreadsheets/d/1Q-rwKV1YTM80cdLGD9_ZJZqGeavI43U0yDGIqwewFmg/edit?usp=sharing

The difficulty grades for rock climbs are not in a standard numerical format but a rather different one. It goes as follows 5.0, 5.1, 5.2, 5.3..........5.10a, 5.10b, 5.10c, 5.10d , 5.11a, 5.11b, 5.11c, 5.11d, all the way through 5.15d.

Would it be possible to use these diffuculty grade formats in my formulas and cells? I would love to be able to automatically show the hardest grade that I have climbed or the percentage of my climbs that were 5.12s, etc. 

Thanks,
Matt

--------------------------------------------------------------------------------------------------------------------------------------------------