Calculation of salary

The calculation of the SP, with the possibility of changing the position, adding new positions, changing the rate and other functions can be added according to the SP.

The task:
Teachers have the following positions and deposits:
Professor is 15,000 UAH.by ;
The docent is 9000 UAH.by ;
Higher Teacher is 7,000 UAH.by ;
The assistant is 6,000 UAH.

Calculate the reward for teachers.
If the experience is from 5 to 10 years - 10% of the deposit is paid,
from 10 to 20 years - 20% savings,
up to 30 years of age - 25% savings,
Over 30 years - 30% savings.
Calculate the amount of the supplement and the amount before the payment with the account of the deposit and the supplement.
Calculate the total amount of payments by the educational institution; the number of teachers who do not receive a stage supplement and their total amount to pay.
For each position to determine the number of teachers and their total amount to pay.
#Relationship #Relationship #Relationship
#Google Sheets #Tables #Excel