L2 TCA course – e-lesson #13 – Report generation and cost benefit analysis

Hosted by: Jon Giesecke
This final master's-level lesson focuses on the critical process of generating comprehensive reports and analyzing the cost benefits of transformer condition assessments. The presenter, Jon Giesecke, emphasizes the importance of creating concise, understandable reports that effectively communicate inspection findings. He shares his experience in developing a customizable Excel-based reporting system that integrates various testing technologies and provides a clear visual representation of transformer health. A key aspect of the lesson is the discussion on quantifying the financial benefits of proactive maintenance, including strategies for calculating avoided costs and justifying the value of the inspection program. Giesecke provides practical guidance on scenarios and probabilities to consider when determining the cost-benefit ratio. The session concludes with an opportunity for attendees to ask questions and engage with the presenter's wealth of industry knowledge.
Unauthorized message
After more than a year of broadcasting live and sharing on demand the lessons of this course, the time has come to set the final words.
The session is about cost benefit analysis – an easy method for determining the financial benefits of finding an issue/anomaly prior to an actual failure.
Here is what you can learn in the lesson #13:
1. L2CA method of reporting using the Excel spread sheet matrix
2. Learn the Equipment condition status report (ECSR)
3. Learn about the transformer grading tool which assigns
a number and letter grade to each transformer.
4. Learn Cost Benefit Analysis (CBA)
a. The importance of anomaly tracking and avoided cost documentation
b. Understanding the calculation process
c. Build an actual case history using the CBA process
About the author

Jon Giesecke
Mr. Giesecke is one of the world’s leading experts in combining technologies used in the in-service inspection of high voltage oil-filled power transformers and substation diagnostics. He has been training personnel worldwide in these methods for over 20 years with great success.
Prior to forming JLG Associates LLC in 2006, Giesecke was employed by EPRI Solutions as a senior project manager in the Substation Predictive Maintenance business area.
As a Senior Project Manager, some of his responsibilities included: the development and implementation of the Substation Predictive Maintenance Program (SPdM) at numerous electric utilities in the U.S. and abroad; Developing and Instructing an EPRI Solutions’ SPdM course; instructed portions of the EPRI Transformer Performance Monitoring and Diagnostics course and the EPRI Substation/Switchyard Predictive Maintenance course; Providing training, services and consulting to evaluate maintenance responsibility and advanced programs applied to switchyard/substation components.