{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["city_select","jigyosha","jigyosha_hoken","senjusha","senjusha_hoken","hikaku","kubun"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"city_select","index":0,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"jigyosha!C19","v":"名古屋市"},"愛知県",null,"名古屋市","愛知県",null,"一宮市","愛知県",null,"多治見市","岐阜県",null,"尾張旭市","愛知県"]
[null,"均等割",3300,2000,null,{"$f":"ROUNDDOWN(3500-3500*5%,-2)","v":3300},{"$f":"1500+500","v":2000},null,3500,{"$f":"1500+500","v":2000},null,3500,2500,null,3500,2000]
[null,"所得割",7.7000000000000013E-2,2.0000000000000004E-2,null,{"$f":"(60%-60%*5%+20%)*10%","v":7.7000000000000013E-2},{"$f":"(40%-20%)*10%","v":2.0000000000000004E-2},null,{"$f":"60%*10%","v":0.06},{"$f":"40%*10%","v":4.0000000000000008E-2},null,{"$f":"60%*10%","v":0.06},{"$f":"40%*10%","v":4.0000000000000008E-2},null,{"$f":"60%*10%","v":0.06},{"$f":"40%*10%","v":4.0000000000000008E-2}]
[null,"按分率",0.8,0.2,null,0.8,0.2,null,0.6,0.40000000000000008,null,0.6,0.40000000000000008,null,0.6,0.40000000000000008]
[null,"調整控除等",0.04,0.01,null,0.04,0.01,null,0.03,0.02,null,0.03,0.02,null,0.03,0.02]
[null,"寄附金税額控除",0.08,0.02,null,0.08,0.02,null,0.06,0.04,null,0.06,0.04,null,0.06,0.04]
[null,"非課税限度額\n均等割",null,null,null,{"$f":"IF(F11+F12>0,350000*(F11+F12+1)+210000,350000)","v":350000},null,null,{"$f":"IF(I11+I12>0,320000*(I11+I12+1)+189000,320000)","v":320000},null,null,{"$f":"IF(L11+L12>0,320000*(L11+L12+1)+189000,320000)","v":320000},null,null,{"$f":"IF(O11+O12>0,320000*(O11+O12+1)+189000,320000)","v":320000}]

{"sheet":"jigyosha","index":1,"n_rows":60,"n_cols":45,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,{"$f":"C19","v":"名古屋市"},"確定申告",null,"専従者給与控除前"]
[null,null,null,null,null,"（所得税）",null,"専従者給与の額",{"$f":"-senjusha!I1","v":-960000},null,"雑損控除",null,"控除額","医療費の額",null,null,null,{"$f":"\"寄付金額 \"&TEXT(R3,\"#,###\")&\"円\"","v":"寄付金額 8,000円"},"寄付金額 9,000円","寄付金額 10,000円","寄付金額 11,000円","寄付金額 12,000円","寄付金額 13,000円","寄付金額 14,000円",null,0,0,null,{"$f":"Z2+1","v":1},{"$f":"AA2+1","v":1},null,{"$f":"AC2+1","v":2},{"$f":"AD2+1","v":2},null,{"$f":"AF2+1","v":3},{"$f":"AG2+1","v":3},null,{"$f":"AI2+1","v":4},{"$f":"AJ2+1","v":4},null,{"$f":"AL2+1","v":5},{"$f":"AM2+1","v":5},null,{"$f":"AO2+1","v":6},{"$f":"AP2+1","v":6}]
[null,null,null,null,null,"総所得金額",{"$f":"IF(SUM(I1:I3)<0,0,SUM(I1:I3))","v":0},"青色申告特別控除額",-650000,null,"医療費控除",{"$f":"IF(M3>N3,\n          0,\n          IF(N3-M3>2000000,\n              2000000,\n              N3-M3))","v":0},{"$f":"IF(G3<2000000,\nROUNDDOWN(G3*5%,0),\n100000)","v":0},null,null,"寄附金の額（L43）",null,8000,{"$f":"R3+1000","v":9000},10000,11000,12000,13000,14000,null,{"$f":"OFFSET($R$2,0,Z2)","v":"寄付金額 8,000円"},null,null,{"$f":"OFFSET($R$2,0,AC2)","v":"寄付金額 9,000円"},null,null,{"$f":"OFFSET($R$2,0,AF2)","v":"寄付金額 10,000円"},null,null,{"$f":"OFFSET($R$2,0,AI2)","v":"寄付金額 11,000円"},null,null,{"$f":"OFFSET($R$2,0,AL2)","v":"寄付金額 12,000円"},null,null,{"$f":"OFFSET($R$2,0,AO2)","v":"寄付金額 13,000円"},null,null,{"$f":"OFFSET($R$2,0,AR2)","v":"寄付金額 14,000円"}]
[null,null,null,null,null,"所得控除額",{"$f":"SUM(L2:L13)","v":380000},null,null,null,"社会保険料控除",{"$f":"jigyosha_hoken!S13","v":0},null,null,null,"寄附金がなかった場合の所得税額",0,0,0,0,0,0,0,0,null,{"$f":"OFFSET($R$3,0,Z2)","v":8000},null,null,{"$f":"OFFSET($R$3,0,AC2)","v":9000},null,null,{"$f":"OFFSET($R$3,0,AF2)","v":10000},null,null,{"$f":"OFFSET($R$3,0,AI2)","v":11000},null,null,{"$f":"OFFSET($R$3,0,AL2)","v":12000},null,null,{"$f":"OFFSET($R$3,0,AO2)","v":13000},null,null,{"$f":"OFFSET($R$3,0,AR2)","v":14000}]
[null,null,null,null,null,"課税所得金額",{"$f":"IF(G3-G4<0,0,ROUNDDOWN(G3-G4,-3))","v":0},null,null,null,"小規模企業共済等掛金控除",{"$f":"N5","v":0},null,0,null,"寄附金があった場合の所得税額",{"$f":"G10","v":0},0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$6,0,AA2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AD2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AG2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AJ2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AM2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AP2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AS2)","v":0}]
[null,null,null,null,null,"所得税額",{"$f":"IF(G5<=1950000,\n       G5*5%,\n       IF(G5<=3300000,\n            G5*10%-97500,\n            IF(G5<=6950000,\n                 G5*20%-427500,\n                 IF(G5<=9000000,\n                      G5*23%-636000,\n                      IF(G5<=18000000,\n                           G5*33%-1536000,\n                           IF(G5<=40000000,\n                                G5*40%-2796000,\n                                G5*45%-4796000))))))","v":0},null,null,null,"生命保険料控除",{"$f":"jigyosha_hoken!S8","v":0},null,null,null,"所得税の寄附金控除額",{"$f":"Q4-Q5","v":0},0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$10,0,AA2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AD2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AG2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AJ2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AM2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AP2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AS2)","v":0}]
[null,null,null,null,null,"住宅借入金等特別税額控除額",null,null,null,null,"地震保険料控除",{"$f":"jigyosha_hoken!S10","v":0},null,null,null,"寄附金がなかった場合の住民税額",0,0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$11,0,AA2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AD2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AG2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AJ2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AM2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AP2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AS2)","v":0}]
[null,null,null,null,null,"差引所得税額",{"$f":"IF(G7=0,\n       G6,\n       IF(G7>=G6,\n          0,\n          G6-G7))","v":0},null,null,null,"寄附金控除",{"$f":"IF(F1=\"ワンストップ特例\",0,IF(L43-2000<0,0,L43-2000))","v":0},null,null,null,"寄附金があった場合の住民税額",{"$f":"G32","v":0},0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$12,0,AA2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AD2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AG2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AJ2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AM2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AP2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AS2)","v":0}]
[null,null,null,null,null,"復興特別所得税額",{"$f":"IF(G8>0,ROUNDDOWN((G8)*2.1%,0),0)","v":0},null,null,null,"寡婦・寡夫控除",null,null,null,null,"住民税の寄附金控除額",{"$f":"Q7-Q8","v":0},0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$16,0,AA2)","v":8000},null,null,{"$f":"OFFSET($R$16,0,AD2)","v":9000},null,null,{"$f":"OFFSET($R$16,0,AG2)","v":10000},null,null,{"$f":"OFFSET($R$16,0,AJ2)","v":11000},null,null,{"$f":"OFFSET($R$16,0,AM2)","v":12000},null,null,{"$f":"OFFSET($R$16,0,AP2)","v":13000},null,null,{"$f":"OFFSET($R$16,0,AS2)","v":14000}]
[null,null,null,null,null,"所得税額及び復興特別所得税額",{"$f":"G8+G9","v":0},null,null,null,"勤労学生・障害者控除",null,null,null,null,"住民税の寄付金控除額（基礎）",{"$f":"G28","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"源泉徴収税額",null,null,null,null,"配偶者（特別）控除",null,null,null,null,"住民税の寄付金控除額（特例）",{"$f":"G29","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"申告納税額",{"$f":"IF(G10-G11>0,ROUNDDOWN(G10-G11,-2),G10-G11)","v":0},null,null,null,"扶養控除",null,null,null,null,"住民税の寄付金控除額（ﾜﾝｽﾄｯﾌﾟ）",{"$f":"G30","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"基礎控除",380000,null,null,null,"ふるさと納税の効果合計",{"$f":"Q6+Q9","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"予定納税額",null,null,null,null,"計",{"$f":"SUM(L2:L13)","v":380000},null,{"$f":"SUM(L2:L13)-L8","v":380000},null,"寄附金があった場合の支出額",{"$f":"L43+Q5+Q8","v":0},8000,9000,10000,11000,12000,13000,14000]
[null,null,null,null,null,"納める税金",{"$f":"IF(G12-G14>0,G12-G14,0)","v":0},null,null,null,null,null,null,null,null,"寄附金がなかった場合の支出額",0,0,0,0,0,0,0,0]
[null,null,null,null,null,"還付される税金",{"$f":"IF(G12-G14>0,0,G12-G14)","v":0},null,null,null,null,null,null,null,null,"差額",{"$f":"Q14-Q15","v":0},8000,9000,10000,11000,12000,13000,14000]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K2","v":"雑損控除"}]
[null,null,null,null,null,null,null,null,null,null,"医療費控除",{"$f":"L3","v":0}]
[null,null,"名古屋市","愛知県",null,"（住民税）",null,"市","県",null,"社会保険料控除",{"$f":"L4","v":0}]
[null,"均等割",{"$f":"city_select!C3","v":3300},{"$f":"city_select!D3","v":2000},null,"総所得金額",{"$f":"G3","v":0},null,null,null,"小規模企業共済等掛金控除",{"$f":"L5","v":0}]
[null,"所得割",{"$f":"city_select!C4","v":7.7000000000000013E-2},{"$f":"city_select!D4","v":2.0000000000000004E-2},null,"所得控除額（住民税）",{"$f":"SUM(L17:L28)","v":330000},null,null,null,"生命保険料控除",{"$f":"jigyosha_hoken!V8","v":0}]
[null,"按分率",{"$f":"city_select!C5","v":0.8},{"$f":"city_select!D5","v":0.2},null,"　　課税所得金額",{"$f":"IF(G20-G21<0,0,ROUNDDOWN(G20-G21,-3))","v":0},null,null,null,"地震保険料控除",{"$f":"jigyosha_hoken!V10","v":0}]
[null,"調整控除等",{"$f":"city_select!C6","v":0.04},{"$f":"city_select!D6","v":0.01},null,null,null,null,null,null,"寄附金控除"]
[null,"寄附金控除",{"$f":"city_select!C7","v":0.08},{"$f":"city_select!D7","v":0.02},null,"均等割　",{"$f":"H24+I24","v":0},{"$f":"IF(G20<=L35,0,C20)","v":0},{"$f":"IF(G20<=L35,0,D20)","v":0},null,"寡婦・寡夫控除"]
[null,null,null,null,null,"所得割　",0,{"$f":"IF(G20<=L36,0,ROUNDDOWN(G22*C21,0))","v":0},{"$f":"IF(G20<=L36,0,ROUNDDOWN(G22*D21,0))","v":0},null,"勤労学生・障害者控除"]
[null,null,null,null,null,"調整控除額　",0,{"$f":"IF(G25=0,\n      0,\n      IF(G22<=2000000,\n           IF(G22<L31,\n               G22*C23,\n               L31*C23),\n           IF(L31-(G22-2000000)<50000,\n               50000*C23,\n               (L31-(G22-2000000))*C23)))","v":0},{"$f":"IF(G25=0,\n      0,\n      IF(G22<=2000000,\n           IF(G22<L31,\n               G22*D23,\n               L31*D23),\n           IF(L31-(G22-2000000)<50000,\n               50000*D23,\n               (L31-(G22-2000000))*D23)))","v":0},null,"配偶者（特別）控除"]
[null,null,null,null,null,"住宅借入金等特別税額控除額",{"$f":"H27+I27","v":0},{"$f":"IF(G7=0,\n      0,\n      IF((G7-G6)<=0,\n          0,\n          IF((G7-G6)*C22>H50,\n              H50,\n              (G7-G6)*C22)))","v":0},{"$f":"IF(G7=0,\n      0,\n      IF((G7-G6)<=0,\n          0,\n          IF((G7-G6)*D22>I50,\n              I50,\n              (G7-G6)*D22)))","v":0},null,"扶養控除"]
[null,null,null,null,null,"寄附金税額控除",{"$f":"IF(G20<=L36,\n       0,\n       ROUNDUP(IF(L43-2000>0,\n                            IF(L43>G36,\n                                (G36-2000)*10%,\n                                (L43-2000)*10%),\n                            0),\n       -2))","v":0},{"$f":"G28*C24/(C24+D24)","v":0},{"$f":"G28*D24/(C24+D24)","v":0},null,"基礎控除",330000]
[null,null,null,null,null,"（特例）",{"$f":"ROUNDUP(\n   IF(L43-2000>0,\n       IF((L43-2000)*L48>G37,\n           G37,\n           (L43-2000)*L48),\n   0),\n-2)","v":0},{"$f":"G29*C22/(C22+D22)","v":0},{"$f":"G29*D22/(C22+D22)","v":0},null,"計",{"$f":"SUM(L17:L28)","v":330000}]
[null,null,null,null,null,"（ワンストップ特例）",0,{"$f":"IF(F1=\"ワンストップ特例\",H29*L55,0)","v":0},{"$f":"IF(F1=\"ワンストップ特例\",I29*L55,0)","v":0}]
[null,null,null,null,null,"差引所得割額",0,{"$f":"IF(H25-SUM(H26:H30)>0,ROUNDDOWN(H25-SUM(H26:H30),-2),0)","v":0},{"$f":"IF(I25-SUM(I26:I30)>0,ROUNDDOWN(I25-SUM(I26:I30),-2),0)","v":0},null,"人的控除の差額",{"$f":"SUM(L9:L13)-SUM(L24:L28)","v":50000}]
[null,null,null,null,null,"住民税額",0,{"$f":"H24+H31","v":0},{"$f":"I24+I31","v":0}]
[]
[]
[null,null,null,null,null,"所得税の寄付金控除の限度額",{"$f":"G3*40%","v":0},null,null,null,"非課税限度額　均等割",{"$f":"IF(L38+L39>0,350000*(L38+L39+1)+210000,350000)","v":350000}]
[null,null,null,null,null,"寄附金税額控除（基本）の限度額",{"$f":"G20*30%","v":0},null,null,null,"非課税限度額　所得割",{"$f":"IF(L38+L39>0,350000*(L38+L39+1)+320000,350000)","v":350000}]
[null,null,null,null,null,"寄附金税額控除（特例）の限度額",{"$f":"ROUNDUP((G25-G26)*20%,0)","v":0},{"$f":"G37*C22/(C22+D22)","v":0},{"$f":"G37*D22/(C22+D22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"控除対象配偶者",0]
[null,null,null,null,null,"課税総所得金額　　\n　　－　人的控除の差額の合計",null,null,null,null,"年少扶養親族を含む扶養親族"]
[null,null,null,null,null,"0円未満",0.9]
[null,null,null,null,null,"195万円以下",0.84894999999999998,null,null,null,"寄附金の限度額１",{"$f":"G37/L48+2000","v":2000}]
[null,null,null,null,null,"195万円超　　　330万円以下",0.79790000000000005,null,null,null,"寄附金の限度額２",{"$f":"IF(N42>=40000000+1000,\n       N42-40000000+1000,\n       IF(N42>=18000000+1000,\n          N42-18000000+1000,\n          IF(N42>=9000000+1000,\n             N42-9000000+1000,\n             IF(N42>=6950000+1000,\n                N42-6950000+1000,\n                IF(N42>=3300000+1000,\n                   N42-3300000+1000,\n                   IF(N42>=1950000+1000,\n                       N42-1950000+1000,\n                        N42))))))","v":0},null,{"$f":"IF(G3-N14<0,0,G3-N14)","v":0}]
[null,null,null,null,null,"330万円超　　　695万円以下",0.69579999999999997,null,null,null,"寄附金の額"]
[null,null,null,null,null,"695万円超　　　900万円以下",0.66517000000000004,null,null,null,"税額",{"$f":"G10+G32","v":0},null,null,null,null,null,{"$f":"\"iDeCo \"&TEXT(R45,\"#,###\")& \"円\"","v":"iDeCo 204,000円"},{"$f":"\"iDeCo \"&TEXT(S45,\"#,###\")& \"円\"","v":"iDeCo 216,000円"},"iDeCo 228,000円","iDeCo 240,000円","iDeCo 252,000円","iDeCo 264,000円","iDeCo 276,000円"]
[null,null,null,null,null,"900万円超　　1,800万円以下",0.56307000000000007,null,null,null,"寄附金の額と税額の合計",{"$f":"L43+L44","v":0},null,null,null,"iDeCoの額（N5）",0,{"$f":"R58","v":204000},{"$f":"S58","v":216000},228000,240000,252000,264000,276000]
[null,null,null,null,null,"1,800万円超　4,000万円以下",0.49159999999999998,null,null,null,null,null,null,null,null,"iDeCoがなかった場合の所得税額",0,0,0,0,0,0,0,0]
[null,null,null,null,null,"4,000万円超　",0.44055,null,null,null,"課税総所得金額　　\n－　人的控除の差額の合計",{"$f":"G22-L31","v":-50000},null,null,null,"iDeCoがあった場合の所得税額",{"$f":"G10","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"特例控除額の算出に用いる割合",{"$f":"IF(L47<0,G40,IF(L47<=1950000,G41,IF(L47<=3300000,G42,IF(L47<=6950000,G43,IF(L47<=9000000,G44,IF(L47<=18000000,G45,IF(L47<=40000000,G46,G47)))))))","v":0.9},null,null,null,"所得税のiDeCoの効果",{"$f":"Q46-Q47","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"※入居日によって変わるので確認すること",null,"市","県",null,null,null,null,null,null,"iDeCoがなかった場合の住民税額",0,0,0,0,0,0,0,0]
[null,null,null,null,null,"住民税の住宅借入金等\n特別税額控除の限度額",{"$f":"H50+I50","v":0},{"$f":"IF(G5*C23>H52,H52,G5*C23)","v":0},{"$f":"IF(G5*D23>I52,I52,G5*D23)","v":0},null,null,null,null,null,null,"iDeCoがあった場合の住民税額",{"$f":"G32","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住民税のiDeCoの効果",{"$f":"Q49-Q50","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,97500,{"$f":"G52*C22","v":78000},{"$f":"G52*D22","v":19500},null,null,null,null,null,null,"iDeCoがあった場合の税支出額",{"$f":"Q47+Q50","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"iDeCoがなかった場合の税支出額",0,0,0,0,0,0,0,0]
[null,null,null,null,null,"（ワンストップ特例）",null,null,null,null,null,null,null,null,null,"差額",{"$f":"Q52-Q53","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"課税総所得金額　　\n　　－　人的控除の差額の合計",null,null,null,null,"ワンストップ特例の計算に用いる割合",{"$f":"IF(L47<=1950000,\n  G56,\n      IF(L47<=3300000,\n           G57,\n           IF(L47<=6950000,\n               G58,\n               IF(L47<=9000000,\n                   G59,\n                   G60))))","v":6.0133105601036581E-2}]
[null,null,null,null,null,"195万円以下",{"$f":"5.105/84.895","v":6.0133105601036581E-2},"5.105/84.895"]
[null,null,null,null,null,"195万円超　　　330万円以下",{"$f":"10.21/79.79","v":0.12796089735555835},"10.21/79.79",null,null,null,null,null,null,null,"月額",null,17000,{"$f":"R57+1000","v":18000},19000,20000,21000,22000,23000]
[null,null,null,null,null,"330万円超　　　695万円以下",{"$f":"20.42/69.58","v":0.29347513653348667},"20.42/69.58",null,null,null,null,null,null,null,"年額",null,{"$f":"R57*12","v":204000},{"$f":"S57*12","v":216000},228000,240000,252000,264000,276000]
[null,null,null,null,null,"695万円超　　　900万円以下",{"$f":"23.483/66.517","v":0.35303756934317548},"23.483/66.517"]
[null,null,null,null,null,"900万円超　　1,800万円以下",{"$f":"33.693/56.307","v":0.59838030795460595},"33.693/56.307"]

{"sheet":"jigyosha_hoken","index":2,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,16,1,18],[1,19,1,21],[2,16,2,17],[2,19,2,20],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,1,14,1],[13,2,14,2],[2,7,2,8],[2,9,3,9],[2,10,3,10],[13,6,14,6],[2,6,3,6],[13,7,13,8],[13,9,14,9],[13,10,14,10],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6],[20,7,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10]]}
[null,null,null,null,null,null,null,null,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の名称","保険等の\n種類","保険期間\n又は\n年金支払期間","保険等の\n契約者の氏名","保険金等の受取人",null,"新・旧の区分","あなたが本年中に支払った保険料等の金額（分配を受けた剰余金等の控除後の金額）\n（ａ）",null,null,null,null,null,"計算過程",null,"控除額","計算過程",null,"控除額"]
[null,null,null,null,null,null,null,"氏名","あなたとの\n続柄",null,null,null,null,"一般の生命保険料","新",{"$f":"SUMIFS(K:K,B:B,\"=\"&N4,J:J,\"=\"&O4)","v":0},{"$f":"IF(P4<=20000,\n       P4,\n       IF(P4<=40000,\n            ROUNDUP(P4/2,0)+10000,\n            IF(P4<=80000,\n                   ROUNDUP(P4/4,0)+20000,\n                   40000)))","v":0},{"$f":"IF(Q4+Q5<=40000,Q4+Q5,40000)","v":0},null,{"$f":"IF(P4<=12000,\n       P4,\n       IF(P4<=32000,\n            ROUNDUP(P4/2,0)+6000,\n            IF(P4<=56000,\n                   ROUNDUP(P4/4,0)+14000,\n                   28000)))","v":0},{"$f":"IF(T4+T5<=28000,T4+T5,28000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"一般の生命保険料","旧",{"$f":"SUMIFS(K:K,B:B,\"=\"&N5,J:J,\"=\"&O5)","v":0},{"$f":"IF(P5<=25000,\n       P5,\n       IF(P5<=50000,\n            ROUNDUP(P5/2,0)+12500,\n            IF(P5<=100000,\n                   ROUNDUP(P5/4,0)+25000,\n                   50000)))","v":0},{"$f":"IF(Q5>R4,Q5,R4)","v":0},null,{"$f":"IF(P5<=15000,\n       P5,\n       IF(P5<=40000,\n            ROUNDUP(P5/2,0)+7500,\n            IF(P5<=70000,\n                   ROUNDUP(P5/4,0)+17500,\n                   35000)))","v":0},{"$f":"IF(T5>U4,T5,U4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"介護医療保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N6,J:J,\"=\"&O6)","v":0},{"$f":"IF(P6<=20000,\n       P6,\n       IF(P6<=40000,\n            ROUNDUP(P6/2,0)+10000,\n            IF(P6<=80000,\n                   ROUNDUP(P6/4,0)+20000,\n                   40000)))","v":0},{"$f":"Q6","v":0},null,{"$f":"IF(P6<=12000,\n       P6,\n       IF(P6<=32000,\n            ROUNDUP(P6/2,0)+6000,\n            IF(P6<=56000,\n                   ROUNDUP(P6/4,0)+14000,\n                   28000)))","v":0},{"$f":"T6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"個人年金保険料","新",{"$f":"SUMIFS(K:K,B:B,\"=\"&N7,J:J,\"=\"&O7)","v":0},{"$f":"IF(P7<=20000,\n       P7,\n       IF(P7<=40000,\n            ROUNDUP(P7/2,0)+10000,\n            IF(P7<=80000,\n                   ROUNDUP(P7/4,0)+20000,\n                   40000)))","v":0},{"$f":"IF(Q7+Q8<=40000,Q7+Q8,40000)","v":0},null,{"$f":"IF(P7<=12000,\n       P7,\n       IF(P7<=32000,\n            ROUNDUP(P7/2,0)+6000,\n            IF(P7<=56000,\n                   ROUNDUP(P7/4,0)+14000,\n                   28000)))","v":0},{"$f":"IF(T7+T8<=28000,T7+T8,28000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"個人年金保険料","旧",{"$f":"SUMIFS(K:K,B:B,\"=\"&N8,J:J,\"=\"&O8)","v":0},{"$f":"IF(P8<=25000,\n       P8,\n       IF(P8<=50000,\n            ROUNDUP(P8/2,0)+12500,\n            IF(P8<=100000,\n                   ROUNDUP(P8/4,0)+25000,\n                   50000)))","v":0},{"$f":"IF(Q8>R7,Q8,R7)","v":0},{"$f":"IF(R5+R6+R8<=120000,R5+R6+R8,120000)","v":0},{"$f":"IF(P8<=15000,\n       P8,\n       IF(P8<=40000,\n            ROUNDUP(P8/2,0)+7500,\n            IF(P8<=70000,\n                   ROUNDUP(P8/4,0)+17500,\n                   35000)))","v":0},{"$f":"IF(T8>U7,T8,U7)","v":0},{"$f":"IF(U5+U6+U8<=70000,U5+U6+U8,70000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"地震保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N9)","v":0},{"$f":"IF(P9<=50000,P9,50000)","v":0},{"$f":"Q9","v":0},null,{"$f":"IF(P9<=50000,ROUNDUP(P9/2,0),25000)","v":0},{"$f":"T9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"旧長期損害保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N10)","v":0},{"$f":"IF(P10<=10000,\n       P10,\n       IF(P10<=20000,\n            ROUNDUP(P10/2,0)+5000,\n            15000))","v":0},{"$f":"Q10","v":0},{"$f":"IF(R9+R10<=50000,R9+R10,50000)","v":0},{"$f":"IF(P10<=5000,\n       P10,\n       IF(P10<=15000,\n            ROUNDUP(P10/2,0)+2500,\n            10000))","v":0},{"$f":"T10","v":0},{"$f":"IF(U9+U10<=50000,U9+U10,50000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"国民健康保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"国民年金保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"その他社会保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N13)","v":0},null,null,{"$f":"SUM(P11:P13)","v":0},null,null,{"$f":"SUM(P11:P13)","v":0}]
[null,"区分","契約番号\n証券記号番号","保険会社等\nの名称","保険等\nの種類（目的）","保険期間","保険等の\n契約者の氏名","保険等の対象となった",null,"地震保険料又は\n旧長期損害保険料の区分","あなたが本年中に支払った保険料等のうち、左欄の区分に係る金額（分配を受けた剰余金等の控除後の金額）\nⒶ"]
[null,null,null,null,null,null,null,"家屋等に居住又は家財を利用している者等の氏名","あなたとの\n続柄"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B19=\"\",\"\",B19)","v":""}]
[]
[null,"社会保険の種類",null,"保険料支払先の名称",null,null,"保険料を\n負担することに\nなっている人","氏名","あなたとの\n続柄",null,"あなたが本年中に支払った保険料の金額"]

{"sheet":"senjusha","index":3,"n_rows":60,"n_cols":45,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,{"$f":"C19","v":"名古屋市"},"確定申告",null,"給与の総額",{"$f":"hikaku!B2","v":960000}]
[null,null,null,null,null,"（所得税）",null,"年調給与額",{"$f":"IF(I1<=1618999,I1,IF(I1<=1619999,I1-MOD(I1-1619000,1000),IF(I1<=1623999,I1-MOD(I1-1620000,2000),IF(I1<=6599999,I1-MOD(I1-1624000,4000),I1))))","v":960000},null,"雑損控除",null,"控除額","医療費の額",null,null,null,{"$f":"\"寄付金額 \"&TEXT(R3,\"#,###\")&\"円\"","v":"寄付金額 8,000円"},"寄付金額 9,000円","寄付金額 10,000円","寄付金額 11,000円","寄付金額 12,000円","寄付金額 13,000円","寄付金額 14,000円",null,0,0,null,{"$f":"Z2+1","v":1},{"$f":"AA2+1","v":1},null,{"$f":"AC2+1","v":2},{"$f":"AD2+1","v":2},null,{"$f":"AF2+1","v":3},{"$f":"AG2+1","v":3},null,{"$f":"AI2+1","v":4},{"$f":"AJ2+1","v":4},null,{"$f":"AL2+1","v":5},{"$f":"AM2+1","v":5},null,{"$f":"AO2+1","v":6},{"$f":"AP2+1","v":6}]
[null,null,null,null,null,"総所得金額",{"$f":"I3","v":310000},"給与所得控除後の給与等の金額",{"$f":"IF(I2<=650999,0,IF(I2<=1618999,I2-650000,IF(I2<=1619999,I2*60%-2400,IF(I2<=1621999,I2*60%-2000,IF(I2<=1623999,I2*60%-1200,IF(I2<=1627999,I2*60%-400,IF(I2<=1799999,I2*60%,IF(I2<=3599999,I2*70%-180000,IF(I2<=6599999,I2*80%-540000,IF(I2<=9999999,I2*90%-1200000,IF(I2<=20000000,I2-2200000)))))))))))","v":310000},null,"医療費控除",{"$f":"IF(M3>N3,\n          0,\n          IF(N3-M3>2000000,\n              2000000,\n              N3-M3))","v":0},{"$f":"IF(G3<2000000,\nROUNDDOWN(G3*5%,0),\n100000)","v":15500},null,null,"寄附金の額（L43）",null,8000,{"$f":"R3+1000","v":9000},10000,11000,12000,13000,14000,null,{"$f":"OFFSET($R$2,0,Z2)","v":"寄付金額 8,000円"},null,null,{"$f":"OFFSET($R$2,0,AC2)","v":"寄付金額 9,000円"},null,null,{"$f":"OFFSET($R$2,0,AF2)","v":"寄付金額 10,000円"},null,null,{"$f":"OFFSET($R$2,0,AI2)","v":"寄付金額 11,000円"},null,null,{"$f":"OFFSET($R$2,0,AL2)","v":"寄付金額 12,000円"},null,null,{"$f":"OFFSET($R$2,0,AO2)","v":"寄付金額 13,000円"},null,null,{"$f":"OFFSET($R$2,0,AR2)","v":"寄付金額 14,000円"}]
[null,null,null,null,null,"所得控除額",{"$f":"SUM(L2:L13)","v":380000},null,null,null,"社会保険料控除",{"$f":"senjusha_hoken!S13","v":0},null,null,null,"寄附金がなかった場合の所得税額",0,0,0,0,0,0,0,0,null,{"$f":"OFFSET($R$3,0,Z2)","v":8000},null,null,{"$f":"OFFSET($R$3,0,AC2)","v":9000},null,null,{"$f":"OFFSET($R$3,0,AF2)","v":10000},null,null,{"$f":"OFFSET($R$3,0,AI2)","v":11000},null,null,{"$f":"OFFSET($R$3,0,AL2)","v":12000},null,null,{"$f":"OFFSET($R$3,0,AO2)","v":13000},null,null,{"$f":"OFFSET($R$3,0,AR2)","v":14000}]
[null,null,null,null,null,"課税所得金額",{"$f":"IF(G3-G4<0,0,ROUNDDOWN(G3-G4,-3))","v":0},null,null,null,"小規模企業共済等掛金控除",{"$f":"N5","v":0},null,0,null,"寄附金があった場合の所得税額",{"$f":"G10","v":0},0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$6,0,AA2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AD2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AG2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AJ2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AM2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AP2)","v":0},null,null,{"$f":"OFFSET($R$6,0,AS2)","v":0}]
[null,null,null,null,null,"所得税額",{"$f":"IF(G5<=1950000,\n       G5*5%,\n       IF(G5<=3300000,\n            G5*10%-97500,\n            IF(G5<=6950000,\n                 G5*20%-427500,\n                 IF(G5<=9000000,\n                      G5*23%-636000,\n                      IF(G5<=18000000,\n                           G5*33%-1536000,\n                           IF(G5<=40000000,\n                                G5*40%-2796000,\n                                G5*45%-4796000))))))","v":0},null,null,null,"生命保険料控除",{"$f":"senjusha_hoken!S8","v":0},null,null,null,"所得税の寄附金控除額",{"$f":"Q4-Q5","v":0},0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$10,0,AA2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AD2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AG2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AJ2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AM2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AP2)","v":0},null,null,{"$f":"OFFSET($R$10,0,AS2)","v":0}]
[null,null,null,null,null,"住宅借入金等特別税額控除額",null,null,null,null,"地震保険料控除",{"$f":"senjusha_hoken!S10","v":0},null,null,null,"寄附金がなかった場合の住民税額",0,0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$11,0,AA2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AD2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AG2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AJ2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AM2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AP2)","v":0},null,null,{"$f":"OFFSET($R$11,0,AS2)","v":0}]
[null,null,null,null,null,"差引所得税額",{"$f":"IF(G7=0,\n       G6,\n       IF(G7>=G6,\n          0,\n          G6-G7))","v":0},null,null,null,"寄附金控除",{"$f":"IF(F1=\"ワンストップ特例\",0,IF(L43-2000<0,0,L43-2000))","v":0},null,null,null,"寄附金があった場合の住民税額",{"$f":"G32","v":0},0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$12,0,AA2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AD2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AG2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AJ2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AM2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AP2)","v":0},null,null,{"$f":"OFFSET($R$12,0,AS2)","v":0}]
[null,null,null,null,null,"復興特別所得税額",{"$f":"IF(G8>0,ROUNDDOWN((G8)*2.1%,0),0)","v":0},null,null,null,"寡婦・寡夫控除",null,null,null,null,"住民税の寄附金控除額",{"$f":"Q7-Q8","v":0},0,0,0,0,0,0,0,null,null,{"$f":"OFFSET($R$16,0,AA2)","v":8000},null,null,{"$f":"OFFSET($R$16,0,AD2)","v":9000},null,null,{"$f":"OFFSET($R$16,0,AG2)","v":10000},null,null,{"$f":"OFFSET($R$16,0,AJ2)","v":11000},null,null,{"$f":"OFFSET($R$16,0,AM2)","v":12000},null,null,{"$f":"OFFSET($R$16,0,AP2)","v":13000},null,null,{"$f":"OFFSET($R$16,0,AS2)","v":14000}]
[null,null,null,null,null,"所得税額及び復興特別所得税額",{"$f":"G8+G9","v":0},null,null,null,"勤労学生・障害者控除",null,null,null,null,"住民税の寄付金控除額（基礎）",{"$f":"G28","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"源泉徴収税額",null,null,null,null,"配偶者（特別）控除",null,null,null,null,"住民税の寄付金控除額（特例）",{"$f":"G29","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"申告納税額",{"$f":"IF(G10-G11>0,ROUNDDOWN(G10-G11,-2),G10-G11)","v":0},null,null,null,"扶養控除",null,null,null,null,"住民税の寄付金控除額（ﾜﾝｽﾄｯﾌﾟ）",{"$f":"G30","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"基礎控除",380000,null,null,null,"ふるさと納税の効果合計",{"$f":"Q6+Q9","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"予定納税額",null,null,null,null,"計",{"$f":"SUM(L2:L13)","v":380000},null,{"$f":"SUM(L2:L13)-L8","v":380000},null,"寄附金があった場合の支出額",{"$f":"L43+Q5+Q8","v":0},8000,9000,10000,11000,12000,13000,14000]
[null,null,null,null,null,"納める税金",{"$f":"IF(G12-G14>0,G12-G14,0)","v":0},null,null,null,null,null,null,null,null,"寄附金がなかった場合の支出額",0,0,0,0,0,0,0,0]
[null,null,null,null,null,"還付される税金",{"$f":"IF(G12-G14>0,0,G12-G14)","v":0},null,null,null,null,null,null,null,null,"差額",{"$f":"Q14-Q15","v":0},8000,9000,10000,11000,12000,13000,14000]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K2","v":"雑損控除"}]
[null,null,null,null,null,null,null,null,null,null,"医療費控除",{"$f":"L3","v":0}]
[null,null,{"$f":"jigyosha!C19","v":"名古屋市"},"愛知県",null,"（住民税）",null,"市","県",null,"社会保険料控除",{"$f":"L4","v":0}]
[null,"均等割",{"$f":"city_select!C3","v":3300},{"$f":"city_select!D3","v":2000},null,"総所得金額",{"$f":"G3","v":310000},null,null,null,"小規模企業共済等掛金控除",{"$f":"L5","v":0}]
[null,"所得割",{"$f":"city_select!C4","v":7.7000000000000013E-2},{"$f":"city_select!D4","v":2.0000000000000004E-2},null,"所得控除額（住民税）",{"$f":"SUM(L17:L28)","v":330000},null,null,null,"生命保険料控除",{"$f":"senjusha_hoken!V8","v":0}]
[null,"按分率",{"$f":"city_select!C5","v":0.8},{"$f":"city_select!D5","v":0.2},null,"　　課税所得金額",{"$f":"IF(G20-G21<0,0,ROUNDDOWN(G20-G21,-3))","v":0},null,null,null,"地震保険料控除",{"$f":"senjusha_hoken!V10","v":0}]
[null,"調整控除等",{"$f":"city_select!C6","v":0.04},{"$f":"city_select!D6","v":0.01},null,null,null,null,null,null,"寄附金控除"]
[null,"寄附金控除",{"$f":"city_select!C7","v":0.08},{"$f":"city_select!D7","v":0.02},null,"均等割　",{"$f":"H24+I24","v":0},{"$f":"IF(G20<=L35,0,C20)","v":0},{"$f":"IF(G20<=L35,0,D20)","v":0},null,"寡婦・寡夫控除"]
[null,null,null,null,null,"所得割　",0,{"$f":"IF(G20<=L36,0,ROUNDDOWN(G22*C21,0))","v":0},{"$f":"IF(G20<=L36,0,ROUNDDOWN(G22*D21,0))","v":0},null,"勤労学生・障害者控除"]
[null,null,null,null,null,"調整控除額　",0,{"$f":"IF(G25=0,\n      0,\n      IF(G22<=2000000,\n           IF(G22<L31,\n               G22*C23,\n               L31*C23),\n           IF(L31-(G22-2000000)<50000,\n               50000*C23,\n               (L31-(G22-2000000))*C23)))","v":0},{"$f":"IF(G25=0,\n      0,\n      IF(G22<=2000000,\n           IF(G22<L31,\n               G22*D23,\n               L31*D23),\n           IF(L31-(G22-2000000)<50000,\n               50000*D23,\n               (L31-(G22-2000000))*D23)))","v":0},null,"配偶者（特別）控除"]
[null,null,null,null,null,"住宅借入金等特別税額控除額",{"$f":"H27+I27","v":0},{"$f":"IF(G7=0,\n      0,\n      IF((G7-G6)<=0,\n          0,\n          IF((G7-G6)*C22>H50,\n              H50,\n              (G7-G6)*C22)))","v":0},{"$f":"IF(G7=0,\n      0,\n      IF((G7-G6)<=0,\n          0,\n          IF((G7-G6)*D22>I50,\n              I50,\n              (G7-G6)*D22)))","v":0},null,"扶養控除"]
[null,null,null,null,null,"寄附金税額控除",{"$f":"IF(G20<=L36,\n       0,\n       ROUNDUP(IF(L43-2000>0,\n                            IF(L43>G36,\n                                (G36-2000)*10%,\n                                (L43-2000)*10%),\n                            0),\n       -2))","v":0},{"$f":"G28*C24/(C24+D24)","v":0},{"$f":"G28*D24/(C24+D24)","v":0},null,"基礎控除",330000]
[null,null,null,null,null,"（特例）",{"$f":"ROUNDUP(\n   IF(L43-2000>0,\n       IF((L43-2000)*L48>G37,\n           G37,\n           (L43-2000)*L48),\n   0),\n-2)","v":0},{"$f":"G29*C22/(C22+D22)","v":0},{"$f":"G29*D22/(C22+D22)","v":0},null,"計",{"$f":"SUM(L17:L28)","v":330000}]
[null,null,null,null,null,"（ワンストップ特例）",0,{"$f":"IF(F1=\"ワンストップ特例\",H29*L55,0)","v":0},{"$f":"IF(F1=\"ワンストップ特例\",I29*L55,0)","v":0}]
[null,null,null,null,null,"差引所得割額",0,{"$f":"IF(H25-SUM(H26:H30)>0,ROUNDDOWN(H25-SUM(H26:H30),-2),0)","v":0},{"$f":"IF(I25-SUM(I26:I30)>0,ROUNDDOWN(I25-SUM(I26:I30),-2),0)","v":0},null,"人的控除の差額",{"$f":"SUM(L9:L13)-SUM(L24:L28)","v":50000}]
[null,null,null,null,null,"住民税額",0,{"$f":"H24+H31","v":0},{"$f":"I24+I31","v":0}]
[]
[]
[null,null,null,null,null,"所得税の寄付金控除の限度額",{"$f":"G3*40%","v":124000},null,null,null,"非課税限度額　均等割",{"$f":"IF(L38+L39>0,350000*(L38+L39+1)+210000,350000)","v":350000}]
[null,null,null,null,null,"寄附金税額控除（基本）の限度額",{"$f":"G20*30%","v":93000},null,null,null,"非課税限度額　所得割",{"$f":"IF(L38+L39>0,350000*(L38+L39+1)+320000,350000)","v":350000}]
[null,null,null,null,null,"寄附金税額控除（特例）の限度額",{"$f":"ROUNDUP((G25-G26)*20%,0)","v":0},{"$f":"G37*C22/(C22+D22)","v":0},{"$f":"G37*D22/(C22+D22)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"控除対象配偶者",0]
[null,null,null,null,null,"課税総所得金額　　\n　　－　人的控除の差額の合計",null,null,null,null,"年少扶養親族を含む扶養親族"]
[null,null,null,null,null,"0円未満",0.9]
[null,null,null,null,null,"195万円以下",0.84894999999999998,null,null,null,"寄附金の限度額１",{"$f":"G37/L48+2000","v":2000}]
[null,null,null,null,null,"195万円超　　　330万円以下",0.79790000000000005,null,null,null,"寄附金の限度額２",{"$f":"IF(N42>=40000000+1000,\n       N42-40000000+1000,\n       IF(N42>=18000000+1000,\n          N42-18000000+1000,\n          IF(N42>=9000000+1000,\n             N42-9000000+1000,\n             IF(N42>=6950000+1000,\n                N42-6950000+1000,\n                IF(N42>=3300000+1000,\n                   N42-3300000+1000,\n                   IF(N42>=1950000+1000,\n                       N42-1950000+1000,\n                        N42))))))","v":0},null,{"$f":"IF(G3-N14<0,0,G3-N14)","v":0}]
[null,null,null,null,null,"330万円超　　　695万円以下",0.69579999999999997,null,null,null,"寄附金の額",0]
[null,null,null,null,null,"695万円超　　　900万円以下",0.66517000000000004,null,null,null,"税額",{"$f":"G10+G32","v":0},null,null,null,null,null,{"$f":"\"iDeCo \"&TEXT(R45,\"#,###\")& \"円\"","v":"iDeCo 204,000円"},{"$f":"\"iDeCo \"&TEXT(S45,\"#,###\")& \"円\"","v":"iDeCo 216,000円"},"iDeCo 228,000円","iDeCo 240,000円","iDeCo 252,000円","iDeCo 264,000円","iDeCo 276,000円"]
[null,null,null,null,null,"900万円超　　1,800万円以下",0.56307000000000007,null,null,null,"寄附金の額と税額の合計",{"$f":"L43+L44","v":0},null,null,null,"iDeCoの額（N5）",0,{"$f":"R58","v":204000},{"$f":"S58","v":216000},228000,240000,252000,264000,276000]
[null,null,null,null,null,"1,800万円超　4,000万円以下",0.49159999999999998,null,null,null,null,null,null,null,null,"iDeCoがなかった場合の所得税額",0,0,0,0,0,0,0,0]
[null,null,null,null,null,"4,000万円超　",0.44055,null,null,null,"課税総所得金額　　\n－　人的控除の差額の合計",{"$f":"G22-L31","v":-50000},null,null,null,"iDeCoがあった場合の所得税額",{"$f":"G10","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"特例控除額の算出に用いる割合",{"$f":"IF(L47<0,G40,IF(L47<=1950000,G41,IF(L47<=3300000,G42,IF(L47<=6950000,G43,IF(L47<=9000000,G44,IF(L47<=18000000,G45,IF(L47<=40000000,G46,G47)))))))","v":0.9},null,null,null,"所得税のiDeCoの効果",{"$f":"Q46-Q47","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"※入居日によって変わるので確認すること",null,"市","県",null,null,null,null,null,null,"iDeCoがなかった場合の住民税額",0,0,0,0,0,0,0,0]
[null,null,null,null,null,"住民税の住宅借入金等\n特別税額控除の限度額",{"$f":"H50+I50","v":0},{"$f":"IF(G5*C23>H52,H52,G5*C23)","v":0},{"$f":"IF(G5*D23>I52,I52,G5*D23)","v":0},null,null,null,null,null,null,"iDeCoがあった場合の住民税額",{"$f":"G32","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住民税のiDeCoの効果",{"$f":"Q49-Q50","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,97500,{"$f":"G52*C22","v":78000},{"$f":"G52*D22","v":19500},null,null,null,null,null,null,"iDeCoがあった場合の税支出額",{"$f":"Q47+Q50","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"iDeCoがなかった場合の税支出額",0,0,0,0,0,0,0,0]
[null,null,null,null,null,"（ワンストップ特例）",null,null,null,null,null,null,null,null,null,"差額",{"$f":"Q52-Q53","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,"課税総所得金額　　\n　　－　人的控除の差額の合計",null,null,null,null,"ワンストップ特例の計算に用いる割合",{"$f":"IF(L47<=1950000,\n  G56,\n      IF(L47<=3300000,\n           G57,\n           IF(L47<=6950000,\n               G58,\n               IF(L47<=9000000,\n                   G59,\n                   G60))))","v":6.0133105601036581E-2}]
[null,null,null,null,null,"195万円以下",{"$f":"5.105/84.895","v":6.0133105601036581E-2},"5.105/84.895"]
[null,null,null,null,null,"195万円超　　　330万円以下",{"$f":"10.21/79.79","v":0.12796089735555835},"10.21/79.79",null,null,null,null,null,null,null,"月額",null,17000,{"$f":"R57+1000","v":18000},19000,20000,21000,22000,23000]
[null,null,null,null,null,"330万円超　　　695万円以下",{"$f":"20.42/69.58","v":0.29347513653348667},"20.42/69.58",null,null,null,null,null,null,null,"年額",null,{"$f":"R57*12","v":204000},{"$f":"S57*12","v":216000},228000,240000,252000,264000,276000]
[null,null,null,null,null,"695万円超　　　900万円以下",{"$f":"23.483/66.517","v":0.35303756934317548},"23.483/66.517"]
[null,null,null,null,null,"900万円超　　1,800万円以下",{"$f":"33.693/56.307","v":0.59838030795460595},"33.693/56.307"]

{"sheet":"senjusha_hoken","index":4,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,16,1,18],[1,19,1,21],[2,16,2,17],[2,19,2,20],[20,6,21,6],[20,7,21,7],[20,8,21,8],[20,9,21,9],[20,10,21,10],[2,7,2,8],[2,9,3,9],[2,10,3,10],[2,6,3,6],[13,6,14,6],[13,7,13,8],[13,9,14,9],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[13,10,14,10],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5]]}
[null,null,null,null,null,null,null,null,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の名称","保険等の\n種類","保険期間\n又は\n年金支払期間","保険等の\n契約者の氏名","保険金等の受取人",null,"新・旧の区分","あなたが本年中に支払った保険料等の金額（分配を受けた剰余金等の控除後の金額）\n（ａ）",null,null,null,null,null,"計算過程",null,"控除額","計算過程",null,"控除額"]
[null,null,null,null,null,null,null,"氏名","あなたとの\n続柄",null,null,null,null,"一般の生命保険料","新",{"$f":"SUMIFS(K:K,B:B,\"=\"&N4,J:J,\"=\"&O4)","v":0},{"$f":"IF(P4<=20000,\n       P4,\n       IF(P4<=40000,\n            ROUNDUP(P4/2,0)+10000,\n            IF(P4<=80000,\n                   ROUNDUP(P4/4,0)+20000,\n                   40000)))","v":0},{"$f":"IF(Q4+Q5<=40000,Q4+Q5,40000)","v":0},null,{"$f":"IF(P4<=12000,\n       P4,\n       IF(P4<=32000,\n            ROUNDUP(P4/2,0)+6000,\n            IF(P4<=56000,\n                   ROUNDUP(P4/4,0)+14000,\n                   28000)))","v":0},{"$f":"IF(T4+T5<=28000,T4+T5,28000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"一般の生命保険料","旧",{"$f":"SUMIFS(K:K,B:B,\"=\"&N5,J:J,\"=\"&O5)","v":0},{"$f":"IF(P5<=25000,\n       P5,\n       IF(P5<=50000,\n            ROUNDUP(P5/2,0)+12500,\n            IF(P5<=100000,\n                   ROUNDUP(P5/4,0)+25000,\n                   50000)))","v":0},{"$f":"IF(Q5>R4,Q5,R4)","v":0},null,{"$f":"IF(P5<=15000,\n       P5,\n       IF(P5<=40000,\n            ROUNDUP(P5/2,0)+7500,\n            IF(P5<=70000,\n                   ROUNDUP(P5/4,0)+17500,\n                   35000)))","v":0},{"$f":"IF(T5>U4,T5,U4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"介護医療保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N6,J:J,\"=\"&O6)","v":0},{"$f":"IF(P6<=20000,\n       P6,\n       IF(P6<=40000,\n            ROUNDUP(P6/2,0)+10000,\n            IF(P6<=80000,\n                   ROUNDUP(P6/4,0)+20000,\n                   40000)))","v":0},{"$f":"Q6","v":0},null,{"$f":"IF(P6<=12000,\n       P6,\n       IF(P6<=32000,\n            ROUNDUP(P6/2,0)+6000,\n            IF(P6<=56000,\n                   ROUNDUP(P6/4,0)+14000,\n                   28000)))","v":0},{"$f":"T6","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"個人年金保険料","新",{"$f":"SUMIFS(K:K,B:B,\"=\"&N7,J:J,\"=\"&O7)","v":0},{"$f":"IF(P7<=20000,\n       P7,\n       IF(P7<=40000,\n            ROUNDUP(P7/2,0)+10000,\n            IF(P7<=80000,\n                   ROUNDUP(P7/4,0)+20000,\n                   40000)))","v":0},{"$f":"IF(Q7+Q8<=40000,Q7+Q8,40000)","v":0},null,{"$f":"IF(P7<=12000,\n       P7,\n       IF(P7<=32000,\n            ROUNDUP(P7/2,0)+6000,\n            IF(P7<=56000,\n                   ROUNDUP(P7/4,0)+14000,\n                   28000)))","v":0},{"$f":"IF(T7+T8<=28000,T7+T8,28000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"個人年金保険料","旧",{"$f":"SUMIFS(K:K,B:B,\"=\"&N8,J:J,\"=\"&O8)","v":0},{"$f":"IF(P8<=25000,\n       P8,\n       IF(P8<=50000,\n            ROUNDUP(P8/2,0)+12500,\n            IF(P8<=100000,\n                   ROUNDUP(P8/4,0)+25000,\n                   50000)))","v":0},{"$f":"IF(Q8>R7,Q8,R7)","v":0},{"$f":"IF(R5+R6+R8<=120000,R5+R6+R8,120000)","v":0},{"$f":"IF(P8<=15000,\n       P8,\n       IF(P8<=40000,\n            ROUNDUP(P8/2,0)+7500,\n            IF(P8<=70000,\n                   ROUNDUP(P8/4,0)+17500,\n                   35000)))","v":0},{"$f":"IF(T8>U7,T8,U7)","v":0},{"$f":"IF(U5+U6+U8<=70000,U5+U6+U8,70000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"地震保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N9)","v":0},{"$f":"IF(P9<=50000,P9,50000)","v":0},{"$f":"Q9","v":0},null,{"$f":"IF(P9<=50000,ROUNDUP(P9/2,0),25000)","v":0},{"$f":"T9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"旧長期損害保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N10)","v":0},{"$f":"IF(P10<=10000,\n       P10,\n       IF(P10<=20000,\n            ROUNDUP(P10/2,0)+5000,\n            15000))","v":0},{"$f":"Q10","v":0},{"$f":"IF(R9+R10<=50000,R9+R10,50000)","v":0},{"$f":"IF(P10<=5000,\n       P10,\n       IF(P10<=15000,\n            ROUNDUP(P10/2,0)+2500,\n            10000))","v":0},{"$f":"T10","v":0},{"$f":"IF(U9+U10<=50000,U9+U10,50000)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"国民健康保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"国民年金保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N12)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"その他社会保険料",null,{"$f":"SUMIFS(K:K,B:B,\"=\"&N13)","v":0},null,null,{"$f":"SUM(P11:P13)","v":0},null,null,{"$f":"SUM(P11:P13)","v":0}]
[null,"区分","契約番号\n証券記号番号","保険会社等\nの名称","保険等\nの種類（目的）","保険期間","保険等の\n契約者の氏名","保険等の対象となった",null,"地震保険料又は\n旧長期損害保険料の区分","あなたが本年中に支払った保険料等のうち、左欄の区分に係る金額（分配を受けた剰余金等の控除後の金額）\nⒶ"]
[null,null,null,null,null,null,null,"家屋等に居住又は家財を利用している者等の氏名","あなたとの\n続柄"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B19=\"\",\"\",B19)","v":""}]
[]
[null,"社会保険の種類",null,"保険料支払先の名称",null,null,"保険料を\n負担することに\nなっている人","氏名","あなたとの\n続柄",null,"あなたが本年中に支払った保険料の金額"]

{"sheet":"hikaku","index":5,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,4],[2,5,2,7]]}
[]
[null,960000]
[null,null,"専従者",null,null,"事業主"]
[null,"給与の額","所得金額","所得税","住民税","所得金額","所得税","住民税","税額合計"]
[null,null,{"$f":"senjusha!G3","v":310000},{"$f":"senjusha!G10","v":0},{"$f":"senjusha!G32","v":0},{"$f":"jigyosha!G3","v":0},{"$f":"jigyosha!G10","v":0},{"$f":"jigyosha!G32","v":0},{"$f":"D5+E5+G5+H5","v":0}]
[80000,{"$f":"A6*12","v":960000},310000,0,0,0,0,0,0]
[{"$f":"A6+10000","v":90000},{"$f":"A7*12","v":1080000},430000,2552,12500,0,0,0,15052]
[{"$f":"A7+10000","v":100000},{"$f":"A8*12","v":1200000},550000,8678,24100,0,0,0,32778]
[110000,1320000,670000,14804,35700,0,0,0,50504]
[120000,1440000,790000,20930,47400,0,0,0,68330]
[130000,1560000,910000,27056,59000,0,0,0,86056]
[140000,1680000,1008000,32059,68500,0,0,0,100559]
[150000,1800000,1080000,35735,75500,0,0,0,111235]
[160000,1920000,1164000,40023,83600,0,0,0,123623]
[170000,2040000,1248000,44311,91700,0,0,0,136011]
[180000,2160000,1332000,48599,99900,0,0,0,148499]
[190000,2280000,1416000,52887,108100,0,0,0,160987]
[200000,2400000,1500000,57176,116200,0,0,0,173376]
[210000,2520000,1584000,61464,124300,0,0,0,185764]

{"sheet":"kubun","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"新"]
[null,"旧"]
[]
[null,"新"]
[null,"旧"]