{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":2,"macros":0,"external_links":1,"defined_names":6,"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":"Sheet1","index":0,"n_rows":7,"n_cols":26,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,6,0,9]]}
[null,"Original",null,null,null,null,"Copy for Calculations",null,null,null,null,null,null,null,null," - 1"," - 1"," - 1"," - 2"," - 2",null," - 2"," - 3"," - 3",null," - 3"]
[null,"Band","Stage","Start Time","End Time",null,"Band","Stage","Stage Occurance","Start Time","End Time","Duration",null,"Stage","Stage Name","Band1","Start Time1","Duration1","Band2","Start Time2","Adj Start Time2","Duration2","Band3","Start Time3","Adj Start Time3","Duration3"]
[null,"Band A",4,"13:05:00","13:40:00",null,{"$f":"Table3[[#This Row],[Band]]","v":"Band A"},{"$f":"Table3[[#This Row],[Stage]]","v":4},{"$f":"Table1[[#This Row],[Stage]]&\" - \"&COUNTIF($H$3:H3,H3)","v":"4 - 1"},{"$f":"Table3[[#This Row],[Start Time]]","v":0.54513888888888895},{"$f":"Table3[[#This Row],[End Time]]","v":0.56944444444444442},{"$f":"Table1[[#This Row],[End Time]]-Table1[[#This Row],[Start Time]]","v":2.4305555555555469E-2},null,1,{"$f":"\"Stage \"&Table2[[#This Row],[Stage]]","v":"Stage 1"},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&P$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":"Band D"},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Q$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":0.60069444444444442},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&R$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":2.777777777777779E-2},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&S$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&T$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time2]]-Table2[[#This Row],[Start Time1]]-Table2[[#This Row],[Duration1]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&V$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&W$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&X$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time3]]-Table2[[#This Row],[Duration2]]-Table2[[#This Row],[Start Time2]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Z$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}}]
[null,"Band B",5,"13:30:00","17:00:00",null,{"$f":"Table3[[#This Row],[Band]]","v":"Band B"},{"$f":"Table3[[#This Row],[Stage]]","v":5},{"$f":"Table1[[#This Row],[Stage]]&\" - \"&COUNTIF($H$3:H4,H4)","v":"5 - 1"},{"$f":"Table3[[#This Row],[Start Time]]","v":0.5625},{"$f":"Table3[[#This Row],[End Time]]","v":0.70833333333333337},{"$f":"Table1[[#This Row],[End Time]]-Table1[[#This Row],[Start Time]]","v":0.14583333333333337},null,2,{"$f":"\"Stage \"&Table2[[#This Row],[Stage]]","v":"Stage 2"},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&P$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":"Band E"},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Q$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":0.5625},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&R$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":2.430555555555558E-2},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&S$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&T$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time2]]-Table2[[#This Row],[Start Time1]]-Table2[[#This Row],[Duration1]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&V$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&W$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&X$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time3]]-Table2[[#This Row],[Duration2]]-Table2[[#This Row],[Start Time2]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Z$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}}]
[null,"Band C",3,"14:20:00","14:45:00",null,{"$f":"Table3[[#This Row],[Band]]","v":"Band C"},{"$f":"Table3[[#This Row],[Stage]]","v":3},{"$f":"Table1[[#This Row],[Stage]]&\" - \"&COUNTIF($H$3:H5,H5)","v":"3 - 1"},{"$f":"Table3[[#This Row],[Start Time]]","v":0.59722222222222221},{"$f":"Table3[[#This Row],[End Time]]","v":0.61458333333333337},{"$f":"Table1[[#This Row],[End Time]]-Table1[[#This Row],[Start Time]]","v":1.736111111111116E-2},null,3,{"$f":"\"Stage \"&Table2[[#This Row],[Stage]]","v":"Stage 3"},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&P$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":"Band C"},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Q$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":0.59722222222222221},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&R$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":1.736111111111116E-2},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&S$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&T$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time2]]-Table2[[#This Row],[Start Time1]]-Table2[[#This Row],[Duration1]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&V$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&W$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&X$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time3]]-Table2[[#This Row],[Duration2]]-Table2[[#This Row],[Start Time2]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Z$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}}]
[null,"Band D",1,"14:25:00","15:05:00",null,{"$f":"Table3[[#This Row],[Band]]","v":"Band D"},{"$f":"Table3[[#This Row],[Stage]]","v":1},{"$f":"Table1[[#This Row],[Stage]]&\" - \"&COUNTIF($H$3:H6,H6)","v":"1 - 1"},{"$f":"Table3[[#This Row],[Start Time]]","v":0.60069444444444442},{"$f":"Table3[[#This Row],[End Time]]","v":0.62847222222222221},{"$f":"Table1[[#This Row],[End Time]]-Table1[[#This Row],[Start Time]]","v":2.777777777777779E-2},null,4,{"$f":"\"Stage \"&Table2[[#This Row],[Stage]]","v":"Stage 4"},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&P$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":"Band A"},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Q$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":0.54513888888888895},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&R$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":2.4305555555555469E-2},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&S$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&T$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time2]]-Table2[[#This Row],[Start Time1]]-Table2[[#This Row],[Duration1]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&V$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&W$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&X$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time3]]-Table2[[#This Row],[Duration2]]-Table2[[#This Row],[Start Time2]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Z$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}}]
[null,"Band E",2,"13:30:00","14:05:00",null,{"$f":"Table3[[#This Row],[Band]]","v":"Band E"},{"$f":"Table3[[#This Row],[Stage]]","v":2},{"$f":"Table1[[#This Row],[Stage]]&\" - \"&COUNTIF($H$3:H7,H7)","v":"2 - 1"},{"$f":"Table3[[#This Row],[Start Time]]","v":0.5625},{"$f":"Table3[[#This Row],[End Time]]","v":0.58680555555555558},{"$f":"Table1[[#This Row],[End Time]]-Table1[[#This Row],[Start Time]]","v":2.430555555555558E-2},null,5,{"$f":"\"Stage \"&Table2[[#This Row],[Stage]]","v":"Stage 5"},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&P$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":"Band B"},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Q$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":0.5625},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&R$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":0.14583333333333337},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&S$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&T$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time2]]-Table2[[#This Row],[Start Time1]]-Table2[[#This Row],[Duration1]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&V$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Band],MATCH(Table2[[#This Row],[Stage]:[Stage]]&W$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Start Time],MATCH(Table2[[#This Row],[Stage]:[Stage]]&X$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}},{"$f":"Table2[[#This Row],[Start Time3]]-Table2[[#This Row],[Duration2]]-Table2[[#This Row],[Start Time2]]","v":{"$error":"#N/A"}},{"$f":"INDEX(Table1[Duration],MATCH(Table2[[#This Row],[Stage]:[Stage]]&Z$1,Table1[[Stage Occurance]:[Stage Occurance]],0))","v":{"$error":"#N/A"}}]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}