Hi, for my Class I have to develop an excel program that would help a college student. I decided to make a program that would generate all the possible schedules of classes they could take.
I have already designed a dialog and basic code to have someone input the all the class information needed to generate the schedules. Now I am stuck on the algorithm part to have the computer generate the schedules. I can do it it in my head but I am not knowledgeable enough to translate this into VBA code to execute it.
For example the classes look like this: Headers are (Class Number, Class Section, Name, Days, Start, End)
1301 01 Business Calc MWF 8:00 AM 8:50 AM
1301 02 Business Calc MWF 9:00 AM 9:50 AM
1301 03 Business Calc MW 8:00 AM 9:45 AM
1301 01 Accounting MWF 9:00AM 9:50 AM
1301 02 Accounting MWF 10:00 AM 10:50 AM
ect...
so pretty much, I would like it to generate all possible schedules without including classes of the same category or scheduling classes within the same time period.
I would like to be able to have it generate schedules for 15 possible classes but only scheduling 4 classes a day.
I understand the code will be lengthy so I dont expect full code, but I would appreciate a template or code to get me started on the right algorithm path.
Bookmarks