Class Schedule Generator

Posted on January 11th, 2013 by

This afternoon I was working on updating my class schedules for the Spring 2013 semester and wondered if others across campus were doing the same. Many things went through my mind during this time, but the 2 most relevant were (1) why are we all doing the same task when one person could figure out the dates and share them with everyone else and (2) dates are systematic so you could write a little formula to calculate them for you. To quell those thoughts, I made a google spreadsheet that currently has the dates and days for MWF, TTh, and MW classes during the Spring 2013, but it can also be used to generate dates for any future semester. You just need to change one of the dates in a green cell and the other cells will automatically update. You can find the Class Schedule Generator at Hope this helps, and let me know if you encounter any problems.

Screen shot 2013-01-11 at 1.51.34 PM



  1. Alisa says:

    I have wished for exactly this (and wondered why it didn’t exist and vowed that I would put it together and then not done so) on too many occasions to count. Thank you!

  2. Lisa Heldke says:

    Are you just the nicest and most selfless human on the planet, Kyle?