{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["給与台帳","使い方"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"給与台帳","index":0,"n_rows":37,"n_cols":63,"rows_kept":37,"merged":[[1,1,1,2],[1,4,2,18],[1,22,2,24],[1,25,2,26],[1,27,2,28],[1,29,2,30],[1,31,2,32],[1,47,2,47],[1,48,2,50],[1,51,2,51],[1,52,2,54],[1,55,2,55],[1,56,2,58],[1,59,2,59],[1,60,2,62],[2,1,2,2],[2,34,2,37],[2,39,2,42],[4,1,4,2],[4,3,4,8],[4,9,4,14],[4,15,4,20],[4,21,4,26],[4,27,4,32],[4,33,4,38],[4,39,4,44],[4,45,4,50],[4,51,4,56],[4,57,4,62],[5,1,5,2],[5,3,5,8],[5,9,5,14],[5,15,5,20],[5,21,5,26],[5,27,5,32],[5,33,5,38],[5,39,5,44],[5,45,5,50],[5,51,5,56],[5,57,5,62],[6,1,12,2],[7,6,7,7],[7,12,7,13],[7,18,7,19],[7,24,7,25],[7,30,7,31],[7,36,7,37],[7,42,7,43],[7,48,7,49],[7,54,7,55],[7,60,7,61],[8,6,8,7],[8,12,8,13],[8,18,8,19],[8,24,8,25],[8,30,8,31],[8,36,8,37],[8,42,8,43],[8,48,8,49],[8,54,8,55],[8,60,8,61],[9,6,9,7],[9,12,9,13],[9,18,9,19],[9,24,9,25],[9,30,9,31],[9,36,9,37],[9,42,9,43],[9,48,9,49],[9,54,9,55],[9,60,9,61],[11,4,11,5],[11,7,11,8],[11,10,11,11],[11,13,11,14],[11,16,11,17],[11,19,11,20],[11,22,11,23],[11,25,11,26],[11,28,11,29],[11,31,11,32],[11,34,11,35],[11,37,11,38],[11,40,11,41],[11,43,11,44],[11,46,11,47],[11,49,11,50],[11,52,11,53],[11,55,11,56],[11,58,11,59],[11,61,11,62],[12,4,12,5],[12,7,12,8],[12,10,12,11],[12,13,12,14],[12,16,12,17],[12,19,12,20],[12,22,12,23],[12,25,12,26],[12,28,12,29],[12,31,12,32],[12,34,12,35],[12,37,12,38],[12,40,12,41],[12,43,12,44],[12,46,12,47],[12,49,12,50],[12,52,12,53],[12,55,12,56],[12,58,12,59],[12,61,12,62],[13,1,21,1],[13,3,13,8],[13,9,13,14],[13,15,13,20],[13,21,13,26],[13,27,13,32],[13,33,13,38],[13,39,13,44],[13,45,13,50],[13,51,13,56],[13,57,13,62],[14,3,14,8],[14,9,14,14],[14,15,14,20],[14,21,14,26],[14,27,14,32],[14,33,14,38],[14,39,14,44],[14,45,14,50],[14,51,14,56],[14,57,14,62],[15,3,15,8],[15,9,15,14],[15,15,15,20],[15,21,15,26],[15,27,15,32],[15,33,15,38],[15,39,15,44],[15,45,15,50],[15,51,15,56],[15,57,15,62],[16,3,16,8],[16,9,16,14],[16,15,16,20],[16,21,16,26],[16,27,16,32],[16,33,16,38],[16,39,16,44],[16,45,16,50],[16,51,16,56],[16,57,16,62],[17,3,17,8],[17,9,17,14],[17,15,17,20],[17,21,17,26],[17,27,17,32],[17,33,17,38],[17,39,17,44],[17,45,17,50],[17,51,17,56],[17,57,17,62],[18,3,18,8],[18,9,18,14],[18,15,18,20],[18,21,18,26],[18,27,18,32],[18,33,18,38],[18,39,18,44],[18,45,18,50],[18,51,18,56],[18,57,18,62],[19,3,19,8],[19,9,19,14],[19,15,19,20],[19,21,19,26],[19,27,19,32],[19,33,19,38],[19,39,19,44],[19,45,19,50],[19,51,19,56],[19,57,19,62],[20,3,20,8],[20,9,20,14],[20,15,20,20],[20,21,20,26],[20,27,20,32],[20,33,20,38],[20,39,20,44],[20,45,20,50],[20,51,20,56],[20,57,20,62],[21,3,21,8],[21,9,21,14],[21,15,21,20],[21,21,21,26],[21,27,21,32],[21,33,21,38],[21,39,21,44],[21,45,21,50],[21,51,21,56],[21,57,21,62],[22,1,22,2],[22,3,22,8],[22,9,22,14],[22,15,22,20],[22,21,22,26],[22,27,22,32],[22,33,22,38],[22,39,22,44],[22,45,22,50],[22,51,22,56],[22,57,22,62],[23,1,26,1],[23,3,23,8],[23,9,23,14],[23,15,23,20],[23,21,23,26],[23,27,23,32],[23,33,23,38],[23,39,23,44],[23,45,23,50],[23,51,23,56],[23,57,23,62],[24,3,24,8],[24,9,24,14],[24,15,24,20],[24,21,24,26],[24,27,24,32],[24,33,24,38],[24,39,24,44],[24,45,24,50],[24,51,24,56],[24,57,24,62],[25,3,25,8],[25,9,25,14],[25,15,25,20],[25,21,25,26],[25,27,25,32],[25,33,25,38],[25,39,25,44],[25,45,25,50],[25,51,25,56],[25,57,25,62],[26,3,26,8],[26,9,26,14],[26,15,26,20],[26,21,26,26],[26,27,26,32],[26,33,26,38],[26,39,26,44],[26,45,26,50],[26,51,26,56],[26,57,26,62],[27,1,27,2],[27,3,27,8],[27,9,27,14],[27,15,27,20],[27,21,27,26],[27,27,27,32],[27,33,27,38],[27,39,27,44],[27,45,27,50],[27,51,27,56],[27,57,27,62],[28,1,34,1],[28,3,28,8],[28,9,28,14],[28,15,28,20],[28,21,28,26],[28,27,28,32],[28,33,28,38],[28,39,28,44],[28,45,28,50],[28,51,28,56],[28,57,28,62],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,26],[29,27,29,28],[29,29,29,30],[29,31,29,32],[29,33,29,34],[29,35,29,36],[29,37,29,38],[29,39,29,40],[29,41,29,42],[29,43,29,44],[29,45,29,46],[29,47,29,48],[29,49,29,50],[29,51,29,52],[29,53,29,54],[29,55,29,56],[29,57,29,58],[29,59,29,60],[29,61,29,62],[30,3,30,8],[30,9,30,14],[30,15,30,20],[30,21,30,26],[30,27,30,32],[30,33,30,38],[30,39,30,44],[30,45,30,50],[30,51,30,56],[30,57,30,62],[31,3,31,8],[31,9,31,14],[31,15,31,20],[31,21,31,26],[31,27,31,32],[31,33,31,38],[31,39,31,44],[31,45,31,50],[31,51,31,56],[31,57,31,62],[32,3,32,8],[32,9,32,14],[32,15,32,20],[32,21,32,26],[32,27,32,32],[32,33,32,38],[32,39,32,44],[32,45,32,50],[32,51,32,56],[32,57,32,62],[33,3,33,8],[33,9,33,14],[33,15,33,20],[33,21,33,26],[33,27,33,32],[33,33,33,38],[33,39,33,44],[33,45,33,50],[33,51,33,56],[33,57,33,62],[34,3,34,8],[34,9,34,14],[34,15,34,20],[34,21,34,26],[34,27,34,32],[34,33,34,38],[34,39,34,44],[34,45,34,50],[34,51,34,56],[34,57,34,62],[35,1,35,2],[35,3,35,8],[35,9,35,14],[35,15,35,20],[35,21,35,26],[35,27,35,32],[35,33,35,38],[35,39,35,44],[35,45,35,50],[35,51,35,56],[35,57,35,62],[36,1,36,2],[36,3,36,8],[36,9,36,14],[36,15,36,20],[36,21,36,26],[36,27,36,32],[36,33,36,38],[36,39,36,44],[36,45,36,50],[36,51,36,56],[36,57,36,62]]}
[]
[null,"支給日",null,null,"給与台帳",{"$nulls":17},"令和",{"$nulls":4},"年",{"$nulls":3},"月分",{"$nulls":15},"承認印",{"$nulls":3},"承認印",{"$nulls":3},"検印",{"$nulls":3},"係印"]
[{"$nulls":38},"部",{"$nulls":4},"課"]
[]
[null,"社員番号"]
[null,"氏名"]
[null,"勤務状態",null,"出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日"]
[{"$nulls":3},"遅刻",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,"分"]
[{"$nulls":3},"早退",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,"分"]
[{"$nulls":3},"休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間"]
[{"$nulls":3},"有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日"]
[{"$nulls":3},"残業",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,null,"時間",null,null,"残業",null,null,"時間"]
[{"$nulls":3},"深夜",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,null,"時間",null,null,"深夜",null,null,"時間"]
[null,"支給内訳","基本給"]
[null,null,"職務手当"]
[null,null,"皆勤手当"]
[null,null,"家族手当"]
[null,null,"残業手当",{"$f":"E12*H12","v":0},{"$nulls":5},{"$f":"K12*N12","v":0},{"$nulls":5},{"$f":"Q12*T12","v":0},{"$nulls":5},{"$f":"W12*Z12","v":0},{"$nulls":5},{"$f":"AC12*AF12","v":0},{"$nulls":5},{"$f":"AI12*AL12","v":0},{"$nulls":5},{"$f":"AO12*AR12","v":0},{"$nulls":5},{"$f":"AU12*AX12","v":0},{"$nulls":5},{"$f":"BA12*BD12","v":0},{"$nulls":5},{"$f":"BG12*BJ12","v":0}]
[null,null,"深夜手当",{"$f":"E13*H13","v":0},{"$nulls":5},{"$f":"K13*N13","v":0},{"$nulls":5},{"$f":"Q13*T13","v":0},{"$nulls":5},{"$f":"W13*Z13","v":0},{"$nulls":5},{"$f":"AC13*AF13","v":0},{"$nulls":5},{"$f":"AI13*AL13","v":0},{"$nulls":5},{"$f":"AO13*AR13","v":0},{"$nulls":5},{"$f":"AU13*AX13","v":0},{"$nulls":5},{"$f":"BA13*BD13","v":0},{"$nulls":5},{"$f":"BG13*BJ13","v":0}]
[]
[]
[]
[null,"①\n総支給額",null,{"$f":"SUM(D14:I22)","v":0},{"$nulls":5},{"$f":"SUM(J14:O22)","v":0},{"$nulls":5},{"$f":"SUM(P14:U22)","v":0},{"$nulls":5},{"$f":"SUM(V14:AA22)","v":0},{"$nulls":5},{"$f":"SUM(AB14:AG22)","v":0},{"$nulls":5},{"$f":"SUM(AH14:AM22)","v":0},{"$nulls":5},{"$f":"SUM(AN14:AS22)","v":0},{"$nulls":5},{"$f":"SUM(AT14:AY22)","v":0},{"$nulls":5},{"$f":"SUM(AZ14:BE22)","v":0},{"$nulls":5},{"$f":"SUM(BF14:BK22)","v":0}]
[null,"社会保険控除額","健康保険"]
[null,null,"厚生年金保険"]
[null,null,"雇用保険"]
[null,null,"②\n保険料合計",{"$f":"SUM(D24:I26)","v":0},{"$nulls":5},{"$f":"SUM(J24:O26)","v":0},{"$nulls":5},{"$f":"SUM(P24:U26)","v":0},{"$nulls":5},{"$f":"SUM(V24:AA26)","v":0},{"$nulls":5},{"$f":"SUM(AB24:AG26)","v":0},{"$nulls":5},{"$f":"SUM(AH24:AM26)","v":0},{"$nulls":5},{"$f":"SUM(AN24:AS26)","v":0},{"$nulls":5},{"$f":"SUM(AT24:AY26)","v":0},{"$nulls":5},{"$f":"SUM(AZ24:BE26)","v":0},{"$nulls":5},{"$f":"SUM(BF24:BK26)","v":0}]
[null,"③社会保険料控除後の金額\n①－②",null,{"$f":"D23-D27","v":0},{"$nulls":5},{"$f":"J23-J27","v":0},{"$nulls":5},{"$f":"P23-P27","v":0},{"$nulls":5},{"$f":"V23-V27","v":0},{"$nulls":5},{"$f":"AB23-AB27","v":0},{"$nulls":5},{"$f":"AH23-AH27","v":0},{"$nulls":5},{"$f":"AN23-AN27","v":0},{"$nulls":5},{"$f":"AT23-AT27","v":0},{"$nulls":5},{"$f":"AZ23-AZ27","v":0},{"$nulls":5},{"$f":"BF23-BF27","v":0}]
[null,"控除金額額内訳","所得税"]
[null,null,"（扶養     人)","(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)"]
[null,null,"市町村民税"]
[]
[]
[]
[null,null,"④\n控除額計",{"$f":"SUM(D29,D31:I34)","v":0},{"$nulls":5},{"$f":"SUM(J29,J31:O34)","v":0},{"$nulls":5},{"$f":"SUM(P29,P31:U34)","v":0},{"$nulls":5},{"$f":"SUM(V29,V31:AA34)","v":0},{"$nulls":5},{"$f":"SUM(AB29,AB31:AG34)","v":0},{"$nulls":5},{"$f":"SUM(AH29,AH31:AM34)","v":0},{"$nulls":5},{"$f":"SUM(AN29,AN31:AS34)","v":0},{"$nulls":5},{"$f":"SUM(AT29,AT31:AY34)","v":0},{"$nulls":5},{"$f":"SUM(AZ29,AZ31:BE34)","v":0},{"$nulls":5},{"$f":"SUM(BF29,BF31:BK34)","v":0}]
[null,"⑤\n出張手当等の非課税給"]
[null,"差引支給額\n③－④＋⑤",null,{"$f":"D28-D35+D36","v":0},{"$nulls":5},{"$f":"J28-J35+J36","v":0},{"$nulls":5},{"$f":"P28-P35+P36","v":0},{"$nulls":5},{"$f":"V28-V35+V36","v":0},{"$nulls":5},{"$f":"AB28-AB35+AB36","v":0},{"$nulls":5},{"$f":"AH28-AH35+AH36","v":0},{"$nulls":5},{"$f":"AN28-AN35+AN36","v":0},{"$nulls":5},{"$f":"AT28-AT35+AT36","v":0},{"$nulls":5},{"$f":"AZ28-AZ35+AZ36","v":0},{"$nulls":5},{"$f":"BF28-BF35+BF36","v":0}]

{"sheet":"使い方","index":1,"n_rows":37,"n_cols":63,"rows_kept":37,"merged":[[1,1,1,2],[1,4,2,18],[1,22,2,24],[1,25,2,26],[1,27,2,28],[1,29,2,30],[1,31,2,32],[1,47,2,47],[1,48,2,50],[1,51,2,51],[1,52,2,54],[1,55,2,55],[1,56,2,58],[1,59,2,59],[1,60,2,62],[2,1,2,2],[2,34,2,37],[2,39,2,42],[4,1,4,2],[4,3,4,8],[4,9,4,14],[4,15,4,20],[4,21,4,26],[4,27,4,32],[4,33,4,38],[4,39,4,44],[4,45,4,50],[4,51,4,56],[4,57,4,62],[5,1,5,2],[5,3,5,8],[5,9,5,14],[5,15,5,20],[5,21,5,26],[5,27,5,32],[5,33,5,38],[5,39,5,44],[5,45,5,50],[5,51,5,56],[5,57,5,62],[6,1,12,2],[7,6,7,7],[7,12,7,13],[7,18,7,19],[7,24,7,25],[7,30,7,31],[7,36,7,37],[7,42,7,43],[7,48,7,49],[7,54,7,55],[7,60,7,61],[8,6,8,7],[8,12,8,13],[8,18,8,19],[8,24,8,25],[8,30,8,31],[8,36,8,37],[8,42,8,43],[8,48,8,49],[8,54,8,55],[8,60,8,61],[9,6,9,7],[9,12,9,13],[9,18,9,19],[9,24,9,25],[9,30,9,31],[9,36,9,37],[9,42,9,43],[9,48,9,49],[9,54,9,55],[9,60,9,61],[11,4,11,5],[11,7,11,8],[11,13,11,14],[11,19,11,20],[11,25,11,26],[11,31,11,32],[11,37,11,38],[11,43,11,44],[11,49,11,50],[11,55,11,56],[11,61,11,62],[12,4,12,5],[12,7,12,8],[12,13,12,14],[12,19,12,20],[12,25,12,26],[12,31,12,32],[12,37,12,38],[12,43,12,44],[12,49,12,50],[12,55,12,56],[12,61,12,62],[13,1,21,1],[13,3,13,8],[13,9,13,14],[13,15,13,20],[13,21,13,26],[13,27,13,32],[13,33,13,38],[13,39,13,44],[13,45,13,50],[13,51,13,56],[13,57,13,62],[14,3,14,8],[14,9,14,14],[14,15,14,20],[14,21,14,26],[14,27,14,32],[14,33,14,38],[14,39,14,44],[14,45,14,50],[14,51,14,56],[14,57,14,62],[15,3,15,8],[15,9,15,14],[15,15,15,20],[15,21,15,26],[15,27,15,32],[15,33,15,38],[15,39,15,44],[15,45,15,50],[15,51,15,56],[15,57,15,62],[16,3,16,8],[16,9,16,14],[16,15,16,20],[16,21,16,26],[16,27,16,32],[16,33,16,38],[16,39,16,44],[16,45,16,50],[16,51,16,56],[16,57,16,62],[17,3,17,8],[17,9,17,14],[17,15,17,20],[17,21,17,26],[17,27,17,32],[17,33,17,38],[17,39,17,44],[17,45,17,50],[17,51,17,56],[17,57,17,62],[18,3,18,8],[18,9,18,14],[18,15,18,20],[18,21,18,26],[18,27,18,32],[18,33,18,38],[18,39,18,44],[18,45,18,50],[18,51,18,56],[18,57,18,62],[19,3,19,8],[19,9,19,14],[19,15,19,20],[19,21,19,26],[19,27,19,32],[19,33,19,38],[19,39,19,44],[19,45,19,50],[19,51,19,56],[19,57,19,62],[20,3,20,8],[20,9,20,14],[20,15,20,20],[20,21,20,26],[20,27,20,32],[20,33,20,38],[20,39,20,44],[20,45,20,50],[20,51,20,56],[20,57,20,62],[21,3,21,8],[21,9,21,14],[21,15,21,20],[21,21,21,26],[21,27,21,32],[21,33,21,38],[21,39,21,44],[21,45,21,50],[21,51,21,56],[21,57,21,62],[22,1,22,2],[22,3,22,8],[22,9,22,14],[22,15,22,20],[22,21,22,26],[22,27,22,32],[22,33,22,38],[22,39,22,44],[22,45,22,50],[22,51,22,56],[22,57,22,62],[23,1,26,1],[23,3,23,8],[23,9,23,14],[23,15,23,20],[23,21,23,26],[23,27,23,32],[23,33,23,38],[23,39,23,44],[23,45,23,50],[23,51,23,56],[23,57,23,62],[24,3,24,8],[24,9,24,14],[24,15,24,20],[24,21,24,26],[24,27,24,32],[24,33,24,38],[24,39,24,44],[24,45,24,50],[24,51,24,56],[24,57,24,62],[25,3,25,8],[25,9,25,14],[25,15,25,20],[25,21,25,26],[25,27,25,32],[25,33,25,38],[25,39,25,44],[25,45,25,50],[25,51,25,56],[25,57,25,62],[26,3,26,8],[26,9,26,14],[26,15,26,20],[26,21,26,26],[26,27,26,32],[26,33,26,38],[26,39,26,44],[26,45,26,50],[26,51,26,56],[26,57,26,62],[27,1,27,2],[27,3,27,8],[27,9,27,14],[27,15,27,20],[27,21,27,26],[27,27,27,32],[27,33,27,38],[27,39,27,44],[27,45,27,50],[27,51,27,56],[27,57,27,62],[28,1,34,1],[28,3,28,8],[28,9,28,14],[28,15,28,20],[28,21,28,26],[28,27,28,32],[28,33,28,38],[28,39,28,44],[28,45,28,50],[28,51,28,56],[28,57,28,62],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,26],[29,27,29,28],[29,29,29,30],[29,31,29,32],[29,33,29,34],[29,35,29,36],[29,37,29,38],[29,39,29,40],[29,41,29,42],[29,43,29,44],[29,45,29,46],[29,47,29,48],[29,49,29,50],[29,51,29,52],[29,53,29,54],[29,55,29,56],[29,57,29,58],[29,59,29,60],[29,61,29,62],[30,3,30,8],[30,9,30,14],[30,15,30,20],[30,21,30,26],[30,27,30,32],[30,33,30,38],[30,39,30,44],[30,45,30,50],[30,51,30,56],[30,57,30,62],[31,3,31,8],[31,9,31,14],[31,15,31,20],[31,21,31,26],[31,27,31,32],[31,33,31,38],[31,39,31,44],[31,45,31,50],[31,51,31,56],[31,57,31,62],[32,3,32,8],[32,9,32,14],[32,15,32,20],[32,21,32,26],[32,27,32,32],[32,33,32,38],[32,39,32,44],[32,45,32,50],[32,51,32,56],[32,57,32,62],[33,3,33,8],[33,9,33,14],[33,15,33,20],[33,21,33,26],[33,27,33,32],[33,33,33,38],[33,39,33,44],[33,45,33,50],[33,51,33,56],[33,57,33,62],[34,3,34,8],[34,9,34,14],[34,15,34,20],[34,21,34,26],[34,27,34,32],[34,33,34,38],[34,39,34,44],[34,45,34,50],[34,51,34,56],[34,57,34,62],[35,1,35,2],[35,3,35,8],[35,9,35,14],[35,15,35,20],[35,21,35,26],[35,27,35,32],[35,33,35,38],[35,39,35,44],[35,45,35,50],[35,51,35,56],[35,57,35,62],[36,1,36,2],[36,3,36,8],[36,9,36,14],[36,15,36,20],[36,21,36,26],[36,27,36,32],[36,33,36,38],[36,39,36,44],[36,45,36,50],[36,51,36,56],[36,57,36,62]]}
[]
[null,"支給日",null,null,"給与台帳",{"$nulls":17},"令和",null,null,16,null,"年",null,4,null,"月分",{"$nulls":15},"承認印",{"$nulls":3},"承認印",{"$nulls":3},"検印",{"$nulls":3},"係印"]
[null,"2020-05-25",{"$nulls":32},"営業",{"$nulls":3},"部","営業１",{"$nulls":3},"課"]
[]
[null,"社員番号",null,1001,{"$nulls":5},1002]
[null,"氏名",null,"阿部　信夫",{"$nulls":5},"古田　典夫"]
[null,"勤務状態",null,"出勤",20,"日","欠勤",2,"日","出勤",21,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日","出勤",null,"日","欠勤",null,"日"]
[{"$nulls":3},"遅刻",1,"回",15,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,"分"]
[{"$nulls":3},"早退",2,"回",120,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,"分"]
[{"$nulls":3},"休日\n出勤",1,"日",3.5,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間","休日\n出勤",null,"日",null,null,"時間"]
[{"$nulls":3},"有給\n休暇",1,"日","残",12,"日","有給\n休暇",2,"日","残",11,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日","有給\n休暇",null,"日","残",null,"日"]
[{"$nulls":3},"残業",8,null,"時間",{"v":2500,"d":"@2,500"},null,"残業",null,"時間","@",{"v":2250,"d":"2,250 "},null,"残業",null,"時間","@",null,null,"残業",null,"時間","@",null,null,"残業",null,"時間","@",null,null,"残業",null,"時間","@",null,null,"残業",null,"時間","@",null,null,"残業",null,"時間","@",null,null,"残業",null,"時間","@",null,null,"残業",null,"時間","@"]
[{"$nulls":3},"深夜",2,null,"時間",{"v":2750,"d":"@2,750"},null,"深夜",null,"時間","@",{"v":2500,"d":"2,500 "},null,"深夜",null,"時間","@",null,null,"深夜",null,"時間","@",null,null,"深夜",null,"時間","@",null,null,"深夜",null,"時間","@",null,null,"深夜",null,"時間","@",null,null,"深夜",null,"時間","@",null,null,"深夜",null,"時間","@",null,null,"深夜",null,"時間","@"]
[null,"支給内訳","基本給",{"v":250000,"d":"250,000"},{"$nulls":5},{"v":230000,"d":"230,000"}]
[null,null,"職務手当"]
[null,null,"皆勤手当",{"$nulls":6},{"v":10000,"d":"10,000"}]
[null,null,"家族手当",{"v":20000,"d":"20,000"}]
[null,null,"残業手当",{"$f":"E12*H12","v":{"v":20000,"d":"20,000"}},{"$nulls":5},{"$f":"K12*N12","v":0}]
[null,null,"深夜手当",{"$f":"E13*H13","v":{"v":5500,"d":"5,500"}},{"$nulls":5},{"$f":"K13*N13","v":0}]
[]
[]
[]
[null,"①\n総支給額",null,{"$f":"SUM(D14:I22)","v":{"v":295500,"d":"295,500"}},{"$nulls":5},{"$f":"SUM(J14:O22)","v":{"v":240000,"d":"240,000"}},{"$nulls":5},{"$f":"SUM(P14:U22)","v":0},{"$nulls":5},{"$f":"SUM(V14:AA22)","v":0},{"$nulls":5},{"$f":"SUM(AB14:AG22)","v":0},{"$nulls":5},{"$f":"SUM(AH14:AM22)","v":0},{"$nulls":5},{"$f":"SUM(AN14:AS22)","v":0},{"$nulls":5},{"$f":"SUM(AT14:AY22)","v":0},{"$nulls":5},{"$f":"SUM(AZ14:BE22)","v":0},{"$nulls":5},{"$f":"SUM(BF14:BK22)","v":0}]
[null,"社会保険控除額","健康保険",{"v":12000,"d":"12,000"},{"$nulls":5},{"v":10000,"d":"10,000"}]
[null,null,"厚生年金保険",{"v":25000,"d":"25,000"},{"$nulls":5},{"v":23000,"d":"23,000"}]
[null,null,"雇用保険",{"v":2000,"d":"2,000"},{"$nulls":5},{"v":1500,"d":"1,500"}]
[null,null,"②\n保険料合計",{"$f":"SUM(D24:I26)","v":{"v":39000,"d":"39,000"}},{"$nulls":5},{"$f":"SUM(J24:O26)","v":{"v":34500,"d":"34,500"}},{"$nulls":5},{"$f":"SUM(P24:U26)","v":0},{"$nulls":5},{"$f":"SUM(V24:AA26)","v":0},{"$nulls":5},{"$f":"SUM(AB24:AG26)","v":0},{"$nulls":5},{"$f":"SUM(AH24:AM26)","v":0},{"$nulls":5},{"$f":"SUM(AN24:AS26)","v":0},{"$nulls":5},{"$f":"SUM(AT24:AY26)","v":0},{"$nulls":5},{"$f":"SUM(AZ24:BE26)","v":0},{"$nulls":5},{"$f":"SUM(BF24:BK26)","v":0}]
[null,"③社会保険料控除後の金額\n①－②",null,{"$f":"D23-D27","v":{"v":256500,"d":"256,500"}},{"$nulls":5},{"$f":"J23-J27","v":{"v":205500,"d":"205,500"}},{"$nulls":5},{"$f":"P23-P27","v":0},{"$nulls":5},{"$f":"V23-V27","v":0},{"$nulls":5},{"$f":"AB23-AB27","v":0},{"$nulls":5},{"$f":"AH23-AH27","v":0},{"$nulls":5},{"$f":"AN23-AN27","v":0},{"$nulls":5},{"$f":"AT23-AT27","v":0},{"$nulls":5},{"$f":"AZ23-AZ27","v":0},{"$nulls":5},{"$f":"BF23-BF27","v":0}]
[null,"控除金額額内訳","所得税",{"v":11000,"d":"11,000"},{"$nulls":5},{"v":8000,"d":"8,000"}]
[null,null,"（扶養     人)","(扶養",null,{"v":2,"d":"2 "},null,"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)",null,"(扶養",{"$nulls":3},"人)"]
[null,null,"市町村民税",{"v":8000,"d":"8,000"},{"$nulls":5},{"v":6500,"d":"6,500"}]
[]
[]
[]
[null,null,"④\n控除額計",{"$f":"SUM(D29,D31:I34)","v":{"v":19000,"d":"19,000"}},{"$nulls":5},{"$f":"SUM(J29,J31:O34)","v":{"v":14500,"d":"14,500"}},{"$nulls":5},{"$f":"SUM(P29,P31:U34)","v":0},{"$nulls":5},{"$f":"SUM(V29,V31:AA34)","v":0},{"$nulls":5},{"$f":"SUM(AB29,AB31:AG34)","v":0},{"$nulls":5},{"$f":"SUM(AH29,AH31:AM34)","v":0},{"$nulls":5},{"$f":"SUM(AN29,AN31:AS34)","v":0},{"$nulls":5},{"$f":"SUM(AT29,AT31:AY34)","v":0},{"$nulls":5},{"$f":"SUM(AZ29,AZ31:BE34)","v":0},{"$nulls":5},{"$f":"SUM(BF29,BF31:BK34)","v":0}]
[null,"⑤\n出張手当等の非課税給",null,{"v":5000,"d":"5,000"}]
[null,"差引支給額\n③－④＋⑤",null,{"$f":"D28-D35+D36","v":{"v":242500,"d":"242,500"}},{"$nulls":5},{"$f":"J28-J35+J36","v":{"v":191000,"d":"191,000"}},{"$nulls":5},{"$f":"P28-P35+P36","v":0},{"$nulls":5},{"$f":"V28-V35+V36","v":0},{"$nulls":5},{"$f":"AB28-AB35+AB36","v":0},{"$nulls":5},{"$f":"AH28-AH35+AH36","v":0},{"$nulls":5},{"$f":"AN28-AN35+AN36","v":0},{"$nulls":5},{"$f":"AT28-AT35+AT36","v":0},{"$nulls":5},{"$f":"AZ28-AZ35+AZ36","v":0},{"$nulls":5},{"$f":"BF28-BF35+BF36","v":0}]