In this article, we will go over each of the sheets in the Output report.
Each sheet has it's own heading; you can click on the heading to go directly to the information found in the sheet:
For each output, you are able to dig further down into the data - this is done by downloading the corresponding data from the Output dashboard - please read more about this here.
Summary
The Summary sheet contains a general summary of the case.
| Cell | Description |
|---|---|
| B5 | Project name (project/folder where the case is located). |
| F5 | Case name. |
| B8-9 | Date and time when the simulation was finished. |
| F8 | Number of simulation runs. |
| H8 | Name of the person who exported the Output report. |
| B11 | Number of bases in the case. |
| C11 | Number of assets in the case. |
| D11 | Number of logistics in the case |
| F11 | Number of years the case was simulated. |
| H11 | Displays the project size. This is calculated by the rated power in the turbines times the number of turbines in the case. |
| B16 and below | Displays the Wind farm name (if used in the case), with their respective root causes for PBA loss in column E and blow. |
| E16 and below | Displays the root cause for the PBA loss. Root causes can be read about here. |
| H16 and below | Displays the PBA loss in percentage. More information about the root causes can be found here. |
Availability
The Availability sheet contains information about the TBA and PBA loss, both by years and by monthly average (based on all year). More information about the TBA and PBA loss can be found here: TBA loss - PBA loss.
| Cell | Description |
|---|---|
| C7 | Displays the total TBA loss in percentage. Calculation: PBA [%] = [Actual production [MWh] / Potential production [MWh]] * 100 = [Energy actually produced [MWh] / Energy potentially expected [MWh]] * 100 |
| D7 | Displays the total TBA loss in percentage for the tasks which are not covered by a bookkeeping category. |
| C8 | Displays the total PBA loss in percentage. Calculation: TBA [%] = [(Possible uptime [h] - Downtime [h]) / Possible uptime [h]] * 100 = [Time available [h] / Total time in consideration [h]] * 100. |
| D8 | Displays the total PBA loss in percentage for the tasks which are not covered by a bookkeeping category. |
| C9 | Displays the total downtime for the turbines by hours. |
| D9 | Displays the total downtime for the turbines by hours for the tasks which are not covered by a bookkeeping category. |
| C10 | Displays the total lost production in MWh by hours. |
| D10 | Displays the total lost production in MWh by hours for the tasks which are not covered by a bookkeeping category. |
| P12 | Displays the gross capacity factor. Calculation: potential production [kWh] / SUM over assets(wtg rated capacity [kWh]*simulationDuration) (AggregateOfRuns(TotalOfYears(ActualProduction)) / (1000 * TotalGrossCapacityFactor * simulationDuration)) (AggregateOfRuns(TotalOfYears(ActualProduction)) / 1000) / {TotalGrossCapacityFactor} |
| P13 | Displays the net capacity factor (gross minus losses). Calculation: actual production [kWh] / SUM over assets(wtg rated capacity [kWh]*simulationDuration) SumOfCaseWtgConfigurations(NumberOfWtgInstances * RatedPowers * 8766) |
| Row 19 | Displays the TBA loss in percentage per year. |
| Row 20 | Displays the PBA loss in percentage per year. |
| Row 21 | Displays the downtime by hours per year. |
| Row 22 | Displays the lost production in MWh per year. |
| Row 28 | Displays the TBA loss per year in percentage in the P10 values. |
| Row 29 | Displays the TBA loss per year in percentage in the P50 values. |
| Row 30 | Displays the TBA loss per year in percentage in the P90 values. |
| Row 33 | Displays the TBA loss per month in percentage in the P10 values. |
| Row 34 | Displays the TBA loss per month in percentage in the P50 values. |
| Row 35 | Displays the TBA loss per month in percentage in the P90 values. |
| Row 41 | Displays the PBA loss per year in percentage in the P10 values. |
| Row 42 | Displays the PBA loss per year in percentage in the P50 values. |
| Row 43 | Displays the PBA loss per year in percentage in the P90 values. |
| Row 46 | Displays the PBA loss per month in percentage in the P10 values. |
| Row 47 | Displays the PBA loss per month in percentage in the P50 values. |
| Row 48 | Displays the PBA loss per month in percentage in the P90 values. |
Non-agg. Availability
The Non-aggregated availability sheet contains information about the TBA and PBA loss per month by per year. More information about the TBA and PBA loss can be found here: TBA loss - PBA loss.
| Cell | Description |
|---|---|
| B7 and below | Wind farm name. |
| C7 and below | Displays the year - used in relation with D7 and below. |
| D7 and below | Displays the month - used in relation with C7 and below. |
| E7 and below | Displays the TBA loss in percentage for the P10 value per month per year. |
| F7 and below | Displays the TBA loss in percentage for the P50 value per month per year. |
| G7 and below | Displays the TBA loss in percentage for the P90 value per month per year. |
| H7 and below | Displays the PBA loss in percentage for the P10 value per month per year. |
| I7 and below | Displays the PBA loss in percentage for the P50 value per month per year. |
| J7 and below | Displays the PBA loss in percentage for the P90 value per month per year. |
Costs
The Costs sheet contains information about the costs per year.
| Cell | Description |
|---|---|
| Row 7 | Displays the costs for the P10 value per year. The costs are calculated by adding all personnel, port, transport, spare parts, and consumables cost inputs. |
| Row 8 | Displays the costs for the P50 value per year. The costs are calculated by adding all personnel, port, transport, spare parts, and consumables cost inputs. |
| Row 9 | Displays the costs for the P90 value per year. The costs are calculated by adding all personnel, port, transport, spare parts, and consumables cost inputs. |
| Row 15 | Displays the average accumulated costs per year. The costs are calculated by adding all personnel, port, transport, spare parts, and consumables cost inputs. |
| Row 16 | Displays the average costs per year for personnel. No campaign: The costs are calculated by the 'annual salary / 365.25', and then multiplied by 365 (or 366 if leap year) per personnel. Campaign: The costs are calculated by the 'annual salary / 365.25', and then multiplied by the personnel's availability in days per personnel. |
| Row 17 | Displays the average costs per year for the port(s). The costs are calculated by the annual port cost inputs in the 'Cost' tab on the base(s). |
| Row 18 | Displays the average costs per year for scheduled maintenance consumables and others. The costs are calculated by the consumables cost input in the Scheduled maintenance task(s), based on how many times the task(s) happened. |
| Row 19 | Displays the average costs per year for scheduled maintenance spare parts. The costs are calculated by the |
| Row 20 | Displays the average costs per year for transportation. The costs are calculated by the cost inputs in the Cost tab on the vessel(s), based on the utilisation of the vessel(s). |
| Row 21 | Displays the average costs per year for unscheduled maintenance consumables and others. The costs are calculated by the consumables cost input in the Corrective maintenance task(s), based on how many times the task(s) happened. |
| Row 22 | Displays the average costs per year for unscheduled maintenance spare parts. The costs are calculated by the spare parts cost input in the Corrective maintenance task(s), based on how many times the task(s) happened. |
Task completion
The Task completion sheet contains information about the completed work orders vs not completed work orders, both by number, hours and percentage. The outputs on this sheet heavily changes, depending on the number of scheduled and corrective maintenance tasks - please use the descriptions below from Finished work orders and below. More information about the schedule maintenance completion can be read about here.
| Cell | Description |
|---|---|
| Row C | Contains the task name. |
| Row D | Contains the simulation year. |
| Row E | Contains the average value, based on all P-values. |
| Row F | Displays the P10 values. |
| Row G | Displays the P20 values. |
| Row H | Displays the P30 values. |
| Row I | Displays the P40 values. |
| Row J | Displays the P50 values. |
| Row K | Displays the P60 values. |
| Row L | Displays the P70 values. |
| Row M | Displays the P80 values. |
Row N | Displays the P90 values. |
| Row O | Contains the standard deviation. |
| Row P | Contains the minimum value for all the P-values. |
| Row Q | Contains the maximum value for all the P-values. |
| Row R | Contains the minimum confidence interval - please see more about confidence internal here. |
| Row S | Contains the maximum confidence internal - please see more about confidence internal here. |
Utilization
The Utilization sheet contains information on the vessel and technician utilization per month per P-value. This sheet changes depending on the number of vessels and technician groups in your case. More information about vessel utilization can be found here, while technician utilization information can be found here: Technicians utilisation.
| Cell | Description |
|---|---|
| Row 7 | Total and monthly average utilization for all vessels. |
| Row 8 and down | Total and monthly average utilization for individual vessels. |
| Technician utilization for group [xxxxxx] | Contains the utilization for the technician group(s) in your case, with the relevant P-values and the month. |
Downtime
The Downtime sheet contains information about the annual downtime in hours per component/task (scheduled or corrective task) for each year the simulation was run. More information about the component downtime can be found here.
| Cell | Description |
|---|---|
| Row B | Displays the component/task name. |
| Row C | Displays the total accumulated downtime for all years the simulation was run. |
| Row D | Displays the downtime for year 1. |
| Row E (and onward) | Displays the downtime for year 2 (F=year 3, G=year 4 etc). |
Lost production
The Lost production sheet contains information about the annual lost production in MWh (MegaWatts per hour) per component/task (scheduled or corrective task) for each year the simulation was run. More information about the lost production can be found here.
| Cell | Description |
|---|---|
| Row B | Displays the component/task name. |
| Row C | Displays the total accumulated lost production for all years the simulation was run. |
| Row D | Displays the lost production for year 1. |
| Row E (and onward) | Displays the downtime for year 2 (F=year 3, G=year 4 etc). |