{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["試算表利用時の注意点","保険料の概要","保険料の詳細","保険料計算","パラメーター"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":11,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"保険料の概要","index":1,"n_rows":35,"n_cols":40,"rows_kept":35,"cut":false,"hidden":true,"merged":[[29,14,29,20],[29,23,29,29],[4,5,4,38],[5,5,6,38],[21,32,21,39],[23,32,23,38],[25,32,25,38],[23,23,23,29],[25,23,25,29],[22,14,22,21],[18,7,18,13],[21,14,21,21],[23,14,23,20],[21,23,21,30],[7,5,7,12],[8,7,8,13],[22,23,22,30],[24,23,24,30],[26,23,26,30],[7,23,7,29],[14,7,14,13],[16,7,16,13],[27,23,27,29],[28,5,28,12],[28,14,28,20],[28,23,28,29],[24,14,24,21],[26,14,26,21],[25,14,25,20],[27,14,27,20],[22,32,22,38],[24,32,24,38],[26,32,26,38],[27,32,27,38],[29,32,29,38],[28,32,28,38],[2,33,2,37],[5,1,6,3],[16,24,16,28],[12,32,12,36],[14,16,14,20],[8,24,8,28],[14,24,14,28],[14,32,14,36],[16,32,16,36],[10,7,10,13],[12,7,12,13],[16,16,16,20],[10,16,10,20],[7,15,7,21],[7,31,7,37],[12,16,12,20],[34,33,34,38],[31,5,31,10],[31,12,31,17],[31,19,31,24],[31,26,31,31],[31,33,31,39],[32,5,32,9],[32,12,32,16],[32,19,32,23],[32,26,32,30],[32,33,32,38],[21,1,21,4],[21,5,21,12],[23,1,23,4],[22,5,22,12],[24,5,24,12],[23,5,23,11],[32,1,32,4],[27,1,27,4],[25,1,25,4],[26,5,26,12],[27,5,27,11],[25,5,25,11],[29,1,29,4],[29,5,29,11],[18,32,18,36],[18,16,18,20],[8,32,8,36],[10,24,10,28],[10,32,10,36],[8,16,8,20],[12,24,12,28],[18,24,18,28]]}
[]
[]
[null,null,null,null,null,null,null,null,null,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":"TODAY()","v":"2026-06-10"}]
[]
[null,"年齢区分",null,null,null,"「加入しない」、又は加入される方の年齢区分「未就学児」、「小学生から高校生世代まで」、「１８歳から３９歳まで」、「４０歳から６４歳まで」、「６５歳から７４歳まで」を選択して下さい。"]
[null,"収入額等",null,null,null,"年齢区分選択後、色のかわったセルに給与収入額、年金収入額、その他所得額を入力して下さい。\n収入額については、各種控除前の金額を入力して下さい。\nその他所得額については、営業所得、不動産所得等の合計額を入力して下さい。\n世帯主については、「加入しない」の場合でも必ず収入額等を入力して下さい。\n（※世帯主とは住民票上の世帯主のことをいいます。）"]
[]
[null,null,null,null,null,"年齢区分",null,null,null,null,null,null,null,null,null,{"$f":"DBCS(パラメーター!E11-1)&\"年中の給与収入額\"","v":"７年中の給与収入額"},null,null,null,null,null,null,null,{"$f":"DBCS(パラメーター!E11-1)&\"年中の年金収入額\"","v":"７年中の年金収入額"},null,null,null,null,null,null,null,{"$f":"DBCS(パラメーター!E11-1)&\"年中のその他所得額\"","v":"７年中のその他所得額"}]
[null,"世帯主",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3328058,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者１",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者２",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者３",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,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,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者５",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[]
[null,"区分",null,null,null,"医療分",null,null,null,null,null,null,null,null,"支援分",null,null,null,null,null,null,null,null,"介護分",null,null,null,null,null,null,null,null,"子ども分"]
[null,null,null,null,null,"=",null,null,null,null,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":"保険料の詳細!Q11","v":138244},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q29","v":56389},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q47","v":0},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q64","v":5093},null,null,null,null,null,null,"円"]
[null,null,null,null,null,"＋",null,null,null,null,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":"保険料の詳細!Q16","v":30259},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q34","v":12252},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q52","v":0},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q69","v":1157},null,null,null,null,null,null,"円"]
[null,null,null,null,null,"＋",null,null,null,null,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":"保険料の詳細!Q19","v":18723},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q37","v":7581},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q54","v":0},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q73","v":716},null,null,null,null,null,null,"円"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"＋"]
[null,"18歳以上\n均等割",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"保険料の詳細!Q75","v":59},null,null,null,null,null,null,"円"]
[]
[null,null,null,null,null,{"$f":"パラメーター!A6&TEXT(パラメーター!B6/10000,\"#,##万円\")","v":"賦課限度額67万円"},null,null,null,null,null,null,{"$f":"パラメーター!A11&TEXT(パラメーター!B11/10000,\"#,##万円\")","v":"賦課限度額26万円"},null,null,null,null,null,null,{"$f":"パラメーター!A16&TEXT(パラメーター!B16/10000,\"#,##万円\")","v":"賦課限度額17万円"},null,null,null,null,null,null,{"$f":"パラメーター!A22&TEXT(パラメーター!B22/10000,\"#,##万円\")","v":"賦課限度額3万円"},null,null,null,null,null,null,"年間保険料"]
[null,"合計額",null,null,null,{"$f":"IF(F24+F26+F28>=パラメーター!B6,パラメーター!B6,F24+F26+F28)","v":187226},null,null,null,null,"円","+",{"$f":"IF(O24+O26+O28>=パラメーター!B11,パラメーター!B11,O24+O26+O28)","v":76222},null,null,null,null,"円","+",{"$f":"IF(X24+X26+X28>=パラメーター!B16,パラメーター!B16,X24+X26+X28)","v":0},null,null,null,null,"円","+",{"$f":"IF(AG24+AG26+AG28+AG30>=パラメーター!B22,パラメーター!B22,AG24+AG26+AG28+AG30)","v":7025},null,null,null,null,"円","=",{"$f":"保険料の詳細!Q80","v":270473},null,null,null,null,null,"円"]
[]
[null,{"$f":"IF(保険料計算!G21=0,\"\",\"均等割と平等割が\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(保険料計算!G21=0,\"\",保険料計算!G22)","v":""},null,{"$f":"IF(保険料計算!G21=0,\"\",\"軽減されています\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1ヶ月あたりの保険料",null,{"$f":"保険料の詳細!Q82","v":22539.416666666668},null,null,null,null,null,"円"]

{"sheet":"保険料の詳細","index":2,"n_rows":82,"n_cols":19,"rows_kept":82,"cut":false,"hidden":true,"merged":[[53,17,54,18],[54,13,54,14],[81,16,81,19],[55,9,55,12],[77,8,77,9],[77,13,77,14],[79,16,79,19],[80,8,80,9],[80,13,80,14],[59,9,60,9],[59,10,60,10],[59,11,60,11],[59,12,60,12],[59,13,60,13],[61,11,66,11],[61,13,66,13],[63,16,64,16],[71,13,71,14],[61,14,66,15],[53,13,53,14],[63,17,64,18],[68,13,68,14],[69,13,69,14],[70,13,70,14],[46,16,47,16],[46,17,47,18],[51,3,52,3],[51,13,51,14],[51,16,52,16],[51,17,52,18],[52,13,52,14],[44,11,49,11],[42,3,50,3],[42,5,43,5],[42,13,43,13],[44,13,49,13],[36,16,37,16],[36,17,37,18],[37,13,37,14],[38,9,38,12],[42,10,43,10],[42,11,43,11],[42,6,43,6],[42,7,43,7],[42,8,43,8],[42,9,43,9],[42,12,43,12],[28,16,29,16],[18,17,19,18],[19,13,19,14],[28,17,29,18],[18,16,19,16],[33,3,35,3],[33,13,33,14],[33,16,35,16],[33,17,35,18],[35,13,35,14],[34,13,34,14],[26,11,31,11],[24,3,32,3],[26,13,31,13],[24,6,25,6],[3,3,4,3],[21,3,22,3],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,3,14,3],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[15,3,17,3],[18,3,19,3],[59,8,60,8],[68,3,71,3],[68,15,71,15],[68,16,71,16],[68,17,71,18],[53,16,54,16],[6,13,7,13],[8,13,13,13],[8,11,13,11],[20,9,20,12],[24,10,25,10],[24,11,25,11],[24,7,25,7],[24,8,25,8],[24,5,25,5],[39,3,40,3],[10,16,11,16],[10,17,11,18],[15,13,15,14],[15,16,17,16],[15,17,17,18],[17,13,17,14],[16,13,16,14],[18,13,18,14],[76,9,76,12],[74,3,75,3],[74,13,74,14],[74,16,75,16],[74,17,75,18],[75,13,75,14],[74,15,75,15],[72,3,73,3],[72,13,72,14],[72,16,73,16],[72,17,73,18],[73,13,73,14],[72,15,73,15],[61,12,66,12],[56,3,57,3],[8,12,13,12],[8,14,13,15],[18,15,19,15],[26,12,31,12],[26,14,31,15],[15,15,17,15],[33,15,35,15],[36,15,37,15],[44,12,49,12],[44,14,49,15],[51,15,52,15],[53,15,54,15],[24,9,25,9],[24,12,25,12],[24,13,25,13],[36,3,37,3],[36,13,36,14],[53,3,54,3],[59,3,67,3],[59,5,60,5],[59,6,60,6],[59,7,60,7]]}
[]
[]
[]
[null,null,null,"医療分"]
[]
[null,null,null,null,null,null,null,"※総所得金額が43万円未満の方の基礎控除額は，総所得金額と同額となります。"]
[null,null,null,"所得割",null,"総所得金額","－","※基礎控除額(43万円）","＝","算出所得\n（千円未満切捨て）",null,"算出所得合計","×","所得割料率"]
[]
[null,null,null,null,"世帯主",{"$f":"IF(保険料計算!C2=1,\"\",IF(保険料計算!D2=0,\"\",保険料計算!E2))","v":2249600},"－",{"$f":"IF(F9=\"\",\"\",IF(F9<=保険料計算!F2,F9,430000))","v":430000},"＝",{"$f":"IF(F9=\"\",\"\",IF(F9=0,\"\",ROUNDDOWN(F9-H9,-3)))","v":1819000},null,{"$f":"SUM(J9:J14)","v":1819000},"×",{"$f":"パラメーター!B5","v":7.5999999999999998E-2},"＝"]
[null,null,null,null,"加入者1",{"$f":"IF(保険料計算!C3=1,\"\",保険料計算!E3)","v":""},"－",{"$f":"IF(F10=\"\",\"\",IF(F10<=保険料計算!F2,F10,430000))","v":""},"＝",""]
[null,null,null,null,"加入者2",{"$f":"IF(保険料計算!C4=1,\"\",保険料計算!E4)","v":""},"－",{"$f":"IF(F11=\"\",\"\",IF(F11<=保険料計算!F2,F11,430000))","v":""},"＝","",null,null,null,null,null,null,{"$f":"ROUNDDOWN(L9*N9,0)","v":138244},"…　(ア)"]
[null,null,null,null,"加入者3",{"$f":"IF(保険料計算!C5=1,\"\",保険料計算!E5)","v":""},"－",{"$f":"IF(F12=\"\",\"\",IF(F12<=保険料計算!F2,F12,430000))","v":""},"＝",""]
[null,null,null,null,"加入者4",{"$f":"IF(保険料計算!C6=1,\"\",保険料計算!E6)","v":""},"－",{"$f":"IF(F13=\"\",\"\",IF(F13<=保険料計算!F2,F13,430000))","v":""},"＝",""]
[null,null,null,null,"加入者5",{"$f":"IF(保険料計算!C8=1,\"\",保険料計算!E7)","v":0},"－",{"$f":"IF(F14=\"\",\"\",IF(F14<=保険料計算!F2,F14,430000))","v":0},"＝",""]
[]
[null,null,null,"均等割",null,null,null,"1人につき",null,{"$f":"パラメーター!B3","v":30259},"×",{"$f":"保険料計算!L2","v":1},"＝",{"$f":"J16*L16","v":30259},null,"＝",{"$f":"N16-SUM(N17:O18)","v":30259},"…　(イ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G21=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G21=0,\"\",保険料計算!G22)","v":""},null,{"$f":"IF(保険料計算!G21=0,\"\",保険料計算!I21)","v":""},{"$f":"IF(保険料計算!G21=0,\"\",\"×\")","v":""},{"$f":"IF(保険料計算!G21=0,\"\",保険料計算!L2)","v":""},{"$f":"IF(保険料計算!G21=0,\"\",\"=\")","v":""},{"$f":"IF(保険料計算!G21=0,\"\",J17*L17)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G2=0,\"\",\"子ども軽減\")","v":""},null,null,{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!N21)","v":""},{"$f":"IF(保険料計算!G2=0,\"\",\"×\")","v":""},{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!G2)","v":""},{"$f":"IF(保険料計算!G2=0,\"\",\"=\")","v":""},{"$f":"IF(保険料計算!G2=0,\"\",J18*L18)","v":""}]
[null,null,null,"平等割",null,null,null,"1世帯につき",null,{"$f":"パラメーター!B4","v":18723},null,null,null,{"$f":"IF(保険料計算!L2=0,\"\",パラメーター!B4)","v":18723},null,"＝",{"$f":"N19-SUM(N20)","v":18723},"…　(ウ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G21=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G21=0,\"\",保険料計算!G22)","v":""},null,{"$f":"IF(保険料計算!G21=0,\"\",保険料計算!J21)","v":""},null,null,null,{"$f":"J20","v":""}]
[null,null,null," 医療分の保険料 (ア)＋(イ)＋(ウ)",null,null,{"$f":"パラメーター!A6&TEXT(パラメーター!B6/10000,\"#,###万円\")&\"まで\"","v":"賦課限度額67万円まで"},null,null,{"$f":"IF(Q11+Q16+Q19>パラメーター!B6,パラメーター!B6,Q11+Q16+Q19)","v":187226},null,null,null,null,null,null,null,null,"　…　①"]
[null,null,null,"支援分"]
[]
[null,null,null,null,null,null,null,"※総所得金額が43万円未満の方の基礎控除額は，総所得金額と同額となります。"]
[null,null,null,"所得割",null,"総所得金額","－","※基礎控除額(43万円）","＝","算出所得\n（千円未満切捨て）",null,"算出所得合計","×","所得割料率"]
[]
[null,null,null,null,"世帯主",{"$f":"IF(保険料計算!C2=1,\"\",IF(保険料計算!D2=0,\"\",保険料計算!E2))","v":2249600},"－",{"$f":"IF(F27=\"\",\"\",IF(F27<=保険料計算!$F$2,F27,430000))","v":430000},"＝",{"$f":"IF(F27=\"\",\"\",IF(F27=0,\"\",ROUNDDOWN(F27-H27,-3)))","v":1819000},null,{"$f":"SUM(J27:J32)","v":1819000},"×",{"$f":"パラメーター!B10","v":3.1E-2},"＝"]
[null,null,null,null,"加入者1",{"$f":"IF(保険料計算!C3=1,\"\",保険料計算!E3)","v":""},"－",{"$f":"IF(F28=\"\",\"\",IF(F28<=保険料計算!$F$2,F28,430000))","v":""},"＝",{"$f":"IF(F10=\"\",\"\",IF(F28=0,\"\",ROUNDDOWN(F28-H28,-3)))","v":""}]
[null,null,null,null,"加入者2",{"$f":"IF(保険料計算!C4=1,\"\",保険料計算!E4)","v":""},"－",{"$f":"IF(F29=\"\",\"\",IF(F29<=保険料計算!$F$2,F29,430000))","v":""},"＝",{"$f":"IF(F11=\"\",\"\",IF(F29=0,\"\",ROUNDDOWN(F29-H29,-3)))","v":""},null,null,null,null,null,null,{"$f":"ROUNDDOWN(L27*N27,0)","v":56389},"…　(ア)"]
[null,null,null,null,"加入者3",{"$f":"IF(保険料計算!C5=1,\"\",保険料計算!E5)","v":""},"－",{"$f":"IF(F30=\"\",\"\",IF(F30<=保険料計算!$F$2,F30,430000))","v":""},"＝",{"$f":"IF(F12=\"\",\"\",IF(F30=0,\"\",ROUNDDOWN(F30-H30,-3)))","v":""}]
[null,null,null,null,"加入者4",{"$f":"IF(保険料計算!C6=1,\"\",保険料計算!E6)","v":""},"－",{"$f":"IF(F31=\"\",\"\",IF(F31<=保険料計算!$F$2,F31,430000))","v":""},"＝",{"$f":"IF(F13=\"\",\"\",IF(F31=0,\"\",ROUNDDOWN(F31-H31,-3)))","v":""}]
[null,null,null,null,"加入者5",{"$f":"IF(保険料計算!C8=1,\"\",保険料計算!E7)","v":0},"－",{"$f":"IF(F32=\"\",\"\",IF(F32<=保険料計算!$F$2,F32,430000))","v":0},"＝",{"$f":"IF(F14=\"\",\"\",IF(F32=0,\"\",ROUNDDOWN(F32-H32,-3)))","v":""}]
[]
[null,null,null,"均等割",null,null,null,"1人につき",null,{"$f":"パラメーター!B8","v":12252},"×",{"$f":"保険料計算!L2","v":1},"＝",{"$f":"J34*L34","v":12252},null,"＝",{"$f":"N34-SUM(N35:O36)","v":12252},"…　(イ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G27=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G27=0,\"\",保険料計算!G28)","v":""},null,{"$f":"IF(保険料計算!G27=0,\"\",保険料計算!I27)","v":""},{"$f":"IF(保険料計算!G27=0,\"\",\"×\")","v":""},{"$f":"IF(保険料計算!G27=0,\"\",保険料計算!L2)","v":""},{"$f":"IF(保険料計算!I27=0,\"\",\"=\")","v":""},{"$f":"IF(保険料計算!G21=0,\"\",J35*L35)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G2=0,\"\",\"子ども軽減\")","v":""},null,null,{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!N27)","v":""},{"$f":"IF(保険料計算!G2=0,\"\",\"×\")","v":""},{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!G2)","v":""},{"$f":"IF(保険料計算!G2=0,\"\",\"=\")","v":""},{"$f":"IF(保険料計算!G2=0,\"\",J36*L36)","v":""}]
[null,null,null,"平等割",null,null,null,"1世帯につき",null,{"$f":"パラメーター!B9","v":7581},null,null,null,{"$f":"IF(保険料計算!L2=0,\"\",パラメーター!B9)","v":7581},null,"＝",{"$f":"N37-SUM(N38)","v":7581},"…　(ウ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G27=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G27=0,\"\",保険料計算!G28)","v":""},null,{"$f":"IF(保険料計算!G27=0,\"\",保険料計算!J27)","v":""},null,null,null,{"$f":"J38","v":""}]
[null,null,null," 支援分の保険料 (ア)＋(イ)＋(ウ)",null,null,{"$f":"パラメーター!A11&TEXT(パラメーター!B11/10000,\"#,###万円\")&\"まで\"","v":"賦課限度額26万円まで"},null,null,{"$f":"IF(Q29+Q34+Q37>パラメーター!B11,パラメーター!B11,Q29+Q34+Q37)","v":76222},null,null,null,null,null,null,null,null,"　…　②"]
[null,null,null,"介護分"]
[null,null,null,null,"※40歳以上65歳未満の被保険者が対象"]
[null,null,null,null,null,null,null,"※総所得金額が43万円未満の方の基礎控除額は，総所得金額と同額となります。"]
[null,null,null,"所得割",null,"総所得金額","－","※基礎控除額(43万円）","＝","算出所得\n（千円未満切捨て）",null,"算出所得合計","×","所得割料率"]
[]
[null,null,null,null,"世帯主",{"$f":"IF(保険料計算!C2=5,IF(保険料計算!C2=1,\"\",保険料計算!E2),\"\")","v":""},"－",{"$f":"IF(F45=\"\",\"\",IF(F45<=保険料計算!$F$2,F45,430000))","v":""},"＝",{"$f":"IF(F45=\"\",\"\",IF(F45=0,\"\",ROUNDDOWN(F45-H45,-3)))","v":""},null,{"$f":"SUM(J45:J50)","v":0},"×",{"$f":"パラメーター!B15","v":3.1099999999999999E-2},"＝"]
[null,null,null,null,"加入者1",{"$f":"IF(保険料計算!C3=5,IF(保険料計算!C3=1,\"\",保険料計算!E3),\"\")","v":""},"－",{"$f":"IF(F46=\"\",\"\",IF(F46<=保険料計算!$F$2,F46,430000))","v":""},"＝",""]
[null,null,null,null,"加入者2",{"$f":"IF(保険料計算!C4=5,IF(保険料計算!C4=1,\"\",保険料計算!E4),\"\")","v":""},"－",{"$f":"IF(F47=\"\",\"\",IF(F47<=保険料計算!$F$2,F47,430000))","v":""},"＝","",null,null,null,null,null,null,{"$f":"ROUNDDOWN(L45*N45,0)","v":0},"…　(ア)"]
[null,null,null,null,"加入者3",{"$f":"IF(保険料計算!C5=5,IF(保険料計算!C5=1,\"\",保険料計算!E5),\"\")","v":""},"－",{"$f":"IF(F48=\"\",\"\",IF(F48<=保険料計算!$F$2,F48,430000))","v":""},"＝",""]
[null,null,null,null,"加入者4",{"$f":"IF(保険料計算!C6=5,IF(保険料計算!C6=1,\"\",保険料計算!E6),\"\")","v":""},"－",{"$f":"IF(F49=\"\",\"\",IF(F49<=保険料計算!$F$2,F49,430000))","v":""},"＝",""]
[null,null,null,null,"加入者5",{"$f":"IF(保険料計算!C8=5,IF(保険料計算!C8=1,\"\",保険料計算!E7),\"\")","v":""},"－",{"$f":"IF(F50=\"\",\"\",IF(F50<=保険料計算!$F$2,F50,430000))","v":""},"＝",""]
[]
[null,null,null,"均等割",null,null,null,"1人につき",null,{"$f":"パラメーター!B13","v":12391},"×",{"$f":"保険料計算!J2","v":0},"＝",{"$f":"J52*L52","v":0},null,"＝",{"$f":"N52-SUM(N53)","v":0},"…　(イ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G33=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G33=0,\"\",保険料計算!G34)","v":""},null,{"$f":"IF(保険料計算!G33=0,\"\",保険料計算!I33)","v":""},{"$f":"IF(保険料計算!G33=0,\"\",\"×\")","v":""},{"$f":"IF(保険料計算!G33=0,\"\",保険料計算!J2)","v":""},{"$f":"IF(保険料計算!G33=0,\"\",\"=\")","v":""},{"$f":"IF(保険料計算!G33=0,\"\",J53*L53)","v":""}]
[null,null,null,"平等割",null,null,null,"1世帯につき",null,{"$f":"パラメーター!B14","v":6026},null,null,null,{"$f":"IF(保険料計算!J2=0,\"\",パラメーター!B14)","v":""},null,"＝",{"$f":"SUM(N54)-SUM(N55)","v":0},"…　(ウ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G33=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G33=0,\"\",保険料計算!G34)","v":""},null,{"$f":"IF(保険料計算!G33=0,\"\",保険料計算!J33)","v":""},null,null,null,{"$f":"J55","v":""}]
[null,null,null," 介護分の保険料 (ア)＋(イ)＋(ウ)",null,null,{"$f":"パラメーター!A16&TEXT(パラメーター!B16/10000,\"#,###万円\")&\"まで\"","v":"賦課限度額17万円まで"},null,null,{"$f":"IF(Q47+Q52+Q54>パラメーター!B16,パラメーター!B16,Q47+Q52+Q54)","v":0},null,null,null,null,null,null,null,null,"　…　③"]
[null,null,null,"子ども分"]
[]
[null,null,null,"　",null,null,null,"※総所得金額が43万円未満の方の基礎控除額は，総所得金額と同額となります。"]
[null,null,null,"所得割",null,"総所得金額","－","※基礎控除額(43万円）","＝","算出所得\n（千円未満切捨て）",null,"算出所得合計","×","所得割料率"]
[]
[null,null,null,null,"世帯主",{"$f":"IF(保険料計算!C2=1,\"\",IF(保険料計算!D2=0,\"\",保険料計算!E2))","v":2249600},"－",{"$f":"IF(F62=\"\",\"\",IF(F62<=保険料計算!$F$2,F62,430000))","v":430000},"＝",{"$f":"IF(F62=\"\",\"\",IF(F62=0,\"\",ROUNDDOWN(F62-H62,-3)))","v":1819000},null,{"$f":"SUM(J62:J67)","v":1819000},"×",{"$f":"パラメーター!B20","v":2.8E-3},"＝"]
[null,null,null,null,"加入者1",{"$f":"IF(保険料計算!C3=1,\"\",IF(保険料計算!D3=0,\"\",保険料計算!E3))","v":""},"－",{"$f":"IF(F63=\"\",\"\",IF(F63<=保険料計算!$F$2,F63,430000))","v":""},"＝",""]
[null,null,null,null,"加入者2",{"$f":"IF(保険料計算!C4=1,\"\",IF(保険料計算!D4=0,\"\",保険料計算!E4))","v":""},"－",{"$f":"IF(F64=\"\",\"\",IF(F64<=保険料計算!$F$2,F64,430000))","v":""},"＝","",null,null,null,null,null,null,{"$f":"ROUNDDOWN(L62*N62,0)","v":5093},"…　(ア)"]
[null,null,null,null,"加入者3",{"$f":"IF(保険料計算!C5=1,\"\",IF(保険料計算!D5=0,\"\",保険料計算!E5))","v":""},"－",{"$f":"IF(F65=\"\",\"\",IF(F65<=保険料計算!$F$2,F65,430000))","v":""},"＝",""]
[null,null,null,null,"加入者4",{"$f":"IF(保険料計算!C6=1,\"\",IF(保険料計算!D6=0,\"\",保険料計算!E6))","v":""},"－",{"$f":"IF(F66=\"\",\"\",IF(F66<=保険料計算!$F$2,F66,430000))","v":""},"＝",""]
[null,null,null,null,"加入者5",{"$f":"IF(保険料計算!C7=1,\"\",IF(保険料計算!D7=0,\"\",保険料計算!E7))","v":""},"－",{"$f":"IF(F67=\"\",\"\",IF(F67<=保険料計算!$F$2,F67,430000))","v":""},"＝",""]
[]
[null,null,null,"均等割",null,null,null,"1人につき",null,{"$f":"パラメーター!B18","v":1157},"×",{"$f":"保険料計算!L2","v":1},"＝",{"$f":"J69*L69","v":1157},null,"＝",{"$f":"N69-SUM(N70:N72)","v":1157},"…　(イ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G39=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G39=0,\"\",保険料計算!G40)","v":""},null,{"$f":"IF(保険料計算!G39=0,\"\",保険料計算!I39)","v":""},{"$f":"IF(保険料計算!G39=0,\"\",\"×\")","v":""},{"$f":"IF(保険料計算!G39=0,\"\",保険料計算!L2)","v":""},{"$f":"IF(保険料計算!G39=0,\"\",\"=\")","v":""},{"$f":"IF(保険料計算!G39=0,\"\",J70*L70)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G2=0,\"\",\"子ども軽減\")","v":""},null,null,{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!N39)","v":""},{"$f":"IF(保険料計算!G2=0,\"\",\"×\")","v":""},{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!G2)","v":""},{"$f":"IF(保険料計算!G2=0,\"\",\"=\")","v":""},{"$f":"IF(保険料計算!G2=0,\"\",J71*L71)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(AND(保険料計算!G2=0,保険料計算!H2=0),\"\",\"18歳未満軽減\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(保険料計算!G2=0,保険料計算!H2=0),\"\",IF(保険料計算!G2=0,保険料計算!H2*保険料計算!O40,(保険料計算!G2*保険料計算!O39+保険料計算!H2*保険料計算!O40)))","v":""}]
[null,null,null,"平等割",null,null,null,"1世帯につき",null,{"$f":"パラメーター!B19","v":716},null,null,null,{"$f":"IF(保険料計算!L2=0,\"\",パラメーター!B19)","v":716},null,"＝",{"$f":"N73-SUM(N74)","v":716},"…　(ウ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G39=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G39=0,\"\",保険料計算!G40)","v":""},null,{"$f":"IF(保険料計算!G39=0,\"\",保険料計算!J39)","v":""},null,null,null,{"$f":"J74","v":""}]
[null,null,null,"18歳以上\n均等割",null,null,null,"18歳以上被保険者1人につき",null,{"$f":"パラメーター!B21","v":59},null,{"$f":"保険料計算!L4","v":1},"＝",{"$f":"J75*L75","v":59},null,"＝",{"$f":"N75-SUM(N76)","v":59},"…　(ウ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G39=0,\"\",\"減額：\")","v":""},{"$f":"IF(保険料計算!G45=0,\"\",保険料計算!G46)","v":""},null,{"$f":"IF(保険料計算!G45=0,\"\",保険料計算!I45)","v":""},null,{"$f":"IF(保険料計算!G39=0,\"\",保険料計算!L4)","v":""},null,{"$f":"IF(保険料計算!G39=0,\"\",J76*L76)","v":""}]
[null,null,null," 子ども分の保険料 (ア)＋(イ)＋(ウ)",null,null,{"$f":"パラメーター!A22&TEXT(パラメーター!B22/10000,\"#,###万円\")&\"まで\"","v":"賦課限度額3万円まで"},null,null,{"$f":"IF(Q64+Q69+Q73+Q75>パラメーター!B22,パラメーター!B22,Q64+Q69+Q73+Q75)","v":7025},null,null,null,null,null,null,null,null,"　…　④"]
[]
[]
[null,null,null,null,null,null,null,null,null,"年間 国民健康保険料　【①+②+③+④】",null,null,null,null,null,null,{"$f":"J21+J39+J56+J77","v":270473}]
[]
[null,null,null,null,null,null,null,null,null,"1ヵ月当たりの国民健康保険料　（年間保険料／12ヶ月）",null,null,null,null,null,null,{"$f":"Q80/12","v":22539.416666666668}]

{"sheet":"保険料計算","index":3,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":true,"merged":[[49,1,49,2],[58,1,58,2],[67,1,67,2],[19,2,19,3],[19,4,19,5],[25,2,25,3],[25,4,25,5],[31,2,31,3],[31,4,31,5],[37,2,37,3],[37,4,37,5],[43,2,43,3],[45,6,45,7],[19,6,19,7],[25,6,25,7],[31,6,31,7],[37,6,37,7],[43,6,43,7],[21,6,21,7],[27,6,27,7],[33,6,33,7],[39,6,39,7]]}
["基礎情報",null,"加入区分","擬主判定","総所得金額","基礎控除額","未就学児","小学生から高校生世代まで","１８歳から３９歳まで人数","４０歳から６４歳まで人数","６５歳から７４歳まで人数","合計人数"]
["年齢区分","世帯主",6,{"$f":"IF(C2=1,0,1)","v":1},{"$f":"H11","v":2249600},430000,{"$f":"COUNTIF(C2:C8,2)","v":0},{"$f":"COUNTIF(C2:C8,3)","v":0},{"$f":"COUNTIF(C2:C8,4)","v":0},{"$f":"COUNTIF(C2:C8,5)","v":0},{"$f":"COUNTIF(C2:C8,6)","v":1},{"$f":"G2+H2+I2+J2+K2","v":1},{"$f":"IF(D2=0,IF(B11>550000,L2+1,L2),L2)","v":1}]
["加入しない","加入者１",1,null,{"$f":"H12","v":0},null,null,null,null,null,null,"うち18歳以上"]
["未就学児","加入者２",1,null,0,null,null,null,null,null,null,{"$f":"I2+J2+K2","v":1}]
["小学生から高校生世代まで","加入者３",1,null,0]
["１８歳から３９歳まで","加入者４",1,null,0]
["４０歳から６４歳まで","加入者５",1,null,0]
["６５歳から７４歳まで"]
[null,null,{"$f":"SUM(加入者)","v":5}]
["所得内訳","給与収入額","給与所得額","年金収入額","年金所得額","年金特別控除判定","その他所得","合計所得","給与所得額","年金所得額","給与年金所得控除"]
["世帯主",{"$f":"保険料の概要!Q9","v":3328058},{"$f":"VLOOKUP(D57,D51:J56,7,0)-K11","v":2249600},{"$f":"保険料の概要!Y9","v":0},{"$f":"IF(C2=6,D66,D75)","v":0},{"$f":"IF(OR(C2=1,C2=6),IF(D11<=1100000,0,IF(D11>=1250000,-150000,1100000-D11)),0)","v":0},{"$f":"保険料の概要!AG9","v":0},{"$f":"C11+E11+G11","v":2249600},{"$f":"VLOOKUP(D57,D51:J56,7,0)","v":2249600},{"$f":"IF(C2=6,D66,D75)","v":0},{"$f":"IF(IF(I11>100000,100000,I11)+IF(J11>100000,100000,J11)-100000<0,0,IF(I11>100000,100000,I11)+IF(J11>100000,100000,J11)-100000)","v":0}]
["加入者１",{"$f":"保険料の概要!Q11","v":0},{"$f":"VLOOKUP(E57,E51:K56,7,0)-K12","v":0},{"$f":"保険料の概要!Y11","v":0},{"$f":"IF(C3=6,E66,E75)","v":0},{"$f":"IF(C3=6,IF(D12<=1100000,0,IF(D12>=1250000,-150000,1100000-D12)),0)","v":0},{"$f":"保険料の概要!AG11","v":0},{"$f":"IF(C3>1,C12+E12+G12,0)","v":0},{"$f":"VLOOKUP(E57,E51:K56,7,0)","v":0},{"$f":"IF(C3=6,E66,E75)","v":0},{"$f":"IF(IF(I12>100000,100000,I12)+IF(J12>100000,100000,J12)-100000<0,0,IF(I12>100000,100000,I12)+IF(J12>100000,100000,J12)-100000)","v":0}]
["加入者２",{"$f":"保険料の概要!Q13","v":0},{"$f":"VLOOKUP(F57,F51:L56,7,0)-K13","v":0},{"$f":"保険料の概要!Y13","v":0},{"$f":"IF(C4=6,F66,F75)","v":0},{"$f":"IF(C4=6,IF(D13<=1100000,0,IF(D13>=1250000,-150000,1100000-D13)),0)","v":0},{"$f":"保険料の概要!AG13","v":0},{"$f":"IF(C4>1,C13+E13+G13,0)","v":0},{"$f":"VLOOKUP(F57,F51:L56,7,0)","v":0},{"$f":"IF(C4=6,F66,F75)","v":0},0]
["加入者３",{"$f":"保険料の概要!Q15","v":0},{"$f":"VLOOKUP(G57,G51:M56,7,0)-K14","v":0},{"$f":"保険料の概要!Y15","v":0},{"$f":"IF(C5=6,G66,G75)","v":0},{"$f":"IF(C5=6,IF(D14<=1100000,0,IF(D14>=1250000,-150000,1100000-D14)),0)","v":0},{"$f":"保険料の概要!AG15","v":0},{"$f":"IF(C5>1,C14+E14+G14,0)","v":0},{"$f":"VLOOKUP(G57,G51:M56,7,0)","v":0},{"$f":"IF(C5=6,G66,G75)","v":0},0]
["加入者４",{"$f":"保険料の概要!Q17","v":0},{"$f":"VLOOKUP(H57,H51:N56,7,0)-K15","v":0},{"$f":"保険料の概要!Y17","v":0},{"$f":"IF(C6=6,H66,H75)","v":0},{"$f":"IF(C6=6,IF(D15<=1100000,0,IF(D15>=1250000,-150000,1100000-D15)),0)","v":0},{"$f":"保険料の概要!AG17","v":0},{"$f":"IF(C6>1,C15+E15+G15,0)","v":0},{"$f":"VLOOKUP(H57,H51:N56,7,0)","v":0},{"$f":"IF(C6=6,H66,H75)","v":0},0]
["加入者５",{"$f":"保険料の概要!Q19","v":0},{"$f":"VLOOKUP(I57,I51:O56,7,0)-K16","v":0},{"$f":"保険料の概要!Y19","v":0},{"$f":"IF(C8=6,I66,I75)","v":0},{"$f":"IF(C8=6,IF(D16<=1100000,0,IF(D16>=1250000,-150000,1100000-D16)),0)","v":0},{"$f":"保険料の概要!AG19","v":0},{"$f":"IF(C8>1,C16+E16+G16,0)","v":0},{"$f":"VLOOKUP(I57,I51:O56,7,0)","v":0},{"$f":"IF(C8=6,I66,I75)","v":0},0]
[null,null,null,null,null,{"$f":"SUM(F11:F16)","v":0}]
[]
["軽減"]
["判定所得",{"$f":"SUM(H11:H16)+F17","v":2249600},"（医）均等割軽減額",null,"（医）平等割軽減額",null,"（医）軽減判定",null,"（医）均等割","（医）平等割","（医）未就学児均等割軽減額",null,"（医）未就学判定","（医）未就学児軽減"]
[null,null,7,{"$f":"ROUNDUP(パラメーター!B3*0.7,0)","v":21182},7,{"$f":"ROUNDUP(パラメーター!B4*0.7,0)","v":13107},{"$f":"VLOOKUP(L2,A28:B34,2,0)","v":0},"割",{"$f":"VLOOKUP(G21,C21:D24,2,0)","v":0},{"$f":"VLOOKUP(G21,E21:F24,2,0)","v":0},7,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B3*0.3,0)/2,0)","v":4539},{"$f":"IF(G2>=1,G21,0)","v":0},{"$f":"VLOOKUP(M21,K21:L24,2,0)","v":15130}]
[null,null,5,{"$f":"ROUNDUP(パラメーター!B3*0.5,0)","v":15130},5,{"$f":"ROUNDUP(パラメーター!B4*0.5,0)","v":9362},{"$f":"CONCATENATE(G21,H21)","v":"0割"},null,null,null,5,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B3*0.5,0)/2,0)","v":7565}]
[null,null,2,{"$f":"ROUNDUP(パラメーター!B3*0.2,0)","v":6052},2,{"$f":"ROUNDUP(パラメーター!B4*0.2,0)","v":3745},null,null,null,null,2,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B3*0.8,0)/2,0)","v":12104}]
[null,null,0,null,0,null,null,null,null,null,0,{"$f":"ROUNDUP(パラメーター!B3/2,0)","v":15130}]
[]
[null,null,"（支）均等割軽減額",null,"（支）平等割軽減額",null,"（支）軽減判定",null,"（支）均等割","（支）平等割","（支）未就学児均等割軽減額",null,"（支）未就学判定","（支）未就学児軽減"]
["人数","軽減割合",7,{"$f":"ROUNDUP(パラメーター!B8*0.7,0)","v":8577},7,{"$f":"ROUNDUP(パラメーター!B9*0.7,0)","v":5307},{"$f":"G21","v":0},{"$f":"H21","v":"割"},{"$f":"VLOOKUP(G27,C27:D30,2,0)","v":0},{"$f":"VLOOKUP(G27,E27:F30,2,0)","v":0},7,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B8*0.3,0)/2,0)","v":1838},{"$f":"IF(G2>=1,G27,0)","v":0},{"$f":"VLOOKUP(M27,K27:L30,2,0)","v":6126}]
[1,{"$f":"MAX(パラメーター!C25,パラメーター!E25,パラメーター!G25)","v":0},5,{"$f":"ROUNDUP(パラメーター!B8*0.5,0)","v":6126},5,{"$f":"ROUNDUP(パラメーター!B9*0.5,0)","v":3791},{"$f":"G22","v":"0割"},null,null,null,5,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B8*0.5,0)/2,0)","v":3063}]
[2,{"$f":"MAX(パラメーター!C26,パラメーター!E26,パラメーター!G26)","v":0},2,{"$f":"ROUNDUP(パラメーター!B8*0.2,0)","v":2451},2,{"$f":"ROUNDUP(パラメーター!B9*0.2,0)","v":1517},null,null,null,null,2,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B8*0.8,0)/2,0)","v":4901}]
[3,{"$f":"MAX(パラメーター!C27,パラメーター!E27,パラメーター!G27)","v":0},0,null,0,null,null,null,null,null,0,{"$f":"ROUNDUP(パラメーター!B8/2,0)","v":6126}]
[4,{"$f":"MAX(パラメーター!C28,パラメーター!E28,パラメーター!G28)","v":2}]
[5,{"$f":"MAX(パラメーター!C29,パラメーター!E29,パラメーター!G29)","v":2},"（介）均等割軽減額",null,"（介）平等割軽減額",null,"（介）軽減判定",null,"（介）均等割","（介）平等割"]
[6,{"$f":"MAX(パラメーター!C30,パラメーター!E30,パラメーター!G30)","v":5},7,{"$f":"ROUNDUP(パラメーター!B13*0.7,0)","v":8674},7,{"$f":"ROUNDUP(パラメーター!B14*0.7,0)","v":4219},{"$f":"IF(J2>=1,G21,0)","v":0},"割",{"$f":"VLOOKUP(G33,C33:D36,2,0)","v":0},{"$f":"VLOOKUP(G33,E33:F36,2,0)","v":0}]
[0,null,5,{"$f":"ROUNDUP(パラメーター!B13*0.5,0)","v":6196},5,{"$f":"ROUNDUP(パラメーター!B14*0.5,0)","v":3013},{"$f":"CONCATENATE(G33,H33)","v":"0割"}]
[null,null,2,{"$f":"ROUNDUP(パラメーター!B13*0.2,0)","v":2479},2,{"$f":"ROUNDUP(パラメーター!B14*0.2,0)","v":1206}]
[null,null,0,null,0]
[]
[null,null,"（子）均等割軽減額",null,"（子）平等割軽減額",null,"（子）軽減判定",null,"（子）均等割","（子）平等割","（子）未就学児均等割軽減額",null,"（子）未就学判定","（子）未就学児軽減","18歳未満軽減"]
[null,null,7,{"$f":"ROUNDUP(パラメーター!B18*0.7,0)","v":810},7,{"$f":"ROUNDUP(パラメーター!B19*0.7,0)","v":502},{"$f":"G21","v":0},"割",{"$f":"VLOOKUP(G39,C39:D42,2,0)","v":0},{"$f":"VLOOKUP(G39,E39:F42,2,0)","v":0},7,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B18*0.3,0)/2,0)","v":174},{"$f":"IF(G2>=1,G39,0)","v":0},{"$f":"VLOOKUP(M39,K39:L42,2,0)","v":579},{"$f":"パラメーター!B18-I39-N39","v":578},"未就学児"]
[null,null,5,{"$f":"ROUNDUP(パラメーター!B18*0.5,0)","v":579},5,{"$f":"ROUNDUP(パラメーター!B19*0.5,0)","v":358},{"$f":"CONCATENATE(G39,H39)","v":"0割"},null,null,null,5,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B18*0.5,0)/2,0)","v":289},null,null,{"$f":"パラメーター!B18-I39","v":1157},"小学生～高校生"]
[null,null,2,{"$f":"ROUNDUP(パラメーター!B18*0.2,0)","v":232},2,{"$f":"ROUNDUP(パラメーター!B19*0.2,0)","v":144},null,null,null,null,2,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B18*0.8,0)/2,0)","v":463}]
[null,null,0,null,0,null,null,null,null,null,0,{"$f":"ROUNDUP(パラメーター!B18/2,0)","v":579}]
[]
[null,null,"（子）18均等割軽減額",null,null,null,"（子）18軽減判定",null,"（子）18均等割"]
[null,null,7,{"$f":"ROUNDUP(パラメーター!B21*0.7,0)","v":42},null,null,{"$f":"G21","v":0},"割",{"$f":"VLOOKUP(G45,C45:D48,2,0)","v":0}]
[null,null,5,{"$f":"ROUNDUP(パラメーター!B21*0.5,0)","v":30},null,null,{"$f":"CONCATENATE(G45,H45)","v":"0割"}]
[null,null,2,{"$f":"ROUNDUP(パラメーター!B21*0.2,0)","v":12}]
[null,null,0]
[null,null,null,null,null,null,null,null,null,"給与所得額"]
["給与所得計算","給与収入",null,"世帯主","加入者１","加入者２","加入者３","加入者４","加入者５","世帯主","加入者１","加入者２","加入者３","加入者４","加入者５"]
[null,0,650999,{"$f":"IF($B11<=$C51,0,\"\")","v":""},{"$f":"IF($B$12<=$C51,0,\"\")","v":0},{"$f":"IF($B$13<=$C51,0,\"\")","v":0},{"$f":"IF($B$14<=$C51,0,\"\")","v":0},{"$f":"IF($B$15<=$C51,0,\"\")","v":0},{"$f":"IF($B$16<=$C51,0,\"\")","v":0},0,0,0,0,0,0]
[null,651000,1899999,{"$f":"IF(B11<=C52,1,\"\")","v":""},{"$f":"IF($B$12<=$C52,1,\"\")","v":1},{"$f":"IF($B$13<=$C52,1,\"\")","v":1},{"$f":"IF($B$14<=$C52,1,\"\")","v":1},{"$f":"IF($B$15<=$C52,1,\"\")","v":1},{"$f":"IF($B$16<=$C52,1,\"\")","v":1},{"$f":"B11-650000","v":2678058},{"$f":"B12-650000","v":-650000},{"$f":"B13-650000","v":-650000},{"$f":"B14-650000","v":-650000},{"$f":"B15-650000","v":-650000},{"$f":"B16-650000","v":-650000}]
[null,1900000,3599999,{"$f":"IF(B11<=C53,2,\"\")","v":2},{"$f":"IF($B$12<=$C53,2,\"\")","v":2},{"$f":"IF($B$13<=$C53,2,\"\")","v":2},{"$f":"IF($B$14<=$C53,2,\"\")","v":2},{"$f":"IF($B$15<=$C53,2,\"\")","v":2},{"$f":"IF($B$16<=$C53,2,\"\")","v":2},{"$f":"ROUNDDOWN(B11/4,-3)*2.8-80000","v":2249600},{"$f":"ROUNDDOWN(B12/4,-3)*2.8-80000","v":-80000},{"$f":"ROUNDDOWN(B13/4,-3)*2.8-80000","v":-80000},{"$f":"ROUNDDOWN(B14/4,-3)*2.8-80000","v":-80000},{"$f":"ROUNDDOWN(B15/4,-3)*2.8-80000","v":-80000},{"$f":"ROUNDDOWN(B16/4,-3)*2.8-80000","v":-80000}]
[null,3600000,6599999,{"$f":"IF(B11<=C54,3,\"\")","v":3},{"$f":"IF($B$12<=$C54,3,\"\")","v":3},{"$f":"IF($B$13<=$C54,3,\"\")","v":3},{"$f":"IF($B$14<=$C54,3,\"\")","v":3},{"$f":"IF($B$15<=$C54,3,\"\")","v":3},{"$f":"IF($B$16<=$C54,3,\"\")","v":3},{"$f":"ROUNDDOWN(B11/4,-3)*3.2-440000","v":2222400},{"$f":"ROUNDDOWN(B12/4,-3)*3.2-440000","v":-440000},{"$f":"ROUNDDOWN(B13/4,-3)*3.2-440000","v":-440000},{"$f":"ROUNDDOWN(B14/4,-3)*3.2-440000","v":-440000},{"$f":"ROUNDDOWN(B15/4,-3)*3.2-440000","v":-440000},{"$f":"ROUNDDOWN(B16/4,-3)*3.2-440000","v":-440000}]
[null,6600000,8499999,{"$f":"IF(B11<C55,4,\"\")","v":4},{"$f":"IF($B$12<=$C55,4,\"\")","v":4},{"$f":"IF($B$13<=$C55,4,\"\")","v":4},{"$f":"IF($B$14<=$C55,4,\"\")","v":4},{"$f":"IF($B$15<=$C55,4,\"\")","v":4},{"$f":"IF($B$16<=$C55,4,\"\")","v":4},{"$f":"B11*0.9-1100000","v":1895252.2000000002},{"$f":"B12*0.9-1100000","v":-1100000},{"$f":"B13*0.9-1100000","v":-1100000},{"$f":"B14*0.9-1100000","v":-1100000},{"$f":"B15*0.9-1100000","v":-1100000},{"$f":"B16*0.9-1100000","v":-1100000}]
[null,8500000,null,{"$f":"IF(B11>=C56,5,\"\")","v":5},{"$f":"IF($B$12<=$C56,5,\"\")","v":5},{"$f":"IF($B$13<=$C56,5,\"\")","v":5},{"$f":"IF($B$14<=$C56,5,\"\")","v":5},{"$f":"IF($B$15<=$C56,5,\"\")","v":5},{"$f":"IF($B$16<=$C56,5,\"\")","v":5},{"$f":"B11-1950000","v":1378058},{"$f":"B12-1950000","v":-1950000},{"$f":"B13-1950000","v":-1950000},{"$f":"B14-1950000","v":-1950000},{"$f":"B15-1950000","v":-1950000},{"$f":"B16-1950000","v":-1950000}]
[null,null,null,{"$f":"MIN(D51:D56)","v":2},0,0,0,0,0]
[]
["年金所得計算","年金収入_６５歳以上",null,"世帯主","加入者１","加入者２","加入者３","加入者４","加入者５","世帯主","加入者１","加入者２","加入者３","加入者４","加入者５"]
[null,0,1100000,{"$f":"IF($D$11<=$C60,0,\"\")","v":0},{"$f":"IF($D$12<=$C60,0,\"\")","v":0},{"$f":"IF($D$13<=$C60,0,\"\")","v":0},{"$f":"IF($D$14<=$C60,0,\"\")","v":0},{"$f":"IF($D$15<=$C60,0,\"\")","v":0},{"$f":"IF($D$16<=$C60,0,\"\")","v":0},0,0,0,0,0,0]
[null,1100001,3299999,{"$f":"IF($D$11<=C61,1,\"\")","v":1},{"$f":"IF($D$12<=$C61,1,\"\")","v":1},{"$f":"IF($D$13<=$C61,1,\"\")","v":1},{"$f":"IF($D$14<=$C61,1,\"\")","v":1},{"$f":"IF($D$15<=$C61,1,\"\")","v":1},{"$f":"IF($D$16<=$C61,1,\"\")","v":1},{"$f":"D11-1100000","v":-1100000},{"$f":"D12-1100000","v":-1100000},{"$f":"D13-1100000","v":-1100000},{"$f":"D14-1100000","v":-1100000},{"$f":"D15-1100000","v":-1100000},{"$f":"D16-1100000","v":-1100000}]
[null,3300000,4099999,{"$f":"IF($D$11<=C62,2,\"\")","v":2},{"$f":"IF($D$12<=$C62,2,\"\")","v":2},{"$f":"IF($D$13<=$C62,2,\"\")","v":2},{"$f":"IF($D$14<=$C62,2,\"\")","v":2},{"$f":"IF($D$15<=$C62,2,\"\")","v":2},{"$f":"IF($D$16<=$C62,2,\"\")","v":2},{"$f":"D11*0.75-275000","v":-275000},{"$f":"D12*0.75-275000","v":-275000},{"$f":"D13*0.75-275000","v":-275000},{"$f":"D14*0.75-275000","v":-275000},{"$f":"D15*0.75-275000","v":-275000},{"$f":"D16*0.75-275000","v":-275000}]
[null,4100000,7699999,{"$f":"IF($D$11<=C63,3,\"\")","v":3},{"$f":"IF($D$12<=$C63,3,\"\")","v":3},{"$f":"IF($D$13<=$C63,3,\"\")","v":3},{"$f":"IF($D$14<=$C63,3,\"\")","v":3},{"$f":"IF($D$15<=$C63,3,\"\")","v":3},{"$f":"IF($D$16<=$C63,3,\"\")","v":3},{"$f":"D11*0.85-685000","v":-685000},{"$f":"D12*0.85-685000","v":-685000},{"$f":"D13*0.85-685000","v":-685000},{"$f":"D14*0.85-685000","v":-685000},{"$f":"D15*0.85-685000","v":-685000},{"$f":"D16*0.85-685000","v":-685000}]
[null,7700000,9999999,{"$f":"IF($D$11>=B64,4,\"\")","v":""},{"$f":"IF(D12>=$B$64,4,\"\")","v":""},{"$f":"IF(D13>=$B$64,4,\"\")","v":""},{"$f":"IF(D14>=$B$64,4,\"\")","v":""},{"$f":"IF(D15>=$B$64,4,\"\")","v":""},{"$f":"IF(D16>=$B$64,4,\"\")","v":""},{"$f":"D11*0.95-1455000","v":-1455000},{"$f":"D12*0.95-1455000","v":-1455000},{"$f":"D13*0.95-1455000","v":-1455000},{"$f":"D14*0.95-1455000","v":-1455000},{"$f":"D15*0.95-1455000","v":-1455000},{"$f":"D16*0.95-1455000","v":-1455000}]
[null,null,null,{"$f":"MIN(D60:D64)","v":0},0,0,0,0,0]
[null,null,null,{"$f":"VLOOKUP(D65,D60:J64,7,0)","v":0},0,0,0,0,0]
[]
[null,"年金収入_６４歳未満",null,"世帯主","加入者１","加入者２","加入者３","加入者４","加入者５","世帯主","加入者１","加入者２","加入者３","加入者４","加入者５"]
[null,0,600000,{"$f":"IF($D$11<=$C69,0,\"\")","v":0},{"$f":"IF($D$12<=$C69,0,\"\")","v":0},{"$f":"IF($D$13<=$C69,0,\"\")","v":0},{"$f":"IF($D$14<=$C69,0,\"\")","v":0},{"$f":"IF($D$15<=$C69,0,\"\")","v":0},{"$f":"IF($D$16<=$C69,0,\"\")","v":0},0,0,0,0,0,0]
[null,600001,1299999,{"$f":"IF($D$11<=C70,1,\"\")","v":1},{"$f":"IF($D$12<=$C70,1,\"\")","v":1},{"$f":"IF($D$13<=$C70,1,\"\")","v":1},{"$f":"IF($D$14<=$C70,1,\"\")","v":1},{"$f":"IF($D$15<=$C70,1,\"\")","v":1},{"$f":"IF($D$16<=$C70,1,\"\")","v":1},{"$f":"D11-600000","v":-600000},{"$f":"D12-600000","v":-600000},{"$f":"D13-600000","v":-600000},{"$f":"D14-600000","v":-600000},{"$f":"D15-600000","v":-600000},{"$f":"D16-600000","v":-600000}]
[null,1300000,4099999,{"$f":"IF($D$11<=C71,2,\"\")","v":2},{"$f":"IF($D$12<=$C71,2,\"\")","v":2},{"$f":"IF($D$13<=$C71,2,\"\")","v":2},{"$f":"IF($D$14<=$C71,2,\"\")","v":2},{"$f":"IF($D$15<=$C71,2,\"\")","v":2},{"$f":"IF($D$16<=$C71,2,\"\")","v":2},{"$f":"D11*0.75-275000","v":-275000},{"$f":"D12*0.75-275000","v":-275000},{"$f":"D13*0.75-275000","v":-275000},{"$f":"D14*0.75-275000","v":-275000},{"$f":"D15*0.75-275000","v":-275000},{"$f":"D16*0.75-275000","v":-275000}]
[null,4100000,7699999,{"$f":"IF($D$11<=C72,3,\"\")","v":3},{"$f":"IF($D$12<=$C72,3,\"\")","v":3},{"$f":"IF($D$13<=$C72,3,\"\")","v":3},{"$f":"IF($D$14<=$C72,3,\"\")","v":3},{"$f":"IF($D$15<=$C72,3,\"\")","v":3},{"$f":"IF($D$16<=$C72,3,\"\")","v":3},{"$f":"D11*0.85-685000","v":-685000},{"$f":"D12*0.85-685000","v":-685000},{"$f":"D13*0.85-685000","v":-685000},{"$f":"D14*0.85-685000","v":-685000},{"$f":"D15*0.85-685000","v":-685000},{"$f":"D16*0.85-685000","v":-685000}]
[null,7700000,9999999,{"$f":"IF($D$11>=B73,4,\"\")","v":""},{"$f":"IF(D12>=$B$64,4,\"\")","v":""},{"$f":"IF(D13>=$B$64,4,\"\")","v":""},{"$f":"IF(D14>=$B$64,4,\"\")","v":""},{"$f":"IF(D15>=$B$64,4,\"\")","v":""},{"$f":"IF(D16>=$B$64,4,\"\")","v":""},{"$f":"D11*0.95-1455000","v":-1455000},{"$f":"D12*0.95-1455000","v":-1455000},{"$f":"D13*0.95-1455000","v":-1455000},{"$f":"D14*0.95-1455000","v":-1455000},{"$f":"D15*0.95-1455000","v":-1455000},{"$f":"D16*0.95-1455000","v":-1455000}]
[null,null,null,{"$f":"MIN(D69:D73)","v":0},0,0,0,0,0]
[null,null,null,{"$f":"VLOOKUP(D74,D69:J73,7,0)","v":0},0,0,0,0,0]

{"sheet":"パラメーター","index":4,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,16,2,16],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,0,1,1],[16,0,16,1],[6,0,6,1],[11,0,11,1],[1,14,2,14],[1,15,2,15]]}
["料率等パラメーター"]
["医療分",null,null,null,null,null,null,null,null,null,null,"給与\n所得者数","一般収入","年金収入\n65歳未満","年金収入\n65歳以上","合計","計算値","控除額"]
["均等割",30259,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000]
["平等割",18723,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(保険料計算!B11>550000,1,0)","v":1},{"$f":"IF(保険料計算!C2=3,IF(保険料計算!D11>600000,1,0),0)","v":0},{"$f":"IF(保険料計算!C2=4,IF(保険料計算!D11>1250000,1,0),0)","v":0},{"$f":"SUM(M4:O4)","v":1},{"$f":"MAX(P4-1,)","v":0}]
["所得割",7.5999999999999998E-2,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(保険料計算!B12>550000,M4+1,M4)","v":1},{"$f":"IF(保険料計算!C3=3,IF(保険料計算!D12>600000,N4+1,N4),N4)","v":0},{"$f":"IF(保険料計算!C3=4,IF(保険料計算!D12>1250000,O4+1,O4),O4)","v":0},{"$f":"SUM(M5:O5)","v":1},{"$f":"MAX(P5-1,)","v":0}]
["賦課限度額",670000,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(保険料計算!B13>550000,M5+1,M5)","v":1},{"$f":"IF(保険料計算!C4=3,IF(保険料計算!D13>600000,N5+1,N5),N5)","v":0},{"$f":"IF(保険料計算!C4=4,IF(保険料計算!D13>1250000,O5+1,O5),O5)","v":0},1,0]
["支援分",null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(保険料計算!B14>550000,M6+1,M6)","v":1},{"$f":"IF(保険料計算!C5=3,IF(保険料計算!D14>600000,N6+1,N6),N6)","v":0},{"$f":"IF(保険料計算!C5=4,IF(保険料計算!D14>1250000,O6+1,O6),O6)","v":0},1,0]
["均等割",12252,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(保険料計算!B15>550000,M7+1,M7)","v":1},{"$f":"IF(保険料計算!C6=3,IF(保険料計算!D15>600000,N7+1,N7),N7)","v":0},{"$f":"IF(保険料計算!C6=4,IF(保険料計算!D15>1250000,O7+1,O7),O7)","v":0},1,0]
["平等割",7581,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(保険料計算!B16>550000,M8+1,M8)","v":1},{"$f":"IF(保険料計算!C8=3,IF(保険料計算!D16>600000,N8+1,N8),N8)","v":0},{"$f":"IF(保険料計算!C8=4,IF(保険料計算!D16>1250000,O8+1,O8),O8)","v":0},1,0]
["所得割",3.1E-2]
["賦課限度額",260000,null,"年度",8]
["介護分"]
["均等割",12391]
["平等割",6026]
["所得割",3.1099999999999999E-2]
["賦課限度額",170000]
["子ども分"]
["均等割",1157]
["平等割",716]
["所得割",2.8E-3]
["18歳以上均等割",59]
["賦課限度額",30000]
[]
["軽減判定パラメーター","７割",430000,"５割",310000,"２割",570000]
[1,{"$f":"$C$24","v":430000},{"$f":"IF(B25>=保険料計算!$B$20,7,\"\")","v":""},{"$f":"430000+A25*$E$24","v":740000},{"$f":"IF(D25>=保険料計算!$B$20,5,\"\")","v":""},{"$f":"430000+A25*$G$24","v":1000000},{"$f":"IF(F25>=保険料計算!$B$20,2,\"\")","v":""}]
[2,{"$f":"$C$24+$R$3*Q5","v":430000},{"$f":"IF(B26>=保険料計算!$B$20,7,\"\")","v":""},{"$f":"430000+A26*$E$24+$R$3*Q5","v":1050000},{"$f":"IF(D26>=保険料計算!$B$20,5,\"\")","v":""},{"$f":"430000+A26*$G$24+$R$3*Q5","v":1570000},{"$f":"IF(F26>=保険料計算!$B$20,2,\"\")","v":""}]
[3,{"$f":"$C$24+$R$3*Q6","v":430000},{"$f":"IF(B27>=保険料計算!$B$20,7,\"\")","v":""},{"$f":"430000+A27*$E$24+$R$3*Q6","v":1360000},{"$f":"IF(D27>=保険料計算!$B$20,5,\"\")","v":""},{"$f":"430000+A27*$G$24+$R$3*Q6","v":2140000},{"$f":"IF(F27>=保険料計算!$B$20,2,\"\")","v":""}]
[4,{"$f":"$C$24+$R$3*Q7","v":430000},{"$f":"IF(B28>=保険料計算!$B$20,7,\"\")","v":""},{"$f":"430000+A28*$E$24+$R$3*Q7","v":1670000},{"$f":"IF(D28>=保険料計算!$B$20,5,\"\")","v":""},{"$f":"430000+A28*$G$24+$R$3*Q7","v":2710000},{"$f":"IF(F28>=保険料計算!$B$20,2,\"\")","v":2}]
[5,{"$f":"$C$24+$R$3*Q8","v":430000},{"$f":"IF(B29>=保険料計算!$B$20,7,\"\")","v":""},{"$f":"430000+A29*$E$24+$R$3*Q8","v":1980000},{"$f":"IF(D29>=保険料計算!$B$20,5,\"\")","v":""},{"$f":"430000+A29*$G$24+$R$3*Q8","v":3280000},{"$f":"IF(F29>=保険料計算!$B$20,2,\"\")","v":2}]
[6,{"$f":"$C$24+$R$3*Q9","v":430000},{"$f":"IF(B30>=保険料計算!$B$20,7,\"\")","v":""},{"$f":"430000+A30*$E$24+$R$3*Q9","v":2290000},{"$f":"IF(D30>=保険料計算!$B$20,5,\"\")","v":5},{"$f":"430000+A30*$G$24+$R$3*Q9","v":3850000},{"$f":"IF(F30>=保険料計算!$B$20,2,\"\")","v":2}]
[]
[]
[{"$f":"\"令和\"&DBCS(E11)&\"年度尼崎市国民健康保険料試算表の利用について\"","v":"令和８年度尼崎市国民健康保険料試算表の利用について"}]
[{"$f":"\"令和\"&DBCS(E11)&\"年度尼崎市国民健康保険料試算表の利用につきまして、下記の注意点をよくお読みいただき、ご利用をお願いいたします。\"","v":"令和８年度尼崎市国民健康保険料試算表の利用につきまして、下記の注意点をよくお読みいただき、ご利用をお願いいたします。"}]
[{"$f":"\"令和\"&DBCS(E11)&\"年度尼崎市国民健康保険料の試算表\"","v":"令和８年度尼崎市国民健康保険料の試算表"}]
[{"$f":"\"令和\"&DBCS(E11)&\"年度尼崎市国民健康保険料　計算式詳細\"","v":"令和８年度尼崎市国民健康保険料　計算式詳細"}]
[{"$f":"\"この試算表では、令和\"&DBCS(E11)&\"年度のおおよその年間保険料と1ヶ月あたりの月額保険料の計算ができます。\"","v":"この試算表では、令和８年度のおおよその年間保険料と1ヶ月あたりの月額保険料の計算ができます。"}]
[{"$f":"\"年金収入があり、令和\"&DBCS(E11)&\"年１月２日以降に６５歳になられた場合\"","v":"年金収入があり、令和８年１月２日以降に６５歳になられた場合"}]
[{"$f":"\"保険料の料率は毎年改定されます。令和６年度の試算に使用される場合は、令和５年度の料率を使用した場合の参考の保険料額としてご使用ください。（\"&DBCS(E11-1)&\"年度以前の保険料額については、お問い合わせください。）\"","v":"保険料の料率は毎年改定されます。令和６年度の試算に使用される場合は、令和５年度の料率を使用した場合の参考の保険料額としてご使用ください。（７年度以前の保険料額については、お問い合わせください。）"}]