Once you have enabled the macros UTT is ready in your service.
(To know how to enable the macros refer "Getting started" section of "Chapter 1: Introduction." or click here.)
STEP 1: To create a time table click on the "NEW" button.
STEP 2: UTT will then prompt another window with 3 options.
STEP 3: Let's assume that you are using it for the first time so you need to select the factory reset option.
This will again prompt you to key in an authentication code. The authentication code is just another security level to prevent actidental data loss.
Key in the authentication code and it will navigate you to the basic input sheet.
STEP 4: Fill in the details as desired in the BASIC INPUT sheet and click on the next button.
STEP 5: The next sheet will ask you about the Teacher Details. Just fill the details as below and click on next.
STEP 6: The next sheet will ask you about the Class and section details. Fill in the details as below and click next.
STEP 7: The next sheet will ask you about the Subject Details. Fill in the details and click next.
(Note: Any Teacher type subjects are those, UTT will take the previllage to assign them to the teachers with least number of periods as per its own AI)
STEP 8: The next sheet will be about CCA or other common periods. Fill in the details and click next.
STEP 9: Next you will have to furnish the number of periods per subject per week and click next.
STEP 10: It will then prompt you about the total number of periods of different classes. Just go through it and if everything is fine then click OK.
STEP 11: Next you will furnish the details of block periods if any. It is very important here that you furnish the frequency of block periods.
STEP 12: Next sheet is all about the Distribution of Subjects. After you have filled all details click next.
(Note: If a subject is of Specific Teacher Only type then you will have to specify the teacher for the subject.
How ever if it is Any Teacher type subject then you can leave it blank. UTT will use its own intelligence to assign then to different teachers.)
STEP 13: When you click on the Next button it'll prompt you a window showing an estimate of number of periods assigned to different teachers. Check it carefully if the periods assigned are rational.
STEP 14: Click on the OK button and you will be navigated to the MASTER TIME TABLE (MTT) sheet. If you reached the MTT sheet, it means you have filled all the required details and you are ready to create you time table.
STEP 15: Click on the Create button and it will prompt you a warning message just to ensure that you have not accidentally hit the create button.
STEP 16: After you click OK, UTT will start creating the time table. You can view the progress and relax.
Once it is done you will get a confirmation message.
And bingo..... You have successfully created the time table.
(To know how to enable the macros refer "Getting started" section of "Chapter 1: Introduction." or click here.)
STEP 1: To create a time table click on the "NEW" button.
STEP 2: UTT will then prompt another window with 3 options.
STEP 3: Let's assume that you are using it for the first time so you need to select the factory reset option.
This will again prompt you to key in an authentication code. The authentication code is just another security level to prevent actidental data loss.
Key in the authentication code and it will navigate you to the basic input sheet.
STEP 4: Fill in the details as desired in the BASIC INPUT sheet and click on the next button.
STEP 5: The next sheet will ask you about the Teacher Details. Just fill the details as below and click on next.
STEP 6: The next sheet will ask you about the Class and section details. Fill in the details as below and click next.
STEP 7: The next sheet will ask you about the Subject Details. Fill in the details and click next.
(Note: Any Teacher type subjects are those, UTT will take the previllage to assign them to the teachers with least number of periods as per its own AI)
STEP 8: The next sheet will be about CCA or other common periods. Fill in the details and click next.
STEP 9: Next you will have to furnish the number of periods per subject per week and click next.
STEP 10: It will then prompt you about the total number of periods of different classes. Just go through it and if everything is fine then click OK.
STEP 11: Next you will furnish the details of block periods if any. It is very important here that you furnish the frequency of block periods.
STEP 12: Next sheet is all about the Distribution of Subjects. After you have filled all details click next.
(Note: If a subject is of Specific Teacher Only type then you will have to specify the teacher for the subject.
How ever if it is Any Teacher type subject then you can leave it blank. UTT will use its own intelligence to assign then to different teachers.)
STEP 13: When you click on the Next button it'll prompt you a window showing an estimate of number of periods assigned to different teachers. Check it carefully if the periods assigned are rational.
STEP 14: Click on the OK button and you will be navigated to the MASTER TIME TABLE (MTT) sheet. If you reached the MTT sheet, it means you have filled all the required details and you are ready to create you time table.
STEP 15: Click on the Create button and it will prompt you a warning message just to ensure that you have not accidentally hit the create button.
STEP 16: After you click OK, UTT will start creating the time table. You can view the progress and relax.
Once it is done you will get a confirmation message.
And bingo..... You have successfully created the time table.
Dear Sir, after downloading the excel sheet, all the icons are not working.
ReplyDeletePlease enable the macros & the icons will work.
ReplyDeleteTo know how to do that please refer CHAPTER 1: INTRODUCTION.
Hello, kudos for putting this together.
ReplyDeleteHowever, my MS excel keeps crashing once I try to save work done and this means almost going back to the point where I was able to save last.
Is there a way I can fix this please?
Hello, kudos for putting this together.
ReplyDeleteHowever, my MS excel keeps crashing once I try to save work done and this means almost going back to the point where I was able to save last.
Is there a way I can fix this please?
Also when I click create on the Master time table page, the periods allotted stops at 119/1086 (10.96%) and Microsoft excel stops responding.
ReplyDeletePlease is there a solution to this?
Why 1st period is not allotted to class teacher for everyday?
ReplyDeleteThe problem has been sorted out in 4.8 and later versions. Thanks
DeleteGREAT WORK SIR. I WILL START NOW TO WORK. ANY DIFFICULTIES PLEASE ATTEND TO REPLY SIR
ReplyDeleteSure..
DeleteGreat work sir.
ReplyDeleteThank you very much.
Sir,time table software which I have is not a macro enabled workbook then how will macro work?....if possible plz give your working contact number for WhatsApp so that I can share my time table software.
ReplyDelete