{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data","SalaryParticulars","Ascessment form","house rent reciept","Form 16(page1)","Form 16(page2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":2,"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":"Data","index":0,"n_rows":288,"n_cols":46,"rows_kept":288,"cut":false,"hidden":false,"merged":[[103,2,103,4],[94,2,94,3],[95,2,95,3],[98,2,98,3],[109,2,109,3],[101,2,101,3],[102,2,102,3],[99,2,99,3],[100,2,100,3],[6,29,6,32],[7,29,7,32],[8,29,8,32],[9,29,9,32],[10,29,10,32],[43,2,43,4],[72,2,72,3],[11,29,11,32],[12,29,12,32],[13,29,13,32],[14,29,14,32],[22,2,22,4],[11,2,11,3],[65,2,65,3],[50,2,50,3],[48,2,48,3],[49,2,49,3],[67,2,67,3],[64,2,64,4],[62,2,62,4],[83,2,83,3],[84,2,84,3],[85,2,85,3],[82,2,82,3],[76,2,76,4],[81,2,81,4],[75,2,75,3],[15,2,15,4],[29,2,29,3],[46,2,46,4],[71,2,71,3],[63,2,63,4],[47,2,47,3],[51,2,51,4],[36,2,36,4],[68,2,68,3],[66,2,66,3],[70,2,70,3],[26,2,26,3],[73,2,73,3],[69,2,69,3],[74,2,74,3],[204,33,204,34],[111,2,111,4],[107,2,107,3],[104,2,104,3],[106,2,106,3],[105,2,105,3],[113,1,113,33],[110,2,110,3],[108,2,108,3],[92,2,92,3],[97,2,97,3],[96,2,96,3],[86,2,86,3],[89,2,89,4],[88,2,88,3],[90,2,90,3],[93,2,93,3],[91,2,91,3],[87,2,87,3],[1,2,1,4],[7,2,10,2],[30,2,30,4],[28,2,28,3],[12,2,12,4],[4,2,4,3],[6,2,6,3],[14,2,14,3],[2,2,2,4],[18,2,18,4],[13,2,13,3],[25,2,25,4],[5,2,5,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-01"]
[null,null,"Income Tax 2015-16\ndesigned by Ch Nagendra Rao,SA(Maths), Cell : 9440297273",null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-01"]
[null,null,"1.We have to fill up the items in the Green colour boxes using  \"TAB\" button\n2.Fillup Employee ID NO, then click \"Submit\" button compulsory.Dates should be in the form of MM-DD-YYYY\n3.Read the fields carefully and click on \"Yes\" or \"No\" buttons which is applicable to you.\n4.At the end of this sheet please click \"Submit\" button compulsory\n5.In \"house rent receipt\" sheet;  Door No, place, Address should be noted manually.",null,null,null,null,2]
[null,1,"Employee ID NO (ID given by the Treasury ) :","0926013",null,null,null,3,"2015-03-01",{"$f":"IF(AND(I4>=SalaryParticulars!$AO$4,I4<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I4,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":16600},{"$f":"IF(I4=$V$1,77.896,IF(I4>=$G$22,$I$22,IF(I4>=$G$21,$I$21,IF(I4>=$F$21,$I$19,0))))","v":77.896000000000001},{"$f":"E24","v":12},{"$f":"IF(I4>=$F$22,$I$22,IF(I4>=$F$21,$I$21,$I$19))","v":8.9079999999999995}]
[null,null,"Name of the Teacher/Employee",null,"G.Venugopal",null,null,4,"2015-04-01",{"$f":"IF(AND(I5>=SalaryParticulars!$AO$4,I5<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I5,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":35120},{"$f":"IF(I5=$V$1,77.896,IF(I5>=$G$22,$I$22,IF(I5>=$G$21,$I$21,IF(I5>=$F$21,$I$19,0))))","v":8.9079999999999995},{"$f":"IF(I5>=$F$25,E25,L4)","v":14.5},8.9079999999999995,{"$f":"ROUND(J5*M5%,0)-ROUND(J5*K5%,0)","v":0},{"$f":"IF(I5>$K$22,(ROUND(J5*$I$22%,0)-ROUND(J5*$I$22%,0)),IF(I5>=$F$22,(ROUND(J5*$I$22%,0)-ROUND(J5*$I$21%,0)),IF(I5>$K$21,(ROUND(J5*$I$21%,0)-ROUND(J5*$I$21%,0)),(ROUND(J5*$I$21%,0)-ROUND(J5*$I$19%,0)))))","v":0},{"$f":"$I$21","v":8.9079999999999995},{"$f":"IF(I5>$E$21,$I$21,$I$19)","v":8.9079999999999995},{"$f":"ROUND(J5*P5%,0)-ROUND(J5*Q5%,0)","v":0},{"$f":"IF(I5>=$D$22,$I$22,0)","v":0},{"$f":"IF(I5>$E$22,$I$22,IF(I5>=$D$22,P5,0))","v":0},{"$f":"ROUND(J5*S5%,0)-ROUND(J5*T5%,0)","v":0}]
[null,null,"Design",null,"SGT",null,null,5,"2015-05-01",{"$f":"IF(AND(I6>=SalaryParticulars!$AO$4,I6<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I6,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":35120},8.9079999999999995,{"$f":"IF(I6>=$F$25,E26,L5)","v":0},8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,0,0,0]
[null,null,"Sex    (Male=M, Female=F)",null,"M",null,null,6,"2015-06-01",{"$f":"IF(AND(I7>=SalaryParticulars!$AO$4,I7<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I7,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":35120},8.9079999999999995,"Not Applicable",8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,0,0,0,null,null,null,null,null,null,"Medical Insurance premium U/S. 80-D ",null,"LIC Premium (Salary Deduction) per month"]
[null,null,"Official Address","School Name","MPP School",null,null,7,"2015-07-01",{"$f":"IF(AND(I8>=SalaryParticulars!$AO$4,I8<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I8,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":35120},8.9079999999999995,"above 40%",8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,8.9079999999999995,8.9079999999999995,0,null,null,null,null,null,null,"Treatment of Handicapped Dependent U/S.80-DD ",null,"LIC (Others) per year"]
[null,null,null,"Village","NN Colony, Dhone",null,null,8,"2015-08-01",{"$f":"IF(AND(I9>=SalaryParticulars!$AO$4,I9<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I9,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":36070},8.9079999999999995,15,8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,8.9079999999999995,8.9079999999999995,0,null,null,null,null,null,null,"Expenditure on Medical Treatment of Dependent U/S.80-DDB ",null,"Subscription to NSC VIII issue"]
[null,null,null,"Mandal","Mandal",null,null,9,"2015-09-01",{"$f":"IF(AND(I10>=SalaryParticulars!$AO$4,I10<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I10,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":36070},8.9079999999999995,42339,8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,8.9079999999999995,8.9079999999999995,0,null,null,null,null,null,null,"Interest Paid on Education Loan ( 80 E )",null,"Tuition fee for 2 children"]
[null,null,null,"District","Kurnool Dist",null,null,10,"2015-10-01",{"$f":"IF(AND(I11>=SalaryParticulars!$AO$4,I11<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I11,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":36070},8.9079999999999995,0,8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,8.9079999999999995,8.9079999999999995,0,null,null,null,null,null,null,"Donation to Charitable institution U/S.80-G",null,"Repayment of HBA installments. (Principle Amount)"]
[null,null,"PAN Number of the Teacher/ Employee",null,"AJVPG9142R",null,null,11,"2015-11-01",{"$f":"IF(AND(I12>=SalaryParticulars!$AO$4,I12<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I12,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":36070},8.9079999999999995,"TO\n(MM/DD/YYYY)",8.9079999999999995,0,{"$f":"IF(I12>$K$22,(ROUND(J12*$I$22%,0)-ROUND(J12*$I$22%,0)),IF(I12>=$F$22,(ROUND(J12*$I$22%,0)-ROUND(J12*$I$21%,0)),IF(I12>$K$21,(ROUND(J12*$I$21%,0)-ROUND(J12*$I$21%,0)),(ROUND(J12*$I$21%,0)-ROUND(J12*$I$19%,0)))))","v":0},8.9079999999999995,{"$f":"IF(I12>$E$21,$I$21,$I$19)","v":8.9079999999999995},0,8.9079999999999995,8.9079999999999995,0,null,null,null,null,null,null,"Maintenance of Totally Blind or P.H. U/S.80-U",null,"Premium towards any Annuty/Differed Annuty Plan"]
[null,2,"Pay Particulars",null,null,null,null,12,"2015-12-01",{"$f":"IF(AND(I13>=SalaryParticulars!$AO$4,I13<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I13,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":36070},8.9079999999999995,0,8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,8.9079999999999995,8.9079999999999995,0,null,null,null,null,null,null,null,null,"UTI Retirement Benefit Pension fund."]
[null,null,"PAY as on 1-3-2015    ( PRC 2010  PRC 2015)",null,16600,40,null,1,"2016-01-01",{"$f":"IF(AND(I14>=SalaryParticulars!$AO$4,I14<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I14,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":36070},8.9079999999999995,0,8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,8.9079999999999995,8.9079999999999995,0,null,null,null,null,null,null,null,null,"Investment in UTI's ULIP"]
[null,null,"PPs+FP",null,null,null,null,2,"2016-02-01",{"$f":"IF(AND(I15>=SalaryParticulars!$AO$4,I15<SalaryParticulars!$AI$2),Data!$F$39,LOOKUP(I15,SalaryParticulars!$AI$1:$AI$5,SalaryParticulars!$AJ$1:$AJ$5))","v":36070},8.9079999999999995,0,8.9079999999999995,0,0,8.9079999999999995,8.9079999999999995,0,8.9079999999999995,8.9079999999999995,0,null,null,null,null,null,null,"  i) Approved institutions 50% of qualifying amount.",null,"PLI per year"]
[null,null,"HMA / Spl Allowance for handling higher subjects",null,null,null,null,null,null,null,null,null,null,null,"ZPPF","Cash",null,null,null,null,null,null,null,null,null,null,null,null,null,"Public Provident fund"]
[null,null,"HMA / Spl Allowance for handling higher subjects as on","2015-03-01",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,"Approved Mutual Fund u/s 10(23D)"]
[null,null,"If HMA changes after 1-3-2015, date and HMA",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,"Investment in approved infrastructure bonds"]
[null,null,"DA",null,null,"2016-03-01",null,null,8.9079999999999995,null,null,null,null,{"$f":"SUM(R2:R15)","v":0},{"$f":"SUMIF(I2:I15,\"<=\"&K21,R2:R15)","v":0},{"$f":"N19-O19","v":0},null,null,null,null,null,null,null,null,null,null,null,"  ii) Kargil,National calmatives & PM/CM Relief fund (100%)",null,"Notified Fixed Deposit of any sheduled Bank/Housing Finance Cor. For not less than 5years."]
[null,null,"DA arrears taken ","From","DA arrears taken up to",null,null,"Starting",null,null,"ZPPF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount invested in 5year Post Office Time Deposite A/C"]
[null,null,"DA arrears ( 12.052% ) (Nil)","2015-01-01","2015-12-31",{"$f":"IF(D21<H21,F19,D21)","v":"2015-01-01"},{"$f":"IF(E21<=H21,F19,E21)","v":"2015-12-31"},"2015-01-01",8.9079999999999995,{"$f":"MONTH(G21)&\"/\"&DAY(G21)&\"/\"&YEAR(G21)","v":"12/31/2015"},"2015-11-30",null,null,{"$f":"SUM(U2:U15)","v":0},{"$f":"SUMIF(I2:I15,\"<=\"&K22,U2:U15)","v":0},{"$f":"N21-O21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Amount invested in the Senior Citizen Saving scheme, 2004"]
[null,null,"DA arrears taken ( 15.196% ) (Nil)","2015-07-01","2016-02-28",{"$f":"IF(D22<H22,F19,D22)","v":"2015-07-01"},{"$f":"IF(E22<=H22,F19,E22)","v":"2016-02-28"},"2015-07-01",8.9079999999999995,null,"2016-01-31"]
[null,null,"HRA"]
[null,null,"HRA as on ","2015-03-01",12,null,null,null,15.196]
[null,null,"If HRA changes after 1-3-2015, date and HRA %","2015-04-01",14.5,{"$f":"IF(AND(D25>D24,D25<F19),D25,F19)","v":"2015-04-01"}]
[null,null,"Other Allowances and SL"]
[null,null,"Whether CCA applicable",null,"Not Applicable"]
[null,null,"Whether PHC Allowance applicable, if yes % of disability","No","above 40%"]
[null,null,"No of ELs Surrendered during the year 2015-2016",null,15]
[null,null,"Surrender Leave Month",null,"2015-12-01"]
[null,3,"whether Loss of Pay or Half Pay Leave during this year"]
[null,null,"LEAVE TYPE","FROM\n(MM/DD/YYYY)","TO\n(MM/DD/YYYY)"]
[null,null,"Half Pay Leave",null,null,"2016-03-31",{"$f":"IF(D33<$I$4,$F$19,D33)","v":"2016-03-01"},{"$f":"IF(C33=\"Loss of Pay\",0,IF(C33=\"Half Pay Leave\",0.5,1))","v":0.5}]
[null,null,"Loss of Pay",null,null,null,{"$f":"IF(D34<$I$4,$F$19,D34)","v":"2016-03-01"},{"$f":"IF(C34=\"Loss of Pay\",0,IF(C34=\"Half Pay Leave\",0.5,1))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(D35<$I$4,$F$19,D35)","v":"2016-03-01"},{"$f":"IF(C35=\"Loss of Pay\",0,IF(C35=\"Half Pay Leave\",0.5,1))","v":1}]
[null,null,null,null,null,null,{"$f":"IF(D36<$I$4,$F$19,D36)","v":"2016-03-01"},{"$f":"IF(C36=\"Loss of Pay\",0,IF(C36=\"Half Pay Leave\",0.5,1))","v":1}]
[null,4,"Pay change, if any (after 1-1-2015 to 28-2-2016)\nPay changes time to time should be noted as shown below"]
[null,null,"Due to ","from (mm/dd/yyyy)","pay"]
[null,null,"Pay as on ","2015-03-01",{"$f":"E14","v":16600},{"$f":"LOOKUP(E39,E207:E286,G207:G286)","v":35120},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D39","v":"2015-03-01"}]
[null,null,"Annual Grade Increment","2015-08-01",{"$f":"AT40","v":36070},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D40<$U$39,$F$33+1,D40)","v":"2015-08-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable","2013-03-01",{"$f":"IF(C40=\"Not Applicable\",0,IF(C40=$G$77,LOOKUP(F39,$C$207:$C$287,$D$208:$D$288),LOOKUP(F39,$C$207:$C$287,$D$207:$D$287)))","v":36070}]
[null,null,"Not Applicable",null,{"$f":"AT41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D41<$U$39,$F$33+1,D41)","v":"2016-04-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable","2013-03-01",{"$f":"IF(C41=\"Not Applicable\",0,IF(C41=$G$77,LOOKUP(E40,$C$207:$C$287,$D$208:$D$288),LOOKUP(E40,$C$207:$C$287,$D$207:$D$287)))","v":0}]
[null,null,"Not Applicable",null,{"$f":"AT42","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D42<$U$39,$F$33+1,D42)","v":"2016-04-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable","2013-03-01",0]
[null,null,"Not Applicable",null,{"$f":"AT43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D43<$U$39,$F$33+1,D43)","v":"2016-04-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable","2013-03-01",0]
[null,5,"FOR HRA EXEMPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D25<$U$39,$F$33+1,D25)","v":"2015-04-01"}]
[null,null,"whether  you have  own house Property ",null,"Not Applicable"]
[null,null,"Rent Paid per month (if living in own house rent paid = 0)",{"$f":"\"Rs.\"&SalaryParticulars!A55&\" (Rent Suggested for max HRA exemption)\"","v":"Rs.9200 (Rent Suggested for max HRA exemption)"},7500]
[null,null,"Income from House Property (If you have own property) and Interests "]
[null,null,"Rent Received from the Property per year ( from 1-4-2013 to 31-3-2014 )"]
[null,null,"Municipal Taxes"]
[null,null,"Interest on Housing Loan "]
[null,null,"Income from other sources such as Interests on Savings A/C s etc."]
[null,6,"whether AAS or Promotion Arrears etc drawn during the year"]
[null,null,null,"AAS arrears","Promotion Arrears"]
[null,null,"PAY"]
[null,null,"DA"]
[null,null,"HRA"]
[null,null,"CA"]
[null,null,"CCA"]
[null,null,"IR"]
[null,null,"PT"]
[null,null,"ZPPF/GPF"]
[null,null,"CPS"]
[null,7,"DEDUCTIONS"]
[null,null,"Note : we can change the Deduction mode by selecting the required deduction under section 80C in the GREEN colour rows "]
[null,null,"DEDUCTIONS Under Chapter VI A..U/s. 80C"]
[null,null,"EHS Contribution per month",null,90]
[null,null,"LIC  per year"]
[null,null,"APGLI subscription per month",null,450]
[null,null,"GIS subscription per month",null,60]
[null,null,"PF",null,1500]
[null,null,"Tuition fee for 2 children",null,126000]
[null,null,"Repayment of HBA installments. (Principle Amount)"]
[null,null,"Public Provident fund",null,null,null,"Not Applicable"]
[null,null,"Amount invested in 5year Post Office Time Deposite A/C",null,null,null,"Annual Grade Increment"]
[null,null,"LIC Pension fund U/s. 80 CCC (Max. Rs. 10000) ",null,null,null,"Automatic Advancement Scheme (AAS)"]
[null,null,"Rajiv Gandhi Equity Savings Scheme (50% of amount invested  and is Max. up to Rs.25000/-) U/s 80CCG",null,null,null,"Promotion Pay fixation on Promotion date Under FR 22(a)(i)"]
[null,null,"Deductions change, if any",null,null,null,"Promotion Pay fixation Under FR 22(B) (2 Increments)"]
[null,null,"Deduction","from","Amount (rs)"]
[null,null,"APGLI"]
[null,null,"GIS"]
[null,null,"ZPPF/GPF"]
[null,8,"OTHER DEDUCTIONS UNDER CHAPTER VI A."]
[null,null,"Medical Insurance premium U/S. 80 D "]
[null,null,"Treatment of Handicapped Dependent U/S. 80 DD "]
[null,null,"Expenditure on Medical Treatment of Dependent U/S. 80 DDB "]
[null,null,"Interest Paid on Education Loan ( 80 E )",null,36800]
[null,null,"Donation to Charitable institution U/S. 80 G"]
[null,null,"Maintenance of Totally Blind or P.H. U/S. 80 U",null,{"$f":"IF(D28=\"No\",0,IF(E28=\"above 40%\",50000,100000))","v":0}]
[null,null,"Interest earned on Savings Bank Account  U/S. 80 TTA (Upto Rs.10000)"]
[null,9,"whether Income Tax already Paid if any"]
[null,null,"Month",null,"Tax Amount"]
[null,null,{"$f":"I4","v":"2015-03-01"}]
[null,null,{"$f":"I5","v":"2015-04-01"}]
[null,null,"2015-05-01"]
[null,null,"2015-06-01"]
[null,null,"2015-07-01"]
[null,null,"2015-08-01"]
[null,null,"2015-09-01"]
[null,null,"2015-10-01"]
[null,null,"2015-11-01"]
[null,null,"2015-12-01"]
[null,null,"2016-01-01"]
[null,null,"2016-02-01"]
[null,10,"DDOs Particulars"]
[null,null,"Name of Tax deductor (DDO)",null,"J.RAMACHANDRUDU"]
[null,null,"Father's Name of DDO"]
[null,null,"Designation of the DDO",null,"MEO, Dhone",{"$f":"D40","v":"2015-08-01"},{"$f":"E40","v":36070}]
[null,null,"Address of the DDO",null,"MEO, Dhone",{"$f":"IF(G108=G107,I15,D41)","v":"00:00:00"},{"$f":"E41","v":0}]
[null,null,"Pan No of the DDO",null,null,{"$f":"IF(G109=G108,I15,D42)","v":"2016-02-01"},{"$f":"E42","v":0}]
[null,null,"Tan No of the DDO",null,null,{"$f":"IF(G110=G109,I15,D43)","v":"2016-02-01"},{"$f":"E43","v":0}]
[null,null,"Total Tax payable  :",null,{"$f":"\"Rs.\"&'Ascessment form'!J48","v":"Rs.4180"}]
[null,null,"Note: 1)Medical Insurance premium U/S. 80-D \n(up to 15000/- or Rs.20000/- in case of senior citizen) \n2)Treatment of Handicapped Dependent U/S.80-DD  \n(Rs.50000 for above 40% disability (OR) Rs.100000 for above 80% disability) \n3)Expenditure on Medical Treatment for himself or Dependent U/S.80-DDB \n(Rs.40000 or Actual expenditure whichever is less (OR) Rs.60000 or actual expenditure whichever is less if the dependent is above 60 years of age) \n4)Maintenance of Totally Blind or P.H.C   U/S.80-U  \n(40% and above disability up to Rs.50000 & more than 80% disability up to Rs.100000  for self)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Pay in RPS 2010","Emo = Pay+ DA@63.344%+ Fitment@43%","Fix"]
[null,1,13000,13390,6700,13825,14170]
[null,2,13390,13780,6900,14238,14600]
[null,3,13780,14170,7100,14650,15030]
[null,4,14170,14600,7300,15063,15460]
[null,5,14600,15030,7520,15517,15930]
[null,6,15030,15460,7740,15971,16400]
[null,7,15460,15930,7960,16425,16870]
[null,8,15930,16400,8200,16920,17380]
[null,9,16400,16870,8440,17415,17890]
[null,10,16870,17380,8680,17910,18400]
[null,11,17380,17890,8940,18447,18950]
[null,12,17890,18400,9200,18984,19500]
[null,13,18400,18950,9460,19520,20050]
[null,14,18950,19500,9740,20098,20640]
[null,15,19500,20050,10020,20676,21230]
[null,16,20050,20640,10300,21253,21820]
[null,17,20640,21230,10600,21872,22460]
[null,18,21230,21820,10900,22491,23100]
[null,19,21820,22460,11200,23111,23740]
[null,20,22460,23100,11530,23792,24440]
[null,21,23100,23740,11860,24473,25140]
[null,22,23740,24440,12190,25154,25840]
[null,23,24440,25140,12550,25897,26600]
[null,24,25140,25840,12910,26639,27360]
[null,25,25840,26600,13270,27382,28120]
[null,26,26600,27360,13660,28187,28940]
[null,27,27360,28120,14050,28992,29760]
[null,28,28120,28940,14440,29796,30580]
[null,29,28940,29760,14860,30663,31460]
[null,30,29760,30580,15280,31529,32340]
[null,31,30580,31460,15700,32396,33220]
[null,32,31460,32340,16150,33325,34170]
[null,33,32340,33220,16600,34253,35120]
[null,34,33220,34170,17050,35182,36070]
[null,35,34170,35120,17540,36193,37100]
[null,36,35120,36070,18030,37204,38130]
[null,37,36070,37100,18520,38215,39160]
[null,38,37100,38130,19050,39309,40270]
[null,39,38130,39160,19580,40402,41380]
[null,40,39160,40270,20110,41495,42490]
[null,41,40270,41380,20680,42672,43680]
[null,42,41380,42490,21250,43849,44870]
[null,43,42490,43680,21820,45025,46060]
[null,44,43680,44870,22430,46283,47330]
[null,45,44870,46060,23040,47541,48600]
[null,46,46060,47330,23650,48801,49870]
[null,47,47330,48600,24300,50142,51230]
[null,48,48600,49870,24950,51483,52590]
[null,49,49870,51230,25600,52824,53950]
[null,50,51230,52590,26300,54268,55410]
[null,51,52590,53950,27000,55713,56870]
[null,52,53950,55410,27700,57157,58330]
[null,53,55410,56870,28450,58705,59890]
[null,54,56870,58330,29200,60252,61450]
[null,55,58330,59890,29950,61801,63010]
[null,56,59890,61450,30750,63451,64670]
[null,57,61450,63010,31550,65102,66330]
[null,58,63010,64670,32350,66753,67990]
[null,59,64670,66330,33200,68506,69750]
[null,60,66330,67990,34050,70261,71510]
[null,61,67990,69750,34900,72014,73270]
[null,62,69750,71510,35800,73871,75150]
[null,63,71510,73270,36700,75728,77030]
[null,64,73270,75150,37600,77585,78910]
[null,65,75150,77030,38570,79587,80930]
[null,66,77030,78910,39540,81588,82950]
[null,67,78910,80930,40510,83590,84970]
[null,68,80930,82950,41550,85736,87130]
[null,69,82950,84970,42590,87882,89290]
[null,70,84970,87130,43630,90028,91450]
[null,71,87130,89290,44740,92318,93780]
[null,72,89290,91450,45850,94609,96110]
[null,73,91450,93780,46960,96899,98440]
[null,74,93780,96110,48160,99375,100770]
[null,75,96110,98440,49360,101852,103290]
[null,76,98440,100770,50560,104328,105810]
[null,77,100770,103290,51760,106804,108330]
[null,78,103290,105810,53060,109486,110850]
[null,78,105810,108330,54360,112169,110850]
[null,78,108330,110850,55660,114851,110850]
[null,null,110850,110850]
[null,null,null,110850]

{"sheet":"SalaryParticulars","index":1,"n_rows":55,"n_cols":51,"rows_kept":55,"cut":false,"hidden":false,"merged":[[27,0,27,1],[4,0,4,1],[26,0,26,1],[20,0,20,1],[24,0,24,1],[25,0,25,1]]}
["Before You Print this sheet we should observe that whether all amounts and arrears are correct or not.\nAlso hide the unnecessary columns",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":"Data!U39","v":"2015-03-01"},1,{"$f":"SMALL($AD$1:$AD$5,AE1)","v":"2015-03-01"},null,{"$f":"IF(AF1<Data!I2,Data!F19,AF1)","v":"2015-03-01"},{"$f":"SMALL($AH$1:$AH$5,AE1)","v":"2015-03-01"},{"$f":"LOOKUP(AI1,Data!$U$39:$U$43,Data!$E$39:$E$43)","v":16600},{"$f":"IF(AJ1=0,0,IF(AJ1>18630,350,IF(AJ1>13270,220,IF(AJ1>8200,160,120))))","v":220}]
[null,null,null,null,null,null,{"$f":"CONCATENATE(Data!E8,\", \",Data!E9,\", \",Data!E10,\" MANDAL, \",Data!E11,\" DISTRICT\")","v":"MPP School, NN Colony, Dhone, Mandal MANDAL, Kurnool Dist DISTRICT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Data!U40","v":"2015-08-01"},2,{"$f":"SMALL($AD$1:$AD$5,AE2)","v":"2015-08-01"},null,{"$f":"IF(AF2<Data!$I$2,Data!$F$19,IF(AF2=AF1,Data!$F$19,AF2))","v":"2015-08-01"},{"$f":"SMALL($AH$1:$AH$5,AE2)","v":"2015-08-01"},{"$f":"LOOKUP(AI2,Data!U39:U43,Data!E39:E43)","v":36070},{"$f":"IF(AJ2=0,0,IF(AJ2>18630,350,IF(AJ2>13270,220,IF(AJ2>8200,160,120))))","v":350}]
[null,"DETAILS OF INCOME DURING THE FINANCIAL YEAR 2015-16 (Salaries of Mar-2015 to Feb-2016 (I.e.,  from  1.4.2015  to  31.3.2016))",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":"Data!U41","v":"2016-04-01"},3,{"$f":"SMALL($AD$1:$AD$5,AE3)","v":"2016-04-01"},null,{"$f":"IF(AF3<Data!$I$2,Data!$F$19,IF(AF3=AF2,Data!$F$19,AF3))","v":"2016-04-01"},{"$f":"SMALL($AH$1:$AH$5,AE3)","v":"2016-03-01"},{"$f":"LOOKUP(AI3,Data!U39:U43,Data!E39:E43)","v":36070},{"$f":"IF(AJ3=0,0,IF(AJ3>18630,350,IF(AJ3>13270,220,IF(AJ3>8200,160,120))))","v":350}]
[null,null,null,"Name :",null,null,{"$f":"Data!E5","v":"G.Venugopal"},null,null,null,null,null,null,null,null,null,null,"Designation:",null,{"$f":"Data!E6","v":"SGT"},null,null,null,null,null,null,null,null,null,{"$f":"Data!U42","v":"2016-04-01"},4,{"$f":"SMALL($AD$1:$AD$5,AE4)","v":"2016-04-01"},null,{"$f":"IF(AF4<Data!$I$2,Data!$F$19,IF(AF4=AF3,Data!$F$19,AF4))","v":"2016-03-01"},{"$f":"SMALL($AH$1:$AH$5,AE4)","v":"2016-03-01"},{"$f":"LOOKUP(AI4,Data!U39:U43,Data!E39:E43)","v":36070},{"$f":"IF(AJ4=0,0,IF(AJ4>18630,350,IF(AJ4>13270,220,IF(AJ4>8200,160,120))))","v":350},null,null,"2016-03-01","2015-04-01",77.896000000000001]
["Period",null,"No of days","Pay ","PP+FP","HMA","D.A.","H.R.A.","CCA","CA","IR","TOTAL","P.F","P.T","G.I.S","L.I.C","CPS","APGLI","EHS CONTRIBUTION","E.W.F/\nAFFDF","CMRF","Income Tax","TOTAL \nDEDUCTIONS",null,"CA",null,"2015-12-01",null,null,{"$f":"Data!U43","v":"2016-04-01"},5,{"$f":"SMALL($AD$1:$AD$5,AE5)","v":"2016-04-01"},null,{"$f":"IF(AF5<Data!$I$2,Data!$F$19,IF(AF5=AF4,Data!$F$19,AF5))","v":"2016-03-01"},{"$f":"SMALL($AH$1:$AH$5,AE5)","v":"2016-04-01"},{"$f":"LOOKUP(AI5,Data!U39:U43,Data!E39:E43)","v":0},{"$f":"IF(AJ5=0,0,IF(AJ5>18630,350,IF(AJ5>13270,220,IF(AJ5>8200,160,120))))","v":0},null,null,"Pay","PP+FP","DA","HRA",null,"DA","HRA","CCA","Gr Hyd","Gr VSP","Vja","Others"]
[{"$f":"SalaryParticulars!AH6","v":"2015-03-01"},{"$f":"SalaryParticulars!AI6","v":"2015-03-31"},{"$f":"SalaryParticulars!AK6","v":31},{"$f":"ROUND(AN6*AK6/AJ6,0)","v":16600},{"$f":"ROUND(SalaryParticulars!AO6*SalaryParticulars!AK6/SalaryParticulars!AJ6,0)","v":0},{"$f":"Data!E17","v":0},{"$f":"ROUND(D6*AP4%,0)","v":12931},{"$f":"ROUND(D6*SalaryParticulars!AR6%,0)","v":1992},{"$f":"ROUND(SalaryParticulars!AU6*SalaryParticulars!AK6/SalaryParticulars!AJ6,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A6>=$AA$5,1350,900)*SalaryParticulars!AK6/SalaryParticulars!AJ6,0),0)","v":0},{"$f":"IF(A6<Data!V2,ROUND(SalaryParticulars!D6*27%,0),ROUND(D6*0%,0))","v":4482},{"$f":"SUM(D6:K6)","v":36005},{"$f":"IF(C6>=X6/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A6>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C6>=X6/2,IF(L6>20000,200,IF(L6>15000,150,IF(L6>10000,100,IF(L6>5000,80,0)))),0))","v":200},{"$f":"IF(C6>=X6/2,IF(Data!$E$80>0,IF(A6>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D6+SalaryParticulars!G6)*10%,0),0)","v":0},{"$f":"IF(C6>=X6/2,IF(Data!$E$79>0,IF(SalaryParticulars!A6>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C6>=X6/2,IF(A6>=$AA$6,Data!$E$66,0),0)","v":90},{"$f":"IF(C6>=X6/2,IF(OR(MONTH(A6)=3,MONTH(A6)=12),20,0),0)","v":20},0,{"$f":"IF(C6>=X6/2,LOOKUP(A6,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},{"$f":"SUM(M6:V6)","v":2320},{"$f":"SalaryParticulars!AJ6","v":31},{"$f":"IF(J6>800,800,J6)","v":0},null,"2014-11-01",null,null,"2015-03-01",{"$f":"SMALL($AD$6:$AD$27,AC14)","v":"00:00:00"},{"$f":"IF(AE6<Data!$I$2,Data!$F$19,IF(AE6<$AD$6,Data!$F$19,AE6))","v":"2016-03-01"},{"$f":"SMALL($AF$6:$AF$27,AC14)","v":"2015-03-01"},{"$f":"AG6","v":"2015-03-01"},{"$f":"AH7-1","v":"2015-03-31"},{"$f":"DAY(DATE(YEAR(AH6),MONTH(AH6)+1,1)-1)","v":31},{"$f":"AI6-AH6+1","v":31},{"$f":"IF(AND(AH6>=$AO$4,AH6<$AI$2),Data!$F$39,LOOKUP(AH6,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":16600},{"$f":"IF(AH6=Data!$G$33,Data!$H$33,IF(AH6=Data!$G$34,Data!$H$34,IF(AH6=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},{"$f":"IF(AH6>=$AN$4,0,ROUND(AL6*AM6,0))","v":16600},{"$f":"IF(AN6>0,ROUND(Data!$E$15*AK6*AM6/AK6,0),0)","v":0},{"$f":"IF(AH6>=Data!$G$22,Data!$I$22,IF(AH6>=Data!$G$21,Data!$I$21,IF(AH6>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI6>=Data!$D$25,Data!$E$25,Data!$E$24))","v":12},{"$f":"IF(AM6=0.5,AQ6*2,AQ6)","v":12},{"$f":"ROUND(AN6*AP6%*AK6/AJ6,0)","v":1479},{"$f":"ROUND(AN6*AQ6%*AK6/AJ6,0)","v":1992},{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV6,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW6,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX6,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY6,0))))","v":0},{"$f":"IF(AN6=0,0,IF(AN6>18030,525,IF(AN6>13270,350,IF(AN6>8200,300,200))))","v":350},{"$f":"IF(AN6=0,0,IF(AN6>18030,350,IF(AN6>13270,220,IF(AN6>8200,160,120))))","v":220},{"$f":"IF(AN6=0,0,IF(AN6>18030,350,IF(AN6>13270,220,IF(AN6>8200,160,120))))","v":220},{"$f":"IF(AN6=0,0,IF(AN6>18030,140,IF(AN6>13270,130,IF(AN6>8200,120,100))))","v":130}]
[{"$f":"SalaryParticulars!AH7","v":"2015-04-01"},{"$f":"SalaryParticulars!AI7","v":"2015-04-30"},{"$f":"SalaryParticulars!AK7","v":30},35120,{"$f":"ROUND(SalaryParticulars!AO7*SalaryParticulars!AK7/SalaryParticulars!AJ7,0)","v":0},{"$f":"IF(D7>0,IF(A7>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D7*SalaryParticulars!AP7%,0)","v":3128},{"$f":"ROUND(D7*SalaryParticulars!AR7%,0)","v":5092},{"$f":"ROUND(SalaryParticulars!AU7*SalaryParticulars!AK7/SalaryParticulars!AJ7,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A7>=$AA$5,1350,900)*SalaryParticulars!AK7/SalaryParticulars!AJ7,0),0)","v":0},{"$f":"ROUND(D7*0%,0)","v":0},43340,{"$f":"IF(C7>=X7/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A7>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C7>=X7/2,IF(L7>20000,200,IF(L7>15000,150,IF(L7>10000,100,IF(L7>5000,80,0)))),0))","v":200},{"$f":"IF(C7>=X7/2,IF(Data!$E$80>0,IF(A7>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D7+SalaryParticulars!G7)*10%,0),0)","v":0},{"$f":"IF(C7>=X7/2,IF(Data!$E$79>0,IF(SalaryParticulars!A7>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C7>=X7/2,IF(A7>=$AA$6,Data!$E$66,0),0)","v":90},0,0,{"$f":"IF(C7>=X7/2,LOOKUP(A7,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},{"$f":"SUM(M7:V7)","v":2300},{"$f":"SalaryParticulars!AJ7","v":30},{"$f":"IF(J7>800,800,J7)","v":0},null,null,null,null,"2015-04-01",{"$f":"SMALL($AD$6:$AD$27,AC15)","v":"1900-01-01"},{"$f":"IF(IF(AE7<Data!$I$2,Data!$F$19,IF(AE7<$AD$6,Data!$F$19,AE7))=AF6,Data!$F$19,IF(AE7<Data!$I$2,Data!$F$19,IF(AE7<$AD$6,Data!$F$19,AE7)))","v":"2016-03-01"},{"$f":"SMALL($AF$6:$AF$27,AC15)","v":"2015-04-01"},{"$f":"IF(AG7=AH6,AG8,AG7)","v":"2015-04-01"},"2015-04-30",30,30,{"$f":"IF(AND(AH7>=$AO$4,AH7<$AI$2),Data!$F$39,LOOKUP(AH7,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":35120},{"$f":"IF(AH7=Data!$G$33,Data!$H$33,IF(AH7=Data!$G$34,Data!$H$34,IF(AH7=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},{"$f":"IF(AH7>=$AN$4,0,ROUND(AL7*AM7,0))","v":35120},{"$f":"IF(AN7>0,ROUND(Data!$E$15*AK7*AM7/AK7,0),0)","v":0},{"$f":"IF(AH7>=Data!$G$22,Data!$I$22,IF(AH7>=Data!$G$21,Data!$I$21,IF(AH7>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI7>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},{"$f":"IF(AM7=0.5,AQ7*2,AQ7)","v":14.5},3128,5092,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV7,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW7,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX7,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY7,0))))","v":0},{"$f":"IF(AN7=0,0,IF(AN7>18030,525,IF(AN7>13270,350,IF(AN7>8200,300,200))))","v":525},{"$f":"IF(AN7=0,0,IF(AN7>18030,350,IF(AN7>13270,220,IF(AN7>8200,160,120))))","v":350},{"$f":"IF(AN7=0,0,IF(AN7>18030,350,IF(AN7>13270,220,IF(AN7>8200,160,120))))","v":350},{"$f":"IF(AN7=0,0,IF(AN7>18030,140,IF(AN7>13270,130,IF(AN7>8200,120,100))))","v":140}]
[{"$f":"SalaryParticulars!AH8","v":"2015-05-01"},{"$f":"SalaryParticulars!AI8","v":"2015-05-31"},{"$f":"SalaryParticulars!AK8","v":31},35120,{"$f":"ROUND(SalaryParticulars!AO8*SalaryParticulars!AK8/SalaryParticulars!AJ8,0)","v":0},{"$f":"IF(D8>0,IF(A8>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D8*SalaryParticulars!AP8%,0)","v":3128},{"$f":"ROUND(D8*SalaryParticulars!AR8%,0)","v":5092},{"$f":"ROUND(SalaryParticulars!AU8*SalaryParticulars!AK8/SalaryParticulars!AJ8,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A8>=$AA$5,1350,900)*SalaryParticulars!AK8/SalaryParticulars!AJ8,0),0)","v":0},0,43340,{"$f":"IF(C8>=X8/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A8>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C8>=X8/2,IF(L8>20000,200,IF(L8>15000,150,IF(L8>10000,100,IF(L8>5000,80,0)))),0))","v":200},{"$f":"IF(C8>=X8/2,IF(Data!$E$80>0,IF(A8>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D8+SalaryParticulars!G8)*10%,0),0)","v":0},{"$f":"IF(C8>=X8/2,IF(Data!$E$79>0,IF(SalaryParticulars!A8>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C8>=X8/2,IF(A8>=$AA$6,Data!$E$66,0),0)","v":90},0,0,{"$f":"IF(C8>=X8/2,LOOKUP(A8,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ8","v":31},0,{"$f":"MONTH(A8)","v":5},{"$f":"YEAR(A8)","v":2015},null,null,"2015-05-01","1900-01-01",{"$f":"IF(IF(AE8<Data!$I$2,Data!$F$19,IF(AE8<$AD$6,Data!$F$19,AE8))=AF7,Data!$F$19,IF(AE8<Data!$I$2,Data!$F$19,IF(AE8<$AD$6,Data!$F$19,AE8)))","v":"2016-03-01"},"2015-05-01",{"$f":"IF(AG8=AH7,AG9,AG8)","v":"2015-05-01"},"2015-05-31",31,31,{"$f":"IF(AND(AH8>=$AO$4,AH8<$AI$2),Data!$F$39,LOOKUP(AH8,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":35120},{"$f":"IF(AH8=Data!$G$33,Data!$H$33,IF(AH8=Data!$G$34,Data!$H$34,IF(AH8=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},35120,{"$f":"IF(AN8>0,ROUND(Data!$E$15*AK8*AM8/AK8,0),0)","v":0},{"$f":"IF(AH8>=Data!$G$22,Data!$I$22,IF(AH8>=Data!$G$21,Data!$I$21,IF(AH8>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI8>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3128,5092,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV8,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW8,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX8,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY8,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH9","v":"2015-06-01"},{"$f":"SalaryParticulars!AI9","v":"2015-06-30"},{"$f":"SalaryParticulars!AK9","v":30},35120,{"$f":"ROUND(SalaryParticulars!AO9*SalaryParticulars!AK9/SalaryParticulars!AJ9,0)","v":0},{"$f":"IF(D9>0,IF(A9>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D9*SalaryParticulars!AP9%,0)","v":3128},{"$f":"ROUND(D9*SalaryParticulars!AR9%,0)","v":5092},{"$f":"ROUND(SalaryParticulars!AU9*SalaryParticulars!AK9/SalaryParticulars!AJ9,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A9>=$AA$5,1350,900)*SalaryParticulars!AK9/SalaryParticulars!AJ9,0),0)","v":0},0,43340,{"$f":"IF(C9>=X9/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A9>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C9>=X9/2,IF(L9>20000,200,IF(L9>15000,150,IF(L9>10000,100,IF(L9>5000,80,0)))),0))","v":200},{"$f":"IF(C9>=X9/2,IF(Data!$E$80>0,IF(A9>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D9+SalaryParticulars!G9)*10%,0),0)","v":0},{"$f":"IF(C9>=X9/2,IF(Data!$E$79>0,IF(SalaryParticulars!A9>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C9>=X9/2,IF(A9>=$AA$6,Data!$E$66,0),0)","v":90},0,0,{"$f":"IF(C9>=X9/2,LOOKUP(A9,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ9","v":30},0,{"$f":"MONTH(A9)","v":6},{"$f":"YEAR(A9)","v":2015},null,null,"2015-06-01","1900-01-01",{"$f":"IF(IF(AE9<Data!$I$2,Data!$F$19,IF(AE9<$AD$6,Data!$F$19,AE9))=AF8,Data!$F$19,IF(AE9<Data!$I$2,Data!$F$19,IF(AE9<$AD$6,Data!$F$19,AE9)))","v":"2016-03-01"},"2015-06-01","2015-06-01","2015-06-30",30,30,{"$f":"IF(AND(AH9>=$AO$4,AH9<$AI$2),Data!$F$39,LOOKUP(AH9,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":35120},{"$f":"IF(AH9=Data!$G$33,Data!$H$33,IF(AH9=Data!$G$34,Data!$H$34,IF(AH9=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},35120,{"$f":"IF(AN9>0,ROUND(Data!$E$15*AK9*AM9/AK9,0),0)","v":0},{"$f":"IF(AH9>=Data!$G$22,Data!$I$22,IF(AH9>=Data!$G$21,Data!$I$21,IF(AH9>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI9>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3128,5092,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV9,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW9,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX9,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY9,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH10","v":"2015-07-01"},{"$f":"SalaryParticulars!AI10","v":"2015-07-31"},{"$f":"SalaryParticulars!AK10","v":31},35120,{"$f":"ROUND(SalaryParticulars!AO10*SalaryParticulars!AK10/SalaryParticulars!AJ10,0)","v":0},{"$f":"IF(D10>0,IF(A10>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D10*SalaryParticulars!AP10%,0)","v":3128},{"$f":"ROUND(D10*SalaryParticulars!AR10%,0)","v":5092},{"$f":"ROUND(SalaryParticulars!AU10*SalaryParticulars!AK10/SalaryParticulars!AJ10,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A10>=$AA$5,1350,900)*SalaryParticulars!AK10/SalaryParticulars!AJ10,0),0)","v":0},0,43340,{"$f":"IF(C10>=X10/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A10>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C10>=X10/2,IF(L10>20000,200,IF(L10>15000,150,IF(L10>10000,100,IF(L10>5000,80,0)))),0))","v":200},{"$f":"IF(C10>=X10/2,IF(Data!$E$80>0,IF(A10>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D10+SalaryParticulars!G10)*10%,0),0)","v":0},{"$f":"IF(C10>=X10/2,IF(Data!$E$79>0,IF(SalaryParticulars!A10>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C10>=X10/2,IF(A10>=$AA$6,Data!$E$66,0),0)","v":90},0,{"$f":"IF(AND(Z10=8,AA10=2014),ROUND(D10*1/31,0),0)","v":0},{"$f":"IF(C10>=X10/2,LOOKUP(A10,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ10","v":31},0,7,2015,null,null,"2015-07-01","2015-03-01",{"$f":"IF(IF(AE10<Data!$I$2,Data!$F$19,IF(AE10<$AD$6,Data!$F$19,AE10))=AF9,Data!$F$19,IF(AE10<Data!$I$2,Data!$F$19,IF(AE10<$AD$6,Data!$F$19,AE10)))","v":"2015-03-01"},"2015-07-01","2015-07-01","2015-07-31",31,31,{"$f":"IF(AND(AH10>=$AO$4,AH10<$AI$2),Data!$F$39,LOOKUP(AH10,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":35120},{"$f":"IF(AH10=Data!$G$33,Data!$H$33,IF(AH10=Data!$G$34,Data!$H$34,IF(AH10=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},35120,{"$f":"IF(AN10>0,ROUND(Data!$E$15*AK10*AM10/AK10,0),0)","v":0},{"$f":"IF(AH10>=Data!$G$22,Data!$I$22,IF(AH10>=Data!$G$21,Data!$I$21,IF(AH10>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI10>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3128,5092,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV10,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW10,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX10,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY10,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH11","v":"2015-08-01"},{"$f":"SalaryParticulars!AI11","v":"2015-08-31"},{"$f":"SalaryParticulars!AK11","v":31},36070,{"$f":"ROUND(SalaryParticulars!AO11*SalaryParticulars!AK11/SalaryParticulars!AJ11,0)","v":0},{"$f":"IF(D11>0,IF(A11>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D11*SalaryParticulars!AP11%,0)","v":3213},{"$f":"ROUND(D11*SalaryParticulars!AR11%,0)","v":5230},{"$f":"ROUND(SalaryParticulars!AU11*SalaryParticulars!AK11/SalaryParticulars!AJ11,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A11>=$AA$5,1350,900)*SalaryParticulars!AK11/SalaryParticulars!AJ11,0),0)","v":0},0,44513,{"$f":"IF(C11>=X11/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A11>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C11>=X11/2,IF(L11>20000,200,IF(L11>15000,150,IF(L11>10000,100,IF(L11>5000,80,0)))),0))","v":200},{"$f":"IF(C11>=X11/2,IF(Data!$E$80>0,IF(A11>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D11+SalaryParticulars!G11)*10%,0),0)","v":0},{"$f":"IF(C11>=X11/2,IF(Data!$E$79>0,IF(SalaryParticulars!A11>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C11>=X11/2,IF(A11>=$AA$6,Data!$E$66,0),0)","v":90},0,{"$f":"IF(AND(Z11=8,AA11=2014),ROUND(D11*1/31,0),0)","v":0},{"$f":"IF(C11>=X11/2,LOOKUP(A11,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ11","v":31},0,8,2015,null,null,"2015-08-01","2015-03-01",{"$f":"IF(IF(AE11<Data!$I$2,Data!$F$19,IF(AE11<$AD$6,Data!$F$19,AE11))=AF10,Data!$F$19,IF(AE11<Data!$I$2,Data!$F$19,IF(AE11<$AD$6,Data!$F$19,AE11)))","v":"2016-03-01"},"2015-08-01","2015-08-01","2015-08-31",31,31,{"$f":"IF(AND(AH11>=$AO$4,AH11<$AI$2),Data!$F$39,LOOKUP(AH11,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH11=Data!$G$33,Data!$H$33,IF(AH11=Data!$G$34,Data!$H$34,IF(AH11=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},36070,{"$f":"IF(AN11>0,ROUND(Data!$E$15*AK11*AM11/AK11,0),0)","v":0},{"$f":"IF(AH11>=Data!$G$22,Data!$I$22,IF(AH11>=Data!$G$21,Data!$I$21,IF(AH11>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI11>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3213,5230,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV11,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW11,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX11,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY11,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH12","v":"2015-09-01"},{"$f":"SalaryParticulars!AI12","v":"2015-09-30"},{"$f":"SalaryParticulars!AK12","v":30},36070,{"$f":"ROUND(SalaryParticulars!AO12*SalaryParticulars!AK12/SalaryParticulars!AJ12,0)","v":0},{"$f":"IF(D12>0,IF(A12>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D12*SalaryParticulars!AP12%,0)","v":3213},{"$f":"ROUND(D12*SalaryParticulars!AR12%,0)","v":5230},{"$f":"ROUND(SalaryParticulars!AU12*SalaryParticulars!AK12/SalaryParticulars!AJ12,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A12>=$AA$5,1350,900)*SalaryParticulars!AK12/SalaryParticulars!AJ12,0),0)","v":0},0,44513,{"$f":"IF(C12>=X12/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A12>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C12>=X12/2,IF(L12>20000,200,IF(L12>15000,150,IF(L12>10000,100,IF(L12>5000,80,0)))),0))","v":200},{"$f":"IF(C12>=X12/2,IF(Data!$E$80>0,IF(A12>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D12+SalaryParticulars!G12)*10%,0),0)","v":0},{"$f":"IF(C12>=X12/2,IF(Data!$E$79>0,IF(SalaryParticulars!A12>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C12>=X12/2,IF(A12>=$AA$6,Data!$E$66,0),0)","v":90},0,0,{"$f":"IF(C12>=X12/2,LOOKUP(A12,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ12","v":30},0,{"$f":"MONTH(A12)","v":9},{"$f":"YEAR(A12)","v":2015},null,null,"2015-09-01","2015-04-01",{"$f":"IF(IF(AE12<Data!$I$2,Data!$F$19,IF(AE12<$AD$6,Data!$F$19,AE12))=AF11,Data!$F$19,IF(AE12<Data!$I$2,Data!$F$19,IF(AE12<$AD$6,Data!$F$19,AE12)))","v":"2015-04-01"},"2015-09-01","2015-09-01","2015-09-30",30,30,{"$f":"IF(AND(AH12>=$AO$4,AH12<$AI$2),Data!$F$39,LOOKUP(AH12,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH12=Data!$G$33,Data!$H$33,IF(AH12=Data!$G$34,Data!$H$34,IF(AH12=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},36070,{"$f":"IF(AN12>0,ROUND(Data!$E$15*AK12*AM12/AK12,0),0)","v":0},{"$f":"IF(AH12>=Data!$G$22,Data!$I$22,IF(AH12>=Data!$G$21,Data!$I$21,IF(AH12>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI12>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3213,5230,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV12,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW12,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX12,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY12,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH13","v":"2015-10-01"},{"$f":"SalaryParticulars!AI13","v":"2015-10-31"},{"$f":"SalaryParticulars!AK13","v":31},36070,{"$f":"ROUND(SalaryParticulars!AO13*SalaryParticulars!AK13/SalaryParticulars!AJ13,0)","v":0},{"$f":"IF(D13>0,IF(A13>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D13*SalaryParticulars!AP13%,0)","v":3213},{"$f":"ROUND(D13*SalaryParticulars!AR13%,0)","v":5230},{"$f":"ROUND(SalaryParticulars!AU13*SalaryParticulars!AK13/SalaryParticulars!AJ13,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A13>=$AA$5,1350,900)*SalaryParticulars!AK13/SalaryParticulars!AJ13,0),0)","v":0},0,44513,{"$f":"IF(C13>=X13/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A13>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C13>=X13/2,IF(L13>20000,200,IF(L13>15000,150,IF(L13>10000,100,IF(L13>5000,80,0)))),0))","v":200},{"$f":"IF(C13>=X13/2,IF(Data!$E$80>0,IF(A13>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D13+SalaryParticulars!G13)*10%,0),0)","v":0},{"$f":"IF(C13>=X13/2,IF(Data!$E$79>0,IF(SalaryParticulars!A13>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C13>=X13/2,IF(A13>=$AA$6,Data!$E$66,0),0)","v":90},0,0,{"$f":"IF(C13>=X13/2,LOOKUP(A13,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ13","v":31},0,10,2015,null,null,"2015-10-01","2015-04-01",{"$f":"IF(IF(AE13<Data!$I$2,Data!$F$19,IF(AE13<$AD$6,Data!$F$19,AE13))=AF12,Data!$F$19,IF(AE13<Data!$I$2,Data!$F$19,IF(AE13<$AD$6,Data!$F$19,AE13)))","v":"2016-03-01"},"2015-10-01","2015-10-01","2015-10-31",31,31,{"$f":"IF(AND(AH13>=$AO$4,AH13<$AI$2),Data!$F$39,LOOKUP(AH13,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH13=Data!$G$33,Data!$H$33,IF(AH13=Data!$G$34,Data!$H$34,IF(AH13=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},{"$f":"IF(AH13>=$AN$4,0,ROUND(AL13*AM13,0))","v":36070},{"$f":"IF(AN13>0,ROUND(Data!$E$15*AK13*AM13/AK13,0),0)","v":0},{"$f":"IF(AH13>=Data!$G$22,Data!$I$22,IF(AH13>=Data!$G$21,Data!$I$21,IF(AH13>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI13>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3213,5230,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV13,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW13,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX13,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY13,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH14","v":"2015-11-01"},{"$f":"SalaryParticulars!AI14","v":"2015-11-30"},{"$f":"SalaryParticulars!AK14","v":30},36070,{"$f":"ROUND(SalaryParticulars!AO14*SalaryParticulars!AK14/SalaryParticulars!AJ14,0)","v":0},{"$f":"IF(D14>0,IF(A14>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D14*SalaryParticulars!AP14%,0)","v":3213},{"$f":"ROUND(D14*SalaryParticulars!AR14%,0)","v":5230},{"$f":"ROUND(SalaryParticulars!AU14*SalaryParticulars!AK14/SalaryParticulars!AJ14,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A14>=$AA$5,1350,900)*SalaryParticulars!AK14/SalaryParticulars!AJ14,0),0)","v":0},0,44513,{"$f":"IF(C14>=X14/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A14>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C14>=X14/2,IF(L14>20000,200,IF(L14>15000,150,IF(L14>10000,100,IF(L14>5000,80,0)))),0))","v":200},{"$f":"IF(C14>=X14/2,IF(Data!$E$80>0,IF(A14>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D14+SalaryParticulars!G14)*10%,0),0)","v":0},{"$f":"IF(C14>=X14/2,IF(Data!$E$79>0,IF(SalaryParticulars!A14>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C14>=X14/2,IF(A14>=$AA$6,Data!$E$66,0),0)","v":90},0,{"$f":"IF(AND(Z14=11,AA14=2014),ROUND(D14*2/30,0),0)","v":0},{"$f":"IF(C14>=X14/2,LOOKUP(A14,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ14","v":30},0,{"$f":"MONTH(A14)","v":11},{"$f":"YEAR(A14)","v":2015},null,1,"2015-11-01","2015-05-01",{"$f":"IF(IF(AE14<Data!$I$2,Data!$F$19,IF(AE14<$AD$6,Data!$F$19,AE14))=AF13,Data!$F$19,IF(AE14<Data!$I$2,Data!$F$19,IF(AE14<$AD$6,Data!$F$19,AE14)))","v":"2015-05-01"},"2015-11-01","2015-11-01","2015-11-30",30,30,{"$f":"IF(AND(AH14>=$AO$4,AH14<$AI$2),Data!$F$39,LOOKUP(AH14,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH14=Data!$G$33,Data!$H$33,IF(AH14=Data!$G$34,Data!$H$34,IF(AH14=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},36070,{"$f":"IF(AN14>0,ROUND(Data!$E$15*AK14*AM14/AK14,0),0)","v":0},{"$f":"IF(AH14>=Data!$G$22,Data!$I$22,IF(AH14>=Data!$G$21,Data!$I$21,IF(AH14>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI14>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3213,5230,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV14,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW14,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX14,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY14,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH15","v":"2015-12-01"},{"$f":"SalaryParticulars!AI15","v":"2015-12-31"},{"$f":"SalaryParticulars!AK15","v":31},36070,{"$f":"ROUND(SalaryParticulars!AO15*SalaryParticulars!AK15/SalaryParticulars!AJ15,0)","v":0},{"$f":"IF(D15>0,IF(A15>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D15*SalaryParticulars!AP15%,0)","v":3213},{"$f":"ROUND(D15*SalaryParticulars!AR15%,0)","v":5230},{"$f":"ROUND(SalaryParticulars!AU15*SalaryParticulars!AK15/SalaryParticulars!AJ15,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A15>=$AA$5,1350,900)*SalaryParticulars!AK15/SalaryParticulars!AJ15,0),0)","v":0},0,44513,{"$f":"IF(C15>=X15/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A15>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C15>=X15/2,IF(L15>20000,200,IF(L15>15000,150,IF(L15>10000,100,IF(L15>5000,80,0)))),0))","v":200},{"$f":"IF(C15>=X15/2,IF(Data!$E$80>0,IF(A15>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D15+SalaryParticulars!G15)*10%,0),0)","v":0},{"$f":"IF(C15>=X15/2,IF(Data!$E$79>0,IF(SalaryParticulars!A15>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C15>=X15/2,IF(A15>=$AA$6,Data!$E$66,0),0)","v":90},{"$f":"IF(C15>=X15/2,IF(OR(MONTH(A15)=3,MONTH(A15)=12),50,0),0)","v":50},{"$f":"IF(AND(Z15=11,AA15=2014),ROUND(D15*2/30,0),0)","v":0},{"$f":"IF(C15>=X15/2,LOOKUP(A15,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2350,{"$f":"SalaryParticulars!AJ15","v":31},0,{"$f":"MONTH(A15)","v":12},{"$f":"YEAR(A15)","v":2015},null,2,"2015-12-01","2015-06-01",{"$f":"IF(IF(AE15<Data!$I$2,Data!$F$19,IF(AE15<$AD$6,Data!$F$19,AE15))=AF14,Data!$F$19,IF(AE15<Data!$I$2,Data!$F$19,IF(AE15<$AD$6,Data!$F$19,AE15)))","v":"2015-06-01"},"2015-12-01","2015-12-01","2015-12-31",31,31,{"$f":"IF(AND(AH15>=$AO$4,AH15<$AI$2),Data!$F$39,LOOKUP(AH15,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH15=Data!$G$33,Data!$H$33,IF(AH15=Data!$G$34,Data!$H$34,IF(AH15=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},36070,{"$f":"IF(AN15>0,ROUND(Data!$E$15*AK15*AM15/AK15,0),0)","v":0},{"$f":"IF(AH15>=Data!$G$22,Data!$I$22,IF(AH15>=Data!$G$21,Data!$I$21,IF(AH15>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI15>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3213,5230,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV15,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW15,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX15,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY15,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH16","v":"2016-01-01"},{"$f":"SalaryParticulars!AI16","v":"2016-01-31"},{"$f":"SalaryParticulars!AK16","v":31},36070,{"$f":"ROUND(SalaryParticulars!AO16*SalaryParticulars!AK16/SalaryParticulars!AJ16,0)","v":0},{"$f":"IF(D16>0,IF(A16>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D16*SalaryParticulars!AP16%,0)","v":3213},{"$f":"ROUND(D16*SalaryParticulars!AR16%,0)","v":5230},{"$f":"ROUND(SalaryParticulars!AU16*SalaryParticulars!AK16/SalaryParticulars!AJ16,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A16>=$AA$5,1350,900)*SalaryParticulars!AK16/SalaryParticulars!AJ16,0),0)","v":0},0,44513,{"$f":"IF(C16>=X16/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A16>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C16>=X16/2,IF(L16>20000,200,IF(L16>15000,150,IF(L16>10000,100,IF(L16>5000,80,0)))),0))","v":200},{"$f":"IF(C16>=X16/2,IF(Data!$E$80>0,IF(A16>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D16+SalaryParticulars!G16)*10%,0),0)","v":0},{"$f":"IF(C16>=X16/2,IF(Data!$E$79>0,IF(SalaryParticulars!A16>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C16>=X16/2,IF(A16>=$AA$6,Data!$E$66,0),0)","v":90},0,0,{"$f":"IF(C16>=X16/2,LOOKUP(A16,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ16","v":31},0,1,2016,null,3,"2016-01-01","2015-07-01",{"$f":"IF(IF(AE16<Data!$I$2,Data!$F$19,IF(AE16<$AD$6,Data!$F$19,AE16))=AF15,Data!$F$19,IF(AE16<Data!$I$2,Data!$F$19,IF(AE16<$AD$6,Data!$F$19,AE16)))","v":"2015-07-01"},"2016-01-01","2016-01-01","2016-01-31",31,31,{"$f":"IF(AND(AH16>=$AO$4,AH16<$AI$2),Data!$F$39,LOOKUP(AH16,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH16=Data!$G$33,Data!$H$33,IF(AH16=Data!$G$34,Data!$H$34,IF(AH16=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},36070,{"$f":"IF(AN16>0,ROUND(Data!$E$15*AK16*AM16/AK16,0),0)","v":0},{"$f":"IF(AH16>=Data!$G$22,Data!$I$22,IF(AH16>=Data!$G$21,Data!$I$21,IF(AH16>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI16>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3213,5230,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV16,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW16,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX16,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY16,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH17","v":"2016-02-01"},{"$f":"SalaryParticulars!AI17","v":"2016-02-29"},{"$f":"SalaryParticulars!AK17","v":29},36070,{"$f":"ROUND(SalaryParticulars!AO17*SalaryParticulars!AK17/SalaryParticulars!AJ17,0)","v":0},{"$f":"IF(D17>0,IF(A17>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D17*SalaryParticulars!AP17%,0)","v":3213},{"$f":"ROUND(D17*SalaryParticulars!AR17%,0)","v":5230},{"$f":"ROUND(SalaryParticulars!AU17*SalaryParticulars!AK17/SalaryParticulars!AJ17,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A17>=$AA$5,1350,900)*SalaryParticulars!AK17/SalaryParticulars!AJ17,0),0)","v":0},0,44513,{"$f":"IF(C17>=X17/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A17>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":1500},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C17>=X17/2,IF(L17>20000,200,IF(L17>15000,150,IF(L17>10000,100,IF(L17>5000,80,0)))),0))","v":200},{"$f":"IF(C17>=X17/2,IF(Data!$E$80>0,IF(A17>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":60},null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D17+SalaryParticulars!G17)*10%,0),0)","v":0},{"$f":"IF(C17>=X17/2,IF(Data!$E$79>0,IF(SalaryParticulars!A17>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":450},{"$f":"IF(C17>=X17/2,IF(A17>=$AA$6,Data!$E$66,0),0)","v":90},0,0,{"$f":"IF(C17>=X17/2,LOOKUP(A17,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},2300,{"$f":"SalaryParticulars!AJ17","v":29},0,2,2016,null,4,"2016-02-01","2015-08-01",{"$f":"IF(IF(AE17<Data!$I$2,Data!$F$19,IF(AE17<$AD$6,Data!$F$19,AE17))=AF16,Data!$F$19,IF(AE17<Data!$I$2,Data!$F$19,IF(AE17<$AD$6,Data!$F$19,AE17)))","v":"2015-08-01"},"2016-02-01","2016-02-01","2016-02-29",29,29,{"$f":"IF(AND(AH17>=$AO$4,AH17<$AI$2),Data!$F$39,LOOKUP(AH17,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH17=Data!$G$33,Data!$H$33,IF(AH17=Data!$G$34,Data!$H$34,IF(AH17=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},36070,{"$f":"IF(AN17>0,ROUND(Data!$E$15*AK17*AM17/AK17,0),0)","v":0},{"$f":"IF(AH17>=Data!$G$22,Data!$I$22,IF(AH17>=Data!$G$21,Data!$I$21,IF(AH17>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI17>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,3213,5230,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV17,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW17,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX17,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY17,0))))","v":0},525,350,350,140]
[{"$f":"SalaryParticulars!AH18","v":"2016-03-01"},{"$f":"SalaryParticulars!AI18","v":"2016-02-29"},{"$f":"SalaryParticulars!AK18","v":0},0,{"$f":"ROUND(SalaryParticulars!AO18*SalaryParticulars!AK18/SalaryParticulars!AJ18,0)","v":0},{"$f":"IF(D18>0,IF(A18>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D18*SalaryParticulars!AP18%,0)","v":0},{"$f":"ROUND(D18*SalaryParticulars!AR18%,0)","v":0},{"$f":"ROUND(SalaryParticulars!AU18*SalaryParticulars!AK18/SalaryParticulars!AJ18,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A18>=$AA$5,1350,900)*SalaryParticulars!AK18/SalaryParticulars!AJ18,0),0)","v":0},{"$f":"ROUND(D18*0%,0)","v":0},{"$f":"SUM(D18:K18)","v":0},{"$f":"IF(C18>=X18/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A18>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C18>=X18/2,IF(L18>20000,200,IF(L18>15000,150,IF(L18>10000,100,IF(L18>5000,80,0)))),0))","v":0},{"$f":"IF(C18>=X18/2,IF(Data!$E$80>0,IF(A18>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":0},{"$f":"IF(C18>=X18/2,P17,0)","v":0},{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D18+SalaryParticulars!G18)*10%,0),0)","v":0},{"$f":"IF(C18>=X18/2,IF(Data!$E$79>0,IF(SalaryParticulars!A18>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":0},{"$f":"IF(C18>=X18/2,IF(A18>=$AA$6,Data!$E$66,0),0)","v":0},0,0,{"$f":"IF(C18>=X18/2,LOOKUP(A18,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},{"$f":"SUM(M18:V18)","v":0},{"$f":"SalaryParticulars!AJ18","v":31},0,{"$f":"MONTH(A18)","v":3},{"$f":"YEAR(A18)","v":2016},null,5,{"$f":"Data!D33","v":"00:00:00"},"2015-08-01",{"$f":"IF(IF(AE18<Data!$I$2,Data!$F$19,IF(AE18<$AD$6,Data!$F$19,AE18))=AF17,Data!$F$19,IF(AE18<Data!$I$2,Data!$F$19,IF(AE18<$AD$6,Data!$F$19,AE18)))","v":"2016-03-01"},"2016-03-01","2016-03-01","2016-02-29",31,0,{"$f":"IF(AND(AH18>=$AO$4,AH18<$AI$2),Data!$F$39,LOOKUP(AH18,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH18=Data!$G$33,Data!$H$33,IF(AH18=Data!$G$34,Data!$H$34,IF(AH18=Data!$G$35,Data!$H$35,Data!$H$36)))","v":0.5},0,{"$f":"IF(AN18>0,ROUND(Data!$E$15*AK18*AM18/AK18,0),0)","v":0},{"$f":"IF(AH18>=Data!$G$22,Data!$I$22,IF(AH18>=Data!$G$21,Data!$I$21,IF(AH18>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI18>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},29,0,0,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV18,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW18,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX18,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY18,0))))","v":0},0,0,0,0]
[{"$f":"SalaryParticulars!AH19","v":"2016-03-01"},{"$f":"SalaryParticulars!AI19","v":"2016-02-29"},{"$f":"SalaryParticulars!AK19","v":0},0,{"$f":"ROUND(SalaryParticulars!AO19*SalaryParticulars!AK19/SalaryParticulars!AJ19,0)","v":0},{"$f":"IF(D19>0,IF(A19>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D19*SalaryParticulars!AP19%,0)","v":0},{"$f":"ROUND(D19*SalaryParticulars!AR19%,0)","v":0},{"$f":"ROUND(SalaryParticulars!AU19*SalaryParticulars!AK19/SalaryParticulars!AJ19,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A19>=$AA$5,1350,900)*SalaryParticulars!AK19/SalaryParticulars!AJ19,0),0)","v":0},{"$f":"ROUND(D19*0%,0)","v":0},0,{"$f":"IF(C19>=X19/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A19>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C19>=X19/2,IF(L19>20000,200,IF(L19>15000,150,IF(L19>10000,100,IF(L19>5000,80,0)))),0))","v":0},{"$f":"IF(C19>=X19/2,IF(Data!$E$80>0,IF(A19>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":0},{"$f":"IF(C19>=X19/2,P18,0)","v":0},{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D19+SalaryParticulars!G19)*10%,0),0)","v":0},{"$f":"IF(C19>=X19/2,IF(Data!$E$79>0,IF(SalaryParticulars!A19>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":0},{"$f":"IF(C19>=X19/2,IF(A19>=$AA$6,Data!$E$66,0),0)","v":0},0,0,{"$f":"IF(C19>=X19/2,LOOKUP(A19,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},0,{"$f":"SalaryParticulars!AJ19","v":31},0,3,2016,null,6,{"$f":"IF(Data!D34>Data!E33+1,Data!D34,Data!E33+1)","v":"1900-01-01"},"2015-09-01",{"$f":"IF(IF(AE19<Data!$I$2,Data!$F$19,IF(AE19<$AD$6,Data!$F$19,AE19))=AF18,Data!$F$19,IF(AE19<Data!$I$2,Data!$F$19,IF(AE19<$AD$6,Data!$F$19,AE19)))","v":"2015-09-01"},"2016-03-01","2016-03-01","2016-02-29",31,0,{"$f":"IF(AND(AH19>=$AO$4,AH19<$AI$2),Data!$F$39,LOOKUP(AH19,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH19=Data!$G$33,Data!$H$33,IF(AH19=Data!$G$34,Data!$H$34,IF(AH19=Data!$G$35,Data!$H$35,Data!$H$36)))","v":0.5},{"$f":"IF(AH19>=$AN$4,0,ROUND(AL19*AM19,0))","v":0},{"$f":"IF(AN19>0,ROUND(Data!$E$15*AK19*AM19/AK19,0),0)","v":0},{"$f":"IF(AH19>=Data!$G$22,Data!$I$22,IF(AH19>=Data!$G$21,Data!$I$21,IF(AH19>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI19>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},29,0,0,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV19,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW19,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX19,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY19,0))))","v":0},0,0,0,0]
[{"$f":"SalaryParticulars!AH20","v":"2016-03-01"},{"$f":"SalaryParticulars!AI20","v":"2016-02-29"},{"$f":"SalaryParticulars!AK20","v":0},0,{"$f":"ROUND(SalaryParticulars!AO20*SalaryParticulars!AK20/SalaryParticulars!AJ20,0)","v":0},{"$f":"IF(D20>0,IF(A20>=Data!$D$18,Data!$E$18,Data!$E$17),0)","v":0},{"$f":"ROUND(D20*SalaryParticulars!AP20%,0)","v":0},{"$f":"ROUND(D20*SalaryParticulars!AR20%,0)","v":0},{"$f":"ROUND(SalaryParticulars!AU20*SalaryParticulars!AK20/SalaryParticulars!AJ20,0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",ROUND(IF(A20>=$AA$5,1350,900)*SalaryParticulars!AK20/SalaryParticulars!AJ20,0),0)","v":0},{"$f":"ROUND(D20*0%,0)","v":0},0,{"$f":"IF(C20>=X20/2,IF(Data!$C$70=\"CPS\",0,IF(Data!$E$81>0,IF(A20>=Data!$D$81,Data!$E$81,Data!$E$70),Data!$E$70)),0)","v":0},{"$f":"IF(Data!$D$28=\"Yes\",0,IF(C20>=X20/2,IF(L20>20000,200,IF(L20>15000,150,IF(L20>10000,100,IF(L20>5000,80,0)))),0))","v":0},{"$f":"IF(C20>=X20/2,IF(Data!$E$80>0,IF(A20>=Data!$D$80,Data!$E$80,Data!$E$69),Data!$E$69),0)","v":0},{"$f":"IF(C20>=X20/2,P19,0)","v":0},{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D20+SalaryParticulars!G20)*10%,0),0)","v":0},{"$f":"IF(C20>=X20/2,IF(Data!$E$79>0,IF(SalaryParticulars!A20>=Data!$D$79,Data!$E$79,Data!$E$68),Data!$E$68),0)","v":0},{"$f":"IF(C20>=X20/2,IF(A20>=$AA$6,Data!$E$66,0),0)","v":0},0,0,{"$f":"IF(C20>=X20/2,LOOKUP(A20,Data!$C$92:$D$103,Data!$E$92:$E$103),0)","v":0},0,{"$f":"SalaryParticulars!AJ20","v":31},0,3,2016,null,7,{"$f":"IF(Data!D35>Data!E34+1,Data!D35,Data!E34+1)","v":"1900-01-01"},"2015-10-01",{"$f":"IF(IF(AE20<Data!$I$2,Data!$F$19,IF(AE20<$AD$6,Data!$F$19,AE20))=AF19,Data!$F$19,IF(AE20<Data!$I$2,Data!$F$19,IF(AE20<$AD$6,Data!$F$19,AE20)))","v":"2015-10-01"},"2016-03-01","2016-03-01","2016-02-29",31,0,{"$f":"IF(AND(AH20>=$AO$4,AH20<$AI$2),Data!$F$39,LOOKUP(AH20,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH20=Data!$G$33,Data!$H$33,IF(AH20=Data!$G$34,Data!$H$34,IF(AH20=Data!$G$35,Data!$H$35,Data!$H$36)))","v":0.5},0,{"$f":"IF(AN20>0,ROUND(Data!$E$15*AK20*AM20/AK20,0),0)","v":0},{"$f":"IF(AH20>=Data!$G$22,Data!$I$22,IF(AH20>=Data!$G$21,Data!$I$21,IF(AH20>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI20>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},{"$f":"IF(AM20=0.5,AQ20*2,AQ20)","v":29},{"$f":"ROUND(AN20*AP20%*AK20/AJ20,0)","v":0},{"$f":"ROUND(AN20*AQ20%*AK20/AJ20,0)","v":0},{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV20,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW20,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX20,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY20,0))))","v":0},{"$f":"IF(AN20=0,0,IF(AN20>18030,525,IF(AN20>13270,350,IF(AN20>8200,300,200))))","v":0},{"$f":"IF(AN20=0,0,IF(AN20>18030,350,IF(AN20>13270,220,IF(AN20>8200,160,120))))","v":0},{"$f":"IF(AN20=0,0,IF(AN20>18030,350,IF(AN20>13270,220,IF(AN20>8200,160,120))))","v":0},{"$f":"IF(AN20=0,0,IF(AN20>18030,140,IF(AN20>13270,130,IF(AN20>8200,120,100))))","v":0}]
["TOTAL A",null,null,{"$f":"SUM(D6:D17)","v":409570},{"$f":"SUM(E6:E20)","v":0},{"$f":"SUM(F6:F20)","v":0},47934,58970,0,0,{"$f":"SUM(K6:K20)","v":4482},520956,{"$f":"SUM(M6:M20)","v":18000},2400,720,0,0,5400,1080,{"$f":"SUM(T6:T20)","v":70},{"$f":"SUM(U6:U20)","v":0},{"$f":"SUM(V6:V20)","v":0},27670,null,null,null,null,null,8,{"$f":"IF(Data!D36>Data!E35+1,Data!D36,Data!E35+1)","v":"1900-01-01"},"2015-11-01",{"$f":"IF(IF(AE21<Data!$I$2,Data!$F$19,IF(AE21<$AD$6,Data!$F$19,AE21))=AF20,Data!$F$19,IF(AE21<Data!$I$2,Data!$F$19,IF(AE21<$AD$6,Data!$F$19,AE21)))","v":"2015-11-01"},"2016-03-01","2016-03-01","2016-02-29",31,0,{"$f":"IF(AND(AH21>=$AO$4,AH21<$AI$2),Data!$F$39,LOOKUP(AH21,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH21=Data!$G$33,Data!$H$33,IF(AH21=Data!$G$34,Data!$H$34,IF(AH21=Data!$G$35,Data!$H$35,Data!$H$36)))","v":0.5},0,{"$f":"IF(AN21>0,ROUND(Data!$E$15*AK21*AM21/AK21,0),0)","v":0},{"$f":"IF(AH21>=Data!$G$22,Data!$I$22,IF(AH21>=Data!$G$21,Data!$I$21,IF(AH21>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI21>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},29,0,0,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV21,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW21,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX21,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY21,0))))","v":0},0,0,0,0]
["Surrender Leave",null,null,{"$f":"IF(Data!E29=0,0,ROUND(LOOKUP(Data!$E$30,SalaryParticulars!$A$6:$A$20,D6:D20)*Data!E29/30,0))","v":18035},{"$f":"IF(Data!E29=0,0,ROUND(LOOKUP(Data!$E$30,SalaryParticulars!$A$6:$A$20,E6:E20)*Data!E29/30,0))","v":0},null,{"$f":"IF(Data!E29=0,0,ROUND(LOOKUP(Data!$E$30,SalaryParticulars!$A$6:$A$20,G6:G20)*Data!E29/30,0))+IF(Data!E29>0,ROUND(LOOKUP(Data!E30,Data!I2:I15,Data!N2:N15)*Data!E29/30,0),0)","v":1607},{"$f":"IF(Data!E29=0,0,ROUND(LOOKUP(Data!$E$30,SalaryParticulars!$A$6:$A$20,H6:H20)*Data!E29/30,0))","v":2615},{"$f":"IF(Data!E29=0,0,ROUND(LOOKUP(Data!$E$30,SalaryParticulars!$A$6:$A$20,I6:I20)*Data!E29/30,0))","v":0},null,null,{"$f":"SUM(D22:K22)","v":22257},{"$f":"IF(Data!C70=\"CPS\",0,IF(Data!E29>0,ROUND(LOOKUP(Data!E30,Data!I2:I15,Data!N2:N15)*Data!E29/30,0),0))","v":0},null,null,null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND((SalaryParticulars!D22+SalaryParticulars!G22)*10%,0),0)","v":0},null,null,null,null,null,{"$f":"SUM(M22:V22)","v":0},null,null,null,null,null,9,{"$f":"AD1","v":"2015-03-01"},"2015-12-01",{"$f":"IF(IF(AE22<Data!$I$2,Data!$F$19,IF(AE22<$AD$6,Data!$F$19,AE22))=AF21,Data!$F$19,IF(AE22<Data!$I$2,Data!$F$19,IF(AE22<$AD$6,Data!$F$19,AE22)))","v":"2015-12-01"},"2016-03-01","2016-03-01","2016-02-29",31,0,{"$f":"IF(AND(AH22>=$AO$4,AH22<$AI$2),Data!$F$39,LOOKUP(AH22,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH22=Data!$G$33,Data!$H$33,IF(AH22=Data!$G$34,Data!$H$34,IF(AH22=Data!$G$35,Data!$H$35,Data!$H$36)))","v":0.5},0,{"$f":"IF(AN22>0,ROUND(Data!$E$15*AK22*AM22/AK22,0),0)","v":0},{"$f":"IF(AH22>=Data!$G$22,Data!$I$22,IF(AH22>=Data!$G$21,Data!$I$21,IF(AH22>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI22>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},29,0,0,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV22,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW22,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX22,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY22,0))))","v":0},0,0,0,0]
["D.A. Arrear",null,null,null,null,null,{"$f":"Data!N19","v":0},null,null,null,null,{"$f":"G23","v":0},{"$f":"IF(Data!C70=\"CPS\",0,Data!O19)","v":0},null,null,null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND(L23*10%,0),0)","v":0},null,null,null,null,null,{"$f":"SUM(M23:V23)","v":0},null,null,null,null,null,10,{"$f":"AD2","v":"2015-08-01"},"2016-01-01",{"$f":"IF(IF(AE23<Data!$I$2,Data!$F$19,IF(AE23<$AD$6,Data!$F$19,AE23))=AF22,Data!$F$19,IF(AE23<Data!$I$2,Data!$F$19,IF(AE23<$AD$6,Data!$F$19,AE23)))","v":"2016-01-01"},"2016-03-01","2016-03-01","2016-02-29",31,0,{"$f":"IF(AND(AH23>=$AO$4,AH23<$AI$2),Data!$F$39,LOOKUP(AH23,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH23=Data!$G$33,Data!$H$33,IF(AH23=Data!$G$34,Data!$H$34,IF(AH23=Data!$G$35,Data!$H$35,Data!$H$36)))","v":0.5},0,{"$f":"IF(AN23>0,ROUND(Data!$E$15*AK23*AM23/AK23,0),0)","v":0},{"$f":"IF(AH23>=Data!$G$22,Data!$I$22,IF(AH23>=Data!$G$21,Data!$I$21,IF(AH23>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI23>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},29,0,0,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV23,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW23,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX23,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY23,0))))","v":0},0,0,0,0]
["D.A. Arrear",null,null,null,null,null,{"$f":"Data!N21","v":0},null,null,null,null,{"$f":"G24","v":0},{"$f":"IF(Data!$C$70=\"CPS\",0,Data!O21)","v":0},null,null,null,{"$f":"IF(Data!$C$70=\"CPS\",ROUND(L24*10%,0),0)","v":0},null,null,null,null,null,{"$f":"SUM(M24:V24)","v":0},null,null,null,null,null,11,{"$f":"AD3","v":"2016-04-01"},"2016-02-01",{"$f":"IF(IF(AE24<Data!$I$2,Data!$F$19,IF(AE24<$AD$6,Data!$F$19,AE24))=AF23,Data!$F$19,IF(AE24<Data!$I$2,Data!$F$19,IF(AE24<$AD$6,Data!$F$19,AE24)))","v":"2016-02-01"},"2016-03-01","2016-03-01","2016-03-31",31,31,{"$f":"IF(AND(AH24>=$AO$4,AH24<$AI$2),Data!$F$39,LOOKUP(AH24,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":36070},{"$f":"IF(AH24=Data!$G$33,Data!$H$33,IF(AH24=Data!$G$34,Data!$H$34,IF(AH24=Data!$G$35,Data!$H$35,Data!$H$36)))","v":0.5},0,{"$f":"IF(AN24>0,ROUND(Data!$E$15*AK24*AM24/AK24,0),0)","v":0},{"$f":"IF(AH24>=Data!$G$22,Data!$I$22,IF(AH24>=Data!$G$21,Data!$I$21,IF(AH24>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI24>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},29,0,0,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV24,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW24,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX24,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY24,0))))","v":0},0,0,0,0]
[{"$f":"Data!D53","v":"AAS arrears"},null,null,{"$f":"Data!D54","v":0},null,null,{"$f":"Data!D55","v":0},{"$f":"Data!D56","v":0},{"$f":"Data!D58","v":0},{"$f":"Data!D57","v":0},{"$f":"Data!D59","v":0},{"$f":"SUM(D25:J25)","v":0},{"$f":"Data!D61","v":0},{"$f":"Data!D60","v":0},null,null,{"$f":"Data!D62","v":0},null,null,null,null,null,{"$f":"SUM(M25:V25)","v":0},null,null,null,null,null,12,{"$f":"AD4","v":"2016-04-01"},"2016-04-01",{"$f":"IF(IF(AE25<Data!$I$2,Data!$F$19,IF(AE25<$AD$6,Data!$F$19,AE25))=AF24,Data!$F$19,IF(AE25<Data!$I$2,Data!$F$19,IF(AE25<$AD$6,Data!$F$19,AE25)))","v":"2016-04-01"},"2016-03-01","2016-04-01","2016-03-31",30,0,{"$f":"IF(AND(AH25>=$AO$4,AH25<$AI$2),Data!$F$39,LOOKUP(AH25,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":0},{"$f":"IF(AH25=Data!$G$33,Data!$H$33,IF(AH25=Data!$G$34,Data!$H$34,IF(AH25=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},0,{"$f":"IF(AN25>0,ROUND(Data!$E$15*AK25*AM25/AK25,0),0)","v":0},{"$f":"IF(AH25>=Data!$G$22,Data!$I$22,IF(AH25>=Data!$G$21,Data!$I$21,IF(AH25>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI25>=Data!$D$25,Data!$E$25,Data!$E$24))","v":14.5},14.5,0,0,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV25,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW25,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX25,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY25,0))))","v":0},0,0,0,0]
[{"$f":"Data!E53","v":"Promotion Arrears"},null,null,{"$f":"Data!E54","v":0},null,null,{"$f":"Data!E55","v":0},{"$f":"Data!E56","v":0},{"$f":"Data!E58","v":0},{"$f":"Data!E57","v":0},{"$f":"Data!E59","v":0},{"$f":"SUM(D26:J26)","v":0},{"$f":"Data!E61","v":0},{"$f":"Data!E60","v":0},null,null,{"$f":"Data!E62","v":0},null,null,null,null,null,{"$f":"SUM(M26:V26)","v":0},null,null,null,null,null,13,{"$f":"AD5","v":"2016-04-01"},"2016-04-01",{"$f":"IF(IF(AE26<Data!$I$2,Data!$F$19,IF(AE26<$AD$6,Data!$F$19,AE26))=AF25,Data!$F$19,IF(AE26<Data!$I$2,Data!$F$19,IF(AE26<$AD$6,Data!$F$19,AE26)))","v":"2016-03-01"},"2016-04-01","2016-04-01",-1,30,-42461,{"$f":"IF(AND(AH26>=$AO$4,AH26<$AI$2),Data!$F$39,LOOKUP(AH26,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":0},{"$f":"IF(AH26=Data!$G$33,Data!$H$33,IF(AH26=Data!$G$34,Data!$H$34,IF(AH26=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},0,{"$f":"IF(AN26>0,ROUND(Data!$E$15*AK26*AM26/AK26,0),0)","v":0},{"$f":"IF(AH26>=Data!$G$22,Data!$I$22,IF(AH26>=Data!$G$21,Data!$I$21,IF(AH26>=Data!$F$21,Data!$I$19,0)))","v":8.9079999999999995},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI26>=Data!$D$25,Data!$E$25,Data!$E$24))","v":12},12,0,0,{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV26,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW26,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX26,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY26,0))))","v":0},0,0,0,0]
["TOTAL B",null,null,{"$f":"SUM(D22:D26)","v":18035},0,0,1607,2615,0,0,0,22257,0,0,0,0,0,0,0,0,null,null,{"$f":"SUM(W22:W26)","v":0},null,null,null,null,null,14,{"$f":"Data!U44","v":"2015-04-01"},"2016-04-01",{"$f":"IF(IF(AE27<Data!$I$2,Data!$F$19,IF(AE27<$AD$6,Data!$F$19,AE27))=AF26,Data!$F$19,IF(AE27<Data!$I$2,Data!$F$19,IF(AE27<$AD$6,Data!$F$19,AE27)))","v":"2016-04-01"},"2016-04-01","00:00:00",-1,{"$f":"DAY(DATE(YEAR(AH27),MONTH(AH27)+1,1)-1)","v":31},{"$f":"AI27-AH27+1","v":0},{"$f":"IF(AND(AH27>=$AO$4,AH27<$AI$2),Data!$F$39,LOOKUP(AH27,$AI$1:$AI$5,$AJ$1:$AJ$5))","v":{"$error":"#N/A"}},{"$f":"IF(AH27=Data!$G$33,Data!$H$33,IF(AH27=Data!$G$34,Data!$H$34,IF(AH27=Data!$G$35,Data!$H$35,Data!$H$36)))","v":1},{"$error":"#N/A"},{"$f":"IF(AN27>0,ROUND(Data!$E$15*AK27*AM27/AK27,0),0)","v":{"$error":"#N/A"}},{"$f":"IF(AH27>=Data!$G$22,Data!$I$22,IF(AH27>=Data!$G$21,Data!$I$21,IF(AH27>=Data!$F$21,Data!$I$19,0)))","v":0},{"$f":"IF(Data!$D$25<Data!$D$24,Data!$E$24,IF(AI27>=Data!$D$25,Data!$E$25,Data!$E$24))","v":12},{"$f":"IF(AM27=0.5,AQ27*2,AQ27)","v":12},{"$f":"ROUND(AN27*AP27%*AK27/AJ27,0)","v":{"$error":"#N/A"}},{"$f":"ROUND(AN27*AQ27%*AK27/AJ27,0)","v":{"$error":"#N/A"}},{"$f":"IF(Data!$E$27=\"Greater Hyderabad\",SalaryParticulars!AV27,IF(Data!$E$27=\"Greater Visakhapatnam\",SalaryParticulars!AW27,IF(Data!$E$27=\"Vijayawada\",SalaryParticulars!AX27,IF(Data!$E$27=\"Other Muncipal Corporations\",SalaryParticulars!AY27,0))))","v":0},{"$f":"IF(AN27=0,0,IF(AN27>18030,525,IF(AN27>13270,350,IF(AN27>8200,300,200))))","v":{"$error":"#N/A"}},{"$f":"IF(AN27=0,0,IF(AN27>18030,350,IF(AN27>13270,220,IF(AN27>8200,160,120))))","v":{"$error":"#N/A"}}]
["GRAND TOTAL",null,null,{"$f":"SalaryParticulars!D21+D27","v":427605},{"$f":"SalaryParticulars!E21+E27","v":0},{"$f":"SalaryParticulars!F21+F27","v":0},{"$f":"SalaryParticulars!G21+G27","v":49541},{"$f":"SalaryParticulars!H21+H27","v":61585},{"$f":"SalaryParticulars!I21+I27","v":0},{"$f":"SalaryParticulars!J21+J27","v":0},{"$f":"SalaryParticulars!K21+K27","v":4482},{"$f":"SalaryParticulars!L21+L27","v":543213},{"$f":"SalaryParticulars!M21+M27","v":18000},{"$f":"SalaryParticulars!N21+N27","v":2400},{"$f":"SalaryParticulars!O21+O27","v":720},{"$f":"SalaryParticulars!P21+P27","v":0},{"$f":"SalaryParticulars!Q21+Q27","v":0},{"$f":"SalaryParticulars!R21+R27","v":5400},{"$f":"SalaryParticulars!S21+S27","v":1080},{"$f":"SalaryParticulars!T21+T27","v":70},{"$f":"SalaryParticulars!U21+U27","v":0},{"$f":"SalaryParticulars!V21+V27","v":0},{"$f":"SalaryParticulars!W21+W27","v":27670},null,{"$f":"SUM(Y6:Y27)","v":0},null,null,null,15]
[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,16]
["Details of pay and allowances received from 1st April 2015 to 31st March 2016 (salaries of march, 2015 to Feb. 2016) including the amounts of supplemental bills received during the above period be furnished.",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,17]
["1. Total gross salary income including HRA during the year 2015-16 (as per the statement shown above.)\n year)",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,18]
["2. Amount, if any, received from other sources (other than salary such as arrears etc., during the",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature of the employee.",null,null,null,null,null,null,null,null,null,19]
[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,20]
[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,21]
[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,22]
[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,23]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"ROUND((D28+E28+G28)*10%,0)","v":47715}]
[{"$f":"H28","v":61585},{"$f":"ROUND((A53+A54)/12,0)","v":9108}]
[{"$f":"B54-RIGHT(B54,2)+100","v":9200}]

{"sheet":"Ascessment form","index":2,"n_rows":64,"n_cols":14,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,6,63,9],[57,0,57,3],[57,6,57,8],[59,1,59,5],[52,6,52,8],[53,6,53,8],[54,6,54,8],[55,6,55,8],[56,6,56,8],[55,0,55,3],[3,3,3,6],[40,1,40,3],[51,0,51,4],[51,6,51,9],[1,1,1,2],[2,8,2,9],[5,8,5,9],[6,6,6,9],[4,8,4,9],[4,3,4,6],[3,1,5,2],[3,8,3,9],[5,3,5,6],[41,1,41,3],[10,2,10,6],[11,2,11,6],[0,0,0,9],[1,8,1,9],[2,1,2,2],[1,3,1,6],[2,3,2,6]]}
["INCOME TAX 2015-2016"]
["1.","Name :",null,{"$f":"Data!E5","v":"G.Venugopal"},null,null,null,"ID No :",{"$f":"Data!D4","v":"0926013"}]
[null,"Designation :",null,{"$f":"Data!E6","v":"SGT"},null,null,null,"Sex :",{"$f":"IF(Data!E7=\"M\",\"Male\",\"Female\")","v":"Male"},null,null,null,null,"."]
[null,"Address :",null,{"$f":"Data!E8&\", \"&Data!E9","v":"MPP School, NN Colony, Dhone"},null,null,null,"PAN No :",{"$f":"Data!E12","v":"AJVPG9142R"}]
[null,null,null,{"$f":"Data!E10&\" MANDAL\"","v":"Mandal MANDAL"}]
[null,null,null,{"$f":"Data!E11&\" DISTRICT\"","v":"Kurnool Dist DISTRICT"}]
["2.","Whether living in own house / rented house :",null,null,null,null,{"$f":"IF(Data!E46>0,\"Rented House\",\"Own House\")","v":"Rented House"}]
["3.","Pay and allowances as per statement",null,null,null,null,null,null,null,{"$f":"SalaryParticulars!L28","v":543213}]
["4.","Exemptions :"]
[null,"a)","HRA   U/S 10(13A)",null,null,null,null,{"$f":"E58","v":42285}]
[null,"b)","Conveyance Allowance U/s 10(14)",null,null,null,null,{"$f":"SalaryParticulars!J28","v":0}]
[null,"c)","EWF & FF",null,null,null,null,{"$f":"SalaryParticulars!T21","v":70}]
[null,null,"Total Exemptions 4(a+b+c)",null,null,null,null,null,null,{"$f":"SUM(H10:H12)","v":42355}]
["5.","Total Income from Salary  Col. (3-4)",null,null,null,null,null,null,null,{"$f":"J8-J13","v":500858}]
["6.","Less Professional tax U/S 16(iii)       (Max. Rs.2500/-)",null,null,null,null,null,null,null,{"$f":"IF(SalaryParticulars!N28>2500,2500,SalaryParticulars!N28)","v":2400}]
["7.","Income chargeable under the Head \"SALARIES\" Col.(5-6)",null,null,null,null,null,null,null,{"$f":"J14-J15","v":498458}]
["8.","Income or loss from House Property",null,null,null,null,null,null,null,{"$f":"J58","v":0}]
["9.","Income from other sources such as Interests from bank and Dividends",null,null,null,null,null,null,null,{"$f":"Data!E51","v":0}]
["10.","Gross Total Income Col.(7+8+9)",null,null,null,null,null,null,null,{"$f":"J16+J17+J18","v":498458}]
["11.","DEDUCTIONS Under Chapter VI-A (U/s 80C, 80CCC, 80CCD)"]
[null,"(a)","ZPPF ",null,null,null,null,{"$f":"SalaryParticulars!M28","v":18000}]
[null,"(b)","APGLI",null,null,null,null,{"$f":"SalaryParticulars!R28","v":5400}]
[null,"(c)","Group Insurance",null,null,null,null,{"$f":"SalaryParticulars!O28","v":720}]
[null,"(d)","LIC Policies Premium",null,null,null,null,{"$f":"Data!E67","v":0}]
[null,"(e)",{"$f":"Data!C71","v":"Tuition fee for 2 children"},null,null,null,null,{"$f":"Data!E71","v":126000}]
[null,"(f)",{"$f":"Data!C72","v":"Repayment of HBA installments. (Principle Amount)"},null,null,null,null,{"$f":"IF(Data!E72>150000,150000,Data!E72)","v":0}]
[null,"(g)",{"$f":"Data!C73","v":"Public Provident fund"},null,null,null,null,{"$f":"Data!E73","v":0}]
[null,"(h)",{"$f":"Data!C74","v":"Amount invested in 5year Post Office Time Deposite A/C"},null,null,null,null,{"$f":"Data!E74","v":0}]
[null,"(i)","LIC Pension fund U/s. 80 CCC (Max. Rs. 10000) ",null,null,null,null,{"$f":"IF(Data!E75<10000,Data!E75,10000)","v":0}]
[null,"(j)","Contribution to any Pension scheme U/s. 80 CCD",null,null,null,null,{"$f":"IF(SalaryParticulars!Q28>ROUND(J19*10%,0),ROUND(J19*10%,0),SalaryParticulars!Q28)","v":0}]
[null,"TOTAL (Max. Rs.150000)",null,null,null,null,null,{"$f":"SUM(H21:H30)","v":150120},null,{"$f":"IF(H31>150000,150000,H31)","v":150000}]
["12.","Rajiv Gandhi Equity Savings Scheme U/s. 80CCG",null,null,null,null,null,{"$f":"Data!E76","v":0},null,{"$f":"IF(ROUND(H32/2,0)>25000,25000,ROUND(H32/2,0))","v":0}]
["13.","OTHER DEDUCTIONS UNDER CHAPTER-VI A."]
[null,"(a)","Medical Insurance premium (U/S 80 D)                                                                 ",null,null,null,null,{"$f":"Data!E83+SalaryParticulars!S28","v":1080}]
[null,"(b)","Treatment of Handicapped Dependent (U/S.80 DD)",null,null,null,null,{"$f":"Data!E84","v":0}]
[null,"(c)","Expenditure on Medical Treatment of Dependent ( U/S.80 DDB )",null,null,null,null,{"$f":"Data!E85","v":0}]
[null,"(d)","Interest Paid on Education Loan( 80 E )",null,null,null,null,{"$f":"Data!E86","v":36800}]
[null,"(e)","Donation to Charitable institution U/S.80 G",null,null,null,null,{"$f":"Data!E87+SalaryParticulars!U21","v":0}]
[null,"(f)","Maintenance of Totally Blind or P.H. U/S.80 U",null,null,null,null,{"$f":"Data!E88","v":0}]
[null,"(g)","Interest earned on Savings Bank Account  U/S. 80 TTA",null,null,null,null,{"$f":"IF(Data!E89>10000,10000,Data!E89)","v":0}]
[null,"TOTAL ",null,null,null,null,null,{"$f":"SUM(H34:H40)","v":37880},null,{"$f":"H41","v":37880}]
["14.","Total Deductions (11+12+13)",null,null,null,null,null,null,null,{"$f":"J31+J32+J41","v":187880}]
["15.","Total Taxable income [ 10-14]",null,null,null,null,null,null,null,{"$f":"J19-J42","v":310578},null,{"$f":"IF(J43<250001,0,IF(J43<500001,(J43-250000)*10%,IF(J43<1000001,(J43-500000)*20%+25000,(J43-1000000)*30%+125000)))","v":6057.8}]
["16.","a) Income tax on the Taxable Income",null,null,null,null,null,null,null,{"$f":"ROUND(L43,0)","v":6058},null,{"$f":"IF(J43<250001,0,IF(J43<500001,(J43-250000)*10%,IF(J43<1000001,(J43-500000)*20%+25000,(J43-1000000)*30%+125000)))","v":6057.8}]
[null,"b) Rebate on the amount of tax payable  ( U/S  87A )",null,null,null,null,null,null,null,{"$f":"IF(J44<2000,J44,IF(J43<=500000,2000,0))","v":2000}]
[null,"c) Surcharge\n",null,null,null,null,null,null,null,0]
[null,"d) Education Cess @3%",null,null,null,null,null,null,null,{"$f":"ROUND((J44-J45)*3/100,0)","v":122}]
[null,"Total Tax Payable ",null,null,null,null,null,null,null,{"$f":"J44-J45+J46+J47","v":4180}]
["17.","Amount of tax already paid if any",null,null,null,null,null,null,null,{"$f":"SalaryParticulars!V28","v":0}]
["18.","Amount of tax now payable",null,null,null,null,null,null,null,{"$f":"J48-J49","v":4180}]
[]
["Calculation of HRA exemption",null,null,null,null,null,"Calculation of Income from House Property"]
["a) Actual amount of HRA received",null,null,null,{"$f":"SalaryParticulars!H28","v":61585},null,"a) Gross Annual Rent ",null,null,{"$f":"Data!E48","v":0}]
["b) Actual rent paid, per annum",null,null,null,{"$f":"12*Data!E46","v":90000},null,"b) Municipal Taxes  ",null,null,{"$f":"Data!E49","v":0}]
["c) 10 % of pay + DA",null,null,null,{"$f":"ROUND((SalaryParticulars!D28+SalaryParticulars!E28+SalaryParticulars!G28)*10/100,0)","v":47715},null,"c) Net Annual value   (a)-(b)",null,null,{"$f":"J53-J54","v":0}]
["d) Excess of rent paid over and above 10 % of Salary   ( b ) - ( c )",null,null,null,{"$f":"IF(E54-E55<=0,0,E54-E55)","v":42285},null,"d) Standard Deduction (30% of the Net Annual Value)",null,null,{"$f":"ROUND(J55*30%,0)","v":0}]
["e) 40% of salary (Pay+DA)",null,null,null,{"$f":"ROUND((SalaryParticulars!D28+SalaryParticulars!E28+SalaryParticulars!G28)*40/100,0)","v":190858},null,"e) Interest Paid on Housing Loan",null,null,{"$f":"IF(Data!E45=\"Self Occupaid\",IF(Data!E50>200000,200000,Data!E50),0)","v":0}]
["( a ),( d ) or ( e ) which ever is less     ",null,null,null,{"$f":"MIN(E53,E56,E57)","v":42285},null,"Net Income from the Property  (c)-(d)-(e)",null,null,{"$f":"J55-J56-J57","v":0}]
[]
[null,"Certified that I am incurring an expenditure of Rs \n",null,null,null,null,{"$f":"IF(Data!E46=0,\"-Nil-\",Data!E46&\"/-\")","v":"7500/-"},"per month towards house"]
["rent for my residential purpose during the year 2015-16"]
["        Certified that the particulars furnished above are true and correct."]
[]
[null,null,null,null,null,null,"Signature of the Government Employee"]

{"sheet":"house rent reciept","index":3,"n_rows":138,"n_cols":23,"rows_kept":138,"cut":false,"hidden":false,"merged":[[0,0,0,6],[23,1,23,2],[4,4,4,6],[6,1,6,3],[8,3,8,6],[19,0,19,1],[5,0,5,6],[6,4,6,5],[7,5,7,6],[22,0,22,2],[1,0,1,6],[2,0,2,6],[20,0,20,2],[18,1,18,3],[21,0,21,2]]}
["Drawing house rent allowance upto Rs.3000/- per month need not produce of rent receipt.\nIf annual rent paid exceeds Rs 1,00,000 per annum, it is mandatory for the employee to report PAN of the House Owner "]
["RECEIPT OF HOUSE RENT"]
["(Under Section 1 (13-A) of Income Tax Act )"]
[]
["Received a sum of Rs. ",null,{"$f":"Data!E46*12","v":90000}," (Rupees"]
[{"$f":"H124","v":"Ninety thousand only"}]
["from",{"$f":"Data!E5","v":"G.Venugopal"},null,null,"towards the rent @ Rs.",null,{"$f":"Data!E46","v":7500}]
["per month  from",null,"2015-03-01","to","2016-02-01","in respect of"]
["House No.",null,"situated at"]
[]
[null,null,null,null,"(Affix Revenue Stamp of Rs.1/-)"]
[]
[]
[]
[]
[]
["Date: ",null,null,null," Signature of the House Owner"]
["                                  "]
["Name:"]
["Address: "]
[]
[]
[]
["PAN No: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"C5","v":90000},{"$f":"(H112-H115)/1000","v":90},null,null,null,null,null,null,null,null,null,null,null,1,"One"]
[null,null,null,null,null,null,null,{"$f":"(I112-H114)/100","v":0},{"$f":"H113","v":0},{"$f":"RIGHT(I113,2)*1","v":0},{"$f":"(I113-J113)/100","v":0},{"$f":"(J113-RIGHT(J113,1)*1)/10","v":0},{"$f":"RIGHT(I113,1)*1","v":0},{"$f":"IF(L113=U113,W113,IF(L113=U114,W114,IF(L113=U115,W115,IF(L113=U116,W116,IF(L113=U117,W117,IF(L113=U118,W118,IF(L113=U119,W119,IF(L113=U120,W120,\" \"))))))))","v":" "},{"$f":"IF(L113=1,\" \",IF(M113=U112,V112,IF(M113=U113,V113,IF(M113=U114,V114,IF(M113=U115,V115,IF(M113=U116,V116,IF(M113=U117,V117,\" \")))))))","v":" "},{"$f":"IF(L113=1,\" \",IF(M113=U118,V118,IF(M113=U119,V119,IF(M113=U120,V120,\" \"))))","v":" "},{"$f":"IF(L113=0,\" \",IF(L113>1,\" \",IF(M113=U113,V123,IF(M113=U114,V124,IF(M113=U115,V125,IF(M113=U116,V126,IF(M113=U117,V127,IF(M113=U118,V128,\" \"))))))))","v":" "},{"$f":"IF(L113=0,\" \",IF(L113>1,\" \",IF(M113=U119,V129,IF(M113=U120,V130,IF(M113=U112,V122,IF(M113=0,V121,\" \"))))))","v":" "},{"$f":"IF(L113=0,\" \",\"lakh\")","v":" "},{"$f":"IF(M113=0,\" \",IF(L113>0,\" \",\"lakh\"))","v":" "},2,"Two","Twenty "]
[null,null,null,null,null,null,null,{"$f":"RIGHT(I112,2)*1","v":90},{"$f":"H114","v":90},{"$f":"RIGHT(I114,2)*1","v":90},{"$f":"(I114-J114)/100","v":0},{"$f":"(J114-RIGHT(J114,1)*1)/10","v":9},{"$f":"RIGHT(I114,1)*1","v":0},{"$f":"IF(L114=U113,W113,IF(L114=U114,W114,IF(L114=U115,W115,IF(L114=U116,W116,IF(L114=U117,W117,IF(L114=U118,W118,IF(L114=U119,W119,IF(L114=U120,W120,\" \"))))))))","v":"Ninety "},{"$f":"IF(L114=1,\" \",IF(M114=U112,V112,IF(M114=U113,V113,IF(M114=U114,V114,IF(M114=U115,V115,IF(M114=U116,V116,IF(M114=U117,V117,\" \")))))))","v":" "},{"$f":"IF(L114=1,\" \",IF(M114=U118,V118,IF(M114=U119,V119,IF(M114=U120,V120,\" \"))))","v":" "},{"$f":"IF(L114=0,\" \",IF(L114>1,\" \",IF(M114=U113,V123,IF(M114=U114,V124,IF(M114=U115,V125,IF(M114=U116,V126,IF(M114=U117,V127,IF(M114=U118,V128,\" \"))))))))","v":" "},{"$f":"IF(L114=0,\" \",IF(L114>1,\" \",IF(M114=U119,V129,IF(M114=U120,V130,IF(M114=U112,V122,IF(M114=0,V121,\" \"))))))","v":" "},{"$f":"IF(L114=0,\" \",\"thousand\")","v":"thousand"},{"$f":"IF(M114=0,\" \",IF(L114>0,\" \",\"thousand\"))","v":" "},3,"Three","Thirty "]
[null,null,null,null,null,null,null,{"$f":"RIGHT(H112,3)*1","v":0},{"$f":"H115","v":0},{"$f":"ROUND((I115-K116)/100,0)","v":0},null,null,null,null,{"$f":"IF(J115=0,\" \",IF(J115=U112,V112,IF(J115=U113,V113,IF(J115=U114,V114,IF(J115=U115,V115,IF(J115=U116,V116,IF(J115=U117,V117,\" \")))))))","v":" "},{"$f":"IF(J115=0,\" \",IF(J115=U118,V118,IF(J115=U119,V119,IF(J115=U120,V120,\" \"))))","v":" "},null,null,{"$f":"IF(J115=0,\" \",\"hundred\")","v":" "},null,4,"Four","Forty "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"RIGHT(I115,2)*1","v":0},{"$f":"(K116-RIGHT(K116,1)*1)/10","v":0},{"$f":"RIGHT(I115,1)*1","v":0},{"$f":"IF(L116=U113,W113,IF(L116=U114,W114,IF(L116=U115,W115,IF(L116=U116,W116,IF(L116=U117,W117,IF(L116=U118,W118,IF(L116=U119,W119,IF(L116=U120,W120,\" \"))))))))","v":" "},{"$f":"IF(L116=1,\" \",IF(M116=U112,V112,IF(M116=U113,V113,IF(M116=U114,V114,IF(M116=U115,V115,IF(M116=U116,V116,IF(M116=U117,V117,\" \")))))))","v":" "},{"$f":"IF(L116=1,\" \",IF(M116=U118,V118,IF(M116=U119,V119,IF(M116=U120,V120,\" \"))))","v":" "},{"$f":"IF(L116=0,\" \",IF(L116>1,\" \",IF(M116=U113,V123,IF(M116=U114,V124,IF(M116=U115,V125,IF(M116=U116,V126,IF(M116=U117,V127,IF(M116=U118,V128,\" \"))))))))","v":" "},{"$f":"IF(L116=0,\" \",IF(L116>1,\" \",IF(M116=U119,V129,IF(M116=U120,V130,IF(M116=U112,V122,IF(M116=0,V121,\" \"))))))","v":" "},null,null,5,"Five","Fifty "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L116","v":0},{"$f":"M116","v":0},null,null,null,null,null,null,null,6,"Six","Sixty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Seven","Seventy "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Eight","Eighty "]
[null,null,null,null,null,null,null,{"$f":"TRIM(N113&\" \"&O113&\" \"&P113&\" \"&Q113&\" \"&R113&\" \"&S113&\" \"&T113)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,9,"Nine","Ninety "]
[null,null,null,null,null,null,null,{"$f":"TRIM(N114&\" \"&O114&\" \"&P114&\" \"&Q114&\" \"&R114&\" \"&S114&\" \"&T114)","v":"Ninety thousand"},null,null,null,null,null,null,null,null,null,null,null,null,10,"Ten"]
[null,null,null,null,null,null,null,{"$f":"TRIM(N115&\" \"&O115&\" \"&P115&\" \"&Q115&\" \"&R115&\" \"&S115&\" \"&T115)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,11,"Eleven"]
[null,null,null,null,null,null,null,{"$f":"TRIM(N116&\" \"&O116&\" \"&P116&\" \"&Q116&\" \"&R116)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,12,"Twelve"]
[null,null,null,null,null,null,null,{"$f":"IF(H112>0,TRIM(H120&\" \"&H121&\" \"&H122&\" \"&H123)&\" only\",\"Zero only\")","v":"Ninety thousand only"},null,null,null,null,null,null,null,null,null,null,null,null,13,"Thirteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Fourteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Fifteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Sixteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Seventeen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Eighteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Nineteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Twenty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Thirty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"Forty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"Fifty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"Sixty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,"Seventy "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"Eighty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,"Ninety "]

{"sheet":"Form 16(page1)","index":4,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[15,0,15,12],[22,0,22,4],[24,0,24,2],[34,13,34,14],[35,3,36,5],[35,7,36,9],[35,10,36,12],[35,0,36,2],[13,0,13,1],[13,2,13,5],[13,6,13,8],[13,9,13,11],[14,0,14,1],[14,2,14,5],[14,6,14,8],[14,9,14,11],[11,0,11,1],[11,2,11,5],[11,6,11,8],[11,9,11,11],[12,0,12,1],[12,2,12,5],[12,6,12,8],[12,9,12,11],[8,0,8,12],[9,0,9,1],[9,2,9,5],[9,6,9,11],[10,0,10,1],[10,2,10,5],[10,6,10,8],[10,9,10,11],[46,0,46,2],[47,0,47,2],[0,0,0,12],[1,0,1,12],[2,0,2,12],[3,0,3,12],[4,0,4,5],[4,6,4,12],[5,0,5,5],[5,6,5,12],[6,0,6,2],[6,3,6,5],[6,6,6,12],[7,0,7,2],[7,3,7,5],[7,6,7,12]]}
["  FROM  NO. 16"]
["[See rule 31(1)(a)]"]
["Certificate under section 203 of the Income -tax Act,1961 for tax deducted at source   "]
["from income chargeable under the head \"salaries\""]
["Name and address of the Employer",null,null,null,null,null,"Name and designation of the Employee"]
[{"$f":"UPPER(Data!E105)&\",                                                    \"&UPPER(Data!E107)","v":"J.RAMACHANDRUDU,                                                    MEO, DHONE"},null,null,null,null,null,{"$f":"UPPER(Data!E5)&\", \"&Data!E6","v":"G.VENUGOPAL, SGT"}]
["PAN No. Of the deductor ",null,null,"TAN No. Of the deductor ",null,null,"PAN No. Of the Employee"]
[{"$f":"UPPER(Data!E109)","v":""},null,null,{"$f":"UPPER(Data!E110)","v":""},null,null,{"$f":"UPPER(Data!E12)","v":"AJVPG9142R"}]
["Acknowledgement nos. of all quarterly statements of TDS under sub -section  (3) of section 200 as by TIN Facilitation  center or NSDL web -site."]
["Quarter  ",null,"Acknowledgement no. ",null,null,null,"Period",null,null,null,null,null,"Assessment Year"]
[null,null,null,null,null,null,"From",null,null,"To"]
[1,null,null,null,null,null,"2015-04-01",null,null,"2015-06-30",null,null,"2016-17"]
[2,null,null,null,null,null,"2015-07-01",null,null,"2015-09-30"]
[3,null,null,null,null,null,"2015-10-01",null,null,"2015-12-31"]
[4,null,null,null,null,null,"2016-01-01",null,null,"2016-03-31"]
["DETILS OF SALARY PAID AND ANY OTHER INCOME  AND TAX DEDUCTED"]
["1.Gross salary"]
["a)Salary as per provisions contained in section 17 (1)",null,null,null,null,null,null,"Rs.",{"$f":"'Ascessment form'!J8","v":543213}]
["(b) Value of perquisites under section 17(2)"]
["   (as per From No. 12BA, wherever applicable)",null,null,null,null,null,null,"Rs.",0]
["© Profits in lieu of salary under section 17 (3)"]
["   (as per From No. 12BA, wherever applicable)",null,null,null,null,null,null,"Rs.",0]
["   (d) Total",null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"SUM(I18:I22)","v":543213}]
["2. Less : Allowance to the exempt under  section 10"]
["HRA, CA, etc.",null,null,null,null,null,null,"Rs.",{"$f":"'Ascessment form'!J13","v":42355},null,null,"Rs.",{"$f":"I25","v":42355}]
["3. Balance (1-2)",null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"M23-M25","v":500858}]
["4. Deductions :"]
["(a) Entertainment Allowance",null,null,null,null,null,null,"Rs.",0]
["(b) Tax on Employment             ",null,null,null,null,null,null,"Rs.",{"$f":"'Ascessment form'!J15","v":2400}]
["5. Aggregate of 4 (a) and (b) ",null,null,null,null,null,null,"Rs.",{"$f":"I28+I29","v":2400},null,null,"Rs.",{"$f":"I30","v":2400}]
["6. Income chargeable under the head 'salaries ' (3 - 5)",null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"M26-M30","v":498458}]
["7. Add : Income from Other Sources",null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"'Ascessment form'!J17+'Ascessment form'!J18","v":0}]
["8. Gross total income (6+7)",null,null,null,null,null,null,null,null,null,null,"Rs.",{"$f":"M31+M32","v":498458}]
["9. Deductions under chapter VI - A"]
["  (A) Sections 80C, 80CCC and 80CCD"]
["Section 80C",null,null,"Gross amount",null,null,null,"Qualifying amount",null,null,"Deductible Amount"]
[]
["i)","ZPPF/GPF",null,"Rs.",{"$f":"'Ascessment form'!H21","v":18000}]
["ii)","APGLI",null,"Rs.",{"$f":"'Ascessment form'!H22","v":5400}]
["iii)","Group Insurance",null,"Rs.",{"$f":"'Ascessment form'!H23","v":720}]
["iv)","LIC Policies Premium",null,"Rs.",{"$f":"'Ascessment form'!H24","v":0}]
["v)",{"$f":"IF(Data!E71=0,\" \",Data!C71)","v":"Tuition fee for 2 children"},null,"Rs.",{"$f":"'Ascessment form'!H25","v":126000}]
["vi)",{"$f":"IF(Data!E72=0,\" \",Data!C72)","v":" "},null,"Rs.",{"$f":"'Ascessment form'!H26","v":0}]
["vii)",{"$f":"IF(Data!E73=0,\" \",Data!C73)","v":" "},null,"Rs.",{"$f":"'Ascessment form'!H27","v":0}]
["viii)",{"$f":"IF(Data!E74=0,\" \",Data!C74)","v":" "},null,"Rs.",{"$f":"'Ascessment form'!H28","v":0}]
[null,"Total of 80C",null,"Rs.",{"$f":"SUM(E38:E45)","v":150120},null,null,"Rs.",{"$f":"SUM(E38:E45)","v":150120},null,null,"Rs.",{"$f":"IF(I46>150000,150000,I46)","v":150000}]
["Section 80CCC",null,null,"Rs.",{"$f":"'Ascessment form'!H29","v":0},null,null,"Rs.",{"$f":"E47","v":0},null,null,"Rs.",{"$f":"I47","v":0}]
["Section 80CCD",null,null,"Rs.",{"$f":"'Ascessment form'!H30","v":0},null,null,"Rs.",{"$f":"E48","v":0},null,null,"Rs.",{"$f":"I48","v":0}]
["Total of Sections 80C, 80CCC and 80CCD",null,null,null,null,null,null,null,{"$f":"SUM(I46:I48)","v":150120},null,null,"Rs.",{"$f":"IF(I49>150000,150000,I49)","v":150000}]
["(B) Rajiv Gandhi Equity Savings Scheme U/s. 80CCG",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Ascessment form'!J32","v":0}]

{"sheet":"Form 16(page2)","index":5,"n_rows":131,"n_cols":17,"rows_kept":131,"cut":false,"hidden":false,"merged":[[37,7,37,8],[37,9,37,10],[35,5,35,6],[35,7,35,8],[35,9,35,10],[36,5,36,6],[36,7,36,8],[36,9,36,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[25,9,26,10],[46,1,46,2],[40,0,42,10],[38,9,38,10],[39,5,39,6],[39,7,39,8],[39,9,39,10],[38,5,38,6],[38,7,38,8],[37,5,37,6],[34,5,34,6],[34,7,34,8],[34,9,34,10],[30,9,30,10],[31,5,31,6],[32,7,32,8],[32,9,32,10],[33,5,33,6],[31,7,31,8],[31,9,31,10],[32,5,32,6],[33,7,33,8],[1,0,1,4],[1,9,1,10],[2,0,2,1],[3,0,3,1],[3,2,3,4],[2,2,2,4],[1,7,1,8],[7,0,7,1],[9,0,9,5],[8,0,8,1],[8,2,8,4],[4,2,4,4],[5,0,5,1],[5,2,5,4],[6,0,6,1],[6,2,6,4],[4,0,4,1],[46,7,46,10],[47,7,47,10],[27,9,27,10],[27,7,27,8],[7,2,7,4],[28,9,28,10],[24,0,24,10],[23,0,23,10],[25,7,25,8],[25,5,26,6],[27,5,27,6],[28,5,28,6],[28,7,28,8],[33,9,33,10],[30,5,30,6],[30,7,30,8]]}
["(C) Other sections (e.g., 80E, 80G etc.) Under Chapter VIA"]
["Deduction",null,null,null,null,"Gross amount",null,"Qualifying amount",null,"Deductible Amount"]
["(a) Section",null,"80D Medical Insurance",null,null,"Rs.",{"$f":"'Ascessment form'!H34","v":1080},"Rs.",{"$f":"G3","v":1080},"Rs.",{"$f":"I3","v":1080}]
["(b) Section",null,"80DD Treatment of Handicapped \n          dependent",null,null,"Rs.",{"$f":"'Ascessment form'!H35","v":0},"Rs.",0,"Rs.",0]
["(c) Section",null,"80DDB Expenditure on medical\n           treatment",null,null,"Rs.",{"$f":"'Ascessment form'!H36","v":0},"Rs.",0,"Rs.",0]
["(d) Section",null,"80E Interest paid on Education Loan ",null,null,"Rs.",{"$f":"'Ascessment form'!H37","v":36800},"Rs.",36800,"Rs.",36800]
["(e) Section",null,"80G Donation to Charitable\n        Institution & CMRF",null,null,"Rs.",{"$f":"'Ascessment form'!H38","v":0},"Rs.",{"$f":"G7","v":0},"Rs.",0]
["(f) Section",null,"80U Maintenance of Totally Blind or PHC",null,null,"Rs.",{"$f":"'Ascessment form'!H39","v":0},"Rs.",0,"Rs.",0]
["(g) Section",null,"Interest earned on Savings Bank Account  U/S. 80 TTA",null,null,"Rs.",{"$f":"'Ascessment form'!H40","v":0},null,0,null,0]
["Total of Sections 80D, 80DD, 80DDB, 80E, 80G, 80U, 80 TTA",null,null,null,null,null,null,null,null,"Rs.",{"$f":"SUM(K3:K9)","v":37880}]
["10. Aggregate of deductible amounts Under Chapter VI - A ",null,null,null,null,null,null,null,null,"Rs.",{"$f":"'Form 16(page1)'!M49+K10+'Form 16(page1)'!M50","v":187880}]
["11. Total income ( 8 - 10 ) Rs.",null,null,null,null,null,null,null,null,"Rs.",{"$f":"'Form 16(page1)'!M33-'Form 16(page2)'!K11","v":310578}]
["12. Tax on total income Rs.",null,null,null,null,null,null,null,null,"Rs.",{"$f":"'Ascessment form'!J44","v":6058}]
["13. Rebate on the amount of tax payable  ( U/S  87A )",null,null,null,null,null,null,null,null,"Rs.",{"$f":"'Ascessment form'!J45","v":2000}]
["14. Surcharge ( on tax computed at S. NO. 12 )",null,null,null,null,null,null,null,null,"Rs.",0]
["15. Education Cess @ 3% on ( tax at S. NO. 12 plus surcharge at S. NO. 13 ) ",null,null,null,null,null,null,null,null,"Rs.",{"$f":"'Ascessment form'!J47","v":122}]
["16. Tax payable (12+13+14 ) Rs.",null,null,null,null,null,null,null,null,"Rs.",{"$f":"K13-K14+K15+K16","v":4180}]
["17. Relief  under section 89 (attach details ) Rs.",null,null,null,null,null,null,null,null,"Rs.",0]
["18. Tax payable ( 15 - 16 )  Rs.",null,null,null,null,null,null,null,null,"Rs.",{"$f":"K17-K18","v":4180}]
["19. Less : (a) Tax deducted at source u/s 192 (1)",null,null,null,null,null,null,null,null,"Rs.",{"$f":"K19","v":4180}]
["                (b) Tax paid by the employer on behalf  of the employee u/s 192 (1 A) on ",null,null,null,null,null,null,null,null,"Rs.",0]
["                     perquisites u/s 17 ( 2 )"]
["20.Tax payable / refundable ( 17-18 )",null,null,null,null,null,null,null,null,"Rs.",{"$f":"K19-K20","v":0}]
["DETAILS OF DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT"]
["(The Employer is to provide transaction - wise details of tax deducted and deposited)"]
["S. No.           ","TDS","Surcharge","Education Cess","  Total tax deposited","Cheque / DD No. (if any)",null,"Date on which tax deposited",null,"Transfer voucher / challan Identification No."]
[null,"      Rs.","     Rs.","      Rs.   ","       Rs.",null,null," (dd / mm / yyyy)"]
[1,{"$f":"SalaryParticulars!V6","v":0},0,0,{"$f":"SUM(B28:D28)","v":0}]
[2,{"$f":"SalaryParticulars!V7","v":0},0,0,{"$f":"SUM(B29:D29)","v":0}]
[3,{"$f":"SalaryParticulars!V8","v":0},0,0,0]
[4,{"$f":"SalaryParticulars!V9","v":0},0,0,0]
[5,{"$f":"SalaryParticulars!V10","v":0},0,0,0]
[6,{"$f":"SalaryParticulars!V11","v":0},0,0,0]
[7,{"$f":"SalaryParticulars!V12","v":0},0,0,0]
[8,{"$f":"SalaryParticulars!V13","v":0},0,0,0]
[9,{"$f":"SalaryParticulars!V14","v":0},0,0,0]
[10,{"$f":"SalaryParticulars!V15","v":0},0,0,0]
[11,{"$f":"SalaryParticulars!V16","v":0},0,0,0]
[12,{"$f":"'Ascessment form'!J50","v":4180},0,0,{"$f":"SUM(B39:D39)","v":4180}]
["Total",{"$f":"SUM(B28:B39)","v":4180},{"$f":"SUM(C28:C39)","v":0},{"$f":"SUM(D28:D39)","v":0},{"$f":"SUM(E28:E39)","v":4180}]
[{"$f":"\"               I, \"&Data!E105&\", son/ daughter of \"&Data!E106&\" working in the capacity of \"&Data!E107&\" (designation) do hereby certify that a sum of Rs.\"&K20&\"/- [ Rupees \"&B117&\" (in words)] has been deducted at source and paid to the credit of the Central Government. I further certify that the information given above is true and correct based on the books of account documents and other available records.\"","v":"               I, J.RAMACHANDRUDU, son/ daughter of  working in the capacity of MEO, Dhone (designation) do hereby certify that a sum of Rs.4180/- [ Rupees Four thousand One hundred Eighty only (in words)] has been deducted at source and paid to the credit of the Central Government. I further certify that the information given above is true and correct based on the books of account documents and other available records."}]
[]
[]
[]
[]
["Place :",null,null,null,null,"Signature of person responsible for deduction of tax"]
[" Date :",null,null,null,null,"Full Name         :",null,{"$f":"UPPER(Data!E105)","v":"J.RAMACHANDRUDU"}]
[null,null,null,null,null,"Designation       :",null,{"$f":"UPPER(Data!E108)","v":"MEO, DHONE"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2015-06-30"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"K20","v":4180},{"$f":"(B105-B108)/1000","v":4},null,null,null,null,null,null,null,null,null,null,null,1,"One"]
[null,{"$f":"(C105-B107)/100","v":0},{"$f":"B106","v":0},{"$f":"RIGHT(C106,2)*1","v":0},{"$f":"(C106-D106)/100","v":0},{"$f":"(D106-RIGHT(D106,1)*1)/10","v":0},{"$f":"RIGHT(C106,1)*1","v":0},{"$f":"IF(F106=O106,Q106,IF(F106=O107,Q107,IF(F106=O108,Q108,IF(F106=O109,Q109,IF(F106=O110,Q110,IF(F106=O111,Q111,IF(F106=O112,Q112,IF(F106=O113,Q113,\" \"))))))))","v":" "},{"$f":"IF(F106=1,\" \",IF(G106=O105,P105,IF(G106=O106,P106,IF(G106=O107,P107,IF(G106=O108,P108,IF(G106=O109,P109,IF(G106=O110,P110,\" \")))))))","v":" "},{"$f":"IF(F106=1,\" \",IF(G106=O111,P111,IF(G106=O112,P112,IF(G106=O113,P113,\" \"))))","v":" "},{"$f":"IF(F106=0,\" \",IF(F106>1,\" \",IF(G106=O106,P116,IF(G106=O107,P117,IF(G106=O108,P118,IF(G106=O109,P119,IF(G106=O110,P120,IF(G106=O111,P121,\" \"))))))))","v":" "},{"$f":"IF(F106=0,\" \",IF(F106>1,\" \",IF(G106=O112,P122,IF(G106=O113,P123,IF(G106=O105,P115,IF(G106=0,P114,\" \"))))))","v":" "},{"$f":"IF(F106=0,\" \",\"lakh\")","v":" "},{"$f":"IF(G106=0,\" \",IF(F106>0,\" \",\"lakh\"))","v":" "},2,"Two","Twenty "]
[null,{"$f":"RIGHT(C105,2)*1","v":4},{"$f":"B107","v":4},{"$f":"RIGHT(C107,2)*1","v":4},{"$f":"(C107-D107)/100","v":0},{"$f":"(D107-RIGHT(D107,1)*1)/10","v":0},{"$f":"RIGHT(C107,1)*1","v":4},{"$f":"IF(F107=O106,Q106,IF(F107=O107,Q107,IF(F107=O108,Q108,IF(F107=O109,Q109,IF(F107=O110,Q110,IF(F107=O111,Q111,IF(F107=O112,Q112,IF(F107=O113,Q113,\" \"))))))))","v":" "},{"$f":"IF(F107=1,\" \",IF(G107=O105,P105,IF(G107=O106,P106,IF(G107=O107,P107,IF(G107=O108,P108,IF(G107=O109,P109,IF(G107=O110,P110,\" \")))))))","v":"Four"},{"$f":"IF(F107=1,\" \",IF(G107=O111,P111,IF(G107=O112,P112,IF(G107=O113,P113,\" \"))))","v":" "},{"$f":"IF(F107=0,\" \",IF(F107>1,\" \",IF(G107=O106,P116,IF(G107=O107,P117,IF(G107=O108,P118,IF(G107=O109,P119,IF(G107=O110,P120,IF(G107=O111,P121,\" \"))))))))","v":" "},{"$f":"IF(F107=0,\" \",IF(F107>1,\" \",IF(G107=O112,P122,IF(G107=O113,P123,IF(G107=O105,P115,IF(G107=0,P114,\" \"))))))","v":" "},{"$f":"IF(F107=0,\" \",\"thousand\")","v":" "},{"$f":"IF(G107=0,\" \",IF(F107>0,\" \",\"thousand\"))","v":"thousand"},3,"Three","Thirty "]
[null,{"$f":"RIGHT(B105,3)*1","v":180},{"$f":"B108","v":180},{"$f":"ROUND((C108-E109)/100,0)","v":1},null,null,null,null,{"$f":"IF(D108=0,\" \",IF(D108=O105,P105,IF(D108=O106,P106,IF(D108=O107,P107,IF(D108=O108,P108,IF(D108=O109,P109,IF(D108=O110,P110,\" \")))))))","v":"One"},{"$f":"IF(D108=0,\" \",IF(D108=O111,P111,IF(D108=O112,P112,IF(D108=O113,P113,\" \"))))","v":" "},null,null,{"$f":"IF(D108=0,\" \",\"hundred\")","v":"hundred"},null,4,"Four","Forty "]
[null,null,null,null,{"$f":"RIGHT(C108,2)*1","v":80},{"$f":"(E109-RIGHT(E109,1)*1)/10","v":8},{"$f":"RIGHT(C108,1)*1","v":0},{"$f":"IF(F109=O106,Q106,IF(F109=O107,Q107,IF(F109=O108,Q108,IF(F109=O109,Q109,IF(F109=O110,Q110,IF(F109=O111,Q111,IF(F109=O112,Q112,IF(F109=O113,Q113,\" \"))))))))","v":"Eighty "},{"$f":"IF(F109=1,\" \",IF(G109=O105,P105,IF(G109=O106,P106,IF(G109=O107,P107,IF(G109=O108,P108,IF(G109=O109,P109,IF(G109=O110,P110,\" \")))))))","v":" "},{"$f":"IF(F109=1,\" \",IF(G109=O111,P111,IF(G109=O112,P112,IF(G109=O113,P113,\" \"))))","v":" "},{"$f":"IF(F109=0,\" \",IF(F109>1,\" \",IF(G109=O106,P116,IF(G109=O107,P117,IF(G109=O108,P118,IF(G109=O109,P119,IF(G109=O110,P120,IF(G109=O111,P121,\" \"))))))))","v":" "},{"$f":"IF(F109=0,\" \",IF(F109>1,\" \",IF(G109=O112,P122,IF(G109=O113,P123,IF(G109=O105,P115,IF(G109=0,P114,\" \"))))))","v":" "},null,null,5,"Five","Fifty "]
[null,null,null,null,null,{"$f":"F109","v":8},{"$f":"G109","v":0},null,null,null,null,null,null,null,6,"Six","Sixty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Seven","Seventy "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Eight","Eighty "]
[null,{"$f":"TRIM(H106&\" \"&I106&\" \"&J106&\" \"&K106&\" \"&L106&\" \"&M106&\" \"&N106)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,9,"Nine","Ninety "]
[null,{"$f":"TRIM(H107&\" \"&I107&\" \"&J107&\" \"&K107&\" \"&L107&\" \"&M107&\" \"&N107)","v":"Four thousand"},null,null,null,null,null,null,null,null,null,null,null,null,10,"Ten"]
[null,{"$f":"TRIM(H108&\" \"&I108&\" \"&J108&\" \"&K108&\" \"&L108&\" \"&M108&\" \"&N108)","v":"One hundred"},null,null,null,null,null,null,null,null,null,null,null,null,11,"Eleven"]
[null,{"$f":"TRIM(H109&\" \"&I109&\" \"&J109&\" \"&K109&\" \"&L109)","v":"Eighty"},null,null,null,null,null,null,null,null,null,null,null,null,12,"Twelve"]
[null,{"$f":"IF(B105>0,TRIM(B113&\" \"&B114&\" \"&B115&\" \"&B116)&\" only\",\"Zero only\")","v":"Four thousand One hundred Eighty only"},null,null,null,null,null,null,null,null,null,null,null,null,13,"Thirteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Fourteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Fifteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Sixteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Seventeen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Eighteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Nineteen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Twenty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Thirty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"Forty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"Fifty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"Sixty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,"Seventy "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"Eighty "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,"Ninety "]