Automatically translated from Dutch. Some wording may be inaccurate.
Format A uses several rows per placement: a separate row for each type of hours.
If a placement has regular hours and two types (percentages) of overtime, it has three rows.
An example of such a file:
Regelneef identifies the data by the column names. The header row does not have to be in a fixed position. In this example it is row 2, but it could also start at row 6. Regelneef finds it automatically and expects the data immediately below it. This flexible header position allows you to display dates above the weekday names, for example, to make the file easier to read. Regelneef ignores that information.
The order of the columns may vary.
The format deliberately allows some flexibility. You may include extra columns that are ignored during import. In the example, these columns ('naam', 'totaal', 'totaal per uzk') are grey to indicate this. This extra information can make the hours file easier to read and check manually.
The following column names are required:
•Debiteurnr: repeat this on every row, even if the entire file concerns the same debtor
•Personeelsnr: repeat this on every row
•Urentype: N = regular hours, O = overtime hours, T = premium hours
•Percentage: the percentage of the hourly wage in the placement
•Begindatum: the date of the Monday concerned. In practice this will be the same for all rows.
•Ma through Zo
Hours from different weeks cannot be combined in one file.
The first worksheet is read. To use a different worksheet, name that worksheet 'regelneef'.