{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["data","allowance","front","backN","backE"],"not_rendered":{"images":3,"macros":1,"defined_names":5,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"data","index":0,"n_rows":36,"n_cols":4,"rows_kept":36,"merged":[[1,1,1,3],[1,5,1,6],[2,2,2,3],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[12,2,12,3],[13,2,13,3]]}
[]
[null,"Income Tax Calculation For Financial Year 2024-25"]
[null,"Name of Employee","Pramod Kumar Saini"]
[null,"Designation of Employee","Teacher"]
[null,"PAN of Employee","ABCDE1234E"]
[null,"DDO Office / School of Employee","G S S S Malutana"]
[null,"Basic pay of the month March/2024 ",49300]
[null,"Annual Increment (AGI) applicable from Month","2024-07-01"]
[null,"Surrender of 15 PLs for FY 2024-25 (If Yes,  select received in month)","No","2024-07-01"]
[null,"Ad hoc bonus for FY 2023-24 (If Yes, select  received for months)","Yes",12]
[null,"GPF premia as slab ? (If No, Fill premia)","No",5000]
[null,"SI premia as slab ? (If No, Fill premia)","No",7000]
[null,"Whether a Gazzeted officer ?","No"]
[null,"Group Insurance Scheme (GPA) premia",700]
[]
[null,"Calulation as per Tax Regime","Old Regime","New Regime"]
[null,"Gross Salary... (Including all allowance u/s 17... i.e. Govt. contribution towards NPS)",982634,982634]
[null,"HRA exemption as per eligibility u/s 10(13-A) whether living in … Rented House",54324,0]
[null,"Standard Deduction u/s 16(ia)",50000,75000]
[null,"Interest payable on borrowed capital u/s 24b",0,0]
[null,"Interest from saving Account / Deposits / Income tax refund",0,0]
[null,"Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",0,0]
[null,"80CCD(2) Employer contribution towards New Pension Scheme",0,0]
[null,"80CCD(1B) Additional contribution towards New Pension Scheme",0,0]
[null,"80D Deduction in respect of Health Insurance premia",0,0]
[null,"80DD Maintenance including medical treatment of a dependent who is a person with disability ",0,0]
[null,"80DDB Medical treatment of specified disease",0,0]
[null,"80E Interest on loan taken for higher education ",0,0]
[null,"80G Donations to certain funds, charitable institutions, etc.  ",0,0]
[null,"80TTA Interest on saving bank Accounts in case of other than Resident senior citizens",0,0]
[null,"80U In case of a person with disability",0,0]
[null,"Any other provision of Chapter VI‐A",0,0]
[null,"Relief u/s 89 (Ensure to submit Form 10E)",0,0]
[null,"Total Taxes deducted at Sources",0,0]
[null,"Amount Payable",{"$f":"backE!W46","v":60488},{"$f":"backN!W48","v":42394}]
[null,"Refund",{"$f":"backE!W47","v":0},{"$f":"backN!W49","v":0}]

{"sheet":"allowance","index":1,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[0,1,0,6],[1,1,1,6],[2,1,3,1],[2,2,2,3],[2,4,2,5]]}
[null,":: Allowances Table ::"]
[]
[null,"Month/\nYear","DA Rate",null,"HRA Rate",null,"CCA"]
[null,null,"Due","Drawn","Due","Drawn","City"]
[null,"2024-01-01",50,46,0,0,"Jaipur",{"$nulls":3},{"$f":"ROUND((C5-D5)/100*front!$B$7,0)","v":1972},0]
[null,"2024-02-01",50,46,0,0,"Jaipur",{"$nulls":3},{"$f":"ROUND((C6-D6)/100*front!$B$7,0)","v":1972},0]
[null,"2024-03-01",50,50,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C7-D7)/100*front!$B$7,0)","v":0},{"$f":"ROUND((E7-F7)/100*front!B7,0)","v":0},{"$f":"IF(E7>10,G7,\"\")","v":""}]
[null,"2024-04-01",50,50,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C8-D8)/100*front!B8,0)","v":0},{"$f":"ROUND((E8-F8)/100*front!B8,0)","v":0},{"$f":"IF(E8>10,G8,\"\")","v":""}]
[null,"2024-05-01",50,50,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C9-D9)/100*front!B9,0)","v":0},{"$f":"ROUND((E9-F9)/100*front!B9,0)","v":0},""]
[null,"2024-06-01",50,50,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C10-D10)/100*front!B10,0)","v":0},{"$f":"ROUND((E10-F10)/100*front!B10,0)","v":0},""]
[null,"2024-07-01",53,50,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C11-D11)/100*front!B11,0)","v":1524},{"$f":"ROUND((E11-F11)/100*front!B11,0)","v":0},""]
[null,"2024-08-01",53,50,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C12-D12)/100*front!B12,0)","v":1524},{"$f":"ROUND((E12-F12)/100*front!B12,0)","v":0},""]
[null,"2024-09-01",53,50,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C13-D13)/100*front!B13,0)","v":1524},{"$f":"ROUND((E13-F13)/100*front!B13,0)","v":0},""]
[null,"2024-10-01",53,50,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C14-D14)/100*front!B14,0)","v":1524},{"$f":"ROUND((E14-F14)/100*front!B14,0)","v":0},""]
[null,"2024-11-01",53,53,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C15-D15)/100*front!B15,0)","v":0},{"$f":"ROUND((E15-F15)/100*front!B15,0)","v":0},""]
[null,"2024-12-01",53,53,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C16-D16)/100*front!B16,0)","v":0},{"$f":"ROUND((E16-F16)/100*front!B16,0)","v":0},""]
[null,"2025-01-01",53,53,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C17-D17)/100*front!B17,0)","v":0},{"$f":"ROUND((E17-F17)/100*front!B17,0)","v":0},""]
[null,"2025-02-01",53,53,9,9,"Jaipur",{"$nulls":3},{"$f":"ROUND((C18-D18)/100*front!B18,0)","v":0},{"$f":"ROUND((E18-F18)/100*front!B18,0)","v":0},""]

{"sheet":"front","index":2,"n_rows":28,"n_cols":26,"rows_kept":28,"merged":[[0,0,0,25],[1,0,1,25],[2,0,2,25],[3,0,3,4],[3,5,3,11],[3,12,3,17],[3,18,3,25],[4,0,4,4],[4,5,4,11],[4,12,4,17],[4,18,4,25]]}
[]
[]
["Annual Salary Statement of the Financial Year 2024-25"]
["Name of Employee :",{"$nulls":4},{"$f":"data!C3","v":"Pramod Kumar Saini"},{"$nulls":6},"PAN of Employee :",{"$nulls":5},{"$f":"data!C5","v":"ABCDE1234E"}]
["Designation of Employee :",{"$nulls":4},{"$f":"data!C4","v":"Teacher"},{"$nulls":6},"DDO Office :",{"$nulls":5},{"$f":"data!C6","v":"G S S S Malutana"}]
["Month-Year","Basic",null,null,"DA","HRA","CCA","RoP","Bonus","Arrear",null,"Gross \nSalary","GPF/\nGPF 2004","GPFL","SIP","SIL/SII","GIS &\n Hit Nidhi","RGHS","LIC","I TAX",{"$nulls":3},"Total \nDeduction","Net \nPayment","TV No"]
["2024-03-01",49300,null,null,24650,4437,0,{"$nulls":4},{"$f":"B7+C7+D7+E7+F7+G7+I7+J7+K7-H7","v":78387},5000,null,7000,null,null,658,{"$nulls":5},{"$f":"M7+N7+O7+P7+Q7+R7+S7+T7+U7+V7+W7","v":12658},{"$f":"L7-X7","v":65729}]
["2024-04-01",49300,null,null,24650,4437,0,{"$nulls":4},{"$f":"B8+C8+D8+E8+F8+G8+I8+J8+K8-H8","v":78387},5000,null,7000,null,700,658,{"$nulls":5},{"$f":"M8+N8+O8+P8+Q8+R8+S8+T8+U8+V8+W8","v":13358},{"$f":"L8-X8","v":65029}]
["2024-05-01",49300,null,null,24650,4437,0,{"$nulls":4},78387,5000,null,7000,null,null,658,{"$nulls":5},12658,65729]
["2024-06-01",49300,null,null,24650,4437,0,{"$nulls":4},78387,5000,null,7000,null,null,658,{"$nulls":5},12658,65729]
["2024-07-01",50800,null,null,25400,4572,0,{"$nulls":4},80772,5000,null,7000,null,null,658,{"$nulls":5},12658,68114]
["2024-08-01",50800,null,null,25400,4572,0,{"$nulls":4},80772,5000,null,7000,null,null,658,{"$nulls":5},12658,68114]
["2024-09-01",50800,null,null,25400,4572,0,{"$nulls":4},80772,5000,null,7000,null,null,658,{"$nulls":5},12658,68114]
["2024-10-01",50800,null,null,25400,4572,0,{"$nulls":4},80772,5000,null,7000,null,null,658,{"$nulls":5},12658,68114]
["2024-11-01",50800,null,null,26924,4572,0,{"$nulls":4},82296,5000,null,7000,null,null,658,{"$nulls":5},12658,69638]
["2024-12-01",50800,null,null,26924,4572,0,{"$nulls":4},82296,5000,null,7000,null,250,658,{"$nulls":5},12908,69388]
["2025-01-01",50800,null,null,26924,4572,0,{"$nulls":4},82296,5000,null,7000,null,null,658,{"$nulls":5},12658,69638]
["2025-02-01",50800,null,null,26924,4572,0,{"$nulls":4},82296,5000,null,7000,null,null,658,{"$nulls":5},12658,69638]
["DA Arr",{"$nulls":3},3944,{"$nulls":6},3944,3944,{"$nulls":10},3944,0]
["DA Arr",{"$nulls":3},6096,{"$nulls":6},6096,6096,{"$nulls":10},6096,0]
["Surrender",0,null,null,0,{"$nulls":6},0,{"$nulls":11},0,0]
["Bonus",{"$nulls":7},6774,null,null,6774,1694,{"$nulls":10},1694,5080]
["HRAArr",{"$nulls":4},0,{"$nulls":5},0,{"$nulls":11},0,0]
["Arrear",{"$nulls":10},0,{"$nulls":11},0,0]
["Arrear",{"$nulls":10},0,{"$nulls":11},0,0]
["Total",{"$f":"SUM(B7:B25)","v":{"v":603600,"d":"603,600"}},{"$f":"SUM(C7:C25)","v":0},0,{"v":317936,"d":"317,936"},{"v":54324,"d":"54,324"},0,0,{"v":6774,"d":"6,774"},0,0,{"v":982634,"d":"982,634"},{"v":71734,"d":"71,734"},0,{"v":84000,"d":"84,000"},0,950,{"v":7896,"d":"7,896"},0,0,0,0,0,{"v":164580,"d":"164,580"},{"v":818054,"d":"818,054"}]
[]
[{"$nulls":12},"Employee Signature",{"$nulls":12},"DDO Signature with Official SEAL"]

{"sheet":"backN","index":3,"n_rows":51,"n_cols":23,"rows_kept":51,"merged":[[1,1,1,22],[2,1,2,20],[2,21,2,22],[3,1,3,20],[3,21,3,22],[4,2,4,20],[5,2,5,20],[6,2,6,20],[7,2,7,20],[8,2,8,20],[9,2,9,20],[10,2,10,20],[11,2,11,20],[12,2,12,20],[13,3,13,20],[14,4,14,20],[15,4,15,20],[16,4,16,20],[17,4,17,20],[18,4,18,20],[19,3,19,20],[20,3,20,20],[21,3,21,20],[22,3,22,20],[23,3,23,20],[24,3,24,20],[25,3,25,20],[26,3,26,20],[27,3,27,20],[28,3,28,20],[29,2,29,20],[30,2,30,20],[31,2,31,17],[31,18,31,20],[32,2,32,7],[32,8,32,9],[32,10,32,13],[32,14,32,17],[32,18,32,20],[33,2,33,7],[33,8,33,9],[33,10,33,13],[33,14,33,17],[33,18,33,20],[34,2,34,7],[34,8,34,9],[34,10,34,13],[34,14,34,17],[34,18,34,20],[35,2,35,7],[35,8,35,9],[35,10,35,13],[35,14,35,17],[35,18,35,20],[36,2,36,7],[36,8,36,9],[36,10,36,13],[36,14,36,17],[36,18,36,20],[37,2,37,7],[37,8,37,9],[37,10,37,13],[37,14,37,17],[37,18,37,20],[38,2,38,7],[38,8,38,9],[38,10,38,13],[38,14,38,17],[38,18,38,20],[39,2,39,20],[40,2,40,20],[41,2,41,20],[42,2,42,20],[43,2,43,20],[44,2,44,20],[45,2,45,20],[46,2,46,20],[47,2,47,20],[48,2,48,20]]}
[]
[null,"Income Tax Calculation for Financial Year 2024-25 Assessment Year 2025-26"]
[null,{"$f":"\"Name (Designation) : \"&front!$F$4&\" (\"&front!$F$5&\")\"","v":"Name (Designation) : Pramod Kumar Saini (Teacher)"},{"$nulls":19},{"$f":"\"PAN : \"&front!$S$4","v":"PAN : ABCDE1234E"}]
[null,{"$f":"\"DDO Office : \"&front!$S$5","v":"DDO Office : G S S S Malutana"},{"$nulls":19},"As per New Tax Regim"]
[null,"1.","Gross Salary... (Including all allowance u/s 17... i.e. Govt. contribution towards NPS)",{"$nulls":18},{"$f":"data!D17","v":{"v":982634,"d":"₹ 982,634"}}]
[null,"2.","HRA exemption as per eligibility u/s 10(13-A) whether living in … Rented House",{"$nulls":18},0]
[null,"3.","Net Salary [1-2]",{"$nulls":19},{"$f":"V5-V6","v":{"v":982634,"d":"₹ 982,634"}}]
[null,"4.","Standard Deduction u/s 16(ia)",{"$nulls":18},{"$f":"data!D19","v":{"v":75000,"d":"₹ 75,000"}}]
[null,"5.","Income chargeable under the head ''Salaries'' [3-4]",{"$nulls":19},{"$f":"W7-V8","v":{"v":907634,"d":"₹ 907,634"}}]
[null,"6.","Interest payable on borrowed capital u/s 24b",{"$nulls":18},0]
[null,"7.","Interest from saving Account / Deposits / Income tax refund",{"$nulls":18},{"$f":"data!D21","v":0}]
[null,"8.","Gross Total Income  [5+6+7]",{"$nulls":19},{"$f":"W9+V11","v":{"v":907634,"d":"₹ 907,634"}}]
[null,"9.","Deductions under Chapter VI-A"]
[null,null,"(a)","80C Life insurance premia, deferred annuity, contributions to provident fund etc.",{"$nulls":17},{"$f":"SUM(V15:V19)","v":0},0]
[{"$nulls":3},"(i)","GPF/GPF 2004",{"$nulls":16},0]
[{"$nulls":3},"(ii)","State Insurance",{"$nulls":16},0]
[{"$nulls":3},"(iii)","Group Insurance Accidental",{"$nulls":16},0]
[{"$nulls":3},"(iv)","LIC annual premium",{"$nulls":16},0]
[{"$nulls":3},"(v)","Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",{"$nulls":16},0]
[null,null,"(b)","80CCD(2) Employer contribution towards New pension Scheme",{"$nulls":17},{"$f":"data!D23","v":0},{"$f":"MIN(ROUND(W7*10%,0),V20)","v":0}]
[null,null,"(c)","80CCD(1B) Contribution to pension scheme of Central Government",{"$nulls":17},0,0]
[null,null,"(d)","80D Deduction in respect of Health Insurance premia",{"$nulls":17},0,0]
[null,null,"(e)","80DD Maintenance including medical treatment of a dependent who is a person with disability ",{"$nulls":17},0,0]
[null,null,"(f)","80DDB Medical treatment of specified disease",{"$nulls":17},0,0]
[null,null,"(g)","80E Interest on loan taken for higher education ",{"$nulls":17},0,0]
[null,null,"(h)","80G Donations to certain funds, charitable institutions, etc.  ",{"$nulls":17},0,0]
[null,null,"(i)","80TTA Interest on saving bank Accounts in case of other than Resident senior citizens",{"$nulls":17},0,0]
[null,null,"(j)","80U In case of a person with disability",{"$nulls":17},0,0]
[null,null,"(k)","Any other provision of Chapter VI‐A",{"$nulls":17},0,{"$f":"V29","v":0}]
[null,"10.","Total Deductions under Chapter VI-A",{"$nulls":19},{"$f":"SUM(W20:W29)+W14","v":0}]
[null,"11.","Total Taxable Income [8-10]",{"$nulls":19},{"$f":"IF(ROUND(W12-W29,-1)<0,0,ROUND(W12-W29,-1))","v":{"v":907630,"d":"₹ 907,630"}}]
[null,null,"Tax Calculation Table"]
[null,null,"Income Slab",{"$nulls":5},"Rate",null,"Taxable Income",{"$nulls":3},"Tax"]
[null,null,"Up To ₹ 300000",{"$nulls":5},"Nil",null,{"$f":"MAX(IF(W31>=300000,300000,W31),0)","v":300000},"Nil",{"$f":"MAX(IF($F$31>=250000,250000,$F$31),0)","v":0},"Nil","Nil"]
[null,null,"₹ 300001 To ₹ 700000",{"$nulls":5},{"v":0.05,"d":"5%"},null,{"$f":"IF(W31>=700000,400000,IF(W31<=300000,0,(W31-K34)))","v":400000},{"$f":"ROUND(J35*K35,0)","v":0},{"$f":"IF($F$31>=500000,250000,IF($F$31<=250000,0,($F$31-M34)))","v":0},{"$f":"ROUND(L35*M35,0)","v":0},{"$f":"ROUND(I35*K35,0)","v":20000}]
[null,null,"₹ 700001 To ₹ 1000000",{"$nulls":5},{"v":0.1,"d":"10%"},null,{"$f":"IF(W31>=1000000,300000,IF(W31<=700000,0,(W31-K34-K35)))","v":207630},{"$f":"ROUND(J36*K36,0)","v":0},{"$f":"IF($F$31>=1000000,500000,IF($F$31<=500000,0,($F$31-M34-M35)))","v":0},{"$f":"ROUND(L36*M36,0)","v":0},{"$f":"ROUND(I36*K36,0)","v":20763}]
[null,null,"₹ 1000001 To ₹ 1200000",{"$nulls":5},{"v":0.15,"d":"15%"},null,{"$f":"IF(W31>=1200000,200000,IF(W31<=1000000,0,(W31-K34-K35-K36)))","v":0},{"$nulls":3},{"$f":"ROUND(I37*K37,0)","v":0}]
[null,null,"₹ 1200001 To ₹ 1500000",{"$nulls":5},{"v":0.2,"d":"20%"},null,{"$f":"IF(W31>=1500000,300000,IF(W31<=1200000,0,(W31-K34-K35-K36-K37)))","v":0},{"$nulls":3},{"$f":"ROUND(I38*K38,0)","v":0}]
[null,null,"Above ₹ 1500000",{"$nulls":5},{"v":0.3,"d":"30%"},null,{"$f":"IF(W31<=1500000,0,(W31-1500000))","v":0},{"$f":"ROUND(J39*K39,0)","v":0},{"$f":"IF($F$31<=1000000,0,($F$31-1000000))","v":0},{"$f":"ROUND(L39*M39,0)","v":0},{"$f":"ROUND(I39*K39,0)","v":0},{"$nulls":3},{"$f":"W31=SUM(K34:N39)","v":true}]
[null,"12.","Tax Payable on Total Income ",{"$nulls":19},{"$f":"SUM(O35:R39)","v":{"v":40763,"d":"₹ 40,763"}}]
[null,"13.","Rebate u/s 87A with Marginal Relief u/s 115BAC(1A)",{"$nulls":19},{"$f":"IF(W31>=700000,0,MIN(25000,W40))+IF(W31>=722224,0,IF(W31<=700000,0,W40-(W31-700000)))","v":0}]
[null,"14.","Tax Payable after Rebate [12-13]",{"$nulls":19},{"$f":"W40-W41","v":{"v":40763,"d":"₹ 40,763"}}]
[null,"15.","Health and Education Cess",{"$nulls":19},{"$f":"ROUND(4%*W42,0)","v":{"v":1631,"d":"₹ 1,631"}}]
[null,"16.","Total Tax & Cess [14+15]",{"$nulls":19},{"$f":"W42+W43","v":{"v":42394,"d":"₹ 42,394"}}]
[null,"17.","Relief u/s 89",{"$nulls":19},{"$f":"data!D33","v":0}]
[null,"18.","Balance Tax after Relief [16-17]",{"$nulls":19},{"$f":"W44-W45","v":{"v":42394,"d":"₹ 42,394"}}]
[null,"19.","Total Taxes deducted at Sources",{"$nulls":19},{"$f":"data!D34","v":0}]
[null,"20.","Amount Payable [18-19]",{"$nulls":19},{"$f":"MAX(0,(W46-W47))","v":{"v":42394,"d":"₹ 42,394"}}]
[null,"21.","Refund [19-18]",{"$nulls":19},{"$f":"MAX(0,(W47-W46))","v":0}]
[]
[{"$nulls":21},"Employee Signature"]

{"sheet":"backE","index":4,"n_rows":49,"n_cols":23,"rows_kept":49,"merged":[[0,1,0,22],[1,1,1,22],[2,1,2,20],[2,21,2,22],[3,1,3,20],[3,21,3,22],[4,2,4,20],[5,2,5,20],[6,2,6,20],[7,2,7,20],[8,2,8,20],[9,2,9,20],[10,2,10,20],[11,2,11,20],[12,2,12,20],[13,3,13,20],[14,4,14,20],[15,4,15,20],[16,4,16,20],[17,4,17,20],[18,4,18,20],[19,3,19,20],[20,3,20,20],[21,3,21,20],[22,3,22,20],[23,3,23,20],[24,3,24,20],[25,3,25,20],[26,3,26,20],[27,3,27,20],[28,3,28,20],[29,2,29,20],[30,2,30,20],[31,2,31,17],[31,18,31,20],[32,2,32,7],[32,8,32,9],[32,10,32,13],[32,14,32,17],[32,18,32,20],[33,2,33,7],[33,8,33,9],[33,10,33,13],[33,14,33,17],[33,18,33,20],[34,2,34,7],[34,8,34,9],[34,10,34,13],[34,14,34,17],[34,18,34,20],[35,2,35,7],[35,8,35,9],[35,10,35,13],[35,14,35,17],[35,18,35,20],[36,2,36,7],[36,8,36,9],[36,10,36,13],[36,14,36,17],[36,18,36,20],[37,2,37,20],[38,2,38,20],[39,2,39,20],[40,2,40,20],[41,2,41,20],[42,2,42,20],[43,2,43,20],[44,2,44,20],[45,2,45,20],[46,2,46,20]]}
[]
[null,"Income Tax Calculation for Financial Year 2023-24 Assessment Year 2024-25"]
[null,{"$f":"backN!$B$3","v":"Name (Designation) : Pramod Kumar Saini (Teacher)"},{"$nulls":19},{"$f":"backN!$V$3","v":"PAN : ABCDE1234E"}]
[null,{"$f":"backN!$B$4","v":"DDO Office : G S S S Malutana"},{"$nulls":19},"As per Old Tax Regime"]
[null,"1.","Gross Salary... (Including all allowance u/s 17... i.e. Govt. contribution towards NPS)",{"$nulls":18},{"$f":"data!C17","v":{"v":982634,"d":"₹ 982,634"}}]
[null,"2.","HRA exemption as per eligibility u/s 10(13-A) whether living in … Rented House",{"$nulls":18},{"$f":"data!C18","v":{"v":54324,"d":"₹ 54,324"}}]
[null,"3.","Net Salary [1-2]",{"$nulls":19},{"$f":"V5-V6","v":{"v":928310,"d":"₹ 928,310"}}]
[null,"4.","Standard Deduction u/s 16(ia)",{"$nulls":18},{"$f":"data!C19","v":{"v":50000,"d":"₹ 50,000"}}]
[null,"5.","Income chargeable under the head ''Salaries'' [3-4]",{"$nulls":19},{"$f":"W7-V8","v":{"v":878310,"d":"₹ 878,310"}}]
[null,"6.","Interest payable on borrowed capital u/s 24b",{"$nulls":18},{"$f":"data!C20","v":0}]
[null,"7.","Interest from saving Account / Deposits / Income tax refund",{"$nulls":18},{"$f":"data!C21","v":0}]
[null,"8.","Gross Total Income  [5+6+7]",{"$nulls":19},{"$f":"W9+V11-V10","v":{"v":878310,"d":"₹ 878,310"}}]
[null,"9.","Deductions under Chapter VI-A"]
[null,null,"(a)","80C Life insurance premia, deferred annuity, contributions to provident fund etc.",{"$nulls":17},{"$f":"SUM(V15:V19)","v":{"v":156434,"d":"₹ 156,434"}},{"$f":"MIN(150000,V14)","v":{"v":150000,"d":"₹ 150,000"}}]
[{"$nulls":3},"(i)","GPF/GPF 2004",{"$nulls":16},{"$f":"front!$M$26","v":{"v":71734,"d":"₹ 71,734"}}]
[{"$nulls":3},"(ii)","State Insurance",{"$nulls":16},{"$f":"front!$O$26","v":{"v":84000,"d":"₹ 84,000"}}]
[{"$nulls":3},"(iii)","Group Insurance Accidental",{"$nulls":16},{"$f":"front!$Q$8","v":{"v":700,"d":"₹ 700"}}]
[{"$nulls":3},"(iv)","LIC annual premium",{"$nulls":16},{"$f":"front!$S$26","v":0}]
[{"$nulls":3},"(v)","Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",{"$nulls":16},{"$f":"data!C22","v":0}]
[null,null,"(b)","80CCD(2) Employer contribution towards New pension Scheme",{"$nulls":17},{"$f":"data!C23","v":0},{"$f":"MIN(ROUND(10%*W7,0),V20)","v":0}]
[null,null,"(c)","80CCD(1B) Contribution to pension scheme of Central Government",{"$nulls":17},{"$f":"data!C24","v":0},{"$f":"MIN(50000,V21)","v":0}]
[null,null,"(d)","80D Deduction in respect of Health Insurance premia",{"$nulls":17},{"$f":"data!C25","v":0},{"$f":"MIN(75000,V22)","v":0}]
[null,null,"(e)","80DD Maintenance including medical treatment of a dependent who is a person with disability ",{"$nulls":17},{"$f":"data!C26","v":0},{"$f":"MIN(125000,V23)","v":0}]
[null,null,"(f)","80DDB Medical treatment of specified disease",{"$nulls":17},{"$f":"data!C27","v":0},{"$f":"MIN(40000,V24)","v":0}]
[null,null,"(g)","80E Interest on loan taken for higher education ",{"$nulls":17},{"$f":"data!C28","v":0},{"$f":"V25","v":0}]
[null,null,"(h)","80G Donations to certain funds, charitable institutions, etc.  ",{"$nulls":17},{"$f":"data!C29","v":0},{"$f":"V26","v":0}]
[null,null,"(j)","80TTA Interest on saving bank Accounts in case of other than Resident senior citizens",{"$nulls":17},{"$f":"data!C30","v":0},{"$f":"MIN(10000,V27,V11)","v":0}]
[null,null,"(j)","80U In case of a person with disability",{"$nulls":17},{"$f":"data!C31","v":0},{"$f":"MIN(125000,V28)","v":0}]
[null,null,"(k)","Any other provision of Chapter VI‐A",{"$nulls":17},{"$f":"data!C32","v":0},{"$f":"V29","v":0}]
[null,"10.","Total Deductions under Chapter VI-A",{"$nulls":19},{"$f":"SUM(W20:W29)+W14","v":{"v":150000,"d":"₹ 150,000"}}]
[null,"11.","Total Taxable Income [8-10]",{"$nulls":19},{"$f":"IF(ROUND(W12-W30,-1)<0,0,ROUND(W12-W30,-1))","v":{"v":728310,"d":"₹ 728,310"}}]
[null,null,"Tax Calculation Table"]
[null,null,"Income Slab",{"$nulls":5},"Rate",null,"Taxable Income",{"$nulls":3},"Tax"]
[null,null,"Up To ₹ 250000",{"$nulls":5},"Nil",null,{"$f":"MAX(IF(W31>=250000,250000,W31),0)","v":250000},"Nil",{"$f":"MAX(IF($F$31>=250000,250000,$F$31),0)","v":0},"Nil","Nil"]
[null,null,"₹ 250001 To ₹ 500000",{"$nulls":5},{"v":0.05,"d":"5%"},null,{"$f":"IF(W31>=500000,250000,IF(W31<=250000,0,(W31-K34)))","v":250000},{"$f":"ROUND(J35*K35,0)","v":0},{"$f":"IF($F$31>=500000,250000,IF($F$31<=250000,0,($F$31-M34)))","v":0},{"$f":"ROUND(L35*M35,0)","v":0},{"$f":"ROUND(I35*K35,0)","v":12500}]
[null,null,"₹ 500001 To ₹ 1000000",{"$nulls":5},{"v":0.2,"d":"20%"},null,{"$f":"IF(W31>=1000000,500000,IF(W31<=500000,0,(W31-K34-K35)))","v":228310},{"$nulls":3},{"$f":"ROUND(I36*K36,0)","v":45662}]
[null,null,"Above ₹ 1000000",{"$nulls":5},{"v":0.3,"d":"30%"},null,{"$f":"IF(W31<=1000000,0,(W31-1000000))","v":0},{"$nulls":3},{"$f":"ROUND(I37*K37,0)","v":0},{"$nulls":3},{"$f":"W31=SUM(K34:N37)","v":true}]
[null,"12.","Tax Payable on Total Income ",{"$nulls":19},{"$f":"SUM(O35:R37)","v":{"v":58162,"d":"₹ 58,162"}}]
[null,"13.","Rebate u/s 87A",{"$nulls":19},{"$f":"IF(W31>=500000,0,MIN(12500,W38))","v":0}]
[null,"14.","Tax Payable after Rebate [12-13]",{"$nulls":19},{"$f":"W38-W39","v":{"v":58162,"d":"₹ 58,162"}}]
[null,"15.","Health and Education Cess",{"$nulls":19},{"$f":"ROUND(4%*W40,0)","v":{"v":2326,"d":"₹ 2,326"}}]
[null,"16.","Total Tax & Cess [14+15]",{"$nulls":19},{"$f":"W40+W41","v":{"v":60488,"d":"₹ 60,488"}}]
[null,"17.","Relief u/s 89",{"$nulls":19},{"$f":"data!C33","v":0}]
[null,"18.","Balance Tax after Relief [16-17]",{"$nulls":19},{"$f":"W42-W43","v":{"v":60488,"d":"₹ 60,488"}}]
[null,"19.","Total Taxes deducted at Sources",{"$nulls":19},{"$f":"data!C34","v":0}]
[null,"20.","Amount Payable [18-19]",{"$nulls":19},{"$f":"MAX(0,(W44-W45))","v":{"v":60488,"d":"₹ 60,488"}}]
[null,"21.","Refund [19-18]",{"$nulls":19},{"$f":"MAX(0,(W45-W44))","v":0}]
[]
[{"$nulls":21},"Employee Signature"]