{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["추가근로정보","시간외수당 계산","급여테이블","사원명단"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,5,2,6],[2,7,2,8],[2,9,2,12]]}
[null,null,null,null,null,null,null,null,null,"하루근무시간",{"$f":"IF(M2>M1,HOUR(M2-M1)-K2,HOUR(24+M2-M1)-K2)","v":8},"근무시작시간","09:00:00","4시간근무",1]
[null,null,null,null,null,null,null,null,null,"휴게시간",{"$f":"IF(M2>M1,IF(HOUR(M2-M1)>=9,O2,IF(HOUR(M2-M1)>=4.5,O1,\"\")),IF(HOUR(24+M2-M1)>=9,O2,IF(HOUR(24+M2-M1)>=4.5,O1,\"\")))","v":1},"근무종료시간","18:00:00","8시간근무",1]
[null,null,null,null,null,"시작시간",null,"종료시간",null,"시간외",null,null,null,"정규","정규","정규","정규"]
["순번","성명","사번","근로일자","주/휴일 구분","시","분","시","분","총시간","휴일일반","연장근로","야간근로","야간근로","근무시작시간","근무종료시간"," 휴게시간"]
[1,"홍길동",23001,"2023-11-03",null,18,0,20,0,2,null,2,0,null,"09:00:00","18:00:00",1]
[2,"가나다",23002,"2023-11-04","주말",17,0,22,0,5,4,0,0,null,null,null,1]
[3,"홍길동",23001,"2023-11-13",null,20,0,2,0,6,null,5,4,null,"09:00:00","18:00:00",2]
[4,"김김김",23003,"2023-11-19","주말",10,0,17,0,7,6,0,0,null,null,null,1]
[5,"스티브",23004,"2023-11-27",null,2,0,6,0,4,null,3,4,4,"18:00:00","02:00:00",1]

{"sheet":"시간외수당 계산","index":1,"n_rows":8,"n_cols":20,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,3,2,7],[2,11,2,15],[1,17,1,19]]}
[]
[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,null,null,null,null,"정규시간","정규시간","정규시간"]
["순번","성명","사번","평일(연장)","평일(야간)","휴일(일반)","휴일(연장)","휴일(야간)","특근일수","통상임금","시간당 단가","평일(연장)","평일(야간)","휴일(일반)","휴일(연장)","휴일(야간)","수당지급총액","정규(야간)","금액","일수"]
[1,"홍길동",23001,7,4,0,0,0,2,4000000,{"$f":"ROUNDUP(J5/209,-1)","v":19140},{"$f":"ROUNDUP(D5*$K5*1.5,-1)","v":200970},114840,0,{"$f":"ROUNDUP(G5*$K5*2,-1)","v":0},0,{"$f":"SUM(L5:P5)","v":315810},0,{"$f":"ROUNDUP(R5*$K5*1.5,-1)","v":0},0]
[2,"가나다",23002,null,null,4,0,0,1,3866668,{"$f":"ROUNDUP(J6/209,-1)","v":18510},0,0,111060,0,0,{"$f":"SUM(L6:P6)","v":111060},null,{"$f":"ROUNDUP(R6*$K6*1.5,-1)","v":0}]
[3,"김김김",23003,null,null,6,0,0,1,2800000,{"$f":"ROUNDUP(J7/209,-1)","v":13400},0,0,120600,0,0,{"$f":"SUM(L7:P7)","v":120600},null,{"$f":"ROUNDUP(R7*$K7*1.5,-1)","v":0},1]
[4,"스티브",23004,3,4,null,null,null,1,2800000,{"$f":"ROUNDUP(J8/209,-1)","v":13400},60300,80400,0,0,0,{"$f":"SUM(L8:P8)","v":140700},4,{"$f":"ROUNDUP(R8*$K8*1.5,-1)","v":80400},1]

{"sheet":"급여테이블","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"지급월",0,0,0,"6,12","1,9","1,9",0,0]
["연 환산","직책(호봉)","기본급","직책수당","기술수당","정근수당","상여금","명절수당","식대","자가운전보조금"]
[33960000,1,1800000,null,null,1800000,1800000,180000,200000,200000]
[35580000,2,1900000,null,null,1900000,1900000,190000,200000,200000]
[37200000,3,2000000,null,null,2000000,2000000,200000,200000,200000]
[38820000,4,2100000,null,null,2100000,2100000,210000,200000,200000]
[40440000,5,2200000,null,null,2200000,2200000,220000,200000,200000]
[42060000,6,2300000,null,null,2300000,2300000,230000,200000,200000]
[43680000,7,2400000,null,null,2400000,2400000,240000,200000,200000]
[45300000,8,2500000,null,null,2500000,2500000,250000,200000,200000]
[46920000,9,2600000,null,null,2600000,2600000,260000,200000,200000]
[48540000,10,2700000,null,null,2700000,2700000,270000,200000,200000]
[36360000,"1(기)",1800000,null,200000,1800000,1800000,180000,200000,200000]
[37980000,"2(기)",1900000,null,200000,1900000,1900000,190000,200000,200000]
[39600000,"3(기)",2000000,null,200000,2000000,2000000,200000,200000,200000]
[41220000,"4(기)",2100000,null,200000,2100000,2100000,210000,200000,200000]
[42840000,"5(기)",2200000,null,200000,2200000,2200000,220000,200000,200000]

{"sheet":"사원명단","index":3,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["순번","성명","사번","직책","호봉(급여기준)"]
[1,"홍길동",23001,"대표",10]
[2,"가나다",23002,"팀장",9]
[3,"김김김",23003,"사원",1]
[4,"스티브",23004,"사원",1]