{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data Set","Practice","Trace Dependent","Trace Dependent 1","VBA","VBA 1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Data Set","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Data Set"]
[]
[null,"Order ID","Product"]
[null,"XYZ-121","Desktop"]
[null,"XYZ-123","Audio Box"]
[null,"XYZ-124","Xbox"]
[null,"XYZ-125","Monitor"]
[null,"XYZ-126","Home Theatre"]
[null,"XYZ-129","Laptop"]

{"sheet":"Practice","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Practice Sheet"]
[]
[null,"Order ID","Product"]
[null,"XYZ-121","Desktop"]
[null,"XYZ-123","Audio Box"]
[null,"XYZ-124","Xbox"]
[null,"XYZ-125","Monitor"]
[null,"XYZ-126","Home Theatre"]
[null,"XYZ-129","Laptop"]

{"sheet":"Trace Dependent","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Trace Dependents Command"]
[]
[null,"Order ID","Product"]
[null,"XYZ-121","Desktop"]
[null,"XYZ-123","Audio Box"]
[null,"XYZ-124","Xbox"]
[null,"XYZ-125","Monitor"]
[null,"XYZ-126","Home Theatre"]
[null,"XYZ-129","Laptop"]

{"sheet":"Trace Dependent 1","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Trace Dependents Command"]
[]
[null,"Order ID","Product","Result"]
[null,"XYZ-121","Desktop",{"$f":"COUNTIF('Trace Dependent'!B5:B10,'Trace Dependent 1'!B5)","v":1}]
[null,"XYZ-122","Netbook",{"$f":"COUNTIF('Trace Dependent'!B6:B11,'Trace Dependent 1'!B6)","v":0}]
[null,"XYZ-124","Xbox",{"$f":"COUNTIF('Trace Dependent'!B7:B12,'Trace Dependent 1'!B7)","v":1}]
[null,"XYZ-125","Monitor",{"$f":"COUNTIF('Trace Dependent'!B8:B13,'Trace Dependent 1'!B8)","v":1}]
[null,"XYZ-126","Home Theatre",{"$f":"COUNTIF('Trace Dependent'!B9:B14,'Trace Dependent 1'!B9)","v":1}]
[null,"XYZ-128","Tablet",{"$f":"COUNTIF('Trace Dependent'!B10:B15,'Trace Dependent 1'!B10)","v":0}]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Order ID","Product"]
[null,"XYZ-121","Desktop"]
[null,"XYZ-123","Audio Box"]
[null,"XYZ-124","Xbox"]
[null,"XYZ-125","Monitor"]
[null,"XYZ-126","Home Theatre"]
[null,"XYZ-129","Laptop"]

{"sheet":"VBA 1","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Order ID","Product","Result"]
[null,"XYZ-121","Desktop",{"$f":"COUNTIF(VBA!B5:B10,'VBA 1'!B5)","v":1}]
[null,"XYZ-122","Netbook",{"$f":"COUNTIF(VBA!B6:B11,'VBA 1'!B6)","v":0}]
[null,"XYZ-124","Xbox",{"$f":"COUNTIF(VBA!B7:B12,'VBA 1'!B7)","v":1}]
[null,"XYZ-125","Monitor",{"$f":"COUNTIF(VBA!B8:B13,'VBA 1'!B8)","v":1}]
[null,"XYZ-126","Home Theatre",{"$f":"COUNTIF(VBA!B9:B14,'VBA 1'!B9)","v":1}]
[null,"XYZ-128","Tablet",{"$f":"COUNTIF(VBA!B10:B15,'VBA 1'!B10)","v":0}]