{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Help"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"comments":1,"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":"1904"}

{"sheet":"Sheet1","index":0,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[[23,2,28,2],[44,2,47,2],[29,2,43,2],[23,5,31,5],[32,5,40,5],[41,5,47,5]]}
[]
[null,"Table1",null,null,null,null,null,null,null,null,null,null,null,"Table3"]
[null,"Week","Mon_Sta","Mon_Fin","Tue_Sta","Tue_Fin","Wed_Sta","Wed_Fin","Thu_Sta","Thu_Fin","Fri_Sta","Fri_Fin",null,"Reg","Over","Tot_Wk"]
[null,1,"19:00:00",0.29166666666666669,"06:00:00","16:30:00","06:00:00","12:00:00","05:00:00","14:00:00","00:00:00","06:00:00",null,null,null,{"$f":"SUM(INDEX(Table3[Reg],rown+1),INDEX(Table3[Over],rown+2))","v":1.7083333333333333}]
[null,"Rg_01",{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"02:00:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"10:00:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"05:30:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"07:30:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"00:00:00"},null,null,{"$f":"SUM(Table1[#This Row])","v":1.0416666666666667}]
[null,"Ov_01",{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"09:30:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"00:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"00:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"01:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"05:30:00"},null,null,null,{"$f":"SUM(Table1[#This Row])","v":0.66666666666666652}]
[null,2,"20:00:00",0.29166666666666669,"17:00:00","23:00:00","13:00:00","20:00:00","15:00:00","18:00:00","12:00:00","23:00:00",null,null,null,{"$f":"SUM(INDEX(Table3[Reg],rown+1),INDEX(Table3[Over],rown+2))","v":1.5208333333333335}]
[null,"Rg_02",{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"01:00:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"03:00:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"06:30:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"03:00:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"07:30:00"},null,null,{"$f":"SUM(Table1[#This Row])","v":0.87500000000000022}]
[null,"Ov_02",{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"09:30:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"03:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"00:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"00:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"03:00:00"},null,null,null,{"$f":"SUM(Table1[#This Row])","v":0.64583333333333326}]
[null,3,0.79166666666666663,0.33333333333333331,0.20833333333333334,0.72916666666666674,0.29166666666666669,0.54166666666666674,0.16666666666666666,0.62500000000000011,4.1666666666666699E-2,0.29166666666666669,null,null,null,{"$f":"SUM(INDEX(Table3[Reg],rown+1),INDEX(Table3[Over],rown+2))","v":1.9375000000000004}]
[null,"Rg_03",{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"03:00:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"11:00:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"05:30:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"08:30:00"},null,{"$f":"IFERROR(SQRT(InS-(InS>=Lt)*Bk)^2,OutSg-(OutSg>=Lt)*Bk)","v":"01:00:00"},null,null,{"$f":"SUM(Table1[#This Row])","v":1.2083333333333337}]
[null,"Ov_03",{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"09:30:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"01:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"00:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"02:00:00"},null,{"$f":"IFERROR((OutS-(OutS>=Lt)*Bk),InSg-(InSg>=Lt)*Bk)","v":"05:00:00"},null,null,null,{"$f":"SUM(Table1[#This Row])","v":0.72916666666666674}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table3[Reg])","v":3.1250000000000009},{"$f":"SUBTOTAL(109,Table3[Over])","v":2.0416666666666665},{"$f":"SUBTOTAL(109,Table3[Tot_Wk])","v":5.1666666666666679}]
[]
[null,"Table2","1st Shift"]
[null,"RegS","RegF"]
[null,"06:00:00","20:00:00"]
[]
[null,"Table4","GraveYard Shift"]
[null,"OvrS","OvrF"]
[null,"20:00:00",1.25]
[]
[null,"1st Shift",null,null,"GraveYard Shift"]
[null,"00:00:00","Over",null,"12:00:00","Regular"]
[null,"01:00:00",null,null,"13:00:00"]
[null,"02:00:00",null,null,"14:00:00"]
[null,"03:00:00",null,null,"15:00:00"]
[null,"04:00:00",null,null,"16:00:00"]
[null,"05:00:00",null,null,"17:00:00"]
[null,"06:00:00","Regular",null,"18:00:00"]
[null,"07:00:00",null,null,"19:00:00"]
[null,"08:00:00",null,null,"20:00:00"]
[null,"09:00:00",null,null,"21:00:00","Over"]
[null,"10:00:00",null,null,"22:00:00"]
[null,"11:00:00",null,null,"23:00:00"]
[null,"12:00:00",null,null,1]
[null,"13:00:00",null,null,1.0416666666666701]
[null,"14:00:00",null,null,1.0833333333333299]
[null,"15:00:00",null,null,1.125]
[null,"16:00:00",null,null,1.1666666666666701]
[null,"17:00:00",null,null,1.2083333333333299]
[null,"18:00:00",null,null,1.25,"Regular"]
[null,"19:00:00",null,null,1.2916666666666701]
[null,"20:00:00",null,null,1.3333333333333299]
[null,"21:00:00","Over",null,1.375]
[null,"22:00:00",null,null,1.4166666666666701]
[null,"23:00:00",null,null,1.4583333333333299]
[null,1,null,null,1.5]

{"sheet":"Help","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,"Table5"]
[null,null,"NName","Refers"]
[]
[null,null,"Bk",2.0833333333333301E-2]
[null,null,"coln","COLUMN()-MIN(COLUMN(Table1))+1"]
[null,null,"InS","MIN(MAX(W_f,RegS),RegF)-MAX(MIN(W_s,RegF),RegS)"]
[null,null,"InSg","MIN(MAX(W_f+1,OvrS),OvrF)-MAX(MIN(W_s,OvrF),OvrS)"]
[null,null,"Lt",0.25]
[null,null,"OutS","SQRT(W_f-W_s)^2-InS"]
[null,null,"OutSg","(W_f+1-W_s)-InSg"]
[null,null,"OvrF","Sheet1!$C$21"]
[null,null,"OvrS","Sheet1!$B$21"]
[null,null,"RegF","Sheet1!$C$17"]
[null,null,"RegS","Sheet1!$B$17"]
[null,null,"rown","ROW()-MIN(ROW(Table1))+1"]
[null,null,"W_f","INDEX(Table1,Wn,coln+1)"]
[null,null,"W_s","INDEX(Table1,Wn,coln)"]
[null,null,"Wn","MATCH(RIGHT(Table1[@Week],2)*1,Table1[Week],0)"]