{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["試算表","編集用データ倉庫","Sheet1"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":64,"n_cols":68,"rows_kept":64,"cut":false,"hidden":false,"merged":[[18,9,18,10],[23,10,23,11],[3,36,3,38],[15,40,17,40],[18,40,20,40],[21,40,23,40],[24,40,26,40],[27,40,29,40],[12,37,14,37],[12,36,14,36],[12,35,14,35],[15,35,17,35],[15,36,17,36],[15,37,17,37],[18,39,20,39],[18,38,20,38],[18,37,20,37],[21,36,23,36],[21,37,23,37],[27,39,29,39],[24,39,26,39],[27,38,29,38],[24,38,26,38],[27,37,29,37],[24,10,25,11],[26,10,27,11],[11,18,11,25],[12,15,18,15],[15,32,17,32],[15,31,17,31],[12,39,14,39],[12,38,14,38],[9,42,11,42],[9,39,11,39],[9,38,11,38],[9,36,11,36],[9,35,11,35],[24,28,26,28],[27,28,29,28],[27,29,29,30],[24,29,26,30],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[11,1,11,4],[24,1,25,4],[26,1,27,4],[24,5,25,6],[26,5,27,6],[23,1,23,4],[23,5,23,6],[23,7,23,8],[24,7,25,8],[26,7,27,8],[9,49,11,49],[51,32,52,32],[24,49,26,49],[27,49,29,49],[21,49,23,49],[18,49,20,49],[9,47,11,47],[27,47,29,47],[15,47,17,47],[18,47,20,47],[21,47,23,47],[12,47,14,47],[24,47,26,47],[12,49,14,49],[15,49,17,49],[9,45,11,45],[12,45,14,45],[9,32,11,32],[18,45,20,45],[21,45,23,45],[24,45,26,45],[27,45,29,45],[27,32,29,32],[9,37,11,37],[47,39,47,40],[51,31,52,31],[15,38,17,38],[15,39,17,39],[21,38,23,38],[21,39,23,39],[27,33,28,33],[21,33,22,33],[12,40,14,40],[24,36,26,36],[12,33,13,33],[15,33,16,33],[18,33,19,33],[36,39,36,40],[12,32,14,32],[12,31,14,31],[18,36,20,36],[18,32,20,32],[18,31,20,31],[18,35,20,35],[43,39,44,40],[45,39,45,40],[46,39,46,40],[24,37,26,37],[51,29,52,29],[36,29,36,30],[35,29,35,30],[51,30,52,30],[27,35,29,35],[24,32,26,32],[27,31,29,31],[24,31,26,31],[21,32,23,32],[21,35,23,35],[24,35,26,35],[51,35,52,35],[4,28,4,29],[4,30,4,31],[5,30,5,31],[9,28,11,28],[12,28,14,28],[15,28,17,28],[18,28,20,28],[21,28,23,28],[6,31,7,31],[9,29,11,30],[21,29,23,30],[18,29,20,30],[15,29,17,30],[12,29,14,30],[21,31,23,31],[5,28,5,29],[9,31,11,31],[9,41,11,41],[12,41,14,41],[15,41,17,41],[18,41,20,41],[21,41,23,41],[24,41,26,41],[27,41,29,41],[21,42,23,42],[18,42,20,42],[27,42,29,42],[24,42,26,42],[12,42,14,42],[15,42,17,42],[9,34,10,34],[12,34,13,34],[15,34,16,34],[18,34,19,34],[21,34,22,34],[24,34,25,34],[27,34,28,34],[9,40,11,40],[9,33,10,33],[24,33,25,33],[27,36,29,36]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"子ども減免額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"加入する日付",null,"加入期間",null,null,"１８歳以下基準日","上位所得","子ども人数","医療分","支援分","合計",null,null,"６歳以下基準日","対象人数"]
[null,null,null,null,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":"VALUE(S13&T13&U13&V13&W13&X13&Y13)","v":{"$error":"#VALUE!"}},null,{"$f":"DBCS(V13&W13&X13&Y13)&\"～３月３１日\"","v":"月日～３月３１日"},null,null,"2025-04-01","非該当",{"$f":"COUNTIF($M$13:$M$19,\"○\")","v":0},{"$f":"IF(AND(AJ7>=1,$AI$6=\"非該当\"),IF(AJ7-AQ6>=1,($BB$17)*(AJ7-AQ6)+($BB$17-$BD$17)*(AQ6),($BB$17-$BD$17)*(AJ7)),0)","v":0},{"$f":"IF(AND(AJ7>=1,$AI$6=\"非該当\"),IF(AJ7-AQ6>=1,($BB$18)*(AJ7-AQ6)+($BB$18-$BD$18)*(AQ6),($BB$18-$BD$18)*(AJ7)),0)","v":0},{"$f":"FIXED(AK6+AL6,0)","v":"0"},"（年）",null,"2018-04-02",{"$f":"COUNTIF(AI10:AI30,\"○\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"までに19歳以上になる者を除く",null,{"$f":"AJ6-1","v":-1},{"$f":"ROUNDUP(AK6*BM11,0)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(AL6*BM11,0)","v":{"$error":"#N/A"}},{"$f":"FIXED(AK7+AL7,0)","v":{"$error":"#N/A"}},"（月）",null,"以降生まれの者"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No．","生年月日",null,"年齢","←を数値に","（上）18歳以下基準日時点の年齢\n（下）加入日以降に生まれる方（○・×）","6歳以下基準日時点の年齢","軽減後\n給与所得","所得調整控除後給与所得","年金所得","総所得\n(軽減該当）","総所得\n(通常）","基礎控除後の合計所得(軽減該当)","基礎控除後の合計所得（通常）","※年金以外合計所得(所得金額調整控除前)",null,"軽減後\n所得割","軽減\n所得割\n合計","通常\n所得割","所得割\n合計","均等割\n（子ども\n軽減後）","均等割\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,null,null,null,1,{"$f":"B13&C13&\"年\"&D13&\"月\"&E13&\"日\"","v":"年月日"},null,{"$f":"DATEDIF(AD10,$AC$6,\"y\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C13>0,VALUE(AF10),\"\")","v":""},{"$f":"IF(COUNTA(B13:E13)=4,DATEDIF(AD10,$AH$6,\"y\"),\"\")","v":""},{"$f":"IF(ISERROR(AF10),\"\",IF(DATEVALUE(AD10)>=$AP$6,\"○\",\"\"))","v":""},{"$f":"IF(F13=\"該当\",AF37*0.3,AF37)","v":0},{"$f":"IF(F13=\"該当\",AJ10-AP38-AP45,AF36)","v":0},{"$f":"AG54","v":0},{"$f":"AK10+AL10+J13","v":0},{"$f":"AF36+AL10+J13","v":0},{"$f":"IF(AM10-430000>0,AM10-430000,0)","v":0},{"$f":"IF(AN10-430000>0,AN10-430000,0)","v":0},{"$f":"AF37+J13","v":0},"医療分",{"$f":"ROUNDDOWN(IF($AM$10>430000,($AM$10-430000)*$BA$17,0),0)","v":0},{"$f":"AS10+AS11+AS12","v":0},{"$f":"ROUNDDOWN(IF(AN10>430000,(AN10-430000)*BA17,\"0\"),0)","v":0},{"$f":"AU10+AU11+AU12","v":0},{"$f":"IF(AG10<>\"\",IF(AI10=\"○\",$BB$17-$BD$17,$BB$17),0)","v":0},{"$f":"AW10+AW11+AW12","v":0},null,"国保加入者数",{"$f":"COUNTA($C$13:$C$19)","v":0},"子ども減免後","月割賦課額",null,"国保加入者数",{"$f":"IF(COUNTIF($F$13:$F$19,\"該当\")>0,COUNTA($C$13:$C$19),\"\")","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,"支援分",{"$f":"IF(AM10>430000,(AM10-430000)*$BA$18,0)","v":0},null,{"$f":"IF(AN10>430000,(AN10-430000)*BA18,\"0\")","v":"0"},null,{"$f":"IF(AG10<>\"\",IF(AI10=\"○\",$BB$18-$BD$18,$BB$18),0)","v":0},null,null,"医療分年税額",{"$f":"IF(COUNTA($C$13:$C$19)>0,IF($BA$23>$BG$16,$BG$16,$BA$23),\"0\")","v":"0"},{"$f":"(IF(BA11-$AK$6>0,ROUNDDOWN(BA11-$AK$6,-2),0))","v":0},{"$f":"ROUNDDOWN(BA11*$BM$11-AK7,-2)","v":{"$error":"#N/A"}},null,"医療分年税額",{"$f":"IF(COUNTIF($F$13:$F$19,\"該当\")>0,IF($BA$28>$BG$16,$BG$16,$BA$28),\"\")","v":""},{"$f":"IF(BF11-$AK$6>0,ROUNDDOWN(BF11-$AK$6,-2),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDDOWN(BF11*$BM$11-$AK$7,-2)","v":{"$error":"#VALUE!"}},null,1,0.25,"３ヶ月分",{"$f":"VLOOKUP(V13,BJ10:BK22,2)","v":{"$error":"#N/A"}}]
[null,"②生年月日",null,null,null,"③非自発軽減","④給与収入","※⑤所得金額調整控除(子ども・特別障がい者等を有する者等)","⑥年金収入","⑦その他所得",null,"合計の所得金額","18歳以下の方","所得割","均等割","平等割","介護",null,"①　いつから国保に加入するか",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(B13:E13)<4,\"\",IF(VALUE(AD10)>$AC$6,\"○\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"介護分",{"$f":"IF(AND(AG10>39,AG10<65,$AM$10>430000),($AM$10-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG10>39,AG10<65,$AN$10>430000),($AN$10-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG10>39,AG10<65,C13>0),$BB$19,0)","v":0},null,null,"支援分年税額",{"$f":"IF(COUNTA($C$13:$C$19)>0,IF($BA$24>$BG$17,$BG$17,$BA$24),\"0\")","v":"0"},{"$f":"(IF(BA12-$AL$6>0,ROUNDDOWN(BA12-$AL$6,-2),0))","v":0},{"$f":"ROUNDDOWN(BA12*$BM$11-AL7,-2)","v":{"$error":"#N/A"}},null,"支援分年税額",{"$f":"IF(COUNTIF($F$13:$F$19,\"該当\")>0,IF($BA$29>$BG$17,$BG$17,$BA$29),\"\")","v":""},{"$f":"IF(BF12-$AL$6>0,ROUNDDOWN(BF12-$AL$6,-2),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDDOWN(BF12*$BM$11-$AL$7,-2)","v":{"$error":"#VALUE!"}},null,2,0.16666666666666699,"２ヶ月分"]
[1,null,null,null,null,"　",null,null,null,null,null,{"$f":"IF(C13>0,AM10,\"\")","v":""},{"$f":"IF(AH12=\"○\",\"加入日に未出生の方は含められません\",IF(AH10<=18,\"○\",\"\"))","v":""},{"$f":"IF(C13>0,AT10,\"\")","v":""},{"$f":"IF(C13>0,IF(Q13=\"該当\",SUM($BB$17:$BB$19),SUM($BB$17:$BB$18)),\"\")","v":""},{"$f":"IF(C13>0,IF(COUNTIF(Q13:Q19,\"該当\")>0,SUM(BC17:BC19),SUM(BC17:BC18)),\"\")","v":""},{"$f":"IF(C13>0,IF(AND(AG10>39,AG10<65),\"該当\",\"\"),\"\")","v":""},null,"令和",null,"年",null,"月",null,"日","から",null,null,2,{"$f":"B14&C14&\"年\"&D14&\"月\"&E14&\"日\"","v":"年月日"},null,{"$f":"DATEDIF(AD13,$AC$6,\"y\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C14>0,VALUE(AF13),\"\")","v":""},{"$f":"IF(COUNTA(B14:E14)=4,DATEDIF(AD13,$AH$6,\"y\"),\"\")","v":""},{"$f":"IF(ISERROR(AF13),\"\",IF(DATEVALUE(AD13)>=$AP$6,\"○\",\"\"))","v":""},{"$f":"IF(F14=\"該当\",AG37*0.3,AG37)","v":0},{"$f":"IF(F14=\"該当\",AJ13-AQ38-AQ45,AG36)","v":0},{"$f":"AG55","v":0},{"$f":"AK13+AL13+J14","v":0},{"$f":"AG36+AL13+J14","v":0},{"$f":"IF(AM13-430000>0,AM13-430000,0)","v":0},{"$f":"IF(AN13-430000>0,AN13-430000,0)","v":0},{"$f":"AG37+J14","v":0},"医療分",{"$f":"ROUNDDOWN(IF($AM$13>430000,($AM$13-430000)*$BA$17,0),0)","v":0},{"$f":"AS13+AS14+AS15","v":0},{"$f":"ROUNDDOWN(IF(AN13>430000,(AN13-430000)*BA17,\"0\"),0)","v":0},{"$f":"AU13+AU14+AU15","v":0},{"$f":"IF(AG13<>\"\",IF(AI13=\"○\",$BB$17-$BD$17,$BB$17),0)","v":0},{"$f":"AW13+AW14+AW15","v":0},null,"介護分年税額",{"$f":"IF(COUNTA($C$13:$C$19)>0,IF($BA$25>$BG$18,$BG$18,$BA$25),\"0\")","v":"0"},{"$f":"ROUNDDOWN(BA13,-2)","v":0},{"$f":"ROUNDDOWN(BA13*$BM$11,-2)","v":{"$error":"#N/A"}},null,"介護分年税額",{"$f":"IF(COUNTIF($F$13:$F$19,\"該当\")>0,IF($BA$30>$BG$18,$BG$18,$BA$30),\"\")","v":""},{"$f":"IF(BF13-$AK$7>0,ROUNDDOWN(BF13-$AK$7,-2),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUNDDOWN(BF13*$BM$11,-2)","v":{"$error":"#VALUE!"}},null,3,8.3333333333333329E-2,"１ヶ月分","「○○ヶ月分」と表示させる"]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C14>0,AM13,\"\")","v":""},{"$f":"IF(AH15=\"○\",\"加入日に未出生の方は含められません\",IF(AH13<=18,\"○\",\"\"))","v":""},{"$f":"IF(C14>0,AT13,\"\")","v":""},"",null,{"$f":"IF(C14>0,IF(AND(AG13>39,AG13<65),\"該当\",\"\"),\"\")","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,"支援分",{"$f":"IF($AM$13>430000,ROUNDDOWN(($AM$13-430000)*$BA$18,0),0)","v":0},null,{"$f":"IF(AN13>430000,(AN13-430000)*BA18,\"0\")","v":"0"},null,{"$f":"IF(AG13<>\"\",IF(AI13=\"○\",$BB$18-$BD$18,$BB$18),0)","v":0},null,null,"計",{"$f":"SUM(BA11:BA13)","v":0},{"$f":"SUM(BB11:BB13)","v":0},{"$f":"SUM(BC11:BC13)","v":{"$error":"#N/A"}},null,"計",{"$f":"SUM(BF11:BF13)","v":0},{"$f":"SUM(BG11:BG13)","v":{"$error":"#VALUE!"}},{"$f":"SUM(BH11:BH13)","v":{"$error":"#VALUE!"}},null,4,1,"１２ヶ月分",{"$f":"IF(C13>0,VLOOKUP(V13,BJ10:BL22,3),\"\")","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15>0,AM16,\"\")","v":""},{"$f":"IF(AH18=\"○\",\"加入日に未出生の方は含められません\",IF(AH16<=18,\"○\",\"\"))","v":""},{"$f":"IF(C15>0,AT16,\"\")","v":""},"",null,{"$f":"IF(C15>0,IF(AND(AG16>39,AG16<65),\"該当\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(B14:E14)<4,\"\",IF(VALUE(AD13)>$AC$6,\"○\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"介護分",{"$f":"IF(AND(AG13>39,AG13<65,$AM$13>430000),($AM$13-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG13>39,AG13<65,$AN$13>430000),($AN$13-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG13>39,AG13<65,C14>0),$BB$19,0)","v":0},null,null,null,null,{"$f":"IF(AND(COUNTA(B13:E13)=4,ISNUMBER(BB14)),\"減免額表示\",\"入力不備\")","v":"入力不備"},null,null,null,null,null,null,null,5,0.91666666666666696,"１１ヶ月分","↓「非自発的軽減該当時の一ヶ月分の金額」"]
[4,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C16>0,AM19,\"\")","v":""},{"$f":"IF(AH21=\"○\",\"加入日に未出生の方は含められません\",IF(AH19<=18,\"○\",\"\"))","v":""},{"$f":"IF(C16>0,AT19,\"\")","v":""},"",null,{"$f":"IF(C16>0,IF(AND(AG19>39,AG19<65),\"該当\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"B15&C15&\"年\"&D15&\"月\"&E15&\"日\"","v":"年月日"},null,{"$f":"DATEDIF(AD16,$AC$6,\"y\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C15>0,VALUE(AF16),\"\")","v":""},{"$f":"IF(COUNTA(B15:E15)=4,DATEDIF(AD16,$AH$6,\"y\"),\"\")","v":""},{"$f":"IF(ISERROR(AF16),\"\",IF(DATEVALUE(AD16)>=$AP$6,\"○\",\"\"))","v":""},{"$f":"IF(F15=\"該当\",AH37*0.3,AH37)","v":0},{"$f":"IF(F15=\"該当\",AJ16-AR38-AR45,AH36)","v":0},{"$f":"AG56","v":0},{"$f":"AK16+AL16+J15","v":0},{"$f":"AH36+AL16+J15","v":0},{"$f":"IF(AM16-430000>0,AM16-430000,0)","v":0},{"$f":"IF(AN16-430000>0,AN16-430000,0)","v":0},{"$f":"AH37+J15","v":0},"医療分",{"$f":"ROUNDDOWN(IF($AM$16>430000,($AM$16-430000)*$BA$17,0),0)","v":0},{"$f":"AS16+AS17+AS18","v":0},{"$f":"ROUNDDOWN(IF($AN$16>430000,($AN$16-430000)*BA17,\"0\"),0)","v":0},{"$f":"AU16+AU17+AU18","v":0},{"$f":"IF(AG16<>\"\",IF(AI16=\"○\",$BB$17-$BD$17,$BB$17),0)","v":0},{"$f":"AW16+AW17+AW18","v":0},null,"税率","所得割","均等割","平等割","子ども均等割\n軽減額",null,"医療分限度額",650000,null,null,6,0.83333333333333337,"１０ヶ月分",{"$f":"IF(AND($BM$23=\"試算額表示\",COUNTIF($F$13:$F$19,\"該当\")>0),\"約\"&FIXED($BH$14/$BM$11/12,0,FALSE)&\"円\",\"\")","v":""}]
[5,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C17>0,AM22,\"\")","v":""},{"$f":"IF(AH24=\"○\",\"加入日に未出生の方は含められません\",IF(AH22<=18,\"○\",\"\"))","v":""},{"$f":"IF(C17>0,AT22,\"\")","v":""},"",null,{"$f":"IF(C17>0,IF(AND(AG22>39,AG22<65),\"該当\",\"\"),\"\")","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,"支援分",{"$f":"IF($AM$16>430000,($AM$16-430000)*$BA$18,0)","v":0},null,{"$f":"IF($AN$16>430000,($AN$16-430000)*BA18,\"0\")","v":"0"},null,{"$f":"IF(AG16<>\"\",IF(AI16=\"○\",$BB$18-$BD$18,$BB$18),0)","v":0},null,null,"医療分",6.5000000000000002E-2,19700,18300,{"$f":"BB17*0.5","v":9850},null,"支援分限度額",220000,null,null,7,0.75,"９ヶ月分","↓「非自発的軽減該当時の○○月分の金額」"]
[6,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C18>0,AM25,\"\")","v":""},{"$f":"IF(AH27=\"○\",\"加入日に未出生の方は含められません\",IF(AH25<=18,\"○\",\"\"))","v":""},{"$f":"IF(C18>0,AT25,\"\")","v":""},"",null,{"$f":"IF(C18>0,IF(AND(AG25>39,AG25<65),\"該当\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(B15:E15)<4,\"\",IF(VALUE(AD16)>$AC$6,\"○\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"介護分",{"$f":"IF(AND(AG16>39,AG16<65,$AM$16>430000),($AM$16-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG16>39,AG16<65,$AN$16>430000),($AN$16-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG16>39,AG16<65,C15>0),$BB$19,0)","v":0},null,null,"支援分",2.5999999999999999E-2,7800,7200,{"$f":"BB18*0.5","v":3900},null,"介護分限度額",170000,null,null,8,0.66666666666666663,"８ヶ月分",{"$f":"IF(AND($BM$23=\"試算額表示\",COUNTIF($F$13:$F$19,\"該当\")>0),IF($E$13>0,\"約\"&FIXED($BH$14,0,FALSE)&\"円\",\"\"),\"\")","v":""},"子ども減免\n非該当時\n→",{"$f":"IF($BM$23=\"試算額表示\",ROUNDDOWN(BA14*BM11,-2),\"\")","v":""}]
[7,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C19>0,AM28,\"\")","v":""},{"$f":"IF(AH30=\"○\",\"加入日に未出生の方は含められません\",IF(AH28<=18,\"○\",\"\"))","v":""},{"$f":"IF(C19>0,AT28,\"\")","v":""},"",null,{"$f":"IF(C19>0,IF(AND(AG28>39,AG28<65),\"該当\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"B16&C16&\"年\"&D16&\"月\"&E16&\"日\"","v":"年月日"},null,{"$f":"DATEDIF(AD19,$AC$6,\"y\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C16>0,VALUE(AF19),\"\")","v":""},{"$f":"IF(COUNTA(B16:E16)=4,DATEDIF(AD19,$AH$6,\"y\"),\"\")","v":""},{"$f":"IF(ISERROR(AF19),\"\",IF(DATEVALUE(AD19)>=$AP$6,\"○\",\"\"))","v":""},{"$f":"IF(F16=\"該当\",AI37*0.3,AI37)","v":0},{"$f":"IF(F16=\"該当\",AJ19-AS38-AS45,AI36)","v":0},{"$f":"AG57","v":0},{"$f":"AK19+AL19+J16","v":0},{"$f":"AI36+AL19+J16","v":0},{"$f":"IF(AM19-430000>0,AM19-430000,0)","v":0},{"$f":"IF(AN19-430000>0,AN19-430000,0)","v":0},{"$f":"AI37+J16","v":0},"医療分",{"$f":"ROUNDDOWN(IF($AM$19>430000,($AM$19-430000)*$BA$17,0),0)","v":0},{"$f":"AS19+AS20+AS21","v":0},{"$f":"ROUNDDOWN(IF($AN$19>430000,($AN$19-430000)*$BA$17,\"0\"),0)","v":0},{"$f":"AU19+AU20+AU21","v":0},{"$f":"IF(AG19<>\"\",IF(AI19=\"○\",$BB$17-$BD$17,$BB$17),0)","v":0},{"$f":"AW19+AW20+AW21","v":0},null,"介護分",2.5999999999999999E-2,10000,6200,{"$f":"BB19*0.5","v":5000},null,null,null,null,null,9,0.58333333333333337,"７ヶ月分","↓「通常時一月分の金額」",null,"↓"]
[null,"※⑤所得金額調整控除（子ども・特別障がい者等を有する者等）欄は給与収入が850万円を超え、",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支援分",{"$f":"IF($AM$19>430000,($AM$19-430000)*$BA$18,0)","v":0},null,{"$f":"IF($AN$19>430000,($AN$19-430000)*$BA$18,\"0\")","v":"0"},null,{"$f":"IF(AG19<>\"\",IF(AI19=\"○\",$BB$18-$BD$18,$BB$18),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,10,0.5,"６ヶ月分",{"$f":"IF(AND($BM$23=\"試算額表示\",$BO$22/$BM$11>0),\"約\"&FIXED($BO$22/$BM$11/12,0,FALSE)&\"円\",\"\")","v":{"$error":"#VALUE!"}},null,"↓"]
[null,"　適用対象者の方 （1.本人が特別障がい者である場合　2.年齢23歳未満の扶養親族がいる場合　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(B16:E16)<4,\"\",IF(VALUE(AD19)>$AC$6,\"○\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"介護分",{"$f":"IF(AND(AG19>39,AG19<65,$AM$19>430000),($AM$19-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG19>39,AG19<65,$AN$19>430000),($AN$19-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG19>39,AG19<65,C16>0),$BB$19,0)","v":0},null,null,"軽減該当前",null,null,null,null,null,null,null,null,null,11,0.41666666666666669,"５ヶ月分","↓「通常時○○月分の金額」",null,"↓"]
[null," 　3.特別障がい者である同一生計配偶者・扶養親族がいる場合）のみ「有」となります。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"B17&C17&\"年\"&D17&\"月\"&E17&\"日\"","v":"年月日"},null,{"$f":"DATEDIF(AD22,$AC$6,\"y\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C17>0,VALUE(AF22),\"\")","v":""},{"$f":"IF(COUNTA(B17:E17)=4,DATEDIF(AD22,$AH$6,\"y\"),\"\")","v":""},{"$f":"IF(ISERROR(AF22),\"\",IF(DATEVALUE(AD22)>=$AP$6,\"○\",\"\"))","v":""},{"$f":"IF(F17=\"該当\",AJ37*0.3,AJ37)","v":0},{"$f":"IF(F17=\"該当\",AJ22-AT38-AT45,AJ36)","v":0},{"$f":"AG58","v":0},{"$f":"AK22+AL22+J17","v":0},{"$f":"AJ36+AL22+J17","v":0},{"$f":"IF(AM22-430000>0,AM22-430000,0)","v":0},{"$f":"IF(AN22-430000>0,AN22-430000,0)","v":0},{"$f":"AJ37+J17","v":0},"医療分",{"$f":"ROUNDDOWN(IF($AM$22>430000,($AM$22-430000)*$BA$17,0),0)","v":0},{"$f":"AS22+AS23+AS24","v":0},{"$f":"ROUNDDOWN(IF($AN$22>430000,($AN$22-430000)*$BA$17,\"0\"),0)","v":0},{"$f":"AU22+AU23+AU24","v":0},{"$f":"IF(AG22<>\"\",IF(AI22=\"○\",$BB$17-$BD$17,$BB$17),0)","v":0},{"$f":"AW22+AW23+AW24","v":0},null,null,"子ども減免前",null,null,null,null,null,null,null,null,12,0.33333333333333331,"４ヶ月分",{"$f":"IF($BM$23=\"試算額表示\",\"約\"&FIXED($BO$22,0,FALSE)&\"円\",\"\")","v":""},"←　←　←　←",{"$f":"IF(AND(COUNTIF($F$13:$F$19,\"該当\")>0,SUM($AP$10:$AP$30)>6000000),$BO$18,IF($BM$23=\"試算額表示\",$BC$14,\"\"))","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,"支援分",{"$f":"IF($AM$22>430000,($AM$22-430000)*$BA$18,0)","v":0},null,{"$f":"IF($AN$22>430000,($AN$22-430000)*$BA$18,\"0\")","v":"0"},null,{"$f":"IF(AG22<>\"\",IF(AI22=\"○\",$BB$18-$BD$18,$BB$18),0)","v":0},null,null,"医療分小計",{"$f":"AU10+AW10+AU13+AW13+AU16+AW16+AU19+AW19+AU22+AW22+AU25+AW25+AU28+AW28+BC17","v":18300},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(COUNTA(B13:E13)=4,ISNUMBER(BB14)),\"試算額表示\",\"入力不備\")","v":"入力不備"}]
[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,{"$f":"IF(COUNTA(B17:E17)<4,\"\",IF(VALUE(AD22)>$AC$6,\"○\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"介護分",{"$f":"IF(AND(AG22>39,AG22<65,$AM$22>430000),($AM$22-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG22>39,AG22<65,$AN$22>430000),($AN$22-430000)*$BA$19,\"0\")","v":"0"},null,{"$f":"IF(AND(AG22>39,AG22<65,C17>0),$BB$19,0)","v":0},null,null,"支援分小計",{"$f":"AU11+AW11+AU14+AW14+AU17+AW17+AU20+AW20+AU23+AW23+AU26+AW26+AU29+AW29+BC18","v":7200}]
[null,{"$f":"IF(X13>0,AE6,\"\")","v":""},null,null,null,{"$f":"IF(AND(G13<=8500000,H13=\"有\"),\"④給与収入850万円以下の場合、※⑤所得金額調整控除を「無」にしてください\",IF(ISERROR(BM22),\"①、②を入力すると\",BM22))","v":""},null,{"$f":"IF(AND(G13<=8500000,H13=\"有\"),\"\",IF(ISERROR(BM22),\"計算結果が表示されます\",BM18))","v":""},null,null,{"$f":"IF(AND($BB$15=\"減免額表示\",AJ6>1),IF($AI$6=\"非該当\",\"約\"&$AM$7&\"円\",\"上位所得世帯に該当します\"),\"１８歳以下の子どもが２人以上いる場合、２人　\n　目以降の均等割額分の減免額が表示されます\")","v":"１８歳以下の子どもが２人以上いる場合、２人　\n　目以降の均等割額分の減免額が表示されます"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"B18&C18&\"年\"&D18&\"月\"&E18&\"日\"","v":"年月日"},null,{"$f":"DATEDIF(AD25,$AC$6,\"y\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C18>0,VALUE(AF25),\"\")","v":""},{"$f":"IF(COUNTA(B18:E18)=4,DATEDIF(AD25,$AH$6,\"y\"),\"\")","v":""},{"$f":"IF(ISERROR(AF25),\"\",IF(DATEVALUE(AD25)>=$AP$6,\"○\",\"\"))","v":""},{"$f":"IF(F18=\"該当\",AK37*0.3,AK37)","v":0},{"$f":"IF(F18=\"該当\",AJ25-AU38-AU45,AK36)","v":0},{"$f":"AG59","v":0},{"$f":"AK25+AL25+J18","v":0},{"$f":"AK36+AL25+J18","v":0},{"$f":"IF(AM25-430000>0,AM25-430000,0)","v":0},{"$f":"IF(AN25-430000>0,AN25-430000,0)","v":0},{"$f":"AK37+J18","v":0},"医療分",{"$f":"ROUNDDOWN(IF($AM$25>430000,($AM$25-430000)*$BA$17,0),0)","v":0},{"$f":"AS25+AS26+AS27","v":0},{"$f":"ROUNDDOWN(IF($AN$25>430000,($AN$25-430000)*$BA$17,\"0\"),0)","v":0},{"$f":"AU25+AU26+AU27","v":0},{"$f":"IF(AG25<>\"\",IF(AI25=\"○\",$BB$17-$BD$17,$BB$17),0)","v":0},{"$f":"AW25+AW26+AW27","v":0},null,"介護分小計",{"$f":"$AU$12+$AW$12+$AU$15+$AW$15+$AU$18+$AW$18+$AU$21+$AW$21+$AU$24+$AW$24+$AU$27+$AW$27+$AU$30+$AW$30+IF(COUNTIF($Q$13:$Q$19,\"該当\")>0,$BC$19,\"0\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($BM$23=\"試算額表示\",\"約\"&FIXED(ROUNDDOWN(BB14*BM11,-2),0,FALSE)&\"円\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支援分",{"$f":"IF($AM$25>430000,($AM$25-430000)*$BA$18,0)","v":0},null,{"$f":"IF($AN$25>430000,($AN$25-430000)*$BA$18,\"0\")","v":"0"},null,{"$f":"IF(AG25<>\"\",IF(AI25=\"○\",$BB$18-$BD$18,$BB$18),0)","v":0},null,null,"軽減該当後"]
[null,"１ヶ月分",null,null,null,{"$f":"IF(ISERROR(BM20),\"\",BM20)","v":""},null,{"$f":"IF(ISERROR(BM16),\"\",BM16)","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,{"$f":"IF(COUNTA(B18:E18)<4,\"\",IF(VALUE(AD25)>$AC$6,\"○\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"介護分",{"$f":"IF(AND(AG25>39,AG25<65,$AM$25>430000),($AM$25-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG25>39,AG25<65,$AN$25>430000),($AN$25-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG25>39,AG25<65,C18>0),$BB$19,0)","v":0},null,null,null,"子ども減免前"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"B19&C19&\"年\"&D19&\"月\"&E19&\"日\"","v":"年月日"},null,{"$f":"DATEDIF(AD28,$AC$6,\"y\")","v":{"$error":"#VALUE!"}},{"$f":"IF(C19>0,VALUE(AF28),\"\")","v":""},{"$f":"IF(COUNTA(B19:E19)=4,DATEDIF(AD28,$AH$6,\"y\"),\"\")","v":""},{"$f":"IF(ISERROR(AF28),\"\",IF(DATEVALUE(AD28)>=$AP$6,\"○\",\"\"))","v":""},{"$f":"IF(F19=\"該当\",AL37*0.3,AL37)","v":0},{"$f":"IF(F19=\"該当\",AJ28-AV38-AV45,AL36)","v":0},{"$f":"AG60","v":0},{"$f":"AK28+AL28+J19","v":0},{"$f":"AL36+AL28+J19","v":0},{"$f":"IF(AM28-430000>0,AM28-430000,0)","v":0},{"$f":"IF(AN28-430000>0,AN28-430000,0)","v":0},{"$f":"AL37+J19","v":0},"医療分",{"$f":"ROUNDDOWN(IF($AM$28>430000,($AM$28-430000)*$BA$17,0),0)","v":0},{"$f":"AS28+AS29+AS30","v":0},{"$f":"ROUNDDOWN(IF($AN$28>430000,($AN$28-430000)*$BA$17,\"0\"),0)","v":0},{"$f":"AU28+AU29+AU30","v":0},{"$f":"IF(AG28<>\"\",IF(AI28=\"○\",$BB$17-$BD$17,$BB$17),0)","v":0},{"$f":"AW28+AW29+AW30","v":0},null,"医療分小計",{"$f":"AS10+AW10+AS13+AW13+AS16+AW16+AS19+AW19+AS22+AW22+AS25+AW25+AS28+AW28+BC17","v":18300}]
[null,"★国民健康保険税の軽減：一定の所得以下の世帯に対して、均等割額・平等割額を軽減する制度があります。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"支援分",{"$f":"IF($AM$28>430000,($AM$28-430000)*$BA$18,0)","v":0},null,{"$f":"IF($AN$28>430000,($AN$28-430000)*$BA$18,\"0\")","v":"0"},null,{"$f":"IF(AG28<>\"\",IF(AI28=\"○\",$BB$18-$BD$18,$BB$18),0)","v":0},null,null,"支援分小計",{"$f":"AS11+AW11+AS14+AW14+AS17+AW17+AS20+AW20+AS23+AW23+AS26+AW26+AS29+AW29+BC18","v":7200}]
[null,"→詳しくはこちら：",null,null,"http://www.city.fukushima.fukushima.jp/kokuho-shikaku/kurashi/kokuho/hokenkyufu/sedo/1072.html",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(B19:E19)<4,\"\",IF(VALUE(AD28)>$AC$6,\"○\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,"介護分",{"$f":"IF(AND(AG28>39,AG28<65,$AM$28>430000),($AM$28-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG28>39,AG28<65,$AN$28>430000),($AN$28-430000)*$BA$19,0)","v":0},null,{"$f":"IF(AND(AG28>39,AG28<65,C19>0),$BB$19,0)","v":0},null,null,"介護分小計",{"$f":"AS12+AW12+AS15+AW15+AS18+AW18+AS21+AW21+AS24+AW24+AS27+AW27+AS30+AW30+IF(COUNTIF(Q13:Q19,\"該当\")>0,BC19,\"0\")","v":0}]
[null,"★非自発的失業者にかかる国民健康保険税の軽減：会社の倒産・解雇などによる離職（特定受給資格者）や",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AO10:AO30)","v":0},{"$f":"SUM(AP10:AP30)","v":0}]
[null,"雇い止めなどによる離職（特定理由離職者）により、職場の健康保険等を脱退したかたに対する軽減制度があります。"]
[null,"→詳しくはこちら：",null,null,"http://www.city.fukushima.fukushima.jp/kokuho-shikaku/kurashi/kokuho/hokenkyufu/sedo/1061.html"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"＜給与所得＞"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"パラメータ",null,1,2,3,4,5,6,7,null,"＜所得金額調整控除＞"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"調整控除後給与所得",null,{"$f":"IF(H13=\"有\",AF37-AP38-AP45,AF37-AP45)","v":0},{"$f":"IF(H14=\"有\",AG37-AQ38-AQ45,AG37-AQ45)","v":0},{"$f":"IF(H15=\"有\",AH37-AR38-AR45,AH37-AR45)","v":0},{"$f":"IF(H16=\"有\",AI37-AS38-AS45,AI37-AS45)","v":0},{"$f":"IF(H17=\"有\",AJ37-AT38-AT45,AJ37-AT45)","v":0},{"$f":"IF(H18=\"有\",AK37-AU38-AU45,AK37-AU45)","v":0},{"$f":"IF(H19=\"有\",AL37-AV38-AV45,AL37-AV45)","v":0},null,"１項：特別障がい者等（給与収入850万超えの場合）"]
[null,null,null,null,null,null,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":"VLOOKUP(G13,AD38:AF48,3)","v":0},{"$f":"VLOOKUP(G14,AD38:AG48,4)","v":0},{"$f":"VLOOKUP(G15,AD38:AH48,5)","v":0},{"$f":"VLOOKUP(G16,AD38:AI48,6)","v":0},{"$f":"VLOOKUP(G17,AD38:AJ48,7)","v":0},{"$f":"VLOOKUP(G18,AD38:AK48,8)","v":0},{"$f":"VLOOKUP(G19,AD38:AL48,9)","v":0},null,"パラメータ（子ども・特別障がい者等調整控除有）",null,1,2,3,4,5,6,7]
[null,null,null,null,null,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,550999,0,0,0,0,0,0,0,null,null,"１項調整\n控除額",{"$f":"IF(H13=\"有\",VLOOKUP(G13,AN39:AP40,3),0)","v":0},{"$f":"IF(H14=\"有\",VLOOKUP(G14,AN39:AQ40,4),0)","v":0},{"$f":"IF(H15=\"有\",VLOOKUP(G15,AN39:AR40,5),0)","v":0},{"$f":"IF(H16=\"有\",VLOOKUP(G16,AN39:AS40,6),0)","v":0},{"$f":"IF(H17=\"有\",VLOOKUP(G17,AN39:AT40,7),0)","v":0},{"$f":"IF(H18=\"有\",VLOOKUP(G18,AN39:AU40,8),0)","v":0},{"$f":"IF(H19=\"有\",VLOOKUP(G19,AN39:AV40,9),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,551000,1618999,{"$f":"G13-550000","v":-550000},{"$f":"G14-550000","v":-550000},{"$f":"G15-550000","v":-550000},{"$f":"G16-550000","v":-550000},{"$f":"G17-550000","v":-550000},{"$f":"G18-550000","v":-550000},{"$f":"G19-550000","v":-550000},null,8500001,9999999,{"$f":"ROUNDUP((G13-8500000)*0.1,0)","v":-850000},{"$f":"ROUNDUP((G14-8500000)*0.1,0)","v":-850000},{"$f":"ROUNDUP((G15-8500000)*0.1,0)","v":-850000},{"$f":"ROUNDUP((G16-8500000)*0.1,0)","v":-850000},{"$f":"ROUNDUP((G17-8500000)*0.1,0)","v":-850000},{"$f":"ROUNDUP((G18-8500000)*0.1,0)","v":-850000},{"$f":"ROUNDUP((G19-8500000)*0.1,0)","v":-850000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1619000,1619999,1069000,1069000,1069000,1069000,1069000,1069000,1069000,null,10000000,null,{"$f":"150000","v":150000},150000,150000,150000,150000,150000,150000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1620000,1621999,1070000,1070000,1070000,1070000,1070000,1070000,1070000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1622000,1623999,1072000,1072000,1072000,1072000,1072000,1072000,1072000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1624000,1627999,1074000,1074000,1074000,1074000,1074000,1074000,1074000,null,"２項：年金所得がある者"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1628000,1799999,{"$f":"ROUNDDOWN(G13/4,-3)*4*0.6+100000","v":100000},{"$f":"ROUNDDOWN(G14/4,-3)*4*0.6+100000","v":100000},{"$f":"ROUNDDOWN(G15/4,-3)*4*0.6+100000","v":100000},{"$f":"ROUNDDOWN(G16/4,-3)*4*0.6+100000","v":100000},{"$f":"ROUNDDOWN(G17/4,-3)*4*0.6+100000","v":100000},{"$f":"ROUNDDOWN(G18/4,-3)*4*0.6+100000","v":100000},{"$f":"ROUNDDOWN(G19/4,-3)*4*0.6+100000","v":100000},null,"調整控除額",null,1,2,3,4,5,6,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1800000,3599999,{"$f":"ROUNDDOWN(G13/4,-3)*4*0.7-80000","v":-80000},{"$f":"ROUNDDOWN(G14/4,-3)*4*0.7-80000","v":-80000},{"$f":"ROUNDDOWN(G15/4,-3)*4*0.7-80000","v":-80000},{"$f":"ROUNDDOWN(G16/4,-3)*4*0.7-80000","v":-80000},{"$f":"ROUNDDOWN(G17/4,-3)*4*0.7-80000","v":-80000},{"$f":"ROUNDDOWN(G18/4,-3)*4*0.7-80000","v":-80000},{"$f":"ROUNDDOWN(G19/4,-3)*4*0.7-80000","v":-80000},null,null,null,{"$f":"IF(AP48-100000<0,0,AP48-100000)","v":0},{"$f":"IF(AQ48-100000<0,0,AQ48-100000)","v":0},0,0,0,0,{"$f":"IF(AV48-100000<0,0,AV48-100000)","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,3600000,6599999,{"$f":"ROUNDDOWN(G13/4,-3)*4*0.8-440000","v":-440000},{"$f":"ROUNDDOWN(G14/4,-3)*4*0.8-440000","v":-440000},{"$f":"ROUNDDOWN(G15/4,-3)*4*0.8-440000","v":-440000},{"$f":"ROUNDDOWN(G16/4,-3)*4*0.8-440000","v":-440000},{"$f":"ROUNDDOWN(G17/4,-3)*4*0.8-440000","v":-440000},{"$f":"ROUNDDOWN(G18/4,-3)*4*0.8-440000","v":-440000},{"$f":"ROUNDDOWN(G19/4,-3)*4*0.8-440000","v":-440000},null,"a.給与所得（上限10万円）",null,{"$f":"IF(AF37>=100000,100000,AF37)","v":0},0,0,0,0,0,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,6600000,8499999,{"$f":"G13*0.9-1100000","v":-1100000},{"$f":"G14*0.9-1100000","v":-1100000},{"$f":"G15*0.9-1100000","v":-1100000},{"$f":"G16*0.9-1100000","v":-1100000},{"$f":"G17*0.9-1100000","v":-1100000},{"$f":"G18*0.9-1100000","v":-1100000},{"$f":"G19*0.9-1100000","v":-1100000},null,"b.年金所得（上限10万円）",null,{"$f":"IF(AG54>=100000,100000,AG54)","v":0},{"$f":"IF(AG55>=100000,100000,AG55)","v":0},{"$f":"IF(AG56>=100000,100000,AG56)","v":0},{"$f":"IF(AG57>=100000,100000,AG57)","v":0},{"$f":"IF(AG58>=100000,100000,AG58)","v":0},{"$f":"IF(AG59>=100000,100000,AG59)","v":0},{"$f":"IF(AG60>=100000,100000,AG60)","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,8500000,null,{"$f":"G13-1950000","v":-1950000},{"$f":"G14-1950000","v":-1950000},{"$f":"G15-1950000","v":-1950000},{"$f":"G16-1950000","v":-1950000},{"$f":"G17-1950000","v":-1950000},{"$f":"G18-1950000","v":-1950000},{"$f":"G19-1950000","v":-1950000},null,"a+b",null,{"$f":"SUM(AP46:AP47)","v":0},0,0,0,0,0,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,"生年\n月日","←を計算\n可能に","年齢区分","年金所得",null,null,"年金控除減少額（年金以外所得が1000万以上）","年金所得算出パラメータ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"65歳未満の場合","65歳以上の場合"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(C13>0,IF(B13=\"令和\",\"5\",IF(B13=\"平成\",\"4\",IF(B13=\"昭和\",\"3\",\"\")))&C13&D13&E13,\"\")","v":""},{"$f":"IF(C13>0,VALUE(AD54),\"\")","v":""},{"$f":"IF(AE54=\"\",\"\",IF(AE54<=$AF$63,\"65歳以上\",\"65歳未満\"))","v":""},{"$f":"IF(AE54<=$AF$63,AI54,AH54)","v":0},{"$f":"IF(I13*VLOOKUP(I13,$AK$60:$AM$64,2)-VLOOKUP(I13,$AK$60:$AM$64,3)+AJ54>0,I13*VLOOKUP(I13,$AK$60:$AM$64,2)-VLOOKUP(I13,$AK$60:$AM$64,3)+AJ54,0)","v":0},{"$f":"IF(I13*VLOOKUP(I13,$AK$54:$AM$58,2)-VLOOKUP(I13,$AK$54:$AM$58,3)+AJ54>0,I13*VLOOKUP(I13,$AK$54:$AM$58,2)-VLOOKUP(I13,$AK$54:$AM$58,3)+AJ54,0)","v":0},{"$f":"IF(AQ10<=10000000,0,IF(AQ10<=20000000,100000,200000))","v":0},0,1,1100000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(C14>0,IF(B14=\"令和\",\"5\",IF(B14=\"平成\",\"4\",IF(B14=\"昭和\",\"3\",\"\")))&C14&D14&E14,\"\")","v":""},{"$f":"IF(C14>0,VALUE(AD55),\"\")","v":""},{"$f":"IF(AE55=\"\",\"\",IF(AE55<=$AF$63,\"65歳以上\",\"65歳未満\"))","v":""},0,{"$f":"IF(I14*VLOOKUP(I14,$AK$60:$AM$64,2)-VLOOKUP(I14,$AK$60:$AM$64,3)+AJ55>0,I14*VLOOKUP(I14,$AK$60:$AM$64,2)-VLOOKUP(I14,$AK$60:$AM$64,3)+AJ55,0)","v":0},{"$f":"IF(I14*VLOOKUP(I14,$AK$54:$AM$58,2)-VLOOKUP(I14,$AK$54:$AM$58,3)+AJ55>0,I14*VLOOKUP(I14,$AK$54:$AM$58,2)-VLOOKUP(I14,$AK$54:$AM$58,3)+AJ55,0)","v":0},{"$f":"IF(AQ13<=10000000,0,IF(AQ13<=20000000,100000,200000))","v":0},3300000,0.75,275000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(C15>0,IF(B15=\"令和\",\"5\",IF(B15=\"平成\",\"4\",IF(B15=\"昭和\",\"3\",\"\")))&C15&D15&E15,\"\")","v":""},{"$f":"IF(C15>0,VALUE(AD56),\"\")","v":""},"",0,0,0,{"$f":"IF(AQ16<=10000000,0,IF(AQ16<=20000000,100000,200000))","v":0},4100000,0.85,685000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"","","",0,{"$f":"IF(I16*VLOOKUP(I16,$AK$60:$AM$64,2)-VLOOKUP(I16,$AK$60:$AM$64,3)+AJ57>0,I16*VLOOKUP(I16,$AK$60:$AM$64,2)-VLOOKUP(I16,$AK$60:$AM$64,3)+AJ57,0)","v":0},0,{"$f":"IF(AQ19<=10000000,0,IF(AQ19<=20000000,100000,200000))","v":0},7700000,0.95,1455000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"","","",0,0,0,{"$f":"IF(AQ22<=10000000,0,IF(AQ22<=20000000,100000,200000))","v":0},10000000,1,1955000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(C18>0,IF(B18=\"令和\",\"5\",IF(B18=\"平成\",\"4\",IF(B18=\"昭和\",\"3\",\"\")))&C18&D18&E18,\"\")","v":""},{"$f":"IF(C18>0,VALUE(AD59),\"\")","v":""},"",0,0,{"$f":"IF(I18*VLOOKUP(I18,$AK$54:$AM$58,2)-VLOOKUP(I18,$AK$54:$AM$58,3)+AJ59>0,I18*VLOOKUP(I18,$AK$54:$AM$58,2)-VLOOKUP(I18,$AK$54:$AM$58,3)+AJ59,0)","v":0},{"$f":"IF(AQ25<=10000000,0,IF(AQ25<=20000000,100000,200000))","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,7,"","","",0,0,0,{"$f":"IF(AQ28<=10000000,0,IF(AQ28<=20000000,100000,200000))","v":0},0,1,600000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1300000,0.75,275000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年齢区分\n判定基準日",null,null,null,null,4100000,0.85,685000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3340101,null,null,null,null,7700000,0.95,1455000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※税法上65歳以上の年金控除額となる基準日",null,null,null,null,10000000,1,1955000]

{"sheet":"編集用データ倉庫","index":1,"n_rows":91,"n_cols":36,"rows_kept":91,"cut":false,"hidden":true,"merged":[[4,29,6,29],[4,30,6,30],[4,31,6,31],[4,32,6,32],[4,33,6,33],[10,35,12,35],[7,35,9,35],[3,30,3,31],[3,32,3,33],[3,34,3,35],[4,34,6,34],[4,35,6,35],[10,34,12,34],[7,34,9,34],[7,29,8,29],[7,30,9,30],[7,31,9,31],[7,32,9,32],[7,33,9,33],[10,29,11,29],[10,30,12,30],[10,31,12,31],[10,32,12,32],[10,33,12,33]]}
[null,"※下記の点に注意して黄色の部分を入力してください。"]
[null,"①生年月日は、必ず入力してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"平成２７年度　国民健康保険税　試算表"]
[null,"②非自発軽減は、非自発的離職者に係る国民健康保険税の軽減に該当した場合の試算を希望の際に入力してください。"]
[null,"③給与収入は、源泉徴収票の支払金額、もしくは申告書の給与収入の金額を入力してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"区分","医療分",null,"支援分",null,"介護分"]
[null,"④年金収入（公的年金）は、源泉徴収票の支払金額、もしくは申告書の年金収入の金額を入力してください。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"所得割率","7.80","％","2.90","％","2.50","％"]
[null,"⑤その他所得には、営業・農業・不動産・その他の事業等の所得金額（収入金額－必要経費）を入力してください。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"均等割額",17800,"円",6000,"円",7800,"円"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（１人あたり）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"平等割額",19700,"円",6600,"円",5700,"円"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（１世帯あたり）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※計算結果はあくまで概算であり、実際の税額と異なる場合があります※"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"【試算表の使い方】"]
[]
[null,null,null,null,null,null,null,null,null,null,"◆◇◆下記の三点をお読みいただいた後に、黄色の部分を入力してください◆◇◆"]
[]
[]
[]
[null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　◇◆◇入力例◇◆◇"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"様"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"（概算）"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}