Spreadsheet: 877684d1724492156-pay-calculation-form-junior-to-senior-scale-pay-calculation-form-junior-to-senior-scale
Sheet: Sheet1

 |  |  |  |  | Salary Month | Pay Scale after Promotion |  | Junior Programmer  Pay Scale | Senior [NAME]
Pay Scale on Date | 2024-08-08 00:00:00 | Pay Scale of Junior Programmer | 35830 |  |  | 36910 |  | 29100 | 35700 |  | Remarks
 |  |  |  |  |  | 36910 |  |  |  |  | Column F from Cell F2 onwards contains formula to return the months
Regular Increment Date/Month | 2025-04-01 00:00:00 |  |  |  |  | 36910 |  |  |  |  | Column I contains formula from Cell I3 onwards to calculate pay scale
 |  |  |  |  |  | 36910 |  |  |  |  | Column J contains formula from Cell J3 onwards to calculate pay scale
In excel column I there is pay scale range starting from cell I2 to I33 which is 29100 in cell I2 and it increase by 3 percentage and rounded to ceiling 10, in I33 the pay scale is 73020 of Junior Programmer,  In column J there is pay scale range starting from J2 to J33 which is 35700 in cell J2 and increase by 3 percentage and rounded to ceiling 10, in J33 the pay scale is 89510 of Senior Programmer. In cell B2 there is present pay scale date which is in this example is 08-aug-2024 and the regular increment date is in cell B4 which is 01-apr-2025 in this case. The present pay scale of Junior Programmer is in cell [NAME] which is 35830 in this example and the pay scale fixation of promoted employee will be done as shown in column G starting from cell G2 onwards and Salary Months will be as per column F. The logic of pay fixation of promoted employee will be as below. In our example, The present pay scale of promoted employee is 35830, then he will get the increment in Junior Programmer cadre as per column I, which is 36910, and his regular increment month/date it 01-apr-2025, in column G the result will be from cell G2 to G9 will be 36910.  When the regular increment month Apr-25 will come in column F Cell (in this case Cell F10) the employee will received next increment in the Junior Programmer cadre which will be in this case is 38020 as per column I and will be fitted in the next higher scale of Senior Programmer  cadre as per column J which is 39030. So this employee will receive 39030 from Apr-25 onwards for next 12 months till mar-26 and then in apr-26 he will received next increment as per column J which will be 40210 in this case and that scale will be last for 12 months and so on. So basically by entering Data in Cell B2, B4 and D2 I expect the result as per Column G from cell G2 onwards. P.S. Colour coding and formatting is for better understanding only. |  |  |  |  |  | 36910
 |  |  |  |  |  | 36910
 |  |  |  |  |  | 36910
 |  |  |  |  |  | 36910
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 39030
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 40210
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 41420
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 42670
 |  |  |  |  |  | 43960
 |  |  |  |  |  | 43960
 |  |  |  |  |  | 43960
 |  |  |  |  |  | 43960
 |  |  |  |  |  | 43960