

One of the most common techniques to assess the condition of Power Transformers is through regular insulating liquid sampling and analysis. These SMEs are also busy dealing with all sort of emergencies and requirements from the day-to-day operation of the business.īased on many years of accumulated experience, international reliability surveys and the hard work of many of these SMEs around the world, the industry has developed a range of diagnosis techniques that assist in the management of these assets. Utilities and other asset intensive organisations depend on assessments performed by Subject Matter Experts (SME) to make the most effective and efficient decisions. These are typically very expensive assets with long replacement lead times. Power transformers and other insulating liquid-filled assets are critical component of electrical grids. It appears that Matlab and Mathematica may have this feature built in.The challenge of managing Power Transformers Ī critical aspect of managing assets is to understand their condition, their performance against the organisation's objectives and the level of risk they represent. I tried DPlot once, but never used its ternary plot feature. If you really feel that you cannot use this kind of approach, then I think you will need to seek out third party graphing packages that have triangle plots built into them. If you are careful the first time, you can save that file as a template to use it for future triangle diagrams. It is a bit of effort up front to review the geometry involved in the transformation. I have used this approach when creating my own ternary and triangle plots, and it works fairly well. If you can explain why this approach would not be useful to you, we may be better able to suggest alternatives (or help you overcome those obstacles in Excel). Can you explain why "plotting the triangle on a scatter plot" is unhelpful for your purposes? Whether you use built in Excel functionality or VBA or any other programming language, creating the chart in Excel is going to come down to using an XY scatter chart with appropriate formulas (whether spreadsheet formulas or VBA formulas) to transform the data into triangular coordinates.
