The aggregate statistics of the yearly and monthly average of the technicians' utilization display for each group the sum of available and worked days for each year or month.
Yearly
For example, the following values are given:
- Technicians in a group: 15
- Technicians used per day: 5
- Number of possible working days in a year of the simulation: 300
- Number of weather days in a year of the simulation (none work was done due to weather conditions): 53
- Number of days without work but OK weather for vessels the technicians have access to go offshore in a year of the simulation: 12
Then can be calculated:
5* 300 = 1500 working technicians
15 * 312 = 4680 total technicians available
1500 / 4680 = 0.3205 = 32.05 % technician utilization a year of the simulation
An example file is found on the bottom.
Description about the output:
| Cell | Description (values are in hours) |
|---|---|
| Column A | Displays the technician group name. |
| Column B | Displays the simulation year. |
| Column C | Displays the average value for the technician group - the average is calculated by all the P-values for that year. |
| Column D | Displays the P10 value for the downtime. |
| Column E | Displays the P20 value for the downtime. |
| Column F | Displays the P30 value for the downtime. |
| Column G | Displays the P40 value for the downtime. |
| Column H | Displays the P50 value for the downtime. |
| Column I | Displays the P60 value for the downtime. |
| Column J | Displays the P70 value for the downtime. |
| Column K | Displays the P80 value for the downtime. |
| Column L | Displays the P90 value for the downtime. |
| Column M | Displays the minimum value between the different P-values. |
| Column N | Displays the maximum value between the different P-values. |
| Column O | Displays the standard deviation. You can read more about the standard deviation on the Wikipedia page. |
| Column P | Displays the minimum confidence interval (read more about confidence interval here). |
| Column Q | Displays the maximum confidence interval (read more about confidence interval here). |
Monthly
For example, the following values are given:
- Technicians in a group: 15
- Technicians used per day: 5
- Number of possible working days in the first month of the simulation: 20
- Number of weather days in the first month of the simulation (none work was done due to weather conditions): 10
- Number of days without work but OK weather for vessels the technicians have access to go offshore in the first month of the simulation: 1
Then it can be calculated:
5* 20 = 100 working technicians
15 * 21 = 315 total technicians available
100 / 315 = 0.3174 = 31.74 % technician utilization the first month of the simulation
An example file is found on the bottom.
| Cell | Description (values are in hours) |
|---|---|
| Column A | Displays the technician group name. |
| Column B | Displays the simulation month. |
| Column C | Displays the average value for the technician group - the average is calculated by all the P-values for that year. |
| Column D | Displays the P10 value for the downtime. |
| Column E | Displays the P20 value for the downtime. |
| Column F | Displays the P30 value for the downtime. |
| Column G | Displays the P40 value for the downtime. |
| Column H | Displays the P50 value for the downtime. |
| Column I | Displays the P60 value for the downtime. |
| Column J | Displays the P70 value for the downtime. |
| Column K | Displays the P80 value for the downtime. |
| Column L | Displays the P90 value for the downtime. |
| Column M | Displays the minimum value between the different P-values. |
| Column N | Displays the maximum value between the different P-values. |
| Column O | Displays the standard deviation. You can read more about the standard deviation on the Wikipedia page. |
| Column P | Displays the minimum confidence interval (read more about confidence interval here). |
| Column Q | Displays the maximum confidence interval (read more about confidence interval here). |