{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["設定シート","保険料計算の方法","月額保険料計算シート","加入者別年間保険料","試算結果【提供用】"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":23,"comments":4,"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":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":true,"merged":[[7,2,7,3],[8,2,8,3],[0,1,1,8],[12,2,12,3],[13,2,13,3],[2,1,2,3],[3,1,8,1],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[17,1,19,1],[19,2,19,3],[14,1,14,3],[12,1,13,1],[9,1,11,1],[9,2,9,3],[10,2,10,3],[11,2,11,3],[14,7,14,12],[21,2,21,3],[22,2,22,3],[21,5,22,10],[16,2,16,3],[17,2,17,3],[18,2,18,3],[16,4,16,5],[17,7,17,12]]}
[null,"年度変更に伴い、このファイルを継続的に使用するためには、下記の項目を設定してください。\nこのシートで設定した数値等が、保険料計算のシート等に反映します。淡黄色と淡緑色のセルのみ更新・変更可能です。"]
[]
[null,"　保険料計算年度　（「年度」は不要です）",null,null,8]
[null,"保険料","医療均等割額（年額）",null,47600]
[null,null,"支援均等割額（年額）",null,17600]
[null,null,"介護均等割額（年額）",null,17800]
[null,null,"医療所得割率（年率）",null,7.51]
[null,null,"支援所得割率（年率）",null,2.8]
[null,null,"介護所得割率（年率）",null,2.4300000000000002]
[null,"限度額","医療（年額）",null,670000,"←国保情報2025/12/1よりR8年度の限度額は、社会保障審議会医療保険部会で了承"]
[null,null,"支援（年額）",null,260000]
[null,null,"介護（年額）",null,170000]
[null,"軽減判定加算額","５割減額（政減２号）",null,310000]
[null,null,"２割減額（政減３号）",null,570000]
[null,"均等割減額対象年齢 (未就学児)",null,null,6,"軽減割合",0.5,"←この年齢と軽減率を変更することで均等割額が軽減される対象年齢と率が変更になっても対応できます。　30パーセント減なら「0.3」"]
[]
[null,"Ｒ８より追加項目","子育て支援分",null,"均等割軽減対象　→",null,18,"歳以下"]
[null,"保険料","均等割額（年額）",null,1873,"軽減割合",1,"←　　　軽減割合がなく、軽減そのものがない場合は「0」を入力\n　　　　　30パーセント減なら「0.3」　均等割全額軽減なら「1」を入力"]
[null,null,"所得割額（年率）",null,0.27,null,"設定シートで入力した年齢以下の場合は、均等割を軽減する計算式を設定。"]
[null,null,"限度額（年額）",null,30000]
[]
[null,"介護保険対象者","下限年齢",null,40,"←この年齢を変更することで介護保険対象者の年齢に変更があった場合にも対応できますが、年金所得の計算式と年金所得特別控除の計算式中には、「40」と「65」の年齢判定による計算式のままとしています。"]
[null,null,"対象外年齢",null,65]

{"sheet":"保険料計算の方法","index":1,"n_rows":88,"n_cols":4,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,3,1,9],[0,1,1,2],[34,0,35,13],[41,0,42,13],[47,0,48,13],[68,1,69,13],[70,1,71,13],[78,1,79,13],[81,1,82,13],[56,0,57,13],[60,0,61,13]]}
["令和7年分",{"$f":"TRIM(\"令和\"&設定シート!E3&\"年\")","v":"令和8年"},null,"度  品川区国民健康保険料計算の方法"]
[]
[]
[]
["①【月額保険料計算シート】のタブをクリックして下記のシートを表示させるか、【保険料試算】をクリックします。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"TRIM(\"★★　　入力する収入および所得は、令和\"&設定シート!E3-1&\"年1月1日から令和\"&設定シート!E3-1&\"年12月31日までのものとなります。　　★★\")","v":"★★　入力する収入および所得は、令和7年1月1日から令和7年12月31日までのものとなります。　★★"}]
[]
["②一人目の加入者（加入者Ａ）の年齢に応じて【加入者Ａ介護あり】または【加入者Ａ介護なし】のいずれかをクリックします。"]
[]
[]
["③加入者Ａの年齢を入力します。【年齢入力の注意点】をクリックすると注意点が表示されます。"]
["（年金収入がある場合は、",null,null,{"$f":"TRIM(\"令和\"&設定シート!E3&\"年１月１日現在の年齢を入力してください。\")","v":"令和8年１月１日現在の年齢を入力してください。"}]
[{"$f":"TRIM(\"令和\"&設定シート!E3+1&\"年4月1日時点で未就学児等で均等割軽減対象の場合は\"&設定シート!E15&\"以下の数値を入力してください。\")","v":"令和9年4月1日時点で未就学児等で均等割軽減対象の場合は6以下の数値を入力してください。"}]
[]
["④収入種別ごとに収入額を入力してください。ただし、営業所得・不動産所得・業務所得・雑所得の場合は収入ではなく「所得」を入力してください。"]
[]
[" 営業・不動産・業務・雑所得の入力欄には年金所得を除く所得額の合計を入力してください。"]
[]
[{"$f":"TRIM(\"※　計算対象となる収入は令和\"&設定シート!E3-1&\"年１月１日から令和\"&設定シート!E3-1&\"年12月31日までの収入となります。\")","v":"※　計算対象となる収入は令和7年１月１日から令和7年12月31日までの収入となります。"}]
[]
["⑤二人目以降の加入者がいる場合は、同様に加入者Ｂ・加入者C・加入者Ｄ・加入者Ｅの各項目に年齢や収入額等を入力してください。"]
[]
[]
["⑥入力内容を確認後、【計算結果表示】をクリックします。"]
[]
["⑦【世帯員別 年間保険料】をクリックすると加入者ごとの１年間（12ヶ月）分の保険料が表示されます。"]
[]
["※　入力内容に誤りがある場合は、【入力データクリア】をクリックしてください。"]
[]
["※　分離課税による所得がある方は、各分離所得から繰越控除額を控除した金額を④の営業・不動産・業務・雑所得の欄に加算して入力してください。"]
[]
["（ただし、雑損失の繰越控除は控除の対象となりません）"]
[]
["※分離長期・分離短期譲渡所得については、特別控除後の金額を入力することで保険料の計算が可能ですが、所得金額によっては均等割額が正しく計算されない場合があります。"]
["計算されない場合があります。"]
[]
[]
[null,"注意事項"]
[]
[null,"計算結果は概算ですので端数の違いが生じる場合があります。"]
[]
[null,"非自発的失業で保険料の軽減措置が該当する場合は、「非自発失業該当」の「該当」を選択して入力する必要があります。"]
[]
[null,"国保に加入していない世帯主（社会保険加入者・後期高齢者）がいる場合は必ず淡黄色の部分に所得額等を入力してください。"]
[]
[null,"専従者給与または専従者控除がある世帯では正しく計算できません。"]
[]
[null,"加入者が６名以上いる場合は、このエクセルでは計算できません。"]
[]
[null,"加入者が旧被扶養者の場合は、正しく計算できません。"]
[]
[null,"年度内に40歳になって介護保険料が発生する場合と、65歳に達して介護保険料が国保料とは別に徴収される場合は年間保険料は計算結果とは一致しません。"]
[null,"一致しません。"]
[]
[null,"1月１日現在、64歳で加入後に65歳に達した場合は、国民健康保険料として介護保険料は対象外となりますが、含まれた金額が表示されます。"]
[]
[null,"未就学児に収入所得がある場合は、保険料が正しく計算できない場合があります。"]
[]
[null,"年度内に75歳に達して後期高齢者医療制度に移行される方の年間保険料は一致しません。"]
[]
[null,"給与所得調整控除がある方は、⑧のセルをクリックして「有」を選択してください。"]

{"sheet":"月額保険料計算シート","index":2,"n_rows":82,"n_cols":31,"rows_kept":82,"cut":false,"hidden":false,"merged":[[75,0,76,15],[77,4,78,14],[79,0,80,4],[81,0,83,5],[12,27,13,29],[12,30,13,32],[33,13,33,14],[12,13,13,13],[14,17,15,17],[30,13,30,14],[14,21,15,21],[14,18,15,18],[12,18,13,18],[14,14,15,14],[14,15,15,15],[14,16,15,16],[12,14,13,14],[12,15,13,15],[12,16,13,16],[12,17,13,17],[14,9,15,9],[24,2,25,4],[34,13,34,14],[39,1,39,2],[10,0,11,0],[10,1,11,1],[10,2,11,2],[14,3,15,3],[14,4,15,4],[10,5,11,5],[10,6,11,6],[32,13,32,14],[27,13,27,15],[28,13,28,14],[14,5,15,5],[14,7,15,7],[14,8,15,8],[14,10,15,10],[14,11,15,11],[14,12,15,12],[17,1,17,18],[22,0,22,7],[21,0,21,6],[26,2,26,4],[30,2,30,4],[25,13,25,14],[23,13,23,14],[14,6,15,6],[8,2,9,2],[8,5,9,5],[8,6,9,6],[8,7,9,7],[6,8,7,8],[6,10,7,10],[6,11,7,11],[8,8,9,8],[10,7,11,7],[10,8,11,8],[10,10,11,10],[10,11,11,11],[10,9,11,9],[14,1,15,1],[14,2,15,2],[14,0,15,0],[28,2,29,4],[12,7,13,7],[12,9,13,9],[14,13,15,13],[12,1,13,1],[20,0,20,5],[12,5,13,5],[12,0,13,0],[12,2,13,2],[12,6,13,6],[12,8,13,8],[23,7,23,11],[19,11,20,11],[24,13,24,14],[19,0,19,5],[12,11,13,11],[12,10,13,10],[18,0,18,6],[20,9,20,10],[21,9,21,10],[65,6,65,14],[35,13,35,14],[36,13,36,14],[56,8,56,11],[57,8,57,11],[58,8,58,11],[52,9,52,11],[26,13,26,14],[42,2,42,4],[36,2,37,4],[38,2,38,4],[32,2,33,4],[40,2,41,4],[31,13,31,14],[34,2,34,4],[29,13,29,14],[0,0,1,1],[0,9,1,9],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,4,3,4],[2,5,3,5],[2,13,3,13],[2,3,3,3],[0,5,1,8],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,9,3,9],[6,22,7,22],[4,30,5,32],[6,30,7,32],[2,17,3,17],[2,18,3,18],[2,14,3,14],[2,15,3,15],[2,16,3,16],[6,18,7,18],[4,18,5,18],[2,22,3,22],[4,15,5,15],[4,16,5,16],[4,14,5,14],[6,14,7,14],[2,21,3,21],[4,21,5,21],[6,21,7,21],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,7,5,7],[4,9,5,9],[6,9,7,9],[8,9,9,9],[8,14,9,14],[4,12,5,12],[4,13,5,13],[6,1,7,1],[6,2,7,2],[6,5,7,5],[6,6,7,6],[6,7,7,7],[4,8,5,8],[4,10,5,10],[6,0,7,0],[6,13,7,13],[4,11,5,11],[4,5,5,5],[4,6,5,6],[6,12,7,12],[8,1,9,1],[8,0,9,0],[10,30,11,32],[4,17,5,17],[4,27,5,29],[6,27,7,29],[8,27,9,29],[10,27,11,29],[8,17,9,17],[8,18,9,18],[10,17,11,17],[10,18,11,18],[10,15,11,15],[10,12,11,12],[10,13,11,13],[10,14,11,14],[6,15,7,15],[6,16,7,16],[6,17,7,17],[4,22,5,22],[8,30,9,32],[8,15,9,15],[8,16,9,16],[8,10,9,10],[8,11,9,11],[8,22,9,22],[10,22,11,22],[12,22,13,22],[14,22,15,22],[10,21,11,21],[12,21,13,21],[10,16,11,16],[8,13,9,13],[8,12,9,12],[8,21,9,21],[12,12,13,12]]}
[{"$f":"TRIM(保険料計算の方法!B1&\"度\")","v":"令和8年度"},null,null,{"$f":"設定シート!E3","v":8},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"設定シート!E3-1","v":7}]
[null,null,null,{"$f":"IF(RIGHT(LEFT(設定シート!E3,3),1)=\"1\",TRIM(\"令和\"&LEFT(RIGHT(設定シート!E3,3),2)+1&\"年\"),TRIM(\"令和\"&LEFT(RIGHT(設定シート!E3,2),1)+1&\"年\"))","v":"令和9年"},{"$f":"TRIM(\"令和\"&LEFT(RIGHT(設定シート!E3,2),1)-1&\"年\")","v":"令和7年"}]
[null,"年齢","２号\n該当","資格\n 区分",null,"給与収入","給与所得","非自発的\n失業該当","計算対象所得\n（非自発⇒30％）","給与所得\n調整控除","年金収入","年金所得","年金特別控除\n６５歳以上","営業・不動産\n業務・雑所得\n配当・譲渡所得","基礎控除","賦課基準額","R03以降\n政減判定","給与年金\n所得額調整控除","介護計算用\n賦課基準額",null,null,"チェック","チェック2"]
[]
["加入者A",null,{"$f":"IF((B5>=設定シート!$E$22)*AND(B5<設定シート!$E$23),\"○\",\"\")","v":""},null,{"$f":"COUNTIF(D5:D5,\"1\")","v":0},null,{"$f":"IF(設定シート!$E$3>=8,IF(AND(J5=\"有\",F5>10000000),F5-1950000-150000,IF(AND(J5=\"有\",F5>8500000,F5<=10000000),ROUNDDOWN((F5-1950000)-((F5-8500000)*0.1),),IF(F5<=650000,0,IF(F5<=1900000,F5-650000,IF(F5<=3599999,ROUNDDOWN(F5/4,-3)*2.8-80000,IF(F5<=6599999,ROUNDDOWN(F5/4,-3)*3.2-440000,IF(F5<=8499999,F5*0.9-1100000,IF(F5>=8500000,F5-1950000)))))))),IF(AND(J5=\"有\",F5>10000000),F5-1950000-150000,IF(AND(J5=\"有\",F5>8500000,F5<=10000000),ROUNDDOWN((F5-1950000)-((F5-8500000)*0.1),),IF(F5<=550000,0,IF(F5<1619000,F5-550000,IF(F5<=1619999,1069000,IF(F5<=1621999,1070000,IF(F5<=1623999,1072000,IF(F5<=1627999,1074000,IF(F5<=1799999,ROUNDDOWN(F5/4,-3)*2.4+100000,IF(F5<=3599999,ROUNDDOWN(F5/4,-3)*2.8-80000,IF(F5<=6599999,ROUNDDOWN(F5/4,-3)*3.2-440000,IF(F5<=8499999,F5*0.9-1100000,IF(F5>=8500000,F5-1950000))))))))))))))","v":0},null,{"$f":"IF(AND(H5=\"該当\",J5=\"有\",F5>8500000),ROUNDDOWN((G5+I23)*3/10,0)-I23,IF(H5=\"該当\",ROUNDDOWN(G5*3/10,0),G5))","v":0},null,null,{"$f":"IF(G5+N5>20000000,IF(K5>10000000,K5-(1955000-200000),IF(K5>7700000,K5*0.95-(1455000-200000),IF(K5>4100000,K5*0.85-(685000-200000),IF(B5>=65,IF(K5<=(1100000-200000),0,IF(K5<=3300000,K5-(1100000-200000),IF(K5<=4100000,K5*0.75-(275000-200000)))),IF(K5<=(600000-200000),0,IF(K5<=1300000,K5-(600000-200000),IF(K5<=4100000,K5*0.75-(275000-200000)))))))),IF(G5+N5>10000000,IF(K5>10000000,K5-(1955000-100000),IF(K5>7700000,K5*0.95-(1455000-100000),IF(K5>4100000,K5*0.85-(685000-100000),IF(B5>=65,IF(K5<=(1100000-100000),0,IF(K5<=3300000,K5-(1100000-100000),IF(K5<=4100000,K5*0.75-(275000-100000)))),IF(K5<=(600000-100000),0,IF(K5<=1300000,K5-(600000-100000),IF(K5<=4100000,K5*0.75-(275000-100000)))))))),IF(K5>10000000,K5-1955000,IF(K5>7700000,K5*0.95-1455000,IF(K5>4100000,K5*0.85-685000,IF(B5>=65,IF(K5<=1100000,0,IF(K5<=3300000,K5-1100000,IF(K5<=4100000,K5*0.75-275000))),IF(K5<=600000,0,IF(K5<=1300000,K5-600000,IF(K5<=4100000,K5*0.75-275000)))))))))","v":0},{"$f":"IF(B5>=65,IF(L5>=150000,150000,L5),0)","v":0},null,{"$f":"IF(ISBLANK(B5),0,IF(G5+L5+N5<=24000000,430000,IF(G5+L5+N5<=24500000,290000,IF(G5+L5+N5<=25000000,150000,IF(G5+L5+N5>25000000,0)))))","v":0},{"$f":"IF(I5+L5+N5-O5-R5<=0,0,I5+L5+N5-O5-R5)","v":0},{"$f":"IF(OR(G5>0,L5>0),\"○\",\"\")","v":""},{"$f":"IF(G5+L5>100000,IF(AND(G5>0,L5>0),IF(AND(G5>=100000,L5>=100000),100000,MIN((G5+L5-100000),G5,L5)),0),)","v":0},{"$f":"IF(B74=65,0,IF(COUNT(D6:D6)=0,0,P5))","v":0},null,null,{"$f":"IF(OR(AND(ISBLANK(B5),E5=1),AND(E5=0,B5<>\"\")),\"×\",\"\")","v":""},{"$f":"IF(OR(AND(B5<設定シート!$E$22,E6=1),AND(B5>=設定シート!$E$23,E6=1),AND(B5>=設定シート!$E$22,B5<設定シート!$E$23,E6<>1)),\"×\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(AND(F5<>\"\",B5=\"\"),(AND(K5<>\"\",B5=\"\")),(AND(N5<>\"\",B5=\"\"))),\"加入者Aの年齢を入力してください\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(ISBLANK(B5),E5=1),(AND(ISNUMBER(B5),E5=0))),\"加入者Aの資格設定ボタンをクリックして資格を設定してください\",\"\")","v":""}]
[null,null,null,null,{"$f":"COUNTIF(D6:D6,\"4\")","v":0}]
["加入者B",null,{"$f":"IF((B7>=設定シート!$E$22)*AND(B7<設定シート!$E$23),\"○\",\"\")","v":""},null,{"$f":"COUNTIF(D7:D7,\"1\")","v":0},null,{"$f":"IF(設定シート!$E$3>=8,IF(AND(J7=\"有\",F7>10000000),F7-1950000-150000,IF(AND(J7=\"有\",F7>8500000,F7<=10000000),ROUNDDOWN((F7-1950000)-((F7-8500000)*0.1),),IF(F7<=650000,0,IF(F7<=1900000,F7-650000,IF(F7<=3599999,ROUNDDOWN(F7/4,-3)*2.8-80000,IF(F7<=6599999,ROUNDDOWN(F7/4,-3)*3.2-440000,IF(F7<=8499999,F7*0.9-1100000,IF(F7>=8500000,F7-1950000)))))))),IF(AND(J7=\"有\",F7>10000000),F7-1950000-150000,IF(AND(J7=\"有\",F7>8500000,F7<=10000000),ROUNDDOWN((F7-1950000)-((F7-8500000)*0.1),),IF(F7<=550000,0,IF(F7<1619000,F7-550000,IF(F7<=1619999,1069000,IF(F7<=1621999,1070000,IF(F7<=1623999,1072000,IF(F7<=1627999,1074000,IF(F7<=1799999,ROUNDDOWN(F7/4,-3)*2.4+100000,IF(F7<=3599999,ROUNDDOWN(F7/4,-3)*2.8-80000,IF(F7<=6599999,ROUNDDOWN(F7/4,-3)*3.2-440000,IF(F7<=8499999,F7*0.9-1100000,IF(F7>=8500000,F7-1950000))))))))))))))","v":0},null,{"$f":"IF(AND(H7=\"該当\",J7=\"有\",F7>8500000),ROUNDDOWN((G7+J23)*3/10,0)-J23,IF(H7=\"該当\",ROUNDDOWN(G7*3/10,0),G7))","v":0},null,null,{"$f":"IF(G7+N7>20000000,IF(K7>10000000,K7-(1955000-200000),IF(K7>7700000,K7*0.95-(1455000-200000),IF(K7>4100000,K7*0.85-(685000-200000),IF(B7>=65,IF(K7<=(1100000-200000),0,IF(K7<=3300000,K7-(1100000-200000),IF(K7<=4100000,K7*0.75-(275000-200000)))),IF(K7<=(600000-200000),0,IF(K7<=1300000,K7-(600000-200000),IF(K7<=4100000,K7*0.75-(275000-200000)))))))),IF(G7+N7>10000000,IF(K7>10000000,K7-(1955000-100000),IF(K7>7700000,K7*0.95-(1455000-100000),IF(K7>4100000,K7*0.85-(685000-100000),IF(B7>=65,IF(K7<=(1100000-100000),0,IF(K7<=3300000,K7-(1100000-100000),IF(K7<=4100000,K7*0.75-(275000-100000)))),IF(K7<=(600000-100000),0,IF(K7<=1300000,K7-(600000-100000),IF(K7<=4100000,K7*0.75-(275000-100000)))))))),IF(K7>10000000,K7-1955000,IF(K7>7700000,K7*0.95-1455000,IF(K7>4100000,K7*0.85-685000,IF(B7>=65,IF(K7<=1100000,0,IF(K7<=3300000,K7-1100000,IF(K7<=4100000,K7*0.75-275000))),IF(K7<=600000,0,IF(K7<=1300000,K7-600000,IF(K7<=4100000,K7*0.75-275000)))))))))","v":0},{"$f":"IF(B7>=65,IF(L7>=150000,150000,L7),0)","v":0},null,{"$f":"IF(ISBLANK(B7),0,IF(G7+L7+N7<=24000000,430000,IF(G7+L7+N7<=24500000,290000,IF(G7+L7+N7<=25000000,150000,IF(G7+L7+N7>25000000,0)))))","v":0},{"$f":"IF(I7+L7+N7-O7-R7<=0,0,I7+L7+N7-O7-R7)","v":0},{"$f":"IF(OR(G7>0,L7>0),\"○\",\"\")","v":""},{"$f":"IF(G7+L7>100000,IF(AND(G7>0,L7>0),IF(AND(G7>=100000,L7>=100000),100000,MIN((G7+L7-100000),G7,L7)),0),)","v":0},{"$f":"IF(B75=65,0,IF(COUNT(D8:D8)=0,0,P7))","v":0},null,null,{"$f":"IF(OR(AND(ISBLANK(B7),E7=1),AND(E7=0,B7<>\"\")),\"×\",\"\")","v":""},{"$f":"IF(OR(AND(B7<設定シート!$E$22,E8=1),AND(B7>=設定シート!$E$23,E8=1),AND(B7>=設定シート!$E$22,B7<設定シート!$E$23,E8<>1)),\"×\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(AND(F7<>\"\",B7=\"\"),(AND(K7<>\"\",B7=\"\")),(AND(N7<>\"\",B7=\"\"))),\"加入者Bの年齢を入力してください\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(ISBLANK(B7),E7=1),(AND(ISNUMBER(B7),E7=0))),\"加入者Bの資格設定ボタンをクリックして資格を設定してください\",\"\")","v":""}]
[null,null,null,null,{"$f":"COUNTIF(D8:D8,\"4\")","v":0}]
["加入者C",null,{"$f":"IF((B9>=設定シート!$E$22)*AND(B9<設定シート!$E$23),\"○\",\"\")","v":""},null,{"$f":"COUNTIF(D9:D9,\"1\")","v":0},null,{"$f":"IF(設定シート!$E$3>=8,IF(AND(J9=\"有\",F9>10000000),F9-1950000-150000,IF(AND(J9=\"有\",F9>8500000,F9<=10000000),ROUNDDOWN((F9-1950000)-((F9-8500000)*0.1),),IF(F9<=650000,0,IF(F9<=1900000,F9-650000,IF(F9<=3599999,ROUNDDOWN(F9/4,-3)*2.8-80000,IF(F9<=6599999,ROUNDDOWN(F9/4,-3)*3.2-440000,IF(F9<=8499999,F9*0.9-1100000,IF(F9>=8500000,F9-1950000)))))))),IF(AND(J9=\"有\",F9>10000000),F9-1950000-150000,IF(AND(J9=\"有\",F9>8500000,F9<=10000000),ROUNDDOWN((F9-1950000)-((F9-8500000)*0.1),),IF(F9<=550000,0,IF(F9<1619000,F9-550000,IF(F9<=1619999,1069000,IF(F9<=1621999,1070000,IF(F9<=1623999,1072000,IF(F9<=1627999,1074000,IF(F9<=1799999,ROUNDDOWN(F9/4,-3)*2.4+100000,IF(F9<=3599999,ROUNDDOWN(F9/4,-3)*2.8-80000,IF(F9<=6599999,ROUNDDOWN(F9/4,-3)*3.2-440000,IF(F9<=8499999,F9*0.9-1100000,IF(F9>=8500000,F9-1950000))))))))))))))","v":0},null,{"$f":"IF(AND(H9=\"該当\",J9=\"有\",F9>8500000),ROUNDDOWN((G9+K23)*3/10,0)-K23,IF(H9=\"該当\",ROUNDDOWN(G9*3/10,0),G9))","v":0},null,null,{"$f":"IF(G9+N9>20000000,IF(K9>10000000,K9-(1955000-200000),IF(K9>7700000,K9*0.95-(1455000-200000),IF(K9>4100000,K9*0.85-(685000-200000),IF(B9>=65,IF(K9<=(1100000-200000),0,IF(K9<=3300000,K9-(1100000-200000),IF(K9<=4100000,K9*0.75-(275000-200000)))),IF(K9<=(600000-200000),0,IF(K9<=1300000,K9-(600000-200000),IF(K9<=4100000,K9*0.75-(275000-200000)))))))),IF(G9+N9>10000000,IF(K9>10000000,K9-(1955000-100000),IF(K9>7700000,K9*0.95-(1455000-100000),IF(K9>4100000,K9*0.85-(685000-100000),IF(B9>=65,IF(K9<=(1100000-100000),0,IF(K9<=3300000,K9-(1100000-100000),IF(K9<=4100000,K9*0.75-(275000-100000)))),IF(K9<=(600000-100000),0,IF(K9<=1300000,K9-(600000-100000),IF(K9<=4100000,K9*0.75-(275000-100000)))))))),IF(K9>10000000,K9-1955000,IF(K9>7700000,K9*0.95-1455000,IF(K9>4100000,K9*0.85-685000,IF(B9>=65,IF(K9<=1100000,0,IF(K9<=3300000,K9-1100000,IF(K9<=4100000,K9*0.75-275000))),IF(K9<=600000,0,IF(K9<=1300000,K9-600000,IF(K9<=4100000,K9*0.75-275000)))))))))","v":0},{"$f":"IF(B9>=65,IF(L9>=150000,150000,L9),0)","v":0},null,{"$f":"IF(ISBLANK(B9),0,IF(G9+L9+N9<=24000000,430000,IF(G9+L9+N9<=24500000,290000,IF(G9+L9+N9<=25000000,150000,IF(G9+L9+N9>25000000,0)))))","v":0},{"$f":"IF(I9+L9+N9-O9-R9<=0,0,I9+L9+N9-O9-R9)","v":0},{"$f":"IF(OR(G9>0,L9>0),\"○\",\"\")","v":""},{"$f":"IF(G9+L9>100000,IF(AND(G9>0,L9>0),IF(AND(G9>=100000,L9>=100000),100000,MIN((G9+L9-100000),G9,L9)),0),)","v":0},{"$f":"IF(B76=65,0,IF(COUNT(D10:D10)=0,0,P9))","v":0},null,null,{"$f":"IF(OR(AND(ISBLANK(B9),E9=1),AND(E9=0,B9<>\"\")),\"×\",\"\")","v":""},{"$f":"IF(OR(AND(B9<設定シート!$E$22,E10=1),AND(B9>=設定シート!$E$23,E10=1),AND(B9>=設定シート!$E$22,B9<設定シート!$E$23,E10<>1)),\"×\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(AND(F9<>\"\",B9=\"\"),(AND(K9<>\"\",B9=\"\")),(AND(N9<>\"\",B9=\"\"))),\"加入者Cの年齢を入力してください\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(ISBLANK(B9),E9=1),(AND(ISNUMBER(B9),E9=0))),\"加入者Cの資格設定ボタンをクリックして資格を設定してください\",\"\")","v":""}]
[null,null,null,null,{"$f":"COUNTIF(D10:D10,\"4\")","v":0}]
["加入者D",null,{"$f":"IF((B11>=設定シート!$E$22)*AND(B11<設定シート!$E$23),\"○\",\"\")","v":""},null,{"$f":"COUNTIF(D11:D11,\"1\")","v":0},null,{"$f":"IF(設定シート!$E$3>=8,IF(AND(J11=\"有\",F11>10000000),F11-1950000-150000,IF(AND(J11=\"有\",F11>8500000,F11<=10000000),ROUNDDOWN((F11-1950000)-((F11-8500000)*0.1),),IF(F11<=650000,0,IF(F11<=1900000,F11-650000,IF(F11<=3599999,ROUNDDOWN(F11/4,-3)*2.8-80000,IF(F11<=6599999,ROUNDDOWN(F11/4,-3)*3.2-440000,IF(F11<=8499999,F11*0.9-1100000,IF(F11>=8500000,F11-1950000)))))))),IF(AND(J11=\"有\",F11>10000000),F11-1950000-150000,IF(AND(J11=\"有\",F11>8500000,F11<=10000000),ROUNDDOWN((F11-1950000)-((F11-8500000)*0.1),),IF(F11<=550000,0,IF(F11<1619000,F11-550000,IF(F11<=1619999,1069000,IF(F11<=1621999,1070000,IF(F11<=1623999,1072000,IF(F11<=1627999,1074000,IF(F11<=1799999,ROUNDDOWN(F11/4,-3)*2.4+100000,IF(F11<=3599999,ROUNDDOWN(F11/4,-3)*2.8-80000,IF(F11<=6599999,ROUNDDOWN(F11/4,-3)*3.2-440000,IF(F11<=8499999,F11*0.9-1100000,IF(F11>=8500000,F11-1950000))))))))))))))","v":0},null,{"$f":"IF(AND(H11=\"該当\",J11=\"有\",F11>8500000),ROUNDDOWN((G11+L23)*3/10,0)-L23,IF(H11=\"該当\",ROUNDDOWN(G11*3/10,0),G11))","v":0},null,null,{"$f":"IF(G11+N11>20000000,IF(K11>10000000,K11-(1955000-200000),IF(K11>7700000,K11*0.95-(1455000-200000),IF(K11>4100000,K11*0.85-(685000-200000),IF(B11>=65,IF(K11<=(1100000-200000),0,IF(K11<=3300000,K11-(1100000-200000),IF(K11<=4100000,K11*0.75-(275000-200000)))),IF(K11<=(600000-200000),0,IF(K11<=1300000,K11-(600000-200000),IF(K11<=4100000,K11*0.75-(275000-200000)))))))),IF(G11+N11>10000000,IF(K11>10000000,K11-(1955000-100000),IF(K11>7700000,K11*0.95-(1455000-100000),IF(K11>4100000,K11*0.85-(685000-100000),IF(B11>=65,IF(K11<=(1100000-100000),0,IF(K11<=3300000,K11-(1100000-100000),IF(K11<=4100000,K11*0.75-(275000-100000)))),IF(K11<=(600000-100000),0,IF(K11<=1300000,K11-(600000-100000),IF(K11<=4100000,K11*0.75-(275000-100000)))))))),IF(K11>10000000,K11-1955000,IF(K11>7700000,K11*0.95-1455000,IF(K11>4100000,K11*0.85-685000,IF(B11>=65,IF(K11<=1100000,0,IF(K11<=3300000,K11-1100000,IF(K11<=4100000,K11*0.75-275000))),IF(K11<=600000,0,IF(K11<=1300000,K11-600000,IF(K11<=4100000,K11*0.75-275000)))))))))","v":0},{"$f":"IF(B11>=65,IF(L11>=150000,150000,L11),0)","v":0},null,{"$f":"IF(ISBLANK(B11),0,IF(G11+L11+N11<=24000000,430000,IF(G11+L11+N11<=24500000,290000,IF(G11+L11+N11<=25000000,150000,IF(G11+L11+N11>25000000,0)))))","v":0},{"$f":"IF(I11+L11+N11-O11-R11<=0,0,I11+L11+N11-O11-R11)","v":0},{"$f":"IF(OR(G11>0,L11>0),\"○\",\"\")","v":""},{"$f":"IF(G11+L11>100000,IF(AND(G11>0,L11>0),IF(AND(G11>=100000,L11>=100000),100000,MIN((G11+L11-100000),G11,L11)),0),)","v":0},{"$f":"IF(B77=65,0,IF(COUNT(D12:D12)=0,0,P11))","v":0},null,null,{"$f":"IF(OR(AND(ISBLANK(B11),E11=1),AND(E11=0,B11<>\"\")),\"×\",\"\")","v":""},{"$f":"IF(OR(AND(B11<設定シート!$E$22,E12=1),AND(B11>=設定シート!$E$23,E12=1),AND(B11>=設定シート!$E$22,B11<設定シート!$E$23,E12<>1)),\"×\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(AND(F11<>\"\",B11=\"\"),(AND(K11<>\"\",B11=\"\")),(AND(N11<>\"\",B11=\"\"))),\"加入者Dの年齢を入力してください\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(ISBLANK(B11),E11=1),(AND(ISNUMBER(B11),E11=0))),\"加入者Dの資格設定ボタンをクリックして資格を設定してください\",\"\")","v":""}]
[null,null,null,null,{"$f":"COUNTIF(D12:D12,\"4\")","v":0}]
["加入者E",null,{"$f":"IF((B13>=設定シート!$E$22)*AND(B13<設定シート!$E$23),\"○\",\"\")","v":""},null,0,null,{"$f":"IF(設定シート!$E$3>=8,IF(AND(J13=\"有\",F13>10000000),F13-1950000-150000,IF(AND(J13=\"有\",F13>8500000,F13<=10000000),ROUNDDOWN((F13-1950000)-((F13-8500000)*0.1),),IF(F13<=650000,0,IF(F13<=1900000,F13-650000,IF(F13<=3599999,ROUNDDOWN(F13/4,-3)*2.8-80000,IF(F13<=6599999,ROUNDDOWN(F13/4,-3)*3.2-440000,IF(F13<=8499999,F13*0.9-1100000,IF(F13>=8500000,F13-1950000)))))))),IF(AND(J13=\"有\",F13>10000000),F13-1950000-150000,IF(AND(J13=\"有\",F13>8500000,F13<=10000000),ROUNDDOWN((F13-1950000)-((F13-8500000)*0.1),),IF(F13<=550000,0,IF(F13<1619000,F13-550000,IF(F13<=1619999,1069000,IF(F13<=1621999,1070000,IF(F13<=1623999,1072000,IF(F13<=1627999,1074000,IF(F13<=1799999,ROUNDDOWN(F13/4,-3)*2.4+100000,IF(F13<=3599999,ROUNDDOWN(F13/4,-3)*2.8-80000,IF(F13<=6599999,ROUNDDOWN(F13/4,-3)*3.2-440000,IF(F13<=8499999,F13*0.9-1100000,IF(F13>=8500000,F13-1950000))))))))))))))","v":0},null,{"$f":"IF(AND(H13=\"該当\",J13=\"有\",F13>8500000),ROUNDDOWN((G13+L25)*3/10,0)-L25,IF(H13=\"該当\",ROUNDDOWN(G13*3/10,0),G13))","v":0},null,null,{"$f":"IF(G13+N13>20000000,IF(K13>10000000,K13-(1955000-200000),IF(K13>7700000,K13*0.95-(1455000-200000),IF(K13>4100000,K13*0.85-(685000-200000),IF(B13>=65,IF(K13<=(1100000-200000),0,IF(K13<=3300000,K13-(1100000-200000),IF(K13<=4100000,K13*0.75-(275000-200000)))),IF(K13<=(600000-200000),0,IF(K13<=1300000,K13-(600000-200000),IF(K13<=4100000,K13*0.75-(275000-200000)))))))),IF(G13+N13>10000000,IF(K13>10000000,K13-(1955000-100000),IF(K13>7700000,K13*0.95-(1455000-100000),IF(K13>4100000,K13*0.85-(685000-100000),IF(B13>=65,IF(K13<=(1100000-100000),0,IF(K13<=3300000,K13-(1100000-100000),IF(K13<=4100000,K13*0.75-(275000-100000)))),IF(K13<=(600000-100000),0,IF(K13<=1300000,K13-(600000-100000),IF(K13<=4100000,K13*0.75-(275000-100000)))))))),IF(K13>10000000,K13-1955000,IF(K13>7700000,K13*0.95-1455000,IF(K13>4100000,K13*0.85-685000,IF(B13>=65,IF(K13<=1100000,0,IF(K13<=3300000,K13-1100000,IF(K13<=4100000,K13*0.75-275000))),IF(K13<=600000,0,IF(K13<=1300000,K13-600000,IF(K13<=4100000,K13*0.75-275000)))))))))","v":0},{"$f":"IF(B13>=65,IF(L13>=150000,150000,L13),0)","v":0},null,{"$f":"IF(ISBLANK(B13),0,IF(G13+L13+N13<=24000000,430000,IF(G13+L13+N13<=24500000,290000,IF(G13+L13+N13<=25000000,150000,IF(G13+L13+N13>25000000,0)))))","v":0},{"$f":"IF(I13+L13+N13-O13-R13<=0,0,I13+L13+N13-O13-R13)","v":0},{"$f":"IF(OR(G13>0,L13>0),\"○\",\"\")","v":""},{"$f":"IF(G13+L13>100000,IF(AND(G13>0,L13>0),IF(AND(G13>=100000,L13>=100000),100000,MIN((G13+L13-100000),G13,L13)),0),)","v":0},{"$f":"IF(B79=65,0,IF(COUNT(D14:D14)=0,0,P13))","v":0},null,null,{"$f":"IF(OR(AND(ISBLANK(B13),E13=1),AND(E13=0,B13<>\"\")),\"×\",\"\")","v":""},{"$f":"IF(OR(AND(B13<設定シート!$E$22,E14=1),AND(B13>=設定シート!$E$23,E14=1),AND(B13>=設定シート!$E$22,B13<設定シート!$E$23,E14<>1)),\"×\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(AND(F13<>\"\",B13=\"\"),(AND(K13<>\"\",B13=\"\")),(AND(N13<>\"\",B13=\"\"))),\"加入者Eの年齢を入力してください\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(ISBLANK(B13),E13=1),(AND(ISNUMBER(B13),E13=0))),\"加入者Eの資格設定ボタンをクリックして資格を設定してください\",\"\")","v":""}]
[null,null,null,null,0]
["旧被扶",null,{"$f":"IF((B15>=設定シート!$E$22)*AND(B15<設定シート!$E$23),\"○\",\"\")","v":""},null,{"$f":"COUNTA(D15:D15)","v":0},null,{"$f":"IF(設定シート!$E$3>=8,IF(AND(J15=\"有\",F15>10000000),F15-1950000-150000,IF(AND(J15=\"有\",F15>8500000,F15<=10000000),ROUNDDOWN((F15-1950000)-((F15-8500000)*0.1),),IF(F15<=650000,0,IF(F15<=1900000,F15-650000,IF(F15<=3599999,ROUNDDOWN(F15/4,-3)*2.8-80000,IF(F15<=6599999,ROUNDDOWN(F15/4,-3)*3.2-440000,IF(F15<=8499999,F15*0.9-1100000,IF(F15>=8500000,F15-1950000)))))))),IF(AND(J15=\"有\",F15>10000000),F15-1950000-150000,IF(AND(J15=\"有\",F15>8500000,F15<=10000000),ROUNDDOWN((F15-1950000)-((F15-8500000)*0.1),),IF(F15<=550000,0,IF(F15<1619000,F15-550000,IF(F15<=1619999,1069000,IF(F15<=1621999,1070000,IF(F15<=1623999,1072000,IF(F15<=1627999,1074000,IF(F15<=1799999,ROUNDDOWN(F15/4,-3)*2.4+100000,IF(F15<=3599999,ROUNDDOWN(F15/4,-3)*2.8-80000,IF(F15<=6599999,ROUNDDOWN(F15/4,-3)*3.2-440000,IF(F15<=8499999,F15*0.9-1100000,IF(F15>=8500000,F15-1950000))))))))))))))","v":0},null,{"$f":"IF(H15=\"該当\",ROUNDDOWN(G15*3/10,0),G15)","v":0},null,null,{"$f":"IF(G15+N15>20000000,IF(K15>10000000,K15-(1955000-200000),IF(K15>7700000,K15*0.95-(1455000-200000),IF(K15>4100000,K15*0.85-(685000-200000),IF(B15>=65,IF(K15<=(1100000-200000),0,IF(K15<=3300000,K15-(1100000-200000),IF(K15<=4100000,K15*0.75-(275000-200000)))),IF(K15<=(600000-200000),0,IF(K15<=1300000,K15-(600000-200000),IF(K15<=4100000,K15*0.75-(275000-200000)))))))),IF(G15+N15>10000000,IF(K15>10000000,K15-(1955000-100000),IF(K15>7700000,K15*0.95-(1455000-100000),IF(K15>4100000,K15*0.85-(685000-100000),IF(B15>=65,IF(K15<=(1100000-100000),0,IF(K15<=3300000,K15-(1100000-100000),IF(K15<=4100000,K15*0.75-(275000-100000)))),IF(K15<=(600000-100000),0,IF(K15<=1300000,K15-(600000-100000),IF(K15<=4100000,K15*0.75-(275000-100000)))))))),IF(K15>10000000,K15-1955000,IF(K15>7700000,K15*0.95-1455000,IF(K15>4100000,K15*0.85-685000,IF(B15>=65,IF(K15<=1100000,0,IF(K15<=3300000,K15-1100000,IF(K15<=4100000,K15*0.75-275000))),IF(K15<=600000,0,IF(K15<=1300000,K15-600000,IF(K15<=4100000,K15*0.75-275000)))))))))","v":0},{"$f":"IF(B15>=65,IF(L15>=150000,150000,L15),0)","v":0},null,{"$f":"IF(ISBLANK(B15),0,IF(G15+L15+N15<=24000000,430000,IF(G15+L15+N15<=24500000,290000,IF(G15+L15+N15<=25000000,150000,IF(G15+L15+N15>25000000,0)))))","v":0},{"$f":"IF(I15+L15+N15-O15-R15<=0,0,I15+L15+N15-O15-R15)","v":0},{"$f":"IF(OR(G15>0,L15>0),\"○\",\"\")","v":""},{"$f":"IF(G15+L15>100000,IF(AND(G15>0,L15>0),IF(AND(G15>=100000,L15>=100000),100000,MIN((G15+L15-100000),G15,L15)),0),)","v":0},{"$f":"IF(COUNT(D16:D16)=0,0,P15)","v":0},null,null,{"$f":"IF(OR(AND(ISBLANK(B15),E15=1),AND(E15=0,B15<>\"\")),\"×\",\"\")","v":""},{"$f":"IF(OR(AND(B15<設定シート!$E$22,E16=1),AND(B15>=設定シート!$E$23,E16=1),AND(B15>=設定シート!$E$22,B15<設定シート!$E$23,E16<>1)),\"×\",\"\")","v":""}]
[]
["合計",null,null,null,null,{"$f":"SUM(F5:F16)","v":0},{"$f":"SUM(G5:G16)","v":0},null,{"$f":"SUM(I5:I16)","v":0},{"$f":"SUM(J5:J16)","v":0},0,0,0,0,0,0,{"$f":"COUNTIF(Q5:Q16,\"○\")","v":0},{"$f":"SUM(R5:R16)","v":0},{"$f":"SUM(S5:S16)","v":0},null,null,{"$f":"COUNTIF(V5:V16,\"×\")","v":0},{"$f":"COUNTIF(W5:W16,\"×\")","v":0},{"$f":"V17+W17","v":0}]
[]
["国保に加入しない世帯主がいる場合はその所得を入力",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"世帯合計所得",{"$f":"I17+L17+N17+H19","v":0}]
["後期① 旧国保   所得を直接入力",null,null,null,null,null,null,null,null,"国保加入者数",{"$f":"COUNT(B5:B16)+COUNT(H20:H21)","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,null,null,null,"給与年金所得額調整控除",{"$f":"-R17","v":0}]
["後期高齢者分等を含む合計総所得金額",null,null,null,null,null,null,{"$f":"I17+L17+N17+H19+H20+H21","v":0},{"$f":"COUNTIF(I19:I21,\"○\")","v":0},{"$f":"IF(Q17+I22=0,IF(U23<=430000,\"均等割７割減\",IF(U23<=(430000+(国保加入者数*M54)),\"均等割５割減\",IF(U23<=(430000+(国保加入者数*M55)),\"均等割２割減\",\"政減対象外\"))),IF(U23<=(430000+(100000*(Q17-1+I22))),\"均等割７割減\",IF(U23<=(430000+(国保加入者数*M54)+(100000*(Q17-1+I22))),\"均等割５割減\",IF(U23<=(430000+(国保加入者数*M55)+(100000*(Q17-1+I22))),\"均等割２割減\",\"政減対象外\"))))","v":"均等割７割減"},null,{"$f":"IF(J22=\"均等割７割減\",0.3,IF(J22=\"均等割５割減\",0.5,IF(J22=\"均等割２割減\",0.8,1)))","v":0.3},null,null,null,null,null,null,null,"年金特別控除６５以上",{"$f":"-M17","v":0}]
["加入者の給与調整控除額Ｒ２年度税制改正（Ｒ３以降適用）  ",null,null,null,null,null,null,null,{"$f":"IF(AND(J5=\"有\",F5>10000000),150000,IF(AND(J5=\"有\",F5>8500000,F5<=10000000),((F5-8500000)*0.1),))","v":0},{"$f":"IF(AND(J7=\"有\",F7>10000000),150000,IF(AND(J7=\"有\",F7>8500000,F7<=10000000),((F7-8500000)*0.1),))","v":0},{"$f":"IF(AND(J9=\"有\",F9>10000000),150000,IF(AND(J9=\"有\",F9>8500000,F9<=10000000),((F9-8500000)*0.1),))","v":0},{"$f":"IF(AND(J11=\"有\",F11>10000000),150000,IF(AND(J11=\"有\",F11>8500000,F11<=10000000),((F11-8500000)*0.1),))","v":0},{"$f":"IF(AND(J13=\"有\",F13>10000000),150000,IF(AND(J13=\"有\",F13>8500000,F13<=10000000),((F13-8500000)*0.1),))","v":0},null,null,null,null,null,null,"判定基準額",{"$f":"SUM(U19:U22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"世帯の医療均等割額",null,{"$f":"ROUNDDOWN(((COUNTIFS($D$5:$D$14,1,$B$5:$B$14,\">\"&$M$57))*(医療均等割/12)*$L$22+(COUNTIFS($D$5:$D$14,1,$B$5:$B$14,\"<=\"&$M$57))*(医療均等割/12)*$L$22*$O$57+COUNTIF($D$15,\"◎\")*(医療均等割/12)*$L$22*0.5+COUNTIF($D$15,\"×\")*(医療均等割/12)*$L$22),0)","v":0}]
[null,null,"医療分",null,null,"加入者Ａ","加入者Ｂ","加入者Ｃ","加入者Ｄ","加入者E","旧被扶養者","合　計",null,"世帯の支援金均等割額",null,{"$f":"ROUNDDOWN(((COUNTIFS($D$5:$D$14,1,$B$5:$B$14,\">\"&$M$57))*(支援金均等割/12)*$L$22+(COUNTIFS($D$5:$D$14,1,$B$5:$B$14,\"<=\"&$M$57))*(支援金均等割/12)*$L$22*$O$57+COUNTIF($D$15,\"◎\")*(支援金均等割/12)*$L$22*0.5+COUNTIF($D$15,\"×\")*(支援金均等割/12)*$L$22),0)","v":0}]
[null,null,null,null,null,{"$f":"IF(E5=0,0,IF(B5>$M$57,IF(ROUNDDOWN((P5*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P5*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)),IF(ROUNDDOWN((P5*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P5*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"IF(E7=0,0,IF(B7>$M$57,IF(ROUNDDOWN((P7*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P7*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)),IF(ROUNDDOWN((P7*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P7*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"IF(E9=0,0,IF(B9>$M$57,IF(ROUNDDOWN((P9*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P9*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)),IF(ROUNDDOWN((P9*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P9*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"IF(E11=0,0,IF(B11>$M$57,IF(ROUNDDOWN((P11*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P11*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)),IF(ROUNDDOWN((P11*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P11*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"IF(E13=0,0,IF(B13>$M$57,IF(ROUNDDOWN((P13*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P13*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0)),IF(ROUNDDOWN((P13*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)>医療限度額/12,ROUNDDOWN(医療限度額/12,0),ROUNDDOWN((P13*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"ROUNDDOWN(COUNTIF($D$15,\"◎\")*(医療均等割/12)*$L$22*0.5+COUNTIF($D$15,\"×\")*(医療均等割/12)*$L$22,0)","v":0},{"$f":"IF(SUM(F26:K26)>=医療限度額/12,ROUNDDOWN(医療限度額/12,0),SUM(F26:K26))","v":0},{"$f":"IF(E13=0,0,IF(B13>$M$57,ROUNDDOWN((P13*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0),ROUNDDOWN((P13*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)))+IF(E5=0,0,IF(B5>$M$57,ROUNDDOWN((P5*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0),ROUNDDOWN((P5*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)))+IF(E7=0,0,IF(B7>$M$57,ROUNDDOWN((P7*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0),ROUNDDOWN((P7*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)))+IF(E9=0,0,IF(B9>$M$57,ROUNDDOWN((P9*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0),ROUNDDOWN((P9*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)))+IF(E11=0,0,IF(B11>$M$57,ROUNDDOWN((P11*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12),0),ROUNDDOWN((P11*医療割合/100/12),0)+ROUNDDOWN((医療均等割*$L$22/12*$O$57),0)))+ROUNDDOWN(IF($L$22>0.5,COUNTIF(D15:D15,\"◎\")*医療均等割/12*0.5+COUNTIF(D15:D15,\"×\")*医療均等割/12*$L$22,(COUNTA(D15:D15)*医療均等割/12*$L$22)),0)","v":0},"世帯の介護均等割額",null,{"$f":"ROUNDDOWN((COUNTIF($D$5:$D$14,4)-COUNTIF(B74:B77,設定シート!$E$23))*介護均等割/12*$L$22,0)","v":0}]
[null,null,{"$f":"IF(M26>=L26,\"按分額\",\"\")","v":"按分額"},null,null,{"$f":"IF($M$26>=ROUNDDOWN(医療限度額/12,0),IF(ISBLANK(B5),0,IF(B5<=$M$57,IF(P5=0,医療均等割/12*$O$57,($L$26-$P$24)*P5/$P$17+医療均等割/12*$O$57),IF(P5=0,医療均等割/12,($L$26-$P$24)*P5/$P$17+医療均等割/12))),0)","v":0},{"$f":"IF($M$26>=ROUNDDOWN(医療限度額/12,0),IF(ISBLANK(B7),0,IF(B7<=$M$57,IF(P7=0,医療均等割/12*$O$57,($L$26-$P$24)*P7/$P$17+医療均等割/12*$O$57),IF(P7=0,医療均等割/12,($L$26-$P$24)*P7/$P$17+医療均等割/12))),0)","v":0},{"$f":"IF($M$26>=ROUNDDOWN(医療限度額/12,0),IF(ISBLANK(B9),0,IF(B9<=$M$57,IF(P9=0,医療均等割/12*$O$57,($L$26-$P$24)*P9/$P$17+医療均等割/12*$O$57),IF(P9=0,医療均等割/12,($L$26-$P$24)*P9/$P$17+医療均等割/12))),0)","v":0},{"$f":"IF($M$26>=ROUNDDOWN(医療限度額/12,0),IF(ISBLANK(B11),0,IF(B11<=$M$57,IF(P11=0,医療均等割/12*$O$57,($L$26-$P$24)*P11/$P$17+医療均等割/12*$O$57),IF(P11=0,医療均等割/12,($L$26-$P$24)*P11/$P$17+医療均等割/12))),0)","v":0},{"$f":"IF($M$26>=ROUNDDOWN(医療限度額/12,0),IF(ISBLANK(B13),0,IF(B13<=$M$57,IF(P13=0,医療均等割/12*$O$57,($L$26-$P$24)*P13/$P$17+医療均等割/12*$O$57),IF(P13=0,医療均等割/12,($L$26-$P$24)*P13/$P$17+医療均等割/12))),0)","v":0},{"$f":"IF($M$26>=ROUNDDOWN(医療限度額/12,0),IF(ISBLANK(B15),0,IF(D15=\"◎\",医療均等割/12*0.5,IF(D15=\"×\",医療均等割/12))),0)","v":0},{"$f":"SUM(F27:K27)","v":0},null,{"$f":"IF(設定シート!E3<=7,\"\",TRIM(\"世帯の\"&設定シート!C17&\"均等割額\"))","v":"世帯の子育て支援分均等割額"},null,{"$f":"IF(設定シート!E3<=7,0,ROUNDDOWN(((COUNTIFS($D$5:$D$14,1,$B$5:$B$14,\">\"&$M$58))*(子ども支援金均等割/12)*$L$22+(COUNTIFS($D$5:$D$14,1,$B$5:$B$14,\"<=\"&$M$58,$B$5:$B$14,\"<=\"&$M$57))*(子ども支援金均等割/12*$M$59)*$L$22*$O$57+(COUNTIFS($D$5:$D$14,1,$B$5:$B$14,\"<=\"&$M$58,$B$5:$B$14,\">\"&$M$57))*(子ども支援金均等割/12*$M$59)*$L$22+COUNTIF($D$15,\"◎\")*(子ども支援金均等割/12)*$L$22*0.5+COUNTIF($D$15,\"×\")*(子ども支援金均等割/12)*$L$22),0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Ｒ４以降の保険料に反映"]
[null,null,"支援分",null,null,"加入者Ａ","加入者Ｂ","加入者Ｃ","加入者Ｄ","加入者E","旧被扶養者","合　計",null,"未就学児の人数",null,{"$f":"COUNTIF(B5:B14,\"<=\"&$M$57)","v":0}]
[null,null,null,null,null,{"$f":"IF(E5=0,0,IF(B5>$M$57,IF(ROUNDDOWN((P5*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P5*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P5*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P5*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"IF(E7=0,0,IF(B7>$M$57,IF(ROUNDDOWN((P7*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P7*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P7*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P7*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"IF(E9=0,0,IF(B9>$M$57,IF(ROUNDDOWN((P9*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P9*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P9*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P9*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"IF(E11=0,0,IF(B11>$M$57,IF(ROUNDDOWN((P11*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P11*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P11*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P11*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"IF(E13=0,0,IF(B13>$M$57,IF(ROUNDDOWN((P13*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P13*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P13*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)>支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),ROUNDDOWN((P13*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0))))","v":0},{"$f":"ROUNDDOWN(COUNTIF($D$15,\"◎\")*(支援金均等割/12)*$L$22*0.5+COUNTIF($D$15,\"×\")*(支援金均等割/12)*$L$22,0)","v":0},{"$f":"IF(SUM(F30:K30)>=支援金限度額/12,ROUNDDOWN(支援金限度額/12,0),SUM(F30:K30))","v":0},{"$f":"IF(E13=0,0,IF(B13>$M$57,ROUNDDOWN((P13*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0),ROUNDDOWN((P13*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)))+IF(E5=0,0,IF(B5>$M$57,ROUNDDOWN((P5*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0),ROUNDDOWN((P5*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)))+IF(E7=0,0,IF(B7>$M$57,ROUNDDOWN((P7*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0),ROUNDDOWN((P7*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)))+IF(E9=0,0,IF(B9>$M$57,ROUNDDOWN((P9*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0),ROUNDDOWN((P9*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)))+IF(E11=0,0,IF(B11>$M$57,ROUNDDOWN((P11*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12),0),ROUNDDOWN((P11*支援金割合/100/12),0)+ROUNDDOWN((支援金均等割*$L$22/12*$O$57),0)))+ROUNDDOWN(IF($L$22>0.5,COUNTIF(D15:D15,\"◎\")*支援金均等割/12*0.5+COUNTIF(D15:D15,\"×\")*支援金均等割/12*$L$22,(COUNTA(D15:D15)*支援金均等割/12*$L$22)),0)","v":0},"Aの月数 (未就学児の場合)",null,{"$f":"IF(B5<=$M$57,COUNTIF(D5:D5,1),0)","v":0}]
[null,null,{"$f":"IF(M30>=L30,\"按分額\",\"\")","v":"按分額"},null,null,{"$f":"IF($M$30>=ROUNDDOWN(支援金限度額/12,0),IF(ISBLANK(B5),0,IF(B5<=$M$57,IF(P5=0,支援金均等割/12*$O$57,($L$30-$P$25)*P5/$P$17+支援金均等割/12*$O$57),IF(P5=0,支援金均等割/12,($L$30-$P$25)*P5/$P$17+支援金均等割/12))),0)","v":0},{"$f":"IF($M$30>=ROUNDDOWN(支援金限度額/12,0),IF(ISBLANK(B7),0,IF(B7<=$M$57,IF(P7=0,支援金均等割/12*$O$57,($L$30-$P$25)*P7/$P$17+支援金均等割/12*$O$57),IF(P7=0,支援金均等割/12,($L$30-$P$25)*P7/$P$17+支援金均等割/12))),0)","v":0},{"$f":"IF($M$30>=ROUNDDOWN(支援金限度額/12,0),IF(ISBLANK(B9),0,IF(B9<=$M$57,IF(P9=0,支援金均等割/12*$O$57,($L$30-$P$25)*P9/$P$17+支援金均等割/12*$O$57),IF(P9=0,支援金均等割/12,($L$30-$P$25)*P9/$P$17+支援金均等割/12))),0)","v":0},{"$f":"IF($M$30>=ROUNDDOWN(支援金限度額/12,0),IF(ISBLANK(B11),0,IF(B11<=$M$57,IF(P11=0,支援金均等割/12*$O$57,($L$30-$P$25)*P11/$P$17+支援金均等割/12*$O$57),IF(P11=0,支援金均等割/12,($L$30-$P$25)*P11/$P$17+支援金均等割/12))),0)","v":0},{"$f":"IF($M$30>=ROUNDDOWN(支援金限度額/12,0),IF(ISBLANK(B13),0,IF(B13<=$M$57,IF(P13=0,支援金均等割/12*$O$57,($L$30-$P$25)*P13/$P$17+支援金均等割/12*$O$57),IF(P13=0,支援金均等割/12,($L$30-$P$25)*P13/$P$17+支援金均等割/12))),0)","v":0},{"$f":"IF($M$26>=ROUNDDOWN(支援金限度額/12,0),IF(ISBLANK(B15),0,IF(D15=\"◎\",支援金均等割/12*0.5,IF(D15=\"×\",支援金均等割/12))),0)","v":0},{"$f":"SUM(F31:K31)","v":0},null,"Bの月数 (未就学児の場合)",null,{"$f":"IF(B7<=$M$57,COUNTIF(D7:D7,1),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cの月数 (未就学児の場合)",null,{"$f":"IF(B9<=$M$57,COUNTIF(D9:D9,1),0)","v":0}]
[null,null,"介護分",null,null,"加入者Ａ","加入者Ｂ","加入者Ｃ","加入者Ｄ","加入者E","旧被扶養者","合　計",null,"Dの月数 (未就学児の場合)",null,{"$f":"IF(B11<=$M$57,COUNTIF(D11:D11,1),0)","v":0}]
[null,null,null,null,null,{"$f":"IF(B69=設定シート!$E$23,0,IF(E6=0,0,IF(B5>=設定シート!$E$22,IF(ROUNDDOWN((P5*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)>介護限度額/12,ROUNDDOWN(介護限度額/12,0),ROUNDDOWN((P5*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))))","v":0},{"$f":"IF(B70=設定シート!$E$23,0,IF(E8=0,0,IF(B7>=設定シート!$E$22,IF(ROUNDDOWN((P7*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)>介護限度額/12,ROUNDDOWN(介護限度額/12,0),ROUNDDOWN((P7*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))))","v":0},{"$f":"IF(B71=設定シート!$E$23,0,IF(E10=0,0,IF(B9>=設定シート!$E$22,IF(ROUNDDOWN((P9*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)>介護限度額/12,ROUNDDOWN(介護限度額/12,0),ROUNDDOWN((P9*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))))","v":0},{"$f":"IF(B72=設定シート!$E$23,0,IF(E12=0,0,IF(B11>=設定シート!$E$22,IF(ROUNDDOWN((P11*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)>介護限度額/12,ROUNDDOWN(介護限度額/12,0),ROUNDDOWN((P11*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))))","v":0},{"$f":"IF(B73=設定シート!$E$23,0,IF(E14=0,0,IF(B13>=設定シート!$E$22,IF(ROUNDDOWN((P13*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)>介護限度額/12,ROUNDDOWN(介護限度額/12,0),ROUNDDOWN((P13*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))))","v":0},null,{"$f":"IF(SUM(F34:K34)>=介護限度額/12,ROUNDDOWN(介護限度額/12,0),SUM(F34:K34))","v":0},{"$f":"IF(E14=0,0,IF(AND(B13>=設定シート!$E$22,B78<>設定シート!$E$23),ROUNDDOWN((S13*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))+IF(E6=0,0,IF(AND(B5>=設定シート!$E$22,B74<>設定シート!$E$23),ROUNDDOWN((S5*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))+IF(E8=0,0,IF(AND(B7>=設定シート!$E$22,B75<>設定シート!$E$23),ROUNDDOWN((S7*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))+IF(E10=0,0,IF(AND(B9>=設定シート!$E$22,B76<>設定シート!$E$23),ROUNDDOWN((S9*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))+IF(E12=0,0,IF(AND(B11>=設定シート!$E$22,B77<>設定シート!$E$23),ROUNDDOWN((S11*介護割合/100/12),0)+ROUNDDOWN((介護均等割*$L$22/12),0)))","v":0},"Eの月数 (未就学児の場合)",null,{"$f":"IF(B13<=$M$57,COUNTIF(D13:D13,1),0)","v":0}]
[null,null,{"$f":"IF(M34>=L34,\"按分額\",\"\")","v":"按分額"},null,null,{"$f":"IF(F34=0,0,IF(B74=設定シート!$E$23,0,IF($M$34>=ROUNDDOWN(介護限度額/12,0),IF(OR(ISBLANK(B5),B5<設定シート!$E$22),0,IF(S5=0,介護均等割/12*$L$22,($L$34-$P$26)*S5/$S$17+介護均等割/12)),0)))","v":0},{"$f":"IF(G34=0,0,IF(B75=設定シート!$E$23,0,IF($M$34>=ROUNDDOWN(介護限度額/12,0),IF(OR(ISBLANK(B7),B7<設定シート!$E$22),0,IF(S7=0,介護均等割/12*$L$22,($L$34-$P$26)*S7/$S$17+介護均等割/12)),0)))","v":0},{"$f":"IF(H34=0,0,IF(B76=設定シート!$E$23,0,IF($M$34>=ROUNDDOWN(介護限度額/12,0),IF(OR(ISBLANK(B9),B9<設定シート!$E$22),0,IF(S9=0,介護均等割/12*$L$22,($L$34-$P$26)*S9/$S$17+介護均等割/12)),0)))","v":0},{"$f":"IF(I34=0,0,IF(B77=設定シート!$E$23,0,IF($M$34>=ROUNDDOWN(介護限度額/12,0),IF(OR(ISBLANK(B11),B11<設定シート!$E$22),0,IF(S11=0,介護均等割/12*$L$22,($L$34-$P$26)*S11/$S$17+介護均等割/12)),0)))","v":0},{"$f":"IF(J34=0,0,IF(B78=設定シート!$E$23,0,IF($M$34>=ROUNDDOWN(介護限度額/12,0),IF(OR(ISBLANK(B13),B13<設定シート!$E$22),0,IF(S13=0,介護均等割/12*$L$22,($L$34-$P$26)*S13/$S$17+介護均等割/12)),0)))","v":0},null,{"$f":"SUM(F35:K35)","v":0},null,"未就学児の合計月数",null,{"$f":"SUM(P30:P34)","v":0}]
[null,null,"子ども支援金分 (Ｒ８より追加)",null,null,null,null,null,null,null,null,null,null,"世帯年間保険料"]
[null,null,{"$f":"IF(設定シート!E3<=7,\"\",設定シート!C17)","v":"子育て支援分"},null,null,"加入者Ａ","加入者Ｂ","加入者Ｃ","加入者Ｄ","加入者E","旧被扶養者","合　計",null,{"$f":"加入者別年間保険料!J21","v":0}]
[null,null,null,null,null,{"$f":"IF(設定シート!E3<=7,0,IF(E5=0,0,IF(B5<=$M$57,ROUNDDOWN(P5*子ども支援金割合/100/12,0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59*$O$57),0),IF(B5>$M$58,IF(ROUNDDOWN((P5*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P5*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P5*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P5*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0))))))","v":0},{"$f":"IF(設定シート!E3<=7,0,IF(E7=0,0,IF(B7<=$M$57,ROUNDDOWN(P7*子ども支援金割合/100/12,0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59*$O$57),0),IF(B7>$M$58,IF(ROUNDDOWN((P7*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P7*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P7*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P7*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0))))))","v":0},{"$f":"IF(設定シート!E3<=7,0,IF(E9=0,0,IF(B9<=$M$57,ROUNDDOWN(P9*子ども支援金割合/100/12,0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59*$O$57),0),IF(B9>$M$58,IF(ROUNDDOWN((P9*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P9*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P9*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P9*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0))))))","v":0},{"$f":"IF(設定シート!E3<=7,0,IF(E11=0,0,IF(B11<=$M$57,ROUNDDOWN(P11*子ども支援金割合/100/12,0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59*$O$57),0),IF(B11>$M$58,IF(ROUNDDOWN((P11*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P11*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P11*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P11*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0))))))","v":0},{"$f":"IF(設定シート!E3<=7,0,IF(E13=0,0,IF(B13<=$M$57,ROUNDDOWN(P13*子ども支援金割合/100/12,0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59*$O$57),0),IF(B13>$M$58,IF(ROUNDDOWN((P13*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P13*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0)),IF(ROUNDDOWN((P13*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0)>子ども支援金限度額/12,子ども支援金限度額/12,ROUNDDOWN((P13*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$M$59),0))))))","v":0},{"$f":"ROUNDDOWN(COUNTIF($D$15,\"◎\")*(子ども支援金均等割/12)*$L$22*0.5+COUNTIF($D$15,\"×\")*(子ども支援金均等割/12)*$L$22,0)","v":0},{"$f":"IF(SUM(F38:K38)>=子ども支援金限度額/12,ROUNDDOWN(子ども支援金限度額/12,0),SUM(F38:K38))","v":0},{"$f":"IF(E13=0,0,IF(B13>$M$57,ROUNDDOWN((P13*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0),ROUNDDOWN((P13*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$O$57),0)))+IF(E5=0,0,IF(B5>$M$57,ROUNDDOWN((P5*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0),ROUNDDOWN((P5*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$O$57),0)))+IF(E7=0,0,IF(B7>$M$57,ROUNDDOWN((P7*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0),ROUNDDOWN((P7*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$O$57),0)))+IF(E9=0,0,IF(B9>$M$57,ROUNDDOWN((P9*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0),ROUNDDOWN((P9*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$O$57),0)))+IF(E11=0,0,IF(B11>$M$57,ROUNDDOWN((P11*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12),0),ROUNDDOWN((P11*子ども支援金割合/100/12),0)+ROUNDDOWN((子ども支援金均等割*$L$22/12*$O$57),0)))+ROUNDDOWN(IF($L$22>0.5,COUNTIF(D15:D15,\"◎\")*子ども支援金均等割/12*0.5+COUNTIF(D15:D15,\"×\")*子ども支援金均等割/12*$L$22,(COUNTA(D15:D15)*子ども支援金均等割/12*$L$22)),0)","v":0}]
[null,null,{"$f":"IF(M38>=L38,\"按分額\",\"\")","v":"按分額"},null,null,{"$f":"IF(設定シート!$E$3<=7,0,IF(ISBLANK(B5),0,IF($M$38>=ROUNDDOWN(子ども支援金限度額/12,0),IF(B5<=$M$57,ROUNDDOWN(($L$38-$P$27)*P5/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$O$57*$M$59,0),IF(AND(B5>$M$57,B5<=$M$58),ROUNDDOWN(($L$38-$P$27)*P5/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$M$59,0),IF(B5>$M$58,ROUNDDOWN(($L$38-$P$27)*P5/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12,0)))),0)))","v":0},{"$f":"IF(設定シート!$E$3<=7,0,IF(ISBLANK(B7),0,IF($M$38>=ROUNDDOWN(子ども支援金限度額/12,0),IF(B7<=$M$57,ROUNDDOWN(($L$38-$P$27)*P7/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$O$57*$M$59,0),IF(AND(B7>$M$57,B7<=$M$58),ROUNDDOWN(($L$38-$P$27)*P7/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$M$59,0),IF(B7>$M$58,ROUNDDOWN(($L$38-$P$27)*P7/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12,0)))),0)))","v":0},{"$f":"IF(設定シート!$E$3<=7,0,IF(ISBLANK(B9),0,IF($M$38>=ROUNDDOWN(子ども支援金限度額/12,0),IF(B9<=$M$57,ROUNDDOWN(($L$38-$P$27)*P9/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$O$57*$M$59,0),IF(AND(B9>$M$57,B9<=$M$58),ROUNDDOWN(($L$38-$P$27)*P9/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$M$59,0),IF(B9>$M$58,ROUNDDOWN(($L$38-$P$27)*P9/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12,0)))),0)))","v":0},{"$f":"IF(設定シート!$E$3<=7,0,IF(ISBLANK(B11),0,IF($M$38>=ROUNDDOWN(子ども支援金限度額/12,0),IF(B11<=$M$57,ROUNDDOWN(($L$38-$P$27)*P11/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$O$57*$M$59,0),IF(AND(B11>$M$57,B11<=$M$58),ROUNDDOWN(($L$38-$P$27)*P11/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$M$59,0),IF(B11>$M$58,ROUNDDOWN(($L$38-$P$27)*P11/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12,0)))),0)))","v":0},{"$f":"IF(設定シート!$E$3<=7,0,IF(ISBLANK(B13),0,IF($M$38>=ROUNDDOWN(子ども支援金限度額/12,0),IF(B13<=$M$57,ROUNDDOWN(($L$38-$P$27)*P13/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$O$57*$M$59,0),IF(AND(B13>$M$57,B13<=$M$58),ROUNDDOWN(($L$38-$P$27)*P13/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12*$M$59,0),IF(B13>$M$58,ROUNDDOWN(($L$38-$P$27)*P13/$P$17,0)+ROUNDDOWN(子ども支援金均等割/12,0)))),0)))","v":0},{"$f":"IF(設定シート!E3<=7,0,IF(設定シート!E18=0,0,IF($M$38>=ROUNDDOWN(子ども支援金限度額/12,0),IF(ISBLANK(B15),0,IF(B15<=$M$57,IF(P15=0,ROUNDDOWN(子ども支援金均等割/12*$O$57,0),($L$38-$P$27)*P15/$P$17+ROUNDDOWN(子ども支援金均等割/12*$O$57,0)),IF(P15=0,ROUNDDOWN(子ども支援金均等割/12,0),($L$38-$P$27)*P15/$P$17+ROUNDDOWN(子ども支援金均等割/12,0)))),0)))","v":0},{"$f":"SUM(F39:K39)","v":0}]
[]
[null,null,"合　計",null,null,"加入者Ａ","加入者Ｂ","加入者Ｃ","加入者Ｄ","加入者E","旧被扶養者","合　計"]
[null,null,null,null,null,{"$f":"F26+F30+F34+F38","v":0},{"$f":"G26+G30+G34+G38","v":0},0,0,0,0,{"$f":"L26+L30+L34+L38","v":0},{"$f":"M26+M30+M34+M38","v":0}]
[null,null,{"$f":"IF(M42>=L42,\"按分額\",\"\")","v":"按分額"},null,null,{"$f":"ROUNDDOWN(IF(F27=0,F26,F27)+IF(F31=0,F30,F31)+IF(F35=0,F34,F35)+IF(F39=0,F38,F39),0)","v":0},0,0,0,0,0,{"$f":"SUM(F43:K43)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"割合","均等割額","限度額","月額均等割額","月額限度額"]
[null,null,null,null,null,null,null,null,null,"医療給付費分",{"$f":"設定シート!$E$7","v":7.51},{"$f":"設定シート!$E$4","v":47600},{"$f":"設定シート!$E$10","v":670000},{"$f":"ROUNDDOWN(医療均等割/12,0)","v":3966},{"$f":"ROUNDDOWN(医療限度額/12,0)","v":55833}]
[null,null,null,null,null,null,null,null,null,"支援金分",{"$f":"設定シート!$E$8","v":2.8},{"$f":"設定シート!$E$5","v":17600},{"$f":"設定シート!$E$11","v":260000},{"$f":"ROUNDDOWN(支援金均等割/12,0)","v":1466},{"$f":"ROUNDDOWN(支援金限度額/12,0)","v":21666}]
[null,null,null,null,null,null,null,null,null,"介護分",{"$f":"設定シート!$E$9","v":2.4300000000000002},{"$f":"設定シート!$E$6","v":17800},{"$f":"設定シート!$E$12","v":170000},{"$f":"ROUNDDOWN(介護均等割/12,0)","v":1483},{"$f":"ROUNDDOWN(介護限度額/12,0)","v":14166}]
[null,null,null,null,null,null,null,null,null,"子育て支援分",{"$f":"設定シート!E19","v":0.27},{"$f":"設定シート!E18","v":1873},{"$f":"設定シート!E20","v":30000},{"$f":"ROUNDDOWN(子ども支援金均等割/12,0)","v":156},{"$f":"ROUNDDOWN(子ども支援金限度額/12,0)","v":2500}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K48:K51)","v":13.009999999999998},{"$f":"SUM(L48:L51)","v":84873},{"$f":"SUM(M48:M51)","v":1130000},null,{"$f":"SUM(O48:O51)","v":94165}]
[null,null,null,null,null,null,null,null,null,"政減判定 均等割減額加算額"]
[null,null,null,null,null,null,null,null,null,null,null,"5割減加算額",{"$f":"設定シート!$E$13","v":310000}]
[null,null,null,null,null,null,null,null,null,null,null,"2割減加算額",{"$f":"設定シート!$E$14","v":570000}]
[]
[null,null,null,null,null,null,null,null,{"$f":"設定シート!B15","v":"均等割減額対象年齢 (未就学児)"},null,null,null,{"$f":"設定シート!$E$15","v":6},{"$f":"設定シート!F15","v":"軽減割合"},{"$f":"1-設定シート!G15","v":0.5}]
[null,null,null,null,null,null,null,null,{"$f":"TRIM(設定シート!C17&\"均等割軽減対象外年齢\")","v":"子育て支援分均等割軽減対象外年齢"},null,null,null,{"$f":"設定シート!G17","v":18}]
[null,null,null,null,null,null,null,null,{"$f":"TRIM(設定シート!C17&\" 均等割 割合\")","v":"子育て支援分 均等割 割合"},null,null,null,{"$f":"1-設定シート!G18","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"保険料計算の方法!B37","v":0}]
[]
[]
[null,null,{"$f":"設定シート!$E$23-1","v":64},{"$f":"IF(ISBLANK(B69),0,B69-C69)","v":0}]
[null,null,{"$f":"設定シート!$E$23-1","v":64},{"$f":"IF(ISBLANK(B70),0,B70-C70)","v":0}]
[null,null,{"$f":"設定シート!$E$23-1","v":64},0]
[null,null,{"$f":"設定シート!$E$23-1","v":64},0]
[null,null,{"$f":"設定シート!$E$23-1","v":64},0]
[]
[]
[{"$f":"TRIM(\"★ 入力する収入および所得は、令和\"&設定シート!E3-1&\"年1月1日から令和\"&設定シート!E3-1&\"年12月31日までのものとなります。★\")","v":"★ 入力する収入および所得は、令和7年1月1日から令和7年12月31日までのものとなります。★"}]
[]
[null,null,null,null,"加入者ごとに下のコマンドボタンをクリックして資格を設定してください。"]
[]
[{"$f":"TRIM(設定シート!E22&\"歳以上\"&\" \"&設定シート!E23&\"歳未満\")","v":"40歳以上 65歳未満"}]
[]
[{"$f":"TRIM(\"39歳以下 または\"&\" \"&設定シート!E23&\"歳以上\")","v":"39歳以下 または 65歳以上"}]

{"sheet":"加入者別年間保険料","index":3,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[11,3,12,3],[9,9,10,9],[11,9,12,9],[13,9,14,9],[15,9,16,9],[7,10,7,13],[24,1,24,3],[21,1,21,3],[0,7,0,8],[17,1,18,1],[17,3,18,3],[13,3,14,3],[15,3,16,3],[17,9,18,9],[0,0,0,1],[2,8,2,9],[9,1,10,1],[11,1,12,1],[13,1,14,1],[15,1,16,1],[9,3,10,3]]}
[{"$f":"月額保険料計算シート!A1","v":"令和8年度"},null,"品川区国民健康保険料　　　各個人の年間保険料（１２か月加入の場合）",null,null,null,null,{"$f":"NOW()","v":"2026-02-25T10:01:51.800"}]
[null,null,null,null,null,null,null,null,"世帯政減割合",{"$f":"月額保険料計算シート!L22","v":0.3}]
[null,null,null,null,"均等割額（年）","所得割率（年）","限度額",null,"世帯合計均等割（12か月分）"]
[null,null,null,"医療",{"$f":"月額保険料計算シート!医療均等割","v":47600},{"$f":"月額保険料計算シート!医療割合","v":7.51},{"$f":"月額保険料計算シート!医療限度額","v":670000},null,"医療",{"$f":"COUNTIF(D10:D19,\"<=\"&月額保険料計算シート!$M$57)*E4*月額保険料計算シート!$O$57*$J$2+COUNTIF(D10:D19,\">\"&月額保険料計算シート!$M$57)*E4*$J$2+COUNTIF(C20,\"◎\")*E4*$J$2*0.5+COUNTIF(C20,\"×\")*E4*$J$2","v":0}]
[null,null,null,"支援金",{"$f":"月額保険料計算シート!支援金均等割","v":17600},{"$f":"月額保険料計算シート!支援金割合","v":2.8},{"$f":"月額保険料計算シート!支援金限度額","v":260000},null,"支援",{"$f":"COUNTIF(D10:D19,\"<=\"&月額保険料計算シート!$M$57)*E5*月額保険料計算シート!$O$57*$J$2+COUNTIF(D10:D19,\">\"&月額保険料計算シート!$M$57)*E5*$J$2+COUNTIF(C20,\"◎\")*E5*$J$2*0.5+COUNTIF(C20,\"×\")*E5*$J$2","v":0}]
[null,null,null,"介護",{"$f":"月額保険料計算シート!介護均等割","v":17800},{"$f":"月額保険料計算シート!介護割合","v":2.4300000000000002},{"$f":"月額保険料計算シート!介護限度額","v":170000},null,"介護",{"$f":"COUNTIFS(D10:D19,\">=\"&設定シート!$E$22,D10:D19,\"<\"&設定シート!$E$23)*E6*J2","v":0}]
[null,null,null,{"$f":"IF(設定シート!E3<=7,\"\",設定シート!C17)","v":"子育て支援分"},{"$f":"IF(設定シート!E3<=7,0,子ども支援金均等割)","v":1873},{"$f":"IF(設定シート!E3<=7,0,子ども支援金割合)","v":0.27},{"$f":"IF(設定シート!E3<=7,0,子ども支援金限度額)","v":30000},null,{"$f":"D7","v":"子育て支援分"},{"$f":"SUM(N10:N20)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(月額保険料計算シート!J22=\"政減対象外\",\"\",TRIM(月額保険料計算シート!$J$22&\"適用\"))","v":"均等割７割減適用"},null,null,"各個人の保険料の内の均等割額（再掲）"]
[null,null,null,"年齢","賦課基準額","医療分","後期高齢者\n支援金分","介護納付金分",{"$f":"IF(設定シート!E3<=7,\"\",TRIM(設定シート!C17))","v":"子育て支援分"},"合計","医療均等割","支援均等割","介護均等割",{"$f":"IF(設定シート!E3<=7,\"\",TRIM(設定シート!C17&\"均等割\"))","v":"子育て支援分均等割"}]
[null,"加入者A","按分前",{"$f":"IF(ISBLANK(月額保険料計算シート!B5),\"\",IF(月額保険料計算シート!D74=1,月額保険料計算シート!B5+1,月額保険料計算シート!B5))","v":""},{"$f":"月額保険料計算シート!P5","v":0},{"$f":"IF(ISNUMBER(F11),\"\",IF(AND(D10<=月額保険料計算シート!$M$57,E10=0),月額保険料計算シート!医療均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D10<=月額保険料計算シート!$M$57,(E10*$F$4/100+K10),IF(F11=\"\",IF(D10=\"\",0,IF(E10*$F$4/100+$E$4*$J$2>=$G$4,$G$4,E10*$F$4/100+$E$4*$J$2)),\"\"))))","v":0},{"$f":"IF(ISNUMBER(G11),\"\",IF(AND(D10<=月額保険料計算シート!$M$57,E10=0),月額保険料計算シート!支援金均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D10<=月額保険料計算シート!$M$57,(E10*$F$5/100+L10),IF(G11=\"\",IF(D10=\"\",0,IF(E10*$F$5/100+$E$5*$J$2>=$G$5,$G$5,E10*$F$5/100+$E$5*$J$2)),\"\"))))","v":0},{"$f":"IF(月額保険料計算シート!F34=0,\"\",IF(AND(D10<=月額保険料計算シート!$M$57,E10=0),\"\",IF(H11=\"\",IF(OR(D10=0,D10<設定シート!$E$22,D10>=設定シート!$E$23),0,IF(E10*$F$6/100+$E$6*$J$2>=$G$6,$G$6,E10*$F$6/100+$E$6*$J$2)),\"\")))","v":""},{"$f":"IF(D10=\"\",\"\",IF(ISNUMBER(I11),\"\",IF(IF(月額保険料計算シート!F38=0,\"\",IF(D10<=月額保険料計算シート!$M$57,E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D10<=月額保険料計算シート!$M$58,D10>月額保険料計算シート!$M$57),E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D10>月額保険料計算シート!$M$58,E10*$F$7/100+$E$7*$J$2))))>$G$7,$G$7,IF(月額保険料計算シート!F38=0,\"\",IF(D10<=月額保険料計算シート!$M$57,E10*$F$7/100+E7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D10<=月額保険料計算シート!$M$58,D10>月額保険料計算シート!$M$57),E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D10>月額保険料計算シート!$M$58,E10*$F$7/100+$E$7*$J$2)))))))","v":""},{"$f":"SUM(F10:I11)","v":0},{"$f":"COUNTIF(D10,\"<=\"&月額保険料計算シート!$M$57)*E4*月額保険料計算シート!$O$57*J2+COUNTIF(D10,\">\"&月額保険料計算シート!$M$57)*E4*J2","v":0},{"$f":"COUNTIF(D10,\"<=\"&月額保険料計算シート!$M$57)*E5*月額保険料計算シート!$O$57*J2+COUNTIF(D10,\">\"&月額保険料計算シート!$M$57)*E5*J2","v":0},{"$f":"(COUNTIF(D10,\"<\"&設定シート!$E$23)*COUNTIF(D10,\">=\"&設定シート!$E$22)*E6*J2)","v":0},{"$f":"IF(D10=\"\",0,IF(AND(D10<=設定シート!$G$17,D10<=月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59*月額保険料計算シート!$O$57,IF(AND(D10<=設定シート!$G$17,D10>月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59,IF(D10>設定シート!$G$17,$E$7*$J$2,0))))","v":0}]
[null,null,"按分後",null,null,{"$f":"IF(月額保険料計算シート!F27=0,\"\",IF(OR($E$10*$F$4/100+$E$4*$J$2>=$G$4,$E$12*$F$4/100+$E$4*$J$2>=$G$4,$E$14*$F$4/100+$E$4*$J$2>=$G$4,$E$16*$F$4/100+$E$4*$J$2>=$G$4,$E$18*$F$4/100+$E$4*$J$2>=$G$4,(($E$10*$F$4/100+$E$4*$J$2)+($E$12*$F$4/100+$E$4*$J$2)+($E$14*$F$4/100+$E$4*$J$2)+($E$16*$F$4/100+$E$4*$J$2)+($E$18*$F$4/100+$E$4*$J$2)>=$G$4)),K10+ROUNDDOWN((($G$4-$J$4)*E10/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!F31=0,\"\",IF(OR($E$10*$F$5/100+$E$5*$J$2>=$G$5,$E$12*$F$5/100+$E$5*$J$2>=$G$5,$E$14*$F$5/100+$E$5*$J$2>=$G$5,$E$16*$F$5/100+$E$5*$J$2>=$G$5,$E$18*$F$5/100+$E$5*$J$2>=$G$5,(($E$10*$F$5/100+$E$5*$J$2)+($E$12*$F$5/100+$E$5*$J$2)+($E$14*$F$5/100+$E$5*$J$2)+($E$16*$F$5/100+$E$5*$J$2)+($E$18*$F$5/100+$E$5*$J$2)>=$G$5)),L10+ROUNDDOWN((($G$5-$J$5)*E10/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!F35=0,\"\",IF(OR(D10=0,D10<設定シート!$E$22,D10>=設定シート!$E$23),0,IF(OR($E$10*$F$6/100+$E$6*$J$2>=$G$6,$E$12*$F$6/100+$E$6*$J$2>=$G$6,$E$14*$F$6/100+$E$6*$J$2>=$G$6,$E$16*$F$6/100+$E$6*$J$2>=$G$6,$E$18*$F$6/100+$E$6*$J$2>=$G$6,(($E$10*$F$6/100+$E$6*$J$2)+($E$12*$F$6/100+$E$6*$J$2)+($E$14*$F$6/100+$E$6*$J$2)+($E$16*$F$6/100+$E$6*$J$2)+($E$18*$F$6/100+$E$6*$J$2)>=$G$6)),M10+ROUNDDOWN((($G$6-$J$6)*E10/$E$22),0),\"\")))","v":""},{"$f":"IF((IF(月額保険料計算シート!F38=0,0,IF(D10<=月額保険料計算シート!$M$57,E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D10<=月額保険料計算シート!$M$58,D10>月額保険料計算シート!$M$57),E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D10>月額保険料計算シート!$M$58,E10*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!G38=0,0,IF(D12<=月額保険料計算シート!$M$57,E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D12<=月額保険料計算シート!$M$58,D12>月額保険料計算シート!$M$57),E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D12>月額保険料計算シート!$M$58,E12*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!H38=0,0,IF(D14<=月額保険料計算シート!$M$57,E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D14<=月額保険料計算シート!$M$58,D14>月額保険料計算シート!$M$57),E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D14>月額保険料計算シート!$M$58,E14*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!I38=0,0,IF(D16<=月額保険料計算シート!$M$57,E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D16<=月額保険料計算シート!$M$58,D16>月額保険料計算シート!$M$57),E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D16>月額保険料計算シート!$M$58,E16*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!J38=0,0,IF(D18<=月額保険料計算シート!$M$57,E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D18<=月額保険料計算シート!$M$58,D18>月額保険料計算シート!$M$57),E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D18>月額保険料計算シート!$M$58,E18*$F$7/100+$E$7*$J$2)))))>$G$7,ROUNDDOWN(($G$7-$J$7)*(E10/$E$21),0)+N10,\"\")","v":""}]
[null,"加入者B","按分前",{"$f":"IF(ISBLANK(月額保険料計算シート!B7),\"\",IF(月額保険料計算シート!D75=1,月額保険料計算シート!B7+1,月額保険料計算シート!B7))","v":""},{"$f":"月額保険料計算シート!P7","v":0},{"$f":"IF(ISNUMBER(F13),\"\",IF(AND(D12<=月額保険料計算シート!$M$57,E12=0),月額保険料計算シート!医療均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D12<=月額保険料計算シート!$M$57,(E12*$F$4/100+K12),IF(F13=\"\",IF(D12=\"\",0,IF(E12*$F$4/100+$E$4*$J$2>=$G$4,$G$4,E12*$F$4/100+$E$4*$J$2)),\"\"))))","v":0},{"$f":"IF(ISNUMBER(G13),\"\",IF(AND(D12<=月額保険料計算シート!$M$57,E12=0),月額保険料計算シート!支援金均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D12<=月額保険料計算シート!$M$57,(E12*$F$5/100+L12),IF(G13=\"\",IF(D12=\"\",0,IF(E12*$F$5/100+$E$5*$J$2>=$G$5,$G$5,E12*$F$5/100+$E$5*$J$2)),\"\"))))","v":0},{"$f":"IF(月額保険料計算シート!G34=0,\"\",IF(AND(D12<=月額保険料計算シート!$M$57,E12=0),\"\",IF(H13=\"\",IF(OR(D12=0,D12<設定シート!$E$22,D12>=設定シート!$E$23),0,IF(E12*$F$6/100+$E$6*$J$2>=$G$6,$G$6,E12*$F$6/100+$E$6*$J$2)),\"\")))","v":""},{"$f":"IF(D12=\"\",\"\",IF(ISNUMBER(I13),\"\",IF(IF(月額保険料計算シート!G38=0,\"\",IF(D12<=月額保険料計算シート!$M$57,E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D12<=月額保険料計算シート!$M$58,D12>月額保険料計算シート!$M$57),E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D12>月額保険料計算シート!$M$58,E12*$F$7/100+$E$7*$J$2))))>$G$7,$G$7,IF(月額保険料計算シート!G38=0,\"\",IF(D12<=月額保険料計算シート!$M$57,E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D12<=月額保険料計算シート!$M$58,D12>月額保険料計算シート!$M$57),E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D12>月額保険料計算シート!$M$58,E12*$F$7/100+$E$7*$J$2)))))))","v":""},{"$f":"SUM(F12:I13)","v":0},{"$f":"COUNTIF(D12,\"<=\"&月額保険料計算シート!$M$57)*E4*月額保険料計算シート!$O$57*J2+COUNTIF(D12,\">\"&月額保険料計算シート!$M$57)*E4*J2","v":0},{"$f":"COUNTIF(D12,\"<=\"&月額保険料計算シート!$M$57)*E5*月額保険料計算シート!$O$57*J2+COUNTIF(D12,\">\"&月額保険料計算シート!$M$57)*E5*J2","v":0},{"$f":"(COUNTIF(D12,\"<\"&設定シート!$E$23)*COUNTIF(D12,\">=\"&設定シート!$E$22)*E6*J2)","v":0},{"$f":"IF(D12=\"\",0,IF(AND(D12<=設定シート!$G$17,D12<=月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59*月額保険料計算シート!$O$57,IF(AND(D12<=設定シート!$G$17,D12>月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59,IF(D12>設定シート!$G$17,$E$7*$J$2,0))))","v":0}]
[null,null,"按分後",null,null,{"$f":"IF(月額保険料計算シート!G27=0,\"\",IF(OR($E$10*$F$4/100+$E$4*$J$2>=$G$4,$E$12*$F$4/100+$E$4*$J$2>=$G$4,$E$14*$F$4/100+$E$4*$J$2>=$G$4,$E$16*$F$4/100+$E$4*$J$2>=$G$4,$E$18*$F$4/100+$E$4*$J$2>=$G$4,(($E$10*$F$4/100+$E$4*$J$2)+($E$12*$F$4/100+$E$4*$J$2)+($E$14*$F$4/100+$E$4*$J$2)+($E$16*$F$4/100+$E$4*$J$2)+($E$18*$F$4/100+$E$4*$J$2)>=$G$4)),K12+ROUNDDOWN((($G$4-$J$4)*E12/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!G31=0,\"\",IF(OR($E$10*$F$5/100+$E$5*$J$2>=$G$5,$E$12*$F$5/100+$E$5*$J$2>=$G$5,$E$14*$F$5/100+$E$5*$J$2>=$G$5,$E$16*$F$5/100+$E$5*$J$2>=$G$5,$E$18*$F$5/100+$E$5*$J$2>=$G$5,(($E$10*$F$5/100+$E$5*$J$2)+($E$12*$F$5/100+$E$5*$J$2)+($E$14*$F$5/100+$E$5*$J$2)+($E$16*$F$5/100+$E$5*$J$2)+($E$18*$F$5/100+$E$5*$J$2)>=$G$5)),L12+ROUNDDOWN((($G$5-$J$5)*E12/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!G35=0,\"\",IF(OR(D12=0,D12<設定シート!$E$22,D12>=設定シート!$E$23),0,IF(OR($E$10*$F$6/100+$E$6*$J$2>=$G$6,$E$12*$F$6/100+$E$6*$J$2>=$G$6,$E$14*$F$6/100+$E$6*$J$2>=$G$6,$E$16*$F$6/100+$E$6*$J$2>=$G$6,$E$18*$F$6/100+$E$6*$J$2>=$G$6,(($E$10*$F$6/100+$E$6*$J$2)+($E$12*$F$6/100+$E$6*$J$2)+($E$14*$F$6/100+$E$6*$J$2)+($E$16*$F$6/100+$E$6*$J$2)+($E$18*$F$6/100+$E$6*$J$2)>=$G$6)),M12+ROUNDDOWN((($G$6-$J$6)*E12/$E$22),0),\"\")))","v":""},{"$f":"IF((IF(月額保険料計算シート!F38=0,0,IF(D10<=月額保険料計算シート!$M$57,E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D10<=月額保険料計算シート!$M$58,D10>月額保険料計算シート!$M$57),E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D10>月額保険料計算シート!$M$58,E10*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!G38=0,0,IF(D12<=月額保険料計算シート!$M$57,E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D12<=月額保険料計算シート!$M$58,D12>月額保険料計算シート!$M$57),E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D12>月額保険料計算シート!$M$58,E12*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!H38=0,0,IF(D14<=月額保険料計算シート!$M$57,E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D14<=月額保険料計算シート!$M$58,D14>月額保険料計算シート!$M$57),E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D14>月額保険料計算シート!$M$58,E14*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!I38=0,0,IF(D16<=月額保険料計算シート!$M$57,E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D16<=月額保険料計算シート!$M$58,D16>月額保険料計算シート!$M$57),E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D16>月額保険料計算シート!$M$58,E16*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!J38=0,0,IF(D18<=月額保険料計算シート!$M$57,E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D18<=月額保険料計算シート!$M$58,D18>月額保険料計算シート!$M$57),E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D18>月額保険料計算シート!$M$58,E18*$F$7/100+$E$7*$J$2)))))>$G$7,ROUNDDOWN(($G$7-$J$7)*(E12/$E$21),0)+N12,\"\")","v":""}]
[null,"加入者C","按分前",{"$f":"IF(ISBLANK(月額保険料計算シート!B9),\"\",IF(月額保険料計算シート!D76=1,月額保険料計算シート!B9+1,月額保険料計算シート!B9))","v":""},{"$f":"月額保険料計算シート!P9","v":0},{"$f":"IF(ISNUMBER(F15),\"\",IF(AND(D14<=月額保険料計算シート!$M$57,E14=0),月額保険料計算シート!医療均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D14<=月額保険料計算シート!$M$57,(E14*$F$4/100+K14),IF(F15=\"\",IF(D14=\"\",0,IF(E14*$F$4/100+$E$4*$J$2>=$G$4,$G$4,E14*$F$4/100+$E$4*$J$2)),\"\"))))","v":0},{"$f":"IF(ISNUMBER(G15),\"\",IF(AND(D14<=月額保険料計算シート!$M$57,E14=0),月額保険料計算シート!支援金均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D14<=月額保険料計算シート!$M$57,(E14*$F$5/100+L14),IF(G15=\"\",IF(D14=\"\",0,IF(E14*$F$5/100+$E$5*$J$2>=$G$5,$G$5,E14*$F$5/100+$E$5*$J$2)),\"\"))))","v":0},{"$f":"IF(月額保険料計算シート!H34=0,\"\",IF(AND(D14<=月額保険料計算シート!$M$57,E14=0),\"\",IF(H15=\"\",IF(OR(D14=0,D14<設定シート!$E$22,D14>=設定シート!$E$23),0,IF(E14*$F$6/100+$E$6*$J$2>=$G$6,$G$6,E14*$F$6/100+$E$6*$J$2)),\"\")))","v":""},{"$f":"IF(D14=\"\",\"\",IF(ISNUMBER(I15),\"\",IF(IF(月額保険料計算シート!H38=0,\"\",IF(D14<=月額保険料計算シート!$M$57,E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D14<=月額保険料計算シート!$M$58,D14>月額保険料計算シート!$M$57),E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D14>月額保険料計算シート!$M$58,E14*$F$7/100+$E$7*$J$2))))>$G$7,$G$7,IF(月額保険料計算シート!H38=0,\"\",IF(D14<=月額保険料計算シート!$M$57,E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D14<=月額保険料計算シート!$M$58,D14>月額保険料計算シート!$M$57),E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D14>月額保険料計算シート!$M$58,E14*$F$7/100+$E$7*$J$2)))))))","v":""},{"$f":"SUM(F14:I15)","v":0},{"$f":"COUNTIF(D14,\"<=\"&月額保険料計算シート!$M$57)*E4*月額保険料計算シート!$O$57*J2+COUNTIF(D14,\">\"&月額保険料計算シート!$M$57)*E4*J2","v":0},{"$f":"COUNTIF(D14,\"<=\"&月額保険料計算シート!$M$57)*E5*月額保険料計算シート!$O$57*J2+COUNTIF(D14,\">\"&月額保険料計算シート!$M$57)*E5*J2","v":0},{"$f":"(COUNTIF(D14,\"<\"&設定シート!$E$23)*COUNTIF(D14,\">=\"&設定シート!$E$22)*E6*J2)","v":0},{"$f":"IF(D14=\"\",0,IF(AND(D14<=設定シート!$G$17,D14<=月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59*月額保険料計算シート!$O$57,IF(AND(D14<=設定シート!$G$17,D14>月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59,IF(D14>設定シート!$G$17,$E$7*$J$2,0))))","v":0}]
[null,null,"按分後",null,null,{"$f":"IF(月額保険料計算シート!H27=0,\"\",IF(OR($E$10*$F$4/100+$E$4*$J$2>=$G$4,$E$12*$F$4/100+$E$4*$J$2>=$G$4,$E$14*$F$4/100+$E$4*$J$2>=$G$4,$E$16*$F$4/100+$E$4*$J$2>=$G$4,$E$18*$F$4/100+$E$4*$J$2>=$G$4,(($E$10*$F$4/100+$E$4*$J$2)+($E$12*$F$4/100+$E$4*$J$2)+($E$14*$F$4/100+$E$4*$J$2)+($E$16*$F$4/100+$E$4*$J$2)+($E$18*$F$4/100+$E$4*$J$2)>=$G$4)),K14+ROUNDDOWN((($G$4-$J$4)*E14/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!H31=0,\"\",IF(OR($E$10*$F$5/100+$E$5*$J$2>=$G$5,$E$12*$F$5/100+$E$5*$J$2>=$G$5,$E$14*$F$5/100+$E$5*$J$2>=$G$5,$E$16*$F$5/100+$E$5*$J$2>=$G$5,$E$18*$F$5/100+$E$5*$J$2>=$G$5,(($E$10*$F$5/100+$E$5*$J$2)+($E$12*$F$5/100+$E$5*$J$2)+($E$14*$F$5/100+$E$5*$J$2)+($E$16*$F$5/100+$E$5*$J$2)+($E$18*$F$5/100+$E$5*$J$2)>=$G$5)),L14+ROUNDDOWN((($G$5-$J$5)*E14/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!H35=0,\"\",IF(OR(D14=0,D14<設定シート!$E$22,D14>=設定シート!$E$23),0,IF(OR($E$10*$F$6/100+$E$6*$J$2>=$G$6,$E$12*$F$6/100+$E$6*$J$2>=$G$6,$E$14*$F$6/100+$E$6*$J$2>=$G$6,$E$16*$F$6/100+$E$6*$J$2>=$G$6,$E$18*$F$6/100+$E$6*$J$2>=$G$6,(($E$10*$F$6/100+$E$6*$J$2)+($E$12*$F$6/100+$E$6*$J$2)+($E$14*$F$6/100+$E$6*$J$2)+($E$16*$F$6/100+$E$6*$J$2)+($E$18*$F$6/100+$E$6*$J$2)>=$G$6)),M14+ROUNDDOWN((($G$6-$J$6)*E14/$E$22),0),\"\")))","v":""},{"$f":"IF((IF(月額保険料計算シート!F38=0,0,IF(D10<=月額保険料計算シート!$M$57,E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D10<=月額保険料計算シート!$M$58,D10>月額保険料計算シート!$M$57),E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D10>月額保険料計算シート!$M$58,E10*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!G38=0,0,IF(D12<=月額保険料計算シート!$M$57,E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D12<=月額保険料計算シート!$M$58,D12>月額保険料計算シート!$M$57),E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D12>月額保険料計算シート!$M$58,E12*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!H38=0,0,IF(D14<=月額保険料計算シート!$M$57,E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D14<=月額保険料計算シート!$M$58,D14>月額保険料計算シート!$M$57),E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D14>月額保険料計算シート!$M$58,E14*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!I38=0,0,IF(D16<=月額保険料計算シート!$M$57,E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D16<=月額保険料計算シート!$M$58,D16>月額保険料計算シート!$M$57),E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D16>月額保険料計算シート!$M$58,E16*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!J38=0,0,IF(D18<=月額保険料計算シート!$M$57,E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D18<=月額保険料計算シート!$M$58,D18>月額保険料計算シート!$M$57),E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D18>月額保険料計算シート!$M$58,E18*$F$7/100+$E$7*$J$2)))))>$G$7,ROUNDDOWN(($G$7-$J$7)*(E14/$E$21),0)+N14,\"\")","v":""}]
[null,"加入者D","按分前",{"$f":"IF(ISBLANK(月額保険料計算シート!B11),\"\",IF(月額保険料計算シート!D77=1,月額保険料計算シート!B11+1,月額保険料計算シート!B11))","v":""},{"$f":"月額保険料計算シート!P11","v":0},{"$f":"IF(ISNUMBER(F17),\"\",IF(AND(D16<=月額保険料計算シート!$M$57,E16=0),月額保険料計算シート!医療均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D16<=月額保険料計算シート!$M$57,(E16*$F$4/100+K16),IF(F17=\"\",IF(D16=\"\",0,IF(E16*$F$4/100+$E$4*$J$2>=$G$4,$G$4,E16*$F$4/100+$E$4*$J$2)),\"\"))))","v":0},{"$f":"IF(ISNUMBER(G17),\"\",IF(AND(D16<=月額保険料計算シート!$M$57,E16=0),月額保険料計算シート!支援金均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D16<=月額保険料計算シート!$M$57,(E16*$F$5/100+L16),IF(G17=\"\",IF(D16=\"\",0,IF(E16*$F$5/100+$E$5*$J$2>=$G$5,$G$5,E16*$F$5/100+$E$5*$J$2)),\"\"))))","v":0},{"$f":"IF(月額保険料計算シート!I34=0,\"\",IF(AND(D16<=月額保険料計算シート!$M$57,E16=0),\"\",IF(H17=\"\",IF(OR(D16=0,D16<設定シート!$E$22,D16>=設定シート!$E$23),0,IF(E16*$F$6/100+$E$6*$J$2>=$G$6,$G$6,E16*$F$6/100+$E$6*$J$2)),\"\")))","v":""},{"$f":"IF(D16=\"\",\"\",IF(ISNUMBER(I17),\"\",IF(IF(月額保険料計算シート!I38=0,\"\",IF(D16<=月額保険料計算シート!$M$57,E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D16<=月額保険料計算シート!$M$58,D16>月額保険料計算シート!$M$57),E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D16>月額保険料計算シート!$M$58,E16*$F$7/100+$E$7*$J$2))))>$G$7,$G$7,IF(月額保険料計算シート!I38=0,\"\",IF(D16<=月額保険料計算シート!$M$57,E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D16<=月額保険料計算シート!$M$58,D16>月額保険料計算シート!$M$57),E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D16>月額保険料計算シート!$M$58,E16*$F$7/100+$E$7*$J$2)))))))","v":""},{"$f":"SUM(F16:I17)","v":0},{"$f":"COUNTIF(D16,\"<=\"&月額保険料計算シート!$M$57)*E4*月額保険料計算シート!$O$57*J2+COUNTIF(D16,\">\"&月額保険料計算シート!$M$57)*E4*J2","v":0},{"$f":"COUNTIF(D16,\"<=\"&月額保険料計算シート!$M$57)*E5*月額保険料計算シート!$O$57*J2+COUNTIF(D16,\">\"&月額保険料計算シート!$M$57)*E5*J2","v":0},{"$f":"(COUNTIF(D16,\"<\"&設定シート!$E$23)*COUNTIF(D16,\">=\"&設定シート!$E$22)*E6*J2)","v":0},{"$f":"IF(D16=\"\",0,IF(AND(D16<=設定シート!$G$17,D16<=月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59*月額保険料計算シート!$O$57,IF(AND(D16<=設定シート!$G$17,D16>月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59,IF(D16>設定シート!$G$17,$E$7*$J$2,0))))","v":0}]
[null,null,"按分後",null,null,{"$f":"IF(月額保険料計算シート!I27=0,\"\",IF(OR($E$10*$F$4/100+$E$4*$J$2>=$G$4,$E$12*$F$4/100+$E$4*$J$2>=$G$4,$E$14*$F$4/100+$E$4*$J$2>=$G$4,$E$16*$F$4/100+$E$4*$J$2>=$G$4,$E$18*$F$4/100+$E$4*$J$2>=$G$4,(($E$10*$F$4/100+$E$4*$J$2)+($E$12*$F$4/100+$E$4*$J$2)+($E$14*$F$4/100+$E$4*$J$2)+($E$16*$F$4/100+$E$4*$J$2)+($E$18*$F$4/100+$E$4*$J$2)>=$G$4)),K16+ROUNDDOWN((($G$4-$J$4)*E16/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!I31=0,\"\",IF(OR($E$10*$F$5/100+$E$5*$J$2>=$G$5,$E$12*$F$5/100+$E$5*$J$2>=$G$5,$E$14*$F$5/100+$E$5*$J$2>=$G$5,$E$16*$F$5/100+$E$5*$J$2>=$G$5,$E$18*$F$5/100+$E$5*$J$2>=$G$5,(($E$10*$F$5/100+$E$5*$J$2)+($E$12*$F$5/100+$E$5*$J$2)+($E$14*$F$5/100+$E$5*$J$2)+($E$16*$F$5/100+$E$5*$J$2)+($E$18*$F$5/100+$E$5*$J$2)>=$G$5)),L16+ROUNDDOWN((($G$5-$J$5)*E16/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!I35=0,\"\",IF(OR(D16=0,D16<設定シート!$E$22,D16>=設定シート!$E$23),0,IF(OR($E$10*$F$6/100+$E$6*$J$2>=$G$6,$E$12*$F$6/100+$E$6*$J$2>=$G$6,$E$14*$F$6/100+$E$6*$J$2>=$G$6,$E$16*$F$6/100+$E$6*$J$2>=$G$6,$E$18*$F$6/100+$E$6*$J$2>=$G$6,(($E$10*$F$6/100+$E$6*$J$2)+($E$12*$F$6/100+$E$6*$J$2)+($E$14*$F$6/100+$E$6*$J$2)+($E$16*$F$6/100+$E$6*$J$2)+($E$18*$F$6/100+$E$6*$J$2)>=$G$6)),M16+ROUNDDOWN((($G$6-$J$6)*E16/$E$22),0),\"\")))","v":""},{"$f":"IF((IF(月額保険料計算シート!F38=0,0,IF(D10<=月額保険料計算シート!$M$57,E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D10<=月額保険料計算シート!$M$58,D10>月額保険料計算シート!$M$57),E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D10>月額保険料計算シート!$M$58,E10*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!G38=0,0,IF(D12<=月額保険料計算シート!$M$57,E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D12<=月額保険料計算シート!$M$58,D12>月額保険料計算シート!$M$57),E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D12>月額保険料計算シート!$M$58,E12*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!H38=0,0,IF(D14<=月額保険料計算シート!$M$57,E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D14<=月額保険料計算シート!$M$58,D14>月額保険料計算シート!$M$57),E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D14>月額保険料計算シート!$M$58,E14*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!I38=0,0,IF(D16<=月額保険料計算シート!$M$57,E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D16<=月額保険料計算シート!$M$58,D16>月額保険料計算シート!$M$57),E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D16>月額保険料計算シート!$M$58,E16*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!J38=0,0,IF(D18<=月額保険料計算シート!$M$57,E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D18<=月額保険料計算シート!$M$58,D18>月額保険料計算シート!$M$57),E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D18>月額保険料計算シート!$M$58,E18*$F$7/100+$E$7*$J$2)))))>$G$7,ROUNDDOWN(($G$7-$J$7)*(E16/$E$21),0)+N16,\"\")","v":""}]
[null,"加入者E","按分前",{"$f":"IF(ISBLANK(月額保険料計算シート!B13),\"\",IF(月額保険料計算シート!D78=1,月額保険料計算シート!B13+1,月額保険料計算シート!B13))","v":""},{"$f":"月額保険料計算シート!P13","v":0},{"$f":"IF(ISNUMBER(F19),\"\",IF(AND(D18<=月額保険料計算シート!$M$57,E18=0),月額保険料計算シート!医療均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D18<=月額保険料計算シート!$M$57,(E18*$F$4/100+K18),IF(F19=\"\",IF(D18=\"\",0,IF(E18*$F$4/100+$E$4*$J$2>=$G$4,$G$4,E18*$F$4/100+$E$4*$J$2)),\"\"))))","v":0},{"$f":"IF(ISNUMBER(G19),\"\",IF(AND(D18<=月額保険料計算シート!$M$57,E18=0),月額保険料計算シート!支援金均等割*月額保険料計算シート!$L$22*月額保険料計算シート!$O$57,IF(D18<=月額保険料計算シート!$M$57,(E18*$F$5/100+L18),IF(G19=\"\",IF(D18=\"\",0,IF(E18*$F$5/100+$E$5*$J$2>=$G$5,$G$5,E18*$F$5/100+$E$5*$J$2)),\"\"))))","v":0},{"$f":"IF(月額保険料計算シート!J34=0,\"\",IF(AND(D18<=月額保険料計算シート!$M$57,E18=0),\"\",IF(H19=\"\",IF(OR(D18=0,D18<設定シート!$E$22,D18>=設定シート!$E$23),0,IF(E18*$F$6/100+$E$6*$J$2>=$G$6,$G$6,E18*$F$6/100+$E$6*$J$2)),\"\")))","v":""},{"$f":"IF(D18=\"\",\"\",IF(ISNUMBER(I19),\"\",IF(IF(月額保険料計算シート!J38=0,\"\",IF(D18<=月額保険料計算シート!$M$57,E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D18<=月額保険料計算シート!$M$58,D18>月額保険料計算シート!$M$57),E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D18>月額保険料計算シート!$M$58,E18*$F$7/100+$E$7*$J$2))))>$G$7,$G$7,IF(月額保険料計算シート!J38=0,\"\",IF(D18<=月額保険料計算シート!$M$57,E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D18<=月額保険料計算シート!$M$58,D18>月額保険料計算シート!$M$57),E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D18>月額保険料計算シート!$M$58,E18*$F$7/100+$E$7*$J$2)))))))","v":""},{"$f":"SUM(F18:I19)","v":0},{"$f":"COUNTIF(D18,\"<=\"&月額保険料計算シート!$M$57)*E4*月額保険料計算シート!$O$57*J2+COUNTIF(D18,\">\"&月額保険料計算シート!$M$57)*E4*J2","v":0},{"$f":"COUNTIF(D18,\"<=\"&月額保険料計算シート!$M$57)*E5*月額保険料計算シート!$O$57*J2+COUNTIF(D18,\">\"&月額保険料計算シート!$M$57)*E5*J2","v":0},{"$f":"(COUNTIF(D18,\"<\"&設定シート!$E$23)*COUNTIF(D18,\">=\"&設定シート!$E$22)*E6*J2)","v":0},{"$f":"IF(D18=\"\",0,IF(AND(D18<=設定シート!$G$17,D18<=月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59*月額保険料計算シート!$O$57,IF(AND(D18<=設定シート!$G$17,D18>月額保険料計算シート!$M$57),$E$7*$J$2*月額保険料計算シート!$M$59,IF(D18>設定シート!$G$17,$E$7*$J$2,0))))","v":0}]
[null,null,"按分後",null,null,{"$f":"IF(月額保険料計算シート!J27=0,\"\",IF(OR($E$10*$F$4/100+$E$4*$J$2>=$G$4,$E$12*$F$4/100+$E$4*$J$2>=$G$4,$E$14*$F$4/100+$E$4*$J$2>=$G$4,$E$16*$F$4/100+$E$4*$J$2>=$G$4,$E$18*$F$4/100+$E$4*$J$2>=$G$4,(($E$10*$F$4/100+$E$4*$J$2)+($E$12*$F$4/100+$E$4*$J$2)+($E$14*$F$4/100+$E$4*$J$2)+($E$16*$F$4/100+$E$4*$J$2)+($E$18*$F$4/100+$E$4*$J$2)>=$G$4)),K18+ROUNDDOWN((($G$4-$J$4)*E18/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!J31=0,\"\",IF(OR($E$10*$F$5/100+$E$5*$J$2>=$G$5,$E$12*$F$5/100+$E$5*$J$2>=$G$5,$E$14*$F$5/100+$E$5*$J$2>=$G$5,$E$16*$F$5/100+$E$5*$J$2>=$G$5,$E$18*$F$5/100+$E$5*$J$2>=$G$5,(($E$10*$F$5/100+$E$5*$J$2)+($E$12*$F$5/100+$E$5*$J$2)+($E$14*$F$5/100+$E$5*$J$2)+($E$16*$F$5/100+$E$5*$J$2)+($E$18*$F$5/100+$E$5*$J$2)>=$G$5)),L18+ROUNDDOWN((($G$5-$J$5)*E18/$E$21),0),\"\"))","v":""},{"$f":"IF(月額保険料計算シート!J35=0,\"\",IF(OR(D18=0,D18<設定シート!$E$22,D18>=設定シート!$E$23),0,IF(OR($E$10*$F$6/100+$E$6*$J$2>=$G$6,$E$12*$F$6/100+$E$6*$J$2>=$G$6,$E$14*$F$6/100+$E$6*$J$2>=$G$6,$E$16*$F$6/100+$E$6*$J$2>=$G$6,$E$18*$F$6/100+$E$6*$J$2>=$G$6,(($E$10*$F$6/100+$E$6*$J$2)+($E$12*$F$6/100+$E$6*$J$2)+($E$14*$F$6/100+$E$6*$J$2)+($E$16*$F$6/100+$E$6*$J$2)+($E$18*$F$6/100+$E$6*$J$2)>=$G$6)),M18+ROUNDDOWN((($G$6-$J$6)*E18/$E$22),0),\"\")))","v":""},{"$f":"IF((IF(月額保険料計算シート!F38=0,0,IF(D10<=月額保険料計算シート!$M$57,E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D10<=月額保険料計算シート!$M$58,D10>月額保険料計算シート!$M$57),E10*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D10>月額保険料計算シート!$M$58,E10*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!G38=0,0,IF(D12<=月額保険料計算シート!$M$57,E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D12<=月額保険料計算シート!$M$58,D12>月額保険料計算シート!$M$57),E12*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D12>月額保険料計算シート!$M$58,E12*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!H38=0,0,IF(D14<=月額保険料計算シート!$M$57,E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D14<=月額保険料計算シート!$M$58,D14>月額保険料計算シート!$M$57),E14*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D14>月額保険料計算シート!$M$58,E14*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!I38=0,0,IF(D16<=月額保険料計算シート!$M$57,E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D16<=月額保険料計算シート!$M$58,D16>月額保険料計算シート!$M$57),E16*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D16>月額保険料計算シート!$M$58,E16*$F$7/100+$E$7*$J$2)))))+(IF(月額保険料計算シート!J38=0,0,IF(D18<=月額保険料計算シート!$M$57,E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$O$57*月額保険料計算シート!$M$59,IF(AND(D18<=月額保険料計算シート!$M$58,D18>月額保険料計算シート!$M$57),E18*$F$7/100+$E$7*$J$2*月額保険料計算シート!$M$59,IF(D18>月額保険料計算シート!$M$58,E18*$F$7/100+$E$7*$J$2)))))>$G$7,ROUNDDOWN(($G$7-$J$7)*(E18/$E$21),0)+N18,\"\")","v":""}]
[null,"旧被扶養者",{"$f":"IF(月額保険料計算シート!D15=\"\",\"\",月額保険料計算シート!D15)","v":""},{"$f":"IF(ISBLANK(月額保険料計算シート!B15),\"\",月額保険料計算シート!B15)","v":""},{"$f":"月額保険料計算シート!P15","v":0},{"$f":"IF(C20=\"\",\"\",IF($J$2=0.3,$E$4*0.3,IF(C20=\"◎\",$E$4*0.5,$E$4)))","v":""},{"$f":"IF(C20=\"\",\"\",IF($J$2=0.3,$E$5*0.3,IF(C20=\"◎\",$E$5*0.5,$E$5)))","v":""},null,{"$f":"IF(C20=\"\",\"\",IF($J$2=0.3,$E$7*0.3,IF(C20=\"◎\",$E$7*0.5,$E$7)))","v":""},{"$f":"SUM(F20:I20)","v":0},{"$f":"COUNTIF(C20,\"◎\")*E4*J2*0.5+COUNTIF(C20,\"×\")*E4*J2","v":0},{"$f":"COUNTIF(C20,\"◎\")*E5*J2*0.5+COUNTIF(C20,\"×\")*E5*J2","v":0},null,{"$f":"COUNTIF(C20,\"◎\")*E7*J2*0.5+COUNTIF(C20,\"×\")*E7*J2","v":0}]
[null,"合　計",null,null,{"$f":"E10+E12+E14+E16+E18","v":0},{"$f":"SUM(F10:F20)","v":0},{"$f":"SUM(G10:G20)","v":0},0,0,0]
[null,"介護用賦課基準額（世帯合計）",null,null,{"$f":"SUMIFS(E10:E19,D10:D19,\">=\"&設定シート!$E$22,D10:D19,\"<\"&設定シート!$E$23)","v":0}]
[null,null,"※　計算結果は概算ですので、数円程度の差異が生じる場合があります。"]
[null,null,{"$f":"TRIM(\"※　１月１日現在の年齢が\"&設定シート!E23-1&\"歳であっても加入時点で\"&設定シート!E23&\"歳の場合は、介護保険料は賦課されません。\")","v":"※　１月１日現在の年齢が64歳であっても加入時点で65歳の場合は、介護保険料は賦課されません。"}]
[null,{"$f":"IF(設定シート!E3>7,\"子育て支援賦課基準額（世帯合計）\",\"\")","v":"子育て支援賦課基準額（世帯合計）"},null,null,{"$f":"SUMIF(D10:D19,\">=\"&設定シート!$G$17,E10:E19)","v":0}]
[null,"↑　子育て支援金の対象が加入者の年齢で均等割対象外を除く場合は、この数値にすること。"]

{"sheet":"試算結果【提供用】","index":4,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":true,"merged":[[18,4,19,4],[20,4,21,4],[1,0,1,1],[8,0,9,0],[16,0,17,0],[12,4,13,4],[14,4,15,4],[16,4,17,4]]}
[{"$f":"TRIM(月額保険料計算シート!A1&\"保険料　　【月額】　　試算結果\")","v":"令和8年度保険料　【月額】　試算結果"}]
[{"$f":"NOW()","v":"2026-02-25T10:01:51.800"}]
["月額",null,null,null,"給与収入","給与所得","非自発","非自発所得","給与調整控除","年金収入","年金所得","年金特別控除","営業所得等","基礎控除","賦課基準額"]
["医療均等割額",{"$f":"ROUNDDOWN(月額保険料計算シート!医療均等割/12,0)","v":3966},null,"加入者A",5000000,3560000,null,3560000,null,null,0,0,null,430000,3130000]
[null,"●",null,"加入者B",null,0,null,0,null,null,0,0,null,0,0]
["支援金均等割額",{"$f":"ROUNDDOWN(月額保険料計算シート!支援金均等割/12,0)","v":1466},null,"加入者C",null,0,null,0,null,null,0,0,null,0,0]
[null,null,null,"加入者D",null,0,null,0,null,null,0,0,null,0,0]
["介護均等割額",{"$f":"ROUNDDOWN(月額保険料計算シート!介護均等割/12,0)","v":1483},null,"加入者E",null,0,null,0,null,null,0,0,null,0,0]
[{"$f":"IF(設定シート!E3<=7,\"\",TRIM(設定シート!C17&\"均等割額\"))","v":"子育て支援分均等割額"},null,null,"旧被扶",null,0,null,0,null,null,0,0,null,0,0]
[null,{"$f":"IF(設定シート!E3<=7,\"\",ROUNDDOWN([0]!子ども支援金均等割/12,0))","v":156},null,"合計",5000000,3560000,null,3560000,0,0,0,0,0,430000,3130000]
[]
["医療所得割率",{"$f":"TRIM(ROUNDDOWN(月額保険料計算シート!医療割合/12,3)&\"%\")","v":"0.625%"},null,null,null,"加入者Ａ","加入者Ｂ","加入者Ｃ","加入者Ｄ","加入者E","旧被扶養者","合　計"]
[null,null,null,null,"医療分",24051,0,0,0,0,0,24051]
["支援金所得割率",{"$f":"TRIM(ROUNDDOWN(月額保険料計算シート!支援金割合/12,3)&\"%\")","v":"0.233%"},null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,"支援分",8416,0,0,0,0,0,8416]
["介護所得割率",{"$f":"TRIM(ROUNDDOWN(月額保険料計算シート!介護割合/12,3)&\"%\")","v":"0.202%"},null,null,null,0,0,0,0,0,0,0]
[{"$f":"IF(設定シート!E3<=7,\"\",TRIM(設定シート!C17&\"所得割率\"))","v":"子育て支援分所得割率"},null,null,null,"介護分",7251,0,0,0,0,null,7251]
[null,{"$f":"IF(設定シート!E3<=7,\"\",TRIM(ROUNDDOWN([0]!子ども支援金割合/12,3)&\"%\"))","v":"0.022%"},null,null,null,0,0,0,0,0,null,0]
[null,null,null,null,"子育て支援分",2630,0,0,0,0,null,2630]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,"合計",42348,0,0,0,0,0,42348,"下段は按分後の数値"]
[null,null,null,null,null,42348,0,0,0,0,0,42348,"　※ 任意継続との比較金額"]
[null,null,null,null,null,"計算結果は目安であり、数円程度の差異が生じる場合があります。"]
[null,null,null,null,null,"★なお、同一世帯に既に国保加入者がいる場合は、計算結果が一致しない場合があります。"]
[]
[null,null,null,null,null,"　※ 令和８年度から「子ども・子育て支援金分」が追加されました。"]