The substation model is easily implemented using
Microsoft Excel. The conditional formatting function
allows you to program visual indications of the
severity of the equipment routine test result. In this
instance, the following applies for the model:
• RED = 3
• YELLOW = 2
• GREEN = 1
Furthermore, Fig. 9 below illustrates the substation
PHI scores for a number of substations. Here, the
substation PHI is scored as follows:
• RED = >5
• YELLOW 3-5
• GREEN