{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["January Overview","Week 1 Shifts","Week 2 Shifts","Week 3 Shifts","Week 4 Shifts","Week 5 Shifts"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"January Overview","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["                                                                          UNMCF RANK STRUCTURE NM-UIG-2"]
[]
["UNMCF ARMY","UNMCF NAVAL COMMAND","UNMCF MARINE CORPS"]
["E-1 PRIVATE (PVT)","Seaman Recruit (SMR)","E-1 PRIVATE (PVT)"]
["E-2 PRIVATE 2 (PVT)","Seaman Apprentice (SMA)","E2- PRIVATE FIRST CLASS (PFC)"]
["E-3 PRIVATE FIRST CLASS (PFC)","Seaman (SEAM)","E-3 LANCE CORPORAL (LCPL)"]
["E-4 SPECIALIST/CORPORAL  (SPC) (CPL)","Petty Officer Third Class (PO3C)","E4 CORPORAL (CPL)"]
["E-5 SERGEANT (SGT)","Petty Officer Second Class (PO2C)","E-5 SERGEANT (SGT)"]
["E-6 STAFF SERGEANT (SSGT)","Petty Officer First Class (PO1C)","E-6 STAFF SERGEANT (SSGT)"]
["E-7 SERGEANT FIRST CLASS (SFC)","Chief Petty Officer (CPO)","E-7 GUNNERY SERGEANT (GSGT)"]
["E-8 FIRST SERGEANT (1SG)","Senior Chief Petty Officer (SCPO)","E-8 FIRST SERGEANT (1SG)"]
["E-9 SERGENT MAJOR (SGM)","Master Chief Petty Officer (MCPO)","E-9 SERGENT MAJOR (SGM)"]
["-","-","-"]
["O-1 2nd Lieutenant (2LT)","O-1 Ensign (ESN)","O-1 2nd Lieutenant (2LT)"]
["O-2 1st Lieutenant (1LT)","O-2 Lieutant Junior Grade (LTJG)","O-2 1st Lieutenant (1LT"]
["O-3 Captain (CPTN)","O-3 Lieutant (LT)","O-3 Captain (CPTN)"]
["O-4 Major (MAJR)","O-4 Lieutant Commander (LTCM)","O-4 Major (MAJR)"]
["O-5 Lieutenant Colonel","O-5 Commander (CMDR)","O-5 Lieutenant Colonel"]
["O-6 Colonel (COL)","O-6 Captain (CAPT)","O-6 Colonel (COL)"]
["O-7 Brigadier General (BGEN)","O-7 Vice Admiral (VADM)","O-7 Brigadier General (BGEN)"]
["O-8 Major General (MGEN)","O-8 Admiral (ADMR)","O-8 Major General (MGEN)"]
["O-9 Lieutenant General (LGEN))","O-9 Fleet Admiral (FADM)","O-9 Lieutenant General (LGEN))"]
["O-10 General (Gen)","-","O-10 General (Gen)"]

{"sheet":"Week 1 Shifts","index":1,"n_rows":99,"n_cols":33,"rows_kept":99,"cut":false,"hidden":false,"merged":[[78,30,78,31],[78,32,78,33],[73,28,73,29],[73,30,73,31],[73,32,73,33],[74,28,74,29],[74,30,74,31],[74,32,74,33],[78,28,78,29],[81,30,81,31],[81,32,81,33],[79,28,79,29],[79,30,79,31],[79,32,79,33],[80,28,80,29],[80,30,80,31],[80,32,80,33],[81,28,81,29],[84,30,84,31],[84,32,84,33],[82,28,82,29],[82,30,82,31],[82,32,82,33],[83,28,83,29],[83,30,83,31],[83,32,83,33],[84,28,84,29],[90,30,90,31],[90,32,90,33],[85,28,85,29],[85,30,85,31],[85,32,85,33],[86,28,86,29],[86,30,86,31],[86,32,86,33],[90,28,90,29],[93,30,93,31],[93,32,93,33],[91,28,91,29],[91,30,91,31],[91,32,91,33],[92,28,92,29],[92,30,92,31],[92,32,92,33],[93,28,93,29],[96,30,96,31],[96,32,96,33],[94,28,94,29],[94,30,94,31],[94,32,94,33],[95,28,95,29],[95,30,95,31],[95,32,95,33],[96,28,96,29],[47,30,47,31],[47,32,47,33],[45,28,45,29],[45,30,45,31],[45,32,45,33],[46,28,46,29],[46,30,46,31],[46,32,46,33],[47,28,47,29],[54,30,54,31],[54,32,54,33],[49,28,49,29],[49,30,49,31],[49,32,49,33],[50,28,50,29],[50,30,50,31],[50,32,50,33],[54,28,54,29],[57,30,57,31],[57,32,57,33],[55,28,55,29],[55,30,55,31],[55,32,55,33],[56,28,56,29],[56,30,56,31],[56,32,56,33],[57,28,57,29],[97,28,97,29],[97,30,97,31],[97,32,97,33],[98,28,98,29],[98,30,98,31],[98,32,98,33],[25,28,25,29],[25,30,25,31],[25,32,25,33],[26,28,26,29],[26,30,26,31],[26,32,26,33],[27,4,27,33],[28,4,28,33],[29,4,29,11],[29,12,29,19],[29,20,29,27],[29,28,29,33],[30,30,30,31],[30,32,30,33],[7,3,7,25],[7,27,7,29],[8,3,8,5],[10,3,13,3],[11,5,12,31],[15,4,15,33],[16,4,16,33],[17,4,17,11],[17,12,17,19],[17,20,17,27],[17,28,17,33],[18,28,18,29],[18,30,18,31],[18,32,18,33],[21,30,21,31],[21,32,21,33],[19,28,19,29],[19,30,19,31],[19,32,19,33],[20,28,20,29],[20,30,20,31],[20,32,20,33],[21,28,21,29],[24,30,24,31],[24,32,24,33],[22,28,22,29],[22,30,22,31],[22,32,22,33],[23,28,23,29],[23,30,23,31],[23,32,23,33],[24,28,24,29],[30,28,30,29],[31,28,31,29],[31,30,31,31],[31,32,31,33],[32,28,32,29],[32,30,32,31],[32,32,32,33],[35,30,35,31],[35,32,35,33],[33,28,33,29],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[38,30,38,31],[38,32,38,33],[39,4,39,33],[40,4,40,33],[41,4,41,11],[41,12,41,19],[41,20,41,27],[41,28,41,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,28,37,29],[37,30,37,31],[37,32,37,33],[38,28,38,29],[44,30,44,31],[44,32,44,33],[42,28,42,29],[42,30,42,31],[42,32,42,33],[43,28,43,29],[43,30,43,31],[43,32,43,33],[44,28,44,29],[53,20,53,27],[53,28,53,33],[48,28,48,29],[48,30,48,31],[48,32,48,33],[51,4,51,33],[52,4,52,33],[53,4,53,11],[53,12,53,19],[60,30,60,31],[60,32,60,33],[63,4,63,33],[64,4,64,33],[65,4,65,11],[65,12,65,19],[65,20,65,27],[65,28,65,33],[58,28,58,29],[58,30,58,31],[58,32,58,33],[59,28,59,29],[59,30,59,31],[59,32,59,33],[60,28,60,29],[66,30,66,31],[66,32,66,33],[61,28,61,29],[61,30,61,31],[61,32,61,33],[62,28,62,29],[62,30,62,31],[62,32,62,33],[66,28,66,29],[69,30,69,31],[69,32,69,33],[67,28,67,29],[67,30,67,31],[67,32,67,33],[68,28,68,29],[68,30,68,31],[68,32,68,33],[69,28,69,29],[70,28,70,29],[70,30,70,31],[70,32,70,33],[71,28,71,29],[71,30,71,31],[71,32,71,33],[72,28,72,29],[77,20,77,27],[87,4,87,33],[88,4,88,33],[89,4,89,11],[89,12,89,19],[89,20,89,27],[89,28,89,33],[99,3,101,3],[72,30,72,31],[72,32,72,33],[75,4,75,33],[76,4,76,33],[77,4,77,11],[77,12,77,19],[77,28,77,33]]}
{"$rows_empty":7}
[null,null,null,"Jan 1 - Jan 7"]
[null,null,null,"Weekly Schedule 01"]
[]
[null,null,null,"Quick Tip  ➜"]
[{"$nulls":5},"Highlight \"Names\" and all the cells below it, then go to Data > Filter views > Create new (temporary) filter view to be able to filter for specific names."]
[]
[]
[]
[{"$nulls":4},"2017-01-01"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[null,null,null,"Names",8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},{"$f":"COUNTIF($E20:$L20, \"=\"&AC$19)","v":8},null,{"$f":"COUNTIF($M20:$T20, \"=\"&AE$19)","v":8},null,{"$f":"COUNTIF($U20:$AB20, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",0,null,8,null,8]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer","A","A","A","A","A","A","A","A",{"$nulls":8},"C","C","C","C","C","C","C","C",8,null,0,null,8]
[null,null,null,"Molly Maker",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",0,null,8,null,8]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-02"]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E32:$L32, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M32:$T32, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U32:$AB32, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",0,null,8,null,8]
[null,null,null,"Abby Author",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[null,null,null,"Casey Creator","A","A","A","A","A","A","A","A","B","B","B","B","B","B",{"$nulls":10},8,null,6,null,0]
[null,null,null,"Perry Presenter",{"$nulls":14},"B","B","C","C","C","C","C","C","C","C",0,null,2,null,8]
[null,null,null,"Vinny Viewer",{"$nulls":8},"B","B","B","B","B","B","B","B",{"$nulls":8},0,null,8,null,0]
[null,null,null,"Molly Maker","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[null,null,null,"Berry Books","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[{"$nulls":4},"2017-01-03"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E44:$L44, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M44:$T44, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U44:$AB44, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader","A","A","A","A","A","A","A","A",{"$nulls":8},"C","C","C","C","C","C","C","C",8,null,0,null,8]
[null,null,null,"Abby Author","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},8,null,8,null,0]
[null,null,null,"Casey Creator","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},8,null,8,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[null,null,null,"Berry Books",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",0,null,8,null,8]
[{"$nulls":4},"2017-01-04"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":16},"C","C","C","C","C","C","C","C",{"$f":"COUNTIF($E56:$L56, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M56:$T56, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U56:$AB56, \"=\"&AG$19)","v":8}]
[null,null,null,"Ronny Reader",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",0,null,8,null,8]
[null,null,null,"Abby Author","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},8,null,8,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer","A","A","A","A","A","A","A","A",{"$nulls":8},"C","C","C","C","C","C","C","C",8,null,0,null,8]
[null,null,null,"Molly Maker","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},8,null,8,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-05"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer","A","A","A","A","A","A","A","A",{"$nulls":16},{"$f":"COUNTIF($E68:$L68, \"=\"&AC$19)","v":8},null,{"$f":"COUNTIF($M68:$T68, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U68:$AB68, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",0,null,8,null,8]
[null,null,null,"Casey Creator",{"$nulls":8},"B","B","B","B","B","B","B","B",{"$nulls":8},0,null,8,null,0]
[null,null,null,"Perry Presenter",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",0,null,8,null,8]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker","A","A","A","A","A","A","A","A",{"$nulls":8},"C","C","C","C","C","C","C","C",8,null,0,null,8]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-06"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",{"$f":"COUNTIF($E80:$L80, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M80:$T80, \"=\"&AE$19)","v":8},null,{"$f":"COUNTIF($U80:$AB80, \"=\"&AG$19)","v":8}]
[null,null,null,"Ronny Reader","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},8,null,8,null,0]
[null,null,null,"Abby Author","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},8,null,8,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[null,null,null,"Vinny Viewer",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[{"$nulls":4},"2017-01-07"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E92:$L92, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M92:$T92, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U92:$AB92, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[null,null,null,"Abby Author","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",0,null,8,null,8]
[null,null,null,"Perry Presenter","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},8,null,8,null,0]
[null,null,null,"Vinny Viewer","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},8,null,8,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]

{"sheet":"Week 2 Shifts","index":2,"n_rows":99,"n_cols":33,"rows_kept":99,"cut":false,"hidden":false,"merged":[[78,30,78,31],[78,32,78,33],[73,28,73,29],[73,30,73,31],[73,32,73,33],[74,28,74,29],[74,30,74,31],[74,32,74,33],[78,28,78,29],[81,30,81,31],[81,32,81,33],[79,28,79,29],[79,30,79,31],[79,32,79,33],[80,28,80,29],[80,30,80,31],[80,32,80,33],[81,28,81,29],[84,30,84,31],[84,32,84,33],[82,28,82,29],[82,30,82,31],[82,32,82,33],[83,28,83,29],[83,30,83,31],[83,32,83,33],[84,28,84,29],[90,30,90,31],[90,32,90,33],[85,28,85,29],[85,30,85,31],[85,32,85,33],[86,28,86,29],[86,30,86,31],[86,32,86,33],[90,28,90,29],[93,30,93,31],[93,32,93,33],[91,28,91,29],[91,30,91,31],[91,32,91,33],[92,28,92,29],[92,30,92,31],[92,32,92,33],[93,28,93,29],[96,30,96,31],[96,32,96,33],[94,28,94,29],[94,30,94,31],[94,32,94,33],[95,28,95,29],[95,30,95,31],[95,32,95,33],[96,28,96,29],[47,30,47,31],[47,32,47,33],[45,28,45,29],[45,30,45,31],[45,32,45,33],[46,28,46,29],[46,30,46,31],[46,32,46,33],[47,28,47,29],[54,30,54,31],[54,32,54,33],[49,28,49,29],[49,30,49,31],[49,32,49,33],[50,28,50,29],[50,30,50,31],[50,32,50,33],[54,28,54,29],[57,30,57,31],[57,32,57,33],[55,28,55,29],[55,30,55,31],[55,32,55,33],[56,28,56,29],[56,30,56,31],[56,32,56,33],[57,28,57,29],[97,28,97,29],[97,30,97,31],[97,32,97,33],[98,28,98,29],[98,30,98,31],[98,32,98,33],[25,28,25,29],[25,30,25,31],[25,32,25,33],[26,28,26,29],[26,30,26,31],[26,32,26,33],[27,4,27,33],[28,4,28,33],[29,4,29,11],[29,12,29,19],[29,20,29,27],[29,28,29,33],[30,30,30,31],[30,32,30,33],[7,3,7,25],[7,27,7,29],[8,3,8,5],[10,3,13,3],[11,5,12,31],[15,4,15,33],[16,4,16,33],[17,4,17,11],[17,12,17,19],[17,20,17,27],[17,28,17,33],[18,28,18,29],[18,30,18,31],[18,32,18,33],[21,30,21,31],[21,32,21,33],[19,28,19,29],[19,30,19,31],[19,32,19,33],[20,28,20,29],[20,30,20,31],[20,32,20,33],[21,28,21,29],[24,30,24,31],[24,32,24,33],[22,28,22,29],[22,30,22,31],[22,32,22,33],[23,28,23,29],[23,30,23,31],[23,32,23,33],[24,28,24,29],[30,28,30,29],[31,28,31,29],[31,30,31,31],[31,32,31,33],[32,28,32,29],[32,30,32,31],[32,32,32,33],[35,30,35,31],[35,32,35,33],[33,28,33,29],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[38,30,38,31],[38,32,38,33],[39,4,39,33],[40,4,40,33],[41,4,41,11],[41,12,41,19],[41,20,41,27],[41,28,41,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,28,37,29],[37,30,37,31],[37,32,37,33],[38,28,38,29],[44,30,44,31],[44,32,44,33],[42,28,42,29],[42,30,42,31],[42,32,42,33],[43,28,43,29],[43,30,43,31],[43,32,43,33],[44,28,44,29],[53,20,53,27],[53,28,53,33],[48,28,48,29],[48,30,48,31],[48,32,48,33],[51,4,51,33],[52,4,52,33],[53,4,53,11],[53,12,53,19],[60,30,60,31],[60,32,60,33],[63,4,63,33],[64,4,64,33],[65,4,65,11],[65,12,65,19],[65,20,65,27],[65,28,65,33],[58,28,58,29],[58,30,58,31],[58,32,58,33],[59,28,59,29],[59,30,59,31],[59,32,59,33],[60,28,60,29],[66,30,66,31],[66,32,66,33],[61,28,61,29],[61,30,61,31],[61,32,61,33],[62,28,62,29],[62,30,62,31],[62,32,62,33],[66,28,66,29],[69,30,69,31],[69,32,69,33],[67,28,67,29],[67,30,67,31],[67,32,67,33],[68,28,68,29],[68,30,68,31],[68,32,68,33],[69,28,69,29],[70,28,70,29],[70,30,70,31],[70,32,70,33],[71,28,71,29],[71,30,71,31],[71,32,71,33],[72,28,72,29],[77,20,77,27],[87,4,87,33],[88,4,88,33],[89,4,89,11],[89,12,89,19],[89,20,89,27],[89,28,89,33],[99,3,101,3],[72,30,72,31],[72,32,72,33],[75,4,75,33],[76,4,76,33],[77,4,77,11],[77,12,77,19],[77,28,77,33]]}
{"$rows_empty":7}
[null,null,null,"Jan 8 - Jan 14"]
[null,null,null,"Weekly Schedule 02"]
[]
[null,null,null,"Quick Tip  ➜"]
[{"$nulls":5},"Highlight \"Names\" and all the cells below it, then go to Data > Filter Views > Create New Filter View to be able to filter for specific names."]
[]
[]
[]
[{"$nulls":4},"2017-01-08"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[null,null,null,"Names",8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E20:$L20, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M20:$T20, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U20:$AB20, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-09"]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E32:$L32, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M32:$T32, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U32:$AB32, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-10"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E44:$L44, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M44:$T44, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U44:$AB44, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-11"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E56:$L56, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M56:$T56, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U56:$AB56, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-12"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E68:$L68, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M68:$T68, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U68:$AB68, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-13"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E80:$L80, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M80:$T80, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U80:$AB80, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-14"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E92:$L92, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M92:$T92, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U92:$AB92, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]

{"sheet":"Week 3 Shifts","index":3,"n_rows":99,"n_cols":33,"rows_kept":99,"cut":false,"hidden":false,"merged":[[78,30,78,31],[78,32,78,33],[73,28,73,29],[73,30,73,31],[73,32,73,33],[74,28,74,29],[74,30,74,31],[74,32,74,33],[78,28,78,29],[81,30,81,31],[81,32,81,33],[79,28,79,29],[79,30,79,31],[79,32,79,33],[80,28,80,29],[80,30,80,31],[80,32,80,33],[81,28,81,29],[84,30,84,31],[84,32,84,33],[82,28,82,29],[82,30,82,31],[82,32,82,33],[83,28,83,29],[83,30,83,31],[83,32,83,33],[84,28,84,29],[90,30,90,31],[90,32,90,33],[85,28,85,29],[85,30,85,31],[85,32,85,33],[86,28,86,29],[86,30,86,31],[86,32,86,33],[90,28,90,29],[93,30,93,31],[93,32,93,33],[91,28,91,29],[91,30,91,31],[91,32,91,33],[92,28,92,29],[92,30,92,31],[92,32,92,33],[93,28,93,29],[96,30,96,31],[96,32,96,33],[94,28,94,29],[94,30,94,31],[94,32,94,33],[95,28,95,29],[95,30,95,31],[95,32,95,33],[96,28,96,29],[47,30,47,31],[47,32,47,33],[45,28,45,29],[45,30,45,31],[45,32,45,33],[46,28,46,29],[46,30,46,31],[46,32,46,33],[47,28,47,29],[54,30,54,31],[54,32,54,33],[49,28,49,29],[49,30,49,31],[49,32,49,33],[50,28,50,29],[50,30,50,31],[50,32,50,33],[54,28,54,29],[57,30,57,31],[57,32,57,33],[55,28,55,29],[55,30,55,31],[55,32,55,33],[56,28,56,29],[56,30,56,31],[56,32,56,33],[57,28,57,29],[97,28,97,29],[97,30,97,31],[97,32,97,33],[98,28,98,29],[98,30,98,31],[98,32,98,33],[25,28,25,29],[25,30,25,31],[25,32,25,33],[26,28,26,29],[26,30,26,31],[26,32,26,33],[27,4,27,33],[28,4,28,33],[29,4,29,11],[29,12,29,19],[29,20,29,27],[29,28,29,33],[30,30,30,31],[30,32,30,33],[7,3,7,25],[7,27,7,29],[8,3,8,5],[10,3,13,3],[11,5,12,31],[15,4,15,33],[16,4,16,33],[17,4,17,11],[17,12,17,19],[17,20,17,27],[17,28,17,33],[18,28,18,29],[18,30,18,31],[18,32,18,33],[21,30,21,31],[21,32,21,33],[19,28,19,29],[19,30,19,31],[19,32,19,33],[20,28,20,29],[20,30,20,31],[20,32,20,33],[21,28,21,29],[24,30,24,31],[24,32,24,33],[22,28,22,29],[22,30,22,31],[22,32,22,33],[23,28,23,29],[23,30,23,31],[23,32,23,33],[24,28,24,29],[30,28,30,29],[31,28,31,29],[31,30,31,31],[31,32,31,33],[32,28,32,29],[32,30,32,31],[32,32,32,33],[35,30,35,31],[35,32,35,33],[33,28,33,29],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[38,30,38,31],[38,32,38,33],[39,4,39,33],[40,4,40,33],[41,4,41,11],[41,12,41,19],[41,20,41,27],[41,28,41,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,28,37,29],[37,30,37,31],[37,32,37,33],[38,28,38,29],[44,30,44,31],[44,32,44,33],[42,28,42,29],[42,30,42,31],[42,32,42,33],[43,28,43,29],[43,30,43,31],[43,32,43,33],[44,28,44,29],[53,20,53,27],[53,28,53,33],[48,28,48,29],[48,30,48,31],[48,32,48,33],[51,4,51,33],[52,4,52,33],[53,4,53,11],[53,12,53,19],[60,30,60,31],[60,32,60,33],[63,4,63,33],[64,4,64,33],[65,4,65,11],[65,12,65,19],[65,20,65,27],[65,28,65,33],[58,28,58,29],[58,30,58,31],[58,32,58,33],[59,28,59,29],[59,30,59,31],[59,32,59,33],[60,28,60,29],[66,30,66,31],[66,32,66,33],[61,28,61,29],[61,30,61,31],[61,32,61,33],[62,28,62,29],[62,30,62,31],[62,32,62,33],[66,28,66,29],[69,30,69,31],[69,32,69,33],[67,28,67,29],[67,30,67,31],[67,32,67,33],[68,28,68,29],[68,30,68,31],[68,32,68,33],[69,28,69,29],[70,28,70,29],[70,30,70,31],[70,32,70,33],[71,28,71,29],[71,30,71,31],[71,32,71,33],[72,28,72,29],[77,20,77,27],[87,4,87,33],[88,4,88,33],[89,4,89,11],[89,12,89,19],[89,20,89,27],[89,28,89,33],[99,3,101,3],[72,30,72,31],[72,32,72,33],[75,4,75,33],[76,4,76,33],[77,4,77,11],[77,12,77,19],[77,28,77,33]]}
{"$rows_empty":7}
[null,null,null,"Jan 15 - Jan 21"]
[null,null,null,"Weekly Schedule 03"]
[]
[null,null,null,"Quick Tip  ➜"]
[{"$nulls":5},"Highlight \"Names\" and all the cells below it, then go to Data > Filter Views > Create New Filter View to be able to filter for specific names."]
[]
[]
[]
[{"$nulls":4},"2017-01-15"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[null,null,null,"Names",8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E20:$L20, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M20:$T20, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U20:$AB20, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-16"]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E32:$L32, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M32:$T32, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U32:$AB32, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-17"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E44:$L44, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M44:$T44, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U44:$AB44, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-18"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E56:$L56, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M56:$T56, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U56:$AB56, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-19"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E68:$L68, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M68:$T68, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U68:$AB68, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-20"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E80:$L80, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M80:$T80, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U80:$AB80, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-21"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E92:$L92, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M92:$T92, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U92:$AB92, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]

{"sheet":"Week 4 Shifts","index":4,"n_rows":99,"n_cols":33,"rows_kept":99,"cut":false,"hidden":false,"merged":[[78,30,78,31],[78,32,78,33],[73,28,73,29],[73,30,73,31],[73,32,73,33],[74,28,74,29],[74,30,74,31],[74,32,74,33],[78,28,78,29],[81,30,81,31],[81,32,81,33],[79,28,79,29],[79,30,79,31],[79,32,79,33],[80,28,80,29],[80,30,80,31],[80,32,80,33],[81,28,81,29],[84,30,84,31],[84,32,84,33],[82,28,82,29],[82,30,82,31],[82,32,82,33],[83,28,83,29],[83,30,83,31],[83,32,83,33],[84,28,84,29],[90,30,90,31],[90,32,90,33],[85,28,85,29],[85,30,85,31],[85,32,85,33],[86,28,86,29],[86,30,86,31],[86,32,86,33],[90,28,90,29],[93,30,93,31],[93,32,93,33],[91,28,91,29],[91,30,91,31],[91,32,91,33],[92,28,92,29],[92,30,92,31],[92,32,92,33],[93,28,93,29],[96,30,96,31],[96,32,96,33],[94,28,94,29],[94,30,94,31],[94,32,94,33],[95,28,95,29],[95,30,95,31],[95,32,95,33],[96,28,96,29],[47,30,47,31],[47,32,47,33],[45,28,45,29],[45,30,45,31],[45,32,45,33],[46,28,46,29],[46,30,46,31],[46,32,46,33],[47,28,47,29],[54,30,54,31],[54,32,54,33],[49,28,49,29],[49,30,49,31],[49,32,49,33],[50,28,50,29],[50,30,50,31],[50,32,50,33],[54,28,54,29],[57,30,57,31],[57,32,57,33],[55,28,55,29],[55,30,55,31],[55,32,55,33],[56,28,56,29],[56,30,56,31],[56,32,56,33],[57,28,57,29],[97,28,97,29],[97,30,97,31],[97,32,97,33],[98,28,98,29],[98,30,98,31],[98,32,98,33],[25,28,25,29],[25,30,25,31],[25,32,25,33],[26,28,26,29],[26,30,26,31],[26,32,26,33],[27,4,27,33],[28,4,28,33],[29,4,29,11],[29,12,29,19],[29,20,29,27],[29,28,29,33],[30,30,30,31],[30,32,30,33],[7,3,7,25],[7,27,7,29],[8,3,8,5],[10,3,13,3],[11,5,12,31],[15,4,15,33],[16,4,16,33],[17,4,17,11],[17,12,17,19],[17,20,17,27],[17,28,17,33],[18,28,18,29],[18,30,18,31],[18,32,18,33],[21,30,21,31],[21,32,21,33],[19,28,19,29],[19,30,19,31],[19,32,19,33],[20,28,20,29],[20,30,20,31],[20,32,20,33],[21,28,21,29],[24,30,24,31],[24,32,24,33],[22,28,22,29],[22,30,22,31],[22,32,22,33],[23,28,23,29],[23,30,23,31],[23,32,23,33],[24,28,24,29],[30,28,30,29],[31,28,31,29],[31,30,31,31],[31,32,31,33],[32,28,32,29],[32,30,32,31],[32,32,32,33],[35,30,35,31],[35,32,35,33],[33,28,33,29],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[38,30,38,31],[38,32,38,33],[39,4,39,33],[40,4,40,33],[41,4,41,11],[41,12,41,19],[41,20,41,27],[41,28,41,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,28,37,29],[37,30,37,31],[37,32,37,33],[38,28,38,29],[44,30,44,31],[44,32,44,33],[42,28,42,29],[42,30,42,31],[42,32,42,33],[43,28,43,29],[43,30,43,31],[43,32,43,33],[44,28,44,29],[53,20,53,27],[53,28,53,33],[48,28,48,29],[48,30,48,31],[48,32,48,33],[51,4,51,33],[52,4,52,33],[53,4,53,11],[53,12,53,19],[60,30,60,31],[60,32,60,33],[63,4,63,33],[64,4,64,33],[65,4,65,11],[65,12,65,19],[65,20,65,27],[65,28,65,33],[58,28,58,29],[58,30,58,31],[58,32,58,33],[59,28,59,29],[59,30,59,31],[59,32,59,33],[60,28,60,29],[66,30,66,31],[66,32,66,33],[61,28,61,29],[61,30,61,31],[61,32,61,33],[62,28,62,29],[62,30,62,31],[62,32,62,33],[66,28,66,29],[69,30,69,31],[69,32,69,33],[67,28,67,29],[67,30,67,31],[67,32,67,33],[68,28,68,29],[68,30,68,31],[68,32,68,33],[69,28,69,29],[70,28,70,29],[70,30,70,31],[70,32,70,33],[71,28,71,29],[71,30,71,31],[71,32,71,33],[72,28,72,29],[77,20,77,27],[87,4,87,33],[88,4,88,33],[89,4,89,11],[89,12,89,19],[89,20,89,27],[89,28,89,33],[99,3,101,3],[72,30,72,31],[72,32,72,33],[75,4,75,33],[76,4,76,33],[77,4,77,11],[77,12,77,19],[77,28,77,33]]}
{"$rows_empty":7}
[null,null,null,"Jan 22 - Jan 28"]
[null,null,null,"Weekly Schedule 04"]
[]
[null,null,null,"Quick Tip  ➜"]
[{"$nulls":5},"Highlight \"Names\" and all the cells below it, then go to Data > Filter Views > Create New Filter View to be able to filter for specific names."]
[]
[]
[]
[{"$nulls":4},"2017-01-22"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[null,null,null,"Names",8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E20:$L20, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M20:$T20, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U20:$AB20, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-23"]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E32:$L32, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M32:$T32, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U32:$AB32, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-24"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E44:$L44, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M44:$T44, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U44:$AB44, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-25"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E56:$L56, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M56:$T56, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U56:$AB56, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-26"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E68:$L68, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M68:$T68, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U68:$AB68, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-27"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E80:$L80, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M80:$T80, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U80:$AB80, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-28"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E92:$L92, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M92:$T92, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U92:$AB92, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]

{"sheet":"Week 5 Shifts","index":5,"n_rows":99,"n_cols":33,"rows_kept":99,"cut":false,"hidden":false,"merged":[[78,30,78,31],[78,32,78,33],[73,28,73,29],[73,30,73,31],[73,32,73,33],[74,28,74,29],[74,30,74,31],[74,32,74,33],[78,28,78,29],[81,30,81,31],[81,32,81,33],[79,28,79,29],[79,30,79,31],[79,32,79,33],[80,28,80,29],[80,30,80,31],[80,32,80,33],[81,28,81,29],[84,30,84,31],[84,32,84,33],[82,28,82,29],[82,30,82,31],[82,32,82,33],[83,28,83,29],[83,30,83,31],[83,32,83,33],[84,28,84,29],[90,30,90,31],[90,32,90,33],[85,28,85,29],[85,30,85,31],[85,32,85,33],[86,28,86,29],[86,30,86,31],[86,32,86,33],[90,28,90,29],[93,30,93,31],[93,32,93,33],[91,28,91,29],[91,30,91,31],[91,32,91,33],[92,28,92,29],[92,30,92,31],[92,32,92,33],[93,28,93,29],[96,30,96,31],[96,32,96,33],[94,28,94,29],[94,30,94,31],[94,32,94,33],[95,28,95,29],[95,30,95,31],[95,32,95,33],[96,28,96,29],[47,30,47,31],[47,32,47,33],[45,28,45,29],[45,30,45,31],[45,32,45,33],[46,28,46,29],[46,30,46,31],[46,32,46,33],[47,28,47,29],[54,30,54,31],[54,32,54,33],[49,28,49,29],[49,30,49,31],[49,32,49,33],[50,28,50,29],[50,30,50,31],[50,32,50,33],[54,28,54,29],[57,30,57,31],[57,32,57,33],[55,28,55,29],[55,30,55,31],[55,32,55,33],[56,28,56,29],[56,30,56,31],[56,32,56,33],[57,28,57,29],[97,28,97,29],[97,30,97,31],[97,32,97,33],[98,28,98,29],[98,30,98,31],[98,32,98,33],[25,28,25,29],[25,30,25,31],[25,32,25,33],[26,28,26,29],[26,30,26,31],[26,32,26,33],[27,4,27,33],[28,4,28,33],[29,4,29,11],[29,12,29,19],[29,20,29,27],[29,28,29,33],[30,30,30,31],[30,32,30,33],[7,3,7,25],[7,27,7,29],[8,3,8,5],[10,3,13,3],[11,5,12,31],[15,4,15,33],[16,4,16,33],[17,4,17,11],[17,12,17,19],[17,20,17,27],[17,28,17,33],[18,28,18,29],[18,30,18,31],[18,32,18,33],[21,30,21,31],[21,32,21,33],[19,28,19,29],[19,30,19,31],[19,32,19,33],[20,28,20,29],[20,30,20,31],[20,32,20,33],[21,28,21,29],[24,30,24,31],[24,32,24,33],[22,28,22,29],[22,30,22,31],[22,32,22,33],[23,28,23,29],[23,30,23,31],[23,32,23,33],[24,28,24,29],[30,28,30,29],[31,28,31,29],[31,30,31,31],[31,32,31,33],[32,28,32,29],[32,30,32,31],[32,32,32,33],[35,30,35,31],[35,32,35,33],[33,28,33,29],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[38,30,38,31],[38,32,38,33],[39,4,39,33],[40,4,40,33],[41,4,41,11],[41,12,41,19],[41,20,41,27],[41,28,41,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,28,37,29],[37,30,37,31],[37,32,37,33],[38,28,38,29],[44,30,44,31],[44,32,44,33],[42,28,42,29],[42,30,42,31],[42,32,42,33],[43,28,43,29],[43,30,43,31],[43,32,43,33],[44,28,44,29],[53,20,53,27],[53,28,53,33],[48,28,48,29],[48,30,48,31],[48,32,48,33],[51,4,51,33],[52,4,52,33],[53,4,53,11],[53,12,53,19],[60,30,60,31],[60,32,60,33],[63,4,63,33],[64,4,64,33],[65,4,65,11],[65,12,65,19],[65,20,65,27],[65,28,65,33],[58,28,58,29],[58,30,58,31],[58,32,58,33],[59,28,59,29],[59,30,59,31],[59,32,59,33],[60,28,60,29],[66,30,66,31],[66,32,66,33],[61,28,61,29],[61,30,61,31],[61,32,61,33],[62,28,62,29],[62,30,62,31],[62,32,62,33],[66,28,66,29],[69,30,69,31],[69,32,69,33],[67,28,67,29],[67,30,67,31],[67,32,67,33],[68,28,68,29],[68,30,68,31],[68,32,68,33],[69,28,69,29],[70,28,70,29],[70,30,70,31],[70,32,70,33],[71,28,71,29],[71,30,71,31],[71,32,71,33],[72,28,72,29],[77,20,77,27],[87,4,87,33],[88,4,88,33],[89,4,89,11],[89,12,89,19],[89,20,89,27],[89,28,89,33],[99,3,101,3],[72,30,72,31],[72,32,72,33],[75,4,75,33],[76,4,76,33],[77,4,77,11],[77,12,77,19],[77,28,77,33]]}
{"$rows_empty":7}
[null,null,null,"Jan 29 - Feb 4"]
[null,null,null,"Weekly Schedule 05"]
[]
[null,null,null,"Quick Tip  ➜"]
[{"$nulls":5},"Highlight \"Names\" and all the cells below it, then go to Data > Filter Views > Create New Filter View to be able to filter for specific names."]
[]
[]
[]
[{"$nulls":4},"2017-01-29"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[null,null,null,"Names",8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E20:$L20, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M20:$T20, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U20:$AB20, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-30"]
[{"$nulls":4},"Monday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E32:$L32, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M32:$T32, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U32:$AB32, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-01-31"]
[{"$nulls":4},"Tuesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E44:$L44, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M44:$T44, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U44:$AB44, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-02-01"]
[{"$nulls":4},"Wednesday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E56:$L56, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M56:$T56, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U56:$AB56, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-02-02"]
[{"$nulls":4},"Thursday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E68:$L68, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M68:$T68, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U68:$AB68, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-02-03"]
[{"$nulls":4},"Friday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E80:$L80, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M80:$T80, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U80:$AB80, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]
[{"$nulls":4},"2017-02-04"]
[{"$nulls":4},"Saturday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":4},8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,0.0,1.0,2.0,3.0,4.0,5.0,6.0,7.0,"A",null,"B",null,"C"]
[null,null,null,"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E92:$L92, \"=\"&AC$19)","v":0},null,{"$f":"COUNTIF($M92:$T92, \"=\"&AE$19)","v":0},null,{"$f":"COUNTIF($U92:$AB92, \"=\"&AG$19)","v":0}]
[null,null,null,"Ronny Reader",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Abby Author",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Casey Creator",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Molly Maker",{"$nulls":24},0,null,0,null,0]
[null,null,null,"Berry Books",{"$nulls":24},0,null,0,null,0]