{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Data Entry sheet","PL Report"],"not_rendered":{"images":1,"external_links":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Data Entry sheet","index":0,"n_rows":415,"n_cols":16,"rows_kept":415,"merged":[[1,0,3,1],[2,2,2,6],[4,2,4,4],[5,2,5,4],[408,2,408,5],[409,2,409,5],[410,2,410,5],[411,2,411,5],[412,2,412,5],[414,6,414,8]]}
[]
["कार्यालय का नाम / पीईईओ विद्यालय का नाम :-"]
[null,null,"jktdh; mPp ek/;fed fo|ky; bUnjokM+k] ¼jkuh½ ikyh"]
[]
[null,null,"मंत्रालय कर्मचारियों के लिए निर्धारित उपार्जित अवकाश :-",null,null,30]
[null,null,"अन्य कार्मिको के लिए निर्धारित उपार्जित अवकाश :-",null,null,15]
[]
["क्र. स. ","कार्यालय / विद्यालय का नाम","कार्मिक का नाम ","पद   ","प्रथम नियुक्ति तिथि","जन्म तिथि","मंत्रालय कर्मचारी     अन्य कार्मिक / अधिकारी"]
[1,"GUPS","Jai Shree ","Teacher","2006-07-20","1980-01-01","अन्य कार्मिक / अधिकारी",{"$nulls":8},"मंत्रालय कर्मचारी"]
[2,"GUPS","Krishana","LDC","2010-01-01","1990-01-01","मंत्रालय कर्मचारी",{"$nulls":8},"अन्य कार्मिक / अधिकारी"]
[3,"PS","Ram","Teacher","1980-08-10","1991-07-02","अन्य कार्मिक / अधिकारी"]
[4,"PS","shyam","Teacher","2019-11-18","1992-07-03","अन्य कार्मिक / अधिकारी"]
[5,"PS","kailash","Teacher","2012-09-20","1992-07-04","अन्य कार्मिक / अधिकारी"]
[6,"GUPS","dinesh","UDC","2012-09-21","1995-05-05","मंत्रालय कर्मचारी"]
[7,"GUPS","Ranu","Sr. Teacher","2006-07-14","1986-06-06","अन्य कार्मिक / अधिकारी"]
[8,"GUPS","rekha","LDC","2018-06-17","1985-05-05","मंत्रालय कर्मचारी"]
[9,"PS","mohan","Teacher","2005-05-05","1987-07-07","अन्य कार्मिक / अधिकारी"]
{"$rows_empty":391}
[null,null,"Programmer  &   Presented By"]
[null,null,"HEERA LAL JAT"]
[null,null,"Sr. Teacher at GSSS Inderwara (PALI)"]
[null,null,"V./P. -  CHANDAWAL NAGAR , SOJAT (PALI)"]
[null,null,"heeralaljatexcelguru@gmail.com"]
[]
[{"$nulls":6},"t; xq:nso oklqnso th egkjkt"]

{"sheet":"PL Report","index":1,"n_rows":129,"n_cols":30,"rows_kept":129,"merged":[[0,2,0,12],[1,2,1,12],[1,16,4,21],[2,2,2,3],[2,4,2,10],[3,2,3,3],[3,4,3,12],[4,2,4,3],[4,4,4,8],[4,9,4,10],[4,11,4,12],[5,2,5,3],[5,4,5,8],[5,9,5,10],[5,11,5,12],[6,2,7,2],[6,3,6,4],[6,5,6,9],[6,10,6,11],[6,12,7,12],[7,16,12,20],[15,16,15,20],[16,16,16,20],[17,16,17,20],[18,16,18,20]]}
[null,null,"izi= &2 dkfeZd mikftZr vodk'k ys[kk fooj.k",{"$nulls":21},"मंत्रालय कर्मचारी",null,"izfrekg",{"$f":"IFERROR(DAY(D9),\"\")","v":20},{"$f":"IFERROR(DATEDIF(D9,E9,\"M\"),\"\")","v":5},{"$f":"IF(AND(AD7<=730),\"\",IF(AND(AA6<E9),\"\",IF(AB1<=15,AC1+1,AC1)))","v":5}]
[null,null,"¼izFke fu;qfDr frfFk ls vc rd lsok fjdkMZ ds vk/kkj ij ½",{"$nulls":13},"जिस कार्मिक की पीएल अवकाश की डिटेल चाहिए, उस कार्मिक की जो डाटा एंट्री शीट पर क्रम संख्या हैं उसे  पिले कलर की सेल में देकर रिपोर्ट generate कर सकते हैं ",{"$nulls":7},"अन्य कार्मिक / अधिकारी",{"$f":"'Data Entry sheet'!F5","v":30},{"$f":"Z2/12","v":2.5},null,{"$f":"IFERROR(IF(AND(AD7<=730),\"\",IF(AND(AA6<E9),\"\",IF(AND(AC4=Y1),ROUND(ROUND(AD1*AA2,0),0),IF(AND(AC4=Y2),ROUND(ROUND(AD1*AA4,0),0),\"\")))),\"\")","v":6}]
[null,null,"dk;kZy; dk uke %&",null,{"$f":"IFERROR(IF($M$3=\"\",\"\",'Data Entry sheet'!C3),\"\")","v":"jktdh; mPp ek/;fed fo|ky; bUnjokM+k] ¼jkuh½ ikyh"},{"$nulls":6},"Sr. No.",1]
[null,null,"fo|ky; dk uke %&",null,{"$f":"IFERROR(IF($M$3=\"\",\"\",VLOOKUP(M3,'Data Entry sheet'!A9:G407,2,0)),\"\")","v":"GUPS"},{"$nulls":18},"2020-12-31",null,{"$f":"'Data Entry sheet'!F6","v":15},{"$f":"Z4/12","v":1.25},null,{"$f":"VLOOKUP(M3,'Data Entry sheet'!A9:G407,7,0)","v":"अन्य कार्मिक / अधिकारी"}]
[null,null,"dkfeZd dk uke %&",null,{"$f":"IFERROR(IF($M$3=\"\",\"\",VLOOKUP(M3,'Data Entry sheet'!A9:G407,3,0)),\"\")","v":"Jai Shree "},{"$nulls":4},"tUefrfFk",null,{"$f":"IFERROR(IF($M$3=\"\",\"\",VLOOKUP(M3,'Data Entry sheet'!A9:G407,6,0)),\"\")","v":"1980-01-01"},{"$nulls":11},2]
[null,null,"in %&",null,{"$f":"IFERROR(IF($M$3=\"\",\"\",VLOOKUP(M3,'Data Entry sheet'!A9:G407,4,0)),\"\")","v":"Teacher"},{"$nulls":4},"izFke fu;qfDr frfFk",null,{"$f":"IFERROR(IF($M$3=\"\",\"\",VLOOKUP(M3,'Data Entry sheet'!A9:G407,5,0)),\"\")","v":"2006-07-20"},{"$nulls":11},{"$f":"EDATE(E9+1,0)","v":"2009-01-01"},1,null,{"$f":"TODAY()","v":"2020-06-21"},{"$f":"YEAR((AA6))","v":2020}]
[null,null,"Ø-l-","dSysUMj o\"kZ",null,",d dySUMj o\"kZ esa vftZr fd;s x;s mikftZr vodk'k",{"$nulls":4},"o\"kZ esa fy, x;s mikftZr vodk'k",null,"o\"kZ ds vUr esa vo'ks\"k dqy ih,y vodk'k",{"$nulls":12},{"$f":"L5","v":"1980-01-01"},{"$f":"L6","v":"2006-07-20"},{"$f":"YEAR(Z7)+60","v":2040},null,{"$f":"DATEDIF(AA7,AA6,\"D\")","v":5085}]
[{"$nulls":3},"1 tuojh ls","31 fnlEcj"," dySUMj o\"kZ esa vftZr mikftZr vodk'k","lsokdky dh ,ot esa izkIr ih,y","fo\"ks'k dk;Z dh ,ot esa izkIr ih,y","vuqi;ksftr dk;Z xzg.k vof/k","o\"kZ esa dqy vftZr vodk'k","mi;ksx fd;s x;s ih,y vodk'k","lefiZr fd;s x;s ih,y vodk'k",{"$nulls":4},"सेवाकाल की एवज में , विशेष कार्य की एवज में, अनुपयोजित कार्यग्रहण अवधि,  उपयोग किये गए तथा समर्पित किये गए अवकाश की प्रविष्टि आप PL पासवर्ड लगाकर सेल को अनलॉक करके कर सकते हैं ",{"$nulls":9},{"$f":"YEAR(AA7)+2","v":2008}]
[{"$f":"MOD(B9,2)","v":1},{"$f":"IF(LEN(D9)>=3,1,0)","v":1},{"$f":"IF(B9=0,\"\",B9)","v":1},{"$f":"IFERROR(IF($M$3=\"\",\"\",IF(Z9=\"\",\"\",IF(AD7>730,DATE(YEAR($L$6)+($X$5),MONTH($L$6),DAY($L$6)),\"\"))),\"\")","v":"2008-07-20"},{"$f":"IFERROR(IF(D9=\"\",\"\",DATE(YEAR(D9),MONTH($X$4),DAY($X$4))),\"\")","v":"2008-12-31"},{"$f":"IFERROR(IF(D9=\"\",\"\",AC2),\"\")","v":6},{"$f":"IFERROR(IF(D9=\"\",\"\",IF(F9=\"\",\"\",F9)),\"\")","v":6},0,0,{"$f":"IFERROR(IF(D9=\"\",\"\",SUM(G9,H9,I9)),\"\")","v":6},0,0,{"$f":"IFERROR(IF(D9=\"\",\"\",SUM(J9-K9-L9)),\"\")","v":6},{"$nulls":12},{"$f":"YEAR(AA7)+2","v":2008},{"$f":"IF(AA8<$AB$7,AA8+1,\"\")","v":2009}]
[{"$f":"MOD(B10,2)","v":0},{"$f":"IF(LEN(D10)>=3,B9+1,0)","v":2},{"$f":"IF(B10=0,\"\",B10)","v":2},{"$f":"IFERROR(IF($M$3=\"\",\"\",IF(Z10=\"\",\"\",DATE(YEAR(X6),MONTH($X$6),DAY($X$6)))),\"\")","v":"2009-01-01"},"2009-12-31",{"$f":"IFERROR(IF(D10=\"\",\"\",$AC$10),\"\")","v":15},{"$f":"IFERROR(IF(D10=\"\",\"\",SUM(M9,F10)),\"\")","v":21},null,null,{"$f":"IFERROR(IF(D10=\"\",\"\",SUM(G10,H10,I10)),\"\")","v":21},null,null,{"$f":"IFERROR(IF(D10=\"\",\"\",SUM(J10-K10-L10)),\"\")","v":21},{"$nulls":12},{"$f":"IF(Z9<$AB$6,Z9+1,\"\")","v":2009},2010,null,{"$f":"IF(AND(AC4=Y1),ROUND((Z2),0),IF(AND(AC4=Y2),ROUND((Z4),0),\"\"))","v":15}]
[{"$f":"MOD(B11,2)","v":1},{"$f":"IF(LEN(D11)>=3,B10+1,0)","v":3},3,{"$f":"IFERROR(IF($M$3=\"\",\"\",IF(Z11=\"\",\"\",DATE(YEAR(D10)+$Y$6,MONTH($X$6),DAY($X$6)))),\"\")","v":"2010-01-01"},"2010-12-31",{"$f":"IFERROR(IF(D11=\"\",\"\",$AC$10),\"\")","v":15},{"$f":"IFERROR(IF(D11=\"\",\"\",SUM(M10,F11)),\"\")","v":36},null,null,36,null,null,36,{"$nulls":12},2010,2011]
[0,4,4,{"$f":"IFERROR(IF($M$3=\"\",\"\",IF(Z12=\"\",\"\",DATE(YEAR(D11)+$Y$6,MONTH($X$6),DAY($X$6)))),\"\")","v":"2011-01-01"},"2011-12-31",15,51,null,null,51,null,null,51,{"$nulls":12},2011,2012]
[{"$f":"MOD(B13,2)","v":1},{"$f":"IF(LEN(D13)>=3,B12+1,0)","v":5},{"$f":"IF(B13=0,\"\",B13)","v":5},"2012-01-01","2012-12-31",15,66,null,null,66,null,null,66,{"$nulls":12},2012,2013]
[{"$f":"MOD(B14,2)","v":0},{"$f":"IF(LEN(D14)>=3,B13+1,0)","v":6},{"$f":"IF(B14=0,\"\",B14)","v":6},"2013-01-01","2013-12-31",15,81,null,null,81,null,null,81,{"$nulls":10}," ",null,2013,2014]
[1,7,7,"2014-01-01","2014-12-31",15,96,null,null,96,null,null,96,{"$nulls":12},2014,2015]
[0,8,8,"2015-01-01","2015-12-31",15,111,null,null,{"$f":"IFERROR(IF(D16=\"\",\"\",SUM(G16,H16,I16)),\"\")","v":111},null,null,111,{"$nulls":3},"इस प्रोग्राम का निर्माणकर्त्ता ",{"$nulls":8},2015,2016]
[1,9,9,"2016-01-01","2016-12-31",15,126,null,null,126,null,null,126,{"$nulls":3},"हीरालाल जाट ",{"$nulls":8},2016,2017]
[0,10,10,"2017-01-01","2017-12-31",15,141,null,null,141,null,null,141,{"$nulls":3},"वरिष्ठ अध्यापक एवं एक्सेल प्रोग्रामर ",{"$nulls":8},2017,2018]
[1,11,11,"2018-01-01","2018-12-31",15,156,null,null,156,null,null,156,{"$nulls":3},"चंडावल नगर , सोजत , जिला - पाली ",{"$nulls":8},{"$f":"IF(Z18<$AB$6,Z18+1,\"\")","v":2018},{"$f":"IF(AA18<$AB$7,AA18+1,\"\")","v":2019}]
[0,12,12,"2019-01-01","2019-12-31",15,171,null,null,171,null,null,171,{"$nulls":12},2019,2020]
[1,13,13,"2020-01-01","2020-12-31",15,186,null,null,186,null,null,186,{"$nulls":12},2020,2021]
[{"$f":"MOD(B22,2)","v":0},{"$f":"IF(LEN(D22)>=3,B21+1,0)","v":0},{"$f":"IF(B22=0,\"\",B22)","v":""},"","","","",null,null,"",null,null,"",{"$nulls":12},"",2022]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2023]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2024]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2025]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2026]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2027]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2028]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2029]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2030]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2031]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2032]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2033]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2034]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2035]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2036]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2037]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2038]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2039]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",2040]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[0,0,"","","","","",null,null,"",null,null,"",{"$nulls":12},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},{"$f":"IF(Z82<$AB$6,Z82+1,\"\")","v":""},{"$f":"IF(AA82<$AB$7,AA82+1,\"\")","v":""}]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]
[{"$nulls":25},"",""]