{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["시작","1","2","2-1","3","4","수고하셨습니다"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":0,"defined_names":35,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1","index":1,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"MID(CELL(\"filename\",C1),FIND(\"]\",CELL(\"filename\",C1))+1,255)&\" 페이지\"","v":"1 페이지"}]
[]
[]
[]
[null,null,"WHY? 🡢 "]
[]
[null,null,null,"선입선출은 '박스당 관리'를 기본 원칙으로 하고 있기 때문에"]
[null,null,null,"VBA (또는 외부 프로그램의 도움없이) 박스당 관리를 사람이 직접 한다는 것은 현실적으로 불가능합니다."]
[null,null,null,"(P.s…) 실무에서는 다양한 외부요인으로 인하여 선입선출 되지 않는 상황이 100% 발생하므로"]
[null,null,null,"매뉴얼로 관리해줘야 하는 상황이 무조건 발생합니다.. "]
[]
[null,null,"BUT…"]
[]
[null,null,null,"VBA 또는 외부프로그램을 사용할 상황이 되지 않는 경우, 엑셀 내부기능만으로 관리할 수 있는 선에서 타협을 본다면"]
[null,null,null,"아래 수준으로 선입선출 재고 관리가 가능합니다."]
[null,null,null,"Ⅰ. 판매된 재고 원가를 '건by건' 이 아닌 '월 또는 특정 기간 단위'로 끊어서 관리해도 괜찮을 경우"]
[null,null,null,"Ⅱ. 매뉴얼로 관리해줘야되는 Special Case는 별도의 표로 관리 괜찮을 경우"]
[]
[null,null,"재고관리 - 관리 수준 예제"]
[null,null,null,"모든 업무가 그렇듯이.. 관리수준이 높아 질수록 🡢"]
[null,null,null,"1. 관리해야 할 데이터의 양은 ^n (제곱)으로 많아집니다."]
[null,null,null,"2. (실무자 입장에서) 처리해야 할 업무 또한 배로 증가합니다"]
[null,null,null,"3. 문제 발생시 역순으로 원인을 해결하기 용이합니다. (e.g. 스커트 염색에 문제가 생겼다는 고객 문의가 들어왔을 경우.. 제품 S/N : SKIRT002-04, 만약 제품이 의료제품이라면..?)"]
[null,null,null,"4. 비용과 효용을 고려하여 적절한 관리수준을 채용"]

{"sheet":"2","index":2,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"MID(CELL(\"filename\",C1),FIND(\"]\",CELL(\"filename\",C1))+1,255)&\" 페이지\"","v":"2 페이지"}]
[null,null,"[입고수량]",null,null,null,null,null,"[출고수량]"]
[null,null,"박스ID","입고일","주문번호","제품명","수량",null,"박스ID","입고일","주문번호","제품명","수량",null,"주문이 들어왔습니다."]
[null,null,"BOX001","2020-01-01","A192001","스커트",50,null,null,null,null,null,null,null,"스커트 250개 + 청치마 400개"]
[null,null,"BOX002","2020-01-01","A192001","청치마",70]
[null,null,"BOX003","2020-01-01","A192002","스커트",100]
[null,null,"BOX004","2020-01-01","A192002","청치마",100]
[null,null,"BOX005","2020-01-02","A192003","스커트",200]
[null,null,"BOX006","2020-01-02","A192003","청치마",200]
[null,null,"BOX007","2020-01-02","A192003","면바지",200]
[null,null,"BOX008","2020-01-02","A192004","겨울점퍼",200]
[null,null,"BOX009","2020-01-02","A192004","청바지",200]
[null,null,"BOX010","2020-01-03","A192005","청치마",200]
[null,null,"BOX011","2020-01-03","A192005","스커트",200]
[null,null,"BOX012","2020-01-03","A192005","면바지",200]

{"sheet":"2-1","index":3,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"MID(CELL(\"filename\",D1),FIND(\"]\",CELL(\"filename\",D1))+1,255)&\" 페이지\"","v":"2-1 페이지"}]
[]
[null,null,null,"2020-01-01",null,"2020-01-01",null,"2020-01-02",null,"2020-01-02",null,"2020-01-04",null,"2020-01-05"]
[null,null,null,50,null,100,null,50,null,100,null,50,null,100]
[]
[null,"총 판매수량","현재 박스수량",{"$f":"D4","v":50},null,{"$f":"F4","v":100},null,{"$f":"H4","v":50},null,{"$f":"J4","v":100},null,{"$f":"L4","v":50},null,{"$f":"N4","v":100}]
[null,101]
[]
[null,null,"총 판매수량",{"$f":"$B$7","v":101},null,{"$f":"$B$7","v":101},null,{"$f":"$B$7","v":101},null,{"$f":"$B$7","v":101},null,{"$f":"$B$7","v":101},null,{"$f":"$B$7","v":101}]
[null,null,"- 이전 입고수량",{"$f":"SUM($C$4:C4)","v":0},null,{"$f":"SUM($C$4:E4)","v":50},null,{"$f":"SUM($C$4:G4)","v":150},null,{"$f":"SUM($C$4:I4)","v":200},null,{"$f":"SUM($C$4:K4)","v":300},null,{"$f":"SUM($C$4:M4)","v":350}]
[null,null,null,{"$f":"IF(D9-D10<0,0,D9-D10)","v":101},null,{"$f":"IF(F9-F10<0,0,F9-F10)","v":51},null,{"$f":"IF(H9-H10<0,0,H9-H10)","v":0},null,{"$f":"IF(J9-J10<0,0,J9-J10)","v":0},null,{"$f":"IF(L9-L10<0,0,L9-L10)","v":0},null,{"$f":"IF(N9-N10<0,0,N9-N10)","v":0}]
[]
[]
[null,"출고 수량은 🡢","둘중 작은 값",{"$f":"MIN(D6,D11)","v":50},null,{"$f":"MIN(F6,F11)","v":51},null,0,null,0,null,0,null,0]
[]
[null,"기말재고 수량은 🡢","입고-출고수량",{"$f":"D6-D14","v":0},null,{"$f":"F6-F14","v":49},null,50,null,100,null,50,null,100]

{"sheet":"3","index":4,"n_rows":16,"n_cols":33,"rows_kept":16,"cut":false,"hidden":false,"merged":[[5,16,5,17],[5,22,5,23],[5,28,5,29]]}
[null,null,{"$f":"MID(CELL(\"filename\",C1),FIND(\"]\",CELL(\"filename\",C1))+1,255)&\" 페이지\"","v":"3 페이지"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.oppadu.com/vlookup-함수-여러개-값-출력/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=INDEX($출력범위, SMALL(IF(($찾을값=$찾을범위),MATCH(ROW($찾을범위), ROW($찾을범위)), \"\"), ROWS($A$1:A1)), COLUMNS($A$1:A1))"]
[null,"구매내역",null,null,null,null,null,"판매내역",null,null,"출고내역",null,null,null,null,null,"기말재고",null,null,null,null,null,"기말재고_필터",null,null,null,null,null,"기말재고_필터"]
[]
[null,"Box","입고일","단가","수량","금액",null,"판매일","수량",null,"Box","입고일","단가","수량","금액",null,"Box","입고일","단가","수량","금액",null,"Box","입고일","단가","수량","금액",null,"Box","입고일","단가","수량","금액"]
[null,null,null,{"$f":"F6/E6","v":0},{"$f":"SUM(E8:E1048576)","v":1400},{"$f":"SUM(F8:F1048576)","v":0},null,"-",{"$f":"SUM(I8:I1048576)","v":100},null,null,null,null,{"$f":"SUM(N8:N1048576)","v":0},{"$f":"SUM(O8:O1048576)","v":0},null,null,null,{"$f":"U6/T6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(T8:T1048576)","v":0},{"$f":"SUM(U8:U1048576)","v":0},null,null,null,{"$f":"AA6/Z6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Z8:Z1048576)","v":0},{"$f":"SUM(AA8:AA1048576)","v":0},null,null,null,{"$f":"AG6/AF6","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AF8:AF1048576)","v":0},{"$f":"SUM(AG8:AG1048576)","v":0}]
[]
[null,1,"2020-01-01",3700,100,null,null,"2020-01-01",100]
[null,2,"2020-01-02",5700,200]
[null,3,"2020-01-03",3900,100]
[null,4,"2020-01-07",8100,50]
[null,5,"2020-01-10",5500,300]
[null,6,"2020-01-15",3650,200]
[null,7,"2020-01-17",7500,100]
[null,8,"2020-01-19",3900,300]
[null,9,"2020-01-23",7300,50]

{"sheet":"4","index":5,"n_rows":32,"n_cols":39,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,26,5,28],[5,19,5,21],[5,1,5,3],[5,33,5,35]]}
[null,null,{"$f":"MID(CELL(\"filename\",C1),FIND(\"]\",CELL(\"filename\",C1))+1,255)&\" 페이지\"","v":"4 페이지"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.oppadu.com/vlookup-함수-여러개-값-출력/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=INDEX($출력범위, SMALL(IF(($찾을값=$찾을범위),MATCH(ROW($찾을범위), ROW($찾을범위)), \"\"), ROWS($A$1:A1)), COLUMNS($A$1:A1))"]
[null,"구매내역",null,null,null,null,null,null,"판매내역",null,null,null,"출고내역",null,null,null,null,null,null,"기말재고",null,null,null,null,null,null,"기말재고_필터",null,null,null,null,null,null,"기말재고_필터"]
[]
[null,"Box","입고일","제품명","단가","수량","금액",null,"판매일","제품명","수량",null,"Box","입고일","제품명","단가","수량","금액",null,"Box","입고일","제품명","단가","수량","금액",null,"Box","입고일","제품명","단가","수량","금액",null,"Box","입고일","제품명","단가","수량","금액"]
[null,null,null,null,{"$f":"G6/F6","v":4978.5714285714284},{"$f":"SUM(F8:F1048576)","v":1400},{"$f":"SUM(G8:G1048576)","v":6970000},null,"-","-",{"$f":"SUM(K8:K1048576)","v":200},null,null,null,null,null,{"$f":"SUM(Q8:Q1048576)","v":200},{"$f":"SUM(R8:R1048576)","v":940000},null,null,null,null,{"$f":"Y6/X6","v":5025},{"$f":"SUM(X8:X1048576)","v":1200},{"$f":"SUM(Y8:Y1048576)","v":6030000},null,null,null,null,{"$f":"AF6/AE6","v":5025},{"$f":"SUM(AE8:AE1048576)","v":1200},{"$f":"SUM(AF8:AF1048576)","v":6030000},null,null,null,null,{"$f":"AM6/AL6","v":5025},{"$f":"SUM(AL8:AL1048576)","v":1200},{"$f":"SUM(AM8:AM1048576)","v":6030000}]
[]
[null,1,"2020-01-01","선풍기",3700,100,{"$f":"F8*E8","v":370000},null,"2020-01-01","선풍기",100,null,{"$f":"B8","v":1},{"$f":"C8","v":"2020-01-01"},{"$f":"D8","v":"선풍기"},{"$f":"E8","v":3700},{"$f":"MIN(F8,IF(SUMIF(J:J,O8,K:K)-SUMIFS(F:F,D:D,O8,C:C,\"<\"&N8)-SUMIFS($Q$7:Q7,$O$7:O7,O8,$N$7:N7,N8)<0,0,SUMIF(J:J,O8,K:K)-SUMIFS(F:F,D:D,O8,C:C,\"<\"&N8)-SUMIFS($Q$7:Q7,$O$7:O7,O8,$N$7:N7,N8)))","v":100},{"$f":"Q8*P8","v":370000},null,{"$f":"B8","v":1},{"$f":"C8","v":"2020-01-01"},{"$f":"D8","v":"선풍기"},{"$f":"E8","v":3700},{"$f":"F8-Q8","v":0},{"$f":"X8*W8","v":0},null,{"$f":"_xlfn._xlws.FILTER(T8:Y23,X8:X23>0)","v":2},"2020-01-03","USB",5700,100,570000,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A1)), COLUMNS($A$1:A1)),\"\")","v":2},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B1)), COLUMNS($A$1:B1)),\"\")","v":"2020-01-03"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C1)), COLUMNS($A$1:C1)),\"\")","v":"USB"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D1)), COLUMNS($A$1:D1)),\"\")","v":5700},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E1)), COLUMNS($A$1:E1)),\"\")","v":100},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F1)), COLUMNS($A$1:F1)),\"\")","v":570000}]
[null,2,"2020-01-03","USB",5700,200,{"$f":"F9*E9","v":1140000},null,"2020-01-03","USB",100,null,2,{"$f":"C9","v":"2020-01-03"},{"$f":"D9","v":"USB"},{"$f":"E9","v":5700},{"$f":"MIN(F9,IF(SUMIF(J:J,O9,K:K)-SUMIFS(F:F,D:D,O9,C:C,\"<\"&N9)-SUMIFS($Q$7:Q8,$O$7:O8,O9,$N$7:N8,N9)<0,0,SUMIF(J:J,O9,K:K)-SUMIFS(F:F,D:D,O9,C:C,\"<\"&N9)-SUMIFS($Q$7:Q8,$O$7:O8,O9,$N$7:N8,N9)))","v":100},{"$f":"Q9*P9","v":570000},null,{"$f":"B9","v":2},{"$f":"C9","v":"2020-01-03"},"USB",5700,100,{"$f":"X9*W9","v":570000},null,3,"2020-01-05","노트북",3900,100,390000,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A2)), COLUMNS($A$1:A2)),\"\")","v":3},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B2)), COLUMNS($A$1:B2)),\"\")","v":"2020-01-05"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C2)), COLUMNS($A$1:C2)),\"\")","v":"노트북"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D2)), COLUMNS($A$1:D2)),\"\")","v":3900},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E2)), COLUMNS($A$1:E2)),\"\")","v":100},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F2)), COLUMNS($A$1:F2)),\"\")","v":390000}]
[null,3,"2020-01-05","노트북",3900,100,390000,null,null,null,null,null,3,"2020-01-05","노트북",3900,{"$f":"MIN(F10,IF(SUMIF(J:J,O10,K:K)-SUMIFS(F:F,D:D,O10,C:C,\"<\"&N10)-SUMIFS($Q$7:Q9,$O$7:O9,O10,$N$7:N9,N10)<0,0,SUMIF(J:J,O10,K:K)-SUMIFS(F:F,D:D,O10,C:C,\"<\"&N10)-SUMIFS($Q$7:Q9,$O$7:O9,O10,$N$7:N9,N10)))","v":0},0,null,3,"2020-01-05","노트북",3900,100,390000,null,4,"2020-01-07","USB",8100,50,405000,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A3)), COLUMNS($A$1:A3)),\"\")","v":4},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B3)), COLUMNS($A$1:B3)),\"\")","v":"2020-01-07"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C3)), COLUMNS($A$1:C3)),\"\")","v":"USB"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D3)), COLUMNS($A$1:D3)),\"\")","v":8100},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E3)), COLUMNS($A$1:E3)),\"\")","v":50},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F3)), COLUMNS($A$1:F3)),\"\")","v":405000}]
[null,4,"2020-01-07","USB",8100,50,405000,null,null,null,null,null,4,"2020-01-07","USB",8100,{"$f":"MIN(F11,IF(SUMIF(J:J,O11,K:K)-SUMIFS(F:F,D:D,O11,C:C,\"<\"&N11)-SUMIFS($Q$7:Q10,$O$7:O10,O11,$N$7:N10,N11)<0,0,SUMIF(J:J,O11,K:K)-SUMIFS(F:F,D:D,O11,C:C,\"<\"&N11)-SUMIFS($Q$7:Q10,$O$7:O10,O11,$N$7:N10,N11)))","v":0},0,null,4,"2020-01-07","USB",8100,50,405000,null,5,"2020-01-10","선풍기",5500,300,1650000,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A4)), COLUMNS($A$1:A4)),\"\")","v":5},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B4)), COLUMNS($A$1:B4)),\"\")","v":"2020-01-10"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C4)), COLUMNS($A$1:C4)),\"\")","v":"선풍기"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D4)), COLUMNS($A$1:D4)),\"\")","v":5500},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E4)), COLUMNS($A$1:E4)),\"\")","v":300},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F4)), COLUMNS($A$1:F4)),\"\")","v":1650000}]
[null,5,"2020-01-10","선풍기",5500,300,1650000,null,null,null,null,null,5,"2020-01-10","선풍기",5500,{"$f":"MIN(F12,IF(SUMIF(J:J,O12,K:K)-SUMIFS(F:F,D:D,O12,C:C,\"<\"&N12)-SUMIFS($Q$7:Q11,$O$7:O11,O12,$N$7:N11,N12)<0,0,SUMIF(J:J,O12,K:K)-SUMIFS(F:F,D:D,O12,C:C,\"<\"&N12)-SUMIFS($Q$7:Q11,$O$7:O11,O12,$N$7:N11,N12)))","v":0},0,null,5,"2020-01-10","선풍기",5500,300,1650000,null,6,"2020-01-15","키보드",3650,200,730000,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A5)), COLUMNS($A$1:A5)),\"\")","v":6},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B5)), COLUMNS($A$1:B5)),\"\")","v":"2020-01-15"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C5)), COLUMNS($A$1:C5)),\"\")","v":"키보드"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D5)), COLUMNS($A$1:D5)),\"\")","v":3650},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E5)), COLUMNS($A$1:E5)),\"\")","v":200},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F5)), COLUMNS($A$1:F5)),\"\")","v":730000}]
[null,6,"2020-01-15","키보드",3650,200,730000,null,null,null,null,null,6,"2020-01-15","키보드",3650,{"$f":"MIN(F13,IF(SUMIF(J:J,O13,K:K)-SUMIFS(F:F,D:D,O13,C:C,\"<\"&N13)-SUMIFS($Q$7:Q12,$O$7:O12,O13,$N$7:N12,N13)<0,0,SUMIF(J:J,O13,K:K)-SUMIFS(F:F,D:D,O13,C:C,\"<\"&N13)-SUMIFS($Q$7:Q12,$O$7:O12,O13,$N$7:N12,N13)))","v":0},0,null,6,"2020-01-15","키보드",3650,200,730000,null,7,"2020-01-17","마우스",7500,100,750000,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A6)), COLUMNS($A$1:A6)),\"\")","v":7},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B6)), COLUMNS($A$1:B6)),\"\")","v":"2020-01-17"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C6)), COLUMNS($A$1:C6)),\"\")","v":"마우스"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D6)), COLUMNS($A$1:D6)),\"\")","v":7500},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E6)), COLUMNS($A$1:E6)),\"\")","v":100},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F6)), COLUMNS($A$1:F6)),\"\")","v":750000}]
[null,7,"2020-01-17","마우스",7500,100,750000,null,null,null,null,null,7,"2020-01-17","마우스",7500,{"$f":"MIN(F14,IF(SUMIF(J:J,O14,K:K)-SUMIFS(F:F,D:D,O14,C:C,\"<\"&N14)-SUMIFS($Q$7:Q13,$O$7:O13,O14,$N$7:N13,N14)<0,0,SUMIF(J:J,O14,K:K)-SUMIFS(F:F,D:D,O14,C:C,\"<\"&N14)-SUMIFS($Q$7:Q13,$O$7:O13,O14,$N$7:N13,N14)))","v":0},0,null,7,"2020-01-17","마우스",7500,100,750000,null,8,"2020-01-19","USB",3900,300,1170000,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A7)), COLUMNS($A$1:A7)),\"\")","v":8},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B7)), COLUMNS($A$1:B7)),\"\")","v":"2020-01-19"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C7)), COLUMNS($A$1:C7)),\"\")","v":"USB"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D7)), COLUMNS($A$1:D7)),\"\")","v":3900},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E7)), COLUMNS($A$1:E7)),\"\")","v":300},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F7)), COLUMNS($A$1:F7)),\"\")","v":1170000}]
[null,8,"2020-01-19","USB",3900,300,1170000,null,null,null,null,null,8,"2020-01-19","USB",3900,{"$f":"MIN(F15,IF(SUMIF(J:J,O15,K:K)-SUMIFS(F:F,D:D,O15,C:C,\"<\"&N15)-SUMIFS($Q$7:Q14,$O$7:O14,O15,$N$7:N14,N15)<0,0,SUMIF(J:J,O15,K:K)-SUMIFS(F:F,D:D,O15,C:C,\"<\"&N15)-SUMIFS($Q$7:Q14,$O$7:O14,O15,$N$7:N14,N15)))","v":0},0,null,8,"2020-01-19","USB",3900,300,1170000,null,9,"2020-01-23","선풍기",7300,50,365000,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A8)), COLUMNS($A$1:A8)),\"\")","v":9},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B8)), COLUMNS($A$1:B8)),\"\")","v":"2020-01-23"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C8)), COLUMNS($A$1:C8)),\"\")","v":"선풍기"},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D8)), COLUMNS($A$1:D8)),\"\")","v":7300},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E8)), COLUMNS($A$1:E8)),\"\")","v":50},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F8)), COLUMNS($A$1:F8)),\"\")","v":365000}]
[null,9,"2020-01-23","선풍기",7300,50,365000,null,null,null,null,null,9,"2020-01-23","선풍기",7300,{"$f":"MIN(F16,IF(SUMIF(J:J,O16,K:K)-SUMIFS(F:F,D:D,O16,C:C,\"<\"&N16)-SUMIFS($Q$7:Q15,$O$7:O15,O16,$N$7:N15,N16)<0,0,SUMIF(J:J,O16,K:K)-SUMIFS(F:F,D:D,O16,C:C,\"<\"&N16)-SUMIFS($Q$7:Q15,$O$7:O15,O16,$N$7:N15,N16)))","v":0},0,null,9,"2020-01-23","선풍기",7300,50,365000,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A9)), COLUMNS($A$1:A9)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B9)), COLUMNS($A$1:B9)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C9)), COLUMNS($A$1:C9)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D9)), COLUMNS($A$1:D9)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E9)), COLUMNS($A$1:E9)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F9)), COLUMNS($A$1:F9)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A10)), COLUMNS($A$1:A10)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B10)), COLUMNS($A$1:B10)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C10)), COLUMNS($A$1:C10)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D10)), COLUMNS($A$1:D10)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E10)), COLUMNS($A$1:E10)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F10)), COLUMNS($A$1:F10)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A11)), COLUMNS($A$1:A11)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B11)), COLUMNS($A$1:B11)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C11)), COLUMNS($A$1:C11)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D11)), COLUMNS($A$1:D11)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E11)), COLUMNS($A$1:E11)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F11)), COLUMNS($A$1:F11)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A12)), COLUMNS($A$1:A12)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B12)), COLUMNS($A$1:B12)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C12)), COLUMNS($A$1:C12)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D12)), COLUMNS($A$1:D12)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E12)), COLUMNS($A$1:E12)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F12)), COLUMNS($A$1:F12)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A13)), COLUMNS($A$1:A13)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B13)), COLUMNS($A$1:B13)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C13)), COLUMNS($A$1:C13)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D13)), COLUMNS($A$1:D13)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E13)), COLUMNS($A$1:E13)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F13)), COLUMNS($A$1:F13)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A14)), COLUMNS($A$1:A14)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B14)), COLUMNS($A$1:B14)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C14)), COLUMNS($A$1:C14)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D14)), COLUMNS($A$1:D14)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E14)), COLUMNS($A$1:E14)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F14)), COLUMNS($A$1:F14)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A15)), COLUMNS($A$1:A15)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B15)), COLUMNS($A$1:B15)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C15)), COLUMNS($A$1:C15)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D15)), COLUMNS($A$1:D15)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E15)), COLUMNS($A$1:E15)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F15)), COLUMNS($A$1:F15)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A16)), COLUMNS($A$1:A16)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B16)), COLUMNS($A$1:B16)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C16)), COLUMNS($A$1:C16)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D16)), COLUMNS($A$1:D16)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E16)), COLUMNS($A$1:E16)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F16)), COLUMNS($A$1:F16)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A17)), COLUMNS($A$1:A17)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B17)), COLUMNS($A$1:B17)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C17)), COLUMNS($A$1:C17)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D17)), COLUMNS($A$1:D17)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E17)), COLUMNS($A$1:E17)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F17)), COLUMNS($A$1:F17)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A18)), COLUMNS($A$1:A18)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B18)), COLUMNS($A$1:B18)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C18)), COLUMNS($A$1:C18)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D18)), COLUMNS($A$1:D18)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E18)), COLUMNS($A$1:E18)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F18)), COLUMNS($A$1:F18)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A19)), COLUMNS($A$1:A19)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B19)), COLUMNS($A$1:B19)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C19)), COLUMNS($A$1:C19)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D19)), COLUMNS($A$1:D19)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E19)), COLUMNS($A$1:E19)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F19)), COLUMNS($A$1:F19)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A20)), COLUMNS($A$1:A20)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B20)), COLUMNS($A$1:B20)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C20)), COLUMNS($A$1:C20)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D20)), COLUMNS($A$1:D20)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E20)), COLUMNS($A$1:E20)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F20)), COLUMNS($A$1:F20)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A21)), COLUMNS($A$1:A21)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B21)), COLUMNS($A$1:B21)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C21)), COLUMNS($A$1:C21)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D21)), COLUMNS($A$1:D21)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E21)), COLUMNS($A$1:E21)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F21)), COLUMNS($A$1:F21)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A22)), COLUMNS($A$1:A22)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B22)), COLUMNS($A$1:B22)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C22)), COLUMNS($A$1:C22)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D22)), COLUMNS($A$1:D22)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E22)), COLUMNS($A$1:E22)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F22)), COLUMNS($A$1:F22)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A23)), COLUMNS($A$1:A23)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B23)), COLUMNS($A$1:B23)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C23)), COLUMNS($A$1:C23)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D23)), COLUMNS($A$1:D23)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E23)), COLUMNS($A$1:E23)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F23)), COLUMNS($A$1:F23)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A24)), COLUMNS($A$1:A24)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B24)), COLUMNS($A$1:B24)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C24)), COLUMNS($A$1:C24)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D24)), COLUMNS($A$1:D24)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E24)), COLUMNS($A$1:E24)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F24)), COLUMNS($A$1:F24)),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:A25)), COLUMNS($A$1:A25)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:B25)), COLUMNS($A$1:B25)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:C25)), COLUMNS($A$1:C25)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:D25)), COLUMNS($A$1:D25)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:E25)), COLUMNS($A$1:E25)),\"\")","v":""},{"$f":"IFERROR(INDEX($T$8:$Y$32, SMALL(IF(($X$8:$X$32>0),MATCH(ROW($T$8:$Y$32), ROW($T$8:$Y$32)), \"\"), ROWS($A$1:F25)), COLUMNS($A$1:F25)),\"\")","v":""}]

{"sheet":"수고하셨습니다","index":6,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]