{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Numbers","Daily Schedule"],"not_rendered":{"charts":0,"images":1,"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":"Numbers","index":0,"n_rows":101,"n_cols":12,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Payroll Budget Calculator"]
[]
[]
[null,null,null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Total"]
["Anticipated Merchandise Sales Per Day:",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:K6)","v":0}]
[null,"       Number of days per weeks you are open:"]
[]
["Designer Wages:"]
[null,"Hours avaliable = Sales * Target % / average hourly rate",null,null,{"$f":"IF(SUM(E6)=0,0,SUM((E6*$C34)/$C32)/100)","v":0},0,0,0,0,0,0,{"$f":"SUM(E10:K10)","v":0}]
[]
[null,null,"Hourly"]
[null,"Employee Name","Rate",null,"Hours","Hours","Hours","Hours","Hours","Hours","Hours","Total"]
[null,null,null,null,{"$f":"+'Daily Schedule'!B36","v":0},{"$f":"+'Daily Schedule'!B71","v":0},{"$f":"+'Daily Schedule'!B106","v":0},{"$f":"+'Daily Schedule'!B141","v":0},{"$f":"+'Daily Schedule'!B176","v":0},{"$f":"+'Daily Schedule'!B211","v":0},{"$f":"+'Daily Schedule'!B246","v":0},{"$f":"SUM(E14:K14)","v":0}]
[null,null,null,null,{"$f":"+'Daily Schedule'!C36","v":0},{"$f":"+'Daily Schedule'!C71","v":0},{"$f":"+'Daily Schedule'!C106","v":0},{"$f":"+'Daily Schedule'!C141","v":0},{"$f":"+'Daily Schedule'!C176","v":0},{"$f":"+'Daily Schedule'!C211","v":0},{"$f":"+'Daily Schedule'!C246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!D36","v":0},{"$f":"+'Daily Schedule'!D71","v":0},{"$f":"+'Daily Schedule'!D106","v":0},{"$f":"+'Daily Schedule'!D141","v":0},{"$f":"+'Daily Schedule'!D176","v":0},{"$f":"+'Daily Schedule'!D211","v":0},{"$f":"+'Daily Schedule'!D246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!E36","v":0},{"$f":"+'Daily Schedule'!E71","v":0},{"$f":"+'Daily Schedule'!E106","v":0},{"$f":"+'Daily Schedule'!E141","v":0},{"$f":"+'Daily Schedule'!E176","v":0},{"$f":"+'Daily Schedule'!E211","v":0},{"$f":"+'Daily Schedule'!E246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!F36","v":0},{"$f":"+'Daily Schedule'!F71","v":0},{"$f":"+'Daily Schedule'!F106","v":0},{"$f":"+'Daily Schedule'!F141","v":0},{"$f":"+'Daily Schedule'!F176","v":0},{"$f":"+'Daily Schedule'!F211","v":0},{"$f":"+'Daily Schedule'!F246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!G36","v":0},{"$f":"+'Daily Schedule'!G71","v":0},{"$f":"+'Daily Schedule'!G106","v":0},{"$f":"+'Daily Schedule'!G141","v":0},{"$f":"+'Daily Schedule'!G176","v":0},{"$f":"+'Daily Schedule'!G211","v":0},{"$f":"+'Daily Schedule'!G246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!H36","v":0},{"$f":"+'Daily Schedule'!H71","v":0},{"$f":"+'Daily Schedule'!H106","v":0},{"$f":"+'Daily Schedule'!H141","v":0},{"$f":"+'Daily Schedule'!H176","v":0},{"$f":"+'Daily Schedule'!H211","v":0},{"$f":"+'Daily Schedule'!H246","v":0},0]
[null,"     Number of employees",{"$f":"COUNT(C14:C20)","v":0},"Hours Used",{"$f":"SUM(E14:E20)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Hours Left",{"$f":"SUM(E10-E21)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Wages","Wages","Wages","Wages","Wages","Wages","Wages","Total"]
[null,{"$f":"+B14","v":0},0,null,{"$f":"SUM(E14*$C14)","v":0},0,0,0,0,0,0,{"$f":"SUM(E24:K24)","v":0}]
[null,{"$f":"+B15","v":0},0,null,{"$f":"SUM(E15*$C15)","v":0},0,0,0,0,0,0,{"$f":"SUM(E25:K25)","v":0}]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,{"$f":"SUM(E30:K30)","v":0}]
[null,"Total ",null,null,{"$f":"SUM(E24:E30)","v":0},0,0,0,0,0,0,0]
[null,"    Average pay rate",{"$f":"IF(SUM(C21)=0,0,SUM(C14:C20)/C21)","v":0}]
[]
[null,"My Target Percentage",13,null,{"$f":"IF(SUM(E6)=0,0,SUM(E31/E6))","v":0},0,0,0,0,0,0,{"$f":"SUM(E34:K34)/D7","v":{"$error":"#DIV/0!"}}]
[null,"Industry Target Percentage",15]
[]
["Sales & Administrative Wages:"]
[null,"Hours avaliable = Sales * Target % / average hourly rate",null,null,{"$f":"IF(SUM(E6)=0,0,SUM((E6*$C62)/$C60)/100)","v":0},0,0,0,0,0,0,{"$f":"SUM(E38:K38)","v":0}]
[]
[null,null,"Hourly"]
[null,"Employee Name","Rate",null,"Hours","Hours","Hours","Hours","Hours","Hours","Hours","Total"]
[null,null,null,null,{"$f":"+'Daily Schedule'!K36","v":0},{"$f":"+'Daily Schedule'!K71","v":0},{"$f":"+'Daily Schedule'!K106","v":0},{"$f":"+'Daily Schedule'!K141","v":0},{"$f":"+'Daily Schedule'!K176","v":0},{"$f":"+'Daily Schedule'!K211","v":0},{"$f":"+'Daily Schedule'!K246","v":0},{"$f":"SUM(E42:K42)","v":0}]
[null,null,null,null,{"$f":"+'Daily Schedule'!L36","v":0},{"$f":"+'Daily Schedule'!L71","v":0},{"$f":"+'Daily Schedule'!L106","v":0},{"$f":"+'Daily Schedule'!L141","v":0},{"$f":"+'Daily Schedule'!L176","v":0},{"$f":"+'Daily Schedule'!L211","v":0},{"$f":"+'Daily Schedule'!L246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!M36","v":0},{"$f":"+'Daily Schedule'!M71","v":0},{"$f":"+'Daily Schedule'!M106","v":0},{"$f":"+'Daily Schedule'!M141","v":0},{"$f":"+'Daily Schedule'!M176","v":0},{"$f":"+'Daily Schedule'!M211","v":0},{"$f":"+'Daily Schedule'!M246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!N36","v":0},{"$f":"+'Daily Schedule'!N71","v":0},{"$f":"+'Daily Schedule'!N106","v":0},{"$f":"+'Daily Schedule'!N141","v":0},{"$f":"+'Daily Schedule'!N176","v":0},{"$f":"+'Daily Schedule'!N211","v":0},{"$f":"+'Daily Schedule'!N246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!O36","v":0},{"$f":"+'Daily Schedule'!O71","v":0},{"$f":"+'Daily Schedule'!O106","v":0},{"$f":"+'Daily Schedule'!O141","v":0},{"$f":"+'Daily Schedule'!O176","v":0},{"$f":"+'Daily Schedule'!O211","v":0},{"$f":"+'Daily Schedule'!O246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!P36","v":0},{"$f":"+'Daily Schedule'!P71","v":0},{"$f":"+'Daily Schedule'!P106","v":0},{"$f":"+'Daily Schedule'!P141","v":0},{"$f":"+'Daily Schedule'!P176","v":0},{"$f":"+'Daily Schedule'!P211","v":0},{"$f":"+'Daily Schedule'!P246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!Q36","v":0},{"$f":"+'Daily Schedule'!Q71","v":0},{"$f":"+'Daily Schedule'!Q106","v":0},{"$f":"+'Daily Schedule'!Q141","v":0},{"$f":"+'Daily Schedule'!Q176","v":0},{"$f":"+'Daily Schedule'!Q211","v":0},{"$f":"+'Daily Schedule'!Q246","v":0},0]
[null,"     Number of employees",{"$f":"COUNT(C42:C48)","v":0},"Hours Used",{"$f":"SUM(E42:E48)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Hours Left",{"$f":"SUM(E38-E49)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Wages","Wages","Wages","Wages","Wages","Wages","Wages","Total"]
[null,{"$f":"+B42","v":0},0,null,{"$f":"SUM(E42*$C42)","v":0},0,0,0,0,0,0,{"$f":"SUM(E52:K52)","v":0}]
[null,0,0,null,0,0,0,0,0,0,0,{"$f":"SUM(E53:K53)","v":0}]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,"Total ",null,null,{"$f":"SUM(E52:E58)","v":0},0,0,0,0,0,0,0]
[null,"    Average pay rate",{"$f":"IF(SUM(C49)=0,0,SUM(C42:C48)/C49)","v":0}]
[]
[null,"My Target Percentage",5,null,{"$f":"IF(SUM(E6)=0,0,SUM(E$59/E6))","v":0},0,0,0,0,0,0,{"$f":"SUM(E62:K62)/D7","v":{"$error":"#DIV/0!"}}]
[null,"Industry Target Percentage",5]
[]
["Delivery Wages:"]
[null,"Hours avaliable = Sales * Target % / average hourly rate",null,null,{"$f":"IF(SUM(E6)=0,0,SUM((E6*$C90)/$C88)/100)","v":0},0,0,0,0,0,0,{"$f":"SUM(E66:K66)","v":0}]
[]
[null,null,"Hourly"]
[null,"Employee Name","Rate",null,"Hours","Hours","Hours","Hours","Hours","Hours","Hours","Total"]
[null,null,null,null,{"$f":"+'Daily Schedule'!T36","v":0},{"$f":"+'Daily Schedule'!T71","v":0},{"$f":"+'Daily Schedule'!T106","v":0},{"$f":"+'Daily Schedule'!T141","v":0},{"$f":"+'Daily Schedule'!T176","v":0},{"$f":"+'Daily Schedule'!T211","v":0},{"$f":"+'Daily Schedule'!T246","v":0},{"$f":"SUM(E70:K70)","v":0}]
[null,null,null,null,{"$f":"+'Daily Schedule'!U36","v":0},{"$f":"+'Daily Schedule'!U71","v":0},{"$f":"+'Daily Schedule'!U106","v":0},{"$f":"+'Daily Schedule'!U141","v":0},{"$f":"+'Daily Schedule'!U176","v":0},{"$f":"+'Daily Schedule'!U211","v":0},{"$f":"+'Daily Schedule'!U246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!V36","v":0},{"$f":"+'Daily Schedule'!V71","v":0},{"$f":"+'Daily Schedule'!V106","v":0},{"$f":"+'Daily Schedule'!V141","v":0},{"$f":"+'Daily Schedule'!V176","v":0},{"$f":"+'Daily Schedule'!V211","v":0},{"$f":"+'Daily Schedule'!V246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!W36","v":0},{"$f":"+'Daily Schedule'!W71","v":0},{"$f":"+'Daily Schedule'!W106","v":0},{"$f":"+'Daily Schedule'!W141","v":0},{"$f":"+'Daily Schedule'!W176","v":0},{"$f":"+'Daily Schedule'!W211","v":0},{"$f":"+'Daily Schedule'!W246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!X36","v":0},{"$f":"+'Daily Schedule'!X71","v":0},{"$f":"+'Daily Schedule'!X106","v":0},{"$f":"+'Daily Schedule'!X141","v":0},{"$f":"+'Daily Schedule'!X176","v":0},{"$f":"+'Daily Schedule'!X211","v":0},{"$f":"+'Daily Schedule'!X246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!Y36","v":0},{"$f":"+'Daily Schedule'!Y71","v":0},{"$f":"+'Daily Schedule'!Y106","v":0},{"$f":"+'Daily Schedule'!Y141","v":0},{"$f":"+'Daily Schedule'!Y176","v":0},{"$f":"+'Daily Schedule'!Y211","v":0},{"$f":"+'Daily Schedule'!Y246","v":0},0]
[null,null,null,null,{"$f":"+'Daily Schedule'!Z36","v":0},{"$f":"+'Daily Schedule'!Z71","v":0},{"$f":"+'Daily Schedule'!Z106","v":0},{"$f":"+'Daily Schedule'!Z141","v":0},{"$f":"+'Daily Schedule'!Z176","v":0},{"$f":"+'Daily Schedule'!Z211","v":0},{"$f":"+'Daily Schedule'!Z246","v":0},0]
[null,"     Number of employees",{"$f":"COUNT(C70:C76)","v":0},"Hours Used",{"$f":"SUM(E70:E76)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Hours Left",{"$f":"SUM(E66-E77)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,"Wages","Wages","Wages","Wages","Wages","Wages","Wages","Total"]
[null,{"$f":"+B70","v":0},0,null,{"$f":"SUM(E70*$C70)","v":0},0,0,0,0,0,0,{"$f":"SUM(E80:K80)","v":0}]
[null,0,0,null,0,0,0,0,0,0,0,{"$f":"SUM(E81:K81)","v":0}]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,0]
[null,"Total ",null,null,{"$f":"SUM(E80:E86)","v":0},0,0,0,0,0,0,0]
[null,"    Average pay rate",{"$f":"IF(SUM(C77)=0,0,SUM(C70:C76)/C77)","v":0}]
[]
[null,"My Target Percentage",5,null,{"$f":"IF(SUM(E6)=0,0,SUM(E$87/E6))","v":0},0,0,0,0,0,0,{"$f":"SUM(E90:K90)/D7","v":{"$error":"#DIV/0!"}}]
[null,"Industry Target Percentage",5]
[]
[]
[]
[null,"Total Anticipated Payroll",null,null,{"$f":"SUM(E31+E59+E87)","v":0},0,0,0,0,0,0,{"$f":"SUM(E95:K95)","v":0}]
[null,"Total Payroll Percentage",null,null,{"$f":"IF(SUM(E6)=0,0,SUM(E95/E6))","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Average Daily Percentage:",null,{"$f":"IF(SUM(D7)=0,0,SUM(L96/D7))","v":0}]
[null,"Ctrl R - To Reset Worksheet for Next Payroll"]
[null,"Ctrl E -  To Erase Worksheet"]
[]
[null,"  © Crockett, Myers & Associates, Inc."]

{"sheet":"Daily Schedule","index":1,"n_rows":252,"n_cols":26,"rows_kept":252,"cut":false,"hidden":false,"merged":[]}
["Daily Schedule"]
["(Put the number 1 in each time block scheduled)"]
[]
[null,{"$f":"+Numbers!E5","v":"Monday"}]
[]
[null,"Designers",null,null,null,null,null,null,null,null,"Sales & Administrative",null,null,null,null,null,null,null,null,"Drivers"]
[null,{"$f":"+Numbers!$B$14","v":0},{"$f":"+Numbers!$B$15","v":0},{"$f":"+Numbers!$B$16","v":0},{"$f":"+Numbers!$B$17","v":0},{"$f":"+Numbers!$B$18","v":0},{"$f":"+Numbers!$B$19","v":0},{"$f":"+Numbers!$B$20","v":0},null,null,{"$f":"+Numbers!$B$42","v":0},{"$f":"+Numbers!$B$43","v":0},{"$f":"+Numbers!$B$44","v":0},{"$f":"+Numbers!$B$45","v":0},{"$f":"+Numbers!$B$46","v":0},{"$f":"+Numbers!$B$47","v":0},{"$f":"+Numbers!$B$48","v":0},null,null,{"$f":"+Numbers!$B$70","v":0},{"$f":"+Numbers!$B$71","v":0},{"$f":"+Numbers!$B$72","v":0},{"$f":"+Numbers!$B$73","v":0},{"$f":"+Numbers!$B$74","v":0},{"$f":"+Numbers!$B$75","v":0},{"$f":"+Numbers!$B$76","v":0}]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
["09:30:00",null,null,null,null,null,null,null,null,"09:30:00",null,null,null,null,null,null,null,null,"09:30:00"]
["10:00:00",null,null,null,null,null,null,null,null,"10:00:00",null,null,null,null,null,null,null,null,"10:00:00"]
["10:30:00",null,null,null,null,null,null,null,null,"10:30:00",null,null,null,null,null,null,null,null,"10:30:00"]
["11:00:00",null,null,null,null,null,null,null,null,"11:00:00",null,null,null,null,null,null,null,null,"11:00:00"]
["11:30:00",null,null,null,null,null,null,null,null,"11:30:00",null,null,null,null,null,null,null,null,"11:30:00"]
["12:00:00",null,null,null,null,null,null,null,null,"12:00:00",null,null,null,null,null,null,null,null,"12:00:00"]
["12:30:00",null,null,null,null,null,null,null,null,"12:30:00",null,null,null,null,null,null,null,null,"12:30:00"]
["01:00:00",null,null,null,null,null,null,null,null,"01:00:00",null,null,null,null,null,null,null,null,"01:00:00"]
["01:30:00",null,null,null,null,null,null,null,null,"01:30:00",null,null,null,null,null,null,null,null,"01:30:00"]
["02:00:00",null,null,null,null,null,null,null,null,"02:00:00",null,null,null,null,null,null,null,null,"02:00:00"]
["02:30:00",null,null,null,null,null,null,null,null,"02:30:00",null,null,null,null,null,null,null,null,"02:30:00"]
["03:00:00",null,null,null,null,null,null,null,null,"03:00:00",null,null,null,null,null,null,null,null,"03:00:00"]
["03:30:00",null,null,null,null,null,null,null,null,"03:30:00",null,null,null,null,null,null,null,null,"03:30:00"]
["04:00:00",null,null,null,null,null,null,null,null,"04:00:00",null,null,null,null,null,null,null,null,"04:00:00"]
["04:30:00",null,null,null,null,null,null,null,null,"04:30:00",null,null,null,null,null,null,null,null,"04:30:00"]
["05:00:00",null,null,null,null,null,null,null,null,"05:00:00",null,null,null,null,null,null,null,null,"05:00:00"]
["05:30:00",null,null,null,null,null,null,null,null,"05:30:00",null,null,null,null,null,null,null,null,"05:30:00"]
["06:00:00",null,null,null,null,null,null,null,null,"06:00:00",null,null,null,null,null,null,null,null,"06:00:00"]
["06:30:00",null,null,null,null,null,null,null,null,"06:30:00",null,null,null,null,null,null,null,null,"06:30:00"]
["07:00:00",null,null,null,null,null,null,null,null,"07:00:00",null,null,null,null,null,null,null,null,"07:00:00"]
["07:30:00",null,null,null,null,null,null,null,null,"07:30:00",null,null,null,null,null,null,null,null,"07:30:00"]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
[]
[null,{"$f":"SUM(B8:B34)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(K8:K34)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(T8:T34)/2","v":0},0,0,0,0,0,0]
[null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(B36:H36)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(K36:Q36)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(T36:Z36)","v":0}]
[]
[null,{"$f":"+Numbers!F5","v":"Tuesday"}]
[]
[null,"Designers",null,null,null,null,null,null,null,null,"Sales & Administrative",null,null,null,null,null,null,null,null,"Drivers"]
[null,{"$f":"+Numbers!$B$14","v":0},{"$f":"+Numbers!$B$15","v":0},{"$f":"+Numbers!$B$16","v":0},{"$f":"+Numbers!$B$17","v":0},{"$f":"+Numbers!$B$18","v":0},{"$f":"+Numbers!$B$19","v":0},{"$f":"+Numbers!$B$20","v":0},null,null,{"$f":"+Numbers!$B$42","v":0},{"$f":"+Numbers!$B$43","v":0},{"$f":"+Numbers!$B$44","v":0},{"$f":"+Numbers!$B$45","v":0},{"$f":"+Numbers!$B$46","v":0},{"$f":"+Numbers!$B$47","v":0},{"$f":"+Numbers!$B$48","v":0},null,null,{"$f":"+Numbers!$B$70","v":0},{"$f":"+Numbers!$B$71","v":0},{"$f":"+Numbers!$B$72","v":0},{"$f":"+Numbers!$B$73","v":0},{"$f":"+Numbers!$B$74","v":0},{"$f":"+Numbers!$B$75","v":0},{"$f":"+Numbers!$B$76","v":0}]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
["09:30:00",null,null,null,null,null,null,null,null,"09:30:00",null,null,null,null,null,null,null,null,"09:30:00"]
["10:00:00",null,null,null,null,null,null,null,null,"10:00:00",null,null,null,null,null,null,null,null,"10:00:00"]
["10:30:00",null,null,null,null,null,null,null,null,"10:30:00",null,null,null,null,null,null,null,null,"10:30:00"]
["11:00:00",null,null,null,null,null,null,null,null,"11:00:00",null,null,null,null,null,null,null,null,"11:00:00"]
["11:30:00",null,null,null,null,null,null,null,null,"11:30:00",null,null,null,null,null,null,null,null,"11:30:00"]
["12:00:00",null,null,null,null,null,null,null,null,"12:00:00",null,null,null,null,null,null,null,null,"12:00:00"]
["12:30:00",null,null,null,null,null,null,null,null,"12:30:00",null,null,null,null,null,null,null,null,"12:30:00"]
["01:00:00",null,null,null,null,null,null,null,null,"01:00:00",null,null,null,null,null,null,null,null,"01:00:00"]
["01:30:00",null,null,null,null,null,null,null,null,"01:30:00",null,null,null,null,null,null,null,null,"01:30:00"]
["02:00:00",null,null,null,null,null,null,null,null,"02:00:00",null,null,null,null,null,null,null,null,"02:00:00"]
["02:30:00",null,null,null,null,null,null,null,null,"02:30:00",null,null,null,null,null,null,null,null,"02:30:00"]
["03:00:00",null,null,null,null,null,null,null,null,"03:00:00",null,null,null,null,null,null,null,null,"03:00:00"]
["03:30:00",null,null,null,null,null,null,null,null,"03:30:00",null,null,null,null,null,null,null,null,"03:30:00"]
["04:00:00",null,null,null,null,null,null,null,null,"04:00:00",null,null,null,null,null,null,null,null,"04:00:00"]
["04:30:00",null,null,null,null,null,null,null,null,"04:30:00",null,null,null,null,null,null,null,null,"04:30:00"]
["05:00:00",null,null,null,null,null,null,null,null,"05:00:00",null,null,null,null,null,null,null,null,"05:00:00"]
["05:30:00",null,null,null,null,null,null,null,null,"05:30:00",null,null,null,null,null,null,null,null,"05:30:00"]
["06:00:00",null,null,null,null,null,null,null,null,"06:00:00",null,null,null,null,null,null,null,null,"06:00:00"]
["06:30:00",null,null,null,null,null,null,null,null,"06:30:00",null,null,null,null,null,null,null,null,"06:30:00"]
["07:00:00",null,null,null,null,null,null,null,null,"07:00:00",null,null,null,null,null,null,null,null,"07:00:00"]
["07:30:00",null,null,null,null,null,null,null,null,"07:30:00",null,null,null,null,null,null,null,null,"07:30:00"]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
[]
[null,{"$f":"SUM(B43:B69)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(K43:K69)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(T43:T69)/2","v":0},0,0,0,0,0,0]
[null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(B71:H71)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(K71:Q71)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(T71:Z71)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Sales & Administrative",null,null,null,null,null,null,null,null,"Drivers"]
[null,{"$f":"+Numbers!$B$14","v":0},{"$f":"+Numbers!$B$15","v":0},{"$f":"+Numbers!$B$16","v":0},{"$f":"+Numbers!$B$17","v":0},{"$f":"+Numbers!$B$18","v":0},{"$f":"+Numbers!$B$19","v":0},{"$f":"+Numbers!$B$20","v":0},null,null,{"$f":"+Numbers!$B$42","v":0},{"$f":"+Numbers!$B$43","v":0},{"$f":"+Numbers!$B$44","v":0},{"$f":"+Numbers!$B$45","v":0},{"$f":"+Numbers!$B$46","v":0},{"$f":"+Numbers!$B$47","v":0},{"$f":"+Numbers!$B$48","v":0},null,null,{"$f":"+Numbers!$B$70","v":0},{"$f":"+Numbers!$B$71","v":0},{"$f":"+Numbers!$B$72","v":0},{"$f":"+Numbers!$B$73","v":0},{"$f":"+Numbers!$B$74","v":0},{"$f":"+Numbers!$B$75","v":0},{"$f":"+Numbers!$B$76","v":0}]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
["09:30:00",null,null,null,null,null,null,null,null,"09:30:00",null,null,null,null,null,null,null,null,"09:30:00"]
["10:00:00",null,null,null,null,null,null,null,null,"10:00:00",null,null,null,null,null,null,null,null,"10:00:00"]
["10:30:00",null,null,null,null,null,null,null,null,"10:30:00",null,null,null,null,null,null,null,null,"10:30:00"]
["11:00:00",null,null,null,null,null,null,null,null,"11:00:00",null,null,null,null,null,null,null,null,"11:00:00"]
["11:30:00",null,null,null,null,null,null,null,null,"11:30:00",null,null,null,null,null,null,null,null,"11:30:00"]
["12:00:00",null,null,null,null,null,null,null,null,"12:00:00",null,null,null,null,null,null,null,null,"12:00:00"]
["12:30:00",null,null,null,null,null,null,null,null,"12:30:00",null,null,null,null,null,null,null,null,"12:30:00"]
["01:00:00",null,null,null,null,null,null,null,null,"01:00:00",null,null,null,null,null,null,null,null,"01:00:00"]
["01:30:00",null,null,null,null,null,null,null,null,"01:30:00",null,null,null,null,null,null,null,null,"01:30:00"]
["02:00:00",null,null,null,null,null,null,null,null,"02:00:00",null,null,null,null,null,null,null,null,"02:00:00"]
["02:30:00",null,null,null,null,null,null,null,null,"02:30:00",null,null,null,null,null,null,null,null,"02:30:00"]
["03:00:00",null,null,null,null,null,null,null,null,"03:00:00",null,null,null,null,null,null,null,null,"03:00:00"]
["03:30:00",null,null,null,null,null,null,null,null,"03:30:00",null,null,null,null,null,null,null,null,"03:30:00"]
["04:00:00",null,null,null,null,null,null,null,null,"04:00:00",null,null,null,null,null,null,null,null,"04:00:00"]
["04:30:00",null,null,null,null,null,null,null,null,"04:30:00",null,null,null,null,null,null,null,null,"04:30:00"]
["05:00:00",null,null,null,null,null,null,null,null,"05:00:00",null,null,null,null,null,null,null,null,"05:00:00"]
["05:30:00",null,null,null,null,null,null,null,null,"05:30:00",null,null,null,null,null,null,null,null,"05:30:00"]
["06:00:00",null,null,null,null,null,null,null,null,"06:00:00",null,null,null,null,null,null,null,null,"06:00:00"]
["06:30:00",null,null,null,null,null,null,null,null,"06:30:00",null,null,null,null,null,null,null,null,"06:30:00"]
["07:00:00",null,null,null,null,null,null,null,null,"07:00:00",null,null,null,null,null,null,null,null,"07:00:00"]
["07:30:00",null,null,null,null,null,null,null,null,"07:30:00",null,null,null,null,null,null,null,null,"07:30:00"]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
[]
[null,{"$f":"SUM(B78:B104)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(K78:K104)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(T78:T104)/2","v":0},0,0,0,0,0,0]
[null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(B106:H106)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(K106:Q106)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(T106:Z106)","v":0}]
[]
[null,{"$f":"+Numbers!H5","v":"Thursday"}]
[]
[null,"Designers",null,null,null,null,null,null,null,null,"Sales & Administrative",null,null,null,null,null,null,null,null,"Drivers"]
[null,{"$f":"+Numbers!$B$14","v":0},{"$f":"+Numbers!$B$15","v":0},{"$f":"+Numbers!$B$16","v":0},{"$f":"+Numbers!$B$17","v":0},{"$f":"+Numbers!$B$18","v":0},{"$f":"+Numbers!$B$19","v":0},{"$f":"+Numbers!$B$20","v":0},null,null,{"$f":"+Numbers!$B$42","v":0},{"$f":"+Numbers!$B$43","v":0},{"$f":"+Numbers!$B$44","v":0},{"$f":"+Numbers!$B$45","v":0},{"$f":"+Numbers!$B$46","v":0},{"$f":"+Numbers!$B$47","v":0},{"$f":"+Numbers!$B$48","v":0},null,null,{"$f":"+Numbers!$B$70","v":0},{"$f":"+Numbers!$B$71","v":0},{"$f":"+Numbers!$B$72","v":0},{"$f":"+Numbers!$B$73","v":0},{"$f":"+Numbers!$B$74","v":0},{"$f":"+Numbers!$B$75","v":0},{"$f":"+Numbers!$B$76","v":0}]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
["09:30:00",null,null,null,null,null,null,null,null,"09:30:00",null,null,null,null,null,null,null,null,"09:30:00"]
["10:00:00",null,null,null,null,null,null,null,null,"10:00:00",null,null,null,null,null,null,null,null,"10:00:00"]
["10:30:00",null,null,null,null,null,null,null,null,"10:30:00",null,null,null,null,null,null,null,null,"10:30:00"]
["11:00:00",null,null,null,null,null,null,null,null,"11:00:00",null,null,null,null,null,null,null,null,"11:00:00"]
["11:30:00",null,null,null,null,null,null,null,null,"11:30:00",null,null,null,null,null,null,null,null,"11:30:00"]
["12:00:00",null,null,null,null,null,null,null,null,"12:00:00",null,null,null,null,null,null,null,null,"12:00:00"]
["12:30:00",null,null,null,null,null,null,null,null,"12:30:00",null,null,null,null,null,null,null,null,"12:30:00"]
["01:00:00",null,null,null,null,null,null,null,null,"01:00:00",null,null,null,null,null,null,null,null,"01:00:00"]
["01:30:00",null,null,null,null,null,null,null,null,"01:30:00",null,null,null,null,null,null,null,null,"01:30:00"]
["02:00:00",null,null,null,null,null,null,null,null,"02:00:00",null,null,null,null,null,null,null,null,"02:00:00"]
["02:30:00",null,null,null,null,null,null,null,null,"02:30:00",null,null,null,null,null,null,null,null,"02:30:00"]
["03:00:00",null,null,null,null,null,null,null,null,"03:00:00",null,null,null,null,null,null,null,null,"03:00:00"]
["03:30:00",null,null,null,null,null,null,null,null,"03:30:00",null,null,null,null,null,null,null,null,"03:30:00"]
["04:00:00",null,null,null,null,null,null,null,null,"04:00:00",null,null,null,null,null,null,null,null,"04:00:00"]
["04:30:00",null,null,null,null,null,null,null,null,"04:30:00",null,null,null,null,null,null,null,null,"04:30:00"]
["05:00:00",null,null,null,null,null,null,null,null,"05:00:00",null,null,null,null,null,null,null,null,"05:00:00"]
["05:30:00",null,null,null,null,null,null,null,null,"05:30:00",null,null,null,null,null,null,null,null,"05:30:00"]
["06:00:00",null,null,null,null,null,null,null,null,"06:00:00",null,null,null,null,null,null,null,null,"06:00:00"]
["06:30:00",null,null,null,null,null,null,null,null,"06:30:00",null,null,null,null,null,null,null,null,"06:30:00"]
["07:00:00",null,null,null,null,null,null,null,null,"07:00:00",null,null,null,null,null,null,null,null,"07:00:00"]
["07:30:00",null,null,null,null,null,null,null,null,"07:30:00",null,null,null,null,null,null,null,null,"07:30:00"]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
[]
[null,{"$f":"SUM(B113:B139)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(K113:K139)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(T113:T139)/2","v":0},0,0,0,0,0,0]
[null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(B141:H141)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(K141:Q141)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(T141:Z141)","v":0}]
[]
[null,{"$f":"+Numbers!I5","v":"Friday"}]
[]
[null,"Designers",null,null,null,null,null,null,null,null,"Sales & Administrative",null,null,null,null,null,null,null,null,"Drivers"]
[null,{"$f":"+Numbers!$B$14","v":0},{"$f":"+Numbers!$B$15","v":0},{"$f":"+Numbers!$B$16","v":0},{"$f":"+Numbers!$B$17","v":0},{"$f":"+Numbers!$B$18","v":0},{"$f":"+Numbers!$B$19","v":0},{"$f":"+Numbers!$B$20","v":0},null,null,{"$f":"+Numbers!$B$42","v":0},{"$f":"+Numbers!$B$43","v":0},{"$f":"+Numbers!$B$44","v":0},{"$f":"+Numbers!$B$45","v":0},{"$f":"+Numbers!$B$46","v":0},{"$f":"+Numbers!$B$47","v":0},{"$f":"+Numbers!$B$48","v":0},null,null,{"$f":"+Numbers!$B$70","v":0},{"$f":"+Numbers!$B$71","v":0},{"$f":"+Numbers!$B$72","v":0},{"$f":"+Numbers!$B$73","v":0},{"$f":"+Numbers!$B$74","v":0},{"$f":"+Numbers!$B$75","v":0},{"$f":"+Numbers!$B$76","v":0}]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
["09:30:00",null,null,null,null,null,null,null,null,"09:30:00",null,null,null,null,null,null,null,null,"09:30:00"]
["10:00:00",null,null,null,null,null,null,null,null,"10:00:00",null,null,null,null,null,null,null,null,"10:00:00"]
["10:30:00",null,null,null,null,null,null,null,null,"10:30:00",null,null,null,null,null,null,null,null,"10:30:00"]
["11:00:00",null,null,null,null,null,null,null,null,"11:00:00",null,null,null,null,null,null,null,null,"11:00:00"]
["11:30:00",null,null,null,null,null,null,null,null,"11:30:00",null,null,null,null,null,null,null,null,"11:30:00"]
["12:00:00",null,null,null,null,null,null,null,null,"12:00:00",null,null,null,null,null,null,null,null,"12:00:00"]
["12:30:00",null,null,null,null,null,null,null,null,"12:30:00",null,null,null,null,null,null,null,null,"12:30:00"]
["01:00:00",null,null,null,null,null,null,null,null,"01:00:00",null,null,null,null,null,null,null,null,"01:00:00"]
["01:30:00",null,null,null,null,null,null,null,null,"01:30:00",null,null,null,null,null,null,null,null,"01:30:00"]
["02:00:00",null,null,null,null,null,null,null,null,"02:00:00",null,null,null,null,null,null,null,null,"02:00:00"]
["02:30:00",null,null,null,null,null,null,null,null,"02:30:00",null,null,null,null,null,null,null,null,"02:30:00"]
["03:00:00",null,null,null,null,null,null,null,null,"03:00:00",null,null,null,null,null,null,null,null,"03:00:00"]
["03:30:00",null,null,null,null,null,null,null,null,"03:30:00",null,null,null,null,null,null,null,null,"03:30:00"]
["04:00:00",null,null,null,null,null,null,null,null,"04:00:00",null,null,null,null,null,null,null,null,"04:00:00"]
["04:30:00",null,null,null,null,null,null,null,null,"04:30:00",null,null,null,null,null,null,null,null,"04:30:00"]
["05:00:00",null,null,null,null,null,null,null,null,"05:00:00",null,null,null,null,null,null,null,null,"05:00:00"]
["05:30:00",null,null,null,null,null,null,null,null,"05:30:00",null,null,null,null,null,null,null,null,"05:30:00"]
["06:00:00",null,null,null,null,null,null,null,null,"06:00:00",null,null,null,null,null,null,null,null,"06:00:00"]
["06:30:00",null,null,null,null,null,null,null,null,"06:30:00",null,null,null,null,null,null,null,null,"06:30:00"]
["07:00:00",null,null,null,null,null,null,null,null,"07:00:00",null,null,null,null,null,null,null,null,"07:00:00"]
["07:30:00",null,null,null,null,null,null,null,null,"07:30:00",null,null,null,null,null,null,null,null,"07:30:00"]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
[]
[null,{"$f":"SUM(B148:B174)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(K148:K174)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(T148:T174)/2","v":0},0,0,0,0,0,0]
[null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(B176:H176)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(K176:Q176)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(T176:Z176)","v":0}]
[]
[null,{"$f":"+Numbers!J5","v":"Saturday"}]
[]
[null,"Designers",null,null,null,null,null,null,null,null,"Sales & Administrative",null,null,null,null,null,null,null,null,"Drivers"]
[null,{"$f":"+Numbers!$B$14","v":0},{"$f":"+Numbers!$B$15","v":0},{"$f":"+Numbers!$B$16","v":0},{"$f":"+Numbers!$B$17","v":0},{"$f":"+Numbers!$B$18","v":0},{"$f":"+Numbers!$B$19","v":0},{"$f":"+Numbers!$B$20","v":0},null,null,{"$f":"+Numbers!$B$42","v":0},{"$f":"+Numbers!$B$43","v":0},{"$f":"+Numbers!$B$44","v":0},{"$f":"+Numbers!$B$45","v":0},{"$f":"+Numbers!$B$46","v":0},{"$f":"+Numbers!$B$47","v":0},{"$f":"+Numbers!$B$48","v":0},null,null,{"$f":"+Numbers!$B$70","v":0},{"$f":"+Numbers!$B$71","v":0},{"$f":"+Numbers!$B$72","v":0},{"$f":"+Numbers!$B$73","v":0},{"$f":"+Numbers!$B$74","v":0},{"$f":"+Numbers!$B$75","v":0},{"$f":"+Numbers!$B$76","v":0}]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
["09:30:00",null,null,null,null,null,null,null,null,"09:30:00",null,null,null,null,null,null,null,null,"09:30:00"]
["10:00:00",null,null,null,null,null,null,null,null,"10:00:00",null,null,null,null,null,null,null,null,"10:00:00"]
["10:30:00",null,null,null,null,null,null,null,null,"10:30:00",null,null,null,null,null,null,null,null,"10:30:00"]
["11:00:00",null,null,null,null,null,null,null,null,"11:00:00",null,null,null,null,null,null,null,null,"11:00:00"]
["11:30:00",null,null,null,null,null,null,null,null,"11:30:00",null,null,null,null,null,null,null,null,"11:30:00"]
["12:00:00",null,null,null,null,null,null,null,null,"12:00:00",null,null,null,null,null,null,null,null,"12:00:00"]
["12:30:00",null,null,null,null,null,null,null,null,"12:30:00",null,null,null,null,null,null,null,null,"12:30:00"]
["01:00:00",null,null,null,null,null,null,null,null,"01:00:00",null,null,null,null,null,null,null,null,"01:00:00"]
["01:30:00",null,null,null,null,null,null,null,null,"01:30:00",null,null,null,null,null,null,null,null,"01:30:00"]
["02:00:00",null,null,null,null,null,null,null,null,"02:00:00",null,null,null,null,null,null,null,null,"02:00:00"]
["02:30:00",null,null,null,null,null,null,null,null,"02:30:00",null,null,null,null,null,null,null,null,"02:30:00"]
["03:00:00",null,null,null,null,null,null,null,null,"03:00:00",null,null,null,null,null,null,null,null,"03:00:00"]
["03:30:00",null,null,null,null,null,null,null,null,"03:30:00",null,null,null,null,null,null,null,null,"03:30:00"]
["04:00:00",null,null,null,null,null,null,null,null,"04:00:00",null,null,null,null,null,null,null,null,"04:00:00"]
["04:30:00",null,null,null,null,null,null,null,null,"04:30:00",null,null,null,null,null,null,null,null,"04:30:00"]
["05:00:00",null,null,null,null,null,null,null,null,"05:00:00",null,null,null,null,null,null,null,null,"05:00:00"]
["05:30:00",null,null,null,null,null,null,null,null,"05:30:00",null,null,null,null,null,null,null,null,"05:30:00"]
["06:00:00",null,null,null,null,null,null,null,null,"06:00:00",null,null,null,null,null,null,null,null,"06:00:00"]
["06:30:00",null,null,null,null,null,null,null,null,"06:30:00",null,null,null,null,null,null,null,null,"06:30:00"]
["07:00:00",null,null,null,null,null,null,null,null,"07:00:00",null,null,null,null,null,null,null,null,"07:00:00"]
["07:30:00",null,null,null,null,null,null,null,null,"07:30:00",null,null,null,null,null,null,null,null,"07:30:00"]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
[]
[null,{"$f":"SUM(B183:B209)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(K183:K209)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(T183:T209)/2","v":0},0,0,0,0,0,0]
[null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(B211:H211)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(K211:Q211)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(T211:Z211)","v":0}]
[]
[null,{"$f":"+Numbers!K5","v":"Sunday"}]
[]
[null,"Designers",null,null,null,null,null,null,null,null,"Sales & Administrative",null,null,null,null,null,null,null,null,"Drivers"]
[null,{"$f":"+Numbers!$B$14","v":0},{"$f":"+Numbers!$B$15","v":0},{"$f":"+Numbers!$B$16","v":0},{"$f":"+Numbers!$B$17","v":0},{"$f":"+Numbers!$B$18","v":0},{"$f":"+Numbers!$B$19","v":0},{"$f":"+Numbers!$B$20","v":0},null,null,{"$f":"+Numbers!$B$42","v":0},{"$f":"+Numbers!$B$43","v":0},{"$f":"+Numbers!$B$44","v":0},{"$f":"+Numbers!$B$45","v":0},{"$f":"+Numbers!$B$46","v":0},{"$f":"+Numbers!$B$47","v":0},{"$f":"+Numbers!$B$48","v":0},null,null,{"$f":"+Numbers!$B$70","v":0},{"$f":"+Numbers!$B$71","v":0},{"$f":"+Numbers!$B$72","v":0},{"$f":"+Numbers!$B$73","v":0},{"$f":"+Numbers!$B$74","v":0},{"$f":"+Numbers!$B$75","v":0},{"$f":"+Numbers!$B$76","v":0}]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
["09:30:00",null,null,null,null,null,null,null,null,"09:30:00",null,null,null,null,null,null,null,null,"09:30:00"]
["10:00:00",null,null,null,null,null,null,null,null,"10:00:00",null,null,null,null,null,null,null,null,"10:00:00"]
["10:30:00",null,null,null,null,null,null,null,null,"10:30:00",null,null,null,null,null,null,null,null,"10:30:00"]
["11:00:00",null,null,null,null,null,null,null,null,"11:00:00",null,null,null,null,null,null,null,null,"11:00:00"]
["11:30:00",null,null,null,null,null,null,null,null,"11:30:00",null,null,null,null,null,null,null,null,"11:30:00"]
["12:00:00",null,null,null,null,null,null,null,null,"12:00:00",null,null,null,null,null,null,null,null,"12:00:00"]
["12:30:00",null,null,null,null,null,null,null,null,"12:30:00",null,null,null,null,null,null,null,null,"12:30:00"]
["01:00:00",null,null,null,null,null,null,null,null,"01:00:00",null,null,null,null,null,null,null,null,"01:00:00"]
["01:30:00",null,null,null,null,null,null,null,null,"01:30:00",null,null,null,null,null,null,null,null,"01:30:00"]
["02:00:00",null,null,null,null,null,null,null,null,"02:00:00",null,null,null,null,null,null,null,null,"02:00:00"]
["02:30:00",null,null,null,null,null,null,null,null,"02:30:00",null,null,null,null,null,null,null,null,"02:30:00"]
["03:00:00",null,null,null,null,null,null,null,null,"03:00:00",null,null,null,null,null,null,null,null,"03:00:00"]
["03:30:00",null,null,null,null,null,null,null,null,"03:30:00",null,null,null,null,null,null,null,null,"03:30:00"]
["04:00:00",null,null,null,null,null,null,null,null,"04:00:00",null,null,null,null,null,null,null,null,"04:00:00"]
["04:30:00",null,null,null,null,null,null,null,null,"04:30:00",null,null,null,null,null,null,null,null,"04:30:00"]
["05:00:00",null,null,null,null,null,null,null,null,"05:00:00",null,null,null,null,null,null,null,null,"05:00:00"]
["05:30:00",null,null,null,null,null,null,null,null,"05:30:00",null,null,null,null,null,null,null,null,"05:30:00"]
["06:00:00",null,null,null,null,null,null,null,null,"06:00:00",null,null,null,null,null,null,null,null,"06:00:00"]
["06:30:00",null,null,null,null,null,null,null,null,"06:30:00",null,null,null,null,null,null,null,null,"06:30:00"]
["07:00:00",null,null,null,null,null,null,null,null,"07:00:00",null,null,null,null,null,null,null,null,"07:00:00"]
["07:30:00",null,null,null,null,null,null,null,null,"07:30:00",null,null,null,null,null,null,null,null,"07:30:00"]
["08:00:00",null,null,null,null,null,null,null,null,"08:00:00",null,null,null,null,null,null,null,null,"08:00:00"]
["08:30:00",null,null,null,null,null,null,null,null,"08:30:00",null,null,null,null,null,null,null,null,"08:30:00"]
["09:00:00",null,null,null,null,null,null,null,null,"09:00:00",null,null,null,null,null,null,null,null,"09:00:00"]
[]
[null,{"$f":"SUM(B218:B244)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(K218:K244)/2","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(T218:T244)/2","v":0},0,0,0,0,0,0]
[null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(B246:H246)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(K246:Q246)","v":0},null,null,null,null,null,"                    Total Hours for Day:",null,null,{"$f":"SUM(T246:Z246)","v":0}]
[]
[]
[]
[null,{"$f":"SUM(B36+B71+B106+B141+B176+B211+B246)","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(K36+K71+K106+K141+K176+K211+K246)","v":0},0,0,0,0,0,0,null,null,{"$f":"SUM(T36+T71+T106+T141+T176+T211+T246)","v":0},0,0,0,0,0,0]
[null,null,null,null,"                 Total Hours for Week:",null,null,{"$f":"SUM(B251:H251)","v":0},null,null,null,null,null,"                 Total Hours for Week:",null,null,{"$f":"SUM(K251:Q251)","v":0},null,null,null,null,null,"                 Total Hours for Week:",null,null,{"$f":"SUM(T251:Z251)","v":0}]