{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["案内ガイド","65歳①","65歳②","65歳③"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":1,"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":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["※次のいずれかの該当する欄に「１」を入力し「決定」ボタンをクリックしてください。"]
[]
["①　今年度","「60歳」になる"]
[null,"(S38.4.2～S39.4.1生れの方)"]
[]
["②　今年度","女性で「62歳」になる"]
[null,"(S36.4.2～S37.4.1生れの方)"]
[]
["③　今年度","男性で「64歳」になる"]
[null,"(S34.4.2～S35.4.1生れの方)"]
[]
["③　今年度","「65歳」になる",1]
[null,"(S34.4.2～S35.4.1生れの方)"]

{"sheet":"65歳①","index":1,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,8,3,14],[4,8,4,9]]}
[null,"【世帯の状況】"]
[null,null,null,null,null,"（※黄色の箇所を入力してください。）"]
["⑴","あなたの６５歳の誕生月と性別を入力してください。",null,null,null,null,null,"⑶　あなたの家計の状態を入力してみましょう。"]
[null,"（ただし、「１日」が誕生日の場合は、誕生月の「前月」を入力してください。）",null,null,null,null,null,null,"（参考）家計調査年報（家計収支編）（総務省統計局：http://www.stat.go.jp/data/kakei/npsf.html）を加工して作成"]
["　①","あなたの誕生月",12,"月",null,null,null,"自分の家の家計","夫婦無職世帯年間生活費平均",null,"2018年","2019年","2020年","2021年","2022年"]
["②","あなたの性別は",1,null,null,null,null,null,"公的年金等",{"$f":"AVERAGE(K6:O6)","v":215529.4},203824,216910,219976,216519,220418]
[null,"（※男性「１」、女性「２」を入力してください。）",null,null,null,null,null,null,"賃金他",{"$f":"AVERAGE(K7:O7)","v":24464.2},19011,20750,36685,20056,25819]
["⑵","あなたには配偶者がいますか？",null,null,null,null,null,null,"税・保険料",{"$f":"AVERAGE(K8:O8)","v":30742},29092,30982,31160,30664,31812]
[null,"（※配偶者がいない場合は、「決定」をクリックして次へ進んでください。）",null,null,null,null,null,{"$f":"H6+H7-H8","v":0},"可処分所得",209251.6,193743,206678,225501,205911,214425]
["①","配偶者がいる？",1,null,null,null,null,231973,"食料",{"$f":"AVERAGE(K10:O10)","v":66229.2},65319,66458,65804,65789,67776]
[null,"（※配偶者がいる場合は「１」を入力してください。）",null,null,null,null,null,null,"住居",{"$f":"AVERAGE(K11:O11)","v":14768.8},13625,13625,14518,16498,15578]
["②","配偶者の性別は？",2,null,null,null,null,null,"水道・光熱",20368,19905,19983,19845,19496,22611]
[null,"（※男性「１」、女性「２」を入力してください。）",null,null,null,null,null,null,"家具・家事用品",10109.6,9385,10100,10258,10434,10371]
["③","配偶者の年齢は今年の誕生日で何歳になりますか？",null,null,null,null,null,null,"被服・履物",5395.8,6171,6065,4699,5041,5003]
[null,null,58,"歳（54歳～70歳で入力してください。）",null,null,null,null,"保健・医療",15768.2,15181,15759,16057,16163,15681]
["④","配偶者の誕生月を入力してください。",null,null,null,null,null,null,"交通・通信",27460.799999999999,28071,28328,26795,25232,28878]
[null,"（ただし、「１日」が誕生日の場合は、誕生月の「前月」を入力してください。）",null,null,null,null,null,null,"教育",6.2,2,20,4,2,3]
[null,"配偶者の誕生月",2,"月",null,null,null,null,"教養・娯楽",21861,24239,24804,19658,19239,21365]
[null,null,null,null,null,null,null,null,"交際費他",50249.2,53717,54805,46752,46542,49430]
["（※入力が終わったら「次へ進む」ボタンをクリックしてください。）",null,null,null,null,null,null,{"$f":"SUM(H10:H19)","v":231973},"支出計",232216.8,235615,239947,224390,224436,236696]
[null,null,null,null,null,null,null,{"$f":"H9-H20","v":-231973},"過不足",-22965.199999999983,-41872,-33269,1111,-18525,-22271]
[null,null,null,null,null,null,null,{"$f":"H6+H7","v":0},"総収入額",{"$f":"J6+J7","v":239993.60000000001},"（公的年金＋賃金他）"]
[null,null,null,null,null,null,null,{"$f":"H8+H20","v":231973},"総支出額",{"$f":"J8+J20","v":262958.8},"（支出計＋税・保険料）"]

{"sheet":"65歳②","index":2,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[[18,16,18,17],[36,12,36,13],[31,0,31,6],[33,8,33,10],[45,0,45,5]]}
[null,"【年金の状況と今後の希望】",null,null,null,null,null,"（※黄色の箇所を入力してください。）"]
["⑴","あなたの年金額を入力してください。",null,null,null,null,null,"⑵ 配偶者の年金額を入力してください。"]
["（※可能なら「年金定期便」にある「６５歳」時点の見込額を入力しましょう。）",null,null,null,null,null,null,"（※可能なら「年金定期便」にある「６５歳」時点の見込額も入力しましょう。）"]
[null,null,null,"６５歳時点",null,null,null,null,null,"65歳未満",null,"65歳以上"]
["➊","老齢基礎年金",null,777800,"円",null,null,"➊老齢基礎年金（又は定額部分の額）",null,0,"円",777800,"円"]
[null,null,null,null,null,"報酬比例計",null,null,"報酬比例計",null,null,null,null,"報酬比例計"]
["❷","老齢厚生年金",null,{"$f":"D8+D9+D11+D12+D13+D15+D16+D17","v":1205600},"円",{"$f":"D8+D11+D15","v":1200000},null,"❷老齢厚生年金",{"$f":"J8+J11+J15","v":835000},{"$f":"J8+J9+J11+J12+J13+J15+J16+J17","v":835000},"円",{"$f":"L8+L9+L11+L12+L13+L15+L16+L17","v":1202400},"円",{"$f":"L8+L11+L15","v":1200000}]
[null,"①一般厚生年金","報酬比例部分",1200000,"円","経過加算計",null,"①一般厚生年金","報酬比例部分",835000,"円",1200000,"円","経過加算計"]
[null,null,"経過的加算部分",5600,"円",{"$f":"D9+D12+D13+D16+D17","v":5600},null,null,"経過的加算部分",null,"円",2400,"円",{"$f":"L9+L12+L13+L16+L17","v":2400}]
[]
[null,"②公務員厚生年金","報酬比例部分",0,"円",null,null,"②公務員厚生年金","報酬比例部分",null,"円",0,"円"]
[null,null,"経過的加算部分",0,"円",null,null,null,"経過的加算部分",null,"円",0,"円"]
[null,null,"経過的職域加算額（共済年金）",0,"円",null,null,null,"経過的職域加算額（共済年金）",null,"円",0,"円"]
[]
[null,"③私学共済厚生年金","報酬比例部分",0,"円",null,null,"③私学共済厚生年金","報酬比例部分",null,"円",0,"円"]
[null,null,"経過的加算部分",0,"円",null,null,null,"経過的加算部分",null,"円",0,"円"]
[null,null,"経過的職域加算額（共済年金）",0,"円",null,null,null,"経過的職域加算額（共済年金）",null,"円",0,"円"]
[]
["⑶","繰下支給の希望の有無と繰下希望の年齢を入力してください。",null,null,null,null,null,"⑷   配偶者の繰下支給の希望の有無と繰下希望の年齢を入力してください。",null,null,null,null,null,null,null,null,"生年月日（年齢）",null,"振替加算額"]
["➊","老齢基礎年金",null,null,null,null,null,"➊","老齢基礎年金",null,null,null,null,null,null,null,54,"歳以前"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"歳"," "]
[null,"①繰下支給希望の有無",null,1,"有「１」無「０」を入力",null,null,null,"①繰下支給希望の有無",null,1,"有「１」無「０」を入力",null,null,null,null,56,"歳"," "]
[null,"（①「0」の場合に「65」を、「1」の場合に「繰下希望年齢」を②に入力する。）",null,null,null,null,null,null,"（①「0」の場合に「65」を、「1」の場合に「繰下希望年齢」を②に入力する。）",null,null,null,null,null,null,null,57,"歳"," "]
[null,"　　②繰下支給希望年齢",null,67,"歳（65歳～75歳の範囲で入力する。）",null,null,null,"　　②繰下支給希望年齢",null,68,"歳（65歳～75歳の範囲で入力する。）",null,null,null,null,58,"歳"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,"歳",15732]
["❷","老齢厚生年金",null,null,null,null,null,"❷","老齢厚生年金",null,null,null,null,null,null,null,60,"歳",15732]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"歳",15732]
[null,"①繰下支給希望の有無",null,1,"有「１」無「０」を入力",null,null,null,"①繰下支給希望の有無",null,1,"有「１」無「０」を入力",null,null,null,null,62,"歳",15732]
[null,"（①「0」の場合に「65」を、「1」の場合に「繰下希望年齢」を②に入力する。）",null,null,null,null,null,null,"（①「0」の場合に「65」を、「1」の場合に「繰下希望年齢」を②に入力する。）",null,null,null,null,null,null,null,63,"歳",15732]
[null,"　　②繰下支給希望年齢",null,66,"歳（65歳～75歳の範囲で入力する。）",null,null,null,"　　②繰下支給希望年齢",null,67,"歳（65歳～75歳の範囲で入力する。）",null,null,null,null,64,"歳",21836]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,"歳",28176]
["⑸　６５歳以降も在職するか？、在職する場合は年間収入（見込）額を入力してください。",null,null,null,null,null,null,"⑺　","厚生年金保険計（加入月数）",null,null,240,"月",null,null,null,66,"歳",34516]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"歳",40620]
["①","在職予定の有無",null,1,"有「１」無「０」を入力",null,null,"⑻　","配偶者の厚生年金保険加入総月数",null,null,239,"月",null,null,null,68,"歳",46960]
[null,null,null,null,null,"再評価率",null,null,null,null,null,null,null,null,null,null,69,"歳",53141]
["②","在職する予定の年齢",null,75,"歳まで",0.92600000000000005,null,null,"配偶者加給年金額加算の有無",null,null,{"$f":"IF(L34>=240,0,IF(L32>=240,1,0))","v":1},"有「１」無「０」を入力",null,null,null,70,"歳",59227]
[null,null,null,null,null,"乗率",null,null,"S.18.4.2以降生まれ（224,700円×改定率＋74,900円×改定率）",null,null,null,"令和６年度",null,408100,"円","年齢",1,2]
["③","在職時の年間収入",null,3600000,"円","5.481/1000",null,null,"自身への振替加算の有無",null,null,{"$f":"IF(L32>=240,0,IF(L34>=240,1,0))","v":0},"有「１」無「０」を入力",null,null,"S44",55,65,65]
[null,null,null,null,null,"定時改定額",null,null,null,null,null,null,null,null,null,"S43",56,65,65]
["④","支給停止額",null,{"$f":"IF(D42+D43<=D44,0,((D38+F7)-D44*12)/2)","v":0},"円",{"$f":"D38*F36*5.481/1000","v":18271.461599999999},"円",null,"配偶者への振替加算の有無",null,null,{"$f":"IF(L34>=240,0,IF(L32>=240,1,0))","v":1},"有「１」無「０」を入力",null,null,"S42",57,65,65]
[null,null,null,null,null,null,66,{"$f":"IF(D36<G41,0,D38*F36*5.481/1000)","v":18271.461599999999},null,null,null,null,null,null,null,"S41",58,65,65]
[null,null,"基本月額",{"$f":"D7/12","v":100466.66666666667},null,null,67,{"$f":"IF(D36<G41,0,D38*2*F36*5.481/1000)","v":36542.923199999997},null,null,null,null,null,null,null,"S40",59,65,64]
[null,null,"標準報酬額",{"$f":"D38/12","v":300000},null,null,68,{"$f":"IF(D36<G41,0,D38*3*F36*5.481/1000)","v":54814.3848},null,null,null,null,null,null,null,"S39",60,65,64]
["（R5年3月までは470,000円）",null,"支給停止基準額",480000,null,null,69,{"$f":"IF(D36<G41,0,D38*4*F36*5.481/1000)","v":73085.846399999995},null,null,null,null,null,null,null,"S38",61,65,63]
[null,null,null,null,null,null,70,{"$f":"IF(D36<G41,0,D38*5*F36*5.481/1000)","v":91357.308000000005},null,null,null,null,null,null,null,"S37",62,65,63]
["⑹　配偶者は６５歳以降も在職しますか？在職する場合は年間収入（見込額）を入力してください。",null,null,null,null,null,71,{"$f":"IF(D36<G41,0,D38*5*F36*5.481/1000)","v":91357.308000000005},"⑼　すべての入力が終わったら「入力完了」ボタンをクリックしてください。",null,null,null,null,null,null,"S36",63,65,62]
[null,null,null,null,null,null,72,{"$f":"IF(D36<G41,0,D38*5*F36*5.481/1000)","v":91357.308000000005},null,null,null,null,null,null,null,"S35",64,64,62]
["①","在職予定の有無",null,1,"有「１」無「０」を入力",null,73,{"$f":"IF(D36<G41,0,D38*5*F36*5.481/1000)","v":91357.308000000005},null,null,null,null,null,null,null,"S34",65,64,61]
[null,null,null,null,null,"再評価率(年上は変更有？)",74,{"$f":"IF(D36<G41,0,D38*5*F36*5.481/1000)","v":91357.308000000005},null,null,null,null,null,null,null,"S33",66,63,61]
["②","在職する予定の年齢",null,65,"歳まで",0.92600000000000005,75,{"$f":"IF(D36<G41,0,D38*5*F36*5.481/1000)","v":91357.308000000005},null,null,null,null,null,null,null,"S32",67,63,60]
[null,null,null,null,null,"乗率",76,{"$f":"IF(D36<G41,0,D38*5*F36*5.481/1000)","v":91357.308000000005},null,null,null,null,null,null,null,"S31",68,62,60]
["③","在職時の年間収入",null,1800000,"円","5.481/1000",77,{"$f":"IF(D36<G41,0,D38*5*F36*5.481/1000)","v":91357.308000000005},null,null,null,null,null,null,null,"S30",69,62,60]
[null,null,"65歳未満","65歳以上",null,"定時改定額",null,null,null,null,null,null,null,null,null,"S29",70,61,60]
["④","支給停止額",{"$f":"IF(C56+C57<=D44,0,((D52+I7)-D44*12)/2)","v":0},{"$f":"IF(D56+D57<=D44,0,((D52+N7)-D44*12)/2)","v":0},"円",{"$f":"D52*F50*5.481/1000","v":9135.7307999999994},"円",null,null,null,null,null,null,null,null,"S28",71,61,60]
[]
[null,"基本月額",{"$f":"I7/12","v":69583.333333333328},{"$f":"N7/12","v":100000}]
[null,"標準報酬額",{"$f":"D52/12","v":150000},{"$f":"D52/12","v":150000}]

{"sheet":"65歳③","index":3,"n_rows":50,"n_cols":31,"rows_kept":50,"cut":false,"hidden":false,"merged":[[32,20,32,21],[32,22,32,23],[32,24,32,25],[32,26,32,27],[33,1,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[33,14,33,15],[33,16,33,17],[33,18,33,19],[33,20,33,21],[33,22,33,23],[33,24,33,25],[33,26,33,27],[32,1,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[32,10,32,11],[32,12,32,13],[32,14,32,15],[32,16,32,17],[32,18,32,19],[10,26,10,27],[42,26,42,27],[40,1,40,3],[38,4,38,5],[38,6,38,7],[46,1,46,3],[38,26,38,27],[40,4,40,5],[40,6,40,7],[40,8,40,9],[40,10,40,11],[40,12,40,13],[40,14,40,15],[40,16,40,17],[40,18,40,19],[40,20,40,21],[40,22,40,23],[40,24,40,25],[40,26,40,27],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[38,16,38,17],[38,18,38,19],[41,1,41,3],[43,1,43,3],[44,1,44,3],[38,1,38,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[44,10,44,11],[42,0,42,3],[27,26,27,27],[36,1,36,3],[37,1,37,3],[35,1,35,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,12,36,13],[36,14,36,15],[36,16,36,17],[36,18,36,19],[36,20,36,21],[36,22,36,23],[36,24,36,25],[36,26,36,27],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,10,37,11],[37,12,37,13],[37,14,37,15],[37,16,37,17],[37,18,37,19],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[27,22,27,23],[27,24,27,25],[17,24,17,25],[17,26,17,27],[11,26,11,27],[16,1,16,3],[17,1,17,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[16,18,16,19],[16,20,16,21],[16,22,16,23],[16,24,16,25],[16,26,16,27],[17,4,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[17,18,17,19],[17,20,17,21],[43,22,43,23],[43,24,43,25],[43,26,43,27],[15,18,15,19],[15,20,15,21],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[43,12,43,13],[43,14,43,15],[43,16,43,17],[43,18,43,19],[43,20,43,21],[23,20,23,21],[23,22,23,23],[23,24,23,25],[23,26,23,27],[24,8,24,9],[24,10,24,11],[24,12,24,13],[17,22,17,23],[24,20,24,21],[15,1,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[19,2,19,3],[15,14,15,15],[15,16,15,17],[17,16,17,17],[9,16,9,17],[9,18,9,19],[9,20,9,21],[9,22,9,23],[9,24,9,25],[12,14,12,15],[12,16,12,17],[12,18,12,19],[12,20,12,21],[12,22,12,23],[11,14,11,15],[11,16,11,17],[11,18,11,19],[11,20,11,21],[11,22,11,23],[11,24,11,25],[10,14,10,15],[10,16,10,17],[10,18,10,19],[10,20,10,21],[10,22,10,23],[10,24,10,25],[1,2,1,3],[12,1,12,3],[13,1,13,3],[9,4,9,5],[9,6,9,7],[7,1,7,3],[7,4,7,5],[7,6,7,7],[5,4,5,5],[5,6,5,7],[2,4,2,5],[2,6,2,7],[6,1,6,3],[6,4,6,5],[6,6,6,7],[11,1,11,3],[11,4,11,5],[11,6,11,7],[10,1,10,3],[10,4,10,5],[10,6,10,7],[9,8,9,9],[12,4,12,5],[12,6,12,7],[12,8,12,9],[13,14,13,15],[13,4,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[9,10,9,11],[9,12,9,13],[12,10,12,11],[12,12,12,13],[9,14,9,15],[11,8,11,9],[11,10,11,11],[11,12,11,13],[10,8,10,9],[10,10,10,11],[10,12,10,13],[7,22,7,23],[6,24,6,25],[6,20,6,21],[6,22,6,23],[2,26,2,27],[5,26,5,27],[6,26,6,27],[7,26,7,27],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[6,16,6,17],[6,18,6,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[9,26,9,27],[7,8,7,9],[7,10,7,11],[7,12,7,13],[2,22,2,23],[2,24,2,25],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[2,16,2,17],[2,18,2,19],[2,20,2,21],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[7,24,7,25],[5,16,5,17],[5,18,5,19],[7,14,7,15],[7,16,7,17],[7,18,7,19],[7,20,7,21],[12,26,12,27],[13,26,13,27],[15,26,15,27],[23,1,23,3],[24,1,24,3],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,19],[22,20,22,21],[22,22,22,23],[22,24,22,25],[22,26,22,27],[23,8,23,9],[13,16,13,17],[13,18,13,19],[13,20,13,21],[13,22,13,23],[13,24,13,25],[12,24,12,25],[15,22,15,23],[15,24,15,25],[28,1,28,3],[29,1,29,3],[31,1,31,3],[22,4,22,5],[22,6,22,7],[23,4,23,5],[23,6,23,7],[26,4,26,5],[26,6,26,7],[28,4,28,5],[28,6,28,7],[29,4,29,5],[29,6,29,7],[31,4,31,5],[31,6,31,7],[30,4,30,5],[24,4,24,5],[24,6,24,7],[27,1,27,3],[27,4,27,5],[27,6,27,7],[24,22,24,23],[24,24,24,25],[24,26,24,27],[23,10,23,11],[23,12,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[24,14,24,15],[24,16,24,17],[24,18,24,19],[26,18,26,19],[26,20,26,21],[26,22,26,23],[26,24,26,25],[26,26,26,27],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[28,18,28,19],[28,20,28,21],[28,22,28,23],[28,24,28,25],[28,26,28,27],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,16,28,17],[29,18,29,19],[29,20,29,21],[29,22,29,23],[29,24,29,25],[29,26,29,27],[29,8,29,9],[29,10,29,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[44,24,44,25],[35,10,35,11],[35,12,35,13],[31,18,31,19],[31,20,31,21],[31,22,31,23],[31,24,31,25],[31,26,31,27],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[31,16,31,17],[37,20,37,21],[37,22,37,23],[37,24,37,25],[37,26,37,27],[42,12,42,13],[42,14,42,15],[42,16,42,17],[42,18,42,19],[42,20,42,21],[42,22,42,23],[42,24,42,25],[35,26,35,27],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[41,12,41,13],[41,14,41,15],[41,16,41,17],[41,18,41,19],[41,20,41,21],[41,22,41,23],[41,24,41,25],[41,26,41,27],[35,14,35,15],[35,16,35,17],[35,18,35,19],[35,20,35,21],[35,22,35,23],[35,4,35,5],[35,6,35,7],[35,8,35,9],[38,20,38,21],[38,22,38,23],[38,24,38,25],[14,18,14,19],[44,26,44,27],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[46,12,46,13],[46,14,46,15],[46,16,46,17],[46,18,46,19],[46,20,46,21],[46,22,46,23],[46,24,46,25],[46,26,46,27],[44,14,44,15],[44,16,44,17],[44,18,44,19],[44,20,44,21],[44,22,44,23],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,12,44,13],[35,24,35,25],[14,20,14,21],[14,22,14,23],[14,24,14,25],[14,26,14,27],[30,1,30,3],[30,26,30,27],[30,16,30,17],[30,18,30,19],[30,20,30,21],[30,22,30,23],[30,24,30,25],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[30,14,30,15],[14,1,14,3],[14,4,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[14,16,14,17]]}
[]
["⑴","自分の","年齢",null,65,"歳",{"$f":"E2+1","v":66},"歳",{"$f":"G2+1","v":67},"歳",{"$f":"I2+1","v":68},"歳",{"$f":"K2+1","v":69},"歳",{"$f":"M2+1","v":70},"歳",{"$f":"O2+1","v":71},"歳",{"$f":"Q2+1","v":72},"歳",{"$f":"S2+1","v":73},"歳",{"$f":"U2+1","v":74},"歳",{"$f":"W2+1","v":75},"歳",{"$f":"Y2+1","v":76},"歳",null,"繰上下げ率"]
[null,null,null,"西暦",2024,null,2025,null,2026,null,2027,null,2028,null,2029,null,2030,null,2031,null,2032,null,2033,null,2034,null,2035,null,null,60]
[null,null,null,"誕生月",{"$f":"'65歳①'!C5","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"E4","v":12},"月",{"$f":"G4","v":12},"月",null,61]
[null,null,null,"繰下率",1,null,1.0840000000000001,null,1.1679999999999999,null,1.252,null,1.3360000000000001,null,1.42,null,1.504,null,1.5880000000000001,null,1.6719999999999999,null,1.756,null,1.84,null,1.84,null,null,62]
["➊","老齢基礎年金額",null,null,{"$f":"IF('65歳②'!D22=0,'65歳②'!D5,\" \")","v":" "},null,{"$f":"IF(E6<\" \",E6,IF('65歳②'!D24=66,'65歳②'!D5*'65歳③'!G5,\" \"))","v":" "},null,{"$f":"IF(G6<\" \",G6,IF('65歳②'!D24=67,'65歳②'!D5*'65歳③'!I5,\" \"))","v":908470.39999999991},null,{"$f":"IF(I6<\" \",I6,IF('65歳②'!D24=68,'65歳②'!D5*'65歳③'!K5,\" \"))","v":908470.39999999991},null,{"$f":"IF(K6<\" \",K6,IF('65歳②'!D24=69,'65歳②'!D5*'65歳③'!M5,\" \"))","v":908470.39999999991},null,{"$f":"IF(M6<\" \",M6,IF('65歳②'!D24=70,'65歳②'!D5*'65歳③'!O5,\" \"))","v":908470.39999999991},null,{"$f":"IF(O6<\" \",O6,IF('65歳②'!D24=71,'65歳②'!D5*'65歳③'!Q5,\" \"))","v":908470.39999999991},null,{"$f":"IF(Q6<\" \",Q6,IF('65歳②'!D24=72,'65歳②'!D5*'65歳③'!S5,\" \"))","v":908470.39999999991},null,{"$f":"IF(S6<\" \",S6,IF('65歳②'!D24=73,'65歳②'!D5*'65歳③'!U5,\" \"))","v":908470.39999999991},null,{"$f":"IF(U6<\" \",U6,IF('65歳②'!D24=74,'65歳②'!D5*'65歳③'!W5,\" \"))","v":908470.39999999991},null,{"$f":"IF(W6<\" \",W6,IF('65歳②'!D24=75,'65歳②'!D5*'65歳③'!Y5,\" \"))","v":908470.39999999991},null,{"$f":"Y6","v":908470.39999999991},null,null,63]
[null,"振替加算",null,null,{"$f":"IF(E20<65,\" \",IF('65歳②'!D24=65,'65歳②'!S31,\" \"))","v":" "},null,{"$f":"IF(E7<\" \",E7,IF(G20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>66,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(G7<\" \",G7,IF(I20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>67,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(I7<\" \",I7,IF(K20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>68,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(K7<\" \",K7,IF(M20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>69,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(M7<\" \",M7,IF(O20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>70,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(O7<\" \",O7,IF(Q20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>71,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(Q7<\" \",Q7,IF(S20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>72,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(S7<\" \",S7,IF(U20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>73,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(U7<\" \",U7,IF(W20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>74,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(W7<\" \",W7,IF(Y20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>75,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,{"$f":"IF(Y7<\" \",Y7,IF(AA20<65,\" \",IF('65歳②'!L38=0,\" \",IF('65歳②'!D24>76,\" \",IF('65歳②'!D24>=65,'65歳②'!S31,\" \")))))","v":" "},null,null,64]
[null,"小計",null,null,{"$f":"IF(E7=\" \",E6,E6+E7)","v":" "},null,{"$f":"IF(G7=\" \",G6,G6+G7)","v":" "},null,{"$f":"IF(I7=\" \",I6,I6+I7)","v":908470.39999999991},null,{"$f":"IF(K7=\" \",K6,K6+K7)","v":908470.39999999991},null,{"$f":"IF(M7=\" \",M6,M6+M7)","v":908470.39999999991},null,{"$f":"IF(O7=\" \",O6,O6+O7)","v":908470.39999999991},null,{"$f":"IF(Q7=\" \",Q6,Q6+Q7)","v":908470.39999999991},null,{"$f":"IF(S7=\" \",S6,S6+S7)","v":908470.39999999991},null,{"$f":"IF(U7=\" \",U6,U6+U7)","v":908470.39999999991},null,{"$f":"IF(W7=\" \",W6,W6+W7)","v":908470.39999999991},null,{"$f":"IF(Y7=\" \",Y6,Y6+Y7)","v":908470.39999999991},null,{"$f":"IF(AA7=\" \",AA6,AA6+AA7)","v":908470.39999999991},null,null,65,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,66,1.0840000000000001]
["❷","老齢厚生年金額",null,null,{"$f":"IF('65歳②'!D28=0,'65歳②'!F7,\" \")","v":" "},null,{"$f":"IF(E10<\" \",E10,IF('65歳②'!D30=66,('65歳②'!F7*G5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(G10<\" \",G10,IF('65歳②'!D30=67,('65歳②'!F7*I5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(I10<\" \",I10,IF('65歳②'!D30=68,('65歳②'!F7*K5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(K10<\" \",K10,IF('65歳②'!D30=69,('65歳②'!F7*M5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(M10<\" \",M10,IF('65歳②'!D30=70,('65歳②'!F7*O5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(O10<\" \",O10,IF('65歳②'!D30=71,('65歳②'!F7*Q5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(Q10<\" \",Q10,IF('65歳②'!D30=72,('65歳②'!F7*S5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(S10<\" \",S10,IF('65歳②'!D30=73,('65歳②'!F7*U5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(U10<\" \",U10,IF('65歳②'!D30=74,('65歳②'!F7*W5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(W10<\" \",W10,IF('65歳②'!D30=75,('65歳②'!F7*Y5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,{"$f":"IF(Y10<\" \",Y10,IF('65歳②'!D30=75,('65歳②'!F7*AA5*IF('65歳②'!D28=0,1,1-('65歳②'!F7+'65歳②'!D38+'65歳②'!H41-'65歳②'!D44*12)/2/'65歳②'!F7)),\" \"))","v":1811216.8678128},null,null,67,1.1679999999999999]
[null,"定時改定増加見込額",null,null,null,null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<G2,IF(G10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(G10=\" \",\" \",'65歳②'!H41)))","v":18271.461599999999},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<I2,IF(I10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(I10=\" \",\" \",'65歳②'!H42)))","v":36542.923199999997},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<K2,IF(K10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(K10=\" \",\" \",'65歳②'!H43)))","v":54814.3848},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<M2,IF(M10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(M10=\" \",\" \",'65歳②'!H44)))","v":73085.846399999995},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<O2,IF(O10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(O10=\" \",\" \",'65歳②'!H45)))","v":91357.308000000005},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<Q2,IF(Q10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(Q10=\" \",\" \",'65歳②'!H46)))","v":91357.308000000005},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<S2,IF(S10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(S10=\" \",\" \",'65歳②'!H47)))","v":91357.308000000005},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<U2,IF(U10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(U10=\" \",\" \",'65歳②'!H48)))","v":91357.308000000005},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<W2,IF(W10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(W10=\" \",\" \",'65歳②'!H49)))","v":91357.308000000005},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<Y2,IF(Y10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(Y10=\" \",\" \",'65歳②'!H50)))","v":91357.308000000005},null,{"$f":"IF('65歳②'!D34=0,0,IF('65歳②'!D36<AA2,IF(AA10=\" \",\" \",VLOOKUP('65歳②'!D36,'65歳②'!G41:H52,2,FALSE)),IF(AA10=\" \",\" \",'65歳②'!H51)))","v":91357.308000000005}]
[null,"在職支給停止見込額",null,null,{"$f":"IF(E10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38)-'65歳②'!D44*12)/2)))","v":" "},null,{"$f":"IF(G10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+G11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+G11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(I10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+I11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+I11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(K10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+K11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+K11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(M10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+M11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+M11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(O10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+O11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+O11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(Q10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+Q11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+Q11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(S10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+S11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+S11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(U10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+U11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+U11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(W10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+W11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+W11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(Y10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+Y11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+Y11)-'65歳②'!D44*12)/2)))","v":0},null,{"$f":"IF(AA10=\" \",\" \",IF('65歳②'!D34=0,0,IF((('65歳②'!F7+'65歳②'!D38+AA11)-'65歳②'!D44*12)/2<0,0,(('65歳②'!F7+'65歳②'!D38+AA11)-'65歳②'!D44*12)/2)))","v":0}]
[null,"経過的加算(変動有)",null,null,{"$f":"IF(E10=\" \",\" \",'65歳②'!F9)","v":" "},null,{"$f":"IF(E13<\" \",E13,IF('65歳②'!D30=66,'65歳②'!F9*G5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(G13<\" \",G13,IF('65歳②'!D30=67,'65歳②'!F9*I5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(I13<\" \",I13,IF('65歳②'!D30=68,'65歳②'!F9*K5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(K13<\" \",K13,IF('65歳②'!D30=69,'65歳②'!F9*M5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(M13<\" \",M13,IF('65歳②'!D30=70,'65歳②'!F9*O5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(O13<\" \",O13,IF('65歳②'!D30=71,'65歳②'!F9*Q5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(Q13<\" \",Q13,IF('65歳②'!D30=72,'65歳②'!F9*S5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(S13<\" \",S13,IF('65歳②'!D30=73,'65歳②'!F9*U5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(U13<\" \",U13,IF('65歳②'!D30=74,'65歳②'!F9*W5,\" \"))","v":6070.4000000000005},null,{"$f":"IF(W13<\" \",W13,IF('65歳②'!D30=75,'65歳②'!F9*Y5,\" \"))","v":6070.4000000000005},null,{"$f":"Y13","v":6070.4000000000005},null,null,68,1.252]
[null,"配偶者加給年金",null,null,{"$f":"IF(E10=\" \",\" \",IF(E20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(E20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(E20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":" "},null,{"$f":"IF(G10=\" \",\" \",IF(G20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(G20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(G20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":408100},null,{"$f":"IF(I10=\" \",\" \",IF(I20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(I20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(I20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":408100},null,{"$f":"IF(K10=\" \",\" \",IF(K20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(K20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(K20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":408100},null,{"$f":"IF(M10=\" \",\" \",IF(M20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(M20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(M20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":408100},null,{"$f":"IF(O10=\" \",\" \",IF(O20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(O20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(O20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":408100},null,{"$f":"IF(Q10=\" \",\" \",IF(Q20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(Q20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(Q20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":408100},null,{"$f":"IF(S10=\" \",\" \",IF(S20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(S20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(S20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":" "},null,{"$f":"IF(U10=\" \",\" \",IF(U20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(U20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(U20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":" "},null,{"$f":"IF(W10=\" \",\" \",IF(W20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(W20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(W20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":" "},null,{"$f":"IF(Y10=\" \",\" \",IF(Y20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(Y20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(Y20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":" "},null,{"$f":"IF(AA10=\" \",\" \",IF(AA20>=65,\" \",IF('65歳②'!L36=0,IF('65歳①'!C12=2,IF(AA20<VLOOKUP(E20,'65歳②'!Q38:S54,3,FALSE),'65歳②'!O37,\" \"),IF(AA20<VLOOKUP(E20,'65歳②'!Q38:S54,2,FALSE),'65歳②'!O37,\" \")),'65歳②'!O37)))","v":" "},null,null,69,1.3360000000000001]
[null,"小計",null,null,{"$f":"IF(E10=\" \",\" \",IF(E14=\" \",E10-E12+E13,E10-E12+E13+E14))","v":" "},null,{"$f":"IF(G10=\" \",\" \",IF(G14=\" \",G10-G12+G13,G10-G12+G13+G14))","v":2225387.2678127997},null,{"$f":"IF(I10=\" \",\" \",IF(I14=\" \",I10-I12+I13,I10-I12+I13+I14))","v":2225387.2678127997},null,{"$f":"IF(K10=\" \",\" \",IF(K14=\" \",K10-K12+K13,K10-K12+K13+K14))","v":2225387.2678127997},null,{"$f":"IF(M10=\" \",\" \",IF(M14=\" \",M10-M12+M13,M10-M12+M13+M14))","v":2225387.2678127997},null,{"$f":"IF(O10=\" \",\" \",IF(O14=\" \",O10-O12+O13,O10-O12+O13+O14))","v":2225387.2678127997},null,{"$f":"IF(Q10=\" \",\" \",IF(Q14=\" \",Q10-Q12+Q13,Q10-Q12+Q13+Q14))","v":2225387.2678127997},null,{"$f":"IF(S10=\" \",\" \",IF(S14=\" \",S10-S12+S13,S10-S12+S13+S14))","v":1817287.2678127999},null,{"$f":"IF(U10=\" \",\" \",IF(U14=\" \",U10-U12+U13,U10-U12+U13+U14))","v":1817287.2678127999},null,{"$f":"IF(W10=\" \",\" \",IF(W14=\" \",W10-W12+W13,W10-W12+W13+W14))","v":1817287.2678127999},null,{"$f":"IF(Y10=\" \",\" \",IF(Y14=\" \",Y10-Y12+Y13,Y10-Y12+Y13+Y14))","v":1817287.2678127999},null,{"$f":"IF(AA10=\" \",\" \",IF(AA14=\" \",AA10-AA12+AA13,AA10-AA12+AA13+AA14))","v":1817287.2678127999},null,null,70,1.42]
[null,"自身の年金月額",null,null,{"$f":"(IF(E8=\" \",0,E8)+IF(E15=\" \",0,E15))/12","v":0},null,{"$f":"(IF(G8=\" \",0,G8)+IF(G15=\" \",0,G15))/12","v":185448.93898439998},null,{"$f":"(IF(I8=\" \",0,I8)+IF(I15=\" \",0,I15))/12","v":261154.80565106662},null,{"$f":"(IF(K8=\" \",0,K8)+IF(K15=\" \",0,K15))/12","v":261154.80565106662},null,{"$f":"(IF(M8=\" \",0,M8)+IF(M15=\" \",0,M15))/12","v":261154.80565106662},null,{"$f":"(IF(O8=\" \",0,O8)+IF(O15=\" \",0,O15))/12","v":261154.80565106662},null,{"$f":"(IF(Q8=\" \",0,Q8)+IF(Q15=\" \",0,Q15))/12","v":261154.80565106662},null,{"$f":"(IF(S8=\" \",0,S8)+IF(S15=\" \",0,S15))/12","v":227146.47231773334},null,{"$f":"(IF(U8=\" \",0,U8)+IF(U15=\" \",0,U15))/12","v":227146.47231773334},null,{"$f":"(IF(W8=\" \",0,W8)+IF(W15=\" \",0,W15))/12","v":227146.47231773334},null,{"$f":"(IF(Y8=\" \",0,Y8)+IF(Y15=\" \",0,Y15))/12","v":227146.47231773334},null,{"$f":"(IF(AA8=\" \",0,AA8)+IF(AA15=\" \",0,AA15))/12","v":227146.47231773334},null,null,71,1.504]
[null,"自身の給与収入",null,null,{"$f":"IF('65歳②'!D34=0,0,IF(E2>'65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(G2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(I2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(K2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(M2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(O2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(Q2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(S2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(U2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(W2>='65歳②'!D36,0,'65歳②'!D38/12))","v":300000},null,{"$f":"IF('65歳②'!D34=0,0,IF(Y2>='65歳②'!D36,0,'65歳②'!D38/12))","v":0},null,{"$f":"IF('65歳②'!D34=0,0,IF(AA2>='65歳②'!D36,0,'65歳②'!D38/12))","v":0}]
[null,"自身の総収入",null,null,{"$f":"E16+E17","v":300000},null,{"$f":"G16+G17","v":485448.93898440001},null,{"$f":"I16+I17","v":561154.80565106659},null,{"$f":"K16+K17","v":561154.80565106659},null,{"$f":"M16+M17","v":561154.80565106659},null,{"$f":"O16+O17","v":561154.80565106659},null,{"$f":"Q16+Q17","v":561154.80565106659},null,{"$f":"S16+S17","v":527146.47231773334},null,{"$f":"U16+U17","v":527146.47231773334},null,{"$f":"W16+W17","v":527146.47231773334},null,{"$f":"Y16+Y17","v":227146.47231773334},null,{"$f":"AA16+AA17","v":227146.47231773334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,1.5880000000000001]
["⑵　","配偶者の","年齢",null,{"$f":"'65歳①'!C15","v":58},"歳",{"$f":"E20+1","v":59},"歳",{"$f":"G20+1","v":60},"歳",{"$f":"I20+1","v":61},"歳",{"$f":"K20+1","v":62},"歳",{"$f":"M20+1","v":63},"歳",{"$f":"O20+1","v":64},"歳",{"$f":"Q20+1","v":65},"歳",{"$f":"S20+1","v":66},"歳",{"$f":"U20+1","v":67},"歳",{"$f":"W20+1","v":68},"歳",{"$f":"Y20+1","v":69},"歳",null,73,1.6719999999999999]
[null,null,null,"誕生月",{"$f":"'65歳①'!C18","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"E21","v":2},"月",{"$f":"G21","v":2},"月",null,74,1.756]
[null,null,null,"繰下率",{"$f":"IF(E20<65,\" \",IF(E20>=75,AE22,VLOOKUP(E20,AD8:AE22,2,FALSE)))","v":" "},null,{"$f":"IF(G20<65,\" \",IF(G20>=75,AE22,VLOOKUP(G20,AD8:AE22,2,FALSE)))","v":" "},null,{"$f":"IF(I20<65,\" \",IF(I20>=75,AE22,VLOOKUP(I20,AD8:AE22,2,FALSE)))","v":" "},null,{"$f":"IF(K20<65,\" \",IF(K20>=75,AE22,VLOOKUP(K20,AD8:AE22,2,FALSE)))","v":" "},null,{"$f":"IF(M20<65,\" \",IF(M20>=75,AE22,VLOOKUP(M20,AD8:AE22,2,FALSE)))","v":" "},null,{"$f":"IF(O20<65,\" \",IF(O20>=75,AE22,VLOOKUP(O20,AD8:AE22,2,FALSE)))","v":" "},null,{"$f":"IF(Q20<65,\" \",IF(Q20>=75,AE22,VLOOKUP(Q20,AD8:AE22,2,FALSE)))","v":" "},null,{"$f":"IF(S20<65,\" \",IF(S20>=75,AE22,VLOOKUP(S20,AD8:AE22,2,FALSE)))","v":1},null,{"$f":"IF(U20<65,\" \",IF(U20>=75,AE22,VLOOKUP(U20,AD8:AE22,2,FALSE)))","v":1.0840000000000001},null,{"$f":"IF(W20<65,\" \",IF(W20>=75,AE22,VLOOKUP(W20,AD8:AE22,2,FALSE)))","v":1.1679999999999999},null,{"$f":"IF(Y20<65,\" \",IF(Y20>=75,AE22,VLOOKUP(Y20,AD8:AE22,2,FALSE)))","v":1.252},null,{"$f":"IF(AA20<65,\" \",IF(AA20>=75,AE22,VLOOKUP(AA20,AD8:AE22,2,FALSE)))","v":1.3360000000000001},null,null,75,1.84]
["❸","老齢基礎年金額",null,null,{"$f":"IF(E20<60,\" \",IF(E20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(E20<'65歳②'!K24,\" \",'65歳②'!L5*E22))))","v":" "},null,{"$f":"IF(G20<60,\" \",IF(G20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(G20<'65歳②'!K24,\" \",IF(G20>'65歳②'!K24,E23,'65歳②'!L5*G22)))))","v":" "},null,{"$f":"IF(I20<60,\" \",IF(I20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(I20<'65歳②'!K24,\" \",IF(I20>'65歳②'!K24,G23,'65歳②'!L5*I22)))))","v":" "},null,{"$f":"IF(K20<60,\" \",IF(K20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(K20<'65歳②'!K24,\" \",IF(K20>'65歳②'!K24,I23,'65歳②'!L5*K22)))))","v":" "},null,{"$f":"IF(M20<60,\" \",IF(M20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(M20<'65歳②'!K24,\" \",IF(M20>'65歳②'!K24,K23,'65歳②'!L5*M22)))))","v":" "},null,{"$f":"IF(O20<60,\" \",IF(O20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(O20<'65歳②'!K24,\" \",IF(O20>'65歳②'!K24,M23,'65歳②'!L5*O22)))))","v":" "},null,{"$f":"IF(Q20<60,\" \",IF(Q20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(Q20<'65歳②'!K24,\" \",IF(Q20>'65歳②'!K24,O23,'65歳②'!L5*Q22)))))","v":" "},null,{"$f":"IF(S20<60,\" \",IF(S20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(S20<'65歳②'!K24,\" \",IF(S20>'65歳②'!K24,Q23,'65歳②'!L5*S22)))))","v":" "},null,{"$f":"IF(U20<60,\" \",IF(U20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(U20<'65歳②'!K24,\" \",IF(U20>'65歳②'!K24,S23,'65歳②'!L5*U22)))))","v":" "},null,{"$f":"IF(W20<60,\" \",IF(W20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(W20<'65歳②'!K24,\" \",IF(W20>'65歳②'!K24,U23,'65歳②'!L5*W22)))))","v":" "},null,{"$f":"IF(Y20<60,\" \",IF(Y20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(Y20<'65歳②'!K24,\" \",IF(Y20>'65歳②'!K24,W23,'65歳②'!L5*Y22)))))","v":973805.6},null,{"$f":"IF(AA20<60,\" \",IF(AA20<65,IF('65歳②'!J5=0,\" \",'65歳②'!J5),IF('65歳②'!K22=0,'65歳②'!L5,IF(AA20<'65歳②'!K24,\" \",IF(AA20>'65歳②'!K24,Y23,'65歳②'!L5*AA22)))))","v":973805.6}]
[null,"振替加算",null,null,{"$f":"IF(E23=\" \",\" \",IF(E20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(G23=\" \",\" \",IF(G20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(I23=\" \",\" \",IF(I20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(K23=\" \",\" \",IF(K20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(M23=\" \",\" \",IF(M20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(O23=\" \",\" \",IF(O20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(Q23=\" \",\" \",IF(Q20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(S23=\" \",\" \",IF(S20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(U23=\" \",\" \",IF(U20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(W23=\" \",\" \",IF(W20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":" "},null,{"$f":"IF(Y23=\" \",\" \",IF(Y20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":0},null,{"$f":"IF(AA23=\" \",\" \",IF(AA20<65,\" \",IF('65歳②'!L40=0,\" \",VLOOKUP('65歳①'!C15,'65歳②'!Q20:S36,3,FALSE))))","v":0}]
[null,"小計",null,null,{"$f":"IF(E24=\" \",E23,E23+E24)","v":" "},null,{"$f":"IF(G24=\" \",G23,G23+G24)","v":" "},null,{"$f":"IF(I24=\" \",I23,I23+I24)","v":" "},null,{"$f":"IF(K24=\" \",K23,K23+K24)","v":" "},null,{"$f":"IF(M24=\" \",M23,M23+M24)","v":" "},null,{"$f":"IF(O24=\" \",O23,O23+O24)","v":" "},null,{"$f":"IF(Q24=\" \",Q23,Q23+Q24)","v":" "},null,{"$f":"IF(S24=\" \",S23,S23+S24)","v":" "},null,{"$f":"IF(U24=\" \",U23,U23+U24)","v":" "},null,{"$f":"IF(W24=\" \",W23,W23+W24)","v":" "},null,{"$f":"IF(Y24=\" \",Y23,Y23+Y24)","v":973805.6},null,{"$f":"IF(AA24=\" \",AA23,AA23+AA24)","v":973805.6}]
[]
["❹","老齢厚生年金額",null,null,{"$f":"IF(E20<60,\" \",IF(E20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(E20<'65歳②'!K30,\" \",IF('65歳②'!K30<E20,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N7,'65歳②'!N7*E22)))))","v":" "},null,{"$f":"IF(G20<60,\" \",IF(G20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(G20<'65歳②'!K30,\" \",IF(G20>'65歳②'!K30,E27,'65歳②'!N7*G22)))))","v":" "},null,{"$f":"IF(I20<60,\" \",IF(I20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(I20<'65歳②'!K30,\" \",IF(I20>'65歳②'!K30,G27,'65歳②'!N7*I22)))))","v":835000},null,{"$f":"IF(K20<60,\" \",IF(K20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(K20<'65歳②'!K30,\" \",IF(K20>'65歳②'!K30,I27,'65歳②'!N7*K22)))))","v":835000},null,{"$f":"IF(M20<60,\" \",IF(M20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(M20<'65歳②'!K30,\" \",IF(M20>'65歳②'!K30,K27,'65歳②'!N7*M22)))))","v":835000},null,{"$f":"IF(O20<60,\" \",IF(O20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(O20<'65歳②'!K30,\" \",IF(O20>'65歳②'!K30,M27,'65歳②'!N7*O22)))))","v":835000},null,{"$f":"IF(Q20<60,\" \",IF(Q20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(Q20<'65歳②'!K30,\" \",IF(Q20>'65歳②'!K30,O27,'65歳②'!N7*Q22)))))","v":835000},null,{"$f":"IF(S20<60,\" \",IF(S20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(S20<'65歳②'!K30,\" \",IF(S20>'65歳②'!K30,Q27,'65歳②'!N7*S22)))))","v":" "},null,{"$f":"IF(U20<60,\" \",IF(U20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(U20<'65歳②'!K30,\" \",IF(U20>'65歳②'!K30,S27,'65歳②'!N7*U22)))))","v":" "},null,{"$f":"IF(W20<60,\" \",IF(W20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(W20<'65歳②'!K30,\" \",IF(W20>'65歳②'!K30,U27,'65歳②'!N7*W22)))))","v":1401600},null,{"$f":"IF(Y20<60,\" \",IF(Y20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(Y20<'65歳②'!K30,\" \",IF(Y20>'65歳②'!K30,W27,'65歳②'!N7*Y22)))))","v":1401600},null,{"$f":"IF(AA20<60,\" \",IF(AA20<65,IF('65歳②'!J7=0,\" \",'65歳②'!J7),IF('65歳②'!K28=0,'65歳②'!N7,IF(AA20<'65歳②'!K30,\" \",IF(AA20>'65歳②'!K30,Y27,'65歳②'!N7*AA22)))))","v":1401600}]
[null,"在職支給停止額",null,null,{"$f":"IF(E27=\" \",\" \",IF(E20<65,'65歳②'!C54,'65歳②'!D54))","v":" "},null,{"$f":"IF(G27=\" \",\" \",IF(G20<65,'65歳②'!C54,'65歳②'!D54))","v":" "},null,{"$f":"IF(I27=\" \",\" \",IF(I20<65,'65歳②'!C54,'65歳②'!D54))","v":0},null,{"$f":"IF(K27=\" \",\" \",IF(K20<65,'65歳②'!C54,'65歳②'!D54))","v":0},null,{"$f":"IF(M27=\" \",\" \",IF(M20<65,'65歳②'!C54,'65歳②'!D54))","v":0},null,{"$f":"IF(O27=\" \",\" \",IF(O20<65,'65歳②'!C54,'65歳②'!D54))","v":0},null,{"$f":"IF(Q27=\" \",\" \",IF(Q20<65,'65歳②'!C54,'65歳②'!D54))","v":0},null,{"$f":"IF(S27=\" \",\" \",IF(S20<65,'65歳②'!C54,'65歳②'!D54))","v":" "},null,{"$f":"IF(U27=\" \",\" \",IF(U20<65,'65歳②'!C54,'65歳②'!D54))","v":" "},null,{"$f":"IF(W27=\" \",\" \",IF(W20<65,'65歳②'!C54,'65歳②'!D54))","v":0},null,{"$f":"IF(Y27=\" \",\" \",IF(Y20<65,'65歳②'!C54,'65歳②'!D54))","v":0},null,{"$f":"IF(AA27=\" \",\" \",IF(AA20<65,'65歳②'!C54,'65歳②'!D54))","v":0}]
[null,"経過的加算",null,null,{"$f":"IF(E20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(E27=\" \",\" \",IF('65歳②'!K30=E20,'65歳②'!N9*E22,IF('65歳②'!K30<E20,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9,'65歳②'!N9)))))","v":" "},null,{"$f":"IF(G20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(G27=\" \",\" \",IF('65歳②'!K30=G20,'65歳②'!N9*G22,IF('65歳②'!K30<G20,E29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":" "},null,{"$f":"IF(I20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(I27=\" \",\" \",IF('65歳②'!K30=I20,'65歳②'!N9*I22,IF('65歳②'!K30<I20,G29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":" "},null,{"$f":"IF(K20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(K27=\" \",\" \",IF('65歳②'!K30=K20,'65歳②'!N9*K22,IF(K20>'65歳②'!K30,I29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FAKSE)*'65歳②'!N9)))))","v":" "},null,{"$f":"IF(M20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(M27=\" \",\" \",IF('65歳②'!K30=M20,'65歳②'!N9*M22,IF(M20>'65歳②'!K30,K29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":" "},null,{"$f":"IF(O20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(O27=\" \",\" \",IF('65歳②'!K30=O20,'65歳②'!N9*O22,IF(O20>'65歳②'!K30,M29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":" "},null,{"$f":"IF(Q20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(Q27=\" \",\" \",IF('65歳②'!K30=Q20,'65歳②'!N9*Q22,IF(Q20>'65歳②'!K30,O29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":" "},null,{"$f":"IF(S20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(S27=\" \",\" \",IF('65歳②'!K30=S20,'65歳②'!N9*S22,IF(S20>'65歳②'!K30,Q29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":" "},null,{"$f":"IF(U20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(U27=\" \",\" \",IF('65歳②'!K30=U20,'65歳②'!N9*U22,IF(U20>'65歳②'!K30,S29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":" "},null,{"$f":"IF(W20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(W27=\" \",\" \",IF('65歳②'!K30=W20,'65歳②'!N9*W22,IF(W20>'65歳②'!K30,U29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":2803.2},null,{"$f":"IF(Y20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(Y27=\" \",\" \",IF('65歳②'!K30=Y20,'65歳②'!N9*Y22,IF(Y20>'65歳②'!K30,W29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":2803.2},null,{"$f":"IF(AA20<65,\" \",IF('65歳②'!K28=0,'65歳②'!N9,IF(AA27=\" \",\" \",IF('65歳②'!K30=AA20,'65歳②'!N9*AA22,IF(AA20>'65歳②'!K30,Y29,VLOOKUP('65歳②'!K30,AD8:AE22,2,FALSE)*'65歳②'!N9)))))","v":2803.2}]
[null,"配偶者加給年金"]
[null,"小計",null,null,{"$f":"IF(E29=\" \",E27,E27-E28+E29)","v":" "},null,{"$f":"IF(G29=\" \",G27,G27-G28+G29)","v":" "},null,{"$f":"IF(I29=\" \",I27,I27-I28+I29)","v":835000},null,{"$f":"IF(K29=\" \",K27,K27-K28+K29)","v":835000},null,{"$f":"IF(M29=\" \",M27,M27-M28+M29)","v":835000},null,{"$f":"IF(O29=\" \",O27,O27-O28+O29)","v":835000},null,{"$f":"IF(Q29=\" \",Q27,Q27-Q28+Q29)","v":835000},null,{"$f":"IF(S29=\" \",S27,S27-S28+S29)","v":" "},null,{"$f":"IF(U29=\" \",U27,U27-U28+U29)","v":" "},null,{"$f":"IF(W29=\" \",W27,W27-W28+W29)","v":1404403.2},null,{"$f":"IF(Y29=\" \",Y27,Y27-Y28+Y29)","v":1404403.2},null,{"$f":"IF(AA29=\" \",AA27,AA27-AA28+AA29)","v":1404403.2}]
[null,"配偶者年金月額",null,null,{"$f":"(IF(E25=\" \",0,E25)+IF(E31=\" \",0,E31))/12","v":0},null,{"$f":"(IF(G25=\" \",0,G25)+IF(G31=\" \",0,G31))/12","v":0},null,{"$f":"(IF(I25=\" \",0,I25)+IF(I31=\" \",0,I31))/12","v":69583.333333333328},null,{"$f":"(IF(K25=\" \",0,K25)+IF(K31=\" \",0,K31))/12","v":69583.333333333328},null,{"$f":"(IF(M25=\" \",0,M25)+IF(M31=\" \",0,M31))/12","v":69583.333333333328},null,{"$f":"(IF(O25=\" \",0,O25)+IF(O31=\" \",0,O31))/12","v":69583.333333333328},null,{"$f":"(IF(Q25=\" \",0,Q25)+IF(Q31=\" \",0,Q31))/12","v":69583.333333333328},null,{"$f":"(IF(S25=\" \",0,S25)+IF(S31=\" \",0,S31))/12","v":0},null,{"$f":"(IF(U25=\" \",0,U25)+IF(U31=\" \",0,U31))/12","v":0},null,{"$f":"(IF(W25=\" \",0,W25)+IF(W31=\" \",0,W31))/12","v":117033.59999999999},null,{"$f":"(IF(Y25=\" \",0,Y25)+IF(Y31=\" \",0,Y31))/12","v":198184.06666666665},null,{"$f":"(IF(AA25=\" \",0,AA25)+IF(AA31=\" \",0,AA31))/12","v":198184.06666666665}]
[null,"配偶者の給与収入",null,null,{"$f":"IF('65歳②'!D48=0,0,IF(E20>'65歳②'!D50,0,'65歳②'!D52/12))","v":150000},null,{"$f":"IF('65歳②'!D48=0,0,IF(G20>'65歳②'!D50,0,'65歳②'!D52/12))","v":150000},null,{"$f":"IF('65歳②'!D48=0,0,IF(I20>'65歳②'!D50,0,'65歳②'!D52/12))","v":150000},null,{"$f":"IF('65歳②'!D48=0,0,IF(K20>'65歳②'!D50,0,'65歳②'!D52/12))","v":150000},null,{"$f":"IF('65歳②'!D48=0,0,IF(K20>'65歳②'!D50,0,'65歳②'!D52/12))","v":150000},null,{"$f":"IF('65歳②'!D48=0,0,IF(O20>'65歳②'!D50,0,'65歳②'!D52/12))","v":150000},null,{"$f":"IF('65歳②'!D48=0,0,IF(Q20>'65歳②'!D50,0,'65歳②'!D52/12))","v":150000},null,{"$f":"IF('65歳②'!D48=0,0,IF(S20>'65歳②'!D50,0,'65歳②'!D52/12))","v":150000},null,{"$f":"IF('65歳②'!D48=0,0,IF(U20>'65歳②'!D50,0,'65歳②'!D52/12))","v":0},null,{"$f":"IF('65歳②'!D48=0,0,IF(W20>'65歳②'!D50,0,'65歳②'!D52/12))","v":0},null,{"$f":"IF('65歳②'!D48=0,0,IF(Y20>'65歳②'!D50,0,'65歳②'!D52/12))","v":0},null,{"$f":"IF('65歳②'!D48=0,0,IF(AA20>'65歳②'!D50,0,'65歳②'!D52/12))","v":0}]
[null,"配偶者の総収入",null,null,{"$f":"E32+E33","v":150000},null,{"$f":"G32+G33","v":150000},null,{"$f":"I32+I33","v":219583.33333333331},null,{"$f":"K32+K33","v":219583.33333333331},null,{"$f":"M32+M33","v":219583.33333333331},null,{"$f":"O32+O33","v":219583.33333333331},null,{"$f":"Q32+Q33","v":219583.33333333331},null,{"$f":"S32+S33","v":150000},null,{"$f":"U32+U33","v":0},null,{"$f":"W32+W33","v":117033.59999999999},null,{"$f":"Y32+Y33","v":198184.06666666665},null,{"$f":"AA32+AA33","v":198184.06666666665}]
[]
["⑶","年金額(世帯合計)",null,null,{"$f":"E16+E32","v":0},null,{"$f":"G16+G32","v":185448.93898439998},null,{"$f":"I16+I32","v":330738.13898439996},null,{"$f":"K16+K32","v":330738.13898439996},null,{"$f":"M16+M32","v":330738.13898439996},null,{"$f":"O16+O32","v":330738.13898439996},null,{"$f":"Q16+Q32","v":330738.13898439996},null,{"$f":"S16+S32","v":227146.47231773334},null,{"$f":"U16+U32","v":227146.47231773334},null,{"$f":"W16+W32","v":344180.07231773331},null,{"$f":"Y16+Y32","v":425330.53898439999},null,{"$f":"AA16+AA32","v":425330.53898439999}]
[null,"賃金その他の収入",null,null,{"$f":"E17+E33","v":450000},null,{"$f":"G17+G33","v":450000},null,{"$f":"I17+I33","v":450000},null,{"$f":"K17+K33","v":450000},null,{"$f":"M17+M33","v":450000},null,{"$f":"O17+O33","v":450000},null,{"$f":"Q17+Q33","v":450000},null,{"$f":"S17+S33","v":450000},null,{"$f":"U17+U33","v":300000},null,{"$f":"W17+W33","v":300000},null,{"$f":"Y17+Y33","v":0},null,{"$f":"AA17+AA33","v":0}]
[null,"世帯の合計収入",null,null,{"$f":"E36+E37","v":450000},null,{"$f":"G36+G37","v":635448.93898440001},null,{"$f":"I36+I37","v":780738.13898439996},null,{"$f":"K36+K37","v":780738.13898439996},null,{"$f":"M36+M37","v":780738.13898439996},null,{"$f":"O36+O37","v":780738.13898439996},null,{"$f":"Q36+Q37","v":780738.13898439996},null,{"$f":"S36+S37","v":677146.47231773334},null,{"$f":"U36+U37","v":527146.47231773334},null,{"$f":"W36+W37","v":644180.07231773331},null,{"$f":"Y36+Y37","v":425330.53898439999},null,{"$f":"AA36+AA37","v":425330.53898439999}]
[null,"税・保険料",null,null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0},null,{"$f":"'65歳①'!H8","v":0}]
[]
[null,"世帯可処分所得月額",null,null,{"$f":"E38-E39","v":450000},null,{"$f":"G38-G39","v":635448.93898440001},null,{"$f":"I38-I39","v":780738.13898439996},null,{"$f":"K38-K39","v":780738.13898439996},null,{"$f":"M38-M39","v":780738.13898439996},null,780738.13898439996,null,780738.13898439996,null,677146.47231773334,null,527146.47231773334,null,644180.07231773331,null,425330.53898439999,null,425330.53898439999]
["⑷","現在の夫婦生活費",null,null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973},null,{"$f":"'65歳①'!H20","v":231973}]
["総務省家計調査生活費平均",null,null,null,231973]
["A","夫婦最低日常生活費",null,null,232000]
["B","夫婦ゆとり生活費",null,null,379000]
[]
["⑸","不足生活費",null,null,{"$f":"E41-E42","v":218027},null,{"$f":"G41-G42","v":403475.93898440001},null,{"$f":"I41-I42","v":548765.13898439996},null,{"$f":"K41-K42","v":548765.13898439996},null,{"$f":"M41-M42","v":548765.13898439996},null,{"$f":"O41-O42","v":548765.13898439996},null,{"$f":"Q41-Q42","v":548765.13898439996},null,{"$f":"S41-S42","v":445173.47231773334},null,{"$f":"U41-U42","v":295173.47231773334},null,{"$f":"W41-W42","v":412207.07231773331},null,{"$f":"Y41-Y42","v":193357.53898439999},null,{"$f":"AA41-AA42","v":193357.53898439999}]
["※⑷　家計簿や預金通帳等から過去１年間の家計の支出額を平均した額"]
["※A　公益財団法人生命保険文化センター公表の「老後を夫婦２人で暮らしていく上で必要と考えられている最低日常生活費の平均額」は、232，000円（R４年度）"]
["※B　公益財団法人生命保険文化センター公表の「老後を夫婦２人で暮らしていく上で必要と考えられているゆとりある老後生活費の平均額」は、379，000円（R４年度）"]