{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["CONTROL"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"CONTROL","index":0,"n_rows":31,"n_cols":28,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,6,0,11],[0,12,0,16],[0,17,0,21],[0,22,0,26],[30,0,32,16]]}
[null,"MONDAY",null,null,null,null,"TUESDAY",null,null,null,null,null,"WEDNESDAY",null,null,null,null,"THURSDAY",null,null,null,null,"FRIDAY",null,null,null,null,"TOTAL"]
["08:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["08:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["09:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["09:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["10:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["10:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["11:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["11:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["12:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["12:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["13:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["13:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["14:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["14:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["15:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["15:30:00",0.75,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.75,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["16:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["16:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["17:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["17:30:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["18:00:00",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["18:30:00",0.5,0.5,0.5,0.5,0.5,0.75,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["TUTOR 1",{"$f":"SumCellsByColor(B$2:B$23, $AB$24)","v":8.25},{"$f":"SumCellsByColor(C$2:C$23, $AB$24)","v":0},{"$f":"SumCellsByColor(D$2:D$23, $AB$24)","v":0},0,0,8.25,0,0,0,0,0,8.25,0,0,{"$f":"SumCellsByColor(P$2:P$23, $AB$24)","v":0},0,9.5,0,{"$f":"SumCellsByColor(T$2:T$23, $AB$24)","v":0},0,0,2,0,0,0,0,{"$f":"SUM(B24:AA24)","v":36.25}]
["TUTOR 2",{"$f":"SumCellsByColor(B$2:B$23, $AB$25)","v":0},{"$f":"SumCellsByColor(C$2:C$23, $AB$25)","v":5},{"$f":"SumCellsByColor(D$2:D$23, $AB$25)","v":0},0,0,0,5,0,0,0,0,0,{"$f":"SumCellsByColor(N$2:N$23, $AB$25)","v":5},0,{"$f":"SumCellsByColor(P$2:P$23, $AB$25)","v":0},0,0,5,{"$f":"SumCellsByColor(T$2:T$23, $AB$25)","v":0},0,0,0,0,0,0,0,20]
["TUTOR 3",{"$f":"SumCellsByColor(B$2:B$23, $AB$26)","v":0},{"$f":"SumCellsByColor(C$2:C$23, $AB$26)","v":0},{"$f":"SumCellsByColor(D$2:D$23, $AB$26)","v":0},{"$f":"SumCellsByColor(E$2:E$23, $AB$26)","v":8},0,0,0,0,3,0,0,0,0,0,{"$f":"SumCellsByColor(P$2:P$23, $AB$26)","v":3},0,0,0,{"$f":"SumCellsByColor(T$2:T$23, $AB$26)","v":2},0,0,0,0,4,0,0,20]
["TUTOR 4",{"$f":"SumCellsByColor(B$2:B$23, $AB$27)","v":0},0,0,0,4,0,0,0,0,0,4,0,0,0,{"$f":"SumCellsByColor(P$2:P$23, $AB$27)","v":0},6,0,0,{"$f":"SumCellsByColor(T$2:T$23, $AB$27)","v":0},0,{"$f":"SumCellsByColor(V$2:V$23, $AB$27)","v":6},0,0,0,0,0,{"$f":"SUM(B27:AA27)","v":20}]
["TUTOR 5",{"$f":"SumCellsByColor(B$2:B$23, $AB$28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SumCellsByColor(T$2:T$23, $AB$28)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(B28:AA28)","v":0}]
["TUTOR 6",{"$f":"SumCellsByColor(B$2:B$23, $AB$29)","v":0},0,6,0,0,0,0,6,0,0,0,0,0,0,0,0,0,0,{"$f":"SumCellsByColor(T$2:T$23, $AB$29)","v":0},0,0,0,0,0,0,0,12]
[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(AB25:AB29)","v":72}]
["INSTRUCTIONS: EACH CELL REPRESENTS A THIRTY MINUTE BLOCK. HIGHLIGHT THE CELLS FOR INDIVIDUAL TUTOR SHIFTS (2 CELLS=1 HOUR) AND SHADE THEM IN WITH THE CORRESPONDING COLOR. THE DATA WILL AUTOFILL AND CALCULATE TOTALS. TO ERASE SHIFTS, COPY A SINGLE BLANK CELL AND PASTE OVER THE SHADED COLUMN IN ORDER TO AVOID CLEARING THE FORMAT.",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(AB25:AB30)","v":144}]