PDA

View Full Version : pay calculaiton



geeta
18-09-2010, 11:26 AM
Sir my basic pay in june was 12440 + grade pay 4200

How to calculate 3% increament. I am new in gconnect and want to learn service matter. Please help how to calculate 3% increment.


geeta

K.B.Dhruwanshi
18-09-2010, 03:40 PM
It is very simple. Take total of pay in the payband in June 2010 and Grade Pay. Here it is.
Pay in the payband in June 2010- 12440
Grade pay - 4200
Total Basic Pay in June 2010 - 16640
3% of Basic Pay - (16640*3)/100 = 499
Pay in the pay band in July 2010- 12440+499=12939 rounded off to next ten rupees =12940
K.B.Dhruwanshi

SASI
18-09-2010, 06:10 PM
Sir my basic pay in june was 12440 + grade pay 4200

How to calculate 3% increament. I am new in gconnect and want to learn service matter. Please help how to calculate 3% increment.


geeta

While calculating increment, first calculate 3%, ignore paise and round off to next multiple of 10. In excel this formulae will calculate the increment =CEILING(ROUNDDOWN(A1*3%,0),10), where cell A1 contains pay+gp before increment.

sasi

prasannakumar
18-09-2010, 07:18 PM
While calculating increment, first calculate 3%, ignore paise and round off to next multiple of 10. In excel this formulae will calculate the increment =CEILING(ROUNDDOWN(A1*3%,0),10), where cell A1 contains pay+gp before increment.

sasi


Dear Mr. Sasiji,

I am suggesting one more formula in excel sheet which is the same as you suggested. In our office it was the same problem as Ms. geetha stated. I had developed our pay bill in excel sheet (we input pay in pay band and grade pay in cells A1 and B1 respectively) and for calculating the increment, I suggested the establishment department the following formula which has worked well.

Please consider this as an additional information only.

=CEILING(ROUNDDOWN((A1+B1)*3%,0),10)

Regards
Prasanna Kumar.

naukar
18-09-2010, 08:01 PM
There were many requests from members for sharing PAY BILL PREPARATION PROGRAM and OTHER SIMILAR PROGRAMS (for use of accounts people). If possible, can any body share such programs with other members for their official use.