{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Work Calendar","WTA 2","WTA3","Schools","Times"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":2,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Work Calendar","index":0,"n_rows":30,"n_cols":50,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,43,4,43],[3,44,4,44],[3,45,4,45],[3,46,4,46],[3,47,4,47],[3,38,4,38],[3,39,4,39],[3,40,4,40],[3,41,4,41],[3,42,4,42],[3,33,4,33],[3,34,4,34],[3,35,4,35],[3,36,4,36],[3,37,4,37],[3,28,4,28],[3,29,4,29],[3,30,4,30],[3,31,4,31],[3,32,4,32],[3,23,4,23],[3,24,4,24],[3,25,4,25],[3,26,4,26],[3,27,4,27],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[0,0,0,3],[0,4,0,6],[6,27,6,30],[6,40,6,43],[6,1,6,4],[6,5,6,9],[6,18,6,22],[6,23,6,26],[6,10,6,13],[6,14,6,17],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[0,9,0,12],[6,31,6,35],[6,36,6,39],[6,44,6,48],[6,49,7,49],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22]]}
["SCHOOL CALENDAR",null,null,null,"2024/25",null,null,null,"Establishment name:","School"]
["GRAND TOTAL",null,"Parents Meetings ",{"$f":"AX10","v":"00:00:00"},null,null,"Staff Meetings",{"$f":"AX12","v":"00:00:00"},null,"Reports/ Records",{"$f":"AX14","v":"00:00:00"},null,null,"Forward Planning",{"$f":"AX16","v":"00:00:00"},null,"Formal Assessment",{"$f":"AX18","v":"00:00:00"}]
[{"$f":"SUM(D2,H2,K2,O2,R2,D3,H3,K3,O3,R3)","v":"00:00:00"},null,"PRD",{"$f":"AX20","v":"00:00:00"},{"$f":"IF(D3<>(6/24),\"PRD MUST EQUATE TO 6 HOURS\",\" \")","v":"PRD MUST EQUATE TO 6 HOURS"},null,"Additional  Prep & Correction",{"$f":"AX22","v":"00:00:00"},null,"Curriculum Development",{"$f":"AX24","v":"00:00:00"},null,null,"Supervised Pupil Activities",{"$f":"AX26","v":"00:00:00"},null,"Flexibility",{"$f":"AX28","v":"00:00:00"}]
[null,{"$f":"IF((B30+C30)>(10/24),\"TWO WEEK CUMULATIVE HOURS EXCEEDS 10 HOURS.\",\"\")","v":""},{"$f":"IF((C30+D30)>(10/24),\"TWO WEEK CUMULATIVE HOURS EXCEEDS 10 HOURS.\",\"\")","v":""},{"$f":"IF((D30+E30)>(10/24),\"TWO WEEK CUMULATIVE HOURS EXCEEDS 10 HOURS.\",\"\")","v":""},{"$f":"IF((E30+F30)>(10/24),\"TWO WEEK CUMULATIVE HOURS EXCEEDS 10 HOURS.\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF((AV30+AW30)>(10/24),\"TWO WEEK CUMULATIVE HOURS EXCEEDS 10 HOURS.\",\"\")","v":""}]
[]
[null,{"$f":"IF(AND(B10=0,(B30>(5/24))),\"EXCEEDS 5 HOURS PLEASE ADJUST\",IF(AND(B10>0,(B30>(8/24))),\"EXCEEDS 8 HOURS PLEASE ADJUST\",\"\"))","v":""},{"$f":"IF(AND(C10=0,(C30>(5/24))),\"EXCEEDS 5 HOURS PLEASE ADJUST\",IF(AND(C10>0,(C30>(8/24))),\"EXCEEDS 8 HOURS PLEASE ADJUST\",\"\"))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Month","2024-08-01",null,null,null,"2024-09-01",null,null,null,null,"2024-10-01",null,null,null,"2024-11-01",null,null,null,"2024-12-01",null,null,null,null,"2025-01-01",null,null,null,"2025-02-01",null,null,null,"2025-03-01",null,null,null,null,"2024-04-01",null,null,null,"2024-05-01",null,null,null,"2024-06-01",null,null,null,null,"TOTAL"]
["Week begin",5,12,19,26,2,9,16,23,30,7,14,21,28,4,11,18,25,2,9,16,23,30,6,13,20,27,3,10,17,24,3,10,17,24,31,7,14,21,28,5,12,19,26,2,9,16,23,30]
["No. Working Days",0,5,5,5,5,5,5,4,4,5,0,5,5,5,5,5,5,5,5,5,0,0,5,5,5,5,5,5,3,5,5,5,5,5,5,0,0,4,5,4,5,4,4,5,5,5,3,0,{"$f":"SUM(B9:AW9)","v":195}]
["Parents Meetings ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B10:AW10)","v":0}]
["PM Notes"]
["Staff Meetings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["SM Notes"]
["Reports/ Records",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["R&R Notes"]
["Forward Planning",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FP Notes"]
["Formal Assessment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["FA Notes"]
["PRD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["PRD Notes"]
["Add  Prep +Correction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["AP&C Notes"]
["Curriculum Develop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["CD Notes"]
["Supervised Pupil Activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["SPA Notes"]
["Flexibility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Flex Notes"]
["WTA TOTAL",{"$f":"SUM(B10:B28)","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"SUM(B30:AW30)","v":"00:00:00"}]

{"sheet":"WTA 2","index":1,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Establishment Name:","School"]
[]
["Activity","Time Allocation (hours)  per session"]
["Parents Meetings ",{"$f":"'Work Calendar'!D2","v":0}]
["Staff Meetings",{"$f":"'Work Calendar'!H2","v":0}]
["Reports/ Records",{"$f":"'Work Calendar'!K2","v":0}]
["Forward Planning",{"$f":"'Work Calendar'!O2","v":0}]
["Formal Assessment",{"$f":"'Work Calendar'!R2","v":0}]
["PRD",{"$f":"'Work Calendar'!D3","v":0}]
["Add  Prep +Correction",{"$f":"'Work Calendar'!H3","v":0}]
["Curr Develop",{"$f":"'Work Calendar'!K3","v":0}]
["Supervised Pupil Activities",{"$f":"'Work Calendar'!O3","v":0}]
["Flexibility",{"$f":"'Work Calendar'!R3","v":0}]
["Total Number of Collegiate Hours",{"$f":"SUM(B4:B13)","v":0}]

{"sheet":"WTA3","index":2,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[31,1,31,8],[4,1,5,8],[7,4,7,5],[10,1,10,8],[12,1,12,4],[12,5,12,8],[19,1,23,8],[25,1,25,8],[27,1,27,4],[27,5,27,6],[28,1,28,4],[28,5,28,6],[43,1,44,4],[43,5,44,7],[43,8,44,8],[33,1,33,3],[33,4,33,7],[34,1,36,3],[34,4,36,7],[34,8,36,8],[38,1,38,8],[40,1,40,4],[40,5,40,7],[41,1,42,4],[41,5,42,7],[41,8,42,8],[49,1,50,4],[49,5,50,7],[49,8,50,8],[45,1,46,4],[45,5,46,7],[45,8,46,8],[47,1,48,4],[47,5,48,7],[47,8,48,8]]}
[]
[]
[]
[]
[null,"LOCAL AGREEMENT ON THE OPERATION OF THE 35 HOUR WORKING WEEK IN SCHOOLS AND SUPPORT SERVICES"]
[]
[]
[null,null,null,null,"2024/25"]
[]
[]
[null,"AGREEMENT FOR THE USE OF REMAINING TIME/COLLEGIATE ACTIVITIES"]
[]
[null,"School Name / Central Support Service:"]
[]
[null,"EMAIL COMPLETED WORKBOOK TO NATASHA.DAVIDSON@EASTDUNBARTON.GOV.UK"]
[null,"DEADLINE: FRIDAY 07 JUNE 2024"]
[null,"COPY BY EMAIL THE WORKING GROUP WHO AGREED TO THIS WTA"]
[null,"NO NEED FOR WET SIGNATURES, "]
[]
[null,"We confirm that the attached calendar and time allocation summary is accepted as the pattern for the working year for teaching emplloyees in this school/support service for school session 2024/25"]
[]
[]
[]
[]
[]
[null,"We confirm that the following forms have been appended to this Agreement:"]
[]
[null,"Collegiate Calendar Planning Form",null,null,null,"Work Calendar"]
[null,"Time Allocation Summary",null,null,null,"LNCT/WTA 2"]
[]
[]
[null,"Head Teacher / Central Support Service Manager"]
[]
[null,"Name",null,null,"Position",null,null,null,"Date"]
[]
[]
[]
[]
[null,"Teaching Employee Representative(s) / Trade Union Agreement"]
[]
[null,"Name",null,null,null,"Trade Union",null,null,"Date"]

{"sheet":"Schools","index":3,"n_rows":46,"n_cols":4,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
["Sector","School","Head Teacher","Position"]
["Primary","Baldernock Primary","Jill Carr","Head Teacher"]
["Primary","Baljaffray Primary","Lesley Rodden","Head Teacher"]
["Primary","Balmuildy Primary","Lorna Kenney","Head Teacher"]
["Primary","Bearsden Primary","Catriona Smith","Head Teacher"]
["Primary","Castlehill Primary","Mandy Thompson","Head Teacher"]
["Primary","Clober Primary","Cationa Marshall","Head Teacher"]
["Primary","Colquhoun Park Primary","Claire Loney","Head Teacher"]
["Primary","Craigdhu Primary","Lesley Davidson","Head Teacher"]
["Primary","Craighead Primary","Lynne Stewart","Head Teacher"]
["Primary","Gartconner Primary","Paul Manley","Head Teacher"]
["Primary","Harestanes Primary","Jacqueline Gillespie","Head Teacher"]
["Primary","Hillhead Primary","James Friel","Head Teacher"]
["Primary","Holy Family Primary","Andy Gallagher","Head Teacher"]
["Primary","Holy Trinity Primary","Grace McGill","Head Teacher"]
["Primary","Killermont Primary","Elspeth Smith","Head Teacher"]
["Primary","Lairdsland Primary","Martyn Glancy","Head Teacher"]
["Primary","Lennoxtown Primary","Rona Coughlan","Head Teacher"]
["Primary","Lenzie Meadow Primary","Sheona Allen","Head Teacher"]
["Primary","Meadowburn Primary","Jennifer Campbell","Head Teacher"]
["Primary","Millersneuk Primary","Greg Caldow","Head Teacher"]
["Primary","Milngavie Primary","Garry Graham","Head Teacher"]
["Primary","Mosshead Primary","Susan Yeoman","Head Teacher"]
["Primary","Oxgang Primary","Sarah Mutone","Head Teacher"]
["Primary","St Nicholas' Primary","Maureen O'Conner","Head Teacher"]
["Primary","St Helen's Primary","Rosaleen Miller","Head Teacher"]
["Primary","St Machan's Primary","Claire Wilson","Head Teacher"]
["Primary","St Matthew's Primary","Charlotte Grogan","Head Teacher"]
["Primary","Thomas Muir Primary","Hannah Young","Head Teacher"]
["Primary","Torrance Primary","Laura Law","Head Teacher"]
["Primary","Twechar Primary","Marie-Louise Brogan","Head Teacher"]
["Primary","Wester Cleddens Primary","Fiona Kynigos","Head Teacher"]
["Primary","Westerton Primary","Kate Turnbull","Head Teacher"]
["Secondary","Bearsden Academy","George Cooper","Head Teacher"]
["Secondary","Bishopbriggs Academy","Ian Donaghey","Head Teacher"]
["Secondary","Boclair Academy","Douglas Brown","Head Teacher"]
["Secondary","Douglas Academy","Barry Smedley","Head Teacher"]
["Secondary","Kirkintilloch High","Maureen Daniel","Head Teacher"]
["Secondary","Lenzie Academy","Brian Paterson","Head Teacher"]
["Secondary","St Ninian's High","Paul McLaughlin","Head Teacher"]
["Secondary","Turnbull High","Eileen Kennedy","Head Teacher"]
["ASN","Primary Wellbeing","Gaynor Hale","Head Teacher"]
["ASN","Secondary Wellbeing","Paul Quinn","Team Leader"]
["ASN","Woodland View School","Kay Hunter","Team Leader"]
["IMS","Instrumental Music Services","Jane Fergusson","Team Leader"]
[null,"Please Select Sector First"]

{"sheet":"Times","index":4,"n_rows":97,"n_cols":1,"rows_kept":97,"cut":false,"hidden":true,"merged":[]}
["Time"]
["00:05:00"]
["00:10:00"]
["00:15:00"]
["00:20:00"]
["00:25:00"]
["00:30:00"]
["00:35:00"]
["00:40:00"]
["00:45:00"]
["00:50:00"]
["00:55:00"]
["01:00:00"]
["01:05:00"]
["01:10:00"]
["01:15:00"]
["01:20:00"]
["01:25:00"]
["01:30:00"]
["01:35:00"]
["01:40:00"]
["01:45:00"]
["01:50:00"]
["01:55:00"]
["02:00:00"]
["02:05:00"]
["02:10:00"]
["02:15:00"]
["02:20:00"]
["02:25:00"]
["02:30:00"]
["02:35:00"]
["02:40:00"]
["02:45:00"]
["02:50:00"]
["02:55:00"]
["03:00:00"]
["03:05:00"]
["03:10:00"]
["03:15:00"]
["03:20:00"]
["03:25:00"]
["03:30:00"]
["03:35:00"]
["03:40:00"]
["03:45:00"]
["03:50:00"]
["03:55:00"]
["04:00:00"]
["04:05:00"]
["04:10:00"]
["04:15:00"]
["04:20:00"]
["04:25:00"]
["04:30:00"]
["04:35:00"]
["04:40:00"]
["04:45:00"]
["04:50:00"]
["04:55:00"]
["05:00:00"]
["05:05:00"]
["05:10:00"]
["05:15:00"]
["05:20:00"]
["05:25:00"]
["05:30:00"]
["05:35:00"]
["05:40:00"]
["05:45:00"]
["05:50:00"]
["05:55:00"]
["06:00:00"]
["06:05:00"]
["06:10:00"]
["06:15:00"]
["06:20:00"]
["06:25:00"]
["06:30:00"]
["06:35:00"]
["06:40:00"]
["06:45:00"]
["06:50:00"]
["06:55:00"]
["07:00:00"]
["07:05:00"]
["07:10:00"]
["07:15:00"]
["07:20:00"]
["07:25:00"]
["07:30:00"]
["07:35:00"]
["07:40:00"]
["07:45:00"]
["07:50:00"]
["07:55:00"]
["08:00:00"]