Administration
Users
By pressing on add in the user menu, the form for creating a new user appears.
Warning
Only users with role global administrator or OTR administrator are enabled
to create new users
Field Explanation
| Field | Description |
|---|---|
| First name | Real name of contributor |
| Surname | Contributor's real last name |
| Username | User name used for logging into the application |
| Password | Password used for logging into the application |
| Password | Password confirmation |
| Organization | Which OTR the contributor is part of (content varies depending on the role of the contributor) |
| Role | Role of the contributor (content varies based on the role of the person performing the operation) |
| Hourly rate | Contributor's hourly rate in CHF used for operation cost calculations |
Report per user.
On the users page you can select a user and generate a report. A page will be shown where you define the period you want to consider.
Contracts
Field Explanation
| Field | Description |
|---|---|
| Contractor | The employee to whom the contract relates |
| Start | Start day of contract validity |
| End | Day of end of validity of the contract. Blank if the contract is indefinite |
| Hours per day | Hours per working day (reported at 100%) |
| Percentage | Percentage of employee's work |
| Annual vacation hours | Vacation hours due to employee (referred to one year at 100%) |
Calculation of vacation due during the year.
The calculation of vacation hours due to an employee is done for each contract valid during the year, using the formula:
"annual vacation hours" * ("days in the contract" / "days in the year") * "percentage of the contract"
Rounded to the nearest whole number
Example 1:
Indefinite contract, beginning January 1, percentage 50%, annual vacation hours 200. The calculation of vacation hours due (in a non-leap year) will be:
200 * (365 / 365) * 0.5 = 200
Example 2:
Contract beginning April 1, ending April 30, percentage 80%, annual vacation hours 200. The calculation of due vacation hours will be:
200 * (30 / 365) * 0.8 = 13.15068 -> 13 vacation hours due.
Cost calculations.
Net cost of an intervention.
The net cost of an intervention, is calculated by summing: - Labor cost (hours worked * hourly rate of staff member) - Cost of lunches + dinners - Material cost - Machinery cost - Vehicle cost - Invoice cost
Breakdown of overhead costs.
The costs added below on the Overhead Costs page are allocated proportionally to the interventions in the same year.
For example, for an OTR that carried out interventions with a total length of 100,000 m in 2020 and recorded 100,000 CHF in overhead costs, an intervention of 5,000 m will have 5,000 CHF in apportioned overhead costs.
Info
Allocated costs are calculated and shown only in reports.
Distribution of costs by municipality.
In the reports of interventions, the total costs of interventions are distributed by municipality in proportion to the meters of intervention in the municipality.
For example, an intervention on a 1000-meter-long path (750 m in the municipality of Lumino and 250 m in the municipality of Arbedo-Castione) will have 75% of the costs allocated to Lumino and 25% to Arbedo-Castione.
Info
The distribution of costs by municipality is calculated and shown only in the reports.
COANSE data.
Data created in the previous application (COANSE), were exported as of April 2022 and can be accessed in two different ways in Ibex.
Imported data.
A simplified version of the jobs data recorded in Coanse, has been imported within Ibex, as a separate template in the coanse menu.
It allows data to be filtered by date, tourist board, and category.
Consultation of raw data.
In case you need to do more in-depth analysis You can consult the raw data exported from COANSE via pgAdmin, a PostgreSQL database management tool. You can consult the documentation of pgAdmin here.
The tool is available at ibex.opengis.ch/pgadmin/.
pgAdmin allows you to query all Coanse data, in the original state of the April 2022 export. Since the data is unfiltered by organization and contains potentially sensitive information, arrangements must be made with TicinoSentieri in order to receive credentials to use the tool.