jagomart
digital resources
picture1_Ledger Format In Excel Free Download 30982 | Copy Of D16 147965  Actewagl 2015 16   Annual Rin Response   Basis Of Preparation   1 November 2016   Public


 309x       Filetype XLSX       File size 0.42 MB       Source: www.aer.gov.au


File: Ledger Format In Excel Free Download 30982 | Copy Of D16 147965 Actewagl 2015 16 Annual Rin Response Basis Of Preparation 1 November 2016 Public
actewagl distribution basis of preparation annual rin 201516 variable financial or actual or data source methodology nonfinancial estimated worksheet 211 labour table 2113 labour nonlabour expenditure split 21131 opex inhouse ...

icon picture XLSX Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Partial file snippet.
                                                                                                                                                                                                ActewAGL Distribution: Basis of Preparation - ANNUAL RIN 2015/16
                                                                   Variable                                                  Financial or       Actual or                                                Data source                                                                                                                            Methodology
                                                                                                                           Non-Financial        Estimated
                     Worksheet 2.11 - LABOUR
                     Table 2.11.3 - LABOUR / NON-LABOUR EXPENDITURE SPLIT
                     2.11.3.1 - Opex
                     In-house labour expenditure                                                                                  F                  A          ORACLE general ledger                                                                          ORACLE General Ledger has natural accounts which capture total expenditure for this category. Related party services are separated by reviewing expenditure to ActewAGL's          a
                     Labour expenditure outsourced to related parties                                                             F                  A                                                                                                         partners.
                     Labour expenditure outsourced to unrelated parties                                                           F                  A
                     Controllable non-labour expenditure                                                                          F                  A
                     Uncontrollable non-labour expenditure                                                                        F                  A
                     2.11.3.2 - Capex
                     In-house labour expenditure                                                                                  F                  A          ORACLE general ledger                                                                          ORACLE General Ledger has natural accounts which capture total expenditure for this category. Related party services are separated by reviewing expenditure to ActewAGL's          a
                     Labour expenditure outsourced to related parties                                                             F                  A                                                                                                         partners.
                     Labour expenditure outsourced to unrelated parties                                                           F                  A
                     Controllable non-labour expenditure                                                                          F                  A
                     Uncontrollable non-labour expenditure                                                                        F                  A
                     Worksheet 3.6 - QUALITY OF SERVICES
                     Table 3.6.5 - QUALITY OF SUPPLY METRICS
                     Over voltage events - due to high voltage injection                                                          x                  x          x                                                                                              TNSP Metering Project has been approved and will be completed during 2016/17 to install metering capable of measuring quality of supply                                            a
                     Customers receiving over-voltage - due to high voltage injection                                             x                  x
                     Over voltage events - due to lightning                                                                       x                  x
                     Customers receiving over-voltage - due to lightning                                                          x                  x
                     Over voltage events - due to voltage regulation or other cause                                               x                  x
                     Customers receiving over-voltage - due to voltage regulation or other cause                                  x                  x
                     Voltage variations - steady state (zone sub)                                                                 x                  x
                     Voltage variations - one minute (zone sub)                                                                   x                  x
                     Voltage variations - 10 seconds (zone sub) Min<0.7                                                           x                  x
                     Voltage variations - 10 seconds (zone sub) Min<0.8                                                           x                  x
                     Voltage variations - 10 seconds (zone sub) Min<0.9                                                           x                  x
                     Voltage variations - steady state (feeder)                                                                   x                  x
                     Voltage variations - % zone subs monitored                                                                   x                  x
                     Voltage variations - % feeders monitored                                                                     x                  x
                     Table 3.6.6 - COMPLAINTS - TECHNICAL QUALITY OF SUPPLY
                     3.6.6.1 - TECHNICAL QUALITY OF SUPPLY
                     Number of complaints - technical quality of supply                                                           N                  A          VELOCITY billing database                                                                      [VELOCITY extract] Monthly SQL from VELOCITY filtered by complaint category 'quality of supply'. This report shows all complaint categories required in this table (e.g.           a
                                                                                                                                                                                                                                                               Complaint - technical quality of supply - number), consistent with definitions as described in legislation (Annual RIN issued by the AER to ActewAGL 3rd February 2016) and 
                                                                                                                                                                                                                                                               previous years experience/calculation methodology. 
                                                                                                                                                                                                                                                               ActewAGL confirms complaint information is captured and calculations made in accordance with the AER's final decision on ActewAGL's revenue proposal 2015-19 
                                                                                                                                                                                                                                                               (attachment 11 - Service Target Performance Incentive Scheme).
                     3.6.6.2 - PERCENTAGE OF COMPLAINTS BY CATEGORY
                     Low voltage supply                                                                                           x                  x          x                                                                                              TNSP Metering Project has been approved and will be completed during 2016/17 to install metering capable of measuring quality of supply.                                           a
                     Voltage dips                                                                                                 x                  x
                     Voltage swell                                                                                                x                  x
                     Voltage spike (impulsive transient)                                                                          x                  x
                     Waveform distortion                                                                                          x                  x
                     TV or radio interference                                                                                     x                  x
                     Solar related                                                                                                x                  x
                     Noise from appliances                                                                                        x                  x
                     Other                                                                                                        x                  x
                     3.6.6.3 - PERCENTAGE OF COMPLAINTS BY LIKELY CAUSE
                     Network equipment faulty                                                                                     x                  x          x                                                                                              x                                                                                                                                                                                  a
                     Network interference by NSP equipment                                                                        x                  x
                     Network interference by another customer                                                                     x                  x
                     Network limitation                                                                                           x                  x
                     Customer internal problem                                                                                    x                  x
                     No problem identified                                                                                        x                  x
                     Environmental                                                                                                x                  x
                     Other                                                                                                        x                  x
                     Table 3.6.7 - CUSTOMER SERVICE METRICS
                     3.6.7.1 - TIMELY PROVISIONS OF SERVICES
                     Number of connections made                                                                                   x                  x          x                                                                                              x                                                                                                                                                                                  a
                     Number of connections not made on or before agreed date                                                      x                  x
                     3.6.7.2 - TIMELY REPAIR OF FAULTY STREET LIGHTS
                     Street lights - average monthly number "out"                                                                 x                  x          ActewAGL Distribution does not own the streetlight network in the ACT                          x                                                                                                                                                                                  a
                     Street lights - not repaired by "fix by" date                                                                x                  x
                     Street lights - average number of days to repair                                                             x                  x
                     Total number of street lights                                                                                x                  x
                     3.6.7.3 - CALL CENTRE PERFORMANCE
                     Calls to call centre fault line                                                                              N                  A          CISCO historical reporting platform                                                            Data is extracted by accessing the CISCO historical reporting platform for specific contact centre reports for the specified date range (01/07/2015 to 30/06/2016). This report    a
                     Calls to fault line answered within 30 seconds                                                               N                  A                                                                                                         shows all categories required in this table (e.g. Calls to fault line - average waiting time before call answered), consistent with definitions as described in legislation (Annual 
                                                                                                                                                                                                                                                               RIN issued by the AER to ActewAGL 3rd February 2016) and previous years experience/calculation methodology. 
                                                                                                                                                                                                                                                               Percentage of calls abandoned is provided in the report obtained from CISCO historical reporting. Calculation is based on number of abandoned calls divided by total calls 
                     Calls to fault line - average waiting time before call answered                                              N                  A                                                                                                         presented to obtain a percentage.
                                                                                                                                                                                                                                                               Note: Overload events are tracked manually within the business based on specific events. [Please note  there were nil overload events this FY].
                                                                                                                                                                                                                                                               ActewAGL confirms reliability and performance calculations are made in accordance with the AER's final decision on ActewAGL's revenue proposal 2015-19 (attachment 11 - 
                                                                                                                                                                                                                                                               Service Target Performance Incentive Scheme).
                     Call centre - number of overload events                                                                      N                  A
                                                                                                                                                                CISCO historical reporting platform                                                            Data is extracted by accessing the CISCO historical reporting platform for specific contact centre reports for the specified date range (01/07/2015 to 30/06/2016). This report 
                                                                                                                                                                                                                                                               shows all categories required in this table (e.g. Calls to fault line - average waiting time before call answered), consistent with definitions as described in legislation (Annual 
                                                                                                                                                                                                                                                               RIN issued by the AER to ActewAGL 3rd February 2016) and previous years experience/calculation methodology. 
                                                                                                                                                                                                                                                               Percentage of calls abandoned is provided in the report obtained from CISCO historical reporting. Calculation is based on number of abandoned calls divided by total calls 
                                                                                                                                                                                                                                                               presented to obtain a percentage.
                                                                                                                                                                                                                                                               Note: Overload events are tracked manually within the business based on specific events. [Please note  there were nil overload events this FY].
                                                                                                                                                                                                ActewAGL Distribution: Basis of Preparation - ANNUAL RIN 2015/16
                                                                                                                                                                                                                                                               ActewAGL confirms reliability and performance calculations are made in accordance with the AER's final decision on ActewAGL's revenue proposal 2015-19 (attachment 11 - 
                                                                                                                                                                                                                                                               Service Target Performance Incentive Scheme).
                                                                   Variable                                                  Financial or       Actual or                                                Data source                                                                                                                            Methodology
                                                                                                                           Non-Financial        Estimated
                     Percentage of calls abandoned                                                                                N                  A
                     3.6.7.4 - NUMBER OF CUSTOMER COMPLAINTS
                     Complaint - reliability of supply                                                                            x                  x          VELOCITY billing database                                                                      Refer to table 3.6.6.1 re Complaint - technical quality of supply                                                                                                                  a
                     Complaint - technical quality of supply                                                                      N                  A
                     Complaint - administrative process or customer service                                                       x                  x
                     Complaint - connection or augmentation                                                                       x                  x
                     Complaint - other                                                                                            x                  x
                     Total number of complaints                                                                                   x                  x
                     Worksheet 3.6.8 - NETWORK - FEEDERS
                     Table 3.6.8 - Network Feeder Reliability
                     Feeder ID / name                                                                                             N                  A          ADMS Distribution Management System, APPLY Outage database, ArcFM GIS database                 Feeder classification is based on the ratio which existed during the previous regulatory period,  which was used for the 5 year average and as a basis for the current STPIS       a
                     Description of the service area for the feeder                                                               N                  A                                                                                                         targets. ActewAGL considers this reasonable as it is consistent with legislation (Annual RIN issued by the AER to ActewAGL 3rd February 2016) and previous years 
                                                                                                                                                                                                                                                               methodologies. ActewAGL also considers this reliable as there exists sufficient and appropriate supporting documentation to present in support of the methodology, and the 
                     Feeder classification                                                                                        N                  A                                                                                                         information itself was prepared by competent, capable and objective ActewAGL staff, Feeder classification is considered 'Actual' data since it is not estimated or calculated.
                     Number of distribution customers(1)                                                                          N                  A                                                                                                         Number of Distribution Customers: Number of customers on each feeder (count of Active NMI per feeder obtained from ArcFM extracts)
                     Length of high voltage distribution lines - Overhead                                                         N                  A
                     Length of high voltage distribution lines - Underground                                                      N                  A                                                                                                         ActewAGL confirms reliability calculations are made in accordance with the AER's final decision on ActewAGL's revenue proposal 2015-19 (attachment 11 - Service Target 
                     Maximum demand (MVA)                                                                                         N                  A                                                                                                         Performance Incentive Scheme).
                                                                                                                                                                                                                                                               SAIDI is the sum of the duration of each unplanned sustained interruption (in minutes) divided by the total number of distribution customers. SAIDI excludes momentary 
                                                                                                                                                                                                                                                               interruptions (one minute or less). 
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIDI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                     Energy not supplied (MWh) - Unplanned                                                                        N                  A                                                                                                         Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification - Urban: Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural: Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               SAIFI is the total number of each unplanned sustained interruption divided by the total number of distribution customers. SAIFI excludes momentary interruptions (one 
                     Energy not supplied (MWh) - Planned                                                                          N                  A                                                                                                         minute or less)). SAIFI is expressed per 0.01 interruption. 
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIFI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                     Low Reliability Feeder (SAIDI)                                                                               N                  A                                                                                                         Network Classification - Urban: Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural: Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               ActewAGL has applied the definitions (as per Annual RIN issued by the AER to ActewAGL 3rd February 2016) relating to Energy not supplied (unplanned)(MWh), Energy not 
                                                                                                                                                                                                                                                               supplied (planned)(MWh), Unplanned outage, SAIDI and SAIFI to its calculation methodology, exclusive of the effect of excluded outages (such as load interruptions by a 
                                                                                                                                                                                                                                                               transmission connection asset failure) and exclusive of momentary outages.
                                                                                                                                                                                                                                                               For outages from 1-Jul-2015 to 19-Feb-2016, energy not supplied is calculated using average energy not delivered per customer per minute from ADMS data above multiplied 
                     Unplanned Outages - Total number of unplanned outages                                                        N                  A                                                                                                         by the customer minutes off supply. ActewAGL considers this reasonable as it is consistent with legislation (Annual RIN issued by the AER to ActewAGL 3rd February 2016) and 
                                                                                                                                                                                                                                                               previous years experience (calculation methodology. It was not possible to use option (a) for this period due to IT systems (APPLY and TCS) not allowing the linking of actual 
                                                                                                                                                                                                                                                               energy delivered (billing history) with customers connected to each feeder.
                                                                                                                                                                                                                                                               From 20-Feb-2016 onwards, energy not supplied is calculated using option (a) average consumption of customers interrupted based on their billing history. This data is 
                     Unplanned Outages - Unplanned customer minutes off-supply - Including excluded events and                    N                  A                                                                                                         included in the outages extract from ADMS. ActewAGL considers this calculation to be as reliable as possible as going forward, ActewAGL will be reporting on reliability using 
                     MEDs                                                                                                                                                                                                                                      the ADMS as the single source of truth ensuring only the highest quality data is used.
                                                                                                                                                                                                                                                               ActewAGL confirms this approach is consistent with the definition of Total planned customer minutes off supply (not including momentary interruptions) as per the Annual 
                                                                                                                                                                                                                                                               RIN issued by the AER to ActewAGL 3rd February 2016.
                                                                                                                                                                                                                                                               [ADMS Distribution Management System - outages extract] manipulated in spreadsheet to produce outage reports (Actual)] - Irrelevant records (Customer fault and 
                                                                                                                                                                                                                                                               Cancelled incidents) are first removed from ADMS extract. Planned statistics are sum of Incidents with "Planned" Cause where average duration is > 1 minute. Unplanned 
                                                                                                                                                                                                                                                               statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                     Unplanned Outages - Unplanned customer minutes off-supply -After removing excluded events                    N                  A
                     and MED                                                                                                                                                                                                                                   [APPLY Outage database extract] manipulated in spreadsheet to produce outage  reports (Actual). Single Premise Outage Report extract manipulated in spreadsheet to 
                                                                                                                                                                                                                                                               produce outage  reports (Actual)] - Irrelevant records (Customer fault incidents) are first removed from APPLY extract. Planned statistics are sum of Incidents with "Planned" 
                                                                                                                                                                                                                                                               Cause where average duration is > 1 minute. Unplanned statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [ArcFM extract (PremiseInfo, Meter and ServicePoint tables)] manipulated in spreadsheet to estimate the ratio of Urban vs Rural customers; and extract of HV cables and 
                                                                                                                                                                                                                                                               conductors manipulated in spreadsheet to calculate OH and UG feeder lengths] - Premise Info table is first joined to Meter table using PremiseInfoUID. The resulting table is 
                                                                                                                                                                                                                                                               then joined to Service Point table using ServicePointUID. A Pivot table is then constructed to count the number of NMIs (number of customers) for each HV feeder.
                     Unplanned Outages - Unplanned interruptions - Including excluded events and MEDs                             N                  A
                     Unplanned Outages - Unplanned interruptions - After removing excluded events and MED                         N                  A
                     Planned Outages - Total number of planned outages                                                            N                  A
                     Planned Outages - Planned customer minutes off-supply - Including excluded events and MEDs                   N                  A
                     Planned Outages - Planned customer minutes off-supply - After removing excluded events and                   N                  A
                     MED
                     Planned Outages - Planned interruptions (SAIFI) - Including excluded events and MEDs                         N                  A
                     Planned Outages - Planned interruptions (SAIFI) -After removing excluded events and MED                      N                  A
                     Worksheet 3.6.9 - NETWORK - RELIABILITY
                     Table 3.6.9.1 - PLANNED MINUTES OFF SUPPLY (SAIDI)
                                                                                                                                                                                                ActewAGL Distribution: Basis of Preparation - ANNUAL RIN 2015/16
                                                                   Variable                                                  Financial or       Actual or                                                Data source                                                                                                                            Methodology
                                                                                                                           Non-Financial        Estimated
                     SAIDI - Network categorisation - CBD                                                                         N                  A          ADMS Distribution Management System, APPLY Outage database, ArcFM GIS database,                SAIDI is the sum of the duration of each unplanned sustained interruption (in minutes) divided by the total number of distribution customers. SAIDI excludes momentary             a
                                                                                                                                                                Annual RIN 3.6.8                                                                               interruptions (one minute or less)
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIDI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification -Urban  - Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural – Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Individual Feeder – Customers on that Feeder (count of Active NMI per feeder obtained from ArcFM extracts) 
                     SAIDI - Network categorisation - Urban                                                                       N                  A                                                                                                         SAIFI is the total number of each unplanned sustained interruption divided by the total number of distribution customers. SAIFI excludes momentary interruptions (one 
                                                                                                                                                                                                                                                               minute or less)). SAIFI is expressed per 0.01 interruption. 
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIFI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification -Urban  - Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural – Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               ActewAGL has applied the definition (as per Annual RIN issued by the AER to ActewAGL 3rd February 2016) relating to Planned SAIDI to its calculation methodology, excluding 
                                                                                                                                                                                                                                                               momentary interruptions (one minute or less). As shown above this is inclusive of Whole Network, and Network Classification.
                                                                                                                                                                                                                                                               [ADMS Distribution Management System - outages extract] manipulated in spreadsheet to produce outage reports (Actual)] - Irrelevant records (Customer fault and 
                                                                                                                                                                                                                                                               Cancelled incidents) are first removed from ADMS extract. Planned statistics are sum of Incidents with "Planned" Cause where average duration is > 1 minute. Unplanned 
                     SAIDI - Network categorisation - Rural short                                                                 N                  A                                                                                                         statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [APPLY Outage database extract] manipulated in spreadsheet to produce outage  reports (Actual). Single Premise Outage Report extract manipulated in spreadsheet to 
                                                                                                                                                                                                                                                               produce outage  reports (Actual)] - Irrelevant records (Customer fault incidents) are first removed from APPLY extract. Planned statistics are sum of Incidents with "Planned" 
                                                                                                                                                                                                                                                               Cause where average duration is > 1 minute. Unplanned statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [ArcFM extract (PremiseInfo, Meter and ServicePoint tables)] manipulated in spreadsheet to estimate the ratio of Urban vs Rural customers; and extract of HV cables and 
                                                                                                                                                                                                                                                               conductors manipulated in spreadsheet to calculate OH and UG feeder lengths] -  Premise Info table is first joined to Meter table using PremiseInfoUID. The resulting table is 
                                                                                                                                                                                                                                                               then joined to Service Point table using ServicePointUID. A Pivot table is then constructed to count the number of NMIs (number of customers) for each HV feeder.
                     SAIDI - Network categorisation - Rural long                                                                  N                  A
                     SAIDI - Network categorisation - Whole network                                                               N                  A
                     Table 3.6.9.2 - PLANNED INTERRUPTIONS TO SUPPLY (SAIFI)
                     SAIFI - Network categorisation - CBD                                                                         N                  A          ADMS Distribution Management System, APPLY Outage database, ArcFM GIS database,                SAIDI is the sum of the duration of each unplanned sustained interruption (in minutes) divided by the total number of distribution customers. SAIDI excludes momentary             a
                                                                                                                                                                Annual RIN 3.6.8                                                                               interruptions (one minute or less).
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIDI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification -Urban  - Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural – Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Individual Feeder – Customers on that Feeder (count of Active NMI per feeder obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               SAIFI is the total number of each unplanned sustained interruption divided by the total number of distribution customers. SAIFI excludes momentary interruption (one minute 
                                                                                                                                                                                                                                                               or less)). SAIFI is expressed per 0.01 interruption. 
                     SAIFI - Network categorisation - Urban                                                                       N                  A                                                                                                         The number of distribution customer used to derive SAIFI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification -Urban  - Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural – Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               ActewAGL has applied the definition (as per Annual RIN issued by the AER to ActewAGL 3rd February 2016) relating to Planned SAIFI to its calculation methodology, excluding 
                                                                                                                                                                                                                                                               momentary interruptions (one minute or less). As shown above this is inclusive of Whole Network, and Network Classification.
                                                                                                                                                                                                                                                               [ADMS Distribution Management System - outages extract] manipulated in spreadsheet to produce outage reports (Actual)] - Irrelevant records (Customer fault and 
                                                                                                                                                                                                                                                               Cancelled incidents) are first removed from ADMS extract. Planned statistics are sum of Incidents with "Planned" Cause where average duration is > 1 minute. Unplanned 
                     SAIFI - Network categorisation - Rural short                                                                 N                  A                                                                                                         statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [APPLY Outage database extract] manipulated in spreadsheet to produce outage  reports (Actual). Single Premise Outage Report extract manipulated in spreadsheet to 
                                                                                                                                                                                                                                                               produce outage  reports (Actual)] -  Irrelevant records (Customer fault incidents) are first removed from APPLY extract. Planned statistics are sum of Incidents with "Planned" 
                                                                                                                                                                                                                                                               Cause where average duration is > 1 minute. Unplanned statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [ArcFM extract (PremiseInfo, Meter and ServicePoint tables)] manipulated in spreadsheet to estimate the ratio of Urban vs Rural customers; and extract of HV cables and 
                                                                                                                                                                                                                                                               conductors manipulated in spreadsheet to calculate OH and UG feeder lengths] - Premise Info table is first joined to Meter table using PremiseInfoUID. The resulting table is 
                                                                                                                                                                                                                                                               then joined to Service Point table using ServicePointUID. A Pivot table is then constructed to count the number of NMIs (number of customers) for each HV feeder.
                     SAIFI - Network categorisation - Rural long                                                                  N                  A
                     SAIFI - Network categorisation - Whole network                                                               N                  A
                     Worksheet 6.2 RELIABILITY AND CUSTOMER SERVICE PERFORMANCE
                     Table 6.2.1 -UNPLANNED MINUTES OFF SUPPLY (SAIDI)
                     Total sustained minutes off supply - CBD                                                                     N                  A          ADMS Distribution Management System, APPLY Outage database, ArcFM GIS database,                Feeder classification is based on the ratio which existed during the previous regulatory period,  which was used for the 5 year average and as a basis for the current STPIS       a
                     Total sustained minutes off supply - Urban                                                                   N                  A          Annual RIN 3.6.8                                                                               targets. ActewAGL considers this reasonable as it is consistent with legislation (Annual RIN issued by the AER to ActewAGL 3rd February 2016) and previous years 
                                                                                                                                                                                                                                                               methodologies. ActewAGL also considers this reliable as there exists sufficient and appropriate supporting documentation to present in support of the methodology, and the 
                                                                                                                                                                                                                                                               information itself was prepared by competent, capable and objective ActewAGL staff, Feeder classification is considered 'Actual' data since it is not estimated or calculated.
                                                                                                                                                                                                                                                               ActewAGL confirms reliability calculations are made in accordance with the AER's final decision on ActewAGL's revenue proposal 2015-19 (attachment 11 - Service Target 
                                                                                                                                                                                                                                                               Performance Incentive Scheme).
                                                                                                                                                                                                                                                               SAIDI is the sum of the duration of each unplanned sustained interruption (in minutes) divided by the total number of distribution customers. SAIDI excludes momentary 
                                                                                                                                                                                                                                                               interruptions (one minute or less)
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIDI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification - Urban: Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural: Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Individual Feeder – Customers on that Feeder (count of Active NMI per feeder obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               SAIFI is the total number of each unplanned sustained interruption divided by the total number of distribution customers. SAIFI excludes momentary interruptions (one 
                                                                                                                                                                                                                                                               minute or less)). SAIFI is expressed per 0.01 interruption. 
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIFI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification - Urban: Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural: Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               ActewAGL has applied the definitions (as per Annual RIN issued by the AER to ActewAGL 3rd February 2016) relating to Energy not supplied (unplanned)(MWh), Energy not 
                                                                                                                                                                                                                                                               supplied (planned)(MWh), Unplanned outage, SAIDI and SAIFI to its calculation methodology, exclusive of the effect of excluded outages (such as load interruptions by a 
                                                                                                                                                                                                                                                               transmission connection asset failure) and exclusive of momentary outages.
                                                                                                                                                                                                                                                               [ADMS Distribution Management System - outages extract] manipulated in spreadsheet to produce outage reports (Actual)] - Irrelevant records (Customer fault and 
                                                                                                                                                                                                                                                               Cancelled incidents) are first removed from ADMS extract. Planned statistics are sum of Incidents with "Planned" Cause where average duration is > 1 minute. Unplanned 
                                                                                                                                                                                                                                                               statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [APPLY Outage database extract] manipulated in spreadsheet to produce outage  reports (Actual). Single Premise Outage Report extract manipulated in spreadsheet to 
                                                                                                                                                                                                                                                               produce outage  reports (Actual)] -  Irrelevant records (Customer fault incidents) are first removed from APPLY extract. Planned statistics are sum of Incidents with "Planned" 
                                                                                                                                                                                                                                                               Cause where average duration is > 1 minute. Unplanned statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [ArcFM extract (PremiseInfo, Meter and ServicePoint tables)] manipulated in spreadsheet to estimate the ratio of Urban vs Rural customers; and extract of HV cables and 
                                                                                                                                                                                                                                                               conductors manipulated in spreadsheet to calculate OH and UG feeder lengths] - Premise Info table is first joined to Meter table using PremiseInfoUID. The resulting table is 
                                                                                                                                                                                                                                                               then joined to Service Point table using ServicePointUID. A Pivot table is then constructed to count the number of NMIs (number of customers) for each HV feeder.
                                                                                                                                                                                                ActewAGL Distribution: Basis of Preparation - ANNUAL RIN 2015/16
                                                                                                                             Financial or       Actual or       ADMS Distribution Management System, APPLY Outage database, ArcFM GIS database,                Feeder classification is based on the ratio which existed during the previous regulatory period,  which was used for the 5 year average and as a basis for the current STPIS 
                                                                   Variable                                                Non-Financial        Estimated                                                Data source                                                                                                                            Methodology
                                                                                                                                                                Annual RIN 3.6.8                                                                               targets. ActewAGL considers this reasonable as it is consistent with legislation (Annual RIN issued by the AER to ActewAGL 3rd February 2016) and previous years 
                                                                                                                                                                                                                                                               methodologies. ActewAGL also considers this reliable as there exists sufficient and appropriate supporting documentation to present in support of the methodology, and the 
                     Total sustained minutes off supply - Short Rural                                                             N                  A                                                                                                         information itself was prepared by competent, capable and objective ActewAGL staff, Feeder classification is considered 'Actual' data since it is not estimated or calculated.
                                                                                                                                                                                                                                                               ActewAGL confirms reliability calculations are made in accordance with the AER's final decision on ActewAGL's revenue proposal 2015-19 (attachment 11 - Service Target 
                                                                                                                                                                                                                                                               Performance Incentive Scheme).
                                                                                                                                                                                                                                                               SAIDI is the sum of the duration of each unplanned sustained interruption (in minutes) divided by the total number of distribution customers. SAIDI excludes momentary 
                                                                                                                                                                                                                                                               interruptions (one minute or less)
                     Total sustained minutes off supply - Long Rural                                                              N                  A                                                                                                         The number of distribution customer used to derive SAIDI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification - Urban: Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural: Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                     Total sustained minutes off supply - Whole Network                                                           N                  A                                                                                                         Individual Feeder – Customers on that Feeder (count of Active NMI per feeder obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               SAIFI is the total number of each unplanned sustained interruption divided by the total number of distribution customers. SAIFI excludes momentary interruptions (one 
                                                                                                                                                                                                                                                               minute or less)). SAIFI is expressed per 0.01 interruption. 
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIFI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                     Total of excluded events (see 3.3 of STPIS) - CBD                                                            N                  A                                                                                                         Network Classification - Urban: Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural: Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               ActewAGL has applied the definitions (as per Annual RIN issued by the AER to ActewAGL 3rd February 2016) relating to Energy not supplied (unplanned)(MWh), Energy not 
                     Total of excluded events (see 3.3 of STPIS) - Urban                                                          N                  A                                                                                                         supplied (planned)(MWh), Unplanned outage, SAIDI and SAIFI to its calculation methodology, exclusive of the effect of excluded outages (such as load interruptions by a 
                                                                                                                                                                                                                                                               transmission connection asset failure) and exclusive of momentary outages.
                                                                                                                                                                                                                                                               [ADMS Distribution Management System - outages extract] manipulated in spreadsheet to produce outage reports (Actual)] - Irrelevant records (Customer fault and 
                     Total of excluded events (see 3.3 of STPIS) - Short Rural                                                    N                  A                                                                                                         Cancelled incidents) are first removed from ADMS extract. Planned statistics are sum of Incidents with "Planned" Cause where average duration is > 1 minute. Unplanned 
                                                                                                                                                                                                                                                               statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [APPLY Outage database extract] manipulated in spreadsheet to produce outage  reports (Actual). Single Premise Outage Report extract manipulated in spreadsheet to 
                                                                                                                                                                                                                                                               produce outage  reports (Actual)] -  Irrelevant records (Customer fault incidents) are first removed from APPLY extract. Planned statistics are sum of Incidents with "Planned" 
                                                                                                                                                                                                                                                               Cause where average duration is > 1 minute. Unplanned statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [ArcFM extract (PremiseInfo, Meter and ServicePoint tables)] manipulated in spreadsheet to estimate the ratio of Urban vs Rural customers; and extract of HV cables and 
                                                                                                                                                                                                                                                               conductors manipulated in spreadsheet to calculate OH and UG feeder lengths] - Premise Info table is first joined to Meter table using PremiseInfoUID. The resulting table is 
                     Total of excluded events (see 3.3 of STPIS) - Long Rural                                                     N                  A                                                                                                         then joined to Service Point table using ServicePointUID. A Pivot table is then constructed to count the number of NMIs (number of customers) for each HV feeder.
                     Total of excluded events (see 3.3 of STPIS) - Whole Network                                                  N                  A
                     Total sustained minutes off supply after removing excluded events - CBD                                      N                  A
                     Total sustained minutes off supply after removing excluded events - Urban                                    N                  A
                     Total sustained minutes off supply after removing excluded events - Short Rural                              N                  A
                     Total sustained minutes off supply after removing excluded events - Long Rural                               N                  A
                     Total sustained minutes off supply after removing excluded events - Whole Network                            N                  A
                     Table 6.2.2 -UNPLANNED MINUTES OFF SUPPLY (SAIFI)
                     Total sustained minutes off supply - CBD                                                                     N                  A          ADMS Distribution Management System, APPLY Outage database, ArcFM GIS database,                Feeder classification is based on the ratio which existed during the previous regulatory period,  which was used for the 5 year average and as a basis for the current STPIS       a
                     Total sustained minutes off supply - Urban                                                                   N                  A          Annual RIN 3.6.8                                                                               targets. ActewAGL considers this reasonable as it is consistent with legislation (Annual RIN issued by the AER to ActewAGL 3rd February 2016) and previous years 
                                                                                                                                                                                                                                                               methodologies. ActewAGL also considers this reliable as there exists sufficient and appropriate supporting documentation to present in support of the methodology, and the 
                                                                                                                                                                                                                                                               information itself was prepared by competent, capable and objective ActewAGL staff, Feeder classification is considered 'Actual' data since it is not estimated or calculated.
                                                                                                                                                                                                                                                               ActewAGL confirms reliability calculations are made in accordance with the AER's final decision on ActewAGL's revenue proposal 2015-19 (attachment 11 - Service Target 
                                                                                                                                                                                                                                                               Performance Incentive Scheme).
                     Total sustained minutes off supply - Short Rural                                                             N                  A
                                                                                                                                                                                                                                                               SAIDI is the sum of the duration of each unplanned sustained interruption (in minutes) divided by the total number of distribution customers. SAIDI excludes momentary 
                                                                                                                                                                                                                                                               interruptions (one minute or less)
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIDI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                                                                                                                                                                                                                                                               Network Classification - Urban: Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural: Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Individual Feeder – Customers on that Feeder (count of Active NMI per feeder obtained from ArcFM extracts)
                     Total sustained minutes off supply - Long Rural                                                              N                  A                                                                                                         SAIFI is the total number of each unplanned sustained interruption divided by the total number of distribution customers. SAIFI excludes momentary interruptions (one 
                                                                                                                                                                                                                                                               minute or less)). SAIFI is expressed per 0.01 interruption. 
                                                                                                                                                                                                                                                               The number of distribution customer used to derive SAIFI reflect the relevant network type and the average of the number of customer at the beginning of the reporting 
                                                                                                                                                                                                                                                               period and the number of customers at the end of the reporting period.
                                                                                                                                                                                                                                                               Whole Network – Total Distribution  customers
                     Total sustained minutes off supply - Whole Network                                                           N                  A                                                                                                         Network Classification - Urban: Total Urban Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               Network Classification – Short Rural: Total Short Rural Customers (using ratio obtained from ArcFM extracts)
                                                                                                                                                                                                                                                               ActewAGL has applied the definitions (as per Annual RIN issued by the AER to ActewAGL 3rd February 2016) relating to Energy not supplied (unplanned)(MWh), Energy not 
                                                                                                                                                                                                                                                               supplied (planned)(MWh), Unplanned outage, SAIDI and SAIFI to its calculation methodology, exclusive of the effect of excluded outages (such as load interruptions by a 
                                                                                                                                                                                                                                                               transmission connection asset failure) and exclusive of momentary outages.
                                                                                                                                                                                                                                                               [ADMS Distribution Management System - outages extract] manipulated in spreadsheet to produce outage reports (Actual)] - Irrelevant records (Customer fault and 
                                                                                                                                                                                                                                                               Cancelled incidents) are first removed from ADMS extract. Planned statistics are sum of Incidents with "Planned" Cause where average duration is > 1 minute. Unplanned 
                     Total of excluded events (see 3.3 of STPIS) - CBD                                                            N                  A                                                                                                         statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                                                                                                                                                                                                                                                               [APPLY Outage database extract] manipulated in spreadsheet to produce outage  reports (Actual). Single Premise Outage Report extract manipulated in spreadsheet to 
                                                                                                                                                                                                                                                               produce outage  reports (Actual)] -  Irrelevant records (Customer fault incidents) are first removed from APPLY extract. Planned statistics are sum of Incidents with "Planned" 
                                                                                                                                                                                                                                                               Cause where average duration is > 1 minute. Unplanned statistics are sum of Incidents with Cause of anything other than "Planned" where the average duration is > 1 minute.
                     Total of excluded events (see 3.3 of STPIS) - Urban                                                          N                  A                                                                                                         [ArcFM extract (PremiseInfo, Meter and ServicePoint tables)] manipulated in spreadsheet to estimate the ratio of Urban vs Rural customers; and extract of HV cables and 
                                                                                                                                                                                                                                                               conductors manipulated in spreadsheet to calculate OH and UG feeder lengths] - Premise Info table is first joined to Meter table using PremiseInfoUID. The resulting table is 
                                                                                                                                                                                                                                                               then joined to Service Point table using ServicePointUID. A Pivot table is then constructed to count the number of NMIs (number of customers) for each HV feeder.
                     Total of excluded events (see 3.3 of STPIS) - Short Rural                                                    N                  A
The words contained in this file might help you see if this file matches what you are looking for:

...Actewagl distribution basis of preparation annual rin variable financial or actual data source methodology nonfinancial estimated worksheet labour table nonlabour expenditure split opex inhouse f a oracle general ledger has natural accounts which capture total for this category related party services are separated by reviewing to s outsourced parties partners unrelated controllable uncontrollable capex quality supply metrics over voltage events due high injection x tnsp metering project been approved and will be completed during install capable measuring customers receiving overvoltage lightning regulation other cause variations steady state zone sub one minute seconds min unplanned statistics sum incidents with anything than planned where the average duration is manipulated in spreadsheet estimate ratio urban vs rural extract hv cables conductors calculate oh ug feeder lengths premise info first joined meter using premiseinfouid resulting then service point servicepointuid pivot const...

no reviews yet
Please Login to review.