annual increment

[bibra]

while creating a payroll there are annual increments which are given on the 1st of july every year
is there any video or thread which gives the details of how to build the increment into the payroll

conditions

--percentage increment could vary from year to year
--also the date date of announcement of the increment also varies--so for this year the increment is announced in october so i would have to calculate the supplementary claim from july to september also

 

[BrianJN1]

Is something what I have offered in my link too simple?

For each employee I've offered a "base" monthly sum. In each month that has incremented by the 0.03 I have in October.
I have the October date in C2. Col C also has a calculation of back paying of the increment.

https://www.dropbox.com/s/hewkvmzrqfdm0md/Payroll.xlsx?dl=0

 

[bibra]

Is something what I have offered in my link too simple?

For each employee I've offered a "base" monthly sum. In each month that has incremented by the 0.03 I have in October.
I have the October date in C2. Col C also has a calculation of back paying of the increment.

https://www.dropbox.com/s/hewkvmzrqfdm0md/Payroll.xlsx?dl=0

thanks for the quick response
how do i upload my worksheet to dropbox

 

[BrianJN1]

Do you have Dropbox? If not locate it with a search engine and create an account. Conversely use an cloud site that you may have and share there, otherwise the site offers its own suggestions.

 

[bibra]

Do you have Dropbox? If not locate it with a search engine and create an account. Conversely use an cloud site that you may have and share there, otherwise the site offers its own suggestions.

https://www.dropbox.com/s/gi48dt9zjanq9l4/New Microsoft Excel Worksheet.xlsx?dl=0

 

[BrianJN1]

@ bibra Please see my PM.

 

[BrianJN1]

Bibra, I think that a repost of that workbook without names in all of your tables would be appropriate.
Then all can appreciate the full scope of your worksheet.
A brief explanation of the interaction of the formulae from table to table, where appropriate for your increment inclusion would be useful too.
As you require minimal adjustments to the layout and formulae, a suggestion as to where it might be most convenient for you to see the inclusion and which existing columns it will impact should be of assistance.

 

[bibra]

Bibra, I think that a repost of that workbook without names in all of your tables would be appropriate.
Then all can appreciate the full scope of your worksheet.
A brief explanation of the interaction of the formulae from table to table, where appropriate for your increment inclusion would be useful too.
As you require minimal adjustments to the layout and formulae, a suggestion as to where it might be most convenient for you to see the inclusion and which existing columns it will impact should be of assistance.

ok
will do

 

[bibra]

an explanation for each column value with formulae as derived

https://www.dropbox.com/s/4sgrzxqvkjs3f0a/first.mht?dl=0

open with browser since its saved as an .mht file exported from evernote

 

[BrianJN1]

an explanation for each column value with formulae as derived

https://www.dropbox.com/s/4sgrzxqvkjs3f0a/first.mht?dl=0

open with browser since its saved as an .mht file exported from evernote

Wow! That does seem quite complex although taken on the basis of one row at a time, from table to table, that may not be so.

For the benefit of others who may view, the explanations mentioned are annotations within the document that bibra has mentioned via his link.

So, where/how is the best place to install an increment percentage with least disruption to the overall layout of the sheet?