The aggregate statistics of the yearly and monthly average of the personnel 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:
- Personnel in a group: 15
- Personnel 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 personnel have access to go offshore in a year of the simulation: 12
Then can be calculated:
5* 300 = 1500 working personnel
15 * 312 = 4680 total personnel available
1500 / 4680 = 0.3205 = 32.05 % personnel 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 personnel group name. |
| Column B | Displays the simulation year. |
| Column C | Displays the average value for the personnel 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:
- Personnel in a group: 15
- Personnel 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 personnel
15 * 21 = 315 total personnel available
100 / 315 = 0.3174 = 31.74 % personnel 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 personnel group name. |
| Column B | Displays the simulation month. |
| Column C | Displays the average value for the personnel 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). |