Auto-Schedule Generator Excel Macro

Octagon Software


1. Description

The Schedule Generator Excel Macro is a project I worked on with two other CS students as a sample of Microsoft Excel macros, for a Professional Communications class.  The project grew into a handy utility to generate a weekly schedule sheet of classes, and it has saved me much time and hassle ever since.  I've decided to make it freely publicly available so that other people may use it as well.

2. Screen Shot


 

3. Disclaimer

THE AUTO-SCHEDULE GENERATOR EXCEL MACRO IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MARK ROTH DISCLAIMS ALL WARRANTIES, EITHER EXPRESSED OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO EVENT SHALL MARK ROTH BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MARK ROTH HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

4. Usage Instructions

To use the Auto-Schedule Generator Excel Macro, you must have the following: To use the macro, download the spreadsheet by right-clicking the link in the next section and selecting "Save Link As..."  Save the spreadsheet in a folder on your hard drive and open it in Microsoft Excel*.  Once the spreadsheet is open, Excel* may warn you that there are Macros in the spreadsheet.  You must click "Enable Macros" for this spreadsheet to work.

Once the spreadsheet is downloaded and opened in Excel, simply fill in your class name, building, room, days, time from, and time to for each of your classes, type in a title for the spreadsheet, and click the "Generate!" button.  The schedule will be generated.  Click the print icon or select Print from the File menu to print your schedule.

To reuse the spreadsheet, click the "Reset Sheet" button.  This will clear out all the information you have entered and allow you to start over again.

5. Download

To download the Auto-Schedule Generator Excel Spreadsheet, right click on the following link, and select "Save Link As."  Choose any folder on your hard drive or a floppy or zip disk.  To run the macro, extract scheduler.xls from the zip file, and load up Microsoft Excel* and open the scheduler.xls file (be sure to select "Enable Macros").  See previous paragraph for more details.

6. Final Notes

This program was created by Mark Roth, a student at the Rochester Institute of Technology in Rochester, NY.  If you have any questions, comments, suggestions, or bug reports, please do not hesitate to contact me.  My contact information is as follows:

        Mark Roth
        Rochester Institute of Technology
        E-mail: markroth8@yahoo.com



* Microsoft Excel is a registered trademark of Microsoft Corp.

Last Updated: December 6, 1998