Thanks to Emily Heiner at Whatcom College for supplying the Decode Formula below
[per Emily's Information: 5/6/2011]
In essence, it can take an input like B012 and get the following information:
Academic Year Start: 2010
Academic Year End: 2011
Quarter Number: 2
Quarter Name: Fall
Basically, they are using Base36 on the first digit to get around Y2K, which gives a range of the year 1900 to the year 2259 (YRQ of Z999). The Breakdown of the 4 digit YRQ is as follows:
Digit 1: The decade indicator (in Base36). Anything numeric is in the 1900’s, once you hit ‘A’ you are at the year 2000. ‘B’ is 2010, ‘C’ will be 2020
Digit 2: The last digit of the academic year start. In the example above (B012), that would be the ‘0’. Add Digit 1 and 2 together and you get 2010.
Digit 3: The last digit of the academic year end. In the example above (B012), that would be the ‘1’. Add Digit 1 and 3 together and you get 2011.
Digit 4: The quarter number. Fairly self-explanatory. 1=Summer, 2=Fall, 3=Winter, 4=Spring
The formula that I used (roughly) is:
• Start with the number 2000
• Convert the first digit of the YRQ from Base36 to Base10 and subtract 11 to get the decade multiplier
o Subtracting 11 makes the letter A equal 0 instead of 11 (0 through 9 are now -0 through -9)
• Multiply the decade multiplier by 10, add it to the starting number of 2000, and then add the second digit of the YRQ and you get the school year that the quarter starts.
• Do the same exact equation, except use the third digit of the YRQ instead of the second digit to get the year that the quarter ends.
o The one exception is when the decade rolls over, so I do a test when the second digit is greater than the third digit. If it is, then I add 10 to the final result to bump it up to the next decade
• The fourth digit of the YRQ is the quarter