{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["１枚目","2枚目"],"not_rendered":{"images":113,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"１枚目","index":0,"n_rows":44,"n_cols":11,"rows_kept":44,"merged":[[0,0,0,8],[2,0,3,0],[2,1,3,9],[4,0,5,0],[4,1,5,9],[7,0,12,3],[7,4,8,5],[7,6,8,7],[7,8,8,9],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[12,6,14,8],[16,1,16,3],[16,5,16,7],[16,8,16,9],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,0,25,4],[25,5,25,6],[26,0,26,4],[27,0,27,4],[27,5,27,6],[29,0,29,1],[30,0,30,1],[32,0,32,1],[34,0,34,1],[36,0,36,1],[38,0,38,1],[40,0,40,1],[42,0,42,1],[43,0,44,2]]}
["令和　  　年分　医療費控除の明細書"]
[null,null,"※この控除を受ける方は、セルフメディケーション税制は受けられません。"]
["住所　　　　　　　　                                                             　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　"]
[]
["氏名　　　　　　　　　                                                             　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　"]
[]
[]
["１　医療費通知に関する事項\n医療費通知を添付する場合、右記の(1)～(3)を記入してください。\n（注） 医療費通知には前年支払分の医療費が記載されている場合がありますのでご注意ください。",{"$nulls":3},"(1)医療費通知に記載された\n医療費の額（自己負担額）",null,"(2) (1)のうちその年中\nに実際に支払った\n医療費の額",null,"(3) (2)のうち保険金等\nで補填される金額"]
[]
[{"$nulls":5},"円",null,"円",null,"円"]
[]
[]
[{"$nulls":6},"領収書1枚ごとではなく、医療を受けた方・病院等ごとにまとめて記入できます"]
[]
[]
["２　医療費（上記１以外）の明細（通知書に記載されているものは記入しないでください）"]
["(1)医療費を\n受けた方の氏名","(2)病院薬局などの\n名称",null,null,"(3)医療費の区分","(4)支払った医療費の額",null,null,"(5)左のうち保険金等で\n補填される金額"]
[{"$nulls":5},{"v":40000,"d":"40,000 "},null,"円",null,"円"]
[{"$nulls":5},{"v":20000,"d":"20,000 "},null,"円",null,"円"]
[{"$nulls":7},"円",null,"円"]
[{"$nulls":5},{"v":250000,"d":"250,000 "},null,"円",null,"円"]
[{"$nulls":7},"円",null,"円"]
[{"$nulls":7},"円",null,"円"]
[{"$nulls":7},"円",null,"円"]
[{"$nulls":7},"円",null,"円"]
["２　　の　　合　　計",{"$nulls":4},{"$f":"IF(SUM(G18:G25)<>0,SUM(G18:G25),\"\")","v":""},null,"円",{"$f":"IF(SUM(I18:I25)=\"\",\"\",IF(SUM(I18:I25)<>0,SUM(I18:I25),\"\"))","v":""},"円"]
[]
["医　　療　　費　　の　　合　　計",{"$nulls":4},{"$f":"IF(SUM(F26,G10,'2枚目'!E30)<>0,SUM(F26,G10,'2枚目'!E30),\"\")","v":""},null,"円",{"$f":"IF(SUM(I26,I10,'2枚目'!G30)<>0,SUM(I26,I10,'2枚目'!G30),\"\")","v":""},"円"]
[]
["3　控除額の計算"]
["①支払った医療費",null,{"$f":"F28","v":""},"円",{"$nulls":5},{"$f":"IF(SUM(G18:G25,G10,'2枚目'!E30)<>0,SUM(G18:G25,G10,'2枚目'!E30),\"0\")","v":"0"},{"$f":"IF(SUM(I18:I25,I10,'2枚目'!G30)<>0,SUM(I18:I25,I10,'2枚目'!G30),\"0\")","v":"0"}]
[]
["②保険金などで\n補てんされる金額",null,{"$f":"I28","v":""},"円"]
[]
["③差引金額（①－②）",null,{"$f":"IF(AND(C31=\"\",C33=\"\"),\"\",IF(J31-K31>0,J31-K31,IF(J31-K31<0,\"\",IF(J31-K31=0,\"0\"))))","v":""},"円"]
[]
["④所得金額の合計額",null,null,"円"]
[]
["⑤所得金額×5%\n（④×5％）",null,{"$f":"IF(C37=\"\",\"\",IF(ROUNDDOWN(C37*0.05,0)<=0,0,ROUNDDOWN(C37*0.05,0)))","v":""},"円"]
[]
["⑥ ⑤と10万円のいずれか少ない方の金額",null,{"$f":"IF(C37=\"\",\"\",IF((ROUNDDOWN(C37*0.05,0))<=0,\"0\",IF(C39<100000,C39,100000)))","v":""},"円"]
[]
["医療費控除額（③－⑥）",null,{"$f":"IF(C37=\"\",\"\",IF(SUM(C35)-SUM(C41)<=0,\"0\",SUM(C35)-SUM(C41)))","v":""},"円"]
["（控除額は最高で２００万円）"]

{"sheet":"2枚目","index":1,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[0,0,1,6],[3,0,4,0],[3,1,4,7],[5,0,6,0],[5,1,6,7],[8,1,8,2],[8,4,8,5],[8,6,8,7],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,0,29,3]]}
["令和　  　年分　医療費控除の明細書"]
[]
[null,null,"※この控除を受ける方は、セルフメディケーション税制は受けられません。"]
["住所　　　　　　　　                                                             　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　"]
[]
["氏名　　　　　　　　　                                                             　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　"]
[]
["２　医療費（上記１以外）の明細（通知書に記載されているものは記入しないでください）"]
["(1)医療費を\n受けた方の氏名","(2)病院薬局などの\n名称",null,"(3)医療費の区分","(4)支払った医療費の額",null,"(5)左のうち保険金等で\n補てんされる金額"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
[{"$nulls":5},"円",null,"円"]
["合　　計",{"$nulls":3},{"$f":"IF(SUM(E10:E29)<>0,SUM(E10:E29),\"\")","v":""},"円",{"$f":"IF(SUM(G10:G29)=\"\",\"\",IF(SUM(G10:G29)<>0,SUM(G10:G29),\"\"))","v":""},"円"]