{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["仓库库存清单","库存选取列表","箱查找"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"仓库库存清单","index":0,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"仓库库存清单"]
[null,"库存总值:","库存项目:","箱数:","库存选取列表","箱查找"]
[null,{"$f":"SUM(库存清单[库存价值])","v":4649},{"$f":"COUNTA(库存清单[描述])","v":11},{"$f":"SUMPRODUCT((1/COUNTIF(库存清单[箱号],库存清单[箱号]&\"\")))","v":6}]
[null,"SKU","描述","箱号","位置","单位","数量","续订数量","成本","库存价值","续订"]
[null,"SP7875","项目 1","T345",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 2 行，第 1 格"},"每个",20,10,30,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":600},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]
[null,"TR87680","项目​​ 2","T345",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 2 行，第 1 格"},"每个",30,15,40,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":1200},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]
[null,"MK676554","项目​​ 3","T5789",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 1 行，第 1 格"},"每个",10,5,5,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":50},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]
[null,"YE98767","项目 4","T9876",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 3 行，第 2 格"},"箱（10 盒）",40,10,15,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":600},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]
[null,"XR23423","项目​​ 5","T098",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 3 行，第 1 格"},"每个",12,10,26,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":312},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]
[null,"PW98762","项目 6","T345",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 2 行，第 1 格"},"每个",7,10,50,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":350},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":1}]
[null,"BM87684","项目 7","T349",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 1 行，第 2 格"},"每个",10,5,10,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":100},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]
[null,"BH67655","项目 8","T5789",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 1 行，第 1 格"},"每个",19,10,3,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":57},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]
[null,"WT98768","项目 9","T9875",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 2 行，第 2 格"},"包（5 盒）",20,30,14,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":280},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":1}]
[null,"TS3456","项目 10","T349",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 1 行，第 2 格"},"每个",15,8,60,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":900},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]
[null,"WDG123","项目 11","T349",{"$f":"IFERROR(VLOOKUP(库存清单[[#This Row],[箱号]],箱查找[],3,FALSE),\"\")","v":"第 1 行，第 2 格"},"每个",25,15,8,{"$f":"库存清单[[#This Row],[数量]]*库存清单[[#This Row],[成本]]","v":200},{"$f":"IFERROR(IF(库存清单[[#This Row],[数量]]<=库存清单[[#This Row],[续订数量]],1,0),0)","v":0}]

{"sheet":"库存选取列表","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"库存选取列表"]
[null,null,"库存清单"]
[]
[null,"订单编号","SKU","选取数量","可用数量","项目描述","单位","箱号","位置"]
[null,"TP001-1","SP7875",3,{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],6,FALSE),\"\")","v":20},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],2,FALSE),\"\")","v":"项目 1"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],5,FALSE),\"\")","v":"每个"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],3,FALSE),\"\")","v":"T345"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],4,FALSE),\"\")","v":"第 2 行，第 1 格"}]
[null,"TP001-1","YE98767",1,{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],6,FALSE),\"\")","v":40},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],2,FALSE),\"\")","v":"项目 4"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],5,FALSE),\"\")","v":"箱（10 盒）"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],3,FALSE),\"\")","v":"T9876"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],4,FALSE),\"\")","v":"第 3 行，第 2 格"}]
[null,"TP001-1","BM87684",2,{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],2,FALSE),\"\")","v":"项目 7"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],5,FALSE),\"\")","v":"每个"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],4,FALSE),\"\")","v":"第 1 行，第 2 格"}]
[null,"TP001-1","TS3456",6,{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],6,FALSE),\"\")","v":15},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],2,FALSE),\"\")","v":"项目 10"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],5,FALSE),\"\")","v":"每个"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],4,FALSE),\"\")","v":"第 1 行，第 2 格"}]
[null,"TP001-1","MK676554",3,{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],2,FALSE),\"\")","v":"项目​​ 3"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],5,FALSE),\"\")","v":"每个"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],3,FALSE),\"\")","v":"T5789"},{"$f":"IFERROR(VLOOKUP(库存选取列表[SKU],库存清单[],4,FALSE),\"\")","v":"第 1 行，第 1 格"}]

{"sheet":"箱查找","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[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]