{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["MAIN","data","salary","printF","backE","backN","compEN","reliefC","form10E"],"not_rendered":{"images":15,"macros":1,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"MAIN","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,0,16]]}
["pksaini"]

{"sheet":"data","index":1,"n_rows":7,"n_cols":458,"rows_kept":7,"merged":[[0,446,0,457],[1,446,1,448],[1,449,1,451],[1,452,1,454],[1,455,1,457],[2,26,2,45],[2,46,2,65],[2,66,2,85],[2,86,2,105],[2,106,2,125],[2,126,2,145],[2,146,2,165],[2,166,2,185],[2,186,2,205],[2,206,2,225],[2,226,2,245],[2,246,2,265],[2,266,2,285],[2,286,2,305],[2,306,2,325],[2,326,2,345],[2,346,2,365],[2,366,2,385],[2,386,2,405],[2,406,2,425],[2,426,2,445]]}
["Col1_1","Col1_2","Col1_3","Col1_4","Col1_5","Col1_6","Col1_7","Col1_8","Col1_9","Col1_10","Col1_11","Col1_12","Col1_13","Col1_14","Col1_15","Col1_16","Col1_17","Col1_18","Col1_19","Col1_20","Col1_21","Col1_22","Col1_23","Col1_24","Col1_25","Col1_26",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,{"$nulls":400},"Relief 10E"]
["Col2_1","Col2_2","Col2_3","Col2_4","Col2_5","Col2_6","Col2_7","Col2_8","Col2_9","Col2_10","Col2_11","Col2_12","Col2_13","Col2_14","Col2_15","Col2_16","Col2_17","Col2_18","Col2_19","Col2_20","Col2_21","Col2_22","Col2_23","Col2_24","Col2_25","Col2_26","Col2_27","Col2_28","Col2_29","Col2_30","Col2_31","Col2_32","Col2_33","Col2_34","Col2_35","Col2_36","Col2_37","Col2_38","Col2_39","Col2_40","Col2_41","Col2_42","Col2_43","Col2_44","Col2_45","Col2_46","Col2_47","Col2_48","Col2_49","Col2_50","Col2_51","Col2_52","Col2_53","Col2_54","Col2_55","Col2_56","Col2_57","Col2_58","Col2_59","Col2_60","Col2_61","Col2_62","Col2_63","Col2_64","Col2_65","Col2_66","Col2_67","Col2_68","Col2_69","Col2_70","Col2_71","Col2_72","Col2_73","Col2_74","Col2_75","Col2_76","Col2_77","Col2_78","Col2_79","Col2_80","Col2_81","Col2_82","Col2_83","Col2_84","Col2_85","Col2_86","Col2_87","Col2_88","Col2_89","Col2_90","Col2_91","Col2_92","Col2_93","Col2_94","Col2_95","Col2_96","Col2_97","Col2_98","Col2_99","Col2_100","Col2_101","Col2_102","Col2_103","Col2_104","Col2_105","Col2_106","Col2_107","Col2_108","Col2_109","Col2_110","Col2_111","Col2_112","Col2_113","Col2_114","Col2_115","Col2_116","Col2_117","Col2_118","Col2_119","Col2_120","Col2_121","Col2_122","Col2_123","Col2_124","Col2_125","Col2_126","Col2_127","Col2_128","Col2_129","Col2_130","Col2_131","Col2_132","Col2_133","Col2_134","Col2_135","Col2_136","Col2_137","Col2_138","Col2_139","Col2_140","Col2_141","Col2_142","Col2_143","Col2_144","Col2_145","Col2_146","Col2_147","Col2_148","Col2_149","Col2_150","Col2_151","Col2_152","Col2_153","Col2_154","Col2_155","Col2_156","Col2_157","Col2_158","Col2_159","Col2_160","Col2_161","Col2_162","Col2_163","Col2_164","Col2_165","Col2_166","Col2_167","Col2_168","Col2_169","Col2_170","Col2_171","Col2_172","Col2_173","Col2_174","Col2_175","Col2_176","Col2_177","Col2_178","Col2_179","Col2_180","Col2_181","Col2_182","Col2_183","Col2_184","Col2_185","Col2_186","Col2_187","Col2_188","Col2_189","Col2_190","Col2_191","Col2_192","Col2_193","Col2_194","Col2_195","Col2_196","Col2_197","Col2_198","Col2_199","Col2_200","Col2_201","Col2_202","Col2_203","Col2_204","Col2_205","Col2_206","Col2_207","Col2_208","Col2_209","Col2_210","Col2_211","Col2_212","Col2_213","Col2_214","Col2_215","Col2_216","Col2_217","Col2_218","Col2_219","Col2_220","Col2_221","Col2_222","Col2_223","Col2_224","Col2_225","Col2_226","Col2_227","Col2_228","Col2_229","Col2_230","Col2_231","Col2_232","Col2_233","Col2_234","Col2_235","Col2_236","Col2_237","Col2_238","Col2_239","Col2_240","Col2_241","Col2_242","Col2_243","Col2_244","Col2_245","Col2_246","Col2_247","Col2_248","Col2_249","Col2_250","Col2_251","Col2_252","Col2_253","Col2_254","Col2_255","Col2_256","Col2_257","Col2_258","Col2_259","Col2_260","Col2_261","Col2_262","Col2_263","Col2_264","Col2_265","Col2_266","Col2_267","Col2_268","Col2_269","Col2_270","Col2_271","Col2_272","Col2_273","Col2_274","Col2_275","Col2_276","Col2_277","Col2_278","Col2_279","Col2_280","Col2_281","Col2_282","Col2_283","Col2_284","Col2_285","Col2_286","Col2_287","Col2_288","Col2_289","Col2_290","Col2_291","Col2_292","Col2_293","Col2_294","Col2_295","Col2_296","Col2_297","Col2_298","Col2_299","Col2_300","Col2_301","Col2_302","Col2_303","Col2_304","Col2_305","Col2_306","Col2_307","Col2_308","Col2_309","Col2_310","Col2_311","Col2_312","Col2_313","Col2_314","Col2_315","Col2_316","Col2_317","Col2_318","Col2_319","Col2_320","Col2_321","Col2_322","Col2_323","Col2_324","Col2_325","Col2_326","Col2_327","Col2_328","Col2_329","Col2_330","Col2_331","Col2_332","Col2_333","Col2_334","Col2_335","Col2_336","Col2_337","Col2_338","Col2_339","Col2_340","Col2_341","Col2_342","Col2_343","Col2_344","Col2_345","Col2_346","Col2_347","Col2_348","Col2_349","Col2_350","Col2_351","Col2_352","Col2_353","Col2_354","Col2_355","Col2_356","Col2_357","Col2_358","Col2_359","Col2_360","Col2_361","Col2_362","Col2_363","Col2_364","Col2_365","Col2_366","Col2_367","Col2_368","Col2_369","Col2_370","Col2_371","Col2_372","Col2_373","Col2_374","Col2_375","Col2_376","Col2_377","Col2_378","Col2_379","Col2_380","Col2_381","Col2_382","Col2_383","Col2_384","Col2_385","Col2_386","Col2_387","Col2_388","Col2_389","Col2_390","Col2_391","Col2_392","Col2_393","Col2_394","Col2_395","Col2_396","Col2_397","Col2_398","Col2_399","Col2_400","Col2_401","Col2_402","Col2_403","Col2_404","Col2_405","Col2_406","Col2_407","Col2_408","Col2_409","Col2_410","Col2_411","Col2_412","Col2_413","Col2_414","Col2_415","Col2_416","Col2_417","Col2_418","Col2_419","Col2_420","Col2_421","Col2_422","Col2_423","Col2_424","Col2_425","Col2_426","Col2_427","Col2_428","Col2_429","Col2_430","Col2_431","Col2_432","Col2_433","Col2_434","Col2_435","Col2_436","Col2_437","Col2_438","Col2_439","Col2_440","Col2_441","Col2_442","Col2_443","Col2_444","Col2_445","Col2_446","2020-21",null,null,"2021-22",null,null,"2022-23",null,null,"2023-24"]
["Col3_1","Col3_2","Col3_3","Col3_4","Col3_5","Col3_6","Col3_7","Col3_8","Col3_9","Col3_10","Col3_11","Col3_12","Col3_13","Col3_14","Col3_15","Col3_16","Col3_17","Col3_18","Col3_19","Col3_20","Col3_21","Col3_22","Col3_23","Col3_24","Col3_25","Col3_26",{"$nulls":420},"TI","SA","TR","TI","SA","TR","TI","SA","TR","TI","SA","TR"]
[1,"Pramod Kumar Saini","Teacher","ASDF1234X","GSSS Malutana",49300,7,null,12,700,120000,null,null,50000,{"$nulls":12},49300,49300,49300,49300,50800,50800,50800,50800,50800,50800,50800,50800,{"$nulls":3},0,{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":8},24650,24650,24650,24650,25400,25400,25400,25400,26924,26924,26924,26924,3944,6096,null,0,{"$nulls":4},4437,4437,4437,4437,4572,4572,4572,4572,5080,5080,5080,5080,null,null,0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":24},6774,{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":8},5000,5000,5000,5000,5000,5000,2850,2850,2850,2850,2850,2850,3944,6096,null,null,1694,{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":8},7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},700,{"$nulls":18},658,658,658,658,658,658,658,658,658,658,658,658,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":8},4000,4000,4000,4000,4000,4000,4000,3000,3000,3000,3000,3000,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0]
[2,"Mukesh Yadav","Sr Teacher","ASDFG1234H","GSSS Malutana",38400,7,null,12,700]
[3,"Puran Chand Meena","Prabodhak","SDFGH4321K","GSSS Malutana",49300,7,null,12,2100,{"$nulls":16},49300,49300,49300,49300,50800,50800,50800,50800,50800,50800,50800,50800,{"$nulls":3},0,{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":8},24650,24650,24650,24650,25400,25400,25400,25400,26924,26924,26924,26924,3944,6096,null,0,{"$nulls":4},4437,4437,4437,4437,4572,4572,4572,4572,5080,5080,5080,5080,null,null,0,{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":24},6774,{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":8},2850,2850,2850,2850,2850,2850,2850,2850,2850,2850,2850,2850,3944,6096,null,null,1694,{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":8},3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},2100,{"$nulls":18},658,658,658,658,658,658,658,658,658,658,658,658,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0,{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0]
[4,"Gyana Ram Gurjar","Teacher","DFGHJK1234K","GSSS Malutana",39800,7,null,12,700]

{"sheet":"salary","index":2,"n_rows":26,"n_cols":27,"rows_kept":26,"merged":[[0,1,0,25],[2,1,2,25],[3,1,4,1],[3,2,3,11],[3,12,4,12],[3,13,3,22],[3,23,4,23],[3,24,4,24],[3,25,4,25]]}
[]
[{"$f":"INDEX(data!$A:$A,MATCH(salary!$B$2,data!$B:$B,0))","v":1},"Pramod Kumar Saini","Select Employee :",{"$nulls":8},{"$f":"\"Desig. : \"&IFERROR(VLOOKUP(A2,pk_Tb,3,0),\"\")","v":"Desig. : Teacher"},null,null,{"$f":"\"PAN : \"&IFERROR(VLOOKUP(A2,pk_Tb,4,0),\"\")","v":"PAN : ASDF1234X"},{"$nulls":11},{"$f":"A2","v":1}]
[]
[null,"Month\nYear","------------------Allowances---------------------",{"$nulls":9},"Total\nAllow","------------------Deductions---------------------",{"$nulls":9},"Total \nDedu","Net\nSalary","TV \nNo"]
[null,null,"Basic",null,null,"DA","HRA","CCA",null,"Bonus","ROP",null,null,"GPF","GPFL","SI","SIL","GIS","RGHS","LIC","ITAX"]
[null,"2024-03-01",49300,null,null,24650,4437,{"$nulls":5},{"$f":"SUM(C6:J6)+L6-K6","v":78387},5000,null,7000,null,null,658,null,4000,null,null,{"$f":"SUM(N6:W6)","v":16658},{"$f":"M6-X6","v":61729}]
[null,"2024-04-01",49300,0,0,24650,4437,0,0,null,0,0,{"$f":"SUM(C7:J7)+L7-K7","v":78387},5000,0,7000,0,700,658,0,4000,0,0,{"$f":"SUM(N7:W7)","v":17358},{"$f":"M7-X7","v":61029}]
[null,"2024-05-01",49300,0,0,24650,4437,0,0,null,0,0,78387,5000,0,7000,0,null,658,0,4000,0,0,16658,61729]
[null,"2024-06-01",49300,0,0,24650,4437,0,0,null,0,0,78387,5000,0,7000,0,null,658,0,4000,0,0,16658,61729]
[null,"2024-07-01",50800,0,0,25400,4572,0,0,null,0,0,80772,5000,0,7000,0,null,658,0,4000,0,0,16658,64114]
[null,"2024-08-01",50800,0,0,25400,4572,0,0,null,0,0,80772,5000,0,7000,0,null,658,0,4000,0,0,16658,64114]
[null,"2024-09-01",50800,0,0,25400,4572,0,0,null,0,0,80772,2850,0,7000,0,null,658,0,4000,0,0,14508,66264]
[null,"2024-10-01",50800,0,0,25400,4572,0,0,null,0,0,80772,2850,0,7000,0,null,658,0,3000,0,0,13508,67264]
[null,"2024-11-01",50800,0,0,26924,5080,0,0,null,0,0,82804,2850,0,7000,0,null,658,0,3000,0,0,13508,69296]
[null,"2024-12-01",50800,0,0,26924,5080,0,0,null,0,0,82804,2850,0,7000,0,null,658,0,3000,0,0,13508,69296]
[null,"2025-01-01",50800,0,0,26924,5080,0,0,null,0,0,82804,2850,0,7000,0,null,658,0,3000,0,0,13508,69296]
[null,"2025-02-01",50800,0,0,26924,5080,0,0,null,0,0,82804,2850,0,7000,0,null,658,0,3000,0,0,13508,69296]
[null,"DA Arr",{"$nulls":3},3944,{"$nulls":6},3944,3944,{"$nulls":9},3944,0]
[null,"DA Arr",{"$nulls":3},6096,{"$nulls":6},6096,6096,{"$nulls":9},6096,0]
[null,"HRA Arr",{"$nulls":4},0,{"$nulls":5},0,{"$nulls":10},0,0]
[null,"Surrender",0,null,null,0,{"$nulls":6},0,{"$nulls":10},0,0]
[null,"Bonus",{"$nulls":7},6774,null,null,6774,1694,{"$nulls":9},1694,5080]
[null,"Arrear",{"$nulls":10},0,{"$nulls":10},0,0]
[null,"Arrear",{"$nulls":10},0,{"$nulls":10},0,0]
[null,"Arrear",{"$nulls":10},0,{"$nulls":10},0,0]
[null,"Total",{"$f":"SUM(C6:C25)","v":603600},{"$f":"SUM(D6:D25)","v":0},0,317936,56356,0,0,6774,0,0,984666,58834,0,84000,0,700,7896,0,43000,0,0,194430,790236]

{"sheet":"printF","index":3,"n_rows":28,"n_cols":496,"rows_kept":28,"merged":[[0,1,0,25],[1,2,1,5],[1,6,1,12],[1,14,1,17],[1,18,1,24],[2,2,2,5],[2,6,2,12],[2,14,2,17],[2,18,2,24],[3,1,4,1],[3,2,3,11],[3,12,4,12],[3,13,3,22],[3,23,4,23],[3,24,4,24],[3,25,4,25]]}
[null,"Annual Salary Statement of the Financial Year 2024-25",{"$nulls":25},{"$f":"INDEX(data!$A:$A,MATCH(printF!$AC$1,data!$B:$B,0))","v":1},"Pramod Kumar Saini",{"$nulls":48},"2024-01-01",50,46,9,9,{"$nulls":412},"Designation","Posting Place"]
[null,null,"Employee Name :",{"$nulls":3},{"$f":"VLOOKUP($AB$1,pk_Tb,2,0)","v":"Pramod Kumar Saini"},{"$nulls":7},"Employee Desig. :",{"$nulls":3},{"$f":"VLOOKUP($AB$1,pk_Tb,3,0)","v":"Teacher"},{"$nulls":58},"2024-02-01",50,46,9,9,{"$nulls":412},"Principal","GSSS Malutana"]
[null,null,"Employee PAN :",{"$nulls":3},{"$f":"VLOOKUP($AB$1,pk_Tb,4,0)","v":"ASDF1234X"},{"$nulls":7},"DDO Office :",{"$nulls":3},{"$f":"VLOOKUP($AB$1,pk_Tb,5,0)","v":"GSSS Malutana"},{"$nulls":58},"2024-03-01",50,50,9,9,{"$nulls":412},"Vice Principal","1A"]
[null,"Month\nYear","------------------Allowances---------------------",{"$nulls":9},"Gross\nAmount","------------------Deductions---------------------",{"$nulls":9},"Total \nDedu","Net\nAmount","TV \nNo",{"$nulls":23},"Pramod Kumar Saini",{"$nulls":10},"50","46",{"$f":"BI4-BJ4","v":4},{"$f":"ROUND(AZ6*BK4/100,0)","v":1972},"9","9",{"$f":"BM4-BN4","v":0},{"$f":"ROUND(AZ6*BO4/100,)","v":0},{"$nulls":9},"2024-04-01",50,50,9,9,{"$nulls":412},"Lecturer","2A"]
[null,null,"Basic",null,null,"DA","HRA","CCA",null,"Bonus","ROP",null,null,"GPF","GPFL","SI","SIL","GIS","RGHS","LIC","ITAX",{"$nulls":28},{"$f":"INDEX(data!A:A,MATCH(printF!AX4,data!B:B,0))","v":1},{"$nulls":10},"50","46",{"$f":"BI5-BJ5","v":4},{"$f":"ROUND(AZ6*BK5/100,0)","v":1972},"9","9",{"$f":"BM5-BN5","v":0},{"$f":"ROUND(AZ6*BO5/100,)","v":0},{"$nulls":9},"2024-05-01",50,50,9,9,{"$nulls":412},"Sr Teacher","3A"]
[null,"2024-03-01",{"$f":"VLOOKUP($AB$1,pk_Tb,AB6,0)","v":49300},{"$f":"VLOOKUP($AB$1,pk_Tb,AC6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AD6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AE6,0)","v":24650},{"$f":"VLOOKUP($AB$1,pk_Tb,AF6,0)","v":4437},{"$f":"VLOOKUP($AB$1,pk_Tb,AG6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AH6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AI6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AJ6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AK6,0)","v":0},{"$f":"SUM(C6:J6)+L6-K6","v":78387},{"$f":"VLOOKUP($AB$1,pk_Tb,AL6,0)","v":5000},{"$f":"VLOOKUP($AB$1,pk_Tb,AM6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AN6,0)","v":7000},{"$f":"VLOOKUP($AB$1,pk_Tb,AO6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AP6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AQ6,0)","v":658},{"$f":"VLOOKUP($AB$1,pk_Tb,AR6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AS6,0)","v":4000},{"$f":"VLOOKUP($AB$1,pk_Tb,AT6,0)","v":0},{"$f":"VLOOKUP($AB$1,pk_Tb,AU6,0)","v":0},{"$f":"SUM(N6:W6)","v":16658},{"$f":"M6-X6","v":61729},{"$f":"VLOOKUP($AB$1,pk_Tb,AV6,0)","v":0},null,27,{"$f":"AB6+20","v":47},{"$f":"AC6+20","v":67},{"$f":"AD6+20","v":87},107,127,147,167,187,207,227,247,267,287,307,327,347,367,387,407,{"$f":"AU6+20","v":427},3,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,1,0),0)","v":1},"2024-03-01",{"$f":"AX11","v":49300},{"$f":"ROUND(AZ6*BJ6/100,0)","v":24650},{"$f":"ROUND(AZ6*BN6/100,0)","v":4437},null,{"$f":"IF(AZ6>167000,10500,IF(AZ6>116000,8900,IF(AZ6>80000,6150,IF(AZ6>72000,4800,BH6))))","v":2850},{"$f":"IF($AZ$6>72000,5000,IF($AZ$6>46500,3000,IF($AZ$6>28500,2200,IF($AZ$6>22000,1200,IF($AZ$6>0,800,0)))))","v":3000},null,{"$f":"IF(AZ6>54000,875,IF(AZ6>33500,658,IF(AZ6>18000,440,IF(AZ6>0,265,0))))","v":658},{"$f":"IF(AZ6>62000,4200,IF(AZ6>51500,3575,IF(AZ6>38500,2850,IF(AZ6>28500,2100,IF(AZ6>23100,1625,1450)))))","v":2850},"50","50",0,{"$f":"ROUND(AZ6*BK6/100,0)","v":0},"9","9",0,{"$f":"ROUND(AZ6*BO6/100,)","v":0},{"$nulls":9},"2024-06-01",50,50,9,9,{"$nulls":412},"Teacher","4A"]
[null,"2024-04-01",49300,0,0,24650,4437,0,0,0,0,0,{"$f":"SUM(C7:J7)+L7-K7","v":78387},5000,0,7000,0,700,658,0,4000,0,0,{"$f":"SUM(N7:W7)","v":17358},{"$f":"M7-X7","v":61029},0,null,28,{"$f":"AB7+20","v":48},68,88,108,128,148,168,188,208,228,248,268,288,308,328,348,{"$f":"AR7+20","v":368},388,408,428,4,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,2,0),0)","v":"Pramod Kumar Saini"},"2024-04-01",{"$f":"AZ6","v":49300},24650,4437,null,2850,{"$f":"IF($AZ$6>72000,5000,IF($AZ$6>46500,3000,IF($AZ$6>28500,2200,IF($AZ$6>22000,1200,IF($AZ$6>0,800,0)))))","v":3000},{"$f":"AX15","v":700},{"$f":"IF(AZ7>54000,875,IF(AZ7>33500,658,IF(AZ7>18000,440,IF(AZ7>0,265,0))))","v":658},2850,"50","50",0,0,"9","9",0,0,{"$nulls":9},"2024-07-01",53,50,9,9,{"$nulls":412},"PET III","5A"]
[null,"2024-05-01",49300,0,0,24650,4437,0,0,0,0,0,78387,5000,0,7000,0,0,658,0,4000,0,0,16658,61729,0,null,29,49,69,89,109,129,149,169,189,209,229,249,269,289,309,329,349,369,389,409,429,5,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,3,0),0)","v":"Teacher"},"2024-05-01",{"$f":"AZ7","v":49300},24650,4437,null,2850,3000,null,658,2850,"50","50",0,0,"9","9",0,0,{"$nulls":9},"2024-08-01",53,50,9,9,{"$nulls":412},"Prabodhak","6A"]
[null,"2024-06-01",49300,0,0,24650,4437,0,0,0,0,0,78387,5000,0,7000,0,0,658,0,4000,0,0,16658,61729,0,null,30,50,70,90,110,130,150,170,190,210,230,250,270,290,310,330,350,370,390,410,430,6,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,4,0),0)","v":"ASDF1234X"},"2024-06-01",{"$f":"AZ8","v":49300},24650,4437,null,2850,3000,null,658,2850,"50","50",0,0,"9","9",0,0,{"$nulls":9},"2024-09-01",53,50,9,9,{"$nulls":412},"Sr Assistant","7A"]
[null,"2024-07-01",50800,0,0,25400,4572,0,0,0,0,0,80772,5000,0,7000,0,0,658,0,4000,0,0,16658,64114,0,null,31,51,71,91,111,131,151,171,191,211,231,251,271,291,311,331,351,371,391,411,431,7,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,5,0),0)","v":"GSSS Malutana"},"2024-07-01",{"$f":"IF(AX12=AW10,MROUND(AZ9*103%,100),AZ9)","v":50800},25400,4572,null,2850,3000,null,658,2850,"53","50",3,1524,"9","9",0,0,{"$nulls":9},"2024-10-01",53,50,9,9,{"$nulls":412},"Jr Assistant","8A"]
[null,"2024-08-01",50800,0,0,25400,4572,0,0,0,0,0,80772,5000,0,7000,0,0,658,0,4000,0,0,16658,64114,0,null,32,52,72,92,112,132,152,172,192,212,232,252,272,292,312,332,352,372,392,412,432,8,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,6,0),0)","v":49300},"2024-08-01",{"$f":"AZ10","v":50800},25400,4572,null,2850,3000,null,658,2850,"53","50",3,1524,"9","9",0,0,{"$nulls":9},"2024-11-01",53,53,10,10,{"$nulls":412},"BCI","9A"]
[null,"2024-09-01",50800,0,0,25400,4572,0,0,0,0,0,80772,2850,0,7000,0,0,658,0,4000,0,0,14508,66264,0,null,33,53,73,93,113,133,153,173,193,213,233,253,273,293,313,333,353,373,393,413,433,9,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,7,0),0)","v":7},"2024-09-01",{"$f":"AZ11","v":50800},25400,4572,null,2850,3000,null,658,2850,"53","50",3,1524,"9","9",0,0,{"$nulls":9},"2024-12-01",53,53,10,10,{"$nulls":412},"Nil1"]
[null,"2024-10-01",50800,0,0,25400,4572,0,0,0,0,0,80772,2850,0,7000,0,0,658,0,3000,0,0,13508,67264,0,null,34,54,74,94,114,134,154,174,194,214,234,254,274,294,314,334,354,374,394,414,434,10,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,8,0),0)","v":0},"2024-10-01",{"$f":"AZ12","v":50800},25400,4572,null,2850,3000,null,658,2850,"53","50",3,1524,"9","9",0,0,{"$nulls":9},"2025-01-01",53,53,10,10,{"$nulls":412},"Nil2"]
[null,"2024-11-01",50800,0,0,26924,5080,0,0,0,0,0,82804,2850,0,7000,0,0,658,0,3000,0,0,13508,69296,0,null,35,55,75,95,115,135,155,175,195,215,235,255,275,295,315,335,355,375,395,415,435,11,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,9,0),0)","v":12},"2024-11-01",{"$f":"AZ13","v":50800},26924,5080,null,2850,3000,null,658,2850,"53","53",0,0,"10","10",0,0,{"$nulls":9},"2025-02-01",53,53,10,10,{"$nulls":412},"Nil3"]
[null,"2024-12-01",50800,0,0,26924,5080,0,0,0,0,0,82804,2850,0,7000,0,0,658,0,3000,0,0,13508,69296,0,null,36,56,76,96,116,136,156,176,196,216,236,256,276,296,316,336,356,376,396,416,436,12,{"$f":"IFERROR(VLOOKUP($AX$5,pk_Tb,10,0),0)","v":700},"2024-12-01",{"$f":"AZ14","v":50800},26924,5080,null,2850,3000,null,658,2850,"53","53",0,0,"10","10",0,0,{"$nulls":426},"Nil4"]
[null,"2025-01-01",50800,0,0,26924,5080,0,0,0,0,0,82804,2850,0,7000,0,0,658,0,3000,0,0,13508,69296,0,null,37,57,77,97,117,137,157,177,197,217,237,257,277,297,317,337,357,377,397,417,437,1,null,"2025-01-01",{"$f":"IF(AX12=AW16,MROUND(AZ15*103%,100),AZ15)","v":50800},26924,5080,null,2850,3000,null,658,2850,"53","53",0,0,"10","10",0,0,{"$nulls":426},"Nil5"]
[null,"2025-02-01",50800,0,0,26924,5080,0,0,0,0,0,82804,2850,0,7000,0,0,658,0,3000,0,0,13508,69296,0,null,38,58,78,98,118,138,158,178,198,218,238,258,278,298,318,338,358,378,398,418,438,2,null,"2025-02-01",{"$f":"AZ16","v":50800},26924,5080,null,2850,3000,null,658,2850,"53","53",0,0,"10","10",0,0,{"$nulls":426},"Nil6"]
[null,"DA Arr",0,0,0,3944,0,0,0,0,0,0,3944,3944,0,0,0,0,0,0,0,0,0,3944,0,0,null,39,59,79,99,119,139,159,179,199,219,239,259,279,299,319,339,359,379,399,419,439,null,null,"DA Arr",null,{"$f":"SUM(BL4:BL9)","v":3944},null,null,{"$f":"BA18","v":3944},{"$nulls":438},"Nil7"]
[null,"DA Arr",0,0,0,6096,0,0,0,0,0,0,6096,6096,0,0,0,0,0,0,0,0,0,6096,0,0,null,40,60,80,100,120,140,160,180,200,220,240,260,280,300,320,340,360,380,400,420,440,null,null,"DA Arr",null,{"$f":"SUM(BL10:BL17)","v":6096},null,null,{"$f":"BA19","v":6096},{"$nulls":438},"Nil8"]
[null,"HRA Arr",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,41,61,81,101,121,141,161,181,201,221,241,261,281,301,321,341,361,381,401,421,441,null,null,"HRA Arr",null,null,{"$f":"SUM(BP4:BP17)","v":0},{"$nulls":440},"Nil9"]
[null,"Surrender",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,42,62,82,102,122,142,162,182,202,{"$f":"AJ21+20","v":222},242,262,282,302,322,342,362,382,402,422,442,null,null,"Surrender",{"$f":"IFERROR(ROUND(VLOOKUP(AX13,AW6:BA17,4,0)/2,0),)","v":0},{"$f":"IFERROR(ROUND(VLOOKUP(AX13,AW6:BA17,5,0)/2,0),)","v":0},{"$nulls":441},"Nil10"]
[null,"Bonus",0,0,0,0,0,0,0,6774,0,0,6774,1694,0,0,0,0,0,0,0,0,0,1694,5080,0,null,43,63,{"$f":"AC22+20","v":83},103,123,143,163,183,203,223,243,263,283,303,323,343,363,383,403,423,443,null,null,"Bonus",{"$nulls":3},{"$f":"ROUND((6774/12)*AX14,0)","v":6774},{"$f":"ROUND(BC22*25/100,0)","v":1694}]
[null,"Arrear",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,44,64,{"$f":"AC23+20","v":84},104,124,144,164,184,204,224,244,264,284,304,324,344,364,384,404,424,444,null,null,"Arrear"]
[null,"Arrear",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,45,65,{"$f":"AC24+20","v":85},105,125,145,165,185,205,225,245,265,285,305,325,345,365,385,405,425,445,null,null,"Arrear"]
[null,"Arrear",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,46,66,{"$f":"AC25+20","v":86},106,126,146,166,186,206,226,246,266,286,306,326,346,366,386,406,426,446,null,null,"Arrear"]
[null,"Total",{"$f":"SUM(C6:C25)","v":603600},{"$f":"SUM(D6:D25)","v":0},0,317936,56356,0,0,6774,0,0,984666,58834,0,84000,0,700,7896,0,43000,0,0,194430,790236]
[]
[{"$nulls":13},"Employee Signature",{"$nulls":8},"DDO Signature"]

{"sheet":"backE","index":4,"n_rows":49,"n_cols":27,"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,3,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]]}
[{"$nulls":24},1,{"$f":"IFERROR(VLOOKUP($AA$1,pk_Tb,Y1,0),\"\")","v":1},{"$f":"printF!AB1","v":1}]
[null,"Income Tax Calculation for Financial Year 2023-24 Assessment Year 2024-25",{"$nulls":22},2,"Pramod Kumar Saini"]
[null,{"$f":"\"Name (Designation) : \"&Z2&\" (\"&Z3&\")\"","v":"Name (Designation) : Pramod Kumar Saini (Teacher)"},{"$nulls":19},{"$f":"\"PAN : \"&Z4","v":"PAN : ASDF1234X"},null,null,3,"Teacher"]
[null,{"$f":"\"DDO Office : \"&Z5","v":"DDO Office : GSSS Malutana"},{"$nulls":19},"As per Old Tax Regime",null,null,4,"ASDF1234X"]
[null,"1.","Gross Salary... (Including all allowance u/s 17... i.e. Govt. contribution towards NPS)",{"$nulls":18},{"$f":"printF!M26","v":{"v":984666,"d":"₹ 984,666"}},null,null,5,"GSSS Malutana"]
[null,"2.","HRA exemption as per eligibility u/s 10(13-A) whether living in … Rented House",{"$nulls":18},{"$f":"IFERROR(MIN(Z11,SUM(salary!G6:G17)),0)","v":{"v":56356,"d":"₹ 56,356"}}]
[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":"MAX(MIN(50000,W7),0)","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":"IFERROR(MIN(Z12,200000),0)","v":0}]
[null,"7.","Interest from saving Account / Deposits / Income tax refund",{"$nulls":18},{"$f":"Z13","v":0},null,null,11,120000]
[null,"8.","Gross Total Income  [5+6+7]",{"$nulls":19},{"$f":"W9+V11-V10","v":{"v":878310,"d":"₹ 878,310"}},null,12,0]
[null,"9.","Deductions under Chapter VI-A",{"$nulls":21},13,0]
[null,null,"(a)","80C Life insurance premia, deferred annuity, contributions to provident fund etc.",{"$nulls":17},{"$f":"SUM(V15:V18)","v":{"v":143534,"d":"₹ 143,534"}},null,null,14,50000]
[{"$nulls":3},"(i)","GPF/GPF 2004",{"$nulls":16},{"$f":"printF!N26","v":{"v":58834,"d":"₹ 58,834"}},null,null,15,0]
[{"$nulls":3},"(ii)","State Insurance",{"$nulls":16},{"$f":"printF!P26","v":{"v":84000,"d":"₹ 84,000"}},null,null,16,0]
[{"$nulls":3},"(iii)","Group Insurance Accidental",{"$nulls":16},{"$f":"printF!R26","v":{"v":700,"d":"₹ 700"}},null,null,17,0]
[{"$nulls":3},"(iv)","LIC annual premium",{"$nulls":16},{"$f":"printF!T26","v":0},null,null,18,0]
[null,null,"(b)","Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",{"$nulls":17},{"$f":"Z14+Z15+Z16","v":{"v":50000,"d":"₹ 50,000"}},null,null,19,0]
[{"$nulls":3},"Total deductible amount u/s 80C, 80CCC & 80CCD(1)",{"$nulls":17},{"$f":"V14+V19","v":{"v":193534,"d":"₹ 193,534"}},{"$f":"MIN((V14+V19),150000)","v":{"v":150000,"d":"₹ 150,000"}},null,20,0]
[null,null,"(c)","80CCD(1B) Additional contribution towads NPS",{"$nulls":17},{"$f":"Z17","v":0},{"$f":"MIN(V21,50000)","v":0},null,21,0]
[null,null,"(d)","80CCD(2) Employer contribution towards NPS",{"$nulls":17},{"$f":"Z18","v":0},{"$f":"MIN(ROUND(10%*W7,0),V22)","v":0},null,22,0]
[null,null,"(e)","80D Deduction in respect of Health Insurance premia",{"$nulls":17},{"$f":"Z19","v":0},{"$f":"MIN(75000,V23)","v":0},null,23,0]
[null,null,"(f)","80DD Maintenance including medical treatment of a dependent who is a person with disability ",{"$nulls":17},{"$f":"IF(Z20=\"Below 80%\",75000,IF(Z20=\"80% Or Above\",125000,0))","v":0},{"$f":"V24","v":0},null,24,0]
[null,null,"(g)","80DDB Medical treatment of specified disease",{"$nulls":17},{"$f":"Z21","v":0},{"$f":"MIN(100000,V25)","v":0},null,25,0]
[null,null,"(h)","80E Interest on loan taken for higher education ",{"$nulls":17},{"$f":"Z22","v":0},{"$f":"V26","v":0},null,26,0]
[null,null,"(j)","80G Donations to certain funds, charitable institutions, etc.  ",{"$nulls":17},{"$f":"Z23","v":0},{"$f":"V27","v":0}]
[null,null,"(j)","80TTA Interest on saving bank Accounts in case of other than Resident senior citizens",{"$nulls":17},{"$f":"Z24","v":0},{"$f":"MIN(10000,V28,V11)","v":0}]
[null,null,"(k)","80U In case of a person with disability",{"$nulls":17},{"$f":"IF(Z25=\"Below 80%\",75000,IF(Z25=\"80% Or Above\",125000,0))","v":0},{"$f":"V29","v":0}]
[null,"10.","Total Deductions under Chapter VI-A",{"$nulls":19},{"$f":"SUM(W20:W29)","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":"Z26","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":"printF!U26","v":{"v":43000,"d":"₹ 43,000"}}]
[null,"20.","Amount Payable [18-19]",{"$nulls":19},{"$f":"MAX(0,(W44-W45))","v":{"v":17488,"d":"₹ 17,488"}}]
[null,"21.","Refund [19-18]",{"$nulls":19},{"$f":"MAX(0,(W45-W44))","v":0}]
[]
[{"$nulls":21},"Employee Signature"]

{"sheet":"backN","index":5,"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,3,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":"backE!B3","v":"Name (Designation) : Pramod Kumar Saini (Teacher)"},{"$nulls":19},{"$f":"backE!V3","v":"PAN : ASDF1234X"}]
[null,{"$f":"backE!B4","v":"DDO Office : GSSS Malutana"},{"$nulls":19},"As per New Tax Regime"]
[null,"1.","Gross Salary... (Including all allowance u/s 17... i.e. Govt. contribution towards NPS)",{"$nulls":18},{"$f":"printF!M26","v":{"v":984666,"d":"₹ 984,666"}}]
[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":984666,"d":"₹ 984,666"}}]
[null,"4.","Standard Deduction u/s 16(ia)",{"$nulls":18},{"$f":"MAX(MIN(W7,75000),0)","v":{"v":75000,"d":"₹ 75,000"}}]
[null,"5.","Income chargeable under the head ''Salaries'' [3-4]",{"$nulls":19},{"$f":"W7-V8","v":{"v":909666,"d":"₹ 909,666"}}]
[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":"backE!V11","v":0}]
[null,"8.","Gross Total Income  [5+6+7]",{"$nulls":19},{"$f":"W9+V11","v":{"v":909666,"d":"₹ 909,666"}}]
[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}]
[{"$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]
[null,null,"(b)","Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",{"$nulls":17},0]
[{"$nulls":3},"Total deductible amount u/s 80C, 80CCC & 80CCD(1)",{"$nulls":17},{"$f":"V19+V14","v":0},0]
[null,null,"(c)","80CCD(1B) Additional contribution towads NPS",{"$nulls":17},0,0]
[null,null,"(d)","80CCD(2) Employer contribution towards NPS",{"$nulls":17},{"$f":"backE!V22","v":0},{"$f":"MIN(ROUND(W7*10%,0),V22)","v":0}]
[null,null,"(e)","80D Deduction in respect of Health Insurance premia",{"$nulls":17},0,0]
[null,null,"(f)","80DD Maintenance including medical treatment of a dependent who is a person with disability ",{"$nulls":17},0,0]
[null,null,"(g)","80DDB Medical treatment of specified disease",{"$nulls":17},0,0]
[null,null,"(h)","80E Interest on loan taken for higher education ",{"$nulls":17},0,0]
[null,null,"(i)","80G Donations to certain funds, charitable institutions, etc.  ",{"$nulls":17},0,0]
[null,null,"(j)","80TTA Interest on saving bank Accounts in case of other than Resident senior citizens",{"$nulls":17},0,0]
[null,null,"(k)","80U In case of a person with disability",{"$nulls":17},0,0]
[null,"10.","Total Deductions under Chapter VI-A",{"$nulls":19},{"$f":"SUM(W20:W29)","v":0}]
[null,"11.","Total Taxable Income [8-10]",{"$nulls":19},{"$f":"IF(ROUND(W12-W30,-1)<0,0,ROUND(W12-W30,-1))","v":{"v":909670,"d":"₹ 909,670"}}]
[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":209670},{"$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":20967}]
[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":40967,"d":"₹ 40,967"}}]
[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":40967,"d":"₹ 40,967"}}]
[null,"15.","Health and Education Cess",{"$nulls":19},{"$f":"ROUND(4%*W42,0)","v":{"v":1639,"d":"₹ 1,639"}}]
[null,"16.","Total Tax & Cess [14+15]",{"$nulls":19},{"$f":"W42+W43","v":{"v":42606,"d":"₹ 42,606"}}]
[null,"17.","Relief u/s 89",{"$nulls":19},{"$f":"backE!W43","v":0}]
[null,"18.","Balance Tax after Relief [16-17]",{"$nulls":19},{"$f":"W44-W45","v":{"v":42606,"d":"₹ 42,606"}}]
[null,"19.","Total Taxes deducted at Sources",{"$nulls":19},{"$f":"backE!W45","v":{"v":43000,"d":"₹ 43,000"}}]
[null,"20.","Amount Payable [18-19]",{"$nulls":19},{"$f":"MAX(0,(W46-W47))","v":0}]
[null,"21.","Refund [19-18]",{"$nulls":19},{"$f":"MAX(0,(W47-W46))","v":{"v":394,"d":"₹ 394"}}]
[]
[{"$nulls":21},"Employee Signature"]

{"sheet":"compEN","index":6,"n_rows":51,"n_cols":25,"rows_kept":51,"merged":[[1,1,1,22],[2,1,2,11],[2,12,2,20],[2,21,3,21],[2,22,3,22],[3,1,3,11],[3,12,3,20],[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,3,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,10],[31,11,31,19],[32,2,32,5],[32,7,32,8],[32,9,32,10],[32,11,32,14],[32,16,32,17],[32,18,32,19],[33,2,33,5],[33,7,33,8],[33,9,33,10],[33,11,33,14],[33,16,33,17],[33,18,33,19],[34,2,34,5],[34,7,34,8],[34,9,34,10],[34,11,34,14],[34,16,34,17],[34,18,34,19],[35,2,35,5],[35,7,35,8],[35,9,35,10],[35,11,35,14],[35,16,35,17],[35,18,35,19],[36,2,36,5],[36,7,36,8],[36,9,36,10],[36,11,36,14],[36,16,36,17],[36,18,36,19],[37,2,37,10],[37,11,37,14],[37,16,37,17],[37,18,37,19],[38,2,38,10],[38,11,38,14],[38,16,38,17],[38,18,38,19],[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 Camparison for FY 2024-25 Asessment Year 2025-26"]
[null,{"$f":"\"Emp Name : \"&backE!Z2","v":"Emp Name : Pramod Kumar Saini"},{"$nulls":10},{"$f":"\"Emp Desig. : \"&backE!Z3","v":"Emp Desig. : Teacher"},{"$nulls":8},"As per Tax\nOld Regime▼","As per Tax\nNew Regime▼"]
[null,{"$f":"\"Emp PAN : \"&backE!Z4","v":"Emp PAN : ASDF1234X"},{"$nulls":10},{"$f":"\"DDO Office : \"&backE!Z5","v":"DDO Office : GSSS Malutana"}]
[null,"1.","Gross Salary... (Including all allowance u/s 17... i.e. Govt. contribution towards NPS)",{"$nulls":18},{"$f":"backE!V5","v":{"v":984666,"d":"₹ 984,666"}},{"$f":"backN!V5","v":{"v":984666,"d":"₹ 984,666"}}]
[null,"2.","HRA exemption as per eligibility u/s 10(13-A) whether living in … Rented House",{"$nulls":18},{"$f":"backE!V6","v":{"v":56356,"d":"₹ 56,356"}},0]
[null,"3.","Net Salary [1-2]",{"$nulls":18},{"$f":"V5-V6","v":{"v":928310,"d":"₹ 928,310"}},{"$f":"W5-W6","v":{"v":984666,"d":"₹ 984,666"}}]
[null,"4.","Standard Deduction u/s 16(ia)",{"$nulls":18},{"$f":"backE!V8","v":{"v":50000,"d":"₹ 50,000"}},{"$f":"backN!V8","v":{"v":75000,"d":"₹ 75,000"}}]
[null,"5.","Income chargeable under the head ''Salaries'' [3-4]",{"$nulls":18},{"$f":"V7-V8","v":{"v":878310,"d":"₹ 878,310"}},{"$f":"W7-W8","v":{"v":909666,"d":"₹ 909,666"}}]
[null,"6.","Interest payable on borrowed capital u/s 24b",{"$nulls":18},{"$f":"backE!V10","v":0},0]
[null,"7.","Interest from saving Account / Deposits / Income tax refund",{"$nulls":18},{"$f":"backE!V11","v":0},{"$f":"V11","v":0}]
[null,"8.","Gross Total Income  [5+6+7]",{"$nulls":18},{"$f":"V9+V11-V10","v":{"v":878310,"d":"₹ 878,310"}},{"$f":"W9+W11","v":{"v":909666,"d":"₹ 909,666"}}]
[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:V18)","v":{"v":143534,"d":"₹ 143,534"}},0]
[{"$nulls":3},"(i)","GPF/GPF 2004",{"$nulls":16},{"$f":"backE!V15","v":{"v":58834,"d":"₹ 58,834"}},0]
[{"$nulls":3},"(ii)","State Insurance",{"$nulls":16},{"$f":"backE!V16","v":{"v":84000,"d":"₹ 84,000"}},0]
[{"$nulls":3},"(iii)","Group Insurance Accidental",{"$nulls":16},{"$f":"backE!V17","v":{"v":700,"d":"₹ 700"}},0]
[{"$nulls":3},"(iv)","LIC annual premium",{"$nulls":16},{"$f":"backE!V18","v":0},0]
[null,null,"(b)","Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",{"$nulls":17},{"$f":"backE!V19","v":{"v":50000,"d":"₹ 50,000"}},0]
[{"$nulls":3},"Total deductible amount u/s 80C, 80CCC & 80CCD(1)",{"$nulls":17},{"$f":"backE!W20","v":{"v":150000,"d":"₹ 150,000"}},0]
[null,null,"(c)","80CCD(1B) Additional contribution towads NPS",{"$nulls":17},{"$f":"backE!W21","v":0},0]
[null,null,"(d)","80CCD(2) Employer contribution towards NPS",{"$nulls":17},{"$f":"backE!W22","v":0},{"$f":"V22","v":0}]
[null,null,"(e)","80D Deduction in respect of Health Insurance premia",{"$nulls":17},{"$f":"backE!W23","v":0},0]
[null,null,"(f)","80DD Maintenance including medical treatment of a dependent who is a person with disability ",{"$nulls":17},{"$f":"backE!W24","v":0},0]
[null,null,"(g)","80DDB Medical treatment of specified disease",{"$nulls":17},{"$f":"backE!W25","v":0},0]
[null,null,"(h)","80E Interest on loan taken for higher education ",{"$nulls":17},{"$f":"backE!W26","v":0},0]
[null,null,"(j)","80G Donations to certain funds, charitable institutions, etc.  ",{"$nulls":17},{"$f":"backE!W27","v":0},0]
[null,null,"(j)","80TTA Interest on saving bank Accounts in case of other than Resident senior citizens",{"$nulls":17},{"$f":"backE!W28","v":0},0]
[null,null,"(k)","80U In case of a person with disability",{"$nulls":17},{"$f":"backE!W29","v":0},0]
[null,"10.","Total Deductions under Chapter VI-A",{"$nulls":18},{"$f":"SUM(V20:V29)","v":{"v":150000,"d":"₹ 150,000"}},{"$f":"SUM(W20:W29)","v":0}]
[null,"11.","Total Taxable Income [8-10]",{"$nulls":18},{"$f":"ROUND(V12-V30,-1)","v":{"v":728310,"d":"₹ 728,310"}},{"$f":"ROUND(W12-W30,-1)","v":{"v":909670,"d":"₹ 909,670"}}]
[null,null,"Tax Calculation Table (Old Regime)",{"$nulls":8},"Tax Calculation Table (New Regime)"]
[null,null,"Income Slab",{"$nulls":3},"Rate","Income",null,"Tax",null,"Income Slab",{"$nulls":3},"Rate","Income",null,"Tax",{"$nulls":4},{"$f":"SUM(H34:I37)=V31","v":true},{"$f":"SUM(Q34:R39)=W31","v":true}]
[null,null,"Up To ₹ 250000",{"$nulls":3},"Nil",{"$f":"MAX(IF(V31>=250000,250000,V31),0)","v":250000},null,"Nil",null,"Up To ₹ 300000",{"$nulls":3},"Nil",{"$f":"MAX(IF(W31>=300000,300000,W31),0)","v":300000},null,"Nil"]
[null,null,"₹ 250001 To ₹ 500000",{"$nulls":3},{"v":0.05,"d":"5%"},{"$f":"IF(V31>=500000,250000,IF(V31<=250000,0,(V31-250000)))","v":250000},null,{"$f":"ROUND(G35*H35,0)","v":12500},null,"₹ 300001 To ₹ 700000",{"$nulls":3},{"v":0.05,"d":"5%"},{"$f":"IF(W31>=700000,400000,IF(W31<=300000,0,(W31-Q34)))","v":400000},null,{"$f":"ROUND(P35*Q35,0)","v":20000}]
[null,null,"₹ 500001 To ₹ 1000000",{"$nulls":3},{"v":0.2,"d":"20%"},{"$f":"IF(V31>=1000000,500000,IF(V31<=500000,0,(V31-H34-H35)))","v":228310},null,{"$f":"ROUND(G36*H36,0)","v":45662},null,"₹ 700001 To ₹ 1000000",{"$nulls":3},{"v":0.1,"d":"10%"},{"$f":"IF(W31>=1000000,300000,IF(W31<=700000,0,(W31-Q34-Q35)))","v":209670},null,{"$f":"ROUND(P36*Q36,0)","v":20967}]
[null,null,"Above ₹ 1000000",{"$nulls":3},{"v":0.3,"d":"30%"},{"$f":"IF(V31<=1000000,0,(V31-H34-H35-H36))","v":0},null,{"$f":"ROUND(G37*H37,0)","v":0},null,"₹ 1000001 To ₹ 1200000",{"$nulls":3},{"v":0.15,"d":"15%"},{"$f":"IF(W31>=1200000,200000,IF(W31<=1000000,0,(W31-Q34-Q35-Q36)))","v":0},null,{"$f":"ROUND(P37*Q37,0)","v":0}]
[{"$nulls":11},"₹ 1200001 To ₹ 1500000",{"$nulls":3},{"v":0.2,"d":"20%"},{"$f":"IF(W31>=1500000,300000,IF(W31<=1200000,0,(W31-Q34-Q35-Q36-Q37)))","v":0},null,{"$f":"ROUND(P38*Q38,0)","v":0}]
[{"$nulls":11},"Above ₹ 1500000",{"$nulls":3},{"v":0.3,"d":"30%"},{"$f":"IF(W31<=1500000,0,(W31-1500000))","v":0},null,{"$f":"ROUND(P39*Q39,0)","v":0}]
[null,"12.","Tax Payable on Total Income ",{"$nulls":18},{"$f":"SUM(J35:K37)","v":{"v":58162,"d":"₹ 58,162"}},{"$f":"SUM(S35:T39)","v":{"v":40967,"d":"₹ 40,967"}}]
[null,"13.","Rebate u/s 87A with Marginal Relief u/s 115BAC(1A)",{"$nulls":18},{"$f":"IF(V31>500000,0,MIN(12500,V40))","v":0},{"$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":18},{"$f":"V40-V41","v":{"v":58162,"d":"₹ 58,162"}},{"$f":"W40-W41","v":{"v":40967,"d":"₹ 40,967"}}]
[null,"15.","Health and Education Cess",{"$nulls":18},{"$f":"ROUND(4%*V42,0)","v":{"v":2326,"d":"₹ 2,326"}},{"$f":"ROUND(4%*W42,0)","v":{"v":1639,"d":"₹ 1,639"}}]
[null,"16.","Total Tax & Cess [14+15]",{"$nulls":18},{"$f":"V42+V43","v":{"v":60488,"d":"₹ 60,488"}},{"$f":"W42+W43","v":{"v":42606,"d":"₹ 42,606"}}]
[null,"17.","Relief u/s 89",{"$nulls":18},{"$f":"backE!W43","v":0},{"$f":"V45","v":0}]
[null,"18.","Balance Tax after Relief [16-17]",{"$nulls":18},{"$f":"V44-V45","v":{"v":60488,"d":"₹ 60,488"}},{"$f":"W44-W45","v":{"v":42606,"d":"₹ 42,606"}}]
[null,"19.","Total Taxes deducted at Sources",{"$nulls":18},{"$f":"backE!W45","v":{"v":43000,"d":"₹ 43,000"}},{"$f":"V47","v":{"v":43000,"d":"₹ 43,000"}}]
[null,"20.","Amount Payable [18-19]",{"$nulls":18},{"$f":"MAX(0,(V46-V47))","v":{"v":17488,"d":"₹ 17,488"}},{"$f":"MAX(0,(W46-W47))","v":0}]
[null,"21.","Refund [19-18]",{"$nulls":18},{"$f":"MAX(0,(V47-V46))","v":0},{"$f":"MAX(0,(W47-W46))","v":{"v":394,"d":"₹ 394"}}]
[]
[{"$nulls":21},"Employee Signature"]

{"sheet":"reliefC","index":7,"n_rows":33,"n_cols":9,"rows_kept":33,"merged":[[0,1,0,5],[1,1,1,4],[2,1,2,5],[16,1,16,5],[30,1,30,4]]}
[null,"RELIEF CALCULATION UNDER SECTION 89(1)",{"$nulls":5},{"$f":"INDEX(data!A:A,MATCH(reliefC!I1,data!B:B,0))","v":1},"Pramod Kumar Saini"]
[null,{"$f":"\"Name : \"&I3&\" , PAN : \"&I5","v":"Name : Pramod Kumar Saini , PAN : ASDF1234X"},{"$nulls":3},{"$f":"I18","v":0},null,null,{"$f":"VLOOKUP($H$1,pk_Tb,1,0)","v":1}]
[null,"TAX CALCULATED ON RECEIPT BASIS",{"$nulls":6},{"$f":"VLOOKUP($H$1,pk_Tb,2,0)","v":"Pramod Kumar Saini"}]
[null,"Financial Year","2024-25","2023-24","2022-23","2021-22",null,null,{"$f":"VLOOKUP($H$1,pk_Tb,3,0)","v":"Teacher"}]
[null,"Tax Regime",{"$f":"I18","v":0},{"$f":"I15","v":0},{"$f":"I12","v":0},{"$f":"I9","v":0},null,null,{"$f":"VLOOKUP($H$1,pk_Tb,4,0)","v":"ASDF1234X"}]
[null,"Total Income excluding arrears",{"$f":"C8-C7","v":0},{"$f":"D8","v":0},{"$f":"E8","v":0},{"$f":"F8","v":0},null,null,{"$f":"VLOOKUP($H$1,pk_Tb,5,0)","v":"GSSS Malutana"}]
[null,"Add : Arrears of salary",{"$f":"I17","v":0},{"$nulls":4},447,{"$f":"VLOOKUP($H$1,pk_Tb,H7,0)","v":0}]
[null,"Total Income",{"$f":"I16","v":0},{"$f":"I13","v":0},{"$f":"I10","v":0},{"$f":"I7","v":0},null,448,0]
[null,"Tax on total income",{"$f":"ROUND(IF(C5=\"New Regime\",SUMPRODUCT(--(C8>{300000;700000;1000000;1200000;1500000}),(C8-{300000;700000;1000000;1200000;1500000}),({0.05;0.05;0.05;0.05;0.1})),SUMPRODUCT(--(C8>{250000;500000;1000000}),(C8-{250000;500000;1000000}),({0.05;0.15;0.01}))),0)","v":0},{"$f":"ROUND(IF(D5=\"New Regime\",SUMPRODUCT(--(D8>{300000;600000;900000;1200000;1500000}),(D8-{300000;600000;900000;1200000;1500000}),({0.05;0.05;0.05;0.05;0.1})),SUMPRODUCT(--(D8>{250000;500000;1000000}),(D8-{250000;500000;1000000}),({0.05;0.15;0.01}))),0)","v":0},{"$f":"ROUND(IF(E5=\"New Regime\",SUMPRODUCT(--(E8>{250000;500000;750000;1000000;1250000;1500000}),(E8-{250000;500000;750000;1000000;1250000;1500000}),({0.05;0.05;0.05;0.05;0.05;0.05})),SUMPRODUCT(--(E8>{250000;500000;1000000}),(E8-{250000;500000;1000000}),({0.05;0.15;0.01}))),0)","v":0},{"$f":"ROUND(IF(F5=\"New Regime\",SUMPRODUCT(--(F8>{250000;500000;750000;1000000;1250000;1500000}),(F8-{250000;500000;750000;1000000;1250000;1500000}),({0.05;0.05;0.05;0.05;0.05;0.05})),SUMPRODUCT(--(F8>{250000;500000;1000000}),(F8-{250000;500000;1000000}),({0.05;0.15;0.01}))),0)","v":0},null,449,0]
[null,"Less : Rebate u/s 87A",{"$f":"IF(C5=\"New Regime\",IF(C8>700000,0,MIN(25000,C9))+IF(C8>=722224,0,IF(C8<=700000,0,C9-(C8-700000))),IF(C5=\"Old Regime\",IF(C8>500000,0,MIN(12500,C9)),0))","v":0},{"$f":"IF(D5=\"New Regime\",IF(D8>700000,0,MIN(25000,D9)),IF(D5=\"Old Regime\",IF(D8>500000,0,MIN(12500,D9)),0))","v":0},{"$f":"IF(E8>500000,0,MIN(12500,E9))","v":0},{"$f":"IF(F8>500000,0,MIN(12500,F9))","v":0},null,450,0]
[null,"Tax after Rebate",{"$f":"C9-C10","v":0},{"$f":"D9-D10","v":0},{"$f":"E9-E10","v":0},{"$f":"F9-F10","v":0},null,451,0]
[null,"Add : Education cess",{"$f":"ROUND(4%*C11,0)","v":0},{"$f":"ROUND(4%*D11,0)","v":0},{"$f":"ROUND(4%*E11,0)","v":0},{"$f":"ROUND(4%*F11,0)","v":0},null,452,0]
[null,"Surcharge, if applicable",{"$nulls":5},453,0]
[null,"Total Tax",{"$f":"C11+C12","v":0},{"$f":"D11+D12","v":0},{"$f":"E11+E12","v":0},{"$f":"F11+F12","v":0},null,454,0]
[null,"Total Tax (A)",{"$nulls":3},{"$f":"SUM(C14:F14)","v":0},null,455,0]
[{"$nulls":7},456,0]
[null,"TAX CALCULATED ON ACCRUAL BASIS",{"$nulls":5},457,0]
[null,"Financial Year","2024-25","2023-24","2022-23","2021-22",null,458,0]
[null,"Tax Regime",{"$f":"C5","v":0},0,0,0]
[null,"Total Income excluding arrears",0,0,0,0]
[null,"Add : Arrears of salary",null,{"$f":"I14","v":0},{"$f":"I11","v":0},{"$f":"I8","v":0}]
[null,"Total Income",{"$f":"C20","v":0},{"$f":"D20+D21","v":0},{"$f":"E20+E21","v":0},{"$f":"F20+F21","v":0}]
[null,"Tax on total income",{"$f":"ROUND(IF(C19=\"New Regime\",SUMPRODUCT(--(C22>{300000;700000;1000000;1200000;1500000}),(C22-{300000;700000;1000000;1200000;1500000}),({0.05;0.05;0.05;0.05;0.1})),SUMPRODUCT(--(C22>{250000;500000;1000000}),(C22-{250000;500000;1000000}),({0.05;0.15;0.01}))),0)","v":0},{"$f":"ROUND(IF(D19=\"New Regime\",SUMPRODUCT(--(D22>{300000;600000;900000;1200000;1500000}),(D22-{300000;600000;900000;1200000;1500000}),({0.05;0.05;0.05;0.05;0.1})),SUMPRODUCT(--(D22>{250000;500000;1000000}),(D22-{250000;500000;1000000}),({0.05;0.15;0.01}))),0)","v":0},{"$f":"ROUND(IF(E19=\"New Regime\",SUMPRODUCT(--(E22>{250000;500000;750000;1000000;1250000;1500000}),(E22-{250000;500000;750000;1000000;1250000;1500000}),({0.05;0.05;0.05;0.05;0.05;0.05})),SUMPRODUCT(--(E22>{250000;500000;1000000}),(E22-{250000;500000;1000000}),({0.05;0.15;0.01}))),0)","v":0},{"$f":"ROUND(IF(F19=\"New Regime\",SUMPRODUCT(--(F22>{250000;500000;750000;1000000;1250000;1500000}),(F22-{250000;500000;750000;1000000;1250000;1500000}),({0.05;0.05;0.05;0.05;0.05;0.05})),SUMPRODUCT(--(F22>{250000;500000;1000000}),(F22-{250000;500000;1000000}),({0.05;0.15;0.01}))),0)","v":0}]
[null,"Less : Rebate u/s 87A",{"$f":"IF(C19=\"New Regime\",IF(C22>700000,0,MIN(25000,C23))+IF(C22>=722224,0,IF(C22<=700000,0,C23-(C22-700000))),IF(C19=\"Old Regime\",IF(C22>500000,0,MIN(12500,C23)),0))","v":0},{"$f":"IF(D19=\"New Regime\",IF(D22>700000,0,MIN(25000,D23)),IF(D19=\"Old Regime\",IF(D22>500000,0,MIN(12500,D23)),0))","v":0},{"$f":"IF(E22>500000,0,MIN(12500,E23))","v":0},{"$f":"IF(F22>500000,0,MIN(12500,F23))","v":0}]
[null,"Tax after Rebate",{"$f":"C23-C24","v":0},{"$f":"D23-D24","v":0},{"$f":"E23-E24","v":0},{"$f":"F23-F24","v":0}]
[null,"Add : Education cess",{"$f":"ROUND(4%*C25,0)","v":0},{"$f":"ROUND(4%*D25,0)","v":0},{"$f":"ROUND(4%*E25,0)","v":0},{"$f":"ROUND(4%*F25,0)","v":0}]
[null,"Surcharge, if applicable"]
[null,"Total Tax",{"$f":"C25+C26","v":0},{"$f":"D25+D26","v":0},{"$f":"E25+E26","v":0},{"$f":"F25+F26","v":0}]
[null,"Total Tax (B)",{"$nulls":3},{"$f":"SUM(C28:F28)","v":0}]
[]
[null,"Relief Under Section 89(1)       ie       Total Tax (A) - Total Tax (B)",{"$nulls":3},{"$f":"IF((F15-F29)<1,\"Nil\",(F15-F29))","v":"Nil"}]
[]
[{"$nulls":4},"Signature of the employee"]

{"sheet":"form10E","index":8,"n_rows":53,"n_cols":8,"rows_kept":53,"merged":[[0,1,0,7],[1,1,1,7],[2,1,2,7],[3,1,3,3],[3,5,3,7],[4,1,4,3],[4,5,4,7],[5,1,5,3],[5,5,5,7],[6,1,6,7],[7,1,7,6],[8,1,8,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,1,12,5],[13,1,13,7],[14,1,14,7],[15,1,15,7],[17,2,17,3],[18,2,18,3],[19,1,19,5],[20,1,20,7],[22,1,22,7],[23,1,23,7],[24,1,24,7],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[40,1,40,7],[41,1,41,7]]}
[null,"FORM NO.10 E"]
[null,"[See rule 21AA]"]
[null,"Form for furnishing particulars of income under section 192(2A) for the year ending 31 st March, 2025 for claiming relief under section 89(1) by a Government servant or an employee in a Company, Co-operative society, Local authority ,University, Institution, Association or Body."]
[null,"1. Name and Address of the Employee",null,null,":",{"$f":"reliefC!I3","v":"Pramod Kumar Saini"}]
[null,"2. Permanent Account Number",null,null,":",{"$f":"reliefC!I5","v":"ASDF1234X"}]
[null,"3. Residential Status",null,null,":","RESIDENT"]
[null,{"$f":"B6","v":"3. Residential Status"}]
[null,"1. (a) Salary received in arrears or in advance in accordance with the provisions of sub rule (2) of rule 21A",{"$nulls":5},{"$f":"D48","v":0}]
[null,"1. (b) Payment in the nature of gratuity in respect of past services, extending over a period of not less than 5 years in accordance with the provisions of sub-rule (3) of rule 21A",{"$nulls":5},"---Nil---"]
[null,"1. (c) Payment in the nature of compensation from the employer or former employer at or in connection with termination of employment after continuous service of not less than 3 years or where the unexpired portion of term of employment is also not less than 3 years in accordance with the provisions of sub rule (4) of rule 21A",{"$nulls":5},"---Nil---"]
[null,"1. (d) Payment in commutation of pension in accordance with the provisions of sub-rule (5) of rule 21A",{"$nulls":5},"---Nil---"]
[null,"2. Detailed particulars of payments referred to above may be given in Annexure I,II,IIA,III, or IV as the case may be",{"$nulls":5},"Annexure-I"]
[]
[null,"Signature of the employee"]
[null,"Verification"]
[null,{"$f":"\"       I, \"&PROPER(F4)&\", do hereby declare that what is stated aboveis true to the best of my knowledge and belief.\"","v":"       I, Pramod Kumar Saini, do hereby declare that what is stated aboveis true to the best of my knowledge and belief."}]
[null,{"$f":"\"Verified today on the \"&TEXT(C19,\"MMM DD, YYYY\")","v":"Verified today on the Jan 19, 2025"}]
[null,"Place : ---------"]
[null,"Date : ----------",{"$f":"TODAY()","v":"2025-01-19"}]
[]
[null,"Signature of the employee"]
[]
[null,"ANNEXURE-I"]
[null,"[See item 2 of Form No.10E]"]
[null,"ARREARS OR ADVANCE SALARY"]
[null,"Sl No","Particular",{"$nulls":4},"Amount (Rs)"]
[null,1,"Total income \n(excluding salary received in arrears or advance)",{"$nulls":4},{"$f":"H29-H28","v":0}]
[null,2,"Salary received in arrears or advance",{"$nulls":4},{"$f":"D48","v":0}]
[null,3,"Total income \n(as increased by salary received in arrears or advance) \n[Add item 1 and item 2]",{"$nulls":4},{"$f":"reliefC!C8","v":0}]
[null,4,"Tax on total income \n[as per item 3]",{"$nulls":4},{"$f":"reliefC!C14","v":0}]
[null,5,"Tax on total income \n[as per item 1]",{"$nulls":4},{"$f":"reliefC!C28","v":0}]
[null,6,"Tax on salary received in arrears or advance \n[Difference of item 4 and item 5]",{"$nulls":4},{"$f":"H30-H31","v":0}]
[null,7,"Tax computed in accordance with Table \"A\" \n[Brought from column 7 of Table A]",{"$nulls":4},{"$f":"H48","v":0}]
[null,8,"Relief under Section 89(1)\n[Indicate difference between the amounts mentioned against item 6 and item 7]",{"$nulls":4},{"$f":"IF((H32-H33)<1,\"No Relief\",H32-H33)","v":"No Relief"}]
[]
[{"$nulls":6},"Signature of the employee"]
[{"$nulls":4},"Name:",{"$f":"reliefC!I3","v":"Pramod Kumar Saini"}]
[{"$nulls":4},"Designation:",{"$f":"reliefC!I4","v":"Teacher"}]
[{"$nulls":4},"Office:",{"$f":"reliefC!I6","v":"GSSS Malutana"}]
[]
[null,"TABLE \"A\""]
[null,"[See item 7 of Annexure 1]"]
[null,"Previous year(s)","Total income of the relevent previous year\n(Rs.)","Salary received in arrears or advance relating to the relevent previous year as mentioned in column (1)\n(Rs.)","Total income (as increased by salary received in arrears or advance) of the relevent previous year mentioned in column (1)\n(Rs.)","Tax on total income [as per column (2)-After Rebate and including Edn Cess and Surcharge]\n(Rs.)","Tax on total income[as per column (4) After Rebate and including Edn Cess and Surcharge]\n(Rs.)","Difference in tax [Amount under column (6) minus amount under column  (5)]\n(Rs.)"]
[null,"(1)","(2)","(3)","(4)","(5)","(6)","(7)"]
[null,"2021-22",{"$f":"reliefC!F20","v":0},{"$f":"reliefC!F21","v":0},{"$f":"C45+D45","v":0},{"$f":"reliefC!F14","v":0},{"$f":"reliefC!F28","v":0},{"$f":"G45-F45","v":0}]
[null,"2022-23",{"$f":"reliefC!E20","v":0},{"$f":"reliefC!E21","v":0},{"$f":"C46+D46","v":0},{"$f":"reliefC!E14","v":0},{"$f":"reliefC!E28","v":0},{"$f":"G46-F46","v":0}]
[null,"2023-24",{"$f":"reliefC!D20","v":0},{"$f":"reliefC!D21","v":0},{"$f":"C47+D47","v":0},{"$f":"reliefC!D14","v":0},{"$f":"reliefC!D28","v":0},{"$f":"G47-F47","v":0}]
[null,"Total",{"$f":"SUM(C45:C47)","v":0},0,0,0,0,0]
[]
[{"$nulls":6},"Signature of the employee"]
[{"$nulls":4},"Name:",{"$f":"F37","v":"Pramod Kumar Saini"}]
[{"$nulls":4},"Designation:",{"$f":"F38","v":"Teacher"}]
[{"$nulls":4},"Office:",{"$f":"F39","v":"GSSS Malutana"}]