{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["기본작업","계산작업","분석작업-1","분석작업-2","기타작업-1","기타작업-2","기타작업-3"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":1},"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":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,1,6]]}
["[표1]"]
["하반기 신입사원 지원 현황"]
[]
["성    명","지원부서","필  기","자격증","면  접","평  균","결  과"]
["권유식","총무부",85,60,90,78.3,"합격"]
["고광명","영업부",75,80,90,81.7,"합격"]
["김순식","인사부",90,40,80,70,"불합격"]
["도현명","인사부",80,80,70,76.7,"합격"]
["박문수","총무부",85,100,80,88.3,"합격"]
["이기자","영업부",90,60,90,80,"합격"]
["장성태","총무부",66,69,84,73,"불합격"]
["배승우","홍보부",95,76,79,83.3,"합격"]
["장병철","관리부",65,82,72,73,"불합격"]
["우병순","홍보부",91,86,92,89.7,"합격"]
["오장규","관리부",84,91,95,90,"합격"]
["추병선","영업부",89,92,90,90.3,"불합격"]
["김달호","영업부",60,60,80,66.7,"불합격"]
["하지만","인사부",95,80,90,88.3,"합격"]
["한기철","관리부",65,80,90,78.3,"합격"]
[]
["조건"]
[{"$f":"OR(LEFT(A5,1)=\"장\",B5=\"인사부\",F5>=90)","v":false}]
[]
["성    명","지원부서","평  균"]
["김순식","인사부",70]
["도현명","인사부",76.7]
["장성태","총무부",73]
["장병철","관리부",73]
["오장규","관리부",90]
["추병선","영업부",90.3]
["하지만","인사부",88.3]

{"sheet":"계산작업","index":1,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,3,2,3],[1,4,1,6]]}
["[표1]",null,null,"[표2]"]
["담당지역","급여합계",null,"담당지역","판매"]
["강서구",{"$f":"SUM(($C$9:$C$17=A3)*$D$9:$D$17)","v":8750000},null,null,"1부","2부","3부"]
["강동구",{"$f":"SUM(($C$9:$C$17=A4)*$D$9:$D$17)","v":4450000},null,"강서구",{"$f":"MAX(($C$9:$C$17=$D4)*(RIGHT($B$9:$B$17,2)=E$3)*$D$9:$D$17)","v":1550000},{"$f":"MAX(($C$9:$C$17=$D4)*(RIGHT($B$9:$B$17,2)=F$3)*$D$9:$D$17)","v":2150000},{"$f":"MAX(($C$9:$C$17=$D4)*(RIGHT($B$9:$B$17,2)=G$3)*$D$9:$D$17)","v":2750000}]
["성북구",{"$f":"SUM(($C$9:$C$17=A5)*$D$9:$D$17)","v":3870000},null,"강동구",{"$f":"MAX(($C$9:$C$17=$D5)*(RIGHT($B$9:$B$17,2)=E$3)*$D$9:$D$17)","v":1250000},{"$f":"MAX(($C$9:$C$17=$D5)*(RIGHT($B$9:$B$17,2)=F$3)*$D$9:$D$17)","v":1970000},{"$f":"MAX(($C$9:$C$17=$D5)*(RIGHT($B$9:$B$17,2)=G$3)*$D$9:$D$17)","v":1230000}]
[null,null,null,"성북구",{"$f":"MAX(($C$9:$C$17=$D6)*(RIGHT($B$9:$B$17,2)=E$3)*$D$9:$D$17)","v":1560000},{"$f":"MAX(($C$9:$C$17=$D6)*(RIGHT($B$9:$B$17,2)=F$3)*$D$9:$D$17)","v":2310000},{"$f":"MAX(($C$9:$C$17=$D6)*(RIGHT($B$9:$B$17,2)=G$3)*$D$9:$D$17)","v":0}]
["[표3]"]
["성명","부서","담당지역","급여","대출금","이자(연리)","기간(년)","매월불입금","투자 가치","현재 가치"]
["김정원","판매1부","강서구",1550000,10000000,0.1,3,{"$f":"PMT(F9/12,G9*12,-E9)","v":322671.87193837482},{"$f":"ROUND(FV(F9/12,G9*12,-D9*0.3),-3)","v":19429000},{"$f":"PV(F9/12,G9*12,-D9*0.3)","v":14410924.547176072}]
["박경진","판매1부","강동구",1250000,5000000,0.1,1,{"$f":"PMT(F10/12,G10*12,-E10)","v":439579.43615004799},{"$f":"ROUND(FV(F10/12,G10*12,-D10*0.3),-3)","v":4712000},{"$f":"PV(F10/12,G10*12,-D10*0.3)","v":4265440.6594215035}]
["반상현","판매2부","성북구",2310000,40000000,0.1,5,849881.78845073108,53664000,32616300.733460039]
["어지순","판매1부","성북구",1560000,20000000,0.1,3,645343.74387674965,19554000,14503898.253932048]
["유건석","판매3부","강서구",2300000,50000000,0.1,5,1062352.2355634137,53432000,32475104.626388781]
["은지은","판매3부","강동구",1230000,3000000,0.1,1,263747.66169002879,4637000,4197193.6088707596]
["이순자","판매2부","강서구",2150000,20000000,0.1,3,645343.74387674965,26949000,19989346.952534553]
["제장부","판매2부","강동구",1970000,70000000,0.1,7,1162082.8818820135,71482000,35599870.409415573]
["최지열","판매3부","강서구",2750000,50000000,0.1,5,1062352.2355634137,63886000,38828929.444595285]
[]
["[표4]"]
["사원명","입사일","신장","몸무게","근속수당","표준몸무게"]
["김명식","2023-03-01",178,72,{"$f":"IF(YEAR(TODAY())-YEAR(B21)>=10,150000,50000)","v":50000}]
["박신아","2013-01-01",163,52,{"$f":"IF(YEAR(TODAY())-YEAR(B22)>=10,150000,50000)","v":150000}]
["김철호","2013-01-01",160,49,150000]
["서진혁","2015-01-01",172,58,50000]
["김혜진","2022-01-01",170,62,50000]
["이면철","2017-02-01",168,60,50000]
["강진성","2020-02-01",160,58,50000]
[]
["[표5]"]
["동","호","전력량(kwh)","사용요금","납입일","전월전력량","그래프"]
[101,101,230,46838,"2020-08-24",549]
[102,103,415,143362.5,"2020-08-27",269]
[102,104,157,29860.3,"2020-08-18",223]
[102,303,315,74365.5,"2020-08-11",439]
[102,403,358,92326.6,"2020-08-26",81]
[102,304,159,30236.1,"2020-08-31",443]
[101,601,227,45996.2,"2020-08-25",61]
[101,602,569,187315.5,"2020-08-27",91]

{"sheet":"분석작업-1","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["개설일(월)","쇼핑몰","평균: 운영비총액","평균: 판매매출액","평균: 순이익"]
["04월","음악쇼핑몰",1217947.5,4844359.5,3626412]
[null,"종합쇼핑몰",778222.33333333337,3904634.3333333335,3126412]
["05월","가전쇼핑몰",906466.33333333337,628998,-277468.33333333331]
[null,"여행정보몰",447778,532342.5,84564.5]
[null,"예술쇼핑몰",408779,0,-408779]
[null,"음악쇼핑몰",1019134,3350381.6666666665,2331247.6666666665]
[null,"종합쇼핑몰",767377,822620.66666666663,55243.666666666664]
["총합계",null,822798,1967058.5,1144260.5]

{"sheet":"분석작업-2","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["[표1]"]
["성명","부서","직급","직위","인사고과","기본급","상여비율","수당","총급여액"]
["김경수","판매1팀","3급","과장",25,1350000,7.0000000000000007E-2,229500,1579500]
["김지연","홍보2팀","2급","부장",28,1450000,7.0000000000000007E-2,246500,1696500]
["이승연","기획1팀","2급","부장",30,1450000,0.1,290000,1740000]
["김세연","홍보1팀","3급","과장",10,1350000,0.05,202500,1552500]
["박원래","판매2팀","2급","부장",24,1450000,7.0000000000000007E-2,246500,1696500]
["이학봉","기획3팀","3급","과장",20,1350000,7.0000000000000007E-2,229500,1579500]
["지순녀","기획2팀","4급","대리",18,1200000,0.05,180000,1380000]
["최지은","홍보3팀","4급","대리",15,1200000,0.05,180000,1380000]
["홍길동","판매3팀","4급","대리",6,1200000,0.03,156000,1356000]

{"sheet":"기타작업-1","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,9]]}
[null,"성적 일람표 "]
[]
[null,"학번","이름","학과","성별","중간","기말","과제","출석","총점"]
[null,"C003","최고봉","정보처리과","남",28,38,8,17,{"$f":"SUM(F4:I4)","v":91}]
[null,"A003","장샛별","정보처리과","여",25,33,5,20,83]
[null,"C002","조은별","사무자동화과","남",20,35,9,18,82]
[null,"B003","새희망","사무자동화과","여",29,38,10,19,96]
[null,"A002","박인자","웹디자인과","여",27,30,8,12,77]
[null,"C001","김승리","정보처리과","남",26,32,10,18,86]
[null,"B002","최적극","사무자동화과","남",25,34,8,20,87]
[null,"B001","이용감","웹디자인과","남",29,40,10,18,97]
[null,"A004","김튼튼","정보처리과","남",30,37,8,18,93]
[null,"A001","강성실","정보처리과","여",25,28,5,15,73]

{"sheet":"기타작업-2","index":5,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,0,4,0],[3,1,3,10]]}
[]
["차량 5부제 시행 현황"]
[]
["차량번호","쉬는날"]
[null,0,1,2,3,4,5,6,7,8,9]
[7570,1,0,1,0,1,0,1,0,1,0]
[4889,0,1,0,1,0,1,0,1,0,1]
[5076,1,0,1,0,1,0,1,0,1,0]
[7257,0,1,0,1,0,1,0,1,0,1]
[8222,1,0,1,0,1,0,1,0,1,0]
[2008,1,0,1,0,1,0,1,0,1,0]
[9033,0,1,0,1,0,1,0,1,0,1]
[5574,1,0,1,0,1,0,1,0,1,0]
[2917,0,1,0,1,0,1,0,1,0,1]
[3763,0,1,0,1,0,1,0,1,0,1]
[9452,1,0,1,0,1,0,1,0,1,0]
[5005,0,1,0,1,0,1,0,1,0,1]

{"sheet":"기타작업-3","index":6,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["무선 통신 전화요금"]
[null,null,null,null,null,null,"[참조표]"]
["고객명","등급코드","시간당 단가","기본요금","할인요금",null,"등급코드","시간당 단가"," 기본요금","할인요금"]
["홍길동","A",86,45000,4500,null,"A",86,45000,4500]
["이상민","C",104,30000,1500,null,"B",81,40000,4000]
[null,null,null,null,null,null,"C",104,30000,1500]
[null,null,null,null,null,null,"D",52,25000,1250]