Timesheet Export Templates
Note: Time recording is currently a beta feature and is being rolled out with pilot customers. If you would like to take part, please get in touch with us.
The timesheet export writes a person's recorded time for a period into an Excel file (see Exporting a timesheet). The file is not built from a fixed layout. It is filled into an Excel template: an ordinary workbook with placeholders in some of its cells, which decídalo replaces with the person's data and one row per recorded entry. Everything else in the workbook (logos, texts, fonts, colours, number formats, formulas) stays as you designed it, so the export can match the format your customers expect.
This page describes where the templates are managed and how to write one.
Who can manage templates
The page is found under Administration → Time recording → Timesheet export templates. It needs two things:
- time recording is enabled for your company, and
- you hold the Template management permission, the same one that manages CV templates.
Everyone who can export a timesheet can choose among the templates; only managing them needs the permission.
Templates per language
Templates are kept per language. Pick the language at the top of the page; the list shows that language's templates. In the export, people see the templates of their own screen language first and can switch the language to use another one.
One template per language can be the default. It is preselected in the export. A language without a default uses its first template, and a language without any template uses the standard template that comes with decídalo. The standard template exists in English and German; other languages use the English one. It is always listed last and can only be downloaded, which makes it a good starting point for a template of your own.
| Action | Description |
|---|---|
| Upload template | Add an Excel workbook (.xlsx, up to 5 MB) to the selected language, under a name of your choice. |
| Download | Download the workbook, to edit it and upload the new version. |
| Set as default | Make the template its language's default. The previous default of that language stops being one. |
| Rename | Change the name shown in the export. |
| Delete | Remove the template. If it was the default, the language falls back as described above. |
When you upload a template, decídalo reads its placeholders. Any it does not recognize are listed after the upload. The template is stored anyway, and those cells simply stay empty in the export, so you can correct a typo and upload the workbook again.
Writing a template
Write a placeholder as the whole content of a cell, starting with %, for example %User.DisplayName. The cell keeps its formatting, so format a date cell as a date and a time cell as a time.
- The entry rows. Put the
%Entries.…placeholders of one entry next to each other in a single row. Add;insert:copystylesto the first of them, for example%Entries.WorkDate;insert:copystyles. Every entry then gets a row of its own with the formatting of that row. Without it, the entries are written over the rows below. - Formulas in the entry rows. A formula inside the row (a cell that is not a placeholder) is repeated for each entry when the first placeholder also carries
;copyrange:R<row>C<column>:R<row>C<column>, naming the formula's cell by row and column number. For a formula in cellI11(row 11, column 9) that is%Entries.WorkDate;insert:copystyles;copyrange:R11C9:R11C9. - Durations and sums. Start, End, Pause, Time and every recorded duration are written as Excel times. Format the cells as
hh:mm, and format sums as[hh]:mm, otherwise a total above 24 hours starts again at zero. The simplest way to total a column is to make the entry row part of an Excel table with a totals row: the table grows with the entries and its totals follow. Excel recalculates all totals when the file is opened. - Distances are written as numbers, in the unit of their recording type.
The standard template shows all of this in a small sheet: header fields, an entry table and a total.
Placeholders
The Available placeholders list at the bottom of the page shows every placeholder of your company, including the ones for your own recording types and custom fields.
General and person
| Placeholder | Content |
|---|---|
%CurrentDate |
The day of the export. |
%User.DisplayName |
The person whose time is exported. |
%User.FirstName, %User.LastName |
Their first and last name. |
%User.EmployeeID |
Their employee ID. |
%User.Email |
Their email address. |
%User.OfficePhone, %User.MobilePhone |
Their phone numbers. |
%User.JobTitle |
Their job title, in the language of the template where it exists. |
%User.Team, %User.TeamCode |
Their team and its code. |
%User.Manager |
Their manager. |
%User.CostCenter |
Their cost center. |
%User.Location, %User.CountryCode |
Their location and country. |
%User.UserID |
The internal number of the person in decídalo. |
The exported period and its filters
These describe what was chosen in the export. A filter that was not used leaves its placeholders empty.
| Placeholder | Content |
|---|---|
%Filter.From, %Filter.To |
First and last day of the period. |
%Filter.Year, %Filter.Month |
Year and month of the first day. |
%Filter.ProjectName, %Filter.ProjectCode |
The project the export was narrowed to. |
%Filter.Customer |
That project's customer, or the order's. |
%Filter.OrderName, %Filter.OrderCode |
The order the export was narrowed to. |
%Filter.OrderPositionName, %Filter.OrderPositionCode |
The order position the export was narrowed to. |
One row per entry
| Placeholder | Content |
|---|---|
%Entries.WorkDate |
The day the entry was recorded for. |
%Entries.Subject |
What the time was recorded on, in one line exactly as the timesheet shows it, for example Apollo · Order 1 · Position 1 · Development. |
%Entries.ProjectName, %Entries.ProjectCode |
The project. |
%Entries.WorkPackage |
The work package. |
%Entries.ActivityType, %Entries.GeneralActivity |
The activity. |
%Entries.Customer |
The customer. |
%Entries.OrderName, %Entries.OrderCode |
The order. |
%Entries.OrderPositionName, %Entries.OrderPositionCode |
The order position. |
%Entries.IsBillable |
Whether the time is billable. |
%Entries.Status |
The entry's status, in the language of the template. |
%Entries.StartTime, %Entries.EndTime, %Entries.Pause, %Entries.Time |
Start, end, pause and recorded time. |
%Entries.Description, %Entries.BillingComment |
The description and the comment for billing. |
%Entries.RecordingEntryCode |
The entry's code from an imported system, where it has one. |
Recording types (such as travel time or a travelled distance) and your company's custom fields on time entries each have an %Entries.… placeholder of their own. Only active recording types are exported. Their exact names are shown in the Available placeholders list.