How do to in Civil pay fixation

Civil pay fixation

Link to open:-

Civil pay fixation Calculator

How to do it:-

1. Enter the Date of appointment in the Date cell and follow the format which is also mentioned in the Date of enrollment cell, which is day month (short format Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec)  and in year cell should just enter last figure of the year                    (eg 22 Apr 10). When you enter date and hit enter key and grade cell you should select the grade in drop down menu or just type grade in the Grade column eg (17) and then press enter. 
2. 1^st promotion of Civil you should enter date of promotion, in grade cell select the grade from drop down menu and then select from the drop down menu of Option /Add Inc,” Appt/Prom before 2nd Jun, Appt/Prom after 1st Jun, 2x premature increment, Promotion/ w/o Opt, Upgrade Timescale 1step Opt, Upgrade Timescale 1step w/o Opt, Promotion/with opt”.
3. For the Next promotions you should follow above instructions according to date of promotion, use drop down menu for grade or just type grade in the Grade column eg (17) and then press enter. In  Option/ Add inc menu select ,” Appt/Prom before 2nd Jun, Appt/Prom after 1st Jun, 2x premature increment, Promotion/ w/o Opt, Upgrade Timescale 1step Opt, Upgrade Timescale 1step w/o Opt, Promotion/with opt”.
4. On Educational/Add increment you should enter date , which is day month (short format Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec)  and in year cell just enter last figure of the year (eg 22 Apr 10) and  Option /Add inc you should enter how many increment you will get for example educational increment of FA is two(2), in this case you should enter two (2) in Option/ Add inc column and any other increment flow in this category you should follow the side procedure .

5. If no increment is allowed due to any misconduct or LFP you should and use Educational/Add increment Rows. You should enter date , which is day month (short format Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec)  and in year cell just enter last figure of the year           (eg 22 Apr 10) and  Option /Add inc you should enter how many increment less for example you are in LFP of one year in this case you should enter negative figure eg. (-1) in Option/ Add inc column and any other loss flow in this category you should follow the said procedure. 

6. Report will be generated whenever basic pay has any change either its change due to promotions, revision of pay scale, educational (which ceased 1^st December 2001), additional increments according to the grade.  

• Report of result is 100% accurate according revision of pay scale to which is best of my knowledge.
• Feedback all away welcome.  

·