{"text_format":"1","workbook":"xlsx","n_sheets":9,"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":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["업종별 평균 근속년수"]
[]
["분류","업무","평균학력","평균근속년수","평균경력","임금근로자수"]
["시스템SW개발자","개발",12.4,5.2,5.5,33]
["통신케이블설치","개발",12.7,7.9,10.6,88]
["애니메이터","관리",13.3,8.3000000000000007,9.6999999999999993,89]
["PC수리원","관리",13.7,4,4.9000000000000004,59]
["웹디자이너","관리",14.3,2.5,3.1,84]
["PC강사","개발",14.7,2.4,2.8,83]
["응용SW개발자","개발",12.3,3.8,5.4,51]
["웹개발자","개발",12.4,2,4.0999999999999996,25]
["PC수리원","관리",13.5,4.5999999999999996,4.9000000000000004,65]
["IT컨설턴트","관리",12.5,3.7,5.9,58]
["보안전문가","관리",13.7,2.4,6,95]
["멀티미디어기획","개발",14.1,3.9,3.4,2]
["PC수리원","관리",12.8,4.4000000000000004,6.5,15]
["웹개발자","개발",13.5,2,4.0999999999999996,12]
["멀티미디어기획","개발",15.7,3.9,3.4,54]
["PC수리원","관리",14.2,4.4000000000000004,6.5,32]
["IT컨설턴트","관리",14.1,3.7,5.9,58]
["보안전문가","관리",16.8,2.4,6,47]
["IT컨설턴트","관리",16.7,3.7,5.9,74]
["응용SW개발자","개발",12.4,3.8,5.4,32]
["PC강사","개발",15.9,6.5,8.4,8]
["SM관리자","관리",14.8,5.6,6.7,94]
["정보통신관리자","관리",14.9,7.2,12.9,68]
["웹개발자","개발",15.1,2,4.0999999999999996,72]
["멀티미디어기획","개발",15.2,3.9,3.4,100]
["PC수리원","관리",12.6,4.4000000000000004,6.5,95]
["보안전문가","관리",15.1,2.4,6,31]
["PC수리원","관리",17.8,4.5999999999999996,4.9000000000000004,51]
["시스템설계/분석","관리",18.399999999999999,6.8,8,82]
[]
["조건"]
[{"$f":"AND(FIND(\"SW\",A4)>=1,RIGHT(A4,3)=\"개발자\")","v":true}]
[]
["분류","업무","평균학력","임금근로자수"]
["시스템SW개발자","개발",12.4,33]
["응용SW개발자","개발",12.3,51]
["응용SW개발자","개발",12.4,32]

{"sheet":"계산작업","index":1,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["[표1]",null,null,null,"[표2]"]
["배달량","배달건수",null,null,"배달지역","배달담당"]
[300,{"$f":"COUNTIFS($E$9:$E$35,\"<=\"&A3,$B$9:$B$35,\"*영\")&\"건\"","v":"7건"},null,null,"산남지구",{"$f":"INDEX($B$9:$B$35,MATCH(LARGE(($C$9:$C$35=E3)*$D$9:$D$35,3),($C$9:$C$35=E3)*$D$9:$D$35,0))","v":"장동욱"}]
[600,{"$f":"COUNTIFS($E$9:$E$35,\"<=\"&A4,$B$9:$B$35,\"*영\")&\"건\"","v":"12건"},null,null,"산북지구",{"$f":"INDEX($B$9:$B$35,MATCH(LARGE(($C$9:$C$35=E4)*$D$9:$D$35,3),($C$9:$C$35=E4)*$D$9:$D$35,0))","v":"장동욱"}]
[1000,"16건",null,null,"산서지구",{"$f":"INDEX($B$9:$B$35,MATCH(LARGE(($C$9:$C$35=E5)*$D$9:$D$35,3),($C$9:$C$35=E5)*$D$9:$D$35,0))","v":"도부영"}]
[null,null,null,null,"산동지구",{"$f":"INDEX($B$9:$B$35,MATCH(LARGE(($C$9:$C$35=E6)*$D$9:$D$35,3),($C$9:$C$35=E6)*$D$9:$D$35,0))","v":"배무영"}]
["[표3]"]
["일자","배달담당","배달지역","배달시간(분)","배달량","비고"]
["2020-01-12","도부영","산남지구",63,48]
["2020-01-12","도부영","산북지구",37,331]
["2020-01-12","배무영","산서지구",70,433]
["2020-01-12","장동욱","산동지구",11,362]
["2020-01-12","장동욱","산동지구",28,2,"배달누락"]
["2020-01-13","도부영","산서지구",28,62]
["2020-01-13","도부영","산서지구",42,3,"배달누락"]
["2020-01-13","배무영","산동지구",67,76]
["2020-01-13","장동욱","산남지구",83,471]
["2020-01-13","장동욱","산북지구",36,750]
["2020-01-14","도부영","산서지구",13,914]
["2020-01-14","배무영","산남지구",97,790]
["2020-01-14","배무영","산북지구",91,356]
["2020-01-14","장동욱","산서지구",5,336]
["2020-01-14","장동욱","산서지구",14,4,"배달누락"]
["2020-01-15","도부영","산남지구",16,322]
["2020-01-15","도부영","산북지구",32,247]
["2020-01-15","배무영","산서지구",11,365]
["2020-01-15","장동욱","산동지구",85,423]
["2020-01-16","도부영","산서지구",94,177]
["2020-01-16","배무영","산동지구",56,209]
["2020-01-16","장동욱","산남지구",44,5,"배달누락"]
["2020-01-16","장동욱","산북지구",51,908]
["2020-01-17","도부영","산서지구",11,626]
["2020-01-17","배무영","산동지구",38,874]
["2020-01-17","장동욱","산남지구",74,359]
["2020-01-17","장동욱","산북지구",95,767]
[]
["[표4]"]
["제품코드","제품코드2","품명","판매량","판매금액","이익금"]
["y201k",{"$f":"UPPER(SUBSTITUTE(A39,\"0\",\"9\"))","v":"Y291K"},"곰인형",45,{"$f":"D39*VLOOKUP(RIGHT(B39,1),$H$42:$J$46,2,FALSE)-D39*VLOOKUP(RIGHT(B39,1),$H$42:$J$46,2,FALSE)*VLOOKUP(RIGHT(B39,1),$H$42:$J$46,3,FALSE)","v":128250},{"$f":"fn이익금(E39,C39,D39)","v":38475}]
["b450n",{"$f":"UPPER(SUBSTITUTE(A40,\"0\",\"9\"))","v":"B459N"},"놀이동산",89,{"$f":"D40*VLOOKUP(RIGHT(B40,1),$H$42:$J$46,2,FALSE)-D40*VLOOKUP(RIGHT(B40,1),$H$42:$J$46,2,FALSE)*VLOOKUP(RIGHT(B40,1),$H$42:$J$46,3,FALSE)","v":372465},{"$f":"fn이익금(E40,C40,D40)","v":111739.50000000003},null,"[표5] 제품 코드표"]
["y203d","Y293D","딸랑이",230,338100,169050,null,"코드","판매단가","할인율"]
["y012g","Y912G","꼬마인형",30,151200,45360,null,"k",3000,0.05]
["y305k","Y395K","곰인형",120,342000,102600.00000000003,null,"n",4500,7.0000000000000007E-2]
["y365y","Y365Y","우유병",120,360960,180480,null,"d",1500,0.02]
["b304n","B394N","놀이동산",325,1360125,408037.50000000012,null,"g",5600,0.1]
["b123d","B123D","딸랑이",60,88200,26460.000000000007,null,"y",3200,0.06]

{"sheet":"대리","index":2,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["성명","부서","직위","인사고과","기본급","상여비율","수당","총급여액"]
["주지연","기획부","대리",18,1200000,0.05,180000,1380000]
["김동지","판매부","대리",6,1200000,0.03,156000,1356000]
["오여령","홍보부","대리",15,1200000,0.05,180000,1380000]

{"sheet":"분석작업-1","index":3,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"성명","(모두)"]
[]
[null,"직위","부서","최대 : 기본급","최대 : 수당","합계 : 총수령금액"]
[null,"부장"]
[null,null,"기획부",1450000,290000,1740000]
[null,null,"판매부",1450000,246500,1696500]
[null,null,"홍보부",1450000,246500,1696500]
[null,"부장 요약",null,1450000,290000,5133000]
[null,"과장"]
[null,null,"기획부",1350000,229500,1579500]
[null,null,"판매부",1350000,229500,1579500]
[null,null,"홍보부",1350000,202500,1552500]
[null,"과장 요약",null,1350000,229500,4711500]
[null,"대리"]
[null,null,"기획부",1200000,180000,1380000]
[null,null,"판매부",1200000,156000,1356000]
[null,null,"홍보부",1200000,180000,1380000]
[null,"대리 요약",null,1200000,180000,4116000]
[null,"사원"]
[null,null,"기획부",1125000,168750,1293750]
[null,null,"판매부",995000,149250,1144250]
[null,null,"홍보부",1055000,179350,1234350]
[null,"사원 요약",null,1125000,179350,3672350]
[null,"총합계",null,1450000,290000,17632850]

{"sheet":"시나리오 요약","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"시나리오 요약"]
[null,null,null,"현재 값:","대출금 증가","대출금 감소"]
[null,null,null,null,"만든 사람 Windows User 날짜 2024-01-19","만든 사람 Windows User 날짜 2024-01-19"]
[null,"변경 셀:"]
[null,null,"$C$3",20000000,30000000,15000000]
[null,"결과 셀:"]
[null,null,"$C$6",622124.36321312899,933186.54481969296,466593.27240984602]
[null,"참고: 현재 값 열은 시나리오 요약 보고서가 작성될 때의"]
[null,"변경 셀 값을 나타냅니다. 각 시나리오의 변경 셀들은"]
[null,"회색으로 표시됩니다."]

{"sheet":"분석작업-2","index":5,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"대출금 상환 금액"]
[null,"대출금",20000000]
[null,"연이율",7.4999999999999997E-2]
[null,"상환기간(개월)",36]
[null,"상환금액(월)",{"$f":"PMT(C4/12,C5,-$C3)","v":622124.36321312876}]

{"sheet":"기타작업-1","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,5]]}
[null,"신입사원 명단"]
[]
["성명","성별","TOEIC","TOEFL","졸업학점","면접점수"]
["김근태","남",720,498,3.41,860]
["남연희","여",710,498,3.43,910]
["류성미","여",840,556,2.94,980]
["박선효","여",775,510,3.49,890]
["손정은","여",765,499,3.9,780]
["오성빈","남",665,412,3.63,910]
["정창준","남",875,534,3.52,810]

{"sheet":"기타작업-2","index":7,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["[표1]"]
["성명","영업소","1월","2월","3월","4월","5월","6월","7월","8월","9월","10월","11월","12월"]
["박성호","경기",540,230,190,230,250,250,280,200,190,290,300,180]
["김현승","대구",430,210,75,260,360,240,180,250,270,250,290,160]
["손정호","인천",120,180,200,270,250,230,70,350,180,230,300,170]
["강만식","부산",500,310,270,280,190,280,170,210,220,280,180,210]
["최기정","인천",120,110,140,280,300,290,210,250,200,260,190,200]
["하경희","대구",480,310,180,260,240,240,260,240,180,260,280,220]
["임정희","인천",160,172,210,230,290,180,360,180,260,280,260,230]
["안진국","인천",245,90,230,240,180,190,160,190,240,270,240,310]

{"sheet":"기타작업-3","index":8,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"호수","성명"]
["[표1] 공과금 관리",null,null,null,null,null,null,"101호","김구자"]
[null,null,null,null,null,null,null,"102호","박선량"]
["호수","성명","수도세","전기세","납입기간",null,null,"103호","이시끌"]
["101호","김구자",15000,12000,"납기내",null,null,"104호","최만득"]
["102호","박선량",13000,10000,"납기후"]