{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Overview","Week 1 Shifts"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":31,"n_cols":35,"rows_kept":31,"merged":[[1,3,1,25],[1,27,1,29],[2,3,2,5],[8,4,8,13],[8,14,8,23],[8,24,8,33],[8,34,8,43],[9,4,9,13],[9,14,9,23],[9,24,9,33],[9,34,9,43],[10,4,10,13],[10,14,10,23],[10,24,10,33],[10,34,10,43],[11,4,11,13],[11,14,11,23],[11,24,11,33],[11,34,11,43],[16,4,16,33],[16,34,16,43],[17,4,17,13],[17,14,17,23],[17,24,17,33],[17,34,17,43],[18,4,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,16,18,17],[18,18,18,19],[18,20,18,21],[18,22,18,23],[18,24,18,25],[18,26,18,27],[18,28,18,29],[18,30,18,31],[18,32,18,33],[18,34,18,43],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[19,22,19,23],[19,24,19,25],[19,26,19,27],[19,28,19,29],[19,30,19,31],[19,32,19,33],[19,34,19,43],[20,4,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,16,20,17],[20,18,20,19],[20,20,20,21],[20,22,20,23],[20,24,20,25],[20,26,20,27],[20,28,20,29],[20,30,20,31],[20,32,20,33],[20,34,20,43],[21,4,21,5],[21,6,21,7],[21,8,21,9],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,16,21,17],[21,18,21,19],[21,20,21,21],[21,22,21,23],[21,24,21,25],[21,26,21,27],[21,28,21,29],[21,30,21,31],[21,32,21,33],[21,34,21,43],[22,4,22,5],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,19],[22,20,22,21],[22,22,22,23],[22,24,22,25],[22,26,22,27],[22,28,22,29],[22,30,22,31],[22,32,22,33],[22,34,22,43],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[23,22,23,23],[23,24,23,25],[23,26,23,27],[23,28,23,29],[23,30,23,31],[23,32,23,33],[23,34,23,43],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,12,24,13],[24,14,24,15],[24,16,24,17],[24,18,24,19],[24,20,24,21],[24,22,24,23],[24,24,24,25],[24,26,24,27],[24,28,24,29],[24,30,24,31],[24,32,24,33],[24,34,24,43],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[25,16,25,17],[25,18,25,19],[25,20,25,21],[25,22,25,23],[25,24,25,25],[25,26,25,27],[25,28,25,29],[25,30,25,31],[25,32,25,33],[25,34,25,43],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[26,20,26,21],[26,22,26,23],[26,24,26,25],[26,26,26,27],[26,28,26,29],[26,30,26,31],[26,32,26,33],[26,34,26,43],[27,4,27,5],[27,6,27,7],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[27,22,27,23],[27,24,27,25],[27,26,27,27],[27,28,27,29],[27,30,27,31],[27,32,27,33],[27,34,27,43],[28,34,28,36]]}
[]
[{"$nulls":3},"Company / Business"]
[{"$nulls":3},"Shift Schedule Jan 2021"]
[]
[]
[]
[{"$nulls":3},"Shift Details"]
[]
[{"$nulls":3},"Shift","Duration ",{"$nulls":9},"Period",{"$nulls":9},"Hourly Wage",{"$nulls":9},"Employees per Shift"]
[{"$nulls":3},"A","8 hours",{"$nulls":9},"08:00 - 16:00",{"$nulls":9},{"v":45,"d":"£45"},{"$nulls":9},4]
[{"$nulls":3},"B","8 hours",{"$nulls":9},"16:00 - 00:00",{"$nulls":9},{"v":55,"d":"£55"},{"$nulls":9},3]
[{"$nulls":3},"C","8 hours",{"$nulls":9},"00:00 - 07:00",{"$nulls":9},{"v":85,"d":"£85"},{"$nulls":9},2]
[]
[]
[{"$nulls":3},"Employee Wage Overview"]
[]
[{"$nulls":3},"Employee's Name","Shift",{"$nulls":29},"Monthly Wage"]
[{"$nulls":4},"A",{"$nulls":9},"B",{"$nulls":9},"C"]
[{"$nulls":3},"Name","W1",null,"W2",null,"W3",null,"W4",null,"W5",null,"W1",null,"W2",null,"W3",null,"W4",null,"W5",null,"W1",null,"W2",null,"W3",null,"W4",null,"W5"]
[{"$nulls":3},"Wendy Writer",{"$f":"'Week 1 Shifts'!AC11+'Week 1 Shifts'!AC23+'Week 1 Shifts'!AC35+'Week 1 Shifts'!AC47+'Week 1 Shifts'!AC59+'Week 1 Shifts'!AC71+'Week 1 Shifts'!AC83","v":16},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AE11+'Week 1 Shifts'!AE23+'Week 1 Shifts'!AE35+'Week 1 Shifts'!AE47+'Week 1 Shifts'!AE59+'Week 1 Shifts'!AE71+'Week 1 Shifts'!AE83","v":16},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AG11+'Week 1 Shifts'!AG23+'Week 1 Shifts'!AG35+'Week 1 Shifts'!AG47+'Week 1 Shifts'!AG59+'Week 1 Shifts'!AG71+'Week 1 Shifts'!AG83","v":16},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(E20:N20)*Y10+SUM(O20:X20)*Y11+SUM(Y20:AH20)*Y12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Ronny Reader",{"$f":"'Week 1 Shifts'!AC12+'Week 1 Shifts'!AC24+'Week 1 Shifts'!AC36+'Week 1 Shifts'!AC48+'Week 1 Shifts'!AC60+'Week 1 Shifts'!AC72+'Week 1 Shifts'!AC84","v":24},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AE12+'Week 1 Shifts'!AE24+'Week 1 Shifts'!AE36+'Week 1 Shifts'!AE48+'Week 1 Shifts'!AE60+'Week 1 Shifts'!AE72+'Week 1 Shifts'!AE84","v":32},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AG12+'Week 1 Shifts'!AG24+'Week 1 Shifts'!AG36+'Week 1 Shifts'!AG48+'Week 1 Shifts'!AG60+'Week 1 Shifts'!AG72+'Week 1 Shifts'!AG84","v":40},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(E21:N21)*Y10+SUM(O21:X21)*Y11+SUM(Y21:AH21)*Y12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Abby Author",{"$f":"'Week 1 Shifts'!AC13+'Week 1 Shifts'!AC25+'Week 1 Shifts'!AC37+'Week 1 Shifts'!AC49+'Week 1 Shifts'!AC61+'Week 1 Shifts'!AC73+'Week 1 Shifts'!AC85","v":32},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AE13+'Week 1 Shifts'!AE25+'Week 1 Shifts'!AE37+'Week 1 Shifts'!AE49+'Week 1 Shifts'!AE61+'Week 1 Shifts'!AE73+'Week 1 Shifts'!AE85","v":32},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AG13+'Week 1 Shifts'!AG25+'Week 1 Shifts'!AG37+'Week 1 Shifts'!AG49+'Week 1 Shifts'!AG61+'Week 1 Shifts'!AG73+'Week 1 Shifts'!AG85","v":16},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(E22:N22)*Y10+SUM(O22:X22)*Y11+SUM(Y22:AH22)*Y12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Casey Creator",{"$f":"'Week 1 Shifts'!AC14+'Week 1 Shifts'!AC26+'Week 1 Shifts'!AC38+'Week 1 Shifts'!AC50+'Week 1 Shifts'!AC62+'Week 1 Shifts'!AC74+'Week 1 Shifts'!AC86","v":24},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AE14+'Week 1 Shifts'!AE26+'Week 1 Shifts'!AE38+'Week 1 Shifts'!AE50+'Week 1 Shifts'!AE62+'Week 1 Shifts'!AE74+'Week 1 Shifts'!AE86","v":30},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AG14+'Week 1 Shifts'!AG26+'Week 1 Shifts'!AG38+'Week 1 Shifts'!AG50+'Week 1 Shifts'!AG62+'Week 1 Shifts'!AG74+'Week 1 Shifts'!AG86","v":8},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(E23:N23)*Y10+SUM(O23:X23)*Y11+SUM(Y23:AH23)*Y12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Perry Presenter",{"$f":"'Week 1 Shifts'!AC15+'Week 1 Shifts'!AC27+'Week 1 Shifts'!AC39+'Week 1 Shifts'!AC51+'Week 1 Shifts'!AC63+'Week 1 Shifts'!AC75+'Week 1 Shifts'!AC87","v":8},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AE15+'Week 1 Shifts'!AE27+'Week 1 Shifts'!AE39+'Week 1 Shifts'!AE51+'Week 1 Shifts'!AE63+'Week 1 Shifts'!AE75+'Week 1 Shifts'!AE87","v":18},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AG15+'Week 1 Shifts'!AG27+'Week 1 Shifts'!AG39+'Week 1 Shifts'!AG51+'Week 1 Shifts'!AG63+'Week 1 Shifts'!AG75+'Week 1 Shifts'!AG87","v":24},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(E24:L24)*Y10+SUM(O24:V24)*Y11+SUM(Y24:AF24)*Y12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Vinny Viewer",{"$f":"'Week 1 Shifts'!AC16+'Week 1 Shifts'!AC28+'Week 1 Shifts'!AC40+'Week 1 Shifts'!AC52+'Week 1 Shifts'!AC64+'Week 1 Shifts'!AC76+'Week 1 Shifts'!AC88","v":24},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AE16+'Week 1 Shifts'!AE28+'Week 1 Shifts'!AE40+'Week 1 Shifts'!AE52+'Week 1 Shifts'!AE64+'Week 1 Shifts'!AE76+'Week 1 Shifts'!AE88","v":16},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AG16+'Week 1 Shifts'!AG28+'Week 1 Shifts'!AG40+'Week 1 Shifts'!AG52+'Week 1 Shifts'!AG64+'Week 1 Shifts'!AG76+'Week 1 Shifts'!AG88","v":24},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(E25:N25)*Y10+SUM(O25:X25)*Y11+SUM(Y25:AH25)*Y12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Molly Maker",{"$f":"'Week 1 Shifts'!AC17+'Week 1 Shifts'!AC29+'Week 1 Shifts'!AC41+'Week 1 Shifts'!AC53+'Week 1 Shifts'!AC65+'Week 1 Shifts'!AC77+'Week 1 Shifts'!AC89","v":24},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AE17+'Week 1 Shifts'!AE29+'Week 1 Shifts'!AE41+'Week 1 Shifts'!AE53+'Week 1 Shifts'!AE65+'Week 1 Shifts'!AE77+'Week 1 Shifts'!AE89","v":16},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AG17+'Week 1 Shifts'!AG29+'Week 1 Shifts'!AG41+'Week 1 Shifts'!AG53+'Week 1 Shifts'!AG65+'Week 1 Shifts'!AG77+'Week 1 Shifts'!AG89","v":24},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(E26:N26)*Y10+SUM(O26:X26)*Y11+SUM(Y26:AH26)*Y12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Berry Books",{"$f":"'Week 1 Shifts'!AC18+'Week 1 Shifts'!AC30+'Week 1 Shifts'!AC42+'Week 1 Shifts'!AC54+'Week 1 Shifts'!AC66+'Week 1 Shifts'!AC78+'Week 1 Shifts'!AC90","v":16},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AE18+'Week 1 Shifts'!AE30+'Week 1 Shifts'!AE42+'Week 1 Shifts'!AE54+'Week 1 Shifts'!AE66+'Week 1 Shifts'!AE78+'Week 1 Shifts'!AE90","v":8},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"'Week 1 Shifts'!AG18+'Week 1 Shifts'!AG30+'Week 1 Shifts'!AG42+'Week 1 Shifts'!AG54+'Week 1 Shifts'!AG66+'Week 1 Shifts'!AG78+'Week 1 Shifts'!AG90","v":16},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!+#REF!+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(E27:N27)*Y10+SUM(O27:X27)*Y11+SUM(Y27:AH27)*Y12","v":{"$error":"#REF!"}}]
[{"$nulls":3},"Total Hours / per week",{"$f":"SUM(E20:F27)","v":168},null,{"$f":"SUM(G20:H27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(I20:J27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(K20:L27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(M20:N27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(O20:P27)","v":168},null,{"$f":"SUM(Q20:R27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(S20:T27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(U20:V27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(W20:X27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(Y20:Z27)","v":168},null,{"$f":"SUM(AA20:AB27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(AC20:AD27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(AE20:AF27)","v":{"$error":"#REF!"}},null,{"$f":"SUM(AG20:AH27)","v":{"$error":"#REF!"}}]
[]
[]
[{"$nulls":3},"Spreadsheet Templates - http://www.spreadsheettemplates.info/"]

{"sheet":"Week 1 Shifts","index":1,"n_rows":90,"n_cols":33,"rows_kept":90,"merged":[[3,3,3,25],[3,27,3,29],[4,3,4,5],[6,4,6,33],[7,4,7,33],[8,4,8,11],[8,12,8,19],[8,20,8,27],[8,28,8,33],[9,28,9,29],[9,30,9,31],[9,32,9,33],[10,28,10,29],[10,30,10,31],[10,32,10,33],[11,28,11,29],[11,30,11,31],[11,32,11,33],[12,28,12,29],[12,30,12,31],[12,32,12,33],[13,28,13,29],[13,30,13,31],[13,32,13,33],[14,28,14,29],[14,30,14,31],[14,32,14,33],[15,28,15,29],[15,30,15,31],[15,32,15,33],[16,28,16,29],[16,30,16,31],[16,32,16,33],[17,28,17,29],[17,30,17,31],[17,32,17,33],[18,4,18,33],[19,4,19,33],[20,4,20,11],[20,12,20,19],[20,20,20,27],[20,28,20,33],[21,28,21,29],[21,30,21,31],[21,32,21,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],[24,30,24,31],[24,32,24,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,28,27,29],[27,30,27,31],[27,32,27,33],[28,28,28,29],[28,30,28,31],[28,32,28,33],[29,28,29,29],[29,30,29,31],[29,32,29,33],[30,4,30,33],[31,4,31,33],[32,4,32,11],[32,12,32,19],[32,20,32,27],[32,28,32,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],[35,30,35,31],[35,32,35,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],[38,30,38,31],[38,32,38,33],[39,28,39,29],[39,30,39,31],[39,32,39,33],[40,28,40,29],[40,30,40,31],[40,32,40,33],[41,28,41,29],[41,30,41,31],[41,32,41,33],[42,4,42,33],[43,4,43,33],[44,4,44,11],[44,12,44,19],[44,20,44,27],[44,28,44,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],[47,30,47,31],[47,32,47,33],[48,28,48,29],[48,30,48,31],[48,32,48,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],[51,28,51,29],[51,30,51,31],[51,32,51,33],[52,28,52,29],[52,30,52,31],[52,32,52,33],[53,28,53,29],[53,30,53,31],[53,32,53,33],[54,4,54,33],[55,4,55,33],[56,4,56,11],[56,12,56,19],[56,20,56,27],[56,28,56,33],[57,28,57,29],[57,30,57,31],[57,32,57,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],[60,30,60,31],[60,32,60,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],[63,28,63,29],[63,30,63,31],[63,32,63,33],[64,28,64,29],[64,30,64,31],[64,32,64,33],[65,28,65,29],[65,30,65,31],[65,32,65,33],[66,4,66,33],[67,4,67,33],[68,4,68,11],[68,12,68,19],[68,20,68,27],[68,28,68,33],[69,28,69,29],[69,30,69,31],[69,32,69,33],[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],[72,30,72,31],[72,32,72,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],[75,28,75,29],[75,30,75,31],[75,32,75,33],[76,28,76,29],[76,30,76,31],[76,32,76,33],[77,28,77,29],[77,30,77,31],[77,32,77,33],[78,4,78,33],[79,4,79,33],[80,4,80,11],[80,12,80,19],[80,20,80,27],[80,28,80,33],[81,28,81,29],[81,30,81,31],[81,32,81,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],[84,30,84,31],[84,32,84,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],[87,28,87,29],[87,30,87,31],[87,32,87,33],[88,28,88,29],[88,30,88,31],[88,32,88,33],[89,28,89,29],[89,30,89,31],[89,32,89,33],[90,3,92,3]]}
[]
[]
[]
[{"$nulls":3},"1 Jan - 7 Jan"]
[{"$nulls":3},"Weekly Schedule 01"]
[]
[{"$nulls":4},"2017-01-01"]
[{"$nulls":4},"Sunday"]
[{"$nulls":4},"Shift A",{"$nulls":7},"Shift B",{"$nulls":7},"Shift C",{"$nulls":7},"Total Shifts"]
[{"$nulls":3},"Names",8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,"A",null,"B",null,"C"]
[{"$nulls":3},"Wendy Writer","A","A","A","A","A","A","A","A","B","B","B","B","B","B","B","B",{"$nulls":8},{"$f":"COUNTIF($E11:$L11, \"=\"&AC$10)","v":8},null,{"$f":"COUNTIF($M11:$T11, \"=\"&AE$10)","v":8},null,{"$f":"COUNTIF($U11:$AB11, \"=\"&AG$10)","v":0}]
[{"$nulls":3},"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]
[{"$nulls":3},"Abby Author",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"Casey Creator","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[{"$nulls":3},"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"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]
[{"$nulls":3},"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]
[{"$nulls":3},"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,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,"A",null,"B",null,"C"]
[{"$nulls":3},"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E23:$L23, \"=\"&AC$10)","v":0},null,{"$f":"COUNTIF($M23:$T23, \"=\"&AE$10)","v":0},null,{"$f":"COUNTIF($U23:$AB23, \"=\"&AG$10)","v":0}]
[{"$nulls":3},"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]
[{"$nulls":3},"Abby Author",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[{"$nulls":3},"Casey Creator","A","A","A","A","A","A","A","A","B","B","B","B","B","B",{"$nulls":10},8,null,6,null,0]
[{"$nulls":3},"Perry Presenter",{"$nulls":14},"B","B","C","C","C","C","C","C","C","C",0,null,2,null,8]
[{"$nulls":3},"Vinny Viewer",{"$nulls":8},"B","B","B","B","B","B","B","B",{"$nulls":8},0,null,8,null,0]
[{"$nulls":3},"Molly Maker","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[{"$nulls":3},"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,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,"A",null,"B",null,"C"]
[{"$nulls":3},"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E35:$L35, \"=\"&AC$10)","v":0},null,{"$f":"COUNTIF($M35:$T35, \"=\"&AE$10)","v":0},null,{"$f":"COUNTIF($U35:$AB35, \"=\"&AG$10)","v":0}]
[{"$nulls":3},"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]
[{"$nulls":3},"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]
[{"$nulls":3},"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]
[{"$nulls":3},"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"Molly Maker",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[{"$nulls":3},"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,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,"A",null,"B",null,"C"]
[{"$nulls":3},"Wendy Writer",{"$nulls":16},"C","C","C","C","C","C","C","C",{"$f":"COUNTIF($E47:$L47, \"=\"&AC$10)","v":0},null,{"$f":"COUNTIF($M47:$T47, \"=\"&AE$10)","v":0},null,{"$f":"COUNTIF($U47:$AB47, \"=\"&AG$10)","v":8}]
[{"$nulls":3},"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]
[{"$nulls":3},"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]
[{"$nulls":3},"Casey Creator",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"Perry Presenter",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"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]
[{"$nulls":3},"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]
[{"$nulls":3},"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,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,"A",null,"B",null,"C"]
[{"$nulls":3},"Wendy Writer","A","A","A","A","A","A","A","A",{"$nulls":16},{"$f":"COUNTIF($E59:$L59, \"=\"&AC$10)","v":8},null,{"$f":"COUNTIF($M59:$T59, \"=\"&AE$10)","v":0},null,{"$f":"COUNTIF($U59:$AB59, \"=\"&AG$10)","v":0}]
[{"$nulls":3},"Ronny Reader","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[{"$nulls":3},"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]
[{"$nulls":3},"Casey Creator",{"$nulls":8},"B","B","B","B","B","B","B","B",{"$nulls":8},0,null,8,null,0]
[{"$nulls":3},"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]
[{"$nulls":3},"Vinny Viewer",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"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]
[{"$nulls":3},"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,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,"A",null,"B",null,"C"]
[{"$nulls":3},"Wendy Writer",{"$nulls":8},"B","B","B","B","B","B","B","B","C","C","C","C","C","C","C","C",{"$f":"COUNTIF($E71:$L71, \"=\"&AC$10)","v":0},null,{"$f":"COUNTIF($M71:$T71, \"=\"&AE$10)","v":8},null,{"$f":"COUNTIF($U71:$AB71, \"=\"&AG$10)","v":8}]
[{"$nulls":3},"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]
[{"$nulls":3},"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]
[{"$nulls":3},"Casey Creator",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"Perry Presenter",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[{"$nulls":3},"Vinny Viewer",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[{"$nulls":3},"Molly Maker",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"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,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7,"A",null,"B",null,"C"]
[{"$nulls":3},"Wendy Writer",{"$nulls":24},{"$f":"COUNTIF($E83:$L83, \"=\"&AC$10)","v":0},null,{"$f":"COUNTIF($M83:$T83, \"=\"&AE$10)","v":0},null,{"$f":"COUNTIF($U83:$AB83, \"=\"&AG$10)","v":0}]
[{"$nulls":3},"Ronny Reader",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]
[{"$nulls":3},"Abby Author","A","A","A","A","A","A","A","A",{"$nulls":16},8,null,0,null,0]
[{"$nulls":3},"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]
[{"$nulls":3},"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]
[{"$nulls":3},"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]
[{"$nulls":3},"Molly Maker",{"$nulls":24},0,null,0,null,0]
[{"$nulls":3},"Berry Books",{"$nulls":16},"C","C","C","C","C","C","C","C",0,null,0,null,8]