You are here

Journal table

In this the table working hours are inserted, as well as notes and eventual returns.

Working Days and Festives

Days are considered as working days unless a "0" value is inserted in the Festive column.

Settings for the week are defined in the File Properties -> Start, but may be altered using codes in the Festive column, for example:

  • If you never work on Sundays, enter "W0" on the first Sunday.
    The program will tag all subsequent Sundays with "(0)".
  • If you do not work on the first day of the year, enter "0".
    Use same for all other days of the year that are holidays.
  • Enter "1" (or any other value starting with 1) for other days that you do not have to work, but which are not holidays.

Temporal values in hours and minutes

All temporal values are expressed and visualized in hours and minutes (e.g. 10:55). An hour and a half is visualized as '1:30' (an hour and thirty minutes).
The ":"mark divides the hours from the minutes and the minutes from the seconds. The dot "." divides the seconds from the milliseconds.

If you enter a value preceded by the ">" or "<" sign (minor or major), the software considers it a decimal value and converts it in hours and minutes.

  • "<1.50" becomes 1:30.
  • "<1.75" becomes 1:45 (one hour and three quarters).

Colours and row formats

The colour of the rows is automatically generated

  • The starting row and the total row will be displayed in bold.
  • Daily rows:
    • Festives are in red.
    • Non working days are blue.
    • Today's date, highlighted in yellow.

Columns of the Journal table

  • Section
    The identifier of the row, which can be empty (rows of daily values) is composed as follows:
    • By period:
      • All. For the rows.
      • Year. For rows of the year.
      • Month. For the rows of the month
      • Week. For the rows of the week.
      • Day. For the rows of the day.
    • By type
      • CarryForward.
        Rows that are carried forward
      • Start
        Beginning rows, in which to insert starting values.
        • Holiday hours balance.
        • Adjustments.
      • Total
        Rows for the total of the values from the relative columns.
        The following are added:
        • The values: of the daily rows.
        • The adjustments from the Start section, and
      • Balance
        For the holiday hours balance. The sum of the holidays found in the rows "CarryForward" and "Start", minus the sum of the daily holiday hours.
      • SpaceAfterMonth
        to signal that there must be an empty row.
  • Date
    The date of the day
  • Festive
    A code can be inserted to signal that the day is festive.
    If you do not insert a code the default values will depend on the file properties.
    • Empty. Working day
    • 0 The day is festive (the row will be red).
      (0) Automatically set festive day.
      No value will appear in the "Due" column.
    • 1 The day is non-working (the row will be blue).
      (1) Automatically set non-working day.
      No value will appear in the "Due" column.
    • 2 (or any other value that doesn't begin with 0 or 1) The current day is a working day. It overwrites the predefined value.
    • Codes beginning with W (week day).
      This code sets up the predefined value for the relative week day.
      • W Sets the current weekday as working.
      • W0 Sets the current weekday as festive.
      • W1 Sets the current weekday as non-working
      • WR (reset) resets the current value with the predefined one from the file properties
      • WA resets all days with the predefined ones from the file properties
  • Day description
    Text automatically completed by the software.
    If in a day's row a text preceded by an hashtag is inserted (e.g. "#Christmas", "#Thanksgiving"), the inserted value will be kept.
  • Description
    The column will be automatically filled out by the software
  • Notes
    To insert one's own notes.
  • Code
    To be used to signal an optional project code or a client's identifier.
  • Worked hours
    • Work1 and Work2
      To signal a value in terms of worked hours
    • Start1,Stop1, Start2, Stop2, Start3, Stop3, Start4, Stop4, Start5, Stop5
      These columns allow the user to enter the start and the end of a working period.
      The starting value must not be lower than the preceding End value.
    • Worked
      Calculated by the software. The sum of worked hours.
  • Sick Leave
    Hours of sick leave.
    Autocompletion will suggest the daily difference
    • Sick leave
    • Holidays
    • Service
      For mandatory absences, e.g. mandatory military service.
    • Other
    • Absences
      Calculated by the software, the sum of absences.
  • Adjustment
    Adjustments in term or working hours
  • Total
    The sum of worked hours, leaves and adjustments.
  • Due
    The due daily hours
  • Due Code
    If the Due code is left empty, the due value is completed by the software, according to the file basic data settings (available from the File menu -> File and accounting properties -> Start)
    • Codes to be entered in the Due code column, in order to edit the daily due from the row you are in. You will then need to enter the new value in the Due column.
      • DS (Set Today)
        Sets the due hours for the current day, without changing any other day.
      • WS (Set Week Day)
        Sets the due hours for a specific week day (Tuesday for example) and for the same following days (following Tuesdays)
      • PS (Set Predefined)
        Sets the due hours from that day on
    • Codes to be used to reset the daily due
      • WR (Reset Week Day).
        Resets the predefined value for the week day.
      • WA (Reset All Week Days)
        Resets all predefined values related to the weekdays.
      • PR (Reset Predefined)
        Resets the general predefined value. Removes the general predefined value.
      • PA (Reset Predefined and Week Day)
        Resets the general predefined value and the ones of the week.
        It will be like starting from scratch.
    • Code to reset the Progressive calculation
      • RP (Restart progressive)
        The Progressive column amount will restart from zero.
  • Due
    The due hours for the day
    The due value from the starting rows is not used to calculate the "Difference" and the "Total".
    • If there's no Due Code, the hours will be completed automatically by the software using the predefined values.
      The rows marked as "Festive" (0) or "Non-Working" (1) are not completed.
    • If there's a code the respective value will be used.
  • Difference.
    The "Total" minus the "Due".
    In the starting rows, the "Total" will not take account of the "Due".
  • Progressive.
    The "difference" of the row added to the "difference" of the previous one.
  • Split1 e Split2
    Time fields that can be used to keep track of the hours invested in a particular project.

Adding new columns

With the command "Data" -> "Columns setup" it is possible to add new columns.

If columns are of the data type "Number", "Amount" or "Time counter" the values will be summed up.
Columns can be added, for example, to keep track of expenses, miles traveled or any other value that can be of interest to the user.

Views of the Journal table

The following views are created automatically:

  • Base
    With the base columns.
  • Minimal
    With the editable columns.
  • Complete
    All columns are displayed.

Share this article: Twitter | Facebook | Email


Help us improve the documentation

We welcome feedback on how to improve this page.
Tell us what theme needs a better explanation or how to clarify a topic.