automated work schedule generator

[pipsmultan]

Respectable Greetings to all Excel Guru, Expert, Contributor, and every one

I am running into big problem and challenge

I have two sheets called “Timetable” sheet & “Teachers Details” sheet. what i am trying to accomplish is to generate auto Timetable Randomly, but i m confuse and not getting any idea + solution how it will done..

i want to pick data/details from “Teachers Details” sheet and create automated timetable in “Timetable” sheet so that my huge time which is wasted to create manually timetable can be safe.

plz see the excel attachment
Time table high school.xls

Image of my excel work
Sample Timetable.jpg


right now i am creating timetable manually
Now here is how it works:
1. you click on any cell where you want to create a new course. You set it as you wish regarding the merged cells prior to click on the button.
2. you click on the button which will open a userform divided in 3 sections First part is the matter of the course. You write directly in the texbox (like Math or Bio or Physics). Second part is the teachers' selection. it is a listbox that allow multiple selection. You hold the CTRL key and click on as many teachers as you like. Thrid part is the location of the course. You write directly into the textbox.
3. when you are done, you click on the left button at the bottom to transfer all the information into the selected cell. The macro will add a line feed between each section.

i dont know will “VB/Macro Code” will do it or excel Formula will solve it

ANY help from any one will be great help and highly appreciated

Best Regards

[brokenbiscuits]

Maybe it's just me, but it seems really unclear exactly what you want to achieve.

[pipsmultan]

Maybe it's just me, but it seems really unclear exactly what you want to achieve.

Thanks there is someone

Ok i try to make it more clear and simple to understand

i have reattach the excel sheet by make it more understandable. what i m try to achieve.
I have 2 sheet in my excel file

1. Teachers Details (Sheet).
2. Timetable (Sheet)

Plz find the new attach excel file
Time table high school_V1.xls

Now i am trying to achieve is when anyone enter the detail of a teacher in Teachers Details (Sheet) with the following credential like (which subjects he can teach, which classes he can teach, and in which periods). Excel auto generate timetable from the following given details.

1. Teaching Subject
2. Teachers Name
3. Enter Teaching Class
4. Enter Period (Optional)

plz also see the image file
Sample Timetable_ v1.jpg

hope i am able make it understandable, if still not let me know plz.

Best Regards

[pipsmultan]

bump no reply

[pipsmultan]

bump no reply

[p24leclerc]

It is impossible to do what you want with your actual data structure and I have doubt about its feasibility even with a new structure.

Can you have your teacher's details in the following form with only one subject, one class and one period per row?
Column A Column B Column C Column D
Teaching subject - Teacher's name - Teaching class - Period

If you have more than one teacher for a class put the 2 names in the teacher's name cell.
You need to have one row per subject, class and period.
Even then, I'm not sure it is possible.

How often do you have to create such a timetable?
In the timetable, I can see 3 subjects in the same class and others have only one or two. How is this possible? They are all at the same period.

Your process is not clear enough. I'm sure we're missing a lot of information here.

[pipsmultan]

Your process is not clear enough. I'm sure we're missing a lot of information here.

Happy to see you almost after a year

I have just schedule a meeting with my course coordinator head’s today , bcz you are right i m might missing a lot of information in timetable. I will be in a meeting with them and i discuss all the questions & issues you mentioned.

I will get back to you after the meeting and will answer all the questions with in 24hurs. I am pretty sure we will be generating best timetable with your great efforts and new ideas.

your last work on "teachers class workload" is remarkable hit in our institute and it saves tones of our time. we all are grateful to you

Thanks;

Best Regards

[pipsmultan]

I hope this reply finds you great in health and spirits

sorry for very late reply as last few days was busy schedule and was not able to keep in-touch with you. Now i got free from School side bcz Summer vacation is ON. and school will be remain off for 1 month approx . In that time i will be completing this timetable with all your Help

How often do you have to create such a timetable?

Ans: timetable remains same every day of the week. But timetable only changes when any teachers left or hired.

In the timetable, I can see 3 subjects in the same class and others have only one or two. How is this possible? They are all at the same period

Ans: it is permissible to split a class into more than 3 subjects "on two conditions"
1. 1st condition is when Students hav option to choose subjects of their choice from given group. Students hav option to choose subjects of their choice from given group (Plz see the Syllabus "Excel file" which comprises of all the possible subjects and also optional Subjects)

e.g if any student want to study Science he can choose Any of One subject from (Biology OR Computer OR Electric Wiring) but class will conduct same time with their different respective subject teachers in different rooms. (Sorry after the meeting with our Course coordinator now it is change to Biology & Computer only. (Plz see the the Syllabus Excel file for further details)

2. Subjects are allowed to "clash" when we are shortage of teachers than we have to merge the classrooms of same subjects, like sometime we will merge Electric Wiring students of two classes (10th B & 9th B Teacher "Sir James" teaching two classes at a time.) in one Room with one Electric Wiring Teacher, so that students will not go free without class. (But this will not always the case with "Electric Wiring" subject it can be with any subjects)

that’s why in the 2nd period 10th-A have one teacher, but 10th-B have three teachers for different subjects (2nd period)

Plz see the Syllabus "Excel file" which comprises of all the possible subjects and also optional Subjects.
sylabus.xlsx


With some help i have this "summary of the Generic Model" of my timetable plz find the attachment
Model Spec.doc

i hope this will illustrate how the time table will be design and work after the code is written. plz be free to ask any confusions

thanks for taking time in my timetable issues, highly appreciating

High Regards

[p24leclerc]

HI,
from what I read here, I can't help you on this one.
Sorry about that.

[pipsmultan]

HI,
from what I read here, I can't help you on this one.
Sorry about that.

No problem, and thank you for taking the time to reply to my problem in such a prompt manner

Best Regards

[pipsmultan]

HI,
from what I read here, I can't help you on this one.
Sorry about that.

No problem, and thank you for taking the time to reply to my problem in such a prompt manner

Best Regards

[Mad Monk]

Any update on this issue?? have you managed any solution yet?

[Mad Monk]

Any solution you managed in all these years??

[pipsmultan]

Any solution you managed in all these years??

Hi,
How are you.
Please to see you after many years.
Unfortunately no solution yet.
Still doing it manually.

We can start over again on this if you have time

Kind Regards,