{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["データ入力","デザイン"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":115,"n_cols":16,"rows_kept":115,"cut":false,"hidden":true,"merged":[[2,0,3,0],[5,0,9,0],[0,0,0,4]]}
["早期再就職プラン　作成ソフト"]
[]
["改定時必須　　　項目","60歳未満上限額","60歳以上上限額","2/3以上の支給割合","1/3以上の　　　　　　　支給割合","改定日","改定後の\n2/3以上の　　　　　　　　　　　支給割合","改定後の\n1/3以上の　　　　　　　　　　　　　　　　　　　　　　　　支給割合","改定後の\n60歳未満上限額","改定後の\n60歳以上上限額"]
[null,6190,5004,0.7,0.6,"2023-08-01",0.7,0.6,6290,5085]
[null,null,null,null,"　"]
["入力結果計算","就職日（仮定）","支給開始日から就職日の前日までの日数","支給残日数","再就職手当　　　　　支給額","支給単価",null,"適用割合","上限適用\n（適用なら★）"]
[null,{"$f":"L13+1","v":{"$error":"#N/A"}},{"$f":"IF(DATEDIF($L$13,B7,\"d\")-1<0,\"0\",DATEDIF($L$13,B7,\"d\")-1)","v":{"$error":"#N/A"}},{"$f":"IF($E$13<$M$13,$E$13-C7,$M$13-C7)","v":{"$error":"#N/A"}},{"$f":"IF(D7<J13,\"残日数が1/3未満のため再就職手当は支給されません\",IF(D7=\"\",\"\",ROUNDDOWN(D7*F7*H7,0)))","v":{"$error":"#N/A"}},{"$f":"IF(B7<$F$4,IF($N$13>$G$13,$G$13,$N$13),IF($O$13>$H$13,$H$13,$O$13))","v":{"$error":"#N/A"}},{"$f":"D7-I13","v":{"$error":"#N/A"}},{"$f":"IF(D7=\"\",\"\",IF($F$4>B7,IF(D7>=$I$13,$D$4,$E$4),IF(D7>=$I$13,$G$4,$H$4)))","v":{"$error":"#N/A"}},{"$f":"IF(B7<$F$4,IF($N$13>$G$13,\"\",\"★\"),IF($O$13>$H$13,\"\",\"★\"))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(B7+G7<B7,\"すでに残日数が2/3未満です\",B7+G7)","v":{"$error":"#N/A"}},{"$f":"IF(B8=\"すでに残日数が2/3未満です\",\"\",IF(DATEDIF($L$13,B8,\"d\")-1<0,\"0\",DATEDIF($L$13,B8,\"d\")-1))","v":{"$error":"#N/A"}},{"$f":"IF(C8=\"\",\"\",IF($E$13<$M$13,$E$13-C8,$M$13-C8))","v":{"$error":"#N/A"}},{"$f":"IF(D8=\"\",\"\",ROUNDDOWN(D8*F8*H8,0))","v":{"$error":"#N/A"}},{"$f":"IF(C8=\"\",\"\",IF(B8<$F$4,IF($N$13>$G$13,$G$13,$N$13),IF($O$13>$H$13,$H$13,$O$13)))","v":{"$error":"#N/A"}},{"$f":"D7-J13","v":{"$error":"#N/A"}},{"$f":"IF(D8=\"\",\"\",IF($F$4>B8,IF(D8>=$I$13,$D$4,$E$4),IF(D8>=$I$13,$G$4,$H$4)))","v":{"$error":"#N/A"}},{"$f":"IF(B8<$F$4,IF($N$13>$G$13,\"\",\"★\"),IF($O$13>$H$13,\"\",\"★\"))","v":{"$error":"#N/A"}}]
[null,{"$f":"IF(G8<0,\"すでに残日数が1/3未満です\",B7+G8)","v":{"$error":"#N/A"}},{"$f":"IF(B9=\"すでに残日数が1/3未満です\",\"\",IF(DATEDIF($L$13,B9,\"d\")-1<0,\"0\",DATEDIF($L$13,B9,\"d\")-1))","v":{"$error":"#N/A"}},{"$f":"IF(C9=\"\",\"\",IF($E$13<$M$13,$E$13-C9,$M$13-C9))","v":{"$error":"#N/A"}},{"$f":"IF(C9=\"\",\"\",ROUNDDOWN(D9*F9*H9,0))","v":{"$error":"#N/A"}},{"$f":"IF(C9=\"\",\"\",IF(B9<$F$4,IF($N$13>$G$13,$G$13,$N$13),IF($O$13>$H$13,$H$13,$O$13)))","v":{"$error":"#N/A"}},null,{"$f":"IF(C9=\"\",\"\",IF($F$4>B9,IF(D9>=$I$13,$D$4,$E$4),IF(D9>=$I$13,$G$4,$H$4)))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[]
[]
["NO.","年齢","資格決定","受給期間満了日","所定日数","給付制限","基本手当日額","改定後の基本手当日額","所定日数の\n2/3","所定日数の\n1/3","待期満了日","支給開始日の前日","支給開始日～受給期間満了日までの日数","上限額","日額改定後の\n上限額","任意使用"]
[{"$f":"デザイン!C3","v":1},{"$f":"VLOOKUP($A$13,$A$15:$H$115,2,FALSE)","v":0},{"$f":"VLOOKUP($A$13,$A$15:$H$115,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($A$13,$A$15:$H$115,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP($A$13,$A$15:$H$115,5,FALSE)","v":0},{"$f":"VLOOKUP($A$13,$A$15:$H$115,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($A$13,$A$15:$H$115,7,FALSE)","v":0},{"$f":"VLOOKUP($A$13,$A$15:$H$115,8,FALSE)","v":0},{"$f":"E13*2/3","v":0},{"$f":"E13/3","v":0},{"$f":"C13+6","v":"1900-01-06"},{"$f":"EDATE(K13+1,F13)-1","v":{"$error":"#N/A"}},{"$f":"DATEDIF(L13,D13,\"D\")","v":{"$error":"#N/A"}},{"$f":"IF(B13<60,$B$4,$C$4)","v":6190},{"$f":"IF(B13<60,$I$4,$J$4)","v":6290},{"$f":"IF(VLOOKUP($A$13,$A$15:$I$115,9,FALSE)=0,\"\",VLOOKUP($A$13,$A$15:$I$115,9,FALSE))","v":""}]
[]
["NO.","年齢","資格決定","受給期間満了","所定日数","給付制限","基本手当    日額","改定後の基本手当日額","任意使用欄 　　　　（氏名,支給番号等）",null,null,null,"なし",0]
[1,{"$f":"デザイン!C32","v":0},{"$f":"デザイン!D32","v":0},{"$f":"デザイン!E32","v":0},{"$f":"デザイン!H32","v":0},{"$f":"VLOOKUP(F17,M15:N17,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"デザイン!L32","v":0},{"$f":"G16","v":0},null,null,null,null,"2ヶ月",2]
[2,null,null,null,null,{"$f":"デザイン!J32","v":0},null,null,null,null,null,null,"3ヶ月",3]
[3]
[4]
[5]
[6," "," "," "," "," "," "," "]
[7," "," ",null," "," "," "," "]
[8," "," "," "," "," "," "," "]
[9," "," "," "," "," "," "," "]
[10," "," "," "," "," "," "," "]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"デザイン","index":1,"n_rows":69,"n_cols":18,"rows_kept":69,"cut":false,"hidden":false,"merged":[[43,3,43,5],[27,2,28,15],[30,11,30,15],[31,11,31,15],[30,4,30,6],[30,7,30,8],[31,4,31,6],[31,7,31,8],[30,9,30,10],[41,2,41,15],[42,3,42,5],[31,9,31,10],[33,3,33,16],[36,1,36,2],[36,3,36,4],[34,12,34,14],[56,3,58,15],[61,1,61,18],[53,2,53,16],[54,2,54,16],[42,14,42,16],[46,14,46,16],[50,14,50,16],[49,2,49,11],[45,2,45,11],[51,8,51,9],[46,3,46,5],[50,3,50,5],[47,3,47,5],[51,3,51,5],[43,8,43,9],[47,8,47,9],[69,4,69,11],[70,4,70,11],[62,1,62,17],[63,1,63,17],[64,1,64,18],[66,0,66,18],[8,17,8,18],[11,12,11,13],[11,6,11,11],[8,1,8,16],[10,15,10,16],[34,7,34,8],[34,5,34,6],[35,12,35,14],[35,7,35,9],[4,1,5,2]]}
[]
[]
["NO.",null,1]
[]
[null,"印刷ボタン"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　"]
[null,"　あなたの再就職手当シミュレーション",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　"]
[null,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":"データ入力!P13","v":""}]
[null,null,null,null," ","　",null,null,null,null,null,null,null,null,null,null,"　"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"　"]
[]
[]
[]
[]
[]
[null,null,"下記の黄色いセルに、お手元の受給資格者証の第1面の該当する数値をご入力ください。"]
[]
[null,null,"↓○で囲った数字は受給資格者証に印字されている項目番号に対応します。（⑤なら、受給資格者証第１面5欄の数値を入力）"]
[null,null,"⑤離職時年齢","⑯　求職申込み\n年月日","⑱受給期間満了年月日",null,null,"⑳所定給付日数",null,"⑮給付制限",null,"⑲基本手当日額（毎年8月1日に改訂があります）"]
[]
[]
[null,null,null,"⑲基本手当日額が再就職手当にかかる上限額を超えるときは、上限額で算出されます。"]
[null,null,null,null,null,"※上限額",null,{"$f":"データ入力!F4","v":"2023-08-01"},null,"から","60歳未満",{"$f":"データ入力!I4","v":6290},"円 60歳以上",null,null,{"$f":"データ入力!J4","v":5085},"円"]
[null,null,null,null,null,null,null,"令和5年7月31日までは",null,null,"60歳未満",{"$f":"データ入力!B4","v":6190},"円 60歳以上",null,null,{"$f":"データ入力!C4","v":5004},"円"]
[null,"受給期間満了日",null,{"$f":"データ入力!D13","v":"00:00:00"},null,null,null,"※　基本手当日額や上限額は、毎年8月1日に変更されますのでご注意ください。"]
[]
[]
[]
[null,null,null," ",null,null,null,null," ",null,null," "]
[null,"　","例①　待期期間満了後、１日の支給も受けずに就職された場合（給付制限中など）"]
[null,"　","　",{"$f":"データ入力!B7","v":{"$error":"#N/A"}},null,null,"　"," ",{"$f":"データ入力!D7","v":{"$error":"#N/A"}},"日分"," ",{"$f":"データ入力!E7","v":{"$error":"#N/A"}},"円",null,"の支給が見込まれます"]
[null,null,null,"に就職した場合",null,null,null,null,"支給残日数"]
[]
[null,"　","例②　所定給付日数の３分の２を残して就職された場合"]
[null,"　","　",{"$f":"データ入力!B8","v":{"$error":"#N/A"}},null,null,"　"," ",{"$f":"データ入力!D8","v":{"$error":"#N/A"}},"日分"," ",{"$f":"データ入力!E8","v":{"$error":"#N/A"}},"円",null,"の支給が見込まれます"]
[null,null,null,"に就職した場合",null,null,null,null,"支給残日数"]
[]
[null,"　","例③　所定給付日数の３分の１を残して就職された場合"]
[null,"　","　",{"$f":"データ入力!B9","v":{"$error":"#N/A"}},null,null,"　"," ",{"$f":"データ入力!D9","v":{"$error":"#N/A"}},"日分"," ",{"$f":"データ入力!E9","v":{"$error":"#N/A"}},"円",null,"の支給が見込まれます"]
[null,null,null,"に就職した場合",null,null,null,null,"支給残日数"]
[]
[]
[]
[]
[null,null,null,"再就職手当を受けた方が、引き続きその再就職先に６ヶ月以上雇用され、再就職先で６ヶ月の間に支払われた賃金が雇用保険の給付を受ける直前の賃金に比べて低下している場合、就業促進定着手当の支給を受けることができます。"]
[]
[]
[]
[]
[null,"　 再就職手当とは、所定給付日数の３分の１以上を残して安定した職業に就いた場合に、支給残日数の６～７割に相当"]
[null," 　する日数分に基本手当日額を乗じた額が支給される制度です。"]
[null," 　ただし、過去３年以内に再就職手当等の支給を受けていないなど、支給要件を満たすことが必要です。"]
[null," 　詳しくは受給資格者のしおり【再就職手当について】(P21)の項目をご覧いただくか給付担当職員にお尋ねください。"]
[]
["再就職のご相談は、職業相談の窓口をご利用ください"]
[]
["　",null,null,null,null,null,null,null,null,null,"　"]