{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["試算シート","元データ"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":3,"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":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[19,8,19,11],[1,0,1,7],[3,0,3,7],[11,3,11,4],[11,5,11,6],[12,5,12,6]]}
[]
["令和７年度年間保険料の試算シート"]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[null,null,"①年齢区分","②総所得金額",null,"③給与所得者等区分"]
[null,"世帯主","39歳",null,"円"]
[null,"加入者１",null,null,"円"]
[null,"加入者２",null,null,"円"]
[null,"加入者３",null,null,"円"]
[null,"加入者４",null,null,"円"]
[null,"加入者５",null,null,"円"]

{"sheet":"元データ","index":1,"n_rows":102,"n_cols":48,"rows_kept":102,"cut":false,"hidden":true,"merged":[[96,41,96,42],[69,17,69,18],[89,37,89,38],[89,35,89,36],[89,33,89,34],[89,31,89,32],[95,41,95,42],[92,31,92,32],[59,9,59,10],[71,9,72,9],[69,9,70,9],[69,10,70,10],[69,11,70,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"～加入しない～",1,null,"平等割と均等割は、７割軽減を適用しています。",null,null,null,null,"未就学児の均等割は、さらに１.５割の軽減を適用しています。"]
[null,null,null,null,null,null,null,null,null,"未就学児",2]
[null,null,null,null,null,null,null,null,null,"小学生から３９歳まで",3,null,"平等割と均等割は、５割軽減を適用しています。",null,null,null,null,"未就学児の均等割は、さらに２.５割の軽減を適用しています。"]
[null,null,null,null,null,null,null,null,null,"４０歳から６４歳まで",4]
[null,null,null,null,null,null,null,null,null,"６５歳から７４歳まで",5,null,"平等割と均等割は、２割軽減を適用しています。",null,null,null,null,"未就学児の均等割は、さらに４割の軽減を適用しています。"]
[null,null,null,null,null,null,null,null,null,"【保険料率】",null,null,null,null,null,null,null,"未就学児の均等割は、５割軽減を適用しています。"]
[null,null,null,null,null,null,null,null,null,7,"平等割","均等割","所得割","限度額"]
[null,null,null,null,null,null,null,null,null,"医療分",33574,34424,9.2999999999999999E-2,650000]
[null,null,null,null,null,null,null,null,null,"支援金",10761,11034,3.0200000000000001E-2,240000]
[null,null,null,null,null,null,null,null,null,"介護分",0,18784,2.5600000000000001E-2,170000]
[null,null,null,null,null,null,null,null,null,"【軽減基準】"]
[null,null,null,null,null,null,null,null,null,null,null,305000,null,560000]
[null,null,null,null,null,null,null,null,null,null,"7割軽減","5割軽減","3割軽減","2割軽減"]
[null,null,null,null,null,null,null,null,null,1,430000,{"$f":"430000+$L$43*(J45)+$K$72","v":735000},null,{"$f":"430000+$N$43*J45+$K$72","v":990000}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"$K$45+$K$72","v":430000},{"$f":"430000+$L$43*(J46)+$K$72","v":1040000},null,1550000]
[null,null,null,null,null,null,null,null,null,3,{"$f":"$K$45+$K$72","v":430000},1345000,null,2110000]
[null,null,null,null,null,null,null,null,null,4,{"$f":"$K$45+$K$72","v":430000},1650000,null,2670000]
[null,null,null,null,null,null,null,null,null,5,{"$f":"$K$45+$K$72","v":430000},1955000,null,3230000]
[null,null,null,null,null,null,null,null,null,6,{"$f":"$K$45+$K$72","v":430000},2260000,null,3790000]
[null,null,null,null,null,null,null,null,null,"【軽減基準：世帯主未加入用】"]
[null,null,null,null,null,null,null,null,null,null,"7割軽減","5割軽減","3割軽減","2割軽減"]
[null,null,null,null,null,null,null,null,null,1,{"$f":"K45","v":430000},{"$f":"430000+$L$43*(J53)+$K$72","v":735000},null,{"$f":"430000+$N$43*J53+$K$72","v":990000}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"$K$45+$K$72","v":430000},1040000,null,1550000]
[null,null,null,null,null,null,null,null,null,3,{"$f":"$K$45+$K$72","v":430000},1345000,null,2110000]
[null,null,null,null,null,null,null,null,null,4,{"$f":"$K$45+$K$72","v":430000},1650000,null,2670000]
[null,null,null,null,null,null,null,null,null,5,{"$f":"$K$45+$K$72","v":430000},1955000,null,3230000]
[null,null,null,null,null,null,null,null,null,6,{"$f":"$K$45+$K$72","v":430000},2260000,null,3790000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コンボボックスからの取得数値変換ツール"]
[null,null,null,null,null,null,null,null,null,"【令和３年度保険料より】所得金額調整控除に対応するための数式",null,null,null,null,null,null,"ｺﾝﾎﾞﾎﾞｯｸｽ","医・支","介護","医・支","介護",null,"軽減判定用",null,null,null,"軽減表の判定",{"$f":"IF(Q62=1,\"世帯主なし\",\"世帯主あり\")","v":"世帯主なし"},null,null,"未就学児の軽減判定",{"$f":"IF(COUNTIF(Q62:Q67,2)>0,\"有\",\"無\")","v":"無"}]
[null,null,null,null,null,null,null,null,null,"【選択文言】",null,null,null,null,null,null,"リンク先","均等割用","均等割用","所得割用","所得割用",null,"人数判定","所得判定",null,"軽減判定ツール"]
[null,null,null,null,null,null,null,null,null,"給与所得者等区分","該当フラグ\n(2=該当）","加入フラグ\n（1=加入）","該当あり＋加入ありフラグ（１）\n（給与所得者等に含める）\n",null,null,"世帯主",1,{"$f":"IF(Q62=1,\"0\",IF(Q62=2,\"0.5\",\"1\"))","v":"0"},{"$f":"IF(Q62=4,\"1\",\"0\")","v":"0"},{"$f":"IF(Q62=1,\"0\",試算シート!D13)","v":"0"},{"$f":"IF(Q62=4,試算シート!D13,\"0\")","v":"0"},null,{"$f":"IF(Q62=1,\"0\",\"1\")","v":"0"},{"$f":"IF(試算シート!D13<=0,0,試算シート!D13)","v":0},null,null,null,0]
[null,null,null,null,null,null,null,null,null,"～該当しない～",1,{"$f":"IF($Q62=1,\"0\",IF($Q62>=1,1))","v":"0"},{"$f":"IF(AND(K63=2,L63=1),\"1\",\"0\")","v":"0"},null,null,"加入者１",1,{"$f":"IF(Q63=1,\"0\",IF(Q63=2,\"0.5\",\"1\"))","v":"0"},"0",{"$f":"IF(Q63=1,\"0\",試算シート!D14)","v":"0"},{"$f":"IF(Q63=4,試算シート!D14,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D14<=0,0,試算シート!D14)","v":0},null,{"$f":"IF(AND(AB63>=$X$68,AB62<=$X$68),\"○\",\"×\")","v":{"$error":"#N/A"}},0.3,{"$f":"VLOOKUP($W$68,INDIRECT($AB$60),2,FALSE)","v":{"$error":"#N/A"}},{"$f":"M32","v":"平等割と均等割は、７割軽減を適用しています。"},null,null,{"$f":"R32","v":"未就学児の均等割は、さらに１.５割の軽減を適用しています。"}]
[null,null,null,null,null,null,null,null,null,"～該当する～",1,{"$f":"IF($Q63=1,\"0\",IF($Q63>=1,1))","v":"0"},{"$f":"IF(AND(K64=2,L64=1),\"1\",\"0\")","v":"0"},null,null,"加入者２",1,"0","0",{"$f":"IF(Q64=1,\"0\",試算シート!D15)","v":"0"},{"$f":"IF(Q64=4,試算シート!D15,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D15<=0,0,試算シート!D15)","v":0},null,{"$f":"IF(AND(AB64>=$X$68,AB63<=$X$68),\"○\",\"×\")","v":{"$error":"#N/A"}},0.5,{"$f":"VLOOKUP($W$68,INDIRECT($AB$60),3,FALSE)","v":{"$error":"#N/A"}},{"$f":"M34","v":"平等割と均等割は、５割軽減を適用しています。"},null,null,{"$f":"R34","v":"未就学児の均等割は、さらに２.５割の軽減を適用しています。"}]
[null,null,null,null,null,null,null,null,null,null,1,"0","0",null,null,"加入者３",1,"0","0",{"$f":"IF(Q65=1,\"0\",試算シート!D16)","v":"0"},{"$f":"IF(Q65=4,試算シート!D16,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D16<=0,0,試算シート!D16)","v":0},null,{"$f":"IF(X68>430000,IF(AND(AB65>=$X$68,AB64<=$X$68),\"○\",\"×\"),\"×\")","v":"×"},0.7,{"$f":"VLOOKUP($W$68,INDIRECT($AB$60),4,FALSE)","v":{"$error":"#N/A"}},{"$f":"M35","v":0},null,null,{"$f":"R35","v":0}]
[null,null,null,null,null,null,null,null,null,null,1,"0","0",null,null,"加入者４",1,"0","0",{"$f":"IF(Q66=1,\"0\",試算シート!D17)","v":"0"},{"$f":"IF(Q66=4,試算シート!D17,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D17<=0,0,試算シート!D17)","v":0},null,{"$f":"IF(AND(AB66>=$X$68,AB65<=$X$68),\"○\",\"×\")","v":{"$error":"#N/A"}},0.8,{"$f":"VLOOKUP($W$68,INDIRECT($AB$60),5,FALSE)","v":{"$error":"#N/A"}},{"$f":"M36","v":"平等割と均等割は、２割軽減を適用しています。"},null,null,{"$f":"R36","v":"未就学児の均等割は、さらに４割の軽減を適用しています。"}]
[null,null,null,null,null,null,null,null,null,null,1,"0","0",null,null,"加入者５",1,"0","0",{"$f":"IF(Q67=1,\"0\",試算シート!D18)","v":"0"},{"$f":"IF(Q67=4,試算シート!D18,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D18<=0,0,試算シート!D18)","v":0},null,{"$f":"IF(AB67<X68,\"○\",\"×\")","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP($W$68,INDIRECT($AB$60),5,FALSE)","v":{"$error":"#N/A"}},0,null,null,{"$f":"R37","v":"未就学児の均等割は、５割軽減を適用しています。"}]
[null,null,null,null,null,null,null,null,null,null,1,"0","0",null,null,"介護平等割用→",{"$f":"IF(S68>0,1,0)","v":0},{"$f":"R62+R63+R64+R65+R66+R67","v":0},{"$f":"S62+S63+S64+S65+S66+S67","v":0},null,null,null,{"$f":"$W$62+$W$63+$W$64+$W$65+$W$66+$W$67","v":0},{"$f":"SUM(X62:X67)","v":0}]
[null,null,null,null,null,null,null,null,null,"給与所得者等の合計",{"$f":"COUNTIF(M63:M68,\"1\")","v":0},"人"]
[null,null,null,null,null,null,null,null,null,"軽減判定時の合計\n（上記－１）",{"$f":"IF(K69=6,\"5\",IF(K69=5,\"4\",IF(K69=4,\"3\",IF(K69=3,\"2\",IF(K69=2,\"1\",IF(K69<=1,\"0\"))))))","v":"0"},"人",null,null,null,null,"平等割","均等割",null,"所得割","合計"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"医療分",{"$f":"IF($R$68=0,\"0\",ROUNDDOWN($K$39*VLOOKUP(\"○\",$Z$63:$AB$67,2,FALSE),0))","v":"0"},{"$f":"IF($R$68=0,\"0\",ROUNDDOWN(L39*VLOOKUP(\"○\",$Z$63:$AB$67,2,FALSE),0)*$R$68)","v":"0"},null,{"$f":"IF(T62-430000<=0,\"0\",ROUNDDOWN((T62-430000)*$M$39,0))","v":"0"},{"$f":"IF(SUM(Q71:T76)>$N$39,$N$39,SUM(Q71:T76))","v":0}]
[null,null,null,null,null,null,null,null,null,"１０万円×（給与所得者等の数－１）の結果",{"$f":"K70*100000","v":0},null,null,null,null,null,null,null,null,"0"]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,"0"]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,"0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支援金分",{"$f":"IF($R$68=0,\"0\",ROUNDDOWN($K$40*VLOOKUP(\"○\",$Z$63:$AB$67,2,FALSE),0))","v":"0"},{"$f":"IF($R$68=0,\"0\",ROUNDDOWN(L40*VLOOKUP(\"○\",$Z$63:$AB$67,2,FALSE),0)*$R$68)","v":"0"},null,{"$f":"IF(T62-430000<=0,\"0\",ROUNDDOWN((T62-430000)*$M$40,0))","v":"0"},{"$f":"IF(SUM(Q77:T82)>$N$40,$N$40,SUM(Q77:T82))","v":0}]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,"0"]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,"0"]
[null,null,null,null,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,null,null,null,null,null,"介護分",{"$f":"IF($Q$68=0,\"0\",ROUNDDOWN($K$41*VLOOKUP(\"○\",$Z$63:$AB$67,2,FALSE),0)*Q68)","v":"0"},null,{"$f":"IF(S68=0,\"0\",ROUNDDOWN(L41*VLOOKUP(\"○\",$Z$63:$AB$67,2,FALSE),0)*$S$68)","v":"0"},{"$f":"IF(U62-430000<=0,\"0\",ROUNDDOWN((U62-430000)*$M$41,0))","v":"0"},{"$f":"IF(SUM(Q83:T88)>$N$41,$N$41,SUM(Q83:T88))","v":0}]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,"0"]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,"0"]
[null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"平等割",null,"均等割",null,"所得割",null,"合計額",null,"（最高限度額）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"医療分保険料",{"$f":"Q71","v":"0"},"円",{"$f":"R71","v":"0"},"円",{"$f":"SUM(T71:T76)","v":0},"円",{"$f":"U71","v":0},"円","（650,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,null,null,null,null,null,"後期高齢者支援金分保険料",{"$f":"Q77","v":"0"},"円",{"$f":"R77","v":"0"},"円",{"$f":"SUM(T77:T82)","v":0},"円",{"$f":"U77","v":0},"円","（240,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,null,null,null,null,null,"介護分保険料",null,null,{"$f":"S83","v":"0"},"円",{"$f":"SUM(T83:T88)","v":0},"円",{"$f":"U83","v":0},"円","（170,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,null,null,null,null,null,"合計",{"$f":"SUM(AF91:AF92)","v":0},"円",{"$f":"SUM(AH91:AH93)","v":0},"円",{"$f":"SUM(AJ91:AJ93)","v":0},"円",{"$f":"SUM(AL91:AL93)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年間国民健康保険料",null,null,{"$f":"AL91+AL92+AL93","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,{"$f":"IF(AS97>0,\"約\",\" \")","v":" "},{"$f":"ROUNDDOWN(AS96/12,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,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,{"$f":"IF($R$68=0,\"\",IF(VLOOKUP(\"○\",$Z$63:$AC$67,4,FALSE)=0,\"\",(VLOOKUP(\"○\",$Z$63:$AC$67,4,FALSE))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"IF($R$68=0,\"\",IF(OR(AF60=\"無\",VLOOKUP(\"○\",$Z$63:$AF$67,7,FALSE)=0),\"\",(VLOOKUP(\"○\",$Z$63:$AF$67,7,FALSE))))","v":""}]