1616 - 1684 Arrears calculation sheet

910 views
Skip to first unread message

Prasad C N

unread,
Mar 7, 2018, 5:12:11 AM3/7/18
to bankpe...@googlegroups.com
Dear friends,

XL sheet is attached.

Thanks, a Million. 

With regards, 
Prasad C N
1616-1684 Arrears Calculation.xlsx

T.R.Sitaraman

unread,
Mar 7, 2018, 10:57:18 PM3/7/18
to 'Prasad C N' via bankpensioner
Dear Prasad,
while in service last month, i had basic of 15380/-, DA-3737.03, CCA 375/-, Addl spl allow-340/- and FPA-385/-
Where as i am not having either 340 in special allowance, and 385 as FPA in the drop down of your first page of the chart in spl allow and FPA..
Pl clarify.
Regards,
sitaraman

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensione...@googlegroups.com.
Visit this group at https://groups.google.com/group/bankpensioner.
For more options, visit https://groups.google.com/d/optout.
1616-1684 Arrears Calculation.xlsx

LNG Syn

unread,
Mar 7, 2018, 10:57:52 PM3/7/18
to 'Prasad C N' via bankpensioner
Dear sir,
I have prepared one chart which is attached. I notice that there is difference in the slabs between your chart and my chart. I have tallied the actual pension received in my SB account with the figures in my chart. Figures in column F in sheet "arrears estimate" tally with the actual paid in my SB account.  Can you please help me in locating errors in my chart? Out of academic interest I am asking you. Full working with inputs are provided. Thanks a million and regards. Govindarajan
Arrears Supreme court 13-Feb-2018.xlsx

swantanter.sharma

unread,
Mar 7, 2018, 10:57:52 PM3/7/18
to bankpensioner
Calculations as per sheet seems not to be correct.my basic salary was 13320 with 25 years service and my basic pension was 5015 as on jan2001 but as per sheet the basic pension shown is 4200 app.

Gopalakrishnan Ramachandran

unread,
Mar 8, 2018, 5:35:27 AM3/8/18
to bankpe...@googlegroups.com
Dear Prasadji,

Thank you for the XL sheet. However kindly note that there is no provision for entering:
1. age on next birthday. 52 years,
2. PQA Rs.135/-
3.FPA Rs.385/-.

Kindly advise.

Sincerely

G.Ramachandran
CB-SVRS.




--

nook raju

unread,
Mar 8, 2018, 5:35:40 AM3/8/18
to bankpe...@googlegroups.com
Mr T.R.Sitaraman,Pl clarify one thing people like me who has retired in 2001 VRS and opted pension in 2009-2010(second pension option) ,can they get any benefit from this.

On 7 March 2018 at 18:01, 'T.R.Sitaraman ' via bankpensioner <bankpe...@googlegroups.com> wrote:
Dear Prasad,
while in service last month, i had basic of 15380/-, DA-3737.03, CCA 375/-, Addl spl allow-340/- and FPA-385/-
Where as i am not having either 340 in special allowance, and 385 as FPA in the drop down of your first page of the chart in spl allow and FPA..
Pl clarify.
Regards,
sitaraman

----- Forwarded message -----
From: 'Prasad C N' via bankpensioner <bankpensioner@googlegroups.com>
Sent: Wednesday, 7 March, 2018, 3:42:14 PM IST
Subject: bankpensioner 1616 - 1684 Arrears calculation sheet

Dear friends,

XL sheet is attached.

Thanks, a Million. 

With regards, 
Prasad C N

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensioner+unsubscribe@googlegroups.com.

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensioner+unsubscribe@googlegroups.com.

Yahoo

unread,
Mar 8, 2018, 5:35:40 AM3/8/18
to 'Prasad C N' via bankpensioner
Hi In the sheet attached you have calculated for Commutation while in the judgement there is no mention of it.Pl guide.Bu commutation is even otherwise is recverable/adjusted from pension. How it shall be done.
Rgds
 G K Dora
EPNB
9999256360

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensione...@googlegroups.com.

sekhar G.

unread,
Mar 8, 2018, 5:35:57 AM3/8/18
to bankpensioner, lng...@gmail.com

Desr sir,
The excel sheet is locked and  unable to enter new figure it is asking to unlock the  protected sheet. It is asking password to unlock the sheet.
Sekhar

On 8 Mar 2018 09:27, "LNG Syn" <lng...@gmail.com> wrote:
Dear sir,
I have prepared one chart which is attached. I notice that there is difference in the slabs between your chart and my chart. I have tallied the actual pension received in my SB account with the figures in my chart. Figures in column F in sheet "arrears estimate" tally with the actual paid in my SB account.  Can you please help me in locating errors in my chart? Out of academic interest I am asking you. Full working with inputs are provided. Thanks a million and regards. Govindarajan
 
On 3/7/2018 10:46 AM, 'Prasad C N' via bankpensioner wrote:
Dear friends,

XL sheet is attached.

Thanks, a Million. 

With regards, 
Prasad C N
--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensioner+unsubscribe@googlegroups.com.

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensioner+unsubscribe@googlegroups.com.

sreenivasaprasad

unread,
Mar 8, 2018, 11:04:51 PM3/8/18
to bankpe...@googlegroups.com
May I know interest at 9% on arrears from which date to which date? Please enlighten.






From: LNG Syn <lng...@gmail.com>
Sent: Thu, 8 Mar 2018 09:27:55 GMT+0530
To: 'Prasad C N' via bankpensioner <bankpe...@googlegroups.com>
Subject: Re: bankpensioner 1616 - 1684 Arrears calculation sheet






Dear sir,

I have prepared one chart which is attached. I notice that there
is difference in the slabs between your chart and my chart. I have
tallied the actual pension received in my SB account with the
figures in my chart. Figures in column F in sheet "arrears
estimate" tally with the actual paid in my SB account.  Can you
please help me in locating errors in my chart? Out of academic
interest I am asking you. Full working with inputs are provided.
Thanks a million and regards. Govindarajan

 

On 3/7/2018 10:46 AM, 'Prasad C N' via bankpensioner wrote:


cite="mid:1127805446.92424...@mail.yahoo.com">



Dear friends,




XL sheet is attached.




Thanks, a Million. 




With regards, 

Prasad C N



--

Visit our blog site http:://bankpensioner.blogspot.com

---

You received this message because you are subscribed to the Google
Groups "bankpensioner" group.

To unsubscribe from this group and stop receiving emails from it,
send an email to moz-do-not-send="true" >bankpensione...@googlegroups.com.

Visit this group at moz-do-not-send="true" target='_blank' rel=external>https:roups.google.com/group/bankpensioner.


For more options, visit https://groups.google.com/d/optout.










--

Visit our blog site http:://bankpensioner.blogspot.com

---

You received this message because you are subscribed to the Google Groups "bankpensioner" group.

To unsubscribe from this group and stop receiving emails from it, send an email to bankpensione...@googlegroups.com.

Prasad C N

unread,
Mar 8, 2018, 11:04:51 PM3/8/18
to bankpe...@googlegroups.com, Gopalakrishnan Ramachandran
Dear Sir,

Revised sheet which addresses issued raised by you is attached.

Thanks, a Million.

With regards, 
Prasad C N
1616-1684 Arrears Calculation.xlsx

Sumati M

unread,
Mar 9, 2018, 5:27:24 AM3/9/18
to bankpe...@googlegroups.com
Sir

Can you please share the special vrs optees calc sheet also..both 5year notional service and da arrears ?

Thanks and regards

Sumati

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensione...@googlegroups.com.
Visit this group at https://groups.google.com/group/bankpensioner.
For more options, visit https://groups.google.com/d/optout.
--
SUMATI M

Murali Thirumalai

unread,
Mar 9, 2018, 5:27:38 AM3/9/18
to bankpe...@googlegroups.com
Mr.Prasad, it seems  there is mistake in the DA slab pertaining to revised basic. Please check up.

sekhar G.

unread,
Mar 10, 2018, 4:59:07 AM3/10/18
to bankpensioner
Dear Prasad ji'

The excel sheets are locked and to feed the new datas it

requires Password to remove the protection. Kindly either provide password or 

unprotect the excel sheets.

Regards,
G.Sekhar


ashok gupta

unread,
Mar 11, 2018, 3:12:44 AM3/11/18
to bankpe...@googlegroups.com
On 3/7/18, 'Prasad C N' via bankpensioner

krishna

unread,
Mar 12, 2018, 6:29:01 AM3/12/18
to bankpensioner
I am unable fill the details the details of age, month&year of retirement.
My DOB is 20/071949. I retired on 28.02.2001 under VRS. Retired as MM - III
Have Fpa & pqa. My present basic as on 2005 after ఆడది g five years notional weight age is Rs. 8,001/-.
Can you help calculate the arrears from 2001 to 2005?
Sorry for asking personal favor in a group.
With high regards,
R. Krishna Murthy vrs-2001 from Andhra Bank.

bhaskara sarma

unread,
Mar 13, 2018, 12:12:53 AM3/13/18
to bankpe...@googlegroups.com
You may get around RS 2 lakhs inclusive of Interest.
With regards,
P Bhaskara Sarma.

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensioner+unsubscribe@googlegroups.com.

Nageswara Rao Gullapalli

unread,
Mar 17, 2018, 1:18:12 AM3/17/18
to bankpe...@googlegroups.com, kanneg...@gmail.com
--
G Nageswara Rao

Bharat B. Sahni

unread,
Mar 18, 2018, 11:59:13 PM3/18/18
to bankpensioner
Sir,

Please HELP, my details are here as under;

1. My DOB 09-09-1950
2. Date of Joining Punjab national Bank : 22-Feb-1977
3. Date of VRS (Re) 20-Dec-2000
4. Details of Last Drawn salary
   Basic Pay Rs. 13900-00
   DA           Rs.   3344-31
   PQA        Rs.     340-00
  FPA          Rs.     385-00
TOTAL        Rs.  17969-31

Basic Pension as on 20-Dec-2000 Rs.4613-00

REVISED Basic pension after 05 Years Benefit Rs. 6416-00

What shall be my Basic pension.

Thanking you,

Bharat Sahni





On Saturday, 17 March 2018 10:48:12 UTC+5:30, G Nageswara Rao wrote:
On 12 March 2018 at 17:06, bhaskara sarma <pbsa...@gmail.com> wrote:
You may get around RS 2 lakhs inclusive of Interest.
With regards,
P Bhaskara Sarma.
On Mar 12, 2018 3:59 PM, "krishna" <kmram...@gmail.com> wrote:
I am unable fill the details the details of age, month&year of retirement.
My DOB is 20/071949. I retired on 28.02.2001 under VRS. Retired as MM - III
Have Fpa & pqa. My present basic as on 2005 after ఆడది g five years notional weight age is Rs. 8,001/-.
Can you help calculate the arrears from 2001 to 2005?
Sorry for asking personal favor in a group.
With high regards,
R. Krishna Murthy vrs-2001 from Andhra Bank.

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensione...@googlegroups.com.

--
Visit our blog site http:://bankpensioner.blogspot.com
---
You received this message because you are subscribed to the Google Groups "bankpensioner" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensione...@googlegroups.com.



--
G Nageswara Rao

Mohandas Rao

unread,
Mar 19, 2018, 6:07:52 AM3/19/18
to bankpe...@googlegroups.com
Dear Sri Bharath B Sahni,

​     ​
Your present basic pension will not change as you have already got the benefit of the notional service. You may get some
arrears from 20.12.2000 to 30.04.2005 on account of the 1616-1684 points issue because of the SC judgment of 13.02.2018.

K. MOHANDAS RAO

To unsubscribe from this group and stop receiving emails from it, send an email to bankpensioner+unsubscribe@googlegroups.com.

nook raju

unread,
Mar 19, 2018, 6:07:53 AM3/19/18
to bankpe...@googlegroups.com
Sir,when you were retired whether  you was a clerical or Officer?

On 18 March 2018 at 22:38, Bharat B. Sahni <bharat...@gmail.com> wrote:
To unsubscribe from this group and stop receiving emails from it, send an email to bankpensioner+unsubscribe@googlegroups.com.

Bharat B. Sahni

unread,
Mar 20, 2018, 12:11:25 AM3/20/18
to bankpensioner
Thanks, Sir,

With Regards

Bharat B. Sahni

Bharat B. Sahni

unread,
Mar 20, 2018, 12:11:25 AM3/20/18
to bankpensioner
Was in Officer cader,

Thanks,

Bharat B Sahni


On Monday, 19 March 2018 15:37:53 UTC+5:30, raju wrote:

ajay garg

unread,
Apr 13, 2018, 12:15:16 AM4/13/18
to bankpensioner
Sir,

From which date interest 9 % will be paid by bank. Is it from 1-5-2005 till date of payment. Supreme court judgement is noy clear.

Thanks and Regards

rravindra vijaya bank

unread,
Apr 13, 2018, 6:36:21 AM4/13/18
to bankpe...@googlegroups.com
XL sheet not found, please resend the calculation sheet  for my / my friends use

Ravindra Ramegowda

To unsubscribe from this group and stop receiving emails from it, send an email to bankpensioner+unsubscribe@googlegroups.com.

Nalkoman L

unread,
May 29, 2018, 6:28:45 AM5/29/18
to bankpensioner
Name.Nalkoman.L Date of birth:05/10/1942. Date of joining in the Bank:30/11/1959 Age at VRS 58 years 5 months. Retired as senior manager Scale 3. Basic pension as on date 8135 Basic pension at the date of retirement:6938 Date of retirement 31/3/2001(SVRS)

Kanak Ghosh

unread,
May 30, 2018, 11:39:16 PM5/30/18
to bankpe...@googlegroups.com
How do I use it for calculating my arrears?

--
Reply all
Reply to author
Forward
0 new messages