{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["入力シート","加入者情報","内訳","各期納付額","給与所得算出","年金所得算出"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":95,"n_cols":36,"rows_kept":95,"cut":false,"hidden":false,"merged":[[50,1,50,2],[91,9,91,12],[87,8,87,14],[73,6,73,7],[75,1,75,2],[75,3,75,4],[75,6,75,7],[75,9,75,10],[90,9,90,12],[86,7,86,10],[77,1,77,2],[84,7,84,10],[73,9,73,10],[52,1,52,2],[65,4,65,5],[94,0,98,16],[43,1,43,3],[73,3,73,4],[73,1,73,2],[84,11,84,13],[86,11,86,13],[65,6,65,8],[65,9,65,11],[69,9,69,10],[67,1,67,2],[56,1,56,2],[58,1,58,2],[69,1,69,2],[84,3,84,5],[80,1,80,2],[48,1,48,2],[0,1,0,16],[8,12,18,16],[21,1,30,16],[6,3,7,16],[2,1,5,16],[6,1,7,2],[10,1,10,2],[10,3,10,10],[8,3,8,10],[11,1,18,2],[11,3,18,10],[8,1,9,2],[9,3,9,10],[40,1,40,16],[41,1,41,3],[42,1,42,3],[41,4,41,10],[42,4,42,10],[41,11,44,18],[36,1,36,2],[37,1,37,2],[35,1,35,2],[34,1,34,2],[38,1,38,18],[33,3,33,5],[33,6,33,8],[33,9,33,11],[33,12,33,14],[75,12,75,13],[71,1,71,2],[65,12,65,14],[67,12,67,13],[69,12,69,13],[71,12,71,13],[73,12,73,13],[67,3,67,4],[69,3,69,4],[67,9,67,10],[67,6,67,7],[69,6,69,7],[43,4,43,10],[54,1,54,2]]}
[null,{"$f":"CONCATENATE(\"令和\",Z14,\"年度（\",X14,\"年度）姫路市国民健康保険料簡易計算シート\")","v":"令和8年度（2026年度）姫路市国民健康保険料簡易計算シート"}]
[]
[null,"この計算シートでは、「年齢区分」、「給与所得」、「年金所得」、「その他所得」を入力するだけで、およその国民健康保険料が計算できます。（下の入力欄に必要事項を入力してください）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"〇入力規則選択内容"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"加入者年齢区分","加入しない"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"未就学児"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"小学生以上17歳まで"]
[null,"年齢区分",null,"「加入しない」「未就学児」「小学生以上17歳まで」「18歳から39歳まで」「40歳から64歳まで」「65歳から74歳まで」のいずれかを選択してください。※未就学児とは、令和2年4月2日以降に生まれた方を言います。\n令和8年1月1日現在で65歳以上の方は、右端の「65歳以上」欄で「はい」を選択してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18歳から39歳まで"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40歳から64歳まで"]
[null,"給与所得",null,"令和7年1月1日から12月31日までの1年間における給与所得額を入力してください。",null,null,null,null,null,null,null,null,"世帯主については、軽減判定のため、加入されない場合でも必ず入力してください。（その場合は、年齢区分の欄は「加入しない」を選択した上で、入力してください）",null,null,null,null,null,null,null,null,null,null,"65歳から74歳まで"]
[null,null,null,"※租税特別措置法第41条の3の3第1項に規定する所得金額調整控除に該当する方は、\n控除後の金額を入力してください。第2項については適用前の金額を入力してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65歳以上","はい"]
[null,"年金所得",null,"令和7年1月1日から12月31日までの1年間における公的年金（障害年金や遺族年金を除く）所得額を入力してください。"]
[null,"その他所得",null,"令和7年1月1日から12月31日までの1年間における給与所得、年金所得以外の所得の額を入力してください。\n※「その他所得」とは、営業・農業等の事業所得、不動産所得、配当所得、一時所得、雑所得、山林所得、長期及び短期譲渡所得、土地等に係る事業所得、株式等に係る譲渡所所得などの金額です。\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,"対象の年度(西暦)",2026,"令和に換算→",{"$f":"X14-2018","v":8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"軽減判定","7割軽減",430000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5割軽減",310000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2割軽減",570000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上限額","医療分",670000]
[null,"ご注意",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支援金分",260000]
[null,"次の項目に該当する場合は、このシートでは計算できません。\n(1)年度の途中に加入者の所得や加入人数が変わる場合\n(2)年度の途中に加入者が40歳・65歳・75歳に到達する場合\n(3)世帯内に、国民健康保険から後期高齢者医療制度に移行した人がいる場合\n(4)専従者給与がある場合\n(5)専従者控除を必要経費に算入している場合\n(6)土地建物等の譲渡所得の特別控除が適用されている場合\n(7)損益通算・繰越控除の適用がある場合\n(8)保険料の軽減・減免制度が適用される場合\n　（例）非自発的失業者軽減、産前産後軽減、失業減免",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"介護分",170000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"子ども子育て支援金分",30000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"納期限","1期","2026-06-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2期","2026-07-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3期","2026-08-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4期","2026-09-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5期","2026-11-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6期","2026-11-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7期","2026-12-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8期","2027-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9期","2027-03-01"]
[null,"保険料率（仮）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10期","2027-03-31"]
[null,null,null,"医療分（R7料率）\n（注1）",null,null,"支援金分（R7料率）\n（注1）",null,null,"介護分（R7料率）\n（注1）（注2）",null,null,"子ども子育て支援金分\n（注3）",null,null,null,null,null,null,null,null,null,"公的年金特別控除対象",null,"1961-01-01"]
[null,"所 得 割",null,null,7.0000000000000007E-2,null,null,0.03,null,null,2.7E-2]
[null,"均 等 割",null,null,29310,null,null,12560,null,null,12550,null,null,2400]
[null,"18歳以上均等割",null,null,"ー",null,null,"ー",null,null,"ー"]
[null,"平 等 割",null,null,18220,null,null,7810,null,null,6340]
[null,"（注1）医療分、支援金分、介護分は令和７年度の保険料率です。\n（注2）介護分は、４０歳から６４歳までの方（介護保険第２号被保険者）に賦課されます。\n（注3）子ども・子育て支援金については、国が試算した国民健康保険加入者一人当たりの令和8年度の平均月額200円を基に、年間額に換算したもの\n　　  です。なお、令和8年度の保険料率は5月末頃に決定する予定であり、実際の保険料率とは異なるためご注意ください。"]
[null,{"$f":"CONCATENATE(\"令和\",Z14,\"年度（\",X14,\"年度）における保険料の軽減制度\")","v":"令和8年度（2026年度）における保険料の軽減制度"}]
[null,"※世帯主と加入者全員の令和7年1月1日から12月31日までの1年間における所得の合計額が下記の金額以下の世帯は、\n均等割と平等割が軽減されます。"]
[null,"７割軽減",null,null,{"$f":"Y16/10000","v":43},null,null,null,null,null,null,"ご注意\n①国民健康保険から移行した後期高齢者の所得及び人数を含みます。\n②所得未申告の世帯は、軽減が適用されません。"]
[null,"５割軽減",null,null,{"$f":"Y17/10000","v":31}]
[null,"２割軽減",null,null,{"$f":"Y18/10000","v":57}]
[]
[null,"○入力欄"]
[null,"名前",null,null,"年齢区分",null,null,"給与所得",null,null,"年金所得",null,null,"その他所得",null,null,"R08.1.1現在\n65歳以上",null,null,null,null,"公的年金等特別控除","年金所得","軽減判定年金所得","給与所得","給与所得者等判定","2項控除該当(賦課)","2項控除該当(軽減)","2項控除額(賦課)","2項控除額(軽減)","控除後給与(賦課)","控除後給与(軽減)","その他所得","軽減判定所得","総所得金額","賦課基本所得"]
[]
[null,"世帯主",null,null,"加入しない",null,null,null,"円",null,null,"円",null,null,"円",null,null,null,null,null,null,{"$f":"IF(Q49=\"はい\",\"該当\",\"非該当\")","v":"非該当"},{"$f":"K49","v":0},{"$f":"IF(V49=\"該当\",(IF((W49-150000)>0,(W49-150000),0)),W49)","v":0},{"$f":"H49","v":0},{"$f":"IF(OR(X49>0,Y49>0),1,0)","v":0},{"$f":"IF(AND(W49>0,Y49>0),IF((W49+Y49)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AND(X49>0,Y49>0),IF((X49+Y49)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AA49=\"該当\",IF(W49>100000,100000,W49)+IF(Y49>100000,100000,Y49)-100000,0)","v":0},{"$f":"IF(AB49=\"該当\",IF(X49>100000,100000,X49)+IF(Y49>100000,100000,Y49)-100000,0)","v":0},{"$f":"Y49-AC49","v":0},{"$f":"Y49-AD49","v":0},{"$f":"N49","v":0},{"$f":"SUM(X49,AF49,AG49)","v":0},{"$f":"SUM(W49,AE49,AG49)","v":0},{"$f":"IF((AI49-430000)>0,(AI49-430000),0)","v":0}]
[]
[null,"加入者１",null,null,"加入しない",null,null,null,"円",null,null,"円",null,null,"円",null,null,null,null,null,null,{"$f":"IF(Q51=\"はい\",\"該当\",\"非該当\")","v":"非該当"},{"$f":"K51","v":0},{"$f":"IF(V51=\"該当\",(IF((W51-150000)>0,(W51-150000),0)),W51)","v":0},{"$f":"H51","v":0},{"$f":"IF(OR(X51>0,Y51>0),1,0)","v":0},{"$f":"IF(AND(W51>0,Y51>0),IF((W51+Y51)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AND(X51>0,Y51>0),IF((X51+Y51)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AA51=\"該当\",IF(W51>100000,100000,W51)+IF(Y51>100000,100000,Y51)-100000,0)","v":0},{"$f":"IF(AB51=\"該当\",IF(X51>100000,100000,X51)+IF(Y51>100000,100000,Y51)-100000,0)","v":0},{"$f":"Y51-AC51","v":0},{"$f":"Y51-AD51","v":0},{"$f":"N51","v":0},{"$f":"SUM(X51,AF51,AG51)","v":0},{"$f":"SUM(W51,AE51,AG51)","v":0},{"$f":"IF((AI51-430000)>0,(AI51-430000),0)","v":0}]
[]
[null,"加入者２",null,null,"加入しない",null,null,null,"円",null,null,"円",null,null,"円",null,null,null,null,null,null,{"$f":"IF(Q53=\"はい\",\"該当\",\"非該当\")","v":"非該当"},{"$f":"K53","v":0},{"$f":"IF(V53=\"該当\",(IF((W53-150000)>0,(W53-150000),0)),W53)","v":0},{"$f":"H53","v":0},{"$f":"IF(OR(X53>0,Y53>0),1,0)","v":0},{"$f":"IF(AND(W53>0,Y53>0),IF((W53+Y53)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AND(X53>0,Y53>0),IF((X53+Y53)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AA53=\"該当\",IF(W53>100000,100000,W53)+IF(Y53>100000,100000,Y53)-100000,0)","v":0},{"$f":"IF(AB53=\"該当\",IF(X53>100000,100000,X53)+IF(Y53>100000,100000,Y53)-100000,0)","v":0},{"$f":"Y53-AC53","v":0},{"$f":"Y53-AD53","v":0},{"$f":"N53","v":0},{"$f":"SUM(X53,AF53,AG53)","v":0},{"$f":"SUM(W53,AE53,AG53)","v":0},{"$f":"IF((AI53-430000)>0,(AI53-430000),0)","v":0}]
[]
[null,"加入者３",null,null,"加入しない",null,null,null,"円",null,null,"円",null,null,"円",null,null,null,null,null,null,{"$f":"IF(Q55=\"はい\",\"該当\",\"非該当\")","v":"非該当"},{"$f":"K55","v":0},{"$f":"IF(V55=\"該当\",(IF((W55-150000)>0,(W55-150000),0)),W55)","v":0},{"$f":"H55","v":0},{"$f":"IF(OR(X55>0,Y55>0),1,0)","v":0},{"$f":"IF(AND(W55>0,Y55>0),IF((W55+Y55)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AND(X55>0,Y55>0),IF((X55+Y55)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AA55=\"該当\",IF(W55>100000,100000,W55)+IF(Y55>100000,100000,Y55)-100000,0)","v":0},{"$f":"IF(AB55=\"該当\",IF(X55>100000,100000,X55)+IF(Y55>100000,100000,Y55)-100000,0)","v":0},{"$f":"Y55-AC55","v":0},{"$f":"Y55-AD55","v":0},{"$f":"N55","v":0},{"$f":"SUM(X55,AF55,AG55)","v":0},{"$f":"SUM(W55,AE55,AG55)","v":0},{"$f":"IF((AI55-430000)>0,(AI55-430000),0)","v":0}]
[]
[null,"加入者４",null,null,"加入しない",null,null,null,"円",null,null,"円",null,null,"円",null,null,null,null,null,null,{"$f":"IF(Q57=\"はい\",\"該当\",\"非該当\")","v":"非該当"},{"$f":"K57","v":0},{"$f":"IF(V57=\"該当\",(IF((W57-150000)>0,(W57-150000),0)),W57)","v":0},{"$f":"H57","v":0},{"$f":"IF(OR(X57>0,Y57>0),1,0)","v":0},{"$f":"IF(AND(W57>0,Y57>0),IF((W57+Y57)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AND(X57>0,Y57>0),IF((X57+Y57)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AA57=\"該当\",IF(W57>100000,100000,W57)+IF(Y57>100000,100000,Y57)-100000,0)","v":0},{"$f":"IF(AB57=\"該当\",IF(X57>100000,100000,X57)+IF(Y57>100000,100000,Y57)-100000,0)","v":0},{"$f":"Y57-AC57","v":0},{"$f":"Y57-AD57","v":0},{"$f":"N57","v":0},{"$f":"SUM(X57,AF57,AG57)","v":0},{"$f":"SUM(W57,AE57,AG57)","v":0},{"$f":"IF((AI57-430000)>0,(AI57-430000),0)","v":0}]
[]
[null,"加入者５",null,null,"加入しない",null,null,null,"円",null,null,"円",null,null,"円",null,null,null,null,null,null,{"$f":"IF(Q59=\"はい\",\"該当\",\"非該当\")","v":"非該当"},{"$f":"K59","v":0},{"$f":"IF(V59=\"該当\",(IF((W59-150000)>0,(W59-150000),0)),W59)","v":0},{"$f":"H59","v":0},{"$f":"IF(OR(X59>0,Y59>0),1,0)","v":0},{"$f":"IF(AND(W59>0,Y59>0),IF((W59+Y59)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AND(X59>0,Y59>0),IF((X59+Y59)>100000,\"該当\",\"非該当\"),\"非該当\")","v":"非該当"},{"$f":"IF(AA59=\"該当\",IF(W59>100000,100000,W59)+IF(Y59>100000,100000,Y59)-100000,0)","v":0},{"$f":"IF(AB59=\"該当\",IF(X59>100000,100000,X59)+IF(Y59>100000,100000,Y59)-100000,0)","v":0},{"$f":"Y59-AC59","v":0},{"$f":"Y59-AD59","v":0},{"$f":"N59","v":0},{"$f":"SUM(X59,AF59,AG59)","v":0},{"$f":"SUM(W59,AE59,AG59)","v":0},{"$f":"IF((AI59-430000)>0,(AI59-430000),0)","v":0}]
[]
[null,"※世帯主は、国民健康保険に加入しない場合においても、所得欄に所得を入力してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"給与所得者等の数：",{"$f":"SUM(Z49,Z51,Z53,Z55,Z57,Z59)","v":0}]
[null,"加入しない場合、年齢区分の欄は「加入しない」のままにしておいてください。"]
[null,"※加入者１～５は、世帯主以外の加入者の情報を入力してください。"]
[]
[null,"○試算結果",null,null,{"$f":"CONCATENATE(\"令和\",Z14,\"年度（令和\",Z14,\"年4月～令和\",Z14+1,\"年3月）の保険料の目安\")","v":"令和8年度（令和8年4月～令和9年3月）の保険料の目安"}]
[null,null,null,null,"医療分",null,"支援金分",null,null,"介護分",null,null,"子ども子育て支援金分"]
[]
[null,"所得割算定額",null,{"$f":"内訳!J5","v":""},null,"円",{"$f":"内訳!J28","v":""},null,"円",{"$f":"内訳!J51","v":""},null,"円",{"$f":"内訳!J70","v":""},null,"円"]
[null,null,null,null,"＋",null,null,"＋",null,null,"＋",null,null,"＋"]
[null,"均等割算定額",null,{"$f":"内訳!H12","v":""},null,"円",{"$f":"内訳!H35","v":""},null,"円",{"$f":"内訳!H58","v":""},null,"円",{"$f":"内訳!H77","v":""},null,"円"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"＋"]
[null,"18歳以上均等割算定額",null,null,null,null,null,null,null,null,null,null,{"$f":"内訳!H81","v":""},null,"円"]
[null,null,null,null,"＋",null,null,"＋",null,null,"＋",null,null,"＋"]
[null,"平等割算定額",null,{"$f":"内訳!H20","v":""},null,"円",{"$f":"内訳!H43","v":""},null,"円",{"$f":"内訳!H62","v":""},null,"円",{"$f":"内訳!H85","v":""},null,"円"]
[null,null,null,null,"－",null,null,"－",null,null,"－",null,null,"－"]
[null,"法定軽減額",null,{"$f":"SUM(内訳!H14,内訳!H18,内訳!H22)","v":0},null,"円",{"$f":"SUM(内訳!H37,内訳!H41,内訳!H45)","v":0},null,"円",{"$f":"SUM(内訳!H60,内訳!H64)","v":0},null,"円",{"$f":"SUM(内訳!H79,内訳!H83,内訳!H87)","v":0},null,"円"]
[null,null,null,null,"＝",null,null,"＝",null,null,"＝",null,null,"＝"]
[null,"合計",null,"Ａ",{"$f":"内訳!H24","v":""},"円","Ｂ",{"$f":"内訳!H47","v":""},"円","Ｃ",{"$f":"内訳!H66","v":""},"円","D",{"$f":"内訳!H89","v":""},"円"]
[null,"※10円未満切り捨て、最高限度額を考慮した金額"]
[null,{"$f":"IF(T68=1,\"※均等割・平等割を7割軽減しています。\",IF(T68=2,\"※均等割・平等割を5割軽減しています。\",IF(T68=2,\"※均等割・平等割を2割軽減しています。\",\"\")))","v":""}]
[null,"最高限度額",null,null,{"$f":"Y20","v":670000},"円",null,{"$f":"Y21","v":260000},"円",null,{"$f":"Y22","v":170000},"円",null,{"$f":"Y23","v":30000},"円"]
[]
[]
[]
[null,"軽減判定",null,{"$f":"加入者情報!D26","v":"加入なし"},null,null,null,"年間保険料の目安（Ａ+Ｂ+Ｃ+D）",null,null,null,{"$f":"内訳!J91","v":0},null,null,"円"]
[]
[null,null,null,null,null,null,null,"1か月あたりの保険料",null,null,null,{"$f":"ROUNDDOWN(L85/12,0)","v":0},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,{"$f":"L85-(N92*9)","v":0},"円"]
[null,null,null,null,null,null,null,null,null,"第２期～第１０期",null,null,null,{"$f":"ROUNDDOWN(L85/10,-2)","v":0},"円"]
[]
["【注意事項】"]
["○入力された加入者情報・所得情報等に基づいて試算していますので、実際の保険料・軽減判定と異なる場合があります。\nまた、入力された内容が実際の所得及び資格状況と異なる場合、結果は異なります。"]

{"sheet":"加入者情報","index":1,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,3,25,5],[4,5,9,5],[13,0,13,1],[10,0,10,1],[19,5,19,8],[20,5,20,8],[21,5,21,8],[0,0,0,3],[21,10,21,11],[20,10,20,11],[19,10,19,11],[21,3,21,4],[20,3,20,4],[19,3,19,4],[3,2,3,3],[9,2,9,3],[8,2,8,3],[7,2,7,3],[6,2,6,3],[5,2,5,3],[4,2,4,3],[11,0,11,1],[12,0,12,1]]}
["加入者情報"]
[]
["○加入状況と賦課基本所得の算出"]
[null,"加入状況","前年の\n総所得金額等",null,"－","基礎控除額","＝","賦課基本所得"]
[{"$f":"入力シート!B49","v":"世帯主"},{"$f":"IF(入力シート!E49=\"加入しない\",\"未加入\",IF(入力シート!E49=\"未就学児\",\"加入(未就学児)\",IF(入力シート!E49=\"小学生以上17歳まで\",\"加入(18歳未満)\",IF(入力シート!E49=\"18歳から39歳まで\",\"加入(介護分無)\",IF(入力シート!E49=\"40歳から64歳まで\",\"加入(介護分有)\",\"加入(介護分無)\")))))","v":"未加入"},{"$f":"IF(入力シート!$E$49=\"加入しない\",\"\",入力シート!$AI$49)","v":""},null,"－",430000,"＝",{"$f":"IF(入力シート!$E$49=\"加入しない\",\"\",入力シート!$AJ$49)","v":""}]
[{"$f":"入力シート!B51","v":"加入者１"},{"$f":"IF(入力シート!E51=\"加入しない\",\"未加入\",IF(入力シート!E51=\"未就学児\",\"加入(未就学児)\",IF(入力シート!E51=\"小学生以上17歳まで\",\"加入(18歳未満)\",IF(入力シート!E51=\"18歳から39歳まで\",\"加入(介護分無)\",IF(入力シート!E51=\"40歳から64歳まで\",\"加入(介護分有)\",\"加入(介護分無)\")))))","v":"未加入"},{"$f":"IF(入力シート!$E$51=\"加入しない\",\"\",入力シート!$AI$51)","v":""},null,"－",null,"＝",{"$f":"IF(入力シート!$E$51=\"加入しない\",\"\",入力シート!$AJ$51)","v":""}]
[{"$f":"入力シート!B53","v":"加入者２"},{"$f":"IF(入力シート!E53=\"加入しない\",\"未加入\",IF(入力シート!E53=\"未就学児\",\"加入(未就学児)\",IF(入力シート!E53=\"小学生以上17歳まで\",\"加入(18歳未満)\",IF(入力シート!E53=\"18歳から39歳まで\",\"加入(介護分無)\",IF(入力シート!E53=\"40歳から64歳まで\",\"加入(介護分有)\",\"加入(介護分無)\")))))","v":"未加入"},{"$f":"IF(入力シート!$E$53=\"加入しない\",\"\",入力シート!$AI$53)","v":""},null,"－",null,"＝",{"$f":"IF(入力シート!$E$53=\"加入しない\",\"\",入力シート!$AJ$53)","v":""}]
[{"$f":"入力シート!B55","v":"加入者３"},{"$f":"IF(入力シート!E55=\"加入しない\",\"未加入\",IF(入力シート!E55=\"未就学児\",\"加入(未就学児)\",IF(入力シート!E55=\"小学生以上17歳まで\",\"加入(18歳未満)\",IF(入力シート!E55=\"18歳から39歳まで\",\"加入(介護分無)\",IF(入力シート!E55=\"40歳から64歳まで\",\"加入(介護分有)\",\"加入(介護分無)\")))))","v":"未加入"},{"$f":"IF(入力シート!$E$55=\"加入しない\",\"\",入力シート!$AI$55)","v":""},null,"－",null,"＝",{"$f":"IF(入力シート!$E$55=\"加入しない\",\"\",入力シート!$AJ$55)","v":""}]
[{"$f":"入力シート!B57","v":"加入者４"},{"$f":"IF(入力シート!E57=\"加入しない\",\"未加入\",IF(入力シート!E57=\"未就学児\",\"加入(未就学児)\",IF(入力シート!E57=\"小学生以上17歳まで\",\"加入(18歳未満)\",IF(入力シート!E57=\"18歳から39歳まで\",\"加入(介護分無)\",IF(入力シート!E57=\"40歳から64歳まで\",\"加入(介護分有)\",\"加入(介護分無)\")))))","v":"未加入"},{"$f":"IF(入力シート!$E$57=\"加入しない\",\"\",入力シート!$AI$57)","v":""},null,"－",null,"＝",{"$f":"IF(入力シート!$E$57=\"加入しない\",\"\",入力シート!$AJ$57)","v":""}]
[{"$f":"入力シート!B59","v":"加入者５"},{"$f":"IF(入力シート!E59=\"加入しない\",\"未加入\",IF(入力シート!E59=\"未就学児\",\"加入(未就学児)\",IF(入力シート!E59=\"小学生以上17歳まで\",\"加入(18歳未満)\",IF(入力シート!E59=\"18歳から39歳まで\",\"加入(介護分無)\",IF(入力シート!E59=\"40歳から64歳まで\",\"加入(介護分有)\",\"加入(介護分無)\")))))","v":"未加入"},{"$f":"IF(入力シート!$E$59=\"加入しない\",\"\",入力シート!$AI$59)","v":""},null,"－",null,"＝",{"$f":"IF(入力シート!$E$59=\"加入しない\",\"\",入力シート!$AJ$59)","v":""}]
["・加入者数",null,null,{"$f":"COUNTIF(B5:B10,\"加入(未就学児)\")+COUNTIF(B5:B10,\"加入(18歳未満)\")+COUNTIF(B5:B10,\"加入(介護分無)\")+COUNTIF(B5:B10,\"加入(介護分有)\")","v":0}]
["・未就学児該当者数",null,null,{"$f":"COUNTIF(B5:B10,\"加入(未就学児)\")","v":0}]
["・18歳未満該当者数",null,null,{"$f":"COUNTIF(B5:B10,\"加入(18歳未満)\")","v":0}]
["・介護分該当者数",null,null,{"$f":"COUNTIF(B5:B10,\"加入(介護分有)\")","v":0}]
["・給与所得者等の数",null,null,{"$f":"入力シート!Z61","v":0},{"$f":"IF((D15-1)>0,D15-1,0)","v":0}]
["※55万円超の給与収入か125万円超(65歳未満の場合は60万円)の年金収入のいずれかがあった方"]
[]
["○保険料の軽減制度"]
[null,"軽減判定所得",null,"※左表の合計額が下記の金額以下の世帯は、均等割と平等割が軽減となります。"]
[{"$f":"入力シート!B49","v":"世帯主"},{"$f":"入力シート!AH49","v":0},null,"7割軽減：",null,{"$f":"入力シート!Y16/10000","v":43},null,null,null,"⇒",{"$f":"(F20+(E15*10))*10000","v":430000}]
[{"$f":"入力シート!B51","v":"加入者１"},{"$f":"IF(入力シート!$E$51=\"加入しない\",\"\",入力シート!$AH$51)","v":""},null,"5割軽減：",null,{"$f":"入力シート!Y17/10000","v":31},null,null,null,"⇒",{"$f":"(F20+(E15*10)+(F21*D11))*10000","v":430000}]
[{"$f":"入力シート!B53","v":"加入者２"},{"$f":"IF(入力シート!$E$53=\"加入しない\",\"\",入力シート!$AH$53)","v":""},null,"2割軽減：",null,{"$f":"入力シート!Y18/10000","v":57},null,null,null,"⇒",{"$f":"(F20+(E15*10)+(F22*D11))*10000","v":430000}]
[{"$f":"入力シート!B55","v":"加入者３"},{"$f":"IF(入力シート!$E$55=\"加入しない\",\"\",入力シート!$AH$55)","v":""}]
[{"$f":"入力シート!B57","v":"加入者４"},{"$f":"IF(入力シート!$E$57=\"加入しない\",\"\",入力シート!$AH$57)","v":""}]
[{"$f":"入力シート!B59","v":"加入者５"},{"$f":"IF(入力シート!$E$59=\"加入しない\",\"\",入力シート!$AH$59)","v":""}]
["合計額",{"$f":"SUM(加入者情報!B20:E25)","v":0},"⇒",{"$f":"IF(D11>0,IF(H26=0.7,\"7割軽減に該当します\",IF(H26=0.5,\"5割軽減に該当します\",IF(H26=0.2,\"2割軽減に該当します\",\"軽減ありません\"))),\"加入なし\")","v":"加入なし"},null,null,null,{"$f":"IF(D11=0,0,(IF(B26<=K20,0.7,IF(B26<=K21,0.5,IF(B26<=K22,0.2,0)))))","v":0}]
[]
["【注意事項】"]
["結果は、入力された加入者情報・所得情報等に基づく試算であり、実際の保険料・軽減判定と異なる場合があります。"]
["入力された内容が実際と異なる場合、結果は異なります。"]

{"sheet":"内訳","index":2,"n_rows":94,"n_cols":13,"rows_kept":94,"cut":false,"hidden":false,"merged":[[0,0,0,7],[33,9,34,10],[41,9,42,10],[10,9,11,10],[18,9,19,10],[20,9,21,9],[20,10,21,10],[14,1,17,1],[37,1,40,1],[3,9,3,10],[4,9,9,9],[6,10,7,10],[4,5,9,5],[9,2,9,3],[8,2,8,3],[12,10,16,10],[23,7,23,9],[29,10,30,10],[22,7,22,9],[12,9,16,9],[26,9,26,10],[27,9,32,9],[3,0,9,0],[18,0,21,0],[90,5,90,7],[90,9,90,10],[50,5,55,5],[50,9,55,9],[52,10,53,10],[64,0,64,6],[64,7,64,9],[65,0,65,6],[65,7,65,9],[50,2,50,3],[55,2,55,3],[54,2,54,3],[60,0,63,0],[62,9,63,9],[58,9,59,9],[62,10,63,10],[58,10,59,10],[62,1,63,1],[56,9,57,10],[60,9,61,10],[56,1,57,1],[58,1,59,1],[60,1,61,1],[75,0,78,0],[56,0,59,0],[45,0,45,6],[23,0,23,6],[33,1,34,1],[35,1,36,1],[32,2,32,3],[31,2,31,3],[30,2,30,3],[29,2,29,3],[28,2,28,3],[27,2,27,3],[41,0,44,0],[41,1,42,1],[43,1,44,1],[33,0,40,0],[26,2,26,3],[26,0,32,0],[27,5,32,5],[45,7,45,9],[35,9,39,9],[35,10,39,10],[43,9,44,9],[43,10,44,10],[49,0,55,0],[46,0,46,6],[46,7,46,9],[49,2,49,3],[49,9,49,10],[53,2,53,3],[52,2,52,3],[51,2,51,3],[10,0,17,0],[22,0,22,6],[10,1,11,1],[12,1,13,1],[18,1,19,1],[20,1,21,1],[3,2,3,3],[7,2,7,3],[6,2,6,3],[5,2,5,3],[4,2,4,3],[75,1,76,1],[77,1,78,1],[68,0,74,0],[68,2,68,3],[68,9,68,10],[69,2,69,3],[69,5,74,5],[69,9,74,9],[70,2,70,3],[71,2,71,3],[71,10,72,10],[72,2,72,3],[73,2,73,3],[74,2,74,3],[75,9,76,9],[75,10,76,10],[79,0,82,0],[79,1,80,1],[81,1,82,1],[77,9,78,9],[87,0,87,6],[87,7,87,9],[88,0,88,6],[88,7,88,9],[83,0,86,0],[83,1,84,1],[83,9,84,10],[85,1,86,1],[85,9,86,9],[85,10,86,10],[77,10,78,10],[79,9,80,10],[81,9,82,9],[81,10,82,10]]}
[{"$f":"CONCATENATE(\"令和\",入力シート!Z14,\"年度（\",入力シート!X14,\"年度）国民健康保険料保険料試算額　計算内訳\")","v":"令和8年度（2026年度）国民健康保険料保険料試算額　計算内訳"}]
[]
["【医　療　分】"]
["所得割",null,"賦課基本所得",null,"×","所得割料率","＝","所得割額",null,"小計"]
[null,{"$f":"入力シート!B49","v":"世帯主"},{"$f":"加入者情報!$H$5","v":""},null,"×",{"$f":"入力シート!$E$35","v":7.0000000000000007E-2},"＝",{"$f":"IF(入力シート!$E$49=\"加入しない\",\"\",C5*$F$5)","v":""},null,{"$f":"IF(加入者情報!D11=0,\"\",SUM(H5:H10))","v":""}]
[null,{"$f":"入力シート!B51","v":"加入者１"},{"$f":"加入者情報!$H$6","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$51=\"加入しない\",\"\",C6*$F$5)","v":""}]
[null,{"$f":"入力シート!B53","v":"加入者２"},{"$f":"加入者情報!$H$7","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$53=\"加入しない\",\"\",C7*$F$5)","v":""},null,null,"…A"]
[null,{"$f":"入力シート!B55","v":"加入者３"},{"$f":"加入者情報!$H$8","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$55=\"加入しない\",\"\",ROUNDDOWN(C8*$F$5,0))","v":""}]
[null,{"$f":"入力シート!B57","v":"加入者４"},{"$f":"加入者情報!$H$9","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$57=\"加入しない\",\"\",C9*$F$5)","v":""}]
[null,{"$f":"入力シート!B59","v":"加入者５"},{"$f":"加入者情報!$H$10","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$59=\"加入しない\",\"\",C10*$F$5)","v":""}]
["均等割","算定額",null,"１人あたり",null,"人数",null,"均等割算定額",null,"小計（b1-b2-b3）"]
[null,null,null,{"$f":"入力シート!E36","v":29310},"×",{"$f":"加入者情報!$D$11","v":0},"＝",{"$f":"IF(加入者情報!D11=0,\"\",D12*F12)","v":""},"…b1",null,null,null,{"$f":"D12*F14","v":0}]
[null,"法定軽減額",null,"均等割算定額",null,"軽減割合",null,"均等割軽減額",null,{"$f":"IF(加入者情報!D11=0,\"\",H12-H14-H18)","v":""},"…B"]
[null,null,null,{"$f":"H12","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D11=0,\"\",D14*F14)","v":""},"…b2"]
[null,"未就学児軽減額",null,"軽減適用済均等割額",null,"軽減割合",null,"一人あたりの軽減額"]
[null,null,null,{"$f":"IF(加入者情報!$D$12=0,\"\",入力シート!E36-(入力シート!E36*加入者情報!$H$26))","v":""},"×",{"$f":"IF(加入者情報!$D$12=0,\"\",0.5)","v":""},"＝",{"$f":"IF(加入者情報!$D$12=0,\"\",ROUNDUP(D16*F16,1))","v":""}]
[null,null,null,"一人あたりの軽減額",null,"未就学児人数",null,"未就学児軽減額"]
[null,null,null,{"$f":"H16","v":""},"×",{"$f":"IF(加入者情報!$D$12=0,\"\",加入者情報!$D$12)","v":""},"＝",{"$f":"IF(加入者情報!$D$12=0,0,D18*F18)","v":0},"…b3"]
["平等割","算定額",null,"１世帯あたり",null,null,null,"平等割算定額",null,"小計（c1-c2）"]
[null,null,null,{"$f":"入力シート!E38","v":18220},null,null,"＝",{"$f":"IF(加入者情報!D11=0,\"\",D20)","v":""},"…c1",null,null,null,{"$f":"D20*F22","v":0}]
[null,"法定軽減額",null,"平等割算定額",null,"軽減割合",null,"平等割軽減額",null,{"$f":"IF(加入者情報!D11=0,\"\",H20-H22)","v":""},"…C"]
[null,null,null,{"$f":"H20","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D11=0,\"\",D22*F22)","v":""},"…c2"]
["医療分合計（A＋B＋C）",null,null,null,null,null,null,{"$f":"IF(加入者情報!D11=0,\"\",SUM(J5,J13,J21))","v":""}]
[{"$f":"CONCATENATE(\"確定保険料　※10円未満切り捨て、最高限度額\",入力シート!Y20/10000,\"万円\")","v":"確定保険料　※10円未満切り捨て、最高限度額67万円"},null,null,null,null,null,null,{"$f":"IF(加入者情報!D11=0,\"\",(IF(H23>入力シート!E81,入力シート!E81,ROUNDDOWN(H23,-1))))","v":""},null,null,"…①"]
[]
["【支援金分】"]
["所得割",null,null,null,"×","所得割料率","＝","所得割額",null,"小計"]
[null,{"$f":"入力シート!B49","v":"世帯主"},{"$f":"加入者情報!$H$5","v":""},null,"×",{"$f":"入力シート!H35","v":0.03},"＝",{"$f":"IF(入力シート!$E$49=\"加入しない\",\"\",ROUNDDOWN(C28*$F$28,0))","v":""},null,{"$f":"IF(加入者情報!D11=0,\"\",SUM(H28:H33))","v":""}]
[null,{"$f":"入力シート!B51","v":"加入者１"},{"$f":"加入者情報!$H$6","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$51=\"加入しない\",\"\",C29*$F$28)","v":""}]
[null,{"$f":"入力シート!B53","v":"加入者２"},{"$f":"加入者情報!$H$7","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$53=\"加入しない\",\"\",C30*$F$28)","v":""},null,null,"…D"]
[null,{"$f":"入力シート!B55","v":"加入者３"},{"$f":"加入者情報!$H$8","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$55=\"加入しない\",\"\",C31*$F$28)","v":""}]
[null,{"$f":"入力シート!B57","v":"加入者４"},{"$f":"加入者情報!$H$9","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$57=\"加入しない\",\"\",C32*$F$28)","v":""}]
[null,{"$f":"入力シート!B59","v":"加入者５"},{"$f":"加入者情報!$H$10","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$59=\"加入しない\",\"\",C33*$F$28)","v":""}]
["均等割","算定額",null,"１人あたり",null,"人数",null,"均等割算定額",null,"小計（e1-e2-e3）"]
[null,null,null,{"$f":"入力シート!H36","v":12560},"×",{"$f":"加入者情報!$D$11","v":0},"＝",{"$f":"IF(加入者情報!D11=0,\"\",D35*F35)","v":""},"…e1",null,null,null,{"$f":"D35*F37","v":0}]
[null,"法定軽減額",null,"均等割算定額",null,"軽減割合",null,"均等割軽減額",null,{"$f":"IF(加入者情報!D11=0,\"\",H35-H37-H41)","v":""},"…E"]
[null,null,null,{"$f":"H35","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D11=0,\"\",D37*F37)","v":""},"…e2"]
[null,"未就学児軽減額",null,"軽減適用済均等割額",null,"軽減割合",null,"一人あたりの軽減額"]
[null,null,null,{"$f":"IF(加入者情報!$D$12=0,\"\",入力シート!H36-(入力シート!H36*加入者情報!$H$26))","v":""},"×",{"$f":"IF(加入者情報!$D$12=0,\"\",0.5)","v":""},"＝",{"$f":"IF(加入者情報!$D$12=0,\"\",ROUNDUP(D39*F39,1))","v":""}]
[null,null,null,"一人あたりの軽減額",null,"未就学児人数",null,"未就学児軽減額"]
[null,null,null,{"$f":"H39","v":""},"×",{"$f":"IF(加入者情報!$D$12=0,\"\",加入者情報!$D$12)","v":""},"＝",{"$f":"IF(加入者情報!$D$12=0,0,D41*F41)","v":0},"…e3"]
["平等割","算定額",null,"１世帯あたり",null,null,null,"平等割算定額",null,"小計（f1-f2）"]
[null,null,null,{"$f":"入力シート!H38","v":7810},null,null,"＝",{"$f":"IF(加入者情報!D11=0,\"\",D43)","v":""},"…f1",null,null,null,{"$f":"D43*F45","v":0}]
[null,"法定軽減額",null,"平等割算定額",null,"軽減割合",null,"平等割軽減額",null,{"$f":"IF(加入者情報!D11=0,\"\",H43-H45)","v":""},"…F"]
[null,null,null,{"$f":"H43","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D11=0,\"\",D45*F45)","v":""},"…f2"]
["支援金分合計（D＋E＋F）",null,null,null,null,null,null,{"$f":"IF(加入者情報!D11=0,\"\",(SUM(J28,J36,J44)))","v":""}]
[{"$f":"CONCATENATE(\"確定保険料　※10円未満切り捨て、最高限度額\",入力シート!Y21/10000,\"万円\")","v":"確定保険料　※10円未満切り捨て、最高限度額26万円"},null,null,null,null,null,null,{"$f":"IF(加入者情報!D11=0,\"\",(IF(H46>入力シート!H81,入力シート!H81,ROUNDDOWN(H46,-1))))","v":""},null,null,"…②"]
[]
["【介　護　分】"]
["所得割",null,null,null,"×","所得割料率","＝","所得割額",null,"小計"]
[null,{"$f":"入力シート!B49","v":"世帯主"},{"$f":"IF(入力シート!$E$49=\"40歳から64歳まで\",加入者情報!$H$5,\"\")","v":""},null,"×",{"$f":"入力シート!K35","v":2.7E-2},"＝",{"$f":"IF(入力シート!$E$49=\"40歳から64歳まで\",ROUNDDOWN(C51*$F$51,0),\"\")","v":""},null,{"$f":"IF(加入者情報!D14=0,\"\",SUM(H51:H56))","v":""}]
[null,{"$f":"入力シート!B51","v":"加入者１"},{"$f":"IF(入力シート!$E$51=\"40歳から64歳まで\",加入者情報!$H$6,\"\")","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$51=\"40歳から64歳まで\",C52*$F$51,\"\")","v":""}]
[null,{"$f":"入力シート!B53","v":"加入者２"},{"$f":"IF(入力シート!$E$53=\"40歳から64歳まで\",加入者情報!$H$7,\"\")","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$53=\"40歳から64歳まで\",C53*$F$51,\"\")","v":""},null,null,"…G"]
[null,{"$f":"入力シート!B55","v":"加入者３"},{"$f":"IF(入力シート!$E$55=\"40歳から64歳まで\",加入者情報!$H$8,\"\")","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$55=\"40歳から64歳まで\",C54*$F$51,\"\")","v":""}]
[null,{"$f":"入力シート!B57","v":"加入者４"},{"$f":"IF(入力シート!$E$57=\"40歳から64歳まで\",加入者情報!$H$9,\"\")","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$57=\"40歳から64歳まで\",C55*$F$51,\"\")","v":""}]
[null,{"$f":"入力シート!B59","v":"加入者５"},{"$f":"IF(入力シート!$E$59=\"40歳から64歳まで\",加入者情報!$H$10,\"\")","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$59=\"40歳から64歳まで\",C56*$F$51,\"\")","v":""}]
["均等割","算定額",null,"１人あたり",null,"人数",null,"均等割算定額",null,"小計（h1-h2）"]
[null,null,null,{"$f":"入力シート!K36","v":12550},"×",{"$f":"加入者情報!$D$14","v":0},"＝",{"$f":"IF(加入者情報!D14=0,\"\",D58*F58)","v":""},"…h1",null,null,null,{"$f":"D58*F60","v":0}]
[null,"法定軽減額",null,"均等割算定額",null,"軽減割合",null,"均等割軽減額",null,{"$f":"IF(加入者情報!D14=0,\"\",H58-H60)","v":""},"…H"]
[null,null,null,{"$f":"H58","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D14=0,\"\",D60*F60)","v":""},"…h2"]
["平等割","算定額",null,"１世帯あたり",null,null,null,"平等割算定額",null,"小計（i1-i2）"]
[null,null,null,{"$f":"入力シート!K38","v":6340},null,null,"＝",{"$f":"IF(加入者情報!D14=0,\"\",D62)","v":""},"…i1",null,null,null,{"$f":"D62*F64","v":0}]
[null,"法定軽減額",null,"平等割算定額",null,"軽減割合",null,"平等割軽減額",null,{"$f":"IF(加入者情報!D14=0,\"\",H62-H64)","v":""},"…I"]
[null,null,null,{"$f":"H62","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D14=0,\"\",D64*F64)","v":""},"…i2"]
["介護分合計（G＋H＋I）",null,null,null,null,null,null,{"$f":"IF(加入者情報!D14=0,\"\",SUM(J51,J59,J63))","v":""}]
[{"$f":"CONCATENATE(\"確定保険料　※10円未満切り捨て、最高限度額\",入力シート!Y22/10000,\"万円\")","v":"確定保険料　※10円未満切り捨て、最高限度額17万円"},null,null,null,null,null,null,{"$f":"IF(加入者情報!D14=0,\"\",IF(H65>入力シート!K81,入力シート!K81,ROUNDDOWN(H65,-1)))","v":""},null,null,"…③"]
[]
["【子ども子育て支援金分】"]
["所得割",null,null,null,"×","所得割料率","＝","所得割額",null,"小計"]
[null,{"$f":"入力シート!B49","v":"世帯主"},{"$f":"加入者情報!$H$5","v":""},null,"×",{"$f":"入力シート!N35","v":0},"＝",{"$f":"IF(入力シート!$E$49=\"加入しない\",\"\",ROUNDDOWN(C70*$F$70,0))","v":""},null,{"$f":"IF(加入者情報!D11=0,\"\",SUM(H70:H75))","v":""}]
[null,{"$f":"入力シート!B51","v":"加入者１"},{"$f":"加入者情報!$H$6","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$51=\"加入しない\",\"\",C71*$F$70)","v":""}]
[null,{"$f":"入力シート!B53","v":"加入者２"},{"$f":"加入者情報!$H$7","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$53=\"加入しない\",\"\",C72*$F$70)","v":""},null,null,"…J"]
[null,{"$f":"入力シート!B55","v":"加入者３"},{"$f":"加入者情報!$H$8","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$55=\"加入しない\",\"\",C73*$F$70)","v":""}]
[null,{"$f":"入力シート!B57","v":"加入者４"},{"$f":"加入者情報!$H$9","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$57=\"加入しない\",\"\",C74*$F$70)","v":""}]
[null,{"$f":"入力シート!B59","v":"加入者５"},{"$f":"加入者情報!$H$10","v":""},null,"×",null,"＝",{"$f":"IF(入力シート!$E$59=\"加入しない\",\"\",C75*$F$70)","v":""}]
[null,"算定額",null,"１人あたり",null,"人数※",null,"算定額",null,{"$f":"IF(加入者情報!D11-加入者情報!D12-加入者情報!D13=0,\"\",H77)","v":""}]
[null,null,null,{"$f":"入力シート!N36","v":2400},"×",{"$f":"加入者情報!$D$11-加入者情報!$D$12-加入者情報!$D$13","v":0},"＝",{"$f":"IF(加入者情報!D11-加入者情報!D12-加入者情報!D13=0,\"\",D77*F77)","v":""},null,null,null,null,{"$f":"D77*F79","v":0}]
[null,"法定軽減額",null,"均等割算定額",null,"軽減割合",null,"均等割軽減額",null,{"$f":"IF(加入者情報!D11-加入者情報!D12-加入者情報!D13=0,\"\",H77-H79)","v":""},"…K"]
[null,null,null,{"$f":"H77","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D11-加入者情報!D12-加入者情報!D13=0,\"\",D79*F79)","v":""},"…k2"]
["18歳以上\n均等割","算定額",null,"１人あたり",null,"人数",null,"均等割算定額",null,"小計（l1-l2）"]
[null,null,null,{"$f":"入力シート!N37","v":0},"×",{"$f":"加入者情報!$D$11-加入者情報!$D$12-加入者情報!$D$13","v":0},"＝",{"$f":"IF(加入者情報!D11-加入者情報!D12-加入者情報!D13=0,\"\",D81*F81)","v":""},"…l1"]
[null,"法定軽減額",null,"均等割算定額",null,"軽減割合",null,"均等割軽減額",null,{"$f":"IF(加入者情報!D11-加入者情報!D12-加入者情報!D13=0,\"\",H81-H83)","v":""},"…L"]
[null,null,null,{"$f":"H81","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D11-加入者情報!D12-加入者情報!D13=0,\"\",D83*F83)","v":""},"…l2"]
["平等割","算定額",null,"１世帯あたり",null,null,null,"平等割算定額",null,"小計（m1-m2）"]
[null,null,null,{"$f":"入力シート!N38","v":0},null,null,"＝",{"$f":"IF(加入者情報!D11=0,\"\",D85)","v":""},"…m1",null,null,null,{"$f":"D85*F87","v":0}]
[null,"法定軽減額",null,"平等割算定額",null,"軽減割合",null,"平等割軽減額",null,{"$f":"IF(加入者情報!D11=0,\"\",H85-H87)","v":""},"…M"]
[null,null,null,{"$f":"H85","v":""},"×",{"$f":"加入者情報!$H$26","v":0},null,{"$f":"IF(加入者情報!D11=0,\"\",D87*F87)","v":""},"…m2"]
["子ども子育て支援金分合計",null,null,null,null,null,null,{"$f":"IF(加入者情報!D11=0,\"\",(SUM(J76)))","v":""}]
[{"$f":"CONCATENATE(\"確定保険料　※10円未満切り捨て、最高限度額\",入力シート!Y23/10000,\"万円\")","v":"確定保険料　※10円未満切り捨て、最高限度額3万円"},null,null,null,null,null,null,{"$f":"IF(加入者情報!D11=0,\"\",(IF(H88>入力シート!N81,入力シート!N81,ROUNDDOWN(H88,-1))))","v":""},null,null,"…④"]
["※18歳未満の加入者の人数は含めていません。"]
[null,null,null,null,null,"年間保険料（①＋②＋③+④）",null,null,null,{"$f":"SUM(H24,H47,H66,H89)","v":0}]
["【注意事項】"]
["○入力された加入者情報・所得情報等に基づいて試算していますので、実際の保険料・軽減判定と異なる場合があります。"]
["○入力された内容が実際と異なる場合、結果は異なります。"]

{"sheet":"各期納付額","index":3,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,27,9],[3,1,3,2],[3,3,3,5],[3,6,3,8],[4,1,4,2],[4,3,4,5],[5,1,5,2],[5,3,5,5],[6,1,6,2],[6,3,6,5],[7,1,7,2],[7,3,7,5],[8,1,8,2],[8,3,8,5],[9,1,9,2],[9,3,9,5],[10,1,10,2],[10,3,10,5],[11,1,11,2],[11,3,11,5],[12,1,12,2],[12,3,12,5],[13,1,13,2],[13,3,13,5],[14,1,14,2],[14,3,14,5],[15,1,15,5]]}
["各期ごとの保険料"]
[]
[]
[null,"納期",null,"納期限",null,null,"金額（目安）"]
[null,"第1期",null,{"$f":"入力シート!Y24","v":"2026-06-30"},null,null,null,{"$f":"入力シート!N91","v":0},"円"]
[null,"第2期",null,{"$f":"入力シート!Y25","v":"2026-07-31"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"第3期",null,{"$f":"入力シート!Y26","v":"2026-08-31"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"第4期",null,{"$f":"入力シート!Y27","v":"2026-09-30"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"第5期",null,{"$f":"入力シート!Y28","v":"2026-11-02"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"第6期",null,{"$f":"入力シート!Y29","v":"2026-11-30"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"第7期",null,{"$f":"入力シート!Y30","v":"2026-12-25"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"第8期",null,{"$f":"入力シート!Y31","v":"2027-02-01"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"第9期",null,{"$f":"入力シート!Y32","v":"2027-03-01"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"第10期",null,{"$f":"入力シート!Y33","v":"2027-03-31"},null,null,null,{"$f":"入力シート!N92","v":0},"円"]
[null,"随時",null,null,null,null,null,null,"円"]
[null,"合計",null,null,null,null,null,{"$f":"入力シート!L85","v":0},"円"]
[]
["ご注意"]
["〇入力された加入者情報・所得情報等に基づいて試算していますので、実際の保険料・軽減判定と異なる場合があります。\nまた、入力された内容が実際の所得及び資格状況と異なる場合、結果は異なります。\n〇本シートによる各期の保険料は、当初に提示した金額を10回分割したものであり、年度途中に加入・脱退、減免申請等により金額が変わる場合はこのとおりにはなりません。\n"]

{"sheet":"給与所得算出","index":4,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,8,3,9],[3,6,3,7],[3,2,3,3],[3,0,3,1],[12,0,12,1],[5,0,5,6],[5,8,5,12],[9,0,9,1]]}
[]
["給与所得算出表（令和7年1月1日から12月31日までの給与）"]
[]
["給与収入額：",null,null,null,"円","→","給与所得額：",null,{"$f":"SUM(N7:N16)","v":0},null,"円"]
[]
["給与収入金額",null,null,null,null,null,null,null,"給与所得金額"]
[651000,"円未満",null,null,null,null,null,null,null,null,null,0,"円",{"$f":"IF(C4<A7,L7,0)","v":0}]
[651000,"円以上","～",1900000,"円未満",null,null,null,null,"給与収入額","－",650000,"円",{"$f":"IF(C4>=A8,IF(C4<D8,C4-L8,0),0)","v":0}]
[1900000,"円以上","端数処理",null,null,null,{"$f":"IF(C4>=A9,IF(C4<A14,ROUNDDOWN(C4/4000,0)*4000,0),0)","v":0}]
["～",null,"給与収入額  ÷  4,000円 ＝ a",null,null,null,null,null,"A　×",0.7,"－",80000,"円",{"$f":"IF(C4>=A9,IF(C4<A11,G9*J10-L10,0),0)","v":0}]
[3600000,"円未満","aの小数点以下を切り捨て、a'を求める"]
[3600000,"円以上","a' × 4,000円 = A（端数処理後の給与収入金額）"]
["～",null,null,null,null,null,null,null,"A　×",0.8,"－",440000,"円",{"$f":"IF(C4>=A12,IF(C4<A14,G9*J13-L13,0),0)","v":0}]
[6600000,"円未満"]
[6600000,"円以上","～",8500000,"円未満",null,null,null,"給与収入額  ×",0.9,"－",1100000,"円",{"$f":"IF(C4>=A15,IF(C4<D15,ROUNDDOWN(C4*J15,0)-L15,0),0)","v":0}]
[8500000,"円以上",null,null,null,null,null,null,null,"給与収入額","－",1950000,"円",{"$f":"IF(C4>=A16,C4-L16,0)-D21","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C28=1,\"控除適用\",\"控除非該当\")","v":"控除非該当"}]
[null,null,null,{"$f":"IF(C4>8500000,(IF(C4>10000000,10000000,C4)-8500000),0)","v":0}]
[null,null,1,{"$f":"IF(C28=1,ROUNDUP(D20*0.1,0),0)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,0]

{"sheet":"年金所得算出","index":5,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[8,1,8,5],[8,6,8,11],[6,5,6,6],[3,5,3,8]]}
[]
["年金所得算出表（令和7年1月1日から12月31日までの年金）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,000万円以下の場合"]
[null,"公的年金等雑所得以外の所得に係る合計所得金額",null,null,null,"1,000万円以下の場合",null,null,null,null,{"$f":"IF(F4=O3,0,IF(F4=O4,1,IF(F4=O5,2,\"NG\")))","v":0},null,null,null,"1,000万円超2,000万円以下の場合"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2,000万円超の場合"]
["生年月日：",null,null,null,null,null,null,null,null,"65歳未満：",{"$f":"IF(B6>=A11,B7,0)","v":0}]
["年金収入額：",null,"円","→","年金所得：",{"$f":"SUM(M10:M19)","v":0},null,"円",null,"65歳以上：",{"$f":"IF(B6<=A16,B7,0)","v":0}]
[]
["受給者の年齢","公的年金等の収入金額の合計額",null,null,null,null,"年金所得金額"]
["65歳未満",1300000,"円未満",null,null,null,null,null,"合計額","－",{"$f":"600000-(100000*K4)","v":600000},"円",{"$f":"IF(K6=0,0,IF(K6<B10,IF((K6-K10)>0,(K6-K10),0),0))","v":0}]
[{"$f":"入力シート!Y34+1","v":"1961-01-02"},1300000,"円以上","～",4100000,"円未満","合計額","×",0.75,"－",{"$f":"275000-(100000*K4)","v":275000},"円",{"$f":"IF(K6=0,0,IF(K6>=B11,IF(K6<E11,ROUNDDOWN(K6*I11,0)-K11,0),0))","v":0}]
["以後に生まれた人",4100000,"円以上","～",7700000,"円未満","合計額","×",0.85,"－",{"$f":"685000-(100000*K4)","v":685000},"円",{"$f":"IF(K6=0,0,IF(K6>=B12,IF(K6<E12,ROUNDDOWN(K6*I12,0)-K12,0),0))","v":0}]
[null,7700000,"円以上","～",10000000,"円未満","合計額","×",0.95,"－",{"$f":"1455000-(100000*K4)","v":1455000},"円",{"$f":"IF(K6=0,0,IF(K6>=B13,IF(K6<E13,ROUNDDOWN(K6*I13,0)-K13,0),0))","v":0}]
[null,10000000,"円以上",null,null,null,"合計額",null,null,"－",{"$f":"1955000-(100000*K4)","v":1955000},"円",{"$f":"IF(K6=0,0,IF(K6>=B14,K6-K14,0))","v":0}]
["65歳以上",3300000,"円未満",null,null,null,null,null,"合計額","－",{"$f":"1100000-(100000*K4)","v":1100000},"円",{"$f":"IF(K7=0,0,IF(K7<B15,IF((K7-K15)>0,(K7-K15),0),0))","v":0}]
[{"$f":"入力シート!Y34","v":"1961-01-01"},3300000,"円以上","～",4100000,"円未満","合計額","×",0.75,"－",{"$f":"275000-(100000*K4)","v":275000},"円",{"$f":"IF(K7=0,0,IF(K7>=B16,IF(K7<E16,ROUNDDOWN(K7*I16,0)-K16,0),0))","v":0}]
["以前に生まれた人",4100000,"円以上","～",7700000,"円未満","合計額","×",0.85,"－",{"$f":"685000-(100000*K4)","v":685000},"円",{"$f":"IF(K7=0,0,IF(K7>=B17,IF(K7<E17,ROUNDDOWN(K7*I17,0)-K17,0),0))","v":0}]
[null,7700000,"円以上","～",10000000,"円未満","合計額","×",0.95,"－",{"$f":"1455000-(100000*K4)","v":1455000},"円",{"$f":"IF(K7=0,0,IF(K7>=B18,IF(K7<E18,ROUNDDOWN(K7*I18,0)-K18,0),0))","v":0}]
[null,10000000,"円以上",null,null,null,"合計額",null,null,"－",{"$f":"1955000-(100000*K4)","v":1955000},"円",{"$f":"IF(K7=0,0,IF(K7>=B19,B7-K19,0))","v":0}]