[Sandi Joralemon (Adm)]

Great conversation.  In my days with the utility, our use cases also ran anywhere from a day to several months depending on the scope of the project.  We were just getting started with our analytics platform, so the learning curve affected our timeline for larger projects requiring an automated data flow as opposed to an ad hoc analysis. 

I agree with Nolan’s comment that juggling use cases is art.  In our case, even while we tried to work heads down on projects that took extensive time due to their complexity or the size of the scope, it was important to move quickly to keep senior leadership as well as the business unit leadership engaged and active in the process.

We included analytics efforts and value obtained from absorbing new source data into the process as part of the prioritization process, but of course, high level requests outside of that process made their way into the mix.  We also broke the use cases down into phases using two week iterations where we could, which helped us show progress and made it a little easier to pull in stakeholders for that portion of the solution.    

For Laurie’s quick survey, our department was considered a strategic department but reported to the CIO.  

——————————
Sincerely,

Sandi Joralemon
Sr. Research Analyst
Utility Analytics Institute
sjoralemon@utilityanalytics.com
830.832.5042
——————————
——————————————-
Original Message:
Sent: 05-01-2023 13:08
From: Laurie Shrauger
Subject: What is your lead time for use case delivery?

Hi Michael, 
I have to agree that not all use cases are created equal.  We have taken several months for some and have also turned several around in days/weeks.  Factors include where the directive is coming from, what our existing backlog is and the priority of the use case, how ready the data is (in a database, manually documented, accurate, etc.), and how committed the business area is to supporting the effort.  Our time differs for each use case.

——————————
Laurie Shrauger
Data & Analytics Manager
Fayetteville Public Works Commission
Fayetteville, NC 28301
laurie.shrauger@faypwc.com
http://www.faypwc.com
——————————

Original Message:
Sent: 04-15-2023 10:30
From: Michael Fourman
Subject: What is your lead time for use case delivery?

Not all use cases are created equal.  I realize the answer to my question is probabl, “it depends” but I’d like to understand, roughly, how long does it take you to get from idea to delivery?

——————————
Michael Fourman
Director – Business Intelligence
Georgia Transmission
——————————

[Michael Fourman]

Thank you, Sandi. 

——————————
Michael Fourman
Director – Business Intelligence
Georgia Transmission
——————————
——————————————-
Original Message:
Sent: 05-02-2023 06:43
From: Sandi Joralemon
Subject: What is your lead time for use case delivery?

Great conversation.  In my days with the utility, our use cases also ran anywhere from a day to several months depending on the scope of the project.  We were just getting started with our analytics platform, so the learning curve affected our timeline for larger projects requiring an automated data flow as opposed to an ad hoc analysis. 

I agree with Nolan’s comment that juggling use cases is art.  In our case, even while we tried to work heads down on projects that took extensive time due to their complexity or the size of the scope, it was important to move quickly to keep senior leadership as well as the business unit leadership engaged and active in the process.

We included analytics efforts and value obtained from absorbing new source data into the process as part of the prioritization process, but of course, high level requests outside of that process made their way into the mix.  We also broke the use cases down into phases using two week iterations where we could, which helped us show progress and made it a little easier to pull in stakeholders for that portion of the solution.    

For Laurie’s quick survey, our department was considered a strategic department but reported to the CIO.  

——————————
Sincerely,

Sandi Joralemon
Sr. Research Analyst
Utility Analytics Institute
sjoralemon@utilityanalytics.com
830.832.5042
——————————

Original Message:
Sent: 05-01-2023 13:08
From: Laurie Shrauger
Subject: What is your lead time for use case delivery?

Hi Michael, 
I have to agree that not all use cases are created equal.  We have taken several months for some and have also turned several around in days/weeks.  Factors include where the directive is coming from, what our existing backlog is and the priority of the use case, how ready the data is (in a database, manually documented, accurate, etc.), and how committed the business area is to supporting the effort.  Our time differs for each use case.

——————————
Laurie Shrauger
Data & Analytics Manager
Fayetteville Public Works Commission
Fayetteville, NC 28301
laurie.shrauger@faypwc.com
http://www.faypwc.com

Original Message:
Sent: 04-15-2023 10:30
From: Michael Fourman
Subject: What is your lead time for use case delivery?

Not all use cases are created equal.  I realize the answer to my question is probabl, “it depends” but I’d like to understand, roughly, how long does it take you to get from idea to delivery?

——————————
Michael Fourman
Director – Business Intelligence
Georgia Transmission
——————————

[Tom Anderson]

Hi Sarah,
I have completed many projects leveraging AMI and one of my first was using AMI for transformer load management.    Many have attempted to us AMI and have found that the connecting relevant data can be daunting.  

Here is a link to my white paper I produced with Dr. Prasenjit Shil @Ameren.   If I can be of any assistance feel free to reach out to me.   Additionally, I have posted several videos in LinkedIn that you might find compelling,  most show how I leverage AMI with advanced analytics for customer awareness and asset maintenance. 

https://support.sas.com/resources/papers/proceedings19/3944-2019.pdf

——————————
Tom Anderson
Advisory Systems Engineer
SAS
——————————
——————————————-
Original Message:
Sent: 04-18-2023 09:14
From: Sarah Green
Subject: Transformer Outage Prediction Model

Hi all!

Consumers Energy is looking into utilizing data sources such as AMI meter Data, historical outage data, and other SCADA enabled LVD line devices to develop an algorithm/model to predict when a service or transformer level outage is going to happen in the future. 

We would love to connect with any companies that have already done this to learn more about what datasets you found useful, the granularity of the data utilized within your models, and any other lessons learned along the way. 

Please let me know if you would be available to have a conversation! 

Thanks!

Sarah

——————————
Sarah Green
Director Operations Analytics
Consumers Energy
Jackson MI
——————————

[Kevin Praet (Adm)]

Hello UAI Members,

We’re still collecting responses for our previous #WisdomWednesday post and would love your input! @Michael and @Aaron got us kicked off with some great information and I’m hoping other members might be able to follow suit. We’re again not looking for anything lengthy or time consuming in these #WisdomWednesday posts but instead just a quick hit or lesson learned on a project you’re working on. 

1.) Quick (few sentence) description of a project you’re working on

2.) One thing you’ve learned while working on this project that you would like to pass on to others

Thanks in advance and I look forward to your input and learning more from you!

——————————
Kevin Praet
Membership Coordinator
Utility Analytics Institute (UAI)
Boulder CO
315-440-3033
——————————
——————————————-
Original Message:
Sent: 04-19-2023 10:00
From: Kevin Praet
Subject: Wisdom Wednesday – Working on an Exciting Project? We Want to Hear From You Below!

Good Morning UAI Members,

Happy hump day and I hope everyone’s had a great start to their week! Due to UA Summit, it’s been a little while since our last #WisdomWednesday post and I was hoping to get another thread started for us today.

Getting back to our original theme, I want today’s Wisdom Wednesday thread to surround current projects you’re working on at your utility or solution provider company. Think of this as a glorified show and tell! With all of us working on so many interesting projects, I’m hoping you wouldn’t mind replying to this thread below with the following:

1.) Quick (few sentence) description of a project you’re working on

2.) One thing you’ve learned while working on this project that you would like to pass on to others

The goal of Wisdom Wednesday is to create a forum of quick hits/wins that we can all share and learn from. We thank everyone who has taken time to get involved thus far and look forward to your input throughout the day today.

——————————
Kevin Praet
Membership Coordinator
Utility Analytics Institute (UAI)
Boulder CO
315-440-3033
——————————

[Kraig Bader]

Hello all,

 

This is an interesting thread! Are we talking about transformer outages for overloading conditions or for other failure modes?  Overload prediction is something that we are also still refining (though you could say we are always refining all of our analytics).

 

We have had some success with prediction of service outages related to failing secondary connections by monitoring voltage alerts from metes connected to a specific transformer. To a lesser extent, this has identified a few transformers that were nearing their load rating. To eliminate spurious notifications, the logic was based on triggering with AMI Meters reporting voltage alarms for more than 3 of the last 5 days . The alarms we monitor include no or low voltage (when the disconnect on the meter is closed), maximum voltage monitoring event, minimum voltage monitoring event and events where the voltage has returned to normal.  We have also reported on those with more than one AMI meter voltage alarm reported in the last 24 hours.

 

Combining these with load information can offer some confirmation of a potential failure reason.

 

 

 

. . . . . . . . . . . . . . . . . . 
KRAIG BADER
Director, Electrical Engineering

City of Fort Collins

 

——————————————-
Original Message:
Sent: 5/5/2023 9:19:00 AM
From: Vladyslav Anderson
Subject: RE: Transformer Outage Prediction Model

Hi Sarah, 

Our team is currently working on a transformer failure prediction use case utilizing meter voltage data. We have spent a considerable amount of time collecting data and are focused on cleaning data and identifying signatures. I believe we should have something to share in the next few months and would also be interested what others are doing in this space. 

Thanks, 
Vlad

——————————
Vladyslav (Vlad) Anderson
Prin Quantitative Engineer
Exelon
6673131295
——————————
——————————————-
Original Message:
Sent: 04-18-2023 09:14
From: Sarah Green
Subject: Transformer Outage Prediction Model

Hi all!

Consumers Energy is looking into utilizing data sources such as AMI meter Data, historical outage data, and other SCADA enabled LVD line devices to develop an algorithm/model to predict when a service or transformer level outage is going to happen in the future. 

We would love to connect with any companies that have already done this to learn more about what datasets you found useful, the granularity of the data utilized within your models, and any other lessons learned along the way. 

Please let me know if you would be available to have a conversation! 

Thanks!

Sarah

——————————
Sarah Green
Director Operations Analytics
Consumers Energy
Jackson MI
——————————

[Mohammad Izadi]

Hi, 
We have done a similar project on our footprint where we utilized ML and combined with criticality to not only predict asset health but also optimize CAP/OPEX for future maintenance programs for Transmission Transformers. 
Thanks, 

——————————
Mohammad Izadi
Data Scientist
FirstEnergy
9702151680
——————————
——————————————-
Original Message:
Sent: 04-18-2023 09:14
From: Sarah Green
Subject: Transformer Outage Prediction Model

Hi all!

Consumers Energy is looking into utilizing data sources such as AMI meter Data, historical outage data, and other SCADA enabled LVD line devices to develop an algorithm/model to predict when a service or transformer level outage is going to happen in the future. 

We would love to connect with any companies that have already done this to learn more about what datasets you found useful, the granularity of the data utilized within your models, and any other lessons learned along the way. 

Please let me know if you would be available to have a conversation! 

Thanks!

Sarah

——————————
Sarah Green
Director Operations Analytics
Consumers Energy
Jackson MI
——————————

[Mohammad Izadi]

Hi Leslie, 
How can I register for this event you mentioned?
Thanks

——————————
Mohammad Izadi
Data Scientist
FirstEnergy
9702151680
——————————
——————————————-
Original Message:
Sent: 04-18-2023 09:51
From: Leslie Cook
Subject: Transformer Outage Prediction Model

Hi Sarah,

I saw your note and wanted to recommend you join us for the May 24, 2023 UAI Asset Health Analytics Community Conversation. I copied the session details below where @Bashar from Entergy will be presenting on this topic. I also recommend reaching out to Bashar to discuss. 

If you are not part of the Asset Health Analytics Community, submit a request to join to be a part of the group and receive the meeting invite at https://uaievents.wufoo.com/forms/request-to-join-uai-communities/.

Wednesday, May 24, 2023

Bashar Kellow Manager, Business Analytics, Business Data & Insights

Entergy Services, Inc.

Predicting Asset Failure

Presentation with Q&A/open discussion

With a major focus on customer satisfaction and utilizing the investment Entergy made in Smart Grid, this session will demonstrate how the use of AMI meter data can help predict failure of distribution transformers, plan better for their replacement, and reduce outage minutes and overtime. During this session, Entergy will demonstrate their Transformer Failure Prediction Tool, the business process, and the preliminary business value since the release of this product.

Thanks!

     Leslie

——————————
Leslie Cook
Membership, Engagement, & Training Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@utilityanalytics.com
——————————

Original Message:
Sent: 04-18-2023 09:14
From: Sarah Green
Subject: Transformer Outage Prediction Model

Hi all!

Consumers Energy is looking into utilizing data sources such as AMI meter Data, historical outage data, and other SCADA enabled LVD line devices to develop an algorithm/model to predict when a service or transformer level outage is going to happen in the future. 

We would love to connect with any companies that have already done this to learn more about what datasets you found useful, the granularity of the data utilized within your models, and any other lessons learned along the way. 

Please let me know if you would be available to have a conversation! 

Thanks!

Sarah

——————————
Sarah Green
Director Operations Analytics
Consumers Energy
Jackson MI
——————————

[Vladyslav Anderson]

Hi Sarah, 

Our team is currently working on a transformer failure prediction use case utilizing meter voltage data. We have spent a considerable amount of time collecting data and are focused on cleaning data and identifying signatures. I believe we should have something to share in the next few months and would also be interested what others are doing in this space. 

Thanks, 
Vlad

——————————
Vladyslav (Vlad) Anderson
Prin Quantitative Engineer
Exelon
6673131295
——————————
——————————————-
Original Message:
Sent: 04-18-2023 09:14
From: Sarah Green
Subject: Transformer Outage Prediction Model

Hi all!

Consumers Energy is looking into utilizing data sources such as AMI meter Data, historical outage data, and other SCADA enabled LVD line devices to develop an algorithm/model to predict when a service or transformer level outage is going to happen in the future. 

We would love to connect with any companies that have already done this to learn more about what datasets you found useful, the granularity of the data utilized within your models, and any other lessons learned along the way. 

Please let me know if you would be available to have a conversation! 

Thanks!

Sarah

——————————
Sarah Green
Director Operations Analytics
Consumers Energy
Jackson MI
——————————

[Leslie Cook (Adm)]

Hi @Mohammad, Thanks for your reply! As a member, you get full access to UAI Community Conversations. The monthly virtual event I mention in this post is part of the UAI Asset Health Analytics Community. You can join this Community (and 7 other Communities) and gain access to the monthly virtual events.

Learn more about all UAI Communities here: https://connect.utilityanalytics.com/collaborate/current-communities.  
Request to Join UAI Communities here: https://uaievents.wufoo.com/forms/request-to-join-uai-communities/.

Once you join any and all Communities of your choice, you will receive a message from my teammate, @Kevin that will share more details about the Communities and the monthly virtual event invites for your calendar. 

Please reach out to me at lcook@utilityanalytics.com if you have any other questions. Very happy to get you involved in the UAI Communities and have you join us for the Asset Health Analytics Community Conversation on May 24 that was mentioned in this thread. 

Thanks!

     Leslie

——————————
Leslie Cook
Membership, Engagement, & Training Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@utilityanalytics.com
——————————
——————————————-
Original Message:
Sent: 05-05-2023 07:57
From: Mohammad Izadi
Subject: Transformer Outage Prediction Model

Hi Leslie, 
How can I register for this event you mentioned?
Thanks

——————————
Mohammad Izadi
Data Scientist
FirstEnergy
9702151680
——————————

Original Message:
Sent: 04-18-2023 09:51
From: Leslie Cook
Subject: Transformer Outage Prediction Model

Hi Sarah,

I saw your note and wanted to recommend you join us for the May 24, 2023 UAI Asset Health Analytics Community Conversation. I copied the session details below where @Bashar from Entergy will be presenting on this topic. I also recommend reaching out to Bashar to discuss. 

If you are not part of the Asset Health Analytics Community, submit a request to join to be a part of the group and receive the meeting invite at https://uaievents.wufoo.com/forms/request-to-join-uai-communities/.

Wednesday, May 24, 2023

Bashar Kellow Manager, Business Analytics, Business Data & Insights

Entergy Services, Inc.

Predicting Asset Failure

Presentation with Q&A/open discussion

With a major focus on customer satisfaction and utilizing the investment Entergy made in Smart Grid, this session will demonstrate how the use of AMI meter data can help predict failure of distribution transformers, plan better for their replacement, and reduce outage minutes and overtime. During this session, Entergy will demonstrate their Transformer Failure Prediction Tool, the business process, and the preliminary business value since the release of this product.

Thanks!

     Leslie

——————————
Leslie Cook
Membership, Engagement, & Training Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@utilityanalytics.com

Original Message:
Sent: 04-18-2023 09:14
From: Sarah Green
Subject: Transformer Outage Prediction Model

Hi all!

Consumers Energy is looking into utilizing data sources such as AMI meter Data, historical outage data, and other SCADA enabled LVD line devices to develop an algorithm/model to predict when a service or transformer level outage is going to happen in the future. 

We would love to connect with any companies that have already done this to learn more about what datasets you found useful, the granularity of the data utilized within your models, and any other lessons learned along the way. 

Please let me know if you would be available to have a conversation! 

Thanks!

Sarah

——————————
Sarah Green
Director Operations Analytics
Consumers Energy
Jackson MI
——————————

[Liam Rosewell]

Hi Eddie,

Apologies for the delay in getting back to you. By way of some possible times to discuss with you: (times below are CST and estimating for 1 hour)

5/15 2:30 pm 
5/18 1 pm

These are best guess dates looking through calendars here, but if there is a time and date that works better for you then please let me know and I’ll tell the team here and see what we can do.

Liam

——————————
Liam Rosewell
Sr. Program Manager
Entergy
——————————
——————————————-
Original Message:
Sent: 04-26-2023 14:57
From: Eddie Fee
Subject: Dead Meters

For electric AMI meters, we’ve had success in leveraging the various meter events and alarms to identify failing or dead meters.  After years of refining and proving this out, we no longer have to analyze zero consumption patterns (and the numerous false positives that come along with that approach) to identify issues with electric meters.

 

I recommend working with your AMI meter provider to get a comprehensive listing of all ‘fatal’ errors and alarms that would indicate a failing or dead meter.  Or worst case, ‘reverse engineer’ examples to understand the event and alarm behavior of meters that have been verified to be dead. 

 

Water meters are a whole other animal where consumption analytics still are required to identify dead/dying meters.  We have no experience with gas meters.

 

Eddie Fee, Jr.

Director – Meter Services

Operations | Electric & Water Distribution

OUC – The Reliable One

o – 407.434.2262

e – efeejr@ouc.com

 

 

---

DISCLAIMER:
Florida has a very broad public records law. As a result, any written communication created or received by Orlando Utilities Commission officials and employees will be made available to the public and media, upon request, unless otherwise exempt. Under Florida law, email addresses are public records. If you do not want your email address released in response to a public records request, do not send electronic mail to this office. Instead, contact our office by phone or in writing.

Original Message:
Sent: 4/25/2023 9:37:00 AM
From: Liam Rosewell
Subject: Dead Meters

Hi all,
Has anyone any experience of a use case looking into identifying dead meters?
For electric meters we are looking at: registered zero consumption and meter is functional.
For gas meters we are yet to determine if there are attributes such as pulse rate that may be able to help us.

Any feedback would be welcome.

Thanks
Liam

——————————
Liam Rosewell
Sr. Program Manager
Entergy
——————————