{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["fixation on confirm_1","INTRO","MASTER","ORDER","DATA ENTRY","ARREAR","control","7th pay chart"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":2,"defined_names":61,"comments":3,"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":"fixation on confirm_1","index":0,"n_rows":51,"n_cols":50,"rows_kept":51,"cut":false,"hidden":true,"merged":[[26,7,26,9],[25,7,25,9],[4,11,4,12],[4,13,4,44],[24,7,24,9],[8,11,12,12],[6,11,7,12],[5,11,5,13],[29,1,29,5],[30,4,33,5],[30,1,34,2],[34,3,34,5],[27,0,27,10],[28,7,28,8],[0,0,0,10],[14,7,14,9],[15,7,15,9],[16,7,16,9],[17,0,17,1],[2,0,2,10],[3,0,4,10],[5,2,6,2],[5,1,6,1],[5,0,6,0],[5,10,6,10],[5,5,6,5],[5,6,5,9],[5,4,6,4],[5,3,6,3]]}
[{"$f":"N5","v":"dk;kZy; iz/kkukpk;Z jktdh; mPp ek/;fed fo|ky; 13 Mhvks,y Jhxaxkuxj"}]
[null,"dzekad",null,null,null,null,null,null,"fnukad"]
["dk;kZy; vkns'k"]
["Jheku la;qDr funs'kd ----------------------------------------------------- ds vkns'k Øekad%& --------------------------- fnukad%& ------------------------ dh vuqikyuk esa bl fo|ky; esa dk;Zjr fuEukafdr dkfeZd dk ofj\"B v/;kid ds in ij dkWye 5 esa vafdr dk;Zxzg.k djus dh fnukad ls nks o\"kZ dh ifjoh{kk/khu izf'k{k.kkFkhZ dh vof/k dks larks\"kizn :i ls iw.kZ fd;s tkus ij jktLFkku flfoy lsok ¼iqujhf{kr osrueku½ fu;e 2017 ,oa foŸk foHkkx ds uksfVfQds'ku fnukad 30-10-2017 ds fcUnq la[;k 13¼2½ ds izko/kkukuqlkj dkWye 6 esa vafdr LFkk;hdj.k frfFk ,oa fu;fer osru Ja[kyk izkfIr fnukad ls fuEukuqlkj osru fu;ru fd;k tkrk gS &"]
[null,null,null,null,null,null,null,null,null,null,null,"dk;kZy; uke fy[ksa",null,"dk;kZy; iz/kkukpk;Z jktdh; mPp ek/;fed fo|ky; 13 Mhvks,y Jhxaxkuxj"]
["dzl","uke dkfeZd","in","tUe frfFk","dk;Zxzg.k frfFk","LFkk;hdj.k frfFk@a fu;fer osru Ja[kyk izkfIr frfFk","LFkk;hdj.k i'pkr osru fu;ru",null,null,null,"vkxkeh osruo`f) frfFk","tks dkfeZd iwoZ esa lsok esa ugha jgs gS lsok esa u, fu;qDr gq, gS oks bl 'khV dk iz;ksx djsa ;fn iwoZ esa lsok esa jgs gS rks fixation on confirm _in service sheet dke esa ysos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(F9)","v":2020},7,1,{"$f":"MONTH(F9)","v":9}]
[null,null,null,null,null,null,"fnukad","is cS.M","is ysoy","ewy osru",null,"कॉलम 10 में कार्मिक की पे लेवल चुने ",null,"कार्यालय मोहर के लिए",null,null,9,"प्रथम एसीपी",null,"Existing\nR.P.Band","PB-1\n5200-20200",null,null,null,null,null,null,null,null,"PB-2\n9300-34800",null,null,null,"PB-3\n15600-39100",null,null,null,null,null,null,null,"PB-4\n37400-67000",null,null,null,null,{"$f":"YEAR(F10)","v":1900},7,1,{"$f":"MONTH(F10)","v":1}]
["1","2","3","4","5","6","8","9","10","11","12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1900,7,1,1]
[{"$f":"IF(B9=\"\",\"\",1)","v":1},"Lakhan lal","Sr. Teacher","1991-12-23","2018-09-27","2020-09-27",{"$f":"IF(F9=\"\",\"\",F9)","v":"2020-09-27"},{"$f":"IFERROR(HLOOKUP($I9,Payband,2,0)&\"-\"&HLOOKUP($I9,Payband,3,0),\"\")","v":"33800-106700"},"L_10",{"$f":"IFERROR(IF(B9=\"\",\"\",HLOOKUP($I9,Payband,2,0)),\"\")","v":33800},{"$f":"IFERROR(IF(F9=\"\",\"\",IF(F9<DATE(AU6,AV6,AW6),DATE(AU6,AV6,AW6),DATE((AU6)+1,AV6,AW6))),\"\")","v":"2021-07-01"},"white सेल में सूचना भरें",null,"iz/kkukpk;Z ",null,null,10,"प्रथम एसीपी",null,"Exist.G.P.",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,null,1900,7,1,1]
[{"$f":"IF(B10=\"\",\"\",MAX($A$9:A9)+1)","v":""},null,null,null,null,null,{"$f":"IF(F10=\"\",\"\",F10)","v":""},{"$f":"IFERROR(HLOOKUP($I10,Payband,2,0)&\"-\"&HLOOKUP($I10,Payband,3,0),\"\")","v":""},null,{"$f":"IFERROR(IF(B10=\"\",\"\",HLOOKUP($I10,Payband,2,0)),\"\")","v":""},{"$f":"IFERROR(IF(F10=\"\",\"\",IF(F10<DATE(AU7,AV7,AW7),DATE(AU7,AV7,AW7),DATE((AU7)+1,AV7,AW7))),\"\")","v":""},null,null,"jktdh; mPp ek/;fed fo|ky; ",null,null,18,"द्वितीय एसीपी ",null,"Exist.G.P.No",2,3,4,5,9,"9A","9B",10,"10A",11,12,14,15,15,16,17,18,19,20,21,22,23,"23A",24,null,null,1900,7,1,1]
[{"$f":"IF(B11=\"\",\"\",MAX($A$9:A10)+1)","v":""},null,null,null,null,null,"",{"$f":"IFERROR(HLOOKUP($I11,Payband,2,0)&\"-\"&HLOOKUP($I11,Payband,3,0),\"\")","v":""},null,{"$f":"IFERROR(IF(B11=\"\",\"\",HLOOKUP($I11,Payband,2,0)),\"\")","v":""},"",null,null,"13Mhvks,y Jhxaxkuxj ",null,null,20,"द्वितीय एसीपी ",null,"Levels →","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,null,1900,7,1,1]
[{"$f":"IF(B12=\"\",\"\",MAX($A$9:A11)+1)","v":""},null,null,null,null,null,"",{"$f":"IFERROR(HLOOKUP($I12,Payband,2,0)&\"-\"&HLOOKUP($I12,Payband,3,0),\"\")","v":""},null,{"$f":"IFERROR(IF(B12=\"\",\"\",HLOOKUP($I12,Payband,2,0)),\"\")","v":""},"",null,null,null,null,null,27,"तृतीय एसीपी ",null,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,null,1900,7,1,1]
[{"$f":"IF(B13=\"\",\"\",MAX($A$9:A12)+1)","v":""},null,null,null,null,null,"",{"$f":"IFERROR(HLOOKUP($I13,Payband,2,0)&\"-\"&HLOOKUP($I13,Payband,3,0),\"\")","v":""},null,{"$f":"IFERROR(IF(B13=\"\",\"\",HLOOKUP($I13,Payband,2,0)),\"\")","v":""},"",null,null,null,null,null,30,"तृतीय एसीपी ",null,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,null,1900,7,1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,18700,19000,19300,20400,{"$f":"MROUND(Y13*103%,100)","v":22000},{"$f":"MROUND(Z13*103%,100)","v":22800},23800,{"$f":"MROUND(AB13*103%,100)","v":27900},{"$f":"MROUND(AC13*103%,100)","v":30500},35800,40100,47000,56300,59500,64400,71400,75300,79900,84800,94300,130600,137600,154700,157900]
[null,null,null,null,null,null,null,{"$f":"N9","v":"iz/kkukpk;Z "},null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"N10","v":"jktdh; mPp ek/;fed fo|ky; "},null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"N11","v":"13Mhvks,y Jhxaxkuxj "},null,null,null,null,null,null,null,null,null,null,null,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]
["Øekad%&",null,null,null,null,null,null,null,"fnukad%&",null,null,null,null,null,null,null,null,null,null,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]
["Ikzfrfyih %&",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
["1- Jheku la;qDr funs'kd  ----------------",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
["2- Jheku~ midks\"kkf/kdkjh egksn;-----------",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
["3- lacaf/kr dkfeZd Jh ------------------------",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
["4- futh iaftdk lacaf/kr Jh ----------------------",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
["5- ys[kk 'kk[kk dk;kZy; gktk A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
["6-jf{kr iaftdk A",null,null,null,null,null,null,{"$f":"N9","v":"iz/kkukpk;Z "},null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"N10","v":"jktdh; mPp ek/;fed fo|ky; "},null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,{"$f":"N11","v":"13Mhvks,y Jhxaxkuxj "},null,null,null,null,null,null,null,null,null,null,null,16,27600,27900,28400,29900,32300,33400,35000,41000,44800,52500,58900,69000,82600,87400,94500,104900,110500,117200,124300,138500,191800,202000]
["Disclaimer: - All care has been taken to keep the information upto date and correct and is for educational purpose only. You are encouraged to consult your Accountant or Advisor before taking any decesion based on this calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,"Programmed by",null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,34000,34300,35000,36800,39800,41100,43100,50400,55100,64600,72400,84900,101700,107500,116200,128800,135800,144100,152900,170400]
[null,null,null,"joshihansraj72@gmail.com",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,40,56200,56800,57900,60800,65900,68000,71200,83500,91300,106700,119700,140100,167800,177500,192000]

{"sheet":"INTRO","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,18,0],[0,1,0,3],[1,1,1,2],[1,3,19,3],[2,1,2,2],[4,1,4,2],[13,2,17,2],[19,0,19,2]]}
[]
[null,"ALL-IN-ONE PAY FIXATION AND ARREAR CALCULATION EXCEL UTILITY 2020"]
[null,"HOW TO USE   "]
[null,null,"राजस्थान राज्य कर्मचारियों के  लिए PAY FIXATION AND ARREAR   बाबत इस UTILITY का प्रयोग किया जा सकता है । FILE को SAVE करने के लिए अपनी सुविधा से नाम देकर SAVE AS से Excel Macro- Enable Workbook के रूप में Save करें। file को open करते समय Enable Macro करें।यह excel utility केवल मात्र राज्य कार्मिको के PAY FIXATION AND ARREAR के लिए सहायतार्थ तैयार की गई है ।यद्यपि इसे तैयार करने में पूर्ण सावधानी बरती गई है फिर भी किसी भूल चूक के लिए तैयार कर्ता उत्तरदायी नहीं है । किसी भी गणना के लिए त्रुटि पाए जाने पर आयकर विभाग के नियम मान्य होंगे  किसी प्रकार की तकनीकी कमी पाए जाने पर नीचे दिये गए EMAIL द्वारा अवगत कराने का श्रम करावे।(PLEASE USE LATEST VERSION OF THAT IS  OFFICE 2010 AND ABOVE FOR BEST RESULT)"]
[null,"   1. First Enable Macro whenever open file                    "]
[null,"1. MASTER :-","MASTER SHEET में कार्मिक के वेतन निर्धारण संबन्धित सूचनाएँ जैसे नाम, पदनाम, वेतन नियतन का प्रकार ,वेतन नियतन दिनांक संबन्धित ,आदेश क्रमांक इत्यादि भरें"]
[null,"2. DATA ENTRY SHEET","DATA ENTRY SHEET में जितने माह का ARREAR देय है के माह नाम और मास्टर शीट और ORDER SHEET मे भरे डाटा अनुसार BASIC PAY ऑटोमैटिक शो होगी।यदि बेसिक मे किसी माह मे बदलाव अपेक्षित है तो EDIT BASIC PAY कॉलम मे संबन्धित माह के सम्मुख भरे। वार्षिक वेतन वृद्धि ऑटोमैटिक लग जाएगी। इस शीट मे CHECK & EDIT की सुविधा दी गई है।यदि आप NPS EMPLOYEE है तो इसी शीट मे ड्रॉपडाउन से चयन करे। DA और HRA की दर आपको संबन्धित माह के सामने लिखनी है।"]
[null,"3. ORDER  sheet","ORDER की भाषा MASTER शीट मे आप द्वारा चयन किए गए वेतन नियतन के प्रकार के आधार पर डाइनैमिक ऑटोमैटिक तैयार होगा।बाकी स्थायीकरण/एसीपी/पदोन्नति के लिए काम मे लेने के HELPING POINTS शीट मे दिये गए है"]
[null,"4. ARREAR SHEET ","ARREAR शीट मे NPS की DEDUCTION ऑटोमैटिक होगी बाकी आवश्यकतानुसार MANUALLY भरनी होगी। अनावश्यक ROW और कॉलम को HIDE करके प्रिंट निकाल सकते है।"]
[]
[null,"Disclaimer: -","All care has been taken to keep the information upto date and correct and is for educational purpose only. You are encouraged to consult your Accountant or Advisor before taking any decesion based on this calculator"]
[]
[null,null,"                                  सुधार हेतु सुझाव  आमंत्रित  है "]
[]
[]
[]
[]
[]
[null,null,"                                         joshihansraj72@gmail.com"]
[]
[]
[null,"FEATURES","1. नोशनल लाभ FIXATION और AREEAR CALCULATION सुविधा (NEW FEATURE)"]
[null,null,"2 AREEAR CALCULATION SHEET मे प्रिंट हेतु अनचाहे ROWS और COLUMN को ऑटोमैटिक HIDE, UNHIDE की सुविधा (NEW FEATURE)"]
[null,null,"3 स्थाईकरण,एसीपी,पदोन्नति और नोशनल फ़िक्सेशन की स्थिति मे एक ही प्रोग्राम से कार्यालय आदेश और ARREAR CALCULATION SHEET मे AUTO SWITCH सुविधा"]
[null,null,"4 ARREAR SHEET मे प्रारम्भिक माह मे महीने के दिनों की संख्या के अनुसार ऑटोमैटिक वेतन गणना"]
[]
[null,"UPDATE 02-02-2021","RECTIFIED ERROR -INCOME TAX COLUMN'S AMOUNT WAS NOT ADDING IN TOTAL DEDUCTION HAS BEEN RECTIFIED."]
[null,"UPDATE 21-04-2021","UPGRADED PROGRAM FROM JAN 2017 TO DEC 2021 USEABLE FOR 5 YEARS ARREAR SHEET"]

{"sheet":"MASTER","index":2,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,2,32,3],[34,2,34,3],[32,6,32,8],[1,2,1,9],[7,6,7,8],[9,5,9,7],[9,9,13,9],[11,5,11,7],[13,5,13,7],[15,5,15,7],[15,2,15,4],[26,2,26,8],[28,12,28,14],[29,12,29,14],[30,12,30,14],[28,5,28,6],[28,7,28,8],[30,2,30,8],[26,12,27,14],[17,2,17,8],[19,3,19,8],[23,3,23,8],[21,3,21,8]]}
[]
[null,"कार्यालय","प्रधानाचार्य राजकीय उच्च माध्यमिक विद्यालय 13डीओएल श्री गंगानगर "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"पदनाम","CONFIRMATION ",null,null,null,null,"CADER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PRINCIPAL","ACP ",null,null,null,null,"State Service"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"HEADMASTER","PROMOTION ",null,null,null,null,"Subordinate "]
[null,null,"NAME EMPLOYEE","RAMCHANDER SWAMI",null,"POST","HEADMASTER","CADER","State Service",null,null,null,null,"LECTURER","NOTIONAL",null,null,null,null,"Ministrial"]
[null,null,null,null,null,null,null,"Pay Leval","L_9",null,null,null,null,"SR.TEACHER",null,null,null,null,null,"Class IV"]
[null,null,"पदस्थापन स्थान","GSSS 13DOL",null,"Emp ID","RJGA99999999999",null,null,null,null,null,null,"TEACHER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PRABODHAK"]
[null,null,"वास्तविक कार्यग्रहण तिथि","2013-09-11",null,{"$f":"IF($D$12=\"\",\"Fill reason of fixation above\",\"वेतन नियतन\"&\" (\"&$D$12&\")\"&\"से पूर्व पे -लेवल \")","v":"वेतन नियतन (CONFIRMATION )से पूर्व पे -लेवल "},{"$f":"IF($D$12=\"\",\"Fill reason of fixation above\",\"वेतन नियतन\"&\" (\"&$D$12&\")\"&\"दिनांक\")","v":"वेतन नियतन (CONFIRMATION )दिनांक"},"वेतन नियतन (CONFIRMATION )दिनांक","L_11",null,null,null,null,"PTI"]
[null,null,null,"FIXATION के कारण का चयन करे",null,null,null,null,null,null,null,null,null,"LIBRARIAN"]
[null,null,"वेतन नियतन का कारण","CONFIRMATION ",null,{"$f":"IF($D$12=\"\",\"Fill reason of fixation above\",\"वेतन नियतन\"&\" (\"&$D$12&\")\"&\"से पूर्व वेतन \")","v":"वेतन नियतन (CONFIRMATION )से पूर्व वेतन "},"वेतन नियतन (CONFIRMATION )दिनांक","वेतन नियतन (CONFIRMATION )दिनांक",46500,null,null,null,null,"SENIOR ASSISTANT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"JUNIOR ASSISTANT"]
[null,null,{"$f":"IF(D12=\"NOTIONAL\",\"वास्तविक स्थाईकरण तिथि\",IF($D$12=\"\",\"Fill reason of fixation above\",\"वेतन नियतन\"&\" (\"&$D$12&\")\"&\"दिनांक\"))","v":"वेतन नियतन (CONFIRMATION )दिनांक"},"2017-01-01",null,{"$f":"IF($D$12=\"\",\"Fill reason of fixation above\",\"वेतन नियतन\"&\" (\"&$D$12&\")\"&\"से पूर्व वेतन का प्रकार\")","v":"वेतन नियतन (CONFIRMATION )से पूर्व वेतन का प्रकार"},"वेतन नियतन (CONFIRMATION )दिनांक","वेतन नियतन (CONFIRMATION )दिनांक","Regular"]
[]
[null,null,"यदि एसीपी पर वेतन नियतन किया जा रहा है तो,एसीपी का प्रकार",null,null,"NA"]
[]
[null,null,"स्थाईकरण /एसीपी/पदोन्नति आदेश संबन्धित विवरण"]
[]
[null,null,"आदेशकर्ता अधिकारी","श्रीमान संयुक्त निदेशक"]
[]
[null,null,"आदेशकर्ता कार्यालय","संयुक्त निदेशक स्कूल शिक्षा ,बीकानेर संभाग,बीकानेर "]
[]
[null,null,"आदेश क्रमांक","सनि/स्कू.शि. /2020/स्थायीकरण/1632 दिनांक 15.10.2020"]
[]
[]
[null,null,"पदोन्नति पर कार्यालय आदेश हेतु  विवरण",null,null,null,null,null,null,null,null,null,"कार्यालय मोहर के लिए"]
[]
[null,null,"पदोन्नति से पूर्व पद","SR.TEACHER",null,"पदोन्नति पश्चात  पद",null,"LECTURER",null,null,null,null,"प्रधानाचार्य "]
[null,null,null,null,null,null,null,null,null,null,null,null,"राजकीय उच्च माध्यमिक विद्यालय "]
[null,null,"नोशनल लाभ संबन्धित विवरण ",null,null,null,null,null,null,null,null,null,"13डीओएल श्रीगंगानगर "]
[]
[null,null,"माननीय न्यायालय के निर्णयानुसार नोशनल परिलाभ हेतु निर्धारित तिथि ",null,"2012-11-30",null," ORDER SHEET में  वास्तविक लाभ देय तिथि को वेतन EDIT करना चाहते है तो नीचे YES चयन कर पे लेवल व वेतन का चयन करे"]
[null,null,null,null,null,null,"NO","पे लेवल ","वेतन"]
[null,null,"माननीय न्यायालय के निर्णयानुसार नोशनल परिलाभ हेतु स्थाईकरण तिथि ",null,"2014-11-30",null,null,"L_13",54700]

{"sheet":"ORDER","index":3,"n_rows":59,"n_cols":58,"rows_kept":59,"cut":false,"hidden":false,"merged":[[37,18,37,22],[38,18,38,22],[44,18,45,22],[39,18,41,22],[42,18,43,22],[34,18,35,22],[29,18,30,22],[31,18,33,22],[6,16,6,51],[24,18,25,22],[21,18,23,22],[27,18,27,22],[28,18,28,22],[16,18,17,22],[19,18,19,22],[20,18,20,22],[7,16,7,22],[7,7,7,8],[11,18,12,22],[10,18,10,22],[13,18,15,22],[9,18,9,22],[8,18,8,22],[7,14,8,14],[12,5,12,8],[19,1,19,2],[11,16,14,17],[1,1,1,13],[3,1,3,13],[7,6,8,6],[7,9,7,12],[7,13,8,13],[8,16,9,17],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[6,1,6,13],[4,1,4,13],[5,1,5,13],[7,5,8,5]]}
[]
[null,{"$f":"MASTER!B2&\" \"&MASTER!C2","v":"कार्यालय प्रधानाचार्य राजकीय उच्च माध्यमिक विद्यालय 13डीओएल श्री गंगानगर "}]
[null,null,"dzekad",null,null,null,null,null,null,null,null,"fnukad"]
[null,"dk;kZy; vkns'k"]
[null,{"$f":"MASTER!D20&\" \"&MASTER!D22&\" के \"&MASTER!C24&\" \"&MASTER!D24&\" \"&\" की अनुपालना में\"","v":"श्रीमान संयुक्त निदेशक संयुक्त निदेशक स्कूल शिक्षा ,बीकानेर संभाग,बीकानेर  के आदेश क्रमांक सनि/स्कू.शि. /2020/स्थायीकरण/1632 दिनांक 15.10.2020  की अनुपालना में"}]
[null,{"$f":"IF(MASTER!D12=\"CONFIRMATION \",control!K2,IF(MASTER!D12=\"ACP \",control!Y3,IF(MASTER!D12=\"PROMOTION \",control!Y7,IF(MASTER!D12=\"NOTIONAL\",control!AA3,\"\"))))","v":" इस विद्यालय में कार्यरत निम्नांकित कार्मिक का कॉलम 3 में अंकित पद पर कॉलम 5 में अंकित कार्यग्रहण करने की दिनांक से दो वर्ष की परिवीक्षाधीन प्रशिक्षणार्थी की अवधि को संतोषप्रद रूप से पूर्ण किये जाने पर राजस्थान सिविल सेवा (पुनरीक्षित वेतनमान) नियम 2017 एवं वित्त विभाग के नोटिफिकेशन दिनांक 30.10.2017 के बिन्दु संख्या 13(2) के प्रावधानानुसार कॉलम 6 में अंकित स्थायीकरण तिथि एवं नियमित वेतन श्रंखला प्राप्ति दिनांक से निम्नानुसार वेतन नियतन किया जाता है-"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2021-04-21"},"DATE",{"$f":"YEAR(BB6)","v":2021},7,1]
[null,{"$f":"IF(MASTER!D12=\"ACP \",\"PAY FIXATION AFTER\"&\" \"&MASTER!D12&\"(\"&MASTER!F16&\")\",\"PAY FIXATION AFTER\"&\" \"&MASTER!D12)","v":"PAY FIXATION AFTER CONFIRMATION "}]
[null,"dzl","नाम कार्मिक ","पद ","पदस्थापन स्थान",{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",\"नोशनल लाभ तिथि\",\"कार्यग्रहण तिथि\")","v":"कार्यग्रहण तिथि"},{"$f":"IFERROR(IF(MASTER!$D$12=\"CONFIRMATION \",\"स्थायीकरण तिथि/ नियमित वेतन श्रंखला प्राप्ति तिथि\",IF(MASTER!$D$12=\"ACP \",\"एसीपी प्राप्ति तिथि \",IF(MASTER!$D$12=\"PROMOTION \",\"पदौनती प्राप्ति तिथि\",IF(MASTER!$D$12=\"NOTIONAL\",\"नोशनल स्थायीकरण तिथि/ नियमित वेतन श्रंखला प्राप्ति तिथि\",\"मास्टर शीट से चयन करे\")))),\"\")","v":"स्थायीकरण तिथि/ नियमित वेतन श्रंखला प्राप्ति तिथि"},{"$f":"IF(MASTER!$D$12=\"CONFIRMATION \",\"स्थायीकरण दिनांक से पूर्व वेतन\",IF(MASTER!$D$12=\"ACP \",\"एसीपी दिनांक से पूर्व वेतन\",IF(MASTER!$D$12=\"PROMOTION \",\"पदौनती दिनांक से पूर्व वेतन\",IF(MASTER!$D$12=\"NOTIONAL\",\"नोशनल लाभ तिथि को देय वेतन\",\"मास्टर शीट से चयन करे\"))))","v":"स्थायीकरण दिनांक से पूर्व वेतन"},null,{"$f":"IF(MASTER!$D$12=\"CONFIRMATION \",\"स्थायीकरण उपरांत वेतन नियतन\",IF(MASTER!$D$12=\"ACP \",\"एसीपी उपरांत वेतन नियतन\",IF(MASTER!$D$12=\"PROMOTION \",\"पदौनती उपरांत वेतन नियतन\",IF(MASTER!$D$12=\"NOTIONAL\",\"नोशनल स्थाईकरण उपरांत वेतन नियतन \",\"मास्टर शीट से चयन करे\"))))","v":"स्थायीकरण उपरांत वेतन नियतन"},null,{"$f":"IF(MASTER!$D$12=\"CONFIRMATION \",\"स्थायीकरण दिनांक से पूर्व वेतन\",IF(MASTER!$D$12=\"ACP \",\"एसीपी दिनांक से पूर्व वेतन\",IF(MASTER!$D$12=\"PROMOTION \",\"पदौनती दिनांक से पूर्व वेतन\",\"मास्टर शीट से चयन करे\")))","v":"स्थायीकरण दिनांक से पूर्व वेतन"},null,"आगामी वेतनवृद्धि","विशेष विवरण",null,"मास्टर शीट मे CONFIRMATION/ACP/PROMOTION का चयन करने पर आदेश ऑटोमैटिक GENERATE होगा",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(G11)","v":2017},7,1,{"$f":"MONTH(G11)","v":1}]
[null,null,null,null,null,null,null,"पे लेवल","मूल वेतन","दिनांक","पे बैण्ड","पे लेवल","मूल वेतन",null,null,null,null,null,"HELPING POINT",null,null,null,null,9,"प्रथम एसीपी",null,"Existing\nR.P.Band","PB-1\n5200-20200",null,null,null,null,null,null,null,null,"PB-2\n9300-34800",null,null,null,"PB-3\n15600-39100",null,null,null,null,null,null,null,"PB-4\n37400-67000",null,null,null,null,{"$f":"YEAR(J12)","v":2017},7,1,1]
[null,"1","2","3","4","5","6",7,8,9,10,11,12,13,14,null,null,null,"स्थाईकरण हेतु",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(J13)","v":2018},7,1,1]
[null,{"$f":"IF(C11=\"\",\"\",1)","v":1},{"$f":"'DATA ENTRY'!E4","v":"RAMCHANDER SWAMI"},{"$f":"'DATA ENTRY'!E6","v":"HEADMASTER"},{"$f":"MASTER!D8","v":"GSSS 13DOL"},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",MASTER!E33,IF(MASTER!D10=\"\",\"Fill in Master\",MASTER!D10))","v":"2013-09-11"},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",MASTER!$E$35,IF(MASTER!D14=\"\",\"Fill in Master\",MASTER!D14))","v":"2017-01-01"},{"$f":"MASTER!I10","v":"L_11"},{"$f":"MASTER!I12","v":46500},{"$f":"IF(G11=\"\",\"\",G11)","v":"2017-01-01"},{"$f":"IFERROR(HLOOKUP($L11,Payband,2,0)&\"-\"&HLOOKUP($L11,Payband,3,0),\"\")","v":"44300-140100"},"L_12",48400,{"$f":"IFERROR(IF(G11=\"\",\"\",IF(G11<DATE(BB8,BC8,BD8),DATE(BB8,BC8,BD8),DATE((BB8)+1,BC8,BD8))),\"\")","v":"2017-07-01"},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(ORDER!J11<ORDER!$G$15,\"नोशनल\",\"वास्तविक\"),\"\")","v":""},null,null,null,"1MASTER SHEET मे डाटा भरे",null,null,null,null,10,"प्रथम एसीपी",null,"Exist.G.P.",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,null,{"$f":"YEAR(G14)","v":{"$error":"#VALUE!"}},7,1,{"$error":"#VALUE!"}]
[null,{"$f":"IF(C12=\"\",\"\",MAX($B$11:B11)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(AND(J11<DATE($BD$6,$BE$6,$BF$6),N12=\"वार्षिक वेतनवृद्धि \"),N11,\"\")","v":"2017-07-01"},{"$f":"IFERROR(HLOOKUP($L12,Payband,2,0)&\"-\"&HLOOKUP($L12,Payband,3,0),\"\")","v":"44300-140100"},{"$f":"IF(J12=\"\",\"\",IF(N12=\"वार्षिक वेतनवृद्धि \",L11,\"-\"))","v":"L_12"},{"$f":"IF(J12=\"\",\"\",IF(N12=\"वार्षिक वेतनवृद्धि \",MROUND(M11*103%,100),\"\"))","v":49900},"वार्षिक वेतनवृद्धि ",{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(ORDER!J12<ORDER!$G$15,\"नोशनल\",\"वास्तविक\"),\"\")","v":""},null,"आगामी वेतनवृद्धि",null,"2. यदि आप FIX PAY प्राप्त कर रहे है तो कॉलम 11 मे आपके पद का PAY LEVAL और कॉलम 12 में न्यूनतम वेतन का चयन करे।",null,null,null,null,18,"द्वितीय एसीपी ",null,"Exist.G.P.No",2,3,4,5,9,"9A","9B",10,"10A",11,12,14,15,15,16,17,18,19,20,21,22,23,"23A",24,null,null,{"$f":"YEAR(G15)","v":{"$error":"#VALUE!"}},7,1,{"$error":"#VALUE!"}]
[null,{"$f":"IF(C13=\"\",\"\",MAX($B$11:B12)+1)","v":""},null,null,null,{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",\"वास्तविक कार्यग्रहण /स्थाईकरण तिथि अनुसार लाभ \",\"\")","v":""},null,null,null,{"$f":"IF(AND(J12<DATE(BD6,BE6,BF6),N13=\"वार्षिक वेतनवृद्धि \"),DATE(YEAR(J12)+1,7,1),\"\")","v":"2018-07-01"},{"$f":"IFERROR(HLOOKUP($L13,Payband,2,0)&\"-\"&HLOOKUP($L13,Payband,3,0),\"\")","v":"44300-140100"},{"$f":"IF(J13=\"\",\"\",IF(N13=\"वार्षिक वेतनवृद्धि \",L12,\"-\"))","v":"L_12"},{"$f":"IF(J13=\"\",\"\",IF(N13=\"वार्षिक वेतनवृद्धि \",MROUND(M12*103%,100),\"\"))","v":51400},"वार्षिक वेतनवृद्धि ",{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(ORDER!J13<ORDER!$G$15,\"नोशनल\",\"वास्तविक\"),\"\")","v":""},null,null,null,null,null,null,null,null,20,"द्वितीय एसीपी ",null,"Levels →","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,null,{"$f":"YEAR(G16)","v":1900},7,1,1]
[null,{"$f":"IF(C14=\"\",\"\",MAX($B$11:B13)+1)","v":""},null,null,null,{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",\"कार्यग्रहण तिथि\",\"\")","v":""},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",\" स्थाईकरण तिथि\",\"\")","v":""},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",\" पे -लेवल\",\"\")","v":""},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",\"वेतन\",\"\")","v":""},{"$f":"IF(AND(J13<DATE(BD6,BE6,BF6),N14=\"वार्षिक वेतनवृद्धि \"),DATE(YEAR(J13)+1,7,1),\"\")","v":"2019-07-01"},{"$f":"IFERROR(HLOOKUP($L14,Payband,2,0)&\"-\"&HLOOKUP($L14,Payband,3,0),\"\")","v":"44300-140100"},{"$f":"IF(J14=\"\",\"\",IF(N14=\"वार्षिक वेतनवृद्धि \",L13,\"-\"))","v":"L_12"},{"$f":"IF(J14=\"\",\"\",IF(N14=\"वार्षिक वेतनवृद्धि \",MROUND(M13*103%,100),\"\"))","v":52900},"वार्षिक वेतनवृद्धि ",{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(ORDER!J14<ORDER!$G$15,\"नोशनल\",\"वास्तविक\"),\"\")","v":""},null,null,null,"2. यदि आप पुराने पद का वेतन  प्राप्त कर रहे है तो कॉलम 11 मे आपके नवीन पद का PAY LEVAL और कॉलम 12 में आपके विद्यमान वेतन के समान या ठीक ऊपर वेतन का चयन करे।",null,null,null,null,27,"तृतीय एसीपी ",null,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,null,{"$f":"YEAR(G17)","v":1900},7,1,1]
[null,{"$f":"IF(C15=\"\",\"\",MAX($B$11:B14)+1)","v":""},null,null,null,{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(MASTER!$D$10=\"\",\"FILL IN MASTER\",MASTER!$D$10),\"\")","v":""},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(MASTER!$D$14=\"\",\"FILL IN MASTER\",MASTER!$D$14),\"\")","v":""},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(MASTER!$G$34=\"YES\",MASTER!H35,control!K17),\"\")","v":""},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(MASTER!$G$34=\"YES\",MASTER!I35,control!L17),\"\")","v":""},{"$f":"IF(AND(J14<DATE($BD$6,$BE$6,$BF$6),N15=\"वार्षिक वेतनवृद्धि \"),DATE(YEAR(J14)+1,7,1),\"\")","v":"2020-07-01"},{"$f":"IFERROR(HLOOKUP($L15,Payband,2,0)&\"-\"&HLOOKUP($L15,Payband,3,0),\"\")","v":"44300-140100"},{"$f":"IF(J15=\"\",\"\",IF(N15=\"वार्षिक वेतनवृद्धि \",L14,\"-\"))","v":"L_12"},{"$f":"IF(J15=\"\",\"\",IF(N15=\"वार्षिक वेतनवृद्धि \",MROUND(M14*103%,100),\"\"))","v":54500},"वार्षिक वेतनवृद्धि ",{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(ORDER!J15<ORDER!$G$15,\"नोशनल\",\"वास्तविक\"),\"\")","v":""},null,null,null,null,null,null,null,null,30,"तृतीय एसीपी ",null,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,null,{"$f":"YEAR(G18)","v":1900},7,1,1]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J15<DATE($BD$6,$BE$6,$BF$6),N16=\"वार्षिक वेतनवृद्धि \"),DATE(YEAR(J15)+1,7,1),\"\")","v":"2021-07-01"},{"$f":"IFERROR(HLOOKUP($L16,Payband,2,0)&\"-\"&HLOOKUP($L16,Payband,3,0),\"\")","v":"44300-140100"},{"$f":"IF(J16=\"\",\"\",IF(N16=\"वार्षिक वेतनवृद्धि \",L15,\"-\"))","v":"L_12"},{"$f":"IF(J16=\"\",\"\",IF(N16=\"वार्षिक वेतनवृद्धि \",MROUND(M15*103%,100),\"\"))","v":56100},"वार्षिक वेतनवृद्धि ",{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",IF(ORDER!J16<ORDER!$G$15,\"नोशनल\",\"वास्तविक\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,3,18700,19000,19300,20400,{"$f":"MROUND(AF15*103%,100)","v":22000},{"$f":"MROUND(AG15*103%,100)","v":22800},23800,{"$f":"MROUND(AI15*103%,100)","v":27900},{"$f":"MROUND(AJ15*103%,100)","v":30500},{"$f":"MROUND(AK15*103%,100)","v":35800},40100,{"$f":"MROUND(AM15*103%,100)","v":47000},{"$f":"MROUND(AN15*103%,100)","v":56300},59500,{"$f":"MROUND(AP15*103%,100)","v":64400},{"$f":"MROUND(AQ15*103%,100)","v":71400},75300,{"$f":"MROUND(AS15*103%,100)","v":79900},{"$f":"MROUND(AT15*103%,100)","v":84800},94300,{"$f":"MROUND(AV15*103%,100)","v":130600},{"$f":"MROUND(AW15*103%,100)","v":137600},154700,{"$f":"MROUND(AY15*103%,100)","v":157900}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.यदि आपकी उतरोत्तर वेतन वृद्धि बकाया है तो कॉलम 13 मे ड्रॉपडाउन से वार्षिक वेतनवृद्धि  काचयन करे आगामी वेतन वृद्धि लग जाएगी",null,null,null,null,null,null,null,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,null,null,null,null,{"$f":"MROUND(I11*1.03,100)","v":47900},null,null,null,null,{"$f":"MASTER!M29","v":"प्रधानाचार्य "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,{"$f":"SMALL('7th pay chart'!M6:M45,COUNTIF('7th pay chart'!M6:M45,\"<\"&ORDER!F18)+1)","v":48400},null,null,null,null,{"$f":"MASTER!M30","v":"राजकीय उच्च माध्यमिक विद्यालय "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"Øekad%&",null,null,null,null,null,null,null,null,{"$f":"MASTER!M31","v":"13डीओएल श्रीगंगानगर "},null,null,null,null,null,null,null,"एसीपी हेतु",null,null,null,null,null,null,null,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,"Ikzfrfyih %&",null,null,null,null,null,null,null,null,null,"fnukad%&",null,null,null,null,null,null,"1 MASTER SHEET मे डाटा भरे",null,null,null,null,null,null,null,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,1,{"$f":"MASTER!D20&\" \"&MASTER!D22","v":"श्रीमान संयुक्त निदेशक संयुक्त निदेशक स्कूल शिक्षा ,बीकानेर संभाग,बीकानेर "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.  कॉलम 11 मे आपका ACP उपरांत नवीन PAY LEVAL और कॉलम 12 में विद्यमान वेतन लेवल के वेतन मे एक वेतन वृद्धि जोड़कर जो राशि आए उसके समान या ठीक ऊपर वेतन का चयन करे। ",null,null,null,null,null,null,null,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,2,"श्रीमान् उपकोषाधिकारी महोदय...........",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,3,"संबंधित कार्मिक श्री ........................",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,4,"निजी पंजिका संबंधित श्री ......................",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.यदि आपकी उतरोत्तर वेतन वृद्धि बकाया है तो कॉलम 13 मे ड्रॉपडाउन से वार्षिक वेतनवृद्धि  काचयन करे आगामी वेतन वृद्धि लग जाएगी",null,null,null,null,null,null,null,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,5,"लेखा शाखा कार्यालय हाजा ।",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,6,"रक्षित पंजिका ।",null,null,null,null,null,null,null,{"$f":"MASTER!M29","v":"प्रधानाचार्य "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,{"$f":"MASTER!M30","v":"राजकीय उच्च माध्यमिक विद्यालय "},null,null,null,null,null,null,null,"पदोन्नति हेतु",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,{"$f":"MASTER!M31","v":"13डीओएल श्रीगंगानगर "},null,null,null,null,null,null,null,"1 MASTER SHEET मे डाटा भरे",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. यदि आपको पदोन्नति से पूर्व उस पद के लिए ACP का लाभ मिल चुका है तो  कॉलम 11 मे आपका  PAY LEVAL और कॉलम 12 में विद्यमान वेतन लेवल के वेतन के समान या ठीक ऊपर वेतन का चयन करे। ",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.  यदि आपको पदोन्नति से पूर्व उस पद के लिए ACP का लाभ नहीं मिला  है तो कॉलम 11 मे आपका नवीन पद का  PAY LEVAL और कॉलम 12 में विद्यमान वेतन लेवल के वेतन मे एक वेतन वृद्धि जोड़कर जो राशि आए उसके समान या ठीक ऊपर वेतन का चयन करे। ",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.यदि आपकी उतरोत्तर वेतन वृद्धि बकाया है तो कॉलम 13 मे ड्रॉपडाउन से वार्षिक वेतनवृद्धि  काचयन करे आगामी वेतन वृद्धि लग जाएगी",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"नोशनल लाभ  हेतु",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 MASTER SHEET मे डाटा भरे",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. यदि आपको माननीय न्यायालय के आदेशानुसार नोशनल लाभ देय है तो  कॉलम 11 मे नोशनल स्थाईकरण तिथि को वर्तमान पद का  PAY LEVAL और कॉलम 12 में विद्यमान वेतन लेवल के वेतन के समान या ठीक ऊपर वेतन का चयन करे। ",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.यदि आपकी उतरोत्तर वेतन वृद्धि बकाया है तो कॉलम 13 मे ड्रॉपडाउन से वार्षिक वेतनवृद्धि  का चयन करे आगामी वेतन वृद्धि लग जाएगी",null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LP_1","LP_2","LP_3","LP_4","LP_5","LP_6","LP_7","LP_8","LP_9","LP_10","LP_11","LP_12","LP_13","LP_14","LP_15","LP_16","LP_17","LP_18","LP_19","LP_20","LP_21","LP_22","LP_23","LP_24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12400,12600,12800,13500,14600,15100,15700,18500,20100,23700,26500,31100,null,39300,42500,47200,49700,52800,56000,62300,86200,90800,102100,104200]

{"sheet":"DATA ENTRY","index":4,"n_rows":71,"n_cols":29,"rows_kept":71,"cut":false,"hidden":false,"merged":[[5,9,5,11],[5,1,5,3],[5,4,5,6],[7,4,7,5],[1,1,1,12],[2,1,2,12],[3,1,3,3],[3,9,3,11],[3,4,3,6],[6,7,6,9],[8,2,8,11],[7,1,7,3],[9,1,10,1],[9,2,9,6],[9,8,9,12]]}
[]
[null,{"$f":"MASTER!B2&\" \"&MASTER!C2","v":"कार्यालय प्रधानाचार्य राजकीय उच्च माध्यमिक विद्यालय 13डीओएल श्री गंगानगर "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONTHS"]
[null,"Name Of Employee",null,null,{"$f":"MASTER!D6","v":"RAMCHANDER SWAMI"},null,null,null,null,"ARE YOU \"NPS\" Employee ",null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FEB"]
[null,"Post",null,null,{"$f":"MASTER!G6","v":"HEADMASTER"},null,null,null,null,"वेतन नियतन से पूर्व वेतन का प्रकार",null,null,{"$f":"MASTER!I14","v":"Regular"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAR"]
[null,null,null,null,null,null,null,"जिस दिनांक तक ARREAR बनाना यहाँ भरे",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APR"]
[null,"Type Of Areear",null,null,{"$f":"MASTER!D12&\" \"&\"ARREAR\"","v":"CONFIRMATION  ARREAR"},null,"From",{"$f":"MASTER!D14","v":"2017-01-01"},"to","2021-12-31",null,"TOTAL MONTHS",{"$f":"DATEDIF(H8,J8,\"m\")+1","v":60},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAY"]
[null,null,"{नोट:- इस शीट में एंट्री करने से पूर्व MASTER sheet और ORDER SHEET में आवश्यक पूर्तियाँ करें}",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JUN"]
[null,"SN","वेतन उठाना है(Due)",null,null,null,null,null,"वेतन उठाया गया(Drawn)",null,null,null,null,null,null,"DA RATE",null,null,null,null,null,null,null,null,null,null,null,null,"JUL"]
[null,null,"Month","Basic Pay","Edit Basic Pay","DA Rate","HRA Rate",null,"Month","Basic Pay","Edit Basic Pay","DA Rate","HRA Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AUG"]
[null,{"$f":"IF(control!A9=\"\",\"\",control!A9)","v":1},{"$f":"IFERROR(IF(control!C9=\"\",\"\",control!C9),0)","v":"Jan-17"},{"$f":"IF(MASTER!$D$12=\"NOTIONAL\",ORDER!$I$15,ORDER!$M$11)","v":48400},null,0.17,0.08,null,{"$f":"C12","v":"Jan-17"},{"$f":"MASTER!I12","v":46500},null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEP"]
[null,{"$f":"IF(control!A10=\"\",\"\",control!A10)","v":2},{"$f":"IFERROR(IF(control!C10=\"\",\"\",control!C10),0)","v":"Feb-17"},{"$f":"IF(C13=\"\",\"\",IF(LEFT(C13,3)=\"Jul\",MROUND(D12*103%,100),D12))","v":48400},null,0.17,0.08,null,{"$f":"C13","v":"Feb-17"},{"$f":"IF(I13=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I13,3)=\"Jul\"),MROUND(J12*103%,100),J12))","v":46500},null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCT"]
[null,{"$f":"IF(control!A11=\"\",\"\",control!A11)","v":3},{"$f":"IFERROR(IF(control!C11=\"\",\"\",control!C11),0)","v":"Mar-17"},{"$f":"IF(C14=\"\",\"\",IF(LEFT(C14,3)=\"Jul\",MROUND(D13*103%,100),D13))","v":48400},75700,0.17,0.08,null,{"$f":"C14","v":"Mar-17"},{"$f":"IF(I14=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I14,3)=\"Jul\"),MROUND(J13*103%,100),J13))","v":46500},null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOV"]
[null,{"$f":"IF(control!A12=\"\",\"\",control!A12)","v":4},{"$f":"IFERROR(IF(control!C12=\"\",\"\",control!C12),0)","v":"Apr-17"},48400,null,0.17,0.08,null,"Apr-17",{"$f":"IF(I15=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I15,3)=\"Jul\"),MROUND(J14*103%,100),J14))","v":46500},36900,0,0.08,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEC"]
[null,{"$f":"IF(control!A13=\"\",\"\",control!A13)","v":5},{"$f":"IFERROR(IF(control!C13=\"\",\"\",control!C13),0)","v":"May-17"},48400,null,0.17,0.08,null,"May-17",{"$f":"IF(I16=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I16,3)=\"Jul\"),MROUND(J15*103%,100),J15))","v":46500},36900,0.12,0.08]
[null,{"$f":"IF(control!A14=\"\",\"\",control!A14)","v":6},{"$f":"IFERROR(IF(control!C14=\"\",\"\",control!C14),0)","v":"Jun-17"},48400,null,0.17,0.08,null,"Jun-17",{"$f":"IF(I17=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I17,3)=\"Jul\"),MROUND(J16*103%,100),J16))","v":46500},null,0.17,0.08]
[null,{"$f":"IF(control!A15=\"\",\"\",control!A15)","v":7},{"$f":"IFERROR(IF(control!C15=\"\",\"\",control!C15),0)","v":"Jul-17"},49900,null,0.17,0.08,null,"Jul-17",{"$f":"IF(I18=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I18,3)=\"Jul\"),MROUND(J17*103%,100),J17))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A16=\"\",\"\",control!A16)","v":8},{"$f":"IFERROR(IF(control!C16=\"\",\"\",control!C16),0)","v":"Aug-17"},49900,null,0.17,0.08,null,"Aug-17",{"$f":"IF(I19=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I19,3)=\"Jul\"),MROUND(J18*103%,100),J18))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A17=\"\",\"\",control!A17)","v":9},{"$f":"IFERROR(IF(control!C17=\"\",\"\",control!C17),0)","v":"Sep-17"},49900,null,0.17,0.08,null,"Sep-17",{"$f":"IF(I20=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I20,3)=\"Jul\"),MROUND(J19*103%,100),J19))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A18=\"\",\"\",control!A18)","v":10},{"$f":"IFERROR(IF(control!C18=\"\",\"\",control!C18),0)","v":"Oct-17"},49900,null,0.17,0.08,null,"Oct-17",{"$f":"IF(I21=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I21,3)=\"Jul\"),MROUND(J20*103%,100),J20))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A19=\"\",\"\",control!A19)","v":11},{"$f":"IFERROR(IF(control!C19=\"\",\"\",control!C19),0)","v":"Nov-17"},49900,null,0.17,0.08,null,"Nov-17",{"$f":"IF(I22=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I22,3)=\"Jul\"),MROUND(J21*103%,100),J21))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A20=\"\",\"\",control!A20)","v":12},{"$f":"IFERROR(IF(control!C20=\"\",\"\",control!C20),0)","v":"Dec-17"},49900,null,0.17,0.08,null,"Dec-17",{"$f":"IF(I23=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I23,3)=\"Jul\"),MROUND(J22*103%,100),J22))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A21=\"\",\"\",control!A21)","v":13},{"$f":"IFERROR(IF(control!C21=\"\",\"\",control!C21),0)","v":"Jan-18"},49900,null,0.17,0.08,null,"Jan-18",{"$f":"IF(I24=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I24,3)=\"Jul\"),MROUND(J23*103%,100),J23))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A22=\"\",\"\",control!A22)","v":14},{"$f":"IFERROR(IF(control!C22=\"\",\"\",control!C22),0)","v":"Feb-18"},49900,null,0.17,0.08,null,"Feb-18",{"$f":"IF(I25=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I25,3)=\"Jul\"),MROUND(J24*103%,100),J24))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A23=\"\",\"\",control!A23)","v":15},{"$f":"IFERROR(IF(control!C23=\"\",\"\",control!C23),0)","v":"Mar-18"},49900,null,0.17,0.08,null,"Mar-18",{"$f":"IF(I26=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I26,3)=\"Jul\"),MROUND(J25*103%,100),J25))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A24=\"\",\"\",control!A24)","v":16},{"$f":"IFERROR(IF(control!C24=\"\",\"\",control!C24),0)","v":"Apr-18"},49900,null,0.17,0.08,null,"Apr-18",{"$f":"IF(I27=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I27,3)=\"Jul\"),MROUND(J26*103%,100),J26))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A25=\"\",\"\",control!A25)","v":17},{"$f":"IFERROR(IF(control!C25=\"\",\"\",control!C25),0)","v":"May-18"},49900,null,0.17,0.08,null,"May-18",{"$f":"IF(I28=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I28,3)=\"Jul\"),MROUND(J27*103%,100),J27))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A26=\"\",\"\",control!A26)","v":18},{"$f":"IFERROR(IF(control!C26=\"\",\"\",control!C26),0)","v":"Jun-18"},49900,null,0.17,0.08,null,"Jun-18",{"$f":"IF(I29=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I29,3)=\"Jul\"),MROUND(J28*103%,100),J28))","v":47900},null,0.17,0.08]
[null,{"$f":"IF(control!A27=\"\",\"\",control!A27)","v":19},{"$f":"IFERROR(IF(control!C27=\"\",\"\",control!C27),0)","v":"Jul-18"},51400,null,0.17,0.08,null,"Jul-18",{"$f":"IF(I30=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I30,3)=\"Jul\"),MROUND(J29*103%,100),J29))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A28=\"\",\"\",control!A28)","v":20},{"$f":"IFERROR(IF(control!C28=\"\",\"\",control!C28),0)","v":"Aug-18"},51400,null,0.17,0.08,null,"Aug-18",{"$f":"IF(I31=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I31,3)=\"Jul\"),MROUND(J30*103%,100),J30))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A29=\"\",\"\",control!A29)","v":21},{"$f":"IFERROR(IF(control!C29=\"\",\"\",control!C29),0)","v":"Sep-18"},51400,null,0.17,0.08,null,"Sep-18",{"$f":"IF(I32=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I32,3)=\"Jul\"),MROUND(J31*103%,100),J31))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A30=\"\",\"\",control!A30)","v":22},{"$f":"IFERROR(IF(control!C30=\"\",\"\",control!C30),0)","v":"Oct-18"},51400,null,0.17,0.08,null,"Oct-18",{"$f":"IF(I33=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I33,3)=\"Jul\"),MROUND(J32*103%,100),J32))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A31=\"\",\"\",control!A31)","v":23},{"$f":"IFERROR(IF(control!C31=\"\",\"\",control!C31),0)","v":"Nov-18"},51400,null,0.17,0.08,null,"Nov-18",{"$f":"IF(I34=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I34,3)=\"Jul\"),MROUND(J33*103%,100),J33))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A32=\"\",\"\",control!A32)","v":24},{"$f":"IFERROR(IF(control!C32=\"\",\"\",control!C32),0)","v":"Dec-18"},51400,null,0.17,0.08,null,"Dec-18",{"$f":"IF(I35=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I35,3)=\"Jul\"),MROUND(J34*103%,100),J34))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A33=\"\",\"\",control!A33)","v":25},{"$f":"IFERROR(IF(control!C33=\"\",\"\",control!C33),0)","v":"Jan-19"},51400,null,0.17,0.08,null,{"$f":"C36","v":"Jan-19"},{"$f":"IF(I36=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I36,3)=\"Jul\"),MROUND(J35*103%,100),J35))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A34=\"\",\"\",control!A34)","v":26},{"$f":"IFERROR(IF(control!C34=\"\",\"\",control!C34),0)","v":"Feb-19"},51400,null,0.17,0.08,null,"Feb-19",{"$f":"IF(I37=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I37,3)=\"Jul\"),MROUND(J36*103%,100),J36))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A35=\"\",\"\",control!A35)","v":27},{"$f":"IFERROR(IF(control!C35=\"\",\"\",control!C35),0)","v":"Mar-19"},51400,null,0.17,0.08,null,"Mar-19",{"$f":"IF(I38=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I38,3)=\"Jul\"),MROUND(J37*103%,100),J37))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A36=\"\",\"\",control!A36)","v":28},{"$f":"IFERROR(IF(control!C36=\"\",\"\",control!C36),0)","v":"Apr-19"},51400,null,0.17,0.08,null,"Apr-19",{"$f":"IF(I39=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I39,3)=\"Jul\"),MROUND(J38*103%,100),J38))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A37=\"\",\"\",control!A37)","v":29},{"$f":"IFERROR(IF(control!C37=\"\",\"\",control!C37),0)","v":"May-19"},51400,null,0.17,0.08,null,"May-19",{"$f":"IF(I40=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I40,3)=\"Jul\"),MROUND(J39*103%,100),J39))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A38=\"\",\"\",control!A38)","v":30},{"$f":"IFERROR(IF(control!C38=\"\",\"\",control!C38),0)","v":"Jun-19"},51400,null,0.17,0.08,null,"Jun-19",{"$f":"IF(I41=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I41,3)=\"Jul\"),MROUND(J40*103%,100),J40))","v":49300},null,0.17,0.08]
[null,{"$f":"IF(control!A39=\"\",\"\",control!A39)","v":31},{"$f":"IFERROR(IF(control!C39=\"\",\"\",control!C39),0)","v":"Jul-19"},52900,null,0.17,0.08,null,"Jul-19",{"$f":"IF(I42=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I42,3)=\"Jul\"),MROUND(J41*103%,100),J41))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A40=\"\",\"\",control!A40)","v":32},{"$f":"IFERROR(IF(control!C40=\"\",\"\",control!C40),0)","v":"Aug-19"},52900,null,0.17,0.08,null,"Aug-19",{"$f":"IF(I43=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I43,3)=\"Jul\"),MROUND(J42*103%,100),J42))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A41=\"\",\"\",control!A41)","v":33},{"$f":"IFERROR(IF(control!C41=\"\",\"\",control!C41),0)","v":"Sep-19"},52900,null,0.17,0.08,null,"Sep-19",{"$f":"IF(I44=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I44,3)=\"Jul\"),MROUND(J43*103%,100),J43))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A42=\"\",\"\",control!A42)","v":34},{"$f":"IFERROR(IF(control!C42=\"\",\"\",control!C42),0)","v":"Oct-19"},52900,null,0.17,0.08,null,"Oct-19",{"$f":"IF(I45=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I45,3)=\"Jul\"),MROUND(J44*103%,100),J44))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A43=\"\",\"\",control!A43)","v":35},{"$f":"IFERROR(IF(control!C43=\"\",\"\",control!C43),0)","v":"Nov-19"},52900,null,0.17,0.08,null,"Nov-19",{"$f":"IF(I46=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I46,3)=\"Jul\"),MROUND(J45*103%,100),J45))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A44=\"\",\"\",control!A44)","v":36},{"$f":"IFERROR(IF(control!C44=\"\",\"\",control!C44),0)","v":"Dec-19"},52900,null,0.17,0.08,null,"Dec-19",{"$f":"IF(I47=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I47,3)=\"Jul\"),MROUND(J46*103%,100),J46))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A45=\"\",\"\",control!A45)","v":37},{"$f":"IFERROR(IF(control!C45=\"\",\"\",control!C45),0)","v":"Jan-20"},{"$f":"IF(C48=\"\",\"\",IF(LEFT(C48,3)=\"Jul\",MROUND(D47*103%,100),D47))","v":52900},null,0.17,0.08,null,"Jan-20",{"$f":"IF(I48=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I48,3)=\"Jul\"),MROUND(J47*103%,100),J47))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A46=\"\",\"\",control!A46)","v":38},{"$f":"IFERROR(IF(control!C46=\"\",\"\",control!C46),0)","v":"Feb-20"},52900,null,0.17,0.08,null,"Feb-20",{"$f":"IF(I49=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I49,3)=\"Jul\"),MROUND(J48*103%,100),J48))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A47=\"\",\"\",control!A47)","v":39},{"$f":"IFERROR(IF(control!C47=\"\",\"\",control!C47),0)","v":"Mar-20"},52900,null,0.17,0.08,null,"Mar-20",{"$f":"IF(I50=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I50,3)=\"Jul\"),MROUND(J49*103%,100),J49))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A48=\"\",\"\",control!A48)","v":40},{"$f":"IFERROR(IF(control!C48=\"\",\"\",control!C48),0)","v":"Apr-20"},52900,null,0.17,0.08,null,"Apr-20",{"$f":"IF(I51=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I51,3)=\"Jul\"),MROUND(J50*103%,100),J50))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A49=\"\",\"\",control!A49)","v":41},{"$f":"IFERROR(IF(control!C49=\"\",\"\",control!C49),0)","v":"May-20"},52900,null,0.17,0.08,null,"May-20",{"$f":"IF(I52=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I52,3)=\"Jul\"),MROUND(J51*103%,100),J51))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A50=\"\",\"\",control!A50)","v":42},{"$f":"IFERROR(IF(control!C50=\"\",\"\",control!C50),0)","v":"Jun-20"},52900,null,0.17,0.08,null,"Jun-20",{"$f":"IF(I53=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I53,3)=\"Jul\"),MROUND(J52*103%,100),J52))","v":50800},null,0.17,0.08]
[null,{"$f":"IF(control!A51=\"\",\"\",control!A51)","v":43},{"$f":"IFERROR(IF(control!C51=\"\",\"\",control!C51),0)","v":"Jul-20"},54500,null,0.17,0.08,null,"Jul-20",{"$f":"IF(I54=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I54,3)=\"Jul\"),MROUND(J53*103%,100),J53))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A52=\"\",\"\",control!A52)","v":44},{"$f":"IFERROR(IF(control!C52=\"\",\"\",control!C52),0)","v":"Aug-20"},54500,null,0.17,0.08,null,"Aug-20",{"$f":"IF(I55=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I55,3)=\"Jul\"),MROUND(J54*103%,100),J54))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A53=\"\",\"\",control!A53)","v":45},{"$f":"IFERROR(IF(control!C53=\"\",\"\",control!C53),0)","v":"Sep-20"},54500,null,0.17,0.08,null,"Sep-20",{"$f":"IF(I56=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I56,3)=\"Jul\"),MROUND(J55*103%,100),J55))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A54=\"\",\"\",control!A54)","v":46},{"$f":"IFERROR(IF(control!C54=\"\",\"\",control!C54),0)","v":"Oct-20"},{"$f":"IF(C57=\"\",\"\",IF(LEFT(C57,3)=\"Jul\",MROUND(D56*103%,100),D56))","v":54500},null,0.17,0.08,null,"Oct-20",{"$f":"IF(I57=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I57,3)=\"Jul\"),MROUND(J56*103%,100),J56))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A55=\"\",\"\",control!A55)","v":47},{"$f":"IFERROR(IF(control!C55=\"\",\"\",control!C55),0)","v":"Nov-20"},54500,null,0.17,0.08,null,"Nov-20",{"$f":"IF(I58=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I58,3)=\"Jul\"),MROUND(J57*103%,100),J57))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A56=\"\",\"\",control!A56)","v":48},{"$f":"IFERROR(IF(control!C56=\"\",\"\",control!C56),0)","v":"Dec-20"},54500,null,0.17,0.08,null,"Dec-20",{"$f":"IF(I59=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I59,3)=\"Jul\"),MROUND(J58*103%,100),J58))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A57=\"\",\"\",control!A57)","v":49},{"$f":"IFERROR(IF(control!C57=\"\",\"\",control!C57),0)","v":"Jan-21"},{"$f":"IF(C60=\"\",\"\",IF(LEFT(C60,3)=\"Jul\",MROUND(D59*103%,100),D59))","v":54500},null,0.17,0.08,null,{"$f":"C60","v":"Jan-21"},{"$f":"IF(I60=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I60,3)=\"Jul\"),MROUND(J59*103%,100),J59))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A58=\"\",\"\",control!A58)","v":50},{"$f":"IFERROR(IF(control!C58=\"\",\"\",control!C58),0)","v":"Feb-21"},54500,null,0.17,0.08,null,"Feb-21",{"$f":"IF(I61=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I61,3)=\"Jul\"),MROUND(J60*103%,100),J60))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A59=\"\",\"\",control!A59)","v":51},{"$f":"IFERROR(IF(control!C59=\"\",\"\",control!C59),0)","v":"Mar-21"},54500,null,0.17,0.08,null,"Mar-21",{"$f":"IF(I62=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I62,3)=\"Jul\"),MROUND(J61*103%,100),J61))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A60=\"\",\"\",control!A60)","v":52},{"$f":"IFERROR(IF(control!C60=\"\",\"\",control!C60),0)","v":"Apr-21"},54500,null,0.17,0.08,null,"Apr-21",{"$f":"IF(I63=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I63,3)=\"Jul\"),MROUND(J62*103%,100),J62))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A61=\"\",\"\",control!A61)","v":53},{"$f":"IFERROR(IF(control!C61=\"\",\"\",control!C61),0)","v":"May-21"},54500,null,0.17,0.08,null,"May-21",{"$f":"IF(I64=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I64,3)=\"Jul\"),MROUND(J63*103%,100),J63))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A62=\"\",\"\",control!A62)","v":54},{"$f":"IFERROR(IF(control!C62=\"\",\"\",control!C62),0)","v":"Jun-21"},54500,null,0.17,0.08,null,"Jun-21",{"$f":"IF(I65=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I65,3)=\"Jul\"),MROUND(J64*103%,100),J64))","v":52300},null,0.17,0.08]
[null,{"$f":"IF(control!A63=\"\",\"\",control!A63)","v":55},{"$f":"IFERROR(IF(control!C63=\"\",\"\",control!C63),0)","v":"Jul-21"},56100,null,0.17,0.08,null,"Jul-21",{"$f":"IF(I66=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I66,3)=\"Jul\"),MROUND(J65*103%,100),J65))","v":53900},null,0.17,0.08]
[null,{"$f":"IF(control!A64=\"\",\"\",control!A64)","v":56},{"$f":"IFERROR(IF(control!C64=\"\",\"\",control!C64),0)","v":"Aug-21"},56100,null,0.17,0.08,null,"Aug-21",{"$f":"IF(I67=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I67,3)=\"Jul\"),MROUND(J66*103%,100),J66))","v":53900},null,0.17,0.08]
[null,{"$f":"IF(control!A65=\"\",\"\",control!A65)","v":57},{"$f":"IFERROR(IF(control!C65=\"\",\"\",control!C65),0)","v":"Sep-21"},56100,null,0.17,0.08,null,"Sep-21",{"$f":"IF(I68=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I68,3)=\"Jul\"),MROUND(J67*103%,100),J67))","v":53900},null,0.17,0.08]
[null,{"$f":"IF(control!A66=\"\",\"\",control!A66)","v":58},{"$f":"IFERROR(IF(control!C66=\"\",\"\",control!C66),0)","v":"Oct-21"},56100,null,0.17,0.08,null,"Oct-21",{"$f":"IF(I69=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I69,3)=\"Jul\"),MROUND(J68*103%,100),J68))","v":53900},null,0.17,0.08]
[null,{"$f":"IF(control!A67=\"\",\"\",control!A67)","v":59},{"$f":"IFERROR(IF(control!C67=\"\",\"\",control!C67),0)","v":"Nov-21"},56100,null,0.17,0.08,null,"Nov-21",{"$f":"IF(I70=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I70,3)=\"Jul\"),MROUND(J69*103%,100),J69))","v":53900},null,0.17,0.08]
[null,{"$f":"IF(control!A68=\"\",\"\",control!A68)","v":60},{"$f":"IFERROR(IF(control!C68=\"\",\"\",control!C68),0)","v":"Dec-21"},56100,null,0.17,0.08,null,"Dec-21",{"$f":"IF(I71=\"\",\"\",IF(AND(MASTER!$I$14=\"Regular\",LEFT(I71,3)=\"Jul\"),MROUND(J70*103%,100),J70))","v":53900},null,0.17,0.08]

{"sheet":"ARREAR","index":5,"n_rows":74,"n_cols":35,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,1,1,34],[2,1,2,34],[3,2,3,3],[3,4,3,7],[3,31,3,33],[3,12,3,14],[5,15,5,29],[5,31,7,31],[5,32,7,32],[5,33,7,33],[5,34,7,34],[6,24,6,26],[6,27,6,29],[6,21,6,23],[5,7,5,10],[5,11,5,14],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[6,12,7,12],[73,29,73,32],[71,29,71,32],[72,29,72,32],[6,13,7,13],[68,1,68,2],[6,14,7,14],[6,15,6,17],[6,18,6,20],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[6,7,7,7],[5,1,7,1],[5,2,7,2],[5,3,5,6]]}
[]
[null,{"$f":"ORDER!B2","v":"कार्यालय प्रधानाचार्य राजकीय उच्च माध्यमिक विद्यालय 13डीओएल श्री गंगानगर "}]
[null,{"$f":"'DATA ENTRY'!E8&\" \" &\"FROM\"&\"  \"&TEXT('DATA ENTRY'!H8,\"Mmmm-yyyy\")&\"  \"&\"TO\"&\"  \"&TEXT('DATA ENTRY'!J8,\"mmmm-yyyy\")","v":"CONFIRMATION  ARREAR FROM  January-2017  TO  December-2021"}]
[null,null,"NAME",null,{"$f":"'DATA ENTRY'!E4","v":"RAMCHANDER SWAMI"},null,null,null,null,null,null,"POST",{"$f":"'DATA ENTRY'!E6","v":"HEADMASTER"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Emp ID",{"$f":"MASTER!G8","v":"RJGA99999999999"}]
[]
[null,"S.No.","Month","To Be Drawn",null,null,null,"Alread Drawn",null,null,null,"Difference",null,null,null,"Deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Deductions","Net Amount","omitted bill no","TV no/date"]
[null,null,null,"Basic","DA","HRA","Total","Basic","DA","HRA","Total","Basic","DA","HRA","Total","NPS",null,null,"GPF",null,null,"SI",null,null,"RPMF",null,null,"CM CORONA RELIEF FUND",null,null,"I.TAX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Due","Drawn","Diff","Due","Drawn","Diff","Due","Drawn","Diff","Due","Drawn","Diff","Due","Drawn","Diff"]
[{"$f":"IF(D9=\"\",\"v\",\"\")","v":""},{"$f":"IF(control!A9=\"\",\"\",control!A9)","v":1},{"$f":"IF(control!C9=\"\",\"\",control!C9)","v":"Jan-17"},{"$f":"IF(C9=\"March-20\",control!E9/2,control!E9)","v":48400},{"$f":"IFERROR(ROUND(D9*'DATA ENTRY'!F12,0),0)","v":8228},{"$f":"IFERROR(ROUND(D9*'DATA ENTRY'!G12,0),0)","v":3872},{"$f":"IFERROR(D9+E9+F9,0)","v":60500},{"$f":"control!G9","v":46500},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H9*'DATA ENTRY'!L12,0)),0)","v":0},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H9*'DATA ENTRY'!M12,0)),0)","v":0},{"$f":"IFERROR(H9+I9+J9,0)","v":46500},{"$f":"IFERROR(D9-H9,0)","v":1900},{"$f":"IFERROR(E9-I9,0)","v":8228},{"$f":"IFERROR(F9-J9,0)","v":3872},{"$f":"IFERROR(L9+M9+N9,0)","v":14000},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D9+ARREAR!E9)*10%,0),0),0)","v":5663},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H9+ARREAR!I9)*10%,0),0),0)","v":4650},{"$f":"IFERROR(P9-Q9,0)","v":1013},null,null,{"$f":"IFERROR(S9-T9,0)","v":0},null,null,{"$f":"IFERROR(V9-W9,0)","v":0},null,null,{"$f":"IFERROR(Y9-Z9,0)","v":0},null,null,{"$f":"IFERROR(AB9-AC9,0)","v":0},100,{"$f":"R9+U9+X9+AA9+AD9+AE9","v":1113},{"$f":"O9-AF9","v":12887}]
[{"$f":"IF(D10=\"\",\"v\",\"\")","v":""},{"$f":"IF(control!A10=\"\",\"\",control!A10)","v":2},{"$f":"IF(control!C10=\"\",\"\",control!C10)","v":"Feb-17"},{"$f":"IF(C10=\"March-20\",control!E10/2,control!E10)","v":48400},{"$f":"IFERROR(ROUND(D10*'DATA ENTRY'!F13,0),0)","v":8228},{"$f":"IFERROR(ROUND(D10*'DATA ENTRY'!G13,0),0)","v":3872},{"$f":"IFERROR(D10+E10+F10,0)","v":60500},{"$f":"control!G10","v":46500},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H10*'DATA ENTRY'!L13,0)),0)","v":0},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H10*'DATA ENTRY'!M13,0)),0)","v":0},{"$f":"IFERROR(H10+I10+J10,0)","v":46500},{"$f":"IFERROR(D10-H10,0)","v":1900},8228,3872,{"$f":"IFERROR(L10+M10+N10,0)","v":14000},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D10+ARREAR!E10)*10%,0),0),0)","v":5663},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H10+ARREAR!I10)*10%,0),0),0)","v":4650},{"$f":"IFERROR(P10-Q10,0)","v":1013},null,null,{"$f":"IFERROR(S10-T10,0)","v":0},null,null,{"$f":"IFERROR(V10-W10,0)","v":0},null,null,{"$f":"IFERROR(Y10-Z10,0)","v":0},null,null,{"$f":"IFERROR(AB10-AC10,0)","v":0},null,{"$f":"R10+U10+X10+AA10+AD10+AE10","v":1013},{"$f":"O10-AF10","v":12987}]
["",{"$f":"IF(control!A11=\"\",\"\",control!A11)","v":3},{"$f":"IF(control!C11=\"\",\"\",control!C11)","v":"Mar-17"},{"$f":"IF(C11=\"Mar-20\",control!E11/2,control!E11)","v":75700},{"$f":"IFERROR(ROUND(D11*'DATA ENTRY'!F14,0),0)","v":12869},{"$f":"IFERROR(ROUND(D11*'DATA ENTRY'!G14,0),0)","v":6056},94625,{"$f":"control!G11","v":46500},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H11*'DATA ENTRY'!L14,0)),0)","v":0},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H11*'DATA ENTRY'!M14,0)),0)","v":0},46500,29200,12869,6056,48125,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D11+ARREAR!E11)*10%,0),0),0)","v":8857},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H11+ARREAR!I11)*10%,0),0),0)","v":4650},{"$f":"IFERROR(P11-Q11,0)","v":4207},null,null,0,null,null,0,null,null,{"$f":"IFERROR(Y11-Z11,0)","v":0},null,null,0,null,4207,43918]
["",{"$f":"IF(control!A12=\"\",\"\",control!A12)","v":4},{"$f":"IF(control!C12=\"\",\"\",control!C12)","v":"Apr-17"},{"$f":"IF(C12=\"March-20\",control!E12/2,control!E12)","v":48400},{"$f":"IFERROR(ROUND(D12*'DATA ENTRY'!F15,0),0)","v":8228},{"$f":"IFERROR(ROUND(D12*'DATA ENTRY'!G15,0),0)","v":3872},60500,{"$f":"control!G12","v":36900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H12*'DATA ENTRY'!L15,0)),0)","v":0},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H12*'DATA ENTRY'!M15,0)),0)","v":2952},39852,11500,8228,920,20648,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D12+ARREAR!E12)*10%,0),0),0)","v":5663},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H12+ARREAR!I12)*10%,0),0),0)","v":3690},1973,null,null,0,null,null,0,null,null,0,null,null,0,null,1973,18675]
["",{"$f":"IF(control!A13=\"\",\"\",control!A13)","v":5},{"$f":"IF(control!C13=\"\",\"\",control!C13)","v":"May-17"},{"$f":"IF(C13=\"March-20\",control!E13/2,control!E13)","v":48400},{"$f":"IFERROR(ROUND(D13*'DATA ENTRY'!F16,0),0)","v":8228},{"$f":"IFERROR(ROUND(D13*'DATA ENTRY'!G16,0),0)","v":3872},60500,{"$f":"control!G13","v":36900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H13*'DATA ENTRY'!L16,0)),0)","v":4428},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H13*'DATA ENTRY'!M16,0)),0)","v":2952},44280,11500,3800,920,16220,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D13+ARREAR!E13)*10%,0),0),0)","v":5663},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H13+ARREAR!I13)*10%,0),0),0)","v":4133},1530,null,null,0,null,null,0,null,null,0,null,null,0,null,1530,14690]
[{"$f":"IF(D14=\"\",\"v\",\"\")","v":""},{"$f":"IF(control!A14=\"\",\"\",control!A14)","v":6},{"$f":"IF(control!C14=\"\",\"\",control!C14)","v":"Jun-17"},{"$f":"IF(C14=\"March-20\",control!E14/2,control!E14)","v":48400},{"$f":"IFERROR(ROUND(D14*'DATA ENTRY'!F17,0),0)","v":8228},{"$f":"IFERROR(ROUND(D14*'DATA ENTRY'!G17,0),0)","v":3872},60500,{"$f":"control!G14","v":46500},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H14*'DATA ENTRY'!L17,0)),0)","v":7905},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H14*'DATA ENTRY'!M17,0)),0)","v":3720},58125,1900,323,152,2375,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D14+ARREAR!E14)*10%,0),0),0)","v":5663},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H14+ARREAR!I14)*10%,0),0),0)","v":5441},222,null,null,0,null,null,0,null,null,0,null,null,0,null,222,2153]
[{"$f":"IF(D15=\"\",\"v\",\"\")","v":""},{"$f":"IF(control!A15=\"\",\"\",control!A15)","v":7},{"$f":"IF(control!C15=\"\",\"\",control!C15)","v":"Jul-17"},{"$f":"control!E15","v":49900},{"$f":"IFERROR(ROUND(D15*'DATA ENTRY'!F18,0),0)","v":8483},{"$f":"IFERROR(ROUND(D15*'DATA ENTRY'!G18,0),0)","v":3992},62375,{"$f":"control!G15","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H15*'DATA ENTRY'!L18,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H15*'DATA ENTRY'!M18,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D15+ARREAR!E15)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H15+ARREAR!I15)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A16=\"\",\"\",control!A16)","v":8},{"$f":"IF(control!C16=\"\",\"\",control!C16)","v":"Aug-17"},{"$f":"control!E16","v":49900},{"$f":"IFERROR(ROUND(D16*'DATA ENTRY'!F19,0),0)","v":8483},{"$f":"IFERROR(ROUND(D16*'DATA ENTRY'!G19,0),0)","v":3992},62375,{"$f":"control!G16","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H16*'DATA ENTRY'!L19,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H16*'DATA ENTRY'!M19,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D16+ARREAR!E16)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H16+ARREAR!I16)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A17=\"\",\"\",control!A17)","v":9},{"$f":"IF(control!C17=\"\",\"\",control!C17)","v":"Sep-17"},{"$f":"control!E17","v":49900},{"$f":"IFERROR(ROUND(D17*'DATA ENTRY'!F20,0),0)","v":8483},{"$f":"IFERROR(ROUND(D17*'DATA ENTRY'!G20,0),0)","v":3992},62375,{"$f":"control!G17","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H17*'DATA ENTRY'!L20,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H17*'DATA ENTRY'!M20,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D17+ARREAR!E17)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H17+ARREAR!I17)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A18=\"\",\"\",control!A18)","v":10},{"$f":"IF(control!C18=\"\",\"\",control!C18)","v":"Oct-17"},{"$f":"control!E18","v":49900},{"$f":"IFERROR(ROUND(D18*'DATA ENTRY'!F21,0),0)","v":8483},{"$f":"IFERROR(ROUND(D18*'DATA ENTRY'!G21,0),0)","v":3992},62375,{"$f":"control!G18","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H18*'DATA ENTRY'!L21,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H18*'DATA ENTRY'!M21,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D18+ARREAR!E18)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H18+ARREAR!I18)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A19=\"\",\"\",control!A19)","v":11},{"$f":"IF(control!C19=\"\",\"\",control!C19)","v":"Nov-17"},{"$f":"control!E19","v":49900},{"$f":"IFERROR(ROUND(D19*'DATA ENTRY'!F22,0),0)","v":8483},{"$f":"IFERROR(ROUND(D19*'DATA ENTRY'!G22,0),0)","v":3992},62375,{"$f":"control!G19","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H19*'DATA ENTRY'!L22,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H19*'DATA ENTRY'!M22,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D19+ARREAR!E19)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H19+ARREAR!I19)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A20=\"\",\"\",control!A20)","v":12},{"$f":"IF(control!C20=\"\",\"\",control!C20)","v":"Dec-17"},{"$f":"control!E20","v":49900},{"$f":"IFERROR(ROUND(D20*'DATA ENTRY'!F23,0),0)","v":8483},{"$f":"IFERROR(ROUND(D20*'DATA ENTRY'!G23,0),0)","v":3992},62375,{"$f":"control!G20","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H20*'DATA ENTRY'!L23,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H20*'DATA ENTRY'!M23,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D20+ARREAR!E20)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H20+ARREAR!I20)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A21=\"\",\"\",control!A21)","v":13},{"$f":"IF(control!C21=\"\",\"\",control!C21)","v":"Jan-18"},{"$f":"control!E21","v":49900},{"$f":"IFERROR(ROUND(D21*'DATA ENTRY'!F24,0),0)","v":8483},{"$f":"IFERROR(ROUND(D21*'DATA ENTRY'!G24,0),0)","v":3992},62375,{"$f":"control!G21","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H21*'DATA ENTRY'!L24,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H21*'DATA ENTRY'!M24,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D21+ARREAR!E21)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H21+ARREAR!I21)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A22=\"\",\"\",control!A22)","v":14},{"$f":"IF(control!C22=\"\",\"\",control!C22)","v":"Feb-18"},{"$f":"control!E22","v":49900},{"$f":"IFERROR(ROUND(D22*'DATA ENTRY'!F25,0),0)","v":8483},{"$f":"IFERROR(ROUND(D22*'DATA ENTRY'!G25,0),0)","v":3992},62375,{"$f":"control!G22","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H22*'DATA ENTRY'!L25,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H22*'DATA ENTRY'!M25,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D22+ARREAR!E22)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H22+ARREAR!I22)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A23=\"\",\"\",control!A23)","v":15},{"$f":"IF(control!C23=\"\",\"\",control!C23)","v":"Mar-18"},{"$f":"control!E23","v":49900},{"$f":"IFERROR(ROUND(D23*'DATA ENTRY'!F26,0),0)","v":8483},{"$f":"IFERROR(ROUND(D23*'DATA ENTRY'!G26,0),0)","v":3992},62375,{"$f":"control!G23","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H23*'DATA ENTRY'!L26,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H23*'DATA ENTRY'!M26,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D23+ARREAR!E23)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H23+ARREAR!I23)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A24=\"\",\"\",control!A24)","v":16},{"$f":"IF(control!C24=\"\",\"\",control!C24)","v":"Apr-18"},{"$f":"control!E24","v":49900},{"$f":"IFERROR(ROUND(D24*'DATA ENTRY'!F27,0),0)","v":8483},{"$f":"IFERROR(ROUND(D24*'DATA ENTRY'!G27,0),0)","v":3992},62375,{"$f":"control!G24","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H24*'DATA ENTRY'!L27,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H24*'DATA ENTRY'!M27,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D24+ARREAR!E24)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H24+ARREAR!I24)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A25=\"\",\"\",control!A25)","v":17},{"$f":"IF(control!C25=\"\",\"\",control!C25)","v":"May-18"},{"$f":"control!E25","v":49900},{"$f":"IFERROR(ROUND(D25*'DATA ENTRY'!F28,0),0)","v":8483},{"$f":"IFERROR(ROUND(D25*'DATA ENTRY'!G28,0),0)","v":3992},62375,{"$f":"control!G25","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H25*'DATA ENTRY'!L28,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H25*'DATA ENTRY'!M28,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D25+ARREAR!E25)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H25+ARREAR!I25)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A26=\"\",\"\",control!A26)","v":18},{"$f":"IF(control!C26=\"\",\"\",control!C26)","v":"Jun-18"},{"$f":"control!E26","v":49900},{"$f":"IFERROR(ROUND(D26*'DATA ENTRY'!F29,0),0)","v":8483},{"$f":"IFERROR(ROUND(D26*'DATA ENTRY'!G29,0),0)","v":3992},62375,{"$f":"control!G26","v":47900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H26*'DATA ENTRY'!L29,0)),0)","v":8143},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H26*'DATA ENTRY'!M29,0)),0)","v":3832},59875,2000,340,160,2500,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D26+ARREAR!E26)*10%,0),0),0)","v":5838},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H26+ARREAR!I26)*10%,0),0),0)","v":5604},234,null,null,0,null,null,0,null,null,0,null,null,0,null,234,2266]
["",{"$f":"IF(control!A27=\"\",\"\",control!A27)","v":19},{"$f":"IF(control!C27=\"\",\"\",control!C27)","v":"Jul-18"},{"$f":"control!E27","v":51400},{"$f":"IFERROR(ROUND(D27*'DATA ENTRY'!F30,0),0)","v":8738},{"$f":"IFERROR(ROUND(D27*'DATA ENTRY'!G30,0),0)","v":4112},64250,{"$f":"control!G27","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H27*'DATA ENTRY'!L30,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H27*'DATA ENTRY'!M30,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D27+ARREAR!E27)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H27+ARREAR!I27)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A28=\"\",\"\",control!A28)","v":20},{"$f":"IF(control!C28=\"\",\"\",control!C28)","v":"Aug-18"},{"$f":"control!E28","v":51400},{"$f":"IFERROR(ROUND(D28*'DATA ENTRY'!F31,0),0)","v":8738},{"$f":"IFERROR(ROUND(D28*'DATA ENTRY'!G31,0),0)","v":4112},64250,{"$f":"control!G28","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H28*'DATA ENTRY'!L31,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H28*'DATA ENTRY'!M31,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D28+ARREAR!E28)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H28+ARREAR!I28)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A29=\"\",\"\",control!A29)","v":21},{"$f":"IF(control!C29=\"\",\"\",control!C29)","v":"Sep-18"},{"$f":"control!E29","v":51400},{"$f":"IFERROR(ROUND(D29*'DATA ENTRY'!F32,0),0)","v":8738},{"$f":"IFERROR(ROUND(D29*'DATA ENTRY'!G32,0),0)","v":4112},64250,{"$f":"control!G29","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H29*'DATA ENTRY'!L32,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H29*'DATA ENTRY'!M32,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D29+ARREAR!E29)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H29+ARREAR!I29)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A30=\"\",\"\",control!A30)","v":22},{"$f":"IF(control!C30=\"\",\"\",control!C30)","v":"Oct-18"},{"$f":"control!E30","v":51400},{"$f":"IFERROR(ROUND(D30*'DATA ENTRY'!F33,0),0)","v":8738},{"$f":"IFERROR(ROUND(D30*'DATA ENTRY'!G33,0),0)","v":4112},64250,{"$f":"control!G30","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H30*'DATA ENTRY'!L33,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H30*'DATA ENTRY'!M33,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D30+ARREAR!E30)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H30+ARREAR!I30)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A31=\"\",\"\",control!A31)","v":23},{"$f":"IF(control!C31=\"\",\"\",control!C31)","v":"Nov-18"},{"$f":"control!E31","v":51400},{"$f":"IFERROR(ROUND(D31*'DATA ENTRY'!F34,0),0)","v":8738},{"$f":"IFERROR(ROUND(D31*'DATA ENTRY'!G34,0),0)","v":4112},64250,{"$f":"control!G31","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H31*'DATA ENTRY'!L34,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H31*'DATA ENTRY'!M34,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D31+ARREAR!E31)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H31+ARREAR!I31)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A32=\"\",\"\",control!A32)","v":24},{"$f":"IF(control!C32=\"\",\"\",control!C32)","v":"Dec-18"},{"$f":"control!E32","v":51400},{"$f":"IFERROR(ROUND(D32*'DATA ENTRY'!F35,0),0)","v":8738},{"$f":"IFERROR(ROUND(D32*'DATA ENTRY'!G35,0),0)","v":4112},64250,{"$f":"control!G32","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H32*'DATA ENTRY'!L35,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H32*'DATA ENTRY'!M35,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D32+ARREAR!E32)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H32+ARREAR!I32)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A33=\"\",\"\",control!A33)","v":25},{"$f":"IF(control!C33=\"\",\"\",control!C33)","v":"Jan-19"},{"$f":"control!E33","v":51400},{"$f":"IFERROR(ROUND(D33*'DATA ENTRY'!F36,0),0)","v":8738},{"$f":"IFERROR(ROUND(D33*'DATA ENTRY'!G36,0),0)","v":4112},{"$f":"IFERROR(D33+E33+F33,0)","v":64250},{"$f":"control!G33","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H33*'DATA ENTRY'!L36,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H33*'DATA ENTRY'!M36,0)),0)","v":3944},{"$f":"IFERROR(H33+I33+J33,0)","v":61625},{"$f":"IFERROR(D33-H33,0)","v":2100},{"$f":"IFERROR(E33-I33,0)","v":357},{"$f":"IFERROR(F33-J33,0)","v":168},{"$f":"IFERROR(L33+M33+N33,0)","v":2625},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D33+ARREAR!E33)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H33+ARREAR!I33)*10%,0),0),0)","v":5768},{"$f":"IFERROR(P33-Q33,0)","v":246},null,null,{"$f":"IFERROR(S33-T33,0)","v":0},null,null,{"$f":"IFERROR(V33-W33,0)","v":0},null,null,{"$f":"IFERROR(Y33-Z33,0)","v":0},null,null,{"$f":"IFERROR(AB33-AC33,0)","v":0},null,246,{"$f":"O33-AF33","v":2379}]
["",{"$f":"IF(control!A34=\"\",\"\",control!A34)","v":26},{"$f":"IF(control!C34=\"\",\"\",control!C34)","v":"Feb-19"},{"$f":"control!E34","v":51400},{"$f":"IFERROR(ROUND(D34*'DATA ENTRY'!F37,0),0)","v":8738},{"$f":"IFERROR(ROUND(D34*'DATA ENTRY'!G37,0),0)","v":4112},64250,{"$f":"control!G34","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H34*'DATA ENTRY'!L37,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H34*'DATA ENTRY'!M37,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D34+ARREAR!E34)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H34+ARREAR!I34)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A35=\"\",\"\",control!A35)","v":27},{"$f":"IF(control!C35=\"\",\"\",control!C35)","v":"Mar-19"},{"$f":"control!E35","v":51400},{"$f":"IFERROR(ROUND(D35*'DATA ENTRY'!F38,0),0)","v":8738},{"$f":"IFERROR(ROUND(D35*'DATA ENTRY'!G38,0),0)","v":4112},64250,{"$f":"control!G35","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H35*'DATA ENTRY'!L38,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H35*'DATA ENTRY'!M38,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D35+ARREAR!E35)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H35+ARREAR!I35)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A36=\"\",\"\",control!A36)","v":28},{"$f":"IF(control!C36=\"\",\"\",control!C36)","v":"Apr-19"},{"$f":"control!E36","v":51400},{"$f":"IFERROR(ROUND(D36*'DATA ENTRY'!F39,0),0)","v":8738},{"$f":"IFERROR(ROUND(D36*'DATA ENTRY'!G39,0),0)","v":4112},64250,{"$f":"control!G36","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H36*'DATA ENTRY'!L39,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H36*'DATA ENTRY'!M39,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D36+ARREAR!E36)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H36+ARREAR!I36)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A37=\"\",\"\",control!A37)","v":29},{"$f":"IF(control!C37=\"\",\"\",control!C37)","v":"May-19"},{"$f":"control!E37","v":51400},{"$f":"IFERROR(ROUND(D37*'DATA ENTRY'!F40,0),0)","v":8738},{"$f":"IFERROR(ROUND(D37*'DATA ENTRY'!G40,0),0)","v":4112},64250,{"$f":"control!G37","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H37*'DATA ENTRY'!L40,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H37*'DATA ENTRY'!M40,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D37+ARREAR!E37)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H37+ARREAR!I37)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A38=\"\",\"\",control!A38)","v":30},{"$f":"IF(control!C38=\"\",\"\",control!C38)","v":"Jun-19"},{"$f":"control!E38","v":51400},{"$f":"IFERROR(ROUND(D38*'DATA ENTRY'!F41,0),0)","v":8738},{"$f":"IFERROR(ROUND(D38*'DATA ENTRY'!G41,0),0)","v":4112},64250,{"$f":"control!G38","v":49300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H38*'DATA ENTRY'!L41,0)),0)","v":8381},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H38*'DATA ENTRY'!M41,0)),0)","v":3944},61625,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D38+ARREAR!E38)*10%,0),0),0)","v":6014},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H38+ARREAR!I38)*10%,0),0),0)","v":5768},246,null,null,0,null,null,0,null,null,0,null,null,0,null,246,2379]
["",{"$f":"IF(control!A39=\"\",\"\",control!A39)","v":31},{"$f":"IF(control!C39=\"\",\"\",control!C39)","v":"Jul-19"},{"$f":"control!E39","v":52900},{"$f":"IFERROR(ROUND(D39*'DATA ENTRY'!F42,0),0)","v":8993},{"$f":"IFERROR(ROUND(D39*'DATA ENTRY'!G42,0),0)","v":4232},66125,{"$f":"control!G39","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H39*'DATA ENTRY'!L42,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H39*'DATA ENTRY'!M42,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D39+ARREAR!E39)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H39+ARREAR!I39)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A40=\"\",\"\",control!A40)","v":32},{"$f":"IF(control!C40=\"\",\"\",control!C40)","v":"Aug-19"},{"$f":"control!E40","v":52900},{"$f":"IFERROR(ROUND(D40*'DATA ENTRY'!F43,0),0)","v":8993},{"$f":"IFERROR(ROUND(D40*'DATA ENTRY'!G43,0),0)","v":4232},66125,{"$f":"control!G40","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H40*'DATA ENTRY'!L43,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H40*'DATA ENTRY'!M43,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D40+ARREAR!E40)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H40+ARREAR!I40)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A41=\"\",\"\",control!A41)","v":33},{"$f":"IF(control!C41=\"\",\"\",control!C41)","v":"Sep-19"},{"$f":"control!E41","v":52900},{"$f":"IFERROR(ROUND(D41*'DATA ENTRY'!F44,0),0)","v":8993},{"$f":"IFERROR(ROUND(D41*'DATA ENTRY'!G44,0),0)","v":4232},66125,{"$f":"control!G41","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H41*'DATA ENTRY'!L44,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H41*'DATA ENTRY'!M44,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D41+ARREAR!E41)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H41+ARREAR!I41)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A42=\"\",\"\",control!A42)","v":34},{"$f":"IF(control!C42=\"\",\"\",control!C42)","v":"Oct-19"},{"$f":"control!E42","v":52900},{"$f":"IFERROR(ROUND(D42*'DATA ENTRY'!F45,0),0)","v":8993},{"$f":"IFERROR(ROUND(D42*'DATA ENTRY'!G45,0),0)","v":4232},66125,{"$f":"control!G42","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H42*'DATA ENTRY'!L45,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H42*'DATA ENTRY'!M45,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D42+ARREAR!E42)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H42+ARREAR!I42)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A43=\"\",\"\",control!A43)","v":35},{"$f":"IF(control!C43=\"\",\"\",control!C43)","v":"Nov-19"},{"$f":"control!E43","v":52900},{"$f":"IFERROR(ROUND(D43*'DATA ENTRY'!F46,0),0)","v":8993},{"$f":"IFERROR(ROUND(D43*'DATA ENTRY'!G46,0),0)","v":4232},66125,{"$f":"control!G43","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H43*'DATA ENTRY'!L46,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H43*'DATA ENTRY'!M46,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D43+ARREAR!E43)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H43+ARREAR!I43)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A44=\"\",\"\",control!A44)","v":36},{"$f":"IF(control!C44=\"\",\"\",control!C44)","v":"Dec-19"},{"$f":"control!E44","v":52900},{"$f":"IFERROR(ROUND(D44*'DATA ENTRY'!F47,0),0)","v":8993},{"$f":"IFERROR(ROUND(D44*'DATA ENTRY'!G47,0),0)","v":4232},{"$f":"IFERROR(D44+E44+F44,0)","v":66125},{"$f":"control!G44","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H44*'DATA ENTRY'!L47,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H44*'DATA ENTRY'!M47,0)),0)","v":4064},{"$f":"IFERROR(H44+I44+J44,0)","v":63500},{"$f":"IFERROR(D44-H44,0)","v":2100},{"$f":"IFERROR(E44-I44,0)","v":357},{"$f":"IFERROR(F44-J44,0)","v":168},{"$f":"IFERROR(L44+M44+N44,0)","v":2625},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D44+ARREAR!E44)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H44+ARREAR!I44)*10%,0),0),0)","v":5944},{"$f":"IFERROR(P44-Q44,0)","v":245},null,null,{"$f":"IFERROR(S44-T44,0)","v":0},null,null,{"$f":"IFERROR(V44-W44,0)","v":0},null,null,{"$f":"IFERROR(Y44-Z44,0)","v":0},null,null,{"$f":"IFERROR(AB44-AC44,0)","v":0},null,245,{"$f":"O44-AF44","v":2380}]
["",{"$f":"IF(control!A45=\"\",\"\",control!A45)","v":37},{"$f":"IF(control!C45=\"\",\"\",control!C45)","v":"Jan-20"},{"$f":"control!E45","v":52900},{"$f":"IFERROR(ROUND(D45*'DATA ENTRY'!F48,0),0)","v":8993},{"$f":"IFERROR(ROUND(D45*'DATA ENTRY'!G48,0),0)","v":4232},{"$f":"IFERROR(D45+E45+F45,0)","v":66125},{"$f":"control!G45","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H45*'DATA ENTRY'!L48,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H45*'DATA ENTRY'!M48,0)),0)","v":4064},{"$f":"IFERROR(H45+I45+J45,0)","v":63500},{"$f":"IFERROR(D45-H45,0)","v":2100},{"$f":"IFERROR(E45-I45,0)","v":357},{"$f":"IFERROR(F45-J45,0)","v":168},{"$f":"IFERROR(L45+M45+N45,0)","v":2625},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D45+ARREAR!E45)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H45+ARREAR!I45)*10%,0),0),0)","v":5944},{"$f":"IFERROR(P45-Q45,0)","v":245},null,null,{"$f":"IFERROR(S45-T45,0)","v":0},null,null,{"$f":"IFERROR(V45-W45,0)","v":0},null,null,{"$f":"IFERROR(Y45-Z45,0)","v":0},null,null,{"$f":"IFERROR(AB45-AC45,0)","v":0},null,245,{"$f":"O45-AF45","v":2380}]
["",{"$f":"IF(control!A46=\"\",\"\",control!A46)","v":38},{"$f":"IF(control!C46=\"\",\"\",control!C46)","v":"Feb-20"},{"$f":"control!E46","v":52900},{"$f":"IFERROR(ROUND(D46*'DATA ENTRY'!F49,0),0)","v":8993},{"$f":"IFERROR(ROUND(D46*'DATA ENTRY'!G49,0),0)","v":4232},66125,{"$f":"control!G46","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H46*'DATA ENTRY'!L49,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H46*'DATA ENTRY'!M49,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D46+ARREAR!E46)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H46+ARREAR!I46)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A47=\"\",\"\",control!A47)","v":39},{"$f":"IF(control!C47=\"\",\"\",control!C47)","v":"Mar-20"},{"$f":"control!E47","v":52900},{"$f":"IFERROR(ROUND(D47*'DATA ENTRY'!F50,0),0)","v":8993},{"$f":"IFERROR(ROUND(D47*'DATA ENTRY'!G50,0),0)","v":4232},66125,{"$f":"control!G47","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H47*'DATA ENTRY'!L50,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H47*'DATA ENTRY'!M50,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D47+ARREAR!E47)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H47+ARREAR!I47)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A48=\"\",\"\",control!A48)","v":40},{"$f":"IF(control!C48=\"\",\"\",control!C48)","v":"Apr-20"},{"$f":"control!E48","v":52900},{"$f":"IFERROR(ROUND(D48*'DATA ENTRY'!F51,0),0)","v":8993},{"$f":"IFERROR(ROUND(D48*'DATA ENTRY'!G51,0),0)","v":4232},66125,{"$f":"control!G48","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H48*'DATA ENTRY'!L51,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H48*'DATA ENTRY'!M51,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D48+ARREAR!E48)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H48+ARREAR!I48)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A49=\"\",\"\",control!A49)","v":41},{"$f":"IF(control!C49=\"\",\"\",control!C49)","v":"May-20"},{"$f":"control!E49","v":52900},{"$f":"IFERROR(ROUND(D49*'DATA ENTRY'!F52,0),0)","v":8993},{"$f":"IFERROR(ROUND(D49*'DATA ENTRY'!G52,0),0)","v":4232},66125,{"$f":"control!G49","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H49*'DATA ENTRY'!L52,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H49*'DATA ENTRY'!M52,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D49+ARREAR!E49)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H49+ARREAR!I49)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A50=\"\",\"\",control!A50)","v":42},{"$f":"IF(control!C50=\"\",\"\",control!C50)","v":"Jun-20"},{"$f":"control!E50","v":52900},{"$f":"IFERROR(ROUND(D50*'DATA ENTRY'!F53,0),0)","v":8993},{"$f":"IFERROR(ROUND(D50*'DATA ENTRY'!G53,0),0)","v":4232},66125,{"$f":"control!G50","v":50800},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H50*'DATA ENTRY'!L53,0)),0)","v":8636},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H50*'DATA ENTRY'!M53,0)),0)","v":4064},63500,2100,357,168,2625,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D50+ARREAR!E50)*10%,0),0),0)","v":6189},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H50+ARREAR!I50)*10%,0),0),0)","v":5944},245,null,null,0,null,null,0,null,null,0,null,null,0,null,245,2380]
["",{"$f":"IF(control!A51=\"\",\"\",control!A51)","v":43},{"$f":"IF(control!C51=\"\",\"\",control!C51)","v":"Jul-20"},{"$f":"control!E51","v":54500},{"$f":"IFERROR(ROUND(D51*'DATA ENTRY'!F54,0),0)","v":9265},{"$f":"IFERROR(ROUND(D51*'DATA ENTRY'!G54,0),0)","v":4360},68125,{"$f":"control!G51","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H51*'DATA ENTRY'!L54,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H51*'DATA ENTRY'!M54,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D51+ARREAR!E51)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H51+ARREAR!I51)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A52=\"\",\"\",control!A52)","v":44},{"$f":"IF(control!C52=\"\",\"\",control!C52)","v":"Aug-20"},{"$f":"control!E52","v":54500},{"$f":"IFERROR(ROUND(D52*'DATA ENTRY'!F55,0),0)","v":9265},{"$f":"IFERROR(ROUND(D52*'DATA ENTRY'!G55,0),0)","v":4360},68125,{"$f":"control!G52","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H52*'DATA ENTRY'!L55,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H52*'DATA ENTRY'!M55,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D52+ARREAR!E52)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H52+ARREAR!I52)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A53=\"\",\"\",control!A53)","v":45},{"$f":"IF(control!C53=\"\",\"\",control!C53)","v":"Sep-20"},{"$f":"control!E53","v":54500},{"$f":"IFERROR(ROUND(D53*'DATA ENTRY'!F56,0),0)","v":9265},{"$f":"IFERROR(ROUND(D53*'DATA ENTRY'!G56,0),0)","v":4360},68125,{"$f":"control!G53","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H53*'DATA ENTRY'!L56,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H53*'DATA ENTRY'!M56,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D53+ARREAR!E53)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H53+ARREAR!I53)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A54=\"\",\"\",control!A54)","v":46},{"$f":"IF(control!C54=\"\",\"\",control!C54)","v":"Oct-20"},{"$f":"control!E54","v":54500},{"$f":"IFERROR(ROUND(D54*'DATA ENTRY'!F57,0),0)","v":9265},{"$f":"IFERROR(ROUND(D54*'DATA ENTRY'!G57,0),0)","v":4360},68125,{"$f":"control!G54","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H54*'DATA ENTRY'!L57,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H54*'DATA ENTRY'!M57,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D54+ARREAR!E54)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H54+ARREAR!I54)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A55=\"\",\"\",control!A55)","v":47},{"$f":"IF(control!C55=\"\",\"\",control!C55)","v":"Nov-20"},{"$f":"control!E55","v":54500},{"$f":"IFERROR(ROUND(D55*'DATA ENTRY'!F58,0),0)","v":9265},{"$f":"IFERROR(ROUND(D55*'DATA ENTRY'!G58,0),0)","v":4360},68125,{"$f":"control!G55","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H55*'DATA ENTRY'!L58,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H55*'DATA ENTRY'!M58,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D55+ARREAR!E55)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H55+ARREAR!I55)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A56=\"\",\"\",control!A56)","v":48},{"$f":"IF(control!C56=\"\",\"\",control!C56)","v":"Dec-20"},{"$f":"control!E56","v":54500},{"$f":"IFERROR(ROUND(D56*'DATA ENTRY'!F59,0),0)","v":9265},{"$f":"IFERROR(ROUND(D56*'DATA ENTRY'!G59,0),0)","v":4360},68125,{"$f":"control!G56","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H56*'DATA ENTRY'!L59,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H56*'DATA ENTRY'!M59,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D56+ARREAR!E56)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H56+ARREAR!I56)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A57=\"\",\"\",control!A57)","v":49},{"$f":"IF(control!C57=\"\",\"\",control!C57)","v":"Jan-21"},{"$f":"control!E57","v":54500},{"$f":"IFERROR(ROUND(D57*'DATA ENTRY'!F60,0),0)","v":9265},{"$f":"IFERROR(ROUND(D57*'DATA ENTRY'!G60,0),0)","v":4360},{"$f":"IFERROR(D57+E57+F57,0)","v":68125},{"$f":"control!G57","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H57*'DATA ENTRY'!L60,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H57*'DATA ENTRY'!M60,0)),0)","v":4184},{"$f":"IFERROR(H57+I57+J57,0)","v":65375},{"$f":"IFERROR(D57-H57,0)","v":2200},{"$f":"IFERROR(E57-I57,0)","v":374},{"$f":"IFERROR(F57-J57,0)","v":176},{"$f":"IFERROR(L57+M57+N57,0)","v":2750},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D57+ARREAR!E57)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H57+ARREAR!I57)*10%,0),0),0)","v":6119},{"$f":"IFERROR(P57-Q57,0)","v":258},null,null,{"$f":"IFERROR(S57-T57,0)","v":0},null,null,{"$f":"IFERROR(V57-W57,0)","v":0},null,null,{"$f":"IFERROR(Y57-Z57,0)","v":0},null,null,{"$f":"IFERROR(AB57-AC57,0)","v":0},null,{"$f":"R57+U57+X57+AA57+AD57+AE57","v":258},{"$f":"O57-AF57","v":2492}]
["",{"$f":"IF(control!A58=\"\",\"\",control!A58)","v":50},{"$f":"IF(control!C58=\"\",\"\",control!C58)","v":"Feb-21"},{"$f":"control!E58","v":54500},{"$f":"IFERROR(ROUND(D58*'DATA ENTRY'!F61,0),0)","v":9265},{"$f":"IFERROR(ROUND(D58*'DATA ENTRY'!G61,0),0)","v":4360},68125,{"$f":"control!G58","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H58*'DATA ENTRY'!L61,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H58*'DATA ENTRY'!M61,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D58+ARREAR!E58)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H58+ARREAR!I58)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A59=\"\",\"\",control!A59)","v":51},{"$f":"IF(control!C59=\"\",\"\",control!C59)","v":"Mar-21"},{"$f":"control!E59","v":54500},{"$f":"IFERROR(ROUND(D59*'DATA ENTRY'!F62,0),0)","v":9265},{"$f":"IFERROR(ROUND(D59*'DATA ENTRY'!G62,0),0)","v":4360},68125,{"$f":"control!G59","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H59*'DATA ENTRY'!L62,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H59*'DATA ENTRY'!M62,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D59+ARREAR!E59)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H59+ARREAR!I59)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A60=\"\",\"\",control!A60)","v":52},{"$f":"IF(control!C60=\"\",\"\",control!C60)","v":"Apr-21"},{"$f":"control!E60","v":54500},{"$f":"IFERROR(ROUND(D60*'DATA ENTRY'!F63,0),0)","v":9265},{"$f":"IFERROR(ROUND(D60*'DATA ENTRY'!G63,0),0)","v":4360},68125,{"$f":"control!G60","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H60*'DATA ENTRY'!L63,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H60*'DATA ENTRY'!M63,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D60+ARREAR!E60)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H60+ARREAR!I60)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A61=\"\",\"\",control!A61)","v":53},{"$f":"IF(control!C61=\"\",\"\",control!C61)","v":"May-21"},{"$f":"control!E61","v":54500},{"$f":"IFERROR(ROUND(D61*'DATA ENTRY'!F64,0),0)","v":9265},{"$f":"IFERROR(ROUND(D61*'DATA ENTRY'!G64,0),0)","v":4360},68125,{"$f":"control!G61","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H61*'DATA ENTRY'!L64,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H61*'DATA ENTRY'!M64,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D61+ARREAR!E61)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H61+ARREAR!I61)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A62=\"\",\"\",control!A62)","v":54},{"$f":"IF(control!C62=\"\",\"\",control!C62)","v":"Jun-21"},{"$f":"control!E62","v":54500},{"$f":"IFERROR(ROUND(D62*'DATA ENTRY'!F65,0),0)","v":9265},{"$f":"IFERROR(ROUND(D62*'DATA ENTRY'!G65,0),0)","v":4360},68125,{"$f":"control!G62","v":52300},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H62*'DATA ENTRY'!L65,0)),0)","v":8891},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H62*'DATA ENTRY'!M65,0)),0)","v":4184},65375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D62+ARREAR!E62)*10%,0),0),0)","v":6377},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H62+ARREAR!I62)*10%,0),0),0)","v":6119},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A63=\"\",\"\",control!A63)","v":55},{"$f":"IF(control!C63=\"\",\"\",control!C63)","v":"Jul-21"},{"$f":"control!E63","v":56100},{"$f":"IFERROR(ROUND(D63*'DATA ENTRY'!F66,0),0)","v":9537},{"$f":"IFERROR(ROUND(D63*'DATA ENTRY'!G66,0),0)","v":4488},70125,{"$f":"control!G63","v":53900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H63*'DATA ENTRY'!L66,0)),0)","v":9163},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H63*'DATA ENTRY'!M66,0)),0)","v":4312},67375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D63+ARREAR!E63)*10%,0),0),0)","v":6564},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H63+ARREAR!I63)*10%,0),0),0)","v":6306},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A64=\"\",\"\",control!A64)","v":56},{"$f":"IF(control!C64=\"\",\"\",control!C64)","v":"Aug-21"},{"$f":"control!E64","v":56100},{"$f":"IFERROR(ROUND(D64*'DATA ENTRY'!F67,0),0)","v":9537},{"$f":"IFERROR(ROUND(D64*'DATA ENTRY'!G67,0),0)","v":4488},70125,{"$f":"control!G64","v":53900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H64*'DATA ENTRY'!L67,0)),0)","v":9163},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H64*'DATA ENTRY'!M67,0)),0)","v":4312},67375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D64+ARREAR!E64)*10%,0),0),0)","v":6564},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H64+ARREAR!I64)*10%,0),0),0)","v":6306},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A65=\"\",\"\",control!A65)","v":57},{"$f":"IF(control!C65=\"\",\"\",control!C65)","v":"Sep-21"},{"$f":"control!E65","v":56100},{"$f":"IFERROR(ROUND(D65*'DATA ENTRY'!F68,0),0)","v":9537},{"$f":"IFERROR(ROUND(D65*'DATA ENTRY'!G68,0),0)","v":4488},70125,{"$f":"control!G65","v":53900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H65*'DATA ENTRY'!L68,0)),0)","v":9163},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H65*'DATA ENTRY'!M68,0)),0)","v":4312},67375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D65+ARREAR!E65)*10%,0),0),0)","v":6564},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H65+ARREAR!I65)*10%,0),0),0)","v":6306},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A66=\"\",\"\",control!A66)","v":58},{"$f":"IF(control!C66=\"\",\"\",control!C66)","v":"Oct-21"},{"$f":"control!E66","v":56100},{"$f":"IFERROR(ROUND(D66*'DATA ENTRY'!F69,0),0)","v":9537},{"$f":"IFERROR(ROUND(D66*'DATA ENTRY'!G69,0),0)","v":4488},70125,{"$f":"control!G66","v":53900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H66*'DATA ENTRY'!L69,0)),0)","v":9163},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H66*'DATA ENTRY'!M69,0)),0)","v":4312},67375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D66+ARREAR!E66)*10%,0),0),0)","v":6564},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H66+ARREAR!I66)*10%,0),0),0)","v":6306},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A67=\"\",\"\",control!A67)","v":59},{"$f":"IF(control!C67=\"\",\"\",control!C67)","v":"Nov-21"},{"$f":"control!E67","v":56100},{"$f":"IFERROR(ROUND(D67*'DATA ENTRY'!F70,0),0)","v":9537},{"$f":"IFERROR(ROUND(D67*'DATA ENTRY'!G70,0),0)","v":4488},70125,{"$f":"control!G67","v":53900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H67*'DATA ENTRY'!L70,0)),0)","v":9163},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H67*'DATA ENTRY'!M70,0)),0)","v":4312},67375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D67+ARREAR!E67)*10%,0),0),0)","v":6564},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H67+ARREAR!I67)*10%,0),0),0)","v":6306},258,null,null,0,null,null,0,null,null,0,null,null,0,null,258,2492]
["",{"$f":"IF(control!A68=\"\",\"\",control!A68)","v":60},{"$f":"IF(control!C68=\"\",\"\",control!C68)","v":"Dec-21"},{"$f":"control!E68","v":56100},{"$f":"IFERROR(ROUND(D68*'DATA ENTRY'!F71,0),0)","v":9537},{"$f":"IFERROR(ROUND(D68*'DATA ENTRY'!G71,0),0)","v":4488},70125,{"$f":"control!G68","v":53900},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H68*'DATA ENTRY'!L71,0)),0)","v":9163},{"$f":"IFERROR(IF(MASTER!$I$14=\"Fix Pay\",0,ROUND(H68*'DATA ENTRY'!M71,0)),0)","v":4312},67375,2200,374,176,2750,{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!D68+ARREAR!E68)*10%,0),0),0)","v":6564},{"$f":"IFERROR(IF('DATA ENTRY'!$M$4=\"YES\",ROUND((ARREAR!H68+ARREAR!I68)*10%,0),0),0)","v":6306},258,null,null,0,null,null,0,null,null,0,null,null,null,null,258,2492]
[null,"TOTAL",null,{"$f":"SUM(D9:D68)","v":3158700},{"$f":"SUM(E9:E68)","v":536979},252696,3948375,2986800,475923,227784,3690507,171900,61056,24912,257868,369572,346270,23302,0,0,0,0,0,0,0,0,0,0,0,0,100,23402,234466,0,0]
[]
[null,null,null,null,"अक्षरे रूपये",null,{"$f":"[2]!SpellNumber(AG69)","v":"Rupees Two Lakh ThirtyFour Thousand Four Hundred SixtySix Only "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MASTER!M29","v":"प्रधानाचार्य "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MASTER!M30","v":"राजकीय उच्च माध्यमिक विद्यालय "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MASTER!M31","v":"13डीओएल श्रीगंगानगर "}]

{"sheet":"control","index":6,"n_rows":68,"n_cols":27,"rows_kept":68,"cut":false,"hidden":true,"merged":[[6,1,6,2],[6,23,9,23],[2,23,5,23],[3,5,4,6],[6,3,6,4],[6,5,6,6],[1,10,5,22],[1,9,5,9]]}
[null,null,"MASTER"]
[null,"CADER",{"$f":"MASTER!I6","v":"State Service"},null,"pay leval",{"$f":"RIGHT(MASTER!I7,2)","v":"_9"},null,null,null,"CONFIRMATION ORDER"," इस विद्यालय में कार्यरत निम्नांकित कार्मिक का कॉलम 3 में अंकित पद पर कॉलम 5 में अंकित कार्यग्रहण करने की दिनांक से दो वर्ष की परिवीक्षाधीन प्रशिक्षणार्थी की अवधि को संतोषप्रद रूप से पूर्ण किये जाने पर राजस्थान सिविल सेवा (पुनरीक्षित वेतनमान) नियम 2017 एवं वित्त विभाग के नोटिफिकेशन दिनांक 30.10.2017 के बिन्दु संख्या 13(2) के प्रावधानानुसार कॉलम 6 में अंकित स्थायीकरण तिथि एवं नियमित वेतन श्रंखला प्राप्ति दिनांक से निम्नानुसार वेतन नियतन किया जाता है-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACP","राजस्थान सरकार वित्त विभाग के आदेशांक F15(1)/FD@Rules/2017 जयपुर दिनांक 30.10.2017 के अनुसार में राजस्थान सिविल सेवा (पुनरीक्षित वेतनमान) नियम, 2017 द्वितीय संषोधन के नियम 14 एवं 15 के तहत  इस विद्यालय के निम्नांकित कार्मिक का उनके नाम के सम्मुख अंकित तिथि से  ए0 सी0 पी0 ( Assured Career Progression ) की स्वीकृति प्रदान किये जाने के फलस्वरूप निम्नानुसार वेतन निर्धारण किया जाता हैः-","notional","माननीय उच्च न्यायालय जोधपुर/जयपुर के निर्णयानुसार तृतीय श्रेणी प्राथमिक ओर उच्च प्राथमिक विद्यालय अध्यापक भर्ती 2013 के अन्तर्गत संशोधित एवं पुनः संशोधित परिणाम से चयनोपरान्त शिक्षकों को नोशनल परिलाभ हेतु पारित निर्णय के पालनार्थ श्रीमान वरिष्ठ विधि परामर्शी प्रारम्भिक शिक्षा (विधि प्रकोष्ठ) राजस्थान जयपुर के पत्रांक प.18(279) प्रा.शि/वि.प्र./18/जयपुर दिनांक 20.11.2018 की अनुपालना में  इस कार्यालय के निम्नांकित  कार्मिक के वास्तविक प्रथम कार्यग्रहण तिथि को माननीय न्यायालय के निर्णयानुसार नोशनल/वरिष्ठता परिलाभ हेतु निर्धारित तिथि (प्रथम परिणाम नियुक्त शिक्षको की कार्यग्रहण तिथि)  से नोशनल परिलाभ हेतु स्थायीकरण तिथि करने एवं वास्तविक कार्यग्रहण तिथि से दो वर्ष परिविक्षाकाल पूर्ण होने पर स्थाईकरण  किये जाने पर निम्नानुसार वेतन निर्धारण किया जाता है:-\""]
[null,"FROM",{"$f":"'DATA ENTRY'!H8","v":"2017-01-01"},"TO",{"$f":"'DATA ENTRY'!J8","v":"2021-12-31"},"TOTAL DAYS OF STARTING MONTH",null,{"$f":"DAY(EOMONTH(C4,0))","v":31}]
[null,"EOMONTH",{"$f":"EOMONTH(C4,0)","v":"2017-01-31"},null,null,null,null,null,"2020-03-01"]
[null,"DAYS",{"$f":"DATEDIF(C4,C5,\"D\")+1","v":31},null,{"$f":"ROUND($D$9/$H$4*$C$6,0)","v":48400},null,{"$f":"ROUND(F9/H4*C6,0)","v":46500},null,{"$f":"TEXT(I5,\"mmm\"&\"-\"&\"yy\")","v":"Mar-20"}]
[null,"MONTH",null,"DUE",null,"DRWAN",null,null,{"$f":"VLOOKUP($I$6,$C$9:$E56,3,0)","v":52900},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"इस विद्यालय में कार्यरत निम्नांकित कार्मिक का\" &\"  \"&MASTER!D29&\" से \"&MASTER!H29&\" पद पर पदोन्नति होने पर निम्नानुसार वेतन नियतन किया जाता है।\")","v":"इस विद्यालय में कार्यरत निम्नांकित कार्मिक का  SR.TEACHER से LECTURER पद पर पदोन्नति होने पर निम्नानुसार वेतन नियतन किया जाता है।"}]
[null,null,null,"BASIC","EDIT BASIC","BASIC","EDIT BASIC",null,null,null,"ROUND($D$9/$H$4*$C$6,0)"]
[{"$f":"IF(B9=\"\",\"\",1)","v":1},{"$f":"IF(C4=\"\",\"\",DATE(YEAR(C4),MONTH(C4),DAY(C4)))","v":"2017-01-01"},{"$f":"TEXT(B9,\"mmm\"&\"-\"&\"YY\")","v":"Jan-17"},{"$f":"'DATA ENTRY'!D12","v":48400},{"$f":"IF('DATA ENTRY'!C12=\"\",\"\",ROUND(IF('DATA ENTRY'!E12=\"\",'DATA ENTRY'!D12,'DATA ENTRY'!E12)/$H$4*$C$6,0))","v":48400},{"$f":"'DATA ENTRY'!J12","v":46500},{"$f":"IF('DATA ENTRY'!I12=\"\",\"\",ROUND(IF('DATA ENTRY'!K12=\"\",'DATA ENTRY'!J12,'DATA ENTRY'!K12)/$H$4*$C$6,0))","v":46500},null,{"$f":"IF(OR($C$2=\"All India Services\",$C$2=\"State Service\"),ROUND(I7/31*5,0),IF(AND($C$2=\"Subordinate\",$Z$18>9),ROUND(I7/31*3,0),IF(AND($C$2=\"Subordinate\",OR(F2>4,F2<10)),ROUND(I7/31*2,0),IF($C$2=\"Ministrial\",ROUND(I7/31*2,0),IF(OR($C$2=\"Class IV\",$F$2<5),ROUND(I7/31*1,0))))))","v":8532},null,null,null,null,"NOTIONAL FITMENT"]
[{"$f":"IF(B10=\"\",\"\",A9+1)","v":2},{"$f":"IF(B9=\"\",\"\",IF(EOMONTH(B9,0)+1>$E$4,\"\",EOMONTH(B9,0)+1))","v":"2017-02-01"},{"$f":"TEXT(B10,\"mmm\"&\"-\"&\"YY\")","v":"Feb-17"},{"$f":"'DATA ENTRY'!D13","v":48400},{"$f":"IF('DATA ENTRY'!C13=\"\",\"\",IF('DATA ENTRY'!E13=\"\",'DATA ENTRY'!D13,'DATA ENTRY'!E13))","v":48400},{"$f":"'DATA ENTRY'!J13","v":46500},{"$f":"IF('DATA ENTRY'!I13=\"\",\"\",IF('DATA ENTRY'!K13=\"\",'DATA ENTRY'!J13,'DATA ENTRY'!K13))","v":46500},null,null,null,"वास्तविक स्थाईकरण",null,null,"YEAR","LEVAL","PAY"]
[{"$f":"IF(B11=\"\",\"\",A10+1)","v":3},{"$f":"IF(B10=\"\",\"\",IF(EOMONTH(B10,0)+1>$E$4,\"\",EOMONTH(B10,0)+1))","v":"2017-03-01"},"Mar-17",{"$f":"'DATA ENTRY'!D14","v":48400},{"$f":"IF('DATA ENTRY'!C14=\"\",\"\",IF('DATA ENTRY'!E14=\"\",'DATA ENTRY'!D14,'DATA ENTRY'!E14))","v":75700},{"$f":"'DATA ENTRY'!J14","v":46500},{"$f":"IF('DATA ENTRY'!I14=\"\",\"\",IF('DATA ENTRY'!K14=\"\",'DATA ENTRY'!J14,'DATA ENTRY'!K14))","v":46500}]
[4,"2017-04-01","Apr-17",{"$f":"'DATA ENTRY'!D15","v":48400},{"$f":"IF('DATA ENTRY'!C15=\"\",\"\",IF('DATA ENTRY'!E15=\"\",'DATA ENTRY'!D15,'DATA ENTRY'!E15))","v":48400},{"$f":"'DATA ENTRY'!J15","v":46500},{"$f":"IF('DATA ENTRY'!I15=\"\",\"\",IF('DATA ENTRY'!K15=\"\",'DATA ENTRY'!J15,'DATA ENTRY'!K15))","v":36900},null,null,null,"DATE",null,null,{"$f":"ORDER!J11","v":"2017-01-01"},{"$f":"ORDER!L11","v":"L_12"},{"$f":"ORDER!M11","v":48400},{"$f":"IF($K$13>N12,\"NOTIONAL\",\"REAL\")","v":"NOTIONAL"}]
[5,"2017-05-01","May-17",{"$f":"'DATA ENTRY'!D16","v":48400},{"$f":"IF('DATA ENTRY'!C16=\"\",\"\",IF('DATA ENTRY'!E16=\"\",'DATA ENTRY'!D16,'DATA ENTRY'!E16))","v":48400},{"$f":"'DATA ENTRY'!J16","v":46500},{"$f":"IF('DATA ENTRY'!I16=\"\",\"\",IF('DATA ENTRY'!K16=\"\",'DATA ENTRY'!J16,'DATA ENTRY'!K16))","v":36900},null,null,null,{"$f":"ORDER!G15","v":""},null,null,{"$f":"ORDER!J12","v":"2017-07-01"},{"$f":"ORDER!L12","v":"L_12"},{"$f":"ORDER!M12","v":49900},{"$f":"IF($K$13>N13,\"NOTIONAL\",\"REAL\")","v":"NOTIONAL"}]
[6,"2017-06-01","Jun-17",{"$f":"'DATA ENTRY'!D17","v":48400},{"$f":"IF('DATA ENTRY'!C17=\"\",\"\",IF('DATA ENTRY'!E17=\"\",'DATA ENTRY'!D17,'DATA ENTRY'!E17))","v":48400},{"$f":"'DATA ENTRY'!J17","v":46500},{"$f":"IF('DATA ENTRY'!I17=\"\",\"\",IF('DATA ENTRY'!K17=\"\",'DATA ENTRY'!J17,'DATA ENTRY'!K17))","v":46500},null,null,null,null,null,null,{"$f":"ORDER!J13","v":"2018-07-01"},{"$f":"ORDER!L13","v":"L_12"},{"$f":"ORDER!M13","v":51400},"NOTIONAL"]
[7,"2017-07-01","Jul-17",{"$f":"'DATA ENTRY'!D18","v":49900},{"$f":"IF('DATA ENTRY'!C18=\"\",\"\",IF('DATA ENTRY'!E18=\"\",'DATA ENTRY'!D18,'DATA ENTRY'!E18))","v":49900},{"$f":"'DATA ENTRY'!J18","v":47900},{"$f":"IF('DATA ENTRY'!I18=\"\",\"\",IF('DATA ENTRY'!K18=\"\",'DATA ENTRY'!J18,'DATA ENTRY'!K18))","v":47900},null,null,null,null,null,null,{"$f":"ORDER!J14","v":"2019-07-01"},{"$f":"ORDER!L14","v":"L_12"},{"$f":"ORDER!M14","v":52900},"NOTIONAL"]
[8,"2017-08-01","Aug-17",{"$f":"'DATA ENTRY'!D19","v":49900},{"$f":"IF('DATA ENTRY'!C19=\"\",\"\",IF('DATA ENTRY'!E19=\"\",'DATA ENTRY'!D19,'DATA ENTRY'!E19))","v":49900},{"$f":"'DATA ENTRY'!J19","v":47900},{"$f":"IF('DATA ENTRY'!I19=\"\",\"\",IF('DATA ENTRY'!K19=\"\",'DATA ENTRY'!J19,'DATA ENTRY'!K19))","v":47900},null,null,null,"PAY LEVAL","PAY",null,{"$f":"ORDER!J15","v":"2020-07-01"},{"$f":"ORDER!L15","v":"L_12"},{"$f":"ORDER!M15","v":54500},"NOTIONAL"]
[9,"2017-09-01","Sep-17",{"$f":"'DATA ENTRY'!D20","v":49900},{"$f":"IF('DATA ENTRY'!C20=\"\",\"\",IF('DATA ENTRY'!E20=\"\",'DATA ENTRY'!D20,'DATA ENTRY'!E20))","v":49900},{"$f":"'DATA ENTRY'!J20","v":47900},{"$f":"IF('DATA ENTRY'!I20=\"\",\"\",IF('DATA ENTRY'!K20=\"\",'DATA ENTRY'!J20,'DATA ENTRY'!K20))","v":47900},null,null,null,{"$f":"VLOOKUP($K$13,$N$12:$P16,2,TRUE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($K$13,$N$12:$P16,3,TRUE)","v":{"$error":"#N/A"}}]
[10,"2017-10-01","Oct-17",{"$f":"'DATA ENTRY'!D21","v":49900},{"$f":"IF('DATA ENTRY'!C21=\"\",\"\",IF('DATA ENTRY'!E21=\"\",'DATA ENTRY'!D21,'DATA ENTRY'!E21))","v":49900},{"$f":"'DATA ENTRY'!J21","v":47900},{"$f":"IF('DATA ENTRY'!I21=\"\",\"\",IF('DATA ENTRY'!K21=\"\",'DATA ENTRY'!J21,'DATA ENTRY'!K21))","v":47900}]
[11,"2017-11-01","Nov-17",{"$f":"'DATA ENTRY'!D22","v":49900},{"$f":"IF('DATA ENTRY'!C22=\"\",\"\",IF('DATA ENTRY'!E22=\"\",'DATA ENTRY'!D22,'DATA ENTRY'!E22))","v":49900},{"$f":"'DATA ENTRY'!J22","v":47900},{"$f":"IF('DATA ENTRY'!I22=\"\",\"\",IF('DATA ENTRY'!K22=\"\",'DATA ENTRY'!J22,'DATA ENTRY'!K22))","v":47900}]
[12,"2017-12-01","Dec-17",{"$f":"'DATA ENTRY'!D23","v":49900},{"$f":"IF('DATA ENTRY'!C23=\"\",\"\",IF('DATA ENTRY'!E23=\"\",'DATA ENTRY'!D23,'DATA ENTRY'!E23))","v":49900},{"$f":"'DATA ENTRY'!J23","v":47900},{"$f":"IF('DATA ENTRY'!I23=\"\",\"\",IF('DATA ENTRY'!K23=\"\",'DATA ENTRY'!J23,'DATA ENTRY'!K23))","v":47900}]
[13,"2018-01-01","Jan-18",{"$f":"'DATA ENTRY'!D24","v":49900},{"$f":"IF('DATA ENTRY'!C24=\"\",\"\",IF('DATA ENTRY'!E24=\"\",'DATA ENTRY'!D24,'DATA ENTRY'!E24))","v":49900},{"$f":"'DATA ENTRY'!J24","v":47900},{"$f":"IF('DATA ENTRY'!I24=\"\",\"\",IF('DATA ENTRY'!K24=\"\",'DATA ENTRY'!J24,'DATA ENTRY'!K24))","v":47900}]
[14,"2018-02-01","Feb-18",{"$f":"'DATA ENTRY'!D25","v":49900},{"$f":"IF('DATA ENTRY'!C25=\"\",\"\",IF('DATA ENTRY'!E25=\"\",'DATA ENTRY'!D25,'DATA ENTRY'!E25))","v":49900},{"$f":"'DATA ENTRY'!J25","v":47900},{"$f":"IF('DATA ENTRY'!I25=\"\",\"\",IF('DATA ENTRY'!K25=\"\",'DATA ENTRY'!J25,'DATA ENTRY'!K25))","v":47900}]
[15,"2018-03-01","Mar-18",{"$f":"'DATA ENTRY'!D26","v":49900},{"$f":"IF('DATA ENTRY'!C26=\"\",\"\",IF('DATA ENTRY'!E26=\"\",'DATA ENTRY'!D26,'DATA ENTRY'!E26))","v":49900},{"$f":"'DATA ENTRY'!J26","v":47900},{"$f":"IF('DATA ENTRY'!I26=\"\",\"\",IF('DATA ENTRY'!K26=\"\",'DATA ENTRY'!J26,'DATA ENTRY'!K26))","v":47900}]
[16,"2018-04-01","Apr-18",{"$f":"'DATA ENTRY'!D27","v":49900},{"$f":"IF('DATA ENTRY'!C27=\"\",\"\",IF('DATA ENTRY'!E27=\"\",'DATA ENTRY'!D27,'DATA ENTRY'!E27))","v":49900},{"$f":"'DATA ENTRY'!J27","v":47900},{"$f":"IF('DATA ENTRY'!I27=\"\",\"\",IF('DATA ENTRY'!K27=\"\",'DATA ENTRY'!J27,'DATA ENTRY'!K27))","v":47900}]
[17,"2018-05-01","May-18",{"$f":"'DATA ENTRY'!D28","v":49900},{"$f":"IF('DATA ENTRY'!C28=\"\",\"\",IF('DATA ENTRY'!E28=\"\",'DATA ENTRY'!D28,'DATA ENTRY'!E28))","v":49900},{"$f":"'DATA ENTRY'!J28","v":47900},{"$f":"IF('DATA ENTRY'!I28=\"\",\"\",IF('DATA ENTRY'!K28=\"\",'DATA ENTRY'!J28,'DATA ENTRY'!K28))","v":47900}]
[18,"2018-06-01","Jun-18",{"$f":"'DATA ENTRY'!D29","v":49900},{"$f":"IF('DATA ENTRY'!C29=\"\",\"\",IF('DATA ENTRY'!E29=\"\",'DATA ENTRY'!D29,'DATA ENTRY'!E29))","v":49900},{"$f":"'DATA ENTRY'!J29","v":47900},{"$f":"IF('DATA ENTRY'!I29=\"\",\"\",IF('DATA ENTRY'!K29=\"\",'DATA ENTRY'!J29,'DATA ENTRY'!K29))","v":47900}]
[19,"2018-07-01","Jul-18",{"$f":"'DATA ENTRY'!D30","v":51400},{"$f":"IF('DATA ENTRY'!C30=\"\",\"\",IF('DATA ENTRY'!E30=\"\",'DATA ENTRY'!D30,'DATA ENTRY'!E30))","v":51400},{"$f":"'DATA ENTRY'!J30","v":49300},{"$f":"IF('DATA ENTRY'!I30=\"\",\"\",IF('DATA ENTRY'!K30=\"\",'DATA ENTRY'!J30,'DATA ENTRY'!K30))","v":49300}]
[20,"2018-08-01","Aug-18",{"$f":"'DATA ENTRY'!D31","v":51400},{"$f":"IF('DATA ENTRY'!C31=\"\",\"\",IF('DATA ENTRY'!E31=\"\",'DATA ENTRY'!D31,'DATA ENTRY'!E31))","v":51400},{"$f":"'DATA ENTRY'!J31","v":49300},{"$f":"IF('DATA ENTRY'!I31=\"\",\"\",IF('DATA ENTRY'!K31=\"\",'DATA ENTRY'!J31,'DATA ENTRY'!K31))","v":49300}]
[21,"2018-09-01","Sep-18",{"$f":"'DATA ENTRY'!D32","v":51400},{"$f":"IF('DATA ENTRY'!C32=\"\",\"\",IF('DATA ENTRY'!E32=\"\",'DATA ENTRY'!D32,'DATA ENTRY'!E32))","v":51400},{"$f":"'DATA ENTRY'!J32","v":49300},{"$f":"IF('DATA ENTRY'!I32=\"\",\"\",IF('DATA ENTRY'!K32=\"\",'DATA ENTRY'!J32,'DATA ENTRY'!K32))","v":49300}]
[22,"2018-10-01","Oct-18",{"$f":"'DATA ENTRY'!D33","v":51400},{"$f":"IF('DATA ENTRY'!C33=\"\",\"\",IF('DATA ENTRY'!E33=\"\",'DATA ENTRY'!D33,'DATA ENTRY'!E33))","v":51400},{"$f":"'DATA ENTRY'!J33","v":49300},{"$f":"IF('DATA ENTRY'!I33=\"\",\"\",IF('DATA ENTRY'!K33=\"\",'DATA ENTRY'!J33,'DATA ENTRY'!K33))","v":49300}]
[23,"2018-11-01","Nov-18",{"$f":"'DATA ENTRY'!D34","v":51400},{"$f":"IF('DATA ENTRY'!C34=\"\",\"\",IF('DATA ENTRY'!E34=\"\",'DATA ENTRY'!D34,'DATA ENTRY'!E34))","v":51400},{"$f":"'DATA ENTRY'!J34","v":49300},{"$f":"IF('DATA ENTRY'!I34=\"\",\"\",IF('DATA ENTRY'!K34=\"\",'DATA ENTRY'!J34,'DATA ENTRY'!K34))","v":49300}]
[24,"2018-12-01","Dec-18",{"$f":"'DATA ENTRY'!D35","v":51400},{"$f":"IF('DATA ENTRY'!C35=\"\",\"\",IF('DATA ENTRY'!E35=\"\",'DATA ENTRY'!D35,'DATA ENTRY'!E35))","v":51400},{"$f":"'DATA ENTRY'!J35","v":49300},{"$f":"IF('DATA ENTRY'!I35=\"\",\"\",IF('DATA ENTRY'!K35=\"\",'DATA ENTRY'!J35,'DATA ENTRY'!K35))","v":49300}]
[25,{"$f":"IF(B32=\"\",\"\",IF(EOMONTH(B32,0)+1>$E$4,\"\",EOMONTH(B32,0)+1))","v":"2019-01-01"},"Jan-19",{"$f":"'DATA ENTRY'!D36","v":51400},{"$f":"IF('DATA ENTRY'!C36=\"\",\"\",IF('DATA ENTRY'!E36=\"\",'DATA ENTRY'!D36,'DATA ENTRY'!E36))","v":51400},{"$f":"'DATA ENTRY'!J36","v":49300},{"$f":"IF('DATA ENTRY'!I36=\"\",\"\",IF('DATA ENTRY'!K36=\"\",'DATA ENTRY'!J36,'DATA ENTRY'!K36))","v":49300}]
[26,"2019-02-01","Feb-19",{"$f":"'DATA ENTRY'!D37","v":51400},{"$f":"IF('DATA ENTRY'!C37=\"\",\"\",IF('DATA ENTRY'!E37=\"\",'DATA ENTRY'!D37,'DATA ENTRY'!E37))","v":51400},{"$f":"'DATA ENTRY'!J37","v":49300},{"$f":"IF('DATA ENTRY'!I37=\"\",\"\",IF('DATA ENTRY'!K37=\"\",'DATA ENTRY'!J37,'DATA ENTRY'!K37))","v":49300}]
[27,{"$f":"IF(B34=\"\",\"\",IF(EOMONTH(B34,0)+1>$E$4,\"\",EOMONTH(B34,0)+1))","v":"2019-03-01"},"Mar-19",{"$f":"'DATA ENTRY'!D38","v":51400},{"$f":"IF('DATA ENTRY'!C38=\"\",\"\",IF('DATA ENTRY'!E38=\"\",'DATA ENTRY'!D38,'DATA ENTRY'!E38))","v":51400},{"$f":"'DATA ENTRY'!J38","v":49300},{"$f":"IF('DATA ENTRY'!I38=\"\",\"\",IF('DATA ENTRY'!K38=\"\",'DATA ENTRY'!J38,'DATA ENTRY'!K38))","v":49300}]
[28,"2019-04-01","Apr-19",{"$f":"'DATA ENTRY'!D39","v":51400},{"$f":"IF('DATA ENTRY'!C39=\"\",\"\",IF('DATA ENTRY'!E39=\"\",'DATA ENTRY'!D39,'DATA ENTRY'!E39))","v":51400},{"$f":"'DATA ENTRY'!J39","v":49300},{"$f":"IF('DATA ENTRY'!I39=\"\",\"\",IF('DATA ENTRY'!K39=\"\",'DATA ENTRY'!J39,'DATA ENTRY'!K39))","v":49300}]
[29,"2019-05-01","May-19",{"$f":"'DATA ENTRY'!D40","v":51400},{"$f":"IF('DATA ENTRY'!C40=\"\",\"\",IF('DATA ENTRY'!E40=\"\",'DATA ENTRY'!D40,'DATA ENTRY'!E40))","v":51400},{"$f":"'DATA ENTRY'!J40","v":49300},{"$f":"IF('DATA ENTRY'!I40=\"\",\"\",IF('DATA ENTRY'!K40=\"\",'DATA ENTRY'!J40,'DATA ENTRY'!K40))","v":49300}]
[30,"2019-06-01","Jun-19",{"$f":"'DATA ENTRY'!D41","v":51400},{"$f":"IF('DATA ENTRY'!C41=\"\",\"\",IF('DATA ENTRY'!E41=\"\",'DATA ENTRY'!D41,'DATA ENTRY'!E41))","v":51400},{"$f":"'DATA ENTRY'!J41","v":49300},{"$f":"IF('DATA ENTRY'!I41=\"\",\"\",IF('DATA ENTRY'!K41=\"\",'DATA ENTRY'!J41,'DATA ENTRY'!K41))","v":49300}]
[31,"2019-07-01","Jul-19",{"$f":"'DATA ENTRY'!D42","v":52900},{"$f":"IF('DATA ENTRY'!C42=\"\",\"\",IF('DATA ENTRY'!E42=\"\",'DATA ENTRY'!D42,'DATA ENTRY'!E42))","v":52900},{"$f":"'DATA ENTRY'!J42","v":50800},{"$f":"IF('DATA ENTRY'!I42=\"\",\"\",IF('DATA ENTRY'!K42=\"\",'DATA ENTRY'!J42,'DATA ENTRY'!K42))","v":50800}]
[32,"2019-08-01","Aug-19",{"$f":"'DATA ENTRY'!D43","v":52900},{"$f":"IF('DATA ENTRY'!C43=\"\",\"\",IF('DATA ENTRY'!E43=\"\",'DATA ENTRY'!D43,'DATA ENTRY'!E43))","v":52900},{"$f":"'DATA ENTRY'!J43","v":50800},{"$f":"IF('DATA ENTRY'!I43=\"\",\"\",IF('DATA ENTRY'!K43=\"\",'DATA ENTRY'!J43,'DATA ENTRY'!K43))","v":50800}]
[33,"2019-09-01","Sep-19",{"$f":"'DATA ENTRY'!D44","v":52900},{"$f":"IF('DATA ENTRY'!C44=\"\",\"\",IF('DATA ENTRY'!E44=\"\",'DATA ENTRY'!D44,'DATA ENTRY'!E44))","v":52900},{"$f":"'DATA ENTRY'!J44","v":50800},{"$f":"IF('DATA ENTRY'!I44=\"\",\"\",IF('DATA ENTRY'!K44=\"\",'DATA ENTRY'!J44,'DATA ENTRY'!K44))","v":50800}]
[34,"2019-10-01","Oct-19",{"$f":"'DATA ENTRY'!D45","v":52900},{"$f":"IF('DATA ENTRY'!C45=\"\",\"\",IF('DATA ENTRY'!E45=\"\",'DATA ENTRY'!D45,'DATA ENTRY'!E45))","v":52900},{"$f":"'DATA ENTRY'!J45","v":50800},{"$f":"IF('DATA ENTRY'!I45=\"\",\"\",IF('DATA ENTRY'!K45=\"\",'DATA ENTRY'!J45,'DATA ENTRY'!K45))","v":50800}]
[{"$f":"IF(B43=\"\",\"\",A42+1)","v":35},{"$f":"IF(B42=\"\",\"\",IF(EOMONTH(B42,0)+1>$E$4,\"\",EOMONTH(B42,0)+1))","v":"2019-11-01"},"Nov-19",{"$f":"'DATA ENTRY'!D46","v":52900},{"$f":"IF('DATA ENTRY'!C46=\"\",\"\",IF('DATA ENTRY'!E46=\"\",'DATA ENTRY'!D46,'DATA ENTRY'!E46))","v":52900},{"$f":"'DATA ENTRY'!J46","v":50800},{"$f":"IF('DATA ENTRY'!I46=\"\",\"\",IF('DATA ENTRY'!K46=\"\",'DATA ENTRY'!J46,'DATA ENTRY'!K46))","v":50800}]
[36,"2019-12-01","Dec-19",{"$f":"'DATA ENTRY'!D47","v":52900},{"$f":"IF('DATA ENTRY'!C47=\"\",\"\",IF('DATA ENTRY'!E47=\"\",'DATA ENTRY'!D47,'DATA ENTRY'!E47))","v":52900},{"$f":"'DATA ENTRY'!J47","v":50800},{"$f":"IF('DATA ENTRY'!I47=\"\",\"\",IF('DATA ENTRY'!K47=\"\",'DATA ENTRY'!J47,'DATA ENTRY'!K47))","v":50800}]
[{"$f":"IF(B45=\"\",\"\",A44+1)","v":37},"2020-01-01",{"$f":"TEXT(B45,\"mmm\"&\"-\"&\"YY\")","v":"Jan-20"},{"$f":"'DATA ENTRY'!D48","v":52900},{"$f":"IF('DATA ENTRY'!C48=\"\",\"\",IF('DATA ENTRY'!E48=\"\",'DATA ENTRY'!D48,'DATA ENTRY'!E48))","v":52900},{"$f":"'DATA ENTRY'!J48","v":50800},{"$f":"IF('DATA ENTRY'!I48=\"\",\"\",IF('DATA ENTRY'!K48=\"\",'DATA ENTRY'!J48,'DATA ENTRY'!K48))","v":50800}]
[38,"2020-02-01","Feb-20",{"$f":"'DATA ENTRY'!D49","v":52900},{"$f":"IF('DATA ENTRY'!C49=\"\",\"\",IF('DATA ENTRY'!E49=\"\",'DATA ENTRY'!D49,'DATA ENTRY'!E49))","v":52900},{"$f":"'DATA ENTRY'!J49","v":50800},{"$f":"IF('DATA ENTRY'!I49=\"\",\"\",IF('DATA ENTRY'!K49=\"\",'DATA ENTRY'!J49,'DATA ENTRY'!K49))","v":50800}]
[39,"2020-03-01","Mar-20",{"$f":"'DATA ENTRY'!D50","v":52900},{"$f":"IF('DATA ENTRY'!C50=\"\",\"\",IF('DATA ENTRY'!E50=\"\",'DATA ENTRY'!D50,'DATA ENTRY'!E50))","v":52900},{"$f":"'DATA ENTRY'!J50","v":50800},{"$f":"IF('DATA ENTRY'!I50=\"\",\"\",IF('DATA ENTRY'!K50=\"\",'DATA ENTRY'!J50,'DATA ENTRY'!K50))","v":50800}]
[40,"2020-04-01","Apr-20",{"$f":"'DATA ENTRY'!D51","v":52900},{"$f":"IF('DATA ENTRY'!C51=\"\",\"\",IF('DATA ENTRY'!E51=\"\",'DATA ENTRY'!D51,'DATA ENTRY'!E51))","v":52900},{"$f":"'DATA ENTRY'!J51","v":50800},{"$f":"IF('DATA ENTRY'!I51=\"\",\"\",IF('DATA ENTRY'!K51=\"\",'DATA ENTRY'!J51,'DATA ENTRY'!K51))","v":50800}]
[41,"2020-05-01","May-20",{"$f":"'DATA ENTRY'!D52","v":52900},{"$f":"IF('DATA ENTRY'!C52=\"\",\"\",IF('DATA ENTRY'!E52=\"\",'DATA ENTRY'!D52,'DATA ENTRY'!E52))","v":52900},{"$f":"'DATA ENTRY'!J52","v":50800},{"$f":"IF('DATA ENTRY'!I52=\"\",\"\",IF('DATA ENTRY'!K52=\"\",'DATA ENTRY'!J52,'DATA ENTRY'!K52))","v":50800}]
[42,"2020-06-01","Jun-20",{"$f":"'DATA ENTRY'!D53","v":52900},{"$f":"IF('DATA ENTRY'!C53=\"\",\"\",IF('DATA ENTRY'!E53=\"\",'DATA ENTRY'!D53,'DATA ENTRY'!E53))","v":52900},{"$f":"'DATA ENTRY'!J53","v":50800},{"$f":"IF('DATA ENTRY'!I53=\"\",\"\",IF('DATA ENTRY'!K53=\"\",'DATA ENTRY'!J53,'DATA ENTRY'!K53))","v":50800}]
[43,"2020-07-01","Jul-20",{"$f":"'DATA ENTRY'!D54","v":54500},{"$f":"IF('DATA ENTRY'!C54=\"\",\"\",IF('DATA ENTRY'!E54=\"\",'DATA ENTRY'!D54,'DATA ENTRY'!E54))","v":54500},{"$f":"'DATA ENTRY'!J54","v":52300},{"$f":"IF('DATA ENTRY'!I54=\"\",\"\",IF('DATA ENTRY'!K54=\"\",'DATA ENTRY'!J54,'DATA ENTRY'!K54))","v":52300}]
[44,"2020-08-01","Aug-20",{"$f":"'DATA ENTRY'!D55","v":54500},{"$f":"IF('DATA ENTRY'!C55=\"\",\"\",IF('DATA ENTRY'!E55=\"\",'DATA ENTRY'!D55,'DATA ENTRY'!E55))","v":54500},{"$f":"'DATA ENTRY'!J55","v":52300},{"$f":"IF('DATA ENTRY'!I55=\"\",\"\",IF('DATA ENTRY'!K55=\"\",'DATA ENTRY'!J55,'DATA ENTRY'!K55))","v":52300}]
[45,"2020-09-01","Sep-20",{"$f":"'DATA ENTRY'!D56","v":54500},{"$f":"IF('DATA ENTRY'!C56=\"\",\"\",IF('DATA ENTRY'!E56=\"\",'DATA ENTRY'!D56,'DATA ENTRY'!E56))","v":54500},{"$f":"'DATA ENTRY'!J56","v":52300},{"$f":"IF('DATA ENTRY'!I56=\"\",\"\",IF('DATA ENTRY'!K56=\"\",'DATA ENTRY'!J56,'DATA ENTRY'!K56))","v":52300}]
[46,"2020-10-01","Oct-20",{"$f":"'DATA ENTRY'!D57","v":54500},{"$f":"IF('DATA ENTRY'!C57=\"\",\"\",IF('DATA ENTRY'!E57=\"\",'DATA ENTRY'!D57,'DATA ENTRY'!E57))","v":54500},{"$f":"'DATA ENTRY'!J57","v":52300},{"$f":"IF('DATA ENTRY'!I57=\"\",\"\",IF('DATA ENTRY'!K57=\"\",'DATA ENTRY'!J57,'DATA ENTRY'!K57))","v":52300}]
[47,"2020-11-01","Nov-20",{"$f":"'DATA ENTRY'!D58","v":54500},{"$f":"IF('DATA ENTRY'!C58=\"\",\"\",IF('DATA ENTRY'!E58=\"\",'DATA ENTRY'!D58,'DATA ENTRY'!E58))","v":54500},{"$f":"'DATA ENTRY'!J58","v":52300},{"$f":"IF('DATA ENTRY'!I58=\"\",\"\",IF('DATA ENTRY'!K58=\"\",'DATA ENTRY'!J58,'DATA ENTRY'!K58))","v":52300}]
[48,"2020-12-01","Dec-20",{"$f":"'DATA ENTRY'!D59","v":54500},{"$f":"IF('DATA ENTRY'!C59=\"\",\"\",IF('DATA ENTRY'!E59=\"\",'DATA ENTRY'!D59,'DATA ENTRY'!E59))","v":54500},{"$f":"'DATA ENTRY'!J59","v":52300},{"$f":"IF('DATA ENTRY'!I59=\"\",\"\",IF('DATA ENTRY'!K59=\"\",'DATA ENTRY'!J59,'DATA ENTRY'!K59))","v":52300}]
[{"$f":"IF(B57=\"\",\"\",A56+1)","v":49},"2021-01-01",{"$f":"TEXT(B57,\"mmm\"&\"-\"&\"YY\")","v":"Jan-21"},{"$f":"'DATA ENTRY'!D60","v":54500},{"$f":"IF('DATA ENTRY'!C60=\"\",\"\",IF('DATA ENTRY'!E60=\"\",'DATA ENTRY'!D60,'DATA ENTRY'!E60))","v":54500},{"$f":"'DATA ENTRY'!J60","v":52300},{"$f":"IF('DATA ENTRY'!I60=\"\",\"\",IF('DATA ENTRY'!K60=\"\",'DATA ENTRY'!J60,'DATA ENTRY'!K60))","v":52300}]
[50,"2021-02-01","Feb-21",{"$f":"'DATA ENTRY'!D61","v":54500},{"$f":"IF('DATA ENTRY'!C61=\"\",\"\",IF('DATA ENTRY'!E61=\"\",'DATA ENTRY'!D61,'DATA ENTRY'!E61))","v":54500},{"$f":"'DATA ENTRY'!J61","v":52300},{"$f":"IF('DATA ENTRY'!I61=\"\",\"\",IF('DATA ENTRY'!K61=\"\",'DATA ENTRY'!J61,'DATA ENTRY'!K61))","v":52300}]
[51,"2021-03-01","Mar-21",{"$f":"'DATA ENTRY'!D62","v":54500},{"$f":"IF('DATA ENTRY'!C62=\"\",\"\",IF('DATA ENTRY'!E62=\"\",'DATA ENTRY'!D62,'DATA ENTRY'!E62))","v":54500},{"$f":"'DATA ENTRY'!J62","v":52300},{"$f":"IF('DATA ENTRY'!I62=\"\",\"\",IF('DATA ENTRY'!K62=\"\",'DATA ENTRY'!J62,'DATA ENTRY'!K62))","v":52300}]
[52,"2021-04-01","Apr-21",{"$f":"'DATA ENTRY'!D63","v":54500},{"$f":"IF('DATA ENTRY'!C63=\"\",\"\",IF('DATA ENTRY'!E63=\"\",'DATA ENTRY'!D63,'DATA ENTRY'!E63))","v":54500},{"$f":"'DATA ENTRY'!J63","v":52300},{"$f":"IF('DATA ENTRY'!I63=\"\",\"\",IF('DATA ENTRY'!K63=\"\",'DATA ENTRY'!J63,'DATA ENTRY'!K63))","v":52300}]
[53,"2021-05-01","May-21",{"$f":"'DATA ENTRY'!D64","v":54500},{"$f":"IF('DATA ENTRY'!C64=\"\",\"\",IF('DATA ENTRY'!E64=\"\",'DATA ENTRY'!D64,'DATA ENTRY'!E64))","v":54500},{"$f":"'DATA ENTRY'!J64","v":52300},{"$f":"IF('DATA ENTRY'!I64=\"\",\"\",IF('DATA ENTRY'!K64=\"\",'DATA ENTRY'!J64,'DATA ENTRY'!K64))","v":52300}]
[{"$f":"IF(B62=\"\",\"\",A61+1)","v":54},"2021-06-01",{"$f":"TEXT(B62,\"mmm\"&\"-\"&\"YY\")","v":"Jun-21"},{"$f":"'DATA ENTRY'!D65","v":54500},{"$f":"IF('DATA ENTRY'!C65=\"\",\"\",IF('DATA ENTRY'!E65=\"\",'DATA ENTRY'!D65,'DATA ENTRY'!E65))","v":54500},{"$f":"'DATA ENTRY'!J65","v":52300},{"$f":"IF('DATA ENTRY'!I65=\"\",\"\",IF('DATA ENTRY'!K65=\"\",'DATA ENTRY'!J65,'DATA ENTRY'!K65))","v":52300}]
[55,"2021-07-01","Jul-21",{"$f":"'DATA ENTRY'!D66","v":56100},{"$f":"IF('DATA ENTRY'!C66=\"\",\"\",IF('DATA ENTRY'!E66=\"\",'DATA ENTRY'!D66,'DATA ENTRY'!E66))","v":56100},{"$f":"'DATA ENTRY'!J66","v":53900},{"$f":"IF('DATA ENTRY'!I66=\"\",\"\",IF('DATA ENTRY'!K66=\"\",'DATA ENTRY'!J66,'DATA ENTRY'!K66))","v":53900}]
[56,"2021-08-01","Aug-21",{"$f":"'DATA ENTRY'!D67","v":56100},{"$f":"IF('DATA ENTRY'!C67=\"\",\"\",IF('DATA ENTRY'!E67=\"\",'DATA ENTRY'!D67,'DATA ENTRY'!E67))","v":56100},{"$f":"'DATA ENTRY'!J67","v":53900},{"$f":"IF('DATA ENTRY'!I67=\"\",\"\",IF('DATA ENTRY'!K67=\"\",'DATA ENTRY'!J67,'DATA ENTRY'!K67))","v":53900}]
[57,"2021-09-01","Sep-21",{"$f":"'DATA ENTRY'!D68","v":56100},{"$f":"IF('DATA ENTRY'!C68=\"\",\"\",IF('DATA ENTRY'!E68=\"\",'DATA ENTRY'!D68,'DATA ENTRY'!E68))","v":56100},{"$f":"'DATA ENTRY'!J68","v":53900},{"$f":"IF('DATA ENTRY'!I68=\"\",\"\",IF('DATA ENTRY'!K68=\"\",'DATA ENTRY'!J68,'DATA ENTRY'!K68))","v":53900}]
[58,"2021-10-01","Oct-21",{"$f":"'DATA ENTRY'!D69","v":56100},{"$f":"IF('DATA ENTRY'!C69=\"\",\"\",IF('DATA ENTRY'!E69=\"\",'DATA ENTRY'!D69,'DATA ENTRY'!E69))","v":56100},{"$f":"'DATA ENTRY'!J69","v":53900},{"$f":"IF('DATA ENTRY'!I69=\"\",\"\",IF('DATA ENTRY'!K69=\"\",'DATA ENTRY'!J69,'DATA ENTRY'!K69))","v":53900}]
[59,"2021-11-01","Nov-21",{"$f":"'DATA ENTRY'!D70","v":56100},{"$f":"IF('DATA ENTRY'!C70=\"\",\"\",IF('DATA ENTRY'!E70=\"\",'DATA ENTRY'!D70,'DATA ENTRY'!E70))","v":56100},{"$f":"'DATA ENTRY'!J70","v":53900},{"$f":"IF('DATA ENTRY'!I70=\"\",\"\",IF('DATA ENTRY'!K70=\"\",'DATA ENTRY'!J70,'DATA ENTRY'!K70))","v":53900}]
[60,"2021-12-01","Dec-21",{"$f":"'DATA ENTRY'!D71","v":56100},{"$f":"IF('DATA ENTRY'!C71=\"\",\"\",IF('DATA ENTRY'!E71=\"\",'DATA ENTRY'!D71,'DATA ENTRY'!E71))","v":56100},{"$f":"'DATA ENTRY'!J71","v":53900},{"$f":"IF('DATA ENTRY'!I71=\"\",\"\",IF('DATA ENTRY'!K71=\"\",'DATA ENTRY'!J71,'DATA ENTRY'!K71))","v":53900}]

{"sheet":"7th pay chart","index":7,"n_rows":60,"n_cols":25,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,0,9],[0,10,0,13],[0,14,0,21],[0,22,0,24]]}
["Existing\nR.P.Band","PB_1\n5200_20200",null,null,null,null,null,null,null,null,"PB_2\n9300_34800",null,null,null,"PB_3\n15600_39100",null,null,null,null,null,null,null,"PB_4\n37400_67000"]
["Exist.G.P.",1700,1750,1900,2000,2400,2400,2400,2800,2800,3600,4200,4800,5400,5400,6000,6600,6800,7200,7600,8200,8700,8900,9500,10000]
["Exist.G.P.No",2,3,4,5,9,"9A","9B",10,"10A",11,12,14,15,15,16,17,18,19,20,21,22,23,"23A",24]
["Levels →","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"]
["Cell No. ↓",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[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]
[15,26800,27100,27600,29000,31400,32400,34000,39800,43500,51000,57200,67000,80200,84900,91700,101800,107300,113800,120700,134500,186200,196100]
[16,27600,27900,28400,29900,32300,33400,35000,41000,44800,52500,58900,69000,82600,87400,94500,104900,110500,117200,124300,138500,191800,202000]
[17,28400,28700,29300,30800,33300,34400,36100,42200,46100,54100,60700,71100,85100,90000,97300,108000,113800,120700,128000,142700,197600,208100]
[18,29300,29600,30200,31700,34300,35400,37200,43500,47500,55700,62500,73200,87700,92700,100200,111200,117200,124300,131800,147000,203500]
[19,30200,30500,31100,32700,35300,36500,38300,44800,48900,57400,64400,75400,90300,95500,103200,114500,120700,128000,135800,151400]
[20,31100,31400,32000,33700,36400,37600,39400,46100,50400,59100,66300,77700,93000,98400,106300,117900,124300,131800,139900,155900]
[21,32000,32300,33000,34700,37500,38700,40600,47500,51900,60900,68300,80000,95800,101400,109500,121400,128000,135800,144100,160600]
[22,33000,33300,34000,35700,38600,39900,41800,48900,53500,62700,70300,82400,98700,104400,112800,125000,131800,139900,148400,165400]
[23,34000,34300,35000,36800,39800,41100,43100,50400,55100,64600,72400,84900,101700,107500,116200,128800,135800,144100,152900,170400]
[24,35000,35300,36100,37900,41000,42300,44400,51900,56800,66500,74600,87400,104800,110700,119700,132700,139900,148400,157500,175500]
[25,36100,36400,37200,39000,42200,43600,45700,53500,58500,68500,76800,90000,107900,114000,123300,136700,144100,152900,162200,180800]
[26,37200,37500,38300,40200,43500,44900,47100,55100,60300,70600,79100,92700,111100,117400,127000,140800,148400,157500,167100,186200]
[27,38300,38600,39400,41400,44800,46200,48500,56800,62100,72700,81500,95500,114400,120900,130800,145000,152900,162200,172100,191800]
[28,39400,39800,40600,42600,46100,47600,50000,58500,64000,74900,83900,98400,117800,124500,134700,149400,157500,167100,177300,197600]
[29,40600,41000,41800,43900,47500,49000,51500,60300,65900,77100,86400,101400,121300,128200,138700,153900,162200,172100,182600,203500]
[30,41800,42200,43100,45200,48900,50500,53000,62100,67900,79400,89000,104400,124900,132000,142900,158500,167100,177300,188100]
[31,43100,43500,44400,46600,50400,52000,54600,64000,69900,81800,91700,107500,128600,136000,147200,163300,172100,182600,193700]
[32,44400,44800,45700,48000,51900,53600,56200,65900,72000,84300,94500,110700,132500,140100,151600,168200,177300,188100,199500]
[33,45700,46100,47100,49400,53500,55200,57900,67900,74200,86800,97300,114000,136500,144300,156100,173200,182600,193700]
[34,47100,47500,48500,50900,55100,56900,59600,69900,76400,89400,100200,117400,140600,148600,160800,178400,188100,199500]
[35,48500,48900,50000,52400,56800,58600,61400,72000,78700,92100,103200,120900,144800,153100,165600,183800,193700]
[36,50000,50400,51500,54000,58500,60400,63200,74200,81100,94900,106300,124500,149100,157700,170600,189300,199500]
[37,51500,51900,53000,55600,60300,62200,65100,76400,83500,97700,109500,128200,153600,162400,175700,195000]
[38,53000,53500,54600,57300,62100,64100,67100,78700,86000,100600,112800,132000,158200,167300,181000]
[39,54600,55100,56200,59000,64000,66000,69100,81100,88600,103600,116200,136000,162900,172300,186400]
[40,56200,56800,57900,60800,65900,68000,71200,83500,91300,106700,119700,140100,167800,177500,192000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"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,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,56200,56800,57900,60800,65900,68000,71200,83500,91300,106700,119700,140100,167800,177500,192000,195000,199500,199500,199500,203500,203500,208100,214100,218600]