Saturday 5 September 2015

Government Announces One Rank One Pension Scheme for Ex-Servicemen

The Government has announced the One Rank One Pension scheme for the Ex-Servicemen. This was announced by the Defence Minister Shri Manohar Parrikar here today. The following is the statement of the Defence Minister:

“Government of India respects its Defence Forces and Ex-Servicemen for their valour, patriotism and sacrifices. The Government is proud of their devotion to duty and bravery. Our forces, besides vigilantly and gallantly defending the nation, have displayed exemplary standards of courage and bravery in natural calamities, law and order situations and other difficult circumstances.

The issue of “One Rank One Pension” (OROP) has been pending for nearly four decades. It is a matter of deep anguish that the various governments remained ambivalent on the issue of OROP. In February 2014, the then Government stated that OROP would be implemented in 2014-15, but did not specify what OROP would be, how it would be implemented or how much it would cost. An estimated Rs. 500 crore provided for OROP in the budget presented in February 2014 by the then government was not based on any thorough analysis. It is pertinent to mention that the then Minister of State for Defence in 2009 had, in reply to a question, informed Parliament that there are administrative, technical and financial difficulties in implementing OROP. It is for these reasons that the present government took some time to fulfil its promise.

Prime Minister Shri Narendra Modi has, on various occasions, reiterated the Government’s commitment to implement OROP for Ex-Servicemen under military pension. As stated above, the previous government has estimated that OROP would be implemented with a budget provision of a mere Rs. 500 crore. The reality, however, is that to implement OROP, the estimated cost to the exchequer would be Rs. 8,000 to 10,000 crore at present, and will increase further in future.

The Government held extensive consultations with experts and Ex-Servicemen. The main argument for OROP is that the Defence personnel retire early and thus are not able to get the benefits of serving till normal retirement age. Despite the huge fiscal burden, given its commitment to the welfare of Ex-Servicemen, the Government has taken a decision to implement the OROP.

In simple terms, OROP implies that uniform pension be paid to the Armed Forces personnel retiring in the same rank with the same length of service, regardless of their date of retirement. Future enhancements in the rates of pension would be automatically passed on to the past pensioners. This implies bridging the gap between the rate of pension of current and past pensioners at periodic intervals.

Under this definition, it has been decided that the gap between rate of pension of current pensioners and past pensioners will be bridged every 5 years.

Under the OROP Scheme:

The benefit will be given with effect from 1st July, 2014. The present government assumed office on 26th May, 2014 and therefore, it has been decided to make the scheme effective from a date immediately after.

Arrears will be paid in four half-yearly instalments. All widows, including war widows, will be paid arrears in one instalment.

To begin with, OROP would be fixed on the basis of calendar year 2013.

Pension will be re-fixed for all pensioners retiring in the same rank and with the same length of service as the average of minimum and maximum pension in 2013. Those drawing pensions above the average will be protected.

Personnel who voluntarily retire will not be covered under the OROP scheme.

In future, the pension would be re-fixed every 5 years.

It is estimated that the expenditure on arrears alone would be ten to twelve thousand crores of rupees.  Apart from the fact that the previous government had provided for only Rs. 500 crore in the budget, it is noteworthy that the Koshiyari Committee had accepted the estimate of Rs. 235 crore as additional financial burden to implement OROP. The present government has accepted OROP in true spirit without being constrained by these inaccurate estimates.

OROP is a complex issue. A thorough examination of interests of retirees of different periods and different ranks is needed. The inter-service issues of the three Forces also require consideration. This is not an administrative matter alone. Therefore, it has also been decided that a One Member Judicial Committee would be constituted which will give its report in six months.

Prime Minister Shri Modi has fulfilled his commitment and approved OROP for Armed Forces personnel. Ministry of Defence will soon issue detailed Government Order.”

Source:http://www.pib.nic.in/newsite/erelease.aspx?relid=0

Government may increase maternity leave from six to eight months


Happy Janmashtami And Happy Teachers Day

“On the auspicious occasion of Janmashtami, I extend hearty greetings and good wishes to all my fellow citizens. 

Let us on this day imbibe the teachings of Lord Krishna which proclaim the triumph of virtue and righteousness over intolerance and narrowness of mind. 

On this day, may all of us reaffirm our commitment to pursue the path of duty without concern for reward and re-dedicate ourselves to the progress and prosperity of our diverse and multi-cultural nation”. 

-The President of India, Shri Pranab Mukherjee

Happy Teacher's Day

Parcel COD Payment Status Tracking in Parcel Net

Track COD Payment Status in Parcel Net

Payment Status also can be tracked in Parcel Net website to ensure the payment.
Image result for parcelnet cod  tracking

Solution

  1. Login to https://services.ptcmysore.gov.in/ParcelNet/ . 
  2. Go to COD Reports -> COD Article Details enter the COD article number 
  3. Click on the search button. 
  4. The delivery of the article has been updated in epayment server . 
Contact the Office of Payment to Update / raise the ticket with CEPT.

Employment News : 05th Sep to 11 Sep 2015





  1.  Vijaya Bank, Bangalore.
    Name of Post – Manager Security and Manager Rajbhasha. 
    No. of Vacancies – 36
    Last Date – 19.09.2015
  2. Uttarakhand Open University, Nainital. Name of Posts –Professor, Associate Professor and Assistant Professor.
    No. of Vacancies - 25
    Last Date – 21.09.2015
  3. Garden Reach Shipbuilders & Engineers Ltd., KolkataName of Posts – Assistant Manager (E-1).
    No. of Vacancies – 52
    Date- 14.09.2015
  4. Steel Authority of India Limited, West Bengal. Name of Posts – Dy. Managers (Grade E-3).
    No. of Vacancies –27
    Last Date – -25.09.2015
  5. Central Council for Research in Siddha, Chennai. Name of Post –Research Officer (Siddha & Siddha Pharmacy).
    No. of Vacancies -27
    Last Date: – Within 60 days
  6. CSIR-Indian Institute of Petroleum, Uttarakhand. Name of Post –Scientist, Sr. Scientist, Principal Scientist, Sr. Principal Scientist.
    No. of Vacancies –14
    Last Date – 05.10.2015
Source : http://employmentnews.gov.in/

Your Excel formulas sheet: 15 tips for calculations and common tasks

Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For example, there are several ways to enter formulas and calculate numbers in Excel.


1. Manually enter Excel formulas:


Long Lists: =SUM(B4:B13)

Short Lists: =SUM(B4,B5,B6,B7); =SUM(B4+B5+B6+B7). Or, place your cursor in the first empty cell at the bottom of your list (or any cell, really) and press the plus sign, then click B4; press the plus sign again and click B5; and so on to the end; then press Enter. Excel adds/totals this list you just “pointed to:” =+B4+B5+B6+B7.

Excel formulas







2. Click the Insert Function button


Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list:

=COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).

=COUNTA(B3:B13) Counts all characters in a range (also ignores blank/empty cells).


3. Select a function from a group (Formulas tab)


Narrow your search a bit and choose a formula subset for Financial, Logical, or Date/Time, for example.

=TODAY() Inserts today’s date.


4. The Recently Used button


Click the Recently Used button to show functions you've used recently. It's a welcome timesaver, especially when wrestling with an extra-hairy spreadsheet.

=AVERAGE(B4:B13) adds the list, divides by the number of values, then provides the average.


5. Auto functions under the AutoSum button


Auto functions are my editor's personal favorite, because they're so fast. Select a cell range and a function, and your result appears with no muss or fuss. Here are a few examples:

=MAX(B4:B13) returns the highest value in the list.

=MIN(B4:B13) returns the lowest value in the list.


AutoSum in ExcelJD SARTAIN

Use the AutoSum button to calculate basic formulas such as SUM, AVERAGE, COUNT, etc.


Note: If your cursor is positioned in the empty cell just below your range of numbers, Excel determines that this is the range you want to calculate and automatically highlights the range, or enters the range cell addresses in the corresponding dialog boxes.



Bonus tip: With basic formulas, the AutoSum button is the top choice. It’s faster to click AutoSum>SUM (notice that Excel highlights the range for you) and press Enter.



Another bonus tip: The quickest way to add/total a list of numbers is to position your cursor at the bottom of the list and press Alt+ = (press the Alt key and hold, press the equal sign, release both keys), then press Enter. Excel highlights the range and totals the column.



Five handy formulas for common tasks


The five formulas below may have somewhat inscrutable names, but their functions save time and data entry on a daily basis.


Note: Some formulas require you to input the single cell or range address of the values or text you want calculated. When Excel displays the various cell/range dialog boxes, you can either manually enter the cell/range address, or cursor and point to it. Pointing means you click the field box first, then click the corresponding cell over in the worksheet. Repeat this process for formulas that calculate a range of cells (e.g., beginning date, ending date, etc.)



1. =DAYS


This is a handy formula to calculate the number of days between two dates (so there’s no worries about how many days are in each month of the range).

Example: End Date October 12, 2015 minus Start Date March 31, 2015 = 195 days

Formula: =DAYS(A30,A29)


2. =NETWORKDAYS


This similar formula calculates the number of workdays (i.e., a five-day workweek) within a specified timeframe. It also includes an option to subtract the holidays from the total, but this must be entered as a range of dates.

Example: Start Date March 31, 2015 minus End Date October 12, 2015 = 140 days

Formula: =NETWORKDAYS(A33,A34)


3. =TRIM


TRIM is a lifesaver if you’re always importing or pasting text into Excel (such as from a database, website, word processing software, or other text-based program). So often, the imported text is filled with extra spaces scattered throughout the list. TRIM removes the extra spaces in seconds. In this case, just enter the formula once, then copy it down to the end of the list.

Example: =TRIM plus the cell address inside parenthesis.

Formula: =TRIM(A39)


Excel formulas


4. =CONCATENATE


This is another keeper if you import a lot of data into Excel. This formula joins (or merges) the contents of two or more fields/cells into one. For example: In databases; dates, times, phone numbers, and other multiple data records are often entered in separate fields, which is a real inconvenience. To add spaces between words or punctuation between fields, just surround this data with quotation marks.

Example: =CONCATENATE plus (month,”space”,day,”comma space”,year) where month, day, and year are cell addresses and the info inside the quotation marks is actually a space and a comma.

Formula: For dates enter: =CONCATENATE(E33,” “,F33,”, “,G33)

Formula: For phone numbers enter: =CONCATENATE(E37,”-“,F37,”-“,G37)


5. =DATEVALUE


DATEVALUE converts the above formula into an Excel date, which is necessary if you plan to use this date for calculations. This one is easy: Select DATEVALUE from the formula list. Click the Date_Text field in the dialog box, click the corresponding cell on the spreadsheet, then click OK, and copy down. The results are Excel serial numbers, so you must choose Format>Format Cells>Number>Date, and then select a format from the list.

Formula: =DATEVALUE(H33)


Three more formula tips


As you work with formulas more, keep these bonus tips in mind to avoid confusion:


Tip 1: You don’t need another formula to convert formulas to text or numbers. Just copy the range of formulas and then paste as Special>Values. Why bother to convert the formulas to values? Because you can’t move or manipulate the data until it’s converted. Those cells may look like phone numbers, but they’re actually formulas, which cannot be edited as numbers or text.



Tip 2: If you use Copy and Paste>Special>Values for dates, the result will be text and cannot be converted to a real date. Dates require the DATEVALUE formula to function as actual dates.



Tip 3: Formulas are always displayed in uppercase; however, if you type them in lowercase, Excel converts them to uppercase. Also notice there are no spaces in formulas. If your formula fails, check for spaces and remove them.


Excel formulas

SSC Combined Graduate Level (CGL) (Tier-II) 2014 Final Result Out



SSC Combined Graduate Level (CGL) (Tier-II) 2014 Final Result Out :
Date
Examination name and year
Write Up
Result
Marks
2nd September 2015
Combined Graduate Level Examination, 2014 - declaration of final result.LIST OF THE CANDIDATES IN ROLLNO. ORDER RECOMMENDED FOR APPOINTMENT FOR INTERVIEW POSTS OTHER THAN STATISTICAL INVESTIGATOR
2nd September 2015
Combined Graduate Level Examination, 2014 - declaration of final result.LIST OF THE CANDIDATES IN ROLLNO. ORDER RECOMMENDED FOR APPOINTMENTFOR THE POST OF STATISTICAL INVESTIGATOR GR.II
2nd September 2015
Combined Graduate Level Examination, 2014 - declaration of final result.LIST OF THE CANDIDATES IN ROLLNO. ORDER RECOMMENDED FOR APPOINTMENTFOR NON-INTERVIEW POSTS

Pradhan Mantri Jeevan Jyoti Bima Yojana (PMJJBY) and Pradhan Mantri Suraksha Bima Yojana (PMSBY) are going to be launched in all the CBS Post Offices w.e.f. 7th September, 2015