Revised pension Proposals due to DA raised.xlsx

	A	B	C	D	E	F	G	H
1	Software for Revised Pension Proposals
2	Designed by Ch Nagendra Rao, SA(Maths), MPUPS SIDDARDHA NAGAR, Cell: 9440297273.
4		Data of the Retired Teacher
5		1	Name of the Pensioner		M SYAMA MOHAN
6		2	Designation		Junior Assistant
7		3	Father/Husband's Name		Gopala Krishnamacharyulu
8		4	Present Address		D No: 24-324/1D,Pujitha Towers, Employees Colony,Nuzvid,Nuzvid Mandal,Eluru D.t,Pin Code:521201
10		5	Name of the School/Office		SRRZPH SCHOOL, NUZVID
11		Pension Sanctioning and Disbursing Othority
12		6	Pension Sanctioning Authority	Name	B Hema Latha
13				Designation	Headmistress
14				School/ Mandal (if MEO)	SRRZPH SCHOOL, NUZVID
15				Station	Krishna District
16		7	Name of the Pension Disbursing Authority		STO, Nuzvid
17		Family Pensionar
18		8	Name of the Family pensioner		M Andalu
19			Relation		Wife
20		Bank from Pension drawn and Aadhar details
21		9	Name of the Bank and Branch			SBI, NUZVID
22			S.B . Account No.			10720067257
23		10	a) IFS code and			SBIN0000889
24			b) MICR code of the Bank			521002056
25		11	PAN Card No.			BGAPM9158C
26		12	Aadhaar No.			556261964141
27			Service Particulars			Date	Month	Year
28		13	Date of Birth			13	8	1959
29		14	Date of entering in to service			3	3	1990
30		15	Date of retirement / death			31	8	2019
31		16	Net Qualifying Service			33	0	0
32		17	Date of sanction of Pensionary Benefits			7	6	2022
34		18	Las pay drawn ( as on 31-8-2019) in RPS 2015		Rs.	42490
35			DA%	Already drawn		27.248	To be drawn	38.776
36			HRA%			14.5
39			IR%			27
40			DA GO			1)G.O.Ms.No.94 FINANCE (PC-TA) Dept Dated: 04-11-2020 (DA@30.392%), 2)G.O.Ms.No.51 FINANCE (PC-TA) Dept Dated: 31-07-2021 (DA@33.536%)& 3)G.O.Ms.No.99 FINANCE (PC-TA) Dept Dated: 20-12-2021 (DA@38.776%)
41		PPO details
42		19	PPO No			ZPP/KNA/2815/2019
43			Date			29	8	2019
44		Pensionary Benefits sanctioned
45		20					Now Sanctioned	Already Sanctioned
46			Service Pension			Rs.
47			Gratuity			Rs.	972939.00	892122.00
48			Enhanced Family Pension			Rs.
49			Normal Family Pension			Rs.
50			Commutation			Rs.
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105