{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["シミュレーションシート","入力","計算シート","期間①","期間②","期間③","期間④"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"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":100,"n_cols":31,"rows_kept":100,"cut":false,"hidden":false,"merged":[[79,1,80,10],[61,1,62,10],[63,1,64,10],[65,1,66,10],[61,11,62,16],[81,23,82,27],[65,23,66,27],[67,23,68,27],[81,11,82,16],[81,17,82,22],[67,1,68,10],[69,1,70,10],[67,11,68,16],[79,11,80,16],[79,17,80,22],[79,23,80,27],[71,11,72,16],[61,23,62,27],[63,23,64,27],[65,11,66,16],[69,17,72,27],[97,1,98,10],[99,1,100,10],[63,17,64,22],[65,17,66,22],[67,17,68,22],[81,1,84,3],[81,4,82,10],[83,4,84,10],[85,1,88,3],[85,4,86,10],[87,4,88,10],[89,1,92,3],[89,4,90,10],[89,11,90,16],[89,17,90,22],[91,4,92,10],[91,11,92,16],[91,17,92,22],[69,11,70,16],[71,1,72,10],[93,1,96,3],[93,4,94,10],[93,11,94,16],[95,4,96,10],[13,9,13,27],[13,1,15,2],[14,3,15,8],[13,3,13,8],[16,1,17,8],[16,9,17,27],[24,1,26,8],[23,1,23,8],[19,1,20,8],[21,1,22,8],[24,9,26,27],[23,9,23,27],[19,9,20,27],[14,9,15,27],[21,9,22,27],[18,1,18,8],[18,9,18,27],[99,23,100,27],[83,23,84,27],[85,23,86,27],[85,11,86,16],[87,11,88,16],[97,11,98,16],[99,11,100,16],[85,17,86,22],[87,17,88,22],[97,17,98,22],[99,17,100,22],[91,23,92,27],[97,23,98,27],[87,23,88,27],[83,11,84,16],[83,17,84,22],[89,23,90,27],[93,17,94,22],[93,23,94,27],[95,11,96,16],[95,17,96,22],[95,23,96,27],[39,11,40,16],[41,1,42,10],[41,11,42,16],[49,1,50,7],[53,15,54,16],[51,1,54,7],[61,17,62,22],[59,11,60,16],[63,11,64,16],[51,17,52,20],[53,17,54,20],[51,15,52,16],[51,8,52,14],[59,17,60,22],[51,23,52,25],[59,23,60,27],[49,23,50,26],[39,17,40,22],[39,23,40,27],[41,17,42,22],[41,23,42,27],[49,17,50,20],[45,1,46,10],[45,11,46,16],[45,17,46,22],[45,23,46,27],[43,1,44,10],[43,11,44,16],[43,17,44,22],[43,23,44,27],[49,10,50,11],[49,8,50,9],[53,8,54,14],[59,1,60,10],[49,12,50,15],[49,16,50,16],[49,21,50,21],[39,1,40,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"育\n休",null,"取得可能期間",null,null,null,null,null,"最長で子の３歳の誕生日の前日まで【注】"]
[null,null,null,"取得回数",null,null,null,null,null,"①１人の子につき原則２回まで\n②①に加えて、出生から57日以内に２回まで（いわゆる「産後パパ育休」）。"]
[]
[null,"給与（給料及び諸手当）",null,null,null,null,null,null,null,"休業期間中は無給（給料及び一部手当は、月途中での休業開始又は復職の場合、日割計算）"]
[]
[null,"通勤手当",null,null,null,null,null,null,null,"月の初日から末日までの全期間にわたって通勤がない場合、当該月は不支給"]
[null,"期末・勤勉手当",null,null,null,null,null,null,null,"基準日（６月１日又は12月１日）以前６か月以内に勤務した期間がある場合に、その期間に応じて支給（期末手当は休業期間を２分の１除算。勤勉手当は休業期間を全期間除算。ただし、休業の承認期間が１か月以下の場合には、除算なし。）"]
[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,null,null,null,null,null,null,null,null,null,null,null,"「マクロを有効」にできない場合は、「入力」シートに必要事項を入力してください。"]
[]
[null,"社会保険料（共済短期掛金、厚生年金保険料、退職等年金掛金、介護掛金等）",null,null,null,null,null,null,null,"申出により、休業期間中は免除\n※共済組合に係る掛金の免除は次のとおり\n　○例月給与分（①育児休業期間に月末日を含む場合又は②同一月内かつ14日間以上\n　　　　　　　　の育児休業の場合　は当該月が免除）\n　○期末手当分（育児休業期間中に支給月の末日を含み、かつ期間が１か月と１日以\n　　　　　　　　上ある場合　は当該月は免除）"]
[null,"育児休業手当金（共済）",null,null,null,null,null,null,null,"子の１歳（パパママ育休プラス適用の場合は１歳2か月、保育所に入所できない場合等は最長２歳）の誕生日の前日まで、標準報酬日額の50％（休業期間が180日に達するまでの期間については67％（地方公務員共済組合法第70条の2第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,{"$f":"L68","v":176729.72727272726},null,null,null,null,null,{"$f":"R68","v":173550},null,null,null,null,null,{"$f":"R42-L42","v":-3179.7272727272648}]
[]
[null,"期末・勤勉手当影響額",null,null,null,null,null,null,null,null,null,{"$f":"L98","v":2355084},null,null,null,null,null,{"$f":"R98","v":2355084},null,null,null,null,null,{"$f":"R44-L44","v":0}]
[]
[null,"合計",null,null,null,null,null,null,null,null,null,{"$f":"L42+L44","v":2531813.7272727271},null,null,null,null,null,{"$f":"R42+R44","v":2528634},null,null,null,null,null,{"$f":"R46-L46","v":-3179.7272727270611}]
[]
[]
[]
[null,"育休取得期間",null,null,null,null,null,null,{"$f":"IF(入力!K30>入力!AB30,\"error\",IF(入力!K30=\"\",\"\",計算シート!K6))","v":21},null,"日間（",null,{"$f":"IF(入力!K30=\"\",\"\",入力!K30)","v":"2023-12-27"},null,null,null,"～",{"$f":"IF(入力!AB30=\"\",\"\",入力!AB30)","v":"2024-01-16"},null,null,null,"）",null,"手当金の支給対象日数"]
[]
[null,"育児休業手当金支給額",null,null,null,null,null,null,"育休１～180日まで",null,null,null,null,null,null,"日額",null,{"$f":"計算シート!K28","v":11570},null,null,null,null,null,{"$f":"IF(入力!K30>入力!AB30,\"error\",IF(入力!K30=\"\",\"\",計算シート!K9))","v":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,null,null,null,null,null,"育休180日～",null,null,null,null,null,null,"日額",null,{"$f":"計算シート!K33","v":8635}]
[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,null,null,null,null,{"$f":"計算シート!F27+計算シート!F28","v":232592.72727272726},null,null,null,null,null,0,null,null,null,null,null,{"$f":"計算シート!H27+計算シート!H28","v":-232592.72727272726}]
[]
[null,"（支給額）育児休業手当金",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"計算シート!G29","v":173550},null,null,null,null,null,{"$f":"計算シート!H29","v":173550}]
[]
[null,"（控除額）社会保険料",null,null,null,null,null,null,null,null,null,{"$f":"計算シート!F30","v":-55863},null,null,null,null,null,{"$f":"計算シート!G30","v":0},null,null,null,null,null,{"$f":"計算シート!H30","v":55863}]
[]
[null,"合計",null,null,null,null,null,null,null,null,null,{"$f":"計算シート!F33","v":176729.72727272726},null,null,null,null,null,{"$f":"計算シート!G33","v":173550},null,null,null,null,null,{"$f":"計算シート!H33","v":-3179.7272727272648}]
[]
[null,"（参考）所得税額",null,null,null,null,null,null,null,null,null,{"$f":"計算シート!F31","v":0},null,null,null,null,null,"※下記＜税金関係＞参照"]
[]
[null,"（参考）住民税額",null,null,null,null,null,null,null,null,null,{"$f":"計算シート!F32","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"項目",null,null,null,null,null,null,null,null,null,"育休を取得しない場合",null,null,null,null,null,"育休を取得した場合",null,null,null,null,null,"差額"]
[]
[null,{"$f":"計算シート!B37","v":"期間① 2023年6月支給時"},null,null,"（支給額）期末・勤勉手当金",null,null,null,null,null,null,{"$f":"計算シート!F37","v":690207},null,null,null,null,null,{"$f":"計算シート!G37","v":690207},null,null,null,null,null,{"$f":"計算シート!H37","v":0}]
[]
[null,null,null,null,"（控除額）社会保険料",null,null,null,null,null,null,{"$f":"計算シート!F38","v":-101436},null,null,null,null,null,{"$f":"計算シート!G38","v":-101436},null,null,null,null,null,{"$f":"計算シート!H38","v":0}]
[]
[null,{"$f":"計算シート!B40","v":"期間② 2023年12月支給時"},null,null,"（支給額）期末・勤勉手当金",null,null,null,null,null,null,{"$f":"計算シート!F40","v":690207},null,null,null,null,null,{"$f":"計算シート!G40","v":690207},null,null,null,null,null,{"$f":"計算シート!H40","v":0}]
[]
[null,null,null,null,"（控除額）社会保険料",null,null,null,null,null,null,{"$f":"計算シート!F41","v":-101436},null,null,null,null,null,{"$f":"計算シート!G41","v":-101436},null,null,null,null,null,{"$f":"計算シート!H41","v":0}]
[]
[null,{"$f":"計算シート!B43","v":"期間③ 2024年6月支給時"},null,null,"（支給額）期末・勤勉手当金",null,null,null,null,null,null,{"$f":"計算シート!F43","v":690207},null,null,null,null,null,{"$f":"計算シート!G43","v":690207},null,null,null,null,null,{"$f":"計算シート!H43","v":0}]
[]
[null,null,null,null,"（控除額）社会保険料",null,null,null,null,null,null,{"$f":"計算シート!F44","v":-101436},null,null,null,null,null,{"$f":"計算シート!G44","v":-101436},null,null,null,null,null,{"$f":"計算シート!H44","v":0}]
[]
[null,{"$f":"計算シート!B46","v":"期間④ 2024年12月支給時"},null,null,"（支給額）期末・勤勉手当金",null,null,null,null,null,null,{"$f":"計算シート!F46","v":690207},null,null,null,null,null,{"$f":"計算シート!G46","v":690207},null,null,null,null,null,{"$f":"計算シート!H46","v":0}]
[]
[null,null,null,null,"（控除額）社会保険料",null,null,null,null,null,null,{"$f":"計算シート!F47","v":-101436},null,null,null,null,null,{"$f":"計算シート!G47","v":-101436},null,null,null,null,null,{"$f":"計算シート!H47","v":0}]
[]
[null,"合計",null,null,null,null,null,null,null,null,null,{"$f":"計算シート!F49","v":2355084},null,null,null,null,null,{"$f":"計算シート!G49","v":2355084},null,null,null,null,null,{"$f":"計算シート!H49","v":0}]
[]
[null,"（参考）所得税額（期間中の合計額）",null,null,null,null,null,null,null,null,null,{"$f":"計算シート!F50","v":0},null,null,null,null,null,{"$f":"計算シート!G50","v":0},null,null,null,null,null,"ー"]

{"sheet":"入力","index":1,"n_rows":30,"n_cols":85,"rows_kept":30,"cut":false,"hidden":false,"merged":[[19,7,19,10],[19,11,19,13],[19,14,19,16],[19,17,19,20],[19,21,19,24],[16,84,17,89],[16,78,17,83],[18,51,18,53],[18,54,18,57],[16,43,16,44],[16,60,16,63],[16,64,16,67],[16,40,16,42],[18,58,18,61],[18,62,18,64],[18,65,18,67],[18,40,18,42],[18,43,18,46],[18,47,18,50],[17,48,17,51],[16,38,16,39],[16,1,16,3],[16,4,16,6],[16,7,16,8],[16,9,16,17],[16,21,16,22],[16,24,16,27],[18,25,18,28],[18,29,18,31],[18,32,18,35],[16,28,16,30],[16,31,16,33],[16,34,16,37],[18,1,18,5],[18,7,18,10],[18,11,18,13],[18,14,18,16],[18,17,18,20],[18,21,18,24],[18,36,18,39],[6,38,6,40],[6,41,6,43],[22,68,22,70],[6,1,6,3],[6,4,6,6],[6,7,6,8],[6,9,6,16],[6,20,6,21],[6,23,6,25],[6,26,6,28],[8,1,8,3],[8,4,8,6],[8,28,8,29],[6,29,6,31],[6,32,6,34],[6,35,6,37],[12,1,12,2],[12,21,12,22],[12,43,12,44],[16,68,16,70],[16,56,16,59],[20,1,20,4],[20,5,20,7],[6,48,6,51],[6,52,6,54],[6,55,6,57],[6,58,6,60],[6,61,6,63],[6,64,6,65],[7,64,7,65],[8,64,8,65],[22,43,22,44],[22,65,22,67],[16,45,16,46],[16,48,16,51],[16,52,16,55],[17,52,17,55],[12,65,12,67],[10,8,10,10],[10,11,10,13],[10,14,10,16],[10,17,10,19],[10,20,10,22],[10,23,10,25],[10,26,10,28],[9,64,9,65],[6,67,6,70],[10,60,10,62],[10,63,10,67],[10,68,10,71],[8,61,8,63],[10,35,10,37],[10,38,10,40],[10,41,10,43],[10,44,10,47],[10,48,10,51],[10,54,10,56],[10,57,10,59],[8,53,8,55],[8,56,8,57],[8,58,8,60],[6,44,6,47],[8,34,8,36],[8,37,8,39],[8,40,8,42],[8,43,8,46],[8,49,8,52],[29,10,30,15],[29,27,30,32],[29,1,30,9],[29,18,30,26],[29,16,30,17],[29,33,30,34],[8,22,8,23],[8,7,8,10],[8,11,8,13],[8,14,8,17],[8,18,8,21],[8,24,8,27],[10,29,10,31],[10,32,10,34],[22,1,22,2],[22,21,22,22],[11,1,11,3],[10,1,10,3],[10,4,10,7],[7,23,7,25],[7,67,7,70],[11,8,11,10],[11,4,11,7],[9,84,10,89],[7,78,8,83],[9,78,10,83],[7,84,8,89],[9,56,9,57],[9,58,9,60],[9,61,9,63],[7,26,7,28],[7,29,7,31],[7,32,7,34],[7,38,7,40],[7,41,7,43],[7,44,7,47],[7,48,7,51],[7,52,7,54],[7,55,7,57],[7,58,7,60],[9,7,9,10],[9,18,9,21],[8,31,8,33]]}
[]
[]
[]
[]
["○給料等支給明細書"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,302536,null,null,10000,null,null,null,null,null,24500,null,null,null,null,null,null,null,null,null,null,null,4100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"短期",null,null,380000,null,null,null,null,null,null,null,null,null,null,"諸手当額（時間外勤務手当、通勤手当等を除く）",null,null,null,null,null,{"$f":"IF(SUM(AA8,AD8,AG8,AM8,AP8,AS8,AW8,BA8,S10)>0,SUM(AA8,AD8,AG8,AM8,AP8,AS8,AW8,BA8,S10),0)","v":38600}]
[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,"共済介護\n介護保険",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18243,null,null,34770,null,null,"退年",null,null,null,null,null,null,null,null,null,null,null,null,null,"社会保険料額",null,null,null,null,null,{"$f":"IF(SUM(BE10:BL10)+B12>0,SUM(BE10:BL10)+B12,0)","v":55863}]
[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,"商品代金\n保険料　介護",null,null,"積立金",null,null,"団体保険保険\n保険料　厚生",null,null,null,"団体保険共済\n保険料　健保",null,null,null,null,null,"債権差押",null,null,"差引支給計",null,null,"口座振替額",null,null,"現金支給額",null,null,null,null,"受領印"]
[null,2850]
[null,"A口座",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,"円","C口座",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,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":"IF(SUM(L20:Y20)>0,SUM(L20:Y20),0)","v":101436}]
[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,null,393194,null,null,null,297013]
[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,"積立金\n（福祉・共済）",null,null,"健康保険・船員保険",null,null,null,"厚 生 年 金",null,null,null,"介 護 保 険",null,null,"雇 用 保 険"]
[null,null,null,null,null,null,null,null,null,null,null,33126,null,null,63135,null,null,5175]
[null,"債権差押",null,null,null,"保険料"]
[]
[null,"A口座",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,"円","C口座",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,"2023-12-27",null,null,null,null,null,{"$f":"IF(K30=\"\",\"\",TEXT(K30,\"(aaa)\"))","v":"(水)"},null,"育休終了年月日",null,null,null,null,null,null,null,null,"2024-01-16",null,null,null,null,null,{"$f":"IF(AB30=\"\",\"\",TEXT(AB30,\"(aaa)\"))","v":"(火)"}]

{"sheet":"計算シート","index":2,"n_rows":56,"n_cols":23,"rows_kept":56,"cut":false,"hidden":true,"merged":[[42,1,42,3],[40,1,41,1],[40,2,41,2],[40,3,41,3],[39,1,39,3],[35,1,35,3],[37,1,38,1],[37,2,38,2],[37,3,38,3],[36,1,36,3],[43,1,44,1],[43,2,44,2],[43,3,44,3],[46,1,47,1],[46,2,47,2],[46,3,47,3],[45,1,45,3]]}
[]
[null,"育児休業　収入シミュレーション　計算シート",null,null,null,null,null,null,null,null,null,null,null,null,"2021-12-02","2022-06-02","2022-12-02","2023-06-02","2023-12-02","2024-06-02","2024-12-02","2025-06-02","2023-06-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-06-01","2022-12-01","2023-06-01","2023-12-01","2024-06-01","2024-12-01","2025-06-01","2025-12-01","2023-12-01"]
[]
[null,null,null,null,{"$f":"シミュレーションシート!C32","v":0},{"$f":"入力!K30","v":"2023-12-27"},null,null,null,null,null,null,null,{"$f":"N7-1","v":"2022-12-01"}]
[null,null,null,null,{"$f":"シミュレーションシート!P32","v":0},{"$f":"入力!AB30","v":"2024-01-16"},null,null,null,"育休期間中の全日数",{"$f":"IF(K7+K8<1,0,K7+K8)","v":21},null,null,"期間①","期間②","期間③","期間④"]
[null,null,null,null,{"$f":"シミュレーションシート!C35","v":0},{"$f":"入力!BP8","v":380000},null,null,null,"うち、180日まで",{"$f":"F6-F5+1-K8","v":21},null,"期間の開始日","2022-12-02","2023-06-02","2023-12-02","2024-06-02"]
[null,null,null,null,{"$f":"シミュレーションシート!P35","v":0},{"$f":"入力!X8","v":302536},null,null,null,"うち、181日以降",{"$f":"IF(F6-F5+1-180<0,0,F6-F5+1-180)","v":0},null,"期間の終了日","2023-06-01","2023-12-01","2024-06-01","2024-12-01"]
[null,null,null,null,{"$f":"シミュレーションシート!C37","v":0},{"$f":"入力!CG8","v":38600},null,null,null,"育休期間中の土日を除いた日数",{"$f":"IF(NETWORKDAYS(F5,F6)<1,0,NETWORKDAYS(F5,F6))","v":15},null,"期間の末月の末日",{"$f":"EOMONTH(N8,0)","v":"2023-06-30"},{"$f":"EOMONTH(O8,0)","v":"2023-12-31"},"2024-06-30","2024-12-31"]
[null,null,null,null,{"$f":"シミュレーションシート!P37","v":0},{"$f":"入力!CG12","v":0},null,null,null,"うち、180日まで",{"$f":"K9-K11","v":15},null,"期間中の土日を除いた日数",{"$f":"NETWORKDAYS(N7,N8)","v":130},{"$f":"NETWORKDAYS(O7,O8)","v":131},{"$f":"NETWORKDAYS(P7,P8)","v":130},{"$f":"NETWORKDAYS(Q7,Q8)","v":130}]
[null,null,null,null,{"$f":"シミュレーションシート!C39","v":0},{"$f":"入力!CG10*-1","v":-55863},null,null,null,"うち、181日以降",{"$f":"IF(NETWORKDAYS(K14,F6)>0,NETWORKDAYS(K14,F6),0)","v":0},null,"期間中の日数",{"$f":"N8-N7+1","v":182},{"$f":"O8-O7+1","v":183},{"$f":"P8-P7+1","v":183},{"$f":"Q8-Q7+1","v":183}]
[null,null,null,null,{"$f":"シミュレーションシート!P39","v":0},{"$f":"入力!E12*-1","v":0},null,null,null,"育休開始から1か月後",{"$f":"EDATE(F5,1)-1","v":"2024-01-26"},null,"(参照開始年月日)",{"$f":"MAX(N7,F5)","v":"2023-12-27"},{"$f":"MAX(O7,F5)","v":"2023-12-27"},{"$f":"MAX(P7,F5)","v":"2023-12-27"},{"$f":"MAX(Q7,F5)","v":"2024-06-02"}]
[null,null,null,null,{"$f":"シミュレーションシート!C41","v":0},{"$f":"入力!I12*-1","v":0},null,null,null,"育休終了日の翌日",{"$f":"F6+1","v":"2024-01-17"},null,"(参照終了年月日)",{"$f":"MIN(F6,N8)","v":"2023-06-01"},{"$f":"MIN(F6,O8)","v":"2023-12-01"},{"$f":"MIN(F6,P8)","v":"2024-01-16"},{"$f":"MIN(F6,Q8)","v":"2024-01-16"}]
[null,null,null,null,{"$f":"シミュレーションシート!C44","v":0},{"$f":"入力!AW18","v":393194},null,null,null,"取得から181日目",{"$f":"F5+180","v":"2024-06-24"},null,"期間中の育休日数",{"$f":"IF(N13-N12>=0,N13-N12+1,0)","v":0},{"$f":"IF(O13-O12>=0,O13-O12+1,0)","v":0},{"$f":"IF(P13-P12>=0,P13-P12+1,0)","v":21},{"$f":"IF(Q13-Q12>=0,Q13-Q12+1,0)","v":0}]
[null,null,null,null,{"$f":"シミュレーションシート!C46","v":0},{"$f":"入力!BA18","v":297013},null,null,null,"月末時点で育休中の回数",{"$f":"Q20+IF(F22=\"〇\",1,0)","v":1},null,"（育休開始日～当該期間末日の日数）",{"$f":"NETWORKDAYS($F$5,N8)","v":-150},{"$f":"NETWORKDAYS($F$5,O8)","v":-19},{"$f":"NETWORKDAYS($F$5,P8)","v":113},{"$f":"NETWORKDAYS($F$5,Q8)","v":243}]
[null,null,null,null,{"$f":"シミュレーションシート!P44","v":0},{"$f":"入力!CG17*-1","v":-101436},null,null,null,"育休終了月",{"$f":"MONTH(F6)","v":1},null,"（育休終了日の翌日～期間の終了日の日数）",{"$f":"NETWORKDAYS($K$13,N8)","v":-165},{"$f":"NETWORKDAYS($K$13,O8)","v":-34},{"$f":"NETWORKDAYS($K$13,P8)","v":98},{"$f":"NETWORKDAYS($K$13,Q8)","v":228}]
[null,null,null,null,{"$f":"シミュレーションシート!P46","v":0},{"$f":"入力!H20*-1","v":0},null,null,null,"育休終了月の翌日の月",{"$f":"MONTH(K13)","v":1},null,"期間中の土日を除いた育休日数",{"$f":"IF(N15-IF(N16<0,0,N16)<0,0,N15-IF(N16<0,0,N16))","v":0},{"$f":"IF(O15-IF(O16<0,0,O16)-N17<0,0,O15-IF(O16<0,0,O16)-N17)","v":0},{"$f":"IF(P15-IF(P16<0,0,P16)-O17-N17<0,0,P15-IF(P16<0,0,P16)-O17-N17)","v":15},{"$f":"IF(Q15-IF(Q16<0,0,Q16)-P17-O17-N17<0,0,Q15-IF(Q16<0,0,Q16)-P17-O17-N17)","v":0}]
[null,null,null,{"$f":"N9","v":"2023-06-30"},"左記の日が育休中か",{"$f":"IF(AND(F5<D18,D18<=F6,EDATE(F5,1)+1<F6),\"〇\",\"×\")","v":"×"},null,null,null,"育休開始から終了までの足掛けの月数",{"$f":"DATEDIF(F5,F6,\"m\")+1","v":1},null,"（育休開始から期間末日までの月末回数）",null,null,null,{"$f":"(YEAR(Q8)-YEAR(F5))*12+MONTH(Q8)-MONTH(F5)","v":12}]
[null,null,null,{"$f":"O9","v":"2023-12-31"},"左記の日が育休中か",{"$f":"IF(AND(F5<D19,D19<=F6,EDATE(F5,1)+1<F6),\"〇\",\"×\")","v":"×"},null,null,null,null,null,null,"（育休終了から期間末日までの月末回数）",null,null,null,{"$f":"(YEAR(Q8)-YEAR(F6))*12+MONTH(Q8)-MONTH(F6)","v":11}]
[null,null,null,{"$f":"P9","v":"2024-06-30"},"左記の日が育休中か",{"$f":"IF(AND(F5<D20,D20<=F6,EDATE(F5,1)+1<F6),\"〇\",\"×\")","v":"×"},null,null,null,null,null,null,"月末をまたぐ回数",null,null,null,{"$f":"Q18-Q19","v":1}]
[null,null,null,{"$f":"Q9","v":"2024-12-31"},"左記の日が育休中か",{"$f":"IF(AND(F5<D21,D21<=F6,EDATE(F5,1)+1<F6),\"〇\",\"×\")","v":"×"}]
[null,null,null,null,"育休終了日が月末か",{"$f":"IF(K16=K17,\"×\",\"〇\")","v":"×"}]
[]
[null,null,null,null,null,null,null,null,null,"①育休取得～180日の手当金計算","　       ・雇用保険法第１７条第４項第２号ハに定める額：",null,null,15020,"円　←毎年8月1日に改訂"]
[null,null,null,null,null,null,null,null,null,"計算式：",{"$f":"N24","v":15020},"×",30,"×",67,"÷",100,"÷",22,"＝",{"$f":"ROUNDDOWN(K25*M25*O25/Q25/S25,0)","v":13722},"円（円未満切捨て）"]
[null,null,null,null,"（俸給等関係）","育休を取得しない場合","育休を取得した場合","差額",null,"標準報酬の日額：",{"$f":"F7","v":380000},"÷",22,"＝",{"$f":"ROUND(K26/M26,2)","v":17272.73},null,"≒",{"$f":"ROUND(O26,-1)","v":17270},"円（円未満切捨て）"]
[null,null,null,null,"給与及び諸手当　育休期間の通算支給額（日割り）",{"$f":"(F8+F9)/22*K9","v":232592.72727272726},0,{"$f":"G27-F27","v":-232592.72727272726},null,"給付日額：",{"$f":"R26","v":17270},"×",67,"÷",100,"＝",{"$f":"ROUNDDOWN(K27*M27/O27,0)","v":11570},"円（円未満切捨て）"]
[null,null,null,null,"超勤　（日割り計算）",{"$f":"F10/22*K9","v":0},0,{"$f":"G28-F28","v":0},null,"ＡorBの少ない方＝日額単価→",{"$f":"MIN(U25,Q27)","v":11570},"×",{"$f":"K10","v":15},"日　＝",{"$f":"ROUNDDOWN(K28*M28,0)","v":173550},"円（円未満切捨て）"]
[null,null,null,null,"育児休業手当金　育休期間の通算支給額",0,{"$f":"O28+O33","v":173550},{"$f":"G29-F29","v":173550},null,"②育休取得181日～の手当金計算"]
[null,null,null,null,"社会保険料　　　育休期間の通算控除額（毎月末に支払いと仮定）",{"$f":"F11","v":-55863},{"$f":"IF(OR(シミュレーションシート!I65>13,K15=1),0,F11)","v":0},{"$f":"G30-F30","v":55863},null,"計算式：",{"$f":"N24","v":15020},"×",30,"×",50,"÷",100,"÷",22,"＝",{"$f":"ROUNDDOWN(K30*M30*O30/Q30/S30,0)","v":10240},"円（円未満切捨て）"]
[null,null,null,null,"所得税額(参考)",{"$f":"F12/22*K9","v":0},"-","-",null,"標準報酬の日額：",{"$f":"F7","v":380000},"÷",22,"＝",{"$f":"ROUND(K31/M31,2)","v":17272.73},"≒",{"$f":"ROUND(O31,-1)","v":17270},"円（円未満切捨て）"]
[null,null,null,null,"住民税額（参考）",{"$f":"IF(F5>F6,0,K18*F13)","v":0},"-","-",null,"給付日額：",{"$f":"Q31","v":17270},"×",50,"÷",100,"＝",{"$f":"ROUNDDOWN(K32*M32/O32,0)","v":8635},"円（円未満切捨て）"]
[null,null,null,null,"計（所得税・住民税除く）",{"$f":"SUM(F27:F30)","v":176729.72727272726},{"$f":"SUM(G27:G30)","v":173550},{"$f":"G33-F33","v":-3179.7272727272648},null,"ＣorＤの少ない方=日額単価→",{"$f":"MIN(U30,Q32)","v":8635},"×",{"$f":"K11","v":0},"日　＝",{"$f":"ROUNDDOWN(K33*M33,0)","v":0},"円（円未満切捨て）"]
[]
[]
[null,"期末勤勉手当の算定期間",null,null,"（期末勤勉手当関係）","育休を取得しない場合","育休を取得した場合","差額",null,"期末手当","休業月数","休業日数","育休期間の1/2除算後の休業月数","育休期間の1/2除算後の休業日数","1/2除算を踏まえた出勤月数","1/2除算を踏まえた出勤日数","期間中の育休1か月以内判定","全期間育休の場合、0値で表示"]
[null,{"$f":"\"期間① \"&YEAR(D38)&\"年\"&MONTH(D38)&\"月支給時\"","v":"期間① 2023年6月支給時"},null,null,"期末・勤勉手当　支給額（期末支給額×期間率＋勤勉支給額×在職期間別割合）",{"$f":"F14+F15","v":690207},{"$f":"IF(F37=0,0,(F14*M43)*R37+F15*T43)","v":690207},{"$f":"G37-F37","v":0},null,"期間１",{"$f":"IF(期間①!H14=6,6,期間①!M14)","v":0},{"$f":"期間①!W9","v":0},{"$f":"K37/2","v":0},0,{"$f":"期間①!F65","v":6},{"$f":"ROUNDUP(IF(期間①!F66=30,0,期間①!F66),0)","v":0},{"$f":"IF(R43=5,\"〇\",\"×\")","v":"×"},{"$f":"IF(N14/N11=1,0,1)","v":1}]
[null,{"$f":"N7","v":"2022-12-02"},"～",{"$f":"N8","v":"2023-06-01"},"期末・勤勉手当　社会保険料",{"$f":"F16","v":-101436},{"$f":"IF(G37=0,0,IF(F18=\"〇\",0,G37*F38/F37))","v":-101436},{"$f":"G38-F38","v":0},null,"期間２",{"$f":"IF(期間②!H14=6,6,期間②!M14)","v":0},{"$f":"期間②!W9","v":0},0,0,{"$f":"期間②!F65","v":6},{"$f":"ROUNDUP(IF(期間②!F66=30,0,期間②!F66),0)","v":0},{"$f":"IF(R44=5,\"〇\",\"×\")","v":"×"},{"$f":"IF(O14/O11=1,0,1)","v":1}]
[null,null,null,null,"所得税",{"$f":"F17","v":0},{"$f":"IF(G37=0,0,G37*F39/F37)","v":0},"-",null,"期間３",{"$f":"IF(期間③!H14=6,6,期間③!M14)","v":0},{"$f":"期間③!W9","v":21},0,10.5,{"$f":"期間③!F65","v":5},{"$f":"ROUNDUP(IF(期間③!F66=30,0,期間③!F66),0)","v":20},{"$f":"IF(R45=5,\"〇\",\"×\")","v":"〇"},{"$f":"IF(P14/P11=1,0,1)","v":1}]
[null,{"$f":"\"期間② \"&YEAR(D41)&\"年\"&MONTH(D41)&\"月支給時\"","v":"期間② 2023年12月支給時"},null,null,"期末・勤勉手当　支給額（期末支給額×期間率＋勤勉支給額×在職期間別割合）",{"$f":"F14+F15","v":690207},{"$f":"IF(F40=0,0,(F14*M44)*R38+F15*T44)","v":690207},{"$f":"G40-F40","v":0},null,"期間４",{"$f":"IF(期間④!H14=6,6,期間④!M14)","v":0},{"$f":"期間④!W9","v":0},0,0,{"$f":"期間④!F65","v":6},{"$f":"ROUNDUP(IF(期間④!F66=30,0,期間④!F66),0)","v":0},"×",{"$f":"IF(Q14/Q11=1,0,1)","v":1}]
[null,{"$f":"O7","v":"2023-06-02"},"～",{"$f":"O8","v":"2023-12-01"},"期末・勤勉手当　社会保険料",{"$f":"F16","v":-101436},{"$f":"IF(G40=0,0,IF(F19=\"〇\",0,G40*F41/F40))","v":-101436},{"$f":"G41-F41","v":0}]
[null,null,null,null,"所得税",{"$f":"F17","v":0},{"$f":"IF(G40=0,0,G40*F42/F40)","v":0},"-",null,"在職期間別割合",null,"                    適用在職期間別割合",null,null,"勤勉手当","期間率",null,"出勤月数","出勤日数","適用期間率"]
[null,{"$f":"\"期間③ \"&YEAR(D44)&\"年\"&MONTH(D44)&\"月支給時\"","v":"期間③ 2024年6月支給時"},null,null,"期末・勤勉手当　支給額（期末支給額×期間率＋勤勉支給額×在職期間別割合）",{"$f":"F14+F15","v":690207},{"$f":"IF(F43=0,0,(F14*M45)*R39+F15*T45)","v":690207},{"$f":"G43-F43","v":0},null,"①3か月未満",0.3,"期間１",{"$f":"期間①!L70","v":1},null,0,0,"期間１",{"$f":"期間①!E53","v":6},{"$f":"期間①!E54","v":1},{"$f":"期間①!V61","v":1}]
[null,{"$f":"P7","v":"2023-12-02"},"～",{"$f":"P8","v":"2024-06-01"},"期末・勤勉手当　社会保険料",{"$f":"F16","v":-101436},{"$f":"IF(G43=0,0,IF(F20=\"〇\",0,G43*F44/F43))","v":-101436},{"$f":"G44-F44","v":0},null,"②3か月以上5か月未満",0.6,"期間２",{"$f":"期間②!L70","v":1},null,"15日未満",0.05,"期間２",{"$f":"期間②!E53","v":6},{"$f":"期間②!E54","v":0},{"$f":"期間②!V61","v":1}]
[null,null,null,null,"所得税",{"$f":"F17","v":0},{"$f":"IF(G43=0,0,G43*F45/F43)","v":0},"-",null,"③5か月以上6か月未満",0.8,"期間３",{"$f":"期間③!L70","v":1},null,"15日以上1月未満",0.1,"期間３",{"$f":"期間③!E53","v":5},{"$f":"期間③!E54","v":10},{"$f":"期間③!V61","v":1}]
[null,{"$f":"\"期間④ \"&YEAR(D47)&\"年\"&MONTH(D47)&\"月支給時\"","v":"期間④ 2024年12月支給時"},null,null,"期末・勤勉手当　支給額（期末支給額×期間率＋勤勉支給額×在職期間別割合）",{"$f":"F14+F15","v":690207},{"$f":"IF(F46=0,0,(F14*M46)*R40+F15*T46)","v":690207},{"$f":"G46-F46","v":0},null,"④6か月",1,"期間４",{"$f":"期間④!L70","v":1},null,"1月以上1月15日未満",0.15,"期間４",{"$f":"期間④!E53","v":6},{"$f":"期間④!E54","v":0},{"$f":"期間④!V61","v":1}]
[null,{"$f":"Q7","v":"2024-06-02"},"～",{"$f":"Q8","v":"2024-12-01"},"期末・勤勉手当　社会保険料",{"$f":"F16","v":-101436},{"$f":"IF(G46=0,0,IF(F21=\"〇\",0,G46*F47/F46))","v":-101436},{"$f":"G47-F47","v":0},null,null,null,null,null,null,"1月15日以上2月未満",0.2]
[null,null,null,null,"所得税",{"$f":"F17","v":0},{"$f":"IF(G46=0,0,G46*F48/F46)","v":0},"-",null,null,null,null,null,null,"2月以上2月15日未満",0.3]
[null,null,null,null,"計（期末・勤勉手当の支給額・社会保険料）",{"$f":"SUM(F37,F38,F40,F41,F43,F44,F46,F47)","v":2355084},{"$f":"SUM(G37,G38,G40,G41,G43,G44,G46,G47)","v":2355084},{"$f":"SUM(H37:H48)","v":0},null,null,null,null,null,null,"2月15日以上3月未満",0.4]
[null,null,null,null,"計（所得税）",{"$f":"SUM(F39,F42,F45,F48)","v":0},{"$f":"SUM(G39,G42,G45,G48)","v":0},"-",null,null,null,null,null,null,"3月以上3月15日未満",0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3月15日以上4月未満",0.6]
[null,null,null,null,null,null,"ボーナスと月額との差額の総計",{"$f":"H33+H49","v":-3179.7272727272648},null,null,null,null,null,null,"4月以上4月15日未満",0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4月15日以上5月未満",0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5月以上5月15日未満",0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5月15日以上6月未満",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6か月",1]

{"sheet":"期間①","index":3,"n_rows":71,"n_cols":23,"rows_kept":71,"cut":false,"hidden":true,"merged":[[5,11,5,17]]}
[null,null,"期末勤勉手当の除算期間等の計算"]
[null,null,"対象：期間①"]
[null,null,"育休の開始年月日",{"$f":"計算シート!F5","v":"2023-12-27"}]
[null,null,"育休終了年月日",{"$f":"計算シート!F6","v":"2024-01-16"},null,null,null,"　期間の開始日が育休中か",{"$f":"D18","v":"出勤"},null,"期間の終了日が育休中か",{"$f":"IF(S48=\"\",S47,S48)","v":"出勤"},null,null,null,null,null,null,null,"（数字の整理）","日数カウント開始基準日",null,"数値処理後"]
[null,null,null,{"$f":"IF(D4-D3<1,0,D4-D3)","v":20},null,null,"育休開始日と期間の開始日のうち、大きい方",null,null,null,{"$f":"MAX(D3,C18)","v":"2023-12-27"},null,null,null,null,null,null,null,null,{"$f":"K7+(L7*100000)","v":45317},{"$f":"IF(M14=0,K5,MAX(T5:T10)-100000)","v":"2023-12-27"},"→",{"$f":"IF(M14=0,U5-1,U5)","v":"2023-12-26"}]
[null,null,null,null,null,null,null,null,null,null,"育休の開始日と期間の開始日のうち大きい方","左記の日が育休中なら1で返す",null,null,null,null,null,null,null,45348,"期間の最終日と育休終了日の小さい方"]
[null,null,null,"①期間開始日の1か月後の日(１)",{"$f":"EDATE(C18,1)-1","v":"2023-01-01"},null,null,"育休開始の1か月後の日(a)",{"$f":"EDATE($D$3,1)-1","v":"2024-01-26"},null,{"$f":"EDATE($K$5,1)-1","v":"2024-01-26"},{"$f":"COUNTIF(M7:R7,\"育休中\")","v":0},{"$f":"VLOOKUP(K7,$C$18:$D$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$F$18:$G$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$I$18:$J$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$L$18:$M$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$O$18:$P$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$R$18:$S$48,2,FALSE)","v":{"$error":"#N/A"}},null,45377,{"$f":"MIN(U19-1,D4)","v":"2023-06-01"}]
[null,null,null,"②(１)の翌日～2か月後の日(２)",{"$f":"EDATE(E7,1)","v":"2023-02-01"},null,null,"育休開始の2か月後の日(b)",{"$f":"EDATE($D$3,2)-1","v":"2024-02-26"},null,{"$f":"EDATE($K$5,2)-1","v":"2024-02-26"},{"$f":"COUNTIF(M8:R8,\"育休中\")","v":0},{"$f":"VLOOKUP(K8,$C$18:$D$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K8,$F$18:$G$48,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45408,"育休日数",null,"（全休の場合カウントしない）"]
[null,null,null,"③(２)の翌日～3か月後の日(３)",{"$f":"EDATE(E8,1)","v":"2023-03-01"},null,null,"育休開始の3か月後の日(c)",{"$f":"EDATE($D$3,3)-1","v":"2024-03-26"},null,{"$f":"EDATE($K$5,3)-1","v":"2024-03-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45438,{"$f":"IF(U7-W5<1,0,U7-W5)","v":0},"→",{"$f":"IF(V50=0,0,IF(H14=6,0,U9))","v":0}]
[null,null,null,"④(３)の翌日～4か月後の日(４)",{"$f":"EDATE(E9,1)","v":"2023-04-01"},null,null,"育休開始の4か月後の日(d)",{"$f":"EDATE($D$3,4)-1","v":"2024-04-26"},null,{"$f":"EDATE($K$5,4)-1","v":"2024-04-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45469]
[null,null,null,"⑤(４)の翌日～5か月後の日(５)",{"$f":"EDATE(E10,1)","v":"2023-05-01"},null,null,"育休開始の5か月後の日(e)",{"$f":"EDATE($D$3,5)-1","v":"2024-05-26"},null,{"$f":"EDATE($K$5,5)-1","v":"2024-05-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"⑥(５)の翌日～6か月後の日(６)",{"$f":"EDATE(E11,1)","v":"2023-06-01"},null,null,"育休開始の6か月後の日(f)",{"$f":"EDATE($D$3,6)-1","v":"2024-06-26"},null,{"$f":"EDATE($K$5,6)-1","v":"2024-06-26"},{"$f":"COUNTIF(M12:R12,\"育休中\")","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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":"IF(V49=0,6,\"\")","v":""},"月",null,null,"期間中全休でない場合",{"$f":"IF(H14=\"\",SUM(L7:L12),\"\")","v":0},"月",null,null,null,null,null,"もの）を「日数カウント開始基準日」に設定"]
[]
[]
[null,null,"対象日","出勤／育休"]
[null,"期間の開始日→",{"$f":"計算シート!N7","v":"2022-12-02"},{"$f":"IF(AND(C18>$D$3-1,C18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(C18,1)","v":"2023-01-02"},{"$f":"IF(AND(F18>$D$3-1,F18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(F18,1)","v":"2023-02-02"},{"$f":"IF(AND(I18>$D$3-1,I18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(I18,1)","v":"2023-03-02"},{"$f":"IF(AND(L18>$D$3-1,L18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(L18,1)","v":"2023-04-02"},{"$f":"IF(AND(O18>$D$3-1,O18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(O18,1)","v":"2023-05-02"},{"$f":"IF(AND(R18>$D$3-1,R18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,"次の期間の初日"]
[null,null,{"$f":"C18+1","v":"2022-12-03"},{"$f":"IF(AND(C19>$D$3-1,C19<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"F18+1","v":"2023-01-03"},{"$f":"IF(AND(F19>$D$3-1,F19<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"I18+1","v":"2023-02-03"},"出勤",null,{"$f":"L18+1","v":"2023-03-03"},"出勤",null,{"$f":"O18+1","v":"2023-04-03"},"出勤",null,{"$f":"R18+1","v":"2023-05-03"},"出勤",null,{"$f":"EDATE(R18,1)","v":"2023-06-02"}]
[null,null,{"$f":"C19+1","v":"2022-12-04"},"出勤",null,"2023-01-04","出勤",null,"2023-02-04","出勤",null,"2023-03-04","出勤",null,"2023-04-04","出勤",null,"2023-05-04","出勤"]
[null,null,"2022-12-05","出勤",null,"2023-01-05","出勤",null,"2023-02-05","出勤",null,"2023-03-05","出勤",null,"2023-04-05","出勤",null,"2023-05-05","出勤",null,{"$f":"U19","v":"2023-06-02"}]
[null,null,"2022-12-06","出勤",null,"2023-01-06","出勤",null,"2023-02-06","出勤",null,"2023-03-06","出勤",null,"2023-04-06","出勤",null,"2023-05-06","出勤",null,"以降に育休あるか"]
[null,null,"2022-12-07","出勤",null,"2023-01-07","出勤",null,"2023-02-07","出勤",null,"2023-03-07","出勤",null,"2023-04-07","出勤",null,"2023-05-07","出勤",null,{"$f":"IF(D4>U21,\"〇\",\"×\")","v":"〇"}]
[null,null,"2022-12-08","出勤",null,"2023-01-08","出勤",null,"2023-02-08","出勤",null,"2023-03-08","出勤",null,"2023-04-08","出勤",null,"2023-05-08","出勤"]
[null,null,"2022-12-09","出勤",null,"2023-01-09","出勤",null,"2023-02-09","出勤",null,"2023-03-09","出勤",null,"2023-04-09","出勤",null,"2023-05-09","出勤"]
[null,null,"2022-12-10","出勤",null,"2023-01-10","出勤",null,"2023-02-10","出勤",null,"2023-03-10","出勤",null,"2023-04-10","出勤",null,"2023-05-10","出勤"]
[null,null,"2022-12-11","出勤",null,"2023-01-11","出勤",null,"2023-02-11","出勤",null,"2023-03-11","出勤",null,"2023-04-11","出勤",null,"2023-05-11","出勤"]
[null,null,"2022-12-12","出勤",null,"2023-01-12","出勤",null,"2023-02-12","出勤",null,"2023-03-12","出勤",null,"2023-04-12","出勤",null,"2023-05-12","出勤"]
[null,null,"2022-12-13","出勤",null,"2023-01-13","出勤",null,"2023-02-13","出勤",null,"2023-03-13","出勤",null,"2023-04-13","出勤",null,"2023-05-13","出勤"]
[null,null,"2022-12-14","出勤",null,"2023-01-14","出勤",null,"2023-02-14","出勤",null,"2023-03-14","出勤",null,"2023-04-14","出勤",null,"2023-05-14","出勤"]
[null,null,"2022-12-15","出勤",null,"2023-01-15","出勤",null,"2023-02-15","出勤",null,"2023-03-15","出勤",null,"2023-04-15","出勤",null,"2023-05-15","出勤"]
[null,null,"2022-12-16","出勤",null,"2023-01-16","出勤",null,"2023-02-16","出勤",null,"2023-03-16","出勤",null,"2023-04-16","出勤",null,"2023-05-16","出勤"]
[null,null,"2022-12-17","出勤",null,"2023-01-17","出勤",null,"2023-02-17","出勤",null,"2023-03-17","出勤",null,"2023-04-17","出勤",null,"2023-05-17","出勤"]
[null,null,"2022-12-18","出勤",null,"2023-01-18","出勤",null,"2023-02-18","出勤",null,"2023-03-18","出勤",null,"2023-04-18","出勤",null,"2023-05-18","出勤"]
[null,null,"2022-12-19","出勤",null,"2023-01-19","出勤",null,"2023-02-19","出勤",null,"2023-03-19","出勤",null,"2023-04-19","出勤",null,"2023-05-19","出勤"]
[null,null,"2022-12-20","出勤",null,"2023-01-20","出勤",null,"2023-02-20","出勤",null,"2023-03-20","出勤",null,"2023-04-20","出勤",null,"2023-05-20","出勤"]
[null,null,"2022-12-21","出勤",null,"2023-01-21","出勤",null,"2023-02-21","出勤",null,"2023-03-21","出勤",null,"2023-04-21","出勤",null,"2023-05-21","出勤"]
[null,null,"2022-12-22","出勤",null,"2023-01-22","出勤",null,"2023-02-22","出勤",null,"2023-03-22","出勤",null,"2023-04-22","出勤",null,"2023-05-22","出勤"]
[null,null,"2022-12-23","出勤",null,"2023-01-23","出勤",null,"2023-02-23","出勤",null,"2023-03-23","出勤",null,"2023-04-23","出勤",null,"2023-05-23","出勤"]
[null,null,"2022-12-24","出勤",null,"2023-01-24","出勤",null,"2023-02-24","出勤",null,"2023-03-24","出勤",null,"2023-04-24","出勤",null,"2023-05-24","出勤"]
[null,null,"2022-12-25","出勤",null,"2023-01-25","出勤",null,"2023-02-25","出勤",null,"2023-03-25","出勤",null,"2023-04-25","出勤",null,"2023-05-25","出勤"]
[null,null,"2022-12-26","出勤",null,"2023-01-26","出勤",null,"2023-02-26","出勤",null,"2023-03-26","出勤",null,"2023-04-26","出勤",null,"2023-05-26","出勤"]
[null,null,"2022-12-27","出勤",null,"2023-01-27","出勤",null,"2023-02-27","出勤",null,"2023-03-27","出勤",null,"2023-04-27","出勤",null,"2023-05-27","出勤"]
[null,null,{"$f":"IF(C43=\"\",\"\",IF(C43+2>$F$18,\"\",C43+1))","v":"2022-12-28"},{"$f":"IF(C44=\"\",\"\",IF(AND(C44>$D$3-1,C44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(F43=\"\",\"\",IF(F43+2>$I$18,\"\",F43+1))","v":"2023-01-28"},{"$f":"IF(F44=\"\",\"\",IF(AND(F44>$D$3-1,F44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(I43=\"\",\"\",IF(I43+2>$L$18,\"\",I43+1))","v":"2023-02-28"},{"$f":"IF(I44=\"\",\"\",IF(AND(I44>$D$3-1,I44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(L43=\"\",\"\",IF(L43+2>$O$18,\"\",L43+1))","v":"2023-03-28"},{"$f":"IF(L44=\"\",\"\",IF(AND(L44>$D$3-1,L44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(O43=\"\",\"\",IF(O43+2>$R$18,\"\",O43+1))","v":"2023-04-28"},{"$f":"IF(O44=\"\",\"\",IF(AND(O44>$D$3-1,O44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(R43=\"\",\"\",IF(R43+2>$U$19,\"\",R43+1))","v":"2023-05-28"},{"$f":"IF(R44=\"\",\"\",IF(AND(R44>$D$3-1,R44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"}]
[null,null,"2022-12-29",{"$f":"IF(C45=\"\",\"\",IF(AND(C45>$D$3-1,C45<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,"2023-01-29",{"$f":"IF(F45=\"\",\"\",IF(AND(F45>$D$3-1,F45<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,"2023-03-01","出勤",null,"2023-03-29","出勤",null,"2023-04-29","出勤",null,"2023-05-29","出勤"]
[null,null,"2022-12-30","出勤",null,"2023-01-30","出勤",null,"","",null,"2023-03-30","出勤",null,"2023-04-30","出勤",null,"2023-05-30","出勤"]
[null,null,"2022-12-31","出勤",null,"2023-01-31","出勤",null,"","",null,"2023-03-31","出勤",null,"2023-05-01","出勤",null,"2023-05-31","出勤"]
[null,null,"2023-01-01","出勤",null,"2023-02-01","出勤",null,"","",null,"2023-04-01","出勤",null,"","",null,"2023-06-01","出勤"]
[null,null,"","",{"$f":"VLOOKUP(U7,C18:D48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(F48=\"\",\"\",IF(F48+2>$I$18,\"\",F48+1))","v":""},"",{"$f":"VLOOKUP(U7,F18:G48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I48=\"\",\"\",IF(I48+2>$L$18,\"\",I48+1))","v":""},"",{"$f":"VLOOKUP(U7,I18:J48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(L48=\"\",\"\",IF(L48+2>$O$18,\"\",L48+1))","v":""},"",{"$f":"VLOOKUP(U7,L18:M48,2,FALSE)","v":{"$error":"#N/A"}},"","",{"$f":"VLOOKUP(U7,O18:P48,2,FALSE)","v":{"$error":"#N/A"}},"","",{"$f":"VLOOKUP(U7,R18:S48,2,FALSE)","v":"出勤"},null,{"$f":"C50+F50+I50+L50+O50+R50-D50-G50-J50-M50-P50-S50","v":182}]
[null,"育休の合計",{"$f":"COUNTIF(C18:C49,\">0\")","v":31},{"$f":"COUNTIF(D18:D49,\"育休中\")","v":0},{"$f":"IF(DAY(C48)=1,IF(OR(E49=\"育休中\",E49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(F18:F49,\">0\")","v":31},{"$f":"COUNTIF(G18:G49,\"育休中\")","v":0},{"$f":"IF(DAY(F48)=1,IF(OR(H49=\"育休中\",H49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(I18:I49,\">0\")","v":28},{"$f":"COUNTIF(J18:J49,\"育休中\")","v":0},{"$f":"IF(DAY(I48)=1,IF(OR(K49=\"育休中\",K49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(L18:L49,\">0\")","v":31},{"$f":"COUNTIF(M18:M49,\"育休中\")","v":0},{"$f":"IF(DAY(L48)=1,IF(OR(N49=\"育休中\",N49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(O18:O49,\">0\")","v":30},{"$f":"COUNTIF(P18:P49,\"育休中\")","v":0},{"$f":"IF(DAY(O48)=1,IF(OR(Q49=\"育休中\",Q49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(R18:R49,\">0\")","v":31},{"$f":"COUNTIF(S18:S49,\"育休中\")","v":0},{"$f":"IF(DAY(R48)=1,IF(OR(T49=\"育休中\",T49=\"出勤\"),1,0),0)","v":1},"育休日数",{"$f":"D50+G50+J50+M50+P50+S50","v":0}]
[null,null,null,null,{"$f":"IF(C50=D50,0,IFERROR(E50,0))","v":0},null,null,{"$f":"IF(F50=G50,0,IFERROR(H50,0))","v":0},null,null,{"$f":"IF(I50=J50,0,IFERROR(K50,0))","v":0},null,null,{"$f":"IF(L50=M50,0,IFERROR(N50,0))","v":0},null,null,{"$f":"IF(O50=P50,0,IFERROR(Q50,0))","v":0},null,null,{"$f":"IF(R50=S50,0,IFERROR(T50,0))","v":1}]
[]
[null,null,null,"勤務月換算",{"$f":"IF(H14=6,0,6-M14-IF(W9>0,1,0))","v":6},null,"↓月数×100","計算上の値",null,{"$f":"IF((DAY($D$3)=DAY(EDATE($D$3,1)))=TRUE,EDATE($D$3,1)-1,EDATE($D$3,1))","v":"2024-01-26"}]
[null,null,null,"勤務日換算",{"$f":"IF(W9=0,0,IF(E53=6,0,IF(H14=6,0,30-W9)))+E56","v":1},null,{"$f":"E53*100","v":600},{"$f":"G54+E55+E54","v":601},null,{"$f":"D4-J53","v":-10}]
[null,null,null,"(5月30日の場合の調整値)",{"$f":"IF(AND(M14=5,W9=30),1,0)","v":0}]
[null,null,null,"(月間31日で休業日数30日の場合の調整値)",{"$f":"SUM(E51:T51)","v":1}]
[]
[null,null,null,null,null,null,null,"（Ａ）の値","（左記数値を下記数値に置換）","（勤務日が０の場合1で返す）","（置換後）","日数足し上げ",null,null,null,0,0,0,0,0,null,{"$f":"VLOOKUP(H54,P58:T71,5,TRUE)","v":1}]
[null,null,null,"①",null,"②",null,0,0,{"$f":"IF(AND(K$59=I59,$F$61=0),1,0)","v":0},{"$f":"VLOOKUP(F60,H59:I71,2,TRUE)","v":600},{"$f":"IF(SUM(J59:J71)=1,K59,IF(F61=0,(K59+F61)-70,K59+F61))","v":600},null,null,null,1,"15日未満",0,15,0.05]
[null,null,"1/2除算後の休業月数",{"$f":"IF(H14=6,3,M14/2)","v":0},"勤務月数換算（Ａ）",{"$f":"IF(F61>0,6-D60-1,6-D60)","v":6},null,0.5,85,null,null,null,null,null,null,15,"15日以上1月未満",1,0,0.1,null,"（数値処理後）期間率"]
[null,null,"1/2除算後の休業日数",{"$f":"W9/2","v":0},"勤務日数換算（Ｂ）",{"$f":"IF(D61=0,0,30-D61)","v":0},null,1,100,{"$f":"IF(AND(K$59=I61,$F$61=0),1,0)","v":0},null,null,null,null,null,100,"1月以上1月15日未満",1,15,0.15,null,{"$f":"IF(J54=0,T71,IF(E53=5,T71,V58))","v":1}]
[null,null,null,null,null,null,null,1.5,185,null,"（係数）",null,null,null,null,115,"1月15日以上2月未満",2,0,0.2]
[null,null,null,null,null,null,null,2,200,0,230,"②3か月以上5か月未満",3,0.6,null,200,"2月以上2月15日未満",2,15,0.3]
[null,null,null,"③",null,"④",null,2.5,285,null,430,"③5か月以上6か月未満",5,0.8,null,215,"2月15日以上3月未満",3,0,0.4]
[null,null,"月数の小数点以下を補正",{"$f":"INT(MOD(SIGN(L59)*L59/100,10))","v":6},"（数値処理後）勤務月数",{"$f":"IF(V49=0,3,IF(AND(F60=6,F61=0),F60,D65))","v":6},null,3,300,0,530,"④6か月",6,1,null,300,"3月以上3月15日未満",3,15,0.5]
[null,null,null,{"$f":"L59-D65*100","v":0},"（数値処理後）勤務日数",{"$f":"IF(V49=0,0,IF(AND(F60=6,F61=0),F61,D66))","v":0},null,3.5,385,null,null,null,null,null,null,315,"3月15日以上4月未満",4,0,0.6]
[null,null,null,null,null,null,null,4,400,0,null,"判定",null,null,null,400,"4月以上4月15日未満",4,15,0.7]
[null,null,null,null,null,null,null,4.5,485,null,null,{"$f":"VLOOKUP(L59,K63:N65,4,TRUE)","v":1},null,null,null,415,"4月15日以上5月未満",5,0,0.8]
[null,null,null,null,null,null,null,5,500,0,null,"（数値処理後）在職期間別割合",null,null,null,500,"5月以上5月15日未満",5,15,0.9]
[null,null,null,null,null,null,null,5.5,585,null,null,{"$f":"IF(J54=0,N65,IF(H14=6,0,IF(E53=5,N65,L68)))","v":1},null,null,null,515,"5月15日以上6月未満",5,31,0.95]
[null,null,null,null,null,null,null,6,600,1,null,null,null,null,null,600,"6か月",6,0,1]

{"sheet":"期間②","index":4,"n_rows":71,"n_cols":23,"rows_kept":71,"cut":false,"hidden":true,"merged":[[5,11,5,17]]}
[null,null,"期末勤勉手当の除算期間等の計算"]
[null,null,"対象：期間②"]
[null,null,"育休の開始年月日",{"$f":"計算シート!F5","v":"2023-12-27"}]
[null,null,"育休終了年月日",{"$f":"計算シート!F6","v":"2024-01-16"},null,null,null,"　期間の開始日が育休中か",{"$f":"D18","v":"出勤"},null,"期間の終了日が育休中か",{"$f":"IF(S48=\"\",S47,S48)","v":"出勤"},null,null,null,null,null,null,null,"（数字の整理）","日数カウント開始基準日",null,"数値処理後"]
[null,null,null,{"$f":"IF(D4-D3<1,0,D4-D3)","v":20},null,null,"育休開始日と期間の開始日のうち、大きい方",null,null,null,{"$f":"MAX(D3,C18)","v":"2023-12-27"},null,null,null,null,null,null,null,null,{"$f":"K7+(L7*100000)","v":45317},{"$f":"IF(M14=0,K5,MAX(T5:T10)-100000)","v":"2023-12-27"},"→",{"$f":"IF(M14=0,U5-1,U5)","v":"2023-12-26"}]
[null,null,null,null,null,null,null,null,null,null,"育休の開始日と期間の開始日のうち大きい方","左記の日が育休中なら1で返す",null,null,null,null,null,null,null,45348,"期間の最終日と育休終了日の小さい方"]
[null,null,null,"①期間開始日の1か月後の日(１)",{"$f":"EDATE(C18,1)-1","v":"2023-07-01"},null,null,"育休開始の1か月後の日(a)",{"$f":"EDATE($D$3,1)-1","v":"2024-01-26"},null,{"$f":"EDATE($K$5,1)-1","v":"2024-01-26"},{"$f":"COUNTIF(M7:R7,\"育休中\")","v":0},{"$f":"VLOOKUP(K7,$C$18:$D$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$F$18:$G$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$I$18:$J$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$L$18:$M$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$O$18:$P$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$R$18:$S$48,2,FALSE)","v":{"$error":"#N/A"}},null,45377,{"$f":"MIN(U19-1,D4)","v":"2023-12-01"}]
[null,null,null,"②(１)の翌日～2か月後の日(２)",{"$f":"EDATE(E7,1)","v":"2023-08-01"},null,null,"育休開始の2か月後の日(b)",{"$f":"EDATE($D$3,2)-1","v":"2024-02-26"},null,{"$f":"EDATE($K$5,2)-1","v":"2024-02-26"},{"$f":"COUNTIF(M8:R8,\"育休中\")","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45408,"育休日数",null,"（全休の場合カウントしない）"]
[null,null,null,"③(２)の翌日～3か月後の日(３)",{"$f":"EDATE(E8,1)","v":"2023-09-01"},null,null,"育休開始の3か月後の日(c)",{"$f":"EDATE($D$3,3)-1","v":"2024-03-26"},null,{"$f":"EDATE($K$5,3)-1","v":"2024-03-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45438,{"$f":"IF(U7-W5<1,0,U7-W5)","v":0},"→",{"$f":"IF(V50=0,0,IF(H14=6,0,U9))","v":0}]
[null,null,null,"④(３)の翌日～4か月後の日(４)",{"$f":"EDATE(E9,1)","v":"2023-10-01"},null,null,"育休開始の4か月後の日(d)",{"$f":"EDATE($D$3,4)-1","v":"2024-04-26"},null,{"$f":"EDATE($K$5,4)-1","v":"2024-04-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45469]
[null,null,null,"⑤(４)の翌日～5か月後の日(５)",{"$f":"EDATE(E10,1)","v":"2023-11-01"},null,null,"育休開始の5か月後の日(e)",{"$f":"EDATE($D$3,5)-1","v":"2024-05-26"},null,{"$f":"EDATE($K$5,5)-1","v":"2024-05-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"⑥(５)の翌日～6か月後の日(６)",{"$f":"EDATE(E11,1)","v":"2023-12-01"},null,null,"育休開始の6か月後の日(f)",{"$f":"EDATE($D$3,6)-1","v":"2024-06-26"},null,{"$f":"EDATE($K$5,6)-1","v":"2024-06-26"},{"$f":"COUNTIF(M12:R12,\"育休中\")","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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":"IF(V49=0,6,\"\")","v":""},"月",null,null,"期間中全休でない場合",{"$f":"IF(H14=\"\",SUM(L7:L12),\"\")","v":0},"月",null,null,null,null,null,"もの）を「日数カウント開始基準日」に設定"]
[]
[]
[null,null,"対象日","出勤／育休"]
[null,"期間の開始日→",{"$f":"計算シート!O7","v":"2023-06-02"},{"$f":"IF(AND(C18>$D$3-1,C18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(C18,1)","v":"2023-07-02"},{"$f":"IF(AND(F18>$D$3-1,F18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(F18,1)","v":"2023-08-02"},{"$f":"IF(AND(I18>$D$3-1,I18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(I18,1)","v":"2023-09-02"},{"$f":"IF(AND(L18>$D$3-1,L18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(L18,1)","v":"2023-10-02"},{"$f":"IF(AND(O18>$D$3-1,O18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(O18,1)","v":"2023-11-02"},{"$f":"IF(AND(R18>$D$3-1,R18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,"次の期間の初日"]
[null,null,{"$f":"C18+1","v":"2023-06-03"},{"$f":"IF(AND(C19>$D$3-1,C19<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"F18+1","v":"2023-07-03"},{"$f":"IF(AND(F19>$D$3-1,F19<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"I18+1","v":"2023-08-03"},"出勤",null,{"$f":"L18+1","v":"2023-09-03"},"出勤",null,{"$f":"O18+1","v":"2023-10-03"},"出勤",null,{"$f":"R18+1","v":"2023-11-03"},"出勤",null,{"$f":"EDATE(R18,1)","v":"2023-12-02"}]
[null,null,{"$f":"C19+1","v":"2023-06-04"},"出勤",null,"2023-07-04","出勤",null,"2023-08-04","出勤",null,"2023-09-04","出勤",null,"2023-10-04","出勤",null,"2023-11-04","出勤"]
[null,null,"2023-06-05","出勤",null,"2023-07-05","出勤",null,"2023-08-05","出勤",null,"2023-09-05","出勤",null,"2023-10-05","出勤",null,"2023-11-05","出勤",null,{"$f":"U19","v":"2023-12-02"}]
[null,null,"2023-06-06","出勤",null,"2023-07-06","出勤",null,"2023-08-06","出勤",null,"2023-09-06","出勤",null,"2023-10-06","出勤",null,"2023-11-06","出勤",null,"以降に育休あるか"]
[null,null,"2023-06-07","出勤",null,"2023-07-07","出勤",null,"2023-08-07","出勤",null,"2023-09-07","出勤",null,"2023-10-07","出勤",null,"2023-11-07","出勤",null,{"$f":"IF(D4>U21,\"〇\",\"×\")","v":"〇"}]
[null,null,"2023-06-08","出勤",null,"2023-07-08","出勤",null,"2023-08-08","出勤",null,"2023-09-08","出勤",null,"2023-10-08","出勤",null,"2023-11-08","出勤"]
[null,null,"2023-06-09","出勤",null,"2023-07-09","出勤",null,"2023-08-09","出勤",null,"2023-09-09","出勤",null,"2023-10-09","出勤",null,"2023-11-09","出勤"]
[null,null,"2023-06-10","出勤",null,"2023-07-10","出勤",null,"2023-08-10","出勤",null,"2023-09-10","出勤",null,"2023-10-10","出勤",null,"2023-11-10","出勤"]
[null,null,"2023-06-11","出勤",null,"2023-07-11","出勤",null,"2023-08-11","出勤",null,"2023-09-11","出勤",null,"2023-10-11","出勤",null,"2023-11-11","出勤"]
[null,null,"2023-06-12","出勤",null,"2023-07-12","出勤",null,"2023-08-12","出勤",null,"2023-09-12","出勤",null,"2023-10-12","出勤",null,"2023-11-12","出勤"]
[null,null,"2023-06-13","出勤",null,"2023-07-13","出勤",null,"2023-08-13","出勤",null,"2023-09-13","出勤",null,"2023-10-13","出勤",null,"2023-11-13","出勤"]
[null,null,"2023-06-14","出勤",null,"2023-07-14","出勤",null,"2023-08-14","出勤",null,"2023-09-14","出勤",null,"2023-10-14","出勤",null,"2023-11-14","出勤"]
[null,null,"2023-06-15","出勤",null,"2023-07-15","出勤",null,"2023-08-15","出勤",null,"2023-09-15","出勤",null,"2023-10-15","出勤",null,"2023-11-15","出勤"]
[null,null,"2023-06-16","出勤",null,"2023-07-16","出勤",null,"2023-08-16","出勤",null,"2023-09-16","出勤",null,"2023-10-16","出勤",null,"2023-11-16","出勤"]
[null,null,"2023-06-17","出勤",null,"2023-07-17","出勤",null,"2023-08-17","出勤",null,"2023-09-17","出勤",null,"2023-10-17","出勤",null,"2023-11-17","出勤"]
[null,null,"2023-06-18","出勤",null,"2023-07-18","出勤",null,"2023-08-18","出勤",null,"2023-09-18","出勤",null,"2023-10-18","出勤",null,"2023-11-18","出勤"]
[null,null,"2023-06-19","出勤",null,"2023-07-19","出勤",null,"2023-08-19","出勤",null,"2023-09-19","出勤",null,"2023-10-19","出勤",null,"2023-11-19","出勤"]
[null,null,"2023-06-20","出勤",null,"2023-07-20","出勤",null,"2023-08-20","出勤",null,"2023-09-20","出勤",null,"2023-10-20","出勤",null,"2023-11-20","出勤"]
[null,null,"2023-06-21","出勤",null,"2023-07-21","出勤",null,"2023-08-21","出勤",null,"2023-09-21","出勤",null,"2023-10-21","出勤",null,"2023-11-21","出勤"]
[null,null,"2023-06-22","出勤",null,"2023-07-22","出勤",null,"2023-08-22","出勤",null,"2023-09-22","出勤",null,"2023-10-22","出勤",null,"2023-11-22","出勤"]
[null,null,"2023-06-23","出勤",null,"2023-07-23","出勤",null,"2023-08-23","出勤",null,"2023-09-23","出勤",null,"2023-10-23","出勤",null,"2023-11-23","出勤"]
[null,null,"2023-06-24","出勤",null,"2023-07-24","出勤",null,"2023-08-24","出勤",null,"2023-09-24","出勤",null,"2023-10-24","出勤",null,"2023-11-24","出勤"]
[null,null,"2023-06-25","出勤",null,"2023-07-25","出勤",null,"2023-08-25","出勤",null,"2023-09-25","出勤",null,"2023-10-25","出勤",null,"2023-11-25","出勤"]
[null,null,"2023-06-26","出勤",null,"2023-07-26","出勤",null,"2023-08-26","出勤",null,"2023-09-26","出勤",null,"2023-10-26","出勤",null,"2023-11-26","出勤"]
[null,null,"2023-06-27","出勤",null,"2023-07-27","出勤",null,"2023-08-27","出勤",null,"2023-09-27","出勤",null,"2023-10-27","出勤",null,"2023-11-27","出勤"]
[null,null,{"$f":"IF(C43=\"\",\"\",IF(C43+2>$F$18,\"\",C43+1))","v":"2023-06-28"},{"$f":"IF(C44=\"\",\"\",IF(AND(C44>$D$3-1,C44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(F43=\"\",\"\",IF(F43+2>$I$18,\"\",F43+1))","v":"2023-07-28"},{"$f":"IF(F44=\"\",\"\",IF(AND(F44>$D$3-1,F44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(I43=\"\",\"\",IF(I43+2>$L$18,\"\",I43+1))","v":"2023-08-28"},{"$f":"IF(I44=\"\",\"\",IF(AND(I44>$D$3-1,I44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(L43=\"\",\"\",IF(L43+2>$O$18,\"\",L43+1))","v":"2023-09-28"},{"$f":"IF(L44=\"\",\"\",IF(AND(L44>$D$3-1,L44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(O43=\"\",\"\",IF(O43+2>$R$18,\"\",O43+1))","v":"2023-10-28"},{"$f":"IF(O44=\"\",\"\",IF(AND(O44>$D$3-1,O44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(R43=\"\",\"\",IF(R43+2>$U$19,\"\",R43+1))","v":"2023-11-28"},{"$f":"IF(R44=\"\",\"\",IF(AND(R44>$D$3-1,R44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"}]
[null,null,"2023-06-29",{"$f":"IF(C45=\"\",\"\",IF(AND(C45>$D$3-1,C45<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,"2023-07-29",{"$f":"IF(F45=\"\",\"\",IF(AND(F45>$D$3-1,F45<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,"2023-08-29","出勤",null,"2023-09-29","出勤",null,"2023-10-29","出勤",null,"2023-11-29","出勤"]
[null,null,"2023-06-30","出勤",null,"2023-07-30","出勤",null,"2023-08-30","出勤",null,"2023-09-30","出勤",null,"2023-10-30","出勤",null,"2023-11-30","出勤"]
[null,null,"2023-07-01","出勤",null,"2023-07-31","出勤",null,"2023-08-31","出勤",null,"2023-10-01","出勤",null,"2023-10-31","出勤",null,"2023-12-01","出勤"]
[null,null,"","",null,"2023-08-01","出勤",null,"2023-09-01","出勤",null,"","",null,"2023-11-01","出勤",null,"",""]
[null,null,"","",{"$f":"VLOOKUP(U7,C18:D48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(F48=\"\",\"\",IF(F48+2>$I$18,\"\",F48+1))","v":""},"",{"$f":"VLOOKUP(U7,F18:G48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I48=\"\",\"\",IF(I48+2>$L$18,\"\",I48+1))","v":""},"",{"$f":"VLOOKUP(U7,I18:J48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(L48=\"\",\"\",IF(L48+2>$O$18,\"\",L48+1))","v":""},"",{"$f":"VLOOKUP(U7,L18:M48,2,FALSE)","v":{"$error":"#N/A"}},"","",{"$f":"VLOOKUP(U7,O18:P48,2,FALSE)","v":{"$error":"#N/A"}},"","",{"$f":"VLOOKUP(U7,R18:S48,2,FALSE)","v":"出勤"},null,{"$f":"C50+F50+I50+L50+O50+R50-D50-G50-J50-M50-P50-S50","v":183}]
[null,"育休の合計",{"$f":"COUNTIF(C18:C49,\">0\")","v":30},{"$f":"COUNTIF(D18:D49,\"育休中\")","v":0},{"$f":"IF(DAY(C48)=1,IF(OR(E49=\"育休中\",E49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(F18:F49,\">0\")","v":31},{"$f":"COUNTIF(G18:G49,\"育休中\")","v":0},{"$f":"IF(DAY(F48)=1,IF(OR(H49=\"育休中\",H49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(I18:I49,\">0\")","v":31},{"$f":"COUNTIF(J18:J49,\"育休中\")","v":0},{"$f":"IF(DAY(I48)=1,IF(OR(K49=\"育休中\",K49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(L18:L49,\">0\")","v":30},{"$f":"COUNTIF(M18:M49,\"育休中\")","v":0},{"$f":"IF(DAY(L48)=1,IF(OR(N49=\"育休中\",N49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(O18:O49,\">0\")","v":31},{"$f":"COUNTIF(P18:P49,\"育休中\")","v":0},{"$f":"IF(DAY(O48)=1,IF(OR(Q49=\"育休中\",Q49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(R18:R49,\">0\")","v":30},{"$f":"COUNTIF(S18:S49,\"育休中\")","v":0},{"$f":"IF(DAY(R48)=1,IF(OR(T49=\"育休中\",T49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},"育休日数",{"$f":"D50+G50+J50+M50+P50+S50","v":0}]
[null,null,null,null,{"$f":"IF(C50=D50,0,IFERROR(E50,0))","v":0},null,null,{"$f":"IF(F50=G50,0,IFERROR(H50,0))","v":0},null,null,{"$f":"IF(I50=J50,0,IFERROR(K50,0))","v":0},null,null,{"$f":"IF(L50=M50,0,IFERROR(N50,0))","v":0},null,null,{"$f":"IF(O50=P50,0,IFERROR(Q50,0))","v":0},null,null,{"$f":"IF(R50=S50,0,IFERROR(T50,0))","v":0}]
[]
[null,null,null,"勤務月換算",{"$f":"IF(H14=6,0,6-M14-IF(W9>0,1,0))","v":6},null,"↓月数×100","計算上の値",null,{"$f":"IF((DAY($D$3)=DAY(EDATE($D$3,1)))=TRUE,EDATE($D$3,1)-1,EDATE($D$3,1))","v":"2024-01-26"}]
[null,null,null,"勤務日換算",{"$f":"IF(W9=0,0,IF(E53=6,0,IF(H14=6,0,30-W9)))+E56","v":0},null,{"$f":"E53*100","v":600},{"$f":"G54+E55+E54","v":600},null,{"$f":"D4-J53","v":-10}]
[null,null,null,"(5月30日の場合の調整値)",{"$f":"IF(AND(M14=5,W9=30),1,0)","v":0}]
[null,null,null,"(月間31日で休業日数30日の場合の調整値)",{"$f":"SUM(E51:T51)","v":0}]
[]
[null,null,null,null,null,null,null,"（Ａ）の値","（左記数値を下記数値に置換）","（勤務日が０の場合1で返す）","（置換後）","日数足し上げ",null,null,null,0,0,0,0,0,null,{"$f":"VLOOKUP(H54,P58:T71,5,TRUE)","v":1}]
[null,null,null,"①",null,"②",null,0,0,{"$f":"IF(AND(K$59=I59,$F$61=0),1,0)","v":0},{"$f":"VLOOKUP(F60,H59:I71,2,TRUE)","v":600},{"$f":"IF(SUM(J59:J71)=1,K59,IF(F61=0,(K59+F61)-70,K59+F61))","v":600},null,null,null,1,"15日未満",0,15,0.05]
[null,null,"1/2除算後の休業月数",{"$f":"IF(H14=6,3,M14/2)","v":0},"勤務月数換算（Ａ）",{"$f":"IF(F61>0,6-D60-1,6-D60)","v":6},null,0.5,85,null,null,null,null,null,null,15,"15日以上1月未満",1,0,0.1,null,"（数値処理後）期間率"]
[null,null,"1/2除算後の休業日数",{"$f":"W9/2","v":0},"勤務日数換算（Ｂ）",{"$f":"IF(D61=0,0,30-D61)","v":0},null,1,100,{"$f":"IF(AND(K$59=I61,$F$61=0),1,0)","v":0},null,null,null,null,null,100,"1月以上1月15日未満",1,15,0.15,null,{"$f":"IF(J54=0,T71,IF(E53=5,T71,V58))","v":1}]
[null,null,null,null,null,null,null,1.5,185,null,"（係数）",null,null,null,null,115,"1月15日以上2月未満",2,0,0.2]
[null,null,null,null,null,null,null,2,200,0,230,"②3か月以上5か月未満",3,0.6,null,200,"2月以上2月15日未満",2,15,0.3]
[null,null,null,"③",null,"④",null,2.5,285,null,430,"③5か月以上6か月未満",5,0.8,null,215,"2月15日以上3月未満",3,0,0.4]
[null,null,"月数の小数点以下を補正",{"$f":"INT(MOD(SIGN(L59)*L59/100,10))","v":6},"（数値処理後）勤務月数",{"$f":"IF(V49=0,3,IF(AND(F60=6,F61=0),F60,D65))","v":6},null,3,300,0,530,"④6か月",6,1,null,300,"3月以上3月15日未満",3,15,0.5]
[null,null,null,{"$f":"L59-D65*100","v":0},"（数値処理後）勤務日数",{"$f":"IF(V49=0,0,IF(AND(F60=6,F61=0),F61,D66))","v":0},null,3.5,385,null,null,null,null,null,null,315,"3月15日以上4月未満",4,0,0.6]
[null,null,null,null,null,null,null,4,400,0,null,"判定",null,null,null,400,"4月以上4月15日未満",4,15,0.7]
[null,null,null,null,null,null,null,4.5,485,null,null,{"$f":"VLOOKUP(L59,K63:N65,4,TRUE)","v":1},null,null,null,415,"4月15日以上5月未満",5,0,0.8]
[null,null,null,null,null,null,null,5,500,0,null,"（数値処理後）在職期間別割合",null,null,null,500,"5月以上5月15日未満",5,15,0.9]
[null,null,null,null,null,null,null,5.5,585,null,null,{"$f":"IF(J54=0,N65,IF(H14=6,0,IF(E53=5,N65,L68)))","v":1},null,null,null,515,"5月15日以上6月未満",5,31,0.95]
[null,null,null,null,null,null,null,6,600,1,null,null,null,null,null,600,"6か月",6,0,1]

{"sheet":"期間③","index":5,"n_rows":71,"n_cols":23,"rows_kept":71,"cut":false,"hidden":true,"merged":[[5,11,5,17]]}
[null,null,"期末勤勉手当の除算期間等の計算"]
[null,null,"対象：期間③"]
[null,null,"育休の開始年月日",{"$f":"計算シート!F5","v":"2023-12-27"}]
[null,null,"育休終了年月日",{"$f":"計算シート!F6","v":"2024-01-16"},null,null,null,"　期間の開始日が育休中か",{"$f":"D18","v":"出勤"},null,"期間の終了日が育休中か",{"$f":"IF(S48=\"\",S47,S48)","v":"出勤"},null,null,null,null,null,null,null,"（数字の整理）","日数カウント開始基準日",null,"数値処理後"]
[null,null,null,{"$f":"IF(D4-D3<1,0,D4-D3)","v":20},null,null,"育休開始日と期間の開始日のうち、大きい方",null,null,null,{"$f":"MAX(D3,C18)","v":"2023-12-27"},null,null,null,null,null,null,null,null,{"$f":"K7+(L7*100000)","v":45317},{"$f":"IF(M14=0,K5,MAX(T5:T10)-100000)","v":"2023-12-27"},"→",{"$f":"IF(M14=0,U5-1,U5)","v":"2023-12-26"}]
[null,null,null,null,null,null,null,null,null,null,"育休の開始日と期間の開始日のうち大きい方","左記の日が育休中なら1で返す",null,null,null,null,null,null,null,45348,"期間の最終日と育休終了日の小さい方"]
[null,null,null,"①期間開始日の1か月後の日(１)",{"$f":"EDATE(C18,1)-1","v":"2024-01-01"},null,null,"育休開始の1か月後の日(a)",{"$f":"EDATE($D$3,1)-1","v":"2024-01-26"},null,{"$f":"EDATE($K$5,1)-1","v":"2024-01-26"},{"$f":"COUNTIF(M7:R7,\"育休中\")","v":0},{"$f":"VLOOKUP(K7,$C$18:$D$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$F$18:$G$48,2,FALSE)","v":"出勤"},{"$f":"VLOOKUP(K7,$I$18:$J$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$L$18:$M$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$O$18:$P$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$R$18:$S$48,2,FALSE)","v":{"$error":"#N/A"}},null,45377,{"$f":"MIN(U19-1,D4)","v":"2024-01-16"}]
[null,null,null,"②(１)の翌日～2か月後の日(２)",{"$f":"EDATE(E7,1)","v":"2024-02-01"},null,null,"育休開始の2か月後の日(b)",{"$f":"EDATE($D$3,2)-1","v":"2024-02-26"},null,{"$f":"EDATE($K$5,2)-1","v":"2024-02-26"},{"$f":"COUNTIF(M8:R8,\"育休中\")","v":0},{"$error":"#N/A"},{"$error":"#N/A"},"出勤",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45408,"育休日数",null,"（全休の場合カウントしない）"]
[null,null,null,"③(２)の翌日～3か月後の日(３)",{"$f":"EDATE(E8,1)","v":"2024-03-01"},null,null,"育休開始の3か月後の日(c)",{"$f":"EDATE($D$3,3)-1","v":"2024-03-26"},null,{"$f":"EDATE($K$5,3)-1","v":"2024-03-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"出勤",{"$error":"#N/A"},{"$error":"#N/A"},null,45438,{"$f":"IF(U7-W5<1,0,U7-W5)","v":21},"→",{"$f":"IF(V50=0,0,IF(H14=6,0,U9))","v":21}]
[null,null,null,"④(３)の翌日～4か月後の日(４)",{"$f":"EDATE(E9,1)","v":"2024-04-01"},null,null,"育休開始の4か月後の日(d)",{"$f":"EDATE($D$3,4)-1","v":"2024-04-26"},null,{"$f":"EDATE($K$5,4)-1","v":"2024-04-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"出勤",{"$error":"#N/A"},null,45469]
[null,null,null,"⑤(４)の翌日～5か月後の日(５)",{"$f":"EDATE(E10,1)","v":"2024-05-01"},null,null,"育休開始の5か月後の日(e)",{"$f":"EDATE($D$3,5)-1","v":"2024-05-26"},null,{"$f":"EDATE($K$5,5)-1","v":"2024-05-26"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"出勤"]
[null,null,null,"⑥(５)の翌日～6か月後の日(６)",{"$f":"EDATE(E11,1)","v":"2024-06-01"},null,null,"育休開始の6か月後の日(f)",{"$f":"EDATE($D$3,6)-1","v":"2024-06-26"},null,{"$f":"EDATE($K$5,6)-1","v":"2024-06-26"},{"$f":"COUNTIF(M12:R12,\"育休中\")","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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":"IF(V49=0,6,\"\")","v":""},"月",null,null,"期間中全休でない場合",{"$f":"IF(H14=\"\",SUM(L7:L12),\"\")","v":0},"月",null,null,null,null,null,"もの）を「日数カウント開始基準日」に設定"]
[]
[]
[null,null,"対象日","出勤／育休"]
[null,"期間の開始日→",{"$f":"計算シート!P7","v":"2023-12-02"},{"$f":"IF(AND(C18>$D$3-1,C18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(C18,1)","v":"2024-01-02"},{"$f":"IF(AND(F18>$D$3-1,F18<$D$4+1),\"育休中\",\"出勤\")","v":"育休中"},null,{"$f":"EDATE(F18,1)","v":"2024-02-02"},{"$f":"IF(AND(I18>$D$3-1,I18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(I18,1)","v":"2024-03-02"},{"$f":"IF(AND(L18>$D$3-1,L18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(L18,1)","v":"2024-04-02"},{"$f":"IF(AND(O18>$D$3-1,O18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(O18,1)","v":"2024-05-02"},{"$f":"IF(AND(R18>$D$3-1,R18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,"次の期間の初日"]
[null,null,{"$f":"C18+1","v":"2023-12-03"},{"$f":"IF(AND(C19>$D$3-1,C19<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"F18+1","v":"2024-01-03"},{"$f":"IF(AND(F19>$D$3-1,F19<$D$4+1),\"育休中\",\"出勤\")","v":"育休中"},null,{"$f":"I18+1","v":"2024-02-03"},"出勤",null,{"$f":"L18+1","v":"2024-03-03"},"出勤",null,{"$f":"O18+1","v":"2024-04-03"},"出勤",null,{"$f":"R18+1","v":"2024-05-03"},"出勤",null,{"$f":"EDATE(R18,1)","v":"2024-06-02"}]
[null,null,{"$f":"C19+1","v":"2023-12-04"},"出勤",null,"2024-01-04","育休中",null,"2024-02-04","出勤",null,"2024-03-04","出勤",null,"2024-04-04","出勤",null,"2024-05-04","出勤"]
[null,null,"2023-12-05","出勤",null,"2024-01-05","育休中",null,"2024-02-05","出勤",null,"2024-03-05","出勤",null,"2024-04-05","出勤",null,"2024-05-05","出勤",null,{"$f":"U19","v":"2024-06-02"}]
[null,null,"2023-12-06","出勤",null,"2024-01-06","育休中",null,"2024-02-06","出勤",null,"2024-03-06","出勤",null,"2024-04-06","出勤",null,"2024-05-06","出勤",null,"以降に育休あるか"]
[null,null,"2023-12-07","出勤",null,"2024-01-07","育休中",null,"2024-02-07","出勤",null,"2024-03-07","出勤",null,"2024-04-07","出勤",null,"2024-05-07","出勤",null,{"$f":"IF(D4>U21,\"〇\",\"×\")","v":"×"}]
[null,null,"2023-12-08","出勤",null,"2024-01-08","育休中",null,"2024-02-08","出勤",null,"2024-03-08","出勤",null,"2024-04-08","出勤",null,"2024-05-08","出勤"]
[null,null,"2023-12-09","出勤",null,"2024-01-09","育休中",null,"2024-02-09","出勤",null,"2024-03-09","出勤",null,"2024-04-09","出勤",null,"2024-05-09","出勤"]
[null,null,"2023-12-10","出勤",null,"2024-01-10","育休中",null,"2024-02-10","出勤",null,"2024-03-10","出勤",null,"2024-04-10","出勤",null,"2024-05-10","出勤"]
[null,null,"2023-12-11","出勤",null,"2024-01-11","育休中",null,"2024-02-11","出勤",null,"2024-03-11","出勤",null,"2024-04-11","出勤",null,"2024-05-11","出勤"]
[null,null,"2023-12-12","出勤",null,"2024-01-12","育休中",null,"2024-02-12","出勤",null,"2024-03-12","出勤",null,"2024-04-12","出勤",null,"2024-05-12","出勤"]
[null,null,"2023-12-13","出勤",null,"2024-01-13","育休中",null,"2024-02-13","出勤",null,"2024-03-13","出勤",null,"2024-04-13","出勤",null,"2024-05-13","出勤"]
[null,null,"2023-12-14","出勤",null,"2024-01-14","育休中",null,"2024-02-14","出勤",null,"2024-03-14","出勤",null,"2024-04-14","出勤",null,"2024-05-14","出勤"]
[null,null,"2023-12-15","出勤",null,"2024-01-15","育休中",null,"2024-02-15","出勤",null,"2024-03-15","出勤",null,"2024-04-15","出勤",null,"2024-05-15","出勤"]
[null,null,"2023-12-16","出勤",null,"2024-01-16","育休中",null,"2024-02-16","出勤",null,"2024-03-16","出勤",null,"2024-04-16","出勤",null,"2024-05-16","出勤"]
[null,null,"2023-12-17","出勤",null,"2024-01-17","出勤",null,"2024-02-17","出勤",null,"2024-03-17","出勤",null,"2024-04-17","出勤",null,"2024-05-17","出勤"]
[null,null,"2023-12-18","出勤",null,"2024-01-18","出勤",null,"2024-02-18","出勤",null,"2024-03-18","出勤",null,"2024-04-18","出勤",null,"2024-05-18","出勤"]
[null,null,"2023-12-19","出勤",null,"2024-01-19","出勤",null,"2024-02-19","出勤",null,"2024-03-19","出勤",null,"2024-04-19","出勤",null,"2024-05-19","出勤"]
[null,null,"2023-12-20","出勤",null,"2024-01-20","出勤",null,"2024-02-20","出勤",null,"2024-03-20","出勤",null,"2024-04-20","出勤",null,"2024-05-20","出勤"]
[null,null,"2023-12-21","出勤",null,"2024-01-21","出勤",null,"2024-02-21","出勤",null,"2024-03-21","出勤",null,"2024-04-21","出勤",null,"2024-05-21","出勤"]
[null,null,"2023-12-22","出勤",null,"2024-01-22","出勤",null,"2024-02-22","出勤",null,"2024-03-22","出勤",null,"2024-04-22","出勤",null,"2024-05-22","出勤"]
[null,null,"2023-12-23","出勤",null,"2024-01-23","出勤",null,"2024-02-23","出勤",null,"2024-03-23","出勤",null,"2024-04-23","出勤",null,"2024-05-23","出勤"]
[null,null,"2023-12-24","出勤",null,"2024-01-24","出勤",null,"2024-02-24","出勤",null,"2024-03-24","出勤",null,"2024-04-24","出勤",null,"2024-05-24","出勤"]
[null,null,"2023-12-25","出勤",null,"2024-01-25","出勤",null,"2024-02-25","出勤",null,"2024-03-25","出勤",null,"2024-04-25","出勤",null,"2024-05-25","出勤"]
[null,null,"2023-12-26","出勤",null,"2024-01-26","出勤",null,"2024-02-26","出勤",null,"2024-03-26","出勤",null,"2024-04-26","出勤",null,"2024-05-26","出勤"]
[null,null,"2023-12-27","育休中",null,"2024-01-27","出勤",null,"2024-02-27","出勤",null,"2024-03-27","出勤",null,"2024-04-27","出勤",null,"2024-05-27","出勤"]
[null,null,{"$f":"IF(C43=\"\",\"\",IF(C43+2>$F$18,\"\",C43+1))","v":"2023-12-28"},{"$f":"IF(C44=\"\",\"\",IF(AND(C44>$D$3-1,C44<$D$4+1),\"育休中\",\"出勤\"))","v":"育休中"},null,{"$f":"IF(F43=\"\",\"\",IF(F43+2>$I$18,\"\",F43+1))","v":"2024-01-28"},{"$f":"IF(F44=\"\",\"\",IF(AND(F44>$D$3-1,F44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(I43=\"\",\"\",IF(I43+2>$L$18,\"\",I43+1))","v":"2024-02-28"},{"$f":"IF(I44=\"\",\"\",IF(AND(I44>$D$3-1,I44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(L43=\"\",\"\",IF(L43+2>$O$18,\"\",L43+1))","v":"2024-03-28"},{"$f":"IF(L44=\"\",\"\",IF(AND(L44>$D$3-1,L44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(O43=\"\",\"\",IF(O43+2>$R$18,\"\",O43+1))","v":"2024-04-28"},{"$f":"IF(O44=\"\",\"\",IF(AND(O44>$D$3-1,O44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(R43=\"\",\"\",IF(R43+2>$U$19,\"\",R43+1))","v":"2024-05-28"},{"$f":"IF(R44=\"\",\"\",IF(AND(R44>$D$3-1,R44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"}]
[null,null,"2023-12-29",{"$f":"IF(C45=\"\",\"\",IF(AND(C45>$D$3-1,C45<$D$4+1),\"育休中\",\"出勤\"))","v":"育休中"},null,"2024-01-29",{"$f":"IF(F45=\"\",\"\",IF(AND(F45>$D$3-1,F45<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,"2024-02-29","出勤",null,"2024-03-29","出勤",null,"2024-04-29","出勤",null,"2024-05-29","出勤"]
[null,null,"2023-12-30","育休中",null,"2024-01-30","出勤",null,"2024-03-01","出勤",null,"2024-03-30","出勤",null,"2024-04-30","出勤",null,"2024-05-30","出勤"]
[null,null,"2023-12-31","育休中",null,"2024-01-31","出勤",null,"","",null,"2024-03-31","出勤",null,"2024-05-01","出勤",null,"2024-05-31","出勤"]
[null,null,"2024-01-01","育休中",null,"2024-02-01","出勤",null,"","",null,"2024-04-01","出勤",null,"","",null,"2024-06-01","出勤"]
[null,null,"","",{"$f":"VLOOKUP(U7,C18:D48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(F48=\"\",\"\",IF(F48+2>$I$18,\"\",F48+1))","v":""},"",{"$f":"VLOOKUP(U7,F18:G48,2,FALSE)","v":"育休中"},{"$f":"IF(I48=\"\",\"\",IF(I48+2>$L$18,\"\",I48+1))","v":""},"",{"$f":"VLOOKUP(U7,I18:J48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(L48=\"\",\"\",IF(L48+2>$O$18,\"\",L48+1))","v":""},"",{"$f":"VLOOKUP(U7,L18:M48,2,FALSE)","v":{"$error":"#N/A"}},"","",{"$f":"VLOOKUP(U7,O18:P48,2,FALSE)","v":{"$error":"#N/A"}},"","",{"$f":"VLOOKUP(U7,R18:S48,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"C50+F50+I50+L50+O50+R50-D50-G50-J50-M50-P50-S50","v":162}]
[null,"育休の合計",{"$f":"COUNTIF(C18:C49,\">0\")","v":31},{"$f":"COUNTIF(D18:D49,\"育休中\")","v":6},{"$f":"IF(DAY(C48)=1,IF(OR(E49=\"育休中\",E49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(F18:F49,\">0\")","v":31},{"$f":"COUNTIF(G18:G49,\"育休中\")","v":15},{"$f":"IF(DAY(F48)=1,IF(OR(H49=\"育休中\",H49=\"出勤\"),1,0),0)","v":1},{"$f":"COUNTIF(I18:I49,\">0\")","v":29},{"$f":"COUNTIF(J18:J49,\"育休中\")","v":0},{"$f":"IF(DAY(I48)=1,IF(OR(K49=\"育休中\",K49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(L18:L49,\">0\")","v":31},{"$f":"COUNTIF(M18:M49,\"育休中\")","v":0},{"$f":"IF(DAY(L48)=1,IF(OR(N49=\"育休中\",N49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(O18:O49,\">0\")","v":30},{"$f":"COUNTIF(P18:P49,\"育休中\")","v":0},{"$f":"IF(DAY(O48)=1,IF(OR(Q49=\"育休中\",Q49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(R18:R49,\">0\")","v":31},{"$f":"COUNTIF(S18:S49,\"育休中\")","v":0},{"$f":"IF(DAY(R48)=1,IF(OR(T49=\"育休中\",T49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},"育休日数",{"$f":"D50+G50+J50+M50+P50+S50","v":21}]
[null,null,null,null,{"$f":"IF(C50=D50,0,IFERROR(E50,0))","v":0},null,null,{"$f":"IF(F50=G50,0,IFERROR(H50,0))","v":1},null,null,{"$f":"IF(I50=J50,0,IFERROR(K50,0))","v":0},null,null,{"$f":"IF(L50=M50,0,IFERROR(N50,0))","v":0},null,null,{"$f":"IF(O50=P50,0,IFERROR(Q50,0))","v":0},null,null,{"$f":"IF(R50=S50,0,IFERROR(T50,0))","v":0}]
[]
[null,null,null,"勤務月換算",{"$f":"IF(H14=6,0,6-M14-IF(W9>0,1,0))","v":5},null,"↓月数×100","計算上の値",null,{"$f":"IF((DAY($D$3)=DAY(EDATE($D$3,1)))=TRUE,EDATE($D$3,1)-1,EDATE($D$3,1))","v":"2024-01-26"}]
[null,null,null,"勤務日換算",{"$f":"IF(W9=0,0,IF(E53=6,0,IF(H14=6,0,30-W9)))+E56","v":10},null,{"$f":"E53*100","v":500},{"$f":"G54+E55+E54","v":510},null,{"$f":"D4-J53","v":-10}]
[null,null,null,"(5月30日の場合の調整値)",{"$f":"IF(AND(M14=5,W9=30),1,0)","v":0}]
[null,null,null,"(月間31日で休業日数30日の場合の調整値)",{"$f":"SUM(E51:T51)","v":1}]
[]
[null,null,null,null,null,null,null,"（Ａ）の値","（左記数値を下記数値に置換）","（勤務日が０の場合1で返す）","（置換後）","日数足し上げ",null,null,null,0,0,0,0,0,null,{"$f":"VLOOKUP(H54,P58:T71,5,TRUE)","v":0.9}]
[null,null,null,"①",null,"②",null,0,0,{"$f":"IF(AND(K$59=I59,$F$61=0),1,0)","v":0},{"$f":"VLOOKUP(F60,H59:I71,2,TRUE)","v":500},{"$f":"IF(SUM(J59:J71)=1,K59,IF(F61=0,(K59+F61)-70,K59+F61))","v":519.5},null,null,null,1,"15日未満",0,15,0.05]
[null,null,"1/2除算後の休業月数",{"$f":"IF(H14=6,3,M14/2)","v":0},"勤務月数換算（Ａ）",{"$f":"IF(F61>0,6-D60-1,6-D60)","v":5},null,0.5,85,null,null,null,null,null,null,15,"15日以上1月未満",1,0,0.1,null,"（数値処理後）期間率"]
[null,null,"1/2除算後の休業日数",{"$f":"W9/2","v":10.5},"勤務日数換算（Ｂ）",{"$f":"IF(D61=0,0,30-D61)","v":19.5},null,1,100,{"$f":"IF(AND(K$59=I61,$F$61=0),1,0)","v":0},null,null,null,null,null,100,"1月以上1月15日未満",1,15,0.15,null,{"$f":"IF(J54=0,T71,IF(E53=5,T71,V58))","v":1}]
[null,null,null,null,null,null,null,1.5,185,null,"（係数）",null,null,null,null,115,"1月15日以上2月未満",2,0,0.2]
[null,null,null,null,null,null,null,2,200,0,230,"②3か月以上5か月未満",3,0.6,null,200,"2月以上2月15日未満",2,15,0.3]
[null,null,null,"③",null,"④",null,2.5,285,null,430,"③5か月以上6か月未満",5,0.8,null,215,"2月15日以上3月未満",3,0,0.4]
[null,null,"月数の小数点以下を補正",{"$f":"INT(MOD(SIGN(L59)*L59/100,10))","v":5},"（数値処理後）勤務月数",{"$f":"IF(V49=0,3,IF(AND(F60=6,F61=0),F60,D65))","v":5},null,3,300,0,530,"④6か月",6,1,null,300,"3月以上3月15日未満",3,15,0.5]
[null,null,null,{"$f":"L59-D65*100","v":19.5},"（数値処理後）勤務日数",{"$f":"IF(V49=0,0,IF(AND(F60=6,F61=0),F61,D66))","v":19.5},null,3.5,385,null,null,null,null,null,null,315,"3月15日以上4月未満",4,0,0.6]
[null,null,null,null,null,null,null,4,400,0,null,"判定",null,null,null,400,"4月以上4月15日未満",4,15,0.7]
[null,null,null,null,null,null,null,4.5,485,null,null,{"$f":"VLOOKUP(L59,K63:N65,4,TRUE)","v":0.8},null,null,null,415,"4月15日以上5月未満",5,0,0.8]
[null,null,null,null,null,null,null,5,500,0,null,"（数値処理後）在職期間別割合",null,null,null,500,"5月以上5月15日未満",5,15,0.9]
[null,null,null,null,null,null,null,5.5,585,null,null,{"$f":"IF(J54=0,N65,IF(H14=6,0,IF(E53=5,N65,L68)))","v":1},null,null,null,515,"5月15日以上6月未満",5,31,0.95]
[null,null,null,null,null,null,null,6,600,0,null,null,null,null,null,600,"6か月",6,0,1]

{"sheet":"期間④","index":6,"n_rows":71,"n_cols":23,"rows_kept":71,"cut":false,"hidden":true,"merged":[[5,11,5,17]]}
[null,null,"期末勤勉手当の除算期間等の計算"]
[null,null,"対象：期間④"]
[null,null,"育休の開始年月日",{"$f":"計算シート!F5","v":"2023-12-27"}]
[null,null,"育休終了年月日",{"$f":"計算シート!F6","v":"2024-01-16"},null,null,null,"　期間の開始日が育休中か",{"$f":"D18","v":"出勤"},null,"期間の終了日が育休中か",{"$f":"IF(S48=\"\",S47,S48)","v":"出勤"},null,null,null,null,null,null,null,"（数字の整理）","日数カウント開始基準日",null,"数値処理後"]
[null,null,null,{"$f":"IF(D4-D3<1,0,D4-D3)","v":20},null,null,"育休開始日と期間の開始日のうち、大きい方",null,null,null,{"$f":"MAX(D3,C18)","v":"2024-06-02"},null,null,null,null,null,null,null,null,{"$f":"K7+(L7*100000)","v":45474},{"$f":"IF(M14=0,K5,MAX(T5:T10)-100000)","v":"2024-06-02"},"→",{"$f":"IF(M14=0,U5-1,U5)","v":"2024-06-01"}]
[null,null,null,null,null,null,null,null,null,null,"育休の開始日と期間の開始日のうち大きい方","左記の日が育休中なら1で返す",null,null,null,null,null,null,null,45505,"期間の最終日と育休終了日の小さい方"]
[null,null,null,"①期間開始日の1か月後の日(１)",{"$f":"EDATE(C18,1)-1","v":"2024-07-01"},null,null,"育休開始の1か月後の日(a)",{"$f":"EDATE($D$3,1)-1","v":"2024-01-26"},null,{"$f":"EDATE($K$5,1)-1","v":"2024-07-01"},{"$f":"COUNTIF(M7:R7,\"育休中\")","v":0},{"$f":"VLOOKUP(K7,$C$18:$D$48,2,FALSE)","v":"出勤"},{"$f":"VLOOKUP(K7,$F$18:$G$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$I$18:$J$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$L$18:$M$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$O$18:$P$48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K7,$R$18:$S$48,2,FALSE)","v":{"$error":"#N/A"}},null,45536,{"$f":"MIN(U19-1,D4)","v":"2024-01-16"}]
[null,null,null,"②(１)の翌日～2か月後の日(２)",{"$f":"EDATE(E7,1)","v":"2024-08-01"},null,null,"育休開始の2か月後の日(b)",{"$f":"EDATE($D$3,2)-1","v":"2024-02-26"},null,{"$f":"EDATE($K$5,2)-1","v":"2024-08-01"},{"$f":"COUNTIF(M8:R8,\"育休中\")","v":0},{"$error":"#N/A"},"出勤",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45566,"育休日数",null,"（全休の場合カウントしない）"]
[null,null,null,"③(２)の翌日～3か月後の日(３)",{"$f":"EDATE(E8,1)","v":"2024-09-01"},null,null,"育休開始の3か月後の日(c)",{"$f":"EDATE($D$3,3)-1","v":"2024-03-26"},null,{"$f":"EDATE($K$5,3)-1","v":"2024-09-01"},0,{"$error":"#N/A"},{"$error":"#N/A"},"出勤",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,45597,{"$f":"IF(U7-W5<1,0,U7-W5)","v":0},"→",{"$f":"IF(V50=0,0,IF(H14=6,0,U9))","v":0}]
[null,null,null,"④(３)の翌日～4か月後の日(４)",{"$f":"EDATE(E9,1)","v":"2024-10-01"},null,null,"育休開始の4か月後の日(d)",{"$f":"EDATE($D$3,4)-1","v":"2024-04-26"},null,{"$f":"EDATE($K$5,4)-1","v":"2024-10-01"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"出勤",{"$error":"#N/A"},{"$error":"#N/A"},null,45627]
[null,null,null,"⑤(４)の翌日～5か月後の日(５)",{"$f":"EDATE(E10,1)","v":"2024-11-01"},null,null,"育休開始の5か月後の日(e)",{"$f":"EDATE($D$3,5)-1","v":"2024-05-26"},null,{"$f":"EDATE($K$5,5)-1","v":"2024-11-01"},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"出勤",{"$error":"#N/A"}]
[null,null,null,"⑥(５)の翌日～6か月後の日(６)",{"$f":"EDATE(E11,1)","v":"2024-12-01"},null,null,"育休開始の6か月後の日(f)",{"$f":"EDATE($D$3,6)-1","v":"2024-06-26"},null,{"$f":"EDATE($K$5,6)-1","v":"2024-12-01"},{"$f":"COUNTIF(M12:R12,\"育休中\")","v":0},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"出勤",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":"IF(V49=0,6,\"\")","v":""},"月",null,null,"期間中全休でない場合",{"$f":"IF(H14=\"\",SUM(L7:L12),\"\")","v":0},"月",null,null,null,null,null,"もの）を「日数カウント開始基準日」に設定"]
[]
[]
[null,null,"対象日","出勤／育休"]
[null,"期間の開始日→",{"$f":"計算シート!Q7","v":"2024-06-02"},{"$f":"IF(AND(C18>$D$3-1,C18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(C18,1)","v":"2024-07-02"},{"$f":"IF(AND(F18>$D$3-1,F18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(F18,1)","v":"2024-08-02"},{"$f":"IF(AND(I18>$D$3-1,I18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(I18,1)","v":"2024-09-02"},{"$f":"IF(AND(L18>$D$3-1,L18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(L18,1)","v":"2024-10-02"},{"$f":"IF(AND(O18>$D$3-1,O18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"EDATE(O18,1)","v":"2024-11-02"},{"$f":"IF(AND(R18>$D$3-1,R18<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,"次の期間の初日"]
[null,null,{"$f":"C18+1","v":"2024-06-03"},{"$f":"IF(AND(C19>$D$3-1,C19<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"F18+1","v":"2024-07-03"},{"$f":"IF(AND(F19>$D$3-1,F19<$D$4+1),\"育休中\",\"出勤\")","v":"出勤"},null,{"$f":"I18+1","v":"2024-08-03"},"出勤",null,{"$f":"L18+1","v":"2024-09-03"},"出勤",null,{"$f":"O18+1","v":"2024-10-03"},"出勤",null,{"$f":"R18+1","v":"2024-11-03"},"出勤",null,{"$f":"EDATE(R18,1)","v":"2024-12-02"}]
[null,null,{"$f":"C19+1","v":"2024-06-04"},"出勤",null,"2024-07-04","出勤",null,"2024-08-04","出勤",null,"2024-09-04","出勤",null,"2024-10-04","出勤",null,"2024-11-04","出勤"]
[null,null,"2024-06-05","出勤",null,"2024-07-05","出勤",null,"2024-08-05","出勤",null,"2024-09-05","出勤",null,"2024-10-05","出勤",null,"2024-11-05","出勤",null,{"$f":"U19","v":"2024-12-02"}]
[null,null,"2024-06-06","出勤",null,"2024-07-06","出勤",null,"2024-08-06","出勤",null,"2024-09-06","出勤",null,"2024-10-06","出勤",null,"2024-11-06","出勤",null,"以降に育休あるか"]
[null,null,"2024-06-07","出勤",null,"2024-07-07","出勤",null,"2024-08-07","出勤",null,"2024-09-07","出勤",null,"2024-10-07","出勤",null,"2024-11-07","出勤",null,{"$f":"IF(D4>U21,\"〇\",\"×\")","v":"×"}]
[null,null,"2024-06-08","出勤",null,"2024-07-08","出勤",null,"2024-08-08","出勤",null,"2024-09-08","出勤",null,"2024-10-08","出勤",null,"2024-11-08","出勤"]
[null,null,"2024-06-09","出勤",null,"2024-07-09","出勤",null,"2024-08-09","出勤",null,"2024-09-09","出勤",null,"2024-10-09","出勤",null,"2024-11-09","出勤"]
[null,null,"2024-06-10","出勤",null,"2024-07-10","出勤",null,"2024-08-10","出勤",null,"2024-09-10","出勤",null,"2024-10-10","出勤",null,"2024-11-10","出勤"]
[null,null,"2024-06-11","出勤",null,"2024-07-11","出勤",null,"2024-08-11","出勤",null,"2024-09-11","出勤",null,"2024-10-11","出勤",null,"2024-11-11","出勤"]
[null,null,"2024-06-12","出勤",null,"2024-07-12","出勤",null,"2024-08-12","出勤",null,"2024-09-12","出勤",null,"2024-10-12","出勤",null,"2024-11-12","出勤"]
[null,null,"2024-06-13","出勤",null,"2024-07-13","出勤",null,"2024-08-13","出勤",null,"2024-09-13","出勤",null,"2024-10-13","出勤",null,"2024-11-13","出勤"]
[null,null,"2024-06-14","出勤",null,"2024-07-14","出勤",null,"2024-08-14","出勤",null,"2024-09-14","出勤",null,"2024-10-14","出勤",null,"2024-11-14","出勤"]
[null,null,"2024-06-15","出勤",null,"2024-07-15","出勤",null,"2024-08-15","出勤",null,"2024-09-15","出勤",null,"2024-10-15","出勤",null,"2024-11-15","出勤"]
[null,null,"2024-06-16","出勤",null,"2024-07-16","出勤",null,"2024-08-16","出勤",null,"2024-09-16","出勤",null,"2024-10-16","出勤",null,"2024-11-16","出勤"]
[null,null,"2024-06-17","出勤",null,"2024-07-17","出勤",null,"2024-08-17","出勤",null,"2024-09-17","出勤",null,"2024-10-17","出勤",null,"2024-11-17","出勤"]
[null,null,"2024-06-18","出勤",null,"2024-07-18","出勤",null,"2024-08-18","出勤",null,"2024-09-18","出勤",null,"2024-10-18","出勤",null,"2024-11-18","出勤"]
[null,null,"2024-06-19","出勤",null,"2024-07-19","出勤",null,"2024-08-19","出勤",null,"2024-09-19","出勤",null,"2024-10-19","出勤",null,"2024-11-19","出勤"]
[null,null,"2024-06-20","出勤",null,"2024-07-20","出勤",null,"2024-08-20","出勤",null,"2024-09-20","出勤",null,"2024-10-20","出勤",null,"2024-11-20","出勤"]
[null,null,"2024-06-21","出勤",null,"2024-07-21","出勤",null,"2024-08-21","出勤",null,"2024-09-21","出勤",null,"2024-10-21","出勤",null,"2024-11-21","出勤"]
[null,null,"2024-06-22","出勤",null,"2024-07-22","出勤",null,"2024-08-22","出勤",null,"2024-09-22","出勤",null,"2024-10-22","出勤",null,"2024-11-22","出勤"]
[null,null,"2024-06-23","出勤",null,"2024-07-23","出勤",null,"2024-08-23","出勤",null,"2024-09-23","出勤",null,"2024-10-23","出勤",null,"2024-11-23","出勤"]
[null,null,"2024-06-24","出勤",null,"2024-07-24","出勤",null,"2024-08-24","出勤",null,"2024-09-24","出勤",null,"2024-10-24","出勤",null,"2024-11-24","出勤"]
[null,null,"2024-06-25","出勤",null,"2024-07-25","出勤",null,"2024-08-25","出勤",null,"2024-09-25","出勤",null,"2024-10-25","出勤",null,"2024-11-25","出勤"]
[null,null,"2024-06-26","出勤",null,"2024-07-26","出勤",null,"2024-08-26","出勤",null,"2024-09-26","出勤",null,"2024-10-26","出勤",null,"2024-11-26","出勤"]
[null,null,"2024-06-27","出勤",null,"2024-07-27","出勤",null,"2024-08-27","出勤",null,"2024-09-27","出勤",null,"2024-10-27","出勤",null,"2024-11-27","出勤"]
[null,null,{"$f":"IF(C43=\"\",\"\",IF(C43+2>$F$18,\"\",C43+1))","v":"2024-06-28"},{"$f":"IF(C44=\"\",\"\",IF(AND(C44>$D$3-1,C44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(F43=\"\",\"\",IF(F43+2>$I$18,\"\",F43+1))","v":"2024-07-28"},{"$f":"IF(F44=\"\",\"\",IF(AND(F44>$D$3-1,F44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(I43=\"\",\"\",IF(I43+2>$L$18,\"\",I43+1))","v":"2024-08-28"},{"$f":"IF(I44=\"\",\"\",IF(AND(I44>$D$3-1,I44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(L43=\"\",\"\",IF(L43+2>$O$18,\"\",L43+1))","v":"2024-09-28"},{"$f":"IF(L44=\"\",\"\",IF(AND(L44>$D$3-1,L44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(O43=\"\",\"\",IF(O43+2>$R$18,\"\",O43+1))","v":"2024-10-28"},{"$f":"IF(O44=\"\",\"\",IF(AND(O44>$D$3-1,O44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,{"$f":"IF(R43=\"\",\"\",IF(R43+2>$U$19,\"\",R43+1))","v":"2024-11-28"},{"$f":"IF(R44=\"\",\"\",IF(AND(R44>$D$3-1,R44<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"}]
[null,null,"2024-06-29",{"$f":"IF(C45=\"\",\"\",IF(AND(C45>$D$3-1,C45<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,"2024-07-29",{"$f":"IF(F45=\"\",\"\",IF(AND(F45>$D$3-1,F45<$D$4+1),\"育休中\",\"出勤\"))","v":"出勤"},null,"2024-08-29","出勤",null,"2024-09-29","出勤",null,"2024-10-29","出勤",null,"2024-11-29","出勤"]
[null,null,"2024-06-30","出勤",null,"2024-07-30","出勤",null,"2024-08-30","出勤",null,"2024-09-30","出勤",null,"2024-10-30","出勤",null,"2024-11-30","出勤"]
[null,null,"2024-07-01","出勤",null,"2024-07-31","出勤",null,"2024-08-31","出勤",null,"2024-10-01","出勤",null,"2024-10-31","出勤",null,"2024-12-01","出勤"]
[null,null,"","",null,"2024-08-01","出勤",null,"2024-09-01","出勤",null,"","",null,"2024-11-01","出勤",null,"",""]
[null,null,"","",{"$f":"VLOOKUP(U7,C18:D48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(F48=\"\",\"\",IF(F48+2>$I$18,\"\",F48+1))","v":""},"",{"$f":"VLOOKUP(U7,F18:G48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(I48=\"\",\"\",IF(I48+2>$L$18,\"\",I48+1))","v":""},"",{"$f":"VLOOKUP(U7,I18:J48,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(L48=\"\",\"\",IF(L48+2>$O$18,\"\",L48+1))","v":""},"",{"$f":"VLOOKUP(U7,L18:M48,2,FALSE)","v":{"$error":"#N/A"}},"","",{"$f":"VLOOKUP(U7,O18:P48,2,FALSE)","v":{"$error":"#N/A"}},"","",{"$f":"VLOOKUP(U7,R18:S48,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"C50+F50+I50+L50+O50+R50-D50-G50-J50-M50-P50-S50","v":183}]
[null,"育休の合計",{"$f":"COUNTIF(C18:C49,\">0\")","v":30},{"$f":"COUNTIF(D18:D49,\"育休中\")","v":0},{"$f":"IF(DAY(C48)=1,IF(OR(E49=\"育休中\",E49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(F18:F49,\">0\")","v":31},{"$f":"COUNTIF(G18:G49,\"育休中\")","v":0},{"$f":"IF(DAY(F48)=1,IF(OR(H49=\"育休中\",H49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(I18:I49,\">0\")","v":31},{"$f":"COUNTIF(J18:J49,\"育休中\")","v":0},{"$f":"IF(DAY(I48)=1,IF(OR(K49=\"育休中\",K49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(L18:L49,\">0\")","v":30},{"$f":"COUNTIF(M18:M49,\"育休中\")","v":0},{"$f":"IF(DAY(L48)=1,IF(OR(N49=\"育休中\",N49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},{"$f":"COUNTIF(O18:O49,\">0\")","v":31},{"$f":"COUNTIF(P18:P49,\"育休中\")","v":0},{"$f":"IF(DAY(O48)=1,IF(OR(Q49=\"育休中\",Q49=\"出勤\"),1,0),0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(R18:R49,\">0\")","v":30},{"$f":"COUNTIF(S18:S49,\"育休中\")","v":0},{"$f":"IF(DAY(R48)=1,IF(OR(T49=\"育休中\",T49=\"出勤\"),1,0),0)","v":{"$error":"#VALUE!"}},"育休日数",{"$f":"D50+G50+J50+M50+P50+S50","v":0}]
[null,null,null,null,{"$f":"IF(C50=D50,0,IFERROR(E50,0))","v":0},null,null,{"$f":"IF(F50=G50,0,IFERROR(H50,0))","v":0},null,null,{"$f":"IF(I50=J50,0,IFERROR(K50,0))","v":0},null,null,{"$f":"IF(L50=M50,0,IFERROR(N50,0))","v":0},null,null,{"$f":"IF(O50=P50,0,IFERROR(Q50,0))","v":0},null,null,{"$f":"IF(R50=S50,0,IFERROR(T50,0))","v":0}]
[]
[null,null,null,"勤務月換算",{"$f":"IF(H14=6,0,6-M14-IF(W9>0,1,0))","v":6},null,"↓月数×100","計算上の値",null,{"$f":"IF((DAY($D$3)=DAY(EDATE($D$3,1)))=TRUE,EDATE($D$3,1)-1,EDATE($D$3,1))","v":"2024-01-26"}]
[null,null,null,"勤務日換算",{"$f":"IF(W9=0,0,IF(E53=6,0,IF(H14=6,0,30-W9)))+E56","v":0},null,{"$f":"E53*100","v":600},{"$f":"G54+E55+E54","v":600},null,{"$f":"D4-J53","v":-10}]
[null,null,null,"(5月30日の場合の調整値)",{"$f":"IF(AND(M14=5,W9=30),1,0)","v":0}]
[null,null,null,"(月間31日で休業日数30日の場合の調整値)",{"$f":"SUM(E51:T51)","v":0}]
[]
[null,null,null,null,null,null,null,"（Ａ）の値","（左記数値を下記数値に置換）","（勤務日が０の場合1で返す）","（置換後）","日数足し上げ",null,null,null,0,0,0,0,0,null,{"$f":"VLOOKUP(H54,P58:T71,5,TRUE)","v":1}]
[null,null,null,"①",null,"②",null,0,0,{"$f":"IF(AND(K$59=I59,$F$61=0),1,0)","v":0},{"$f":"VLOOKUP(F60,H59:I71,2,TRUE)","v":600},{"$f":"IF(SUM(J59:J71)=1,K59,IF(F61=0,(K59+F61)-70,K59+F61))","v":600},null,null,null,1,"15日未満",0,15,0.05]
[null,null,"1/2除算後の休業月数",{"$f":"IF(H14=6,3,M14/2)","v":0},"勤務月数換算（Ａ）",{"$f":"IF(F61>0,6-D60-1,6-D60)","v":6},null,0.5,85,null,null,null,null,null,null,15,"15日以上1月未満",1,0,0.1,null,"（数値処理後）期間率"]
[null,null,"1/2除算後の休業日数",{"$f":"W9/2","v":0},"勤務日数換算（Ｂ）",{"$f":"IF(D61=0,0,30-D61)","v":0},null,1,100,{"$f":"IF(AND(K$59=I61,$F$61=0),1,0)","v":0},null,null,null,null,null,100,"1月以上1月15日未満",1,15,0.15,null,{"$f":"IF(J54=0,T71,IF(E53=5,T71,V58))","v":1}]
[null,null,null,null,null,null,null,1.5,185,null,"（係数）",null,null,null,null,115,"1月15日以上2月未満",2,0,0.2]
[null,null,null,null,null,null,null,2,200,0,230,"②3か月以上5か月未満",3,0.6,null,200,"2月以上2月15日未満",2,15,0.3]
[null,null,null,"③",null,"④",null,2.5,285,null,430,"③5か月以上6か月未満",5,0.8,null,215,"2月15日以上3月未満",3,0,0.4]
[null,null,"月数の小数点以下を補正",{"$f":"INT(MOD(SIGN(L59)*L59/100,10))","v":6},"（数値処理後）勤務月数",{"$f":"IF(V49=0,3,IF(AND(F60=6,F61=0),F60,D65))","v":6},null,3,300,0,530,"④6か月",6,1,null,300,"3月以上3月15日未満",3,15,0.5]
[null,null,null,{"$f":"L59-D65*100","v":0},"（数値処理後）勤務日数",{"$f":"IF(V49=0,0,IF(AND(F60=6,F61=0),F61,D66))","v":0},null,3.5,385,null,null,null,null,null,null,315,"3月15日以上4月未満",4,0,0.6]
[null,null,null,null,null,null,null,4,400,0,null,"判定",null,null,null,400,"4月以上4月15日未満",4,15,0.7]
[null,null,null,null,null,null,null,4.5,485,null,null,{"$f":"VLOOKUP(L59,K63:N65,4,TRUE)","v":1},null,null,null,415,"4月15日以上5月未満",5,0,0.8]
[null,null,null,null,null,null,null,5,500,0,null,"（数値処理後）在職期間別割合",null,null,null,500,"5月以上5月15日未満",5,15,0.9]
[null,null,null,null,null,null,null,5.5,585,null,null,{"$f":"IF(J54=0,N65,IF(H14=6,0,IF(E53=5,N65,L68)))","v":1},null,null,null,515,"5月15日以上6月未満",5,31,0.95]
[null,null,null,null,null,null,null,6,600,1,null,null,null,null,null,600,"6か月",6,0,1]