Configuration instructions
Some settings must be performed on the Cfg tab of the spreadsheet file.
The tracker shows one year at a time. This must be set here.
🚧 Insert screenshot here
The column C of the tracker is the time ratio (see Use instructions). Some behaviors are controlled from this tab.
🚧 Insert screenshot here
| Ratio | Description |
|---|---|
| Half-day auto-switch threshold | The content of C column is calculated. If you began to type your spent time on a line and the total is below this ratio of expected time for the day, it will be set to half day instead of full day. You will remain able to override the time ratio. |
| Pause deduction threshold | The minimal pause of the rule set will be deduced from your spent time only if the time ratio in column C is above this value. |
The rule sets allow you to specify several constraints on how you are supposed to spend your time at work. The possible constraints were inspired from constraints we encountered in real life.
🚧 Insert screenshot here
Just fill the columns as you need.
| Column name | Mandatory | Description |
|---|---|---|
Rule set |
Y | The ID for the rule set. To work properly, the IDs must be sequential integers. |
Name |
N | A name for the rule set. Has no effect whatsoever on the worksheet. |
Day length |
Y | The number of hours you should work each day. |
Min. pause |
N | If the pause is mandatory, you can set the minimal length here. It will be deduced from total if you don't take a pause at Midday. If you do take a pause but it is shorter than the minimum you set here, this value will be used instead. |
Not before |
N | You can arrive before this hour, but that time will not be counted. |
Not after |
N | You can leave after this hour, but that time will not be counted. |
💡 Rule set and Day length are the only mandatory columns of a rule set for the time tracker to work.
In most cases, one profile should be enough for your needs. So why are you allowed several? You may need them for various reasons. Among the reasons that caused us to consider them:
- The day restrictions may change according to the day of the week or due to duty periods for instance.
- You are a consultant intervening on several missions at a time.
So set a name to know what the profile is related to and fill the rules accordingly.
🚧 Insert screenshot here
Once your rule set was created, you can apply it to a line in the time sheet by setting the associated ID in column B.
🚧 Insert screenshot here
- Profiles description
- Cfg, technical fields
