{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["試算表"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"試算表","index":0,"n_rows":52,"n_cols":41,"rows_kept":52,"cut":false,"hidden":false,"merged":[[27,25,49,44],[25,25,26,44],[6,25,24,44],[50,25,51,38],[50,40,51,44],[6,14,6,17],[7,14,7,17],[8,14,8,17],[5,18,5,21],[6,18,6,21],[7,18,7,21],[8,18,8,21],[9,18,9,21],[10,18,10,21],[11,18,11,21],[12,14,12,17],[31,19,31,21],[26,22,27,22],[15,22,16,22],[21,16,22,21],[26,16,27,21],[21,22,22,22],[18,22,19,22],[18,16,19,21],[12,18,12,21],[10,2,10,10],[11,2,11,10],[9,11,9,12],[15,16,16,21],[9,14,9,17],[10,14,10,17],[11,14,11,17],[3,1,4,1],[3,2,4,10],[3,14,4,17],[3,18,4,22],[3,11,4,13],[5,14,5,17],[8,2,8,10],[5,2,5,10],[7,11,7,12],[5,11,5,12],[7,2,7,10],[6,2,6,10],[6,11,6,12],[8,11,8,12],[11,11,11,12],[18,1,19,3],[9,2,9,10],[18,5,19,9],[15,1,16,3],[12,2,12,10],[26,4,27,4],[12,11,12,12],[26,10,27,10],[26,1,27,3],[15,4,16,4],[21,10,22,14],[26,14,27,14],[18,10,19,10],[15,10,16,10],[29,22,30,22],[39,19,39,21],[32,16,33,21],[29,16,30,21],[40,16,41,21],[0,1,0,45],[48,15,49,15],[48,16,49,21],[48,22,49,22],[43,16,44,21],[43,15,44,15],[43,22,44,22],[40,15,41,15],[37,15,38,15],[1,1,1,22],[37,16,38,21],[32,22,33,22],[37,22,38,22],[15,5,16,9],[29,10,30,10],[29,1,30,3],[37,1,38,3],[26,15,27,15],[10,11,10,12],[40,1,41,3],[40,5,41,9],[48,1,52,5],[37,11,38,12],[37,4,38,4],[4,25,5,44],[32,15,33,15],[29,15,30,15],[51,16,52,21],[51,7,52,9],[51,15,52,15],[51,10,52,14],[40,10,41,10],[40,11,41,12],[42,19,42,21],[51,22,52,22],[26,5,27,9],[37,5,38,9],[37,10,38,10],[32,10,33,14],[29,11,30,12],[37,14,38,14],[20,19,20,21],[40,22,41,22],[29,5,30,9],[48,10,49,14],[26,11,27,12],[21,15,22,15],[15,11,16,12],[18,11,19,12],[15,15,16,15],[48,7,49,9],[43,10,44,14],[15,14,16,14],[18,15,19,15]]}
[null,"令和6年度 豊島区 国民健康保険料の試算シート"]
[null,"下表の　　　　　欄を入力してください"]
[]
[null,null,"氏名",null,null,null,null,null,null,null,null,"年齢",null,null,"総所得金額等\n（X)",null,null,null,"算定基礎額\n（X-430,000）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"試算にあたっての注意\n【必ずお読みになり、同意のうえご利用ください】"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L6>39,L6<65),1,\" \")","v":" "},null,null,null,null,{"$f":"IF(O6<=430000,\"0\",O6-430000)","v":"0"}]
[null,2,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,{"$f":"IF(O7<=430000,\"0\",O7-430000)","v":"0"},null,null,null,null,null,null,"□本シートで計算された保険料は、概算です。\n　　実際の保険料と異なる場合があります。\n　　（実際の保険料は令和6年1月1日の住民登録地に申告されて\n　　　いる総所得金額等をもとに計算されるため）\n□本シートで計算された保険料は、1年間（4月から翌年3月まで）\n　　加入した場合の金額となります。\n□実際の保険料のお支払いは、6月から翌年3月までの10回払いです。\n　　1期あたりの保険料は、本シートでの「月単価」とは異なります。\n□均等割額の減額措置には、本シートは対応しておりません。\n□以下の条件に該当するかたが世帯にいらっしゃる場合は、正確な保険\n　　料が算出されない場合があります。\n　　①年度の途中で国民健康保険に加入・脱退されたかた\n　　②年度の途中で40歳・65歳・75歳になる（なった）かた\n　　③分離課税・繰越控除等の申告をされたかた\n　　④専従者控除または専従者給与のあるかた\n　　⑤非自発的失業にかかる軽減措置に該当するかた"]
[null,3,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"0"]
[null,4,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"0"]
[null,5,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"0"]
[null,6,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"0"]
[null,7,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"0"]
[null,null,"世帯合計",null,null,null,null,null,null,null,null,{"$f":"COUNT(L6:M12)","v":0},null,"名",{"$f":"IF(COUNT(L6:M12)=0,\" \",SUM(O6:R12))","v":" "},null,null,null,{"$f":"IF(COUNT(L6:M12)=0,\" \",SUM(S6:W12))","v":" "}]
[]
[null,"■医療分",null,null,null,"所得割算定基礎額（世帯合計）"]
[null,"所得割額",null,null,null,{"$f":"$S$13","v":" "},null,null,null,null,"×",8.69,null,null,"％","＝",{"$f":"IF(COUNT($L$6:$L$12)=0,0,ROUNDDOWN(F16*L16/100,0))","v":0},null,null,null,null,null,"A"]
[]
[]
[null,"均等割額",null,null,null,49100,null,null,null,null,"×",{"$f":"COUNTA($L$6:$L$12)","v":0},{"$f":"COUNTA($D$8:$D$18)","v":0},null,null,"＝",{"$f":"IF(COUNT($L$6:$L$12)=0,0,F19*L19)","v":0},null,null,null,null,null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA($D$8:$D$18)","v":0},{"$f":"COUNTA($D$8:$D$18)","v":0},null,"人"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※限度額",null,null,650000]
[null,null,null,null,null,null,null,null,null,null,"A+B",null,null,null,null,"＝",{"$f":"IF(COUNT(L6:M12)=0,0,IF((Q16+Q19)<=T21,(Q16+Q19),T21))","v":0},{"$f":"IF((27600*$D22+$F22*0.68)<=470000,(27600*$D22+$F22*0.68),470000)","v":0},0,0,0,0,"①"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((27600*$D23+$F23*0.68)<=470000,(27600*$D23+$F23*0.68),470000)","v":0},0,0,0,0,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,null,{"$f":"$S$13","v":" "},null,null,null,null,"×",2.8,null,null,"％","＝",{"$f":"IF(COUNT($L$6:$L$12)=0,0,ROUNDDOWN(F27*L27/100,0))","v":0},null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"□算定基礎額：所得割額を計算する際に用いるものです。\n　「総所得金額等ー基礎控除額（430,000円）」で算出します。\n　※総所得金額等 ： 令和5年分給与所得の源泉徴収票の場合\n　　→「給与所得控除後の金額」　確定申告書の場合→「所得金額の合計」\n　　の欄をご覧ください。年金収入のみの場合は、お問い合わせください。\n□「医療分」「後期支援金分」：加入者全員に賦課されます。\n□「介護分」： 40歳から64歳までのかたに賦課されます。\n□年間保険料（④）： 令和6年4月～令和7年3月までの分です。\n□月単価（⑤）： 年間保険料を単純に12ヶ月で割ったものです。\n　※その年の途中で加入した人の保険料は、\n　　「（加入月から3月までの月数）×月単価」となります。\n　※社会保険等を離脱し、任意継続等との比較をする場合は、\n     この月単価で比較してください。"]
[]
[null,"均等割額",null,null,null,16500,null,null,null,null,"×",{"$f":"COUNTA($L$6:$L$12)","v":0},{"$f":"COUNTA($D$8:$D$18)","v":0},null,null,"＝",{"$f":"IF(COUNT($L$6:$L$12)=0,0,F30*L30)","v":0},null,null,null,null,null,"D"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA($D$8:$D$18)","v":0},{"$f":"COUNTA($D$8:$D$18)","v":0},null,"人"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※限度額",null,null,240000]
[null,null,null,null,null,null,null,null,null,null,"C+D",null,null,null,null,"＝",{"$f":"IF(COUNT(L6:M12)=0,0,IF((Q27+Q30)<=T32,(Q27+Q30),T32))","v":0},{"$f":"IF((27600*$D33+$F33*0.68)<=470000,(27600*$D33+$F33*0.68),470000)","v":0},0,0,0,0,"②"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((27600*$D34+$F34*0.68)<=470000,(27600*$D34+$F34*0.68),470000)","v":0},0,0,0,0,0]
[]
[]
[null,"■介護分",null,null,null,"所得割算定基礎額\n（世帯合計）"]
[null,"所得割額",null,null,null,{"$f":"SUMIF($N$6:$N$12,\"1\",$S$6:$W$12)","v":0},{"$f":"SUMIF(F7:F17,\"=1\",G7:G17)","v":0},0,0,0,"×",2.36,null,null,"％","＝",{"$f":"IF(COUNT($L$6:$L$12)=0,0,ROUNDDOWN(F38*L38/100,0))","v":0},null,null,null,null,null,"E"]
[null,null,null,null,null,{"$f":"SUMIF(E8:E18,\"=1\",F8:F18)","v":0},0,0,0,0]
[]
[null,"均等割額",null,null,null,16500,null,null,null,null,"×",{"$f":"IF(COUNTIF($N$6:$N$12,\"1\")=0,\"0\",(COUNTIF($N$6:$N$12,\"1\")))","v":"0"},{"$f":"COUNTIF(N13:N20,\"=1\")","v":0},null,null,"＝",{"$f":"IF(COUNT($N$6:$N$12)=0,0,F41*L41)","v":0},null,null,null,null,null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(M15:M21,\"=1\")","v":0},{"$f":"COUNTIF(N15:N21,\"=1\")","v":0},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,"E+F",null,null,null,null,"＝",{"$f":"IF(COUNT(L6:M12)=0,0,IF((Q38+Q41)<=T43,(Q38+Q41),T43))","v":0},{"$f":"IF((27600*$D44+$F44*0.68)<=470000,(27600*$D44+$F44*0.68),470000)","v":0},0,0,0,0,"③"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((27600*$D45+$F45*0.68)<=470000,(27600*$D45+$F45*0.68),470000)","v":0},0,0,0,0,0]
[]
[]
[]
[null,"令和6年度　　\n保険料 概算　　",null,null,null,null,null,"年　間",null,null,"①+②+③",null,null,null,null,"＝",{"$f":"IF(Q22+Q33+Q44<0,0,Q22+Q33+Q44)","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,null,null,null,null,"問合せ先：豊島区国民健康保険課資格・保険料グループ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03-4566-2377"]
[null,null,null,null,null,null,null,"月単価",null,null,"④÷12月",null,null,null,null,"≒",{"$f":"Q49/12","v":0},null,null,null,null,null,"⑤"]