{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Production Plan","Explosion Detail","Item Master","BOM Builder","Setup","BOM Structure"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":2,"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":"Home","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Production Plan","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["FG SKU#","FG Description","FG Quantity","Missing BOM?",null,"Component SKU#","Component Description","Component Quantity"]
[2001,{"$f":"_xlfn.XLOOKUP(tblItems2[[#This Row],[FG SKU'#]],tblItems[SKU'#],tblItems[Description],\"\",0,)","v":"Office Starter Kit"},5,{"$f":"IF(AND(COUNTIFS('BOM Structure'!B:B,tblItems2[[#This Row],[FG SKU'#]])=0,tblItems2[[#This Row],[FG SKU'#]]>0),\"Missing BOM!\",\"\")","v":""},null,1008,"Barcode Labels Roll",10]
[2004,{"$f":"_xlfn.XLOOKUP(tblItems2[[#This Row],[FG SKU'#]],tblItems[SKU'#],tblItems[Description],\"\",0,)","v":"Laptop Setup Bundle"},1,{"$f":"IF(AND(COUNTIFS('BOM Structure'!B:B,tblItems2[[#This Row],[FG SKU'#]])=0,tblItems2[[#This Row],[FG SKU'#]]>0),\"Missing BOM!\",\"\")","v":""},null,1012,"Tape Roll",10]
[2002,{"$f":"_xlfn.XLOOKUP(tblItems2[[#This Row],[FG SKU'#]],tblItems[SKU'#],tblItems[Description],\"\",0,)","v":"Work From Home Bundle"},3,{"$f":"IF(AND(COUNTIFS('BOM Structure'!B:B,tblItems2[[#This Row],[FG SKU'#]])=0,tblItems2[[#This Row],[FG SKU'#]]>0),\"Missing BOM!\",\"\")","v":"Missing BOM!"},null,1010,"Microfiber Cloth",10]
[null,{"$f":"_xlfn.XLOOKUP(tblItems2[[#This Row],[FG SKU'#]],tblItems[SKU'#],tblItems[Description],\"\",0,)","v":""},null,{"$f":"IF(AND(COUNTIFS('BOM Structure'!B:B,tblItems2[[#This Row],[FG SKU'#]])=0,tblItems2[[#This Row],[FG SKU'#]]>0),\"Missing BOM!\",\"\")","v":""},null,1005,"Notebook A5",5]
[null,{"$f":"_xlfn.XLOOKUP(tblItems2[[#This Row],[FG SKU'#]],tblItems[SKU'#],tblItems[Description],\"\",0,)","v":""},null,{"$f":"IF(AND(COUNTIFS('BOM Structure'!B:B,tblItems2[[#This Row],[FG SKU'#]])=0,tblItems2[[#This Row],[FG SKU'#]]>0),\"Missing BOM!\",\"\")","v":""},null,1006,"Pen Blue (Pack of 10)",5]
[null,{"$f":"_xlfn.XLOOKUP(tblItems2[[#This Row],[FG SKU'#]],tblItems[SKU'#],tblItems[Description],\"\",0,)","v":""},null,{"$f":"IF(AND(COUNTIFS('BOM Structure'!B:B,tblItems2[[#This Row],[FG SKU'#]])=0,tblItems2[[#This Row],[FG SKU'#]]>0),\"Missing BOM!\",\"\")","v":""},null,1009,"Cleaning Spray 500ml",5]
[null,{"$f":"_xlfn.XLOOKUP(tblItems2[[#This Row],[FG SKU'#]],tblItems[SKU'#],tblItems[Description],\"\",0,)","v":""},null,{"$f":"IF(AND(COUNTIFS('BOM Structure'!B:B,tblItems2[[#This Row],[FG SKU'#]])=0,tblItems2[[#This Row],[FG SKU'#]]>0),\"Missing BOM!\",\"\")","v":""},null,1007,"Packing Box Medium",5]
[null,{"$f":"_xlfn.XLOOKUP(tblItems2[[#This Row],[FG SKU'#]],tblItems[SKU'#],tblItems[Description],\"\",0,)","v":""},null,{"$f":"IF(AND(COUNTIFS('BOM Structure'!B:B,tblItems2[[#This Row],[FG SKU'#]])=0,tblItems2[[#This Row],[FG SKU'#]]>0),\"Missing BOM!\",\"\")","v":""},null,1011,"Bubble Wrap Roll",5]
[null,null,null,null,null,1001,"USB Cable 1m",5]

{"sheet":"Explosion Detail","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["Level","Structure","Type","Qty per","Total Qty"]
[0,"2001 Office Starter Kit","FG",null,5]
[1,"  3001 Writing Set","SUB",1,5]
[2,"    +- 1005 Notebook A5","RM",1,5]
[2,"    +- 1006 Pen Blue (Pack of 10)","RM",1,5]
[2,"    +- 3004 Desk Accessories Kit","SUB",1,5]
[3,"        +- 1008 Barcode Labels Roll","RM",2,10]
[3,"        +- 1012 Tape Roll","RM",1,5]
[1,"  3002 Cleaning Set","SUB",1,5]
[2,"    +- 1009 Cleaning Spray 500ml","RM",1,5]
[2,"    +- 1010 Microfiber Cloth","RM",2,10]
[2,"    +- 3005 Labeling Kit","SUB",1,5]
[3,"        +- 1007 Packing Box Medium","RM",1,5]
[3,"        +- 1011 Bubble Wrap Roll","RM",1,5]
[3,"        +- 1012 Tape Roll","RM",1,5]
[]
[0,"2004 Laptop Setup Bundle","FG",null,1]
[1,"  1001 USB Cable 1m","RM",5,5]
[]
[0,"2002 Work From Home Bundle","FG",null,3]

{"sheet":"Item Master","index":3,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["SKU#","Description","Type","Missing BOM?"]
[2001,"Office Starter Kit","FG",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[2002,"Work From Home Bundle","FG",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":"Yes"}]
[2003,"Cleaning Kit Standard","FG",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[2004,"Laptop Setup Bundle","FG",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[2005,"Packaging Kit Small","FG",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":"Yes"}]
[3001,"Writing Set","SUB",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[3002,"Cleaning Set","SUB",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[3003,"Packaging Set Medium","SUB",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[3004,"Desk Accessories Kit","SUB",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[3005,"Labeling Kit","SUB",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1001,"USB Cable 1m","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1002,"Wireless Mouse","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1003,"Mechanical Keyboard","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1004,"Laptop Stand","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1005,"Notebook A5","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1006,"Pen Blue (Pack of 10)","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1007,"Packing Box Medium","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1008,"Barcode Labels Roll","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1009,"Cleaning Spray 500ml","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1010,"Microfiber Cloth","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1011,"Bubble Wrap Roll","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]
[1012,"Tape Roll","RM",{"$f":"IF(AND(ISERROR(MATCH(tblItems[[#This Row],[SKU'#]],'BOM Structure'!B:B,0)),OR(tblItems[[#This Row],[Type]]=\"SUB\",tblItems[[#This Row],[Type]]=\"FG\")),\"Yes\",\"\")","v":""}]

{"sheet":"BOM Builder","index":4,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
["Parent SKU","Parent Type","Parent Description","Base Qty"]
[2002,{"$f":"IF(LEN(A3)=0,\"\",_xlfn.XLOOKUP(A3,tblItems[SKU'#],tblItems[Type],\"\",0,))","v":"FG"},{"$f":"IF(LEN(A3)=0,\"\",_xlfn.XLOOKUP(A3,tblItems[SKU'#],tblItems[Description],\"\",0,))","v":"Work From Home Bundle"},1]
[]
["Component SKU","Component Description","Component Type","Quantity","Missing BOM?"]
[3001,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":"Writing Set"},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":"SUB"},5,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[3002,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":"Cleaning Set"},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":"SUB"},10,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[1002,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":"Wireless Mouse"},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":"RM"},1,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]
[null,{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Description],\"\",0,))","v":""},{"$f":"IF(LEN(tblItems4[[#This Row],[Component SKU]])=0,\"\",_xlfn.XLOOKUP(tblItems4[[#This Row],[Component SKU]],tblItems[SKU'#],tblItems[Type],\"\",0,))","v":""},null,{"$f":"IF(tblItems4[[#This Row],[Component Type]]=\"SUB\",\n    IF(COUNTIFS('BOM Structure'!B:B,tblItems4[[#This Row],[Component SKU]])=0,\n        \"Missing BOM!\",\n        \"\"\n    ),\n\"\")","v":""}]

{"sheet":"Setup","index":5,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Key","Value",null,"Home",null,null,"Type",null,"FG Items",null,"FG and SUB",null,"Sub and RM"]
["Version","Paid",null,"KPIs",null,null,"FG",null,{"$f":"_xlfn._xlws.FILTER(tblItems[SKU'#],tblItems[Type]=\"FG\")","v":2001},null,{"$f":"_xlfn.VSTACK(_xlfn._xlws.FILTER(tblItems[SKU'#],tblItems[Type]=\"FG\"),_xlfn._xlws.FILTER(tblItems[SKU'#],tblItems[Type]=\"SUB\"))","v":2001},null,{"$f":"_xlfn.VSTACK(_xlfn._xlws.FILTER(tblItems[SKU'#],tblItems[Type]=\"RM\"),_xlfn._xlws.FILTER(tblItems[SKU'#],tblItems[Type]=\"SUB\"))","v":1001}]
["Mode","Auto",null,"Total BOMs",{"$f":"IF(D8=1,0,COUNTA(_xlfn.UNIQUE(_xlfn._xlws.FILTER('BOM Structure'!B2:B99000,'BOM Structure'!B2:B99000<>\"\"))))","v":8},null,"RM",null,2002,null,2002,null,1002]
["In/Out","Inbound",null,"Missing BOMS",{"$f":"IF(D8=1,0,COUNTIFS(tblItems[Missing BOM?],\"Yes\"))","v":2},null,"SUB",null,2003,null,2003,null,1003]
["MaxItems",10,null,"Total Items",{"$f":"IF(D8=1,0,COUNTA(I:I)+COUNTA(M:M)-2)","v":22},null,null,null,2004,null,2004,null,1004]
["MaxBOM",6,null,null,null,null,null,null,2005,null,2005,null,1005]
["ScanCount",0,null,"#of Rows in Bom structure",null,null,null,null,null,null,3001,null,1006]
["LastScanTime","(optional)",null,{"$f":"COUNTA('BOM Structure'!A:A)","v":20},null,null,null,null,null,null,3002,null,1007]
[null,null,null,null,null,null,null,null,null,null,3003,null,1008]
[null,null,null,null,null,null,null,null,null,null,3004,null,1009]
[null,null,null,null,null,null,null,null,null,null,3005,null,1010]
[null,null,null,null,null,null,null,null,null,null,null,null,1011]
[null,null,null,null,null,null,null,null,null,null,null,null,1012]
[null,null,null,null,null,null,null,null,null,null,null,null,3001]
[null,null,null,null,null,null,null,null,null,null,null,null,3002]
[null,null,null,null,null,null,null,null,null,null,null,null,3003]
[null,null,null,null,null,null,null,null,null,null,null,null,3004]
[null,null,null,null,null,null,null,null,null,null,null,null,3005]

{"sheet":"BOM Structure","index":6,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Timestamp","Parent SKU","Parent Description","Component SKU","Component Description","Component Type","Quantity"]
["2026-04-20T20:34:05",2001,"Office Starter Kit",3001,"Writing Set","SUB",1]
["2026-04-20T20:34:05",2001,"Office Starter Kit",3002,"Cleaning Set","SUB",1]
["2026-04-20T20:34:05",2004,"Laptop Setup Bundle",1001,"USB Cable 1m","RM",5]
["2026-04-20T20:34:05",2003,"Cleaning Kit Pro",3002,"Cleaning Set","SUB",2]
["2026-04-20T20:34:05",2003,"Cleaning Kit Pro",1009,"Cleaning Spray 500ml","RM",1]
["2026-04-20T20:34:05",3001,"Writing Set",1005,"Notebook A5","RM",1]
["2026-04-20T20:34:05",3001,"Writing Set",1006,"Pen Blue (Pack of 10)","RM",1]
["2026-04-20T20:34:05",3001,"Writing Set",3004,"Labeling Kit","SUB",1]
["2026-04-20T20:34:05",3002,"Cleaning Set",1009,"Cleaning Spray 500ml","RM",1]
["2026-04-20T20:34:05",3002,"Cleaning Set",1010,"Microfiber Cloth","RM",2]
["2026-04-20T20:34:05",3002,"Cleaning Set",3005,"Packaging Set Small","SUB",1]
["2026-04-20T20:34:05",3003,"Desk Accessories Kit",1004,"Laptop Stand","RM",1]
["2026-04-20T20:34:05",3003,"Desk Accessories Kit",1002,"Wireless Mouse","RM",1]
["2026-04-20T20:34:05",3003,"Desk Accessories Kit",3004,"Labeling Kit","SUB",2]
["2026-04-20T20:34:05",3004,"Labeling Kit",1008,"Barcode Labels Roll","RM",2]
["2026-04-20T20:34:05",3004,"Labeling Kit",1012,"Tape Roll","RM",1]
["2026-04-20T20:34:05",3005,"Packaging Set Small",1007,"Packing Box Medium","RM",1]
["2026-04-20T20:34:05",3005,"Packaging Set Small",1011,"Bubble Wrap Roll","RM",1]
["2026-04-20T20:34:05",3005,"Packaging Set Small",1012,"Tape Roll","RM",1]