Instruction for Routine Verification Tool ========================================= BASIC-INPUT Sheet: ------------------ 1. First Enter name of the teaching staffs (max limit 75) from Cell M3 onwards, Sl No will be automatically populated.. 2. Check the Autogenerated Initials/short names, if any duplicate (Highlighted) found Change Y to N in the respective Cell (S1) to enter manual Short Name of all staff. 3. You can change number of classes permissible given subject wise and class wise if required (in the blue coloured table). CLASS-INPUT Sheet: ------------------- 1. Teachers' names will be automatically populated from the previous sheet. 2. Now enter class, sec & subject in the format CLASS SEC-SUBJECT (eg., X A-BNGA) 3. So, Give space between Class & Section and hyphen (-) between class sec & Subject. 4. As per above format allot class to each teacher as required. If any duplication (same class and subject twice) found in the same day those cells will be highlighted. Then you can delete any one. 5. SUBJECT CODES are predefined as given in the BASIC-INPUT Sheet. Use only those codes. TEACHER-INDV Sheet: ------------------- 1. Here you will get the out put of the classes of the selected (Select any teacher in the A7 cell) teacher. CLASS-WISE Sheet: ----------------- 1. Enter Class Section in the Yellow coloured cell. 2. Classes alloted will be automatically populated. 3. Below the weekly routine Highlighted ALLOTTED cell direct you - if highlighted green then classes due as per permissible, if red then it indicates more than permissible class entered. Then looking weekly allotment you can change the allotted class. so, this tool will help you to make ERROR FREE Weekly Class Routine.