{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["庫存清單","庫存檢料清單","箱子查詢"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"庫存清單","index":0,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"倉庫庫存清單"]
[null,"總庫存價值：",null,"箱子計數：",null,"庫存項目："]
[null,{"$f":"SUM(InventoryTable[庫存價值])","v":139470},null,{"$f":"SUMPRODUCT((1/COUNTIF(InventoryTable[箱子編號],InventoryTable[箱子編號]&\"\")))","v":6},null,{"$f":"COUNTA(InventoryTable[描述])","v":11}]
[]
[null,"SKU","描述","箱子編號","位置","單位","數量","追加訂購數量","成本","庫存價值","追加訂購"]
[null,"SP7875","項目 1","T345",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 2 列，第 1 個插槽"},"單件",20,10,900,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":18000},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]
[null,"TR87680","項目 2","T345",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 2 列，第 1 個插槽"},"單件",30,15,1200,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":36000},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]
[null,"MK676554","項目 3","T5789",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 1 列，第 1 個插槽"},"單件",10,5,150,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":1500},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]
[null,"YE98767","項目 4","T9876",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 3 列，第 2 個插槽"},"箱 (10 件裝)",40,10,450,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":18000},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]
[null,"XR23423","項目 5","T098",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 3 列，第 1 個插槽"},"單件",12,10,780,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":9360},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]
[null,"PW98762","項目 6","T345",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 2 列，第 1 個插槽"},"單件",7,10,1500,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":10500},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":1}]
[null,"BM87684","項目 7","T349",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 1 列，第 2 個插槽"},"單件",10,5,300,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":3000},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]
[null,"BH67655","項目 8","T5789",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 1 列，第 1 個插槽"},"單件",19,10,90,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":1710},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]
[null,"WT98768","項目 9","T9875",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 2 列，第 2 個插槽"},"包 (5 件裝)",20,30,420,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":8400},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":1}]
[null,"TS3456","項目 10","T349",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 1 列，第 2 個插槽"},"單件",15,8,1800,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":27000},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]
[null,"WDG123","項目 11","T349",{"$f":"IFERROR(VLOOKUP(InventoryTable[[#This Row],[箱子編號]],BinLookupTable[],3,FALSE),\"\")","v":"第 1 列，第 2 個插槽"},"單件",25,15,240,{"$f":"InventoryTable[[#This Row],[數量]]*InventoryTable[[#This Row],[成本]]","v":6000},{"$f":"IF(InventoryTable[[#This Row],[數量]]<=InventoryTable[[#This Row],[追加訂購數量]],1,0)","v":0}]

{"sheet":"庫存檢料清單","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"庫存撿料清單"]
[]
[null,"訂單編號","SKU","撿料數量","可用的數量","項目說明","單位","箱子編號","位置"]
[null,"TP001-1","SP7875",3,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":20},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"項目 1"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"單件"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T345"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"第 2 列，第 1 個插槽"}]
[null,"TP001-1","YE98767",1,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":40},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"項目 4"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"箱 (10 件裝)"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T9876"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"第 3 列，第 2 個插槽"}]
[null,"TP001-1","BM87684",2,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"項目 7"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"單件"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"第 1 列，第 2 個插槽"}]
[null,"TP001-1","TS3456",6,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":15},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"項目 10"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"單件"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"第 1 列，第 2 個插槽"}]
[null,"TP001-1","MK676554",3,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],2,FALSE),\"\")","v":"項目 3"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],5,FALSE),\"\")","v":"單件"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],3,FALSE),\"\")","v":"T5789"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU],InventoryTable[],4,FALSE),\"\")","v":"第 1 列，第 1 個插槽"}]

{"sheet":"箱子查詢","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[null,"箱子查詢"]
[]
[null,"此表格為庫存清單和庫存撿料清單工作表提供資料。"]
[null,"箱子編號","描述","位置","寬","高","長"]
[null,"T345","大型箱","第 2 列，第 1 個插槽",50,10,10]
[null,"T5789","小型箱","第 1 列，第 1 個插槽",25,5,5]
[null,"T9876","大型箱","第 3 列，第 2 個插槽",50,10,10]
[null,"T098","中型箱","第 3 列，第 1 個插槽",30,7,10]
[null,"T349","小型箱","第 1 列，第 2 個插槽",25,5,5]
[null,"T5789","大型箱","第 4 列，第 5 個插槽",50,10,10]
[null,"T9875","大型箱","第 2 列，第 2 個插槽",50,10,10]