{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instruction","detail","01.07.22 PEEO school","Metrix chart"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instruction","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,9],[13,0,13,9],[4,1,4,9],[9,1,9,9],[10,1,10,9],[11,0,11,9],[12,0,12,9],[15,1,15,2],[15,5,15,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[5,1,5,9],[8,1,8,9],[6,1,6,9],[7,1,7,9]]}
["नमस्कार साथिओ"]
["आपकी सहायतार्थ मैने जुलाई 2022 में लगने वाली वार्षिक वेतन वृद्धि के आदेश बनाने के लिए यह एक्सेल प्रोग्राम बनाया है आशा करता हु इससे आपको बहुत सहायता मिलेगी |"]
["प्रयोग में लेना का तरीका "]
["सर्वप्रथम detail में आप अपने कार्यालय का नाम एवं अधीनस्थ विद्यालयों के कर्मचरियों का डाटा इस प्रकार से भरे |"]
["कार्यालय का नाम","कार्यालय का नाम लिखना है जिससे आदेश जारी होने है"]
["नाम कर्मचारी -","इसमें कर्मचारी का नाम लिखे "]
["पद -","कर्मचारी का पद लिखे "]
["सथायी","कर्मचारी का स्थायी का विवरण"]
["नाम विद्यालय -","सम्बंधित कर्मचारी के विद्यालय का नाम लिखे"]
["लेवल -","कर्मचारी का लेवल लिखे"]
["वर्तमान वेतन -","कर्मचारी का 30 जून 2022 का मूल वेतन लिखे"]
["ये डाटा भरने के बाद आपका वार्षिक वेतन वृद्धि आर्डर तैयार हो जायेगा आप इसका प्रिंट लेकर कर्मचारी की निजी पंजिका में लगा सकते है |"]
["For any Problem you can Contact-"]
["SUMIT GIRI, Senior Assistant"]
["Government Senior Secondary School, 15Z (Sri Ganganagar)"]
[null,9414631519,null,null,null,"sumitgiri777@gmail.com"]
["Password to enter details is 'sumit'.  All  sheets are protected. "]

{"sheet":"detail","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,7],[4,5,4,6],[2,0,2,2],[2,3,2,7],[1,0,1,2],[1,3,1,7],[3,0,3,2],[3,3,3,7]]}
["jktLFkku ljdkj "]
["dk;kZy; dk uke %&",null,null,"ihbZbZvks 10tSM ,oa iz/kkukpk;Z jkmekfo 15tSM Jhxaxkuxj"]
["fnukad 30twu rd izkIr osru dh fnukad",null,null,"2021-07-01"]
["osru o`f} dh fnukad %&",null,null,"2022-07-01"]
["Ø-la-","dkfeZd dk uke","dkfeZd dk in","LFkk;h ;k LFkkukiUUk ","inLFkkiu LFkku ","is&eSfVªDl ysoy",null,"orZeku osru"]
[1,"Jh lqfer fxjh","o0v0 ¼iz/kkuk/;kid½","LFkk;h","jkmizzkfo 12tSM","Leval-","12",61300]
[2,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizzkfo 12tSM","Leval-","12",59500]
[3,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizzkfo 12tSM","Leval-","11",43800]
[4,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizzkfo 12tSM","Leval-","11",45100]
[5,"Jh lqfer fxjh"," 'kk-f'k-","LFkk;h","jkmizzkfo 12tSM","Leval-","12",56100]
[6,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizzkfo 12tSM","Leval-","10",35800]
[7,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizzkfo 10, NksVh","Leval-","11",43800]
[8,"Jh lqfer fxjh","v- ysoy&k","LFkk;h","jkizkfo 8, NksVh","Leval-","10",39100]
[9,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkizkfo 8, NksVh","Leval-","10",33800]
[10,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkizkfo 8tSM","Leval-","13",65200]
[11,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkizkfo 8tSM","Leval-","10",33800]
[12,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]
[13,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]
[14,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]
[15,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]
[16,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]
[17,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]
[18,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]
[19,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]
[20,"Jh lqfer fxjh","v0 ysoy&kk","LFkk;h","jkmizkfo 10, NksVh","Leval-","10",36900]

{"sheet":"01.07.22 PEEO school","index":2,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,4,3,9],[5,1,5,17],[2,1,2,2],[2,3,2,4],[2,6,2,17],[31,1,31,17],[32,11,32,13],[0,0,0,17],[7,10,8,10],[7,13,8,13],[7,14,7,15],[7,16,7,17],[9,1,9,2],[9,5,9,7],[7,0,9,0],[7,1,8,2],[7,4,8,4],[7,5,8,7],[7,8,8,8],[7,9,8,9],[1,1,1,17]]}
["jktLFkku ljdkj "]
[null,"dkfeZd ¼[k&1½ foHkkx "]
[null,"fu;rdkyhu osru o`f} izek.k i= ",null,"dk;kZy; %& ",null,null,{"$f":"detail!$D$2","v":"ihbZbZvks 10tSM ,oa iz/kkukpk;Z jkmekfo 15tSM Jhxaxkuxj"}]
[null,"Schedule-1","Part `B`","Rule No. 5(vi) and (vii)","Pay Matrix of State Government Servants",null,null,null,null,null,"bl foHkkx dh vkKk ","ua-,Q15¼1½,QMh@:Yl@2017 ",null,null,"t;iqj]","fnukad","2017-12-30","ds vuqlj.k esa "]
[]
[null,"1   izekf.kr fd;k tkrk gS fd fuEufyf[kr jkT; deZpkjh us [kkuk la[;k 6 esa cryk, x, fu;e ls fu/kkZfjr fu;rdkfyd osruo`f} vftZr dj yh gSa jkT; deZpkjh us [kkuk la[;k 5 dh rkjh[k ls fufnZ\"V in ij u;s osrueku 2017 ds fu;ekuqlkj vof/k esa dk;Z fd;k gSA mDr vof/k dh x.kuk nqjkpj.k vkfn ds dkj.k fuyEcu dh vof/k] osru vodk'k] vuqifLFkfr dh vof/k o in dks LFkkukiUu :i ls /kkj.k djus dh fLFkfr esas lHkh izdkj ds vodk'kksa dh vof/k ?kVk dj dh xbZ gSA  "]
[]
["Ø-la-","deZpkjh dk uke e; in",null,{"$f":"detail!$D$2","v":"ihbZbZvks 10tSM ,oa iz/kkukpk;Z jkmekfo 15tSM Jhxaxkuxj"},"laLFkk;h ;k LFkkukiUUk ","is&eSfVªDl ysoy",null,null,"orZeku osru ","rkjh[k ftllasa orZeku osru izkIr fd;k tk jgk gS ","orZeku osru o`f} dh rkjh[k ","le lkef;d osru o`f)",0.03,"Hkkoh osru","nqjkpj.k ds fuyEcu vkSj ,slh vU; vuqifLFkfr ftldh x.kuk o`f} ds fy, ugha gksrh ",null,"fcuk osru vkSj LFkkukuUu inkf/kdkjh;kss ds ekeyksa ds vU; lHkh izdkj ds vodk'k "]
[null,null,null,"ifj{ks= ds dkfeZd dk inLFkkiu fo|ky; dk uke",null,null,null,null,null,null,null,0.03,null,null,"rkjh[k ls ","rkjh[k rd ","rkjh[k ls ","rkjh[k rd"]
[null,1,null,null,2,3,null,null,4,5,6,7,7,8,9,10,11,12]
[1,{"$f":"detail!B6","v":"Jh lqfer fxjh"},{"$f":"detail!C6","v":"o0v0 ¼iz/kkuk/;kid½"},{"$f":"detail!E6","v":"jkmizzkfo 12tSM"},{"$f":"detail!D6","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F6","v":"Leval-"},{"$f":"detail!G6","v":"12"},{"$f":"detail!H6","v":61300},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},{"$f":"ROUND(M11,-2)","v":1800},{"$f":"I11*3/100","v":1839},{"$f":"I11+L11","v":63100}]
[2,{"$f":"detail!B7","v":"Jh lqfer fxjh"},{"$f":"detail!C7","v":"v0 ysoy&kk"},{"$f":"detail!E7","v":"jkmizzkfo 12tSM"},{"$f":"detail!D7","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F7","v":"Leval-"},{"$f":"detail!G7","v":"12"},{"$f":"detail!H7","v":59500},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},{"$f":"ROUND(M12,-2)","v":1800},1785,{"$f":"I12+L12","v":61300}]
[3,{"$f":"detail!B8","v":"Jh lqfer fxjh"},{"$f":"detail!C8","v":"v0 ysoy&kk"},{"$f":"detail!E8","v":"jkmizzkfo 12tSM"},{"$f":"detail!D8","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F8","v":"Leval-"},{"$f":"detail!G8","v":"11"},{"$f":"detail!H8","v":43800},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},{"$f":"ROUND(M13,-2)","v":1300},1314,{"$f":"I13+L13","v":45100}]
[4,{"$f":"detail!B9","v":"Jh lqfer fxjh"},{"$f":"detail!C9","v":"v0 ysoy&kk"},{"$f":"detail!E9","v":"jkmizzkfo 12tSM"},{"$f":"detail!D9","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F9","v":"Leval-"},{"$f":"detail!G9","v":"11"},{"$f":"detail!H9","v":45100},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1400,1353,{"$f":"I14+L14","v":46500}]
[5,{"$f":"detail!B10","v":"Jh lqfer fxjh"},{"$f":"detail!C10","v":" 'kk-f'k-"},{"$f":"detail!E10","v":"jkmizzkfo 12tSM"},{"$f":"detail!D10","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F10","v":"Leval-"},{"$f":"detail!G10","v":"12"},{"$f":"detail!H10","v":56100},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1700,{"$f":"I15*3/100","v":1683},{"$f":"I15+L15","v":57800}]
[6,{"$f":"detail!B11","v":"Jh lqfer fxjh"},{"$f":"detail!C11","v":"v0 ysoy&kk"},{"$f":"detail!E11","v":"jkmizzkfo 12tSM"},{"$f":"detail!D11","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F11","v":"Leval-"},{"$f":"detail!G11","v":"10"},{"$f":"detail!H11","v":35800},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1100,1074,36900]
[7,{"$f":"detail!B12","v":"Jh lqfer fxjh"},{"$f":"detail!C12","v":"v0 ysoy&kk"},{"$f":"detail!E12","v":"jkmizzkfo 10, NksVh"},{"$f":"detail!D12","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F12","v":"Leval-"},{"$f":"detail!G12","v":"11"},{"$f":"detail!H12","v":43800},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1300,1314,45100]
[8,{"$f":"detail!B13","v":"Jh lqfer fxjh"},{"$f":"detail!C13","v":"v- ysoy&k"},{"$f":"detail!E13","v":"jkizkfo 8, NksVh"},{"$f":"detail!D13","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F13","v":"Leval-"},{"$f":"detail!G13","v":"10"},{"$f":"detail!H13","v":39100},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1200,1173,{"$f":"I18+L18","v":40300}]
[9,{"$f":"detail!B14","v":"Jh lqfer fxjh"},{"$f":"detail!C14","v":"v0 ysoy&kk"},{"$f":"detail!E14","v":"jkizkfo 8, NksVh"},{"$f":"detail!D14","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F14","v":"Leval-"},{"$f":"detail!G14","v":"10"},{"$f":"detail!H14","v":33800},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1000,1014,{"$f":"I19+L19","v":34800}]
[10,{"$f":"detail!B15","v":"Jh lqfer fxjh"},{"$f":"detail!C15","v":"v0 ysoy&kk"},{"$f":"detail!E15","v":"jkizkfo 8tSM"},{"$f":"detail!D15","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F15","v":"Leval-"},{"$f":"detail!G15","v":"13"},{"$f":"detail!H15","v":65200},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},2000,{"$f":"I20*3/100","v":1956},{"$f":"I20+L20","v":67200}]
[11,{"$f":"detail!B16","v":"Jh lqfer fxjh"},{"$f":"detail!C16","v":"v0 ysoy&kk"},{"$f":"detail!E16","v":"jkizkfo 8tSM"},{"$f":"detail!D16","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F16","v":"Leval-"},{"$f":"detail!G16","v":"10"},{"$f":"detail!H16","v":33800},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1000,{"$f":"I21*3/100","v":1014},34800]
[12,{"$f":"detail!B17","v":"Jh lqfer fxjh"},{"$f":"detail!C17","v":"v0 ysoy&kk"},{"$f":"detail!E17","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D17","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F17","v":"Leval-"},{"$f":"detail!G17","v":"10"},{"$f":"detail!H17","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1100,{"$f":"I22*3/100","v":1107},{"$f":"I22+L22","v":38000}]
[13,{"$f":"detail!B18","v":"Jh lqfer fxjh"},{"$f":"detail!C18","v":"v0 ysoy&kk"},{"$f":"detail!E18","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D18","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F18","v":"Leval-"},{"$f":"detail!G18","v":"10"},{"$f":"detail!H18","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1100,{"$f":"I23*3/100","v":1107},{"$f":"I23+L23","v":38000}]
[14,{"$f":"detail!B19","v":"Jh lqfer fxjh"},{"$f":"detail!C19","v":"v0 ysoy&kk"},{"$f":"detail!E19","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D19","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F19","v":"Leval-"},{"$f":"detail!G19","v":"10"},{"$f":"detail!H19","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1100,1107,{"$f":"I24+L24","v":38000}]
[15,{"$f":"detail!B20","v":"Jh lqfer fxjh"},{"$f":"detail!C20","v":"v0 ysoy&kk"},{"$f":"detail!E20","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D20","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F20","v":"Leval-"},{"$f":"detail!G20","v":"10"},{"$f":"detail!H20","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1100,{"$f":"I25*3/100","v":1107},{"$f":"I25+L25","v":38000}]
[16,{"$f":"detail!B21","v":"Jh lqfer fxjh"},{"$f":"detail!C21","v":"v0 ysoy&kk"},{"$f":"detail!E21","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D21","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F21","v":"Leval-"},{"$f":"detail!G21","v":"10"},{"$f":"detail!H21","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1100,{"$f":"I26*3/100","v":1107},{"$f":"I26+L26","v":38000}]
[17,{"$f":"detail!B22","v":"Jh lqfer fxjh"},{"$f":"detail!C22","v":"v0 ysoy&kk"},{"$f":"detail!E22","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D22","v":"LFkk;h"},"PB(2)- (9300-34800) (5400)",{"$f":"detail!F22","v":"Leval-"},{"$f":"detail!G22","v":"10"},{"$f":"detail!H22","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1100,{"$f":"I27*3/100","v":1107},{"$f":"I27+L27","v":38000}]
[18,{"$f":"detail!B23","v":"Jh lqfer fxjh"},{"$f":"detail!C23","v":"v0 ysoy&kk"},{"$f":"detail!E23","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D23","v":"LFkk;h"},null,{"$f":"detail!F23","v":"Leval-"},{"$f":"detail!G23","v":"10"},{"$f":"detail!H23","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},{"$f":"ROUND(M28,-2)","v":1100},{"$f":"I28*3/100","v":1107},{"$f":"I28+L28","v":38000}]
[19,{"$f":"detail!B24","v":"Jh lqfer fxjh"},{"$f":"detail!C24","v":"v0 ysoy&kk"},{"$f":"detail!E24","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D24","v":"LFkk;h"},null,{"$f":"detail!F24","v":"Leval-"},{"$f":"detail!G24","v":"10"},{"$f":"detail!H24","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},{"$f":"ROUND(M29,-2)","v":1100},{"$f":"I29*3/100","v":1107},{"$f":"I29+L29","v":38000}]
[20,{"$f":"detail!B25","v":"Jh lqfer fxjh"},{"$f":"detail!C25","v":"v0 ysoy&kk"},{"$f":"detail!E25","v":"jkmizkfo 10, NksVh"},{"$f":"detail!D25","v":"LFkk;h"},null,{"$f":"detail!F25","v":"Leval-"},{"$f":"detail!G25","v":"10"},{"$f":"detail!H25","v":36900},{"$f":"detail!$D$3","v":"2021-07-01"},{"$f":"detail!$D$4","v":"2022-07-01"},1100,1107,38000]
[]
[null,"         izekf.kr fd;k tkrk gS fd jktLFkku lsok fu;e 31ds vuqlkj mi;qZDr vodk'k dh x.kuk ml in ds le;eku esa osru o`f} ds fy, ekU; gksrh gS ftl ij mi;qZDr jkT; deZpkjh vodk'k tkrs le; LFkkukiUu fLFkfr esa dk;Z dj jgk Fkk vkSj og vodk'k ij ugha tkrk rks aLFkkukiUu fLFkfr esa dk;Z djrk jgrkA "]
[null,"Øekad %&","------------------------------------------------------------------",null,null,null,null,null,null,null,"fnukad","------------------------"]
[null,"uksV%& 1 dkj.k la[;k ¼1½ ;k ¼2½ izR;sd uke ds vkxs fy[kh tkuh pkfg,A ftl izzdj.k esa dkj.k la[;k ¼2½ Hkkx gksrk gS og Li\"Vhdj.k Kkiu layXu djuk pkfg,A"]
[null,"la[;k%& ua-,Q15¼1½,QMh@:Yl@2017                  t;iqj fnukad%& 30-10-2017"]
[null,"2 vuqHkkxkf/kdkjh] dkfeZd ¼x½ foHkkx 'kklu lfpoky; dks vfrfjDr izfr lfgr lwpukFkZ ,oa vko';d dk;Zokgh gsrq izsf\"kr gSA "]
[null,"3 lacaf/kr O;fDr@dkfeZd A "]
[null,"4 futh i=koyh @jf{kr i=koyhA "]
[null,"5 Jheku dks\"kkf/kdkjh@midks\"kkf/kdkjh ---------------------------------"]

{"sheet":"Metrix chart","index":3,"n_rows":46,"n_cols":28,"rows_kept":46,"cut":false,"hidden":false,"merged":[[5,1,5,24],[0,0,0,24],[1,1,1,9],[1,10,1,13],[1,14,1,20],[1,21,1,24]]}
["Pay Metrix of State Government Servents wef 01-10-2017"]
["Existing Pay Band","PB-1 (5200-20200)",null,null,null,null,null,null,null,null,"PB-2 (9300-34800)",null,null,null,"PB-3 (15600-39100)",null,null,null,null,null,null,"PB-4 (37400-67000)",null,null,null,null,{"$f":"RIGHT(AA4,LEN(AA4)-2)+1","v":13},{"$f":"CONCATENATE(\"L-\",AA2)","v":"L-13"}]
["Existing Grade Pay",1700,1750,1900,2000,2400,2400,2400,2800,2800,3600,4200,4800,5400,5400,6000,6600,6800,7200,7600,8200,8700,8900,9500,10000,null,{"$f":"[1]Entry!E11","v":59500},{"$f":"ROUND(AA5*3%,-2)+AA5","v":61300}]
["Existing Grade Pay No.",2,3,4,5,9,"9A","9B",10,"10A",11,12,13,15,15,16,17,18,19,20,21,22,23,"23A",24,null,{"$f":"[1]Entry!G11","v":"L-12"},{"$f":"AB2","v":"L-13"}]
["Level","L-1 ","L-2","L-3","L-4","L-5","L-6","L-7","L-8","L-9","L-10","L-11","L-12","L-13","L-14","L-15","L-16","L-17","L-18","L-19","L-20","L-21","L-22","L-23","L-24",null,{"$f":"INDEX($AA$7:$AA$46,MATCH(TRUE,INDEX($AA$7:$AA$46>=AA3,0),))","v":59500},{"$f":"INDEX($AB$7:$AB$46,MATCH(TRUE,INDEX($AB$7:$AB$46>=AB3,0),))","v":61500}]
["Cell No.","Pay Metrix (Amount in Rs.)"]
[1,17700,17900,18200,19200,20800,21500,22400,26300,28700,33800,37800,44300,53100,56100,60700,67300,71000,75300,79900,88900,123100,129700,145800,148800,null,{"$f":"IF($AA$4=\"L-1\",B7,IF($AA$4=\"L-2\",C7,IF($AA$4=\"L-3\",D7,IF($AA$4=\"L-4\",E7,IF($AA$4=\"L-5\",F7,IF($AA$4=\"L-6\",G7,IF($AA$4=\"L-7\",H7,IF($AA$4=\"L-8\",I7,IF($AA$4=\"L-9\",J7,IF($AA$4=\"L-10\",K7,IF($AA$4=\"L-11\",L7,IF($AA$4=\"L-12\",M7,IF($AA$4=\"L-13\",N7,IF($AA$4=\"L-14\",O7,IF($AA$4=\"L-15\",P7,IF($AA$4=\"L-16\",Q7,IF($AA$4=\"L-17\",R7,IF($AA$4=\"L-18\",S7,IF($AA$4=\"L-19\",T7,IF($AA$4=\"L-20\",U7,IF($AA$4=\"L-21\",V7,IF($AA$4=\"L-22\",W7,IF($AA$4=\"L-23\",X7,IF($AA$4=\"L-24\",Y7,\"\"))))))))))))))))))))))))","v":44300},{"$f":"IF($AB$4=\"L-1\",B7,IF($AB$4=\"L-2\",C7,IF($AB$4=\"L-3\",D7,IF($AB$4=\"L-4\",E7,IF($AB$4=\"L-5\",F7,IF($AB$4=\"L-6\",G7,IF($AB$4=\"L-7\",H7,IF($AB$4=\"L-8\",I7,IF($AB$4=\"L-9\",J7,IF($AB$4=\"L-10\",K7,IF($AB$4=\"L-11\",L7,IF($AB$4=\"L-12\",M7,IF($AB$4=\"L-13\",N7,IF($AB$4=\"L-14\",O7,IF($AB$4=\"L-15\",P7,IF($AB$4=\"L-16\",Q7,IF($AB$4=\"L-17\",R7,IF($AB$4=\"L-18\",S7,IF($AB$4=\"L-19\",T7,IF($AB$4=\"L-20\",U7,IF($AB$4=\"L-21\",V7,IF($AB$4=\"L-22\",W7,IF($AB$4=\"L-23\",X7,IF($AB$4=\"L-24\",Y7,\"\"))))))))))))))))))))))))","v":53100}]
[2,18200,18400,18700,19800,21400,22100,23100,27100,29600,34800,38900,45600,54700,57800,62500,69300,73100,77600,82300,91600,126800,133600,150200,153300,null,{"$f":"IF($AA$4=\"L-1\",B8,IF($AA$4=\"L-2\",C8,IF($AA$4=\"L-3\",D8,IF($AA$4=\"L-4\",E8,IF($AA$4=\"L-5\",F8,IF($AA$4=\"L-6\",G8,IF($AA$4=\"L-7\",H8,IF($AA$4=\"L-8\",I8,IF($AA$4=\"L-9\",J8,IF($AA$4=\"L-10\",K8,IF($AA$4=\"L-11\",L8,IF($AA$4=\"L-12\",M8,IF($AA$4=\"L-13\",N8,IF($AA$4=\"L-14\",O8,IF($AA$4=\"L-15\",P8,IF($AA$4=\"L-16\",Q8,IF($AA$4=\"L-17\",R8,IF($AA$4=\"L-18\",S8,IF($AA$4=\"L-19\",T8,IF($AA$4=\"L-20\",U8,IF($AA$4=\"L-21\",V8,IF($AA$4=\"L-22\",W8,IF($AA$4=\"L-23\",X8,IF($AA$4=\"L-24\",Y8,\"\"))))))))))))))))))))))))","v":45600},{"$f":"IF($AB$4=\"L-1\",B8,IF($AB$4=\"L-2\",C8,IF($AB$4=\"L-3\",D8,IF($AB$4=\"L-4\",E8,IF($AB$4=\"L-5\",F8,IF($AB$4=\"L-6\",G8,IF($AB$4=\"L-7\",H8,IF($AB$4=\"L-8\",I8,IF($AB$4=\"L-9\",J8,IF($AB$4=\"L-10\",K8,IF($AB$4=\"L-11\",L8,IF($AB$4=\"L-12\",M8,IF($AB$4=\"L-13\",N8,IF($AB$4=\"L-14\",O8,IF($AB$4=\"L-15\",P8,IF($AB$4=\"L-16\",Q8,IF($AB$4=\"L-17\",R8,IF($AB$4=\"L-18\",S8,IF($AB$4=\"L-19\",T8,IF($AB$4=\"L-20\",U8,IF($AB$4=\"L-21\",V8,IF($AB$4=\"L-22\",W8,IF($AB$4=\"L-23\",X8,IF($AB$4=\"L-24\",Y8,\"\"))))))))))))))))))))))))","v":54700}]
[3,18700,19000,19300,20400,22000,22800,23800,27900,30500,35800,40100,47000,56300,59500,64400,71400,75300,79900,84800,94300,130600,137600,154700,157900,null,47000,56300]
[4,19300,19600,19900,21000,22700,23500,24500,28700,31400,36900,41300,48400,58000,61300,66300,73500,77600,82300,87300,97100,134500,141700,159300,162600,null,48400,58000]
[5,19900,20200,20500,21600,23400,24200,25200,29600,32300,38000,42500,49900,59700,63100,68300,75700,79900,84800,89900,100000,138500,146000,164100,167500,null,49900,59700]
[6,20500,20800,21100,22200,24100,24900,26000,30500,33300,39100,43800,51400,61500,65000,70300,78000,82300,87300,92600,103000,142700,150400,169000,172500,null,51400,61500]
[7,21100,21400,21700,22900,24800,25600,26800,31400,34300,40300,45100,52900,63300,67000,72400,80300,84800,89900,95400,106100,147000,154900,174100,177700,null,52900,63300]
[8,21700,22000,22400,23600,25500,26400,27600,32300,35300,41500,46500,54500,65200,69000,74600,82700,87300,92600,98300,109300,151400,159500,179300,183000,null,54500,65200]
[9,22400,22700,23100,24300,26300,27200,28400,33300,36400,42700,47900,56100,67200,71100,76800,85200,89900,95400,101200,112600,155900,164300,184700,188500,null,56100,67200]
[10,23100,23400,23800,25000,27100,28000,29300,34300,37500,44000,49300,57800,69200,73200,79100,87800,92600,98300,104200,116000,160600,169200,190200,194200,null,57800,69200]
[11,23800,24100,24500,25800,27900,28800,30200,35300,38600,45300,50800,59500,71300,75400,81500,90400,95400,101200,107300,119500,165400,174300,195900,200000,null,59500,71300]
[12,24500,24800,25200,26600,28700,29700,31100,36400,39800,46700,52300,61300,73400,77700,83900,93100,98300,104200,110500,123100,170400,179500,201800,206000,null,61300,73400]
[13,25200,25500,26000,27400,29600,30600,32000,37500,41000,48100,53900,63100,75600,80000,86400,95900,101200,107300,113800,126800,175500,184900,207900,212200,null,63100,75600]
[14,26000,26300,26800,28200,30500,31500,33000,38600,42200,49500,55500,65000,77900,82400,89000,98800,104200,110500,117200,130600,180800,190400,214100,218600,null,65000,77900]
[15,26800,27100,27600,29000,31400,32400,34000,39800,43500,51000,57200,67000,80200,84900,91700,101800,107300,113800,120700,134500,186200,196100,null,null,null,67000,80200]
[16,27600,27900,28400,29900,32300,33400,35000,41000,44800,52500,58900,69000,82600,87400,94500,104900,110500,117200,124300,138500,191800,202000,null,null,null,69000,82600]
[17,28400,28700,29300,30800,33300,34400,36100,42200,46100,54100,60700,71100,85100,90000,97300,108000,113800,120700,128000,142700,197600,208100,null,null,null,71100,85100]
[18,29300,29600,30200,31700,34300,35400,37200,43500,47500,55700,62500,73200,87700,92700,100200,111200,117200,124300,131800,147000,203500,null,null,null,null,73200,87700]
[19,30200,30500,31100,32700,35300,36500,38300,44800,48900,57400,64400,75400,90300,95500,103200,114500,120700,128000,135800,151400,null,null,null,null,null,75400,90300]
[20,31100,31400,32000,33700,36400,37600,39400,46100,50400,59100,66300,77700,93000,98400,106300,117900,124300,131800,139900,155900,null,null,null,null,null,77700,93000]
[21,32000,32300,33000,34700,37500,38700,40600,47500,51900,60900,68300,80000,95800,101400,109500,121400,128000,135800,144100,160600,null,null,null,null,null,80000,95800]
[22,33000,33300,34000,35700,38600,39900,41800,48900,53500,62700,70300,82400,98700,104400,112800,125000,131800,139900,148400,165400,null,null,null,null,null,82400,98700]
[23,34000,34300,35000,36800,39800,41100,43100,50400,55100,64600,72400,84900,101700,107500,116200,128800,135800,144100,152900,170400,null,null,null,null,null,84900,101700]
[24,35000,35300,36100,37900,41000,42300,44400,51900,56800,66500,74600,87400,104800,110700,119700,132700,139900,148400,157500,175500,null,null,null,null,null,87400,104800]
[25,36100,36400,37200,39000,42200,43600,45700,53500,58500,68500,76800,90000,107900,114000,123300,136700,144100,152900,162200,180800,null,null,null,null,null,90000,107900]
[26,37200,37500,38300,40200,43500,44900,47100,55100,60300,70600,79100,92700,111100,117400,127000,140800,148400,157500,167100,186200,null,null,null,null,null,92700,111100]
[27,38300,38600,39400,41400,44800,46200,48500,56800,62100,72700,81500,95500,114400,120900,130800,145000,152900,162200,172100,191800,null,null,null,null,null,95500,114400]
[28,39400,39800,40600,42600,46100,47600,50000,58500,64000,74900,83900,98400,117800,124500,134700,149400,157500,167100,177300,197600,null,null,null,null,null,98400,117800]
[29,40600,41000,41800,43900,47500,49000,51500,60300,65900,77100,86400,101400,121300,128200,138700,153900,162200,172100,182600,203500,null,null,null,null,null,101400,121300]
[30,41800,42200,43100,45200,48900,50500,53000,62100,67900,79400,89000,104400,124900,132000,142900,158500,167100,177300,188100,null,null,null,null,null,null,104400,124900]
[31,43100,43500,44400,46600,50400,52000,54600,64000,69900,81800,91700,107500,128600,136000,147200,163300,172100,182600,193700,null,null,null,null,null,null,107500,128600]
[32,44400,44800,45700,48000,51900,53600,56200,65900,72000,84300,94500,110700,132500,140100,151600,168200,177300,188100,199500,null,null,null,null,null,null,110700,132500]
[33,45700,46100,47100,49400,53500,55200,57900,67900,74200,86800,97300,114000,136500,144300,156100,173200,182600,193700,null,null,null,null,null,null,null,114000,136500]
[34,47100,47500,48500,50900,55100,56900,59600,69900,76400,89400,100200,117400,140600,148600,160800,178400,188100,199500,null,null,null,null,null,null,null,117400,140600]
[35,48500,48900,50000,52400,56800,58600,61400,72000,78700,92100,103200,120900,144800,153100,165600,183800,193700,null,null,null,null,null,null,null,null,120900,144800]
[36,50000,50400,51500,54000,58500,60400,63200,74200,81100,94900,106300,124500,149100,157700,170600,189300,199500,null,null,null,null,null,null,null,null,124500,149100]
[37,51500,51900,53000,55600,60300,62200,65100,76400,83500,97700,109500,128200,153600,162400,175700,195000,null,null,null,null,null,null,null,null,null,128200,153600]
[38,53000,53500,54600,57300,62100,64100,67100,78700,86000,100600,112800,132000,158200,167300,181000,null,null,null,null,null,null,null,null,null,null,132000,158200]
[39,54600,55100,56200,59000,64000,66000,69100,81100,88600,103600,116200,136000,162900,172300,186400,null,null,null,null,null,null,null,null,null,null,136000,162900]
[40,56200,56800,57900,60800,65900,68000,71200,83500,91300,106700,119700,140100,167800,177500,192000,null,null,null,null,null,null,null,null,null,null,140100,167800]