{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2","기타작업-3"],"not_rendered":{"charts":1,"images":13,"macros":1,"external_links":1,"defined_names":1,"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":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["동","호수","납부일자","가족수","전기사용량","공동요금","전기요금","단위별공동요금","층수"]
["목련동",502,"2022-02-01",1,423,25000,183987.1,833,5]
["장미동",303,"2022-02-07",7,724,35000,495797.31999999995,700,3]
["국화동",403,"2022-02-20",2,222,40000,43313.8,800,4]
["목련동",503,"2022-02-12",2,438,25000,190252.6,500,5]
["장미동",503,"2022-02-13",3,171,35000,3049.723,700,5]
["목련동",603,"2022-02-25",6,741,25000,507135.12999999995,500,6]
["목련동",401,"2022-02-02",4,548,25000,382305.7,1250,4]
["목련동",301,"2022-02-03",6,154,25000,2817.136,1250,3]
["장미동",701,"2022-02-07",6,663,35000,455114.58999999997,1750,7]
["장미동",802,"2022-02-08",4,476,35000,196183.93999999997,1166,8]
["국화동",702,"2022-02-12",7,765,40000,523141.44999999995,1333,7]
["장미동",303,"2022-02-09",3,460,35000,189834.9,700,3]
["국화동",501,"2022-02-21",4,157,40000,2874.5410000000002,2000,5]
["목련동",402,"2022-02-25",2,203,25000,39743.700000000004,833,4]
["장미동",302,"2022-02-01",4,237,35000,44796.330999999998,1166,3]
["국화동",903,"2022-02-12",7,682,40000,467786.25999999995,800,9]
["목련동",901,"2022-02-16",3,457,25000,188644.45499999999,1250,9]
["장미동",103,"2022-02-23",5,134,35000,2569.4560000000001,700,1]
["국화동",203,"2022-02-21",6,588,40000,405094.83999999997,800,2]
["목련동",402,"2022-02-13",5,492,25000,200477.89599999998,833,4]
["장미동",502,"2022-02-19",2,520,35000,381880,1166,5]
["장미동",603,"2022-02-04",3,444,35000,183485.86,700,6]
["목련동",402,"2022-02-08",5,766,25000,523808.37999999995,833,4]
["목련동",902,"2022-02-07",2,660,25000,481210,833,9]
["장미동",501,"2022-02-15",5,157,35000,2854.2879999999996,1750,5]
["장미동",201,"2022-02-22",3,407,35000,168803.70499999999,1750,2]

{"sheet":"기본작업-2","index":1,"n_rows":90,"n_cols":10,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]"]
["접수일자","거래처코드","상호","행선지코드","행선지","차량종류","금액","세액","합계","출발일자"]
["2022-03-01","AA-01","대명금속  ","PT-1","평택","1톤",50000,5625,55000,"2022-03-01"]
["2022-03-01","BB-02","코암유통 ","WJ-1","원주","1톤",70000,7875,77000,"2022-03-01"]
["2022-03-01","BB-02","코암유통 ","IC-3","인천","3톤",85000,9562.5,93500,"2022-03-02"]
["2022-03-01","BB-04","텔슨통신기술","SW-1","수원","1톤",35000,3937.5,38500,"2022-03-02"]
["2022-03-01","BB-06","Y.C 인터네셔날  ","KR-3","강릉","3톤",150000,16875,165000,"2022-03-02"]
["2022-03-01","BB-08","계성제지","CA-5","천안","5톤",100000,11250,110000,"2022-03-02"]
["2022-03-01","CC-13","율촌화학","US-5","울산","5톤",220000,24750,242000,"2022-03-02"]
["2022-03-02","AA-07","정금강업  ","WJ-5","원주","5톤",120000,13500,132000,"2022-03-03"]
["2022-03-02","AA-10","진한통상  ","JJ-1","전주","1톤",120000,13500,132000,"2022-03-03"]
["2022-03-02","BB-06","Y.C 인터네셔날  ","PT-3","평택","3톤",80000,9000,88000,"2022-03-03"]
["2022-03-02","BB-10","삼성코닝","WJ-5","원주","5톤",120000,13500,132000,"2022-03-03"]
["2022-03-02","CC-18","하이크리에이션","BS-5","부산","5톤",220000,24750,242000,"2022-03-02"]
["2022-03-02","CC-19","기아특수강","DK-5","대구","5톤",170000,19125,187000,"2022-03-02"]
["2022-03-02","CC-20","현진산업","MS-1","마산","1톤",170000,19125,187000,"2022-03-03"]
["2022-03-03","AA-07","정금강업  ","BS-1","부산","1톤",170000,19125,187000,"2022-03-03"]
["2022-03-03","AA-10","진한통상  ","BS-3","부산","3톤",190000,21375,209000,"2022-03-04"]
["2022-03-03","BB-02","코암유통 ","US-1","울산","1톤",170000,19125,187000,"2022-03-04"]
["2022-03-03","BB-05","한영산업","KR-3","강릉","3톤",150000,16875,165000,"2022-03-04"]
["2022-03-03","BB-08","계성제지","BS-3","부산","3톤",190000,21375,209000,"2022-03-04"]
["2022-03-03","CC-11","쌍용제지","MS-1","마산","1톤",170000,19125,187000,"2022-03-03"]
["2022-03-03","CC-12","LG화학","DJ-1","대전","1톤",80000,9000,88000,"2022-03-03"]
["2022-03-03","CC-15","한솔제지","WJ-1","원주","1톤",70000,7875,77000,"2022-03-04"]
["2022-03-03","CC-19","기아특수강","PT-5","평택","5톤",90000,10125,99000,"2022-03-03"]
["2022-03-04","AA-01","대명금속  ","DK-5","대구","5톤",170000,19125,187000,"2022-03-05"]
["2022-03-04","AA-08","효신 제조업 ","DK-3","대구","3톤",140000,15750,154000,"2022-03-05"]
["2022-03-04","BB-08","계성제지","DK-5","대구","5톤",170000,19125,187000,"2022-03-05"]
["2022-03-04","CC-16","한국화이바","JJ-1","전주","1톤",120000,13500,132000,"2022-03-05"]
["2022-03-05","AA-07","정금강업  ","CA-5","천안","5톤",100000,11250,110000,"2022-03-06"]
["2022-03-05","BB-03","텔슨정보통신 ","PH-3","포항","3톤",190000,21375,209000,"2022-03-06"]
["2022-03-05","BB-05","한영산업","KAJ-5","광주","5톤",200000,22500,220000,"2022-03-06"]
["2022-03-05","CC-14","한국제지","DJ-3","대전","3톤",100000,11250,110000,"2022-03-06"]
["2022-03-06","AA-08","효신 제조업 ","PH-1","포항","1톤",170000,19125,187000,"2022-03-06"]
["2022-03-06","AA-10","진한통상  ","SW-3","수원","3톤",60000,6750,66000,"2022-03-07"]
["2022-03-06","BB-02","코암유통 ","KR-3","강릉","3톤",150000,16875,165000,"2022-03-06"]
["2022-03-06","BB-07","금호산업","KR-3","강릉","3톤",150000,16875,165000,"2022-03-07"]
["2022-03-06","BB-09","대한펄프","US-3","울산","3톤",190000,21375,209000,"2022-03-06"]
["2022-03-06","BB-10","삼성코닝","KYJ-5","경주","5톤",220000,24750,242000,"2022-03-07"]
["2022-03-06","BB-10","삼성코닝","PT-3","평택","3톤",80000,9000,88000,"2022-03-06"]
["2022-03-06","CC-10","선경인더스트리","IC-1","인천","1톤",55000,6187.5,60500,"2022-03-06"]
["2022-03-06","CC-16","한국화이바","DK-1","대구","1톤",120000,13500,132000,"2022-03-07"]
["2022-03-06","CC-19","기아특수강","IC-1","인천","1톤",55000,6187.5,60500,"2022-03-07"]
["2022-03-07","BB-04","텔슨통신기술","PH-1","포항","1톤",170000,19125,187000,"2022-03-08"]
["2022-03-07","BB-10","삼성코닝","KYJ-1","경주","1톤",170000,19125,187000,"2022-03-07"]
["2022-03-07","CC-10","선경인더스트리","CJ-1","청주","1톤",70000,7875,77000,"2022-03-08"]
["2022-03-07","CC-20","현진산업","CJ-3","청주","3톤",90000,10125,99000,"2022-03-08"]
["2022-03-08","AA-01","대명금속  ","SW-1","수원","1톤",35000,3937.5,38500,"2022-03-09"]
["2022-03-08","AA-06","국보화학  ","KAJ-5","광주","5톤",200000,22500,220000,"2022-03-08"]
["2022-03-08","AA-07","정금강업  ","JJ-1","전주","1톤",120000,13500,132000,"2022-03-08"]
["2022-03-08","AA-08","효신 제조업 ","WJ-5","원주","5톤",120000,13500,132000,"2022-03-08"]
["2022-03-08","BB-03","텔슨정보통신 ","KAJ-5","광주","5톤",200000,22500,220000,"2022-03-09"]
["2022-03-08","BB-07","금호산업","BS-5","부산","5톤",220000,24750,242000,"2022-03-09"]
["2022-03-08","BB-08","계성제지","PH-3","포항","3톤",190000,21375,209000,"2022-03-09"]
["2022-03-08","CC-10","선경인더스트리","WJ-3","원주","3톤",90000,10125,99000,"2022-03-09"]
["2022-03-08","CC-14","한국제지","DJ-3","대전","3톤",100000,11250,110000,"2022-03-08"]
["2022-03-09","AA-02","모건알루미늄공업","AS-5","안산","5톤",100000,11250,110000,"2022-03-10"]
["2022-03-09","AA-03","신한산업","PT-5","평택","5톤",90000,10125,99000,"2022-03-09"]
["2022-03-09","BB-08","계성제지","US-5","울산","5톤",220000,24750,242000,"2022-03-10"]
["2022-03-09","BB-09","대한펄프","CJ-1","청주","1톤",70000,7875,77000,"2022-03-10"]
["2022-03-10","AA-05","우광산업","KAJ-5","광주","5톤",200000,22500,220000,"2022-03-11"]
["2022-03-10","AA-06","국보화학  ","PT-1","평택","1톤",50000,5625,55000,"2022-03-11"]
["2022-03-10","AA-07","정금강업  ","WJ-3","원주","3톤",90000,10125,99000,"2022-03-11"]
["2022-03-10","CC-12","LG화학","SW-3","수원","3톤",60000,6750,66000,"2022-03-11"]
["2022-03-10","CC-17","LG Caltex정유","SW-3","수원","3톤",60000,6750,66000,"2022-03-11"]
["2022-03-11","AA-04","영신스톤 ","CJ-3","청주","3톤",90000,10125,99000,"2022-03-12"]
["2022-03-11","CC-11","쌍용제지","DJ-3","대전","3톤",100000,11250,110000,"2022-03-12"]
["2022-03-11","CC-16","한국화이바","SW-1","수원","1톤",35000,3937.5,38500,"2022-03-12"]
["2022-03-11","CC-17","LG Caltex정유","AS-3","안산","3톤",80000,9000,88000,"2022-03-12"]
["2022-03-11","CC-18","하이크리에이션","JJ-1","전주","1톤",120000,13500,132000,"2022-03-12"]
["2022-03-12","AA-02","모건알루미늄공업","DK-3","대구","3톤",140000,15750,154000,"2022-03-13"]
["2022-03-12","AA-08","효신 제조업 ","US-1","울산","1톤",170000,19125,187000,"2022-03-12"]
["2022-03-12","BB-03","텔슨정보통신 ","CJ-5","청주","5톤",120000,13500,132000,"2022-03-13"]
["2022-03-12","BB-04","텔슨통신기술","BS-1","부산","1톤",170000,19125,187000,"2022-03-13"]
["2022-03-12","BB-04","텔슨통신기술","DJ-1","대전","1톤",80000,9000,88000,"2022-03-13"]
["2022-03-12","CC-17","LG Caltex정유","PH-5","포항","5톤",220000,24750,242000,"2022-03-13"]
["2022-03-13","AA-06","국보화학  ","DK-5","대구","5톤",170000,19125,187000,"2022-03-14"]
["2022-03-13","BB-01","케이스텔레콤","MS-1","마산","1톤",170000,19125,187000,"2022-03-14"]
["2022-03-13","BB-03","텔슨정보통신 ","JJ-5","전주","5톤",170000,19125,187000,"2022-03-14"]
["2022-03-13","BB-08","계성제지","IC-3","인천","3톤",85000,9562.5,93500,"2022-03-14"]
["2022-03-13","CC-11","쌍용제지","BS-3","부산","3톤",190000,21375,209000,"2022-03-14"]
["2022-03-13","CC-12","LG화학","JJ-5","전주","5톤",170000,19125,187000,"2022-03-13"]
["2022-03-14","BB-03","텔슨정보통신 ","CJ-1","청주","1톤",70000,7875,77000,"2022-03-15"]
["2022-03-14","BB-05","한영산업","KYJ-1","경주","1톤",170000,19125,187000,"2022-03-15"]
["2022-03-14","BB-06","Y.C 인터네셔날  ","PT-1","평택","1톤",50000,5625,55000,"2022-03-15"]
["2022-03-14","BB-08","계성제지","PT-5","평택","5톤",90000,10125,99000,"2022-03-15"]
["2022-03-14","CC-11","쌍용제지","JJ-1","전주","1톤",120000,13500,132000,"2022-03-15"]
["2022-03-15","AA-05","우광산업","US-5","울산","5톤",220000,24750,242000,"2022-03-16"]
["2022-03-15","AA-10","진한통상  ","WJ-1","원주","1톤",70000,7875,77000,"2022-03-16"]

{"sheet":"계산작업","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[30,4,30,6],[31,0,32,1],[31,2,32,2],[31,3,32,3],[30,0,30,3]]}
["[표1]"]
["동","호수","가족수","전기사용량","공동요금","전기요금","단위별공동요금","층수","엘리베이터요금"]
["목련동",502,1,423,{"$f":"ROUND(IF(A3=\"목련동\",25000,IF(A3=\"장미동\",35000,40000)),0)","v":25000},null,null,5]
["장미동",303,7,724,{"$f":"ROUND(IF(A4=\"목련동\",25000,IF(A4=\"장미동\",35000,40000)),0)","v":35000},null,null,3]
["국화동",403,2,222,40000,null,null,4]
["목련동",503,2,438,25000,null,null,5]
["장미동",503,3,171,35000,null,null,5]
["목련동",603,6,741,25000,null,null,6]
["목련동",401,4,548,25000,null,null,4]
["목련동",301,6,154,25000,null,null,3]
["장미동",701,6,663,35000,null,null,7]
["장미동",802,4,476,35000,null,null,8]
["국화동",702,7,765,40000,null,null,7]
["장미동",303,3,460,35000,null,null,3]
["국화동",501,4,157,40000,null,null,5]
["목련동",402,2,203,25000,null,null,4]
["장미동",302,4,237,35000,null,null,3]
["국화동",903,7,682,40000,null,null,9]
["목련동",901,3,457,25000,null,null,9]
["장미동",103,5,134,35000,null,null,1]
["국화동",203,6,588,40000,null,null,2]
["목련동",402,5,492,25000,null,null,4]
["장미동",502,2,520,35000,null,null,5]
["장미동",603,3,444,35000,null,null,6]
["목련동",402,5,766,25000,null,null,4]
["목련동",902,2,660,25000,null,null,9]
["장미동",501,5,157,35000,null,null,5]
["장미동",201,3,407,35000,null,null,2]
[]
["[표2]"]
["전력량",null,null,null,"가족수"]
["구간",null,"기본요금","전력량요금",1,3,5]
[null,null,null,null,2,4]
[0,100,410,60.7,0,0.03,0.04]
[101,200,910,12.9,0,0.03,0.04]
[201,300,1600,187.9,0,0.03,0.05]
[301,400,3850,280.60000000000002,0,0.03,0.05]
[401,500,7300,417.7,0,0.05,0.06]
[500,null,12940,709.5,0,0.05,0.06]
[]
["[표3] 동별 호수별 최대 전기사용량",null,null,null,null,"[표4] 동별 전기사용량 합계/개수"]
["동",1,2,3,null,"동","합계/개수"]
["목련동",null,null,null,null,"목련동"]
["장미동",null,null,null,null,"장미동"]
["국화동",null,null,null,null,"국화동"]

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

{"sheet":"분석작업-2","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]",null,null,"아동수"]
["아동수",12,null,4]
["선생님별 아동 비율",3,null,8]
["추가아동",1,null,12]
["전체 반의 수",{"$f":"ROUND(B3/(B4+B5),0)","v":3},null,16]
[null,null,null,20]
[null,null,null,24]
[]
[]
[null,"[표2]","아동수"]
[null,null,5,10,15,20,25]
["선생님별 아동 비율",2]
[null,4]
[null,6]
[null,8]
[null,10]

{"sheet":"기타작업-1","index":5,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["[표1] 지점별 영업 실적"]
["지점명","1월","2월","전월대비 증감율"]
["서울점",10854000,9970000,-8.8699999999999992]
["오산점",16345000,16016000,-2.0499999999999998]
["안양점",7602000,7720000,1.53]
["인천점",3477000,4347000,20.010000000000002]
["수원점",15380000,14549000,-5.71]
["성남점",14512000,14987000,3.17]
["파주점",5512000,"휴점",0]
["부천점",6405000,6916000,7.39]
["안산점",14320000,17571000,18.5]
["시흥점",10594000,10594000,0]
["고양점",7246000,10568000,31.43]
["화성점",10253000,10151000,-1]
["평택점",11372000,11721000,2.98]
["김포점",10478000,15642000,33.01]
["군포점",1983000,1835000,-8.07]
["하남점",14761000,12956000,-13.93]
["남양주점",9169000,8794000,-4.26]
["대전점",16557000,26524000,37.58]

{"sheet":"기타작업-2","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"[표1] ","목련동 전기 사용 현황"]
[null,"호수","가족수","전기사용량","공동요금","전기요금","단위별공동요금"]
[null,502,1,423,25000,183987.1,833]
[null,503,2,438,25000,190252.6,500]
[null,603,6,741,25000,507135.12999999995,500]
[null,401,4,548,25000,382305.7,1250]
[null,301,6,154,25000,2817.136,1250]
[null,402,2,203,25000,39743.700000000004,833]
[null,901,3,457,25000,188644.45499999999,1250]
[null,402,5,492,25000,200477.89599999998,833]
[null,402,5,766,25000,523808.37999999995,833]
[null,902,2,660,25000,481210,833]

{"sheet":"기타작업-3","index":7,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]"]
["구입날짜","담당자","비품명","가격","부가세",null,"비품명"]
["2022-04-12","홍길동","프린터","350,000원",35000,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,"스캐너"]