{"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":105,"n_cols":48,"rows_kept":105,"cut":false,"hidden":true,"merged":[[61,9,61,10],[73,9,74,9],[71,9,72,9],[71,10,72,10],[71,11,72,11],[99,41,99,42],[71,17,71,18],[91,37,91,38],[91,35,91,36],[91,33,91,34],[91,31,91,32],[98,41,98,42],[94,31,94,32],[95,31,95,32]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,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,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,"６５歳から７４歳まで",6,null,null,null,null,null,null,"未就学児の均等割は、５割軽減を適用しています。"]
[null,null,null,null,null,null,null,null,null,"【保険料率】"]
[null,null,null,null,null,null,null,null,null,8,"平等割","均等割","所得割","限度額"]
[null,null,null,null,null,null,null,null,null,"医療分",33908,34990,9.5000000000000001E-2,660000]
[null,null,null,null,null,null,null,null,null,"支援金",10845,11191,3.0599999999999999E-2,260000]
[null,null,null,null,null,null,null,null,null,"介護分",0,18682,2.5999999999999999E-2,170000]
[null,null,null,null,null,null,null,null,null,"子ども分（18歳以上）",0,1841,2.8E-3,30000]
[null,null,null,null,null,null,null,null,null,"【軽減基準】"]
[null,null,null,null,null,null,null,null,null,null,null,310000,null,570000]
[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$45*(J47)+$K$74","v":740000},null,{"$f":"430000+$N$45*J47+$K$74","v":1000000}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"$K$47+$K$74","v":430000},1050000,null,1570000]
[null,null,null,null,null,null,null,null,null,3,{"$f":"$K$47+$K$74","v":430000},1360000,null,2140000]
[null,null,null,null,null,null,null,null,null,4,{"$f":"$K$47+$K$74","v":430000},1670000,null,2710000]
[null,null,null,null,null,null,null,null,null,5,{"$f":"$K$47+$K$74","v":430000},1980000,null,3280000]
[null,null,null,null,null,null,null,null,null,6,{"$f":"$K$47+$K$74","v":430000},2290000,null,3850000]
[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":"K47","v":430000},{"$f":"430000+$L$45*(J55)+$K$74","v":740000},null,{"$f":"430000+$N$45*J55+$K$74","v":1000000}]
[null,null,null,null,null,null,null,null,null,2,{"$f":"$K$47+$K$74","v":430000},1050000,null,1570000]
[null,null,null,null,null,null,null,null,null,3,{"$f":"$K$47+$K$74","v":430000},1360000,null,2140000]
[null,null,null,null,null,null,null,null,null,4,{"$f":"$K$47+$K$74","v":430000},1670000,null,2710000]
[null,null,null,null,null,null,null,null,null,5,{"$f":"$K$47+$K$74","v":430000},1980000,null,3280000]
[null,null,null,null,null,null,null,null,null,6,{"$f":"$K$47+$K$74","v":430000},2290000,null,3850000]
[null,null,null,null,null,null,null,null,null,null,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(Q64=1,\"世帯主なし\",\"世帯主あり\")","v":"世帯主なし"},null,null,"未就学児の軽減判定",{"$f":"IF(COUNTIF(Q64:Q69,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(Q64=1,\"0\",IF(Q64=2,\"0.5\",\"1\"))","v":"0"},{"$f":"IF(Q64=5,\"1\",\"0\")","v":"0"},{"$f":"IF(Q64=1,\"0\",IF(Q64>3,\"1\",\"0\"))","v":"0"},{"$f":"IF(Q64=1,\"0\",試算シート!D13)","v":"0"},{"$f":"IF(Q64=5,試算シート!D13,\"0\")","v":"0"},null,{"$f":"IF(Q64=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($Q64=1,\"0\",IF($Q64>=1,1))","v":"0"},{"$f":"IF(AND(K65=2,L65=1),\"1\",\"0\")","v":"0"},null,null,"加入者１",1,{"$f":"IF(Q65=1,\"0\",IF(Q65=2,\"0.5\",\"1\"))","v":"0"},"0",{"$f":"IF(Q65=1,\"0\",IF(Q65>3,\"1\",\"0\"))","v":"0"},{"$f":"IF(Q65=1,\"0\",試算シート!D14)","v":"0"},{"$f":"IF(Q65=5,試算シート!D14,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D14<=0,0,試算シート!D14)","v":0},null,{"$f":"IF(AND(AC65>=$Y$70,AC64<=$Y$70),\"○\",\"×\")","v":{"$error":"#N/A"}},0.3,{"$f":"VLOOKUP($X$70,INDIRECT($AC$62),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($Q65=1,\"0\",IF($Q65>=1,1))","v":"0"},"0",null,null,"加入者２",1,"0",{"$f":"IF(Q66=5,\"1\",\"0\")","v":"0"},{"$f":"IF(Q66=1,\"0\",IF(Q66>3,\"1\",\"0\"))","v":"0"},{"$f":"IF(Q66=1,\"0\",試算シート!D15)","v":"0"},{"$f":"IF(Q66=5,試算シート!D15,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D15<=0,0,試算シート!D15)","v":0},null,{"$f":"IF(AND(AC66>=$Y$70,AC65<=$Y$70),\"○\",\"×\")","v":{"$error":"#N/A"}},0.5,{"$f":"VLOOKUP($X$70,INDIRECT($AC$62),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",{"$f":"IF(Q67=5,\"1\",\"0\")","v":"0"},"0",{"$f":"IF(Q67=1,\"0\",試算シート!D16)","v":"0"},{"$f":"IF(Q67=5,試算シート!D16,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D16<=0,0,試算シート!D16)","v":0},null,{"$f":"IF(Y70>430000,IF(AND(AC67>=$Y$70,AC66<=$Y$70),\"○\",\"×\"),\"×\")","v":"×"},0.7,{"$f":"VLOOKUP($X$70,INDIRECT($AC$62),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","0",{"$f":"IF(Q68=1,\"0\",試算シート!D17)","v":"0"},{"$f":"IF(Q68=5,試算シート!D17,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D17<=0,0,試算シート!D17)","v":0},null,{"$f":"IF(AND(AC68>=$Y$70,AC67<=$Y$70),\"○\",\"×\")","v":{"$error":"#N/A"}},0.8,{"$f":"VLOOKUP($X$70,INDIRECT($AC$62),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","0",{"$f":"IF(Q69=1,\"0\",試算シート!D18)","v":"0"},{"$f":"IF(Q69=5,試算シート!D18,\"0\")","v":"0"},null,"0",{"$f":"IF(試算シート!D18<=0,0,試算シート!D18)","v":0},null,{"$f":"IF(AC69<Y70,\"○\",\"×\")","v":{"$error":"#N/A"}},1,{"$f":"VLOOKUP($X$70,INDIRECT($AC$62),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(S70>0,1,0)","v":0},{"$f":"R64+R65+R66+R67+R68+R69","v":0},{"$f":"S64+S65+S66+S67+S68+S69","v":0},{"$f":"T64+T65+T66+T67+T68+T69","v":0},null,null,null,{"$f":"$X$64+$X$65+$X$66+$X$67+$X$68+$X$69","v":0},{"$f":"SUM(Y64:Y69)","v":0}]
[null,null,null,null,null,null,null,null,null,"給与所得者等の合計",{"$f":"COUNTIF(M65:M70,\"1\")","v":0},"人"]
[null,null,null,null,null,null,null,null,null,"軽減判定時の合計\n（上記－１）",{"$f":"IF(K71=6,\"5\",IF(K71=5,\"4\",IF(K71=4,\"3\",IF(K71=3,\"2\",IF(K71=2,\"1\",IF(K71<=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$70=0,\"0\",ROUNDDOWN($K$40*VLOOKUP(\"○\",$AA$65:$AC$69,2,FALSE),0))","v":"0"},{"$f":"IF($R$70=0,\"0\",ROUNDDOWN(L40*VLOOKUP(\"○\",$AA$65:$AC$69,2,FALSE),0)*$R$70)","v":"0"},null,{"$f":"IF(U64-430000<=0,\"0\",ROUNDDOWN((U64-430000)*$M$40,0))","v":"0"},{"$f":"IF(SUM(Q73:T78)>$N$40,$N$40,SUM(Q73:T78))","v":0}]
[null,null,null,null,null,null,null,null,null,"１０万円×（給与所得者等の数－１）の結果",{"$f":"K72*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$70=0,\"0\",ROUNDDOWN($K$41*VLOOKUP(\"○\",$AA$65:$AC$69,2,FALSE),0))","v":"0"},{"$f":"IF($R$70=0,\"0\",ROUNDDOWN(L41*VLOOKUP(\"○\",$AA$65:$AC$69,2,FALSE),0)*$R$70)","v":"0"},null,{"$f":"IF(U64-430000<=0,\"0\",ROUNDDOWN((U64-430000)*$M$41,0))","v":"0"},{"$f":"IF(SUM(Q79:T84)>$N$41,$N$41,SUM(Q79:T84))","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$70=0,\"0\",ROUNDDOWN($K$42*VLOOKUP(\"○\",$AA$65:$AC$69,2,FALSE),0)*Q70)","v":"0"},null,{"$f":"IF(S70=0,\"0\",ROUNDDOWN(L42*VLOOKUP(\"○\",$AA$65:$AC$69,2,FALSE),0)*$S$70)","v":"0"},{"$f":"IF(V64-430000<=0,\"0\",ROUNDDOWN((V64-430000)*$M$42,0))","v":"0"},{"$f":"IF(SUM(Q85:T90)>$N$42,$N$42,SUM(Q85:T90))","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$70=0,\"0\",ROUNDDOWN($K$43*VLOOKUP(\"○\",$AA$65:$AC$69,2,FALSE),0)*Q70)","v":"0"},null,{"$f":"IF(T70=0,\"0\",ROUNDDOWN(L43*VLOOKUP(\"○\",$AA$65:$AC$69,2,FALSE),0)*$T$70)","v":"0"},{"$f":"IF(U64-430000<=0,\"0\",ROUNDDOWN((U64-430000)*$M$43,0))","v":"0"},{"$f":"IF(SUM(Q91:T96)>$N$43,$N$43,SUM(Q91:T96))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U65-430000<=0,\"0\",ROUNDDOWN((U65-430000)*$M$43,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,"0",null,null,null,null,null,null,null,null,null,null,"医療分保険料",{"$f":"Q73","v":"0"},"円",{"$f":"R73","v":"0"},"円",{"$f":"SUM(T73:T78)","v":0},"円",{"$f":"U73","v":0},"円","（660,000円）"]
[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,"後期高齢者支援金分保険料",{"$f":"Q79","v":"0"},"円",{"$f":"R79","v":"0"},"円",{"$f":"SUM(T79:T84)","v":0},"円",{"$f":"U79","v":0},"円","（260,000円）"]
[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,{"$f":"S85","v":"0"},"円",{"$f":"SUM(T85:T90)","v":0},"円",{"$f":"U85","v":0},"円","（170,000円）"]
[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,{"$f":"S91","v":"0"},"円",{"$f":"SUM(T91:T96)","v":0},"円",{"$f":"U91","v":0},"円","（30,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(AF93:AF94)","v":0},"円",{"$f":"SUM(AH93:AH96)","v":0},"円",{"$f":"SUM(AJ93:AJ96)","v":0},"円",{"$f":"SUM(AL93:AL96)","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":"AL93+AL94+AL95+AL96","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(AS100>0,\"約\",\" \")","v":" "},{"$f":"ROUNDDOWN(AS99/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$70=0,\"\",IF(VLOOKUP(\"○\",$AA$65:$AD$69,4,FALSE)=0,\"\",(VLOOKUP(\"○\",$AA$65:$AD$69,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$70=0,\"\",IF(OR(AG62=\"無\",VLOOKUP(\"○\",$AA$65:$AG$69,7,FALSE)=0),\"\",(VLOOKUP(\"○\",$AA$65:$AG$69,7,FALSE))))","v":""}]