{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["入力用","給与所得計算","年金所得計算","税額計算","結果"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[[5,1,5,7],[6,1,6,7],[49,1,49,6],[33,2,34,2],[33,1,34,1],[33,6,34,6],[33,7,34,7]]}
[]
[]
[]
[]
[]
[null,"●荒尾市の国民健康保険に加入した場合の税額の計算ができます。"]
[null,"あくまで目安ですので、実際の税額とは異なる場合があります。"]
[null,"※注意事項※　計算する前にお読みください。"]
[null,"次のような場合は、正しい税額を計算することができませんので、直接窓口にお問い合わせください。"]
[null,"・前年中に分離課税の所得や専従者給与があった場合"]
[null,"・年金所得があり、それ以外の所得が1,000万円以上ある場合"]
[null,"・純損失、雑損失の繰越控除がある場合"]
[null,"・世帯員ごとに加入月数が異なる場合（例：世帯主は４月からで世帯員１は８月から、等）"]
[null,"・社会保険の被保険者が７５歳になることでその被扶養者が国民健康保険に加入する場合"]
[null,"・年度途中に４０歳もしくは６５歳になる人がいる世帯"]
[null,"・特定世帯及び特定継続世帯（※）"]
[null,"※特定世帯とは・・・世帯内の国民健康保険加入者が後期高齢者医療保険制度に移行したために、国民健康保険の被保険者"]
[null,"の人数が１人になった世帯のことで、医療分と後期高齢者支援分の世帯割が５年間半額になります。"]
[null,"　特定継続世帯とは・・・特定世帯が５年を経過しても世帯状況が変わらなかった世帯のことで、さらに３年間世帯割が"]
[null,"４分の１減額になります。"]
[]
[null,"●次の①～④まで入力し、”計算する”を押すと国民健康保険税の税額がわかります。"]
[null,null,"①国保に加入するのは何人ですか？（同じ世帯ですでに加入している人も含みます）"]
[null,null,"　","人　　　（国保に加入する人のみ入力してください。）"]
[]
[null,null,"②何月から加入しますか？"]
[null,null,"　","月"]
[]
[null,null,"③世帯主は国保に加入しますか？"]
[null,null,"　"]
[]
[null,null,"④下の表に加入する人（している人）の収入・所得を入力してください。"]
[null,null,"※世帯主の年齢区分と収入・所得は、世帯主が国保に加入しない場合でも必ず入力してください。"]
[null,null,"年齢区分\n（※１）","前年中の給与収入","前年中の年金収入","その他の所得","失業軽減\n（※２）"]
[null,null,null,"（源泉徴収票の支払金額）","（源泉徴収票の支払金額）","（収入から必要経費を引いた金額）"]
[null,"世帯主"]
[null,"世帯員１"]
[null,"世帯員２"]
[null,"世帯員３"]
[null,"世帯員４"]
[null,"世帯員５"]
[null,"世帯員６"]
[null,null,"※１　加入される人の年齢区分は必ず入力してください。(１月１日時点の年齢)"]
[null,null,"※２　失業軽減は、雇用保険受給資格者証をお持ちの人で、離職理由の番号が１１・１２・２１・２２"]
[null,null,"・２３・３１・３２・３３・３４のいずれかに該当する場合に限り○を選択してください。"]
[null,null,"（加入される場合、失業軽減後の税額を適用するには、窓口で申請が必要です。）"]
[]
[]
[]
[null,"※計算するボタンを押すことができない場合は、「結果」シートを開くと試算結果の確認ができます。"]

{"sheet":"給与所得計算","index":1,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":true,"merged":[[2,3,4,3],[32,1,35,1],[2,1,5,1],[7,1,10,1],[12,1,15,1],[17,1,20,1],[22,1,25,1],[27,1,30,1],[7,3,9,3],[12,3,14,3],[17,3,19,3],[22,3,24,3],[27,3,29,3],[32,3,34,3]]}
[]
[]
[null,"世帯主","給与所得額の計算","課税所得\n（非自発計算含む）","調整控除額"]
[null,null,{"$f":"IF(入力用!D36<=550999,0,IF(入力用!D36<=1618999,入力用!D36-550000,IF(入力用!D36<=1619999,1069000,IF(入力用!D36<=1621999,1070000,IF(入力用!D36<=1623999,1072000,IF(入力用!D36<=1627999,1074000,IF(入力用!D36<=1799999,ROUNDDOWN(入力用!D36/4,-3)*2.4+100000,IF(入力用!D36<=3599999,ROUNDDOWN(入力用!D36/4,-3)*2.8-80000,IF(入力用!D36<=6599999,ROUNDDOWN(入力用!D36/4,-3)*3.2-440000,IF(入力用!D36<=8499999,入力用!D36*0.9-1100000,IF(8500000<=入力用!D36,入力用!D36-1950000,0)))))))))))","v":0},null,{"$f":"IF(AND(C6>=100000,年金所得計算!F6>=100000),100000,IF(AND(C6>=100000,年金所得計算!F6<1000000),年金所得計算!F6,IF(AND(C6<100000,年金所得計算!F6>=1000000),C6,IF(AND(C6<100000,年金所得計算!F6<1000000),C6,0))))","v":0}]
[null,null,"給与所得額",null,"調整控除後"]
[null,null,{"$f":"C4","v":0},{"$f":"IF(入力用!G36=\"○\",E6*0.3,E6)","v":0},{"$f":"IF(E4>0,C6-E4,C6)","v":0}]
[]
[null,"世帯員１","給与所得額の計算","課税所得\n（非自発計算含む）","調整控除額"]
[null,null,{"$f":"IF(入力用!D37<=550999,0,IF(入力用!D37<=1618999,入力用!D37-550000,IF(入力用!D37<=1619999,1069000,IF(入力用!D37<=1621999,1070000,IF(入力用!D37<=1623999,1072000,IF(入力用!D37<=1627999,1074000,IF(入力用!D37<=1799999,ROUNDDOWN(入力用!D37/4,-3)*2.4+100000,IF(入力用!D37<=3599999,ROUNDDOWN(入力用!D37/4,-3)*2.8-80000,IF(入力用!D37<=6599999,ROUNDDOWN(入力用!D37/4,-3)*3.2-440000,IF(入力用!D37<=8499999,入力用!D37*0.9-1100000,IF(8500000<=入力用!D37,入力用!D37-1950000,0)))))))))))","v":0},null,{"$f":"IF(AND(C11>=100000,年金所得計算!F12>=100000),100000,IF(AND(C11>=100000,年金所得計算!F12<1000000),年金所得計算!F12,IF(AND(C11<100000,年金所得計算!F12>=1000000),C11,IF(AND(C11<100000,年金所得計算!F12<1000000),C11,0))))","v":0}]
[null,null,"給与所得額",null,"調整控除後"]
[null,null,{"$f":"C9","v":0},{"$f":"IF(入力用!G37=\"○\",E11*0.3,E11)","v":0},{"$f":"IF(E9>0,C11-E9,C11)","v":0}]
[]
[null,"世帯員２","給与所得額の計算","課税所得\n（非自発計算含む）","調整控除額"]
[null,null,{"$f":"IF(入力用!D38<=550999,0,IF(入力用!D38<=1618999,入力用!D38-550000,IF(入力用!D38<=1619999,1069000,IF(入力用!D38<=1621999,1070000,IF(入力用!D38<=1623999,1072000,IF(入力用!D38<=1627999,1074000,IF(入力用!D38<=1799999,ROUNDDOWN(入力用!D38/4,-3)*2.4+100000,IF(入力用!D38<=3599999,ROUNDDOWN(入力用!D38/4,-3)*2.8-80000,IF(入力用!D38<=6599999,ROUNDDOWN(入力用!D38/4,-3)*3.2-440000,IF(入力用!D38<=8499999,入力用!D38*0.9-1100000,IF(8500000<=入力用!D38,入力用!D38-1950000,0)))))))))))","v":0},null,{"$f":"IF(AND(C16>=100000,年金所得計算!F18>=100000),100000,IF(AND(C16>=100000,年金所得計算!F18<1000000),年金所得計算!F18,IF(AND(C16<100000,年金所得計算!F18>=1000000),C16,IF(AND(C16<100000,年金所得計算!F18<1000000),C16,0))))","v":0}]
[null,null,"給与所得額",null,"調整控除後"]
[null,null,{"$f":"C14","v":0},{"$f":"IF(入力用!G38=\"○\",E16*0.3,E16)","v":0},{"$f":"IF(E14>0,C16-E14,C16)","v":0}]
[]
[null,"世帯員３","給与所得額の計算","課税所得\n（非自発計算含む）","調整控除額"]
[null,null,{"$f":"IF(入力用!D39<=550999,0,IF(入力用!D39<=1618999,入力用!D39-550000,IF(入力用!D39<=1619999,1069000,IF(入力用!D39<=1621999,1070000,IF(入力用!D39<=1623999,1072000,IF(入力用!D39<=1627999,1074000,IF(入力用!D39<=1799999,ROUNDDOWN(入力用!D39/4,-3)*2.4+100000,IF(入力用!D39<=3599999,ROUNDDOWN(入力用!D39/4,-3)*2.8-80000,IF(入力用!D39<=6599999,ROUNDDOWN(入力用!D39/4,-3)*3.2-440000,IF(入力用!D39<=8499999,入力用!D39*0.9-1100000,IF(8500000<=入力用!D39,入力用!D39-1950000,0)))))))))))","v":0},null,{"$f":"IF(AND(C21>=100000,年金所得計算!F24>=100000),100000,IF(AND(C21>=100000,年金所得計算!F24<1000000),年金所得計算!F24,IF(AND(C21<100000,年金所得計算!F24>=1000000),C21,IF(AND(C21<100000,年金所得計算!F24<1000000),C21,0))))","v":0}]
[null,null,"給与所得額",null,"調整控除後"]
[null,null,{"$f":"C19","v":0},{"$f":"IF(入力用!G39=\"○\",E21*0.3,E21)","v":0},{"$f":"IF(E19>0,C21-E19,C21)","v":0}]
[]
[null,"世帯員４","給与所得額の計算","課税所得\n（非自発計算含む）","調整控除額"]
[null,null,{"$f":"IF(入力用!D40<=550999,0,IF(入力用!D40<=1618999,入力用!D40-550000,IF(入力用!D40<=1619999,1069000,IF(入力用!D40<=1621999,1070000,IF(入力用!D40<=1623999,1072000,IF(入力用!D40<=1627999,1074000,IF(入力用!D40<=1799999,ROUNDDOWN(入力用!D40/4,-3)*2.4+100000,IF(入力用!D40<=3599999,ROUNDDOWN(入力用!D40/4,-3)*2.8-80000,IF(入力用!D40<=6599999,ROUNDDOWN(入力用!D40/4,-3)*3.2-440000,IF(入力用!D40<=8499999,入力用!D40*0.9-1100000,IF(8500000<=入力用!D40,入力用!D40-1950000,0)))))))))))","v":0},null,{"$f":"IF(AND(C26>=100000,年金所得計算!F30>=100000),100000,IF(AND(C26>=100000,年金所得計算!F30<1000000),年金所得計算!F30,IF(AND(C26<100000,年金所得計算!F30>=1000000),C26,IF(AND(C26<100000,年金所得計算!F30<1000000),C26,0))))","v":0}]
[null,null,"給与所得額",null,"調整控除後"]
[null,null,{"$f":"C24","v":0},{"$f":"IF(入力用!G40=\"○\",E26*0.3,E26)","v":0},{"$f":"IF(E24>0,C26-E24,C26)","v":0}]
[]
[null,"世帯員５","給与所得額の計算","課税所得\n（非自発計算含む）","調整控除額"]
[null,null,{"$f":"IF(入力用!D41<=550999,0,IF(入力用!D41<=1618999,入力用!D41-550000,IF(入力用!D41<=1619999,1069000,IF(入力用!D41<=1621999,1070000,IF(入力用!D41<=1623999,1072000,IF(入力用!D41<=1627999,1074000,IF(入力用!D41<=1799999,ROUNDDOWN(入力用!D41/4,-3)*2.4+100000,IF(入力用!D41<=3599999,ROUNDDOWN(入力用!D41/4,-3)*2.8-80000,IF(入力用!D41<=6599999,ROUNDDOWN(入力用!D41/4,-3)*3.2-440000,IF(入力用!D41<=8499999,入力用!D41*0.9-1100000,IF(8500000<=入力用!D41,入力用!D41-1950000,0)))))))))))","v":0},null,{"$f":"IF(AND(C31>=100000,年金所得計算!F36>=100000),100000,IF(AND(C31>=100000,年金所得計算!F36<1000000),年金所得計算!F36,IF(AND(C31<100000,年金所得計算!F36>=1000000),C31,IF(AND(C31<100000,年金所得計算!F36<1000000),C31,0))))","v":0}]
[null,null,"給与所得額",null,"調整控除後"]
[null,null,{"$f":"C29","v":0},{"$f":"IF(入力用!G41=\"○\",E31*0.3,E31)","v":0},{"$f":"IF(E29>0,C31-E29,C31)","v":0}]
[]
[null,"世帯員６","給与所得額の計算","課税所得\n（非自発計算含む）","調整控除額"]
[null,null,{"$f":"IF(入力用!D42<=550999,0,IF(入力用!D42<=1618999,入力用!D42-550000,IF(入力用!D42<=1619999,1069000,IF(入力用!D42<=1621999,1070000,IF(入力用!D42<=1623999,1072000,IF(入力用!D42<=1627999,1074000,IF(入力用!D42<=1799999,ROUNDDOWN(入力用!D42/4,-3)*2.4+100000,IF(入力用!D42<=3599999,ROUNDDOWN(入力用!D42/4,-3)*2.8-80000,IF(入力用!D42<=6599999,ROUNDDOWN(入力用!D42/4,-3)*3.2-440000,IF(入力用!D42<=8499999,入力用!D42*0.9-1100000,IF(8500000<=入力用!D42,入力用!D42-1950000,0)))))))))))","v":0},null,{"$f":"IF(AND(C36>=100000,年金所得計算!F42>=100000),100000,IF(AND(C36>=100000,年金所得計算!F42<1000000),年金所得計算!F42,IF(AND(C36<100000,年金所得計算!F42>=1000000),C36,IF(AND(C36<100000,年金所得計算!F42<1000000),C36,0))))","v":0}]
[null,null,"給与所得額",null,"調整控除後"]
[null,null,{"$f":"C34","v":0},{"$f":"IF(入力用!G42=\"○\",E36*0.3,E36)","v":0},{"$f":"IF(E34>0,C36-E34,C36)","v":0}]

{"sheet":"年金所得計算","index":2,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[4,5,4,6],[5,5,5,6],[4,7,4,8],[5,7,5,8],[2,1,5,1],[10,3,10,4],[10,5,10,6],[10,7,10,8],[7,3,7,4],[8,1,11,1],[8,3,8,4],[9,3,9,4],[11,3,11,4],[11,5,11,6],[11,7,11,8],[13,3,13,4],[14,1,17,1],[14,3,14,4],[15,3,15,4],[16,3,16,4],[20,1,23,1],[20,3,20,4],[21,3,21,4],[22,3,22,4],[22,5,22,6],[16,7,16,8],[17,3,17,4],[17,5,17,6],[17,7,17,8],[19,3,19,4],[16,5,16,6],[26,1,29,1],[26,3,26,4],[27,3,27,4],[28,3,28,4],[28,5,28,6],[22,7,22,8],[23,3,23,4],[23,5,23,6],[23,7,23,8],[25,3,25,4],[32,1,35,1],[32,3,32,4],[33,3,33,4],[34,3,34,4],[34,5,34,6],[28,7,28,8],[29,3,29,4],[29,5,29,6],[29,7,29,8],[31,3,31,4],[38,1,41,1],[38,3,38,4],[39,3,39,4],[40,3,40,4],[40,5,40,6],[40,7,40,8],[41,3,41,4],[41,5,41,6],[41,7,41,8],[34,7,34,8],[35,3,35,4],[35,5,35,6],[35,7,35,8],[37,3,37,4]]}
[]
[null,null,"６５歳未満","６５歳以上"]
[null,"世帯主","年金所得額の計算","年金所得額の計算"]
[null,null,{"$f":"IF(AND(入力用!C36=\"４０歳～６４歳\",入力用!E36<=600000),0,IF(AND(入力用!C36=\"４０歳～６４歳\",入力用!E36<=1299999),入力用!E36-600000,IF(AND(入力用!C36=\"４０歳～６４歳\",入力用!E36<=4099999),入力用!E36*0.75-275000,IF(AND(入力用!C36=\"４０歳～６４歳\",入力用!E36<=7699999),入力用!E36*0.85-685000,IF(AND(入力用!C36=\"４０歳～６４歳\",入力用!E36<=9999999),入力用!E36*0.95-1455000,IF(AND(入力用!C36=\"４０歳～６４歳\",10000000<=入力用!E36),入力用!E36-1955000,0))))))","v":0},{"$f":"IF(AND(入力用!C36=\"６５歳以上\",入力用!E36<=1100000),0,IF(AND(入力用!C36=\"６５歳以上\",入力用!E36<=3299999),入力用!E36-1100000,IF(AND(入力用!C36=\"６５歳以上\",入力用!E36<=4099999),入力用!E36*0.75-275000,IF(AND(入力用!C36=\"６５歳以上\",入力用!E36<=7699999),入力用!E36*0.85-685000,IF(AND(入力用!C36=\"６５歳以上\",入力用!E36<=9999999),入力用!E36*0.95-1455000,IF(AND(入力用!C36=\"６５歳以上\",10000000<=入力用!E36),入力用!E36-1955000,0))))))","v":0}]
[null,null,"年金所得額","年金所得額",null,"課税所得（所得割算定用）",null,"課税所得（軽減判定用）"]
[null,null,{"$f":"C4","v":0},{"$f":"D4","v":0},null,{"$f":"IF(入力用!C36=\"４０歳～６４歳\",C6,D6)","v":0},null,{"$f":"IF(AND(入力用!C36=\"６５歳以上\",D6>=150000),D6-150000,IF(AND(入力用!C36=\"６５歳以上\",D6<150000),D6-D6,C6))","v":0}]
[]
[null,null,"６５歳未満","６５歳以上"]
[null,"世帯員１","年金所得額の計算","年金所得額の計算"]
[null,null,{"$f":"IF(AND(入力用!C37=\"４０歳～６４歳\",入力用!E37<=600000),0,IF(AND(入力用!C37=\"４０歳～６４歳\",入力用!E37<=1299999),入力用!E37-600000,IF(AND(入力用!C37=\"４０歳～６４歳\",入力用!E37<=4099999),入力用!E37*0.75-275000,IF(AND(入力用!C37=\"４０歳～６４歳\",入力用!E37<=7699999),入力用!E37*0.85-685000,IF(AND(入力用!C37=\"４０歳～６４歳\",入力用!E37<=9999999),入力用!E37*0.95-1455000,IF(AND(入力用!C37=\"４０歳～６４歳\",10000000<=入力用!E37),入力用!E37-1955000,0))))))","v":0},{"$f":"IF(AND(入力用!C37=\"６５歳～７４歳\",入力用!E37<=1100000),0,IF(AND(入力用!C37=\"６５歳～７４歳\",入力用!E37<=3299999),入力用!E37-1100000,IF(AND(入力用!C37=\"６５歳～７４歳\",入力用!E37<=4099999),入力用!E37*0.75-275000,IF(AND(入力用!C37=\"６５歳～７４歳\",入力用!E37<=7699999),入力用!E37*0.85-685000,IF(AND(入力用!C37=\"６５歳～７４歳\",入力用!E37<=9999999),入力用!E37*0.95-1455000,IF(AND(入力用!C37=\"６５歳～７４歳\",10000000<=入力用!E37),入力用!E37-1955000,0))))))","v":0}]
[null,null,"年金所得額","年金所得額",null,"課税所得（所得割算定用）",null,"課税所得（軽減判定用）"]
[null,null,{"$f":"C10","v":0},{"$f":"D10","v":0},null,{"$f":"IF(入力用!C37=\"４０歳～６４歳\",C12,D12)","v":0},null,{"$f":"IF(AND(入力用!C37=\"６５歳～７４歳\",D12>=150000),D12-150000,IF(AND(入力用!C37=\"６５歳～７４歳\",D12<150000),D12-D12,C12))","v":0}]
[]
[null,null,"６５歳未満","６５歳以上"]
[null,"世帯員２","年金所得額の計算","年金所得額の計算"]
[null,null,{"$f":"IF(AND(入力用!C38=\"４０歳～６４歳\",入力用!E38<=600000),0,IF(AND(入力用!C38=\"４０歳～６４歳\",入力用!E38<=1299999),入力用!E38-600000,IF(AND(入力用!C38=\"４０歳～６４歳\",入力用!E38<=4099999),入力用!E38*0.75-275000,IF(AND(入力用!C38=\"４０歳～６４歳\",入力用!E38<=7699999),入力用!E38*0.85-685000,IF(AND(入力用!C38=\"４０歳～６４歳\",入力用!E38<=9999999),入力用!E38*0.95-1455000,IF(AND(入力用!C38=\"４０歳～６４歳\",10000000<=入力用!E38),入力用!E38-1955000,0))))))","v":0},{"$f":"IF(AND(入力用!C38=\"６５歳～７４歳\",入力用!E38<=1100000),0,IF(AND(入力用!C38=\"６５歳～７４歳\",入力用!E38<=3299999),入力用!E38-1100000,IF(AND(入力用!C38=\"６５歳～７４歳\",入力用!E38<=4099999),入力用!E38*0.75-275000,IF(AND(入力用!C38=\"６５歳～７４歳\",入力用!E38<=7699999),入力用!E38*0.85-685000,IF(AND(入力用!C38=\"６５歳～７４歳\",入力用!E38<=9999999),入力用!E38*0.95-1455000,IF(AND(入力用!C38=\"６５歳～７４歳\",10000000<=入力用!E38),入力用!E38-1955000,0))))))","v":0}]
[null,null,"年金所得額","年金所得額",null,"課税所得（所得割算定用）",null,"課税所得（軽減判定用）"]
[null,null,{"$f":"C16","v":0},{"$f":"D16","v":0},null,{"$f":"IF(入力用!C38=\"４０歳～６４歳\",C18,D18)","v":0},null,{"$f":"IF(AND(入力用!C38=\"６５歳～７４歳\",D18>=150000),D18-150000,IF(AND(入力用!C38=\"６５歳～７４歳\",D18<150000),D18-D18,C18))","v":0}]
[]
[null,null,"６５歳未満","６５歳以上"]
[null,"世帯員３","年金所得額の計算","年金所得額の計算"]
[null,null,{"$f":"IF(AND(入力用!C39=\"４０歳～６４歳\",入力用!E39<=600000),0,IF(AND(入力用!C39=\"４０歳～６４歳\",入力用!E39<=1299999),入力用!E39-600000,IF(AND(入力用!C39=\"４０歳～６４歳\",入力用!E39<=4099999),入力用!E39*0.75-275000,IF(AND(入力用!C39=\"４０歳～６４歳\",入力用!E39<=7699999),入力用!E39*0.85-685000,IF(AND(入力用!C39=\"４０歳～６４歳\",入力用!E39<=9999999),入力用!E39*0.95-1455000,IF(AND(入力用!C39=\"４０歳～６４歳\",10000000<=入力用!E39),入力用!E39-1955000,0))))))","v":0},{"$f":"IF(AND(入力用!C39=\"６５歳～７４歳\",入力用!E39<=1100000),0,IF(AND(入力用!C39=\"６５歳～７４歳\",入力用!E39<=3299999),入力用!E39-1100000,IF(AND(入力用!C39=\"６５歳～７４歳\",入力用!E39<=4099999),入力用!E39*0.75-275000,IF(AND(入力用!C39=\"６５歳～７４歳\",入力用!E39<=7699999),入力用!E39*0.85-685000,IF(AND(入力用!C39=\"６５歳～７４歳\",入力用!E39<=9999999),入力用!E39*0.95-1455000,IF(AND(入力用!C39=\"６５歳～７４歳\",10000000<=入力用!E39),入力用!E39-1955000,0))))))","v":0}]
[null,null,"年金所得額","年金所得額",null,"課税所得（所得割算定用）",null,"課税所得（軽減判定用）"]
[null,null,{"$f":"C22","v":0},{"$f":"D22","v":0},null,{"$f":"IF(入力用!C39=\"４０歳～６４歳\",C24,D24)","v":0},null,{"$f":"IF(AND(入力用!C39=\"６５歳～７４歳\",D24>=150000),D24-150000,IF(AND(入力用!C39=\"６５歳～７４歳\",D24<150000),D24-D24,C24))","v":0}]
[]
[null,null,"６５歳未満","６５歳以上"]
[null,"世帯員４","年金所得額の計算","年金所得額の計算"]
[null,null,{"$f":"IF(AND(入力用!C40=\"４０歳～６４歳\",入力用!E40<=600000),0,IF(AND(入力用!C40=\"４０歳～６４歳\",入力用!E40<=1299999),入力用!E40-600000,IF(AND(入力用!C40=\"４０歳～６４歳\",入力用!E40<=4099999),入力用!E40*0.75-275000,IF(AND(入力用!C40=\"４０歳～６４歳\",入力用!E40<=7699999),入力用!E40*0.85-685000,IF(AND(入力用!C40=\"４０歳～６４歳\",入力用!E40<=9999999),入力用!E40*0.95-1455000,IF(AND(入力用!C40=\"４０歳～６４歳\",10000000<=入力用!E40),入力用!E40-1955000,0))))))","v":0},{"$f":"IF(AND(入力用!C40=\"６５歳～７４歳\",入力用!E40<=1100000),0,IF(AND(入力用!C40=\"６５歳～７４歳\",入力用!E40<=3299999),入力用!E40-1100000,IF(AND(入力用!C40=\"６５歳～７４歳\",入力用!E40<=4099999),入力用!E40*0.75-275000,IF(AND(入力用!C40=\"６５歳～７４歳\",入力用!E40<=7699999),入力用!E40*0.85-685000,IF(AND(入力用!C40=\"６５歳～７４歳\",入力用!E40<=9999999),入力用!E40*0.95-1455000,IF(AND(入力用!C40=\"６５歳～７４歳\",10000000<=入力用!E40),入力用!E40-1955000,0))))))","v":0}]
[null,null,"年金所得額","年金所得額",null,"課税所得（所得割算定用）",null,"課税所得（軽減判定用）"]
[null,null,{"$f":"C28","v":0},{"$f":"D28","v":0},null,{"$f":"IF(入力用!C40=\"４０歳～６４歳\",C30,D30)","v":0},null,{"$f":"IF(AND(入力用!C40=\"６５歳～７４歳\",D30>=150000),D30-150000,IF(AND(入力用!C40=\"６５歳～７４歳\",D30<150000),D30-D30,C30))","v":0}]
[]
[null,null,"６５歳未満","６５歳以上"]
[null,"世帯員５","年金所得額の計算","年金所得額の計算"]
[null,null,{"$f":"IF(AND(入力用!C41=\"４０歳～６４歳\",入力用!E41<=600000),0,IF(AND(入力用!C41=\"４０歳～６４歳\",入力用!E41<=1299999),入力用!E41-600000,IF(AND(入力用!C41=\"４０歳～６４歳\",入力用!E41<=4099999),入力用!E41*0.75-275000,IF(AND(入力用!C41=\"４０歳～６４歳\",入力用!E41<=7699999),入力用!E41*0.85-685000,IF(AND(入力用!C41=\"４０歳～６４歳\",入力用!E41<=9999999),入力用!E41*0.95-1455000,IF(AND(入力用!C41=\"４０歳～６４歳\",10000000<=入力用!E41),入力用!E41-1955000,0))))))","v":0},{"$f":"IF(AND(入力用!C41=\"６５歳～７４歳\",入力用!E41<=1100000),0,IF(AND(入力用!C41=\"６５歳～７４歳\",入力用!E41<=3299999),入力用!E41-1100000,IF(AND(入力用!C41=\"６５歳～７４歳\",入力用!E41<=4099999),入力用!E41*0.75-275000,IF(AND(入力用!C41=\"６５歳～７４歳\",入力用!E41<=7699999),入力用!E41*0.85-685000,IF(AND(入力用!C41=\"６５歳～７４歳\",入力用!E41<=9999999),入力用!E41*0.95-1455000,IF(AND(入力用!C41=\"６５歳～７４歳\",10000000<=入力用!E41),入力用!E41-1955000,0))))))","v":0}]
[null,null,"年金所得額","年金所得額",null,"課税所得（所得割算定用）",null,"課税所得（軽減判定用）"]
[null,null,{"$f":"C34","v":0},{"$f":"D34","v":0},null,{"$f":"IF(入力用!C41=\"４０歳～６４歳\",C36,D36)","v":0},null,{"$f":"IF(AND(入力用!C41=\"６５歳～７４歳\",D36>=150000),D36-150000,IF(AND(入力用!C41=\"６５歳～７４歳\",D36<150000),D36-D36,C36))","v":0}]
[]
[null,null,"６５歳未満","６５歳以上"]
[null,"世帯員６","年金所得額の計算","年金所得額の計算"]
[null,null,{"$f":"IF(AND(入力用!C42=\"４０歳～６４歳\",入力用!E42<=600000),0,IF(AND(入力用!C42=\"４０歳～６４歳\",入力用!E42<=1299999),入力用!E42-600000,IF(AND(入力用!C42=\"４０歳～６４歳\",入力用!E42<=4099999),入力用!E42*0.75-275000,IF(AND(入力用!C42=\"４０歳～６４歳\",入力用!E42<=7699999),入力用!E42*0.85-685000,IF(AND(入力用!C42=\"４０歳～６４歳\",入力用!E42<=9999999),入力用!E42*0.95-1455000,IF(AND(入力用!C42=\"４０歳～６４歳\",10000000<=入力用!E42),入力用!E42-1955000,0))))))","v":0},{"$f":"IF(AND(入力用!C42=\"６５歳～７４歳\",入力用!E42<=1100000),0,IF(AND(入力用!C42=\"６５歳～７４歳\",入力用!E42<=3299999),入力用!E42-1100000,IF(AND(入力用!C42=\"６５歳～７４歳\",入力用!E42<=4099999),入力用!E42*0.75-275000,IF(AND(入力用!C42=\"６５歳～７４歳\",入力用!E42<=7699999),入力用!E42*0.85-685000,IF(AND(入力用!C42=\"６５歳～７４歳\",入力用!E42<=9999999),入力用!E42*0.95-1455000,IF(AND(入力用!C42=\"６５歳～７４歳\",10000000<=入力用!E42),入力用!E42-1955000,0))))))","v":0}]
[null,null,"年金所得額","年金所得額",null,"課税所得（所得割算定用）",null,"課税所得（軽減判定用）"]
[null,null,{"$f":"C40","v":0},{"$f":"D40","v":0},null,{"$f":"IF(入力用!C42=\"４０歳～６４歳\",C42,D42)","v":0},null,{"$f":"IF(AND(入力用!C42=\"６５歳～７４歳\",D42>=150000),D42-150000,IF(AND(入力用!C42=\"６５歳～７４歳\",D42<150000),D42-D42,C42))","v":0}]

{"sheet":"税額計算","index":3,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":true,"merged":[[2,11,2,13],[32,7,34,10],[22,1,22,3],[27,1,27,3],[4,1,10,1],[11,1,11,2],[3,1,3,2],[13,1,19,1],[27,4,27,6],[30,1,31,3],[33,1,33,3],[24,1,24,3],[28,1,28,3],[32,1,32,3],[34,4,34,6],[34,1,34,3],[25,1,25,3]]}
[]
[null,"加入月数",{"$f":"IF(入力用!C27=4,12,IF(入力用!C27=5,11,IF(入力用!C27=6,10,IF(入力用!C27=7,9,IF(入力用!C27=8,8,IF(入力用!C27=9,7,IF(入力用!C27=10,6,IF(入力用!C27=11,5,IF(入力用!C27=12,4,IF(入力用!C27=1,3,IF(入力用!C27=2,2,IF(入力用!C27=3,1))))))))))))","v":false},"か月"]
[null,null,null,null,null,null,null,null,null,null,null,"１２か月"]
[null,null,null,"課税所得（基礎控除後）","医療分","後期分","介護分","軽減判定用所得","人数",null,null,"医療分","後期分","介護分"]
[null,"所得割","世帯主",{"$f":"IF(入力用!C30=\"いいえ\",0,IF(給与所得計算!D6+年金所得計算!F6+入力用!F36<=430000,0,IF(430000<給与所得計算!D6+年金所得計算!F6+入力用!F36,給与所得計算!D6+年金所得計算!F6+入力用!F36-430000)))","v":0},{"$f":"ROUNDDOWN(D5*0.09*$C$2/12,0)","v":0},{"$f":"ROUNDDOWN(D5*0.033*$C$2/12,0)","v":0},{"$f":"IF(入力用!C36=\"４０歳～６４歳\",ROUNDDOWN(D5*0.023*$C$2/12,0),0)","v":0},{"$f":"給与所得計算!D6+年金所得計算!H6+入力用!F36","v":0},{"$f":"IF(給与所得計算!D6+年金所得計算!H6>0,1,0)","v":0},null,null,{"$f":"ROUNDDOWN(D5*0.09,0)","v":0},{"$f":"ROUNDDOWN(D5*0.033,0)","v":0},{"$f":"IF(入力用!C36=\"４０歳～６４歳\",ROUNDDOWN(D5*0.023,0),0)","v":0}]
[null,null,"世帯員１",{"$f":"IF(給与所得計算!D11+年金所得計算!F12+入力用!F37<=430000,0,IF(430000<給与所得計算!D11+年金所得計算!F12+入力用!F37,給与所得計算!D11+年金所得計算!F12+入力用!F37-430000))","v":0},{"$f":"ROUNDDOWN(D6*0.09*$C$2/12,0)","v":0},{"$f":"ROUNDDOWN(D6*0.033*$C$2/12,0)","v":0},{"$f":"IF(入力用!C37=\"４０歳～６４歳\",D6*0.023,0)","v":0},{"$f":"給与所得計算!D11+年金所得計算!H12+入力用!F37","v":0},{"$f":"IF(給与所得計算!D11+年金所得計算!H12>0,1,0)","v":0},null,null,{"$f":"ROUNDDOWN(D6*0.09,0)","v":0},{"$f":"ROUNDDOWN(D6*0.033,0)","v":0},{"$f":"IF(入力用!C37=\"４０歳～６４歳\",ROUNDDOWN(D6*0.023,0),0)","v":0}]
[null,null,"世帯員２",{"$f":"IF(給与所得計算!D16+年金所得計算!F18+入力用!F38<=430000,0,IF(430000<給与所得計算!D16+年金所得計算!F18+入力用!F38,給与所得計算!D16+年金所得計算!F18+入力用!F38-430000))","v":0},0,0,{"$f":"IF(入力用!C38=\"４０歳～６４歳\",D7*0.023,0)","v":0},{"$f":"給与所得計算!D16+年金所得計算!H18+入力用!F38","v":0},{"$f":"IF(給与所得計算!D16+年金所得計算!H18>0,1,0)","v":0},null,null,{"$f":"ROUNDDOWN(D7*0.09,0)","v":0},0,{"$f":"IF(入力用!C38=\"４０歳～６４歳\",ROUNDDOWN(D7*0.023,0),0)","v":0}]
[null,null,"世帯員３",{"$f":"IF(給与所得計算!D21+年金所得計算!F24+入力用!F39<=430000,0,IF(430000<給与所得計算!D21+年金所得計算!F24+入力用!F39,給与所得計算!D21+年金所得計算!F24+入力用!F39-430000))","v":0},0,0,{"$f":"IF(入力用!C39=\"４０歳～６４歳\",D8*0.023,0)","v":0},{"$f":"給与所得計算!D21+年金所得計算!H24+入力用!F39","v":0},{"$f":"IF(給与所得計算!D21+年金所得計算!H24>0,1,0)","v":0},null,null,0,0,{"$f":"IF(入力用!C39=\"４０歳～６４歳\",ROUNDDOWN(D8*0.023,0),0)","v":0}]
[null,null,"世帯員４",{"$f":"IF(給与所得計算!D26+年金所得計算!F30+入力用!F40<=430000,0,IF(430000<給与所得計算!D26+年金所得計算!F30+入力用!F40,給与所得計算!D26+年金所得計算!F30+入力用!F40-430000))","v":0},0,0,{"$f":"IF(入力用!C40=\"４０歳～６４歳\",D9*0.023,0)","v":0},{"$f":"給与所得計算!D26+年金所得計算!H30+入力用!F40","v":0},{"$f":"IF(給与所得計算!D26+年金所得計算!H30>0,1,0)","v":0},null,null,0,0,{"$f":"IF(入力用!C40=\"４０歳～６４歳\",ROUNDDOWN(D9*0.023,0),0)","v":0}]
[null,null,"世帯員５",{"$f":"IF(給与所得計算!D31+年金所得計算!F36+入力用!F41<=430000,0,IF(430000<給与所得計算!D31+年金所得計算!F36+入力用!F41,給与所得計算!D31+年金所得計算!F36+入力用!F41-430000))","v":0},0,0,{"$f":"IF(入力用!C41=\"４０歳～６４歳\",D10*0.023,0)","v":0},{"$f":"給与所得計算!D31+年金所得計算!H36+入力用!F41","v":0},{"$f":"IF(給与所得計算!D31+年金所得計算!H36>0,1,0)","v":0},null,null,0,0,{"$f":"IF(入力用!C41=\"４０歳～６４歳\",ROUNDDOWN(D10*0.023,0),0)","v":0}]
[null,null,"世帯員６",{"$f":"IF(給与所得計算!D36+年金所得計算!F42+入力用!F42<=430000,0,IF(430000<給与所得計算!D36+年金所得計算!F42+入力用!F42,給与所得計算!D36+年金所得計算!F42+入力用!F42-430000))","v":0},0,0,{"$f":"IF(入力用!C42=\"４０歳～６４歳\",D11*0.023,0)","v":0},{"$f":"給与所得計算!D36+年金所得計算!H42+入力用!F42","v":0},{"$f":"IF(給与所得計算!D36+年金所得計算!H42>0,1,0)","v":0},null,null,{"$f":"ROUNDDOWN(D11*0.09,0)","v":0},0,{"$f":"IF(入力用!C42=\"４０歳～６４歳\",ROUNDDOWN(D11*0.023,0),0)","v":0}]
[null,"合計",null,{"$f":"SUM(D5:D11)","v":0},0,0,0,{"$f":"SUM(H5:H11)","v":0},0,null,"合計",{"$f":"SUM(L5:L11)","v":0},{"$f":"SUM(M5:M11)","v":0},{"$f":"SUM(N5:N11)","v":0}]
[]
[null,"均等割","世帯主",{"$f":"IF(入力用!C30=\"いいえ\",0,IF(入力用!C36=\"未就学児\",0.5,IF(入力用!C36=\"\",0,1)))","v":0},{"$f":"ROUNDDOWN(26000*D14*$C$2/12,0)","v":0},{"$f":"ROUNDDOWN(7500*D14*$C$2/12,0)","v":0},{"$f":"IF(入力用!C36=\"４０歳～６４歳\",ROUNDDOWN(8900*D14*$C$2/12,0),0)","v":0},null,null,null,null,{"$f":"ROUNDDOWN(26000*D14,0)","v":0},{"$f":"ROUNDDOWN(7500*D14,0)","v":0},{"$f":"IF(入力用!C36=\"４０歳～６４歳\",ROUNDDOWN(8900*D14,0),0)","v":0}]
[null,null,"世帯員１",{"$f":"IF(入力用!C37=\"未就学児\",0.5,IF(入力用!C37=\"\",0,1))","v":0},{"$f":"ROUNDDOWN(26000*D15*$C$2/12,0)","v":0},{"$f":"ROUNDDOWN(7500*D15*$C$2/12,0)","v":0},{"$f":"IF(入力用!C37=\"４０歳～６４歳\",ROUNDDOWN(8900*D15*$C$2/12,0),0)","v":0},null,null,null,null,{"$f":"ROUNDDOWN(26000*D15,0)","v":0},{"$f":"ROUNDDOWN(7500*D15,0)","v":0},{"$f":"IF(入力用!C37=\"４０歳～６４歳\",ROUNDDOWN(8900*D15,0),0)","v":0}]
[null,null,"世帯員２",{"$f":"IF(入力用!C38=\"未就学児\",0.5,IF(入力用!C38=\"\",0,1))","v":0},0,0,{"$f":"IF(入力用!C38=\"４０歳～６４歳\",ROUNDDOWN(8900*D16*$C$2/12,0),0)","v":0},null,null,null,null,0,0,{"$f":"IF(入力用!C38=\"４０歳～６４歳\",ROUNDDOWN(8900*D16,0),0)","v":0}]
[null,null,"世帯員３",{"$f":"IF(入力用!C39=\"未就学児\",0.5,IF(入力用!C39=\"\",0,1))","v":0},0,0,{"$f":"IF(入力用!C39=\"４０歳～６４歳\",ROUNDDOWN(8900*D17*$C$2/12,0),0)","v":0},null,null,null,null,0,0,{"$f":"IF(入力用!C39=\"４０歳～６４歳\",ROUNDDOWN(8900*D17,0),0)","v":0}]
[null,null,"世帯員４",{"$f":"IF(入力用!C40=\"未就学児\",0.5,IF(入力用!C40=\"\",0,1))","v":0},0,0,{"$f":"IF(入力用!C40=\"４０歳～６４歳\",ROUNDDOWN(8900*D18*$C$2/12,0),0)","v":0},null,null,null,null,0,0,{"$f":"IF(入力用!C40=\"４０歳～６４歳\",ROUNDDOWN(8900*D18,0),0)","v":0}]
[null,null,"世帯員５",{"$f":"IF(入力用!C41=\"未就学児\",0.5,IF(入力用!C41=\"\",0,1))","v":0},0,0,{"$f":"IF(入力用!C41=\"４０歳～６４歳\",ROUNDDOWN(8900*D19*$C$2/12,0),0)","v":0},null,null,null,null,0,0,{"$f":"IF(入力用!C41=\"４０歳～６４歳\",ROUNDDOWN(8900*D19,0),0)","v":0}]
[null,null,"世帯員６",{"$f":"IF(入力用!C42=\"未就学児\",0.5,IF(入力用!C42=\"\",0,1))","v":0},{"$f":"ROUNDDOWN(26000*D20*$C$2/12,0)","v":0},{"$f":"ROUNDDOWN(7500*D20*$C$2/12,0)","v":0},{"$f":"IF(入力用!C42=\"４０歳～６４歳\",ROUNDDOWN(8900*D20*$C$2/12,0),0)","v":0},null,null,null,null,0,0,{"$f":"IF(入力用!C42=\"４０歳～６４歳\",ROUNDDOWN(8900*D20,0),0)","v":0}]
[null,null,null,"合計",{"$f":"SUM(E14:E20)","v":0},{"$f":"SUM(F14:F20)","v":0},{"$f":"SUM(G14:G20)","v":0},null,null,null,"合計",{"$f":"SUM(L14:L20)","v":0},{"$f":"SUM(M14:M20)","v":0},{"$f":"SUM(N14:N20)","v":0}]
[null,null,null,null,null,null,null,"世帯割介護分判定"]
[null,"世帯割",null,null,{"$f":"ROUNDDOWN(23200*$C$2/12,0)","v":0},{"$f":"ROUNDDOWN(7300*$C$2/12,0)","v":0},{"$f":"IF(H23=\"○\",ROUNDDOWN(5700*$C$2/12,0),0)","v":0},{"$f":"IF(AND(入力用!C30=\"はい\",OR(入力用!C36=\"４０歳～６４歳\",入力用!C37=\"４０歳～６４歳\",入力用!C38=\"４０歳～６４歳\",入力用!C39=\"４０歳～６４歳\",入力用!C40=\"４０歳～６４歳\",入力用!C41=\"４０歳～６４歳\",入力用!C42=\"４０歳～６４歳\")),\"○\",IF(AND(入力用!C30=\"いいえ\",OR(入力用!C37=\"４０歳～６４歳\",入力用!C38=\"４０歳～６４歳\",入力用!C39=\"４０歳～６４歳\",入力用!C40=\"４０歳～６４歳\",入力用!C41=\"４０歳～６４歳\",入力用!C42=\"４０歳～６４歳\")),\"○\",\"×\"))","v":"×"},null,null,"均等割",23200,7300,{"$f":"IF(H23=\"○\",5700,0)","v":0}]
[]
[null,"軽減前合計",null,null,{"$f":"E12+E21+E23","v":0},{"$f":"F12+F21+F23","v":0},{"$f":"G12+G21+G23","v":0}]
[null,"限度超過額",null,null,{"$f":"IF(E25>=650000,E25-650000,0)","v":0},{"$f":"IF(F25>=220000,F25-220000,0)","v":0},{"$f":"IF(G25>=170000,G25-170000,0)","v":0}]
[]
[null,"軽減割合",null,null,{"$f":"IF(OR(H12<=430000,H12<=430000+(I12-1)*100000),\"７割軽減\",IF(H12<=430000+(I12-1)*100000+(290000*入力用!C24),\"５割軽減\",IF(H12<=430000+(I12-1)*100000+(535000*入力用!C24),\"２割軽減\",\"軽減なし\")))","v":"７割軽減"}]
[null,"軽減額",null,null,{"$f":"IF(E28=\"７割軽減\",((E21+E23)*0.7)*C2/12,IF(E28=\"５割軽減\",((E21+E23)*0.5)*C2/12,IF(E28=\"２割軽減\",((E21+E23)*0.2)*C2/12,0)))","v":0},{"$f":"IF(E28=\"７割軽減\",((F21+F23)*0.7)*C2/12,IF(E28=\"５割軽減\",((F21+F23)*0.5)*C2/12,IF(E28=\"２割軽減\",((F21+F23)*0.2)*C2/12,0)))","v":0},{"$f":"IF(E28=\"７割軽減\",((G21+G23)*0.7)*C2/12,IF(E28=\"５割軽減\",((G21+G23)*0.5)*C2/12,IF(E28=\"２割軽減\",((G21+G23)*0.2)*C2/12,0)))","v":0},null,null,null,null,{"$f":"IF(E28=\"７割軽減\",(L21+L23)*0.7,IF(E28=\"５割軽減\",(L21+L23)*0.5,IF(E28=\"２割軽減\",(L21+L23)*0.2,0)))","v":16239.999999999998},{"$f":"IF(E28=\"７割軽減\",(M21+M23)*0.7,IF(E28=\"５割軽減\",(M21+M23)*0.5,IF(E28=\"２割軽減\",(M21+M23)*0.2,0)))","v":5110},{"$f":"IF(E28=\"７割軽減\",(N21+N23)*0.7,IF(E28=\"５割軽減\",(N21+N23)*0.5,IF(E28=\"２割軽減\",(N21+N23)*0.2,0)))","v":0}]
[]
[null,"算出税額（１２か月）",null,null,"医療分","後期分","介護分"]
[null,null,null,null,{"$f":"L12+L21+L23-L29-E26","v":6960.0000000000018},{"$f":"M12+M21+M23-M29-F26","v":2190},{"$f":"N12+N21+N23-N29-G26","v":0}]
[null,"算出税額（月割増減調整後）",null,null,{"$f":"E32-E32*(12-C2)/12","v":0},{"$f":"F32-F32*(12-C2)/12","v":0},{"$f":"G32-G32*(12-C2)/12","v":0},"※１２か月未満で計算するときは、システム同様最後に月割増減で調整するよう計算式を入れているため、軽減前合計から軽減額を引いた金額と一致しないことがあります。"]
[null,"算出税額（100円未満切捨）",null,null,{"$f":"ROUNDDOWN(E33,-2)","v":0},{"$f":"ROUNDDOWN(F33,-2)","v":0},{"$f":"ROUNDDOWN(G33,-2)","v":0}]
[null,"合　　計",null,null,{"$f":"E34+F34+G34","v":0}]

{"sheet":"結果","index":4,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[29,1,29,2],[29,3,30,3],[29,4,30,4],[29,5,30,6],[19,3,20,3],[26,3,27,3],[26,4,27,4],[26,5,27,6],[19,4,20,4],[19,5,20,6],[31,1,31,2],[32,1,32,2],[17,5,17,6],[18,5,18,6],[21,5,21,6],[22,5,22,6],[21,1,24,1],[25,5,25,6],[23,3,24,3],[23,4,24,4],[23,5,24,6],[28,5,28,6],[28,1,28,2],[17,1,20,1],[25,1,27,1],[30,1,30,2],[1,8,1,9],[15,1,15,3],[16,1,16,3],[14,1,14,2],[6,3,7,6],[16,5,16,6],[16,7,16,8],[7,7,8,7],[8,5,8,6],[15,5,15,6],[15,7,15,8],[8,3,8,4],[17,7,17,8],[23,7,24,8],[33,5,33,8],[25,7,25,8],[31,7,31,8],[32,7,32,8],[31,5,31,6],[32,5,32,6],[28,7,28,8],[18,7,18,8],[21,7,21,8],[22,7,22,8],[19,7,20,8],[29,7,30,8],[26,7,27,8],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[45,1,45,2],[46,1,46,2],[47,1,47,2],[44,1,44,2],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[54,0,54,9],[51,1,51,2],[48,1,48,2],[49,1,49,2],[50,1,50,2]]}
[]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-05-29"}]
[null,"計算の結果、"]
[]
[]
[null,null,null,"あなたの（世帯の）国民健康保険税は、"]
[null,null,null,{"$f":"税額計算!E35","v":0}]
[null,null,null,null,null,null,null,"円です。"]
[null,null,null,"（1か月あたり約）",null,{"$f":"ROUNDDOWN(D7/税額計算!C2,0)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,{"$f":"入力用!C27","v":"　"},"月から加入された場合、お支払いの開始は",null,null,null,{"$f":"IF(OR(B12=1,B12=2,B12=6,B12=7,B12=8,B12=9,B12=10,B12=11,),B12+1,IF(OR(B12=4,B12=5),6,IF(B12=12,1,3)))","v":3},"月からとなります。"]
[null,{"$f":"G12","v":3},{"$f":"IF(B13=3,\"月に１回で加入月数分を納付していただきます。\",\"月から３月までの各月で均等に割った金額を毎月納付していただきます。\")","v":"月に１回で加入月数分を納付していただきます。"}]
[]
[null,"計算結果の内訳 "]
[null,"区分",null,null,"医療分","後期支援分",null,"介護分"]
[null,"計算対象年齢",null,null,"０歳～７４歳","０歳～７４歳",null,"４０歳～６４歳のみ"]
[null,"所得割","課税所得額","①",{"$f":"税額計算!$D$12","v":0},{"$f":"税額計算!$D$12","v":0},null,{"$f":"税額計算!$D$12","v":0}]
[null,null,"税率","②",0.09,3.3000000000000002E-2,null,2.3E-2]
[null,null,"算出額","③",{"$f":"税額計算!E12","v":0},{"$f":"税額計算!F12","v":0},null,{"$f":"税額計算!G12","v":0}]
[null,null,"①×②×加入月数/12"]
[null,"均等割","均等割額（一人あたり）","④",26000,7500,null,8900]
[null,null,"人数","⑤",{"$f":"入力用!$C$24","v":"　"},{"$f":"入力用!$C$24","v":"　"},null,{"$f":"IF(税額計算!H23=\"×\",0,入力用!C24)","v":0}]
[null,null,"算出額","⑥",{"$f":"税額計算!E21","v":0},{"$f":"税額計算!F21","v":0},null,{"$f":"税額計算!G21","v":0}]
[null,null,"④×⑤×加入月数/12"]
[null,"世帯割","世帯割","⑦",23200,7300,null,{"$f":"IF(税額計算!H23=\"×\",0,5700)","v":0}]
[null,null,"算出額","⑧",{"$f":"税額計算!E23","v":0},{"$f":"税額計算!F23","v":0},null,{"$f":"税額計算!G23","v":0}]
[null,null,"⑦×加入月数/12"]
[null,"軽減額",null,"⑨",{"$f":"税額計算!E29","v":0},{"$f":"税額計算!F29","v":0},null,{"$f":"税額計算!G29","v":0}]
[null,"算出額計",null,"⑩",{"$f":"税額計算!E33","v":0},{"$f":"税額計算!F33","v":0},null,{"$f":"税額計算!G33","v":0}]
[null,"③＋⑥＋⑧－⑨"]
[null,"課税限度額",null,"⑪",650000,220000,null,170000]
[null,"計算結果",null,"⑫",{"$f":"税額計算!E34","v":0},{"$f":"税額計算!F34","v":0},null,{"$f":"税額計算!G34","v":0}]
[null,null,null,null,"合計",{"$f":"税額計算!E35","v":0}]
[]
[]
[null,null,"荒尾市国民健康保険税は、第１期（６月）～第１０期（翌３月）までの"]
[null,null,"納期で年税額を納付することになっています。（４・５月はお支払いはありません。）"]
[]
[null,"加入月（届出月）",null,"納付書発送時期",null,"納付回数"]
[null,"４月",null,"６月中旬",null,"１０回"]
[null,"５月",null,"６月中旬",null,"１０回"]
[null,"６月",null,"７月１０日頃",null,"９回"]
[null,"７月",null,"８月１０日頃",null,"８回"]
[null,"８月",null,"９月１０日頃",null,"７回"]
[null,"９月",null,"１０月１０日頃",null,"６回"]
[null,"１０月",null,"１１月１０日頃",null,"５回"]
[null,"１１月",null,"１２月１０日頃",null,"４回"]
[null,"１２月",null,"１月１０日頃",null,"３回"]
[null,"１月",null,"２月１０日頃",null,"２回"]
[null,"２月",null,"３月１０日頃",null,"１回"]
[null,"３月",null,"加入時手渡し、もしくは随時郵送",null,"１回"]
[]
[]
["計算の結果について、御不明な点があればお問い合わせください。　荒尾市役所　税務課　市民税係　(0968)-63-1342（直通）"]