{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["재고 목록","창고 발주서","BIN 목록"],"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":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"재고 목록"]
[null,"총 재고 금액","재고 항목 개수","BIN 개수","INVENTORY PICK LIST","BIN LOOKUP"]
[null,{"$f":"SUM(InventoryList[재고가격])","v":2787},{"$f":"COUNTA(InventoryList[제품명])","v":7},{"$f":"SUMPRODUCT((1/COUNTIF(InventoryList[BIN 번호],InventoryList[BIN 번호]&\"\")))","v":5}]
[null,"재고번호(SKU)","제품명","BIN 번호","BIN 위치","단위","수량","발주수량","단가","재고가격","주문여부","출고후수량"]
[null,"IP11XS","아이폰 11 XS","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN 번호]],BinLookup[],3,FALSE),\"\")","v":"2열, 슬롯 1"},"Each",15,{"$f":"SUMIF('창고 발주서'!C:C,InventoryList[[#This Row],[재고번호(SKU)]],'창고 발주서'!D:D)","v":5},30,{"$f":"InventoryList[[#This Row],[수량]]*InventoryList[[#This Row],[단가]]","v":450},{"$f":"IFERROR(IF(InventoryList[[#This Row],[수량]]<=InventoryList[[#This Row],[발주수량]],1,0),0)","v":0},{"$f":"InventoryList[[#This Row],[수량]]-InventoryList[[#This Row],[발주수량]]","v":10}]
[null,"GLS10","갤럭시 S10","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN 번호]],BinLookup[],3,FALSE),\"\")","v":"2열, 슬롯 1"},"Each",25,{"$f":"SUMIF('창고 발주서'!C:C,InventoryList[[#This Row],[재고번호(SKU)]],'창고 발주서'!D:D)","v":5},40,{"$f":"InventoryList[[#This Row],[수량]]*InventoryList[[#This Row],[단가]]","v":1000},{"$f":"IFERROR(IF(InventoryList[[#This Row],[수량]]<=InventoryList[[#This Row],[발주수량]],1,0),0)","v":0},{"$f":"InventoryList[[#This Row],[수량]]-InventoryList[[#This Row],[발주수량]]","v":20}]
[null,"GLS11","갤럭시 S11","T5789",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN 번호]],BinLookup[],3,FALSE),\"\")","v":"1열, 슬롯 1"},"Each",10,{"$f":"SUMIF('창고 발주서'!C:C,InventoryList[[#This Row],[재고번호(SKU)]],'창고 발주서'!D:D)","v":0},5,{"$f":"InventoryList[[#This Row],[수량]]*InventoryList[[#This Row],[단가]]","v":50},{"$f":"IFERROR(IF(InventoryList[[#This Row],[수량]]<=InventoryList[[#This Row],[발주수량]],1,0),0)","v":0},{"$f":"InventoryList[[#This Row],[수량]]-InventoryList[[#This Row],[발주수량]]","v":10}]
[null,"GSN10","갤럭시 노트 10","T9876",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN 번호]],BinLookup[],3,FALSE),\"\")","v":"3열, 슬롯 2"},"Box (10 ct)",35,{"$f":"SUMIF('창고 발주서'!C:C,InventoryList[[#This Row],[재고번호(SKU)]],'창고 발주서'!D:D)","v":5},15,{"$f":"InventoryList[[#This Row],[수량]]*InventoryList[[#This Row],[단가]]","v":525},{"$f":"IFERROR(IF(InventoryList[[#This Row],[수량]]<=InventoryList[[#This Row],[발주수량]],1,0),0)","v":0},{"$f":"InventoryList[[#This Row],[수량]]-InventoryList[[#This Row],[발주수량]]","v":30}]
[null,"IP11SE","아이폰 10 SE","T098",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN 번호]],BinLookup[],3,FALSE),\"\")","v":"3열, 슬롯 1"},"Each",12,{"$f":"SUMIF('창고 발주서'!C:C,InventoryList[[#This Row],[재고번호(SKU)]],'창고 발주서'!D:D)","v":0},26,{"$f":"InventoryList[[#This Row],[수량]]*InventoryList[[#This Row],[단가]]","v":312},{"$f":"IFERROR(IF(InventoryList[[#This Row],[수량]]<=InventoryList[[#This Row],[발주수량]],1,0),0)","v":0},{"$f":"InventoryList[[#This Row],[수량]]-InventoryList[[#This Row],[발주수량]]","v":12}]
[null,"GLSFLD","갤럭시 폴드","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN 번호]],BinLookup[],3,FALSE),\"\")","v":"2열, 슬롯 1"},"Each",7,{"$f":"SUMIF('창고 발주서'!C:C,InventoryList[[#This Row],[재고번호(SKU)]],'창고 발주서'!D:D)","v":0},50,{"$f":"InventoryList[[#This Row],[수량]]*InventoryList[[#This Row],[단가]]","v":350},{"$f":"IFERROR(IF(InventoryList[[#This Row],[수량]]<=InventoryList[[#This Row],[발주수량]],1,0),0)","v":0},{"$f":"InventoryList[[#This Row],[수량]]-InventoryList[[#This Row],[발주수량]]","v":7}]
[null,"MACPRO","맥북프로 10","T349",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN 번호]],BinLookup[],3,FALSE),\"\")","v":"1열, 슬롯1"},"Each",10,{"$f":"SUMIF('창고 발주서'!C:C,InventoryList[[#This Row],[재고번호(SKU)]],'창고 발주서'!D:D)","v":0},10,{"$f":"InventoryList[[#This Row],[수량]]*InventoryList[[#This Row],[단가]]","v":100},{"$f":"IFERROR(IF(InventoryList[[#This Row],[수량]]<=InventoryList[[#This Row],[발주수량]],1,0),0)","v":0},{"$f":"InventoryList[[#This Row],[수량]]-InventoryList[[#This Row],[발주수량]]","v":10}]

{"sheet":"창고 발주서","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"발주서"]
[null,null,"INVENTORY LIST"]
[]
[null,"주문번호","SKU(제품번호)","요청수량","가용수량","제품명","단위","BIN 번호","BIN 위치"]
[null,"주문번호1","IP11XS",5,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],6,FALSE),\"\")","v":15},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],2,FALSE),\"\")","v":"아이폰 11 XS"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],5,FALSE),\"\")","v":"Each"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],3,FALSE),\"\")","v":"T345"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],4,FALSE),\"\")","v":"2열, 슬롯 1"}]
[null,"주문번호1","GLS10",5,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],6,FALSE),\"\")","v":25},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],2,FALSE),\"\")","v":"갤럭시 S10"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],5,FALSE),\"\")","v":"Each"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],3,FALSE),\"\")","v":"T345"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],4,FALSE),\"\")","v":"2열, 슬롯 1"}]
[null,"주문번호1","GSN10",5,{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],6,FALSE),\"\")","v":35},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],2,FALSE),\"\")","v":"갤럭시 노트 10"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],5,FALSE),\"\")","v":"Box (10 ct)"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],3,FALSE),\"\")","v":"T9876"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[SKU(제품번호)],InventoryList[],4,FALSE),\"\")","v":"3열, 슬롯 2"}]

{"sheet":"BIN 목록","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"BIN 목록"]
[null,"INVENTORY LIST"]
[]
[null,"BIN 번호","BIN 크기 구분","위치","가로","세로","높이"]
[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열, 슬롯1",25,5,5]
[null,"T5789","대형","4열, 슬롯 5",50,10,10]
[null,"T9875","대형","2열, 슬롯 2",50,10,10]