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.


CellDescription
B5Project name (project/folder where the case is located).
F5Case name.
B8-9Date and time when the simulation was finished.
F8Number of simulation runs.
H8Name of the person who exported the Output report.
B11Number of bases in the case.
C11Number of assets in the case.
D11Number of logistics in the case
F11Number of years the case was simulated.
H11Displays the project size. This is calculated by the rated power in the turbines times the number of turbines in the case.
B16 and belowDisplays the Wind farm name (if used in the case), with their respective root causes for PBA loss in column E and blow.
E16 and belowDisplays the root cause for the PBA loss. Root causes can be read about here.
H16 and belowDisplays 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.


CellDescription
C7Displays the total TBA loss in percentage.

Calculation:
PBA [%] = [Actual production [MWh] / Potential production [MWh]] * 100 = [Energy actually produced [MWh] / Energy potentially expected [MWh]] * 100
D7Displays the total TBA loss in percentage for the tasks which are not covered by a bookkeeping category.
C8Displays 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.
D8Displays the total PBA loss in percentage for the tasks which are not covered by a bookkeeping category.
C9Displays the total downtime for the turbines by hours.
D9Displays the total downtime for the turbines by hours for the tasks which are not covered by a bookkeeping category.
C10Displays the total lost production in MWh by hours.
D10Displays the total lost production in MWh by hours for the tasks which are not covered by a bookkeeping category.
P12Displays 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}
P13Displays the net capacity factor (gross minus losses).

Calculation:
actual production [kWh] / SUM over assets(wtg rated capacity [kWh]*simulationDuration)
SumOfCaseWtgConfigurations(NumberOfWtgInstances * RatedPowers * 8766)
Row 19Displays the TBA loss in percentage per year.
Row 20Displays the PBA loss in percentage per year.
Row 21Displays the downtime by hours per year.
Row 22Displays the lost production in MWh per year.
Row 28Displays the TBA loss per year in percentage in the P10 values.
Row 29Displays the TBA loss per year in percentage in the P50 values.
Row 30Displays the TBA loss per year in percentage in the P90 values.
Row 33Displays the TBA loss per month in percentage in the P10 values.
Row 34Displays the TBA loss per month in percentage in the P50 values.
Row 35Displays the TBA loss per month in percentage in the P90 values.
Row 41Displays the PBA loss per year in percentage in the P10 values.
Row 42Displays the PBA loss per year in percentage in the P50 values.
Row 43Displays the PBA loss per year in percentage in the P90 values.
Row 46Displays the PBA loss per month in percentage in the P10 values.
Row 47Displays the PBA loss per month in percentage in the P50 values.
Row 48Displays 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


CellDescription
B7 and belowWind farm name.
C7 and belowDisplays the year - used in relation with D7 and below.
D7 and belowDisplays the month - used in relation with C7 and below.
E7 and belowDisplays the TBA loss in percentage for the P10 value per month per year.
F7 and belowDisplays the TBA loss in percentage for the P50 value per month per year.
G7 and belowDisplays the TBA loss in percentage for the P90 value per month per year.
H7 and belowDisplays the PBA loss in percentage for the P10 value per month per year.
I7 and belowDisplays the PBA loss in percentage for the P50 value per month per year.
J7 and belowDisplays the PBA loss in percentage for the P90 value per month per year.


Costs

The Costs sheet contains information about the costs per year.


CellDescription
Row 7Displays 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 8Displays 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 9Displays 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 15Displays the average accumulated costs per year.

The costs are calculated by adding all personnel, port, transport, spare parts, and consumables cost inputs.
Row 16Displays 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 17Displays 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 18Displays 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 19Displays the average costs per year for scheduled maintenance spare parts.

The costs are calculated by the
Row 20Displays 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 21Displays 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 22Displays 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.


CellDescription
Row CContains the task name.
Row DContains the simulation year.
Row EContains the average value, based on all P-values.
Row FDisplays the P10 values.
Row GDisplays the P20 values.
Row HDisplays the P30 values.
Row IDisplays the P40 values.
Row JDisplays the P50 values.
Row KDisplays the P60 values.
Row LDisplays the P70 values.
Row MDisplays the P80 values.

Row N
Displays the P90 values.
Row OContains the standard deviation.
Row PContains the minimum value for all the P-values.
Row QContains the maximum value for all the P-values.
Row RContains the minimum confidence interval - please see more about confidence internal here.
Row SContains 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.


CellDescription
Row 7Total and monthly average utilization for all vessels.
Row 8 and downTotal 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.


CellDescription
Row BDisplays the component/task name.
Row CDisplays the total accumulated downtime for all years the simulation was run.
Row DDisplays 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.


CellDescription
Row B
Displays the component/task name.
Row CDisplays the total accumulated lost production for all years the simulation was run.
Row DDisplays the lost production for year 1.
Row E (and onward)Displays the downtime for year 2 (F=year 3, G=year 4 etc).