{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MAIN","data","salary","printF","backE","backN","compEN","reliefC","form10E"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":14,"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":"MAIN","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[[12,0,12,16],[13,0,13,16],[7,0,7,16],[8,0,8,16],[9,0,9,16],[10,0,10,16],[11,0,11,16],[0,0,0,16],[6,0,6,16],[1,0,1,16],[2,0,2,16],[3,0,3,16],[4,0,4,16],[5,0,5,16],[19,0,19,16],[14,0,14,16],[15,0,15,16],[16,0,16,16],[17,0,17,16],[18,0,18,16]]}
["pksaini"]
["Income Tax Utility"]
["2024-25"]
["with truly unlimited employees for office use"]
[{"$f":"_xlfn.UNICHAR(ROW()-4+9311)&\"  DATA ENTRY\"","v":"①  DATA ENTRY"}]
[{"$f":"_xlfn.UNICHAR(ROW()-4+9311)&\"  SALARY SHEET / SALARY FORM\"","v":"②  SALARY SHEET / SALARY FORM"}]
[{"$f":"_xlfn.UNICHAR(ROW()-4+9311)&\"  PRINT PDF\"","v":"③  PRINT PDF"}]

{"sheet":"data","index":1,"n_rows":4,"n_cols":458,"rows_kept":4,"cut":false,"hidden":false,"merged":[[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,426,2,445],[2,326,2,345],[2,346,2,365],[2,366,2,385],[2,386,2,405],[2,406,2,425],[0,446,0,457],[1,446,1,448],[1,449,1,451],[1,452,1,454],[1,455,1,457]]}
["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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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",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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,"TI","SA","TR","TI","SA","TR","TI","SA","TR","TI","SA","TR"]
[1,"Pramod Kumar Saini","Teacher","ASDFG","GSSS Malutana",49300,7,null,12,700,100000,null,null,null,null,58834,50000,58834,7934,null,null,null,null,null,null,null,49300,49300,49300,49300,50800,50800,50800,50800,50800,50800,50800,50800,null,null,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,24650,24650,24650,24650,25400,25400,25400,25400,26924,26924,26924,26924,3944,6096,null,0,null,null,null,null,4437,4437,4437,4437,4572,4572,4572,4572,5080,5080,5080,5080,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6774,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,5000,5000,5000,5000,5000,5000,5000,2850,2850,2850,2850,2850,3944,6096,null,null,1694,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,7000,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,658,658,658,658,658,658,658,658,658,658,658,658,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,4000,4000,4000,4000,4000,4000,4000,3000,3000,3000,3000,3000,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,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,31411,2142,"New Regime",21424,1242,"New Regime",null,null,null,null,3384]

{"sheet":"salary","index":2,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,25],[2,1,2,25],[0,1,0,25],[3,13,3,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[3,1,4,1],[3,2,3,11],[3,12,4,12]]}
[null,"Select Employee▼"]
[{"$f":"INDEX(data!$A:$A,MATCH(salary!$B$2,data!$B:$B,0))","v":1},"Pramod Kumar Saini",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A2","v":1}]
[null,{"$f":"IFERROR(VLOOKUP(A2,pk_Tb,4,0),\"\")","v":"ASDFG"}]
[null,"Month\nYear","------------------Allowances---------------------",null,null,null,null,null,null,null,null,null,"Total\nAllow","------------------Deductions---------------------",null,null,null,null,null,null,null,null,null,"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,null,null,null,null,null,{"$f":"SUM(C6:J6)+L6-K6","v":78387},2850,null,3000,null,null,658,null,null,null,null,{"$f":"SUM(N6:W6)","v":6508},{"$f":"M6-X6","v":71879}]
[null,"2024-04-01",49300,{"$f":"D6","v":0},{"$f":"E6","v":0},24650,4437,{"$f":"H6","v":0},{"$f":"I6","v":0},null,null,{"$f":"L6","v":0},{"$f":"SUM(C7:J7)+L7-K7","v":78387},2850,{"$f":"O6","v":0},3000,{"$f":"Q6","v":0},700,658,{"$f":"T6","v":0},{"$f":"U6","v":0},{"$f":"V6","v":0},{"$f":"W6","v":0},{"$f":"SUM(N7:W7)","v":7208},{"$f":"M7-X7","v":71179}]
[null,"2024-05-01",49300,{"$f":"D7","v":0},{"$f":"E7","v":0},24650,4437,{"$f":"H7","v":0},{"$f":"I7","v":0},null,null,{"$f":"L7","v":0},78387,2850,{"$f":"O7","v":0},3000,{"$f":"Q7","v":0},null,658,{"$f":"T7","v":0},{"$f":"U7","v":0},{"$f":"V7","v":0},{"$f":"W7","v":0},6508,71879]
[null,"2024-06-01",49300,0,0,24650,4437,0,0,null,null,0,78387,2850,0,3000,0,null,658,0,0,0,0,6508,71879]
[null,"2024-07-01",50800,0,0,25400,4572,0,0,null,null,0,80772,2850,0,3000,0,null,658,0,0,0,0,6508,74264]
[null,"2024-08-01",50800,0,0,25400,4572,0,0,null,null,0,80772,2850,0,3000,0,null,658,0,0,0,0,6508,74264]
[null,"2024-09-01",50800,0,0,25400,4572,0,0,null,null,0,80772,2850,0,3000,0,null,658,0,0,0,0,6508,74264]
[null,"2024-10-01",50800,0,0,25400,4572,0,0,null,null,0,80772,2850,0,3000,0,null,658,0,0,0,0,6508,74264]
[null,"2024-11-01",50800,0,0,26924,5080,0,0,null,null,0,82804,2850,0,3000,0,null,658,0,0,0,0,6508,76296]
[null,"2024-12-01",50800,0,0,26924,5080,0,0,null,null,0,82804,2850,0,3000,0,null,658,0,0,0,0,6508,76296]
[null,"2025-01-01",50800,0,0,26924,5080,0,0,null,null,0,82804,2850,0,3000,0,null,658,0,0,0,0,6508,76296]
[null,"2025-02-01",50800,0,0,26924,5080,0,0,null,null,0,82804,2850,0,3000,0,null,658,0,0,0,0,6508,76296]
[null,"DA Arr",null,null,null,3944,null,null,null,null,null,null,3944,3944,null,null,null,null,null,null,null,null,null,3944,0]
[null,"DA Arr",null,null,null,6096,null,null,null,null,null,null,6096,6096,null,null,null,null,null,null,null,null,null,6096,0]
[null,"HRA Arr",null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Surrender",0,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Bonus",null,null,null,null,null,null,null,6774,null,null,6774,1694,null,null,null,null,null,null,null,null,null,1694,5080]
[null,"Arrear",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Arrear",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Arrear",null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,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,45934,0,36000,0,700,7896,0,0,0,0,90530,894136]

{"sheet":"printF","index":3,"n_rows":28,"n_cols":496,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,13,3,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[0,1,0,25],[1,14,1,17],[2,14,2,17],[1,18,1,24],[2,18,2,24],[1,2,1,5],[1,6,1,12],[2,2,2,5],[2,6,2,12],[3,1,4,1],[3,2,3,11],[3,12,4,12]]}
[null,"Annual Salary Statement of the Financial Year 2024-25",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,{"$f":"INDEX(data!$A:$A,MATCH(printF!$AC$1,data!$B:$B,0))","v":1},"Pramod Kumar Saini",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-01",50,46,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Designation","Posting Place"]
[null,null,"Employee Name :",null,null,null,{"$f":"VLOOKUP($AB$1,pk_Tb,2,0)","v":"Pramod Kumar Saini"},null,null,null,null,null,null,null,"Employee Desig. :",null,null,null,{"$f":"VLOOKUP($AB$1,pk_Tb,3,0)","v":"Teacher"},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,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,"2024-02-01",50,46,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Principal","GSSS Malutana"]
[null,null,"Employee PAN :",null,null,null,{"$f":"VLOOKUP($AB$1,pk_Tb,4,0)","v":"ASDFG"},null,null,null,null,null,null,null,"DDO Office :",null,null,null,{"$f":"VLOOKUP($AB$1,pk_Tb,5,0)","v":"GSSS Malutana"},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,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,"2024-03-01",50,50,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Vice Principal","MGGS Bandrol"]
[null,"Month\nYear","------------------Allowances---------------------",null,null,null,null,null,null,null,null,null,"Gross\nAmount","------------------Deductions---------------------",null,null,null,null,null,null,null,null,null,"Total \nDedu","Net\nAmount","TV \nNo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pramod Kumar Saini",null,null,null,null,null,null,null,null,null,null,"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},null,null,null,null,null,null,null,null,null,"2024-04-01",50,50,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Lecturer","GGUPS Malutana"]
[null,null,"Basic",null,null,"DA","HRA","CCA",null,"Bonus","ROP",null,null,"GPF","GPFL","SI","SIL","GIS","RGHS","LIC","ITAX",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,{"$f":"INDEX(data!A:A,MATCH(printF!AX4,data!B:B,0))","v":1},null,null,null,null,null,null,null,null,null,null,"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},null,null,null,null,null,null,null,null,null,"2024-05-01",50,50,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Sr Teacher","GPS Khatiyon Ki Dhani"]
[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},null,null,null,null,null,null,null,null,null,"2024-06-01",50,50,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Teacher","GPS Rada Binjala"]
[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,null,null,null,null,null,null,null,null,null,"2024-07-01",53,50,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"PET III","GPS Guwara Hanuman"]
[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,null,null,null,null,null,null,null,null,null,"2024-08-01",53,50,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Prabodhak","GPS Bali Ki Dhani"]
[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":"ASDFG"},"2024-06-01",{"$f":"AZ8","v":49300},24650,4437,null,2850,3000,null,658,2850,"50","50",0,0,"9","9",0,0,null,null,null,null,null,null,null,null,null,"2024-09-01",53,50,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Sr Assistant","MGGS Dehra"]
[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,null,null,null,null,null,null,null,null,null,"2024-10-01",53,50,9,9,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,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,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,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,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,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,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,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,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,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,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,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,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,"Jr Assistant","AddNew3"]
[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,null,null,null,null,null,null,null,null,null,"2024-11-01",53,53,10,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,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,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,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,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,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,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,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,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,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,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,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,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,"BCI","AddNew2"]
[null,"2024-09-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,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,null,null,null,null,null,null,null,null,null,"2024-12-01",53,53,10,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,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,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,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,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,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,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,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,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,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,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,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,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,"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,null,null,null,null,null,null,null,null,null,"2025-01-01",53,53,10,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,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,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,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,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,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,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,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,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,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,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,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,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,"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,null,null,null,null,null,null,null,null,null,"2025-02-01",53,53,10,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,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,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,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,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,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,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,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,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,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,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,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,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,"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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,"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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,"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,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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,"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},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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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},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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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},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,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,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,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,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,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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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},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,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,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,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,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,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,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,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,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,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,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,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,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,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,"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",null,null,null,{"$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,60984,0,84000,0,700,7896,0,43000,0,0,196580,788086]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee Signature",null,null,null,null,null,null,null,null,"DDO Signature"]

{"sheet":"backE","index":4,"n_rows":49,"n_cols":27,"rows_kept":49,"cut":false,"hidden":false,"merged":[[43,2,43,20],[44,2,44,20],[45,2,45,20],[46,2,46,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],[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],[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],[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],[27,3,27,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],[15,4,15,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],[0,1,0,22],[1,1,1,22],[2,1,2,20],[2,21,2,22],[3,1,3,20],[3,21,3,22]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Pramod Kumar Saini"]
[null,{"$f":"\"Name (Designation) : \"&Z2&\" (\"&Z3&\")\"","v":"Name (Designation) : Pramod Kumar Saini (Teacher)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"PAN : \"&Z4","v":"PAN : ASDFG"},null,null,3,"Teacher"]
[null,{"$f":"\"DDO Office : \"&Z5","v":"DDO Office : GSSS Malutana"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As per Old Tax Regime",null,null,4,"ASDFG"]
[null,"1.","Gross Salary... (Including all allowance u/s 17... i.e. Govt. contribution towards NPS)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"printF!M26","v":984666},null,null,5,"GSSS Malutana"]
[null,"2.","HRA exemption as per eligibility u/s 10(13-A) whether living in … Rented House",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MIN(Z11,SUM(salary!G6:G17)),0)","v":56356}]
[null,"3.","Net Salary [1-2]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V5-V6","v":928310}]
[null,"4.","Standard Deduction u/s 16(ia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(MIN(50000,W7),0)","v":50000}]
[null,"5.","Income chargeable under the head ''Salaries'' [3-4]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W7-V8","v":878310}]
[null,"6.","Interest payable on borrowed capital u/s 24b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MIN(Z12,200000),0)","v":0}]
[null,"7.","Interest from saving Account / Deposits / Income tax refund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z13","v":0},null,null,11,100000]
[null,"8.","Gross Total Income  [5+6+7]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9+V11-V10","v":878310},null,12,0]
[null,"9.","Deductions under Chapter VI-A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0]
[null,null,"(a)","80C Life insurance premia, deferred annuity, contributions to provident fund etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V15:V18)","v":145684},null,null,14,0]
[null,null,null,"(i)","GPF/GPF 2004",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"printF!N26","v":60984},null,null,15,0]
[null,null,null,"(ii)","State Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"printF!P26","v":84000},null,null,16,58834]
[null,null,null,"(iii)","Group Insurance Accidental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"printF!R26","v":700},null,null,17,50000]
[null,null,null,"(iv)","LIC annual premium",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"printF!T26","v":0},null,null,18,58834]
[null,null,"(b)","Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z14+Z15+Z16","v":58834},null,null,19,7934]
[null,null,null,"Total deductible amount u/s 80C, 80CCC & 80CCD(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V14+V19","v":204518},{"$f":"MIN((V14+V19),150000)","v":150000},null,20,0]
[null,null,"(c)","80CCD(1B) Additional contribution towads NPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z17","v":50000},{"$f":"MIN(V21,50000)","v":50000},null,21,0]
[null,null,"(d)","80CCD(2) Employer contribution towards NPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z18","v":58834},{"$f":"MIN(ROUND(10%*W7,0),V22)","v":58834},null,22,0]
[null,null,"(e)","80D Deduction in respect of Health Insurance premia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z19","v":7934},{"$f":"MIN(75000,V23)","v":7934},null,23,0]
[null,null,"(f)","80DD Maintenance including medical treatment of a dependent who is a person with disability ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z21","v":0},{"$f":"MIN(100000,V25)","v":0},null,25,0]
[null,null,"(h)","80E Interest on loan taken for higher education ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z22","v":0},{"$f":"V26","v":0},null,26,0]
[null,null,"(j)","80G Donations to certain funds, charitable institutions, etc.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z24","v":0},{"$f":"MIN(10000,V28,V11)","v":0}]
[null,null,"(k)","80U In case of a person with disability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W20:W29)","v":266768}]
[null,"11.","Total Taxable Income [8-10]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(W12-W30,-1)<0,0,ROUND(W12-W30,-1))","v":611540}]
[null,null,"Tax Calculation Table"]
[null,null,"Income Slab",null,null,null,null,null,"Rate",null,"Taxable Income",null,null,null,"Tax"]
[null,null,"Up To ₹ 250000",null,null,null,null,null,"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",null,null,null,null,null,0.05,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",null,null,null,null,null,0.2,null,{"$f":"IF(W31>=1000000,500000,IF(W31<=500000,0,(W31-K34-K35)))","v":111540},null,null,null,{"$f":"ROUND(I36*K36,0)","v":22308}]
[null,null,"Above ₹ 1000000",null,null,null,null,null,0.3,null,{"$f":"IF(W31<=1000000,0,(W31-1000000))","v":0},null,null,null,{"$f":"ROUND(I37*K37,0)","v":0},null,null,null,{"$f":"W31=SUM(K34:N37)","v":true}]
[null,"12.","Tax Payable on Total Income ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O35:R37)","v":34808}]
[null,"13.","Rebate u/s 87A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(W31>=500000,0,MIN(12500,W38))","v":0}]
[null,"14.","Tax Payable after Rebate [12-13]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W38-W39","v":34808}]
[null,"15.","Health and Education Cess",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(4%*W40,0)","v":1392}]
[null,"16.","Total Tax & Cess [14+15]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W40+W41","v":36200}]
[null,"17.","Relief u/s 89",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z26","v":0}]
[null,"18.","Balance Tax after Relief [16-17]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W42-W43","v":36200}]
[null,"19.","Total Taxes deducted at Sources",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"printF!U26","v":43000}]
[null,"20.","Amount Payable [18-19]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,(W44-W45))","v":0}]
[null,"21.","Refund [19-18]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,(W45-W44))","v":6800}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee Signature"]

{"sheet":"backN","index":5,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":false,"merged":[[45,2,45,20],[46,2,46,20],[47,2,47,20],[48,2,48,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],[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],[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],[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],[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],[28,3,28,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],[16,4,16,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],[4,2,4,20],[1,1,1,22],[2,1,2,20],[2,21,2,22],[3,1,3,20],[3,21,3,22]]}
[]
[null,"Income Tax Calculation for Financial Year 2024-25 Assessment Year 2025-26"]
[null,{"$f":"backE!B3","v":"Name (Designation) : Pramod Kumar Saini (Teacher)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V3","v":"PAN : ASDFG"}]
[null,{"$f":"backE!B4","v":"DDO Office : GSSS Malutana"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As per New Tax Regime"]
[null,"1.","Gross Salary... (Including all allowance u/s 17... i.e. Govt. contribution towards NPS)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"printF!M26","v":984666}]
[null,"2.","HRA exemption as per eligibility u/s 10(13-A) whether living in … Rented House",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"3.","Net Salary [1-2]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V5-V6","v":984666}]
[null,"4.","Standard Deduction u/s 16(ia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(MIN(W7,75000),0)","v":75000}]
[null,"5.","Income chargeable under the head ''Salaries'' [3-4]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W7-V8","v":909666}]
[null,"6.","Interest payable on borrowed capital u/s 24b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"7.","Interest from saving Account / Deposits / Income tax refund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V11","v":0}]
[null,"8.","Gross Total Income  [5+6+7]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W9+V11","v":909666}]
[null,"9.","Deductions under Chapter VI-A"]
[null,null,"(a)","80C Life insurance premia, deferred annuity, contributions to provident fund etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V15:V19)","v":0}]
[null,null,null,"(i)","GPF/GPF 2004",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"(ii)","State Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"(iii)","Group Insurance Accidental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"(iv)","LIC annual premium",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"(b)","Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Total deductible amount u/s 80C, 80CCC & 80CCD(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V19+V14","v":0},0]
[null,null,"(c)","80CCD(1B) Additional contribution towads NPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"(d)","80CCD(2) Employer contribution towards NPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V22","v":58834},{"$f":"MIN(ROUND(W7*10%,0),V22)","v":58834}]
[null,null,"(e)","80D Deduction in respect of Health Insurance premia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"(f)","80DD Maintenance including medical treatment of a dependent who is a person with disability ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"(g)","80DDB Medical treatment of specified disease",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"(h)","80E Interest on loan taken for higher education ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"(i)","80G Donations to certain funds, charitable institutions, etc.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"(j)","80TTA Interest on saving bank Accounts in case of other than Resident senior citizens",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"(k)","80U In case of a person with disability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"10.","Total Deductions under Chapter VI-A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W20:W29)","v":58834}]
[null,"11.","Total Taxable Income [8-10]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(W12-W30,-1)<0,0,ROUND(W12-W30,-1))","v":850830}]
[null,null,"Tax Calculation Table"]
[null,null,"Income Slab",null,null,null,null,null,"Rate",null,"Taxable Income",null,null,null,"Tax"]
[null,null,"Up To ₹ 300000",null,null,null,null,null,"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",null,null,null,null,null,0.05,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",null,null,null,null,null,0.1,null,{"$f":"IF(W31>=1000000,300000,IF(W31<=700000,0,(W31-K34-K35)))","v":150830},{"$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":15083}]
[null,null,"₹ 1000001 To ₹ 1200000",null,null,null,null,null,0.15,null,{"$f":"IF(W31>=1200000,200000,IF(W31<=1000000,0,(W31-K34-K35-K36)))","v":0},null,null,null,{"$f":"ROUND(I37*K37,0)","v":0}]
[null,null,"₹ 1200001 To ₹ 1500000",null,null,null,null,null,0.2,null,{"$f":"IF(W31>=1500000,300000,IF(W31<=1200000,0,(W31-K34-K35-K36-K37)))","v":0},null,null,null,{"$f":"ROUND(I38*K38,0)","v":0}]
[null,null,"Above ₹ 1500000",null,null,null,null,null,0.3,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},null,null,null,{"$f":"W31=SUM(K34:N39)","v":true}]
[null,"12.","Tax Payable on Total Income ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O35:R39)","v":35083}]
[null,"13.","Rebate u/s 87A with Marginal Relief u/s 115BAC(1A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W40-W41","v":35083}]
[null,"15.","Health and Education Cess",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(4%*W42,0)","v":1403}]
[null,"16.","Total Tax & Cess [14+15]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W42+W43","v":36486}]
[null,"17.","Relief u/s 89",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W43","v":0}]
[null,"18.","Balance Tax after Relief [16-17]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W44-W45","v":36486}]
[null,"19.","Total Taxes deducted at Sources",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W45","v":43000}]
[null,"20.","Amount Payable [18-19]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,(W46-W47))","v":0}]
[null,"21.","Refund [19-18]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,(W47-W46))","v":6514}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee Signature"]

{"sheet":"compEN","index":6,"n_rows":51,"n_cols":25,"rows_kept":51,"cut":false,"hidden":false,"merged":[[14,4,14,20],[1,1,1,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],[2,21,3,21],[2,22,3,22],[2,1,2,11],[2,12,2,20],[28,3,28,20],[15,4,15,20],[16,4,16,20],[17,4,17,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],[32,18,32,19],[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],[36,9,36,10],[36,11,36,14],[36,16,36,17],[34,18,34,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],[46,2,46,20],[47,2,47,20],[48,2,48,20],[18,3,18,20],[19,3,19,20],[20,3,20,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],[37,2,37,10],[37,11,37,14],[37,16,37,17],[37,18,37,19],[3,1,3,11],[3,12,3,20],[45,2,45,20],[38,2,38,10],[38,11,38,14],[38,16,38,17],[38,18,38,19],[36,18,36,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]]}
[]
[null,"Income Tax Camparison for FY 2024-25 Asessment Year 2025-26"]
[null,{"$f":"\"Emp Name : \"&backE!Z2","v":"Emp Name : Pramod Kumar Saini"},null,null,null,null,null,null,null,null,null,null,{"$f":"\"Emp Desig. : \"&backE!Z3","v":"Emp Desig. : Teacher"},null,null,null,null,null,null,null,null,"As per Tax\nOld Regime▼","As per Tax\nNew Regime▼"]
[null,{"$f":"\"Emp PAN : \"&backE!Z4","v":"Emp PAN : ASDFG"},null,null,null,null,null,null,null,null,null,null,{"$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)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V5","v":984666},{"$f":"backN!V5","v":984666}]
[null,"2.","HRA exemption as per eligibility u/s 10(13-A) whether living in … Rented House",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V6","v":56356},0]
[null,"3.","Net Salary [1-2]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V5-V6","v":928310},{"$f":"W5-W6","v":984666}]
[null,"4.","Standard Deduction u/s 16(ia)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V8","v":50000},{"$f":"backN!V8","v":75000}]
[null,"5.","Income chargeable under the head ''Salaries'' [3-4]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V7-V8","v":878310},{"$f":"W7-W8","v":909666}]
[null,"6.","Interest payable on borrowed capital u/s 24b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V10","v":0},0]
[null,"7.","Interest from saving Account / Deposits / Income tax refund",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V11","v":0},{"$f":"V11","v":0}]
[null,"8.","Gross Total Income  [5+6+7]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V9+V11-V10","v":878310},{"$f":"W9+W11","v":909666}]
[null,"9.","Deductions under Chapter VI-A"]
[null,null,"(a)","80C Life insurance premia, deferred annuity, contributions to provident fund etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V15:V18)","v":145684},0]
[null,null,null,"(i)","GPF/GPF 2004",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V15","v":60984},0]
[null,null,null,"(ii)","State Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V16","v":84000},0]
[null,null,null,"(iii)","Group Insurance Accidental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V17","v":700},0]
[null,null,null,"(iv)","LIC annual premium",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V18","v":0},0]
[null,null,"(b)","Any other deductible total amount u/s 80C, 80CCC & 80CCD(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!V19","v":58834},0]
[null,null,null,"Total deductible amount u/s 80C, 80CCC & 80CCD(1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W20","v":150000},0]
[null,null,"(c)","80CCD(1B) Additional contribution towads NPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W21","v":50000},0]
[null,null,"(d)","80CCD(2) Employer contribution towards NPS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W22","v":58834},{"$f":"V22","v":58834}]
[null,null,"(e)","80D Deduction in respect of Health Insurance premia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W23","v":7934},0]
[null,null,"(f)","80DD Maintenance including medical treatment of a dependent who is a person with disability ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W24","v":0},0]
[null,null,"(g)","80DDB Medical treatment of specified disease",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W25","v":0},0]
[null,null,"(h)","80E Interest on loan taken for higher education ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W26","v":0},0]
[null,null,"(j)","80G Donations to certain funds, charitable institutions, etc.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W27","v":0},0]
[null,null,"(j)","80TTA Interest on saving bank Accounts in case of other than Resident senior citizens",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W28","v":0},0]
[null,null,"(k)","80U In case of a person with disability",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W29","v":0},0]
[null,"10.","Total Deductions under Chapter VI-A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V20:V29)","v":266768},{"$f":"SUM(W20:W29)","v":58834}]
[null,"11.","Total Taxable Income [8-10]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(V12-V30,-1)","v":611540},{"$f":"ROUND(W12-W30,-1)","v":850830}]
[null,null,"Tax Calculation Table (Old Regime)",null,null,null,null,null,null,null,null,"Tax Calculation Table (New Regime)"]
[null,null,"Income Slab",null,null,null,"Rate","Income",null,"Tax",null,"Income Slab",null,null,null,"Rate","Income",null,"Tax",null,null,null,null,{"$f":"SUM(H34:I37)=V31","v":true},{"$f":"SUM(Q34:R39)=W31","v":true}]
[null,null,"Up To ₹ 250000",null,null,null,"Nil",{"$f":"MAX(IF(V31>=250000,250000,V31),0)","v":250000},null,"Nil",null,"Up To ₹ 300000",null,null,null,"Nil",{"$f":"MAX(IF(W31>=300000,300000,W31),0)","v":300000},null,"Nil"]
[null,null,"₹ 250001 To ₹ 500000",null,null,null,0.05,{"$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",null,null,null,0.05,{"$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",null,null,null,0.2,{"$f":"IF(V31>=1000000,500000,IF(V31<=500000,0,(V31-H34-H35)))","v":111540},null,{"$f":"ROUND(G36*H36,0)","v":22308},null,"₹ 700001 To ₹ 1000000",null,null,null,0.1,{"$f":"IF(W31>=1000000,300000,IF(W31<=700000,0,(W31-Q34-Q35)))","v":150830},null,{"$f":"ROUND(P36*Q36,0)","v":15083}]
[null,null,"Above ₹ 1000000",null,null,null,0.3,{"$f":"IF(V31<=1000000,0,(V31-H34-H35-H36))","v":0},null,{"$f":"ROUND(G37*H37,0)","v":0},null,"₹ 1000001 To ₹ 1200000",null,null,null,0.15,{"$f":"IF(W31>=1200000,200000,IF(W31<=1000000,0,(W31-Q34-Q35-Q36)))","v":0},null,{"$f":"ROUND(P37*Q37,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"₹ 1200001 To ₹ 1500000",null,null,null,0.2,{"$f":"IF(W31>=1500000,300000,IF(W31<=1200000,0,(W31-Q34-Q35-Q36-Q37)))","v":0},null,{"$f":"ROUND(P38*Q38,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Above ₹ 1500000",null,null,null,0.3,{"$f":"IF(W31<=1500000,0,(W31-1500000))","v":0},null,{"$f":"ROUND(P39*Q39,0)","v":0}]
[null,"12.","Tax Payable on Total Income ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J35:K37)","v":34808},{"$f":"SUM(S35:T39)","v":35083}]
[null,"13.","Rebate u/s 87A with Marginal Relief u/s 115BAC(1A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$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]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V40-V41","v":34808},{"$f":"W40-W41","v":35083}]
[null,"15.","Health and Education Cess",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(4%*V42,0)","v":1392},{"$f":"ROUND(4%*W42,0)","v":1403}]
[null,"16.","Total Tax & Cess [14+15]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V42+V43","v":36200},{"$f":"W42+W43","v":36486}]
[null,"17.","Relief u/s 89",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W43","v":0},{"$f":"V45","v":0}]
[null,"18.","Balance Tax after Relief [16-17]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V44-V45","v":36200},{"$f":"W44-W45","v":36486}]
[null,"19.","Total Taxes deducted at Sources",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"backE!W45","v":43000},{"$f":"V47","v":43000}]
[null,"20.","Amount Payable [18-19]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,(V46-V47))","v":0},{"$f":"MAX(0,(W46-W47))","v":0}]
[null,"21.","Refund [19-18]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,(V47-V46))","v":6800},{"$f":"MAX(0,(W47-W46))","v":6514}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee Signature"]

{"sheet":"reliefC","index":7,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,1,2,5],[16,1,16,5],[30,1,30,4],[1,1,1,4]]}
[null,"RELIEF CALCULATION UNDER SECTION 89(1)",null,null,null,null,null,{"$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 : ASDFG"},null,null,null,{"$f":"I18","v":0},null,null,{"$f":"VLOOKUP($H$1,pk_Tb,1,0)","v":1}]
[null,"TAX CALCULATED ON RECEIPT BASIS",null,null,null,null,null,null,{"$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":"New Regime"},{"$f":"I9","v":"New Regime"},null,null,{"$f":"VLOOKUP($H$1,pk_Tb,4,0)","v":"ASDFG"}]
[null,"Total Income excluding arrears",{"$f":"C8-C7","v":-3384},{"$f":"D8","v":0},{"$f":"E8","v":21424},{"$f":"F8","v":31411},null,null,{"$f":"VLOOKUP($H$1,pk_Tb,5,0)","v":"GSSS Malutana"}]
[null,"Add : Arrears of salary",{"$f":"I17","v":3384},null,null,null,null,447,{"$f":"VLOOKUP($H$1,pk_Tb,H7,0)","v":31411}]
[null,"Total Income",{"$f":"I16","v":0},{"$f":"I13","v":0},{"$f":"I10","v":21424},{"$f":"I7","v":31411},null,448,2142]
[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,"New Regime"]
[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,21424]
[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,1242]
[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,"New Regime"]
[null,"Surcharge, if applicable",null,null,null,null,null,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)",null,null,null,{"$f":"SUM(C14:F14)","v":0},null,455,0]
[null,null,null,null,null,null,null,456,0]
[null,"TAX CALCULATED ON ACCRUAL BASIS",null,null,null,null,null,457,3384]
[null,"Financial Year","2024-25","2023-24","2022-23","2021-22",null,458,0]
[null,"Tax Regime",{"$f":"C5","v":0},0,"New Regime","New Regime"]
[null,"Total Income excluding arrears",-3384,0,21424,31411]
[null,"Add : Arrears of salary",null,{"$f":"I14","v":0},{"$f":"I11","v":1242},{"$f":"I8","v":2142}]
[null,"Total Income",{"$f":"C20","v":-3384},{"$f":"D20+D21","v":0},{"$f":"E20+E21","v":22666},{"$f":"F20+F21","v":33553}]
[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)",null,null,null,{"$f":"SUM(C28:F28)","v":0}]
[]
[null,"Relief Under Section 89(1)       ie       Total Tax (A) - Total Tax (B)",null,null,null,{"$f":"IF((F15-F29)<1,\"Nil\",(F15-F29))","v":"Nil"}]
[]
[null,null,null,null,"Signature of the employee"]

{"sheet":"form10E","index":8,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[9,1,9,6],[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],[23,1,23,7],[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],[41,1,41,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]]}
[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":"ASDFG"}]
[null,"3. Residential Status",null,null,":","RESIDENT"]
[null,"Particulars of income referred to in rule 21A of the Income-tax Rules, 1962,during the previous year relevant to assessment year 2024-25 (Rs.)"]
[null,"1. (a) Salary received in arrears or in advance in accordance with the provisions of sub rule (2) of rule 21A",null,null,null,null,null,{"$f":"D48","v":3384}]
[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",null,null,null,null,null,"---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",null,null,null,null,null,"---Nil---"]
[null,"1. (d) Payment in commutation of pension in accordance with the provisions of sub-rule (5) of rule 21A",null,null,null,null,null,"---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",null,null,null,null,null,"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 Nov 07, 2024"}]
[null,"Place : ---------"]
[null,"Date : ----------",{"$f":"TODAY()","v":"2024-11-07"}]
[]
[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",null,null,null,null,"Amount (Rs)"]
[null,1,"Total income \n(excluding salary received in arrears or advance)",null,null,null,null,{"$f":"H29-H28","v":-3384}]
[null,2,"Salary received in arrears or advance",null,null,null,null,{"$f":"D48","v":3384}]
[null,3,"Total income \n(as increased by salary received in arrears or advance) \n[Add item 1 and item 2]",null,null,null,null,{"$f":"reliefC!C8","v":0}]
[null,4,"Tax on total income \n[as per item 3]",null,null,null,null,{"$f":"reliefC!C14","v":0}]
[null,5,"Tax on total income \n[as per item 1]",null,null,null,null,{"$f":"reliefC!C28","v":0}]
[null,6,"Tax on salary received in arrears or advance \n[Difference of item 4 and item 5]",null,null,null,null,{"$f":"H30-H31","v":0}]
[null,7,"Tax computed in accordance with Table \"A\" \n[Brought from column 7 of Table A]",null,null,null,null,{"$f":"H48","v":0}]
[null,8,"Relief under Section 89(1)\n[Indicate difference between the amounts mentioned against item 6 and item 7]",null,null,null,null,{"$f":"IF((H32-H33)<1,\"No Relief\",H32-H33)","v":"No Relief"}]
[]
[null,null,null,null,null,null,"Signature of the employee"]
[null,null,null,null,"Name:",{"$f":"reliefC!I3","v":"Pramod Kumar Saini"}]
[null,null,null,null,"Designation:",{"$f":"reliefC!I4","v":"Teacher"}]
[null,null,null,null,"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":31411},{"$f":"reliefC!F21","v":2142},{"$f":"C45+D45","v":33553},{"$f":"reliefC!F14","v":0},{"$f":"reliefC!F28","v":0},{"$f":"G45-F45","v":0}]
[null,"2022-23",{"$f":"reliefC!E20","v":21424},{"$f":"reliefC!E21","v":1242},{"$f":"C46+D46","v":22666},{"$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":52835},3384,56219,0,0,0]
[]
[null,null,null,null,null,null,"Signature of the employee"]
[null,null,null,null,"Name:",{"$f":"F37","v":"Pramod Kumar Saini"}]
[null,null,null,null,"Designation:",{"$f":"F38","v":"Teacher"}]
[null,null,null,null,"Office:",{"$f":"F39","v":"GSSS Malutana"}]