{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["기본작업-1","기본작업-2","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2"],"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":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["품목","날짜","단가","수량","문구점"]
["연필","2017-03-03",1200,89,"화진아트"]
["크레파스","2017-07-21",5000,86,"화진아트"]
["크레파스","2017-03-22",5000,83,"모닝아트"]
["크레파스","2017-01-13",5000,77,"모닝아트"]
["크레파스","2017-01-08",5000,62,"모닝아트"]

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

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

{"sheet":"분석작업-1","index":3,"n_rows":31,"n_cols":15,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["날짜","문구점","품목코드","품목","단가","수량"]
["2017-01-01","화진아트","C653","연필",1200,46]
["2017-01-08","모닝아트","D381","크레파스",5000,62,null,null,null,"날짜","값"]
["2017-01-13","모닝아트","D381","크레파스",5000,77,null,null,null,"1사분기",null,"2사분기",null,"3사분기"]
["2017-01-19","새싹문구","C653","연필",1200,57,null,"문구점","품목","합계 : 단가","합계 : 수량","합계 : 단가","합계 : 수량","합계 : 단가","합계 : 수량"]
["2017-01-21","모닝아트","E782","리코더",15000,72,null,"남경문구",null,30000,164,20000,35,15000,51]
["2017-02-01","신화상사","Z837","종합장",1000,92,null,null,"리코더",30000,164,15000,24,15000,51]
["2017-02-03","남경문구","E782","리코더",15000,96,null,null,"크레파스","***","***",5000,11,"***","***"]
["2017-02-22","모닝아트","D381","크레파스",5000,42,null,"모닝아트",null,65000,461,30000,179,15000,92]
["2017-02-28","신화상사","D381","크레파스",5000,29,null,null,"리코더",45000,197,30000,179,15000,92]
["2017-03-03","화진아트","C653","연필",1200,89,null,null,"크레파스",20000,264,"***","***","***","***"]
["2017-03-06","모닝아트","E782","리코더",15000,94,null,"새싹문구",null,1200,57,1000,99,"***","***"]
["2017-03-17","남경문구","E782","리코더",15000,68,null,null,"연필",1200,57,"***","***","***","***"]
["2017-03-22","모닝아트","D381","크레파스",5000,83,null,null,"종합장","***","***",1000,99,"***","***"]
["2017-03-26","모닝아트","E782","리코더",15000,31,null,"신화상사",null,7000,178,8200,248,6000,51]
["2017-03-31","신화상사","Z837","종합장",1000,57,null,null,"연필","***","***",1200,99,"***","***"]
["2017-04-06","남경문구","D381","크레파스",5000,11,null,null,"종합장",2000,149,2000,95,1000,29]
["2017-04-19","신화상사","Z837","종합장",1000,57,null,null,"크레파스",5000,29,5000,54,5000,22]
["2017-04-27","신화상사","D381","크레파스",5000,54,null,"화진아트",null,2400,135,1200,16,5000,86]
["2017-05-01","신화상사","C653","연필",1200,99,null,null,"연필",2400,135,1200,16,"***","***"]
["2017-05-12","모닝아트","E782","리코더",15000,99,null,null,"크레파스","***","***","***","***",5000,86]
["2017-05-24","신화상사","Z837","종합장",1000,38,null,"총합계",null,105600,995,60400,577,41000,280]
["2017-06-03","새싹문구","Z837","종합장",1000,99]
["2017-06-09","남경문구","E782","리코더",15000,24]
["2017-06-17","화진아트","C653","연필",1200,16]
["2017-06-25","모닝아트","E782","리코더",15000,80]
["2017-07-01","남경문구","E782","리코더",15000,51]
["2017-07-11","신화상사","D381","크레파스",5000,22]
["2017-07-21","화진아트","D381","크레파스",5000,86]
["2017-07-31","신화상사","Z837","종합장",1000,29]
["2017-08-06","모닝아트","E782","리코더",15000,92]

{"sheet":"분석작업-2","index":4,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"날짜","문구점","품목코드","품목","단가","수량"]
[null,"2016-07-01","남경문구","E782","리코더",15000,51]
[null,"2017-02-03","남경문구","E782","리코더",15000,96]
[null,"2016-05-01","남경문구","C653","연필",1200,99]
[null,null,"남경문구 요약",null,null,{"$f":"SUBTOTAL(9,F3:F5)","v":31200},{"$f":"SUBTOTAL(9,G3:G5)","v":246}]
[null,"2016-09-26","모닝아트","E782","리코더",15000,31]
[null,"2016-01-08","모닝아트","D381","크레파스",5000,62]
[null,"2017-01-13","모닝아트","D381","크레파스",5000,77]
[null,"2016-06-25","모닝아트","E782","리코더",15000,80]
[null,"2017-03-22","모닝아트","D381","크레파스",5000,83]
[null,"2017-08-06","모닝아트","E782","리코더",15000,92]
[null,"2017-12-06","모닝아트","E782","리코더",15000,94]
[null,"2016-05-12","모닝아트","E782","리코더",15000,99]
[null,null,"모닝아트 요약",null,null,{"$f":"SUBTOTAL(9,F7:F14)","v":90000},{"$f":"SUBTOTAL(9,G7:G14)","v":618}]
[null,"2016-06-09","신화상사","E782","리코더",15000,24]
[null,"2016-06-28","신화상사","D381","크레파스",5000,29]
[null,"2017-05-24","신화상사","Z837","종합장",1000,38]
[null,"2017-04-27","신화상사","D381","크레파스",5000,54]
[null,"2016-11-19","신화상사","Z837","종합장",1000,57]
[null,"2016-02-01","신화상사","Z837","종합장",1000,92]
[null,null,"신화상사 요약",null,null,{"$f":"SUBTOTAL(9,F16:F21)","v":28000},{"$f":"SUBTOTAL(9,G16:G21)","v":294}]
[null,"2016-06-17","화진아트","C653","연필",1200,16]
[null,"2016-01-01","화진아트","C653","연필",1200,46]
[null,"2016-10-21","화진아트","E782","리코더",15000,72]
[null,"2016-03-03","화진아트","C653","연필",1200,89]
[null,null,"화진아트 요약",null,null,{"$f":"SUBTOTAL(9,F23:F26)","v":18600},{"$f":"SUBTOTAL(9,G23:G26)","v":223}]
[null,null,"총합계",null,null,{"$f":"SUBTOTAL(9,F3:F26)","v":167800},{"$f":"SUBTOTAL(9,G3:G26)","v":1381}]

{"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":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["날짜","문구점","품목","단가","수량","판매금액"]
["2019-11-11","모닝아트","연필",1200,5,6000]
["2020-04-18","새싹문구"]
[]
[]
[]
[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]