Wednesday, April 2, 2014

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   Apr-02-2014
post by mrl491(!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. 

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.