The completion rate of tasks and works are visible. These values show the percentage of the completed task/working hours from all tasks/working hours.
| Category | Description |
|---|---|
| Unfinished Work Orders | Number of tasks that haven't been finished out of all scheduled |
| Completed Work Orders | Number of tasks that have been completed out of all scheduled |
| Work Hours On Unfinished Work Orders | Total time spent on unfinished tasks |
| Work Hours On Completed Work Orders | Total hours required for completed tasks (Total man hours for the activity * number of tasks) |
| Completion Rate For Work Orders | Percentage of the completed task from all tasks (see calculation above) |
| Completion Rate For Work Hours | Percentage of the working hours from all working hours (see calculation above) |
For example, the following values are given:
- Number of tasks in a year for the whole wind farm: 40 x type A, 40 x type B
- Estimated working hours per task: 8 h (type A), 6 h (type B)
- Finished number of tasks: 40 x type A, 35 x type B
Then can be calculated:
Type A
40 tasks for the whole windfarm in the whole year
40 tasks were finished
0 tasks are remaining in the backlog
40 / 40 = 1 = 100 % completion rate for tasks
40 * 8 h = 320 h estimated working hours for all tasks in the year and the wind farm
0 h working hours are remaining in the backlog
320 h working hours are done
320 h / 320 h = 1 = 100 % completion rate for the works
Type B
40 tasks for the whole windfarm in the whole year
35 tasks were finished
5 tasks are remaining in the backlog
35 / 40 = 0.875 = 87.5 % completion rate for tasks
40 * 6 h = 240 h estimated working hours for all task in the year and the wind farm
5 * 6 h = 30 h working hours are remaining in the backlog
240 h - 30 h = 210 h working hours are done
210 h / 240 h = 0.875 = 87.5 % completion rate for the works
An example file is found on the bottom.
Explanation for the "Completion - Yearly" and "Completion - Non-aggregated" is found below.
Completion - Yearly
| Cell | Description |
|---|---|
| Column A | Wind farm name (if "default", no wind farm name has been added). |
| Column B | Displays the asset ID (seen in the URL when opening/editing an asset in your case). |
| Column C | Displays the maintenance task name. |
| Column D | Displays "item":
|
| Column E | Displays the simulation year |
| Column F | Displays the average values for the relevant item - the average is calculated by all the P-values for that year. |
| Column G | Displays the P10 value for the relevant item. |
| Column H | Displays the P20 value for the relevant item. |
| Column I | Displays the P30 value for the relevant item. |
| Column J | Displays the P40 value for the relevant item. |
| Column K | Displays the P50 value for the relevant item. |
| Column L | Displays the P60 value for the relevant item. |
| Column M | Displays the P70 value for the relevant item. |
| Column N | Displays the P80 value for the relevant item. |
| Column O | Displays the P90 value for the relevant item. |
| Column P | Displays the minimum value between the different P-values. |
| Column Q | Displays the maximum value between the different P-values. |
| Column R | Displays the standard deviation. You can read more about the standard deviation on the Wikipedia page. |
| Column S | Displays the minimum confidence interval (read more about confidence interval here). |
| Column T | Displays the minimum confidence interval (read more about confidence interval here). |
Completion - Non-Aggregated
| Cell | Description |
|---|---|
| Column A | Wind farm name (if "default", no wind farm name has been added). |
| Column B | Displays the asset ID (seen in the URL when opening/editing an asset in your case). |
| Column C | Displays the maintenance task name. |
| Column D | Displays "item":
|
| Column E | Displays the simulation year. |
| Column F | Displays the simulation month (to be used in accordance with the simulation year). |
| Column G | Displays the average values for the relevant item - the average is calculated by all the P-values for that year. |
| Column H | Displays the P10 value for the relevant item. |
| Column I | Displays the P20 value for the relevant item. |
| Column J | Displays the P30 value for the relevant item. |
| Column K | Displays the P40 value for the relevant item. |
| Column L | Displays the P50 value for the relevant item. |
| Column M | Displays the P60 value for the relevant item. |
| Column N | Displays the P70 value for the relevant item. |
| Column O | Displays the P80 value for the relevant item. |
| Column P | Displays the P90 value for the relevant item. |
| Column Q | Displays the minimum value between the different P-values. |
| Column R | Displays the maximum value between the different P-values. |
| Column S | Displays the standard deviation. You can read more about the standard deviation on the Wikipedia page. |
| Column T | Displays the minimum confidence interval (read more about confidence interval here). |
| Column U | Displays the minimum confidence interval (read more about confidence interval here). |