Spreadsheet: 756732d1637743683-want-to-generate-individual-examination-timetable-for-students-timetable-for-individual-student
Sheet: allsub

SN | index no | class | NAME | ENGLISH | FRENCH | MATHS | ADD MATHS | ENGLISH LIT | FRENCH LIT | SOCIOLOGY | [NAME] | ACCOUNTS | ART | TRAVEL N TOURISN | COMPUTER | PHYSICS | CHEMISTRY | BIOLOGY | DC | DT | ENTERPRISE | PHYSICAL EDUCATION | BUSINESS ST | MARATHI | chinese | HINDI | [NAME] | ARABIC | TELEGU | URDU |  |  |  |  |  | Time table forexams
1 | G10/001 | 10E | name1 | 23 | 45 | 61 |  |  |  | 76 | 54 | 47 |  |  | 76 |  |  |  |  |  |  |  | 62 |  |  |  |  |  |  |  |  |  |  | Class | Type | Day | Time
2 | G10/002 | 10E | [NAME] | 45 | 35 | 21 |  | 13 |  | 18 | 41 |  |  |  | 22 |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  | english | paper 1 | 2020-12-28 00:00:00 | 12.00-13.00
3 | G10/003 | 10T | name3 | 54 | 70 | 68 | 32 |  |  |  |  |  | 35 |  | 56 | 50 |  |  |  | 67 |  |  |  |  |  |  |  |  |  |  |  |  |  | english | paper 2 | 2020-12-29 00:00:00 | 08.00-09.00
4 | G10/004 | 10EA | name4 | 51 | 55 | 40 |  |  | 40 |  |  | 40 |  | 55 |  |  |  |  |  |  |  | 35 | 45 |  |  |  |  |  |  |  |  |  |  | english | oral | 2020-12-30 00:00:00 | 12.00-13.00
5 | G10/005 | 10EA | name5 | 35 | 48 | 14 |  | 13 | 43 |  |  | 30 |  | 44 |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  | french | paper 1 | 2020-12-31 00:00:00 | 12.00-13.00
6 | G10/006 | 10EA | name6 | 49 | 47 | 5 |  |  |  | 21 |  | 42 |  | 61 |  |  |  |  |  |  |  | 52 | 19 |  |  |  |  |  |  |  |  |  |  | french | paper 2 | 2021-01-01 00:00:00 | 08.00-09.00
7 | G10/007 | 11 E | name7 | 34 | 45 | 22 |  |  |  | 31 | 30 | 49 |  |  | 32 |  |  |  |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  | french | oral | 2021-01-02 00:00:00 | 12.00-13.00
8 | G10/008 | 10EA | name8 | 44 | 53 | 28 |  |  |  |  |  | 58 |  | 42 | 22 |  |  |  |  |  |  | 47 | 22 |  |  |  |  |  |  |  |  |  |  | maths | paper 1 | 2021-01-03 00:00:00 | 12.00-13.00
9 | G10/009 | 10 ST | name9 | 55 | 48 | 67 | 29 |  |  |  |  |  |  |  | 61 | 41 | 35 | 69 |  |  |  |  |  |  |  |  | 34 |  |  |  |  |  |  | maths | paper 2 | 2021-01-04 00:00:00 | 08.00-09.00
10 | G10/010 | 10T | name10 | 52 | 73 | 26 |  |  |  | 56 |  |  | 51 |  | 66 | 54 |  |  |  | 66 |  |  |  |  |  |  |  |  |  |  |  |  |  | maths | paper 3 | 2021-01-05 00:00:00 | 12.00-13.00
11 | G10/011 | 10E | name11 | 68 | 68 | 89 | 78 |  | 63 |  | 74 | 72 |  |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  | chemistry | paper 1 | 2021-01-06 00:00:00 | 12.00-13.00
12 | G10/012 | 10EA | name12 | 44 | 59 | 4 |  |  | 49 |  |  | 51 |  | 45 |  |  |  |  |  |  |  | 45 | 30 |  |  |  |  |  |  |  |  |  |  | chemistry | paper 2 | 2021-01-07 00:00:00 | 08.00-09.00
13 | G10/013 | 12 E | name13 | 47 | 42 | 69 | 48 |  |  |  | 59 | 64 |  |  | 81 |  |  |  |  |  |  |  | 56 |  |  |  |  |  |  |  |  |  |  | chemistry | paper 3 | 2021-01-08 00:00:00 | 12.00-13.00
14 | G10/014 | 10T | name14 | 66 | 66 | 27 |  |  |  | 35 |  |  | 25 |  | 41 | 45 |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  | physics | paper 1 | 2021-01-09 00:00:00 | 12.00-13.00
15 | G10/015 | 10 ST | [NAME] | 58 | 39 | 48 | 21 |  |  |  |  |  |  |  | 66 | 40 | 23 | 42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | physics | paper 2 | 2021-01-10 00:00:00 | 08.00-09.00
16 | G10/016 | 10 ST | [NAME] | 60 | 55 | 54 | 16 |  |  |  |  |  | 60 |  | 64 | 40 |  |  |  | 44 |  |  |  |  |  |  |  |  |  |  |  |  |  | physics | paper 3 | 2021-01-11 00:00:00 | 12.00-13.00
17 | G10/017 | 10T | name17 | 50 | 61 | 50 | 24 |  |  |  |  |  | 40 |  | 42 |  |  |  |  | 57 |  |  | 3 |  |  |  |  |  |  |  |  |  |  | sociology | paper 1 | 2021-01-12 00:00:00 | 12.00-13.00
18 | G10/018 | 10T | name18 | 57 | 74 | 45 | 28 |  |  |  |  | 47 |  |  | 53 | 42 |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  | sociology | paper 2 | 2021-01-13 00:00:00 | 08.00-09.00
19 | [NAME] | 10E | name19 | 26 | 24 | 40 |  |  |  | 26 | 31 |  |  | 50 |  |  |  |  |  |  | 17 | 38 |  |  |  |  |  |  |  |  |  |  |  | sociology | paper 3 | 2021-01-14 00:00:00 | 12.00-13.00
20 | G10/020 | 13 E | name20 | 68 | 67 | 95 | 94 |  |  |  | 84 | 89 |  |  | 84 |  |  |  |  |  |  |  | 78 |  |  |  |  |  |  |  |  |  |  | add maths | paper 1 | 2021-01-15 00:00:00 | 12.00-13.00
21 | G10/021 | 10 ST | [NAME] | 60 | 43 | 52 | 22 |  |  |  |  | 40 |  |  |  | 40 | 31 | 61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add maths | paper 2 | 2021-01-16 00:00:00 | 08.00-09.00
22 | G10/022 | 10EA | name22 | 43 | 57 | 4 |  |  |  |  | 32 | 11 |  | 31 | 14 |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  | accounts | paper 1 | 2021-01-17 00:00:00 | 12.00-13.00
23 | G10/023 | 10E | name23 | 49 | 30 | 40 |  |  |  | 30 | 46 |  |  |  |  |  |  |  |  |  | 54 | 34 | 40 |  |  |  |  |  |  |  |  |  |  | accounts | paper 2 | 2021-01-18 00:00:00 | 12.00-13.00
24 | G10/024 | 10 ST | name24 | 52 | 43 | 4 |  | 24 |  | 25 |  |  | 51 |  | 26 |  |  |  |  |  |  |  | 28 |  |  |  |  | 45 |  |  |  |  |  | english literature | paper 1 | 2021-01-19 00:00:00 | 08.00-09.00
25 | G10/025 | 10 ST | name25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | english literature | paper 2 | 2021-01-20 00:00:00 | 12.00-13.00
26 | G10/026 | 10EA | [NAME] | 52 | 46 | 6 |  |  |  | 52 | 31 | 48 |  | 51 |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  | add maths | paper 1 | 2021-01-21 00:00:00 | 08.00-09.00
27 | G10/027 | 10EA | name27 | 58 | 62 | 28 |  |  |  | 51 | 49 | 50 |  | 66 |  |  |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  | add maths | paper 2 | 2021-01-22 00:00:00 | 12.00-13.00
28 | G10/028 | 10 ST | name28 | 57 | 53 | 71 | 8 |  |  |  |  |  | 40 |  | 66 | 40 |  |  |  | 54
29 | G10/029 | 10 ST | name29 | 60 | 51 | 53 | 17 |  |  |  |  |  |  |  | 44 | 25 | 28 |  |  |  |  |  |  |  |  | 58
30 | G10/030 | 10 ST | name30 | 70 | 64 | 91 | 86 |  |  |  |  |  |  |  | 81 | 80 | 61 |  |  | 63
31 | [NAME] | 10EA | name31 | 42 | 55 | 12 |  |  | 52 |  |  | 9 | 41 | 36 |  |  |  |  |  |  |  |  | 21
32 | G10/032 | 10 ST | name32 | 43 | 43 | 11 |  |  |  | 18 |  |  | 62 |  | 18 |  |  |  |  | 40 |  |  | 12
33 | G10/033 | 10EA | name33 | 37 | 54 | 4 |  |  |  | 35 |  | 34 |  | 25 |  |  |  |  |  |  |  | 30 | 12
34 | G10/034 | 10T | [NAME] | 57 | 70 | 64 | 34 |  |  |  |  |  |  |  | 48 | 48 |  |  |  | 56 |  | 55
35 | G10/035 | 10T | name35 | 69 | 71 | 44 |  |  |  |  |  | 40 |  |  | 58 | 49 |  |  | 43
36 | G10/036 | 10T | name36 | 59 | 60 | 40 | 21 |  |  |  |  | 50 |  |  | 58 | 45 |  |  | 54
 |  |  | Total of students
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | want to generate an exam timetable  will do a mail merge to generate it
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for example
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | name1 is doing maths english french sociology economics accounts computer and business
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | so depending on subject will need to pull out the data from the time table
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | would be much appreciate if details for student be in a row format so that it will be easier for the mail merge
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | also some subjects have 3 papers and some subjects have 2 papers will need to cater for this also