{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["기본작업-1","기본작업-2","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2","기타작업-3"],"not_rendered":{"charts":1,"images":9,"macros":1,"external_links":0,"defined_names":6,"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":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"학년","반","이름","2016-03-03","2016-03-10","2016-03-17","2016-03-24","2016-03-31","2016-04-07","2016-04-14","2016-04-21","2016-04-28","2016-05-05","2016-05-12","2016-05-19","2016-05-26","2016-06-02","2016-06-09","출석수"]
[null,1,"사랑반","김영서","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",{"$f":"COUNTA(E4:S4)","v":15}]
[null,1,"사랑반","이환","O","O",null,"O","O","O","O","O",null,"O","O","O","O","O","O",13]
[null,1,"사랑반","김유준",null,"O","O","O","O","O","O","O","O","O",null,"O","O",null,"O",12]
[null,1,"화평반","김지환","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,1,"화평반","원가은",null,"O","O","O","O","O","O","O","O","O","O","O","O","O","O",14]
[null,1,"화평반","김서찬","O","O","O","O","O","O",null,null,"O","O","O","O","O","O","O",13]
[null,1,"화평반","노재현",null,"O","O","O",null,"O","O","O","O","O",null,"O","O",null,"O",11]
[null,1,"희락반","최예진","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,1,"희락반","전준호","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,1,"희락반","김우인","O","O","O",null,"O",null,null,null,"O",null,"O","O","O","O","O",10]
[null,2,"양선반","신지섭","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"양선반","정승우","O","O","O","O","O",null,"O","O","O","O","O","O","O","O",null,13]
[null,2,"오래참음반","강연지","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"오래참음반","박소연","O","O","O","O","O","O","O","O",null,"O","O","O","O","O","O",14]
[null,2,"오래참음반","윤지강","O","O","O","O","O","O","O","O","O","O","O",null,"O","O",null,13]
[null,2,"오래참음반","손채영","O","O","O","O","O",null,"O","O",null,"O","O","O","O","O",null,12]
[null,2,"자비반","박지민","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"자비반","김하람","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"자비반","김하영","O",null,"O","O","O","O","O","O","O","O","O","O","O","O","O",14]
[null,2,"자비반","이지훈","O","O",null,"O",null,null,"O","O","O","O","O","O","O","O","O",12]
[null,2,"자비반","이선녕",null,"O","O",null,"O",null,"O",null,null,null,"O","O","O","O","O",9]
[null,2,"충성반","곽용빈","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"충성반","이승아","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"충성반","한정우","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"충성반","이창재","O","O","O","O","O",null,"O","O","O","O","O","O","O","O","O",14]
[null,2,"충성반","노석진",null,"O","O","O",null,"O","O","O","O","O","O","O","O","O","O",13]
[null,2,"충성반","권한지",null,null,"O","O","O","O","O","O","O","O","O","O","O","O","O",13]
[null,2,"충성반","최경주","O","O","O","O",null,"O","O","O",null,null,"O","O",null,null,"O",10]

{"sheet":"기본작업-2","index":1,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"학년","반","이름","2016-03-03","2016-03-10","2016-03-17","2016-03-24","2016-03-31","2016-04-07","2016-04-14","2016-04-21","2016-04-28","2016-05-05","2016-05-12","2016-05-19","2016-05-26","2016-06-02","2016-06-09","출석수"]
[null,2,"오래참음반","강연지","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",{"$f":"COUNTA(E4:S4)","v":15}]
[null,2,"충성반","곽용빈","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"충성반","권한지",null,null,"O","O","O","O","O","O","O","O","O","O","O","O","O",13]
[null,1,"화평반","김서찬","O","O","O","O","O","O",null,null,"O","O","O","O","O","O","O",13]
[null,1,"사랑반","김영서","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,1,"희락반","김우인","O","O","O",null,"O",null,null,null,"O",null,"O","O","O","O","O",10]
[null,1,"사랑반","김유준",null,"O","O","O","O","O","O","O","O","O",null,"O","O",null,"O",12]
[null,1,"화평반","김지환","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"자비반","김하람","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"자비반","김하영","O",null,"O","O","O","O","O","O","O","O","O","O","O","O","O",14]
[null,2,"충성반","노석진",null,"O","O","O",null,"O","O","O","O","O","O","O","O","O","O",13]
[null,1,"화평반","노재현",null,"O","O","O",null,"O","O","O","O","O",null,"O","O",null,"O",11]
[null,2,"오래참음반","박소연","O","O","O","O","O","O","O","O",null,"O","O","O","O","O","O",14]
[null,2,"자비반","박지민","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"오래참음반","손채영","O","O","O","O","O",null,"O","O",null,"O","O","O","O","O",null,12]
[null,2,"양선반","신지섭","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,1,"화평반","원가은",null,"O","O","O","O","O","O","O","O","O","O","O","O","O","O",14]
[null,2,"오래참음반","윤지강","O","O","O","O","O","O","O","O","O","O","O",null,"O","O",null,13]
[null,2,"자비반","이선녕",null,"O","O",null,"O",null,"O",null,null,null,"O","O","O","O","O",9]
[null,2,"충성반","이승아","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"자비반","이지훈","O","O",null,"O",null,null,"O","O","O","O","O","O","O","O","O",12]
[null,2,"충성반","이창재","O","O","O","O","O",null,"O","O","O","O","O","O","O","O","O",14]
[null,1,"사랑반","이환","O","O",null,"O","O","O","O","O",null,"O","O","O","O","O","O",13]
[null,1,"희락반","전준호","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"양선반","정승우","O","O","O","O","O",null,"O","O","O","O","O","O","O","O",null,13]
[null,2,"충성반","최경주","O","O","O","O",null,"O","O","O",null,null,"O","O",null,null,"O",10]
[null,1,"희락반","최예진","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]
[null,2,"충성반","한정우","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",15]

{"sheet":"계산작업","index":2,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[19,14,20,14],[19,10,19,11]]}
[]
[null,"[표1]"]
[null,"가입나이","코드","구분-성별","가입금액","가입기간","미납기간","가입상태",null,null,"[표2]"]
[null,24,"BM",null,null,5,3,null,null,null,"코드","구분","성별"]
[null,41,"BW",null,null,3,0,null,null,null,"BM","기본형","남자"]
[null,50,"SM",null,null,15,0,null,null,null,"SM","추가보장","남자"]
[null,29,"SW",null,null,15,0,null,null,null,"BW","기본형","여자"]
[null,42,"SW",null,null,5,1,null,null,null,"SW","추가보장","여자"]
[null,7,"SW",null,null,10,0]
[null,45,"SM",null,null,14,1,null,null,null,"[표3] 코드별 가입나이별 가입금액"]
[null,16,"SW",null,null,5,1,null,null,null,null,0,10,20,30,40,50,60,70]
[null,16,"BM",null,null,6,1,null,null,null,null,10,20,30,40,50,60,70]
[null,51,"BM",null,null,8,0,null,null,null,"BM",12800,12800,13200,14800,19800,33000,58300,89500]
[null,46,"BM",null,null,8,2,null,null,null,"SM",13100,13100,13700,16100,24000,45000,85500,134800]
[null,22,"BM",null,null,21,0,null,null,null,"BW",12700,12600,13500,16700,22500,26500,32200,43100]
[null,6,"BM",null,null,7,0,null,null,null,"SW",13000,12900,14200,19100,28400,34900,43900,60700]
[null,22,"BW",null,null,21,2]
[null,21,"SM",null,null,20,0]
[null,13,"SW",null,null,8,0,null,null,null,"[표4] 나이대별 가입자수",null,null,null,"[표5] 코드별 나이별 평균 가입기간"]
[null,29,"BM",null,null,24,0,null,null,null,"나이",null,"가입자수",null,"코드",0,20,30,40,60]
[null,61,"BW",null,null,23,1,null,null,null,1,10,null,null,null,20,30,40,60,80]
[null,12,"BW",null,null,20,2,null,null,null,11,20,null,null,"BM"]
[null,64,"SW",null,null,7,0,null,null,null,21,30,null,null,"BW"]
[null,29,"BM",null,null,17,2,null,null,null,31,40,null,null,"SM"]
[null,17,"BW",null,null,21,2,null,null,null,41,50,null,null,"SW"]
[null,29,"SM",null,null,2,2,null,null,null,51,60]
[null,26,"SM",null,null,4,1,null,null,null,61,70]
[null,59,"SM",null,null,2,1]
[null,43,"BW",null,null,5,2]
[null,53,"SM",null,null,21,2]
[null,29,"SW",null,null,18,1]
[null,18,"BM",null,null,9,1]
[null,41,"BW",null,null,7,0]
[null,8,"SM",null,null,9,2]
[null,64,"SW",null,null,20,1]
[null,21,"SW",null,null,12,2]
[null,25,"SW",null,null,21,0]
[null,53,"SW",null,null,23,0]
[null,59,"SW",null,null,9,1]

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

{"sheet":"분석작업-2","index":4,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"[표1]"]
[null,"반","성명","성별","생년월일","연락처","출석일수"]
[null,"믿음반","김서영","여","2007-02-08","010-88**-****",15]
[null,"믿음반","김종헌","남","2007-05-21","010-73**-****",13]
[null,"믿음반","김종헌","남","2007-08-10","010-73**-****",12]
[null,"믿음반","김주형","남","2007-06-29","010-42**-****",15]
[null,"믿음반","박건우","남","2007-02-24","010-47**-****",14]
[null,"믿음반","박연우","남","2007-09-11","010-82**-****",13]
[null,"믿음반","박연우","남","2007-09-11","010-51**-****",11]
[null,"믿음반","송예린","여","2007-03-02",null,15]
[null,"믿음반","전지호","남","2007-09-21","010-53**-****",15]
[null,"소망반","박진우","남","2007-02-03","010-71**-****",10]
[null,"소망반","오정은","여","2007-04-17","010-40**-****",15]
[null,"소망반","유연서","여","2007-12-10","010-52**-****",13]
[null,"소망반","윤서연","여","2007-02-08",null,15]
[null,"소망반","이수린","여","2007-08-09","010-27**-****",14]
[null,"소망반","이유진","여","2007-09-16","010-44**-****",13]
[null,"소망반","임형빈","남","2007-01-03","010-99**-****",12]
[null,"소망반","장시훈","남","2007-12-07","010-46**-****",15]
[null,"소망반","최경은","여","2007-04-30","010-32**-****",15]
[null,"온유반","권지인","여","2007-01-02","010-84**-****",14]
[null,"온유반","김시연","여","2007-09-06","010-36**-****",12]
[null,"온유반","김주한","남","2007-12-24","010-93**-****",9]
[null,"온유반","박준영","남","2007-10-10","010-71**-****",15]
[null,"온유반","박지원","여","2007-09-09","010-47**-****",15]
[null,"온유반","이지선","여","2007-06-18",null,15]
[null,"온유반","차숙원","남","2007-08-27","010-62**-****",14]

{"sheet":"기타작업-1","index":5,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[14,1,15,1],[14,3,15,3],[14,4,15,4],[14,5,14,6],[14,7,14,8],[3,1,4,1],[3,3,4,3],[3,4,4,4],[3,5,3,6],[3,7,3,8]]}
[]
[null,"환율 미국(USD)"]
[]
[null,"날짜","매매","전일비","등락률","현찰",null,"송금(전신환)"]
[null,null,"기준율",null,null,"사실때","파실때","보내실때","받으실때"]
[null,"2020-03-18",1162.5,"▼7.50",-6.4000000000000003E-3,1182.8399999999999,1142.1600000000001,1173.8,1151.2]
[null,"2020-03-17",1170,"▼23.40",-1.9599999999999999E-2,1190.47,1149.53,1181.4000000000001,1158.5999999999999]
[null,"2020-03-16",1193.4000000000001," 3.40",2.8999999999999998E-3,1214.28,1172.52,1205,1181.8]
[null,"2020-03-15",1190," 2.50",2.0999999999999999E-3,1210.82,1169.18,1201.5999999999999,1178.4000000000001]
[null,"2020-03-14",1187.5,"▼6.50",-5.4000000000000003E-3,1208.28,1166.72,1199.0999999999999,1175.9000000000001]
[]
[]
[null,"환율 중국(CNY)"]
[]
[null,"날짜","매매","전일비","등락률","현찰",null,"송금(전신환)"]
[null,null,"기준율",null,null,"사실때","파실때","보내실때","받으실때"]
[null,"2020-03-18",179," 1.43",8.0999999999999996E-3,191.53,170.05,180.79,177.21]
[null,"2020-03-17",177.57,"▼0.43",-2.3999999999999998E-3,189.99,168.7,179.34,175.8]
[null,"2020-03-16",178," 1.76",0.01,190.46,169.1,179.78,176.22]
[null,"2020-03-15",176.24,"▼0.75",-4.1999999999999997E-3,188.57,167.43,178,174.48]
[null,"2020-03-14",176.99,"▼1.90",-1.06E-2,189.37,168.15,178.75,175.23]

{"sheet":"기타작업-2","index":6,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"학년","반","이름","2016-03-03","2016-03-10","2016-03-17","2016-03-24","2016-03-31","2016-04-07","2016-04-14","2016-04-21","출석"]
[null,1,"사랑반","김영서",1,1,1,1,1,1,1,1,{"$f":"SUM(E6:L6)","v":8}]
[null,1,"사랑반","이환",1,1,0,1,1,1,1,1,{"$f":"SUM(E7:L7)","v":7}]
[null,1,"사랑반","김유준",0,1,1,1,1,1,1,1,7]
[null,1,"화평반","김지환",1,1,1,1,1,1,1,1,8]
[null,1,"화평반","원가은",0,1,1,1,1,1,1,1,7]
[null,1,"화평반","김서찬",1,1,1,1,1,1,0,0,6]
[null,1,"화평반","노재현",0,1,1,1,0,1,1,1,6]
[null,1,"희락반","최예진",1,1,1,1,1,1,1,1,8]
[null,1,"희락반","전준호",1,1,1,1,1,1,1,1,8]
[null,1,"희락반","김우인",1,1,1,0,1,0,0,0,4]
[null,2,"양선반","신지섭",1,1,1,1,1,1,1,1,8]
[null,2,"양선반","정승우",1,1,1,1,1,null,1,1,7]
[null,2,"오래참음반","강연지",1,1,1,1,1,1,1,1,8]
[null,2,"오래참음반","박소연",1,1,1,1,1,1,1,1,8]
[null,2,"오래참음반","윤지강",1,1,1,1,1,1,1,1,8]
[null,2,"오래참음반","손채영",1,1,1,1,1,null,1,1,7]
[null,2,"자비반","박지민",1,1,1,1,1,1,1,1,8]
[null,2,"자비반","김하람",1,1,1,1,1,1,1,1,8]
[null,2,"자비반","김하영",1,0,1,1,1,1,1,1,7]
[null,2,"자비반","이지훈",1,1,0,1,0,0,1,1,5]
[null,2,"자비반","이선녕",0,1,1,0,1,0,1,0,4]
[null,2,"충성반","곽용빈",1,1,1,1,1,1,1,1,8]
[null,2,"충성반","이승아",1,1,1,1,1,1,1,1,8]
[null,2,"충성반","한정우",1,1,1,1,1,1,1,1,8]
[null,2,"충성반","이창재",1,1,1,1,1,0,1,1,7]
[null,2,"충성반","노석진",0,1,1,1,0,1,1,1,6]
[null,2,"충성반","권한지",0,0,1,1,1,1,1,1,6]
[null,2,"충성반","최경주",1,1,1,1,0,1,1,1,7]

{"sheet":"기타작업-3","index":7,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"[표1]",null,null,null,null,null,null,null,null,null,null,"[표2]"]
[null,"구분","아동명","보호자동반","기본요금","입장시간","퇴장시간","요금",null,null,null,null,"구분","기본요금"]
[null,"유치","한새미","유",3000,"13:00:00","15:00:00",6000,null,null,null,null,"유아",0]
[null,"초등","이시환","무",4000,"15:40:00","17:30:00",8000,null,null,null,null,"유치",3000]
[null,null,null,null,null,null,null,null,null,null,null,null,"초등",4000]