{"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":3,"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":"기본작업-1","index":0,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[null,"날짜","문구점","품목코드","품목","단가","수량"]
[null,43831,"화진아트","C653","연필",1200,46]
[null,43838,"모닝아트","D381","크레파스",5000,62]
[null,43843,"모닝아트","D381","크레파스",5000,77]
[null,43849,"새싹문구","C653","연필",1200,57]
[null,43851,"모닝아트","E782","리코더",15000,72]
[null,43862,"신화상사","Z837","종합장",1000,92]
[null,43864,"남경문구","E782","리코더",15000,96]
[null,43883,"모닝아트","D381","크레파스",5000,42]
[null,43889,"신화상사","D381","크레파스",5000,29]
[null,43893,"화진아트","C653","연필",1200,89]
[null,43896,"모닝아트","E782","리코더",15000,94]
[null,43907,"남경문구","E782","리코더",15000,68]
[null,43912,"모닝아트","D381","크레파스",5000,83]
[null,43916,"모닝아트","E782","리코더",15000,31]
[null,43921,"신화상사","Z837","종합장",1000,57]
[null,43927,"남경문구","D381","크레파스",5000,11]
[null,43940,"신화상사","Z837","종합장",1000,57]
[null,43948,"신화상사","D381","크레파스",5000,54]
[null,43952,"신화상사","C653","연필",1200,99]
[null,43963,"모닝아트","E782","리코더",15000,99]
[null,43975,"신화상사","Z837","종합장",1000,38]
[null,43985,"새싹문구","Z837","종합장",1000,99]
[null,43991,"남경문구","E782","리코더",15000,24]
[null,43999,"화진아트","C653","연필",1200,16]
[null,44007,"모닝아트","E782","리코더",15000,80]
[null,44013,"남경문구","E782","리코더",15000,51]
[null,44023,"신화상사","D381","크레파스",5000,22]
[null,44033,"화진아트","D381","크레파스",5000,86]
[null,44043,"신화상사","Z837","종합장",1000,29]
[null,44049,"모닝아트","E782","리코더",15000,92]
[]
[null,"조건"]
[null,{"$f":"AND(FIND(\"화\",C3)>=1,OR(MONTH(B3)=5,MONTH(B3)=7))","v":false}]
[]
[null,"날짜","문구점","품목코드","품목","단가","수량"]
[null,43838,"모닝아트","D381","크레파스",5000,62]
[null,43843,"모닝아트","D381","크레파스",5000,77]
[null,43849,"새싹문구","C653","연필",1200,57]
[null,43851,"모닝아트","E782","리코더",15000,72]
[null,43864,"남경문구","E782","리코더",15000,96]
[null,43883,"모닝아트","D381","크레파스",5000,42]
[null,43896,"모닝아트","E782","리코더",15000,94]
[null,43907,"남경문구","E782","리코더",15000,68]
[null,43912,"모닝아트","D381","크레파스",5000,83]
[null,43916,"모닝아트","E782","리코더",15000,31]
[null,43927,"남경문구","D381","크레파스",5000,11]
[null,43952,"신화상사","C653","연필",1200,99]
[null,43963,"모닝아트","E782","리코더",15000,99]
[null,43975,"신화상사","Z837","종합장",1000,38]
[null,43985,"새싹문구","Z837","종합장",1000,99]
[null,43991,"남경문구","E782","리코더",15000,24]
[null,44007,"모닝아트","E782","리코더",15000,80]
[null,44013,"남경문구","E782","리코더",15000,51]
[null,44023,"신화상사","D381","크레파스",5000,22]
[null,44033,"화진아트","D381","크레파스",5000,86]
[null,44043,"신화상사","Z837","종합장",1000,29]
[null,44049,"모닝아트","E782","리코더",15000,92]

{"sheet":"기본작업-2","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"날짜","문구점","품목코드","품목","단가","수량","판매금액"]
[null,43541,"남경문구","E782","리코더",15000,68,918000]
[null,43647,"남경문구","E782","리코더",15000,51,688500]
[null,43864,"남경문구","E782","리코더",15000,96,1224000]
[null,43597,"모닝아트","E782","리코더",15000,99,1262250]
[null,43641,"모닝아트","E782","리코더",15000,80,1020000]
[null,43734,"모닝아트","E782","리코더",15000,31,432450]
[null,44049,"모닝아트","E782","리코더",15000,92,1173000]
[null,44171,"모닝아트","E782","리코더",15000,94,1198500]
[null,43625,"신화상사","E782","리코더",15000,24,334800]
[null,43759,"화진아트","E782","리코더",15000,72,918000]
[null,43586,"남경문구","C653","연필",1200,99,109296]
[null,43484,"새싹문구","C653","연필",1200,57,65664]
[null,43466,"화진아트","C653","연필",1200,46,54096]
[null,43527,"화진아트","C653","연필",1200,89,98256]
[null,43633,"화진아트","C653","연필",1200,16,19200]
[null,43619,"새싹문구","Z837","종합장",1000,100,93000]
[null,43497,"신화상사","Z837","종합장",1000,92,84640]
[null,43555,"신화상사","Z837","종합장",1000,57,54720]
[null,43677,"신화상사","Z837","종합장",1000,29,28420]
[null,43788,"신화상사","Z837","종합장",1000,57,54720]
[null,43975,"신화상사","Z837","종합장",1000,38,37240]
[null,43561,"남경문구","D381","크레파스",5000,11,53900]
[null,43473,"모닝아트","D381","크레파스",5000,62,288300]
[null,43730,"모닝아트","D381","크레파스",5000,42,199500]
[null,43843,"모닝아트","D381","크레파스",5000,77,346500]
[null,43912,"모닝아트","D381","크레파스",5000,83,373500]
[null,43644,"신화상사","D381","크레파스",5000,29,137750]
[null,43657,"신화상사","D381","크레파스",5000,22,104500]
[null,43948,"신화상사","D381","크레파스",5000,54,251100]
[null,43667,"화진아트","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] 할인율"]
[43667,"화진아트","D381","크레파스",5000,86,null,null,null,"수량",1,20,50,70,100]
[43677,"신화상사","Z837","종합장",1000,29,null,null,null,"리코더",0.05,0.070000000000000007,0.10000000000000001,0.14999999999999999,0.20000000000000001]
[43975,"신화상사","Z837","종합장",1000,38,null,null,null,"크레파스",0.020000000000000001,0.05,0.070000000000000007,0.10000000000000001,0.14999999999999999]
[43619,"새싹문구","Z837","종합장",1000,100,null,null,null,"연필",0,0.020000000000000001,0.040000000000000002,0.080000000000000004,0.10000000000000001]
[43597,"모닝아트","E782","리코더",15000,99,null,null,null,"종합장",0,0.020000000000000001,0.040000000000000002,0.080000000000000004,0.070000000000000007]
[44171,"모닝아트","E782","리코더",15000,94]
[43541,"남경문구","E782","리코더",15000,68,null,null,null,"[표3]"]
[43912,"모닝아트","D381","크레파스",5000,83,null,null,null,"문구점","연필","리코더","판매건수"]
[43734,"모닝아트","E782","리코더",15000,31,null,null,null,"남경문구"]
[43466,"화진아트","C653","연필",1200,46,null,null,null,"모닝아트"]
[43644,"신화상사","D381","크레파스",5000,29,null,null,null,"새싹문구"]
[43555,"신화상사","Z837","종합장",1000,57,null,null,null,"신화상사"]
[43561,"남경문구","D381","크레파스",5000,11,null,null,null,"화진아트"]
[43788,"신화상사","Z837","종합장",1000,57]
[43948,"신화상사","D381","크레파스",5000,54,null,null,null,"[표4]"]
[43586,"남경문구","C653","연필",1200,99,null,null,null,"[표4] 수량이 가장 많은 품목과 문구점"]
[43527,"화진아트","C653","연필",1200,89]
[43473,"모닝아트","D381","크레파스",5000,62]
[43843,"모닝아트","D381","크레파스",5000,77]
[43484,"새싹문구","C653","연필",1200,57]
[43759,"화진아트","E782","리코더",15000,72]
[43497,"신화상사","Z837","종합장",1000,92]
[43864,"남경문구","E782","리코더",15000,96]
[43730,"모닝아트","D381","크레파스",5000,42]
[43647,"남경문구","E782","리코더",15000,51]
[43657,"신화상사","D381","크레파스",5000,22]
[43625,"신화상사","E782","리코더",15000,24]
[43633,"화진아트","C653","연필",1200,16]
[43641,"모닝아트","E782","리코더",15000,80]
[44049,"모닝아트","E782","리코더",15000,92]

{"sheet":"분석작업-1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"분석작업-2","index":4,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"[표1]"]
[null,"날짜","문구점","품목코드","품목","단가","수량"]
[null,43466,"화진아트","C653","연필",1200,46]
[null,43473,"모닝아트","D381","크레파스",5000,62]
[null,43497,"신화상사","Z837","종합장",1000,92]
[null,43527,"화진아트","C653","연필",1200,89]
[null,43586,"남경문구","C653","연필",1200,99]
[null,43597,"모닝아트","E782","리코더",15000,99]
[null,43625,"신화상사","E782","리코더",15000,24]
[null,43633,"화진아트","C653","연필",1200,16]
[null,43641,"모닝아트","E782","리코더",15000,80]
[null,43644,"신화상사","D381","크레파스",5000,29]
[null,43647,"남경문구","E782","리코더",15000,51]
[null,43734,"모닝아트","E782","리코더",15000,31]
[null,43759,"화진아트","E782","리코더",15000,72]
[null,43527,"화진아트","C653","연필",1200,89]
[null,43788,"신화상사","Z837","종합장",1000,57]
[null,43843,"모닝아트","D381","크레파스",5000,77]
[null,43864,"남경문구","E782","리코더",15000,96]
[null,43912,"모닝아트","D381","크레파스",5000,83]
[null,44049,"모닝아트","E782","리코더",15000,92]
[null,43948,"신화상사","D381","크레파스",5000,54]
[null,43644,"신화상사","D381","크레파스",5000,29]
[null,43975,"신화상사","Z837","종합장",1000,38]
[null,44171,"모닝아트","E782","리코더",15000,94]

{"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":[]}
["[표1]"]
["날짜","문구점","품목","단가","수량","판매금액"]
[45241,"모닝아트","연필",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]