{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["計算","DAT"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":216,"n_cols":20,"rows_kept":216,"cut":false,"hidden":false,"merged":[[215,1,217,20],[57,2,57,19],[53,2,53,19],[11,2,11,18],[15,2,15,17],[33,2,33,18],[17,5,17,8]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"試算日："]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-03-11"}]
[]
[]
[]
[]
[null,null,null,null,null,null,"世帯主\n（被保険者）",null,null,"被保険者Ａ",null,null,"被保険者Ｂ",null,null,"被保険者Ｃ",null,null,"被保険者Ｄ"]
[]
[null,null,{"$f":"TODAY()","v":"2020-03-11"},null,"基準日"]
[null,null,"世帯主および被保険者の年齢を入力してください。（令和2年1月1日時点）"]
[]
[null,null,"年齢",null,null,null,null,"歳",null,null,"歳",null,null,"歳",null,null,"歳",null,null,"歳"]
[]
[null,null,"世帯主は被保険者ですか。「はい」 「いいえ」 を選択してください。"]
[null,null,null,null,"年齢",null,{"$f":"IF(G14>=63,G14,\"\")","v":""},null,null,{"$f":"IF(J14>=63,J14,\"\")","v":""},null,null,{"$f":"IF(M14>=63,M14,\"\")","v":""},null,null,{"$f":"IF(P14>=63,P14,\"\")","v":""},null,null,{"$f":"IF(S14>=63,S14,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"被保険者判定",null,{"$f":"G69","v":0},null,null,{"$f":"J69","v":0},null,null,{"$f":"M69","v":0},null,null,{"$f":"P69","v":0},null,null,{"$f":"S69","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,null,"円"]
[]
[]
[]
[]
[]
[null,null,"保険料",null,{"$f":"G136","v":""},null,{"$f":"G142","v":""},null,null,{"$f":"J142","v":""},null,null,{"$f":"M142","v":""},null,null,{"$f":"P142","v":""},null,null,{"$f":"S142","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"和歌山県で75歳になられる日、または転入される日を入力してください。以前から和歌山県の被保険者である場合は 2020/4/1 を入力してください。"]
[]
[null,null,"資格取得日\n（加入日）"]
[]
[null,null,"被扶養者軽減に該当する方は軽減開始日(はじめて制度に加入された日)を入力してください。該当しない方は空欄のままにしてください。"]
[]
[null,null,"被扶養者軽減の場合\n軽減開始日"]
[]
[]
[null,null,null,null,"資格取得日",null,{"$f":"IF(OR(G56=\"\",G56<DAT!$C$10),DAT!$C$10,G56)","v":"2020-04-01"},null,null,{"$f":"IF(OR(J56=\"\",J56<DAT!$C$10),DAT!$C$10,J56)","v":"2020-04-01"},null,null,{"$f":"IF(OR(M56=\"\",M56<DAT!$C$10),DAT!$C$10,M56)","v":"2020-04-01"},null,null,{"$f":"IF(OR(P56=\"\",P56<DAT!$C$10),DAT!$C$10,P56)","v":"2020-04-01"},null,null,{"$f":"IF(OR(S56=\"\",S56<DAT!$C$10),DAT!$C$10,S56)","v":"2020-04-01"}]
[null,null,null,null,"●資格取得日の月初",null,{"$f":"DATE(YEAR(G63),MONTH(G63),1)","v":"2020-04-01"},null,null,{"$f":"DATE(YEAR(J63),MONTH(J63),1)","v":"2020-04-01"},null,null,{"$f":"DATE(YEAR(M63),MONTH(M63),1)","v":"2020-04-01"},null,null,{"$f":"DATE(YEAR(P63),MONTH(P63),1)","v":"2020-04-01"},null,null,{"$f":"DATE(YEAR(S63),MONTH(S63),1)","v":"2020-04-01"}]
[null,null,null,null,"資格取得日過去",null,{"$f":"(YEAR(G64)-YEAR(DAT!$C$10))*12+(MONTH(G64)-MONTH(DAT!$C$10))","v":0},null,null,{"$f":"(YEAR(J64)-YEAR(DAT!$C$10))*12+(MONTH(J64)-MONTH(DAT!$C$10))","v":0},null,null,{"$f":"(YEAR(M64)-YEAR(DAT!$C$10))*12+(MONTH(M64)-MONTH(DAT!$C$10))","v":0},null,null,{"$f":"(YEAR(P64)-YEAR(DAT!$C$10))*12+(MONTH(P64)-MONTH(DAT!$C$10))","v":0},null,null,{"$f":"(YEAR(S64)-YEAR(DAT!$C$10))*12+(MONTH(S64)-MONTH(DAT!$C$10))","v":0}]
[null,null,null,null,"被保険者ではない月",null,{"$f":"IF(G65<0,0,G65)","v":0},null,null,{"$f":"IF(J65<0,0,J65)","v":0},null,null,{"$f":"IF(M65<0,0,M65)","v":0},null,null,{"$f":"IF(P65<0,0,P65)","v":0},null,null,{"$f":"IF(S65<0,0,S65)","v":0}]
[null,null,null,null,"賦課月",null,{"$f":"IF(12-G66<0,0,12-G66)","v":12},null,null,{"$f":"IF(12-J66<0,0,12-J66)","v":12},null,null,{"$f":"IF(12-M66<0,0,12-M66)","v":12},null,null,{"$f":"IF(12-P66<0,0,12-P66)","v":12},null,null,{"$f":"IF(12-S66<0,0,12-S66)","v":12}]
[null,null,null,null,"ラジオ戻り値",null,1]
[null,null,null,null,"被保険者判定",null,{"$f":"IF(AND(G68=1,G17<>\"\"),1,0)","v":0},null,null,{"$f":"IF(J17<>\"\",1,0)","v":0},null,null,{"$f":"IF(M17<>\"\",1,0)","v":0},null,null,{"$f":"IF(P17<>\"\",1,0)","v":0},null,null,{"$f":"IF(S17<>\"\",1,0)","v":0}]
[null,null,null,null,"賦課月数",null,{"$f":"IF(G69=1,G67,\"\")","v":""},null,null,{"$f":"IF(J69=1,J67,\"\")","v":""},null,null,{"$f":"IF(M69=1,M67,\"\")","v":""},null,null,{"$f":"IF(P69=1,P67,\"\")","v":""},null,null,{"$f":"IF(S69=1,S67,\"\")","v":""}]
[null,null,null,null,"軽減開始日",null,{"$f":"IF(G60=\"\",DAT!$E$10,G60)","v":"2036-02-09"},null,null,{"$f":"IF(J60=\"\",DAT!$E$10,J60)","v":"2036-02-09"},null,null,{"$f":"IF(M60=\"\",DAT!$E$10,M60)","v":"2036-02-09"},null,null,{"$f":"IF(P60=\"\",DAT!$E$10,P60)","v":"2036-02-09"},null,null,{"$f":"IF(S60=\"\",DAT!$E$10,S60)","v":"2036-02-09"}]
[null,null,null,null,"軽減開始月初",null,{"$f":"DATE(YEAR(G71),MONTH(G71),1)","v":"2036-02-01"},null,null,{"$f":"DATE(YEAR(J71),MONTH(J71),1)","v":"2036-02-01"},null,null,{"$f":"DATE(YEAR(M71),MONTH(M71),1)","v":"2036-02-01"},null,null,{"$f":"DATE(YEAR(P71),MONTH(P71),1)","v":"2036-02-01"},null,null,{"$f":"DATE(YEAR(S71),MONTH(S71),1)","v":"2036-02-01"}]
[null,null,null,null,"軽減終了月初",null,{"$f":"DATE(YEAR(G72),MONTH(G72)+24,1)","v":"2038-02-01"},null,null,{"$f":"DATE(YEAR(J72),MONTH(J72)+24,1)","v":"2038-02-01"},null,null,{"$f":"DATE(YEAR(M72),MONTH(M72)+24,1)","v":"2038-02-01"},null,null,{"$f":"DATE(YEAR(P72),MONTH(P72)+24,1)","v":"2038-02-01"},null,null,{"$f":"DATE(YEAR(S72),MONTH(S72)+24,1)","v":"2038-02-01"}]
[null,null,null,null,"実軽減終了月初",null,{"$f":"IF(G73<DAT!$D$10,DATE(YEAR(DAT!$D$10),MONTH(DAT!$D$10),1),G73)","v":"2038-02-01"},null,null,{"$f":"IF(J73<DAT!$D$10,DATE(YEAR(DAT!$D$10),MONTH(DAT!$D$10),1),J73)","v":"2038-02-01"},null,null,{"$f":"IF(M73<DAT!$D$10,DATE(YEAR(DAT!$D$10),MONTH(DAT!$D$10),1),M73)","v":"2038-02-01"},null,null,{"$f":"IF(P73<DAT!$D$10,DATE(YEAR(DAT!$D$10),MONTH(DAT!$D$10),1),P73)","v":"2038-02-01"},null,null,{"$f":"IF(S73<DAT!$D$10,DATE(YEAR(DAT!$D$10),MONTH(DAT!$D$10),1),S73)","v":"2038-02-01"}]
[null,null,null,null,"みなし軽減月",null,{"$f":"IF(G60=\"\",0,G70)","v":0},null,null,{"$f":"IF(J60=\"\",0,J70)","v":0},null,null,{"$f":"IF(M60=\"\",0,IF(M70=\"\",0,M70))","v":0},null,null,{"$f":"IF(P60=\"\",0,P70)","v":0},null,null,{"$f":"IF(S60=\"\",0,S70)","v":0}]
[null,null,null,null,"軽減終了日過去",null,{"$f":"(YEAR(G74)-YEAR(DAT!$C$10))*12+(MONTH(G74)-MONTH(DAT!$C$10))","v":214},null,null,{"$f":"(YEAR(J74)-YEAR(DAT!$C$10))*12+(MONTH(J74)-MONTH(DAT!$C$10))","v":214},null,null,{"$f":"(YEAR(M74)-YEAR(DAT!$C$10))*12+(MONTH(M74)-MONTH(DAT!$C$10))","v":214},null,null,{"$f":"(YEAR(P74)-YEAR(DAT!$C$10))*12+(MONTH(P74)-MONTH(DAT!$C$10))","v":214},null,null,{"$f":"(YEAR(S74)-YEAR(DAT!$C$10))*12+(MONTH(S74)-MONTH(DAT!$C$10))","v":214}]
[null,null,null,null,"軽減終了していない月",null,{"$f":"IF(G76<0,0,G76)","v":214},null,null,{"$f":"IF(J76<0,0,J76)","v":214},null,null,{"$f":"IF(M76<0,0,M76)","v":214},null,null,{"$f":"IF(P76<0,0,P76)","v":214},null,null,{"$f":"IF(S76<0,0,S76)","v":214}]
[null,null,null,null,"軽減終了月数",null,{"$f":"IF(12-G77<0,0,12-G77)","v":0},null,null,{"$f":"IF(12-J77<0,0,12-J77)","v":0},null,null,{"$f":"IF(12-M77<0,0,12-M77)","v":0},null,null,{"$f":"IF(12-P77<0,0,12-P77)","v":0},null,null,{"$f":"IF(12-S77<0,0,12-S77)","v":0}]
[null,null,null,null,"軽減月数",null,{"$f":"IF(G69=0,0,IF(G75<=G78,0,G75-G78))","v":0},null,null,{"$f":"IF(J69=0,0,IF(J75<=J78,0,J75-J78))","v":0},null,null,{"$f":"IF(M69=0,0,IF(M75<=M78,0,M75-M78))","v":0},null,null,{"$f":"IF(P69=0,0,IF(P75<=P78,0,P75-P78))","v":0},null,null,{"$f":"IF(S69=0,0,IF(S75<=S78,0,S75-S78))","v":0}]
[null,null,null,null,"軽減終了月数",null,{"$f":"IF(G70<=G78,G70,G78)","v":0},null,null,{"$f":"IF(J70<=J78,J70,J78)","v":0},null,null,{"$f":"IF(M70<=M78,M70,M78)","v":0},null,null,{"$f":"IF(P70<=P78,P70,P78)","v":0},null,null,{"$f":"IF(S70<=S78,S70,S78)","v":0}]
[null,null,null,null,"軽減なし月数",null,{"$f":"IF(G69=0,0,G70-G79-G80)","v":0},null,null,{"$f":"IF(J69=0,0,J70-J79-J80)","v":0},null,null,{"$f":"IF(M69=0,0,M70-M79-M80)","v":0},null,null,{"$f":"IF(P69=0,0,P70-P79-P80)","v":0},null,null,{"$f":"IF(S69=0,0,S70-S79-S80)","v":0}]
[]
[]
[]
[]
[null,null,"年間保険料(A＋B)",null,null,null,{"$f":"IF(G69=0,\"\",G202)","v":""},"円",null,{"$f":"IF(J69=0,\"\",J202)","v":""},"円",null,{"$f":"IF(M69=0,\"\",M202)","v":""},"円",null,{"$f":"IF(P69=0,\"\",P202)","v":""},"円",null,{"$f":"IF(S69=0,\"\",S202)","v":""},"円"]
[null,null,"被扶養軽減あり",null,null,null,{"$f":"IF(G144=0,\"\",G203)","v":""},"円",null,{"$f":"IF(J144=0,\"\",J203)","v":""},"円",null,{"$f":"IF(M144=0,\"\",M203)","v":""},"円",null,{"$f":"IF(P144=0,\"\",P203)","v":""},"円",null,{"$f":"IF(S144=0,\"\",S203)","v":""},"円"]
[null,null,"被扶養軽減なし",null,null,null,{"$f":"IF(G144=0,\"\",G204)","v":""},"円",null,{"$f":"IF(J144=0,\"\",J204)","v":""},"円",null,{"$f":"IF(M144=0,\"\",M204)","v":""},"円",null,{"$f":"IF(P144=0,\"\",P204)","v":""},"円",null,{"$f":"IF(S144=0,\"\",S204)","v":""},"円"]
[]
[]
[null,null,"均等割額(A)",null,null,null,{"$f":"IF(G69=0,\"\",G206)","v":""},"円",null,{"$f":"IF(J69=0,\"\",J206)","v":""},"円",null,{"$f":"IF(M69=0,\"\",M206)","v":""},"円",null,{"$f":"IF(P69=0,\"\",P206)","v":""},"円",null,{"$f":"IF(S69=0,\"\",S206)","v":""},"円"]
[null,null,"被扶養軽減あり",null,null,null,{"$f":"IF(G144=0,\"\",G207)","v":""},"円",null,{"$f":"IF(J144=0,\"\",J207)","v":""},"円",null,{"$f":"IF(M144=0,\"\",M207)","v":""},"円",null,{"$f":"IF(P144=0,\"\",P207)","v":""},"円",null,{"$f":"IF(S144=0,\"\",S207)","v":""},"円"]
[null,null,"被扶養軽減なし",null,null,null,{"$f":"IF(G144=0,\"\",G208)","v":""},"円",null,{"$f":"IF(J144=0,\"\",J208)","v":""},"円",null,{"$f":"IF(M144=0,\"\",M208)","v":""},"円",null,{"$f":"IF(P144=0,\"\",P208)","v":""},"円",null,{"$f":"IF(S144=0,\"\",S208)","v":""},"円"]
[]
[]
[null,null,"所得割額(B)",null,null,null,{"$f":"IF(G69=0,\"\",G210)","v":""},"円",null,{"$f":"IF(J69=0,\"\",J210)","v":""},"円",null,{"$f":"IF(M69=0,\"\",M210)","v":""},"円",null,{"$f":"IF(P69=0,\"\",P210)","v":""},"円",null,{"$f":"IF(S69=0,\"\",S210)","v":""},"円"]
[null,null,"被扶養軽減あり",null,null,null,{"$f":"IF(G144=0,\"\",G211)","v":""},"円",null,{"$f":"IF(J144=0,\"\",J211)","v":""},"円",null,{"$f":"IF(M144=0,\"\",M211)","v":""},"円",null,{"$f":"IF(P144=0,\"\",P211)","v":""},"円",null,{"$f":"IF(S144=0,\"\",S211)","v":""},"円"]
[null,null,"被扶養軽減なし",null,null,null,{"$f":"IF(G144=0,\"\",G212)","v":""},"円",null,{"$f":"IF(J144=0,\"\",J212)","v":""},"円",null,{"$f":"IF(M144=0,\"\",M212)","v":""},"円",null,{"$f":"IF(P144=0,\"\",P212)","v":""},"円",null,{"$f":"IF(S144=0,\"\",S212)","v":""},"円"]
[]
[null,null,"賦課月数(月)",null,null,null,{"$f":"G70","v":""},"月",null,{"$f":"J70","v":""},"月",null,{"$f":"M70","v":""},"月",null,{"$f":"P70","v":""},"月",null,{"$f":"S70","v":""},"月"]
[null,null,"被扶養軽減あり",null,null,null,{"$f":"G150","v":""},"月",null,{"$f":"J150","v":""},"月",null,{"$f":"M150","v":""},"月",null,{"$f":"P150","v":""},"月",null,{"$f":"S150","v":""},"月"]
[null,null,"被扶養軽減なし",null,null,null,{"$f":"G151","v":""},"月",null,{"$f":"J151","v":""},"月",null,{"$f":"M151","v":""},"月",null,{"$f":"P151","v":""},"月",null,{"$f":"S151","v":""},"月"]
[]
[null,null,"決定保険料",null,null,null,{"$f":"G214","v":""},"円",null,{"$f":"J214","v":""},"円",null,{"$f":"M214","v":""},"円",null,{"$f":"P214","v":""},"円",null,{"$f":"S214","v":""},"円"]
[]
[]
[]
[null,null,null,null,"被保険者人数",null,{"$f":"G32+J32+M32+P32+S32","v":0}]
[null,null,null,null,"年金収入額（<65歳）",null,{"$f":"IF(G17<65,IF(G36<=DAT!$E$20,1,IF(AND(G36>=DAT!$D$21,G36<=DAT!$E$21),2,IF(AND(G36>=DAT!$D$22,G36<=DAT!$E$22),3,IF(AND(G36>=DAT!$D$23,G36<=DAT!$E$23),4,5)))),0)","v":0},null,null,{"$f":"IF(AND(J17<65,J32=1),IF(J36<=DAT!$E$20,1,IF(AND(J36>=DAT!$D$21,J36<=DAT!$E$21),2,IF(AND(J36>=DAT!$D$22,J36<=DAT!$E$22),3,IF(AND(J36>=DAT!$D$23,J36<=DAT!$E$23),4,5)))),0)","v":0},null,null,{"$f":"IF(AND(M17<65,M32=1),IF(M36<=DAT!$E$20,1,IF(AND(M36>=DAT!$D$21,M36<=DAT!$E$21),2,IF(AND(M36>=DAT!$D$22,M36<=DAT!$E$22),3,IF(AND(M36>=DAT!$D$23,M36<=DAT!$E$23),4,5)))),0)","v":0},null,null,{"$f":"IF(AND(P17<65,P32=1),IF(P36<=DAT!$E$20,1,IF(AND(P36>=DAT!$D$21,P36<=DAT!$E$21),2,IF(AND(P36>=DAT!$D$22,P36<=DAT!$E$22),3,IF(AND(P36>=DAT!$D$23,P36<=DAT!$E$23),4,5)))),0)","v":0},null,null,{"$f":"IF(AND(S17<65,S32=1),IF(S36<=DAT!$E$20,1,IF(AND(S36>=DAT!$D$21,S36<=DAT!$E$21),2,IF(AND(S36>=DAT!$D$22,S36<=DAT!$E$22),3,IF(AND(S36>=DAT!$D$23,S36<=DAT!$E$23),4,5)))),0)","v":0}]
[null,null,null,null,"年金収入額（>=65歳）",null,{"$f":"IF(G17>=65,IF(G36<=DAT!$E$27,6,IF(AND(G36>=DAT!$D$28,G36<=DAT!$E$28),7,IF(AND(G36>=DAT!$D$29,G36<=DAT!$E$29),8,IF(AND(G36>=DAT!$D$30,G36<=DAT!$E$30),9,10)))),0)","v":6},null,null,{"$f":"IF(AND(J17>=65,J32=1),IF(J36<=DAT!$E$27,6,IF(AND(J36>=DAT!$D$28,J36<=DAT!$E$28),7,IF(AND(J36>=DAT!$D$29,J36<=DAT!$E$29),8,IF(AND(J36>=DAT!$D$30,J36<=DAT!$E$30),9,10)))),0)","v":0},null,null,{"$f":"IF(AND(M17>=65,M32=1),IF(M36<=DAT!$E$27,6,IF(AND(M36>=DAT!$D$28,M36<=DAT!$E$28),7,IF(AND(M36>=DAT!$D$29,M36<=DAT!$E$29),8,IF(AND(M36>=DAT!$D$30,M36<=DAT!$E$30),9,10)))),0)","v":0},null,null,{"$f":"IF(AND(P17>=65,P32=1),IF(P36<=DAT!$E$27,6,IF(AND(P36>=DAT!$D$28,P36<=DAT!$E$28),7,IF(AND(P36>=DAT!$D$29,P36<=DAT!$E$29),8,IF(AND(P36>=DAT!$D$30,P36<=DAT!$E$30),9,10)))),0)","v":0},null,null,{"$f":"IF(AND(S17>=65,S32=1),IF(S36<=DAT!$E$27,6,IF(AND(S36>=DAT!$D$28,S36<=DAT!$E$28),7,IF(AND(S36>=DAT!$D$29,S36<=DAT!$E$29),8,IF(AND(S36>=DAT!$D$30,S36<=DAT!$E$30),9,10)))),0)","v":0}]
[null,null,null,null,"年金収入額判定",null,{"$f":"SUM(G109:G110)","v":6},null,null,{"$f":"SUM(J109:J110)","v":0},null,null,{"$f":"SUM(M109:M110)","v":0},null,null,0,null,null,0]
[null,null,null,null,"年金所得",null,{"$f":"IF(G111=6,DAT!$G$27,IF(G111=7,G36-DAT!$G$28,IF(G111=8,ROUNDDOWN(G36*DAT!$F$29,0)-DAT!$G$29,IF(G111=9,ROUNDDOWN(G36*DAT!$F$30,0)-DAT!$G$30,IF(G111=10,ROUNDDOWN(G36*DAT!$F$31,0)-DAT!$G$31,IF(G111=1,DAT!$G$20,IF(G111=2,G36-DAT!$G$21,IF(G111=3,ROUNDDOWN(G36*DAT!$F$22,0)-DAT!$G$22,IF(G111=4,ROUNDDOWN(G36*DAT!$F$23,0)-DAT!$G$23,IF(G111=5,ROUNDDOWN(G36*DAT!$F$24,0)-DAT!$G$24,0))))))))))","v":0},null,null,{"$f":"IF(J111=6,DAT!$G$27,IF(J111=7,J36-DAT!$G$28,IF(J111=8,ROUNDDOWN(J36*DAT!$F$29,0)-DAT!$G$29,IF(J111=9,ROUNDDOWN(J36*DAT!$F$30,0)-DAT!$G$30,IF(J111=10,ROUNDDOWN(J36*DAT!$F$31,0)-DAT!$G$31,IF(J111=1,DAT!$G$20,IF(J111=2,J36-DAT!$G$21,IF(J111=3,ROUNDDOWN(J36*DAT!$F$22,0)-DAT!$G$22,IF(J111=4,ROUNDDOWN(J36*DAT!$F$23,0)-DAT!$G$23,IF(J111=5,ROUNDDOWN(J36*DAT!$F$24,0)-DAT!$G$24,0))))))))))","v":0},null,null,{"$f":"IF(M111=6,DAT!$G$27,IF(M111=7,M36-DAT!$G$28,IF(M111=8,ROUNDDOWN(M36*DAT!$F$29,0)-DAT!$G$29,IF(M111=9,ROUNDDOWN(M36*DAT!$F$30,0)-DAT!$G$30,IF(M111=10,ROUNDDOWN(M36*DAT!$F$31,0)-DAT!$G$31,IF(M111=1,DAT!$G$20,IF(M111=2,M36-DAT!$G$21,IF(M111=3,ROUNDDOWN(M36*DAT!$F$22,0)-DAT!$G$22,IF(M111=4,ROUNDDOWN(M36*DAT!$F$23,0)-DAT!$G$23,IF(M111=5,ROUNDDOWN(M36*DAT!$F$24,0)-DAT!$G$24,0))))))))))","v":0},null,null,{"$f":"IF(P111=6,DAT!$G$27,IF(P111=7,P36-DAT!$G$28,IF(P111=8,ROUNDDOWN(P36*DAT!$F$29,0)-DAT!$G$29,IF(P111=9,ROUNDDOWN(P36*DAT!$F$30,0)-DAT!$G$30,IF(P111=10,ROUNDDOWN(P36*DAT!$F$31,0)-DAT!$G$31,IF(P111=1,DAT!$G$20,IF(P111=2,P36-DAT!$G$21,IF(P111=3,ROUNDDOWN(P36*DAT!$F$22,0)-DAT!$G$22,IF(P111=4,ROUNDDOWN(P36*DAT!$F$23,0)-DAT!$G$23,IF(P111=5,ROUNDDOWN(P36*DAT!$F$24,0)-DAT!$G$24,0))))))))))","v":0},null,null,{"$f":"IF(S111=6,DAT!$G$27,IF(S111=7,S36-DAT!$G$28,IF(S111=8,ROUNDDOWN(S36*DAT!$F$29,0)-DAT!$G$29,IF(S111=9,ROUNDDOWN(S36*DAT!$F$30,0)-DAT!$G$30,IF(S111=10,ROUNDDOWN(S36*DAT!$F$31,0)-DAT!$G$31,IF(S111=1,DAT!$G$20,IF(S111=2,S36-DAT!$G$21,IF(S111=3,ROUNDDOWN(S36*DAT!$F$22,0)-DAT!$G$22,IF(S111=4,ROUNDDOWN(S36*DAT!$F$23,0)-DAT!$G$23,IF(S111=5,ROUNDDOWN(S36*DAT!$F$24,0)-DAT!$G$24,0))))))))))","v":0}]
[null,null,null,null,"高齢者控除後年金所得",null,{"$f":"IF(G112-G121<0,0,G112-G121)","v":0},null,null,{"$f":"IF(J112-J121<0,0,J112-J121)","v":0},null,null,{"$f":"IF(M112-M121<0,0,M112-M121)","v":0},null,null,{"$f":"IF(P112-P121<0,0,P112-P121)","v":0},null,null,{"$f":"IF(S112-S121<0,0,S112-S121)","v":0}]
[null,null,null,null,"給与収入額判定",null,{"$f":"IF(G38<=DAT!$E$34,1,IF(AND(G38>=DAT!$D$35,G38<=DAT!$E$35),2,IF(AND(G38>=DAT!$D$36,G38<=DAT!$E$36),3,IF(AND(G38>=DAT!$D$37,G38<=DAT!$E$37),4,IF(AND(G38>=DAT!$D$38,G38<=DAT!$E$38),5,IF(AND(G38>=DAT!$D$39,G38<=DAT!$E$39),6,IF(AND(G38>=DAT!$D$40,G38<=DAT!$E$40),7,IF(AND(G38>=DAT!$D$41,G38<=DAT!$E$41),8,IF(AND(G38>=DAT!$D$42,G38<=DAT!$E$42),9,10)))))))))","v":1},null,null,{"$f":"IF(J38<=DAT!$E$34,1,IF(AND(J38>=DAT!$D$35,J38<=DAT!$E$35),2,IF(AND(J38>=DAT!$D$36,J38<=DAT!$E$36),3,IF(AND(J38>=DAT!$D$37,J38<=DAT!$E$37),4,IF(AND(J38>=DAT!$D$38,J38<=DAT!$E$38),5,IF(AND(J38>=DAT!$D$39,J38<=DAT!$E$39),6,IF(AND(J38>=DAT!$D$40,J38<=DAT!$E$40),7,IF(AND(J38>=DAT!$D$41,J38<=DAT!$E$41),8,IF(AND(J38>=DAT!$D$42,J38<=DAT!$E$42),9,10)))))))))","v":1},null,null,{"$f":"IF(M38<=DAT!$E$34,1,IF(AND(M38>=DAT!$D$35,M38<=DAT!$E$35),2,IF(AND(M38>=DAT!$D$36,M38<=DAT!$E$36),3,IF(AND(M38>=DAT!$D$37,M38<=DAT!$E$37),4,IF(AND(M38>=DAT!$D$38,M38<=DAT!$E$38),5,IF(AND(M38>=DAT!$D$39,M38<=DAT!$E$39),6,IF(AND(M38>=DAT!$D$40,M38<=DAT!$E$40),7,IF(AND(M38>=DAT!$D$41,M38<=DAT!$E$41),8,IF(AND(M38>=DAT!$D$42,M38<=DAT!$E$42),9,10)))))))))","v":1},null,null,{"$f":"IF(P38<=DAT!$E$34,1,IF(AND(P38>=DAT!$D$35,P38<=DAT!$E$35),2,IF(AND(P38>=DAT!$D$36,P38<=DAT!$E$36),3,IF(AND(P38>=DAT!$D$37,P38<=DAT!$E$37),4,IF(AND(P38>=DAT!$D$38,P38<=DAT!$E$38),5,IF(AND(P38>=DAT!$D$39,P38<=DAT!$E$39),6,IF(AND(P38>=DAT!$D$40,P38<=DAT!$E$40),7,IF(AND(P38>=DAT!$D$41,P38<=DAT!$E$41),8,IF(AND(P38>=DAT!$D$42,P38<=DAT!$E$42),9,10)))))))))","v":1},null,null,{"$f":"IF(S38<=DAT!$E$34,1,IF(AND(S38>=DAT!$D$35,S38<=DAT!$E$35),2,IF(AND(S38>=DAT!$D$36,S38<=DAT!$E$36),3,IF(AND(S38>=DAT!$D$37,S38<=DAT!$E$37),4,IF(AND(S38>=DAT!$D$38,S38<=DAT!$E$38),5,IF(AND(S38>=DAT!$D$39,S38<=DAT!$E$39),6,IF(AND(S38>=DAT!$D$40,S38<=DAT!$E$40),7,IF(AND(S38>=DAT!$D$41,S38<=DAT!$E$41),8,IF(AND(S38>=DAT!$D$42,S38<=DAT!$E$42),9,10)))))))))","v":1}]
[null,null,null,null,"給与所得",null,{"$f":"IF(G114=1,G38-DAT!$G$34,IF(G114=2,DAT!$G$35,IF(G114=3,DAT!$G$36,IF(G114=4,DAT!$G$37,IF(G114=5,DAT!$G$38,IF(G114=6,ROUNDDOWN(G38/4000,0)*4000*DAT!$F$39,IF(G114=7,ROUNDDOWN(G38/4000,0)*4000*DAT!$F$40-180000,IF(G114=8,ROUNDDOWN(G38/4000,0)*4000*DAT!$F$41-540000,IF(G114=9,ROUNDDOWN(G38*DAT!$F$42,0)-1200000,IF(G114=10,G38-2200000,0))))))))))","v":-650000},null,null,{"$f":"IF(J114=1,J38-DAT!$G$34,IF(J114=2,DAT!$G$35,IF(J114=3,DAT!$G$36,IF(J114=4,DAT!$G$37,IF(J114=5,DAT!$G$38,IF(J114=6,ROUNDDOWN(J38/4000,0)*4000*DAT!$F$39,IF(J114=7,ROUNDDOWN(J38/4000,0)*4000*DAT!$F$40-180000,IF(J114=8,ROUNDDOWN(J38/4000,0)*4000*DAT!$F$41-540000,IF(J114=9,ROUNDDOWN(J38*DAT!$F$42,0)-1200000,IF(J114=10,J38-2200000,0))))))))))","v":-650000},null,null,{"$f":"IF(M114=1,M38-DAT!$G$34,IF(M114=2,DAT!$G$35,IF(M114=3,DAT!$G$36,IF(M114=4,DAT!$G$37,IF(M114=5,DAT!$G$38,IF(M114=6,ROUNDDOWN(M38/4000,0)*4000*DAT!$F$39,IF(M114=7,ROUNDDOWN(M38/4000,0)*4000*DAT!$F$40-180000,IF(M114=8,ROUNDDOWN(M38/4000,0)*4000*DAT!$F$41-540000,IF(M114=9,ROUNDDOWN(M38*DAT!$F$42,0)-1200000,IF(M114=10,M38-2200000,0))))))))))","v":-650000},null,null,{"$f":"IF(P114=1,P38-DAT!$G$34,IF(P114=2,DAT!$G$35,IF(P114=3,DAT!$G$36,IF(P114=4,DAT!$G$37,IF(P114=5,DAT!$G$38,IF(P114=6,ROUNDDOWN(P38/4000,0)*4000*DAT!$F$39,IF(P114=7,ROUNDDOWN(P38/4000,0)*4000*DAT!$F$40-180000,IF(P114=8,ROUNDDOWN(P38/4000,0)*4000*DAT!$F$41-540000,IF(P114=9,ROUNDDOWN(P38*DAT!$F$42,0)-1200000,IF(P114=10,P38-2200000,0))))))))))","v":-650000},null,null,{"$f":"IF(S114=1,S38-DAT!$G$34,IF(S114=2,DAT!$G$35,IF(S114=3,DAT!$G$36,IF(S114=4,DAT!$G$37,IF(S114=5,DAT!$G$38,IF(S114=6,ROUNDDOWN(S38/4000,0)*4000*DAT!$F$39,IF(S114=7,ROUNDDOWN(S38/4000,0)*4000*DAT!$F$40-180000,IF(S114=8,ROUNDDOWN(S38/4000,0)*4000*DAT!$F$41-540000,IF(S114=9,ROUNDDOWN(S38*DAT!$F$42,0)-1200000,IF(S114=10,S38-2200000,0))))))))))","v":-650000}]
[null,null,null,null,"給与所得",null,{"$f":"IF(G115<0,0,G115)","v":0},null,null,{"$f":"IF(J115<0,0,J115)","v":0},null,null,{"$f":"IF(M115<0,0,M115)","v":0},null,null,{"$f":"IF(P115<0,0,P115)","v":0},null,null,{"$f":"IF(S115<0,0,S115)","v":0}]
[null,null,null,null,"その他所得合計",null,{"$f":"G116+G40","v":0},null,null,{"$f":"J116+J40","v":0},null,null,{"$f":"M116+M40","v":0},null,null,{"$f":"P116+P40","v":0},null,null,{"$f":"S116+S40","v":0}]
[null,null,null,null,"総所得",null,{"$f":"G112+G116+G40","v":0},null,null,{"$f":"J112+J116+J40","v":0},null,null,{"$f":"M112+M116+M40","v":0},null,null,{"$f":"P112+P116+P40","v":0},null,null,{"$f":"S112+S116+S40","v":0}]
[null,null,null,null,"基礎控除",null,{"$f":"IF(G69=1,IF(OR(G113>0,G116>0),DAT!$C$15,0),0)","v":0},null,null,{"$f":"IF(J69=1,IF(OR(J113>0,J116>0),DAT!$C$15,0),0)","v":0},null,null,{"$f":"IF(M69=1,IF(OR(M113>0,M116>0),DAT!$C$15,0),0)","v":0},null,null,{"$f":"IF(P69=1,IF(OR(P113>0,P116>0),DAT!$C$15,0),0)","v":0},null,null,{"$f":"IF(S69=1,IF(OR(S113>0,S116>0),DAT!$C$15,0),0)","v":0}]
[null,null,null,null,"基礎控除",null,{"$f":"G119","v":0},null,null,{"$f":"J119","v":0},null,null,{"$f":"M119","v":0},null,null,{"$f":"P119","v":0},null,null,{"$f":"S119","v":0}]
[null,null,null,null,"高齢者特別控除",null,{"$f":"IF(AND(G36>0,G112>0,G17>=65),DAT!$C$17,0)","v":0},null,null,{"$f":"IF(AND(J36>0,J112>0,J17>=65),DAT!$C$17,0)","v":0},null,null,{"$f":"IF(AND(M36>0,M112>0,M17>=65),DAT!$C$17,0)","v":0},null,null,{"$f":"IF(AND(P36>0,P112>0,P17>=65),DAT!$C$17,0)","v":0},null,null,{"$f":"IF(AND(S36>0,S112>0,S17>=65),DAT!$C$17,0)","v":0}]
[null,null,null,null,"高齢者特別控除",null,{"$f":"G121","v":0},null,null,{"$f":"J121","v":0},null,null,{"$f":"M121","v":0},null,null,{"$f":"P121","v":0},null,null,{"$f":"S121","v":0}]
[]
[null,null,null,null,"軽減判定所得",null,{"$f":"G40+G113+G116","v":0},null,null,{"$f":"J40+J113+J116","v":0},null,null,{"$f":"M40+M113+M116","v":0},null,null,{"$f":"P40+P113+P116","v":0},null,null,{"$f":"S40+S113+S116","v":0}]
[null,null,null,null,"軽減判定世帯所得",null,{"$f":"SUM(G124:S124)","v":0},null,null,{"$f":"SUM(G124:S124)","v":0},null,null,{"$f":"SUM(G124:S124)","v":0},null,null,{"$f":"SUM(G124:S124)","v":0},null,null,{"$f":"SUM(G124:S124)","v":0}]
[null,null,null,null,"賦課のもととなる所得",null,{"$f":"IF(G32=1,IF(G118-DAT!$C$15<0,0,G118-DAT!$C$15),0)","v":0},null,null,{"$f":"IF(J32=1,IF(J118-DAT!$C$15<0,0,J118-DAT!$C$15),0)","v":0},null,null,{"$f":"IF(M32=1,IF(M118-DAT!$C$15<0,0,M118-DAT!$C$15),0)","v":0},null,null,{"$f":"IF(P32=1,IF(P118-DAT!$C$15<0,0,P118-DAT!$C$15),0)","v":0},null,null,{"$f":"IF(S32=1,IF(S118-DAT!$C$15<0,0,S118-DAT!$C$15),0)","v":0}]
[null,null,null,null,"賦課のもととなる所得",null,{"$f":"IF(G126<0,0,G126)","v":0},null,null,{"$f":"IF(J126<0,0,J126)","v":0},null,null,{"$f":"IF(M126<0,0,M126)","v":0},null,null,{"$f":"IF(P126<0,0,P126)","v":0},null,null,{"$f":"IF(S126<0,0,S126)","v":0}]
[null,null,null,null,"所得割額(軽減前)",null,{"$f":"IF(G32=1,ROUNDDOWN(G127*DAT!$C$43,0),0)","v":0},null,null,{"$f":"ROUNDDOWN(J127*DAT!$C$43,0)","v":0},null,null,{"$f":"ROUNDDOWN(M127*DAT!$C$43,0)","v":0},null,null,{"$f":"ROUNDDOWN(P127*DAT!$C$43,0)","v":0},null,null,{"$f":"ROUNDDOWN(S127*DAT!$C$43,0)","v":0}]
[null,null,null,null,"所得割額(軽減前)【B】",null,{"$f":"IF(G69=1,G128,\"\")","v":""},null,null,{"$f":"IF(J69=1,J128,\"\")","v":""},null,null,{"$f":"IF(M69=1,M128,\"\")","v":""},null,null,{"$f":"IF(P69=1,P128,\"\")","v":""},null,null,{"$f":"IF(S69=1,S128,\"\")","v":""}]
[]
[null,null,null,null,"9割判定",null,{"$f":"IF(AND(G117<=DAT!$C$55,G36+G117<=DAT!$C$54),0,1)","v":0},null,null,{"$f":"IF(AND(J117<=DAT!$C$55,J36+J117<=DAT!$C$54),0,1)","v":0},null,null,{"$f":"IF(AND(M117<=DAT!$C$55,M36+M117<=DAT!$C$54),0,1)","v":0},null,null,{"$f":"IF(AND(P117<=DAT!$C$55,P36+P117<=DAT!$C$54),0,1)","v":0},null,null,{"$f":"IF(AND(S117<=DAT!$C$55,S36+S117<=DAT!$C$54),0,1)","v":0}]
[null,null,null,null,"9割判定世帯",null,{"$f":"IF(G69=0,J131+M131+P131+S131,G131+J131+M131+P131+S131)","v":0},null,null,{"$f":"IF(G69=0,J131+M131+P131+S131,G131+J131+M131+P131+S131)","v":0},null,null,{"$f":"IF(G69=0,J131+M131+P131+S131,G131+J131+M131+P131+S131)","v":0},null,null,{"$f":"IF(G69=0,J131+M131+P131+S131,G131+J131+M131+P131+S131)","v":0},null,null,{"$f":"IF(G69=0,J131+M131+P131+S131,G131+J131+M131+P131+S131)","v":0}]
[null,null,null,null,"均等割額9割判定前",null,{"$f":"IF(G125<=DAT!$C$53,DAT!$D$53,IF(AND(G125>DAT!$C$52,G125<=DAT!$C$53+DAT!$C$52*G108),DAT!$D$52,IF(AND(G125>DAT!$C$53+DAT!$C$52*G108,G125<=DAT!$C$53+DAT!$C$51*G108),DAT!$D$51,DAT!$D$50)))","v":11318},null,null,{"$f":"IF(G125<=DAT!$C$53,DAT!$D$53,IF(AND(G125>DAT!$C$52,G125<=DAT!$C$53+DAT!$C$52*G108),DAT!$D$52,IF(AND(G125>DAT!$C$53+DAT!$C$52*G108,G125<=DAT!$C$53+DAT!$C$51*G108),DAT!$D$51,DAT!$D$50)))","v":11318},null,null,{"$f":"IF(G125<=DAT!$C$53,DAT!$D$53,IF(AND(G125>DAT!$C$52,G125<=DAT!$C$53+DAT!$C$52*G108),DAT!$D$52,IF(AND(G125>DAT!$C$53+DAT!$C$52*G108,G125<=DAT!$C$53+DAT!$C$51*G108),DAT!$D$51,DAT!$D$50)))","v":11318},null,null,{"$f":"IF(G125<=DAT!$C$53,DAT!$D$53,IF(AND(G125>DAT!$C$52,G125<=DAT!$C$53+DAT!$C$52*G108),DAT!$D$52,IF(AND(G125>DAT!$C$53+DAT!$C$52*G108,G125<=DAT!$C$53+DAT!$C$51*G108),DAT!$D$51,DAT!$D$50)))","v":11318},null,null,{"$f":"IF(G125<=DAT!$C$53,DAT!$D$53,IF(AND(G125>DAT!$C$52,G125<=DAT!$C$53+DAT!$C$52*G108),DAT!$D$52,IF(AND(G125>DAT!$C$53+DAT!$C$52*G108,G125<=DAT!$C$53+DAT!$C$51*G108),DAT!$D$51,DAT!$D$50)))","v":11318}]
[null,null,null,null,"均等割合9割判定前",null,{"$f":"IF(ISERROR(VLOOKUP(G133,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(G133,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"},null,null,{"$f":"IF(ISERROR(VLOOKUP(J133,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(J133,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"},null,null,{"$f":"IF(ISERROR(VLOOKUP(M133,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(M133,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"},null,null,{"$f":"IF(ISERROR(VLOOKUP(P133,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(P133,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"},null,null,{"$f":"IF(ISERROR(VLOOKUP(S133,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(S133,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"}]
[null,null,null,null,"均等割額",null,{"$f":"IF(G32=1,IF(AND(G134=DAT!$E$53,G132=0),DAT!$D$54,G133),0)","v":0},null,null,{"$f":"IF(J32=1,IF(AND(J134=DAT!$E$53,J132=0),DAT!$D$54,J133),0)","v":0},null,null,{"$f":"IF(M32=1,IF(AND(M134=DAT!$E$53,M132=0),DAT!$D$54,M133),0)","v":0},null,null,{"$f":"IF(P32=1,IF(AND(P134=DAT!$E$53,P132=0),DAT!$D$54,P133),0)","v":0},null,null,{"$f":"IF(S32=1,IF(AND(S134=DAT!$E$53,S132=0),DAT!$D$54,S133),0)","v":0}]
[null,null,null,null,"均等割額の軽減割合",null,{"$f":"IF(G32=1,IF(AND(G134=DAT!$E$53,G132=0),DAT!$E$54,G134),\"\")","v":""},null,null,{"$f":"IF(J32=1,IF(AND(J134=DAT!$E$53,J132=0),DAT!$E$54,J134),\"\")","v":""},null,null,{"$f":"IF(M32=1,IF(AND(M134=DAT!$E$53,M132=0),DAT!$E$54,M134),\"\")","v":""},null,null,{"$f":"IF(P32=1,IF(AND(P134=DAT!$E$53,P132=0),DAT!$E$54,P134),\"\")","v":""},null,null,{"$f":"IF(S32=1,IF(AND(S134=DAT!$E$53,S132=0),DAT!$E$54,S134),\"\")","v":""}]
[null,null,null,null,"均等割額【A】",null,{"$f":"G135","v":0},null,null,{"$f":"J135","v":0},null,null,{"$f":"M135","v":0},null,null,{"$f":"P135","v":0},null,null,{"$f":"S135","v":0}]
[null,null,null,null,"均等割額の軽減割合",null,{"$f":"G136","v":""},null,null,{"$f":"J136","v":""},null,null,{"$f":"M136","v":""},null,null,{"$f":"P136","v":""},null,null,{"$f":"S136","v":""}]
[null,null,null,null,"【A】+【B】",null,{"$f":"G128+G135","v":0},null,null,{"$f":"J128+J135","v":0},null,null,{"$f":"M128+M135","v":0},null,null,{"$f":"P128+P135","v":0},null,null,{"$f":"S128+S135","v":0}]
[null,null,null,null,"賦課限度額判定",null,{"$f":"IF(G139>=DAT!$C$12,1,0)","v":0},null,null,{"$f":"IF(J139>=DAT!$C$12,1,0)","v":0},null,null,{"$f":"IF(M139>=DAT!$C$12,1,0)","v":0},null,null,{"$f":"IF(P139>=DAT!$C$12,1,0)","v":0},null,null,{"$f":"IF(S139>=DAT!$C$12,1,0)","v":0}]
[null,null,null,null,"年間保険料①通常",null,{"$f":"IF(G140=1,DAT!$C$12,G139)","v":0},null,null,{"$f":"IF(J140=1,DAT!$C$12,J139)","v":0},null,null,{"$f":"IF(M140=1,DAT!$C$12,M139)","v":0},null,null,{"$f":"IF(P140=1,DAT!$C$12,P139)","v":0},null,null,{"$f":"IF(S140=1,DAT!$C$12,S139)","v":0}]
[null,null,null,null,"年間保険料",null,{"$f":"IF(G69=1,ROUNDDOWN(G141,-2),\"\")","v":""},null,null,{"$f":"IF(J69=1,ROUNDDOWN(J141,-2),\"\")","v":""},null,null,{"$f":"IF(M69=1,ROUNDDOWN(M141,-2),\"\")","v":""},null,null,{"$f":"IF(P69=1,ROUNDDOWN(P141,-2),\"\")","v":""},null,null,{"$f":"IF(S69=1,ROUNDDOWN(S141,-2),\"\")","v":""}]
[null,null,null,null,"年間保険料①通常",null,{"$f":"IF(G69=1,G141,\"\")","v":""},null,null,{"$f":"IF(J69=1,J141,\"\")","v":""},null,null,{"$f":"IF(M69=1,M141,\"\")","v":""},null,null,{"$f":"IF(P69=1,P141,\"\")","v":""},null,null,{"$f":"IF(S69=1,S141,\"\")","v":""}]
[null,null,null,null,"軽減あり判定",null,{"$f":"IF(AND(G69=1,G60<>\"\"),1,0)","v":0},null,null,{"$f":"IF(AND(J69=1,J60<>\"\"),1,0)","v":0},null,null,{"$f":"IF(AND(M69=1,M60<>\"\"),1,0)","v":0},null,null,{"$f":"IF(AND(P69=1,P60<>\"\"),1,0)","v":0},null,null,{"$f":"IF(AND(S69=1,S60<>\"\"),1,0)","v":0}]
[null,null,null,null,"均等割額軽減後",null,{"$f":"IF(DAT!$D$56>G135,G135,DAT!$D$56)","v":0},null,null,{"$f":"IF(DAT!$D$56>J135,J135,DAT!$D$56)","v":0},null,null,{"$f":"IF(DAT!$D$56>M135,M135,DAT!$D$56)","v":0},null,null,{"$f":"IF(DAT!$D$56>P135,P135,DAT!$D$56)","v":0},null,null,{"$f":"IF(DAT!$D$56>S135,S135,DAT!$D$56)","v":0}]
[null,null,null,null,"年間保険料②軽減あり",null,{"$f":"IF(G69=1,G145,\"\")","v":""},null,null,{"$f":"IF(J69=1,J145,\"\")","v":""},null,null,{"$f":"IF(M69=1,M145,\"\")","v":""},null,null,{"$f":"IF(P69=1,P145,\"\")","v":""},null,null,{"$f":"IF(S69=1,S145,\"\")","v":""}]
[]
[null,null,null,null,"年間保険料③軽減終了",null,{"$f":"IF(G69=1,G135,\"\")","v":""},null,null,{"$f":"IF(J69=1,J135,\"\")","v":""},null,null,{"$f":"IF(M69=1,M135,\"\")","v":""},null,null,{"$f":"IF(P69=1,P135,\"\")","v":""},null,null,{"$f":"IF(S69=1,S135,\"\")","v":""}]
[]
[null,null,null,null,"軽減月数",null,{"$f":"IF(G144=1,G79,\"\")","v":""},null,null,{"$f":"IF(J144=1,J79,\"\")","v":""},null,null,{"$f":"IF(M144=1,M79,\"\")","v":""},null,null,{"$f":"IF(P144=1,P79,\"\")","v":""},null,null,{"$f":"IF(S144=1,S79,\"\")","v":""}]
[null,null,null,null,"軽減終了月数",null,{"$f":"IF(G144=1,G80,\"\")","v":""},null,null,{"$f":"IF(J144=1,J80,\"\")","v":""},null,null,{"$f":"IF(M144=1,M80,\"\")","v":""},null,null,{"$f":"IF(P144=1,P80,\"\")","v":""},null,null,{"$f":"IF(S144=1,S80,\"\")","v":""}]
[]
[null,null,null,null,"N被扶養軽減なし",null,{"$f":"G141","v":0},null,null,{"$f":"J141","v":0},null,null,{"$f":"M141","v":0},null,null,{"$f":"P141","v":0},null,null,{"$f":"S141","v":0}]
[null,null,null,null,"N'被扶養軽減あり",null,{"$f":"G157+G160","v":0},null,null,{"$f":"J157+J160","v":0},null,null,{"$f":"M157+M160","v":0},null,null,{"$f":"P157+P160","v":0},null,null,{"$f":"S157+S160","v":0}]
[null,null,null,null,"N''被扶養軽減終了",null,{"$f":"G158+G161","v":0},null,null,{"$f":"J158+J161","v":0},null,null,{"$f":"M158+M161","v":0},null,null,{"$f":"P158+P161","v":0},null,null,{"$f":"S158+S161","v":0}]
[]
[null,null,null,null,"N'A被扶養軽減あり",null,{"$f":"G145","v":0},null,null,{"$f":"J145","v":0},null,null,{"$f":"M145","v":0},null,null,{"$f":"P145","v":0},null,null,{"$f":"S145","v":0}]
[null,null,null,null,"N''A被扶養軽減終了",null,{"$f":"G135","v":0},null,null,{"$f":"J135","v":0},null,null,{"$f":"M135","v":0},null,null,{"$f":"P135","v":0},null,null,{"$f":"S135","v":0}]
[]
[null,null,null,null,"N'B被扶養軽減あり",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,"N''B被扶養軽減終了",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[null,null,null,null,"決定保険料",null,{"$f":"IF(G69=1,ROUNDDOWN(G153-ROUNDUP(G153*(12-G80)/12,0)+G154-ROUNDUP(G154*(12-G78)/12,0)+G155-ROUNDUP(G155*(12-G79)/12,0),-2),\"\")","v":""},null,null,{"$f":"IF(J69=1,ROUNDDOWN(J153-ROUNDUP(J153*(12-J80)/12,0)+J154-ROUNDUP(J154*(12-J78)/12,0)+J155-ROUNDUP(J155*(12-J79)/12,0),-2),\"\")","v":""},null,null,{"$f":"IF(M69=1,ROUNDDOWN(M153-ROUNDUP(M153*(12-M80)/12,0)+M154-ROUNDUP(M154*(12-M78)/12,0)+M155-ROUNDUP(M155*(12-M79)/12,0),-2),\"\")","v":""},null,null,{"$f":"IF(P69=1,ROUNDDOWN(P153-ROUNDUP(P153*(12-P80)/12,0)+P154-ROUNDUP(P154*(12-P78)/12,0)+P155-ROUNDUP(P155*(12-P79)/12,0),-2),\"\")","v":""},null,null,{"$f":"IF(S69=1,ROUNDDOWN(S153-ROUNDUP(S153*(12-S80)/12,0)+S154-ROUNDUP(S154*(12-S78)/12,0)+S155-ROUNDUP(S155*(12-S79)/12,0),-2),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,"①",null,null,"②",null,null,"③",null,null,"④",null,null,"⑤"]
[null,null,null,null,"(複)被保険者判定",null,{"$f":"G69","v":0},null,null,{"$f":"J69","v":0},null,null,{"$f":"M69","v":0},null,null,{"$f":"P69","v":0},null,null,{"$f":"S69","v":0}]
[null,null,null,null,"(複)資格取得日",null,{"$f":"G63","v":"2020-04-01"},null,null,{"$f":"J63","v":"2020-04-01"},null,null,{"$f":"M63","v":"2020-04-01"},null,null,{"$f":"P63","v":"2020-04-01"},null,null,{"$f":"S63","v":"2020-04-01"}]
[null,null,null,null,"①世帯被保判定",null,{"$f":"G167","v":0},null,null,{"$f":"IF($G168>=J168,J167,0)","v":0},null,null,{"$f":"IF($G168>=M168,M167,0)","v":0},null,null,{"$f":"IF($G168>=P168,P167,0)","v":0},null,null,{"$f":"IF($G168>=S168,S167,0)","v":0}]
[null,null,null,null,"②世帯被保判定",null,{"$f":"G167","v":0},null,null,{"$f":"J167","v":0},null,null,{"$f":"IF($J168>=M168,M167,0)","v":0},null,null,{"$f":"IF($J168>=P168,P167,0)","v":0},null,null,{"$f":"IF($J168>=S168,S167,0)","v":0}]
[null,null,null,null,"③世帯被保判定",null,{"$f":"G167","v":0},null,null,{"$f":"IF($M168>=J168,J167,0)","v":0},null,null,{"$f":"M167","v":0},null,null,{"$f":"IF($M168>=P168,P167,0)","v":0},null,null,{"$f":"IF($M168>=S168,S167,0)","v":0}]
[null,null,null,null,"④世帯被保判定",null,{"$f":"G167","v":0},null,null,{"$f":"IF($P168>=J168,J167,0)","v":0},null,null,{"$f":"IF($P168>=M168,M167,0)","v":0},null,null,{"$f":"P167","v":0},null,null,{"$f":"IF($P168>=S168,S167,0)","v":0}]
[null,null,null,null,"⑤世帯被保判定",null,{"$f":"G167","v":0},null,null,{"$f":"IF($S168>=J168,J167,0)","v":0},null,null,{"$f":"IF($S168>=M168,M167,0)","v":0},null,null,{"$f":"IF($S168>=P168,P167,0)","v":0},null,null,{"$f":"S167","v":0}]
[]
[null,null,null,null,"期日被保険者数",null,{"$f":"SUM(G169:S169)","v":0},null,null,{"$f":"SUM(G170:S170)","v":0},null,null,{"$f":"SUM(G171:S171)","v":0},null,null,{"$f":"SUM(G172:S172)","v":0},null,null,{"$f":"SUM(G173:S173)","v":0}]
[]
[null,null,null,null,"(複)軽減判定所得",null,{"$f":"G124","v":0},null,null,{"$f":"J124","v":0},null,null,{"$f":"M124","v":0},null,null,{"$f":"P124","v":0},null,null,{"$f":"S124","v":0}]
[null,null,null,null,"期日軽減判定世帯所得",null,{"$f":"G177+J169*J177+M169*M177+P169*P177+S169*S177","v":0},null,null,{"$f":"G177+J170*J177+M170*M177+P170*P177+S170*S177","v":0},null,null,{"$f":"G177+J171*J177+M171*M177+P171*P177+S171*S177","v":0},null,null,{"$f":"G177+J172*J177+M172*M177+P172*P177+S172*S177","v":0},null,null,{"$f":"G177+J173*J177+M173*M177+P173*P177+S173*S177","v":0}]
[]
[null,null,null,null,"(複)9割判定",null,{"$f":"G131","v":0},null,null,{"$f":"J131","v":0},null,null,{"$f":"M131","v":0},null,null,{"$f":"P131","v":0},null,null,{"$f":"S131","v":0}]
[null,null,null,null,"K9割判定世帯",null,{"$f":"G180*G169+J180*J169+M180*M169+P180*P169+S180*S169","v":0},null,null,{"$f":"G180*G170+J180*J170+M180*M170+P180*P170+S180*S170","v":0},null,null,{"$f":"G180*G171+J180*J171+M180*M171+P180*P171+S180*S171","v":0},null,null,{"$f":"G180*G172+J180*J172+M180*M172+P180*P172+S180*S172","v":0},null,null,{"$f":"G180*G173+J180*J173+M180*M173+P180*P173+S180*S173","v":0}]
[null,null,null,null,"K均等割額9割判定前",null,{"$f":"IF(G178<=DAT!$C$53,DAT!$D$53,IF(AND(G178>DAT!$C$52,G178<=DAT!$C$53+DAT!$C$52*G175),DAT!$D$52,IF(AND(G178>DAT!$C$53+DAT!$C$52*G175,G178<=DAT!$C$53+DAT!$C$51*G175),DAT!$D$51,DAT!$D$50)))","v":11318},null,null,{"$f":"IF(J178<=DAT!$C$53,DAT!$D$53,IF(AND(J178>DAT!$C$52,J178<=DAT!$C$53+DAT!$C$52*J175),DAT!$D$52,IF(AND(J178>DAT!$C$53+DAT!$C$52*J175,J178<=DAT!$C$53+DAT!$C$51*J175),DAT!$D$51,DAT!$D$50)))","v":11318},null,null,{"$f":"IF(M178<=DAT!$C$53,DAT!$D$53,IF(AND(M178>DAT!$C$52,M178<=DAT!$C$53+DAT!$C$52*M175),DAT!$D$52,IF(AND(M178>DAT!$C$53+DAT!$C$52*M175,M178<=DAT!$C$53+DAT!$C$51*M175),DAT!$D$51,DAT!$D$50)))","v":11318},null,null,{"$f":"IF(P178<=DAT!$C$53,DAT!$D$53,IF(AND(P178>DAT!$C$52,P178<=DAT!$C$53+DAT!$C$52*P175),DAT!$D$52,IF(AND(P178>DAT!$C$53+DAT!$C$52*P175,P178<=DAT!$C$53+DAT!$C$51*P175),DAT!$D$51,DAT!$D$50)))","v":11318},null,null,{"$f":"IF(S178<=DAT!$C$53,DAT!$D$53,IF(AND(S178>DAT!$C$52,S178<=DAT!$C$53+DAT!$C$52*S175),DAT!$D$52,IF(AND(S178>DAT!$C$53+DAT!$C$52*S175,S178<=DAT!$C$53+DAT!$C$51*S175),DAT!$D$51,DAT!$D$50)))","v":11318}]
[null,null,null,null,"K均等割合9割判定前",null,{"$f":"IF(ISERROR(VLOOKUP(G182,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(G182,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"},null,null,{"$f":"IF(ISERROR(VLOOKUP(J182,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(J182,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"},null,null,{"$f":"IF(ISERROR(VLOOKUP(M182,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(M182,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"},null,null,{"$f":"IF(ISERROR(VLOOKUP(P182,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(P182,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"},null,null,{"$f":"IF(ISERROR(VLOOKUP(S182,DAT!$D$50:$E$56,2,FALSE)),\"\",(VLOOKUP(S182,DAT!$D$50:$E$56,2,FALSE)))","v":"７．７５割軽減"}]
[null,null,null,null,"K均等割額",null,{"$f":"IF(G32=1,IF(AND(G183=DAT!$E$53,G181=0),DAT!$D$54,G182),0)","v":0},null,null,{"$f":"IF(J32=1,IF(AND(J183=DAT!$E$53,J181=0),DAT!$D$54,J182),0)","v":0},null,null,{"$f":"IF(M32=1,IF(AND(M183=DAT!$E$53,M181=0),DAT!$D$54,M182),0)","v":0},null,null,{"$f":"IF(P32=1,IF(AND(P183=DAT!$E$53,P181=0),DAT!$D$54,P182),0)","v":0},null,null,{"$f":"IF(S32=1,IF(AND(S183=DAT!$E$53,S181=0),DAT!$D$54,S182),0)","v":0}]
[null,null,null,null,"K均等割額の軽減割合",null,{"$f":"IF(G32=1,IF(AND(G183=DAT!$E$53,G181=0),DAT!$E$54,G183),\"\")","v":""},null,null,{"$f":"IF(J32=1,IF(AND(J183=DAT!$E$53,J181=0),DAT!$E$54,J183),\"\")","v":""},null,null,{"$f":"IF(M32=1,IF(AND(M183=DAT!$E$53,M181=0),DAT!$E$54,M183),\"\")","v":""},null,null,{"$f":"IF(P32=1,IF(AND(P183=DAT!$E$53,P181=0),DAT!$E$54,P183),\"\")","v":""},null,null,{"$f":"IF(S32=1,IF(AND(S183=DAT!$E$53,S181=0),DAT!$E$54,S183),\"\")","v":""}]
[null,null,null,null,"K均等割額【A】",null,{"$f":"G184","v":0},null,null,{"$f":"J184","v":0},null,null,{"$f":"M184","v":0},null,null,{"$f":"P184","v":0},null,null,{"$f":"S184","v":0}]
[null,null,null,null,"K均等割額の軽減割合",null,{"$f":"G185","v":""},null,null,{"$f":"J185","v":""},null,null,{"$f":"M185","v":""},null,null,{"$f":"P185","v":""},null,null,{"$f":"S185","v":""}]
[null,null,null,null,"K均等割額【A】",null,{"$f":"G186","v":0},null,null,{"$f":"J186","v":0},null,null,{"$f":"M186","v":0},null,null,{"$f":"P186","v":0},null,null,{"$f":"S186","v":0}]
[null,null,null,null,"K均等割額の軽減割合",null,{"$f":"G187","v":""},null,null,{"$f":"J187","v":""},null,null,{"$f":"M187","v":""},null,null,{"$f":"P187","v":""},null,null,{"$f":"S187","v":""}]
[null,null,null,null,"K【A】+【B】",null,{"$f":"G128+G186","v":0},null,null,{"$f":"J128+J186","v":0},null,null,{"$f":"M128+M186","v":0},null,null,{"$f":"P128+P186","v":0},null,null,{"$f":"S128+S186","v":0}]
[null,null,null,null,"K賦課限度額判定",null,{"$f":"IF(G190>=DAT!$C$12,1,0)","v":0},null,null,{"$f":"IF(J190>=DAT!$C$12,1,0)","v":0},null,null,{"$f":"IF(M190>=DAT!$C$12,1,0)","v":0},null,null,{"$f":"IF(P190>=DAT!$C$12,1,0)","v":0},null,null,{"$f":"IF(S190>=DAT!$C$12,1,0)","v":0}]
[null,null,null,null,"K年間保険料①通常",null,{"$f":"IF(G191=1,DAT!$C$12,G190)","v":0},null,null,{"$f":"IF(J191=1,DAT!$C$12,J190)","v":0},null,null,{"$f":"IF(M191=1,DAT!$C$12,M190)","v":0},null,null,{"$f":"IF(P191=1,DAT!$C$12,P190)","v":0},null,null,{"$f":"IF(S191=1,DAT!$C$12,S190)","v":0}]
[null,null,null,null,"K年間保険料",null,{"$f":"IF(G69=1,ROUNDDOWN(G192,-2),\"\")","v":""},null,null,{"$f":"IF(J69=1,ROUNDDOWN(J192,-2),\"\")","v":""},null,null,{"$f":"IF(M69=1,ROUNDDOWN(M192,-2),\"\")","v":""},null,null,{"$f":"IF(P69=1,ROUNDDOWN(P192,-2),\"\")","v":""},null,null,{"$f":"IF(S69=1,ROUNDDOWN(S192,-2),\"\")","v":""}]
[null,null,null,null,"K年間保険料①通常",null,{"$f":"IF(G69=1,G192,\"\")","v":""},null,null,{"$f":"IF(J69=1,J192,\"\")","v":""},null,null,{"$f":"IF(M69=1,M192,\"\")","v":""},null,null,{"$f":"IF(P69=1,P192,\"\")","v":""},null,null,{"$f":"IF(S69=1,S192,\"\")","v":""}]
[null,null,null,null,"(複)軽減あり判定",null,{"$f":"G144","v":0},null,null,{"$f":"J144","v":0},null,null,{"$f":"M144","v":0},null,null,{"$f":"P144","v":0},null,null,{"$f":"S144","v":0}]
[null,null,null,null,"K均等割額軽減後",null,{"$f":"IF(DAT!$D$56>G186,G186,DAT!$D$56)","v":0},null,null,{"$f":"IF(DAT!$D$56>J186,J186,DAT!$D$56)","v":0},null,null,{"$f":"IF(DAT!$D$56>M186,M186,DAT!$D$56)","v":0},null,null,{"$f":"IF(DAT!$D$56>P186,P186,DAT!$D$56)","v":0},null,null,{"$f":"IF(DAT!$D$56>S186,S186,DAT!$D$56)","v":0}]
[null,null,null,null,"K年間保険料②軽減あり",null,{"$f":"IF(G69=1,G196,\"\")","v":""},null,null,{"$f":"IF(J69=1,J196,\"\")","v":""},null,null,{"$f":"IF(M69=1,M196,\"\")","v":""},null,null,{"$f":"IF(P69=1,P196,\"\")","v":""},null,null,{"$f":"IF(S69=1,S196,\"\")","v":""}]
[]
[null,null,null,null,"年間保険料③軽減終了",null,{"$f":"IF(G69=1,G186,\"\")","v":""},null,null,{"$f":"IF(J69=1,J186,\"\")","v":""},null,null,{"$f":"IF(M69=1,M186,\"\")","v":""},null,null,{"$f":"IF(P69=1,P186,\"\")","v":""},null,null,{"$f":"IF(S69=1,S186,\"\")","v":""}]
[]
[]
[null,null,null,null,"N被扶養軽減なし",null,{"$f":"G192","v":0},null,null,{"$f":"J192","v":0},null,null,{"$f":"M192","v":0},null,null,{"$f":"P192","v":0},null,null,{"$f":"S192","v":0}]
[null,null,null,null,"N'被扶養軽減あり",null,{"$f":"G207+G211","v":0},null,null,{"$f":"J207+J211","v":0},null,null,{"$f":"M207+M211","v":0},null,null,{"$f":"P207+P211","v":0},null,null,{"$f":"S207+S211","v":0}]
[null,null,null,null,"N''被扶養軽減終了",null,{"$f":"G208+G212","v":0},null,null,{"$f":"J208+J212","v":0},null,null,{"$f":"M208+M212","v":0},null,null,{"$f":"P208+P212","v":0},null,null,{"$f":"S208+S212","v":0}]
[]
[null,null,null,null,"N被扶養軽減なし",null,{"$f":"G184","v":0},null,null,{"$f":"J184","v":0},null,null,{"$f":"M184","v":0},null,null,{"$f":"P184","v":0},null,null,{"$f":"S184","v":0}]
[null,null,null,null,"N'A被扶養軽減あり",null,{"$f":"G196","v":0},null,null,{"$f":"J196","v":0},null,null,{"$f":"M196","v":0},null,null,{"$f":"P196","v":0},null,null,{"$f":"S196","v":0}]
[null,null,null,null,"N''A被扶養軽減終了",null,{"$f":"G184","v":0},null,null,{"$f":"J184","v":0},null,null,{"$f":"M184","v":0},null,null,{"$f":"P184","v":0},null,null,{"$f":"S184","v":0}]
[]
[null,null,null,null,"N被扶養軽減なし",null,{"$f":"G128","v":0},null,null,{"$f":"J128","v":0},null,null,{"$f":"M128","v":0},null,null,{"$f":"P128","v":0},null,null,{"$f":"S128","v":0}]
[null,null,null,null,"N'B被扶養軽減あり",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[null,null,null,null,"N''B被扶養軽減終了",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[null,null,null,null,"決定保険料",null,{"$f":"IF(G69=1,ROUNDDOWN(G202-ROUNDUP(G202*(12-G81)/12,0)+G203-ROUNDUP(G203*(12-G79)/12,0)+G204-ROUNDUP(G204*(12-G80)/12,0),-2),\"\")","v":""},null,null,{"$f":"IF(J69=1,ROUNDDOWN(J202-ROUNDUP(J202*(12-J81)/12,0)+J203-ROUNDUP(J203*(12-J79)/12,0)+J204-ROUNDUP(J204*(12-J80)/12,0),-2),\"\")","v":""},null,null,{"$f":"IF(M69=1,ROUNDDOWN(M202-ROUNDUP(M202*(12-M81)/12,0)+M203-ROUNDUP(M203*(12-M79)/12,0)+M204-ROUNDUP(M204*(12-M80)/12,0),-2),\"\")","v":""},null,null,{"$f":"IF(P69=1,ROUNDDOWN(P202-ROUNDUP(P202*(12-P81)/12,0)+P203-ROUNDUP(P203*(12-P79)/12,0)+P204-ROUNDUP(P204*(12-P80)/12,0),-2),\"\")","v":""},null,null,{"$f":"IF(S69=1,ROUNDDOWN(S202-ROUNDUP(S202*(12-S81)/12,0)+S203-ROUNDUP(S203*(12-S79)/12,0)+S204-ROUNDUP(S204*(12-S80)/12,0),-2),\"\")","v":""}]
[]
[null,"　・所得の種類によって、試算結果と実際の保険料額は異なる場合があります。\n　・被扶養者軽減は、はじめて制度に加入する前日に被用者保険の被扶養者であった方が対象となります。\n　・年度の途中で資格を喪失した場合は、実際の保険料額は月割計算で減額されます。"]

{"sheet":"DAT","index":1,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"権利者の許可なく、著作物の全部または一部の複製、転用、配布、販売等の二次利用を行うことを禁止します。"]
[null,"©　2018　吹上システム株式会社"]
[]
[]
[]
[]
[null,null,"年度設定値(YYYY/4/1)","軽減特例廃止日","子供20二十歳"]
[null,"資格取得日","2020-04-01","2019-04-01","2036-02-09"]
[]
[null,"賦課限度額",640000]
[]
[]
[null,"基礎控除",330000]
[]
[null,"高齢者特別控除",150000]
[]
[null,"年金所得額（６５歳未満）"]
[null,"0～  700,000 ",0,0,700000,null,0,1]
[null,"700,001～1,299,999 ","年金収入－700,000",700001,1299999,null,700000,2]
[null,"1,300,000～4,099,999 ","年金収入×0.75－375,000",1300000,4099999,0.75,375000,3]
[null,"4,100,000～7,699,999 ","年金収入×0.85－785,000",4100000,7699999,0.85,785000,4]
[null,"7,700,000～         .","年金収入×0.95－1,555,000",7700000,null,0.95,1555000,5]
[]
[null,"年金所得額（６５歳以上）"]
[null,"0～1,200,000 ",0,0,1200000,null,0,6]
[null,"1,200,001～3,299,999 ","年金収入－1,200,000",1200001,3299999,null,1200000,7]
[null,"3,300,000～4,099,999 ","年金収入×0.75－375,000",3300000,4099999,0.75,375000,8]
[null,"4,100,000～7,699,999 ","年金収入×0.85－785,000",4100000,7699999,0.85,785000,9]
[null,"7,700,000～         .","年金収入×0.95－1,555,000",7700000,null,0.95,1555000,10]
[]
[null,"給与所得額"]
[null,null,null,null,1618999,null,650000,1]
[null,null,null,1619000,1619999,null,969000,2]
[null,null,null,1620000,1621999,null,970000,3]
[null,null,null,1622000,1623999,null,972000,4]
[null,null,null,1624000,1627999,null,974000,5]
[null,null,null,1628000,1799999,0.6,0,6]
[null,null,null,1800000,3599999,0.7,180000,7]
[null,null,null,3600000,6599999,0.8,540000,8]
[null,null,null,6600000,9999999,0.9,1200000,9]
[null,"所得割率",9.5100000000000004E-2,10000000,null,null,2200000,10]
[]
[]
[]
[]
[]
[null,"均等割",null,null,null,null,"均等割減額"]
[null,"軽減なし",null,50304,"軽減なし"]
[null,"２割軽減",520000,40243,"２割軽減",null,10061]
[null,"５割軽減",285000,25152,"５割軽減",null,25152]
[null,"７．７５割軽減",330000,11318,"７．７５割軽減",null,38986]
[null,"７割軽減",800000,15091,"７割軽減",null,35213]
[null,"７割軽減",0,15091,"７割軽減",null,35213]
[null,"被扶養者の軽減",null,25152,"被扶養者の軽減"]