Howdy,
Yeah the title's a doozy but let me explain:
I'm trying to develop an auto-sked excel file for my place of work where a weekly schedule is gen'd up that accounts for what training events, lesson topics, briefs, etc. get performed every day. The training is conducted by instructors who achieve the proper qualifications to teach, instruct, proctor, or oversee that particular event.
It's extremely time consuming on our skeds (schedules) department to do all this for all of the instructors and events. I had an idea that would make the process far more streamlined, the "auto-sked" (I haven't thought of a clever name for it yet).
The idea is, for example, a drop down menu on the top of the Monday Column allows the sked writer to select the event/topic/etc. The cell next to it would then ultimately auto-populate a name from a database, on a separate sheet, of instructors that are cross checked with their qualifications.
I've managed to figure out how to play with INDIRECT but I'm trying to avoid excessive drop-down lists and instead get this project to an "auto" kind of method.
This would also eventually have to check for double names for instructors that are multi-qualified or if instructors have appointments listed (appointments, leave, etc. would also be an input at a section at the bottom of the sked template) so that it doesn't place an instructor teaching a course while they have a medical appointment or something of the like.
I know what I want to get this thing to do, I just don't know how to get this thing to find the instructors associated with a specific qualification that is based off of the initial drop down menu item, select a random instructor from that qualified list, and make sure not to "double-book" anybody.
Like I mentioned I know this isn't a simple question but any help, to even a piece of this jig-saw puzzle would be greatly appreciated.
Very respectfully,
Cody Chase
Yeah the title's a doozy but let me explain:
I'm trying to develop an auto-sked excel file for my place of work where a weekly schedule is gen'd up that accounts for what training events, lesson topics, briefs, etc. get performed every day. The training is conducted by instructors who achieve the proper qualifications to teach, instruct, proctor, or oversee that particular event.
It's extremely time consuming on our skeds (schedules) department to do all this for all of the instructors and events. I had an idea that would make the process far more streamlined, the "auto-sked" (I haven't thought of a clever name for it yet).
The idea is, for example, a drop down menu on the top of the Monday Column allows the sked writer to select the event/topic/etc. The cell next to it would then ultimately auto-populate a name from a database, on a separate sheet, of instructors that are cross checked with their qualifications.
I've managed to figure out how to play with INDIRECT but I'm trying to avoid excessive drop-down lists and instead get this project to an "auto" kind of method.
This would also eventually have to check for double names for instructors that are multi-qualified or if instructors have appointments listed (appointments, leave, etc. would also be an input at a section at the bottom of the sked template) so that it doesn't place an instructor teaching a course while they have a medical appointment or something of the like.
I know what I want to get this thing to do, I just don't know how to get this thing to find the instructors associated with a specific qualification that is based off of the initial drop down menu item, select a random instructor from that qualified list, and make sure not to "double-book" anybody.
Like I mentioned I know this isn't a simple question but any help, to even a piece of this jig-saw puzzle would be greatly appreciated.
Very respectfully,
Cody Chase
