[John Kinateder]

Hi Ben.  At American Electric Power, we are working to develop a Transmission Project Estimation tool that is currently mainly focused on estimating upper and lower bounds of capital spend for Transmission projects. 

The details you provided suggest to me that you are looking for something much broader, but I would be happy to discuss our approach on the phone.

John

——————————
[John] [Kinateder]
[Chief Data Scientist]
[American Electric Power]
[Columbus] [OH]
[614-883-7138]
——————————
——————————————-
Original Message:
Sent: 10-13-2020 15:19
From: Ben Ettlinger
Subject: Transmission Project Estimation

Does any one in the discussion group have experience with analytics surrounding analytics and transmission project estimation? We are interested the following capabilities;

• Creation of Estimates: The software must be able to facilitate the creation of project estimates for all project stages, save estimates for future use, maintain searchable information for assemblies, components, crews and material.     
• Workflow: Estimates shall have the ability to be assigned, reviewed, approved, tracked and routed to various estimators.
• Collaboration: The software shall have the ability to allow estimators to collaborate on estimates requiring multidiscipline support. The estimators should have the ability to work concurrently on various parts of the same estimate.
• Integration to Key Platforms/Systems: The software should have the ability to import / export data from multiple databases / platforms, including but not limited to, MS Excel, MS Project, Primavera P6, RS Means, Richardson, SAP, Maximo.
• Standard Classification system: The software should allow for a standard classification system that ties into other coding schemes such as CSI MasterSpec or ERP systems.
• Information / Databases: In addition to integration with other platforms, the software provider should provide access to its own or other third party datasets specific to the utility industry (Hydro, Fossil Fuel, Solar, Wind) that houses information on material, crew and equipment costs that are regularly updated. The dataset items must be importable to the estimates with the ability to change parameters and store items / assemblies for future use.
• Customization: The software should allow for user defined views created by the estimators and role based views.
• Reporting: Standard reports and user configurable reports must be available that include dashboards, comparison of estimates, detail estimates as well as all estimate portfolio views that can be grouped by various parameters, such as location, estimator, project owner, etc.
• Benchmarking: The software should allow for the comparison of current estimates to historical estimates and actual costs for the purposes of benchmarking.

Anyone with knowledge in this space?

——————————
Ben Ettlinger
Emerging Technologies
Enterprise Architecture & Engineering Group
New York Power Authority
White Plains, NY
914 681 6496
——————————

[Kaz Shakir]

At TVA we use C55 from Copperleaf, and I think it will provide most of the items you listed: (i) creation of estimates for all stages; (ii) workflow to allow for the estimates to be reviewed, approved, and tracked; (iii) customization & reporting; etc.  The one item you listed that I don’t believe Copperleaf provides are the third party databases with cost estimate information for similar projects.

 

Hope that helps.

 

——————————

“the primary purpose of business is to create and keep customers” – Peter Drucker

“Strategy is the great Work of the organisation. In situations of life or death, it is the Tao of survival or extinction. Its study cannot be neglected” – Sun Tzu

“The time to stop stupidity and be tough on costs is when times are good, Any schlemiel and most schlamozels try to cut costs when times are bad.” – Ace Greenberg, Chairman Bear Stearns

“I’m just here for the free lunch, not to make a difference” – Anonymous Economist

——————————

Kaz Shakir
Senior Program Manager
Asset Planning

615.232.6908 (w, Nashville)
917.208.2329 (m)
kyshakir@tva.gov

 

——————————————-
Original Message:
Sent: 10/13/2020 3:20:00 PM
From: Ben Ettlinger
Subject: Transmission Project Estimation

Does any one in the discussion group have experience with analytics surrounding analytics and transmission project estimation? We are interested the following capabilities;

• Creation of Estimates: The software must be able to facilitate the creation of project estimates for all project stages, save estimates for future use, maintain searchable information for assemblies, components, crews and material.     
• Workflow: Estimates shall have the ability to be assigned, reviewed, approved, tracked and routed to various estimators.
• Collaboration: The software shall have the ability to allow estimators to collaborate on estimates requiring multidiscipline support. The estimators should have the ability to work concurrently on various parts of the same estimate.
• Integration to Key Platforms/Systems: The software should have the ability to import / export data from multiple databases / platforms, including but not limited to, MS Excel, MS Project, Primavera P6, RS Means, Richardson, SAP, Maximo.
• Standard Classification system: The software should allow for a standard classification system that ties into other coding schemes such as CSI MasterSpec or ERP systems.
• Information / Databases: In addition to integration with other platforms, the software provider should provide access to its own or other third party datasets specific to the utility industry (Hydro, Fossil Fuel, Solar, Wind) that houses information on material, crew and equipment costs that are regularly updated. The dataset items must be importable to the estimates with the ability to change parameters and store items / assemblies for future use.
• Customization: The software should allow for user defined views created by the estimators and role based views.
• Reporting: Standard reports and user configurable reports must be available that include dashboards, comparison of estimates, detail estimates as well as all estimate portfolio views that can be grouped by various parameters, such as location, estimator, project owner, etc.
• Benchmarking: The software should allow for the comparison of current estimates to historical estimates and actual costs for the purposes of benchmarking.

Anyone with knowledge in this space?

——————————
Ben Ettlinger
Emerging Technologies
Enterprise Architecture & Engineering Group
New York Power Authority
White Plains, NY
914 681 6496
——————————

[Sean Crimmins]

Hi David, EPRI is using Informatica products for data set curation.  I can put you in touch with someone from that team to provide more info.

——————————
Sean Crimmins
Manager, Enterprise Architecture and Integration
EPRI
Palo Alto CA
6508557901
——————————
——————————————-
Original Message:
Sent: 10-09-2020 15:00
From: David Botzenhart
Subject: Data Catalog

Hi,
We’re evaluating Data Catalog vendors and looking for other utility experiences. Has anyone researched or are currently using Informatica’s Data Catalog, Alex Systems or Solidatus and would be speaking to my team about your journey?

——————————
David Botzenhart
Sr. BI Architect
Duke Energy
Charlotte NC
704-328-1658
——————————

[Leslie Cook (Adm)]

Hello UAI Members,

I noticed I never got a reply on this post, so I want to circle the question back around to see if anyone can help. The original message…

We have a UAI Utility Member that is looking into getting Master Data Management (MDM) software for their data governance initiative. Do you have MDM software in place? If yes, would you be willing to be introduced to this other Utility Member and have a conversation with them to give your feedback? If yes, please reply to this post or feel free to reach out to me directly at lcook@utilityanalytics.com and I will make the introductions.

Thank you so much! I look forward to your reply.

     Leslie 

——————————
Leslie Cook
Membership & Digital Engagement Manager
Utility Analytics Institute (UAI)
719-203-8650, lcook@endeavorb2b.com
——————————
——————————————-
Original Message:
Sent: 08-04-2020 09:55
From: Leslie Cook
Subject: Master Data Management (MDM) Software – Do you have it in place?

Dear UAI Members,

I hope you are well. We have a UAI Utility Member that is looking into getting Master Data Management (MDM) software for their data governance initiative. Do you have MDM software in place? If yes, would you be willing to be introduced to this other Utility Member and have a conversation with them to give your feedback? If yes, please reply to this post or feel free to reach out to me directly at lcook@utilityanalytics.com and I will make the introductions.

Thank you so much! I look forward to your reply.

     Leslie 

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