{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2","기타작업-3"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"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":"기본작업-1","index":0,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,"날짜","문구점","품목코드","품목","단가","수량"]
[null,"2020-01-01","화진아트","C653","연필",1200,46]
[null,"2020-01-08","모닝아트","D381","크레파스",5000,62]
[null,"2020-01-13","모닝아트","D381","크레파스",5000,77]
[null,"2020-01-19","새싹문구","C653","연필",1200,57]
[null,"2020-01-21","모닝아트","E782","리코더",15000,72]
[null,"2020-02-01","신화상사","Z837","종합장",1000,92]
[null,"2020-02-03","남경문구","E782","리코더",15000,96]
[null,"2020-02-22","모닝아트","D381","크레파스",5000,42]
[null,"2020-02-28","신화상사","D381","크레파스",5000,29]
[null,"2020-03-03","화진아트","C653","연필",1200,89]
[null,"2020-03-06","모닝아트","E782","리코더",15000,94]
[null,"2020-03-17","남경문구","E782","리코더",15000,68]
[null,"2020-03-22","모닝아트","D381","크레파스",5000,83]
[null,"2020-03-26","모닝아트","E782","리코더",15000,31]
[null,"2020-03-31","신화상사","Z837","종합장",1000,57]
[null,"2020-04-06","남경문구","D381","크레파스",5000,11]
[null,"2020-04-19","신화상사","Z837","종합장",1000,57]
[null,"2020-04-27","신화상사","D381","크레파스",5000,54]
[null,"2020-05-01","신화상사","C653","연필",1200,99]
[null,"2020-05-12","모닝아트","E782","리코더",15000,99]
[null,"2020-05-24","신화상사","Z837","종합장",1000,38]
[null,"2020-06-03","새싹문구","Z837","종합장",1000,99]
[null,"2020-06-09","남경문구","E782","리코더",15000,24]
[null,"2020-06-17","화진아트","C653","연필",1200,16]
[null,"2020-06-25","모닝아트","E782","리코더",15000,80]
[null,"2020-07-01","남경문구","E782","리코더",15000,51]
[null,"2020-07-11","신화상사","D381","크레파스",5000,22]
[null,"2020-07-21","화진아트","D381","크레파스",5000,86]
[null,"2020-07-31","신화상사","Z837","종합장",1000,29]
[null,"2020-08-06","모닝아트","E782","리코더",15000,92]
[]
[null,"조건1"]
[null,{"$f":"AND(FIND(\"화\",C3)>=1,OR(MONTH(B3)=5,MONTH(B3)=7))","v":false}]
[]
[null,"날짜","문구점","품목코드","품목","단가","수량"]
[null,"2020-05-01","신화상사","C653","연필",1200,99]
[null,"2020-05-24","신화상사","Z837","종합장",1000,38]
[null,"2020-07-11","신화상사","D381","크레파스",5000,22]
[null,"2020-07-21","화진아트","D381","크레파스",5000,86]
[null,"2020-07-31","신화상사","Z837","종합장",1000,29]

{"sheet":"기본작업-2","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"날짜","문구점","품목코드","품목","단가","수량","판매금액"]
[null,"2019-03-17","남경문구","E782","리코더",15000,68,918000]
[null,"2019-07-01","남경문구","E782","리코더",15000,51,688500]
[null,"2020-02-03","남경문구","E782","리코더",15000,96,1224000]
[null,"2019-05-12","모닝아트","E782","리코더",15000,99,1262250]
[null,"2019-06-25","모닝아트","E782","리코더",15000,80,1020000]
[null,"2019-09-26","모닝아트","E782","리코더",15000,31,432450]
[null,"2020-08-06","모닝아트","E782","리코더",15000,92,1173000]
[null,"2020-12-06","모닝아트","E782","리코더",15000,94,1198500]
[null,"2019-06-09","신화상사","E782","리코더",15000,24,334800]
[null,"2019-10-21","화진아트","E782","리코더",15000,72,918000]
[null,"2019-05-01","남경문구","C653","연필",1200,99,109296]
[null,"2019-01-19","새싹문구","C653","연필",1200,57,65664]
[null,"2019-01-01","화진아트","C653","연필",1200,46,54096]
[null,"2019-03-03","화진아트","C653","연필",1200,89,98256]
[null,"2019-06-17","화진아트","C653","연필",1200,16,19200]
[null,"2019-06-03","새싹문구","Z837","종합장",1000,100,93000]
[null,"2019-02-01","신화상사","Z837","종합장",1000,92,84640]
[null,"2019-03-31","신화상사","Z837","종합장",1000,57,54720]
[null,"2019-07-31","신화상사","Z837","종합장",1000,29,28420]
[null,"2019-11-19","신화상사","Z837","종합장",1000,57,54720]
[null,"2020-05-24","신화상사","Z837","종합장",1000,38,37240]
[null,"2019-04-06","남경문구","D381","크레파스",5000,11,53900]
[null,"2019-01-08","모닝아트","D381","크레파스",5000,62,288300]
[null,"2019-09-22","모닝아트","D381","크레파스",5000,42,199500]
[null,"2020-01-13","모닝아트","D381","크레파스",5000,77,346500]
[null,"2020-03-22","모닝아트","D381","크레파스",5000,83,373500]
[null,"2019-06-28","신화상사","D381","크레파스",5000,29,137750]
[null,"2019-07-11","신화상사","D381","크레파스",5000,22,104500]
[null,"2020-04-27","신화상사","D381","크레파스",5000,54,251100]
[null,"2019-07-21","화진아트","D381","크레파스",5000,86,387000]

{"sheet":"계산작업","index":2,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[18,9,18,12],[19,9,19,12]]}
[]
["[표1]"]
["날짜","문구점","품목코드","품목","단가","수량","판매금액","비고",null,"[표2] 할인율"]
["2019-07-21","화진아트","D381","크레파스",5000,86,{"$f":"E4*F4*(1-VLOOKUP(D4,$J$4:$O$8,MATCH(F4,$K$4:$O$4,1)+1,0))","v":387000},{"$f":"fn비고(A4)","v":"2019-3사분기"},null,"수량",1,20,50,70,100]
["2019-07-31","신화상사","Z837","종합장",1000,29,{"$f":"E5*F5*(1-VLOOKUP(D5,$J$4:$O$8,MATCH(F5,$K$4:$O$4,1)+1,0))","v":28420},{"$f":"fn비고(A5)","v":"2019-3사분기"},null,"리코더",null,7.0000000000000007E-2,0.1,0.15,0.2]
["2020-05-24","신화상사","Z837","종합장",1000,38,37240,"2020-2사분기",null,"크레파스",0.02,0.05,7.0000000000000007E-2,0.1,0.15]
["2019-06-03","새싹문구","Z837","종합장",1000,100,93000,"2019-2사분기",null,"연필",0,0.02,0.04,0.08,0.1]
["2019-05-12","모닝아트","E782","리코더",15000,99,1262250,"2019-2사분기",null,"종합장",0,0.02,0.04,0.08,7.0000000000000007E-2]
["2020-12-06","모닝아트","E782","리코더",15000,94,1198500,"2020-4사분기"]
["2019-03-17","남경문구","E782","리코더",15000,68,918000,"2019-1사분기",null,"[표3]"]
["2020-03-22","모닝아트","D381","크레파스",5000,83,373500,"2020-1사분기",null,"문구점","연필","리코더","판매건수"]
["2019-09-26","모닝아트","E782","리코더",15000,31,432450,"2019-3사분기",null,"남경문구",{"$f":"IFERROR(AVERAGE(IF(($J12=$B$4:$B$33)*(K$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":99},{"$f":"IFERROR(AVERAGE(IF(($J12=$B$4:$B$33)*(L$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":71.666666666666671},{"$f":"TEXT(SUM(($J12=$B$4:$B$33)*1),\"0건\")","v":"5건"}]
["2019-01-01","화진아트","C653","연필",1200,46,54096,"2019-1사분기",null,"모닝아트",{"$f":"IFERROR(AVERAGE(IF(($J13=$B$4:$B$33)*(K$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":"판매수량없음"},{"$f":"IFERROR(AVERAGE(IF(($J13=$B$4:$B$33)*(L$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":79.2},{"$f":"TEXT(SUM(($J13=$B$4:$B$33)*1),\"0건\")","v":"9건"}]
["2019-06-28","신화상사","D381","크레파스",5000,29,137750,"2019-2사분기",null,"새싹문구",{"$f":"IFERROR(AVERAGE(IF(($J14=$B$4:$B$33)*(K$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":57},{"$f":"IFERROR(AVERAGE(IF(($J14=$B$4:$B$33)*(L$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":"판매수량없음"},{"$f":"TEXT(SUM(($J14=$B$4:$B$33)*1),\"0건\")","v":"2건"}]
["2019-03-31","신화상사","Z837","종합장",1000,57,54720,"2019-1사분기",null,"신화상사",{"$f":"IFERROR(AVERAGE(IF(($J15=$B$4:$B$33)*(K$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":"판매수량없음"},{"$f":"IFERROR(AVERAGE(IF(($J15=$B$4:$B$33)*(L$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":24},{"$f":"TEXT(SUM(($J15=$B$4:$B$33)*1),\"0건\")","v":"9건"}]
["2019-04-06","남경문구","D381","크레파스",5000,11,53900,"2019-2사분기",null,"화진아트",{"$f":"IFERROR(AVERAGE(IF(($J16=$B$4:$B$33)*(K$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":50.333333333333336},{"$f":"IFERROR(AVERAGE(IF(($J16=$B$4:$B$33)*(L$11=$D$4:$D$33),($F$4:$F$33))),\"판매수량없음\")","v":72},{"$f":"TEXT(SUM(($J16=$B$4:$B$33)*1),\"0건\")","v":"5건"}]
["2019-11-19","신화상사","Z837","종합장",1000,57,54720,"2019-4사분기"]
["2020-04-27","신화상사","D381","크레파스",5000,54,251099.99999999997,"2020-2사분기",null,"[표4]"]
["2019-05-01","남경문구","C653","연필",1200,99,109296,"2019-2사분기",null,"[표4] 수량이 가장 많은 품목과 문구점"]
["2019-03-03","화진아트","C653","연필",1200,89,98256,"2019-1사분기",null,{"$f":"INDEX($D$4:$D$33,MATCH(MAX($F$4:$F$33),$F$4:$F$33,0),1)&\"-\"&INDEX($B$4:$B$33,MATCH(MAX($F$4:$F$33),$F$4:$F$33,0),1)","v":"종합장-새싹문구"}]
["2019-01-08","모닝아트","D381","크레파스",5000,62,288300,"2019-1사분기"]
["2020-01-13","모닝아트","D381","크레파스",5000,77,346500,"2020-1사분기"]
["2019-01-19","새싹문구","C653","연필",1200,57,65664,"2019-1사분기"]
["2019-10-21","화진아트","E782","리코더",15000,72,918000,"2019-4사분기"]
["2019-02-01","신화상사","Z837","종합장",1000,92,84640,"2019-1사분기"]
["2020-02-03","남경문구","E782","리코더",15000,96,1224000,"2020-1사분기"]
["2019-09-22","모닝아트","D381","크레파스",5000,42,199500,"2019-3사분기"]
["2019-07-01","남경문구","E782","리코더",15000,51,688500,"2019-3사분기"]
["2019-07-11","신화상사","D381","크레파스",5000,22,104500,"2019-3사분기"]
["2019-06-09","신화상사","E782","리코더",15000,24,334800,"2019-2사분기"]
["2019-06-17","화진아트","C653","연필",1200,16,19200,"2019-2사분기"]
["2019-06-25","모닝아트","E782","리코더",15000,80,1020000,"2019-2사분기"]
["2020-08-06","모닝아트","E782","리코더",15000,92,1173000,"2020-3사분기"]

{"sheet":"분석작업-1","index":3,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"날짜","값"]
[null,null,null,"1사분기",null,"2사분기",null,"3사분기"]
[null,"문구점","품목","합계 : 단가","합계 : 수량","합계 : 단가","합계 : 수량","합계 : 단가","합계 : 수량"]
[null,"남경문구",null,30000,164,20000,35,15000,51]
[null,null,"리코더",30000,164,15000,24,15000,51]
[null,null,"크레파스","***","***",5000,11,"***","***"]
[null,"모닝아트",null,65000,461,30000,179,15000,92]
[null,null,"리코더",45000,197,30000,179,15000,92]
[null,null,"크레파스",20000,264,"***","***","***","***"]
[null,"새싹문구",null,1200,57,1000,99,"***","***"]
[null,null,"연필",1200,57,"***","***","***","***"]
[null,null,"종합장","***","***",1000,99,"***","***"]
[null,"신화상사",null,7000,178,8200,248,6000,51]
[null,null,"연필","***","***",1200,99,"***","***"]
[null,null,"종합장",2000,149,2000,95,1000,29]
[null,null,"크레파스",5000,29,5000,54,5000,22]
[null,"화진아트",null,2400,135,1200,16,5000,86]
[null,null,"연필",2400,135,1200,16,"***","***"]
[null,null,"크레파스","***","***","***","***",5000,86]
[null,"총합계",null,105600,995,60400,577,41000,280]

{"sheet":"분석작업-2","index":4,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"[표1]"]
[null,"날짜","문구점","품목코드","품목","단가","수량"]
[null,"2019-05-01","남경문구","C653","연필",1200,99]
[null,null,null,null,"연필 개수",{"$f":"SUBTOTAL(3,F3:F3)","v":1}]
[null,"2019-07-01","남경문구","E782","리코더",15000,51]
[null,"2020-02-03","남경문구","E782","리코더",15000,96]
[null,null,null,null,"리코더 개수",{"$f":"SUBTOTAL(3,F5:F6)","v":2}]
[null,null,"남경문구 개수",null,null,null,{"$f":"SUBTOTAL(3,G3:G6)","v":3}]
[null,"2019-01-08","모닝아트","D381","크레파스",5000,62]
[null,"2020-01-13","모닝아트","D381","크레파스",5000,77]
[null,"2020-03-22","모닝아트","D381","크레파스",5000,83]
[null,null,null,null,"크레파스 개수",{"$f":"SUBTOTAL(3,F9:F11)","v":3}]
[null,"2019-05-12","모닝아트","E782","리코더",15000,99]
[null,"2019-06-25","모닝아트","E782","리코더",15000,80]
[null,"2019-09-26","모닝아트","E782","리코더",15000,31]
[null,"2020-08-06","모닝아트","E782","리코더",15000,92]
[null,"2020-12-06","모닝아트","E782","리코더",15000,94]
[null,null,null,null,"리코더 개수",{"$f":"SUBTOTAL(3,F13:F17)","v":5}]
[null,null,"모닝아트 개수",null,null,null,{"$f":"SUBTOTAL(3,G9:G17)","v":8}]
[null,"2019-02-01","신화상사","Z837","종합장",1000,92]
[null,"2019-11-19","신화상사","Z837","종합장",1000,57]
[null,"2020-05-24","신화상사","Z837","종합장",1000,38]
[null,null,null,null,"종합장 개수",{"$f":"SUBTOTAL(3,F20:F22)","v":3}]
[null,"2019-06-28","신화상사","D381","크레파스",5000,29]
[null,"2020-04-27","신화상사","D381","크레파스",5000,54]
[null,null,null,null,"크레파스 개수",{"$f":"SUBTOTAL(3,F24:F25)","v":2}]
[null,"2019-06-09","신화상사","E782","리코더",15000,24]
[null,null,null,null,"리코더 개수",{"$f":"SUBTOTAL(3,F27:F27)","v":1}]
[null,null,"신화상사 개수",null,null,null,{"$f":"SUBTOTAL(3,G20:G27)","v":6}]
[null,"2019-01-01","화진아트","C653","연필",1200,46]
[null,"2019-03-03","화진아트","C653","연필",1200,89]
[null,"2019-06-17","화진아트","C653","연필",1200,16]
[null,null,null,null,"연필 개수",{"$f":"SUBTOTAL(3,F30:F32)","v":3}]
[null,"2019-10-21","화진아트","E782","리코더",15000,72]
[null,null,null,null,"리코더 개수",{"$f":"SUBTOTAL(3,F34:F34)","v":1}]
[null,null,"화진아트 개수",null,null,null,{"$f":"SUBTOTAL(3,G30:G34)","v":4}]
[]
[]
[null,null,"전체 개수",null,null,null,{"$f":"SUBTOTAL(3,G3:G38)","v":21}]
[null,null,null,null,"전체 개수",{"$f":"SUBTOTAL(3,F3:F39)","v":21}]

{"sheet":"기타작업-1","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["판매 현황"]
["품목","판매금액"]
["리코더",9169500]
["연필",34651200]
["종합장",35082000]
["크레파스",21420500]

{"sheet":"기타작업-2","index":6,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"[표1] 이사 대상 자료"]
[null,"부서","성명","나이","입사연도","희망여부","평가점수"]
[null,"영업","이찬진",54,2002,1,92]
[null,"개발","채경찬",60,1997,0,95]
[null,"영업","임종례",50,2007,1,93]
[null,"개발","정종수",59,1998,0,99]
[null,"영업","서현명",48,2009,1,98]
[null,"개발","고광섭",51,2006,1,94]
[null,"영업","김은조",54,2003,1,91]
[null,"개발","권창영",58,1999,0,96]
[null,"자재","김영민",61,1996,1,91]
[null,"개발","명노찬",52,2005,1,90]

{"sheet":"기타작업-3","index":7,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["날짜","문구점","품목","단가","수량","판매금액"]
["2023-11-11","모닝아트","연필",1200,5,6000]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"문구점","품목","단가"]
[null,null,null,null,null,null,null,"남경문구","리코더",15000]
[null,null,null,null,null,null,null,"모닝아트","연필",1200]
[null,null,null,null,null,null,null,"새싹문구","종합장",1000]
[null,null,null,null,null,null,null,"신화상사","크레파스",5000]