{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Stock Data","Form","Product Search"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Stock Data","index":0,"n_rows":78,"n_cols":6,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["Product ID","Product Name","Quantity Per Unit","Unit Price","Units In Stock","Units On Order"]
[17,"Alice Mutton","20 - 1 kg tins",39,0,0]
[3,"Aniseed Syrup","12 - 550 ml bottles",10,13,70]
[40,"Boston Crab Meat","24 - 4 oz tins",18.399999999999999,123,0]
[60,"Camembert Pierrot","15 - 300 g rounds",34,19,0]
[18,"Carnarvon Tigers","16 kg pkg.",62.5,42,0]
[1,"Chai","10 boxes x 20 bags",18,39,0]
[2,"Chang","24 - 12 oz bottles",19,17,40]
[39,"Chartreuse verte","750 cc per bottle",18,69,0]
[4,"Chef Anton's Cajun Seasoning","48 - 6 oz jars",22,53,0]
[5,"Chef Anton's Gumbo Mix","36 boxes",21.35,0,0]
[48,"Chocolade","10 pkgs.",12.75,15,70]
[38,"Côte de Blaye","12 - 75 cl bottles",263.5,17,0]
[58,"Escargots de Bourgogne","24 pieces",13.25,62,0]
[52,"Filo Mix","16 - 2 kg boxes",7,38,0]
[71,"Fløtemysost","10 - 500 g pkgs.",21.5,26,0]
[33,"Geitost","500 g",2.5,112,0]
[15,"Genen Shouyu","24 - 250 ml bottles",15.5,39,0]
[56,"Gnocchi di nonna Alice","24 - 250 g pkgs.",38,21,10]
[31,"Gorgonzola Telino","12 - 100 g pkgs",12.5,0,70]
[6,"Grandma's Boysenberry Spread","12 - 8 oz jars",25,120,0]
[37,"Gravad lax","12 - 500 g pkgs.",26,11,50]
[24,"Guaraná Fantástica","12 - 355 ml cans",4.5,20,0]
[69,"Gudbrandsdalsost","10 kg pkg.",36,26,0]
[44,"Gula Malacca","20 - 2 kg bags",19.45,27,0]
[26,"Gumbär Gummibärchen","100 - 250 g bags",31.23,15,0]
[22,"Gustaf's Knäckebröd","24 - 500 g pkgs.",21,104,0]
[10,"Ikura","12 - 200 ml jars",31,31,0]
[36,"Inlagd Sill","24 - 250 g  jars",19,112,0]
[43,"Ipoh Coffee","16 - 500 g tins",46,17,10]
[41,"Jack's New England Clam Chowder","12 - 12 oz cans",9.65,85,0]
[13,"Konbu","2 kg box",6,24,0]
[76,"Lakkalikööri","500 ml",18,57,0]
[67,"Laughing Lumberjack Lager","24 - 12 oz bottles",14,52,0]
[74,"Longlife Tofu","5 kg pkg.",10,4,20]
[65,"Louisiana Fiery Hot Pepper Sauce","32 - 8 oz bottles",21.05,76,0]
[66,"Louisiana Hot Spiced Okra","24 - 8 oz jars",17,4,100]
[51,"Manjimup Dried Apples","50 - 300 g pkgs.",53,20,0]
[32,"Mascarpone Fabioli","24 - 200 g pkgs.",32,9,40]
[49,"Maxilaku","24 - 50 g pkgs.",20,10,60]
[9,"Mishi Kobe Niku","18 - 500 g pkgs.",97,29,0]
[72,"Mozzarella di Giovanni","24 - 200 g pkgs.",34.799999999999997,14,0]
[30,"Nord-Ost Matjeshering","10 - 200 g glasses",25.89,10,0]
[8,"Northwoods Cranberry Sauce","12 - 12 oz jars",40,6,0]
[25,"NuNuCa Nuß-Nougat-Creme","20 - 450 g glasses",14,76,0]
[77,"Original Frankfurter grüne Soße","12 boxes",13,32,0]
[70,"Outback Lager","24 - 355 ml bottles",15,15,10]
[55,"Pâté chinois","24 boxes x 2 pies",24,115,0]
[16,"Pavlova","32 - 500 g boxes",17.45,29,0]
[53,"Perth Pasties","48 pieces",32.799999999999997,0,0]
[11,"Queso Cabrales","1 kg pkg.",21,22,30]
[12,"Queso Manchego La Pastora","10 - 500 g pkgs.",38,86,0]
[59,"Raclette Courdavault","5 kg pkg.",55,79,0]
[57,"Ravioli Angelo","24 - 250 g pkgs.",19.5,36,0]
[75,"Rhönbräu Klosterbier","24 - 0.5 l bottles",7.75,125,0]
[73,"Röd Kaviar","24 - 150 g jars",15,101,0]
[45,"Røgede sild","1k pkg.",9.5,5,70]
[28,"Rössle Sauerkraut","25 - 825 g cans",45.6,26,0]
[34,"Sasquatch Ale","24 - 12 oz bottles",14,111,0]
[27,"Schoggi Schokolade","100 - 100 g pieces",43.9,49,0]
[68,"Scottish Longbreads","10 boxes x 8 pieces",12.5,6,10]
[42,"Singaporean Hokkien Fried Mee","32 - 1 kg pkgs.",14,26,0]
[20,"Sir Rodney's Marmalade","30 gift boxes",81,40,0]
[21,"Sir Rodney's Scones","24 pkgs. x 4 pieces",10,3,40]
[61,"Sirop d'érable","24 - 500 ml bottles",28.5,113,0]
[46,"Spegesild","4 - 450 g glasses",12,95,0]
[35,"Steeleye Stout","24 - 12 oz bottles",18,20,0]
[62,"Tarte au sucre","48 pies",49.3,17,0]
[19,"Teatime Chocolate Biscuits","10 boxes x 12 pieces",9.1999999999999993,25,0]
[29,"Thüringer Rostbratwurst","50 bags x 30 sausgs.",123.79,0,0]
[14,"Tofu","40 - 100 g pkgs.",23.25,35,0]
[54,"Tourtière","16 pies",7.45,21,0]
[23,"Tunnbröd","12 - 250 g pkgs.",9,61,0]
[7,"Uncle Bob's Organic Dried Pears","12 - 1 lb pkgs.",30,15,0]
[50,"Valkoinen suklaa","12 - 100 g bars",16.25,65,0]
[63,"Vegie-spread","15 - 625 g jars",43.9,24,0]
[64,"Wimmers gute Semmelknödel","20 bags x 4 pieces",33.25,22,80]
[47,"Zaanse koeken","10 - 4 oz boxes",9.5,36,0]

{"sheet":"Form","index":1,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Name",null,null,null,"Date"]
[]
["ID","Product Name","Quantity Per Unit","Price","Quantity","Total"]
[4,{"$f":"IFERROR(VLOOKUP(A4,'Stock Data'!A:F,2,FALSE),\"\")","v":"Chef Anton's Cajun Seasoning"},{"$f":"IFERROR(VLOOKUP(A4,'Stock Data'!A:F,3,FALSE),\"\")","v":"48 - 6 oz jars"},{"$f":"IFERROR(VLOOKUP(A4,'Stock Data'!A:F,4,FALSE),0)","v":22},10,{"$f":"D4*E4","v":220}]
[65,{"$f":"IFERROR(VLOOKUP(A5,'Stock Data'!A:F,2,FALSE),\"\")","v":"Louisiana Fiery Hot Pepper Sauce"},{"$f":"IFERROR(VLOOKUP(A5,'Stock Data'!A:F,3,FALSE),\"\")","v":"32 - 8 oz bottles"},{"$f":"IFERROR(VLOOKUP(A5,'Stock Data'!A:F,4,FALSE),0)","v":21.05},8,{"$f":"D5*E5","v":168.4}]
[null,{"$f":"IFERROR(VLOOKUP(A6,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A6,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A6,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A7,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A7,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A7,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A8,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A8,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A8,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A9,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A9,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A9,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A10,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A10,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A10,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A11,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A11,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A11,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A12,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A12,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A12,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A13,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A13,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A13,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A14,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A14,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A14,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A15,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A15,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A15,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[null,{"$f":"IFERROR(VLOOKUP(A16,'Stock Data'!A:F,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A16,'Stock Data'!A:F,3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(A16,'Stock Data'!A:F,4,FALSE),0)","v":0},null,0]
[]
[null,null,null,null,"Total",{"$f":"SUM(F4:F16)","v":388.4}]

{"sheet":"Product Search","index":2,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Product ID","Product Name","Quantity Per Unit"]