{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["計算シート","入力例"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[33,3,33,4],[34,3,36,4],[38,3,40,4],[23,3,27,4],[4,9,4,10],[5,9,9,10],[11,9,15,10],[4,3,4,4],[22,3,22,4],[5,3,9,4],[11,3,15,4]]}
["年末調整　保険料控除額算出表"]
[]
["【一般の生命保険料】",null,null,null,null,null,"【個人年金保険料】"]
[]
[null,"区分","本年中に支払った\n保険料等の額","控除額",null,null,null,"区分","本年中に支払った\n保険料等の額","控除額"]
[null,"新",null,null,null,null,null,"新"]
[]
[]
[]
[]
[null,"合計（Ａ）",{"$f":"SUM(C6:C10)","v":0},"①",{"$f":"IF(C11<=20000,C11,IF(C11>=80001,40000,IF(AND(C11>=20001,C11<=40000),ROUNDUP(C11/2+10000,0),IF(AND(C11>=40001,C11<=80000),ROUNDUP(C11/4+20000,0)))))","v":0},null,null,"合計（Ｄ）",{"$f":"SUM(I6:I10)","v":0},"④",{"$f":"IF(I11<=20000,I11,IF(I11>=80001,40000,IF(AND(I11>=20001,I11<=40000),ROUNDUP(I11/2+10000,0),IF(AND(I11>=40001,I11<=80000),ROUNDUP(I11/4+20000,0)))))","v":0}]
[null,"旧",null,null,null,null,null,"旧"]
[]
[]
[]
[]
[null,"合計（Ｂ）",{"$f":"SUM(C12:C16)","v":0},"②",{"$f":"IF(C17<=25000,C17,IF(C17>=100001,50000,IF(AND(C17>=25001,C17<=50000),ROUNDUP(C17/2+12500,0),IF(AND(C17>=50001,C17<=100000),ROUNDUP(C17/4+25000,0)))))","v":0},null,null,"合計（Ｅ）",{"$f":"SUM(I12:I16)","v":0},"⑤",{"$f":"IF(I17<=25000,I17,IF(I17>=100001,50000,IF(AND(I17>=25001,I17<=50000),ROUNDUP(I17/2+12500,0),IF(AND(I17>=50001,I17<=100000),ROUNDUP(I17/4+25000,0)))))","v":0}]
[null,"控除額計（①＋②）",null,"③",{"$f":"IF(E11+E17<=40000,E11+E17,IF(E11+E17>=40001,40000))","v":0},null,null,"控除額計（④＋⑤）",null,"⑥",{"$f":"IF(K11+K17<=40000,K11+K17,IF(K11+K17>=40001,40000))","v":0}]
[null,"控除決定額",null,null,null,null,null,"控除決定額",null,"ハ",{"$f":"IF(K17>=K18,K17,IF(K17<K18,K18))","v":0}]
[]
["【介護医療保険料】",null,null,null,null,null,null,"【生命保険料控除　合計】"]
[]
[null,"区分",null,null,null,null,null,"イロハ",{"$f":"IF(E19+E29+K19<=120000,E19+E29+K19,IF(E19+E29+K19>=120001,120000))","v":0}]
[null,"新"]
[]
[]
[null,null,null,null,null,null,null,"【マクロ設定】"]
[null,null,null,null,null,null,null,"入力リセット：ｃｔｒｌ　＋　ｄ"]
[null,"合計（Ｃ）",{"$f":"SUM(C24:C28)","v":0},"ロ",{"$f":"IF(C29<=20000,C29,IF(C29>=80001,40000,IF(AND(C29>=20001,C29<=40000),ROUNDUP(C29/2+10000,0),IF(AND(C29>=40001,C29<=80000),ROUNDUP(C29/4+20000,0)))))","v":0}]
[null,null,null,null,null,null,null,"入力箇所　"]
[]
["【地震保険料控除】"]
[]
[null,"区分","本年中に支払った\n保険料等の額","控除額"]
[null,"地震"]
[]
[]
[null,"合計",{"$f":"SUM(C35:C37)","v":0},"Ｂ",{"$f":"IF(C38<=50000,C38,IF(C38>=50001,50000))","v":0}]
[null,"旧長期"]
[]
[]
[null,"合計",{"$f":"SUM(C39:C41)","v":0},"Ｃ",{"$f":"IF(C42<=10000,C42,IF(AND(C42>=10001,C42<=20000),ROUNDUP(C42/2+5000,0),15000))","v":0}]
[null,"控除額計（Ｂ＋Ｃ）",null,null,{"$f":"IF(E38+E42<=50000,E38+E42,IF(E38+E42>=50001,50000))","v":0}]

{"sheet":"入力例","index":1,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[22,3,22,4],[23,3,27,4],[33,3,33,4],[34,3,36,4],[38,3,40,4],[4,3,4,4],[4,9,4,10],[5,3,9,4],[5,9,9,10],[11,3,15,4],[11,9,15,10]]}
["年末調整　保険料控除額算出表"]
[]
["【一般の生命保険料】",null,null,null,null,null,"【個人年金保険料】"]
[]
[null,"区分","本年中に支払った\n保険料等の額","控除額",null,null,null,"区分","本年中に支払った\n保険料等の額","控除額"]
[null,"新",58000,null,null,null,null,"新",64250]
[]
[]
[]
[]
[null,"合計（Ａ）",{"$f":"SUM(C6:C10)","v":58000},"①",{"$f":"IF(C11<=20000,C11,IF(C11>=80001,40000,IF(AND(C11>=20001,C11<=40000),ROUNDUP(C11/2+10000,0),IF(AND(C11>=40001,C11<=80000),ROUNDUP(C11/4+20000,0)))))","v":34500},null,null,"合計（Ｄ）",{"$f":"SUM(I6:I10)","v":64250},"④",{"$f":"IF(I11<=20000,I11,IF(I11>=80001,40000,IF(AND(I11>=20001,I11<=40000),ROUNDUP(I11/2+10000,0),IF(AND(I11>=40001,I11<=80000),ROUNDUP(I11/4+20000,0)))))","v":36063}]
[null,"旧",45000,null,null,null,null,"旧",120000]
[]
[]
[]
[]
[null,"合計（Ｂ）",{"$f":"SUM(C12:C16)","v":45000},"②",{"$f":"IF(C17<=25000,C17,IF(C17>=100001,50000,IF(AND(C17>=25001,C17<=50000),ROUNDUP(C17/2+12500,0),IF(AND(C17>=50001,C17<=100000),ROUNDUP(C17/4+25000,0)))))","v":35000},null,null,"合計（Ｅ）",{"$f":"SUM(I12:I16)","v":120000},"⑤",{"$f":"IF(I17<=25000,I17,IF(I17>=100001,50000,IF(AND(I17>=25001,I17<=50000),ROUNDUP(I17/2+12500,0),IF(AND(I17>=50001,I17<=100000),ROUNDUP(I17/4+25000,0)))))","v":50000}]
[null,"控除額計（①＋②）",null,"③",{"$f":"IF(E11+E17<=40000,E11+E17,IF(E11+E17>=40001,40000))","v":40000},null,null,"控除額計（④＋⑤）",null,"⑥",{"$f":"IF(K11+K17<=40000,K11+K17,IF(K11+K17>=40001,40000))","v":40000}]
[null,"控除決定額",null,"イ",{"$f":"IF(E17>=E18,E17,IF(E17<E18,E18))","v":40000},null,null,"控除決定額",null,"ハ",{"$f":"IF(K17>=K18,K17,IF(K17<K18,K18))","v":50000}]
[]
["【介護医療保険料】",null,null,null,null,null,null,"【生命保険料控除　合計】"]
[]
[null,"区分","本年中に支払った\n保険料等の額","控除額",null,null,null,"イロハ",{"$f":"IF(E19+E29+K19<=120000,E19+E29+K19,IF(E19+E29+K19>=120001,120000))","v":120000}]
[null,"新",58000]
[]
[]
[null,null,null,null,null,null,null,"【マクロ設定】"]
[null,null,null,null,null,null,null,"入力リセット：ｃｔｒｌ　＋　ｄ"]
[null,"合計（Ｃ）",{"$f":"SUM(C24:C28)","v":58000},"ロ",{"$f":"IF(C29<=20000,C29,IF(C29>=80001,40000,IF(AND(C29>=20001,C29<=40000),ROUNDUP(C29/2+10000,0),IF(AND(C29>=40001,C29<=80000),ROUNDUP(C29/4+20000,0)))))","v":34500}]
[null,null,null,null,null,null,null,"入力箇所　"]
[]
["【地震保険料控除】"]
[]
[null,"区分","本年中に支払った\n保険料等の額","控除額"]
[null,"地震",13850]
[]
[]
[null,"合計",{"$f":"SUM(C35:C37)","v":13850},"Ｂ",{"$f":"IF(C38<=50000,C38,IF(C38>=50001,50000))","v":13850}]
[null,"旧長期",12549]
[]
[]
[null,"合計",{"$f":"SUM(C39:C41)","v":12549},"Ｃ",{"$f":"IF(C42<=10000,C42,IF(AND(C42>=10001,C42<=20000),ROUNDUP(C42/2+5000,0),15000))","v":11275}]
[null,"控除額計（Ｂ＋Ｃ）",null,null,{"$f":"IF(E38+E42<=50000,E38+E42,IF(E38+E42>=50001,50000))","v":25125}]