{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Attendance Record","References"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Attendance Record","index":0,"n_rows":23,"n_cols":39,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,1,2,3],[1,0,1,5],[4,33,4,37],[4,25,4,28],[4,0,5,0],[4,1,4,4],[4,5,4,8],[4,9,4,12],[4,13,4,16],[4,17,4,20],[4,21,4,24],[4,29,4,32]]}
[]
["        Councillor Attendance"]
["16 May 2023 -","21st May 2024"]
[]
["Name","FULL COUNCIL",null,null,null,"LEISURE, AMENITIES & ENVIRONMENT",null,null,null,"PLANNING & HIGHWAYS",null,null,null,"CIVIC & COMMUNITY EVENTS",null,null,null,"POLICY & FINANCE",null,null,null,"PERSONNEL",null,null,null,"GRANTS sub Committee",null,null,null,"CH sub Committee",null,null,null,"Total Possible Meetings"]
[null,"Number of meetings","Number attended","Apologies given","Percentage Attendance","Number of meetings","Number attended","Apologies given","Percentage Attendance","Number of meetings","Number attended","Apologies given","Percentage Attendance","Number of meetings","Number attended","Apologies given","Percentage Attendance","Number of meetings","Number attended","Apologies given","Percentage Attendance","Number of meetings","Number attended","Apologies given","Percentage Attendance","Number of meetings","Number attended","Apologies given","Percentage Attendance","Number of meetings","Number attended","Apologies given","Percentage Attendance","Number of Meetings","Number Attended","Apologies Given","ABSENCES","Percentage Attendance"]
[{"$f":"References!J2","v":"Cllr Alexander"},{"$f":"References!A31","v":14},13,1,{"$f":"C7/B7","v":0.9285714285714286},1,1,null,{"$f":"IF(F7=0, \"N/A\", (G7/F7))","v":1},{"$f":"IF(References!L2=\"Yes\", References!$C$31, 0)","v":16},15,1,{"$f":"IF(J7=0, \"N/A\", (K7/J7))","v":0.9375},{"$f":"IF(References!M2=\"Yes\", References!$D$31, 0)","v":8},8,null,{"$f":"IF(N7=0, \"N/A\", (O7/N7))","v":1},{"$f":"IF(References!N2=\"Yes\", References!$E$31, 0)","v":0},null,null,{"$f":"IF(R7=0, \"N/A\", (S7/R7))","v":"N/A"},{"$f":"IF(References!P2=\"Yes\", References!$G$31, 0)","v":10},9,1,{"$f":"IF(V7=0, \"N/A\", (W7/V7))","v":0.9},{"$f":"IF(References!O2=\"Yes\", References!$F$31, 0)","v":0},null,null,{"$f":"IF(Z7=0, \"N/A\", (AA7/Z7))","v":"N/A"},{"$f":"IF(References!Q2=\"Yes\", References!$H$31, 0)","v":0},null,null,{"$f":"IF(AD7=0, \"N/A\", (AE7/AD7))","v":"N/A"},{"$f":"Z7+V7+R7+N7+J7+F7+B7+AD7","v":49},{"$f":"AA7+W7+S7+O7+K7+G7+C7+AE7","v":46},{"$f":"AB7+X7+T7+P7+L7+H7+D7+AF7","v":3},{"$f":"AH7-(AI7+AJ7)","v":0},{"$f":"AI7/AH7","v":0.93877551020408168},{"$f":"A7","v":"Cllr Alexander"}]
[{"$f":"References!J3","v":"Cllr Ashby-Parkin"},{"$f":"$B$7","v":14},9,5,{"$f":"C8/B8","v":0.6428571428571429},{"$f":"IF(References!K3=\"Yes\",References!$B$31, 0)","v":7},5,2,{"$f":"IF(F8=0, \"N/A\", (G8/F8))","v":0.7142857142857143},{"$f":"IF(References!L3=\"Yes\", References!$C$31, 0)","v":0},null,null,{"$f":"IF(J8=0, \"N/A\", (K8/J8))","v":"N/A"},{"$f":"IF(References!M3=\"Yes\", ((References!$D$31)-2), 0)","v":6},3,2,{"$f":"IF(N8=0, \"N/A\", (O8/N8))","v":0.5},{"$f":"IF(References!N3=\"Yes\", References!$E$31, 0)","v":0},null,null,{"$f":"IF(R8=0, \"N/A\", (S8/R8))","v":"N/A"},{"$f":"IF(References!P3=\"Yes\", References!$G$31, 0)","v":0},null,null,{"$f":"IF(V8=0, \"N/A\", (W8/V8))","v":"N/A"},{"$f":"IF(References!O3=\"Yes\", References!$F$31, 0)","v":0},null,null,{"$f":"IF(Z8=0, \"N/A\", (AA8/Z8))","v":"N/A"},{"$f":"IF(References!Q3=\"Yes\", References!$H$31, 0)","v":0},null,null,{"$f":"IF(AD8=0, \"N/A\", (AE8/AD8))","v":"N/A"},{"$f":"Z8+V8+R8+N8+J8+F8+B8+AD8","v":27},{"$f":"AA8+W8+S8+O8+K8+G8+C8+AE8","v":17},{"$f":"AB8+X8+T8+P8+L8+H8+D8+AF8","v":9},{"$f":"AH8-(AI8+AJ8)","v":1},{"$f":"AI8/AH8","v":0.62962962962962965},{"$f":"A8","v":"Cllr Ashby-Parkin"}]
[{"$f":"References!J4","v":"Cllr Campbell"},{"$f":"$B$7","v":14},14,null,1,{"$f":"IF(References!K4=\"Yes\",References!$B$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!L4=\"Yes\", References!$C$31, 0)","v":16},16,null,1,{"$f":"IF(References!M4=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N4=\"Yes\", References!$E$31, 0)","v":7},7,null,1,{"$f":"IF(References!P4=\"Yes\", References!$G$31, 0)","v":10},10,null,1,{"$f":"IF(References!O4=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q4=\"Yes\", References!$H$31, 0)-3","v":4},4,null,1,51,51,0,0,1,"Cllr Campbell"]
[{"$f":"References!J5","v":"Cllr Cheta"},14,11,2,0.7857142857142857,{"$f":"IF(References!K5=\"Yes\",References!$B$31, 0)","v":7},4,1,0.5714285714285714,3,0,1,0,{"$f":"IF(References!M5=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N5=\"Yes\", References!$E$31, 0)","v":7},5,1,0.7142857142857143,{"$f":"IF(References!P5=\"Yes\", References!$G$31, 0)","v":10},5,2,0.5,{"$f":"IF(References!O5=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q5=\"Yes\", References!$H$31, 0)-3","v":4},2,1,0.5,45,27,8,10,0.6,"Cllr Cheta"]
[{"$f":"References!J6","v":"Cllr Davies"},14,11,3,0.7857142857142857,{"$f":"IF(References!K6=\"Yes\",References!$B$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!L6=\"Yes\", References!$C$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!M6=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N6=\"Yes\", References!$E$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!P6=\"Yes\", References!$G$31, 0)","v":10},8,2,0.8,{"$f":"IF(References!O6=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q6=\"Yes\", References!$H$31, 0)","v":7},4,2,0.5714285714285714,31,23,7,1,0.74193548387096775,"Cllr Davies"]
[{"$f":"References!J7","v":"Cllr Donovan"},14,12,2,0.8571428571428571,{"$f":"IF(References!K7=\"Yes\",References!$B$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!L7=\"Yes\", References!$C$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!M7=\"Yes\", References!$D$31, 0)","v":8},7,1,0.875,{"$f":"IF(References!N7=\"Yes\", References!$E$31, 0)","v":7},4,3,0.5714285714285714,{"$f":"IF(References!P7=\"Yes\", References!$G$31, 0)","v":10},9,1,0.9,{"$f":"IF(References!O7=\"Yes\", References!$F$31, 0)","v":2},1,1,0.5,{"$f":"IF(References!Q7=\"Yes\", References!$H$31, 0)","v":7},6,1,0.8571428571428571,48,39,9,0,0.8125,"Cllr Donovan"]
[{"$f":"References!J8","v":"Cllr Fabry"},14,14,null,1,{"$f":"IF(References!K8=\"Yes\",References!$B$31, 0)","v":7},7,null,1,{"$f":"IF(References!L8=\"Yes\", References!$C$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!M8=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N8=\"Yes\", References!$E$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!P8=\"Yes\", References!$G$31, 0)","v":10},10,null,1,{"$f":"IF(References!O8=\"Yes\", References!$F$31, 0)","v":2},1,1,0.5,{"$f":"IF(References!Q8=\"Yes\", References!$H$31, 0)","v":0},null,null,"N/A",33,32,1,0,0.96969696969696972,"Cllr Fabry"]
[{"$f":"References!J9","v":"Cllr Gallagher"},14,13,1,0.9285714285714286,{"$f":"IF(References!K9=\"Yes\",References!$B$31, 0)","v":7},7,null,1,{"$f":"IF(References!L9=\"Yes\", References!$C$31, 0)","v":16},14,2,0.875,{"$f":"IF(References!M9=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N9=\"Yes\", References!$E$31, 0)","v":7},6,1,0.8571428571428571,{"$f":"IF(References!P9=\"Yes\", References!$G$31, 0)","v":10},9,1,0.9,{"$f":"IF(References!O9=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q9=\"Yes\", References!$H$31, 0)-3","v":4},2,1,0.5,58,51,6,1,0.87931034482758619,"Cllr Gallagher"]
[{"$f":"References!J10","v":"Cllr Gordon-Garrett"},14,14,null,1,{"$f":"IF(References!K10=\"Yes\",References!$B$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!L10=\"Yes\", References!$C$31, 0)","v":16},15,1,0.9375,{"$f":"IF(References!M10=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N10=\"Yes\", References!$E$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!P10=\"Yes\", References!$G$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!O10=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q10=\"Yes\", References!$H$31, 0)","v":0},null,null,"N/A",30,29,1,0,0.96666666666666667,"Cllr Gordon-Garrett"]
[{"$f":"References!J11","v":"Cllr Griffiths"},14,14,null,1,{"$f":"IF(References!K11=\"Yes\",References!$B$31, 0)","v":7},7,null,1,{"$f":"IF(References!L11=\"Yes\", References!$C$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!M11=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N11=\"Yes\", References!$E$31, 0)","v":7},7,null,1,{"$f":"IF(References!P11=\"Yes\", References!$G$31, 0)","v":10},7,2,0.7,{"$f":"IF(References!O11=\"Yes\", References!$F$31, 0)","v":2},2,null,1,{"$f":"IF(References!Q11=\"Yes\", References!$H$31, 0)","v":7},6,1,0.8571428571428571,47,43,3,1,0.91489361702127658,"Cllr Griffiths"]
[{"$f":"References!J12","v":"Cllr Harman"},14,14,null,1,{"$f":"IF(References!K12=\"Yes\",References!$B$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!L12=\"Yes\", References!$C$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!M12=\"Yes\", References!$D$31, 0)","v":8},6,2,0.75,{"$f":"IF(References!N12=\"Yes\", References!$E$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!P12=\"Yes\", References!$G$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!O12=\"Yes\", References!$F$31, 0)","v":2},2,null,1,{"$f":"IF(References!Q12=\"Yes\", References!$H$31, 0)","v":0},null,null,"N/A",24,22,2,0,0.91666666666666663,"Cllr Harman"]
[{"$f":"References!J13","v":"Cllr Evans"},{"$f":"$B$7-10","v":4},4,null,1,{"$f":"IF(References!K13=\"Yes\",References!$B$31, 0)-5","v":2},1,1,0.5,0,null,null,"N/A",{"$f":"IF(References!M13=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N13=\"Yes\", References!$E$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!P13=\"Yes\", References!$G$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!O13=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q13=\"Yes\", References!$H$31, 0)","v":0},null,null,"N/A",6,5,1,0,0.83333333333333337,"Cllr Evans"]
[{"$f":"References!J14","v":"Cllr Seabrook"},14,14,null,1,{"$f":"IF(References!K14=\"Yes\",References!$B$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!L14=\"Yes\", References!$C$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!M14=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N14=\"Yes\", References!$E$31, 0)","v":7},7,null,1,{"$f":"IF(References!P14=\"Yes\", References!$G$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!O14=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q14=\"Yes\", References!$H$31, 0)","v":7},7,null,1,28,28,0,0,1,"Cllr Seabrook"]
[{"$f":"References!J15","v":"Cllr Sharkey"},14,13,1,0.9285714285714286,{"$f":"IF(References!K15=\"Yes\",References!$B$31, 0)","v":7},5,2,0.7142857142857143,{"$f":"IF(References!L15=\"Yes\", References!$C$31, 0)","v":16},15,1,0.9375,{"$f":"IF(References!M15=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N15=\"Yes\", References!$E$31, 0)","v":7},7,null,1,{"$f":"IF(References!P15=\"Yes\", References!$G$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!O15=\"Yes\", References!$F$31, 0)","v":2},1,1,0.5,{"$f":"IF(References!Q15=\"Yes\", References!$H$31, 0)","v":0},null,null,"N/A",46,41,5,0,0.89130434782608692,"Cllr Sharkey"]
[{"$f":"References!J16","v":"Cllr Studd"},{"$f":"$B$7-8","v":6},5,1,0.83333333333333337,{"$f":"IF(References!K16=\"Yes\",References!$B$31, 0)-4","v":3},3,null,1,{"$f":"IF(References!L16=\"Yes\", References!$C$31, 0)-10","v":6},5,1,0.83333333333333337,{"$f":"IF(References!M16=\"Yes\", References!$D$31, 0)-5","v":3},2,1,0.66666666666666663,{"$f":"IF(References!N16=\"Yes\", References!$E$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!P16=\"Yes\", References!$G$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!O16=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q16=\"Yes\", References!$H$31, 0)","v":0},null,null,"N/A",18,15,3,0,0.83333333333333337,"Cllr Studd"]
[{"$f":"References!J17","v":"Cllr Veck"},14,11,3,0.7857142857142857,{"$f":"IF(References!K17=\"Yes\",References!$B$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!L17=\"Yes\", References!$C$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!M17=\"Yes\", References!$D$31, 0)","v":8},7,1,0.875,{"$f":"IF(References!N17=\"Yes\", References!$E$31, 0)","v":7},5,2,0.7142857142857143,{"$f":"IF(References!P17=\"Yes\", References!$G$31, 0)","v":10},5,4,0.5,{"$f":"IF(References!O17=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q17=\"Yes\", References!$H$31, 0)","v":7},6,1,0.8571428571428571,46,34,11,1,0.73913043478260865,"Cllr Veck"]
[{"$f":"References!J18","v":"Cllr Wood"},14,14,null,1,{"$f":"IF(References!K18=\"Yes\",References!$B$31, 0)","v":7},7,null,1,{"$f":"IF(References!L18=\"Yes\", References!$C$31, 0)","v":16},13,3,0.8125,{"$f":"IF(References!M18=\"Yes\", References!$D$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!N18=\"Yes\", References!$E$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!P18=\"Yes\", References!$G$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!O18=\"Yes\", References!$F$31, 0)","v":0},null,null,"N/A",{"$f":"IF(References!Q18=\"Yes\", References!$H$31, 0)","v":0},null,null,"N/A",37,34,3,0,0.91891891891891897,"Cllr Wood"]

{"sheet":"References","index":1,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Full Council Meeting Dates","LAE Meeting Dates","P&H Meeting Dates","CCE Meeting Dates","P&F Meeting Dates","Grants Meeting Dates","Personnel Meeting Dates","Community House Sub",null,"ALL CLLRS","LAE","P&H","CCE","P&F","Grants","Personnel","Community House"]
["2023-05-16","2023-05-30","2023-05-23","2023-05-25","2023-06-27","2023-11-16","2023-06-06","2023-09-07",null,"Cllr Alexander","No","Yes","Yes","No","No","Yes","No"]
["2023-07-11","2023-07-18","2023-06-13","2023-06-20","2023-09-12","2024-04-25","2023-05-30","2023-10-16",null,"Cllr Ashby-Parkin","Yes","No","Yes","No","No","No","No"]
["2023-09-19","2023-10-03","2023-07-04","2023-08-01","2023-10-24",null,"2023-07-05","2023-11-20",null,"Cllr Campbell","No","Yes","No","Yes","No","Yes","Yes"]
["2023-11-07","2023-11-21","2023-07-25","2023-10-10","2023-12-12",null,"2023-08-08","2024-01-18",null,"Cllr Cheta","Yes","No","No","Yes","No","Yes","Yes"]
["2023-12-19","2024-01-09","2023-08-15","2023-11-28","2024-01-30",null,"2023-07-18","2024-02-15",null,"Cllr Davies","No","No","No","No","No","Yes","Yes"]
["2023-07-25","2024-02-20","2023-09-05","2024-01-16","2024-03-12",null,"2023-09-12","2024-04-18",null,"Cllr Donovan","No","No","Yes","Yes","Yes","Yes","Yes"]
["2023-10-02","2024-04-02","2023-09-26","2024-02-27","2024-04-30",null,"2023-10-10","2024-05-14",null,"Cllr Fabry","Yes","No","No","No","Yes","Yes","No"]
["2023-11-07",null,"2023-10-17","2024-04-16",null,null,"2023-12-05",null,null,"Cllr Gallagher","Yes","Yes","No","Yes","No","Yes","Yes"]
["2023-11-23",null,"2023-11-14",null,null,null,"2024-01-23",null,null,"Cllr Gordon-Garrett","No","Yes","No","No","No","No","No"]
["2023-12-19",null,"2023-12-05",null,null,null,"2024-03-26",null,null,"Cllr Griffiths","Yes","No","No","Yes","Yes","Yes","Yes"]
["2024-02-06",null,"2024-01-09",null,null,null,null,null,null,"Cllr Harman","No","No","Yes","No","Yes","No","No"]
["2024-02-20",null,"2024-01-23",null,null,null,null,null,null,"Cllr Evans","Yes","No","No","No","No","No","No"]
["2024-03-19",null,"2024-02-13",null,null,null,null,null,null,"Cllr Seabrook","No","No","No","Yes","No","No","Yes"]
["2024-05-21",null,"2024-03-05",null,null,null,null,null,null,"Cllr Sharkey","Yes","Yes","No","Yes","Yes","No","No"]
[null,null,"2024-04-09",null,null,null,null,null,null,"Cllr Studd","Yes","Yes","Yes","No","No","No","No"]
[null,null,"2024-05-07",null,null,null,null,null,null,"Cllr Veck","No","No","Yes","Yes","No","Yes","Yes"]
[null,null,null,null,null,null,null,null,null,"Cllr Wood","Yes","Yes","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"COUNTIF(A2:A30,\"<\"&$A$32)","v":14},{"$f":"COUNTIF(B2:B30,\"<\"&$A$32)","v":7},{"$f":"COUNTIF(C2:C30,\"<\"&$A$32)","v":16},{"$f":"COUNTIF(D2:D30,\"<\"&$A$32)","v":8},{"$f":"COUNTIF(E2:E30,\"<\"&$A$32)","v":7},{"$f":"COUNTIF(F2:F30,\"<\"&$A$32)","v":2},{"$f":"COUNTIF(G2:G30,\"<\"&$A$32)","v":10},{"$f":"COUNTIF(H2:H30,\"<\"&$A$32)","v":7}]
[{"$f":"NOW()","v":"2024-07-09T16:01:05.230"}]