4.
Completing the Details in the Excel Worksheet
In this
worksheet, one can add the company’s details and define its policy
regarding working hours as well as employee details, such as the full name, the
address and phone numbers.
The yellow row on this page is for defining the parameter values of the
company’
s default contract; if an employee has a different contract, the specific
parameter values should be entered in the relevant row.
➢
To add the company’s details:
1.
Company Name Enter the company’s name.
➢
To define the company’s policy regarding overtime:
1. To display the drop-down menu, click the little arrow to the right, and
select:
•
1
—
The company pays for overtime hours
•
0
—
The company does not pay for overtime hours.
Figure 27. General Worksheet; Overtime Policy
2.
If you selected 0
in the previous instruction
: Enter the company’s
default parameter values in the yellow row, as shown in Figure 28.
Figure 28. General Worksheet; Default parameter values regarding overtime
In this figure:
X type overtime
hours
The number of hours considered for a specific
overtime type.
Percent for
overtime type X
Additional payment for overtime type X.
The default contract refers to all the employees. If the contract of a specific
employee differs from the default contract, enter the specific different value in
the appropriate Excel cell.
