{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["加入情報入力用","世帯情報入力用","試算結果","世帯賦課条件","試算年度条件","各年度 料率"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,0,0,1],[3,0,3,1]]}
["加入情報"]
[]
["過年度試算 ","次年度試算 "]
["↑現年度試算はチェック不要↑"]
["年度",{"$f":"IF(世帯情報入力用!A4=\"\",\"\",世帯情報入力用!A4)","v":7}]
["開始月",4]
["終了月",3]
["手続き月",null,{"$f":"IF(B17=TRUE,\"←入力不要\",\"\")","v":""}]
[]
["保険料額",{"$f":"IF(OR(B6=\"\",B7=\"\"),\"\",ROUNDDOWN(世帯賦課条件!B31*(B21-B20+1)/12,0))","v":0}]
["期割回数",{"$f":"IF(AND(B16=FALSE,B17=FALSE,B8=\"\"),\"\",IF(B16=TRUE,1,IF(B17=TRUE,10,VLOOKUP(B8,$A$22:$C$33,3,0))))","v":""}]
[]
["今年度75歳 "]
[{"$f":"IF(B18=TRUE,\"誕生日月\",\"\")","v":""},null,{"$f":"IF(AND(B18=TRUE,B14=\"\"),\"←誕生日月入力\",\"\")","v":""}]
[]
["過年度試算",false]
["次年度試算",false]
["75歳 誕生日",false]
["誕生日月前月",{"$f":"IF(B14=\"\",\"\",IF(B14=1,12,B14-1))","v":""}]
["月分 開始値",{"$f":"VLOOKUP(B6,$A$22:$B$33,2,0)","v":1}]
["月分 終了値",{"$f":"VLOOKUP(B7,$A$22:$B$33,2,0)","v":12}]
[4,1,10]
[5,2,10]
[6,3,9]
[7,4,8]
[8,5,7]
[9,6,6]
[10,7,5]
[11,8,4]
[12,9,3]
[1,10,2]
[2,11,1]
[3,12,1]

{"sheet":"世帯情報入力用","index":1,"n_rows":25,"n_cols":31,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,1,0],[4,0,5,0],[6,0,7,0],[17,19,17,22],[18,19,18,22],[9,3,10,4],[2,1,3,2],[2,3,3,4],[6,1,7,2],[16,1,16,4],[17,1,17,4],[18,1,18,4],[12,7,12,8],[13,7,13,8],[14,7,14,8],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,1,15,4],[6,3,7,4],[8,7,8,8],[8,9,8,10],[9,9,10,10],[15,25,15,28],[16,25,16,28],[17,25,17,28],[15,19,15,22],[16,19,16,22],[18,25,18,28],[2,25,3,26],[2,27,3,28],[6,25,7,26],[6,27,7,28],[8,25,8,26],[8,27,8,28],[9,25,9,26],[2,19,3,20],[2,21,3,22],[6,19,7,20],[6,21,7,22],[13,27,13,28],[14,27,14,28],[12,25,12,26],[13,25,13,26],[14,25,14,26],[10,25,10,26],[11,25,11,26],[2,13,3,14],[8,13,8,14],[15,13,15,16],[16,13,16,16],[17,13,17,16],[18,13,18,16],[2,7,3,8],[2,9,3,10],[21,1,21,2],[17,7,17,10],[18,7,18,10],[6,7,7,8],[6,9,7,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,7,15,10],[16,7,16,10],[11,9,11,10],[9,7,9,8],[10,7,10,8],[11,7,11,8],[9,1,9,2],[10,1,10,2],[13,13,13,14],[14,13,14,14],[8,15,8,16],[9,13,9,14],[10,13,10,14],[11,13,11,14],[12,15,12,16],[24,1,24,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[22,1,22,2],[23,1,23,2],[11,1,11,2],[8,1,8,2],[8,3,8,4],[9,27,10,28],[11,27,11,28],[12,27,12,28],[2,15,3,16],[6,13,7,14],[6,15,7,16],[12,19,12,20],[13,19,13,20],[14,19,14,20],[12,21,12,22],[13,21,13,22],[14,21,14,22],[8,19,8,20],[8,21,8,22],[9,19,9,20],[10,19,10,20],[11,19,11,20],[9,21,10,22],[11,21,11,22],[13,15,13,16],[14,15,14,16],[9,15,10,16],[11,15,11,16],[12,13,12,14]]}
["保険料試算"]
[]
["年度","加入者1",null,{"$f":"IF(OR(B6=\"\",C6=\"\",D6=\"\",E6=\"\"),\"4月末  歳\",\"4月末 \"&G17&\"歳\")","v":"4月末  歳"},null,"今年度→西暦",{"$f":"IF($A$4=\"\",\"\",$A$4+2018)","v":2025},"加入者2",null,{"$f":"IF(OR(H6=\"\",I6=\"\",J6=\"\",K6=\"\"),\"4月末  歳\",\"4月末 \"&M17&\"歳\")","v":"4月末  歳"},null,"今年度→西暦",{"$f":"IF($A$4=\"\",\"\",$A$4+2018)","v":2025},"加入者3",null,{"$f":"IF(OR(N6=\"\",O6=\"\",P6=\"\",Q6=\"\"),\"4月末  歳\",\"4月末 \"&S17&\"歳\")","v":"4月末  歳"},null,"今年度→西暦",{"$f":"IF($A$4=\"\",\"\",$A$4+2018)","v":2025},"加入者4",null,{"$f":"IF(OR(T6=\"\",U6=\"\",V6=\"\",W6=\"\"),\"4月末  歳\",\"4月末 \"&Y17&\"歳\")","v":"4月末  歳"},null,"今年度→西暦",{"$f":"IF($A$4=\"\",\"\",$A$4+2018)","v":2025},"加入者5",null,{"$f":"IF(OR(Z6=\"\",AA6=\"\",AB6=\"\",AC6=\"\"),\"4月末  歳\",\"4月末点 \"&AE17&\"歳\")","v":"4月末  歳"},null,"今年度→西暦",{"$f":"IF($A$4=\"\",\"\",$A$4+2018)","v":2025}]
[7,null,null,null,null,"西暦変換",{"$f":"IF(B6=\"西暦\",C6,IF(B6=\"昭和\",C6+1925,IF(B6=\"平成\",C6+1988,IF(B6=\"令和\",C6+2018,\"\"))))","v":""},null,null,null,null,"西暦変換",{"$f":"IF(H6=\"西暦\",I6,IF(H6=\"昭和\",I6+1925,IF(H6=\"平成\",I6+1988,IF(H6=\"令和\",I6+2018,\"\"))))","v":""},null,null,null,null,"西暦変換",{"$f":"IF(N6=\"西暦\",O6,IF(N6=\"昭和\",O6+1925,IF(N6=\"平成\",O6+1988,IF(N6=\"令和\",O6+2018,\"\"))))","v":""},null,null,null,null,"西暦変換",{"$f":"IF(T6=\"西暦\",U6,IF(T6=\"昭和\",U6+1925,IF(T6=\"平成\",U6+1988,IF(T6=\"令和\",U6+2018,\"\"))))","v":""},null,null,null,null,"西暦変換",{"$f":"IF(Z6=\"西暦\",AA6,IF(Z6=\"昭和\",AA6+1925,IF(Z6=\"平成\",AA6+1988,IF(Z6=\"令和\",AA6+2018,\"\"))))","v":""}]
["生年月日","暦","年","月","日","未就学児",{"$f":"IF(OR(B6=\"\",C6=\"\",D6=\"\",E6=\"\"),\"FALSE\",IF(AND(G17>=0,G17<6),\"TRUE\",\"FALSE\"))","v":"FALSE"},"暦","年","月","日","未就学児",{"$f":"IF(OR(H6=\"\",I6=\"\",J6=\"\",K6=\"\"),\"FALSE\",IF(AND(M17>=0,M17<6),\"TRUE\",\"FALSE\"))","v":"FALSE"},"暦","年","月","日","未就学児",{"$f":"IF(OR(N6=\"\",O6=\"\",P6=\"\",Q6=\"\"),\"FALSE\",IF(AND(S17>=0,S17<6),\"TRUE\",\"FALSE\"))","v":"FALSE"},"暦","年","月","日","未就学児",{"$f":"IF(OR(T6=\"\",U6=\"\",V6=\"\",W6=\"\"),\"FALSE\",IF(AND(Y17>=0,Y17<6),\"TRUE\",\"FALSE\"))","v":"FALSE"},"暦","年","月","日","未就学児",{"$f":"IF(OR(Z6=\"\",AA6=\"\",AB6=\"\",AC6=\"\"),\"FALSE\",IF(AND(AE17>=0,AE17<6),\"TRUE\",\"FALSE\"))","v":"FALSE"}]
[null,null,null,null,null,"介護非該当",{"$f":"IF(OR(B6=\"\",C6=\"\",D6=\"\",E6=\"\"),\"FALSE\",IF(AND(G17>=6,G17<40),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"介護非該当",{"$f":"IF(OR(H6=\"\",I6=\"\",J6=\"\",K6=\"\"),\"FALSE\",IF(AND(M17>=6,M17<40),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"介護非該当",{"$f":"IF(OR(N6=\"\",O6=\"\",P6=\"\",Q6=\"\"),\"FALSE\",IF(AND(S17>=6,S17<40),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"介護非該当",{"$f":"IF(OR(T6=\"\",U6=\"\",V6=\"\",W6=\"\"),\"FALSE\",IF(AND(Y17>=6,Y17<40),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"介護非該当",{"$f":"IF(OR(Z6=\"\",AA6=\"\",AB6=\"\",AC6=\"\"),\"FALSE\",IF(AND(AE17>=6,AE17<40),\"TRUE\",\"FALSE\"))","v":"FALSE"}]
["加入事由","転入",null,null,null,"介護該当",{"$f":"IF(OR(B6=\"\",C6=\"\",D6=\"\",E6=\"\"),\"FALSE\",IF(AND(G17>=40,G17<65),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"介護該当",{"$f":"IF(OR(H6=\"\",I6=\"\",J6=\"\",K6=\"\"),\"FALSE\",IF(AND(M17>=40,M17<65),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"介護該当",{"$f":"IF(OR(N6=\"\",O6=\"\",P6=\"\",Q6=\"\"),\"FALSE\",IF(AND(S17>=40,S17<65),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"介護該当",{"$f":"IF(OR(T6=\"\",U6=\"\",V6=\"\",W6=\"\"),\"FALSE\",IF(AND(Y17>=40,Y17<65),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"介護該当",{"$f":"IF(OR(Z6=\"\",AA6=\"\",AB6=\"\",AC6=\"\"),\"FALSE\",IF(AND(AE17>=40,AE17<65),\"TRUE\",\"FALSE\"))","v":"FALSE"}]
[null,null,null,null,null,"65歳以上",{"$f":"IF(OR(B6=\"\",C6=\"\",D6=\"\",E6=\"\"),\"FALSE\",IF(AND(G17>=65,G17<75),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"65歳以上",{"$f":"IF(OR(H6=\"\",I6=\"\",J6=\"\",K6=\"\"),\"FALSE\",IF(AND(M17>=65,M17<75),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"65歳以上",{"$f":"IF(OR(N6=\"\",O6=\"\",P6=\"\",Q6=\"\"),\"FALSE\",IF(AND(S17>=65,S17<75),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"65歳以上",{"$f":"IF(OR(T6=\"\",U6=\"\",V6=\"\",W6=\"\"),\"FALSE\",IF(AND(Y17>=65,Y17<75),\"TRUE\",\"FALSE\"))","v":"FALSE"},null,null,null,null,"65歳以上",{"$f":"IF(OR(Z6=\"\",AA6=\"\",AB6=\"\",AC6=\"\"),\"FALSE\",IF(AND(AE17>=65,AE17<75),\"TRUE\",\"FALSE\"))","v":"FALSE"}]
[null,"収入金額",null,"所得金額",null,"給与所得者等",{"$f":"IF(OR(G11>0,(D12-G12)>0),1,0)","v":0},"収入金額",null,"所得金額",null,"給与所得者等",{"$f":"IF(OR(M11>0,(J12-M12)>0),1,0)","v":0},"収入金額",null,"所得金額",null,"給与所得者等",{"$f":"IF(OR(S11>0,(P12-S12)>0),1,0)","v":0},"収入金額",null,"所得金額",null,"給与所得者等",{"$f":"IF(OR(Y11>0,(V12-Y12)>0),1,0)","v":0},"収入金額",null,"所得金額",null,"給与所得者等",{"$f":"IF(OR(AE11>0,(AB12-AE12)>0),1,0)","v":0}]
["給与収入",null,null,{"$f":"G10-G13","v":0},null,"給与所得(専給含む)",{"$f":"IF(G15=\"TRUE\",0.3*(IF(B10+B11<551000,0,IF(B10+B11<1619000,B10+B11-550000,IF(B10+B11<1620000,1069000,IF(B10+B11<1622000,1070000,IF(B10+B11<1624000,1072000,IF(B10+B11<1628000,1074000,IF(B10+B11<1800000,INT(INT((B10+B11)/4000)*4000*0.6)+100000,IF(B10+B11<3600000,INT(INT((B10+B11)/4000)*4000*0.7)-80000,IF(B10+B11<6600000,INT(INT((B10+B11)/4000)*4000*0.8)-440000,IF(B10+B11<8500000,INT((B10+B11)*0.9)-1100000,B10+B11-1950000))))))))))),IF(B10+B11<551000,0,IF(B10+B11<1619000,B10+B11-550000,IF(B10+B11<1620000,1069000,IF(B10+B11<1622000,1070000,IF(B10+B11<1624000,1072000,IF(B10+B11<1628000,1074000,IF(B10+B11<1800000,INT(INT((B10+B11)/4000)*4000*0.6)+100000,IF(B10+B11<3600000,INT(INT((B10+B11)/4000)*4000*0.7)-80000,IF(B10+B11<6600000,INT(INT((B10+B11)/4000)*4000*0.8)-440000,IF(B10+B11<8500000,INT((B10+B11)*0.9)-1100000,B10+B11-1950000)))))))))))","v":0},null,null,{"$f":"M10-M13","v":0},null,"給与所得(専給含む)",{"$f":"IF(M15=\"TRUE\",0.3*(IF(H10+H11<551000,0,IF(H10+H11<1619000,H10+H11-550000,IF(H10+H11<1620000,1069000,IF(H10+H11<1622000,1070000,IF(H10+H11<1624000,1072000,IF(H10+H11<1628000,1074000,IF(H10+H11<1800000,INT(INT((H10+H11)/4000)*4000*0.6)+100000,IF(H10+H11<3600000,INT(INT((H10+H11)/4000)*4000*0.7)-80000,IF(H10+H11<6600000,INT(INT((H10+H11)/4000)*4000*0.8)-440000,IF(H10+H11<8500000,INT((H10+H11)*0.9)-1100000,H10+H11-1950000))))))))))),IF(H10+H11<551000,0,IF(H10+H11<1619000,H10+H11-550000,IF(H10+H11<1620000,1069000,IF(H10+H11<1622000,1070000,IF(H10+H11<1624000,1072000,IF(H10+H11<1628000,1074000,IF(H10+H11<1800000,INT(INT((H10+H11)/4000)*4000*0.6)+100000,IF(H10+H11<3600000,INT(INT((H10+H11)/4000)*4000*0.7)-80000,IF(H10+H11<6600000,INT(INT((H10+H11)/4000)*4000*0.8)-440000,IF(H10+H11<8500000,INT((H10+H11)*0.9)-1100000,H10+H11-1950000)))))))))))","v":0},null,null,{"$f":"S10-S13","v":0},null,"給与所得(専給含む)",{"$f":"IF(S15=\"TRUE\",0.3*(IF(N10+N11<551000,0,IF(N10+N11<1619000,N10+N11-550000,IF(N10+N11<1620000,1069000,IF(N10+N11<1622000,1070000,IF(N10+N11<1624000,1072000,IF(N10+N11<1628000,1074000,IF(N10+N11<1800000,INT(INT((N10+N11)/4000)*4000*0.6)+100000,IF(N10+N11<3600000,INT(INT((N10+N11)/4000)*4000*0.7)-80000,IF(N10+N11<6600000,INT(INT((N10+N11)/4000)*4000*0.8)-440000,IF(N10+N11<8500000,INT((N10+N11)*0.9)-1100000,N10+N11-1950000))))))))))),IF(N10+N11<551000,0,IF(N10+N11<1619000,N10+N11-550000,IF(N10+N11<1620000,1069000,IF(N10+N11<1622000,1070000,IF(N10+N11<1624000,1072000,IF(N10+N11<1628000,1074000,IF(N10+N11<1800000,INT(INT((N10+N11)/4000)*4000*0.6)+100000,IF(N10+N11<3600000,INT(INT((N10+N11)/4000)*4000*0.7)-80000,IF(N10+N11<6600000,INT(INT((N10+N11)/4000)*4000*0.8)-440000,IF(N10+N11<8500000,INT((N10+N11)*0.9)-1100000,N10+N11-1950000)))))))))))","v":0},null,null,{"$f":"Y10-Y13","v":0},null,"給与所得(専給含む)",{"$f":"IF(Y15=\"TRUE\",0.3*(IF(T10+T11<551000,0,IF(T10+T11<1619000,T10+T11-550000,IF(T10+T11<1620000,1069000,IF(T10+T11<1622000,1070000,IF(T10+T11<1624000,1072000,IF(T10+T11<1628000,1074000,IF(T10+T11<1800000,INT(INT((T10+T11)/4000)*4000*0.6)+100000,IF(T10+T11<3600000,INT(INT((T10+T11)/4000)*4000*0.7)-80000,IF(T10+T11<6600000,INT(INT((T10+T11)/4000)*4000*0.8)-440000,IF(T10+T11<8500000,INT((T10+T11)*0.9)-1100000,T10+T11-1950000))))))))))),IF(T10+T11<551000,0,IF(T10+T11<1619000,T10+T11-550000,IF(T10+T11<1620000,1069000,IF(T10+T11<1622000,1070000,IF(T10+T11<1624000,1072000,IF(T10+T11<1628000,1074000,IF(T10+T11<1800000,INT(INT((T10+T11)/4000)*4000*0.6)+100000,IF(T10+T11<3600000,INT(INT((T10+T11)/4000)*4000*0.7)-80000,IF(T10+T11<6600000,INT(INT((T10+T11)/4000)*4000*0.8)-440000,IF(T10+T11<8500000,INT((T10+T11)*0.9)-1100000,T10+T11-1950000)))))))))))","v":0},null,null,{"$f":"AE10-AE13","v":0},null,"給与所得(専給含む)",{"$f":"IF(AE15=\"TRUE\",0.3*(IF(Z10+Z11<551000,0,IF(Z10+Z11<1619000,Z10+Z11-550000,IF(Z10+Z11<1620000,1069000,IF(Z10+Z11<1622000,1070000,IF(Z10+Z11<1624000,1072000,IF(Z10+Z11<1628000,1074000,IF(Z10+Z11<1800000,INT(INT((Z10+Z11)/4000)*4000*0.6)+100000,IF(Z10+Z11<3600000,INT(INT((Z10+Z11)/4000)*4000*0.7)-80000,IF(Z10+Z11<6600000,INT(INT((Z10+Z11)/4000)*4000*0.8)-440000,IF(Z10+Z11<8500000,INT((Z10+Z11)*0.9)-1100000,Z10+Z11-1950000))))))))))),IF(Z10+Z11<551000,0,IF(Z10+Z11<1619000,Z10+Z11-550000,IF(Z10+Z11<1620000,1069000,IF(Z10+Z11<1622000,1070000,IF(Z10+Z11<1624000,1072000,IF(Z10+Z11<1628000,1074000,IF(Z10+Z11<1800000,INT(INT((Z10+Z11)/4000)*4000*0.6)+100000,IF(Z10+Z11<3600000,INT(INT((Z10+Z11)/4000)*4000*0.7)-80000,IF(Z10+Z11<6600000,INT(INT((Z10+Z11)/4000)*4000*0.8)-440000,IF(Z10+Z11<8500000,INT((Z10+Z11)*0.9)-1100000,Z10+Z11-1950000)))))))))))","v":0}]
["専従給与",null,null,null,null,"軽判給与所得",{"$f":"IF(G15=\"TRUE\",0.3*(IF(B10<551000,0,IF(B10<1619000,B10-550000,IF(B10<1620000,1069000,IF(B10<1622000,1070000,IF(B10<1624000,1072000,IF(B10<1628000,1074000,IF(B10<1800000,INT((INT(B10/4000)*4000)*0.6)+100000,IF(B10<3600000,INT((INT(B10/4000)*4000)*0.7)-80000,IF(B10<6600000,INT((INT(B10/4000)*4000)*0.8)-440000,IF(B10<8500000,INT(B10*0.9)-1100000,B10-1950000))))))))))),IF(B10<551000,0,IF(B10<1619000,B10-550000,IF(B10<1620000,1069000,IF(B10<1622000,1070000,IF(B10<1624000,1072000,IF(B10<1628000,1074000,IF(B10<1800000,INT((INT(B10/4000)*4000)*0.6)+100000,IF(B10<3600000,INT((INT(B10/4000)*4000)*0.7)-80000,IF(B10<6600000,INT((INT(B10/4000)*4000)*0.8)-440000,IF(B10<8500000,INT(B10*0.9)-1100000,B10-1950000)))))))))))","v":0},null,null,null,null,"軽判給与所得",{"$f":"IF(M15=\"TRUE\",0.3*(IF(H10<551000,0,IF(H10<1619000,H10-550000,IF(H10<1620000,1069000,IF(H10<1622000,1070000,IF(H10<1624000,1072000,IF(H10<1628000,1074000,IF(H10<1800000,INT((INT(H10/4000)*4000)*0.6)+100000,IF(H10<3600000,INT((INT(H10/4000)*4000)*0.7)-80000,IF(H10<6600000,INT((INT(H10/4000)*4000)*0.8)-440000,IF(H10<8500000,INT(H10*0.9)-1100000,H10-1950000))))))))))),IF(H10<551000,0,IF(H10<1619000,H10-550000,IF(H10<1620000,1069000,IF(H10<1622000,1070000,IF(H10<1624000,1072000,IF(H10<1628000,1074000,IF(H10<1800000,INT((INT(H10/4000)*4000)*0.6)+100000,IF(H10<3600000,INT((INT(H10/4000)*4000)*0.7)-80000,IF(H10<6600000,INT((INT(H10/4000)*4000)*0.8)-440000,IF(H10<8500000,INT(H10*0.9)-1100000,H10-1950000)))))))))))","v":0},null,null,null,null,"軽判給与所得",{"$f":"IF(S15=\"TRUE\",0.3*(IF(N10<551000,0,IF(N10<1619000,N10-550000,IF(N10<1620000,1069000,IF(N10<1622000,1070000,IF(N10<1624000,1072000,IF(N10<1628000,1074000,IF(N10<1800000,INT((INT(N10/4000)*4000)*0.6)+100000,IF(N10<3600000,INT((INT(N10/4000)*4000)*0.7)-80000,IF(N10<6600000,INT((INT(N10/4000)*4000)*0.8)-440000,IF(N10<8500000,INT(N10*0.9)-1100000,N10-1950000))))))))))),IF(N10<551000,0,IF(N10<1619000,N10-550000,IF(N10<1620000,1069000,IF(N10<1622000,1070000,IF(N10<1624000,1072000,IF(N10<1628000,1074000,IF(N10<1800000,INT((INT(N10/4000)*4000)*0.6)+100000,IF(N10<3600000,INT((INT(N10/4000)*4000)*0.7)-80000,IF(N10<6600000,INT((INT(N10/4000)*4000)*0.8)-440000,IF(N10<8500000,INT(N10*0.9)-1100000,N10-1950000)))))))))))","v":0},null,null,null,null,"軽判給与所得",{"$f":"IF(Y15=\"TRUE\",0.3*(IF(T10<551000,0,IF(T10<1619000,T10-550000,IF(T10<1620000,1069000,IF(T10<1622000,1070000,IF(T10<1624000,1072000,IF(T10<1628000,1074000,IF(T10<1800000,INT((INT(T10/4000)*4000)*0.6)+100000,IF(T10<3600000,INT((INT(T10/4000)*4000)*0.7)-80000,IF(T10<6600000,INT((INT(T10/4000)*4000)*0.8)-440000,IF(T10<8500000,INT(T10*0.9)-1100000,T10-1950000))))))))))),IF(T10<551000,0,IF(T10<1619000,T10-550000,IF(T10<1620000,1069000,IF(T10<1622000,1070000,IF(T10<1624000,1072000,IF(T10<1628000,1074000,IF(T10<1800000,INT((INT(T10/4000)*4000)*0.6)+100000,IF(T10<3600000,INT((INT(T10/4000)*4000)*0.7)-80000,IF(T10<6600000,INT((INT(T10/4000)*4000)*0.8)-440000,IF(T10<8500000,INT(T10*0.9)-1100000,T10-1950000)))))))))))","v":0},null,null,null,null,"軽判給与所得",{"$f":"IF(AE15=\"TRUE\",0.3*(IF(Z10<551000,0,IF(Z10<1619000,Z10-550000,IF(Z10<1620000,1069000,IF(Z10<1622000,1070000,IF(Z10<1624000,1072000,IF(Z10<1628000,1074000,IF(Z10<1800000,INT((INT(Z10/4000)*4000)*0.6)+100000,IF(Z10<3600000,INT((INT(Z10/4000)*4000)*0.7)-80000,IF(Z10<6600000,INT((INT(Z10/4000)*4000)*0.8)-440000,IF(Z10<8500000,INT(Z10*0.9)-1100000,Z10-1950000))))))))))),IF(Z10<551000,0,IF(Z10<1619000,Z10-550000,IF(Z10<1620000,1069000,IF(Z10<1622000,1070000,IF(Z10<1624000,1072000,IF(Z10<1628000,1074000,IF(Z10<1800000,INT((INT(Z10/4000)*4000)*0.6)+100000,IF(Z10<3600000,INT((INT(Z10/4000)*4000)*0.7)-80000,IF(Z10<6600000,INT((INT(Z10/4000)*4000)*0.8)-440000,IF(Z10<8500000,INT(Z10*0.9)-1100000,Z10-1950000)))))))))))","v":0}]
["年金収入",null,null,{"$f":"IF(B12=\"\",0,ROUNDDOWN(IF(G16>=65,(IF(B12<1100000,0,IF(B12<=3300000,B12-1100000,IF(B12<=4100000,(B12*0.75)-275000,IF(B12<=7700000,(B12*0.85)-685000,IF(B12<=10000000,(B12*395)-1455000,B12-1955000)))))),(IF(B12<600000,0,IF(B12<=1300000,B12-600000,IF(B12<=4100000,(B12*0.75)-275000,IF(B12<=7700000,(B12*0.85)-685000,IF(B12<=10000000,(B12*395)-1455000,B12-1955000))))))),0))","v":0},null,"年金１５万円控除",{"$f":"IF(B12=\"\",0,IF(G16>=65,IF(D12>=150000,150000,D12),0))","v":0},null,null,{"$f":"IF(H12=\"\",0,ROUNDDOWN(IF(M16>=65,(IF(H12<1100000,0,IF(H12<=3300000,H12-1100000,IF(H12<=4100000,(H12*0.75)-275000,IF(H12<=7700000,(H12*0.85)-685000,IF(H12<=10000000,(H12*395)-1455000,H12-1955000)))))),(IF(H12<600000,0,IF(H12<=1300000,H12-600000,IF(H12<=4100000,(H12*0.75)-275000,IF(H12<=7700000,(H12*0.85)-685000,IF(H12<=10000000,(H12*395)-1455000,H12-1955000))))))),0))","v":0},null,"年金１５万円控除",{"$f":"IF(H12=\"\",0,IF(M16>=65,IF(J12>=150000,150000,J12),0))","v":0},null,null,{"$f":"IF(N12=\"\",0,ROUNDDOWN(IF(S16>=65,(IF(N12<1100000,0,IF(N12<=3300000,N12-1100000,IF(N12<=4100000,(N12*0.75)-275000,IF(N12<=7700000,(N12*0.85)-685000,IF(N12<=10000000,(N12*395)-1455000,N12-1955000)))))),(IF(N12<600000,0,IF(N12<=1300000,N12-600000,IF(N12<=4100000,(N12*0.75)-275000,IF(N12<=7700000,(N12*0.85)-685000,IF(N12<=10000000,(N12*395)-1455000,N12-1955000))))))),0))","v":0},null,"年金１５万円控除",{"$f":"IF(N12=\"\",0,IF(S16>=65,IF(P12>=150000,150000,P12),0))","v":0},null,null,{"$f":"IF(T12=\"\",0,ROUNDDOWN(IF(Y16>=65,(IF(T12<1100000,0,IF(T12<=3300000,T12-1100000,IF(T12<=4100000,(T12*0.75)-275000,IF(T12<=7700000,(T12*0.85)-685000,IF(T12<=10000000,(T12*395)-1455000,T12-1955000)))))),(IF(T12<600000,0,IF(T12<=1300000,T12-600000,IF(T12<=4100000,(T12*0.75)-275000,IF(T12<=7700000,(T12*0.85)-685000,IF(T12<=10000000,(T12*395)-1455000,T12-1955000))))))),0))","v":0},null,"年金１５万円控除",{"$f":"IF(T12=\"\",0,IF(Y16>=65,IF(V12>=150000,150000,V12),0))","v":0},null,null,{"$f":"IF(Z12=\"\",0,ROUNDDOWN(IF(AE16>=65,(IF(Z12<1100000,0,IF(Z12<=3300000,Z12-1100000,IF(Z12<=4100000,(Z12*0.75)-275000,IF(Z12<=7700000,(Z12*0.85)-685000,IF(Z12<=10000000,(Z12*395)-1455000,Z12-1955000)))))),(IF(Z12<600000,0,IF(Z12<=1300000,Z12-600000,IF(Z12<=4100000,(Z12*0.75)-275000,IF(Z12<=7700000,(Z12*0.85)-685000,IF(Z12<=10000000,(Z12*395)-1455000,Z12-1955000))))))),0))","v":0},null,"年金１５万円控除",{"$f":"IF(Z12=\"\",0,IF(AE16>=65,IF(AB12>=150000,150000,AB12),0))","v":0}]
["営業所得",null,null,null,null,"給与調整控除",{"$f":"IF((IF(G10>=100000,100000,G10)+IF(D12>=100000,100000,D12)-100000)<0,0,IF(G10>=100000,100000,G10)+IF(D12>=100000,100000,D12)-100000)","v":0},null,null,null,null,"給与調整控除",{"$f":"IF((IF(M10>=100000,100000,M10)+IF(J12>=100000,100000,J12)-100000)<0,0,IF(M10>=100000,100000,M10)+IF(J12>=100000,100000,J12)-100000)","v":0},null,null,null,null,"給与調整控除",{"$f":"IF((IF(S10>=100000,100000,S10)+IF(P12>=100000,100000,P12)-100000)<0,0,IF(S10>=100000,100000,S10)+IF(P12>=100000,100000,P12)-100000)","v":0},null,null,null,null,"給与調整控除",{"$f":"IF((IF(Y10>=100000,100000,Y10)+IF(V12>=100000,100000,V12)-100000)<0,0,IF(Y10>=100000,100000,Y10)+IF(V12>=100000,100000,V12)-100000)","v":0},null,null,null,null,"給与調整控除",{"$f":"IF((IF(AE10>=100000,100000,AE10)+IF(AB12>=100000,100000,AB12)-100000)<0,0,IF(AE10>=100000,100000,AE10)+IF(AB12>=100000,100000,AB12)-100000)","v":0}]
["不動産所得",null,null,null,null,"軽判給与調整控除",{"$f":"IF((IF(G11>=100000,100000,G11)+IF(D12-G12>=100000,100000,D12-G12)-100000)<0,0,IF(G11>=100000,100000,G11)+IF(D12-G12>=100000,100000,D12-G12)-100000)","v":0},null,null,null,null,"軽判給与調整控除",{"$f":"IF((IF(M11>=100000,100000,M11)+IF(J12-M12>=100000,100000,J12-M12)-100000)<0,0,IF(M11>=100000,100000,M11)+IF(J12-M12>=100000,100000,J12-M12)-100000)","v":0},null,null,null,null,"軽判給与調整控除",{"$f":"IF((IF(S11>=100000,100000,S11)+IF(P12-S12>=100000,100000,P12-S12)-100000)<0,0,IF(S11>=100000,100000,S11)+IF(P12-S12>=100000,100000,P12-S12)-100000)","v":0},null,null,null,null,"軽判給与調整控除",{"$f":"IF((IF(Y11>=100000,100000,Y11)+IF(V12-Y12>=100000,100000,V12-Y12)-100000)<0,0,IF(Y11>=100000,100000,Y11)+IF(V12-Y12>=100000,100000,V12-Y12)-100000)","v":0},null,null,null,null,"軽判給与調整控除",{"$f":"IF((IF(AE11>=100000,100000,AE11)+IF(AB12-AE12>=100000,100000,AB12-AE12)-100000)<0,0,IF(AE11>=100000,100000,AE11)+IF(AB12-AE12>=100000,100000,AB12-AE12)-100000)","v":0}]
["その他の所得",null,null,null,null,"非失該当",{"$f":"IF(D7=\"会社都合\",\"TRUE\",\"FALSE\")","v":"FALSE"},null,null,null,null,"非失該当",{"$f":"IF(J7=\"会社都合\",\"TRUE\",\"FALSE\")","v":"FALSE"},null,null,null,null,"非失該当",{"$f":"IF(P7=\"会社都合\",\"TRUE\",\"FALSE\")","v":"FALSE"},null,null,null,null,"非失該当",{"$f":"IF(V7=\"会社都合\",\"TRUE\",\"FALSE\")","v":"FALSE"},null,null,null,null,"非失該当",{"$f":"IF(AB7=\"会社都合\",\"TRUE\",\"FALSE\")","v":"FALSE"}]
["総所得",{"$f":"IF(SUM(D10:D15)<0,0,SUM(D10:D15))","v":0},null,null,null,"1/1年齢",{"$f":"IF(IF(AND(D6=1,E6=1),G3-G4,G3-G4-1)<0,0,IF(AND(D6=1,E6=1),G3-G4,G3-G4-1))","v":{"$error":"#VALUE!"}},{"$f":"IF(SUM(J10:J15)<0,0,SUM(J10:J15))","v":0},null,null,null,"1/1年齢",{"$f":"IF(IF(AND(J6=1,K6=1),M3-M4,M3-M4-1)<0,0,IF(AND(J6=1,K6=1),M3-M4,M3-M4-1))","v":{"$error":"#VALUE!"}},{"$f":"IF(SUM(P10:P15)<0,0,SUM(P10:P15))","v":0},null,null,null,"1/1年齢",{"$f":"IF(IF(AND(P6=1,Q6=1),S3-S4,S3-S4-1)<0,0,IF(AND(P6=1,Q6=1),S3-S4,S3-S4-1))","v":{"$error":"#VALUE!"}},{"$f":"IF(SUM(V10:V15)<0,0,SUM(V10:V15))","v":0},null,null,null,"1/1年齢",{"$f":"IF(IF(AND(V6=1,W6=1),Y3-Y4,Y3-Y4-1)<0,0,IF(AND(V6=1,W6=1),Y3-Y4,Y3-Y4-1))","v":{"$error":"#VALUE!"}},{"$f":"IF(SUM(AB10:AB15)<0,0,SUM(AB10:AB15))","v":0},null,null,null,"1/1年齢",{"$f":"IF(IF(AND(AB6=1,AC6=1),AE3-AE4,AE3-AE4-1)<0,0,IF(AND(AB6=1,AC6=1),AE3-AE4,AE3-AE4-1))","v":{"$error":"#VALUE!"}}]
["専従控除額",null,null,null,null,"4/1年齢",{"$f":"IF(IF(D6<5,G3-G4,G3-G4-1)<0,0,IF(D6<5,G3-G4,G3-G4-1))","v":{"$error":"#VALUE!"}},null,null,null,null,"4/1年齢",{"$f":"IF(IF(J6<5,M3-M4,M3-M4-1)<0,0,IF(J6<5,M3-M4,M3-M4-1))","v":{"$error":"#VALUE!"}},null,null,null,null,"4/1年齢",{"$f":"IF(IF(P6<5,S3-S4,S3-S4-1)<0,0,IF(P6<5,S3-S4,S3-S4-1))","v":{"$error":"#VALUE!"}},null,null,null,null,"4/1年齢",{"$f":"IF(IF(V6<5,Y3-Y4,Y3-Y4-1)<0,0,IF(V6<5,Y3-Y4,Y3-Y4-1))","v":{"$error":"#VALUE!"}},null,null,null,null,"4/1年齢",{"$f":"IF(IF(AB6<5,AE3-AE4,AE3-AE4-1)<0,0,IF(AB6<5,AE3-AE4,AE3-AE4-1))","v":{"$error":"#VALUE!"}}]
["軽減判定所得",{"$f":"IF(G11-G14+D12-G12+D13+D14+D15+B17<0,0,G11-G14+D12-G12+D13+D14+D15+B17)","v":0},null,null,null,null,null,{"$f":"IF(M11-M14+J12-M12+J13+J14+J15+H17<0,0,M11-M14+J12-M12+J13+J14+J15+H17)","v":0},null,null,null,null,null,{"$f":"IF(S11-S14+P12-S12+P13+P14+P15+N17<0,0,S11-S14+P12-S12+P13+P14+P15+N17)","v":0},null,null,null,null,null,{"$f":"IF(Y11-Y14+V12-Y12+V13+V14+V15+T17<0,0,Y11-Y14+V12-Y12+V13+V14+V15+T17)","v":0},null,null,null,null,null,{"$f":"IF(AE11-AE14+AB12-AE12+AB13+AB14+AB15+Z17<0,0,AE11-AE14+AB12-AE12+AB13+AB14+AB15+Z17)","v":0}]
["賦課標準所得",{"$f":"IF(B16<=430000,0,IF(A4>=6,B16-430000,ROUNDDOWN((B16-430000),-3)))","v":0},null,null,null,null,null,{"$f":"IF(H16<=430000,0,IF(A4>=6,H16-430000,ROUNDDOWN((H16-430000),-3)))","v":0},null,null,null,null,null,{"$f":"IF(N16<=430000,0,IF(A4>=6,N16-430000,ROUNDDOWN((N16-430000),-3)))","v":0},null,null,null,null,null,{"$f":"IF(T16<=430000,0,IF(A4>=6,T16-430000,ROUNDDOWN((T16-430000),-3)))","v":0},null,null,null,null,null,{"$f":"IF(Z16<=430000,0,IF(A4>=6,Z16-430000,ROUNDDOWN((Z16-430000),-3)))","v":0}]
[]
[]
["世帯人数",{"$f":"G22+M22+S22+Y22+AE22","v":0},null,null,null,"カウント",{"$f":"IF(AND(G5=\"FALSE\",G6=\"FALSE\",G7=\"FALSE\",G8=\"FALSE\"),0,1)","v":0},null,null,null,null,"カウント",{"$f":"IF(AND(M5=\"FALSE\",M6=\"FALSE\",M7=\"FALSE\",M8=\"FALSE\"),0,1)","v":0},null,null,null,null,"カウント",{"$f":"IF(AND(S5=\"FALSE\",S6=\"FALSE\",S7=\"FALSE\",S8=\"FALSE\"),0,1)","v":0},null,null,null,null,"カウント",{"$f":"IF(AND(Y5=\"FALSE\",Y6=\"FALSE\",Y7=\"FALSE\",Y8=\"FALSE\"),0,1)","v":0},null,null,null,null,"カウント",{"$f":"IF(AND(AE5=\"FALSE\",AE6=\"FALSE\",AE7=\"FALSE\",AE8=\"FALSE\"),0,1)","v":0}]
["世帯総所得",{"$f":"B16+H16+N16+T16+Z16","v":0}]
["世帯軽減判定所得",{"$f":"B18+H18+N18+T18+Z18","v":0}]
["世帯賦課標準所得",{"$f":"B19+H19+N19+T19+Z19","v":0}]

{"sheet":"試算結果","index":2,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,14,3,16],[5,1,5,4],[5,5,5,7],[7,1,7,4],[27,1,27,21],[22,1,22,21],[23,1,23,21],[25,1,25,21],[26,1,26,21],[19,1,19,21],[20,1,20,21],[0,17,0,21],[21,1,21,21],[24,1,24,21],[7,5,7,7],[9,1,9,4],[10,3,10,5],[10,6,10,8],[5,8,5,15],[13,1,13,21],[14,1,14,21],[15,1,15,21],[16,1,17,21],[1,0,1,21],[10,11,10,12],[3,0,3,1],[3,5,3,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-04-15"}]
["保険料試算"]
[]
["令和",null,{"$f":"IF(加入情報入力用!B5=\"\",\"\",加入情報入力用!B5)","v":7},"年度",null,"(令和",null,{"$f":"IF(加入情報入力用!B5=\"\",\"\",加入情報入力用!B5)","v":7},"年 4 月～令和",null,null,null,null,{"$f":"IF(加入情報入力用!B5=\"\",\"\",加入情報入力用!B5+1)","v":8},"年 3 月)"]
[]
[null,{"$f":"IF(加入情報入力用!B10=\"\",\"\",加入情報入力用!B10)","v":0},null,null,null,"円／年",null,null,{"$f":"IF(AND(加入情報入力用!B6=\"\",加入情報入力用!B7=\"\"),\"(   月分～   月分)\",IF(加入情報入力用!B6=加入情報入力用!B7,\"( \"&加入情報入力用!B6&\" 月分)\",\"( \"&加入情報入力用!B6&\" 月分～ \"&加入情報入力用!B7&\" 月分)\"))","v":"( 4 月分～ 3 月分)"}]
[]
[null,{"$f":"IF(加入情報入力用!B10=\"\",\"\",加入情報入力用!B10/(加入情報入力用!B21-加入情報入力用!B20+1))","v":0},null,null,null,"円／月"]
[]
[null,"月支払額"]
[null,null,"約",{"$f":"IF(加入情報入力用!B10=\"\",\"\",加入情報入力用!B10/加入情報入力用!B11)","v":{"$error":"#VALUE!"}},null,null,"円／月",null,null,"（",{"$f":"IF(加入情報入力用!B11=\"\",\"\",加入情報入力用!B11)","v":""},"回）"]
[]
[]
[null,{"$f":"IF(加入情報入力用!B5=\"\",\"　※保険料の決定通知書は、翌月の   月中旬に発送します。\",IF(加入情報入力用!B17=TRUE,\"　※保険料の決定通知書は、\"&加入情報入力用!B5&\" 年 6 月中旬に発送します。\",IF(加入情報入力用!B16=TRUE,\"　※保険料の決定通知書は、翌月の \"&加入情報入力用!B8+1&\" 月中旬に発送します。\",IF(加入情報入力用!B8=4,\"　※保険料の決定通知書は、翌々月の \"&6&\" 月中旬に発送します。\",IF(加入情報入力用!B8=12,\"　※保険料の決定通知書は、翌月の \"&1&\" 月中旬に発送します。\",\"　※保険料の決定通知書は、翌月の \"&加入情報入力用!B8+1&\" 月中旬に発送します。\")))))","v":"　※保険料の決定通知書は、翌月の 1 月中旬に発送します。"}]
[null,{"$f":"IF(加入情報入力用!B16=TRUE,IF(加入情報入力用!B5=\"\",\"　　お支払いは、原則通知書発送月の  月末までの一括払いです。\",IF(加入情報入力用!B8=12,\"　　お支払いは、原則通知書発送月の \"&1&\" 月末までの一括払いです。\",\"　　お支払いは、原則通知書発送月の \"&加入情報入力用!B8+1&\" 月末までの一括払いです。\")),IF(加入情報入力用!B5=\"\",\"　　お支払いについては、原則通知書発送月の  月から\",\"　　お支払いについては、原則通知書発送月の \"&IF(加入情報入力用!B17=TRUE,\" 6 \",IF(加入情報入力用!B8=4,\" 6 \",IF(加入情報入力用!B8=12,\" 1 \",加入情報入力用!B8+1)))&\" 月から\"))","v":"　　お支払いについては、原則通知書発送月の 1 月から"}]
[null,{"$f":"IF(OR(加入情報入力用!B16=TRUE,加入情報入力用!B8=3),\"\",IF(加入情報入力用!B18=TRUE,IF(加入情報入力用!B5=\"\",\"　　誕生日の前月の　月までの分割です。\",\"　　誕生日の前月の \"&加入情報入力用!B19&\" 月までの分割です。\" ),IF(加入情報入力用!B5=\"\",\"　　年度末の　年 3 月までの分割です。\",\"　　年度末の \"&加入情報入力用!B5+1&\" 年 3 月までの分割です。\" )))","v":"　　年度末の 8 年 3 月までの分割です。"}]
[null,"　※納付困難な場合は、決定通知書を受取っていただいてから、\n　　本庁、または行政サービスセンター等でご相談ください。"]
[]
[]
[]
[null," ※今回の結果は概算であり保険料の決定額ではありません。"]
[]
[null," ※本シートでは1年間（12か月分）の保険料を計算しておりますが、"]
[null," 　実際に通知される保険料は、加入月数によって変動します。"]
[]
[null," ※国民健康保険は、決定料金を年度末（3月末）までの分割払いと"]
[null," 　となっており、社会保険のような月額払いとは異なります。"]

{"sheet":"世帯賦課条件","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[[24,1,24,5],[0,0,0,7],[2,0,2,1],[3,0,3,1],[18,1,18,5],[21,1,21,5]]}
["賦課明細"]
[]
["給与所得者等 人数",null,{"$f":"世帯情報入力用!G9+世帯情報入力用!M9+世帯情報入力用!S9+世帯情報入力用!Y9+世帯情報入力用!AE9","v":0}]
["世帯被保険者数",null,{"$f":"世帯情報入力用!B22","v":0}]
[]
[null,"7割軽減","5割軽減","2割軽減",null,null,null,"当該世帯軽減率"]
["軽減判定額",{"$f":"IF(C3=0,430000,430000+((C3-1)*100000))","v":430000},{"$f":"IF(C3=0,430000+(試算年度条件!B4*世帯賦課条件!C4),430000+(試算年度条件!B4*世帯賦課条件!C4)+((C3-1)*100000))","v":430000},{"$f":"IF(C3=0,430000+(試算年度条件!B5*世帯賦課条件!C4),430000+(試算年度条件!B5*世帯賦課条件!C4)+((C3-1)*100000))","v":430000},null,null,null,{"$f":"IF(世帯情報入力用!A4=\"\",\"\",IF(I7=0.3,\"7割軽減\",IF(I7=0.5,\"5割軽減\",IF(I7=0.8,\"2割軽減\",\"軽減なし\"))))","v":"7割軽減"},{"$f":"IF(世帯情報入力用!B24<=世帯賦課条件!B7,0.3,IF(世帯情報入力用!B24<=世帯賦課条件!C7,0.5,IF(世帯情報入力用!B24<=世帯賦課条件!D7,0.8,1)))","v":0.3}]
[]
[null,"所得割率","均等割額","平等割額","賦課限度額"]
["医療",{"$f":"試算年度条件!B6","v":9.2999999999999999E-2},{"$f":"試算年度条件!B7","v":34424},{"$f":"試算年度条件!B8","v":33574},{"$f":"試算年度条件!B9","v":650000}]
["支援",{"$f":"試算年度条件!B10","v":3.0200000000000001E-2},{"$f":"試算年度条件!B11","v":11034},{"$f":"試算年度条件!B12","v":10761},{"$f":"試算年度条件!B13","v":240000}]
["介護",{"$f":"試算年度条件!B14","v":2.5600000000000001E-2},{"$f":"試算年度条件!B15","v":18784},{"$f":"試算年度条件!B16","v":0},{"$f":"試算年度条件!B17","v":170000}]
[]
[null,"世帯主","世帯員1","世帯員2","世帯員3","世帯員4"]
["総所得金額",{"$f":"IF(世帯情報入力用!B16=0,\"\",世帯情報入力用!B16)","v":""},{"$f":"IF(世帯情報入力用!H16=0,\"\",世帯情報入力用!H16)","v":""},{"$f":"IF(世帯情報入力用!N16=0,\"\",世帯情報入力用!N16)","v":""},{"$f":"IF(世帯情報入力用!T16=0,\"\",世帯情報入力用!T16)","v":""},{"$f":"IF(世帯情報入力用!Z16=0,\"\",世帯情報入力用!Z16)","v":""}]
["賦課標準所得金額",{"$f":"IF(世帯情報入力用!B19=0,\"\",世帯情報入力用!B19)","v":""},{"$f":"IF(世帯情報入力用!H19=0,\"\",世帯情報入力用!H19)","v":""},{"$f":"IF(世帯情報入力用!N19=0,\"\",世帯情報入力用!N19)","v":""},{"$f":"IF(世帯情報入力用!T19=0,\"\",世帯情報入力用!T19)","v":""},{"$f":"IF(世帯情報入力用!Z19=0,\"\",世帯情報入力用!Z19)","v":""}]
["医療 所得割額",{"$f":"ROUNDDOWN(世帯情報入力用!B19*世帯賦課条件!B10,0)","v":0},{"$f":"ROUNDDOWN(世帯情報入力用!H19*世帯賦課条件!B10,0)","v":0},{"$f":"ROUNDDOWN(世帯情報入力用!N19*世帯賦課条件!B10,0)","v":0},{"$f":"ROUNDDOWN(世帯情報入力用!T19*世帯賦課条件!B10,0)","v":0},{"$f":"ROUNDDOWN(世帯情報入力用!Z19*世帯賦課条件!B10,0)","v":0}]
["医療 均等割額",{"$f":"IF(AND(世帯情報入力用!G22=1,世帯情報入力用!G5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!G22=1,世帯情報入力用!G5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0),0))","v":0},{"$f":"IF(AND(世帯情報入力用!M22=1,世帯情報入力用!M5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!M22=1,世帯情報入力用!M5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0),0))","v":0},{"$f":"IF(AND(世帯情報入力用!S22=1,世帯情報入力用!S5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!S22=1,世帯情報入力用!S5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0),0))","v":0},{"$f":"IF(AND(世帯情報入力用!Y22=1,世帯情報入力用!Y5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!Y22=1,世帯情報入力用!Y5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0),0))","v":0},{"$f":"IF(AND(世帯情報入力用!AE22=1,世帯情報入力用!AE5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!AE22=1,世帯情報入力用!AE5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C10*世帯賦課条件!I7,0),0))","v":0}]
["医療 平等割額",{"$f":"IF(世帯情報入力用!G22+世帯情報入力用!M22+世帯情報入力用!S22+世帯情報入力用!Y22+世帯情報入力用!AE22>0,ROUNDDOWN(D10*I7,0),0)","v":0}]
["支援 所得割額",{"$f":"ROUNDDOWN(世帯情報入力用!B19*世帯賦課条件!B11,0)","v":0},{"$f":"ROUNDDOWN(世帯情報入力用!H19*世帯賦課条件!B11,0)","v":0},{"$f":"ROUNDDOWN(世帯情報入力用!N19*世帯賦課条件!B11,0)","v":0},{"$f":"ROUNDDOWN(世帯情報入力用!T19*世帯賦課条件!B11,0)","v":0},{"$f":"ROUNDDOWN(世帯情報入力用!Z19*世帯賦課条件!B11,0)","v":0}]
["支援 均等割額",{"$f":"IF(AND(世帯情報入力用!G22=1,世帯情報入力用!G5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!G22=1,世帯情報入力用!G5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0),0))","v":0},{"$f":"IF(AND(世帯情報入力用!M22=1,世帯情報入力用!M5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!M22=1,世帯情報入力用!M5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0),0))","v":0},{"$f":"IF(AND(世帯情報入力用!S22=1,世帯情報入力用!S5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!S22=1,世帯情報入力用!S5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0),0))","v":0},{"$f":"IF(AND(世帯情報入力用!Y22=1,世帯情報入力用!Y5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!Y22=1,世帯情報入力用!Y5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0),0))","v":0},{"$f":"IF(AND(世帯情報入力用!AE22=1,世帯情報入力用!AE5=\"TRUE\"),ROUNDDOWN(ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0)/2,0),IF(AND(世帯情報入力用!AE22=1,世帯情報入力用!AE5=\"FALSE\"),ROUNDDOWN(世帯賦課条件!C11*世帯賦課条件!I7,0),0))","v":0}]
["支援 平等割額",{"$f":"IF(世帯情報入力用!G22+世帯情報入力用!M22+世帯情報入力用!S22+世帯情報入力用!Y22+世帯情報入力用!AE22>0,ROUNDDOWN(D11*I7,0),0)","v":0}]
["介護 所得割額",{"$f":"IF(世帯情報入力用!G7=\"TRUE\",ROUNDDOWN(世帯情報入力用!B19*世帯賦課条件!B12,0),0)","v":0},{"$f":"IF(世帯情報入力用!M7=\"TRUE\",ROUNDDOWN(世帯情報入力用!H19*世帯賦課条件!B12,0),0)","v":0},{"$f":"IF(世帯情報入力用!S7=\"TRUE\",ROUNDDOWN(世帯情報入力用!N19*世帯賦課条件!B12,0),0)","v":0},{"$f":"IF(世帯情報入力用!Y7=\"TRUE\",ROUNDDOWN(世帯情報入力用!T19*世帯賦課条件!B12,0),0)","v":0},{"$f":"IF(世帯情報入力用!AE7=\"TRUE\",ROUNDDOWN(世帯情報入力用!Z19*世帯賦課条件!B12,0),0)","v":0}]
["介護 均等割額",{"$f":"IF(AND(世帯情報入力用!G7=\"TRUE\",世帯情報入力用!G22=1),ROUNDDOWN(世帯賦課条件!C12*世帯賦課条件!I7,0),0)","v":0},{"$f":"IF(AND(世帯情報入力用!M7=\"TRUE\",世帯情報入力用!M22=1),ROUNDDOWN(世帯賦課条件!C12*世帯賦課条件!I7,0),0)","v":0},{"$f":"IF(AND(世帯情報入力用!S7=\"TRUE\",世帯情報入力用!S22=1),ROUNDDOWN(世帯賦課条件!C12*世帯賦課条件!I7,0),0)","v":0},{"$f":"IF(AND(世帯情報入力用!Y7=\"TRUE\",世帯情報入力用!Y22=1),ROUNDDOWN(世帯賦課条件!C12*世帯賦課条件!I7,0),0)","v":0},{"$f":"IF(AND(世帯情報入力用!AE7=\"TRUE\",世帯情報入力用!AE22=1),ROUNDDOWN(世帯賦課条件!C12*世帯賦課条件!I7,0),0)","v":0}]
["介護 平等割額",{"$f":"IF(AND(OR(世帯情報入力用!G7=\"TRUE\",世帯情報入力用!M7=\"TRUE\",世帯情報入力用!S7=\"TRUE\",世帯情報入力用!Y7=\"TRUE\",世帯情報入力用!AE7=\"TRUE\"),(世帯情報入力用!G22+世帯情報入力用!M22+世帯情報入力用!S22+世帯情報入力用!Y22+世帯情報入力用!AE22>0)),ROUNDDOWN(世帯賦課条件!D12*世帯賦課条件!I7,0),0)","v":0}]
[]
["世帯医療分",{"$f":"IF(SUM(B17:F19)>=E10,E10,SUM(B17:F19))","v":0}]
["世帯支援分",{"$f":"IF(SUM(B20:F22)>=E11,E11,SUM(B20:F22))","v":0}]
["世帯介護分",{"$f":"IF(SUM(B23:F25)>=E12,E12,SUM(B23:F25))","v":0}]
[]
["世帯保険料額",{"$f":"SUM(B27:B29)","v":0}]
["世帯月保険料額",{"$f":"B31/12","v":0}]

{"sheet":"試算年度条件","index":4,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[[2,0,2,1],[0,0,0,1]]}
[{"$f":"世帯情報入力用!A4","v":7}]
[]
["試算年度条件"]
["5割",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,2,0)","v":305000}]
["2割",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,3,0)","v":560000}]
["医療 所得割率",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,4,0)","v":9.2999999999999999E-2}]
["医療 均等割額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,5,0)","v":34424}]
["医療 平等割額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,6,0)","v":33574}]
["医療 限度額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,7,0)","v":650000}]
["支援 所得割率",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,8,0)","v":3.0200000000000001E-2}]
["支援 均等割額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,9,0)","v":11034}]
["支援 平等割額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,10,0)","v":10761}]
["支援 限度額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,11,0)","v":240000}]
["介護 所得割率",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,12,0)","v":2.5600000000000001E-2}]
["介護 均等割額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,13,0)","v":18784}]
["介護 平等割額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,14,0)","v":0}]
["介護 限度額",{"$f":"VLOOKUP(世帯情報入力用!A4,'各年度 料率'!$A$2:$O$9,15,0)","v":170000}]

{"sheet":"各年度 料率","index":5,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["年度","5割","2割","医療 所得割率","医療 均等割額","医療 平等割額","医療 限度額","支援 所得割率","支援 均等割額","支援 平等割額","支援 限度額","介護 所得割率","介護 均等割額","介護 平等割額","介護 限度額"]
[3,285000,520000,8.48E-2,30157,31368,630000,2.7300000000000001E-2,9478,9858,190000,2.47E-2,18213,0,170000]
[4,285000,520000,8.7099999999999997E-2,31854,32105,630000,2.6599999999999999E-2,9426,9500,190000,2.4799999999999999E-2,18306,0,170000]
[5,290000,535000,8.8599999999999998E-2,32948,32750,650000,2.76E-2,9945,9886,200000,2.6100000000000002E-2,19552,0,170000]
[6,295000,545000,9.5600000000000004E-2,35040,34803,650000,3.1199999999999999E-2,11167,11091,220000,2.64E-2,19389,0,170000]
[7,305000,560000,9.2999999999999999E-2,34424,33574,650000,3.0200000000000001E-2,11034,10761,240000,2.5600000000000001E-2,18784,0,170000]
[8]
[9]
[10]