{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["DB","시트이동목록","직원연봉내역","월별매출내역","부서별인건비분석표"],"not_rendered":{"macros":1,"external_links":1,"defined_names":13},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"DB","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"hidden":true,"flags":["formulas_cached_only"]}
["시트 보호"]
["시트 보호해제"]
[]
["문서서식 포탈비즈폼 www.bizforms.co.kr"]
["본 문서의 저작권은 비즈폼에 있습니다!"]
["무단 복제 배포시 법적 불이익을 받을 수 있습니다!"]

{"sheet":"시트이동목록","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"순번","시트명","※ 주의사항"]
[null,1,"시트이동목록","     시트명 입력시 하단의 시트명과 동일하게 입력하여야 합니다."]
[null,2,"직원연봉내역","     (띄어쓰기, 약어 등으로 입력시 오류발생)"]
[null,3,"월별매출내역"]
[null,4,"부서별인건비분석표"]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"직원연봉내역","index":2,"n_rows":15,"n_cols":13,"rows_kept":15,"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":10},"단위 : 만원",null,"[부서목록]"]
[null,"성 명","부 서","직 위","입사일","퇴사일","연 봉","월급여","이전연봉","인상률","비 고",null,"부서명"]
[null,"홍길동","총무과","과장","1997-10-13",null,{"v":4500,"d":"4,500 "},{"v":375,"d":"375 "},{"v":4200,"d":"4,200 "},{"v":0.07142857142857142,"d":"7.14%"},null,null,"총무과"]
[null,"한라산","관리부","대리","2001-07-26",null,{"v":2600,"d":"2,600 "},{"v":216.66666666666666,"d":"217 "},{"v":2200,"d":"2,200 "},{"v":0.18181818181818182,"d":"18.18%"},null,null,"관리부"]
[null,"백두산","인사과","대리","2001-08-08",null,{"v":2500,"d":"2,500 "},{"v":208.33333333333334,"d":"208 "},{"v":2100,"d":"2,100 "},{"v":0.19047619047619047,"d":"19.05%"},null,null,"인사과"]
[null,"지리산","마케팅","팀장","2000-01-20",null,{"v":2800,"d":"2,800 "},{"v":233.33333333333334,"d":"233 "},{"v":2400,"d":"2,400 "},{"v":0.16666666666666666,"d":"16.67%"},null,null,"마케팅"]
[null,"천지인","개발팀","팀장","2000-03-07",null,{"v":2500,"d":"2,500 "},{"v":208.33333333333334,"d":"208 "},{"v":2200,"d":"2,200 "},{"v":0.13636363636363635,"d":"13.64%"},null,null,"개발팀"]
[null,"설까치","관리부","사원","2003-09-11",null,{"v":2000,"d":"2,000 "},{"v":166.66666666666666,"d":"167 "},{"v":1600,"d":"1,600 "},{"v":0.25,"d":"25.00%"}]
[null,"마동탁","마케팅","사원","2004-03-04",null,{"v":1800,"d":"1,800 "},{"v":150,"d":"150 "},{"v":1400,"d":"1,400 "},{"v":0.2857142857142857,"d":"28.57%"}]
[null,"김동해","개발팀","사원","2004-07-26",null,{"v":1800,"d":"1,800 "},{"v":150,"d":"150 "},{"v":1400,"d":"1,400 "},{"v":0.2857142857142857,"d":"28.57%"}]
[null,"박남해","개발팀","사원","2005-03-01","2006-07-31",{"v":1700,"d":"1,700 "},{"v":141.66666666666666,"d":"142 "},{"v":1300,"d":"1,300 "},{"v":0.3076923076923077,"d":"30.77%"}]
[null,"이서해","인사과","사원","2004-04-02",null,{"v":2000,"d":"2,000 "},{"v":166.66666666666666,"d":"167 "},{"v":1500,"d":"1,500 "},{"v":0.3333333333333333,"d":"33.33%"}]
[null,"남수욕","총무과","사원","2006-02-01","2006-06-22",{"v":1400,"d":"1,400 "},{"v":116.66666666666667,"d":"117 "},{"v":1400,"d":"1,400 "},{"v":0,"d":"0.00%"}]

{"sheet":"월별매출내역","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":4},"단위 : 만원"]
[null,"연도","월","월 매출액","비  고"]
[null,2006,"1 월",{"v":230000,"d":"230,000 "}]
[null,2006,2,{"v":250000,"d":"250,000 "}]
[null,2006,3,{"v":260000,"d":"260,000 "}]
[null,2006,4,{"v":300000,"d":"300,000 "}]
[null,2006,5,{"v":280000,"d":"280,000 "}]
[null,2006,6,{"v":320000,"d":"320,000 "}]
[null,2006,7,{"v":400000,"d":"400,000 "}]

{"sheet":"부서별인건비분석표","index":4,"n_rows":36,"n_cols":39,"rows_kept":36,"merged":[[0,0,3,13],[0,14,3,15],[0,16,0,19],[0,20,0,23],[0,24,0,27],[0,28,0,31],[1,16,3,19],[1,20,3,23],[1,24,3,27],[1,28,3,31],[2,33,2,36],[2,38,2,41],[3,33,3,36],[3,38,3,41],[4,0,4,31],[5,0,8,1],[5,2,6,7],[5,8,6,15],[5,16,6,21],[5,22,6,31],[7,2,8,7],[7,8,7,13],[7,14,7,22],[7,23,7,31],[8,8,8,10],[8,11,8,13],[8,14,8,19],[8,20,8,22],[8,23,8,28],[8,29,8,31],[9,0,18,1],[9,2,9,7],[9,8,9,10],[9,11,9,13],[9,14,9,19],[9,20,9,22],[9,23,9,28],[9,29,9,31],[10,2,10,7],[10,8,10,10],[10,11,10,13],[10,14,10,19],[10,20,10,22],[10,23,10,28],[10,29,10,31],[11,2,11,7],[11,8,11,10],[11,11,11,13],[11,14,11,19],[11,20,11,22],[11,23,11,28],[11,29,11,31],[12,2,12,7],[12,8,12,10],[12,11,12,13],[12,14,12,19],[12,20,12,22],[12,23,12,28],[12,29,12,31],[13,2,13,7],[13,8,13,10],[13,11,13,13],[13,14,13,19],[13,20,13,22],[13,23,13,28],[13,29,13,31],[14,2,14,7],[14,8,14,10],[14,11,14,13],[14,14,14,19],[14,20,14,22],[14,23,14,28],[14,29,14,31],[15,2,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,19],[15,20,15,22],[15,23,15,28],[15,29,15,31],[16,2,16,7],[16,8,16,10],[16,11,16,13],[16,14,16,19],[16,20,16,22],[16,23,16,28],[16,29,16,31],[17,2,17,7],[17,8,17,10],[17,11,17,13],[17,14,17,19],[17,20,17,22],[17,23,17,28],[17,29,17,31],[18,2,18,7],[18,8,18,10],[18,11,18,13],[18,14,18,19],[18,20,18,22],[18,23,18,28],[18,29,18,31],[19,0,19,7],[19,8,19,13],[19,14,19,22],[19,23,19,31],[20,0,20,31],[21,0,24,1],[21,2,22,7],[21,8,22,15],[21,16,22,21],[21,22,22,31],[23,2,24,7],[23,8,23,13],[23,14,23,22],[23,23,23,31],[24,8,24,10],[24,11,24,13],[24,14,24,19],[24,20,24,22],[24,23,24,28],[24,29,24,31],[25,0,34,1],[25,2,25,7],[25,8,25,10],[25,11,25,13],[25,14,25,19],[25,20,25,22],[25,23,25,28],[25,29,25,31],[26,2,26,7],[26,8,26,10],[26,11,26,13],[26,14,26,19],[26,20,26,22],[26,23,26,28],[26,29,26,31],[27,2,27,7],[27,8,27,10],[27,11,27,13],[27,14,27,19],[27,20,27,22],[27,23,27,28],[27,29,27,31],[28,2,28,7],[28,8,28,10],[28,11,28,13],[28,14,28,19],[28,20,28,22],[28,23,28,28],[28,29,28,31],[29,2,29,7],[29,8,29,10],[29,11,29,13],[29,14,29,19],[29,20,29,22],[29,23,29,28],[29,29,29,31],[30,2,30,7],[30,8,30,10],[30,11,30,13],[30,14,30,19],[30,20,30,22],[30,23,30,28],[30,29,30,31],[31,2,31,7],[31,8,31,10],[31,11,31,13],[31,14,31,19],[31,20,31,22],[31,23,31,28],[31,29,31,31],[32,2,32,7],[32,8,32,10],[32,11,32,13],[32,14,32,19],[32,20,32,22],[32,23,32,28],[32,29,32,31],[33,2,33,7],[33,8,33,10],[33,11,33,13],[33,14,33,19],[33,20,33,22],[33,23,33,28],[33,29,33,31],[34,2,34,7],[34,8,34,10],[34,11,34,13],[34,14,34,19],[34,20,34,22],[34,23,34,28],[34,29,34,31],[35,0,35,7],[35,8,35,13],[35,14,35,22],[35,23,35,31]],"flags":["formulas_cached_only"]}
["부서별 인건비 분석표",{"$nulls":13},"결 재",null,"담 당",{"$nulls":3},"대 리",{"$nulls":3},"과 장",{"$nulls":3},"대표이사"]
[]
[{"$nulls":33},"기준연도",{"$nulls":4},"기준월"]
[{"$nulls":33},2006,{"$nulls":4},2]
["단위 : 만원"]
["구 분",null,"월 매출총액",{"$nulls":5},{"v":250000,"d":"250,000"},{"$nulls":7},"매출대비\n인건비 비율",{"$nulls":5},{"v":0.008533333333333334,"d":"0.85%"}]
[]
[null,null,"부  서",{"$nulls":5},"직원",{"$nulls":5},"급여",{"$nulls":8},"평균 급여"]
[{"$nulls":8},"인원수",null,null,"비율",null,null,"월 급여액",{"$nulls":5},"비율",null,null,"평균 급여액",{"$nulls":5},"비율"]
["2006-02-01",null,"총무과",{"$nulls":5},2,null,null,{"v":0.18181818181818182,"d":"18.2%"},null,null,{"v":491.6666666666667,"d":"492 "},{"$nulls":5},{"v":0.23046875,"d":"23.0%"},null,null,{"v":245.83333333333334,"d":"246 "},{"$nulls":5},{"v":0.25,"d":"25.0%"}]
[null,null,"관리부",{"$nulls":5},2,null,null,{"v":0.18181818181818182,"d":"18.2%"},null,null,{"v":383.3333333333333,"d":"383 "},{"$nulls":5},{"v":0.17968749999999997,"d":"18.0%"},null,null,{"v":191.66666666666666,"d":"192 "},{"$nulls":5},{"v":0.19491525423728812,"d":"19.5%"}]
[null,null,"인사과",{"$nulls":5},2,null,null,{"v":0.18181818181818182,"d":"18.2%"},null,null,{"v":375,"d":"375 "},{"$nulls":5},{"v":0.17578125,"d":"17.6%"},null,null,{"v":187.5,"d":"188 "},{"$nulls":5},{"v":0.1906779661016949,"d":"19.1%"}]
[null,null,"마케팅",{"$nulls":5},2,null,null,{"v":0.18181818181818182,"d":"18.2%"},null,null,{"v":383.33333333333337,"d":"383 "},{"$nulls":5},{"v":0.1796875,"d":"18.0%"},null,null,{"v":191.66666666666669,"d":"192 "},{"$nulls":5},{"v":0.19491525423728814,"d":"19.5%"}]
[null,null,"개발팀",{"$nulls":5},3,null,null,{"v":0.2727272727272727,"d":"27.3%"},null,null,{"v":500,"d":"500 "},{"$nulls":5},{"v":0.23437499999999997,"d":"23.4%"},null,null,{"v":166.66666666666666,"d":"167 "},{"$nulls":5},{"v":0.1694915254237288,"d":"16.9%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
["합  계",{"$nulls":7},{"v":11,"d":"11 "},{"$nulls":5},{"v":2133.3333333333335,"d":"2,133 "},{"$nulls":8},{"v":983.3333333333334,"d":"983 "}]
["단위 : 만원"]
["구 분",null,"월 매출총액",{"$nulls":5},0,{"$nulls":7},"매출대비\n인건비 비율",{"$nulls":5},{"v":0,"d":"0.00%"}]
[]
[null,null,"부  서",{"$nulls":5},"직원",{"$nulls":5},"급여",{"$nulls":8},"평균 급여"]
[{"$nulls":8},"인원수",null,null,"비율",null,null,"월 급여액",{"$nulls":5},"비율",null,null,"평균 급여액",{"$nulls":5},"비율"]
["2006-01-01",null,"총무과",{"$nulls":5},1,null,null,{"v":0.1,"d":"10.0%"},null,null,{"v":375,"d":"375 "},{"$nulls":5},{"v":0.18595041322314051,"d":"18.6%"},null,null,{"v":375,"d":"375 "},{"$nulls":5},{"v":0.33707865168539325,"d":"33.7%"}]
[null,null,"관리부",{"$nulls":5},2,null,null,{"v":0.2,"d":"20.0%"},null,null,{"v":383.3333333333333,"d":"383 "},{"$nulls":5},{"v":0.19008264462809918,"d":"19.0%"},null,null,{"v":191.66666666666666,"d":"192 "},{"$nulls":5},{"v":0.17228464419475656,"d":"17.2%"}]
[null,null,"인사과",{"$nulls":5},2,null,null,{"v":0.2,"d":"20.0%"},null,null,{"v":375,"d":"375 "},{"$nulls":5},{"v":0.18595041322314051,"d":"18.6%"},null,null,{"v":187.5,"d":"188 "},{"$nulls":5},{"v":0.16853932584269662,"d":"16.9%"}]
[null,null,"마케팅",{"$nulls":5},2,null,null,{"v":0.2,"d":"20.0%"},null,null,{"v":383.33333333333337,"d":"383 "},{"$nulls":5},{"v":0.1900826446280992,"d":"19.0%"},null,null,{"v":191.66666666666669,"d":"192 "},{"$nulls":5},{"v":0.17228464419475656,"d":"17.2%"}]
[null,null,"개발팀",{"$nulls":5},3,null,null,{"v":0.3,"d":"30.0%"},null,null,{"v":500,"d":"500 "},{"$nulls":5},{"v":0.24793388429752067,"d":"24.8%"},null,null,{"v":166.66666666666666,"d":"167 "},{"$nulls":5},{"v":0.149812734082397,"d":"15.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
[null,null,0,{"$nulls":5},0,null,null,{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"},null,null,0,{"$nulls":5},{"v":0,"d":"0.0%"}]
["합  계",{"$nulls":7},{"v":10,"d":"10 "},{"$nulls":5},{"v":2016.6666666666665,"d":"2,017 "},{"$nulls":8},{"v":1112.5,"d":"1,113 "}]