Unveiling Transformer Failures: Insights from Utilities Repaired Transformers and Their Revival