{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["試算表利用時の注意点","保険料の概要","保険料の詳細","保険料計算","パラメーター"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":10,"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":33,"n_cols":38,"rows_kept":33,"cut":false,"hidden":true,"merged":[[2,33,2,37],[5,1,6,3],[24,22,24,28],[26,22,26,28],[16,24,16,28],[25,14,25,19],[22,14,22,20],[24,14,24,20],[23,22,23,27],[25,22,25,27],[23,14,23,19],[12,32,12,36],[14,16,14,20],[8,24,8,28],[14,24,14,28],[14,32,14,36],[32,31,32,36],[30,5,30,11],[30,30,30,36],[27,22,27,27],[27,14,27,19],[30,22,30,27],[30,14,30,19],[29,30,29,37],[29,14,29,20],[29,22,29,28],[16,32,16,36],[18,24,18,28],[21,22,21,28],[30,1,30,4],[29,5,29,12],[27,1,27,4],[25,1,25,4],[26,5,26,12],[27,5,27,11],[25,5,25,11],[21,1,21,4],[21,5,21,12],[23,1,23,4],[22,5,22,12],[22,22,22,28],[26,14,26,20],[24,5,24,12],[10,7,10,13],[12,7,12,13],[16,16,16,20],[23,5,23,11],[21,14,21,20],[10,16,10,20],[7,15,7,21],[7,31,7,37],[18,7,18,13],[12,16,12,20],[12,24,12,28],[7,5,7,12],[8,7,8,13],[14,7,14,13],[16,7,16,13],[7,23,7,29],[18,32,18,36],[18,16,18,20],[8,32,8,36],[10,24,10,28],[10,32,10,36],[8,16,8,20]]}
[]
[]
[null,null,null,null,null,null,null,null,null,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":"2025-06-06"}]
[]
[null,"年齢区分"]
[null,"収入額等"]
[]
[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,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者１",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者２",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者３",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者４",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[null,"加入者５",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円",null,null,null,null,null,null,null,"円"]
[]
[]
[null,"区分",null,null,null,"医療分",null,null,null,null,null,null,null,null,"支援分",null,null,null,null,null,null,null,"介護分"]
[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":"保険料の詳細!Q10","v":0},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q28","v":0},null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q47","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,{"$f":"保険料の詳細!Q15","v":23400},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q33","v":9035},null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q52","v":3639},null,null,null,null,null,"円"]
[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":"保険料の詳細!Q18","v":5821},null,null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q36","v":2250},null,null,null,null,null,"円",null,{"$f":"保険料の詳細!Q54","v":1778},null,null,null,null,null,"円"]
[]
[null,null,null,null,null,{"$f":"パラメーター!A6&TEXT(パラメーター!B6/10000,\"#,###万円\")","v":"賦課限度額66万円"},null,null,null,null,null,null,null,null,{"$f":"パラメーター!A11&TEXT(パラメーター!B11/10000,\"#,###万円\")","v":"賦課限度額26万円"},null,null,null,null,null,null,null,{"$f":"パラメーター!A16&TEXT(パラメーター!B16/10000,\"#,###万円\")","v":"賦課限度額17万円"},null,null,null,null,null,null,null,"年間保険料"]
[null,"合計額",null,null,null,{"$f":"保険料の詳細!J21","v":29221},null,null,null,null,null,null,"円","+",{"$f":"保険料の詳細!J39","v":11285},null,null,null,null,null,"円","+",{"$f":"保険料の詳細!J57","v":5417},null,null,null,null,null,"円","=",{"$f":"保険料の詳細!Q60","v":45923},null,null,null,null,null,null,"円"]
[]
[null,{"$f":"IF(保険料計算!H22=0,\"\",\"均等割と平等割が\")","v":"均等割と平等割が"},null,null,null,null,null,null,null,{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!H23)","v":"7割"},null,{"$f":"IF(保険料計算!H22=0,\"\",\"軽減されています\")","v":"軽減されています"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1ヶ月あたりの保険料",null,{"$f":"保険料の詳細!Q62","v":3826.9166666666665},null,null,null,null,null,"円"]

{"sheet":"保険料の詳細","index":2,"n_rows":62,"n_cols":19,"rows_kept":62,"cut":false,"hidden":true,"merged":[[55,9,55,12],[61,16,61,19],[56,9,56,12],[57,8,57,9],[57,13,57,14],[59,16,59,19],[60,8,60,9],[60,13,60,14],[53,3,54,3],[53,13,53,14],[53,16,54,16],[53,17,54,18],[54,13,54,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],[37,9,37,12],[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],[35,3,36,3],[35,13,35,14],[35,16,36,16],[35,17,36,18],[36,13,36,14],[25,11,30,11],[23,3,31,3],[23,5,24,5],[25,13,30,13],[23,6,24,6],[32,3,34,3],[32,13,32,14],[32,16,34,16],[32,17,34,18],[34,13,34,14],[33,13,33,14],[27,16,28,16],[17,17,18,18],[18,13,18,14],[27,17,28,18],[17,16,18,16],[17,3,18,3],[17,13,17,14],[19,9,19,12],[20,9,20,12],[23,10,24,10],[23,11,24,11],[23,7,24,7],[23,8,24,8],[23,9,24,9],[23,12,24,12],[23,13,24,13],[14,3,16,3],[14,13,14,14],[14,16,16,16],[14,17,16,18],[16,13,16,14],[15,13,15,14],[5,13,6,13],[7,13,12,13],[7,11,12,11],[9,16,10,16],[9,17,10,18],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,3,13,3],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9]]}
[]
[]
[]
[]
[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":0},"－",{"$f":"IF(F8=\"\",\"\",IF(F8<=保険料計算!F2,F8,430000))","v":0},"＝",{"$f":"IF(F8=\"\",\"\",IF(F8=0,\"\",ROUNDDOWN(F8-H8,-3)))","v":""},null,{"$f":"SUM(J8:J13)","v":0},null,{"$f":"パラメーター!B5","v":8.0399999999999999E-2}]
[null,null,null,null,"加入者1",{"$f":"IF(保険料計算!C3=1,\"\",保険料計算!E3)","v":0},"－",{"$f":"IF(F9=\"\",\"\",IF(F9<=保険料計算!F2,F9,430000))","v":0},"＝",""]
[null,null,null,null,"加入者2",{"$f":"IF(保険料計算!C4=1,\"\",保険料計算!E4)","v":0},"－",{"$f":"IF(F10=\"\",\"\",IF(F10<=保険料計算!F2,F10,430000))","v":0},"＝","",null,null,null,null,null,null,{"$f":"ROUNDDOWN(L8*N8,0)","v":0},"…　(ア)"]
[null,null,null,null,"加入者3",{"$f":"IF(保険料計算!C5=1,\"\",保険料計算!E5)","v":""},"－",{"$f":"IF(F11=\"\",\"\",IF(F11<=保険料計算!F2,F11,430000))","v":""},"＝",""]
[null,null,null,null,"加入者4",{"$f":"IF(保険料計算!C6=1,\"\",保険料計算!E6)","v":""},"－",{"$f":"IF(F12=\"\",\"\",IF(F12<=保険料計算!F2,F12,430000))","v":""},"＝",""]
[null,null,null,null,"加入者5",{"$f":"IF(保険料計算!C7=1,\"\",保険料計算!E7)","v":""},"－",{"$f":"IF(F13=\"\",\"\",IF(F13<=保険料計算!F2,F13,430000))","v":""},"＝",""]
[]
[null,null,null,"均等割",null,null,null,"1人につき",null,{"$f":"パラメーター!B3","v":31200},"×",{"$f":"保険料計算!K2","v":3},"＝",{"$f":"J15*L15","v":93600},null,null,{"$f":"IF(AND(N16=\"\",N17=\"\"),N15,IF(N17=\"\",N15-N16,IF(N16=\"\",N15-N17,N15-N16-N17)))","v":23400},"…　(イ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!H22=0,\"\",\"減額：\")","v":"減額："},{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!H23)","v":"7割"},null,{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!J22)","v":21840},{"$f":"IF(保険料計算!H22=0,\"\",\"×\")","v":"×"},{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!K2)","v":3},{"$f":"IF(保険料計算!J22=0,\"\",\"=\")","v":"="},{"$f":"IF(保険料計算!H22=0,\"\",J16*L16)","v":65520}]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G2=0,\"\",\"子ども軽減\")","v":"子ども軽減"},null,null,{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!J31)","v":4680},{"$f":"IF(保険料計算!G2=0,\"\",\"×\")","v":"×"},{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!G2)","v":1},{"$f":"IF(保険料計算!G2=0,\"\",\"=\")","v":"="},{"$f":"IF(保険料計算!G2=0,\"\",J17*L17)","v":4680}]
[null,null,null,"平等割",null,null,null,"1世帯につき",null,{"$f":"パラメーター!B4","v":19404},null,null,null,{"$f":"IF(保険料計算!K2=0,\"\",パラメーター!B4)","v":19404},null,null,{"$f":"IF(AND(N18=\"\",N19=\"\"),0,IF(N19=\"\",N18,N18-N19))","v":5821},"…　(ウ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!H22=0,\"\",\"減額：\")","v":"減額："},{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!H23)","v":"7割"},null,{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!K22)","v":13583},null,null,null,{"$f":"J19","v":13583}]
[]
[null,null,null," 医療分の保険料 (ア)＋(イ)＋(ウ)",null,null,{"$f":"パラメーター!A6&TEXT(パラメーター!B6/10000,\"#,###万円\")&\"まで\"","v":"賦課限度額66万円まで"},null,null,{"$f":"IF(Q10+Q15+Q18>パラメーター!B6,パラメーター!B6,Q10+Q15+Q18)","v":29221},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":0},"－",{"$f":"IF(F26=\"\",\"\",IF(F26<=保険料計算!$F$2,F26,430000))","v":0},"＝",{"$f":"IF(F8=\"\",\"\",IF(F26=0,\"\",ROUNDDOWN(F26-H26,-3)))","v":""},null,{"$f":"SUM(J26:J31)","v":0},null,{"$f":"パラメーター!B10","v":3.1199999999999999E-2}]
[null,null,null,null,"加入者1",{"$f":"IF(保険料計算!C3=1,\"\",保険料計算!E3)","v":0},"－",{"$f":"IF(F27=\"\",\"\",IF(F27<=保険料計算!$F$2,F27,430000))","v":0},"＝",""]
[null,null,null,null,"加入者2",{"$f":"IF(保険料計算!C4=1,\"\",保険料計算!E4)","v":0},"－",{"$f":"IF(F28=\"\",\"\",IF(F28<=保険料計算!$F$2,F28,430000))","v":0},"＝","",null,null,null,null,null,null,{"$f":"ROUNDDOWN(L26*N26,0)","v":0},"…　(ア)"]
[null,null,null,null,"加入者3",{"$f":"IF(保険料計算!C5=1,\"\",保険料計算!E5)","v":""},"－",{"$f":"IF(F29=\"\",\"\",IF(F29<=保険料計算!$F$2,F29,430000))","v":""},"＝",""]
[null,null,null,null,"加入者4",{"$f":"IF(保険料計算!C6=1,\"\",保険料計算!E6)","v":""},"－",{"$f":"IF(F30=\"\",\"\",IF(F30<=保険料計算!$F$2,F30,430000))","v":""},"＝",""]
[null,null,null,null,"加入者5",{"$f":"IF(保険料計算!C7=1,\"\",保険料計算!E7)","v":""},"－",{"$f":"IF(F31=\"\",\"\",IF(F31<=保険料計算!$F$2,F31,430000))","v":""},"＝",""]
[]
[null,null,null,"均等割",null,null,null,"1人につき",null,{"$f":"パラメーター!B8","v":12048},"×",{"$f":"保険料計算!K2","v":3},"＝",{"$f":"J33*L33","v":36144},null,null,{"$f":"IF(AND(N34=\"\",N35=\"\"),N33,IF(N35=\"\",N33-N34,IF(N34=\"\",N33-N35,N33-N34-N35)))","v":9035},"…　(イ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!H22=0,\"\",\"減額：\")","v":"減額："},{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!H23)","v":"7割"},null,{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!J25)","v":8434},{"$f":"IF(保険料計算!H22=0,\"\",\"×\")","v":"×"},{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!K2)","v":3},{"$f":"IF(保険料計算!J22=0,\"\",\"=\")","v":"="},{"$f":"IF(保険料計算!H22=0,\"\",J34*L34)","v":25302}]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!G2=0,\"\",\"子ども軽減\")","v":"子ども軽減"},null,null,{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!J34)","v":1807},{"$f":"IF(保険料計算!G2=0,\"\",\"×\")","v":"×"},{"$f":"IF(保険料計算!G2=0,\"\",保険料計算!G2)","v":1},{"$f":"IF(保険料計算!G2=0,\"\",\"=\")","v":"="},{"$f":"IF(保険料計算!G2=0,\"\",J35*L35)","v":1807}]
[null,null,null,"平等割",null,null,null,"1世帯につき",null,{"$f":"パラメーター!B9","v":7500},null,null,null,{"$f":"IF(保険料計算!K2=0,\"\",パラメーター!B9)","v":7500},null,null,{"$f":"IF(AND(N36=\"\",N37=\"\"),0,IF(N37=\"\",N36,N36-N37))","v":2250},"…　(ウ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!H22=0,\"\",\"減額：\")","v":"減額："},{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!H23)","v":"7割"},null,{"$f":"IF(保険料計算!H22=0,\"\",保険料計算!K25)","v":5250},null,null,null,{"$f":"J37","v":5250}]
[]
[null,null,null," 支援分の保険料 (ア)＋(イ)＋(ウ)",null,null,{"$f":"パラメーター!A11&TEXT(パラメーター!B11/10000,\"#,###万円\")&\"まで\"","v":"賦課限度額26万円まで"},null,null,{"$f":"IF(Q28+Q33+Q36>パラメーター!B11,パラメーター!B11,Q28+Q33+Q36)","v":11285},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=4,IF(保険料計算!C2=1,\"\",保険料計算!E2),\"\")","v":0},"－",{"$f":"IF(F45=\"\",\"\",IF(F45<=保険料計算!$F$2,F45,430000))","v":0},"＝",{"$f":"IF(F45=\"\",\"\",IF(F45=0,\"\",ROUNDDOWN(F45-H45,-3)))","v":""},null,{"$f":"SUM(J45:J50)","v":0},null,{"$f":"パラメーター!B15","v":0.03}]
[null,null,null,null,"加入者1",{"$f":"IF(保険料計算!C3=4,IF(保険料計算!C3=1,\"\",保険料計算!E3),\"\")","v":""},"－",{"$f":"IF(F46=\"\",\"\",IF(F46<=保険料計算!$F$2,F46,430000))","v":""},"＝",""]
[null,null,null,null,"加入者2",{"$f":"IF(保険料計算!C4=4,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=4,IF(保険料計算!C5=1,\"\",保険料計算!E5),\"\")","v":""},"－",{"$f":"IF(F48=\"\",\"\",IF(F48<=保険料計算!$F$2,F48,430000))","v":""},"＝",""]
[null,null,null,null,"加入者4",{"$f":"IF(保険料計算!C6=4,IF(保険料計算!C6=1,\"\",保険料計算!E6),\"\")","v":""},"－",{"$f":"IF(F49=\"\",\"\",IF(F49<=保険料計算!$F$2,F49,430000))","v":""},"＝",""]
[null,null,null,null,"加入者5",{"$f":"IF(保険料計算!C7=4,IF(保険料計算!C7=1,\"\",保険料計算!E7),\"\")","v":""},"－",{"$f":"IF(F50=\"\",\"\",IF(F50<=保険料計算!$F$2,F50,430000))","v":""},"＝",""]
[]
[null,null,null,"均等割",null,null,null,"1人につき",null,{"$f":"パラメーター!B13","v":12132},"×",{"$f":"保険料計算!I2","v":1},"＝",{"$f":"J52*L52","v":12132},null,null,{"$f":"IF(N53=\"\",N52,N52-N53)","v":3639},"…　(イ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!H26=0,\"\",\"減額：\")","v":"減額："},{"$f":"IF(保険料計算!H26=0,\"\",保険料計算!H27)","v":"7割"},null,{"$f":"IF(保険料計算!H26=0,\"\",保険料計算!J28)","v":8493},{"$f":"IF(保険料計算!H26=0,\"\",\"×\")","v":"×"},{"$f":"IF(保険料計算!H26=0,\"\",保険料計算!I2)","v":1},{"$f":"IF(保険料計算!J26=0,\"\",\"=\")","v":""},{"$f":"IF(保険料計算!H26=0,\"\",J53*L53)","v":8493}]
[null,null,null,"平等割",null,null,null,"1世帯につき",null,{"$f":"パラメーター!B14","v":5928},null,null,null,{"$f":"IF(保険料計算!I2=0,\"\",パラメーター!B14)","v":5928},null,null,{"$f":"IF(AND(N54=\"\",N55=\"\"),0,IF(N55=\"\",N54,N54-N55))","v":1778},"…　(ウ)"]
[null,null,null,null,null,null,{"$f":"IF(保険料計算!H26=0,\"\",\"減額：\")","v":"減額："},{"$f":"IF(保険料計算!H26=0,\"\",保険料計算!H27)","v":"7割"},null,{"$f":"IF(保険料計算!H26=0,\"\",保険料計算!K28)","v":4150},null,null,null,{"$f":"J55","v":4150}]
[]
[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":5417},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+J57","v":45923}]
[]
[null,null,null,null,null,null,null,null,null,"1ヵ月当たりの国民健康保険料　（年間保険料／12ヶ月）",null,null,null,null,null,null,{"$f":"Q60/12","v":3826.9166666666665}]

{"sheet":"保険料計算","index":3,"n_rows":76,"n_cols":15,"rows_kept":76,"cut":false,"hidden":true,"merged":[[45,1,45,2],[59,1,59,2],[68,1,68,2]]}
["基礎情報",null,"加入区分","擬主判定","総所得金額","基礎控除額","未就学児","６歳から３９歳まで人数","４０歳から６４歳まで人数","６５歳から７４歳まで人数","合計人数"]
["年齢区分","世帯主",4,{"$f":"IF(C2=1,0,1)","v":1},{"$f":"H10","v":0},430000,{"$f":"COUNTIF(C2:C7,2)","v":1},{"$f":"COUNTIF(C2:C7,3)","v":1},{"$f":"COUNTIF(C2:C7,4)","v":1},{"$f":"COUNTIF(C2:C7,5)","v":0},{"$f":"G2+H2+I2+J2","v":3},{"$f":"IF(D2=0,IF(B10>550000,K2+1,K2),K2)","v":3}]
["加入しない","加入者１",3,null,0]
["未就学児","加入者２",2,null,0]
["６歳から３９歳まで","加入者３",1,null,0]
["４０歳から６４歳まで","加入者４",1,null,0]
["６５歳から７４歳まで","加入者５",1,null,0]
[null,null,{"$f":"SUM(加入者)","v":8}]
["所得内訳","給与収入額","給与所得額","年金収入額","年金所得額","年金特別控除判定","その他所得","合計所得","給与所得額","年金所得額","給与年金所得控除"]
["世帯主",{"$f":"保険料の概要!Q9","v":0},{"$f":"VLOOKUP(D58,D47:J57,7,0)-K10","v":0},{"$f":"保険料の概要!Y9","v":0},{"$f":"IF(C2=5,D67,D76)","v":0},{"$f":"IF(OR(C2=1,C2=5),IF(D10<=1100000,0,IF(D10>=1250000,-150000,1100000-D10)),0)","v":0},{"$f":"保険料の概要!AG9","v":0},{"$f":"C10+E10+G10","v":0},{"$f":"VLOOKUP(D58,D47:J57,7,0)","v":0},{"$f":"IF(C2=5,D67,D76)","v":0},{"$f":"IF(IF(I10>100000,100000,I10)+IF(J10>100000,100000,J10)-100000<0,0,IF(I10>100000,100000,I10)+IF(J10>100000,100000,J10)-100000)","v":0}]
["加入者１",{"$f":"保険料の概要!Q11","v":0},{"$f":"VLOOKUP(E58,E47:K57,7,0)-K11","v":0},{"$f":"保険料の概要!Y11","v":0},{"$f":"IF(C3=5,E67,E76)","v":0},{"$f":"IF(C3=5,IF(D11<=1100000,0,IF(D11>=1250000,-150000,1100000-D11)),0)","v":0},{"$f":"保険料の概要!AG11","v":0},{"$f":"IF(C3>1,C11+E11+G11,0)","v":0},{"$f":"VLOOKUP(E58,E47:K57,7,0)","v":0},{"$f":"IF(C3=5,E67,E76)","v":0},0]
["加入者２",{"$f":"保険料の概要!Q13","v":0},{"$f":"VLOOKUP(F58,F47:L57,7,0)-K12","v":0},{"$f":"保険料の概要!Y13","v":0},{"$f":"IF(C4=5,F67,F76)","v":0},0,{"$f":"保険料の概要!AG13","v":0},{"$f":"IF(C4>1,C12+E12+G12,0)","v":0},{"$f":"VLOOKUP(F58,F47:L57,7,0)","v":0},{"$f":"IF(C4=5,F67,F76)","v":0},0]
["加入者３",{"$f":"保険料の概要!Q15","v":0},{"$f":"VLOOKUP(G58,G47:M57,7,0)-K13","v":0},{"$f":"保険料の概要!Y15","v":0},{"$f":"IF(C5=5,G67,G76)","v":0},0,{"$f":"保険料の概要!AG15","v":0},{"$f":"IF(C5>1,C13+E13+G13,0)","v":0},{"$f":"VLOOKUP(G58,G47:M57,7,0)","v":0},{"$f":"IF(C5=5,G67,G76)","v":0},0]
["加入者４",{"$f":"保険料の概要!Q17","v":0},{"$f":"VLOOKUP(H58,H47:N57,7,0)-K14","v":0},{"$f":"保険料の概要!Y17","v":0},{"$f":"IF(C6=5,H67,H76)","v":0},0,{"$f":"保険料の概要!AG17","v":0},{"$f":"IF(C6>1,C14+E14+G14,0)","v":0},{"$f":"VLOOKUP(H58,H47:N57,7,0)","v":0},{"$f":"IF(C6=5,H67,H76)","v":0},0]
["加入者５",{"$f":"保険料の概要!Q19","v":0},{"$f":"VLOOKUP(I58,I47:O57,7,0)-K15","v":0},{"$f":"保険料の概要!Y19","v":0},{"$f":"IF(C7=5,I67,I76)","v":0},0,{"$f":"保険料の概要!AG19","v":0},{"$f":"IF(C7>1,C15+E15+G15,0)","v":0},{"$f":"VLOOKUP(I58,I47:O57,7,0)","v":0},{"$f":"IF(C7=5,I67,I76)","v":0},0]
[null,null,null,null,null,{"$f":"SUM(F10:F15)","v":0}]
[]
[null,null,null,null,null,null,null,"軽減判定所得"]
[null,null,null,null,"医療子ども均等割軽減額",null,"支援子ども均等割軽減額",{"$f":"SUM(H10:H15)+F16","v":0}]
[null,null,null,7,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B3*0.3,0)/2,0)","v":4680},7,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B8*0.3,0)/2,0)","v":1807}]
[null,null,null,5,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B3*0.5,0)/2,0)","v":7800},5,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B8*0.5,0)/2,0)","v":3012},"医・支軽減判定",null,"医療均等割","医療平等割"]
[null,null,null,2,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B3*0.8,0)/2,0)","v":12480},2,{"$f":"ROUNDUP(ROUNDDOWN(パラメーター!B8*0.8,0)/2,0)","v":4819},{"$f":"VLOOKUP(K2,A27:B33,2,0)","v":7},"割",{"$f":"VLOOKUP(H22,D26:E29,2,0)","v":21840},{"$f":"VLOOKUP(H22,F26:G29,2,0)","v":13583}]
[null,null,null,0,{"$f":"ROUNDUP(パラメーター!B3/2,0)","v":15600},0,{"$f":"ROUNDUP(パラメーター!B8/2,0)","v":6024},{"$f":"CONCATENATE(H22,I22)","v":"7割"}]
[null,null,null,null,null,null,null,null,null,"支援均等割","支援平等割"]
[null,null,null,null,"医療均等割軽減額",null,"医療平等割軽減額","介護軽減判定",null,{"$f":"VLOOKUP(H22,D32:E35,2,0)","v":8434},{"$f":"VLOOKUP(H22,F32:G35,2,0)","v":5250}]
["人数","軽減割合",null,7,{"$f":"ROUNDUP(パラメーター!B3*0.7,0)","v":21840},7,{"$f":"ROUNDUP(パラメーター!B4*0.7,0)","v":13583},{"$f":"IF(I2>=1,H22,0)","v":7},"割"]
[1,{"$f":"MAX(パラメーター!C19,パラメーター!E19,パラメーター!G19)","v":7},null,5,{"$f":"ROUNDUP(パラメーター!B3*0.5,0)","v":15600},5,{"$f":"ROUNDUP(パラメーター!B4*0.5,0)","v":9702},{"$f":"CONCATENATE(H26,I26)","v":"7割"},null,"介護均等割","介護平等割"]
[2,{"$f":"MAX(パラメーター!C20,パラメーター!E20,パラメーター!G20)","v":7},null,2,{"$f":"ROUNDUP(パラメーター!B3*0.2,0)","v":6240},2,{"$f":"ROUNDUP(パラメーター!B4*0.2,0)","v":3881},null,null,{"$f":"VLOOKUP(H22,D38:E41,2,0)","v":8493},{"$f":"VLOOKUP(H22,F38:G41,2,0)","v":4150}]
[3,{"$f":"MAX(パラメーター!C21,パラメーター!E21,パラメーター!G21)","v":7},null,0,null,0,null,"子ども軽減判定"]
[4,{"$f":"MAX(パラメーター!C22,パラメーター!E22,パラメーター!G22)","v":7},null,null,null,null,null,{"$f":"IF(G2>=1,H22,0)","v":7},"割","医療子ども軽減"]
[5,{"$f":"MAX(パラメーター!C23,パラメーター!E23,パラメーター!G23)","v":7},null,null,"支援均等割軽減額",null,"支援平等割軽減額",{"$f":"CONCATENATE(H30,I30)","v":"7割"},null,{"$f":"VLOOKUP(H30,D20:E23,2,0)","v":4680}]
[6,{"$f":"MAX(パラメーター!C24,パラメーター!E24,パラメーター!G24)","v":7},null,7,{"$f":"ROUNDUP(パラメーター!B8*0.7,0)","v":8434},7,{"$f":"ROUNDUP(パラメーター!B9*0.7,0)","v":5250}]
[0,null,null,5,{"$f":"ROUNDUP(パラメーター!B8*0.5,0)","v":6024},5,{"$f":"ROUNDUP(パラメーター!B9*0.5,0)","v":3750},null,null,"支援子ども軽減"]
[null,null,null,2,{"$f":"ROUNDUP(パラメーター!B8*0.2,0)","v":2410},2,{"$f":"ROUNDUP(パラメーター!B9*0.2,0)","v":1500},null,null,{"$f":"VLOOKUP(H30,F20:G23,2,0)","v":1807}]
[null,null,null,0,null,0]
[]
[null,null,null,null,"介護均等割軽減額",null,"介護平等割軽減額"]
[null,null,null,7,{"$f":"ROUNDUP(パラメーター!B13*0.7,0)","v":8493},7,{"$f":"ROUNDUP(パラメーター!B14*0.7,0)","v":4150}]
[null,null,null,5,{"$f":"ROUNDUP(パラメーター!B13*0.5,0)","v":6066},5,{"$f":"ROUNDUP(パラメーター!B14*0.5,0)","v":2964}]
[null,null,null,2,{"$f":"ROUNDUP(パラメーター!B13*0.2,0)","v":2427},2,{"$f":"ROUNDUP(パラメーター!B14*0.2,0)","v":1186}]
[null,null,null,0,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"給与所得額"]
["給与所得計算","給与収入",null,"世帯主","加入者１","加入者２","加入者３","加入者４","加入者５","世帯主","加入者１","加入者２","加入者３","加入者４","加入者５"]
["給与収入",0,550999,{"$f":"IF($B10<=$C47,0,\"\")","v":0},{"$f":"IF($B$11<=$C47,0,\"\")","v":0},{"$f":"IF($B$12<=$C47,0,\"\")","v":0},{"$f":"IF($B$13<=$C47,0,\"\")","v":0},{"$f":"IF($B$14<=$C47,0,\"\")","v":0},{"$f":"IF($B$15<=$C47,0,\"\")","v":0},0,0,0,0,0,0]
[null,551000,1618999,{"$f":"IF(B10<=C48,1,\"\")","v":1},{"$f":"IF($B$11<=$C48,1,\"\")","v":1},{"$f":"IF($B$12<=$C48,1,\"\")","v":1},{"$f":"IF($B$13<=$C48,1,\"\")","v":1},{"$f":"IF($B$14<=$C48,1,\"\")","v":1},{"$f":"IF($B$15<=$C48,1,\"\")","v":1},{"$f":"B10-550000","v":-550000},{"$f":"B11-550000","v":-550000},{"$f":"B12-550000","v":-550000},{"$f":"B13-550000","v":-550000},{"$f":"B14-550000","v":-550000},{"$f":"B15-550000","v":-550000}]
[null,1619000,1619999,{"$f":"IF(B10<=C49,2,\"\")","v":2},{"$f":"IF($B$11<=$C49,2,\"\")","v":2},{"$f":"IF($B$12<=$C49,2,\"\")","v":2},{"$f":"IF($B$13<=$C49,2,\"\")","v":2},{"$f":"IF($B$14<=$C49,2,\"\")","v":2},{"$f":"IF($B$15<=$C49,2,\"\")","v":2},1069000,1069000,1069000,1069000,1069000,1069000]
[null,1620000,1621999,{"$f":"IF(B10<=C50,3,\"\")","v":3},{"$f":"IF($B$11<=$C50,3,\"\")","v":3},{"$f":"IF($B$12<=$C50,3,\"\")","v":3},{"$f":"IF($B$13<=$C50,3,\"\")","v":3},{"$f":"IF($B$14<=$C50,3,\"\")","v":3},{"$f":"IF($B$15<=$C50,3,\"\")","v":3},1070000,1070000,1070000,1070000,1070000,1070000]
[null,1622000,1623999,{"$f":"IF(B10<C51,4,\"\")","v":4},{"$f":"IF($B$11<=$C51,4,\"\")","v":4},{"$f":"IF($B$12<=$C51,4,\"\")","v":4},{"$f":"IF($B$13<=$C51,4,\"\")","v":4},{"$f":"IF($B$14<=$C51,4,\"\")","v":4},{"$f":"IF($B$15<=$C51,4,\"\")","v":4},1072000,1072000,1072000,1072000,1072000,1072000]
[null,1624000,1627999,{"$f":"IF(B10<=C52,5,\"\")","v":5},{"$f":"IF($B$11<=$C52,5,\"\")","v":5},{"$f":"IF($B$12<=$C52,5,\"\")","v":5},{"$f":"IF($B$13<=$C52,5,\"\")","v":5},{"$f":"IF($B$14<=$C52,5,\"\")","v":5},{"$f":"IF($B$15<=$C52,5,\"\")","v":5},1074000,1074000,1074000,1074000,1074000,1074000]
[null,1628000,1799999,{"$f":"IF(B10<=C53,6,\"\")","v":6},{"$f":"IF($B$11<=$C53,6,\"\")","v":6},{"$f":"IF($B$12<=$C53,6,\"\")","v":6},{"$f":"IF($B$13<=$C53,6,\"\")","v":6},{"$f":"IF($B$14<=$C53,6,\"\")","v":6},{"$f":"IF($B$15<=$C53,6,\"\")","v":6},{"$f":"ROUNDDOWN(B10/4,-3)*2.4+100000","v":100000},{"$f":"ROUNDDOWN(B11/4,-3)*2.4+100000","v":100000},{"$f":"ROUNDDOWN(B12/4,-3)*2.4+100000","v":100000},{"$f":"ROUNDDOWN(B13/4,-3)*2.4+100000","v":100000},{"$f":"ROUNDDOWN(B14/4,-3)*2.4+100000","v":100000},{"$f":"ROUNDDOWN(B15/4,-3)*2.4+100000","v":100000}]
[null,1800000,3599999,{"$f":"IF(B10<=C54,7,\"\")","v":7},{"$f":"IF($B$11<=$C54,7,\"\")","v":7},{"$f":"IF($B$12<=$C54,7,\"\")","v":7},{"$f":"IF($B$13<=$C54,7,\"\")","v":7},{"$f":"IF($B$14<=$C54,7,\"\")","v":7},{"$f":"IF($B$15<=$C54,7,\"\")","v":7},{"$f":"ROUNDDOWN(B10/4,-3)*2.8-80000","v":-80000},{"$f":"ROUNDDOWN(B11/4,-3)*2.8-80000","v":-80000},{"$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}]
[null,3600000,6599999,{"$f":"IF(B10<=C55,8,\"\")","v":8},{"$f":"IF($B$11<=$C55,8,\"\")","v":8},{"$f":"IF($B$12<=$C55,8,\"\")","v":8},{"$f":"IF($B$13<=$C55,8,\"\")","v":8},{"$f":"IF($B$14<=$C55,8,\"\")","v":8},{"$f":"IF($B$15<=$C55,8,\"\")","v":8},{"$f":"ROUNDDOWN(B10/4,-3)*3.2-440000","v":-440000},{"$f":"ROUNDDOWN(B11/4,-3)*3.2-440000","v":-440000},{"$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}]
[null,6600000,8499999,{"$f":"IF(B10<=C56,9,\"\")","v":9},{"$f":"IF($B$11<=$C56,9,\"\")","v":9},{"$f":"IF($B$12<=$C56,9,\"\")","v":9},{"$f":"IF($B$13<=$C56,9,\"\")","v":9},{"$f":"IF($B$14<=$C56,9,\"\")","v":9},{"$f":"IF($B$15<=$C56,9,\"\")","v":9},{"$f":"B10*0.9-1100000","v":-1100000},{"$f":"B11*0.9-1100000","v":-1100000},{"$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}]
[null,8500000,null,{"$f":"IF(B10>=B57,10,\"\")","v":""},{"$f":"IF(B11>=B57,10,\"\")","v":""},{"$f":"IF(B12>=B57,10,\"\")","v":""},{"$f":"IF(B13>=B57,10,\"\")","v":""},{"$f":"IF(B14>=B57,10,\"\")","v":""},{"$f":"IF(B15>=B57,10,\"\")","v":""},{"$f":"B10-1950000","v":-1950000},{"$f":"B11-1950000","v":-1950000},{"$f":"B12-1950000","v":-1950000},{"$f":"B13-1950000","v":-1950000},{"$f":"B14-1950000","v":-1950000},{"$f":"B15-1950000","v":-1950000}]
[null,null,null,{"$f":"MIN(D47:D57)","v":0},0,0,0,0,0]
[]
["年金収入","６５歳以上",null,"世帯主","加入者１","加入者２","加入者３","加入者４","加入者５","世帯主","加入者１","加入者２","加入者３","加入者４","加入者５"]
[null,0,1100000,{"$f":"IF($D$10<=$C61,0,\"\")","v":0},{"$f":"IF($D$11<=$C61,0,\"\")","v":0},{"$f":"IF($D$12<=$C61,0,\"\")","v":0},{"$f":"IF($D$13<=$C61,0,\"\")","v":0},{"$f":"IF($D$14<=$C61,0,\"\")","v":0},{"$f":"IF($D$15<=$C61,0,\"\")","v":0},0,0,0,0,0,0]
[null,1100001,3299999,{"$f":"IF($D$10<=C62,1,\"\")","v":1},{"$f":"IF($D$11<=$C62,1,\"\")","v":1},{"$f":"IF($D$12<=$C62,1,\"\")","v":1},{"$f":"IF($D$13<=$C62,1,\"\")","v":1},{"$f":"IF($D$14<=$C62,1,\"\")","v":1},{"$f":"IF($D$15<=$C62,1,\"\")","v":1},{"$f":"D10-1100000","v":-1100000},{"$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}]
[null,3300000,4099999,{"$f":"IF($D$10<=C63,2,\"\")","v":2},{"$f":"IF($D$11<=$C63,2,\"\")","v":2},{"$f":"IF($D$12<=$C63,2,\"\")","v":2},{"$f":"IF($D$13<=$C63,2,\"\")","v":2},{"$f":"IF($D$14<=$C63,2,\"\")","v":2},{"$f":"IF($D$15<=$C63,2,\"\")","v":2},{"$f":"D10*0.75-275000","v":-275000},{"$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}]
[null,4100000,7699999,{"$f":"IF($D$10<=C64,3,\"\")","v":3},{"$f":"IF($D$11<=$C64,3,\"\")","v":3},{"$f":"IF($D$12<=$C64,3,\"\")","v":3},{"$f":"IF($D$13<=$C64,3,\"\")","v":3},{"$f":"IF($D$14<=$C64,3,\"\")","v":3},{"$f":"IF($D$15<=$C64,3,\"\")","v":3},{"$f":"D10*0.85-685000","v":-685000},{"$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}]
[null,7700000,9999999,{"$f":"IF($D$10>=B65,4,\"\")","v":""},{"$f":"IF(D11>=$B$65,4,\"\")","v":""},{"$f":"IF(D12>=$B$65,4,\"\")","v":""},{"$f":"IF(D13>=$B$65,4,\"\")","v":""},{"$f":"IF(D14>=$B$65,4,\"\")","v":""},{"$f":"IF(D15>=$B$65,4,\"\")","v":""},{"$f":"D10*0.95-1455000","v":-1455000},{"$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}]
[null,null,null,{"$f":"MIN(D61:D65)","v":0},0,0,0,0,0]
[null,null,null,{"$f":"VLOOKUP(D66,D61:J65,7,0)","v":0},0,0,0,0,0]
[]
[null,"６４歳未満",null,"世帯主","加入者１","加入者２","加入者３","加入者４","加入者５","世帯主","加入者１","加入者２","加入者３","加入者４","加入者５"]
[null,0,600000,{"$f":"IF($D$10<=$C70,0,\"\")","v":0},{"$f":"IF($D$11<=$C70,0,\"\")","v":0},{"$f":"IF($D$12<=$C70,0,\"\")","v":0},{"$f":"IF($D$13<=$C70,0,\"\")","v":0},{"$f":"IF($D$14<=$C70,0,\"\")","v":0},{"$f":"IF($D$15<=$C70,0,\"\")","v":0},0,0,0,0,0,0]
[null,600001,1299999,{"$f":"IF($D$10<=C71,1,\"\")","v":1},{"$f":"IF($D$11<=$C71,1,\"\")","v":1},{"$f":"IF($D$12<=$C71,1,\"\")","v":1},{"$f":"IF($D$13<=$C71,1,\"\")","v":1},{"$f":"IF($D$14<=$C71,1,\"\")","v":1},{"$f":"IF($D$15<=$C71,1,\"\")","v":1},{"$f":"D10-600000","v":-600000},{"$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}]
[null,1300000,4099999,{"$f":"IF($D$10<=C72,2,\"\")","v":2},{"$f":"IF($D$11<=$C72,2,\"\")","v":2},{"$f":"IF($D$12<=$C72,2,\"\")","v":2},{"$f":"IF($D$13<=$C72,2,\"\")","v":2},{"$f":"IF($D$14<=$C72,2,\"\")","v":2},{"$f":"IF($D$15<=$C72,2,\"\")","v":2},{"$f":"D10*0.75-275000","v":-275000},{"$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}]
[null,4100000,7699999,{"$f":"IF($D$10<=C73,3,\"\")","v":3},{"$f":"IF($D$11<=$C73,3,\"\")","v":3},{"$f":"IF($D$12<=$C73,3,\"\")","v":3},{"$f":"IF($D$13<=$C73,3,\"\")","v":3},{"$f":"IF($D$14<=$C73,3,\"\")","v":3},{"$f":"IF($D$15<=$C73,3,\"\")","v":3},{"$f":"D10*0.85-685000","v":-685000},{"$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}]
[null,7700000,9999999,{"$f":"IF($D$10>=B74,4,\"\")","v":""},{"$f":"IF(D11>=$B$65,4,\"\")","v":""},{"$f":"IF(D12>=$B$65,4,\"\")","v":""},{"$f":"IF(D13>=$B$65,4,\"\")","v":""},{"$f":"IF(D14>=$B$65,4,\"\")","v":""},{"$f":"IF(D15>=$B$65,4,\"\")","v":""},{"$f":"D10*0.95-1455000","v":-1455000},{"$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}]
[null,null,null,{"$f":"MIN(D70:D74)","v":0},0,0,0,0,0]
[null,null,null,{"$f":"VLOOKUP(D75,D70:J74,7,0)","v":0},0,0,0,0,0]

{"sheet":"パラメーター","index":4,"n_rows":33,"n_cols":18,"rows_kept":33,"cut":false,"hidden":true,"merged":[[6,0,6,1],[11,0,11,1],[1,14,2,14],[1,15,2,15],[1,16,2,16],[1,11,2,11],[1,12,2,12],[1,13,2,13],[1,0,1,1]]}
["料率等パラメーター"]
["医療分",null,null,null,null,null,null,null,null,null,null,"給与\n所得者数","一般収入","年金収入\n65歳未満","年金収入\n65歳以上","合計","計算値","控除額"]
["均等割",31200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000]
["平等割",19404,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(保険料計算!B10>550000,1,0)","v":0},{"$f":"IF(保険料計算!C2=3,IF(保険料計算!D10>600000,1,0),0)","v":0},{"$f":"IF(保険料計算!C2=4,IF(保険料計算!D10>1250000,1,0),0)","v":0},{"$f":"SUM(M4:O4)","v":0},{"$f":"MAX(P4-1,)","v":0}]
["所得割",8.0399999999999999E-2,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(保険料計算!B11>550000,M4+1,M4)","v":0},{"$f":"IF(保険料計算!C3=3,IF(保険料計算!D11>600000,N4+1,N4),N4)","v":0},{"$f":"IF(保険料計算!C3=4,IF(保険料計算!D11>1250000,O4+1,O4),O4)","v":0},{"$f":"SUM(M5:O5)","v":0},{"$f":"MAX(P5-1,)","v":0}]
["賦課限度額",660000,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(保険料計算!B12>550000,M5+1,M5)","v":0},{"$f":"IF(保険料計算!C4=3,IF(保険料計算!D12>600000,N5+1,N5),N5)","v":0},{"$f":"IF(保険料計算!C4=4,IF(保険料計算!D12>1250000,O5+1,O5),O5)","v":0},0,0]
["支援分",null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(保険料計算!B13>550000,M6+1,M6)","v":0},{"$f":"IF(保険料計算!C5=3,IF(保険料計算!D13>600000,N6+1,N6),N6)","v":0},{"$f":"IF(保険料計算!C5=4,IF(保険料計算!D13>1250000,O6+1,O6),O6)","v":0},0,0]
["均等割",12048,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(保険料計算!B14>550000,M7+1,M7)","v":0},{"$f":"IF(保険料計算!C6=3,IF(保険料計算!D14>600000,N7+1,N7),N7)","v":0},{"$f":"IF(保険料計算!C6=4,IF(保険料計算!D14>1250000,O7+1,O7),O7)","v":0},0,0]
["平等割",7500,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(保険料計算!B15>550000,M8+1,M8)","v":0},{"$f":"IF(保険料計算!C7=3,IF(保険料計算!D15>600000,N8+1,N8),N8)","v":0},{"$f":"IF(保険料計算!C7=4,IF(保険料計算!D15>1250000,O8+1,O8),O8)","v":0},0,0]
["所得割",3.1199999999999999E-2]
["賦課限度額",260000,null,"年度",7]
["介護分"]
["均等割",12132]
["平等割",5928]
["所得割",0.03]
["賦課限度額",170000]
[]
["軽減判定パラメーター","７割",430000,"５割",305000,"２割",560000]
[1,{"$f":"$C$18","v":430000},{"$f":"IF(B19>=保険料計算!$H$19,7,\"\")","v":7},{"$f":"430000+A19*$E$18","v":735000},{"$f":"IF(D19>=保険料計算!$H$19,5,\"\")","v":5},{"$f":"430000+A19*$G$18","v":990000},{"$f":"IF(F19>=保険料計算!$H$19,2,\"\")","v":2}]
[2,{"$f":"$C$18+$R$3*Q5","v":430000},{"$f":"IF(B20>=保険料計算!$H$19,7,\"\")","v":7},{"$f":"430000+A20*$E$18+$R$3*Q5","v":1040000},{"$f":"IF(D20>=保険料計算!$H$19,5,\"\")","v":5},{"$f":"430000+A20*$G$18+$R$3*Q5","v":1550000},{"$f":"IF(F20>=保険料計算!$H$19,2,\"\")","v":2}]
[3,{"$f":"$C$18+$R$3*Q6","v":430000},{"$f":"IF(B21>=保険料計算!$H$19,7,\"\")","v":7},{"$f":"430000+A21*$E$18+$R$3*Q6","v":1345000},{"$f":"IF(D21>=保険料計算!$H$19,5,\"\")","v":5},{"$f":"430000+A21*$G$18+$R$3*Q6","v":2110000},{"$f":"IF(F21>=保険料計算!$H$19,2,\"\")","v":2}]
[4,{"$f":"$C$18+$R$3*Q7","v":430000},{"$f":"IF(B22>=保険料計算!$H$19,7,\"\")","v":7},{"$f":"430000+A22*$E$18+$R$3*Q7","v":1650000},{"$f":"IF(D22>=保険料計算!$H$19,5,\"\")","v":5},{"$f":"430000+A22*$G$18+$R$3*Q7","v":2670000},{"$f":"IF(F22>=保険料計算!$H$19,2,\"\")","v":2}]
[5,{"$f":"$C$18+$R$3*Q8","v":430000},{"$f":"IF(B23>=保険料計算!$H$19,7,\"\")","v":7},{"$f":"430000+A23*$E$18+$R$3*Q8","v":1955000},{"$f":"IF(D23>=保険料計算!$H$19,5,\"\")","v":5},{"$f":"430000+A23*$G$18+$R$3*Q8","v":3230000},{"$f":"IF(F23>=保険料計算!$H$19,2,\"\")","v":2}]
[6,{"$f":"$C$18+$R$3*Q9","v":430000},{"$f":"IF(B24>=保険料計算!$H$19,7,\"\")","v":7},{"$f":"430000+A24*$E$18+$R$3*Q9","v":2260000},{"$f":"IF(D24>=保険料計算!$H$19,5,\"\")","v":5},{"$f":"430000+A24*$G$18+$R$3*Q9","v":3790000},{"$f":"IF(F24>=保険料計算!$H$19,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":"保険料の料率は毎年改定されます。令和６年度の試算に使用される場合は、令和５年度の料率を使用した場合の参考の保険料額としてご使用ください。（６年度以前の保険料額については、お問い合わせください。）"}]