{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Master","Arrear","Unlock"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Master","index":0,"n_rows":108,"n_cols":21,"rows_kept":108,"merged":[[0,2,0,4],[2,0,2,1],[2,2,2,7],[3,0,3,1],[3,4,3,6],[4,0,4,1],[4,4,4,6],[7,13,8,15]]}
[null,null,"EMPLOYEE DETAIL",{"$nulls":16},"GPF","YES"]
[{"$nulls":19},"NPS","NO"]
["OFFICE NAME :-",null,"Government Senior Secondry School Inderwara , Pali"]
["Old  7th Pay DA % :-",null,12,null,"Old  7th Pay HRA % :-",null,null,8]
["New  7th Pay DA % :-",null,17,null,"New  7th Pay HRA % :-",null,null,8]
[]
["S.R. NO.","EMPLOYEE NAME","POST","How Many Months make Arrear","7th Pay Basic","GPF / NPS","INCOME TAX","Surrender Arrear  YES / NO"]
[1,"MISHRI LAL","PRINCIPAL",8,71400,"GPF",20,{"$nulls":6},"ije~ iwT; xq:nso oklqnso th egkjkt dks ueu"]
[2,"KALYAN SINGH","LECTURER",8,47000,"NPS"]
[3,"BHAGWAN SINGH","LECTURER",8,71300,"NPS",20]
[4,"MANGILAL RANGI","Sr. Teacher",8,71300,"GPF",20]
[5,"HEERA LAL JAT","Sr. Teacher",8,49300,"GPF",20,"YES"]
[6,"MAHENDRA PATEL","Sr. Teacher",8,41300,"NPS",20]
[7,"BHALA RAM MOBARSA","TEACHER L-1",8,67000,"GPF",20]
[8,"ARJUN SINGH","TEACHER L-1",8,46500,"GPF"]
[9,"SURESH KUMAR ADARA","TEACHER L-2",8,50800,"NPS",20]
[10,"LALIT KUMAR","TEACHER L-1",8,50800,"GPF",20]
[11,"MANDIP SINGH BHULLAR","P.T.I. IIIrd",8,35800,"NPS"]
[12,"AJAY KUMAR","PEON ",8,30500,"GPF"]
[13,"PEERARAM","Sr. Teacher",8,67200,"GPF",20]
[14,"SOHAN LAL","TEACHER L-2",8,38000,"NPS"]
[15,"SITARAM","TEACHER L-1",5,36900,"NPS"]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]

{"sheet":"Arrear","index":1,"n_rows":27,"n_cols":28,"rows_kept":27,"merged":[[0,0,0,19],[1,0,1,19],[2,4,2,8],[2,9,2,13],[2,14,2,15],[2,16,2,19],[4,0,6,0],[4,1,6,1],[4,2,4,5],[4,6,4,9],[4,10,4,13],[4,14,4,16],[4,17,6,17],[4,18,6,18],[4,19,6,19],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,5,15],[5,16,6,16],[18,0,18,1],[19,4,19,8],[19,9,19,19],[20,3,20,18],[21,2,21,6],[21,8,21,9],[21,10,21,12],[21,14,21,19],[22,1,22,7],[23,1,23,7],[24,1,24,5],[24,6,24,12],[25,1,25,3],[26,14,26,19]]}
["DA (17%) Drawn Statement  ",{"$nulls":22},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,4,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,4,FALSE))","v":8},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,6,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,6,FALSE))","v":"GPF"},"NPS","GPF",{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,7,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,7,FALSE))","v":20}]
[{"$f":"IF(AND(Master!C3=\"\"),\"\",CONCATENATE(\"Office Of  \",Master!C3))","v":"Office Of  Government Senior Secondry School Inderwara , Pali"},{"$nulls":23},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,8,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,8,FALSE))","v":"YES"},"YES"]
[{"$nulls":4},"Name of Employee :-",{"$nulls":4},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,2,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,2,FALSE))","v":"HEERA LAL JAT"},{"$nulls":4},"POST:- ",null,{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,3,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,3,FALSE))","v":"Sr. Teacher"}]
[{"$nulls":4},"Sr. No. -",5]
["Serial No.","Month\n& \nYear","Pay Due",{"$nulls":3},"Pay Drawn",{"$nulls":3},"Pay Difference",{"$nulls":3},"Deducation",null,null,"Total \nof \nDedu\nction \nCol.\n15 to 17","To be \npaid\ndeducting\nCol. 14 \nform 18","Treasury\nBill@\nVoucher \nNo.&\nDate"]
[null,null,"Basic\n","Dearness\nAllowance","H.R.A.","Total \nCol.\n3         to         5","Basic\n","Dearness\nAllowance","H.R.A.","Total \nCol.\n7        to          9","Basic\n Pay","Dearness\nAllowance","H.R.A.","Total \nCol.\n11        to            13","NPS/GPF",null,"Income   Tax  /  TDS"]
[{"$nulls":14},"NPS","GPF"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[1,"2019-07-01",{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,5,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE))","v":49300},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C9*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C9*Master!H$5%,0)))","v":3944},{"$f":"IF(AND(C9=\"\"),\"\",SUM(C9:E9))","v":61625},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,5,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE))","v":49300},{"$f":"IF(AND(G9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G9*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G9*Master!H$4%,0)))","v":3944},{"$f":"IF(AND(C9=\"\"),\"\",SUM(G9:I9))","v":59160},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(G9=\"\"),\"\",C9-G9))","v":0},2465,0,2465,{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N9)*10%,0),\"0\"))","v":"0"},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Y$1=AA$1),N9-Q9,\"0\"))","v":1972},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N9=\"\"),\"\",ROUND(N9*AB$1%,0)))","v":493},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C9=\"\"),\"\",IF(AND(O9=\"\"),\"\",IF(AND(P9=\"\"),\"\",O9+P9+Q9))))","v":2465},{"$f":"IF(AND(N9=\"\"),\"\",IF(AND(R9=\"\"),\"\",N9-R9))","v":0},{"$nulls":5},"2019-07-01"]
[2,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<2),\"\",Y10))","v":"2019-08-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<2),\"\",Arrear!C9))","v":49300},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<2),\"\",Arrear!C10))","v":49300},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N10)*10%,0),\"0\"))","v":"0"},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Y$1=AA$1),N10-Q10,\"0\"))","v":1972},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N10=\"\"),\"\",ROUND(N10*AB$1%,0)))","v":493},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C10=\"\"),\"\",IF(AND(O10=\"\"),\"\",IF(AND(P10=\"\"),\"\",O10+P10+Q10))))","v":2465},{"$f":"IF(AND(N10=\"\"),\"\",IF(AND(R10=\"\"),\"\",N10-R10))","v":0},{"$nulls":5},"2019-08-01"]
[3,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<3),\"\",Y11))","v":"2019-09-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<3),\"\",Arrear!C10))","v":49300},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C11*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C11*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<3),\"\",Arrear!C11))","v":49300},{"$f":"IF(AND(G11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G11*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G11*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,"0",1972,493,2465,0,{"$nulls":5},"2019-09-01"]
[4,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<4),\"\",Y12))","v":"2019-10-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<4),\"\",Arrear!C11))","v":49300},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C12*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C12*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<4),\"\",Arrear!C12))","v":49300},{"$f":"IF(AND(G12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G12*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G12*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,"0",1972,493,2465,0,{"$nulls":5},"2019-10-01"]
[5,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<5),\"\",Y13))","v":"2019-11-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<5),\"\",Arrear!C12))","v":49300},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C13*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C13*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<5),\"\",Arrear!C13))","v":49300},{"$f":"IF(AND(G13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G13*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G13*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,"0",1972,493,2465,0,{"$nulls":5},"2019-11-01"]
[6,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<6),\"\",Y14))","v":"2019-12-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<6),\"\",Arrear!C13))","v":49300},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C14*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C14*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<6),\"\",Arrear!C14))","v":49300},{"$f":"IF(AND(G14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G14*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G14*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,"0",1972,493,2465,0,{"$nulls":5},"2019-12-01"]
[7,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Y15))","v":"2020-01-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Arrear!C14))","v":49300},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C15*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C15*Master!H$5%,0)))","v":3944},{"$f":"IF(AND(C15=\"\"),\"\",SUM(C15:E15))","v":61625},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Arrear!C15))","v":49300},{"$f":"IF(AND(G15=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G15*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G15=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G15*Master!H$4%,0)))","v":3944},{"$f":"IF(AND(C15=\"\"),\"\",SUM(G15:I15))","v":59160},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(G15=\"\"),\"\",C15-G15))","v":0},{"$f":"IF(AND(D15=\"\"),\"\",IF(AND(H15=\"\"),\"\",D15-H15))","v":2465},{"$f":"IF(AND(E15=\"\"),\"\",IF(AND(I15=\"\"),\"\",E15-I15))","v":0},{"$f":"IF(AND(F15=\"\"),\"\",IF(AND(J15=\"\"),\"\",F15-J15))","v":2465},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N15)*10%,0),\"0\"))","v":"0"},1972,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N15=\"\"),\"\",ROUND(N15*AB$1%,0)))","v":493},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C15=\"\"),\"\",IF(AND(O15=\"\"),\"\",IF(AND(P15=\"\"),\"\",O15+P15+Q15))))","v":2465},{"$f":"IF(AND(N15=\"\"),\"\",IF(AND(R15=\"\"),\"\",N15-R15))","v":0},{"$nulls":5},"2020-01-01"]
[8,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Y16))","v":"2020-02-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Arrear!C15))","v":49300},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C16*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C16*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Arrear!C16))","v":49300},{"$f":"IF(AND(G16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G16*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G16*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,"0",1972,493,2465,0,{"$nulls":5},"2020-02-01"]
[9,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Y17))","v":""},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Arrear!C16))","v":""},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C17*Master!C$5%,0)))","v":""},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C17*Master!H$5%,0)))","v":""},"",{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Arrear!C17))","v":""},{"$f":"IF(AND(G17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G17*Master!C$4%,0)))","v":""},{"$f":"IF(AND(G17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G17*Master!H$4%,0)))","v":""},"","","","","","","","","","",{"$nulls":5},"2020-03-01"]
[10,"Surrender Arrear",{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Y$2=Z$2),VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE)/2,\"\"))","v":24650},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C18*Master!C$5%,0)))","v":4191},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C18*Master!H$5%,0)))","v":1972},30813,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Y$2=Z$2),VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE)/2,\"\"))","v":24650},{"$f":"IF(AND(G18=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G18*Master!C$4%,0)))","v":2958},{"$f":"IF(AND(G18=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G18*Master!H$4%,0)))","v":1972},29580,0,1233,0,1233,"0",986,247,1233,0,{"$nulls":5},"2020-04-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C9:C18))","v":419050},71239,33524,523813,419050,50286,33524,502860,0,20953,0,20953,0,16762,4191,20953,0]
[{"$nulls":4},"Cash Amount in Words :",{"$nulls":4},{"$f":"IF(AND(F4=\"\"),\"\",IF(AND(S19=0),\"ZERO ONLY\",\"( Rs. \"&LOOKUP(IF(INT(RIGHT(S19,7)/100000)>19,INT(RIGHT(S19,7)/1000000),IF(INT(RIGHT(S19,7)/100000)>=10,INT(RIGHT(S19,7)/100000),0)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" TEN \",\" TWENTY \",\" THIRTY \",\" FOURTY \",\" FIFTY \",\" SIXTY \",\" SEVENTY \",\" EIGHTY \",\" NINETY \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&IF((IF(INT(RIGHT(S19,7)/100000)>19,INT(RIGHT(S19,7)/1000000),IF(INT(RIGHT(S19,7)/100000)>=10,INT(RIGHT(S19,7)/100000),0))+IF(INT(RIGHT(S19,7)/100000)>19,INT(RIGHT(S19,6)/100000),IF(INT(RIGHT(S19,7)/100000)>10,0,INT(RIGHT(S19,6)/100000))))>0,LOOKUP(IF(INT(RIGHT(S19,7)/100000)>19,INT(RIGHT(S19,6)/100000),IF(INT(RIGHT(S19,7)/100000)>10,0,INT(RIGHT(S19,6)/100000))),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" ONE \",\" TWO \",\" THREE \",\" FOUR \",\" FIVE \",\" SIX \",\" SEVEN \",\" EIGHT \",\" NINE \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&\" Lac. \",\" \")&LOOKUP(IF(INT(RIGHT(S19,5)/1000)>19,INT(RIGHT(S19,5)/10000),IF(INT(RIGHT(S19,5)/1000)>=10,INT(RIGHT(S19,5)/1000),0)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" TEN \",\" TWENTY \",\" THIRTY \",\" FOURTY \",\" FIFTY \",\" SIXTY \",\" SEVENTY \",\" EIGHTY \",\" NINETY \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&IF((IF(INT(RIGHT(S19,5)/1000)>19,INT(RIGHT(S19,4)/1000),IF(INT(RIGHT(S19,5)/1000)>10,0,INT(RIGHT(S19,4)/1000)))+IF(INT(RIGHT(S19,5)/1000)>19,INT(RIGHT(S19,5)/10000),IF(INT(RIGHT(S19,5)/1000)>=10,INT(RIGHT(S19,5)/1000),0)))>0,LOOKUP(IF(INT(RIGHT(S19,5)/1000)>19,INT(RIGHT(S19,4)/1000),IF(INT(RIGHT(S19,5)/1000)>10,0,INT(RIGHT(S19,4)/1000))),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" ONE \",\" TWO \",\" THREE \",\" FOUR \",\" FIVE \",\" SIX \",\" SEVEN \",\" EIGHT \",\" NINE \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&\" THOUSAND \",\" \")&IF((INT((RIGHT(S19,3))/100))>0,LOOKUP(INT((RIGHT(S19,3))/100),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" ONE \",\" TWO \",\" THREE \",\" FOUR \",\" FIVE \",\" SIX \",\" SEVEN \",\" EIGHT \",\" NINE \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&\" HUNDRED \",\" \")&LOOKUP(IF(INT(RIGHT(S19,2))>19,INT(RIGHT(S19,2)/10),IF(INT(RIGHT(S19,2))>=10,INT(RIGHT(S19,2)),0)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" TEN \",\" TWENTY \",\" THIRTY \",\" FOURTY \",\" FIFTY \",\" SIXTY \",\" SEVENTY \",\" EIGHTY \",\" NINETY \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&LOOKUP(IF(INT(RIGHT(S19,2))<10,INT(RIGHT(S19,1)),IF(INT(RIGHT(S19,2))<20,0,INT(RIGHT(S19,1)))),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" ONE \",\" TWO \",\" THREE \",\" FOUR \",\" FIVE \",\" SIX \",\" SEVEN \",\" EIGHT \",\" NINE \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&\" Only)\"))","v":"ZERO ONLY"}]
[{"$nulls":3},{"$f":"IF(AND(P19=\"\"),\"\",IF(AND(P19=0),\"\",\"( Rs. \"&LOOKUP(IF(INT(RIGHT(P19,7)/100000)>19,INT(RIGHT(P19,7)/1000000),IF(INT(RIGHT(P19,7)/100000)>=10,INT(RIGHT(P19,7)/100000),0)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" TEN \",\" TWENTY \",\" THIRTY \",\" FOURTY \",\" FIFTY \",\" SIXTY \",\" SEVENTY \",\" EIGHTY \",\" NINETY \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&IF((IF(INT(RIGHT(P19,7)/100000)>19,INT(RIGHT(P19,7)/1000000),IF(INT(RIGHT(P19,7)/100000)>=10,INT(RIGHT(P19,7)/100000),0))+IF(INT(RIGHT(P19,7)/100000)>19,INT(RIGHT(P19,6)/100000),IF(INT(RIGHT(P19,7)/100000)>10,0,INT(RIGHT(P19,6)/100000))))>0,LOOKUP(IF(INT(RIGHT(P19,7)/100000)>19,INT(RIGHT(P19,6)/100000),IF(INT(RIGHT(P19,7)/100000)>10,0,INT(RIGHT(P19,6)/100000))),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" ONE \",\" TWO \",\" THREE \",\" FOUR \",\" FIVE \",\" SIX \",\" SEVEN \",\" EIGHT \",\" NINE \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&\" Lac. \",\" \")&LOOKUP(IF(INT(RIGHT(P19,5)/1000)>19,INT(RIGHT(P19,5)/10000),IF(INT(RIGHT(P19,5)/1000)>=10,INT(RIGHT(P19,5)/1000),0)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" TEN \",\" TWENTY \",\" THIRTY \",\" FOURTY \",\" FIFTY \",\" SIXTY \",\" SEVENTY \",\" EIGHTY \",\" NINETY \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&IF((IF(INT(RIGHT(P19,5)/1000)>19,INT(RIGHT(P19,4)/1000),IF(INT(RIGHT(P19,5)/1000)>10,0,INT(RIGHT(P19,4)/1000)))+IF(INT(RIGHT(P19,5)/1000)>19,INT(RIGHT(P19,5)/10000),IF(INT(RIGHT(P19,5)/1000)>=10,INT(RIGHT(P19,5)/1000),0)))>0,LOOKUP(IF(INT(RIGHT(P19,5)/1000)>19,INT(RIGHT(P19,4)/1000),IF(INT(RIGHT(P19,5)/1000)>10,0,INT(RIGHT(P19,4)/1000))),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" ONE \",\" TWO \",\" THREE \",\" FOUR \",\" FIVE \",\" SIX \",\" SEVEN \",\" EIGHT \",\" NINE \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&\" THOUSAND \",\" \")&IF((INT((RIGHT(P19,3))/100))>0,LOOKUP(INT((RIGHT(P19,3))/100),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" ONE \",\" TWO \",\" THREE \",\" FOUR \",\" FIVE \",\" SIX \",\" SEVEN \",\" EIGHT \",\" NINE \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&\" HUNDRED \",\" \")&LOOKUP(IF(INT(RIGHT(P19,2))>19,INT(RIGHT(P19,2)/10),IF(INT(RIGHT(P19,2))>=10,INT(RIGHT(P19,2)),0)),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" TEN \",\" TWENTY \",\" THIRTY \",\" FOURTY \",\" FIFTY \",\" SIXTY \",\" SEVENTY \",\" EIGHTY \",\" NINETY \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&LOOKUP(IF(INT(RIGHT(P19,2))<10,INT(RIGHT(P19,1)),IF(INT(RIGHT(P19,2))<20,0,INT(RIGHT(P19,1)))),{0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{\"\",\" ONE \",\" TWO \",\" THREE \",\" FOUR \",\" FIVE \",\" SIX \",\" SEVEN \",\" EIGHT \",\" NINE \",\" TEN \",\" ELEVEN \",\" TWELVE \",\" THIRTEEN \",\" FOURTEEN \",\" FIFTEEN \",\" SIXTEEN\",\" SEVENTEEN\",\" EIGHTEEN \",\" NINETEEN \"})&\" Only   Deposite In GPF)\"))","v":"( Rs.   SIXTEEN THOUSAND  SEVEN  HUNDRED  SIXTY  TWO  Only   Deposite In GPF)"}]
[null,"S.R.",{"$nulls":6},"Date :",{"$nulls":5},"SEAL AND SIGN OF DDO"]
[null,"For Copying And Necessary Action"]
[1,"Treasury Officer / Deputy treasury  Officer"]
[2,"Related Employee Sh./Smt./Mis.",{"$nulls":4},{"$f":"IF(AND(F4=\"\"),\"\",CONCATENATE(J3,\",\",\"  \",Q3))","v":"HEERA LAL JAT,  Sr. Teacher"}]
[3,"File Register"]
[{"$nulls":14},"SEAL AND SIGN OF DDO"]

{"sheet":"Unlock","index":2,"n_rows":27,"n_cols":28,"rows_kept":27,"merged":[[0,0,0,19],[1,0,1,19],[2,4,2,8],[2,9,2,13],[2,14,2,15],[2,16,2,19],[4,0,6,0],[4,1,6,1],[4,2,4,5],[4,6,4,9],[4,10,4,13],[4,14,4,16],[4,17,6,17],[4,18,6,18],[4,19,6,19],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,10,6,10],[5,11,6,11],[5,12,6,12],[5,13,6,13],[5,14,5,15],[5,16,6,16],[18,0,18,1],[19,4,19,8],[19,9,19,19],[20,3,20,18],[21,2,21,6],[21,8,21,9],[21,10,21,12],[21,14,21,19],[22,1,22,7],[23,1,23,7],[24,1,24,5],[24,6,24,12],[25,1,25,3],[26,14,26,19]]}
["DA (17%) Drawn Statement  ",{"$nulls":22},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,4,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,4,FALSE))","v":8},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,6,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,6,FALSE))","v":"NPS"},"NPS","GPF",{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,7,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,7,FALSE))","v":20}]
[{"$f":"IF(AND(Master!C3=\"\"),\"\",CONCATENATE(\"Office Of  \",Master!C3))","v":"Office Of  Government Senior Secondry School Inderwara , Pali"},{"$nulls":23},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,8,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,8,FALSE))","v":0},"YES"]
[{"$nulls":4},"Name of Employee :-",{"$nulls":4},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,2,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,2,FALSE))","v":"BHAGWAN SINGH"},{"$nulls":4},"POST:- ",null,{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,3,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,3,FALSE))","v":"LECTURER"}]
[{"$nulls":4},"Sr. No. -",3]
["Serial No.","Month\n& \nYear","Pay Due",{"$nulls":3},"Pay Drawn",{"$nulls":3},"Pay Difference",{"$nulls":3},"Deducation",null,null,"Total \nof \nDedu\nction \nCol.\n15 to 17","To be \npaid\ndeducting\nCol. 14 \nform 18","Treasury\nBill@\nVoucher \nNo.&\nDate"]
[null,null,"Basic\n","Dearness\nAllowance","H.R.A.","Total \nCol.\n3         to         5","Basic\n","Dearness\nAllowance","H.R.A.","Total \nCol.\n7        to          9","Basic\n Pay","Dearness\nAllowance","H.R.A.","Total \nCol.\n11        to            13","NPS/GPF",null,"Income   Tax  /  TDS"]
[{"$nulls":14},"NPS","GPF"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[1,"2019-07-01",{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,5,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE))","v":71300},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C9*Master!C$5%,0)))","v":12121},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C9*Master!H$5%,0)))","v":5704},{"$f":"IF(AND(C9=\"\"),\"\",SUM(C9:E9))","v":89125},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,5,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE))","v":71300},{"$f":"IF(AND(G9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G9*Master!C$4%,0)))","v":8556},{"$f":"IF(AND(G9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G9*Master!H$4%,0)))","v":5704},{"$f":"IF(AND(C9=\"\"),\"\",SUM(G9:I9))","v":85560},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(G9=\"\"),\"\",C9-G9))","v":0},3565,0,3565,{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N9)*10%,0),\"0\"))","v":357},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Y$1=AA$1),N9-Q9,\"0\"))","v":"0"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N9=\"\"),\"\",ROUND(N9*AB$1%,0)))","v":713},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C9=\"\"),\"\",IF(AND(O9=\"\"),\"\",IF(AND(P9=\"\"),\"\",O9+P9+Q9))))","v":1070},{"$f":"IF(AND(N9=\"\"),\"\",IF(AND(R9=\"\"),\"\",N9-R9))","v":2495},{"$nulls":5},"2019-07-01"]
[2,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<2),\"\",Y10))","v":"2019-08-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<2),\"\",Arrear!C9))","v":49300},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<2),\"\",Arrear!C10))","v":49300},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N10)*10%,0),\"0\"))","v":247},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Y$1=AA$1),N10-Q10,\"0\"))","v":"0"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N10=\"\"),\"\",ROUND(N10*AB$1%,0)))","v":493},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C10=\"\"),\"\",IF(AND(O10=\"\"),\"\",IF(AND(P10=\"\"),\"\",O10+P10+Q10))))","v":740},{"$f":"IF(AND(N10=\"\"),\"\",IF(AND(R10=\"\"),\"\",N10-R10))","v":1725},{"$nulls":5},"2019-08-01"]
[3,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<3),\"\",Y11))","v":"2019-09-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<3),\"\",Arrear!C10))","v":49300},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C11*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C11*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<3),\"\",Arrear!C11))","v":49300},{"$f":"IF(AND(G11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G11*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G11*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,247,"0",493,740,1725,{"$nulls":5},"2019-09-01"]
[4,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<4),\"\",Y12))","v":"2019-10-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<4),\"\",Arrear!C11))","v":49300},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C12*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C12*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<4),\"\",Arrear!C12))","v":49300},{"$f":"IF(AND(G12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G12*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G12*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,247,"0",493,740,1725,{"$nulls":5},"2019-10-01"]
[5,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<5),\"\",Y13))","v":"2019-11-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<5),\"\",Arrear!C12))","v":49300},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C13*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C13*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<5),\"\",Arrear!C13))","v":49300},{"$f":"IF(AND(G13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G13*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G13*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,247,"0",493,740,1725,{"$nulls":5},"2019-11-01"]
[6,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<6),\"\",Y14))","v":"2019-12-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<6),\"\",Arrear!C13))","v":49300},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C14*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C14*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<6),\"\",Arrear!C14))","v":49300},{"$f":"IF(AND(G14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G14*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G14*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,247,"0",493,740,1725,{"$nulls":5},"2019-12-01"]
[7,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Y15))","v":"2020-01-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Arrear!C14))","v":49300},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C15*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C15=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C15*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Arrear!C15))","v":49300},{"$f":"IF(AND(G15=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G15*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G15=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G15*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,247,"0",493,740,1725,{"$nulls":5},"2020-01-01"]
[8,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Y16))","v":"2020-02-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Arrear!C15))","v":49300},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C16*Master!C$5%,0)))","v":8381},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C16*Master!H$5%,0)))","v":3944},61625,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Arrear!C16))","v":49300},{"$f":"IF(AND(G16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G16*Master!C$4%,0)))","v":5916},{"$f":"IF(AND(G16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G16*Master!H$4%,0)))","v":3944},59160,0,2465,0,2465,247,"0",493,740,1725,{"$nulls":5},"2020-02-01"]
[9,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Y17))","v":""},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Arrear!C16))","v":""},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C17*Master!C$5%,0)))","v":""},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C17*Master!H$5%,0)))","v":""},"",{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Arrear!C17))","v":""},{"$f":"IF(AND(G17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G17*Master!C$4%,0)))","v":""},{"$f":"IF(AND(G17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G17*Master!H$4%,0)))","v":""},"","","","","","","","","","",{"$nulls":5},"2020-03-01"]
[12,"Surrender Arrear",{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Y$2=Z$2),VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE)/2,\"\"))","v":""},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C18*Master!C$5%,0)))","v":""},{"$f":"IF(AND(C18=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C18*Master!H$5%,0)))","v":""},"",{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Y$2=Z$2),VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE)/2,\"\"))","v":""},{"$f":"IF(AND(G18=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G18*Master!C$4%,0)))","v":""},{"$f":"IF(AND(G18=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G18*Master!H$4%,0)))","v":""},"","","","","","","","","","",{"$nulls":5},"2020-06-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C9:C18))","v":416400},70788,33312,520500,416400,49968,33312,499680,0,20820,0,20820,2086,0,4164,6250,14570]
[{"$nulls":4},"Cash Amount in Words :",{"$nulls":4},"ZERO ONLY"]
[]
[null,"S.R.",{"$nulls":6},"Date :",{"$nulls":5},"SEAL AND SIGN OF DDO"]
[null,"For Copying And Necessary Action"]
[1,"Treasury Officer / Deputy treasury  Officer"]
[2,"Related Employee Sh./Smt./Mis.",{"$nulls":4},{"$f":"IF(AND(F4=\"\"),\"\",CONCATENATE(J3,\",\",\"  \",Q3))","v":"BHAGWAN SINGH,  LECTURER"}]
[3,"File Register"]
[{"$nulls":14},"SEAL AND SIGN OF DDO"]