{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Rota","Timesheet 1","Sheet3","Sheet4","Sheet5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Rota","index":0,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[31,10,32,10],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,8,32,8],[31,9,32,9],[24,8,28,8],[24,9,28,9],[24,10,28,10],[29,5,30,5],[29,6,30,6],[29,7,30,7],[29,8,30,8],[29,9,30,9],[29,10,30,10],[20,1,21,2],[22,1,23,2],[12,1,12,3],[13,1,13,3],[10,1,11,10],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[16,1,17,2],[18,1,19,2],[14,1,15,2],[12,4,13,4],[12,5,13,5],[12,6,13,6],[24,1,28,3],[24,4,28,4],[24,5,28,5],[24,6,28,6],[24,7,28,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CARPENTRY / AUTO ROTA"]
[]
[null,"W/C",null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,"2021-11-25"]
[null,"Steve McGookin",null,"Day","Carp","Auto"]
[null,null,null,"Eve","Float","Stage"]
[null,"Dan Gardner",null,"Day","Float","Lieu"]
[null,null,null,"Eve","Maintenance"]
[null,"Henry Rivers",null,"Day","Stage"]
[null,null,null,"Eve","Get Out"]
[null,"Rhydian Lewis",null,"Day","Get Out"]
[null,null,null,"Eve","Stage"]
[null,"Joe Brown",null,"Day","Stage"]
[null,null,null,"Eve","SL ASM"]
[null,"Notes"]

{"sheet":"Timesheet 1","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[8,0,9,1],[10,0,11,1],[12,0,13,1],[14,0,15,1],[16,0,17,1],[4,0,5,9],[6,0,6,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[7,0,7,2]]}
[]
[]
[]
[]
["CARPENTRY / AUTO ROTA"]
[]
["W/C",null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
["2021-11-25"]
["Steve McGookin",null,"Day",{"$f":"IFERROR(VLOOKUP(Rota!E15,Hours,2,FALSE),\"\")","v":4},{"$f":"IFERROR(VLOOKUP(Rota!F15,Hours,2,FALSE),\"\")","v":4.5},{"$f":"IFERROR(VLOOKUP(Rota!G15,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H15,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I15,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J15,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K15,Hours,2,FALSE),\"\")","v":""}]
[null,null,"Eve",{"$f":"IFERROR(VLOOKUP(Rota!E16,Hours,2,FALSE),\"\")","v":6.5},{"$f":"IFERROR(VLOOKUP(Rota!F16,Hours,2,FALSE),\"\")","v":0.5},{"$f":"IFERROR(VLOOKUP(Rota!G16,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H16,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I16,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J16,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K16,Hours,2,FALSE),\"\")","v":""}]
["Dan Gardner",null,"Day",{"$f":"IFERROR(VLOOKUP(Rota!E17,Hours,2,FALSE),\"\")","v":6.5},{"$f":"IFERROR(VLOOKUP(Rota!F17,Hours,2,FALSE),\"\")","v":7},{"$f":"IFERROR(VLOOKUP(Rota!G17,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H17,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I17,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J17,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K17,Hours,2,FALSE),\"\")","v":""}]
[null,null,"Eve",{"$f":"IFERROR(VLOOKUP(Rota!E18,Hours,2,FALSE),\"\")","v":4.5},{"$f":"IFERROR(VLOOKUP(Rota!F18,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!G18,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H18,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I18,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J18,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K18,Hours,2,FALSE),\"\")","v":""}]
["Henry Rivers",null,"Day",{"$f":"IFERROR(VLOOKUP(Rota!E19,Hours,2,FALSE),\"\")","v":0.5},{"$f":"IFERROR(VLOOKUP(Rota!F19,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!G19,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H19,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I19,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J19,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K19,Hours,2,FALSE),\"\")","v":""}]
[null,null,"Eve",{"$f":"IFERROR(VLOOKUP(Rota!E20,Hours,2,FALSE),\"\")","v":7.5},{"$f":"IFERROR(VLOOKUP(Rota!F20,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!G20,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H20,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I20,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J20,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K20,Hours,2,FALSE),\"\")","v":""}]
["Rhydian Lewis",null,"Day",{"$f":"IFERROR(VLOOKUP(Rota!E21,Hours,2,FALSE),\"\")","v":7.5},{"$f":"IFERROR(VLOOKUP(Rota!F21,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!G21,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H21,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I21,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J21,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K21,Hours,2,FALSE),\"\")","v":""}]
[null,null,"Eve",{"$f":"IFERROR(VLOOKUP(Rota!E22,Hours,2,FALSE),\"\")","v":0.5},{"$f":"IFERROR(VLOOKUP(Rota!F22,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!G22,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H22,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I22,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J22,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K22,Hours,2,FALSE),\"\")","v":""}]
["Joe Brown",null,"Day",{"$f":"IFERROR(VLOOKUP(Rota!E23,Hours,2,FALSE),\"\")","v":0.5},{"$f":"IFERROR(VLOOKUP(Rota!F23,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!G23,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H23,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I23,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J23,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K23,Hours,2,FALSE),\"\")","v":""}]
[null,null,"Eve",{"$f":"IFERROR(VLOOKUP(Rota!E24,Hours,2,FALSE),\"\")","v":3.5},{"$f":"IFERROR(VLOOKUP(Rota!F24,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!G24,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!H24,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!I24,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!J24,Hours,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Rota!K24,Hours,2,FALSE),\"\")","v":""}]

{"sheet":"Sheet3","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Shift","Hours",null,null,null,null,null,null,null,null,"Carp"]
["Auto",4.5,null,null,null,null,null,null,null,null,"Stage"]
["Carp",4,null,null,null,null,null,null,null,null,"Auto"]
["Crew",6.5,null,null,null,null,null,null,null,null,"SM"]
["Float",6.5,null,null,null,null,null,null,null,null,"Maintenance"]
["Get Out",7.5,null,null,null,null,null,null,null,null,"Float"]
["Lieu",7,null,null,null,null,null,null,null,null,"Lieu"]
["LX",6.5,null,null,null,null,null,null,null,null,"Get Out"]
["Maintenance",4.5,null,null,null,null,null,null,null,null,"Crew"]
["SL ASM",3.5,null,null,null,null,null,null,null,null,"Sound"]
["SM",7.5,null,null,null,null,null,null,null,null,"LX"]
["Sound",7]
["Stage",0.5]

{"sheet":"Sheet4","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet5","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}