{"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":0,"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":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"작성일:","2020-02-28"]
["지역명","아파트명","거래종류","전용면적","규모","거래가","층수","입주일","세대수","거래등록일","거래수수료"]
["군포시","e-편한세상","매매",117.994,"대형",693000000,15,"2007-10-29",730,"2020-01-07",3465000]
["수원시","I-PARK","매매",59.73,"소형",730000000,19,"2018-06-20",580,"2020-01-08",3650000]
["남양주시","푸르지오","매매",76.430000000000007,"중형",470000000,20,"2015-03-02",450,"2020-01-09",1880000]
["구리시","e-편한세상","매매",59.335000000000001,"소형",560000000,9,"2006-09-12",380,"2020-01-13",2240000]
["안양시","주공","전세",59.73,"소형",220000000,8,"1995-03-21",640,"2020-01-14",660000]
["성남시","I-PARK","매매",84.236999999999995,"중형",529000000,8,"1992-11-10",1200,"2020-01-15",2116000]
["안양시","래미안","매매",112,"중형",610000000,10,"2000-11-20",480,"2020-01-16",3050000]
["구리시","I-PARK","매매",84.94,"중형",710000000,26,"2018-02-21",255,"2020-01-17",3550000]
["용인시","푸르지오","전세",59.65,"소형",490000000,29,"2019-05-21",610,"2020-01-17",1960000]
["군포시","래미안","매매",112.24,"대형",990000000,3,"2010-05-02",650,"2020-01-21",5940000]
["수원시","레미안","전세",84.909000000000006,"중형",540000000,26,"2018-03-03",420,"2020-01-21",2160000]
["성남시","I-PARK","매매",170.07,"대형",1421000000,16,"2003-03-05",180,"2020-01-29",8526000]
["남양주시","I-PARK","매매",84.62,"중형",690000000,17,"2015-04-21",410,"2020-01-30",3450000]
["군포시","푸르지오","전세",84.992000000000004,"중형",280000000,21,"2004-04-18",280,"2020-02-03",840000]
["성남시","e-편한세상","전세",59.73,"소형",430000000,4,"2003-07-03",980,"2020-02-03",1720000]
["남양주시","e-편한세상","매매",74.98,"중형",680000000,15,"2017-05-06",620,"2020-02-04",3400000]
["남양주시","캐슬","전세",84.97,"중형",310000000,18,"2017-12-03",570,"2020-02-05",1240000]
["성남시","푸르지오","매매",114,"대형",1055000000,24,"2009-09-10",690,"2020-02-05",6330000]
["성남시","푸르지오","전세",84.74,"중형",430000000,15,"2012-12-21",520,"2020-02-06",1720000]
["수원시","e-편한세상","매매",84.98,"중형",445000000,21,"2007-02-01",475,"2020-02-08",1780000]
["군포시","I-PARK","매매",84.367000000000004,"중형",428000000,19,"2007-04-01",560,"2020-02-10",1712000]
["구리시","푸르지오","매매",61.220999999999997,"소형",445000000,7,"1994-10-13",840,"2020-02-11",1780000]
["용인시","비발디","매매",84.989000000000004,"중형",340000000,2,"2002-01-05",470,"2020-02-13",1360000]
["수원시","힐스테이트","매매",59.648000000000003,"소형",450000000,13,"2006-05-02",920,"2020-02-14",1800000]
["안양시","힐스테이트","매매",114,"대형",648000000,28,"2015-02-21",365,"2020-02-17",3240000]
["용인시","e-편한세상","전세",84.96,"중형",430000000,10,"2006-01-23",390,"2020-02-18",1720000]
["수원시","자이","매매",125.6,"대형",1400000000,23,"2012-01-21",490,"2020-02-20",8400000]
["용인시","래미안","매매",98.54,"대형",940000000,8,"2015-09-30",590,"2020-02-20",5640000]
["안양시","e-편한세상","매매",59.84,"소형",520000000,7,"2001-08-31",530,"2020-02-22",2080000]
["구리시","래미안","전세",84.989000000000004,"중형",420000000,21,"2011-02-05",770,"2020-02-27",1680000]

{"sheet":"기본작업-2","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"작성일:","2020-02-28"]
["지역명","아파트명","거래종류","전용면적","규모","거래가","층수","입주일","세대수","거래등록일","거래수수료"]
["군포시","e-편한세상","매매",117.994,"대형",693000000,15,"2007-10-29",730,"2020-01-07",3465000]
["수원시","I-PARK","매매",59.73,"소형",730000000,19,"2018-06-20",580,"2020-01-08",3650000]
["남양주시","푸르지오","매매",76.430000000000007,"중형",470000000,20,"2015-03-02",450,"2020-01-09",1880000]
["구리시","e-편한세상","매매",59.335000000000001,"소형",560000000,9,"2006-09-12",380,"2020-01-13",2240000]
["안양시","주공","전세",59.73,"소형",220000000,8,"1995-03-21",640,"2020-01-14",660000]
["성남시","I-PARK","매매",84.236999999999995,"중형",529000000,8,"1992-11-10",1200,"2020-01-15",2116000]
["안양시","래미안","매매",112,"중형",610000000,10,"2000-11-20",480,"2020-01-16",3050000]
["구리시","I-PARK","매매",84.94,"중형",710000000,26,"2018-02-21",255,"2020-01-17",3550000]
["용인시","푸르지오","전세",59.65,"소형",490000000,29,"2019-05-21",610,"2020-01-17",1960000]
["군포시","래미안","매매",112.24,"대형",990000000,3,"2010-05-02",650,"2020-01-21",5940000]
["수원시","레미안","전세",84.909000000000006,"중형",540000000,26,"2018-03-03",420,"2020-01-21",2160000]
["성남시","I-PARK","매매",170.07,"대형",1421000000,16,"2003-03-05",180,"2020-01-29",8526000]
["남양주시","I-PARK","매매",84.62,"중형",690000000,17,"2015-04-21",410,"2020-01-30",3450000]
["군포시","푸르지오","전세",84.992000000000004,"중형",280000000,21,"2004-04-18",280,"2020-02-03",840000]
["성남시","e-편한세상","전세",59.73,"소형",430000000,4,"2003-07-03",980,"2020-02-03",1720000]
["남양주시","e-편한세상","매매",74.98,"중형",680000000,15,"2017-05-06",620,"2020-02-04",3400000]
["남양주시","캐슬","전세",84.97,"중형",310000000,18,"2017-12-03",570,"2020-02-05",1240000]
["성남시","푸르지오","매매",114,"대형",1055000000,24,"2009-09-10",690,"2020-02-05",6330000]
["성남시","푸르지오","전세",84.74,"중형",430000000,15,"2012-12-21",520,"2020-02-06",1720000]
["수원시","e-편한세상","매매",84.98,"중형",445000000,21,"2007-02-01",475,"2020-02-08",1780000]
["군포시","I-PARK","매매",84.367000000000004,"중형",428000000,19,"2007-04-01",560,"2020-02-10",1712000]
["구리시","푸르지오","매매",61.220999999999997,"소형",445000000,7,"1994-10-13",840,"2020-02-11",1780000]
["용인시","비발디","매매",84.989000000000004,"중형",340000000,2,"2002-01-05",470,"2020-02-13",1360000]
["수원시","힐스테이트","매매",59.648000000000003,"소형",450000000,13,"2006-05-02",920,"2020-02-14",1800000]
["안양시","힐스테이트","매매",114,"대형",648000000,28,"2015-02-21",365,"2020-02-17",3240000]
["용인시","e-편한세상","전세",84.96,"중형",430000000,10,"2006-01-23",390,"2020-02-18",1720000]
["수원시","자이","매매",125.6,"대형",1400000000,23,"2012-01-21",490,"2020-02-20",8400000]
["용인시","래미안","매매",98.54,"대형",940000000,8,"2015-09-30",590,"2020-02-20",5640000]
["안양시","e-편한세상","매매",59.84,"소형",520000000,7,"2001-08-31",530,"2020-02-22",2080000]
["구리시","래미안","전세",84.989000000000004,"중형",420000000,21,"2011-02-05",770,"2020-02-27",1680000]

{"sheet":"계산작업","index":2,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[[43,0,43,1],[38,5,39,5],[38,4,41,4],[34,5,35,5],[34,4,37,4]]}
["[표1]"]
["지역명","아파트명","거래종류","전용면적","거래가","층수","입주일","세대수","거래등록일","거래수수료","규모"]
["군포시","e-편한세상","매매",117.994,693000000,15,"2007-10-29",730,"2020-01-07"]
["수원시","I-PARK","매매",59.73,730000000,19,"2018-06-20",580,"2020-01-08"]
["남양주시","푸르지오","매매",76.430000000000007,470000000,20,"2015-03-02",450,"2020-01-09"]
["구리시","e-편한세상","매매",59.335000000000001,560000000,9,"2006-09-12",380,"2020-01-13"]
["안양시","주공","전세",59.73,220000000,8,"1995-03-21",640,"2020-01-14"]
["성남시","I-PARK","매매",84.236999999999995,529000000,8,"1992-11-10",1200,"2020-01-15"]
["안양시","래미안","매매",112,610000000,10,"2000-11-20",480,"2020-01-16"]
["구리시","I-PARK","매매",84.94,710000000,26,"2018-02-21",255,"2020-01-17"]
["용인시","푸르지오","전세",59.65,490000000,29,"2019-05-21",610,"2020-01-17"]
["군포시","래미안","매매",112.24,990000000,3,"2010-05-02",650,"2020-01-21"]
["수원시","레미안","전세",84.909000000000006,540000000,26,"2018-03-03",420,"2020-01-21"]
["성남시","I-PARK","매매",170.07,1421000000,16,"2003-03-05",180,"2020-01-29"]
["남양주시","I-PARK","매매",84.62,690000000,17,"2015-04-21",410,"2020-01-30"]
["군포시","푸르지오","전세",84.992000000000004,280000000,21,"2004-04-18",280,"2020-02-03"]
["성남시","e-편한세상","전세",59.73,430000000,4,"2003-07-03",980,"2020-02-03"]
["남양주시","e-편한세상","매매",74.98,680000000,15,"2017-05-06",620,"2020-02-04"]
["남양주시","캐슬","전세",84.97,310000000,18,"2017-12-03",570,"2020-02-05"]
["성남시","푸르지오","매매",114,1055000000,24,"2009-09-10",690,"2020-02-05"]
["성남시","푸르지오","전세",84.74,430000000,15,"2012-12-21",520,"2020-02-06"]
["수원시","e-편한세상","매매",84.98,445000000,21,"2007-02-01",475,"2020-02-08"]
["군포시","I-PARK","매매",84.367000000000004,428000000,19,"2007-04-01",560,"2020-02-10"]
["구리시","푸르지오","매매",61.220999999999997,445000000,7,"1994-10-13",840,"2020-02-11"]
["용인시","비발디","매매",84.989000000000004,340000000,2,"2002-01-05",470,"2020-02-13"]
["수원시","힐스테이트","매매",59.648000000000003,450000000,13,"2006-05-02",920,"2020-02-14"]
["안양시","힐스테이트","매매",114,648000000,28,"2015-02-21",365,"2020-02-17"]
["용인시","e-편한세상","전세",84.96,430000000,10,"2006-01-23",390,"2020-02-18"]
["수원시","자이","매매",125.6,1400000000,23,"2012-01-21",490,"2020-02-20"]
["용인시","래미안","매매",98.54,940000000,8,"2015-09-30",590,"2020-02-20"]
["안양시","e-편한세상","매매",59.84,520000000,7,"2001-08-31",530,"2020-02-22"]
["구리시","래미안","전세",84.989000000000004,420000000,21,"2011-02-05",770,"2020-02-27"]
[]
["[표2] 거래가 평균",null,"단위 : 백만원",null,"[표4] 거래종류별 수수료"]
["지역명","매매","전세",null,"전세","거래가",0,50000000,100000000,300000000]
["구리시",null,null,null,null,null,49999999,99999999,299999999]
["군포시",null,null,null,null,"수수료율",5.0000000000000001E-3,4.0000000000000001E-3,3.0000000000000001E-3,4.0000000000000001E-3]
["남양주시",null,null,null,null,"최고수수료",200000,300000,800000,2400000]
["수원시",null,null,null,"매매","거래가",0,50000000,100000000,300000000]
["안양시",null,null,null,null,null,49999999,99999999,299999999]
["용인시",null,null,null,null,"수수료율",6.0000000000000001E-3,5.0000000000000001E-3,4.0000000000000001E-3,5.0000000000000001E-3]
[null,null,null,null,null,"최고수수료",250000,800000,2400000,4500000]
["[표3] 전용면적별 거래건수"]
["전용면적",null,"거래건수",null,"[표5] 거래종류별 최고가 아파트명"]
[40,59,null,null,"거래종류","아파트명"]
[60,79,null,null,"매매"]
[80,99,null,null,"전세"]
[100,150]

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

{"sheet":"분석작업-2","index":4,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"[표1]"]
[null,"학년","반","이름","2021-06-01","2021-06-02","2021-06-03","2021-06-04","2021-06-07","2021-06-08","2021-06-09","2021-06-10","2021-06-11","2021-06-14","2021-06-15","2021-06-16","2021-06-17","2021-06-18","2021-06-21","2021-06-22","2021-06-23","2021-06-24","2021-06-25","2021-06-28","2021-06-29","2021-06-30","출석수"]
[null,1,"꿈나래반","김영서","X","O","O","O","O","O","O","O","O","X","O","O","O","O","O","O","O","O","O","O","O","O",{"$f":"COUNTIF(E3:X3,\"O\")","v":18}]
[null,1,"풀잎반","김서찬","O","O","O","O","O","O","X","X","O","O","O","O","O","X","O","O","O","O","O","O","X","X",17]
[null,2,"행복반","정승우","O","O","O","O","O","X","O","O","O","O","O","O","O","O","O","O","O","O","O","X","O","O",18]
[null,2,"사랑반","강연지","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",20]
[null,2,"사랑반","손채영","O","O","O","O","O","X","O","O","X","O","O","O","O","O","X","O","O","O","O","X","O","O",16]
[null,3,"기쁨반","김하람","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",20]
[null,3,"기쁨반","김하영","O","X","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",19]
[null,3,"행복반","곽용빈","O","O","O","O","O","O","O","O","O","O","O","X","O","O","O","O","X","O","O","O","O","O",18]
[null,3,"행복반","한정우","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",20]
[null,3,"소망반","권한지","X","X","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","X","O","O","O",17]
[null,1,"꿈나래반","이환","O","O","X","O","O","O","O","O","X","O","O","O","O","O","X","O","O","O","O","O","O","O",17]
[null,1,"솔잎반","김지환","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",20]
[null,1,"솔잎반","원가은","X","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",19]
[null,1,"풀잎반","김영서","X","O","O","O","X","O","O","O","O","X","X","O","O","O","O","X","O","O","X","O","O","O",14]
[null,1,"들꽃반","전준호","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","X","O","O",19]
[null,2,"행복반","신지섭","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",20]
[null,2,"사랑반","박소연","O","O","O","O","O","O","O","O","X","O","O","O","O","O","X","O","O","O","O","O","O","O",18]
[null,2,"사랑반","윤지강","O","O","O","X","O","O","O","O","O","O","O","X","O","O","O","O","X","O","O","X","O","O",16]
[null,3,"기쁨반","박지민","X","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",19]
[null,3,"기쁨반","이지훈","O","O","X","O","X","X","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",17]
[null,3,"소망반","이승아","O","O","O","O","O","O","O","O","O","O","O","X","O","O","O","O","X","O","O","O","O","O",18]
[null,3,"소망반","이지훈","O","O","O","O","O","X","O","X","O","O","O","O","O","X","O","O","O","O","O","X","O","X",16]
[null,3,"소망반","노석진","X","O","O","O","X","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",18]
[null,3,"소망반","최경주","O","O","O","O","X","O","O","O","X","X","O","O","X","O","X","O","O","X","X","O","O","O",13]
[null,3,"기쁨반","박지민","X","O","O","X","O","X","O","X","X","X","O","O","O","X","X","O","O","O","O","O","O","X",12]
[null,1,"들꽃반","최예진","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O","O",20]
[null,1,"들꽃반","김우인","O","O","O","X","O","X","X","X","O","X","O","O","O","X","O","O","O","O","O","O","X","X",14]
[null,1,"사랑반","김유준","X","O","O","O","O","O","O","O","O","O","X","O","O","O","O","X","O","O","X","O","O","O",16]

{"sheet":"기타작업-1","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["수입/수출 현황"]
["월","수출액","수입액"]
["1월",46168.934000000001,45153.389000000003]
["2월",39481.803,36651.436999999998]
["3월",47003.205999999998,41992.349000000002]
["4월",48781.156000000003,45047.163999999997]
["5월",45703.947999999997,43619.667000000001]
["6월",44008.404000000002,40104.811999999998]
["7월",46078.220999999998,43762.245000000003]
["8월",44020.065000000002,42457.25]
["9월",44629.053,38741.472999999998]
["10월",46648.756000000001,41396.517]
["11월",44040.722000000002,40729.214999999997]
["12월",45668.341,43687.43]

{"sheet":"기타작업-2","index":6,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["[표1]"]
["팀명","창의성","실용성","경제성","총점"]
["GoodIdea",75,76,71,222]
["창조굿",93,91,90,274]
["IDEAofKING",66,58,68,192]
["발명왕",75,75,75,225]
["GID",71,75,73,219]
["IDEAdesign",57,86,64,207]
["발명유명",93,64,89,246]
["파워Idea",84,76,82,242]
["사고친창의",72,69,71,212]
["상상나라",68,79,72,219]
["SMS",79,71,77,227]
["발명에디슨",57,60,55,172]
["창의적발명",91,90,91,272]

{"sheet":"기타작업-3","index":7,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["[표1] 상공은행 대출현황"]
["대출인 성명","고객등급","대출종류","대출일자","대출기간(월)","대출금액",null,"고객등급","대출종류"]
["홍길동","골드","주택담보","2020-05-08",36,"150,000,000원",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,null,null,null,null,"VIP","특별자금지원"]