TPS Report for SR1 SP3
Madeline Nadrich (SE WP ON NA OPS OS) and Gabriel Caldwell (SE WP ON NA OPS SR2 SVP3)
2026-04-29
- Read Before Use
- SR1 SP3 Overview
- Big Turtle I
- Big Turtle II
- Deerfield II
- Fairbanks
- Fluvanna
- Garden I
- Green River
- Hoosier
- Mendota Hills II
- Minonk
- Scioto Ridge
- Top 10 Alarms by Count and Trends (SG2X)
- Top 10 Alarms by Duration and Trends (SG2X)
- Top 5 Turbines per Top 5 Alarms (Count) (SG2X)
- Top 5 Turbines per Top 5 Alarms (Duration) (SG2X)
- Scioto Ridge Availability (Entire Site)
- Scioto Ridge Availability (SG2X Only)
- Scioto Ridge ATS Cases (Entire Site)
- Scioto Ridge ATS Cases (SG2X Only)
- Shady Oaks II
- Stoney Corners
Read Before Use
See the below tabs for specific information. If you have any questions, please reach out to Madeline Nadrich (madeline.nadrich@siemens-energy.com) or Gabriel Caldwell (gabriel.caldwell@siemens-energy.com)
Report Information
This report was created with the TPS role in mind. The report is divided so that each windfarm has it’s own section. This report is also interactive - you can hover over (most) graphs to see additional information. See below for a brief overview of each section:- SR1 SP3 Overview
- This looks at the top 10 alarms based on the duration of the alarm for each OEM type, for all sites.
- Top 10 Alarms via Count and Trends
- This looks at the top 10 most frequently occurring alarms for the following time periods: 2 weeks, 6 months, and 1 year. Each time period is calculated from the day the report was generated (so for example, if you generate the report on 4/28/25, the report will look at the 2 week period from 4/14/25 - 4/28/25). Some alarms have been excluded from this report. Please refer to the “Excluded Alarms” tab to see a list of the alarms that have been excluded.
- The “Trends” is referring a histogram-type graph that for each of the top 10 alarms, counts the number of alarms that occurred each month from 2023-10 to the date in which the report is generated
- Top 10 Alarms via Duration and Trends
- This looks at the top 10 alarms based on the duration of the alarm for the following time periods: 2 weeks, 6 months, and 1 year. Each time period is calculated from the day the report was generated (so for example, if you generate the report on 4/28/25, the report will look at the 2 week period from 4/14/25 - 4/28/25). Some alarms have been excluded from this report. Please refer to the “Excluded Alarms” tab to see a list of the alarms that have been excluded.
- The “Trends” is referring a histogram-type graph that for each of the top 10 alarms, counts the number of alarms that occurred each month from 2023-10 to the date in which the report is generated
- Top 5 Turbines per Top 5 Alarms (Count)
- This first gets the top 5 alarms via count from the previous 2 weeks, 6 months, and 1 year. Then for each of those top 5 alarms, it looks at the top 5 turbines that contributed to the count of alarms.
- Top 5 Turbines per Top 5 Alarms (Duration)
- This first gets the top 5 alarms via alarm duration from the previous 2 weeks, 6 months, and 1 year. Then for each of those top 5 alarms, it looks at the top 5 turbines that contributed to the duration of the alarm.
- Availability and Trends
- Availability: This looks at the rolling monthly availability average from the contract start date (month and day) of the specified windfarm in 2024 until 3 days before the date in which the report is generated (The reason we don’t look at the availability data on the date in which the report is generated, is because the tables in Polaris aren’t always updated immediately, so we have to look 3 days back in order to get better data). For example, if a site has a contract start of 2022/06/20, this report will start calculating the availability for month 1 from 2024/06/20 - 2024/07/19. That will be the first point on the graph. Then it will look at the availability from 2024/07/20 - 2024/08/19. The second point on the graph will be the average of the availability from 2024/06/20 - 2024/07/19 (the first point on the graph) and the availability from 2024/07/20 - 2024/08/19. This results in a line chart showing us the rolling monthly availability average. The months shown on the availability graph indicates the month start date for that data point. The data point represents the availability for that month starting on that date. The availability is calculated by dividing the numerator by the denominator from the [Avaibility].[TurbineDailyResult] table in Polaris. This is contractual availability data.
- PEP Graph: This looks at the average potential energy produced each month. The data looks for the site’s contract start date to use at the start date for our time frame. If the contract start date isn’t on the first of the month, it will use the next full month as it’s start date. This then looks at the PEP each month from the contract start date until the last date of the previous month from which you knitted the report (aka if today is 2025-07-03, the PEP query will look until 2025-06-30), then averages those PEP numbers to get one average per month, which then gets graphed.
- ATS Cases
- This looks at all ATS cases that are open. One section shows all open Vibration Diagnostics cases, and the other section shows all open cases, excluding Vibration Diagnostics cases, that have been open for 30 days or more.
Alarms Excluded
For Gamesa/SGRE turbines, a column titled “StandSt” is used to filter out certain alarms. In the StandSt column there are two values: 0 = Warning and 1 = Alarm. Alarms with a StandSt value of 0 have been excluded in this report.
Data Sources
Polaris Tables:
- [TurbineOperationalData_General].[vSenvion_StatusCodeMessages]
- Top 10 Alarms via Count and Trends
- Top 10 Alarms via Duration and Trends
- Top 5 Turbines per Top 5 Alarms
- [TurbineOperationalData_General].[vDispWoneAlarm]
- Top 10 Alarms via Count and Trends
- Top 10 Alarms via Duration and Trends
- Top 5 Turbines per Top 5 Alarms
- [MasterDataTurbineSoftwareInfo_General].[vAlarmSetAlarm]
- Top 10 Alarms via Count and Trends
- Top 10 Alarms via Duration and Trends
- Top 5 Turbines per Top 5 Alarms
- [AdviceToSite].[ATS_Case]
- ATS Cases
- [Availability].[TurbineDailyResult]
- Availability and Trends (PEP)
- [Availability].[Contract]
- Availability and Trends (PEP)
Other Notes
The following sites do not have PEP data in this report because they are Time Based sites, which will not have PEP data unlike Yield Based sites:
- Big Turtle I
- Big Turtle II
- Garden I
- Green River
- Scioto Ridge
The following sites do not have PEP data or Availability data in this report because no results were found for these sites in the TurbineDailyResult table in Polaris:
- Hoosier
- Stoney Corners
The alarm queries for Scioto Ridge are only looking at the SG2X turbines. The Availability and ATS sections are spilt into 2 different sub sections - one for the entire site, and one for just SG2X turbines
Due to not all months having 29, 30, or 31 days, for certain sites the availability graph may look different. For example, if a site has a contract start day of the 30th, the calculation will not create it’s own plot point for February because there is no 2/30. Instead, the February availability will be grouped in with the January availability. The availability calculation is still correct, it’s just when looking at the graph, you may notice a February date missing. For example: Let’s say the contract start date is 2024-12-30. You would see plot points such as “12-30”, “1-30”, “3-30”, “4-30” etc.. Whatever number is on the plot point for “1-30”, that is the rolling average availability from 12-30 to 3-29 (Remember, the x axis date on the availability graph is the month start date for the avail calculation. So the number you see on the “12-30” plot point, that is the availability from 12-30 to 1-29)
For Gamesa/SGRE turbines, a column titled “StandSt” is used to filter out certain alarms. In the StandSt column there are two values: 0 = Warning and 1 = Alarm. Alarms with a StandSt value of 0 have been excluded in this report.
SR1 SP3 Overview
Top 10 Alarms by Duration (Gamesa/SGRE)
Top 10 Alarms by Duration (Senvion)
Big Turtle I
Big Turtle I ATS Cases
Big Turtle I and Big Turtle II are in ATS under the same site name - “Big Turtle”. The ATS Cases seen here in the ‘Big Turtle I ATS Cases’ section are the same cases seen in the ‘Big Turtle II ATS Cases’ section.
Big Turtle II
Big Turtle II ATS Cases
Big Turtle I and Big Turtle II are in ATS under the same site name - “Big Turtle”. The ATS Cases seen here in the ‘Big Turtle II ATS Cases’ section are the same cases seen in the ‘Big Turtle I ATS Cases’ section.
