{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Lego Inventory","Customers","Invoice"],"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":"Lego Inventory","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Product number","Product name ","Quantity","Description ","Theme","New/used","Price ","Availability"]
[10333,"Barad-Dur",1,"Barad-Dur - Saurons Tower ","Lord of the Rings","New",3000,"Yes",null,null,"Column1","Column2"]
[42207,"Ferrari F1",1,"Ferrari Sf-24","Super Cars","New",2000,"yes",null,null,"Total Price ",{"$f":"SUM(G:G)","v":66550}]
[75407,"Star Wars sign",2,"Star Wars Sign","Star Wars ","New",500,"Yes",null,null,"Average Price",{"$f":"AVERAGE(G:G)","v":2146.7741935483873}]
[10351,"Sherlock Holmes Book Nook ",1,"Sherlock Holmes Book Nook ","Icons","New",600,"Yes",null,null,"Median",{"$f":"MEDIAN(G:G)","v":2000}]
[21323,"Grand Piano",1,"Playable Lego Piano","Ideas","New ",2000,"Yes"]
[21314,"Tron Legacy ",1,"Light Cycles ","Ideas","Used",600,"Yes"]
[6211,"Imperial Star Destroyer",1,"2006 Imperial Star Destroyer ","Star Wars ","Used",1500,"Yes"]
[6212,"X-wing Fighter",1,"2006 X-wing Fighter ","Star Wars ","Used",1500,"Yes"]
[7658,"Y-wing Fighter",1,"2007 Y-wing Fighter ","Star Wars ","Used",2000,"Yes"]
[7671,"AT-AP walker ",1,"2008 AT-AP Walker","Star Wars ","Used",800,"Yes"]
[7778,"Milenium Falcon - Midi",0,"Midi Scale Milenium Falcon","Star Wars ","Used",400,"Yes",null,null,"Criteria","Counts"]
[7879,"Hoth Echo Base",1,"2011 Hoth Echo Base ","Star Wars ","Used",1500,"Yes",null,null,"Star Wars ",{"$f":"COUNTIF(E2:E38,\"Star Wars \")","v":22}]
[75105,"Millenium Falcon",1,"2015 Milenium Falcon","Star Wars ","Used",3000,"Yes",null,null,"Lord of the rings ",{"$f":"COUNTIF(E2:E38,\"Lord of the Rings\")","v":4}]
[8038,"Battle of Endor",1,"2009 Battle of Endor","Star Wars ","Used",2000,"Yes",null,null,"Other ",{"$f":"COUNTIFS(E2:E38,\"<>Star Wars \",E2:E38,\"<>Lord of the Rings\")","v":11}]
[8089,"Hoth Wampa Cave",1,"2010 Wampa Cave","Star Wars ","Used",500,"Yes"]
[10178,"AT-AT Walker ",1,"2010  motorized AT- AT walker ","Star Wars ","New",2000,"Yes"]
[10188,"Death Star",1,"2008 Death Star (3)","Star Wars ","Used",4000,"No"]
[10198,"Tantive IV",1,"2009 Tantive IV","Star Wars ","Used",3000,"No"]
[10212,"Imperial Shuttle ",1,"2010 Imperial Shuttle ","Star Wars ","Used",5000,"No "]
[10225,"R2-D2",2,"2012 R2-D2 ","Star Wars ","Used",1500,"No"]
[10236,"Ewok Village",1,"Ewok Village ","Star Wars ","Used",5000,"No"]
[10240,"Red Five X-wing ",1,"Red Five X-wing UCS","Star Wars ","Used",2000,"Yes"]
[75059,"Sandcrawler",1,"2014 Sandcrawler UCS","Star Wars ","Used",5000,"Yes"]
[75060,"Slave 1 ",1,"2015 Slave 1 UCS","Star Wars ","Used",4000,"No"]
[75093,"Death Star Final Duel ",1,"2015 Death Star Fianl Duel","Star Wars ","Used",500,"Yes"]
[75102,"Poes X wing ",2,"2015 Poes Xwing Fighter","Star Wars ","Used",550,"Yes"]
[75137,"Carbon Freeze Chamber ",1,"2016 Carbon Freeze Chamber ","Star Wars ","New",200,"Yes"]
[9474,"Battle of Helms deep ",1,"Battle of Helms Deep ","Lord of the Rings","Used",5000,"No"]
[10237,"Tower of Orthank",1,"Tower of Orthank","Lord of the Rings","Used",6000,"Yes"]
[79006,"Council of Elrond",1,"Council of Elrond","Lord of the Rings","Used",800,"Yes"]
[2704,"Limited Edition Trophy",3,"Limited edition trophy award","Limited","New",100,"Yes"]

{"sheet":"Customers","index":1,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["ID","FirstName","LastName","Email","Phone","Address"]
[327137493,"Eddy","Blatt","Blatt@test.com",270824222880,"South Africa"]
[7805235061087,"Neil","Hofman","hofmanneil@yahoo.com",972584850064,"Israel"]
[36589745,"John","Doe","Doe@test.com",968564123,"Timbuktu"]

{"sheet":"Invoice","index":2,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Customer ID","Name ","Name ",null,"Product Name ","Price","Quantity"]
[327137493,"Eddy","Blatt",7778,"Milenium Falcon - Midi",400,1,"2026-03-01T15:40:58"]