decídalo
Documentation
Ask AI
Search Results for

    Show/Hide Table of Contents

    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:copystyles to 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 cell I11 (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.

    In This Article
    Version history Back to top Copyright © data assessment solutions · decidalo.com