{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["무작정따라하기","기출01"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"무작정따라하기","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,5,22,6],[10,0,10,3],[12,0,12,1],[12,3,12,5],[12,6,12,7],[13,0,13,1],[13,3,13,5],[13,6,13,7],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6]]}
["[표1]","학원 관리"]
["성명","성별","주민등록번호","수업료","중간","기말","평균","순위"]
["신선미","여","080312-417****",null,79,87,{"$f":"AVERAGE(E3:F3)","v":83},{"$f":"_xlfn.RANK.EQ(G3:G10,$G$3:$G$10,0)","v":5}]
["이남규","남","071015-311****","납부",88,90,{"$f":"AVERAGE(E4:F4)","v":89},2]
["민철홍","남","060220-323****","납부",75,92,83.5,3]
["김미진","여","081101-442****",null,88,98,93,1]
["강민","여","061202-423****","납부",88,60,74,6]
["이명복","남","080411-342****","납부",90,77,83.5,3]
["조상희","남","071224-336****",null,58,45,51.5,8]
["윤정희","여","070729-416****",null,55,89,72,7]
["가장 큰 값과 두번째로 큰 값의 차이값",null,null,null,{"$f":"MAX(E3:E10)-LARGE(E3:E10,2)","v":2},{"$f":"MAX(F3:F10)-LARGE(F3:F10,2)","v":6},4]
[]
["여학생 중간 평균",null,"수업료 납부자수","기말점수가 90점 이상인 학생수",null,null,"평균 80점대 학생수"]
[{"$f":"AVERAGEIF(B3:B10,B3,E3:E10)","v":77.5},null,{"$f":"COUNTA(D3:D10)","v":4},{"$f":"COUNTIF(F3:F10,\">=90\")","v":3},null,null,{"$f":"COUNTIFS(G3:G10,\">=80\",G3:G10,\"<90\")","v":4}]
[]
[]
["[표2]","세계 클럽컵 축구대회"]
["순위","팀명","팀명2","국가","감독명","국가-감독"]
[1," susung ",{"$f":"UPPER(TRIM(B19))","v":"SUSUNG"},"korea","BENTO",{"$f":"PROPER(D19)&\"-\"&LOWER(E19)","v":"Korea-bento"}]
[2," chelsy ",{"$f":"UPPER(TRIM(B20))","v":"CHELSY"},"england","SALTOR",{"$f":"PROPER(D20)&\"-\"&LOWER(E20)","v":"England-saltor"}]
[3," roma ","ROMA","italy","MANET","Italy-manet"]
[4," hoven ","HOVEN","germany","MESUT","Germany-mesut"]
[5," isac ","ISAC","france","ZIDANE","France-zidane"]

{"sheet":"기출01","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,5],[11,0,11,1],[11,2,11,3],[11,4,11,5],[12,0,12,1],[12,2,12,3],[12,4,12,5],[14,0,14,1],[14,2,14,3],[14,4,14,5],[15,0,15,1],[15,2,15,3],[15,4,15,5]]}
["웹디자인 직무 연수"]
[]
["성명","직위","필기","실기","총점","이수여부","회사명","부서명","구분"]
["김준용","부장",86,79,{"$f":"SUM(C4:D4)","v":165},"이수","adqua","design","BRANCH"]
["이원경","과장",88,64,{"$f":"SUM(C5:D5)","v":152}]
["임선호","대리",76,82,158,"이수"]
["한미주","대리",56,78,134]
["강동준","대리",74,76,150,"이수"]
["고회식","사원",78,66,144,"이수"]
["유보미","사원",62,68,130]
[]
["이수자 총점 평균",null,"70점 이상 총점 평균",null,"대리 이수자수"]
[{"$f":"AVERAGEIF(F4:F10,F4,E4:E10)","v":154.25},null,{"$f":"AVERAGEIFS(E4:E10,C4:C10,\">=70\",D4:D10,\">=70\")","v":157.66666666666666},null,{"$f":"COUNTIFS(B4:B10,B6,F4:F10,F4)","v":2}]
[]
["80점 이상인 수",null,"부서코드",null,"회사명(구분)"]
[{"$f":"COUNTIF(C4:D10,\">=80\")&\"명\"","v":"3명"},null,{"$f":"UPPER(LEFT(G4,2)&\"-\"&RIGHT(H4,4))","v":"AD-SIGN"},null,{"$f":"UPPER(G4)&\"(\"&LOWER(I4)&\")\"","v":"ADQUA(branch)"}]