{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Schedule","Employee Info","Carriers","Formulas"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":26,"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":"Schedule","index":0,"n_rows":86,"n_cols":25,"rows_kept":86,"cut":false,"hidden":false,"merged":[[17,7,17,8],[17,9,17,10],[21,0,22,2],[12,5,12,6],[12,7,12,8],[12,9,12,10],[17,5,17,6],[21,5,21,6],[21,7,21,8],[19,5,19,6],[13,7,13,8],[13,9,13,10],[19,3,19,4],[17,3,17,4],[1,13,1,15],[13,0,14,2],[15,0,16,2],[17,0,18,2],[19,0,20,2],[12,3,12,4],[23,13,23,14],[33,13,33,14],[17,11,17,12],[25,13,25,14],[21,11,21,12],[31,0,32,2],[21,13,21,14],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[12,11,12,12],[12,13,12,14],[17,13,17,14],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[23,0,24,2],[25,0,26,2],[27,0,28,2],[29,0,30,2],[49,0,50,2],[51,0,52,2],[53,0,54,2],[21,9,21,10],[27,3,27,4],[33,0,34,2],[43,9,43,10],[37,3,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[49,5,49,6],[49,7,49,8],[49,9,49,10],[47,3,47,4],[47,5,47,6],[57,0,58,2],[41,0,42,2],[43,0,44,2],[45,0,46,2],[47,0,48,2],[55,0,56,2],[33,11,33,12],[33,3,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[41,3,41,4],[41,5,41,6],[37,0,38,2],[39,0,40,2],[57,3,57,4],[57,5,57,6],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[57,9,57,10],[53,9,53,10],[55,11,55,12],[13,17,14,17],[15,17,16,17],[57,11,57,12],[57,13,57,14],[57,7,57,8],[47,13,47,14],[41,13,41,14],[27,13,27,14],[39,11,39,12],[39,13,39,14],[43,13,43,14],[45,11,45,12],[45,13,45,14],[49,11,49,12],[49,13,49,14],[47,9,47,10],[47,11,47,12],[41,7,41,8],[41,9,41,10],[41,11,41,12],[27,9,27,10],[27,11,27,12],[17,17,18,17],[43,11,43,12],[55,13,55,14],[37,13,37,14],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,11,53,12],[53,13,53,14],[51,11,51,12],[51,13,51,14],[49,3,49,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[47,7,47,8],[23,11,23,12],[21,3,21,4],[25,3,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[27,5,27,6],[27,7,27,8],[13,11,13,12],[13,13,13,14],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[13,3,13,4],[13,5,13,6],[56,17,57,17],[42,17,43,17],[44,17,45,17],[46,17,47,17],[48,17,49,17],[50,17,51,17],[52,17,53,17],[19,17,20,17],[21,17,22,17],[23,17,24,17],[25,17,26,17],[27,17,28,17],[29,17,30,17],[31,17,32,17],[33,17,34,17],[36,17,37,17],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[38,17,39,17],[40,17,41,17],[54,17,55,17],[39,3,39,4],[43,3,43,4],[43,5,43,6],[43,7,43,8],[37,11,37,12],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10]]}
[null,null,null,"Cowboy Donuts Work Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1666666666666671E-2]
[]
[null,null,null,{"$f":"\"Year: \"&year","v":"Year: 2014"},null,null,null,null,null,"Week:",null,{"$f":"week","v":4},null,null,null,null,"[42]"]
[]
[null,null,null,"Month:",null,{"$f":"monthName","v":"July"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Week"]
["2-Week Work Schedule"]
[{"$f":"TEXT(INDEX(Formulas!B$21:B$26,week),\"Mmmm d, yyyy\")&\" - \"","v":"July 20, 2014 - "}]
[{"$f":"TEXT(INDEX(Formulas!H$21:H$27,week+1),\"Mmmm d, yyyy\")","v":"August 2, 2014"}]
[]
[]
["[42]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly totals"]
[null,null,null,{"$f":"Formulas!C$19&\" - \"&DAY(INDEX(Formulas!C$21:C$26,week))","v":"Mon - 21"},null,{"$f":"Formulas!D$19&\" - \"&DAY(INDEX(Formulas!D$21:D$26,week))","v":"Tue - 22"},null,{"$f":"Formulas!E$19&\" - \"&DAY(INDEX(Formulas!E$21:E$26,week))","v":"Wed - 23"},null,{"$f":"Formulas!F$19&\" - \"&DAY(INDEX(Formulas!F$21:F$26,week))","v":"Thu - 24"},null,{"$f":"Formulas!G$19&\" - \"&DAY(INDEX(Formulas!G$21:G$26,week))","v":"Fri - 25"},null,{"$f":"Formulas!H$19&\" - \"&DAY(INDEX(Formulas!H$21:H$26,week))","v":"Sat - 26"},null,null,null,"Employee Notes","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["Manager         ",null,null,"Jay ",null,"Jay",null,"Jay ",null,"Jay",null,"Jay ",null,"Jay",null,{"$f":"N14","v":"Jay"},{"$f":"SUM(S15:X15)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((E15-D15)/$S$1,\"\")","v":0},{"$f":"IFERROR((G15-F15)/$S$1,\"\")","v":0},{"$f":"IFERROR((I15-H15)/$S$1,\"\")","v":0},{"$f":"IFERROR((K15-J15)/$S$1,\"\")","v":0},{"$f":"IFERROR((M15-L15)/$S$1,\"\")","v":0},{"$f":"IFERROR((O15-N15)/$S$1,\"\")","v":0}]
["Supervisor       ",null,null,"Penny",null,"Penny",null,"Penny",null,"Penny",null,"Penny",null,"Penny",null,{"$f":"N16","v":"Penny"},{"$f":"SUM(S17:X17)","v":0},null,{"$f":"IFERROR((E16-D16),\"\")","v":""},{"$f":"IFERROR((G16-F16),\"\")","v":""},{"$f":"IFERROR((I16-H16),\"\")","v":""},{"$f":"IFERROR((K16-J16),\"\")","v":""},{"$f":"IFERROR((M16-L16),\"\")","v":""},{"$f":"IFERROR((O16-N16),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((E17-D17)/$S$1,\"\")","v":0},{"$f":"IFERROR((G17-F17)/$S$1,\"\")","v":0},{"$f":"IFERROR((I17-H17)/$S$1,\"\")","v":0},{"$f":"IFERROR((K17-J17)/$S$1,\"\")","v":0},{"$f":"IFERROR((M17-L17)/$S$1,\"\")","v":0},{"$f":"IFERROR((O17-N17)/$S$1,\"\")","v":0}]
["Baker",null,null,"Nissa",null,"Nissa",null,"Nissa",null,"Nissa",null,"Nissa",null,"Nissa",null,{"$f":"N18","v":"Nissa"},{"$f":"SUM(S19:X19)","v":27.000000000000007},null,{"$f":"IFERROR((E18-D18),\"\")","v":""},{"$f":"IFERROR((G18-F18),\"\")","v":""},{"$f":"IFERROR((I18-H18),\"\")","v":""},{"$f":"IFERROR((K18-J18),\"\")","v":""},{"$f":"IFERROR((M18-L18),\"\")","v":""},{"$f":"IFERROR((O18-N18),\"\")","v":""}]
[null,null,null,"OFF","OFF","02:00:00","07:00:00","02:00:00","07:30:00","02:00:00","07:30:00","02:00:00","07:30:00","02:00:00","07:30:00",null,null,null,{"$f":"IFERROR((E19-D19)/$S$1,\"\")","v":""},{"$f":"IFERROR((G19-F19)/$S$1,\"\")","v":5.000000000000008},{"$f":"IFERROR((I19-H19)/$S$1,\"\")","v":5.5},{"$f":"IFERROR((K19-J19)/$S$1,\"\")","v":5.5},{"$f":"IFERROR((M19-L19)/$S$1,\"\")","v":5.5},{"$f":"IFERROR((O19-N19)/$S$1,\"\")","v":5.5}]
["Baker's Asst. ",null,null,"Tracie",null,"Tracie",null,"Tracie",null,"Tracie",null,"Tracie",null,"Tracie",null,{"$f":"N20","v":"Tracie"},{"$f":"SUM(S21:X21)","v":32.50000000000005}]
[null,null,null,"06:00:00","13:00:00","06:00:00","14:00:00","06:00:00","14:00:00","06:00:00","10:45:00","06:00:00","10:45:00","OFF","OFF",null,null,null,{"$f":"IFERROR((E21-D21)/$S$1,\"\")","v":7.0000000000000062},{"$f":"IFERROR((G21-F21)/$S$1,\"\")","v":8.000000000000016},{"$f":"IFERROR((I21-H21)/$S$1,\"\")","v":8.000000000000016},{"$f":"IFERROR((K21-J21)/$S$1,\"\")","v":4.750000000000008},{"$f":"IFERROR((M21-L21)/$S$1,\"\")","v":4.750000000000008},{"$f":"IFERROR((O21-N21)/$S$1,\"\")","v":""}]
["Fryer",null,null,"Kristi",null,"Kristi",null,"Kristi",null,"Kristi",null,"Kristi",null,"Kristi",null,{"$f":"N22","v":"Kristi"},{"$f":"SUM(S23:X23)","v":36.000000000000092}]
[null,null,null,"02:00:00","08:00:00","02:00:00","08:00:00","02:00:00","08:00:00","02:00:00","08:00:00","02:00:00","08:00:00","02:00:00","08:00:00",null,null,null,{"$f":"IFERROR((E23-D23)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((G23-F23)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((I23-H23)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((K23-J23)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((M23-L23)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((O23-N23)/$S$1,\"\")","v":6.0000000000000151}]
["Icer",null,null,"Will",null,"Will",null,"Will",null,"Will",null,"Will",null,"Will",null,{"$f":"N24","v":"Will"},{"$f":"SUM(S25:X25)","v":23.250000000000007}]
[null,null,null,"02:45:00","07:00:00","OFF","OFF","02:45:00","07:30:00","02:45:00","07:30:00","02:45:00","07:30:00","02:45:00","07:30:00",null,null,null,{"$f":"IFERROR((E25-D25)/$S$1,\"\")","v":4.250000000000008},{"$f":"IFERROR((G25-F25)/$S$1,\"\")","v":""},{"$f":"IFERROR((I25-H25)/$S$1,\"\")","v":4.75},{"$f":"IFERROR((K25-J25)/$S$1,\"\")","v":4.75},{"$f":"IFERROR((M25-L25)/$S$1,\"\")","v":4.75},{"$f":"IFERROR((O25-N25)/$S$1,\"\")","v":4.75}]
["Cashier             ",null,null,"Tiffany",null,"Tiffany",null,"Tiffany",null,"Tiffany",null,"Tiffany",null,"Tiffany",null,{"$f":"N26","v":"Tiffany"},{"$f":"SUM(S27:X27)","v":28.000000000000028}]
[null,null,null,"04:00:00","10:00:00","06:00:00","10:00:00","06:00:00","10:00:00","06:00:00","10:00:00","06:00:00","10:00:00","04:00:00","10:00:00",null,null,null,{"$f":"IFERROR((E27-D27)/$S$1,\"\")","v":5.9999999999999991},{"$f":"IFERROR((G27-F27)/$S$1,\"\")","v":4.000000000000008},{"$f":"IFERROR((I27-H27)/$S$1,\"\")","v":4.000000000000008},{"$f":"IFERROR((K27-J27)/$S$1,\"\")","v":4.000000000000008},{"$f":"IFERROR((M27-L27)/$S$1,\"\")","v":4.000000000000008},{"$f":"IFERROR((O27-N27)/$S$1,\"\")","v":5.9999999999999991}]
["Cashier              ",null,null,"Emily",null,"Emily",null,"Emily",null,"Emily",null,"Emily",null,"Emily",null,{"$f":"N28","v":"Emily"},{"$f":"SUM(S29:X29)","v":24.000000000000043}]
[null,null,null,"04:00:00","08:00:00","04:00:00","08:00:00","04:00:00","08:00:00","04:00:00","08:00:00","04:00:00","08:00:00","04:00:00","08:00:00",null,null,null,{"$f":"IFERROR((E29-D29)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((G29-F29)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((I29-H29)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((K29-J29)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((M29-L29)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((O29-N29)/$S$1,\"\")","v":4.0000000000000071}]
["Cashier               ",null,null,"Danielle",null,"Danielle",null,"Danielle",null,"Danielle",null,"Danielle",null,"Danielle",null,{"$f":"N30","v":"Danielle"},{"$f":"SUM(S31:X31)","v":36.000000000000007}]
[null,null,null,"08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00",null,null,null,{"$f":"IFERROR((E31-D31)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((G31-F31)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((I31-H31)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((K31-J31)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((M31-L31)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((O31-N31)/$S$1,\"\")","v":6.0000000000000009}]
["Cashier               ",null,null,"Haley",null,"Haley",null,"Haley",null,"Haley",null,"Haley",null,"Haley",null,{"$f":"N32","v":"Haley"},{"$f":"SUM(S33:X33)","v":36.000000000000007}]
[null,null,null,"08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00",null,null,null,{"$f":"IFERROR((E33-D33)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((G33-F33)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((I33-H33)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((K33-J33)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((M33-L33)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((O33-N33)/$S$1,\"\")","v":6.0000000000000009}]
["Assistant      ",null,null,"Pauline",null,"Pauline",null,"Pauline",null,"Pauline",null,"Pauline",null,"Pauline",null,{"$f":"N34","v":"Pauline"},{"$f":"SUM(S35:X35)","v":36.000000000000007}]
[null,null,null,"08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00",null,null,null,{"$f":"IFERROR((E35-D35)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((G35-F35)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((I35-H35)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((K35-J35)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((M35-L35)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((O35-N35)/$S$1,\"\")","v":6.0000000000000009}]
["[42]",null,{"$f":"IF(MONTH(INDEX(Formulas!B$21:B$26,week+1))<>month,IF(DAY(INDEX(Formulas!B$21:B$26,week+1))=1,NextMonthName,\"\"),\"\")","v":""},{"$f":"IF(MONTH(INDEX(Formulas!C$21:C$26,week+1))<>month,IF(DAY(INDEX(Formulas!C$21:C$26,week+1))=1,NextMonthName,\"\"),\"\")","v":""},null,{"$f":"IF(MONTH(INDEX(Formulas!E$21:E$26,week+1))<>month,IF(DAY(INDEX(Formulas!E$21:E$26,week+1))=1,NextMonthName,\"\"),\"\")","v":""},null,{"$f":"IF(MONTH(INDEX(Formulas!G$21:G$26,week+1))<>month,IF(DAY(INDEX(Formulas!G$21:G$26,week+1))=1,NextMonthName,\"\"),\"\")","v":"August"},null,{"$f":"IF(MONTH(INDEX(Formulas!I$21:I$26,week+1))<>month,IF(DAY(INDEX(Formulas!I$21:I$26,week+1))=1,NextMonthName,\"\"),\"\")","v":""},null,null,null,null,null,null,null,"Notes Week 2"]
[null,null,null,{"$f":"Formulas!C$19&\" - \"&DAY(INDEX(Formulas!C$21:C$27,week+1))","v":"Mon - 28"},null,{"$f":"Formulas!D$19&\" - \"&DAY(INDEX(Formulas!D$21:D$27,week+1))","v":"Tue - 29"},null,{"$f":"Formulas!E$19&\" - \"&DAY(INDEX(Formulas!E$21:E$27,week+1))","v":"Wed - 30"},null,{"$f":"Formulas!F$19&\" - \"&DAY(INDEX(Formulas!F$21:F$27,week+1))","v":"Thu - 31"},null,{"$f":"Formulas!G$19&\" - \"&DAY(INDEX(Formulas!G$21:G$27,week+1))","v":"Fri - 1"},null,{"$f":"Formulas!H$19&\" - \"&DAY(INDEX(Formulas!H$21:H$27,week+1))","v":"Sat - 2"}]
["Manager         ",null,null,"Jay ",null,"Jay",null,"Jay ",null,"Jay",null,"Jay ",null,"Jay",null,{"$f":"N38","v":"Jay"},{"$f":"SUM(S39:X39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((E39-D39)/$S$1,\"\")","v":0},{"$f":"IFERROR((G39-F39)/$S$1,\"\")","v":0},{"$f":"IFERROR((I39-H39)/$S$1,\"\")","v":0},{"$f":"IFERROR((K39-J39)/$S$1,\"\")","v":0},{"$f":"IFERROR((M39-L39)/$S$1,\"\")","v":0},{"$f":"IFERROR((O39-N39)/$S$1,\"\")","v":0}]
["Supervisor       ",null,null,"Penny",null,"Penny",null,"Penny",null,"Penny",null,"Penny",null,"Penny",null,{"$f":"N40","v":"Penny"},{"$f":"SUM(S41:X41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((E41-D41)/$S$1,\"\")","v":0},{"$f":"IFERROR((G41-F41)/$S$1,\"\")","v":0},{"$f":"IFERROR((I41-H41)/$S$1,\"\")","v":0},{"$f":"IFERROR((K41-J41)/$S$1,\"\")","v":0},{"$f":"IFERROR((M41-L41)/$S$1,\"\")","v":0},{"$f":"IFERROR((O41-N41)/$S$1,\"\")","v":0}]
["Baker",null,null,"Nissa",null,"Nissa",null,"Nissa",null,"Nissa",null,"Nissa",null,"Nissa",null,{"$f":"N42","v":"Nissa"},{"$f":"SUM(S43:X43)","v":34.5}]
[null,null,null,"02:00:00","07:30:00","02:00:00","07:30:00","02:00:00","07:30:00","02:00:00","07:30:00","02:00:00","07:30:00","02:00:00","09:00:00",null,null,null,{"$f":"IFERROR((E43-D43)/$S$1,\"\")","v":5.5},{"$f":"IFERROR((G43-F43)/$S$1,\"\")","v":5.5},{"$f":"IFERROR((I43-H43)/$S$1,\"\")","v":5.5},{"$f":"IFERROR((K43-J43)/$S$1,\"\")","v":5.5},{"$f":"IFERROR((M43-L43)/$S$1,\"\")","v":5.5},{"$f":"IFERROR((O43-N43)/$S$1,\"\")","v":7}]
["Baker's Asst. ",null,null,"Tracie",null,"Tracie",null,"Tracie",null,"Tracie",null,"Tracie",null,"Tracie",null,{"$f":"N44","v":"Tracie"},{"$f":"SUM(S45:X45)","v":33.500000000000064},null,null,null,null,null,null,null,"(Should be =< 350)"]
[null,null,null,"06:00:00","14:00:00","06:00:00","14:00:00","06:00:00","14:00:00","06:00:00","10:45:00","06:00:00","10:45:00","OFF","OFF",null,null,null,{"$f":"IFERROR((E45-D45)/$S$1,\"\")","v":8.000000000000016},{"$f":"IFERROR((G45-F45)/$S$1,\"\")","v":8.000000000000016},{"$f":"IFERROR((I45-H45)/$S$1,\"\")","v":8.000000000000016},{"$f":"IFERROR((K45-J45)/$S$1,\"\")","v":4.750000000000008},{"$f":"IFERROR((M45-L45)/$S$1,\"\")","v":4.750000000000008},{"$f":"IFERROR((O45-N45)/$S$1,\"\")","v":""}]
["Fryer",null,null,"Kristi",null,"Kristi",null,"Kristi",null,"Kristi",null,"Kristi",null,"Kristi",null,{"$f":"N46","v":"Kristi"},{"$f":"SUM(S47:X47)","v":36.000000000000092}]
[null,null,null,"02:00:00","08:00:00","02:00:00","08:00:00","02:00:00","08:00:00","02:00:00","08:00:00","02:00:00","08:00:00","02:00:00","08:00:00",null,null,null,{"$f":"IFERROR((E47-D47)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((G47-F47)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((I47-H47)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((K47-J47)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((M47-L47)/$S$1,\"\")","v":6.0000000000000151},{"$f":"IFERROR((O47-N47)/$S$1,\"\")","v":6.0000000000000151}]
["Icer",null,null,"Will",null,"Will",null,"Will",null,"Will",null,"Will",null,"Will",null,{"$f":"N48","v":"Will"},{"$f":"SUM(S49:X49)","v":28.5}]
[null,null,null,"02:45:00","07:30:00","02:45:00","07:30:00","02:45:00","07:30:00","02:45:00","07:30:00","02:45:00","07:30:00","02:45:00","07:30:00",null,null,null,{"$f":"IFERROR((E49-D49)/$S$1,\"\")","v":4.75},{"$f":"IFERROR((G49-F49)/$S$1,\"\")","v":4.75},{"$f":"IFERROR((I49-H49)/$S$1,\"\")","v":4.75},{"$f":"IFERROR((K49-J49)/$S$1,\"\")","v":4.75},{"$f":"IFERROR((M49-L49)/$S$1,\"\")","v":4.75},{"$f":"IFERROR((O49-N49)/$S$1,\"\")","v":4.75}]
["Cashier             ",null,null,"Tiffany",null,"Tiffany",null,"Tiffany",null,"Tiffany",null,"Tiffany",null,"Tiffany",null,{"$f":"N50","v":"Tiffany"},{"$f":"SUM(S51:X51)","v":28.000000000000028}]
[null,null,null,"04:00:00","10:00:00","06:00:00","10:00:00","06:00:00","10:00:00","06:00:00","10:00:00","06:00:00","10:00:00","04:00:00","10:00:00",null,null,null,{"$f":"IFERROR((E51-D51)/$S$1,\"\")","v":5.9999999999999991},{"$f":"IFERROR((G51-F51)/$S$1,\"\")","v":4.000000000000008},{"$f":"IFERROR((I51-H51)/$S$1,\"\")","v":4.000000000000008},{"$f":"IFERROR((K51-J51)/$S$1,\"\")","v":4.000000000000008},{"$f":"IFERROR((M51-L51)/$S$1,\"\")","v":4.000000000000008},{"$f":"IFERROR((O51-N51)/$S$1,\"\")","v":5.9999999999999991}]
["Cashier              ",null,null,"Emily",null,"Emily",null,"Emily",null,"Emily",null,"Emily",null,"Emily",null,{"$f":"N52","v":"Emily"},{"$f":"SUM(S53:X53)","v":24.000000000000043}]
[null,null,null,"04:00:00","08:00:00","04:00:00","08:00:00","04:00:00","08:00:00","04:00:00","08:00:00","04:00:00","08:00:00","04:00:00","08:00:00",null,null,null,{"$f":"IFERROR((E53-D53)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((G53-F53)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((I53-H53)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((K53-J53)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((M53-L53)/$S$1,\"\")","v":4.0000000000000071},{"$f":"IFERROR((O53-N53)/$S$1,\"\")","v":4.0000000000000071}]
["Cashier               ",null,null,"Danielle",null,"Danielle",null,"Danielle",null,"Danielle",null,"Danielle",null,"Danielle",null,{"$f":"N54","v":"Danielle"},{"$f":"SUM(S55:X55)","v":36.000000000000007}]
[null,null,null,"08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00",null,null,null,{"$f":"IFERROR((E55-D55)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((G55-F55)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((I55-H55)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((K55-J55)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((M55-L55)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((O55-N55)/$S$1,\"\")","v":6.0000000000000009}]
["Cashier               ",null,null,"Haley",null,"Haley",null,"Haley",null,"Haley",null,"Haley",null,"Haley",null,{"$f":"N56","v":"Haley"},{"$f":"SUM(S57:X57)","v":36.000000000000007}]
[null,null,null,"08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00",null,null,null,{"$f":"IFERROR((E57-D57)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((G57-F57)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((I57-H57)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((K57-J57)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((M57-L57)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((O57-N57)/$S$1,\"\")","v":6.0000000000000009}]
["Assistant      ",null,null,"Pauline",null,"Pauline",null,"Pauline",null,"Pauline",null,"Pauline",null,"Pauline",null,{"$f":"N58","v":"Pauline"},{"$f":"SUM(S59:X59)","v":36.000000000000007},null,{"$f":"IFERROR((E58-D58),\"\")","v":""},{"$f":"IFERROR((G58-F58),\"\")","v":""},{"$f":"IFERROR((I58-H58),\"\")","v":""},{"$f":"IFERROR((K58-J58),\"\")","v":""},{"$f":"IFERROR((M58-L58),\"\")","v":""},{"$f":"IFERROR((O58-N58),\"\")","v":""}]
[null,null,null,"08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00","08:00:00","14:00:00",null,null,null,{"$f":"IFERROR((E59-D59)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((G59-F59)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((I59-H59)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((K59-J59)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((M59-L59)/$S$1,\"\")","v":6.0000000000000009},{"$f":"IFERROR((O59-N59)/$S$1,\"\")","v":6.0000000000000009}]
[null,null,null,{"$f":"IF(MONTH(INDEX(Formulas!C$21:C$26,week+1))<>month,IF(DAY(INDEX(Formulas!C$21:C$26,week+1))=1,NextMonthName,\"\"),\"\")","v":""},null,{"$f":"IF(MONTH(INDEX(Formulas!E$21:E$26,week+1))<>month,IF(DAY(INDEX(Formulas!E$21:E$26,week+1))=1,NextMonthName,\"\"),\"\")","v":""},null,{"$f":"IF(MONTH(INDEX(Formulas!G$21:G$26,week+1))<>month,IF(DAY(INDEX(Formulas!G$21:G$26,week+1))=1,NextMonthName,\"\"),\"\")","v":"August"},null,{"$f":"IF(MONTH(INDEX(Formulas!I$21:I$26,week+1))<>month,IF(DAY(INDEX(Formulas!I$21:I$26,week+1))=1,NextMonthName,\"\"),\"\")","v":""}]
[]
[]
[null,{"$f":"D13","v":"Mon - 21"},null,null,{"$f":"F13","v":"Tue - 22"},null,null,{"$f":"H13","v":"Wed - 23"},null,null,{"$f":"J13","v":"Thu - 24"},null,null,{"$f":"L13","v":"Fri - 25"},null,null,{"$f":"N13","v":"Sat - 26"}]
[null,{"$f":"$D14","v":"Jay "},{"$f":"D15","v":0},{"$f":"E15","v":0},{"$f":"F14","v":"Jay"},{"$f":"F15","v":0},{"$f":"G15","v":0},{"$f":"H14","v":"Jay "},{"$f":"H15","v":0},{"$f":"I15","v":0},{"$f":"J14","v":"Jay"},{"$f":"J15","v":0},{"$f":"K15","v":0},{"$f":"L14","v":"Jay "},{"$f":"L15","v":0},{"$f":"M15","v":0},{"$f":"N14","v":"Jay"},{"$f":"N15","v":0},{"$f":"O15","v":0}]
[null,{"$f":"D16","v":"Penny"},{"$f":"D17","v":0},{"$f":"E17","v":0},{"$f":"F16","v":"Penny"},{"$f":"F17","v":0},{"$f":"G17","v":0},{"$f":"H16","v":"Penny"},{"$f":"H17","v":0},{"$f":"J17","v":0},{"$f":"J16","v":"Penny"},{"$f":"J17","v":0},{"$f":"K17","v":0},{"$f":"N16","v":"Penny"},{"$f":"L17","v":0},{"$f":"M17","v":0},{"$f":"N16","v":"Penny"},{"$f":"N17","v":0},{"$f":"O17","v":0}]
[null,{"$f":"D18","v":"Nissa"},{"$f":"D19","v":"OFF"},{"$f":"E19","v":"OFF"},{"$f":"F18","v":"Nissa"},{"$f":"F19","v":"02:00:00"},{"$f":"G19","v":"07:00:00"},{"$f":"H18","v":"Nissa"},{"$f":"H19","v":"02:00:00"},{"$f":"I19","v":"07:30:00"},{"$f":"J18","v":"Nissa"},{"$f":"J19","v":"02:00:00"},{"$f":"K19","v":"07:30:00"},{"$f":"L18","v":"Nissa"},{"$f":"L19","v":"02:00:00"},{"$f":"M19","v":"07:30:00"},{"$f":"N18","v":"Nissa"},{"$f":"N19","v":"02:00:00"},{"$f":"O19","v":"07:30:00"}]
[null,{"$f":"D20","v":"Tracie"},{"$f":"D21","v":0.25},{"$f":"E21","v":0.54166666666666696},{"$f":"F20","v":"Tracie"},{"$f":"F21","v":"06:00:00"},{"$f":"G21","v":"14:00:00"},{"$f":"H20","v":"Tracie"},{"$f":"H21","v":"06:00:00"},{"$f":"I21","v":"14:00:00"},{"$f":"J20","v":"Tracie"},{"$f":"J21","v":"06:00:00"},{"$f":"K21","v":"10:45:00"},{"$f":"L20","v":"Tracie"},{"$f":"L21","v":"06:00:00"},{"$f":"M21","v":"10:45:00"},{"$f":"N20","v":"Tracie"},{"$f":"N21","v":"OFF"},{"$f":"O21","v":"OFF"}]
[null,{"$f":"D22","v":"Kristi"},{"$f":"D23","v":8.3333333333333329E-2},{"$f":"E23","v":0.33333333333333398},{"$f":"F22","v":"Kristi"},{"$f":"F23","v":"02:00:00"},{"$f":"G23","v":"08:00:00"},{"$f":"H22","v":"Kristi"},{"$f":"H23","v":"02:00:00"},{"$f":"I23","v":"08:00:00"},{"$f":"J22","v":"Kristi"},{"$f":"J23","v":"02:00:00"},{"$f":"K23","v":"08:00:00"},{"$f":"L22","v":"Kristi"},{"$f":"L23","v":"02:00:00"},{"$f":"M23","v":"08:00:00"},{"$f":"N22","v":"Kristi"},{"$f":"N23","v":"02:00:00"},{"$f":"O23","v":"08:00:00"}]
[null,{"$f":"D24","v":"Will"},{"$f":"D25","v":0.11458333333333333},{"$f":"E25","v":0.29166666666666702},{"$f":"F24","v":"Will"},{"$f":"F25","v":"OFF"},{"$f":"G25","v":"OFF"},{"$f":"H24","v":"Will"},{"$f":"H25","v":"02:45:00"},{"$f":"I25","v":"07:30:00"},{"$f":"J24","v":"Will"},{"$f":"J25","v":"02:45:00"},{"$f":"K25","v":"07:30:00"},{"$f":"L24","v":"Will"},{"$f":"L25","v":"02:45:00"},{"$f":"M25","v":"07:30:00"},{"$f":"N24","v":"Will"},{"$f":"N25","v":"02:45:00"},{"$f":"O25","v":"07:30:00"}]
[null,{"$f":"D26","v":"Tiffany"},{"$f":"D27","v":0.16666666666666699},{"$f":"D27","v":0.16666666666666699},{"$f":"F26","v":"Tiffany"},{"$f":"F27","v":"06:00:00"},{"$f":"G27","v":0.41666666666666702},{"$f":"H26","v":"Tiffany"},{"$f":"H27","v":"06:00:00"},{"$f":"I27","v":"10:00:00"},{"$f":"J26","v":"Tiffany"},{"$f":"J27","v":"06:00:00"},{"$f":"K27","v":"10:00:00"},{"$f":"L26","v":"Tiffany"},{"$f":"L27","v":"06:00:00"},{"$f":"M27","v":"10:00:00"},{"$f":"N26","v":"Tiffany"},{"$f":"N27","v":"04:00:00"},{"$f":"O27","v":"10:00:00"}]
[null,{"$f":"D28","v":"Emily"},{"$f":"D29","v":0.16666666666666699},{"$f":"D29","v":0.16666666666666699},{"$f":"F28","v":"Emily"},{"$f":"F29","v":"04:00:00"},{"$f":"G29","v":0.33333333333333398},{"$f":"H28","v":"Emily"},{"$f":"H29","v":"04:00:00"},{"$f":"I29","v":"08:00:00"},{"$f":"J28","v":"Emily"},{"$f":"J29","v":"04:00:00"},{"$f":"K29","v":"08:00:00"},{"$f":"L28","v":"Emily"},{"$f":"L29","v":"04:00:00"},{"$f":"M29","v":"08:00:00"},{"$f":"N28","v":"Emily"},{"$f":"N29","v":"04:00:00"},{"$f":"O29","v":"08:00:00"}]
[null,{"$f":"D30","v":"Danielle"},{"$f":"D31","v":0.33333333333333398},{"$f":"D31","v":0.33333333333333398},{"$f":"F30","v":"Danielle"},{"$f":"F31","v":"08:00:00"},{"$f":"G31","v":0.58333333333333404},{"$f":"H30","v":"Danielle"},{"$f":"H31","v":"08:00:00"},{"$f":"I31","v":"14:00:00"},{"$f":"J30","v":"Danielle"},{"$f":"J31","v":"08:00:00"},{"$f":"K31","v":"14:00:00"},{"$f":"L30","v":"Danielle"},{"$f":"L31","v":"08:00:00"},{"$f":"M31","v":"14:00:00"},{"$f":"N30","v":"Danielle"},{"$f":"N31","v":"08:00:00"},{"$f":"O31","v":"14:00:00"}]
[null,{"$f":"D32","v":"Haley"},{"$f":"D33","v":0.33333333333333398},{"$f":"D33","v":0.33333333333333398},{"$f":"F32","v":"Haley"},{"$f":"F33","v":"08:00:00"},{"$f":"G33","v":0.58333333333333404},{"$f":"H32","v":"Haley"},{"$f":"H33","v":"08:00:00"},{"$f":"I33","v":"14:00:00"},{"$f":"J32","v":"Haley"},{"$f":"J33","v":"08:00:00"},{"$f":"K33","v":"14:00:00"},{"$f":"L32","v":"Haley"},{"$f":"L33","v":"08:00:00"},{"$f":"M33","v":"14:00:00"},{"$f":"N32","v":"Haley"},{"$f":"N33","v":"08:00:00"},{"$f":"O33","v":"14:00:00"}]
[null,{"$f":"D34","v":"Pauline"},{"$f":"D35","v":0.33333333333333398},{"$f":"D35","v":0.33333333333333398},{"$f":"F34","v":"Pauline"},{"$f":"F35","v":"08:00:00"},{"$f":"G35","v":0.58333333333333404},{"$f":"H34","v":"Pauline"},{"$f":"H35","v":"08:00:00"},{"$f":"I35","v":"14:00:00"},{"$f":"J34","v":"Pauline"},{"$f":"J35","v":"08:00:00"},{"$f":"K35","v":"14:00:00"},{"$f":"L34","v":"Pauline"},{"$f":"L35","v":"08:00:00"},{"$f":"M35","v":"14:00:00"},{"$f":"N34","v":"Pauline"},{"$f":"N35","v":"08:00:00"},{"$f":"O35","v":"14:00:00"}]
[null,{"$f":"D37","v":"Mon - 28"},null,null,{"$f":"F37","v":"Tue - 29"},null,null,{"$f":"H37","v":"Wed - 30"},null,null,{"$f":"J37","v":"Thu - 31"},null,null,{"$f":"L37","v":"Fri - 1"},null,null,{"$f":"N37","v":"Sat - 2"}]
[null,{"$f":"D38","v":"Jay "},{"$f":"D39","v":0},{"$f":"E39","v":0},{"$f":"F38","v":"Jay"},{"$f":"F39","v":0},{"$f":"G39","v":0},{"$f":"H38","v":"Jay "},{"$f":"H39","v":0},{"$f":"I39","v":0},{"$f":"J38","v":"Jay"},{"$f":"J39","v":0},{"$f":"K39","v":0},{"$f":"L38","v":"Jay "},{"$f":"L39","v":0},{"$f":"M39","v":0},{"$f":"N38","v":"Jay"},{"$f":"N39","v":0},{"$f":"O39","v":0}]
[null,{"$f":"D40","v":"Penny"},{"$f":"D41","v":0},{"$f":"E41","v":0},{"$f":"F40","v":"Penny"},{"$f":"F41","v":0},{"$f":"G41","v":0},{"$f":"H40","v":"Penny"},{"$f":"H41","v":0},{"$f":"I41","v":0},{"$f":"J40","v":"Penny"},{"$f":"J41","v":0},{"$f":"K41","v":0},{"$f":"L40","v":"Penny"},{"$f":"L41","v":0},{"$f":"M41","v":0},{"$f":"N40","v":"Penny"},{"$f":"N41","v":0},{"$f":"O41","v":0}]
[null,{"$f":"D42","v":"Nissa"},{"$f":"D43","v":8.3333333333333329E-2},{"$f":"E43","v":0.3125},{"$f":"F42","v":"Nissa"},{"$f":"F43","v":"02:00:00"},{"$f":"G43","v":0.3125},{"$f":"H42","v":"Nissa"},{"$f":"H43","v":"02:00:00"},{"$f":"I43","v":"07:30:00"},{"$f":"J42","v":"Nissa"},{"$f":"J43","v":"02:00:00"},{"$f":"K43","v":"07:30:00"},{"$f":"L42","v":"Nissa"},{"$f":"L43","v":"02:00:00"},{"$f":"M43","v":"07:30:00"},{"$f":"N42","v":"Nissa"},{"$f":"N43","v":"02:00:00"},{"$f":"O43","v":"09:00:00"}]
[null,{"$f":"D44","v":"Tracie"},{"$f":"D45","v":0.25},{"$f":"E45","v":0.58333333333333404},{"$f":"F44","v":"Tracie"},{"$f":"F45","v":"06:00:00"},{"$f":"G45","v":0.58333333333333404},{"$f":"H44","v":"Tracie"},{"$f":"H45","v":"06:00:00"},{"$f":"I45","v":"14:00:00"},{"$f":"J44","v":"Tracie"},{"$f":"J45","v":"06:00:00"},{"$f":"K45","v":"10:45:00"},{"$f":"L44","v":"Tracie"},{"$f":"L45","v":"06:00:00"},{"$f":"M45","v":"10:45:00"},{"$f":"N44","v":"Tracie"},{"$f":"N45","v":"OFF"},{"$f":"O45","v":"OFF"}]
[null,{"$f":"D46","v":"Kristi"},{"$f":"D47","v":8.3333333333333329E-2},{"$f":"E47","v":0.33333333333333398},{"$f":"F46","v":"Kristi"},{"$f":"F47","v":"02:00:00"},{"$f":"G47","v":0.33333333333333398},{"$f":"H46","v":"Kristi"},{"$f":"H47","v":"02:00:00"},{"$f":"I47","v":"08:00:00"},{"$f":"J46","v":"Kristi"},{"$f":"J47","v":"02:00:00"},{"$f":"K47","v":"08:00:00"},{"$f":"L46","v":"Kristi"},{"$f":"L47","v":"02:00:00"},{"$f":"M47","v":"08:00:00"},{"$f":"N46","v":"Kristi"},{"$f":"N47","v":"02:00:00"},{"$f":"O47","v":"08:00:00"}]
[null,{"$f":"D48","v":"Will"},{"$f":"D49","v":0.11458333333333333},{"$f":"E49","v":0.3125},{"$f":"F48","v":"Will"},{"$f":"F49","v":"02:45:00"},{"$f":"G49","v":0.3125},{"$f":"H48","v":"Will"},{"$f":"H49","v":"02:45:00"},{"$f":"I49","v":"07:30:00"},{"$f":"J48","v":"Will"},{"$f":"J49","v":"02:45:00"},{"$f":"K49","v":"07:30:00"},{"$f":"L48","v":"Will"},{"$f":"L49","v":"02:45:00"},{"$f":"M49","v":"07:30:00"},{"$f":"N48","v":"Will"},{"$f":"N49","v":"02:45:00"},{"$f":"O49","v":"07:30:00"}]
[null,{"$f":"D50","v":"Tiffany"},{"$f":"D51","v":0.16666666666666699},{"$f":"E51","v":0.41666666666666702},{"$f":"F50","v":"Tiffany"},{"$f":"F51","v":"06:00:00"},{"$f":"G51","v":0.41666666666666702},{"$f":"H50","v":"Tiffany"},{"$f":"H51","v":"06:00:00"},{"$f":"I51","v":"10:00:00"},{"$f":"J50","v":"Tiffany"},{"$f":"J51","v":"06:00:00"},{"$f":"K51","v":"10:00:00"},{"$f":"L50","v":"Tiffany"},{"$f":"L51","v":"06:00:00"},{"$f":"M51","v":"10:00:00"},{"$f":"N50","v":"Tiffany"},{"$f":"N51","v":"04:00:00"},{"$f":"O51","v":"10:00:00"}]
[null,{"$f":"D52","v":"Emily"},{"$f":"D53","v":0.16666666666666699},{"$f":"E53","v":0.33333333333333398},{"$f":"F52","v":"Emily"},{"$f":"F53","v":"04:00:00"},{"$f":"G53","v":0.33333333333333398},{"$f":"H52","v":"Emily"},{"$f":"H53","v":"04:00:00"},{"$f":"I53","v":"08:00:00"},{"$f":"J52","v":"Emily"},{"$f":"J53","v":"04:00:00"},{"$f":"K53","v":"08:00:00"},{"$f":"L52","v":"Emily"},{"$f":"L53","v":"04:00:00"},{"$f":"M53","v":"08:00:00"},{"$f":"N52","v":"Emily"},{"$f":"N53","v":"04:00:00"},{"$f":"O53","v":"08:00:00"}]
[null,{"$f":"D54","v":"Danielle"},{"$f":"D55","v":0.33333333333333398},{"$f":"E55","v":0.58333333333333404},{"$f":"F54","v":"Danielle"},{"$f":"F55","v":"08:00:00"},{"$f":"G55","v":0.58333333333333404},{"$f":"H54","v":"Danielle"},{"$f":"H55","v":"08:00:00"},{"$f":"I55","v":"14:00:00"},{"$f":"J54","v":"Danielle"},{"$f":"J55","v":"08:00:00"},{"$f":"K55","v":"14:00:00"},{"$f":"L54","v":"Danielle"},{"$f":"L55","v":"08:00:00"},{"$f":"M55","v":"14:00:00"},{"$f":"N54","v":"Danielle"},{"$f":"N55","v":"08:00:00"},{"$f":"O55","v":"14:00:00"}]
[null,{"$f":"D56","v":"Haley"},{"$f":"D57","v":"08:00:00"},{"$f":"E57","v":0.58333333333333404},{"$f":"F56","v":"Haley"},{"$f":"F57","v":"08:00:00"},{"$f":"G57","v":0.58333333333333404},{"$f":"H56","v":"Haley"},{"$f":"H57","v":"08:00:00"},{"$f":"I57","v":"14:00:00"},{"$f":"J56","v":"Haley"},{"$f":"J57","v":"08:00:00"},{"$f":"K57","v":"14:00:00"},{"$f":"L56","v":"Haley"},{"$f":"L57","v":"08:00:00"},{"$f":"M57","v":"14:00:00"},{"$f":"N56","v":"Haley"},{"$f":"N57","v":"08:00:00"},{"$f":"O57","v":"14:00:00"}]
[null,{"$f":"D58","v":"Pauline"},{"$f":"D59","v":0.33333333333333398},{"$f":"E59","v":0.58333333333333404},{"$f":"F58","v":"Pauline"},{"$f":"F59","v":"08:00:00"},{"$f":"G59","v":0.58333333333333404},{"$f":"H58","v":"Pauline"},{"$f":"H59","v":"08:00:00"},{"$f":"I59","v":"14:00:00"},{"$f":"J58","v":"Pauline"},{"$f":"J59","v":"08:00:00"},{"$f":"K59","v":"14:00:00"},{"$f":"L58","v":"Pauline"},{"$f":"L59","v":"08:00:00"},{"$f":"M59","v":"14:00:00"},{"$f":"N58","v":"Pauline"},{"$f":"N59","v":"08:00:00"},{"$f":"O59","v":"14:00:00"}]

{"sheet":"Employee Info","index":1,"n_rows":74,"n_cols":44,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["Employee Information",null,null,null,null,null,null,null,null,null,null,4.1666666666666699E-2]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L16","v":"Jay"},"start","end",{"$f":"O16","v":"Penny"},"start","end",{"$f":"R16","v":"Nissa"},"start","end",{"$f":"U16","v":"Tracie"},"start","end",{"$f":"X16","v":"Kristi"},"start","end",{"$f":"AA16","v":"Will"},"start","end",{"$f":"AD16","v":"Tiffany"},"start","end",{"$f":"AG16","v":"Emily"},"start","end",{"$f":"AJ16","v":"Danielle"},"start","end",{"$f":"AM16","v":"Haley"},"start","end",{"$f":"AP16","v":"Pauline"},"start","end"]
["Emp. #","Name","Position","Rate/Hr.","2 Wk Hrs","2 week pay","Phone #","Carrier","Carrier code","Email",null,{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(M17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M17,$J$16:$K$74,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(N17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(N17,$J$16:$K$74,2,FALSE)),\"\")","v":""},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(P17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P17,$J$16:$K$74,2,FALSE)),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(Q17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Q17,$J$16:$K$74,2,FALSE)),\"\")","v":""},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(S17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S17,$J$16:$K$74,2,FALSE)),\"\")","v":"OFF"},{"$f":"IFERROR(IF(VLOOKUP(T17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(T17,$J$16:$K$74,2,FALSE)),\"\")","v":"OFF"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(V17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V17,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},{"$f":"IFERROR(IF(VLOOKUP(W17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(W17,$J$16:$K$74,2,FALSE)),\"\")","v":"1 p.m."},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(Y17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y17,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},{"$f":"IFERROR(IF(VLOOKUP(Z17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Z17,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(AB17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB17,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},{"$f":"IFERROR(IF(VLOOKUP(AC17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AC17,$J$16:$K$74,2,FALSE)),\"\")","v":"7 a.m."},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(AE17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE17,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},{"$f":"IFERROR(IF(VLOOKUP(AF17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AF17,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(AH17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH17,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},{"$f":"IFERROR(IF(VLOOKUP(AI17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AI17,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(AK17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK17,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},{"$f":"IFERROR(IF(VLOOKUP(AL17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AL17,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(AN17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN17,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},{"$f":"IFERROR(IF(VLOOKUP(AO17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AO17,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(IF(VLOOKUP(AQ17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ17,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},{"$f":"IFERROR(IF(VLOOKUP(AR17,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AR17,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."}]
[1,"Jay","M","-",{"$f":"(VLOOKUP('Employee Info'!B4,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B4,Schedule!$P$38:$Q$59,2,FALSE))","v":0},{"$f":"IFERROR(E4*D4,\"\")","v":""},3078710570,"Verizon",{"$f":"VLOOKUP(H4,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson112@gmail.com",null,{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(M18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M18,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(P18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P18,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(S18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S18,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},{"$f":"IFERROR(IF(VLOOKUP(T18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(T18,$J$16:$K$74,2,FALSE)),\"\")","v":"7 a.m."},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(V18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V18,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"2 p.m.",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(Y18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y18,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(AB18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB18,$J$16:$K$74,2,FALSE)),\"\")","v":"OFF"},"OFF",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(AE18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE18,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10 a.m.",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(AH18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH18,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(AK18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK18,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(AN18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN18,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(IF(VLOOKUP(AQ18,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ18,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[2,"Penny","M","-",{"$f":"(VLOOKUP('Employee Info'!B5,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B5,Schedule!$P$38:$Q$59,2,FALSE))","v":0},{"$f":"IFERROR(E5*D5,\"\")","v":""},3078710571,"Verizon",{"$f":"VLOOKUP(H5,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson113@gmail.com",null,{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(M19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M19,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(P19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P19,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$H$13","v":"Wed - 23"},"2 a.m.","7:30 a.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(V19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V19,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"2 p.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(Y19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y19,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(AB19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB19,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(AE19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE19,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10 a.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(AH19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH19,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(AK19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK19,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(AN19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN19,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(IF(VLOOKUP(AQ19,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ19,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[3,"Nissa","E",10,{"$f":"(VLOOKUP('Employee Info'!B6,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B6,Schedule!$P$38:$Q$59,2,FALSE))","v":61.500000000000007},615.00000000000011,3078710572,"Verizon",{"$f":"VLOOKUP(H6,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson112@gmail.com",null,{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(M20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M20,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(P20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P20,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(S20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S20,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"7:30 a.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(V20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V20,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10:45 a.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(Y20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y20,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(AB20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB20,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(AE20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE20,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10 a.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(AH20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH20,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(AK20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK20,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(AN20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN20,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(IF(VLOOKUP(AQ20,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ20,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[4,"Tracie","E",10.5,{"$f":"(VLOOKUP('Employee Info'!B7,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B7,Schedule!$P$38:$Q$59,2,FALSE))","v":66.000000000000114},693.00000000000114,3078710573,"Verizon",{"$f":"VLOOKUP(H7,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson113@gmail.com",null,{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(M21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M21,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(P21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P21,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(S21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S21,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"7:30 a.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(V21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V21,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10:45 a.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(Y21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y21,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(AB21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB21,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(AE21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE21,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10 a.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(AH21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH21,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(AK21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK21,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(AN21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN21,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(IF(VLOOKUP(AQ21,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ21,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[5,"Kristi","E",9,{"$f":"(VLOOKUP('Employee Info'!B8,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B8,Schedule!$P$38:$Q$59,2,FALSE))","v":72.000000000000185},648.00000000000171,3078710574,"Verizon",{"$f":"VLOOKUP(H8,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson112@gmail.com",null,{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(M22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M22,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(P22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P22,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(S22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S22,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"7:30 a.m.",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(V22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V22,$J$16:$K$74,2,FALSE)),\"\")","v":"OFF"},"OFF",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(Y22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y22,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(AB22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB22,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(AE22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE22,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"10 a.m.",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(AH22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH22,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(AK22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK22,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(AN22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN22,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(IF(VLOOKUP(AQ22,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ22,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[6,"Will","E",9,{"$f":"(VLOOKUP('Employee Info'!B9,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B9,Schedule!$P$38:$Q$59,2,FALSE))","v":51.750000000000007},465.75000000000006,3078710575,"Verizon",{"$f":"VLOOKUP(H9,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson113@gmail.com",null,{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(M23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M23,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(P23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P23,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(S23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S23,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"7:30 a.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(V23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V23,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"2 p.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(Y23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y23,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(AB23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB23,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(AE23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE23,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"10 a.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(AH23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH23,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(AK23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK23,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(AN23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN23,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(IF(VLOOKUP(AQ23,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ23,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[7,"Tiffany","E",9.5,{"$f":"(VLOOKUP('Employee Info'!B10,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B10,Schedule!$P$38:$Q$59,2,FALSE))","v":56.000000000000057},532.00000000000057,3078710576,"Verizon",{"$f":"VLOOKUP(H10,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson112@gmail.com",null,{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(M24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M24,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(P24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P24,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(S24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S24,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"7:30 a.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(V24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V24,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"2 p.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(Y24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y24,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(AB24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB24,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(AE24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE24,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10 a.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(AH24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH24,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(AK24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK24,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(AN24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN24,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(IF(VLOOKUP(AQ24,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ24,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[8,"Emily","E",9.5,{"$f":"(VLOOKUP('Employee Info'!B11,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B11,Schedule!$P$38:$Q$59,2,FALSE))","v":48.000000000000085},456.0000000000008,3078710577,"Verizon",{"$f":"VLOOKUP(H11,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson113@gmail.com",null,{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(M25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M25,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(P25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P25,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(S25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S25,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"7:30 a.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(V25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V25,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"2 p.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(Y25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y25,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(AB25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB25,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(AE25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE25,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10 a.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(AH25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH25,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(AK25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK25,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(AN25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN25,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(IF(VLOOKUP(AQ25,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ25,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[9,"Danielle","E",9,{"$f":"(VLOOKUP('Employee Info'!B12,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B12,Schedule!$P$38:$Q$59,2,FALSE))","v":72.000000000000014},648.00000000000011,3078710578,"Verizon",{"$f":"VLOOKUP(H12,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson112@gmail.com",null,{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(M26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M26,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(P26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P26,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(S26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S26,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"7:30 a.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(V26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V26,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10:45 a.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(Y26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y26,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(AB26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB26,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(AE26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE26,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10 a.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(AH26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH26,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(AK26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK26,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(AN26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN26,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(IF(VLOOKUP(AQ26,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ26,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[10,"Haley","E",8,{"$f":"(VLOOKUP('Employee Info'!B13,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B13,Schedule!$P$38:$Q$59,2,FALSE))","v":72.000000000000014},576.00000000000011,3078710579,"Verizon",{"$f":"VLOOKUP(H13,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson113@gmail.com",null,{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(M27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M27,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(P27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P27,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(S27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S27,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"7:30 a.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(V27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V27,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10:45 a.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(Y27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y27,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(AB27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB27,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(AE27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE27,$J$16:$K$74,2,FALSE)),\"\")","v":"6 a.m."},"10 a.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(AH27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH27,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(AK27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK27,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(AN27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN27,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(IF(VLOOKUP(AQ27,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ27,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[11,"Pauline","E",11,{"$f":"(VLOOKUP('Employee Info'!B14,Schedule!$P$14:$Q$35,2,FALSE)+VLOOKUP('Employee Info'!B14,Schedule!$P$38:$Q$59,2,FALSE))","v":72.000000000000014},792.00000000000011,3078710580,"verizon",{"$f":"VLOOKUP(H14,Carriers!$A$2:$B$10,2,FALSE)","v":"vtext.com"},"derekjohnson112@gmail.com",null,{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(M28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(M28,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(P28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(P28,$J$16:$K$74,2,FALSE)),\"\")","v":""},"",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(S28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(S28,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"9 a.m.",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(V28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(V28,$J$16:$K$74,2,FALSE)),\"\")","v":"OFF"},{"$f":"IFERROR(IF(VLOOKUP(W28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(W28,$J$16:$K$74,2,FALSE)),\"\")","v":"OFF"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(Y28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(Y28,$J$16:$K$74,2,FALSE)),\"\")","v":"2 a.m."},"8 a.m.",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(AB28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AB28,$J$16:$K$74,2,FALSE)),\"\")","v":"2:45 a.m."},"7:30 a.m.",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(AE28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AE28,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"10 a.m.",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(AH28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AH28,$J$16:$K$74,2,FALSE)),\"\")","v":"4 a.m."},"8 a.m.",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(AK28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AK28,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(AN28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AN28,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m.",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(IF(VLOOKUP(AQ28,$J$16:$K$74,2,FALSE)=0,\"\",VLOOKUP(AQ28,$J$16:$K$74,2,FALSE)),\"\")","v":"8 a.m."},"2 p.m."]
[]
[null,"2 Week Budget",null,null,null,null,null,null,null,"OFF","OFF",{"$f":"B4","v":"Jay"},"start","end",{"$f":"B5","v":"Penny"},"start","end",{"$f":"B6","v":"Nissa"},"start","end",{"$f":"B7","v":"Tracie"},"start","end",{"$f":"B8","v":"Kristi"},"start","end",{"$f":"B9","v":"Will"},"start","end",{"$f":"B10","v":"Tiffany"},"start","end",{"$f":"B11","v":"Emily"},"start","end",{"$f":"B12","v":"Danielle"},"start","end",{"$f":"B13","v":"Haley"},"start","end",{"$f":"B14","v":"Pauline"},"start","end"]
[null,4850,null,null,null,null,null,null,null,0,null,{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":""},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"OFF"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"OFF"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"13:00:00"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"07:00:00"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"04:00:00"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"04:00:00"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$D$13","v":"Mon - 21"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$B$64:$D$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$B$64:$D$74,3,FALSE),\"\")","v":"08:00:00"}]
[null,null,null,null,null,null,null,null,null,4.1666666666666664E-2,"1 a.m.",{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"07:00:00"},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"OFF"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"OFF"},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$F$13","v":"Tue - 22"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$E$64:$G$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$E$64:$G$74,3,FALSE),\"\")","v":"14:00:00"}]
[null,"2 Week Actual",null,null,null,null,null,null,null,5.2083333333333336E-2,"1:15 a.m.",{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":""},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$H$13","v":"Wed - 23"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$H$64:$J$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$H$64:$J$74,3,FALSE),\"\")","v":"14:00:00"}]
[null,{"$f":"SUM(F4:F14)","v":5425.7500000000045},null,null,null,null,null,null,null,6.25E-2,"1:30 a.m.",{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"10:45:00"},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$J$13","v":"Thu - 24"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$K$64:$M$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$K$64:$M$74,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,7.2916666666666699E-2,"1:45 a.m.",{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":""},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"10:45:00"},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$L$13","v":"Fri - 25"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$N$64:$P$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$N$64:$P$74,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,8.3333333333333329E-2,"2 a.m.",{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":0},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"OFF"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"OFF"},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$N$13","v":"Sat - 26"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$Q$64:$S$74,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$Q$64:$S$74,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,9.375E-2,"2:15 a.m.",{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":""},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$D$37","v":"Mon - 28"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$B$76:$D$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$B$76:$D$86,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,0.10416666666666667,"2:30 a.m.",{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$F$37","v":"Tue - 29"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$E$76:$G$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$E$76:$G$86,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,0.11458333333333333,"2:45 a.m.",{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":""},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$H$37","v":"Wed - 30"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$H$76:$J$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$H$76:$J$86,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,0.125,"3 a.m.",{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"10:45:00"},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$J$37","v":"Thu - 31"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$K$76:$M$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$K$76:$M$86,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,0.13541666666666699,"3:15 a.m.",{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":""},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"10:45:00"},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"06:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$L$37","v":"Fri - 1"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$N$76:$P$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$N$76:$P$86,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,"03:30:00","3:30 a.m.",{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP($L$16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":0},{"$f":"IFERROR(VLOOKUP(O16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":0},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(R16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"09:00:00"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"OFF"},{"$f":"IFERROR(VLOOKUP(U16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"OFF"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"02:00:00"},{"$f":"IFERROR(VLOOKUP(X16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"02:45:00"},{"$f":"IFERROR(VLOOKUP(AA16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"07:30:00"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AD16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"10:00:00"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"04:00:00"},{"$f":"IFERROR(VLOOKUP(AG16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"08:00:00"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AJ16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AM16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"14:00:00"},{"$f":"Schedule!$N$37","v":"Sat - 2"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$Q$76:$S$86,2,FALSE),\"\")","v":"08:00:00"},{"$f":"IFERROR(VLOOKUP(AP16,Schedule!$Q$76:$S$86,3,FALSE),\"\")","v":"14:00:00"}]
[null,null,null,null,null,null,null,null,null,0.15625,"3:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.16666666666666699,"4 a.m."]
[null,null,null,null,null,null,null,null,null,0.17708333333333401,"4:15 a.m."]
[null,null,null,null,null,null,null,null,null,0.1875,"4:30 a.m."]
[null,null,null,null,null,null,null,null,null,0.19791666666666699,"4:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.20833333333333401,"5 a.m."]
[null,null,null,null,null,null,null,null,null,0.21875,"5:15 a.m."]
[null,null,null,null,null,null,null,null,null,0.22916666666666699,"5:30 a.m."]
[null,null,null,null,null,null,null,null,null,0.23958333333333401,"5:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.25,"6 a.m."]
[null,null,null,null,null,null,null,null,null,0.26041666666666702,"6:15 a.m."]
[null,null,null,null,null,null,null,null,null,0.27083333333333398,"6:30 a.m."]
[null,null,null,null,null,null,null,null,null,0.28125,"6:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.29166666666666702,"7 a.m."]
[null,null,null,null,null,null,null,null,null,0.30208333333333398,"7:15 a.m."]
[null,null,null,null,null,null,null,null,null,0.3125,"7:30 a.m."]
[null,null,null,null,null,null,null,null,null,0.32291666666666702,"7:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.33333333333333398,"8 a.m."]
[null,null,null,null,null,null,null,null,null,0.34375,"8:15 a.m."]
[null,null,null,null,null,null,null,null,null,0.35416666666666702,"8:30 a.m."]
[null,null,null,null,null,null,null,null,null,0.36458333333333398,"8:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.375,"9 a.m."]
[null,null,null,null,null,null,null,null,null,0.38541666666666702,"9:15 a.m."]
[null,null,null,null,null,null,null,null,null,0.39583333333333398,"9:30 a.m."]
[null,null,null,null,null,null,null,null,null,0.40625,"9:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.41666666666666702,"10 a.m."]
[null,null,null,null,null,null,null,null,null,0.42708333333333398,"10:15 a.m."]
[null,null,null,null,null,null,null,null,null,0.4375,"10:30 a.m."]
[null,null,null,null,null,null,null,null,null,0.44791666666666702,"10:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.45833333333333398,"11 a.m."]
[null,null,null,null,null,null,null,null,null,0.468750000000001,"11:15 a.m."]
[null,null,null,null,null,null,null,null,null,0.47916666666666702,"11:30 a.m."]
[null,null,null,null,null,null,null,null,null,0.48958333333333398,"11:45 a.m."]
[null,null,null,null,null,null,null,null,null,0.500000000000001,"12 p.m."]
[null,null,null,null,null,null,null,null,null,0.51041666666666696,"12:15 p.m."]
[null,null,null,null,null,null,null,null,null,0.52083333333333404,"12:30 p.m."]
[null,null,null,null,null,null,null,null,null,0.531250000000001,"12:45 p.m."]
[null,null,null,null,null,null,null,null,null,0.54166666666666696,"1 p.m."]
[null,null,null,null,null,null,null,null,null,0.55208333333333404,"1:15 p.m."]
[null,null,null,null,null,null,null,null,null,0.562500000000001,"1:30 p.m."]
[null,null,null,null,null,null,null,null,null,0.57291666666666696,"1:45 p.m."]
[null,null,null,null,null,null,null,null,null,0.58333333333333404,"2 p.m."]
[null,null,null,null,null,null,null,null,null,0.593750000000001,"2:15 p.m."]
[null,null,null,null,null,null,null,null,null,0.60416666666666696,"2:30 p.m."]
[null,null,null,null,null,null,null,null,null,0.61458333333333404,"2:45 p.m."]
[null,null,null,null,null,null,null,null,null,0.625000000000001,"3 p.m."]

{"sheet":"Carriers","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Provider","Gateway"]
["AllTel","text.wireless.alltel.com"]
["AT&T","txt.att.net"]
["Boost Mobile","myboostmobile.com"]
["Cricket","sms.mycricket.com"]
["Sprint","messaging.sprintpcs.com"]
["T-Mobile","tmomail.net"]
["US Cellular","email.uscc.net"]
["Verizon","vtext.com"]
["Virgin Mobile","vmobl.com"]

{"sheet":"Formulas","index":3,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Date and Time Formulas"]
[null,null,null,null,null,null,null,null,null,{"$f":"prevMonthName&\" \"&YEAR(H10)","v":"June 2014"}]
[null,"Today's Date",null,"Month Names",null,null,"time",11,null,"S","M","T","W","Th","F","Sa"]
[null,{"$f":"TODAY()","v":"2014-04-11"},null,"January",null,null,"week",4,null,{"$f":"IF(MONTH(prevMonth)<>MONTH(prevMonth-WEEKDAY(prevMonth)+(WeekNo-1)*7+WeekDay),\"\",DAY(prevMonth-WEEKDAY(prevMonth)+(WeekNo-1)*7+WeekDay))","v":1},2,3,4,5,6,7]
[null,{"$f":"MONTH(TODAY())","v":4},null,"February",null,null,"month",7,null,8,9,10,11,12,13,14]
[null,{"$f":"INDEX(monthNames,B5)","v":"April"},null,"March",null,null,"year",2014,null,15,16,17,18,19,20,21]
[null,{"$f":"YEAR(TODAY())","v":2014},null,"April",null,null,"monthName",{"$f":"INDEX(monthNames,month)","v":"July"},null,22,23,24,25,26,27,28]
[null,null,null,"May",null,null,"startDate",{"$f":"DATE(year,month,1)","v":"2014-07-01"},null,29,30,"","","","",""]
[null,null,null,"June",null,null,"startDayOfWeek",{"$f":"WEEKDAY(startDate)","v":3},null,"","","","","","",""]
[null,null,null,"July",null,null,"prevMonth",{"$f":"DATE(YEAR(startDate-1),MONTH(startDate-1),1)","v":"2014-06-01"}]
[null,null,null,"August",null,null,"prevMonthName",{"$f":"INDEX(monthNames,MONTH(H10))","v":"June"},null,{"$f":"monthName&\" \"&year","v":"July 2014"}]
[null,null,null,"September",null,null,"nextMonth",{"$f":"DATE(YEAR(startDate+32),MONTH(startDate+32),1)","v":"2014-08-01"},null,"S","M","T","W","Th","F","Sa"]
[null,null,null,"October",null,null,"nextMonthName",{"$f":"INDEX(monthNames,MONTH(H12))","v":"August"},null,{"$f":"IF(MONTH(startDate)<>MONTH(startDate-startDayOfWeek+(WeekNo-1)*7+WeekDay),\"\",DAY(startDate-startDayOfWeek+(WeekNo-1)*7+WeekDay))","v":""},"",1,2,3,4,5]
[null,null,null,"November",null,null,null,null,null,6,7,8,9,10,11,12]
[null,null,null,"December",null,null,null,null,null,13,14,15,16,17,18,19]
[null,null,null,null,null,null,null,null,null,20,21,22,23,24,25,26]
[null,null,null,null,null,null,null,null,null,27,28,29,30,31,"",""]
[null,null,null,null,null,null,null,null,null,"","","","","","",""]
["WeekNo","Sun","Mon","Tue","Wed","Thu","Fri","Sat"]
[null,1,2,3,4,5,6,7,null,{"$f":"NextMonthName&\" \"&YEAR(H12)","v":"August 2014"}]
[1,{"$f":"startDate-startDayOfWeek+(WeekNo-1)*7+WeekDay","v":"2014-06-29"},"2014-06-30","2014-07-01","2014-07-02","2014-07-03","2014-07-04","2014-07-05",null,"S","M","T","W","Th","F","Sa"]
[2,"2014-07-06","2014-07-07","2014-07-08","2014-07-09","2014-07-10","2014-07-11","2014-07-12",null,{"$f":"IF(MONTH(nextMonth)<>MONTH(nextMonth-WEEKDAY(nextMonth)+(WeekNo-1)*7+WeekDay),\"\",DAY(nextMonth-WEEKDAY(nextMonth)+(WeekNo-1)*7+WeekDay))","v":""},"","","","",1,2]
[3,"2014-07-13","2014-07-14","2014-07-15","2014-07-16","2014-07-17","2014-07-18","2014-07-19",null,3,4,5,6,7,8,9]
[4,"2014-07-20","2014-07-21","2014-07-22","2014-07-23","2014-07-24","2014-07-25","2014-07-26",null,10,11,12,13,14,15,16]
[5,"2014-07-27","2014-07-28","2014-07-29","2014-07-30","2014-07-31","2014-08-01","2014-08-02",null,17,18,19,20,21,22,23]
[6,"2014-08-03","2014-08-04","2014-08-05","2014-08-06","2014-08-07","2014-08-08","2014-08-09",null,24,25,26,27,28,29,30]
[7,"2014-08-10","2014-08-11","2014-08-12","2014-08-13","2014-08-14","2014-08-15","2014-08-16",null,31,"","","","","",""]
[]
[]
["Start_Times"]
[{"$f":"12","v":12}]
[{"$f":"A31+1/48","v":12.020833333333334}]
[12.041666666666668]
[12.062500000000002]
[12.083333333333336]
[12.10416666666667]
[12.125000000000004]
[{"$f":"A37+1/48","v":12.145833333333337}]
[12.166666666666671]
[12.187500000000005]
[12.208333333333339]
[12.229166666666673]
[12.250000000000007]
[12.270833333333341]
[12.291666666666675]
[12.312500000000009]
[12.333333333333343]
[12.354166666666677]
[12.375000000000011]
[{"$f":"A49+1/48","v":12.395833333333345}]
[12.416666666666679]
[12.437500000000012]
[12.458333333333346]
[12.47916666666668]
[12.500000000000014]
[12.520833333333348]
[12.541666666666682]
[12.562500000000016]
[12.58333333333335]
[12.604166666666684]
[12.625000000000018]