{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4"],"not_rendered":{"images":8,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":20,"n_cols":12,"rows_kept":20,"merged":[[0,1,0,11],[1,1,1,11],[2,1,2,11],[2,13,2,17],[3,1,4,1],[3,2,3,4],[3,5,3,7],[3,8,3,9],[3,10,4,10],[3,11,4,11]]}
[]
[null,"Arrear Calculator"]
[null,"from January 01, 2021 to December 31, 2026 (Today)"]
[null,"SN","Employee Detail",null,null,"Arrear Detail",null,null,"Basic Pay",null,"PF \nType","ITax/TDS"]
[null,null,"Name","Desig.","Office","Type","From","To","Due","Drawn"]
[null,{"$f":"IF(COUNTBLANK(C6:K6)>0,\"\",COUNTA($C$6:C6))","v":1},"Pramod Kumar Saini","Teacher","Govt Sr Sc Sch Malutana (Thanagazi) Alwar","Salary","2021-01-01","2025-01-18",47900,45100,"GPF 2004",{"v":0.1,"d":"10%"}]
[null,{"$f":"IF(COUNTBLANK(C7:K7)>0,\"\",COUNTA($C$6:C7))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C8:K8)>0,\"\",COUNTA($C$6:C8))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C9:K9)>0,\"\",COUNTA($C$6:C9))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C10:K10)>0,\"\",COUNTA($C$6:C10))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C11:K11)>0,\"\",COUNTA($C$6:C11))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C12:K12)>0,\"\",COUNTA($C$6:C12))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C13:K13)>0,\"\",COUNTA($C$6:C13))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C14:K14)>0,\"\",COUNTA($C$6:C14))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C15:K15)>0,\"\",COUNTA($C$6:C15))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C16:K16)>0,\"\",COUNTA($C$6:C16))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C17:K17)>0,\"\",COUNTA($C$6:C17))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C18:K18)>0,\"\",COUNTA($C$6:C18))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C19:K19)>0,\"\",COUNTA($C$6:C19))","v":""}]
[null,{"$f":"IF(COUNTBLANK(C20:K20)>0,\"\",COUNTA($C$6:C20))","v":""}]

{"sheet":"Sheet2","index":1,"n_rows":77,"n_cols":37,"rows_kept":77}
[null,{"$f":"Sheet3!$B$3","v":1},{"$f":"IFERROR(VLOOKUP(B1,Sheet1!$B$6:$L$20,2,0),\"\")","v":"Pramod Kumar Saini"}]
[null,null,{"$f":"IFERROR(VLOOKUP(B1,Sheet1!$B$6:$L$20,3,0),\"\")","v":"Teacher"}]
[null,null,{"$f":"\"Office \"&IFERROR(VLOOKUP(B1,Sheet1!$B$6:$L$20,4,0),\"\")","v":"Office Govt Sr Sc Sch Malutana (Thanagazi) Alwar"}]
[null,null,{"$f":"VLOOKUP(B1,Sheet1!$B$6:$L$20,5,0)&\" Arrear from \"&TEXT(VLOOKUP(B1,Sheet1!$B$6:$L$20,6,0),\"DD-MMM-YYYY\")& \" to \"&TEXT(VLOOKUP(B1,Sheet1!$B$6:$L$20,7,0),\"MMM-YYYY\")","v":"Salary Arrear from 01-Jan-2021 to Jan-2025"}]
[{"$nulls":10},"MY","Due\nBasic","Due\nDA","Due\nHRA",null,"Drawn\nBasic","Due\nDA","Due\nHRA",{"$nulls":4},"Due\nGPF",{"$nulls":3},"Drawn\nGPF","Due\nRGHS","Drawn\nRGHS",{"$f":"VLOOKUP($B$1,saini,11,0)","v":{"v":0.1,"d":"10%"}},null,null,"Due DA","Drawn DA","Diff","Due HRA","Drawn HRA"]
[null,{"$f":"DAY(IFERROR(VLOOKUP($B$1,saini,6,0),\"Error\"))","v":1},{"$f":"VLOOKUP(C9,F6:H77,3,0)","v":31},1,2021,{"$f":"D6&\"-\"&E6","v":"1-2021"},1,31,{"$f":"IFERROR(IF($C$10<G6,\"\",IF($C$11<=G6,F6,\"\")),\"\")","v":"1-2021"},null,{"$f":"I6","v":"1-2021"},{"$f":"IFERROR(IF(I6=\"\",0,IF($C$11=$G$6,$B$12,0)),\"\")","v":47900},{"$f":"ROUND(L6*AG6/100,0)","v":8143},{"$f":"ROUND(L6*AJ6/100,0)","v":3832},{"$f":"SUM(L6:N6)","v":59875},{"$f":"IFERROR(IF(I6=\"\",0,IF($C$11=$G$6,$C$12,0)),\"\")","v":45100},{"$f":"ROUND(P6*AH6/100,0)","v":7667},{"$f":"ROUND(P6*AK6/100,0)","v":3608},{"$f":"SUM(P6:R6)","v":56375},{"$f":"IF(L6>51500,3575,IF(L6>38500,2850,IF(L6>28500,2100,IF(L6>23000,1625,IF(L6>0,1450,0)))))","v":2850},{"$f":"IF(L6>167000,10500,IF(L6>116000,8900,IF(L6>80000,6150,IF(L6>72000,4800,IF(L6>62000,4200,T6)))))","v":2850},{"$f":"ROUND(L6*AI6/100,0)","v":0},{"$f":"U6+V6","v":2850},{"$f":"IF(P6>51500,3575,IF(P6>38500,2850,IF(P6>28500,2100,IF(P6>23000,1625,IF(P6>0,1450,0)))))","v":2850},{"$f":"IF(P6>167000,10500,IF(P6>116000,8900,IF(P6>80000,6150,IF(P6>72000,4800,IF(P6>62000,4200,X6)))))","v":2850},{"$f":"ROUND(P6*AI6/100,0)","v":0},{"$f":"Y6+Z6","v":2850},{"$f":"IF(L6>54000,875,IF(L6>33500,658,IF(L6>18000,440,IF(L6>0,265,0))))","v":658},{"$f":"IF(P6>54000,875,IF(P6>33500,658,IF(P6>18000,440,IF(P6>0,265,0))))","v":658},{"$f":"ROUND((O6-S6)*$AD$5,0)","v":350},null,null,17,17,{"$f":"AG6-AH6","v":0},8,8]
[null,{"$f":"MONTH(IFERROR(VLOOKUP($B$1,saini,6,0),\"Error\"))","v":1},{"$f":"MONTH(IFERROR(VLOOKUP($B$1,saini,7,0),\"Error\"))","v":1},2,2021,{"$f":"D7&\"-\"&E7","v":"2-2021"},2,28,"2-2021",null,"2-2021",{"$f":"IFERROR(IF(I7=\"\",0,IF(L6>0,$B$13,$B$12)),\"\")","v":47900},{"$f":"ROUND(L7*AG7/100,0)","v":8143},{"$f":"ROUND(L7*AJ7/100,0)","v":3832},{"$f":"SUM(L7:N7)","v":59875},{"$f":"IFERROR(IF(I7=\"\",0,IF(P6>0,$C$13,$C$12)),\"\")","v":45100},{"$f":"ROUND(P7*AH7/100,0)","v":7667},{"$f":"ROUND(P7*AK7/100,0)","v":3608},{"$f":"SUM(P7:R7)","v":56375},2850,2850,{"$f":"ROUND(L7*AI7/100,0)","v":0},{"$f":"U7+V7","v":2850},2850,2850,{"$f":"ROUND(P7*AI7/100,0)","v":0},{"$f":"Y7+Z7","v":2850},658,658,{"$f":"ROUND((O7-S7)*$AD$5,0)","v":350},null,null,17,17,{"$f":"AG7-AH7","v":0},8,8]
[null,{"$f":"YEAR(IFERROR(VLOOKUP($B$1,saini,6,0),\"Error\"))","v":2021},{"$f":"YEAR(IFERROR(VLOOKUP($B$1,saini,7,0),\"Error\"))","v":2025},3,2021,"3-2021",3,31,"3-2021",null,"3-2021",{"$f":"IFERROR(IF(I8=\"\",0,IF(L7>0,$B$13,$B$12)),\"\")","v":47900},8143,3832,59875,{"$f":"IFERROR(IF(I8=\"\",0,IF(P7>0,$C$13,$C$12)),\"\")","v":45100},7667,3608,56375,2850,2850,0,2850,2850,2850,0,2850,658,658,350,null,null,17,17,0,8,8]
[null,{"$f":"B7&\"-\"&B8","v":"1-2021"},{"$f":"C7&\"-\"&C8","v":"1-2025"},4,2021,"4-2021",4,30,"4-2021",null,"4-2021",{"$f":"IFERROR(IF(I9=\"\",0,IF(L8>0,$B$13,$B$12)),\"\")","v":47900},8143,3832,59875,{"$f":"IFERROR(IF(I9=\"\",0,IF(P8>0,$C$13,$C$12)),\"\")","v":45100},7667,3608,56375,2850,2850,0,2850,2850,2850,0,2850,658,658,350,null,null,17,17,0,8,8]
[null,{"$f":"VLOOKUP(B9,F6:H77,3,0)-B6+1","v":31},{"$f":"VLOOKUP(C9,F6:H77,2,0)","v":49},5,2021,"5-2021",5,31,"5-2021",null,"5-2021",{"$f":"IFERROR(IF(I10=\"\",0,IF(L9>0,$B$13,$B$12)),\"\")","v":47900},8143,3832,59875,{"$f":"IFERROR(IF(I10=\"\",0,IF(P9>0,$C$13,$C$12)),\"\")","v":45100},7667,3608,56375,2850,2850,0,2850,2850,2850,0,2850,658,658,350,null,null,17,17,0,8,8]
[null,{"$f":"VLOOKUP(B9,F6:H77,3,0)","v":31},{"$f":"VLOOKUP(B9,F6:H77,2,0)","v":1},6,2021,"6-2021",6,30,"6-2021",null,"6-2021",{"$f":"IFERROR(IF(I11=\"\",0,IF(L10>0,$B$13,$B$12)),\"\")","v":47900},8143,3832,59875,{"$f":"IFERROR(IF(I11=\"\",0,IF(P10>0,$C$13,$C$12)),\"\")","v":45100},7667,3608,56375,2850,2850,0,2850,2850,2850,0,2850,658,658,350,null,null,17,17,0,8,8]
[null,{"$f":"ROUND((B13/B11)*B10,0)","v":47900},{"$f":"ROUND((C13/B11)*B10,0)","v":45100},7,2021,"7-2021",7,31,"7-2021",null,"7-2021",{"$f":"IFERROR(IF(I12=\"\",0,IF($C$11<7,$B$14,IF(L11>0,$B$13,$B$12))),\"\")","v":49300},15283,4437,69020,{"$f":"IFERROR(IF(I12=\"\",0,IF($C$11<7,$C$14,IF(P11>0,$C$13,$C$12))),\"\")","v":46500},7905,4185,58590,2850,2850,6902,9752,2850,2850,6510,9360,658,658,1043,null,null,31,17,14,9,9]
[null,{"$f":"IFERROR(VLOOKUP($B$1,saini,8,0),\"Error\")","v":47900},{"$f":"IFERROR(VLOOKUP($B$1,saini,9,0),\"Error\")","v":45100},8,2021,"8-2021",8,31,"8-2021",null,"8-2021",49300,15283,4437,69020,46500,7905,4185,58590,2850,2850,6902,9752,2850,2850,6510,9360,658,658,1043,null,null,31,17,14,9,9]
[null,{"$f":"MROUND(B13*103%,100)","v":49300},46500,9,2021,"9-2021",9,30,"9-2021",null,"9-2021",49300,15283,4437,69020,46500,7905,4185,58590,2850,2850,6902,9752,2850,2850,6510,9360,658,658,1043,null,null,31,17,14,9,9]
[null,50800,47900,10,2021,"10-2021",10,31,"10-2021",null,"10-2021",49300,15283,4437,69020,46500,14415,4185,65100,2850,2850,0,2850,2850,2850,0,2850,658,658,392,null,null,31,31,0,9,9]
[null,52300,49300,11,2021,"11-2021",11,30,"11-2021",null,"11-2021",49300,15283,4437,69020,46500,14415,4185,65100,2850,2850,0,2850,2850,2850,0,2850,658,658,392,null,null,31,31,0,9,9]
[null,53900,50800,12,2021,"12-2021",12,31,"12-2021",null,"12-2021",49300,15283,4437,69020,46500,14415,4185,65100,2850,2850,0,2850,2850,2850,0,2850,658,658,392,null,null,31,31,0,9,9]
[null,55500,52300,1,2022,"1-2022",13,31,"1-2022",null,"1-2022",49300,16762,4437,70499,46500,14415,4185,65100,2850,2850,1479,4329,2850,2850,1395,4245,658,658,540,null,null,34,31,3,9,9]
[null,57200,53900,2,2022,"2-2022",14,28,"2-2022",null,"2-2022",49300,16762,4437,70499,46500,14415,4185,65100,2850,2850,1479,4329,2850,2850,1395,4245,658,658,540,null,null,34,31,3,9,9]
[{"$nulls":3},3,2022,"3-2022",15,31,"3-2022",null,"3-2022",49300,16762,4437,70499,46500,14415,4185,65100,2850,2850,1479,4329,2850,2850,1395,4245,658,658,540,null,null,34,31,3,9,9]
[{"$nulls":3},4,2022,"4-2022",16,30,"4-2022",null,"4-2022",49300,16762,4437,70499,46500,15810,4185,66495,2850,2850,0,2850,2850,2850,0,2850,658,658,400,null,null,34,34,0,9,9]
[{"$nulls":3},5,2022,"5-2022",17,31,"5-2022",null,"5-2022",49300,16762,4437,70499,46500,15810,4185,66495,2850,2850,0,2850,2850,2850,0,2850,658,658,400,null,null,34,34,0,9,9]
[{"$nulls":3},6,2022,"6-2022",18,30,"6-2022",null,"6-2022",49300,16762,4437,70499,46500,15810,4185,66495,2850,2850,0,2850,2850,2850,0,2850,658,658,400,null,null,34,34,0,9,9]
[{"$nulls":3},7,2022,"7-2022",19,31,"7-2022",null,"7-2022",{"$f":"IFERROR(IF(I24=\"\",0,IF($C$11<7,$B$15,IF(AND($C$11>6,$C$11<19),$B$14,IF($C$11=$G$24,$B$12)))),\"\")","v":50800},19304,4572,74676,{"$f":"IFERROR(IF(I24=\"\",0,IF($C$11<7,$C$15,IF(AND($C$11>6,$C$11<19),$C$14,IF($C$11=$G$24,$C$12)))),\"\")","v":47900},16286,4311,68497,2850,2850,2032,4882,2850,2850,1916,4766,658,658,618,null,null,38,34,4,9,9]
[{"$nulls":3},8,2022,"8-2022",20,31,"8-2022",null,"8-2022",{"$f":"IFERROR(IF(I25=\"\",0,IF($C$11<7,$B$15,IF(AND($C$11>6,$C$11<19),$B$14,IF(L24>0,$B$13,$B$12)))),\"\")","v":50800},19304,4572,74676,{"$f":"IFERROR(IF(I25=\"\",0,IF($C$11<7,$C$15,IF(AND($C$11>6,$C$11<19),$C$14,IF(P24>0,$C$13,$C$12)))),\"\")","v":47900},16286,4311,68497,2850,2850,2032,4882,2850,2850,1916,4766,658,658,618,null,null,38,34,4,9,9]
[{"$nulls":3},9,2022,"9-2022",21,30,"9-2022",null,"9-2022",50800,19304,4572,74676,47900,16286,4311,68497,2850,2850,2032,4882,2850,2850,1916,4766,658,658,618,null,null,38,34,4,9,9]
[{"$nulls":3},10,2022,"10-2022",22,31,"10-2022",null,"10-2022",50800,19304,4572,74676,47900,18202,4311,70413,2850,2850,0,2850,2850,2850,0,2850,658,658,426,null,null,38,38,0,9,9]
[{"$nulls":3},11,2022,"11-2022",23,30,"11-2022",null,"11-2022",50800,19304,4572,74676,47900,18202,4311,70413,2850,2850,0,2850,2850,2850,0,2850,658,658,426,null,null,38,38,0,9,9]
[{"$nulls":3},12,2022,"12-2022",24,31,"12-2022",null,"12-2022",50800,19304,4572,74676,47900,18202,4311,70413,2850,2850,0,2850,2850,2850,0,2850,658,658,426,null,null,38,38,0,9,9]
[{"$nulls":3},1,2023,"1-2023",25,31,"1-2023",null,"1-2023",50800,21336,4572,76708,47900,18202,4311,70413,2850,2850,2032,4882,2850,2850,1916,4766,658,658,630,null,null,42,38,4,9,9]
[{"$nulls":3},2,2023,"2-2023",26,28,"2-2023",null,"2-2023",50800,21336,4572,76708,47900,18202,4311,70413,2850,2850,2032,4882,2850,2850,1916,4766,658,658,630,null,null,42,38,4,9,9]
[{"$nulls":3},3,2023,"3-2023",27,31,"3-2023",null,"3-2023",50800,21336,4572,76708,47900,18202,4311,70413,2850,2850,2032,4882,2850,2850,1916,4766,658,658,630,null,null,42,38,4,9,9]
[{"$nulls":3},4,2023,"4-2023",28,30,"4-2023",null,"4-2023",50800,21336,4572,76708,47900,20118,4311,72329,2850,2850,0,2850,2850,2850,0,2850,658,658,438,null,null,42,42,0,9,9]
[{"$nulls":3},5,2023,"5-2023",29,31,"5-2023",null,"5-2023",50800,21336,4572,76708,47900,20118,4311,72329,2850,2850,0,2850,2850,2850,0,2850,658,658,438,null,null,42,42,0,9,9]
[{"$nulls":3},6,2023,"6-2023",30,30,"6-2023",null,"6-2023",50800,21336,4572,76708,47900,20118,4311,72329,2850,2850,0,2850,2850,2850,0,2850,658,658,438,null,null,42,42,0,9,9]
[{"$nulls":3},7,2023,"7-2023",31,31,"7-2023",null,"7-2023",{"$f":"IFERROR(IF(I36=\"\",0,IF($C$11<7,$B$16,IF(AND($C$11>6,$C$11<19),$B$15,IF(AND($C$11>18,$C$11<31),$B$14,IF($C$11=$G$36,$B$12))))),\"\")","v":52300},24058,4707,81065,{"$f":"IFERROR(IF(I36=\"\",0,IF($C$11<7,$C$16,IF(AND($C$11>6,$C$11<19),$C$15,IF(AND($C$11>18,$C$11<31),$C$14,IF($C$11=$G$36,$C$12))))),\"\")","v":49300},22678,4437,76415,3575,3575,0,3575,2850,2850,0,2850,658,658,465,null,null,46,46,0,9,9]
[{"$nulls":3},8,2023,"8-2023",32,31,"8-2023",null,"8-2023",{"$f":"IFERROR(IF(I37=\"\",0,IF($C$11<7,$B$16,IF(AND($C$11>6,$C$11<19),$B$15,IF(AND($C$11>18,$C$11<31),$B$14,IF(L36>0,$B$13,$B$12))))),\"\")","v":52300},24058,4707,81065,{"$f":"IFERROR(IF(I37=\"\",0,IF($C$11<7,$C$16,IF(AND($C$11>6,$C$11<19),$C$15,IF(AND($C$11>18,$C$11<31),$C$14,IF(P36>0,$C$13,$C$12))))),\"\")","v":49300},22678,4437,76415,3575,3575,0,3575,2850,2850,0,2850,658,658,465,null,null,46,46,0,9,9]
[{"$nulls":3},9,2023,"9-2023",33,30,{"$f":"IFERROR(IF($C$10<G38,\"\",IF($C$11<=G38,F38,\"\")),\"\")","v":"9-2023"},null,{"$f":"I38","v":"9-2023"},52300,24058,4707,81065,49300,22678,4437,76415,{"$f":"IF(L38>51500,3575,IF(L38>38500,2850,IF(L38>28500,2100,IF(L38>23000,1625,IF(L38>0,1450,0)))))","v":3575},{"$f":"IF(L38>167000,10500,IF(L38>116000,8900,IF(L38>80000,6150,IF(L38>72000,4800,IF(L38>62000,4200,T38)))))","v":3575},0,3575,{"$f":"IF(P38>51500,3575,IF(P38>38500,2850,IF(P38>28500,2100,IF(P38>23000,1625,IF(P38>0,1450,0)))))","v":2850},{"$f":"IF(P38>167000,10500,IF(P38>116000,8900,IF(P38>80000,6150,IF(P38>72000,4800,IF(P38>62000,4200,X38)))))","v":2850},0,2850,{"$f":"IF(L38>54000,875,IF(L38>33500,658,IF(L38>18000,440,IF(L38>0,265,0))))","v":658},{"$f":"IF(P38>54000,875,IF(P38>33500,658,IF(P38>18000,440,IF(P38>0,265,0))))","v":658},465,null,null,46,46,0,9,9]
[{"$nulls":3},10,2023,"10-2023",34,31,"10-2023",null,"10-2023",52300,24058,4707,81065,49300,22678,4437,76415,3575,3575,0,3575,2850,2850,0,2850,658,658,465,null,null,46,46,0,9,9]
[{"$nulls":3},11,2023,"11-2023",35,30,"11-2023",null,"11-2023",52300,24058,4707,81065,49300,22678,4437,76415,3575,3575,0,3575,2850,2850,0,2850,658,658,465,null,null,46,46,0,9,9]
[{"$nulls":3},12,2023,"12-2023",36,31,"12-2023",null,"12-2023",52300,24058,4707,81065,49300,22678,4437,76415,3575,3575,0,3575,2850,2850,0,2850,658,658,465,null,null,46,46,0,9,9]
[{"$nulls":3},1,2024,"1-2024",37,31,"1-2024",null,"1-2024",52300,26150,4707,83157,49300,24650,4437,78387,3575,3575,0,3575,2850,2850,0,2850,658,658,477,null,null,50,50,0,9,9]
[{"$nulls":3},2,2024,"2-2024",38,29,"2-2024",null,"2-2024",52300,26150,4707,83157,49300,24650,4437,78387,3575,3575,0,3575,2850,2850,0,2850,658,658,477,null,null,50,50,0,9,9]
[{"$nulls":3},3,2024,"3-2024",39,31,"3-2024",null,"3-2024",52300,26150,4707,83157,49300,24650,4437,78387,3575,3575,0,3575,2850,2850,0,2850,658,658,477,null,null,50,50,0,9,9]
[{"$nulls":3},4,2024,"4-2024",40,30,"4-2024",null,"4-2024",52300,26150,4707,83157,49300,24650,4437,78387,3575,3575,0,3575,2850,2850,0,2850,658,658,477,null,null,50,50,0,9,9]
[{"$nulls":3},5,2024,"5-2024",41,31,"5-2024",null,"5-2024",52300,26150,4707,83157,49300,24650,4437,78387,3575,3575,0,3575,2850,2850,0,2850,658,658,477,null,null,50,50,0,9,9]
[{"$nulls":3},6,2024,"6-2024",42,30,"6-2024",null,"6-2024",52300,26150,4707,83157,49300,24650,4437,78387,3575,3575,0,3575,2850,2850,0,2850,658,658,477,null,null,50,50,0,9,9]
[{"$nulls":3},7,2024,"7-2024",43,31,"7-2024",null,"7-2024",{"$f":"IFERROR(IF(I48=\"\",0,IF($C$11<7,$B$17,IF(AND($C$11>6,$C$11<19),$B$16,IF(AND($C$11>18,$C$11<31),$B$15,IF(AND($C$11>30,$C$11<43),$B$14,IF($C$11=$G$48,$B$12)))))),\"\")","v":53900},28567,4851,87318,{"$f":"IFERROR(IF(I48=\"\",0,IF($C$11<7,$C$17,IF(AND($C$11>6,$C$11<19),$C$16,IF(AND($C$11>18,$C$11<31),$C$15,IF(AND($C$11>30,$C$11<43),$C$14,IF($C$11=$G$48,$C$12)))))),\"\")","v":50800},26924,4572,82296,3575,3575,0,3575,2850,2850,0,2850,658,658,502,null,null,53,53,0,9,9]
[{"$nulls":3},8,2024,"8-2024",44,31,"8-2024",null,"8-2024",{"$f":"IFERROR(IF(I49=\"\",0,IF($C$11<7,$B$17,IF(AND($C$11>6,$C$11<19),$B$16,IF(AND($C$11>18,$C$11<31),$B$15,IF(AND($C$11>30,$C$11<43),$B$14,IF(L48>0,$B$13,$B$12)))))),\"\")","v":53900},28567,4851,87318,{"$f":"IFERROR(IF(I49=\"\",0,IF($C$11<7,$C$17,IF(AND($C$11>6,$C$11<19),$C$16,IF(AND($C$11>18,$C$11<31),$C$15,IF(AND($C$11>30,$C$11<43),$C$14,IF(P48>0,$C$13,$C$12)))))),\"\")","v":50800},26924,4572,82296,3575,3575,0,3575,2850,2850,0,2850,658,658,502,null,null,53,53,0,9,9]
[{"$nulls":3},9,2024,"9-2024",45,30,"9-2024",null,"9-2024",53900,28567,4851,87318,50800,25400,4572,80772,3575,3575,1617,5192,2850,2850,1524,4374,658,658,655,null,null,53,50,3,9,9]
[{"$nulls":3},10,2024,"10-2024",46,31,"10-2024",null,"10-2024",53900,0,0,53900,50800,0,0,50800,3575,3575,0,3575,2850,2850,0,2850,658,658,310]
[{"$nulls":3},11,2024,"11-2024",47,30,"11-2024",null,"11-2024",53900,0,0,53900,50800,0,0,50800,3575,3575,0,3575,2850,2850,0,2850,658,658,310]
[{"$nulls":3},12,2024,"12-2024",48,31,"12-2024",null,"12-2024",53900,0,0,53900,50800,0,0,50800,3575,3575,0,3575,2850,2850,0,2850,658,658,310]
[{"$nulls":3},1,2025,"1-2025",49,31,"1-2025",null,"1-2025",53900,0,0,53900,50800,0,0,50800,3575,3575,0,3575,2850,2850,0,2850,658,658,310]
[{"$nulls":3},2,2025,"2-2025",50,28,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},3,2025,"3-2025",51,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},4,2025,"4-2025",52,30,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},5,2025,"5-2025",53,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},6,2025,"6-2025",54,30,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},7,2025,"7-2025",55,31,"",null,"",{"$f":"IFERROR(IF(I60=\"\",0,IF($C$11<7,$B$18,IF(AND($C$11>6,$C$11<19),$B$17,IF(AND($C$11>18,$C$11<31),$B$16,IF(AND($C$11>30,$C$11<43),$B$15,IF(AND($C$11>42,$C$11<55),$B$14,IF($C$11=$G$60,$B$12))))))),\"\")","v":0},0,0,0,{"$f":"IFERROR(IF(I60=\"\",0,IF($C$11<7,$C$18,IF(AND($C$11>6,$C$11<19),$C$17,IF(AND($C$11>18,$C$11<31),$C$16,IF(AND($C$11>30,$C$11<43),$C$15,IF(AND($C$11>42,$C$11<55),$C$14,IF($C$11=$G$60,$C$12))))))),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},8,2025,"8-2025",56,31,"",null,"",{"$f":"IFERROR(IF(I61=\"\",0,IF($C$11<7,$B$18,IF(AND($C$11>6,$C$11<19),$B$17,IF(AND($C$11>18,$C$11<31),$B$16,IF(AND($C$11>30,$C$11<43),$B$15,IF(AND($C$11>42,$C$11<55),$B$14,IF(L60>0,$B$13,$B$12))))))),\"\")","v":0},0,0,0,{"$f":"IFERROR(IF(I61=\"\",0,IF($C$11<7,$C$18,IF(AND($C$11>6,$C$11<19),$C$17,IF(AND($C$11>18,$C$11<31),$C$16,IF(AND($C$11>30,$C$11<43),$C$15,IF(AND($C$11>42,$C$11<55),$C$14,IF(P60>0,$C$13,$C$12))))))),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},9,2025,"9-2025",57,30,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},10,2025,"10-2025",58,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},11,2025,"11-2025",59,30,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},12,2025,"12-2025",60,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},1,2026,"1-2026",61,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},2,2026,"2-2026",62,28,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},3,2026,"3-2026",63,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},4,2026,"4-2026",64,30,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},5,2026,"5-2026",65,31,{"$f":"IFERROR(IF($C$10<G70,\"\",IF($C$11<=G70,F70,\"\")),\"\")","v":""},null,{"$f":"I70","v":""},0,0,0,0,0,0,0,0,{"$f":"IF(L70>51500,3575,IF(L70>38500,2850,IF(L70>28500,2100,IF(L70>23000,1625,IF(L70>0,1450,0)))))","v":0},{"$f":"IF(L70>167000,10500,IF(L70>116000,8900,IF(L70>80000,6150,IF(L70>72000,4800,IF(L70>62000,4200,T70)))))","v":0},0,0,{"$f":"IF(P70>51500,3575,IF(P70>38500,2850,IF(P70>28500,2100,IF(P70>23000,1625,IF(P70>0,1450,0)))))","v":0},{"$f":"IF(P70>167000,10500,IF(P70>116000,8900,IF(P70>80000,6150,IF(P70>72000,4800,IF(P70>62000,4200,X70)))))","v":0},0,0,{"$f":"IF(L70>54000,875,IF(L70>33500,658,IF(L70>18000,440,IF(L70>0,265,0))))","v":0},{"$f":"IF(P70>54000,875,IF(P70>33500,658,IF(P70>18000,440,IF(P70>0,265,0))))","v":0},0]
[{"$nulls":3},6,2026,{"$f":"D71&\"-\"&E71","v":"6-2026"},66,30,"",null,"",0,{"$f":"ROUND(L71*AG71/100,0)","v":0},{"$f":"ROUND(L71*AJ71/100,0)","v":0},{"$f":"SUM(L71:N71)","v":0},0,{"$f":"ROUND(P71*AH71/100,0)","v":0},{"$f":"ROUND(P71*AK71/100,0)","v":0},{"$f":"SUM(P71:R71)","v":0},0,0,{"$f":"ROUND(L71*AI71/100,0)","v":0},{"$f":"U71+V71","v":0},0,0,{"$f":"ROUND(P71*AI71/100,0)","v":0},{"$f":"Y71+Z71","v":0},0,0,{"$f":"ROUND((O71-S71)*$AD$5,0)","v":0}]
[{"$nulls":3},7,2026,"7-2026",67,31,"",null,"",{"$f":"IFERROR(IF(I71=\"\",0,IF($C$11<7,$B$19,IF(AND($C$11>6,$C$11<19),$B$18,IF(AND($C$11>18,$C$11<31),$B$17,IF(AND($C$11>30,$C$11<43),$B$16,IF(AND($C$11>42,$C$11<55),$B$15,IF(AND($C$11>54,$C$11<67),$B$14,IF(L70>0,$B$13,$B$12)))))))),\"\")","v":0},0,0,0,{"$f":"IFERROR(IF(I71=\"\",0,IF($C$11<7,$C$19,IF(AND($C$11>6,$C$11<19),$C$18,IF(AND($C$11>18,$C$11<31),$C$17,IF(AND($C$11>30,$C$11<43),$C$16,IF(AND($C$11>42,$C$11<55),$C$15,IF(AND($C$11>54,$C$11<67),$C$14,IF(P70>0,$C$13,$C$12)))))))),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},8,2026,"8-2026",68,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},9,2026,"9-2026",69,30,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},10,2026,"10-2026",70,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},11,2026,"11-2026",71,30,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},12,2026,"12-2026",72,31,"",null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Sheet3","index":2,"n_rows":86,"n_cols":29,"rows_kept":86,"merged":[[3,1,4,1],[3,2,3,5],[3,6,3,9],[3,10,3,13],[3,14,3,16],[3,17,3,19],[3,20,3,22],[3,23,3,25],[3,26,4,26],[3,27,4,27],[3,28,4,28]]}
[null,"Office Govt Sr Sc Sch Malutana (Thanagazi) Alwar"]
[null,"Salary Arrear from 01-Jan-2021 to Jan-2025"]
[null,{"$f":"INDEX(Sheet1!B6:B20,MATCH(Sheet3!C3,Sheet1!C6:C20,0))","v":1},"Pramod Kumar Saini",{"$nulls":11},"Employee Designation : Teacher"]
[null,"Month\n/\nYear","PAY DUE",{"$nulls":3},"PAY DRAWN",{"$nulls":3},"PAY DIFFERENCE",{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B3,Sheet1!$B$6:$L$20,10,0),\"\")","v":"GPF 2004"},null,null,"SIP",null,null,"RGHS",null,null,"I TAX",null,null,"Total\nDedu","Net\nPay","TV\nNo"]
[null,null,"Basic","DA","HRA","Total","Basic","DA","HRA","Total","Basic","DA","HRA",{"$f":"IF(F5=\"\",\"\",F5)","v":"Total"},"Due","Dedu","Diff","Due","Dedu","Diff","Due","Dedu","Diff","Due","Dedu","Diff"]
[null,"2021-01-01",47900,8143,3832,{"$f":"SUM(C6:E6)","v":59875},45100,7667,3608,{"$f":"SUM(G6:I6)","v":56375},{"$f":"C6-G6","v":2800},{"$f":"D6-H6","v":476},{"$f":"E6-I6","v":224},{"$f":"SUM(K6:M6)","v":3500},2850,2850,{"$f":"O6-P6","v":0},0,0,{"$f":"R6-S6","v":0},658,658,{"$f":"U6-V6","v":0},350,0,{"$f":"X6-Y6","v":350},{"$f":"Q6+T6+W6+Z6","v":350},{"$f":"N6-AA6","v":3150}]
[null,"2021-02-01",47900,8143,3832,{"$f":"SUM(C7:E7)","v":59875},45100,7667,3608,{"$f":"SUM(G7:I7)","v":56375},{"$f":"C7-G7","v":2800},{"$f":"D7-H7","v":476},{"$f":"E7-I7","v":224},{"$f":"SUM(K7:M7)","v":3500},2850,2850,{"$f":"O7-P7","v":0},0,0,{"$f":"R7-S7","v":0},658,658,{"$f":"U7-V7","v":0},350,0,{"$f":"X7-Y7","v":350},{"$f":"Q7+T7+W7+Z7","v":350},{"$f":"N7-AA7","v":3150}]
[null,"2021-03-01",47900,8143,3832,{"$f":"SUM(C8:E8)","v":59875},45100,7667,3608,56375,2800,476,224,3500,2850,2850,0,0,0,0,658,658,0,350,0,350,350,3150]
[null,"2021-04-01",47900,8143,3832,59875,45100,7667,3608,56375,2800,476,224,3500,2850,2850,0,0,0,0,658,658,0,350,0,350,350,3150]
[null,"2021-05-01",47900,8143,3832,59875,45100,7667,3608,56375,2800,476,224,3500,2850,2850,0,0,0,0,658,658,0,350,0,350,350,3150]
[null,"2021-06-01",47900,8143,3832,59875,45100,7667,3608,56375,2800,476,224,3500,2850,2850,0,0,0,0,658,658,0,350,0,350,350,3150]
[null,"2021-07-01",49300,15283,4437,69020,46500,7905,4185,58590,2800,7378,252,10430,9752,9360,392,0,0,0,658,658,0,1043,0,1043,1435,8995]
[null,"2021-08-01",49300,15283,4437,69020,46500,7905,4185,58590,2800,7378,252,10430,9752,9360,392,0,0,0,658,658,0,1043,0,1043,1435,8995]
[null,"2021-09-01",49300,15283,4437,69020,46500,7905,4185,58590,2800,7378,252,10430,9752,9360,392,0,0,0,658,658,0,1043,0,1043,1435,8995]
[null,"2021-10-01",49300,15283,4437,69020,46500,14415,4185,65100,2800,868,252,3920,2850,2850,0,0,0,0,658,658,0,392,0,392,392,3528]
[null,"2021-11-01",49300,15283,4437,69020,46500,14415,4185,65100,2800,868,252,3920,2850,2850,0,0,0,0,658,658,0,392,0,392,392,3528]
[null,"2021-12-01",49300,15283,4437,69020,46500,14415,4185,65100,2800,868,252,3920,2850,2850,0,0,0,0,658,658,0,392,0,392,392,3528]
[null,"2022-01-01",49300,16762,4437,70499,46500,14415,4185,65100,2800,2347,252,5399,4329,4245,84,0,0,0,658,658,0,540,0,540,624,4775]
[null,"2022-02-01",49300,16762,4437,70499,46500,14415,4185,65100,2800,2347,252,5399,4329,4245,84,0,0,0,658,658,0,540,0,540,624,4775]
[null,"2022-03-01",49300,16762,4437,70499,46500,14415,4185,65100,2800,2347,252,5399,4329,4245,84,0,0,0,658,658,0,540,0,540,624,4775]
[null,"2022-04-01",49300,16762,4437,70499,46500,15810,4185,66495,2800,952,252,4004,2850,2850,0,0,0,0,658,658,0,400,0,400,400,3604]
[null,"2022-05-01",49300,16762,4437,70499,46500,15810,4185,66495,2800,952,252,4004,2850,2850,0,0,0,0,658,658,0,400,0,400,400,3604]
[null,"2022-06-01",49300,16762,4437,70499,46500,15810,4185,66495,2800,952,252,4004,2850,2850,0,0,0,0,658,658,0,400,0,400,400,3604]
[null,"2022-07-01",50800,19304,4572,74676,47900,16286,4311,68497,2900,3018,261,6179,4882,4766,116,0,0,0,658,658,0,618,0,618,734,5445]
[null,"2022-08-01",50800,19304,4572,74676,47900,16286,4311,68497,2900,3018,261,6179,4882,4766,116,0,0,0,658,658,0,618,0,618,734,5445]
[null,"2022-09-01",50800,19304,4572,74676,47900,16286,4311,68497,2900,3018,261,6179,4882,4766,116,0,0,0,658,658,0,618,0,618,734,5445]
[null,"2022-10-01",50800,19304,4572,74676,47900,18202,4311,70413,2900,1102,261,4263,2850,2850,0,0,0,0,658,658,0,426,0,426,426,3837]
[null,"2022-11-01",50800,19304,4572,74676,47900,18202,4311,70413,2900,1102,261,4263,2850,2850,0,0,0,0,658,658,0,426,0,426,426,3837]
[null,"2022-12-01",50800,19304,4572,74676,47900,18202,4311,70413,2900,1102,261,4263,2850,2850,0,0,0,0,658,658,0,426,0,426,426,3837]
[null,"2023-01-01",50800,21336,4572,76708,47900,18202,4311,70413,2900,3134,261,6295,4882,4766,116,0,0,0,658,658,0,630,0,630,746,5549]
[null,"2023-02-01",50800,21336,4572,76708,47900,18202,4311,70413,2900,3134,261,6295,4882,4766,116,0,0,0,658,658,0,630,0,630,746,5549]
[null,"2023-03-01",50800,21336,4572,76708,47900,18202,4311,70413,2900,3134,261,6295,4882,4766,116,0,0,0,658,658,0,630,0,630,746,5549]
[null,"2023-04-01",50800,21336,4572,76708,47900,20118,4311,72329,2900,1218,261,4379,2850,2850,0,0,0,0,658,658,0,438,0,438,438,3941]
[null,"2023-05-01",50800,21336,4572,76708,47900,20118,4311,72329,2900,1218,261,4379,2850,2850,0,0,0,0,658,658,0,438,0,438,438,3941]
[null,"2023-06-01",50800,21336,4572,76708,47900,20118,4311,72329,2900,1218,261,4379,2850,2850,0,0,0,0,658,658,0,438,0,438,438,3941]
[null,"2023-07-01",52300,24058,4707,81065,49300,22678,4437,76415,3000,1380,270,4650,3575,2850,725,0,0,0,658,658,0,465,0,465,1190,3460]
[null,"2023-08-01",52300,24058,4707,81065,49300,22678,4437,76415,3000,1380,270,4650,3575,2850,725,0,0,0,658,658,0,465,0,465,1190,3460]
[null,"2023-09-01",52300,24058,4707,81065,49300,22678,4437,76415,3000,1380,270,4650,3575,2850,725,0,0,0,658,658,0,465,0,465,1190,3460]
[null,"2023-10-01",52300,24058,4707,81065,49300,22678,4437,76415,3000,1380,270,4650,3575,2850,725,0,0,0,658,658,0,465,0,465,1190,3460]
[null,"2023-11-01",52300,24058,4707,81065,49300,22678,4437,76415,3000,1380,270,4650,3575,2850,725,0,0,0,658,658,0,465,0,465,1190,3460]
[null,"2023-12-01",52300,24058,4707,81065,49300,22678,4437,76415,3000,1380,270,4650,3575,2850,725,0,0,0,658,658,0,465,0,465,1190,3460]
[null,"2024-01-01",52300,26150,4707,83157,49300,24650,4437,78387,3000,1500,270,4770,3575,2850,725,0,0,0,658,658,0,477,0,477,1202,3568]
[null,"2024-02-01",52300,26150,4707,83157,49300,24650,4437,78387,3000,1500,270,4770,3575,2850,725,0,0,0,658,658,0,477,0,477,1202,3568]
[null,"2024-03-01",52300,26150,4707,83157,49300,24650,4437,78387,3000,1500,270,4770,3575,2850,725,0,0,0,658,658,0,477,0,477,1202,3568]
[null,"2024-04-01",52300,26150,4707,83157,49300,24650,4437,78387,3000,1500,270,4770,3575,2850,725,0,0,0,658,658,0,477,0,477,1202,3568]
[null,"2024-05-01",52300,26150,4707,83157,49300,24650,4437,78387,3000,1500,270,4770,3575,2850,725,0,0,0,658,658,0,477,0,477,1202,3568]
[null,"2024-06-01",52300,26150,4707,83157,49300,24650,4437,78387,3000,1500,270,4770,3575,2850,725,0,0,0,658,658,0,477,0,477,1202,3568]
[null,"2024-07-01",53900,28567,4851,87318,50800,26924,4572,82296,3100,1643,279,5022,3575,2850,725,0,0,0,658,658,0,502,0,502,1227,3795]
[null,"2024-08-01",53900,28567,4851,87318,50800,26924,4572,82296,3100,1643,279,5022,3575,2850,725,0,0,0,658,658,0,502,0,502,1227,3795]
[null,"2024-09-01",53900,28567,4851,87318,50800,25400,4572,80772,3100,3167,279,6546,5192,4374,818,0,0,0,658,658,0,655,0,655,1473,5073]
[null,"2024-10-01",53900,0,0,53900,50800,0,0,50800,3100,0,0,3100,3575,2850,725,0,0,0,658,658,0,310,0,310,1035,2065]
[null,"2024-11-01",53900,0,0,53900,50800,0,0,50800,3100,0,0,3100,3575,2850,725,0,0,0,658,658,0,310,0,310,1035,2065]
[null,"2024-12-01",53900,0,0,53900,50800,0,0,50800,3100,0,0,3100,3575,2850,725,0,0,0,658,658,0,310,0,310,1035,2065]
[null,"2025-01-01",53900,0,0,53900,50800,0,0,50800,3100,0,0,3100,3575,2850,725,0,0,0,658,658,0,310,0,310,1035,2065]
[null,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,0,0,0,0,0,{"$f":"SUM(G71:I71)","v":0},{"$f":"C71-G71","v":0},{"$f":"D71-H71","v":0},{"$f":"E71-I71","v":0},{"$f":"SUM(K71:M71)","v":0},0,0,{"$f":"O71-P71","v":0},0,0,{"$f":"R71-S71","v":0},0,0,{"$f":"U71-V71","v":0},0,0,{"$f":"X71-Y71","v":0},{"$f":"Q71+T71+W71+Z71","v":0},{"$f":"N71-AA71","v":0}]
[null,null,0,0,0,{"$f":"SUM(C72:E72)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,null,0,0,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,"Total",{"$f":"SUM(C6:C77)","v":2493500},{"$f":"SUM(D6:D77)","v":871917},202137,3567554,2350600,785277,190560,3326437,142900,86640,11577,241117,192377,176385,15992,0,0,0,32242,32242,0,24112,0,24112,40104,201013]
[{"$nulls":27},{"$f":"\"Net payable amount in words \"&SpellIndian(AB78)","v":"Net payable amount in words Rupees Two Lac One Thousand Thirteen Only"}]
[null,"izek.khdj.k %"]
[null,"1- izekf.kr fd;k tkrk gS fd bl osru varj fooj.k izi= dk ;ksx QykoV tkWp fy;k x;k gS tks lgh gSA"]
[null,"2- izekf.kr fd;k tkrk gS fd bl fcy dk Hkqxrku iwoZ esa ugha mBk;k x;k gS vkSj uk gh mBk;k tkosxkA "]
[null,"3- izekf.kr fd;k tkrk gS fd lkekU; foÙkh; ,oa ys[kk fu;e vuqlkj jkf'k dk dk;kZy; fjdkWMZ esa bUnzkt dj fn;k x;k gSA"]
[null,"4- izekf.kr fd;k tkrk gS fd vk;dj vf/kfu;e 1961 ds fu;e vuqlkj vk;dj dh dVkSrh dj nh x;h gSA"]
[]
[{"$nulls":27},"DDO's Signature with Official SEAL"]

{"sheet":"Sheet4","index":3,"n_rows":75,"n_cols":6,"rows_kept":75,"merged":[[0,1,0,5],[1,1,1,5]]}
[null,"Allowance Rates"]
[]
[null,"MY","Due DA","Drawn DA","Due HRA","Drawn HRA"]
[null,{"$f":"TEXT(Sheet2!F6,\"MMM-YYYY\")","v":"Jan-2021"},17,17,8,8]
[null,{"$f":"TEXT(Sheet2!F7,\"MMM-YYYY\")","v":"Feb-2021"},17,17,8,8]
[null,{"$f":"TEXT(Sheet2!F8,\"MMM-YYYY\")","v":"Mar-2021"},17,17,8,8]
[null,{"$f":"TEXT(Sheet2!F9,\"MMM-YYYY\")","v":"Apr-2021"},17,17,8,8]
[null,{"$f":"TEXT(Sheet2!F10,\"MMM-YYYY\")","v":"May-2021"},17,17,8,8]
[null,{"$f":"TEXT(Sheet2!F11,\"MMM-YYYY\")","v":"Jun-2021"},17,17,8,8]
[null,{"$f":"TEXT(Sheet2!F12,\"MMM-YYYY\")","v":"Jul-2021"},31,17,9,9]
[null,{"$f":"TEXT(Sheet2!F13,\"MMM-YYYY\")","v":"Aug-2021"},31,17,9,9]
[null,{"$f":"TEXT(Sheet2!F14,\"MMM-YYYY\")","v":"Sep-2021"},31,17,9,9]
[null,{"$f":"TEXT(Sheet2!F15,\"MMM-YYYY\")","v":"Oct-2021"},31,31,9,9]
[null,{"$f":"TEXT(Sheet2!F16,\"MMM-YYYY\")","v":"Nov-2021"},31,31,9,9]
[null,{"$f":"TEXT(Sheet2!F17,\"MMM-YYYY\")","v":"Dec-2021"},31,31,9,9]
[null,{"$f":"TEXT(Sheet2!F18,\"MMM-YYYY\")","v":"Jan-2022"},34,31,9,9]
[null,{"$f":"TEXT(Sheet2!F19,\"MMM-YYYY\")","v":"Feb-2022"},34,31,9,9]
[null,{"$f":"TEXT(Sheet2!F20,\"MMM-YYYY\")","v":"Mar-2022"},34,31,9,9]
[null,{"$f":"TEXT(Sheet2!F21,\"MMM-YYYY\")","v":"Apr-2022"},34,34,9,9]
[null,{"$f":"TEXT(Sheet2!F22,\"MMM-YYYY\")","v":"May-2022"},34,34,9,9]
[null,{"$f":"TEXT(Sheet2!F23,\"MMM-YYYY\")","v":"Jun-2022"},34,34,9,9]
[null,{"$f":"TEXT(Sheet2!F24,\"MMM-YYYY\")","v":"Jul-2022"},38,34,9,9]
[null,{"$f":"TEXT(Sheet2!F25,\"MMM-YYYY\")","v":"Aug-2022"},38,34,9,9]
[null,{"$f":"TEXT(Sheet2!F26,\"MMM-YYYY\")","v":"Sep-2022"},38,34,9,9]
[null,{"$f":"TEXT(Sheet2!F27,\"MMM-YYYY\")","v":"Oct-2022"},38,38,9,9]
[null,{"$f":"TEXT(Sheet2!F28,\"MMM-YYYY\")","v":"Nov-2022"},38,38,9,9]
[null,{"$f":"TEXT(Sheet2!F29,\"MMM-YYYY\")","v":"Dec-2022"},38,38,9,9]
[null,{"$f":"TEXT(Sheet2!F30,\"MMM-YYYY\")","v":"Jan-2023"},42,38,9,9]
[null,{"$f":"TEXT(Sheet2!F31,\"MMM-YYYY\")","v":"Feb-2023"},42,38,9,9]
[null,{"$f":"TEXT(Sheet2!F32,\"MMM-YYYY\")","v":"Mar-2023"},42,38,9,9]
[null,{"$f":"TEXT(Sheet2!F33,\"MMM-YYYY\")","v":"Apr-2023"},42,42,9,9]
[null,{"$f":"TEXT(Sheet2!F34,\"MMM-YYYY\")","v":"May-2023"},42,42,9,9]
[null,{"$f":"TEXT(Sheet2!F35,\"MMM-YYYY\")","v":"Jun-2023"},42,42,9,9]
[null,{"$f":"TEXT(Sheet2!F36,\"MMM-YYYY\")","v":"Jul-2023"},46,46,9,9]
[null,{"$f":"TEXT(Sheet2!F37,\"MMM-YYYY\")","v":"Aug-2023"},46,46,9,9]
[null,{"$f":"TEXT(Sheet2!F38,\"MMM-YYYY\")","v":"Sep-2023"},46,46,9,9]
[null,{"$f":"TEXT(Sheet2!F39,\"MMM-YYYY\")","v":"Oct-2023"},46,46,9,9]
[null,{"$f":"TEXT(Sheet2!F40,\"MMM-YYYY\")","v":"Nov-2023"},46,46,9,9]
[null,{"$f":"TEXT(Sheet2!F41,\"MMM-YYYY\")","v":"Dec-2023"},46,46,9,9]
[null,{"$f":"TEXT(Sheet2!F42,\"MMM-YYYY\")","v":"Jan-2024"},50,50,9,9]
[null,{"$f":"TEXT(Sheet2!F43,\"MMM-YYYY\")","v":"Feb-2024"},50,50,9,9]
[null,{"$f":"TEXT(Sheet2!F44,\"MMM-YYYY\")","v":"Mar-2024"},50,50,9,9]
[null,{"$f":"TEXT(Sheet2!F45,\"MMM-YYYY\")","v":"Apr-2024"},50,50,9,9]
[null,{"$f":"TEXT(Sheet2!F46,\"MMM-YYYY\")","v":"May-2024"},50,50,9,9]
[null,{"$f":"TEXT(Sheet2!F47,\"MMM-YYYY\")","v":"Jun-2024"},50,50,9,9]
[null,{"$f":"TEXT(Sheet2!F48,\"MMM-YYYY\")","v":"Jul-2024"},53,53,9,9]
[null,{"$f":"TEXT(Sheet2!F49,\"MMM-YYYY\")","v":"Aug-2024"},53,53,9,9]
[null,{"$f":"TEXT(Sheet2!F50,\"MMM-YYYY\")","v":"Sep-2024"},53,50,9,9]
[null,{"$f":"TEXT(Sheet2!F51,\"MMM-YYYY\")","v":"Oct-2024"}]
[null,{"$f":"TEXT(Sheet2!F52,\"MMM-YYYY\")","v":"Nov-2024"}]
[null,{"$f":"TEXT(Sheet2!F53,\"MMM-YYYY\")","v":"Dec-2024"}]
[null,{"$f":"TEXT(Sheet2!F54,\"MMM-YYYY\")","v":"Jan-2025"}]
[null,{"$f":"TEXT(Sheet2!F55,\"MMM-YYYY\")","v":"Feb-2025"}]
[null,{"$f":"TEXT(Sheet2!F56,\"MMM-YYYY\")","v":"Mar-2025"}]
[null,{"$f":"TEXT(Sheet2!F57,\"MMM-YYYY\")","v":"Apr-2025"}]
[null,{"$f":"TEXT(Sheet2!F58,\"MMM-YYYY\")","v":"May-2025"}]
[null,{"$f":"TEXT(Sheet2!F59,\"MMM-YYYY\")","v":"Jun-2025"}]
[null,{"$f":"TEXT(Sheet2!F60,\"MMM-YYYY\")","v":"Jul-2025"}]
[null,{"$f":"TEXT(Sheet2!F61,\"MMM-YYYY\")","v":"Aug-2025"}]
[null,{"$f":"TEXT(Sheet2!F62,\"MMM-YYYY\")","v":"Sep-2025"}]
[null,{"$f":"TEXT(Sheet2!F63,\"MMM-YYYY\")","v":"Oct-2025"}]
[null,{"$f":"TEXT(Sheet2!F64,\"MMM-YYYY\")","v":"Nov-2025"}]
[null,{"$f":"TEXT(Sheet2!F65,\"MMM-YYYY\")","v":"Dec-2025"}]
[null,{"$f":"TEXT(Sheet2!F66,\"MMM-YYYY\")","v":"Jan-2026"}]
[null,{"$f":"TEXT(Sheet2!F67,\"MMM-YYYY\")","v":"Feb-2026"}]
[null,{"$f":"TEXT(Sheet2!F68,\"MMM-YYYY\")","v":"Mar-2026"}]
[null,{"$f":"TEXT(Sheet2!F69,\"MMM-YYYY\")","v":"Apr-2026"}]
[null,{"$f":"TEXT(Sheet2!F70,\"MMM-YYYY\")","v":"May-2026"}]
[null,{"$f":"TEXT(Sheet2!F71,\"MMM-YYYY\")","v":"Jun-2026"}]
[null,{"$f":"TEXT(Sheet2!F72,\"MMM-YYYY\")","v":"Jul-2026"}]
[null,{"$f":"TEXT(Sheet2!F73,\"MMM-YYYY\")","v":"Aug-2026"}]
[null,{"$f":"TEXT(Sheet2!F74,\"MMM-YYYY\")","v":"Sep-2026"}]
[null,{"$f":"TEXT(Sheet2!F75,\"MMM-YYYY\")","v":"Oct-2026"}]
[null,{"$f":"TEXT(Sheet2!F76,\"MMM-YYYY\")","v":"Nov-2026"}]
[null,{"$f":"TEXT(Sheet2!F77,\"MMM-YYYY\")","v":"Dec-2026"}]