{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Orders","list","Form","Order Form","Sheet1","Data Form","Customers"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"1900"}

{"sheet":"Orders","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["Print","OrderNo.","Date","Customer","Salesperson","Item","Units","UnitCost","Total"]
[null,56098,"2022-11-15","XYZ Company","Lopez","Pen Set",62,4.99,{"$f":"H3*G3","v":309.38}]
[null,56099,"2022-11-15","XYZ Company","Lopez","Binder",85,19.989999999999998,1699.1499999999999]
[null,56100,"2022-11-17","International Ltd.","Cartier","Pen Set",10,1.99,19.899999999999999]
[null,56101,"2022-11-18","ABC Industries","Anderson","Binder",10,4.99,49.900000000000006]
[null,56102,"2022-11-19","International Ltd.","Cartier","Pen",58,19.989999999999998,1159.4199999999998]
[null,56103,"2022-11-20","Really Big Co.","Anderson","Pen Set",24,2.99,71.760000000000005]
[null,56104,"2022-11-21","ABC Industries","Anderson","Pen Set",6,1.99,11.94]
[null,56105,"2022-11-22","International Ltd.","Cartier","Pen Set",39,1.99,77.61]
[null,56106,"2022-11-23","ABC Industries","Anderson","Pen Set",10,4.99,49.900000000000006]
[null,56107,"2022-11-24","XYZ Company","Lopez","Binder",51,1.99,101.49]
[null,56108,"2022-11-25","XYZ Company","Lopez","Pen Set",80,4.99,399.20000000000005]
[null,56109,"2022-11-26","Really Big Co.","Anderson","Binder",33,8.99,296.67]
[null,56110,"2022-11-27","ABC Industries","Anderson","Desk",31,125,3875]

{"sheet":"list","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Use of Excel Ribbon"]
[]
[null,"OrderNo.","Date","Customer","Salesperson","Item","Units","UnitCost","Total",null,{"$f":"_xlfn.UNIQUE(Table13[Item])","v":"Pen Set"}]
[null,56098,"2022-11-15","XYZ Company","Lopez","Pen Set",62,4.99,{"$f":"H5*G5","v":309.38},null,"Binder"]
[null,56099,"2022-11-15","XYZ Company","Lopez","Binder",85,19.989999999999998,1699.1499999999999,null,"Pen"]
[null,56100,"2022-11-17","International Ltd.","Cartier","Pen Set",10,1.99,19.899999999999999,null,"Desk"]
[null,56101,"2022-11-18","ABC Industries","Anderson","Binder",10,4.99,49.900000000000006]
[null,56102,"2022-11-19","International Ltd.","Cartier","Pen",58,19.989999999999998,1159.4199999999998]
[null,56103,"2022-11-20","Really Big Co.","Anderson","Pen Set",24,2.99,71.760000000000005]
[null,56104,"2022-11-21","ABC Industries","Anderson","Pen Set",6,1.99,11.94]
[null,56105,"2022-11-22","International Ltd.","Cartier","Pen Set",39,1.99,77.61]
[null,56106,"2022-11-23","ABC Industries","Anderson","Pen Set",10,4.99,49.900000000000006]
[null,56107,"2022-11-24","XYZ Company","Lopez","Binder",51,1.99,101.49]
[null,56108,"2022-11-25","XYZ Company","Lopez","Pen Set",80,4.99,399.20000000000005]
[null,56109,"2022-11-26","Really Big Co.","Anderson","Binder",33,8.99,296.67]
[null,56110,"2022-11-27","ABC Industries","Anderson","Desk",31,125,3875]

{"sheet":"Form","index":2,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Order Form"]
[]
[null,null,null,"Order Number:",56101]
[null,null,null,"Order Date:","2022-11-18"]
[]
[null,"Ship to:"]
[null,"International Ltd."]
[null,{"$f":"VLOOKUP(B8,Table3[#All],2,FALSE)","v":"3456 Water Rd"}]
[null,{"$f":"VLOOKUP(B8,Table3[#All],3,FALSE)","v":"Oakville"}]
[null,{"$f":"VLOOKUP(B8,Table3[#All],5,FALSE)","v":"L6L 6L6"}]
[]
[null,"Item","Unit Cost","Qty","Total"]
[null,"Pen Set",10,4.99,{"$f":"C14*D14","v":49.900000000000006}]
[]
[null,null,"Subtotal",null,{"$f":"SUM(E14:E14)","v":49.900000000000006}]
[]
[null,null,"Tax",0.08,{"$f":"E16*D18","v":3.9920000000000004}]
[]
[null,null,"TOTAL",null,{"$f":"SUM(E16:E18)","v":53.892000000000003}]
[]
[]
[null,null,null,"Salesperson:","Anderson"]

{"sheet":"Order Form","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Order Form"]
[]
[]
[null,null,null,"Order Number:",56102]
[null,null,null,"Order Date:","2022-11-19"]
[]
[]
[null,"Ship to:"]
[null,"International Ltd."]
[null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,CustLookup,2,FALSE))","v":"3456 Water Rd"}]
[null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,CustLookup,3,FALSE)&\", \"&VLOOKUP(B10,CustLookup,4,FALSE))","v":"Oakville, ON"}]
[null,{"$f":"IF(B10=\"\",\"\",VLOOKUP(B10,CustLookup,5,FALSE))","v":"L6L 6L6"}]
[]
[null,"Item","Unit Cost","Qty","Total"]
[null,"Pen",58,19.989999999999998,{"$f":"C16*D16","v":1159.4199999999998}]
[]
[null,null,"Subtotal",null,{"$f":"SUM(E16:E16)","v":1159.4199999999998}]
[]
[null,null,"Tax",0.08,{"$f":"E18*D20","v":92.753599999999992}]
[]
[null,null,"TOTAL",null,{"$f":"SUM(E18:E20)","v":1252.1735999999999}]
[]
[]
[null,null,null,"Salesperson:","Cartier"]

{"sheet":"Sheet1","index":4,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,2,1,9]]}
[]
[null,null,"Use of Excel Ribbon"]

{"sheet":"Data Form","index":5,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Excel Form Command"]
[]
[null,"ID","Name","Designation","Department","Salary"]

{"sheet":"Customers","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Customer","Street","City","Prov","PostalCode"]
[null,"XYZ Company","123 Main St","Toronto","ON","M5M 5M5"]
[null,"ABC Industries","234 Pine Ave","Toronto","ON","M3M 3M3"]
[null,"International Ltd.","3456 Water Rd","Oakville","ON","L6L 6L6"]
[null,"Really Big Co.","78 First Blvd.","Halifax","NS","B3B 3B3"]
[]
[null,"Item"]
[null,"Pen Set"]
[null,"Binder"]
[null,"Pen"]
[null,"Desk"]