{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Bin Lookup","Inventory List","Inventory Pick List"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"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":"Bin Lookup","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"BIN LOOKUP"]
[]
[null,"BIN #","DESCRIPTION","LOCATION","WIDTH","HEIGHT","LENGTH"]
[null,"T345","Large bin","Row 2, slot 1",50,10,10]
[null,"T5789","Small bin","Row 1, slot 1",25,5,5]
[null,"T9876","Large bin","Row 3, slot 2",50,10,10]
[null,"T098","Medium bin","Row 3, slot 1",30,7,10]
[null,"T349","Small bin","Row 1, slot 2",25,5,5]
[null,"T5786","Large bin","Row 4, slot 5",50,10,10]
[null,"T9875","Large bin","Row 2, slot 2",50,10,10]

{"sheet":"Inventory List","index":1,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"INVENTORY LIST"]
[null,"TOTAL INVENTORY VALUE:","INVENTORY ITEMS:","BIN COUNT:","INVENTORY PICK LIST","BIN LOOKUP"]
[null,{"$f":"SUM(InventoryList[INVENTORY VALUE])","v":4649},{"$f":"COUNTA(InventoryList[DESCRIPTION])","v":11},{"$f":"SUMPRODUCT((1/COUNTIF(InventoryList[BIN '#],InventoryList[BIN '#]&\"\")))","v":7}]
[null,"SKU","DESCRIPTION","BIN #","LOCATION","UNIT","AVAILABLE QTY","REORDER QTY","COST","INVENTORY VALUE","REORDER"]
[null,"SP7875","Item 1","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 2, slot 1"},"Each",20,10,30,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":600},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"TR87680","Item 2","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 2, slot 1"},"Each",30,15,40,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":1200},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"MK676554","Item 3","T5789",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 1"},"Each",10,5,5,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":50},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"YE98767","Item 4","T9876",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 3, slot 2"},"Box (10 ct)",40,10,15,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":600},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"XR23423","Item 5","T098",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 3, slot 1"},"Each",12,10,26,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":312},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"PW98762","Item 6","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 2, slot 1"},"Each",7,10,50,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":350},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":1}]
[null,"BM87684","Item 7","T349",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 2"},"Each",10,5,10,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":100},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"BH67655","Item 8","T5789",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 1"},"Each",19,10,3,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":57},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"WT98768","Item 9","T9875",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 2, slot 2"},"Package (5 ct)",20,30,14,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":280},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":1}]
[null,"TS3456","Item 10","T5786",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 4, slot 5"},"Each",15,8,60,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":900},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"WDG123","Item 11","T349",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 2"},"Each",25,15,8,{"$f":"InventoryList[[#This Row],[AVAILABLE QTY]]*InventoryList[[#This Row],[COST]]","v":200},{"$f":"IFERROR(IF(InventoryList[[#This Row],[AVAILABLE QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]

{"sheet":"Inventory Pick List","index":2,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"INVENTORY PICK LIST"]
[]
[null,"ORDER #","SKU","PICK QTY","QTY AVAILABLE","ITEM DESCRIPTION","UNIT","BIN #","LOCATION"]
[null,"TP001-1","XR23423",3,{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],4,FALSE),\"\")","v":""}]
[null,"TP001-1","YE98767",1,{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],4,FALSE),\"\")","v":""}]
[null,"TP001-1","BM87684",2,{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],4,FALSE),\"\")","v":""}]
[null,"TP001-1","TS3456",6,{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],4,FALSE),\"\")","v":""}]
[null,"TP001-1","MK676554",3,{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],6,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],5,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],3,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP([1]!InventoryPickList[SKU],[1]!InventoryList[#Data],4,FALSE),\"\")","v":""}]