{"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"},"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"},"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"},"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"},"상자(10ct)",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"},"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"},"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"},"1개",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"},"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"},"패키지(5ct)",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"},"1개",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"},"1개",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":"1개"},{"$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":"상자(10ct)"},{"$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":"1개"},{"$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":"1개"},{"$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":"1개"},{"$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]