{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Dataset","Direct Cell Reference","TEXT Function","VLOOKUP","INDEX-MATCH","Left Portion","Middle Portion","Right Portion","Another Sheet","Conditional Logic","Named Range"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Dataset","index":0,"n_rows":13,"n_cols":4,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date"]
["Laptop Pro","Display Device",{"v":1299.5,"d":"1299.50"},"2025-01-15"]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"Direct Cell Reference","index":1,"n_rows":13,"n_cols":6,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Product Name"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,{"$f":"A2","v":"Laptop Pro"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"TEXT Function","index":2,"n_rows":13,"n_cols":6,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Launch Date"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,{"$f":"TEXT(D2, \"dddd, mmmm d, yyyy\")","v":"Wednesday, January 15, 2025"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"VLOOKUP","index":3,"n_rows":13,"n_cols":7,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Product Name","Category"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,"USB-C Hub",{"$f":"VLOOKUP(F2,A2:D13,2,FALSE)","v":"Accessories"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"INDEX-MATCH","index":4,"n_rows":13,"n_cols":7,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Product Name","Category"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,"USB-C Hub",{"$f":"INDEX(B2:B13,MATCH(F2,A2:A13,0))","v":"Accessories"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"Left Portion","index":5,"n_rows":13,"n_cols":6,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Left Part of Product Name"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,{"$f":"LEFT(A5,10)","v":"Mechanical"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"Middle Portion","index":6,"n_rows":13,"n_cols":6,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Middle Part of Product Name"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,{"$f":"MID(A10,10,3)","v":"HDD"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"Right Portion","index":7,"n_rows":13,"n_cols":6,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Right Part of Product Name"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,{"$f":"RIGHT(A10,3)","v":"2TB"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"Another Sheet","index":8,"n_rows":13,"n_cols":6,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Product Name"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,{"$f":"Dataset!A2","v":"Laptop Pro"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]

{"sheet":"Conditional Logic","index":9,"n_rows":13,"n_cols":6,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Price Tier"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,{"$f":"_xlfn.IFS(B2<>\"Storage Device\",\"Not a Storage Device\",C2<=90,\"Budget Storage\",C2<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B2<>\"Storage Device\",\"Not a Storage Device\",C2<=90,\"Budget Storage\",C2<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03",null,{"$f":"_xlfn.IFS(B3<>\"Storage Device\",\"Not a Storage Device\",C3<=90,\"Budget Storage\",C3<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B3<>\"Storage Device\",\"Not a Storage Device\",C3<=90,\"Budget Storage\",C3<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12",null,{"$f":"_xlfn.IFS(B4<>\"Storage Device\",\"Not a Storage Device\",C4<=90,\"Budget Storage\",C4<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B4<>\"Storage Device\",\"Not a Storage Device\",C4<=90,\"Budget Storage\",C4<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20",null,{"$f":"_xlfn.IFS(B5<>\"Storage Device\",\"Not a Storage Device\",C5<=90,\"Budget Storage\",C5<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B5<>\"Storage Device\",\"Not a Storage Device\",C5<=90,\"Budget Storage\",C5<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01",null,{"$f":"_xlfn.IFS(B6<>\"Storage Device\",\"Not a Storage Device\",C6<=90,\"Budget Storage\",C6<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B6<>\"Storage Device\",\"Not a Storage Device\",C6<=90,\"Budget Storage\",C6<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15",null,{"$f":"_xlfn.IFS(B7<>\"Storage Device\",\"Not a Storage Device\",C7<=90,\"Budget Storage\",C7<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B7<>\"Storage Device\",\"Not a Storage Device\",C7<=90,\"Budget Storage\",C7<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22",null,{"$f":"_xlfn.IFS(B8<>\"Storage Device\",\"Not a Storage Device\",C8<=90,\"Budget Storage\",C8<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B8<>\"Storage Device\",\"Not a Storage Device\",C8<=90,\"Budget Storage\",C8<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05",null,{"$f":"_xlfn.IFS(B9<>\"Storage Device\",\"Not a Storage Device\",C9<=90,\"Budget Storage\",C9<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B9<>\"Storage Device\",\"Not a Storage Device\",C9<=90,\"Budget Storage\",C9<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Good Deal"}]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18",null,{"$f":"_xlfn.IFS(B10<>\"Storage Device\",\"Not a Storage Device\",C10<=90,\"Budget Storage\",C10<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B10<>\"Storage Device\",\"Not a Storage Device\",C10<=90,\"Budget Storage\",C10<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Budget Storage"}]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20",null,{"$f":"_xlfn.IFS(B11<>\"Storage Device\",\"Not a Storage Device\",C11<=90,\"Budget Storage\",C11<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B11<>\"Storage Device\",\"Not a Storage Device\",C11<=90,\"Budget Storage\",C11<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22",null,{"$f":"_xlfn.IFS(B12<>\"Storage Device\",\"Not a Storage Device\",C12<=90,\"Budget Storage\",C12<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B12<>\"Storage Device\",\"Not a Storage Device\",C12<=90,\"Budget Storage\",C12<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Budget Storage"}]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24",null,{"$f":"_xlfn.IFS(B13<>\"Storage Device\",\"Not a Storage Device\",C13<=90,\"Budget Storage\",C13<=110,\"Good Deal\",TRUE,\"Premium Storage\"\n=_xlfn.IFS(B13<>\"Storage Device\",\"Not a Storage Device\",C13<=90,\"Budget Storage\",C13<=110,\"Good Deal\",TRUE,\"Premium Storage\"))","v":"Not a Storage Device"}]

{"sheet":"Named Range","index":10,"n_rows":13,"n_cols":6,"rows_kept":13}
["Product Name","Category","Unit Price ($)","Launch Date",null,"Product Name"]
["Laptop Pro","Laptop",{"v":1299.5,"d":"1299.50"},"2025-01-15",null,{"$f":"Laptop","v":"Laptop Pro"}]
["Wireless Mouse","Accessories",{"v":29,"d":"29.00"},"2025-03-03"]
["USB-C Hub","Accessories",{"v":49.5,"d":"49.50"},"2025-04-12"]
["Mechanical Keyboard","Accessories",{"v":89.5,"d":"89.50"},"2025-05-20"]
["27\" Monitor","Display Device",{"v":300,"d":"300.00"},"2025-06-01"]
["Webcam HD","Accessories",{"v":69.5,"d":"69.50"},"2025-07-15"]
["Bluetooth Speaker","Audio Device",{"v":80,"d":"80.00"},"2025-08-22"]
["SSD 1TB","Storage Device",{"v":109.5,"d":"109.50"},"2025-09-05"]
["External HDD 2TB","Storage Device",{"v":90,"d":"90.00"},"2025-10-18"]
["Gaming Mousepad","Accessories",{"v":24.5,"d":"24.50"},"2025-10-20"]
["USB Flash Drive 64GB","Storage Device",{"v":15,"d":"15.00"},"2025-10-22"]
["HDMI Cable 6ft","Accessories",{"v":13,"d":"13.00"},"2025-10-24"]