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

{"sheet":"Order","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"merged":[[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,4,5],[3,6,4,6],[3,7,3,8],[3,9,3,10],[3,11,4,12],[5,11,5,12],[8,10,8,12],[9,10,9,12],[10,10,10,12],[11,0,11,12],[12,0,12,12],[13,0,13,12],[14,0,14,12],[15,0,15,12],[16,10,16,12],[17,10,17,12],[18,10,18,12]]}
["   dk;kZy; jktdh; mPp ek/;fed fo|ky; bUnjokM+k ¼jkuh½] ftyk&ikyh"]
["         dzekad &jkmekfo@bUnjokM+k@,lhih@2020@                                                         fnuakd&"]
["                foRr foHkkx ds vkns'k dzekad&F.15(1)FD(RULES) 2017 t;iqj fnukad 09-12-2017 ,oa lifBr fnukad 30-10-2017 ds fu;e 14] vuqlwph&VI ds fcUnq la[;k 02] vuqlwph&1 ¼ikVZ ,½ esa of.kZr LEVEL IN PAY MATRIX ,oa n'kkZ;s x;s izko/kkukuqlkj deZpkjh Jherh papy pkS/kjh ds uke lEeq[k vafdr frfFk ls ,-lh-ih-(ASSURED CAREER PROGRESSION) dh Lohd`fr  iznku dh tkrh gS muds uke ds lEeq[k vafdr Lohd`r jfuax is iS.M @is&eSfVªDl ysoy esas osru fu/kkZj.k vf/klwpuk ds fu;e 14 ,oa vuqlwph&VI¼fu;e 14½ esa funsZf'kr izfdz;k ds vuqlkj Lohd`fr iznku dh tkrh gSA ,-lh-ih- fnukad 12-11-2018 ls 31-10-2019 dh vof/k dk ,fj;j fu;ekuqlkj ns; gksxkA"]
["dz-l-","uke deZpkjh e; in","inLFkkiu LFkku@fo|ky; dk uke",",lhih Lohd`fr vkns'k",null,",lhih vof/k",",lhih frfFk Lohd`fr frfFk ","fnukd 12-11-2018 dks ,lhih ls iwoZ osrueku o osru ",null,"fnukd 12-11-2018 dks ,lhih Lohd`fr i'pkr~ fu;r osrueku o osru ",null,"vxkeh osru o`f} fnukad"]
[{"$nulls":3},"dzekad","fnukad",null,null,"PAY MATRIX LEVEL","BASIC","PAY MATRIX LEVEL","BASIC"]
[1,"Jherh papy pkS/kjh","jkmekfo nM+koV","1876@ 1890","2019-08-21","27 o\"khZ;","2018-11-12","L-12",59500,"L-13",61500,"01&07&2019"]
[]
[]
[{"$nulls":10},"iz/kkukpk;Z"]
[{"$nulls":10},"jktdh; mPp ek/;fed fo|ky;"]
[{"$nulls":10},"bUnjokM+k] ikyh"]
["izfrfyfi%& lwpukFkZ ,oa vko';d dk;Zokgh gsrq izsf\"kr gS&"]
["1& midks\"k@midks\"kkf/kdkjh ikyhA"]
["2& lacaf/kr deZpkjh Jh@Jherh@------------------------------A"]
["3& dk;kZy; izfr-A"]
[]
[{"$nulls":10},"iz/kkukpk;Z"]
[{"$nulls":10},"jktdh; mPp ek/;fed fo|ky;"]
[{"$nulls":10},"bUnjokM+k] ikyh"]

{"sheet":"Arrear Sheet","index":1,"n_rows":28,"n_cols":33,"rows_kept":28,"merged":[[0,2,0,16],[1,5,1,13],[2,1,2,3],[2,4,2,6],[2,8,2,9],[2,10,2,12],[2,13,2,19],[3,1,4,18],[6,0,7,0],[6,1,7,1],[6,2,6,5],[6,6,6,9],[6,10,6,13],[6,14,7,14],[6,15,7,15],[6,16,7,16],[6,17,7,17],[6,18,7,18],[6,19,7,19],[7,32,7,33],[8,0,9,0],[8,28,12,30],[8,32,8,33],[10,32,10,33],[11,32,11,33],[12,32,12,33],[13,32,13,33],[14,32,14,33],[20,0,20,1],[20,18,20,19],[22,7,22,9],[22,10,22,19],[23,2,23,6],[23,9,23,10],[24,1,24,7],[24,16,24,19],[25,1,25,6],[25,16,25,19],[26,1,26,4],[26,5,26,9],[26,16,27,19],[27,1,27,2]]}
[null,null,"PEEO OFFICE / Principal, Govt. Sr. Secondary School INDERWARA, Rani (Pali)"]
[]
[null,"Employee Name :",null,null,"Chanchal Choudhary",null,null,"Post :","Sr. Teacher",null,"Posting Place :",null,null,"GSSS INDERWARA"]
[null,"ACP Arrear "]
[]
[]
["S.N","MONTH"," Pay is to be receive",{"$nulls":3}," Pay , salary has been Received",{"$nulls":3},"Salary Difference",{"$nulls":3},"NPS Ded.","INCOME TAX     (TDS)","TOTAL DED.","NET PAY ","Bill No & Date","Enc.Date"]
[null,null,"Pay","DA","HRA","TOTAL","Pay","DA","HRA","TOTAL","Pay","DA","HRA","TOTAL",{"$nulls":18},"This Programme Developed by:        HEERALAL JAT "]
[1,"1-12-18 to 11-12-18",{"$f":"ROUND(Order!I6/31*11,0)","v":21113},{"$f":"ROUND((C9*9%),0)","v":1900},{"$f":"ROUND((C9*8%),0)","v":1689},{"$f":"SUM(C9:E9)","v":24702},{"$f":"ROUND(Order!I6/31*11,0)","v":21113},{"$f":"ROUND((G9*9%),0)","v":1900},{"$f":"ROUND((G9*8%),0)","v":1689},{"$f":"SUM(G9:I9)","v":24702},{"$f":"IF(AND(C9=\"\",G9=\"\"),\"\",C9-G9)","v":0},{"$f":"IF(AND(D9=\"\"),\"\",IF(AND(H9=\"\"),\"\",D9-H9))","v":0},0,{"$f":"IF(AND(F9=\"\",J9=\"\"),\"\",SUM(F9-J9))","v":0},{"$f":"IF(AND(C9=\"\"),\"\",IF(AND(N9=\"\"),\"\",ROUND((K9+L9)*10%,0)))","v":0},{"$f":"IF(AND(N9=\"\"),\"\",ROUND((N9*10%),0))","v":0},{"$f":"IF(AND(N9=\"\"),\"\",SUM(O9,P9))","v":0},{"$f":"IF(AND(N9=\"\"),\"\",IF(AND(C9=\"\"),\"\",IF(AND(Q9=\"\"),N9,N9-Q9)))","v":0},{"$nulls":3},{"$f":"#REF!-#REF!","v":{"$error":"#REF!"}},{"$nulls":6},"ije~ iwT; xq:nso oklqnso th egkjkt dks ueu",{"$nulls":3},"Sr.  Teacher"]
[null,"12-12-18 to 31-12-18",{"$f":"ROUND(Order!K6/31*20,0)","v":39677},{"$f":"ROUND((C10*9%),0)","v":3571},{"$f":"ROUND((C10*8%),0)","v":3174},{"$f":"SUM(C10:E10)","v":46422},{"$f":"ROUND(Order!I6/31*20,0)","v":38387},{"$f":"ROUND((G10*9%),0)","v":3455},{"$f":"ROUND((G10*8%),0)","v":3071},{"$f":"SUM(G10:I10)","v":44913},{"$f":"IF(AND(C10=\"\",G10=\"\"),\"\",C10-G10)","v":1290},116,103,{"$f":"IF(AND(F10=\"\",J10=\"\"),\"\",SUM(F10-J10))","v":1509},{"$f":"IF(AND(C10=\"\"),\"\",IF(AND(N10=\"\"),\"\",ROUND((K10+L10)*10%,0)))","v":141},{"$f":"IF(AND(N10=\"\"),\"\",ROUND((N10*10%),0))","v":151},{"$f":"IF(AND(N10=\"\"),\"\",SUM(O10,P10))","v":292},{"$f":"IF(AND(N10=\"\"),\"\",IF(AND(C10=\"\"),\"\",IF(AND(Q10=\"\"),N10,N10-Q10)))","v":1217}]
[2,"2019-01-01",{"$f":"Order!K6","v":61500},{"$f":"ROUND((C11*12%),0)","v":7380},{"$f":"ROUND((C11*8%),0)","v":4920},{"$f":"IF(AND($E$3=\"\"),\"\",IF(AND(C11=\"\"),\"\",SUM(C11:E11)))","v":73800},{"$f":"Order!I6","v":59500},{"$f":"ROUND((G11*12%),0)","v":7140},{"$f":"ROUND((G11*8%),0)","v":4760},{"$f":"IF(AND($E$3=\"\"),\"\",IF(AND(G11=\"\"),\"\",SUM(G11:I11)))","v":71400},{"$f":"IF(AND(C11=\"\",G11=\"\"),\"\",C11-G11)","v":2000},240,160,{"$f":"IF(AND(F11=\"\",J11=\"\"),\"\",SUM(F11-J11))","v":2400},{"$f":"IF(AND(C11=\"\"),\"\",IF(AND(N11=\"\"),\"\",ROUND((K11+L11)*10%,0)))","v":224},{"$f":"IF(AND(N11=\"\"),\"\",ROUND((N11*10%),0))","v":240},{"$f":"IF(AND(N11=\"\"),\"\",SUM(O11,P11))","v":464},{"$f":"IF(AND(N11=\"\"),\"\",IF(AND(C11=\"\"),\"\",IF(AND(Q11=\"\"),N11,N11-Q11)))","v":1936},{"$nulls":3},{"$f":"ROUND(#REF!*#REF!/#REF!,0)","v":{"$error":"#REF!"}}," ",{"$nulls":9},"Government Aadras Senior Secondary School INDERWARA, Rani PALI"]
[3,"2019-02-01",{"$f":"C11","v":61500},{"$f":"ROUND((C12*12%),0)","v":7380},{"$f":"ROUND((C12*8%),0)","v":4920},{"$f":"IF(AND($E$3=\"\"),\"\",IF(AND(C12=\"\"),\"\",SUM(C12:E12)))","v":73800},{"$f":"G11","v":59500},{"$f":"ROUND((G12*12%),0)","v":7140},{"$f":"ROUND((G12*8%),0)","v":4760},{"$f":"IF(AND($E$3=\"\"),\"\",IF(AND(G12=\"\"),\"\",SUM(G12:I12)))","v":71400},{"$f":"IF(AND(C12=\"\",G12=\"\"),\"\",C12-G12)","v":2000},240,160,{"$f":"IF(AND(F12=\"\",J12=\"\"),\"\",SUM(F12-J12))","v":2400},{"$f":"IF(AND(C12=\"\"),\"\",IF(AND(N12=\"\"),\"\",ROUND((K12+L12)*10%,0)))","v":224},{"$f":"IF(AND(N12=\"\"),\"\",ROUND((N12*10%),0))","v":240},{"$f":"IF(AND(N12=\"\"),\"\",SUM(O12,P12))","v":464},{"$f":"IF(AND(N12=\"\"),\"\",IF(AND(C12=\"\"),\"\",IF(AND(Q12=\"\"),N12,N12-Q12)))","v":1936},{"$nulls":3},{"$f":"ROUND(#REF!*V9/#REF!,0)","v":{"$error":"#REF!"}},{"$nulls":10},"V./P. = Chandawal Nagar , Th. - Sojat , Dist-- Pali"]
[4,"2019-03-01",{"$f":"C12","v":61500},7380,{"$f":"ROUND((C13*8%),0)","v":4920},{"$f":"IF(AND($E$3=\"\"),\"\",IF(AND(C13=\"\"),\"\",SUM(C13:E13)))","v":73800},{"$f":"G12","v":59500},7140,{"$f":"ROUND((G13*8%),0)","v":4760},{"$f":"IF(AND($E$3=\"\"),\"\",IF(AND(G13=\"\"),\"\",SUM(G13:I13)))","v":71400},{"$f":"IF(AND(C13=\"\",G13=\"\"),\"\",C13-G13)","v":2000},{"$f":"IF(AND(D13=\"\"),\"\",IF(AND(H13=\"\"),\"\",D13-H13))","v":240},{"$f":"IF(AND(E13=\"\"),\"\",IF(AND(I13=\"\"),\"\",E13-I13))","v":160},{"$f":"IF(AND(F13=\"\",J13=\"\"),\"\",SUM(F13-J13))","v":2400},{"$f":"IF(AND(C13=\"\"),\"\",IF(AND(N13=\"\"),\"\",ROUND((K13+L13)*10%,0)))","v":224},{"$f":"IF(AND(N13=\"\"),\"\",ROUND((N13*10%),0))","v":240},{"$f":"IF(AND(N13=\"\"),\"\",SUM(O13,P13))","v":464},{"$f":"IF(AND(N13=\"\"),\"\",IF(AND(C13=\"\"),\"\",IF(AND(Q13=\"\"),N13,N13-Q13)))","v":1936},{"$nulls":3},{"$f":"SUM(V11:V12)","v":{"$error":"#REF!"}},{"$nulls":10},"heeralaljatchandawal@gmail.com"]
[5,"2019-04-01",61500,7380,4920,73800,59500,7140,4760,71400,2000,240,160,2400,224,240,464,1936,{"$nulls":14},"Contect time =  04:30 P.M. to 7:30 P.M."]
[6,"2019-05-01",61500,7380,4920,73800,59500,7140,4760,71400,2000,240,160,2400,224,240,464,1936]
[7,"2019-06-01",61500,7380,4920,73800,59500,7140,4760,71400,2000,240,160,2400,224,240,464,1936]
[8,"2019-07-01",{"$f":"MROUND(C16*1.03,100)","v":63300},{"$f":"ROUND((C17*17%),0)","v":10761},5064,79125,{"$f":"MROUND(G16*1.03,100)","v":61300},{"$f":"ROUND((G17*17%),0)","v":10421},4904,76625,2000,340,160,2500,234,250,484,2016]
[9,"2019-08-01",63300,{"$f":"ROUND((C18*17%),0)","v":10761},5064,79125,61300,{"$f":"ROUND((G18*17%),0)","v":10421},4904,76625,2000,340,160,2500,234,250,484,2016]
[10,"2019-09-01",63300,10761,5064,79125,61300,10421,4904,76625,2000,340,160,2500,234,250,484,2016]
[11,"2019-10-01",63300,10761,5064,79125,61300,10421,4904,76625,2000,340,160,2500,234,250,484,2016]
["Grand Total",null,{"$f":"SUM(C9:C20)","v":682990},{"$f":"SUM(D9:D20)","v":92795},54639,830424,661700,89879,52936,804515,21290,2916,1703,25909,2421,2591,5012,{"$f":"SUM(R9:R20)","v":20897}]
[{"$nulls":21},{"$f":"ROUND((G9+H9)*10%,0)","v":2301}]
[{"$nulls":7},"In words :",null,null,"( Rs - Twenty Thousand Eight Hundred Ninty Seven )",{"$nulls":10},{"$f":"ROUND((G11+H11)*10%,0)","v":6664}]
[null,"S.R.",{"$nulls":6},"Date :"]
[null,"For Copying And Necessary Action",{"$nulls":14},"(MISHRI LAL )"]
[1,"Treasury Officer / Deputy treasury  Officer",{"$nulls":14},"Seal and Signature"]
[2,"Related Employee Sh./Smt./Mis.",{"$nulls":3},{"$f":"E3&\",  \"&I3","v":"Chanchal Choudhary,  Sr. Teacher"},{"$nulls":10},"Government  Senior Secondary School INDERWARA, Rani PALI"]
[3,"File Register"]