{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sallary Arrear"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sallary Arrear","index":0,"n_rows":203,"n_cols":58,"rows_kept":203,"merged":[[0,0,41,0],[0,1,0,41],[1,1,1,4],[1,5,1,9],[1,10,1,12],[1,13,1,15],[1,16,1,19],[1,20,1,21],[1,22,1,24],[1,25,1,26],[1,27,1,30],[1,31,1,41],[2,1,2,41],[3,1,3,11],[3,12,3,41],[4,1,4,41],[5,1,5,41],[6,1,6,8],[6,9,6,15],[6,16,6,19],[6,20,6,24],[6,25,6,31],[6,32,6,41],[7,1,7,19],[7,20,7,24],[7,26,7,29],[7,30,7,32],[7,33,7,39],[7,40,7,41],[8,1,10,1],[8,2,10,4],[8,8,8,13],[8,14,8,19],[8,20,8,25],[8,26,8,28],[8,29,8,31],[8,32,8,34],[8,35,8,37],[8,38,10,38],[8,39,10,39],[8,40,10,40],[8,41,10,41],[9,8,10,8],[9,11,10,11],[9,13,10,13],[9,14,10,14],[9,17,10,17],[9,19,10,19],[9,20,10,20],[9,21,10,21],[9,22,10,22],[9,23,10,23],[9,25,10,25],[9,26,10,26],[9,27,10,27],[9,28,10,28],[9,29,10,29],[9,30,10,30],[9,31,10,31],[9,32,10,32],[9,33,10,33],[9,34,10,34],[9,35,10,35],[9,36,10,36],[9,37,10,37],[11,1,15,1],[11,2,15,2],[11,8,12,8],[11,9,12,9],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,13,12,13],[11,14,15,14],[11,15,15,15],[11,16,15,16],[11,17,15,17],[11,18,15,18],[11,19,15,19],[11,20,15,20],[11,21,15,21],[11,22,15,22],[11,23,15,23],[11,24,15,24],[11,25,15,25],[11,26,15,26],[11,27,15,27],[11,28,15,28],[11,29,15,29],[11,30,15,30],[11,31,15,31],[11,32,15,32],[11,33,15,33],[11,34,15,34],[11,35,15,35],[11,36,15,36],[11,37,15,37],[11,38,15,38],[11,39,15,39],[11,40,15,40],[11,41,15,41],[11,54,15,54],[11,55,15,55],[11,56,15,56],[11,57,15,57],[11,58,15,58],[12,3,12,4],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[13,13,14,13],[13,44,15,45],[13,46,15,47],[14,3,14,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[27,2,27,4],[28,1,28,4],[29,1,29,22],[29,25,29,41],[30,2,33,4],[30,8,30,14],[30,15,30,22],[30,25,32,41],[31,8,31,14],[31,15,31,22],[32,8,32,14],[32,15,32,22],[33,8,33,14],[33,15,33,22],[33,25,41,41],[34,2,39,4],[34,8,34,14],[34,15,34,22],[35,8,35,14],[35,15,35,22],[36,8,36,14],[36,15,36,22],[37,8,37,14],[37,15,37,22],[38,8,38,14],[38,15,38,22],[39,8,39,14],[39,15,39,22],[40,1,40,14],[40,15,40,22],[41,1,41,14],[41,15,41,22],[42,0,42,42]]}
[null,"Prepared By:-Ummed Tarad (Teacher,GSSS Raimalwada) Mob.No.-9166973141 Email Add.-ummedtrdedu@gmail.com"]
[null,"Type Of Employee",{"$nulls":3},"Already Regular",{"$nulls":4},"Employee Category",null,null,"State Service",null,null,"Income Tax Rate",{"$nulls":3},{"v":0.05,"d":"5%"},null,"GPF कटौती",null,null,0,null,"Arear Type",{"$nulls":3},"स्थायीकरण एरियर अंतर तालिका",{"$nulls":19},{"v":0,"d":"0%"},"State Service"]
[null,"नोट:- सबसे पहले ऊपर उचित डेटा का चयन करें, तत्पश्चात इस शीट में केवल पिंक कलर में दिखाई देने वाले सेल्स में ही उचित एंट्रीज़ करें। खाली पंक्तियों को HIDE कर सकते हो। नीचे के मीनू से उचित डेटा को सिलैक्ट करें। ",{"$nulls":49},{"v":0.01,"d":"1%"},"Subordinate"]
[null,"कार्यालय:प्रधानाचार्य",{"$nulls":49},{"v":0.02,"d":"2%"},"Ministrial"]
[null,{"$f":"AF2","v":"स्थायीकरण एरियर अंतर तालिका"},{"$nulls":49},{"v":0.03,"d":"3%"},"Fourth Grade"]
[{"$nulls":51},{"v":0.04,"d":"4%"}]
[null,"कार्मिक का नाम:-",{"$nulls":14},"पद:-",{"$nulls":8},"एम्प्लोयी आईडी:-",{"$nulls":6},"RJJO2018…………………",{"$nulls":18},{"v":0.05,"d":"5%"}]
[null,"सैलेरी एरियर अवधि:",{"$nulls":18},"2019-03-05",{"$nulls":4},"से","2020-01-31",{"$nulls":3},{"$f":"MONTH(AA8)","v":1},null,null,{"$f":"YEAR(AA8)","v":2020},{"$nulls":6},{"$f":"CONCATENATE(AE8,AH8)","v":"12020"},{"$nulls":3},{"$f":"U8","v":"2019-03-05"},{"$f":"DAY(AS8)","v":5},{"$f":"MONTH(E16)","v":3},{"$f":"YEAR(AS8)","v":2019},{"$nulls":3},{"v":0.06,"d":"6%"}]
[null,"S. N0.","MONTH",{"$nulls":5},"After Fixation/Revise Pay",{"$nulls":5},"Before Fixation/Revise Pay",{"$nulls":5},"वेतन का अंतर",{"$nulls":5},"NPS",null,null,"CMCoronaRelief",null,null,"SI",null,null,"RPMF",null,null,"ROP","INCOME TAX     (TDS)","TOTAL DED.","NET AMOUNT CASH PAYMENT (ARREAR)",null,null,{"$f":"IF(AT8=1,0,AS8-1)","v":"2019-03-04"},{"$f":"DAY(AS9)","v":4},{"$f":"MONTH(C17)","v":4},{"$f":"AT12-AT8+1","v":27},{"$nulls":3},{"v":0.07,"d":"7%"}]
[{"$nulls":8},"BASIC","DA","HRA","CCA","Other Allw.","TOTAL","BASIC","DA","HRA","CCA","Other Allw.","TOTAL","BASIC","DA","HRA","CCA","Other Allw.","TOTAL","TO BE  After Fix Pay","Before Fixation","DIFF.","TO BE  After Fix Pay","Before Fixation","DIFF.","TO BE  After Fix Pay","Before Fixation","DIFF.","TO BE  After Fix Pay","Before Fixation","DIFF.",{"$nulls":6},{"$f":"EOMONTH(AS8,-1)+1","v":"2019-03-01"},{"$f":"DAY(AS10)","v":1},{"$f":"MONTH(C18)","v":5},{"$nulls":4},{"v":0.08,"d":"8%"}]
[{"$nulls":9},{"v":0.12,"d":"12%"},{"v":0.08,"d":"8%"},null,"Cas.All.",null,null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},null,{"$f":"M11","v":"Cas.All."},{"$nulls":5},{"$f":"S11","v":"Cas.All."},{"$nulls":26},{"v":0.09,"d":"9%"}]
[null,1,{"$f":"U8","v":"2019-03-05"},{"$f":"IF(D14=AS10,\"------\",AS10)","v":"2019-03-01"},"to",{"$f":"MONTH(C12)","v":3},{"$f":"YEAR(C12)","v":2019},{"$f":"CONCATENATE(F12,G12)","v":"32019"},{"$f":"ROUND(O12/AT12*AT9,0)","v":3058},{"$f":"IF(P12=0,0,I12*J11)","v":0},{"$f":"IF(Q12=0,0,I12*K11)","v":0},0,0,{"$f":"SUM(I12:M12)","v":3058},23700,{"$f":"IF($F$2=\"Fix To Regular\",0,O12*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O12*$Q$11)","v":0},0,0,{"$f":"SUM(O12:S12)","v":23700},{"$f":"I16-O12","v":8797},{"$f":"J16-P12","v":5005},{"$f":"K16-Q12","v":2355},{"$f":"L16-R12","v":0},{"$f":"M16-S12","v":0},{"$f":"SUM(U12:Y16)","v":16157},{"$f":"IF($AA$9=\"nps\",ROUND((I16+J16)*0.1,0),$Z$2)","v":3750},{"$f":"IF($AA$9=\"nps\",ROUND((O12+P12)*0.1,0),$Z$2)","v":2370},{"$f":"AA12-AB12","v":1380},{"$f":"IF(BF12=\"SSM\",ROUND(I16/31*5,0),IF(BF12=\"SM\",ROUND(I16/31*3,0),IF(BF12=\"MM\",ROUND(I16/31*2,0),IF(BF12=\"FM\",ROUND(I16/31*1,0),IF(BF12=\"SSS\",ROUND(N16/31*2,0),IF(BF12=\"SS\",ROUND(N16/31,0),IF(BF12=\"MS\",ROUND(N16/31,0),IF(BF12=\"FS\",ROUND(N16/31*0,0),IF(BF12=\"SSO\",ROUND(N16/31*2,0),IF(BF12=\"SO\",ROUND(N16/31,0),IF(BF12=\"MO\",ROUND(N16/31,0),IF(BF12=\"FO\",ROUND(N16/31*0,0),0))))))))))))","v":0},{"$f":"IF(BF12=\"SSM\",ROUND(O12/31*5,0),IF(BF12=\"SM\",ROUND(O12/31*3,0),IF(BF12=\"MM\",ROUND(O12/31*2,0),IF(BF12=\"FM\",ROUND(O12/31*1,0),IF(BF12=\"SSS\",ROUND(T12/31*2,0),IF(BF12=\"SS\",ROUND(T12/31,0),IF(BF12=\"MS\",ROUND(T12/31,0),IF(BF12=\"FS\",ROUND(T12/31*0,0),IF(BF12=\"SSO\",ROUND(T12/31*2,0),IF(BF12=\"SO\",ROUND(T12/31,0),IF(BF12=\"MO\",ROUND(T12/31,0),IF(BF12=\"FO\",ROUND(T12/31*0,0),0))))))))))))","v":0},{"$f":"AD12-AE12","v":0},3000,3000,{"$f":"SUM(AG12-AH12)","v":0},0,{"$f":"AJ12","v":0},{"$f":"SUM(AJ12-AK12)","v":0},0,{"$f":"(Z12-AC12-AF12)*$U$2","v":{"v":738.85,"d":"739"}},{"$f":"AC12+AF12+AI12+AN12+AL12","v":{"v":2118.85,"d":"2119"}},{"$f":"Z12-AO12-AM12","v":{"v":14038.15,"d":"14038"}},null,null,{"$f":"EOMONTH(AS8,0)","v":"2019-03-31"},31,{"$nulls":5},{"v":0.1,"d":"10%"},null,null,{"$f":"IF($N$2=\"state service\",5,IF($N$2=\"subordinate\",3,IF($N$2=\"ministrial\",2,1)))","v":5},{"$f":"H12","v":"32019"},{"$f":"BC12+BD12","v":32024},{"$f":"IF(BE12=32025,\"SSM\",IF(BE12=32023,\"SM\",IF(BE12=32022,\"MM\",IF(BE12=32021,\"FM\",IF(BE12=92025,\"SSS\",IF(BE12=92023,\"SS\",IF(BE12=92022,\"MS\",IF(BE12=92021,\"FS\",IF(BE12=102025,\"SSO\",IF(BE12=102023,\"SO\",IF(BE12=102022,\"MO\",IF(BE12=102021,\"FO\",0))))))))))))","v":0}]
[{"$nulls":3},{"$f":"IF(D12=\"------\",\"------\",U8-1)","v":"2019-03-04"},null,{"$f":"F12","v":3},{"$f":"G12","v":2019},"32019",{"$nulls":43},{"v":0.11,"d":"11%"}]
[{"$nulls":3},{"$f":"U8","v":"2019-03-05"},"to",{"$f":"F13","v":3},{"$f":"G13","v":2019},"32019",{"$f":"ROUND(AU14/AT12*AV9,0)","v":29439},{"$f":"ROUND(I14*17/100,0)","v":5005},{"$f":"ROUND(I14*8/100,0)","v":2355},0,0,{"$f":"SUM(I14:M14)","v":36799},{"$nulls":30},"New Basic ↠",null,{"$f":"I17","v":33800},{"$nulls":4},{"v":0.12,"d":"12%"}]
[{"$nulls":3},{"$f":"AS12","v":"2019-03-31"},null,3,2019,"32019",{"$nulls":43},{"v":0.13,"d":"13%"}]
[{"$nulls":3},"Total",{"$f":"C12","v":"2019-03-05"},3,2019,"32019",{"$f":"I14+I12","v":32497},{"$f":"J14+J12","v":5005},{"$f":"K14+K12","v":2355},{"$f":"L14+L12","v":0},0,{"$f":"N14+N12","v":39857},{"$nulls":35},{"$f":"E16","v":"2019-03-05"},null,{"v":0.14,"d":"14%"}]
[null,{"$f":"IF(C17=0,0,B12+1)","v":2},{"$f":"IF(H16=$AO$8,0,AX17)","v":"2019-04-05"},null,null,{"$f":"MONTH(C17)","v":4},{"$f":"YEAR(C17)","v":2019},{"$f":"CONCATENATE(F17,G17)","v":"42019"},33800,{"$f":"ROUND(I17*17/100,0)","v":5746},{"$f":"ROUND(I17*8/100,0)","v":2704},0,0,{"$f":"SUM(I17:M17)","v":42250},{"$f":"IF(C17=0,0,O12)","v":23700},{"$f":"IF($F$2=\"Fix To Regular\",0,O17*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O17*$Q$11)","v":0},0,0,{"$f":"SUM(O17:S17)","v":23700},{"$f":"I17-O17","v":10100},{"$f":"J17-P17","v":5746},{"$f":"K17-Q17","v":2704},{"$f":"L17-R17","v":0},{"$f":"M17-S17","v":0},{"$f":"SUM(U17:Y17)","v":18550},{"$f":"IF($AA$9=\"nps\",ROUND((I17+J17)*0.1,0),$Z$2)","v":3955},{"$f":"IF($AA$9=\"nps\",ROUND((O17+P17)*0.1,0),$Z$2)","v":2370},{"$f":"AA17-AB17","v":1585},{"$f":"IF(BF17=\"SSM\",ROUND(I17/31*5,0),IF(BF17=\"SM\",ROUND(I17/31*3,0),IF(BF17=\"MM\",ROUND(I17/31*2,0),IF(BF17=\"FM\",ROUND(I17/31*1,0),IF(BF17=\"SSS\",ROUND(N17/31*2,0),IF(BF17=\"SS\",ROUND(N17/31,0),IF(BF17=\"MS\",ROUND(N17/31,0),IF(BF17=\"FS\",ROUND(N17/31*0,0),IF(BF17=\"SSO\",ROUND(N17/31*2,0),IF(BF17=\"SO\",ROUND(N17/31,0),IF(BF17=\"MO\",ROUND(N17/31,0),IF(BF17=\"FO\",ROUND(N17/31*0,0),0))))))))))))","v":0},{"$f":"IF(BF17=\"SSM\",ROUND(O17/31*5,0),IF(BF17=\"SM\",ROUND(O17/31*3,0),IF(BF17=\"MM\",ROUND(O17/31*2,0),IF(BF17=\"FM\",ROUND(O17/31*1,0),IF(BF17=\"SSS\",ROUND(T17/31*2,0),IF(BF17=\"SS\",ROUND(T17/31,0),IF(BF17=\"MS\",ROUND(T17/31,0),IF(BF17=\"FS\",ROUND(T17/31*0,0),IF(BF17=\"SSO\",ROUND(T17/31*2,0),IF(BF17=\"SO\",ROUND(T17/31,0),IF(BF17=\"MO\",ROUND(T17/31,0),IF(BF17=\"FO\",ROUND(T17/31*0,0),0))))))))))))","v":0},{"$f":"AD17-AE17","v":0},{"$f":"AG12","v":3000},{"$f":"AH12","v":3000},{"$f":"AI12","v":0},0,{"$f":"AJ17","v":0},{"$f":"AJ17-AK17","v":0},0,{"$f":"(Z17-AC17-AF17)*$U$2","v":{"v":848.25,"d":"848"}},{"$f":"AC17+AF17+AI17+AN17+AL17","v":{"v":2433.25,"d":"2433"}},{"$f":"Z17-AO17-AM12","v":{"v":16116.75,"d":"16117"}},{"$nulls":7},{"$f":"AX16+31","v":"2019-04-05"},null,{"v":0.15,"d":"15%"},null,null,{"$f":"IF($N$2=\"state service\",5,IF($N$2=\"subordinate\",3,IF($N$2=\"ministrial\",2,1)))","v":5},{"$f":"H17","v":"42019"},{"$f":"BC17+BD17","v":42024},{"$f":"IF(BE17=32025,\"SSM\",IF(BE17=32023,\"SM\",IF(BE17=32022,\"MM\",IF(BE17=32021,\"FM\",IF(BE17=92025,\"SSS\",IF(BE17=92023,\"SS\",IF(BE17=92022,\"MS\",IF(BE17=92021,\"FS\",IF(BE17=102025,\"SSO\",IF(BE17=102023,\"SO\",IF(BE17=102022,\"MO\",IF(BE17=102021,\"FO\",0))))))))))))","v":0}]
[null,{"$f":"IF(C18=0,0,B17+1)","v":3},{"$f":"IF(H17=$AO$8,0,IF(C17=0,0,AX18))","v":"2019-05-06"},null,null,{"$f":"MONTH(C18)","v":5},{"$f":"YEAR(C18)","v":2019},{"$f":"CONCATENATE(F18,G18)","v":"52019"},{"$f":"IF(C18=0,0,IF(F18=7,ROUND(I17*103%,-2),I17))","v":33800},{"$f":"ROUND(I18*17/100,0)","v":5746},2704,0,0,{"$f":"SUM(I18:M18)","v":42250},{"$f":"IF(C18=0,0,O17)","v":23700},{"$f":"IF($F$2=\"Fix To Regular\",0,O18*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O18*$Q$11)","v":0},0,0,{"$f":"SUM(O18:S18)","v":23700},{"$f":"I18-O18","v":10100},{"$f":"J18-P18","v":5746},{"$f":"K18-Q18","v":2704},{"$f":"L18-R18","v":0},{"$f":"M18-S18","v":0},{"$f":"SUM(U18:Y18)","v":18550},{"$f":"IF($AA$9=\"nps\",ROUND((I18+J18)*0.1,0),$Z$2)","v":3955},{"$f":"IF($AA$9=\"nps\",ROUND((O18+P18)*0.1,0),$Z$2)","v":2370},{"$f":"AA18-AB18","v":1585},{"$f":"IF(BF18=\"SSM\",ROUND(I18/31*5,0),IF(BF18=\"SM\",ROUND(I18/31*3,0),IF(BF18=\"MM\",ROUND(I18/31*2,0),IF(BF18=\"FM\",ROUND(I18/31*1,0),IF(BF18=\"SSS\",ROUND(N18/31*2,0),IF(BF18=\"SS\",ROUND(N18/31,0),IF(BF18=\"MS\",ROUND(N18/31,0),IF(BF18=\"FS\",ROUND(N18/31*0,0),IF(BF18=\"SSO\",ROUND(N18/31*2,0),IF(BF18=\"SO\",ROUND(N18/31,0),IF(BF18=\"MO\",ROUND(N18/31,0),IF(BF18=\"FO\",ROUND(N18/31*0,0),0))))))))))))","v":0},{"$f":"IF(BF18=\"SSM\",ROUND(O18/31*5,0),IF(BF18=\"SM\",ROUND(O18/31*3,0),IF(BF18=\"MM\",ROUND(O18/31*2,0),IF(BF18=\"FM\",ROUND(O18/31*1,0),IF(BF18=\"SSS\",ROUND(T18/31*2,0),IF(BF18=\"SS\",ROUND(T18/31,0),IF(BF18=\"MS\",ROUND(T18/31,0),IF(BF18=\"FS\",ROUND(T18/31*0,0),IF(BF18=\"SSO\",ROUND(T18/31*2,0),IF(BF18=\"SO\",ROUND(T18/31,0),IF(BF18=\"MO\",ROUND(T18/31,0),IF(BF18=\"FO\",ROUND(T18/31*0,0),0))))))))))))","v":0},0,{"$f":"IF(C18=0,0,AG17)","v":3000},{"$f":"IF(C18=0,0,AH17)","v":3000},{"$f":"AI15","v":0},0,{"$f":"AJ18","v":0},{"$f":"AJ18-AK18","v":0},0,{"$f":"(Z18-AC18-AF18)*$U$2","v":{"v":848.25,"d":"848"}},{"$f":"AC18+AF18+AI18+AN18+AL18","v":{"v":2433.25,"d":"2433"}},{"$f":"Z18-AO18-AM13","v":{"v":16116.75,"d":"16117"}},{"$nulls":7},{"$f":"AX17+31","v":"2019-05-06"},null,{"v":0.16,"d":"16%"},null,null,{"$f":"IF($N$2=\"state service\",5,IF($N$2=\"subordinate\",3,IF($N$2=\"ministrial\",2,1)))","v":5},{"$f":"H18","v":"52019"},{"$f":"BC18+BD18","v":52024},{"$f":"IF(BE18=32025,\"SSM\",IF(BE18=32023,\"SM\",IF(BE18=32022,\"MM\",IF(BE18=32021,\"FM\",IF(BE18=92025,\"SSS\",IF(BE18=92023,\"SS\",IF(BE18=92022,\"MS\",IF(BE18=92021,\"FS\",IF(BE18=102025,\"SSO\",IF(BE18=102023,\"SO\",IF(BE18=102022,\"MO\",IF(BE18=102021,\"FO\",0))))))))))))","v":0}]
[null,{"$f":"IF(C19=0,0,B18+1)","v":4},"2019-06-06",null,null,6,2019,"62019",{"$f":"IF(C19=0,0,IF(F19=7,ROUND(I18*103%,-2),I18))","v":33800},{"$f":"ROUND(I19*17/100,0)","v":5746},{"$f":"ROUND(I19*8/100,0)","v":2704},0,0,42250,{"$f":"IF(C19=0,0,O18)","v":23700},{"$f":"IF($F$2=\"Fix To Regular\",0,O19*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O19*$Q$11)","v":0},0,0,23700,{"$f":"I19-O19","v":10100},{"$f":"J19-P19","v":5746},{"$f":"K19-Q19","v":2704},{"$f":"L19-R19","v":0},{"$f":"M19-S19","v":0},{"$f":"SUM(U19:Y19)","v":18550},3955,2370,{"$f":"AA19-AB19","v":1585},0,0,{"$f":"AD19-AE19","v":0},{"$f":"IF(C19=0,0,AG18)","v":3000},{"$f":"IF(C19=0,0,AH18)","v":3000},{"$f":"AI16","v":0},0,0,0,0,{"v":848.25,"d":"848"},{"$f":"AC19+AF19+AI19+AN19+AL19","v":{"v":2433.25,"d":"2433"}},{"v":16116.75,"d":"16117"},{"$nulls":7},"2019-06-06",null,{"v":0.17,"d":"17%"},null,null,5,"62019",62024,0]
[null,5,"2019-07-07",null,null,7,2019,"72019",34800,5916,2784,0,0,43500,23700,{"$f":"IF($F$2=\"Fix To Regular\",0,O20*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O20*$Q$11)","v":0},0,0,23700,{"$f":"I20-O20","v":11100},{"$f":"J20-P20","v":5916},{"$f":"K20-Q20","v":2784},{"$f":"L20-R20","v":0},{"$f":"M20-S20","v":0},{"$f":"SUM(U20:Y20)","v":19800},4072,2370,{"$f":"AA20-AB20","v":1702},0,0,0,3000,3000,{"$f":"AI17","v":0},0,0,0,0,{"v":904.9000000000001,"d":"905"},{"$f":"AC20+AF20+AI20+AN20+AL20","v":{"v":2606.9,"d":"2607"}},{"v":17193.1,"d":"17193"},{"$nulls":7},"2019-07-07",null,{"v":0.18,"d":"18%"},null,null,5,"72019",72024,0]
[null,6,"2019-08-07",null,null,8,2019,"82019",{"$f":"IF(C21=0,0,IF(F21=7,ROUND(I20*103%,-2),I20))","v":34800},5916,2784,0,0,43500,23700,{"$f":"IF($F$2=\"Fix To Regular\",0,O21*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O21*$Q$11)","v":0},0,0,23700,{"$f":"I21-O21","v":11100},{"$f":"J21-P21","v":5916},{"$f":"K21-Q21","v":2784},{"$f":"L21-R21","v":0},{"$f":"M21-S21","v":0},{"$f":"SUM(U21:Y21)","v":19800},4072,2370,{"$f":"AA21-AB21","v":1702},0,0,0,3000,3000,{"$f":"AI18","v":0},0,0,0,0,{"v":904.9000000000001,"d":"905"},{"$f":"AC21+AF21+AI21+AN21+AL21","v":{"v":2606.9,"d":"2607"}},{"v":17193.1,"d":"17193"},{"$nulls":7},"2019-08-07",null,{"v":0.19,"d":"19%"},null,null,5,"82019",82024,0]
[null,7,"2019-09-07",null,null,9,2019,"92019",{"$f":"IF(C22=0,0,IF(F22=7,ROUND(I21*103%,-2),I21))","v":34800},5916,2784,0,0,43500,23700,{"$f":"IF($F$2=\"Fix To Regular\",0,O22*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O22*$Q$11)","v":0},0,0,23700,{"$f":"I22-O22","v":11100},{"$f":"J22-P22","v":5916},{"$f":"K22-Q22","v":2784},{"$f":"L22-R22","v":0},{"$f":"M22-S22","v":0},{"$f":"SUM(U22:Y22)","v":19800},4072,2370,{"$f":"AA22-AB22","v":1702},0,0,0,3000,3000,{"$f":"AI19","v":0},0,0,0,0,{"v":904.9000000000001,"d":"905"},{"$f":"AC22+AF22+AI22+AN22+AL22","v":{"v":2606.9,"d":"2607"}},{"v":17193.1,"d":"17193"},{"$nulls":7},"2019-09-07",null,{"v":0.2,"d":"20%"},null,null,5,"92019",92024,0]
[null,8,"2019-10-08",null,null,10,2019,"102019",34800,5916,2784,0,0,43500,23700,{"$f":"IF($F$2=\"Fix To Regular\",0,O23*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O23*$Q$11)","v":0},0,0,23700,{"$f":"I23-O23","v":11100},{"$f":"J23-P23","v":5916},{"$f":"K23-Q23","v":2784},{"$f":"L23-R23","v":0},{"$f":"M23-S23","v":0},{"$f":"SUM(U23:Y23)","v":19800},4072,2370,{"$f":"AA23-AB23","v":1702},0,0,0,3000,3000,{"$f":"AI20","v":0},0,0,0,0,{"v":904.9000000000001,"d":"905"},{"$f":"AC23+AF23+AI23+AN23+AL23","v":{"v":2606.9,"d":"2607"}},{"v":17193.1,"d":"17193"},{"$nulls":7},"2019-10-08",null,{"v":0.21,"d":"21%"},null,null,5,"102019",102024,0]
[null,9,"2019-11-08",null,null,11,2019,"112019",34800,5916,2784,0,0,43500,23700,{"$f":"IF($F$2=\"Fix To Regular\",0,O24*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O24*$Q$11)","v":0},0,0,23700,{"$f":"I24-O24","v":11100},{"$f":"J24-P24","v":5916},{"$f":"K24-Q24","v":2784},{"$f":"L24-R24","v":0},{"$f":"M24-S24","v":0},{"$f":"SUM(U24:Y24)","v":19800},4072,2370,{"$f":"AA24-AB24","v":1702},0,0,0,3000,3000,{"$f":"AI21","v":0},0,0,0,0,{"v":904.9000000000001,"d":"905"},{"$f":"AC24+AF24+AI24+AN24+AL24","v":{"v":2606.9,"d":"2607"}},{"v":17193.1,"d":"17193"},{"$nulls":7},"2019-11-08",null,{"v":0.22,"d":"22%"},null,null,5,"112019",112024,0]
[null,10,"2019-12-09",null,null,12,2019,"122019",34800,5916,2784,0,0,43500,23700,{"$f":"IF($F$2=\"Fix To Regular\",0,O25*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O25*$Q$11)","v":0},0,0,23700,{"$f":"I25-O25","v":11100},{"$f":"J25-P25","v":5916},{"$f":"K25-Q25","v":2784},{"$f":"L25-R25","v":0},{"$f":"M25-S25","v":0},{"$f":"SUM(U25:Y25)","v":19800},4072,2370,{"$f":"AA25-AB25","v":1702},0,0,0,3000,3000,{"$f":"AI22","v":0},0,0,0,0,{"v":904.9000000000001,"d":"905"},{"$f":"AC25+AF25+AI25+AN25+AL25","v":{"v":2606.9,"d":"2607"}},{"v":17193.1,"d":"17193"},{"$nulls":7},"2019-12-09",null,{"v":0.23,"d":"23%"},null,null,5,"122019",122024,0]
[null,11,"2020-01-09",null,null,1,2020,"12020",34800,5916,2784,0,0,43500,23700,{"$f":"IF($F$2=\"Fix To Regular\",0,O26*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O26*$Q$11)","v":0},0,0,23700,{"$f":"I26-O26","v":11100},{"$f":"J26-P26","v":5916},{"$f":"K26-Q26","v":2784},{"$f":"L26-R26","v":0},{"$f":"M26-S26","v":0},{"$f":"SUM(U26:Y26)","v":19800},4072,2370,{"$f":"AA26-AB26","v":1702},0,0,0,3000,3000,{"$f":"AI23","v":0},0,0,0,0,{"v":904.9000000000001,"d":"905"},{"$f":"AC26+AF26+AI26+AN26+AL26","v":{"v":2606.9,"d":"2607"}},{"v":17193.1,"d":"17193"},{"$nulls":7},"2020-01-09",null,{"v":0.24,"d":"24%"},null,null,5,"12020",12025,0]
[null,0,"00:00:00",null,null,1,1900,"11900",0,0,0,0,0,0,{"$f":"IF(C27=0,0,O26)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O27*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O27*$Q$11)","v":0},0,0,0,{"$f":"I27-O27","v":0},{"$f":"J27-P27","v":0},{"$f":"K27-Q27","v":0},{"$f":"L27-R27","v":0},{"$f":"M27-S27","v":0},{"$f":"SUM(U27:Y27)","v":0},0,0,{"$f":"AA27-AB27","v":0},0,0,0,0,0,{"$f":"AI24","v":0},0,0,0,0,0,{"$f":"AC27+AF27+AI27+AN27+AL27","v":0},0,{"$nulls":7},"2020-02-09",null,{"v":0.25,"d":"25%"},null,null,5,"11900",11905,0]
[null,0,"00:00:00",null,null,1,1900,"11900",0,0,0,0,0,0,0,{"$f":"IF($F$2=\"Fix To Regular\",0,O28*$P$11)","v":0},{"$f":"IF($F$2=\"Fix To Regular\",0,O28*$Q$11)","v":0},0,0,0,{"$f":"I28-O28","v":0},{"$f":"J28-P28","v":0},{"$f":"K28-Q28","v":0},{"$f":"L28-R28","v":0},{"$f":"M28-S28","v":0},{"$f":"SUM(U28:Y28)","v":0},0,0,{"$f":"AA28-AB28","v":0},0,0,0,0,0,{"$f":"AI25","v":0},0,0,0,0,0,{"$f":"AC28+AF28+AI28+AN28+AL28","v":0},0,{"$nulls":7},"2020-03-11",null,{"v":0.26,"d":"26%"},null,null,5,"11900",11905,0]
[null,"Total",{"$nulls":6},{"$f":"SUM(ROUND(I16:I28,0))","v":377497},{"$f":"SUM(ROUND(J16:J28,0))","v":63655},{"$f":"SUM(ROUND(K16:K28,0))","v":29955},null,null,{"$f":"SUM(ROUND(N16:N28,0))","v":471107},{"$f":"SUM(ROUND(O12:O28,0))","v":260700},{"$f":"SUM(ROUND(P12:P28,0))","v":0},{"$f":"SUM(ROUND(Q12:Q28,0))","v":0},null,null,{"$f":"SUM(ROUND(T12:T28,0))","v":260700},{"$f":"SUM(ROUND(U12:U28,0))","v":116797},{"$f":"SUM(ROUND(V12:V28,0))","v":63655},{"$f":"SUM(ROUND(W12:W28,0))","v":29955},null,null,{"$f":"SUM(ROUND(Z12:Z28,0))","v":210407},{"$f":"SUM(ROUND(AA12:AA28,0))","v":44119},{"$f":"SUM(ROUND(AB12:AB28,0))","v":26070},{"$f":"SUM(ROUND(AC12:AC28,0))","v":18049},{"$f":"SUM(ROUND(AD12:AD28,0))","v":0},{"$f":"SUM(ROUND(AE12:AE28,0))","v":0},{"$f":"SUM(ROUND(AF12:AF28,0))","v":0},{"$f":"SUM(ROUND(AG12:AG28,0))","v":33000},{"$f":"SUM(ROUND(AH12:AH28,0))","v":33000},{"$f":"SUM(ROUND(AI12:AI28,0))","v":0},{"$f":"SUM(ROUND(AJ12:AJ28,0))","v":0},{"$f":"SUM(ROUND(AK12:AK28,0))","v":0},{"$f":"SUM(ROUND(AL12:AL28,0))","v":0},{"$f":"SUM(ROUND(AM12:AM28,0))","v":0},{"$f":"SUM(ROUND(AN12:AN28,0))","v":9618},{"$f":"SUM(ROUND(AO12:AO28,0))","v":27667},{"$f":"SUM(ROUND(AP12:AP28,0))","v":182740},{"$nulls":9},{"v":0.27,"d":"27%"}]
[null,"Total Allowances And Deuctions Summry",{"$nulls":23},"Amount in words :-",{"$nulls":25},{"v":0.28,"d":"28%"}]
[null,"1-","Allowances (Difference)",{"$nulls":5},"Basic",{"$nulls":6},{"$f":"U29","v":116797},{"$nulls":9},{"$f":"SpellNumber(P42)","v":{"$error":"#NAME?"}},{"$nulls":25},{"v":0.29,"d":"29%"}]
[null,"2-",{"$nulls":6},"D.A.",{"$nulls":6},{"$f":"V29","v":63655},{"$nulls":35},{"v":0.3,"d":"30%"}]
[null,"3-",{"$nulls":6},"H.R.A.",{"$nulls":6},{"$f":"W29","v":29955},{"$nulls":35},{"v":0.31,"d":"31%"}]
[{"$nulls":8},"Total Allowances",{"$nulls":6},{"$f":"Z29","v":210407},{"$nulls":9},"हस्ताक्षर डीडीओ मय मुहर",{"$nulls":25},{"v":0.32,"d":"32%"}]
[null,"1-","Deductions",{"$nulls":5},"GPF/NPS",{"$nulls":6},{"$f":"AC29","v":18049},{"$nulls":35},{"v":0.33,"d":"33%"}]
[null,"2-",{"$nulls":6},"CM Corona Relief",{"$nulls":6},{"$f":"AF29","v":0},{"$nulls":35},{"v":0.34,"d":"34%"}]
[null,"3-",{"$nulls":6},"SI",{"$nulls":6},{"$f":"AI29","v":0},{"$nulls":35},{"v":0.35,"d":"35%"}]
[null,"4-",{"$nulls":6},"Income Tax",{"$nulls":6},{"$f":"AN29","v":9618},{"$nulls":35},{"v":0.36,"d":"36%"}]
[null,"5-",{"$nulls":6},"RPMF",{"$nulls":6},{"$f":"AL29","v":0}]
[{"$nulls":8},"Total Deductions",{"$nulls":6},{"$f":"AO29","v":27667},{"$nulls":35},{"v":0.37,"d":"37%"}]
[null,"ROP",{"$nulls":13},{"$f":"AM29","v":0},{"$nulls":35},{"v":0.38,"d":"38%"}]
[null,"NET AMOUNT TO BE PAY",{"$nulls":13},{"$f":"AP29","v":182740},{"$nulls":35},{"v":0.39,"d":"39%"}]
[{"$nulls":51},{"v":0.4,"d":"40%"}]
[{"$nulls":51},{"v":0.41,"d":"41%"}]
[{"$nulls":51},{"v":0.42,"d":"42%"}]
[{"$nulls":51},{"v":0.43,"d":"43%"}]
[{"$nulls":51},{"v":0.44,"d":"44%"}]
[{"$nulls":51},{"v":0.45,"d":"45%"}]
[{"$nulls":51},{"v":0.46,"d":"46%"}]
[{"$nulls":51},{"v":0.47,"d":"47%"}]
[{"$nulls":51},{"v":0.48,"d":"48%"}]
[{"$nulls":51},{"v":0.49,"d":"49%"}]
[{"$nulls":51},{"v":0.5,"d":"50%"}]
[{"$nulls":51},{"v":0.51,"d":"51%"}]
[{"$nulls":51},{"v":0.52,"d":"52%"}]
[{"$nulls":51},{"v":0.53,"d":"53%"}]
[{"$nulls":51},{"v":0.54,"d":"54%"}]
[{"$nulls":51},{"v":0.55,"d":"55%"}]
[{"$nulls":51},{"v":0.56,"d":"56%"}]
[{"$nulls":51},{"v":0.57,"d":"57%"}]
[{"$nulls":51},{"v":0.58,"d":"58%"}]
[{"$nulls":51},{"v":0.59,"d":"59%"}]
[{"$nulls":51},{"v":0.6,"d":"60%"}]
[{"$nulls":51},{"v":0.61,"d":"61%"}]
[{"$nulls":51},{"v":0.62,"d":"62%"}]
[{"$nulls":51},{"v":0.63,"d":"63%"}]
[{"$nulls":51},{"v":0.64,"d":"64%"}]
[{"$nulls":51},{"v":0.65,"d":"65%"}]
[{"$nulls":51},{"v":0.66,"d":"66%"}]
[{"$nulls":51},{"v":0.67,"d":"67%"}]
[{"$nulls":51},{"v":0.68,"d":"68%"}]
[{"$nulls":51},{"v":0.69,"d":"69%"}]
[{"$nulls":51},{"v":0.7,"d":"70%"}]
[{"$nulls":51},{"v":0.71,"d":"71%"}]
[{"$nulls":51},{"v":0.72,"d":"72%"}]
[{"$nulls":51},{"v":0.73,"d":"73%"}]
[{"$nulls":51},{"v":0.74,"d":"74%"}]
[{"$nulls":51},{"v":0.75,"d":"75%"}]
[{"$nulls":51},{"v":0.76,"d":"76%"}]
[{"$nulls":51},{"v":0.77,"d":"77%"}]
[{"$nulls":51},{"v":0.78,"d":"78%"}]
[{"$nulls":51},{"v":0.79,"d":"79%"}]
[{"$nulls":51},{"v":0.8,"d":"80%"}]
[{"$nulls":51},{"v":0.81,"d":"81%"}]
[{"$nulls":51},{"v":0.82,"d":"82%"}]
[{"$nulls":51},{"v":0.83,"d":"83%"}]
[{"$nulls":51},{"v":0.84,"d":"84%"}]
[{"$nulls":51},{"v":0.85,"d":"85%"}]
[{"$nulls":51},{"v":0.86,"d":"86%"}]
[{"$nulls":51},{"v":0.87,"d":"87%"}]
[{"$nulls":51},{"v":0.88,"d":"88%"}]
[{"$nulls":51},{"v":0.89,"d":"89%"}]
[{"$nulls":51},{"v":0.9,"d":"90%"}]
[{"$nulls":51},{"v":0.91,"d":"91%"}]
[{"$nulls":51},{"v":0.92,"d":"92%"}]
[{"$nulls":51},{"v":0.93,"d":"93%"}]
[{"$nulls":51},{"v":0.94,"d":"94%"}]
[{"$nulls":51},{"v":0.95,"d":"95%"}]
[{"$nulls":51},{"v":0.960000000000001,"d":"96%"}]
[{"$nulls":51},{"v":0.970000000000001,"d":"97%"}]
[{"$nulls":51},{"v":0.980000000000001,"d":"98%"}]
[{"$nulls":51},{"v":0.990000000000001,"d":"99%"}]
[{"$nulls":51},{"v":1,"d":"100%"}]
[{"$nulls":51},{"v":1.01,"d":"101%"}]
[{"$nulls":51},{"v":1.02,"d":"102%"}]
[{"$nulls":51},{"v":1.03,"d":"103%"}]
[{"$nulls":51},{"v":1.04,"d":"104%"}]
[{"$nulls":51},{"v":1.05,"d":"105%"}]
[{"$nulls":51},{"v":1.06,"d":"106%"}]
[{"$nulls":51},{"v":1.07,"d":"107%"}]
[{"$nulls":51},{"v":1.08,"d":"108%"}]
[{"$nulls":51},{"v":1.09,"d":"109%"}]
[{"$nulls":51},{"v":1.1,"d":"110%"}]
[{"$nulls":51},{"v":1.11,"d":"111%"}]
[{"$nulls":51},{"v":1.12,"d":"112%"}]
[{"$nulls":51},{"v":1.13,"d":"113%"}]
[{"$nulls":51},{"v":1.14,"d":"114%"}]
[{"$nulls":51},{"v":1.15,"d":"115%"}]
[{"$nulls":51},{"v":1.16,"d":"116%"}]
[{"$nulls":51},{"v":1.17,"d":"117%"}]
[{"$nulls":51},{"v":1.18,"d":"118%"}]
[{"$nulls":51},{"v":1.19,"d":"119%"}]
[{"$nulls":51},{"v":1.2,"d":"120%"}]
[{"$nulls":51},{"v":1.21,"d":"121%"}]
[{"$nulls":51},{"v":1.22,"d":"122%"}]
[{"$nulls":51},{"v":1.23,"d":"123%"}]
[{"$nulls":51},{"v":1.24,"d":"124%"}]
[{"$nulls":51},{"v":1.25,"d":"125%"}]
[{"$nulls":51},{"v":1.26,"d":"126%"}]
[{"$nulls":51},{"v":1.27,"d":"127%"}]
[{"$nulls":51},{"v":1.28,"d":"128%"}]
[{"$nulls":51},{"v":1.29,"d":"129%"}]
[{"$nulls":51},{"v":1.3,"d":"130%"}]
[{"$nulls":51},{"v":1.31,"d":"131%"}]
[{"$nulls":51},{"v":1.32,"d":"132%"}]
[{"$nulls":51},{"v":1.33,"d":"133%"}]
[{"$nulls":51},{"v":1.34,"d":"134%"}]
[{"$nulls":51},{"v":1.35,"d":"135%"}]
[{"$nulls":51},{"v":1.36,"d":"136%"}]
[{"$nulls":51},{"v":1.37,"d":"137%"}]
[{"$nulls":51},{"v":1.38,"d":"138%"}]
[{"$nulls":51},{"v":1.39,"d":"139%"}]
[{"$nulls":51},{"v":1.4,"d":"140%"}]
[{"$nulls":51},{"v":1.41,"d":"141%"}]
[{"$nulls":51},{"v":1.42,"d":"142%"}]
[{"$nulls":51},{"v":1.43,"d":"143%"}]
[{"$nulls":51},{"v":1.44,"d":"144%"}]
[{"$nulls":51},{"v":1.45,"d":"145%"}]
[{"$nulls":51},{"v":1.46,"d":"146%"}]
[{"$nulls":51},{"v":1.47,"d":"147%"}]
[{"$nulls":51},{"v":1.48,"d":"148%"}]
[{"$nulls":51},{"v":1.49,"d":"149%"}]
[{"$nulls":51},{"v":1.5,"d":"150%"}]
[{"$nulls":51},{"v":1.51,"d":"151%"}]
[{"$nulls":51},{"v":1.52,"d":"152%"}]
[{"$nulls":51},{"v":1.53,"d":"153%"}]
[{"$nulls":51},{"v":1.54,"d":"154%"}]
[{"$nulls":51},{"v":1.55,"d":"155%"}]
[{"$nulls":51},{"v":1.56,"d":"156%"}]
[{"$nulls":51},{"v":1.57,"d":"157%"}]
[{"$nulls":51},{"v":1.58,"d":"158%"}]
[{"$nulls":51},{"v":1.59,"d":"159%"}]
[{"$nulls":51},{"v":1.6,"d":"160%"}]
[{"$nulls":51},{"v":1.61,"d":"161%"}]
[{"$nulls":51},{"v":1.62,"d":"162%"}]
[{"$nulls":51},{"v":1.63,"d":"163%"}]
[{"$nulls":51},{"v":1.64,"d":"164%"}]
[{"$nulls":51},{"v":1.65,"d":"165%"}]
[{"$nulls":51},{"v":1.66,"d":"166%"}]
[{"$nulls":51},{"v":1.67,"d":"167%"}]
[{"$nulls":51},{"v":1.68,"d":"168%"}]
[{"$nulls":51},{"v":1.69,"d":"169%"}]
[{"$nulls":51},{"v":1.7,"d":"170%"}]
[{"$nulls":51},{"v":1.71,"d":"171%"}]
[{"$nulls":51},{"v":1.72,"d":"172%"}]
[{"$nulls":51},{"v":1.73,"d":"173%"}]
[{"$nulls":51},{"v":1.74,"d":"174%"}]
[{"$nulls":51},{"v":1.75,"d":"175%"}]
[{"$nulls":51},{"v":1.76,"d":"176%"}]
[{"$nulls":51},{"v":1.77,"d":"177%"}]
[{"$nulls":51},{"v":1.78,"d":"178%"}]
[{"$nulls":51},{"v":1.79,"d":"179%"}]
[{"$nulls":51},{"v":1.8,"d":"180%"}]
[{"$nulls":51},{"v":1.81,"d":"181%"}]
[{"$nulls":51},{"v":1.82,"d":"182%"}]
[{"$nulls":51},{"v":1.83,"d":"183%"}]
[{"$nulls":51},{"v":1.84,"d":"184%"}]
[{"$nulls":51},{"v":1.85,"d":"185%"}]
[{"$nulls":51},{"v":1.86,"d":"186%"}]
[{"$nulls":51},{"v":1.87,"d":"187%"}]
[{"$nulls":51},{"v":1.88,"d":"188%"}]
[{"$nulls":51},{"v":1.89,"d":"189%"}]
[{"$nulls":51},{"v":1.9,"d":"190%"}]
[{"$nulls":51},{"v":1.91,"d":"191%"}]
[{"$nulls":51},{"v":1.92,"d":"192%"}]
[{"$nulls":51},{"v":1.93,"d":"193%"}]
[{"$nulls":51},{"v":1.94,"d":"194%"}]
[{"$nulls":51},{"v":1.95,"d":"195%"}]
[{"$nulls":51},{"v":1.96,"d":"196%"}]
[{"$nulls":51},{"v":1.97,"d":"197%"}]
[{"$nulls":51},{"v":1.98,"d":"198%"}]
[{"$nulls":51},{"v":1.99,"d":"199%"}]
[{"$nulls":51},{"v":2,"d":"200%"}]