{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Filter","Data","Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Filter","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,2,1]
[]
[]
[]
[]
[null,"Order # id","Product","Price"]
[null,{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(A1)),COLUMN(A1)),\"\")","v":1020},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(B1)),COLUMN(B1)),\"\")","v":"Graphics card"},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(C1)),COLUMN(C1)),\"\")","v":90}]
[null,{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(A2)),COLUMN(A2)),\"\")","v":1020},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(B2)),COLUMN(B2)),\"\")","v":"Graphics card"},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(C2)),COLUMN(C2)),\"\")","v":120}]
[null,{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(A5)),COLUMN(A5)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(B5)),COLUMN(B5)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(C5)),COLUMN(C5)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(A6)),COLUMN(A6)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(B6)),COLUMN(B6)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(C6)),COLUMN(C6)),\"\")","v":""}]
[null,{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(A7)),COLUMN(A7)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(B7)),COLUMN(B7)),\"\")","v":""},{"$f":"IFERROR(INDEX(Data!$A$3:$C$11,SMALL(IF((INDEX(uniqueorder,$B$1)=order)*(INDEX(uniqueproduct,$C$1)=product),ROW(order)-MIN(ROW(order))+1,\"\"),ROW(C7)),COLUMN(C7)),\"\")","v":""}]

{"sheet":"Data","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
["Order # id","Product","Price"]
[1010,"Graphics card",100]
[1010,"Soundcard",70]
[1010,"Motherboard",90]
[1010,"Soundcard",60]
[1020,"Graphics card",90]
[1020,"Motherboard",110]
[1020,"Graphics card",120]

{"sheet":"Calculation","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Unique order #","Unique products"]
[{"$f":"IFERROR(INDEX(order,MATCH(0,COUNTIF($A$1:A1,order),0)),\"\")","v":1010},{"$f":"IFERROR(INDEX(product,MATCH(0,COUNTIF($B$1:B1,product)+(order<>INDEX(Calculation!$A$2:$A$3,Filter!$B$1)),0)),\"\")","v":"Graphics card"}]
[{"$f":"IFERROR(INDEX(order,MATCH(0,COUNTIF($A$1:A2,order),0)),\"\")","v":1020},{"$f":"IFERROR(INDEX(product,MATCH(0,COUNTIF($B$1:B2,product)+(order<>INDEX(Calculation!$A$2:$A$3,Filter!$B$1)),0)),\"\")","v":"Motherboard"}]
[{"$f":"IFERROR(INDEX(order,MATCH(0,COUNTIF($A$1:A3,order),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(product,MATCH(0,COUNTIF($B$1:B3,product)+(order<>INDEX(Calculation!$A$2:$A$3,Filter!$B$1)),0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(order,MATCH(0,COUNTIF($A$1:A4,order),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(product,MATCH(0,COUNTIF($B$1:B4,product)+(order<>INDEX(Calculation!$A$2:$A$3,Filter!$B$1)),0)),\"\")","v":""}]
[{"$f":"IFERROR(INDEX(order,MATCH(0,COUNTIF($A$1:A5,order),0)),\"\")","v":""},{"$f":"IFERROR(INDEX(product,MATCH(0,COUNTIF($B$1:B5,product)+(order<>INDEX(Calculation!$A$2:$A$3,Filter!$B$1)),0)),\"\")","v":""}]