{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Master","Arrear","Unlock","Surrender Arrear"],"not_rendered":{"images":1,"defined_names":3},"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",{"$nulls":7},"ije~ iwT; xq:nso oklqnso th egkjkt dks ueu"]
[2,"KALYAN SINGH","LECTURER",8,47000,"NPS"]
[3,"BHAGWAN SINGH","LECTURER",8,71300,"NPS"]
[4,"MANGILAL RANGI","Sr. Teacher",8,71300,"GPF"]
[5,"HEERA LAL JAT","Sr. Teacher",8,49300,"GPF",null,"YES"]
[6,"MAHENDRA PATEL","Sr. Teacher",8,41300,"NPS"]
[7,"BHALA RAM MOBARSA","TEACHER L-1",8,67000,"GPF"]
[8,"ARJUN SINGH","TEACHER L-1",8,46500,"GPF"]
[9,"SURESH KUMAR ADARA","TEACHER L-2",8,50800,"NPS"]
[10,"LALIT KUMAR","TEACHER L-1",8,50800,"GPF"]
[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"]
[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":31,"n_cols":28,"rows_kept":31,"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],[14,0,14,1],[18,0,18,1],[19,0,19,1],[20,4,20,8],[20,9,20,19],[21,3,21,18],[22,1,22,3],[22,4,22,6],[22,7,22,9],[25,2,25,6],[25,8,25,9],[25,10,25,12],[25,14,25,19],[26,1,26,7],[27,1,27,7],[28,1,28,5],[28,6,28,12],[29,1,29,3],[30,14,30,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":0}]
[{"$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":"MISHRI LAL"},{"$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":"PRINCIPAL"}]
[{"$nulls":4},"Sr. No. -",1]
["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":71400},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C9*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C9*Master!H$5%,0)))","v":5712},{"$f":"IF(AND(C9=\"\"),\"\",SUM(C9:E9))","v":89250},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,5,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE))","v":71400},{"$f":"IF(AND(G9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G9*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G9*Master!H$4%,0)))","v":5712},{"$f":"IF(AND(C9=\"\"),\"\",SUM(G9:I9))","v":85680},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(G9=\"\"),\"\",C9-G9))","v":0},3570,0,3570,{"$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":3570},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N9=\"\"),\"\",ROUND(N9*AB$1%,0)))","v":0},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C9=\"\"),\"\",IF(AND(O9=\"\"),\"\",IF(AND(P9=\"\"),\"\",O9+P9+Q9))))","v":3570},{"$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":71400},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<2),\"\",Arrear!C10))","v":71400},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,{"$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":3570},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N10=\"\"),\"\",ROUND(N10*AB$1%,0)))","v":0},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C10=\"\"),\"\",IF(AND(O10=\"\"),\"\",IF(AND(P10=\"\"),\"\",O10+P10+Q10))))","v":3570},{"$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":71400},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C11*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C11*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<3),\"\",Arrear!C11))","v":71400},{"$f":"IF(AND(G11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G11*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G11*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,"0",3570,0,3570,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":71400},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C12*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C12*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<4),\"\",Arrear!C12))","v":71400},{"$f":"IF(AND(G12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G12*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G12*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,"0",3570,0,3570,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":71400},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C13*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C13*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<5),\"\",Arrear!C13))","v":71400},{"$f":"IF(AND(G13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G13*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G13*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,"0",3570,0,3570,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":71400},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C14*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C14*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<6),\"\",Arrear!C14))","v":71400},{"$f":"IF(AND(G14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G14*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G14*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,"0",{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Y$1=AA$1),N14-Q14,\"0\"))","v":3570},0,3570,0,{"$nulls":5},"2019-12-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C9:C14))","v":428400},{"$f":"IF(AND($F$4=\"\"),\"\",SUM(D9:D14))","v":72828},34272,535500,428400,51408,34272,514080,0,21420,0,21420,0,21420,0,21420,0]
[7,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Y16))","v":"2020-01-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Arrear!C14))","v":71400},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C16*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C16*Master!H$5%,0)))","v":5712},{"$f":"IF(AND(C16=\"\"),\"\",SUM(C16:E16))","v":89250},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Arrear!C16))","v":71400},{"$f":"IF(AND(G16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G16*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G16*Master!H$4%,0)))","v":5712},{"$f":"IF(AND(C16=\"\"),\"\",SUM(G16:I16))","v":85680},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(G16=\"\"),\"\",C16-G16))","v":0},{"$f":"IF(AND(D16=\"\"),\"\",IF(AND(H16=\"\"),\"\",D16-H16))","v":3570},{"$f":"IF(AND(E16=\"\"),\"\",IF(AND(I16=\"\"),\"\",E16-I16))","v":0},{"$f":"IF(AND(F16=\"\"),\"\",IF(AND(J16=\"\"),\"\",F16-J16))","v":3570},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N16)*10%,0),\"0\"))","v":"0"},3570,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N16=\"\"),\"\",ROUND(N16*AB$1%,0)))","v":0},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C16=\"\"),\"\",IF(AND(O16=\"\"),\"\",IF(AND(P16=\"\"),\"\",O16+P16+Q16))))","v":3570},{"$f":"IF(AND(N16=\"\"),\"\",IF(AND(R16=\"\"),\"\",N16-R16))","v":0},{"$nulls":5},"2020-01-01"]
[8,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Y17))","v":"2020-02-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Arrear!C16))","v":71400},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C17*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C17*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Arrear!C17))","v":71400},{"$f":"IF(AND(G17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G17*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G17*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,"0",3570,0,3570,0,{"$nulls":5},"2020-02-01"]
[9,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Y18))","v":""},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Arrear!C17))","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(Arrear!X$1<9),\"\",Arrear!C18))","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-03-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C16:C18))","v":142800},{"$f":"IF(AND($F$4=\"\"),\"\",SUM(D16:D18))","v":24276},11424,178500,142800,17136,11424,171360,0,7140,0,7140,0,7140,0,7140,0,{"$nulls":5},"2020-04-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C15+C19))","v":571200},{"$f":"IF(AND($F$4=\"\"),\"\",SUM(D15+D19))","v":97104},45696,714000,571200,68544,45696,685440,0,28560,0,28560,0,28560,0,28560,0]
[{"$nulls":4},"Cash Amount in Words :",{"$nulls":4},{"$f":"IF(AND(F4=\"\"),\"\",IF(AND(S20=0),\"ZERO ONLY\",\"( Rs. \"&LOOKUP(IF(INT(RIGHT(S20,7)/100000)>19,INT(RIGHT(S20,7)/1000000),IF(INT(RIGHT(S20,7)/100000)>=10,INT(RIGHT(S20,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(S20,7)/100000)>19,INT(RIGHT(S20,7)/1000000),IF(INT(RIGHT(S20,7)/100000)>=10,INT(RIGHT(S20,7)/100000),0))+IF(INT(RIGHT(S20,7)/100000)>19,INT(RIGHT(S20,6)/100000),IF(INT(RIGHT(S20,7)/100000)>10,0,INT(RIGHT(S20,6)/100000))))>0,LOOKUP(IF(INT(RIGHT(S20,7)/100000)>19,INT(RIGHT(S20,6)/100000),IF(INT(RIGHT(S20,7)/100000)>10,0,INT(RIGHT(S20,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(S20,5)/1000)>19,INT(RIGHT(S20,5)/10000),IF(INT(RIGHT(S20,5)/1000)>=10,INT(RIGHT(S20,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(S20,5)/1000)>19,INT(RIGHT(S20,4)/1000),IF(INT(RIGHT(S20,5)/1000)>10,0,INT(RIGHT(S20,4)/1000)))+IF(INT(RIGHT(S20,5)/1000)>19,INT(RIGHT(S20,5)/10000),IF(INT(RIGHT(S20,5)/1000)>=10,INT(RIGHT(S20,5)/1000),0)))>0,LOOKUP(IF(INT(RIGHT(S20,5)/1000)>19,INT(RIGHT(S20,4)/1000),IF(INT(RIGHT(S20,5)/1000)>10,0,INT(RIGHT(S20,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(S20,3))/100))>0,LOOKUP(INT((RIGHT(S20,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(S20,2))>19,INT(RIGHT(S20,2)/10),IF(INT(RIGHT(S20,2))>=10,INT(RIGHT(S20,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(S20,2))<10,INT(RIGHT(S20,1)),IF(INT(RIGHT(S20,2))<20,0,INT(RIGHT(S20,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(P20=\"\"),\"\",IF(AND(P20=0),\"\",\"( Rs. \"&LOOKUP(IF(INT(RIGHT(P20,7)/100000)>19,INT(RIGHT(P20,7)/1000000),IF(INT(RIGHT(P20,7)/100000)>=10,INT(RIGHT(P20,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(P20,7)/100000)>19,INT(RIGHT(P20,7)/1000000),IF(INT(RIGHT(P20,7)/100000)>=10,INT(RIGHT(P20,7)/100000),0))+IF(INT(RIGHT(P20,7)/100000)>19,INT(RIGHT(P20,6)/100000),IF(INT(RIGHT(P20,7)/100000)>10,0,INT(RIGHT(P20,6)/100000))))>0,LOOKUP(IF(INT(RIGHT(P20,7)/100000)>19,INT(RIGHT(P20,6)/100000),IF(INT(RIGHT(P20,7)/100000)>10,0,INT(RIGHT(P20,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(P20,5)/1000)>19,INT(RIGHT(P20,5)/10000),IF(INT(RIGHT(P20,5)/1000)>=10,INT(RIGHT(P20,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(P20,5)/1000)>19,INT(RIGHT(P20,4)/1000),IF(INT(RIGHT(P20,5)/1000)>10,0,INT(RIGHT(P20,4)/1000)))+IF(INT(RIGHT(P20,5)/1000)>19,INT(RIGHT(P20,5)/10000),IF(INT(RIGHT(P20,5)/1000)>=10,INT(RIGHT(P20,5)/1000),0)))>0,LOOKUP(IF(INT(RIGHT(P20,5)/1000)>19,INT(RIGHT(P20,4)/1000),IF(INT(RIGHT(P20,5)/1000)>10,0,INT(RIGHT(P20,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(P20,3))/100))>0,LOOKUP(INT((RIGHT(P20,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(P20,2))>19,INT(RIGHT(P20,2)/10),IF(INT(RIGHT(P20,2))>=10,INT(RIGHT(P20,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(P20,2))<10,INT(RIGHT(P20,1)),IF(INT(RIGHT(P20,2))<20,0,INT(RIGHT(P20,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.   TWENTY  EIGHT  THOUSAND  FIVE  HUNDRED  SIXTY  Only   Deposite In GPF)"}]
[null,"july19 to Dec.19  total ",null,null,"jan20 to Feb20  total ",null,null,"july19 to Dec.19  total "]
[null,"total Diff","GPF/NPS","Paid","total Diff","GPF/NPS","Paid","total Diff","GPF/NPS","Paid"]
[null,{"$f":"N15","v":21420},{"$f":"IF(AND(Y$1=AA$1),P15,O15)","v":21420},{"$f":"S15","v":0},{"$f":"N19","v":7140},{"$f":"IF(AND(Y$1=AA$1),P19,O19)","v":7140},{"$f":"S19","v":0},{"$f":"N20","v":28560},{"$f":"IF(AND(Y$1=AA$1),P20,O20)","v":28560},{"$f":"S20","v":0}]
[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":"MISHRI LAL,  PRINCIPAL"}]
[3,"File Register"]
[{"$nulls":14},"SEAL AND SIGN OF DDO"]

{"sheet":"Unlock","index":2,"n_rows":31,"n_cols":28,"rows_kept":31,"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],[14,0,14,1],[18,0,18,1],[19,0,19,1],[20,4,20,8],[20,9,20,19],[21,3,21,18],[22,1,22,3],[22,4,22,6],[22,7,22,9],[25,2,25,6],[25,8,25,9],[25,10,25,12],[25,14,25,19],[26,1,26,7],[27,1,27,7],[28,1,28,5],[28,6,28,12],[29,1,29,3],[30,14,30,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":0}]
[{"$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":"MAHENDRA PATEL"},{"$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. -",6]
["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":41300},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C9*Master!C$5%,0)))","v":7021},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C9*Master!H$5%,0)))","v":3304},{"$f":"IF(AND(C9=\"\"),\"\",SUM(C9:E9))","v":51625},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,5,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE))","v":41300},{"$f":"IF(AND(G9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G9*Master!C$4%,0)))","v":4956},{"$f":"IF(AND(G9=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G9*Master!H$4%,0)))","v":3304},{"$f":"IF(AND(C9=\"\"),\"\",SUM(G9:I9))","v":49560},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(G9=\"\"),\"\",C9-G9))","v":0},2065,0,2065,{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N9)*10%,0),\"0\"))","v":207},{"$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":0},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C9=\"\"),\"\",IF(AND(O9=\"\"),\"\",IF(AND(P9=\"\"),\"\",O9+P9+Q9))))","v":207},{"$f":"IF(AND(N9=\"\"),\"\",IF(AND(R9=\"\"),\"\",N9-R9))","v":1858},{"$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":71400},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<2),\"\",Arrear!C10))","v":71400},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N10)*10%,0),\"0\"))","v":357},{"$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":0},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C10=\"\"),\"\",IF(AND(O10=\"\"),\"\",IF(AND(P10=\"\"),\"\",O10+P10+Q10))))","v":357},{"$f":"IF(AND(N10=\"\"),\"\",IF(AND(R10=\"\"),\"\",N10-R10))","v":3213},{"$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":71400},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C11*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C11*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<3),\"\",Arrear!C11))","v":71400},{"$f":"IF(AND(G11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G11*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G11=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G11*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,357,"0",0,357,3213,{"$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":71400},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C12*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C12*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<4),\"\",Arrear!C12))","v":71400},{"$f":"IF(AND(G12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G12*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G12=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G12*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,357,"0",0,357,3213,{"$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":71400},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C13*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C13*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<5),\"\",Arrear!C13))","v":71400},{"$f":"IF(AND(G13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G13*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G13=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G13*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,357,"0",0,357,3213,{"$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":71400},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C14*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C14*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<6),\"\",Arrear!C14))","v":71400},{"$f":"IF(AND(G14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G14*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G14=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G14*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,357,{"$f":"IF(AND(C14=\"\"),\"\",IF(AND(Y$1=AA$1),N14-Q14,\"0\"))","v":"0"},0,357,3213,{"$nulls":5},"2019-12-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C9:C14))","v":398300},{"$f":"IF(AND($F$4=\"\"),\"\",SUM(D9:D14))","v":67711},31864,497875,398300,47796,31864,477960,0,19915,0,19915,1992,0,0,1992,17923]
[7,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Y16))","v":"2020-01-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Arrear!C14))","v":71400},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C16*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C16*Master!H$5%,0)))","v":5712},{"$f":"IF(AND(C16=\"\"),\"\",SUM(C16:E16))","v":89250},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<7),\"\",Arrear!C16))","v":71400},{"$f":"IF(AND(G16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G16*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G16=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G16*Master!H$4%,0)))","v":5712},{"$f":"IF(AND(C16=\"\"),\"\",SUM(G16:I16))","v":85680},{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(G16=\"\"),\"\",C16-G16))","v":0},3570,0,3570,{"$f":"IF(AND(C16=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N16)*10%,0),\"0\"))","v":357},"0",{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(N16=\"\"),\"\",ROUND(N16*AB$1%,0)))","v":0},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C16=\"\"),\"\",IF(AND(O16=\"\"),\"\",IF(AND(P16=\"\"),\"\",O16+P16+Q16))))","v":357},{"$f":"IF(AND(N16=\"\"),\"\",IF(AND(R16=\"\"),\"\",N16-R16))","v":3213},{"$nulls":5},"2020-01-01"]
[8,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Y17))","v":"2020-02-01"},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Arrear!C16))","v":71400},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C17*Master!C$5%,0)))","v":12138},{"$f":"IF(AND(C17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C17*Master!H$5%,0)))","v":5712},89250,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<8),\"\",Arrear!C17))","v":71400},{"$f":"IF(AND(G17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G17*Master!C$4%,0)))","v":8568},{"$f":"IF(AND(G17=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G17*Master!H$4%,0)))","v":5712},85680,0,3570,0,3570,357,"0",0,357,3213,{"$nulls":5},"2020-02-01"]
[9,{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Y18))","v":""},{"$f":"IF(AND($F$4=\"\"),\"\",IF(AND(Arrear!X$1<9),\"\",Arrear!C17))","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(Arrear!X$1<9),\"\",Arrear!C18))","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-03-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C16:C18))","v":142800},{"$f":"IF(AND($F$4=\"\"),\"\",SUM(D16:D18))","v":24276},11424,178500,142800,17136,11424,171360,0,7140,0,7140,714,0,0,714,6426,{"$nulls":5},"2020-04-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C15+C19))","v":541100},{"$f":"IF(AND($F$4=\"\"),\"\",SUM(D15+D19))","v":91987},43288,676375,541100,64932,43288,649320,0,27055,0,27055,2706,0,0,2706,24349]
[{"$nulls":4},"Cash Amount in Words :"]
[]
[null,"july19 to Dec.19  total ",null,null,"jan20 to Feb20  total ",null,null,"july19 to Dec.19  total "]
[null,"total Diff","GPF/NPS","Paid","total Diff","GPF/NPS","Paid","total Diff","GPF/NPS","Paid"]
[null,{"$f":"N15","v":19915},{"$f":"IF(AND(Y$1=AA$1),P15,O15)","v":1992},{"$f":"S15","v":17923},{"$f":"N19","v":7140},{"$f":"IF(AND(Y$1=AA$1),P19,O19)","v":714},{"$f":"S19","v":6426},{"$f":"N20","v":27055},{"$f":"IF(AND(Y$1=AA$1),P20,O20)","v":2706},{"$f":"S20","v":24349}]
[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":"MAHENDRA PATEL,  Sr. Teacher"}]
[3,"File Register"]
[{"$nulls":14},"SEAL AND SIGN OF DDO"]

{"sheet":"Surrender Arrear","index":3,"n_rows":19,"n_cols":28,"rows_kept":19,"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,6,4,13],[5,0,7,0],[5,1,7,1],[5,2,5,5],[5,6,5,9],[5,10,5,13],[5,14,5,16],[5,17,7,17],[5,18,7,18],[5,19,7,19],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[6,14,6,15],[6,16,7,16],[10,0,10,1],[11,4,11,8],[11,9,11,19],[12,3,12,18],[13,2,13,6],[13,8,13,9],[13,10,13,12],[13,14,13,19],[14,1,14,7],[15,1,15,7],[16,1,16,5],[16,6,16,12],[17,1,17,3],[18,14,18,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":0}]
[{"$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":"MAHENDRA PATEL"},{"$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. -",6]
[{"$nulls":6},"Surrender Arrear Statement"]
["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,"Surrender",{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,5,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE))/2","v":20650},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(C10*Master!C$5%,0)))","v":3511},null,{"$f":"IF(AND(C10=\"\"),\"\",SUM(C10:E10))","v":24161},{"$f":"IF(ISNA(VLOOKUP($F$4,Master!A$8:N$127,5,FALSE)),\"\",VLOOKUP($F$4,Master!A$8:AH$127,5,FALSE))/2","v":20650},{"$f":"IF(AND(G10=\"\"),\"\",IF(AND($F$4=\"\"),\"\",ROUND(G10*Master!C$4%,0)))","v":2478},null,{"$f":"IF(AND(C10=\"\"),\"\",SUM(G10:I10))","v":23128},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(G10=\"\"),\"\",C10-G10))","v":0},1033,"",1033,{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(Y$1=Z$1),ROUND((N10)*10%,0),\"0\"))","v":103},{"$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":0},{"$f":"IF(AND(F$4=\"\"),\"\",IF(AND(C10=\"\"),\"\",IF(AND(O10=\"\"),\"\",IF(AND(P10=\"\"),\"\",O10+P10+Q10))))","v":103},{"$f":"IF(AND(N10=\"\"),\"\",IF(AND(R10=\"\"),\"\",N10-R10))","v":930},{"$nulls":5},"2019-07-01"]
["TOTAL",null,{"$f":"IF(AND($F$4=\"\"),\"\",SUM(C10))","v":20650},{"$f":"IF(AND($F$4=\"\"),\"\",SUM(D10))","v":3511},0,24161,20650,2478,0,23128,0,1033,0,1033,103,0,0,103,930,{"$nulls":5},"2020-04-01"]
[{"$nulls":4},"Cash Amount in Words :"]
[]
[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":"MAHENDRA PATEL,  Sr. Teacher"}]
[3,"File Register"]
[{"$nulls":14},"SEAL AND SIGN OF DDO"]