Hello Friends...........
I am in a trouble in Excel Due Drawn sheet.........I manually create a Excel calculation sheet.........my sheet is working properly without any mistake.......but it is manually........i want to convert it in automatic calculation sheet......
Now i am explaining the problem Step by step
Step 1. I manually feed Rs. 8942 in BASIC PENSION column=8942
Step 2. Period I just mention "START MONTH BASIC PENSION=01.01.2014"
Step 3. Enter "LAST MONTH BASIC PENSION=30.06.2015"
after enter the values in Step 1 to Step 3, excel auto insert row from Step 2 (01.01.2014) to Step 3 (31.06.2015) with Step 1 "8942" (01.01.2014 TO 30.06.2015 )as mentioned in My Excel sheet (attached)
Step 4. Now it takes auto DR value from DR Rates which are mentioned in DR SHEET
01.01.2014 Example:- Basic Pension=8942, DP=0, Commutation=0, DR=roundup((Basic Pension + DP)*100/100,0)=8942
30.06.2015 Example:- Basic Pension=8942, DP=0, Commutation=0, DR=roundup((Basic Pension + DP)*113/100,0)=10105
and i am totally confused how to do? please help me
(Sheet Attached)
Bookmarks