schema 2017 co-ordinated market prioritisation results · schema 2017 co-ordinated market...
TRANSCRIPT
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 1 of 15 Schema 2017 Prioritisation Results
Schema 2017
Co-ordinated Market Prioritisation Results
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 2 of 15 Schema 2017 Prioritisation Results
Table of Contents
1 Process 3
2 Input Criteria 3
3 Statistical Analysis Methodology 5
4 Results 6
4.1 SUMMARY OF ALL RESULTS RECEIVED. .................................................................................................. 6 4.2 ROI PRIORITISATION ........................................................................................................................... 8 4.1 NI PRIORITISATION ........................................................................................................................... 10 4.1 RESULTS FOR MPS WHO OPERATE IN BOTH MARKETS ........................................................................... 12
5 Next Steps 14
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 3 of 15 Schema 2017 Prioritisation Results
1 Process
ReMCoDS requested that all Participants in both Northern Ireland (NI) and RoI (Republic of Ireland) provide their rating against the full set of MCRs applicable to both jurisdictions. The request for prioritisation was made at the ReMCoWG on the 2nd November 2016. ReMCoDS followed up with MPs to ensure an acceptable number of responses were provided for assessment. ReMCoDS analysed the responses to produce 3 final prioritisation lists. These were:
1. RoI MP prioritisation of Schema impacting MCRs. 2. NI MP prioritisation of Schema impacting MCRs. 3. Co-ordinated prioritisation of MPs who operate in both jurisdictions.
This document which contains all prioritisation exercise details will be provided to the two DSO’s namely ESB Networks and NIE Networks. The DSO’s shall meet to discuss the results and provide a proposed Schema Release 2017 package and delivery schedule based on synergies between MCR’s, other Retail Market Work Programmes and priority.
2 Input Criteria
In order to develop the three prioritisation lists and identify the results in section 4, the following input criteria are acknowledged:-
Co-ordinated Respondent Group - 13 MPs responded. These 13 MPs are assessed on the following basis
o RoI respondent group - 11 MP respondents o NI respondent group - 7 MP respondents o MPs who operate in both markets – 5 MP respondents
Total List of MCRs - 9 MCRs were in the pot for prioritisation. o 5 MCRs were RoI MCRs o 2 MCRs were NI MCRs o 2 MCRs were dual
MCR1183 010 Cust Agreement Validation NI
MCR1173 Vulnerable Customer Changes ROI
MCR1167 Public Lighting Proposal ROI
MCR1154 New Un-metered Tariff for NI NI
MCR 1114
Post-Harmonisation Sundry Technical Changes to HBL Schema....
Read more DUAL
MCR 0176 Email Address Validation.... Read more DUAL
MCR 0175 New Reject Reasons for Address Change Rejection.... Read more ROI
MCR 0073Proposal to make first name mandatory on market messages....
Read more ROI
MCR 0069 Irish language character set.... Read more ROI
MCR Number Description Category
MCR Ranking Method.
o MPs rated the MCRs from 1 to 9 with 1 being their preferred MCR and 9 being their least preferred MCR.
o 0 was given where an MCR held no value to the Participant and they did not share an interest in its delivery.
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 4 of 15 Schema 2017 Prioritisation Results
Participant (MP) MCR ranking scores – each MP was requested to provide their organisational view of what MCR was top priority (value 1), lowest priority (9) or has no value (0)
Final MP Prioritisation scores - ReMCoDS converted the ratings provided by MPs into scores. Where an MP gave a rating of 1 this resulted in a score of 9. Where an MP gave a rating of 2 this resulted in a score of 8 and so forth. Where an MP did not rate an MCR it was scored zero.
ReMCoDS then split this overall MCR scoring into two lists. - An RoI list with 7 MCRs and - An NI List with 4 MCRs ReMCoDS then rescored these lists to give an MPs top scoring MCR in RoI a score of 7 and the top scoring MCR in NI a 4. (See example below). This was done for every MP in both jurisdictions. This method provides better clarity of MPs prioritisation where they operate in both Jurisdictions.
MP
Ranking
Score
Final
Score
1 9
2 8
3 7
4 6
5 5
6 4
7 3
8 2
9 1
No
Rating 0
Full List
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 5 of 15 Schema 2017 Prioritisation Results
Example
MP
Ranking
Score
Final
Score
MP
Ranking
Score
Final
Score
1 7 4 1
3 5 3 2
2 6 1 4
4 4 2 3
7 1
5 3
6 2
RoI NI
3 Statistical Analysis Methodology
The main statistical measure used to identify each jurisdictions prioritised list of MCRs was the average of the jurisdictions MP scoring per MCR.
A second metric was used to provide further clarity on the number of MP’s who voted for an MCR as one of their top 3 priorities. The second metric provided a useful insight into the strength of the MCR priority across the relevant market yet still allowing for anonymity. The results of this second evaluation more or less mirrored the results delivered by the average measure.
Metric 1 was applied to the four groups of prioritisation, namely:
MPs operating in both markets.
All MPs
RoI MPs
NI MPs
Metric 2 was used on
MPs operating in both markets.
All MPs
The definitions of metrics 1 and 2 are as follows:-
Metric 1: Statistical Average (Arithmetic Mean) – defined as: the sum of a collection of numbers (ranking score) divided by the number of items in the collection (respondent group)
Metric 2: was calculated by the Number of MPs who rated an MCR in their top 3 (i.e. who rated an MCR either 1, 2 or 3).
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 6 of 15 Schema 2017 Prioritisation Results
MCR1183 010 Cust Agreement Validation 9 9 8 8 2 9 0 9 0 6 1 0 5 5.08 3 66 6 2
MCR1173 Vulnerable Customer Changes 8 7 7 2 8 8 9 6 0 9 9 0 8 6.23 1 81 9 1
MCR1167 Public Lighting Proposal 1 6 6 7 7 7 0 1 0 8 8 0 7 4.46 5 58 6 2
MCR1154 New Un-metered Tariff for NI 2 8 4 9 1 6 0 8 0 7 5 0 4 4.15 6 54 4 3
MCR 1114
Post-Harmonisation Sundry Technical
Changes to HBL Schema. 7 4 5 3 5 5 4 5 0 3 2 0 3 3.54 7 46 1 5
MCR 0176 Email Address Validation.... Read more 5 5 3 4 9 4 6 4 0 4 6 8 6 4.92 4 64 2 4
MCR 0175
New Reject Reasons for Address Change
Rejection.... Read more 6 3 9 6 6 3 8 7 0 5 7 9 9 6.00 2 78 6 2
MCR 0073
Proposal to make first name mandatory on
market messages. 4 2 2 5 4 2 5 3 0 2 4 0 0 2.54 8 33 1 5
MCR 0069 Irish language character set.... Read more 3 1 1 1 3 1 7 2 0 1 3 7 2 2.46 9 32 2 4
RankMP11 MP12 MP13 Rank
Total
ScoreMP7 MP8 MP9 MP10
No of Top 3
Ratings
Avg
ScoreMCR Description MP1 MP2 MP3 MP4 MP5 MP6
4 Results
4.1 Summary of all results received.
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 7 of 15 Schema 2017 Prioritisation Results
Arithmetic Mean Metric
Position Title Score
1st MCR1173 Vulnerable Customer Changes 6.2
2nd MCR 0175
New Reject Reasons for Address Change Rejection....
Read more 6.0
3rd MCR1183 010 Cust Agreement Validation 5.1
4th MCR 0176 Email Address Validation.... Read more 4.9
5th MCR1167 Public Lighting Proposal 4.5
6th MCR1154 New Un-metered Tariff for NI 4.2
7th MCR 1114
Post-Harmonisation Sundry Technical Changes to HBL
Schema. 3.5
8th MCR 0073
Proposal to make first name mandatory on market
messages. 2.5
9th MCR 0069 Irish language character set.... Read more 2.5
Top 3 Metric
Position Title Score
1st MCR1173 Vulnerable Customer Changes 9
2nd MCR 0175
New Reject Reasons for Address Change Rejection....
Read more 6
3rd MCR1183 010 Cust Agreement Validation 6
4th MCR1167 Public Lighting Proposal 6
5th MCR1154 New Un-metered Tariff for NI 4
6th MCR 0175 Email Address Validation.... Read more 2
7th MCR 0069 Irish language character set.... Read more 2
8th MCR 0073
Proposal to make first name mandatory on market
messages. 1
9th MCR 1114
Post-Harmonisation Sundry Technical Changes to HBL
Schema. 1
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 8 of 15 Schema 2017 Prioritisation Results
ROI BOTH ROI Roi ROI BOTH ROI BOTH BOTH ROI Both
MCR1173 Vulnerable Customer Changes 6 2 6 7 7 6 0 7 7 0 6 4.91 2 54 8 1
MCR1167 Public Lighting Proposal 5 7 5 6 0 1 0 6 6 0 5 3.73 4 41 7 3
MCR 1114
Post-Harmonisation Sundry Technical Changes to HBL
Schema. 4 3 3 5 2 5 0 3 1 0 3 2.64 6 29 2 5
MCR 0176 Email Address Validation.... Read more 3 4 7 4 4 4 0 4 4 6 4 4.00 3 44 2 4
MCR 0175
New Reject Reasons for Address Change Rejection....
Read more 7 6 4 3 6 7 0 5 5 7 7 5.18 1 57 8 2
MCR 0073
Proposal to make first name mandatory on market
messages. 2 5 2 2 3 3 0 2 3 0 0 2.00 7 22 1 7
MCR 0069 Irish language character set.... Read more 1 1 1 1 5 2 0 1 2 5 2 1.91 8 21 2 6
MCR Description MP3 MP4
Total
ScoreMP5 MP6 MP7
No of Top 3
RatingsMP12 Rank RankMP13
Avg
ScoreMP8 MP9 MP10 MP11
4.2 RoI Prioritisation
The overall RoI prioritisation scores are shown below.
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 9 of 15 Schema 2017 Prioritisation Results
Arithmetic Mean Metric
Position Title Score
1st MCR 0175
New Reject Reasons for Address Change Rejection.... Read
more 5.18
2nd MCR1173 Vulnerable Customer Changes 4.91
3rd MCR 0176 Email Address Validation.... Read more 4.00
4th MCR1167 Public Lighting Proposal 3.73
5th MCR 1114
Post-Harmonisation Sundry Technical Changes to HBL
Schema.... Read more 2.64
8th MCR 0073
Proposal to make first name mandatory on market
messages.... Read more 2.00
9th MCR 0069 Irish language character set.... Read more 1.91
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 10 of 15 Schema 2017 Prioritisation Results
MCR1183 010 Cust Agreement Validation 4 4 3 4 3 1 3 3.1 1 22 6 1
MCR1154 New Un-metered Tariff for NI 1 3 4 3 4 3 2 2.9 2 20 6 1
MCR 1114Post-Harmonisation Sundry Technical
Changes to HBL Schema.... Read more 3 1 1 2 1 2 1 1.6 4 11 3 2
MCR 0176 Email Address Validation.... Read more 2 2 2 1 2 4 4 2.4 3 17 6 1
MP7
MCR
Number Description MP1 MP2 MP3
No of
Top 3
Ratings Rank
Total
ScoreMP4 MP5 MP6
Avg
Score Rank
4.1 NI Prioritisation
The overall NI prioritisation scores are shown below.
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 11 of 15 Schema 2017 Prioritisation Results
Position Title Score
1st MCR 1183 010 Cust Agreement Validation 3.1
2nd MCR 1154 New Un-metered Tariff for NI 2.9
3rd MCR 0176 Email Address Validation.... Read more 2.4
4th MCR 1114 Post-Harmonisation Sundry Technical Changes to HBL Schema.... Read more1.6
Arithmetic Mean Metric
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 12 of 15 Schema 2017 Prioritisation Results
MCR1183 010 Cust Agreement Validation 8 9 6 1 5 5.8 4 29 2 3
MCR1173 Vulnerable Customer Changes 2 6 9 9 8 6.8 1 34 3 2
MCR1167Public Lighting Proposal 7 1 8 8 7 6.2 3 31 4 1
MCR1154New Un-metered Tariff for NI 9 8 7 5 4 6.6 2 33 3 2
MCR 1114 Post-Harmonisation Sundry Technical Changes to HBL Schema.... Read more3 5 3 2 3 3.2 6 16 1 4
MCR 0176 Email Address Validation.... Read more 4 4 4 6 6 4.8 5 24 2 3
MCR 0175New Reject Reasons for Address Change
Rejection.... Read more 6 7 5 7 9 6.8 1 34 3 2
MCR 0073Proposal to make first name mandatory on
market messages.... Read more 5 3 2 4 0 2.8 7 14 0 5
MCR 0069 Irish language character set.... Read more 1 2 1 3 2 1.8 8 9 0 5
Total
Score
No of
Top 3
RatingsMP2 MP3 MP4 RankMCR Number Description MP1 MP5
Avg
Score Rank
4.1 Results for MPs who operate in both markets
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 13 of 15 Schema 2017 Prioritisation Results
Arithmetic Mean Metric
Position Title Score
1st MCR1173 Vulnerable Customer Changes 6.8
2nd MCR 0175
New Reject Reasons for Address Change
Rejection.... Read more 6.8
3rd MCR1154 New Un-metered Tariff for NI 6.6
4th MCR1167 Public Lighting Proposal 6.2
5th MCR1183 010 Cust Agreement Validation 5.8
6th MCR 0176 Email Address Validation.... Read more 4.8
7th MCR 1114
Post-Harmonisation Sundry Technical
Changes to HBL Schema.... Read more 3.2
8th MCR 0073
Proposal to make first name mandatory on
market messages.... Read more 2.8
9th MCR 0069 Irish language character set.... Read more 1.8
Top 3 Metric
Position Title Score
1st MCR 1167 Public Lighting Proposal 4
2nd MCR 1173 Vulnerable Customer Changes 3
3rd MCR 1154 New Un-metered Tariff for NI 3
4th MCR 0175
New Reject Reasons for Address Change
Rejection.... Read more 3
5th MCR 1183 010 Cust Agreement Validation 2
6th MCR 0176 Email Address Validation.... Read more 2
7th MCR 1114
Post-Harmonisation Sundry Technical
Changes to HBL Schema.... Read more 1
8th MCR 0073
Proposal to make first name mandatory on
market messages.... Read more 0
9th MCR 0069 Irish language character set.... Read more 0
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 14 of 15 Schema 2017 Prioritisation Results
5 Next Steps
Network Operator Review - ESBN / NIE Networks will each separately assess the prioritisation results as laid out in this document.
o ESBN / NIE Networks will assess in terms of:-
Market prioritisation lists (provided in this document).
Wider Co-ordinated and jurisdictional Retail Market Delivery plans (consider other work programmes, projects etc.)
Developmental synergies with the Non Schema prioritisation results for each jurisdiction.
Cost.
Technical complexity.
Resource requirements.
Timescale.
Compatibility with other system work .
Joint Network Operators Review (NIE Networks and ESB Networks) – NIE Networks and ESBN will meet together to review the results from each jurisdiction.
o Fair and equitable distribution of delivered MCRs/functionality for both jurisdictions will underpin discussion.
Following the Joint Network Operators review, ESBN / NIE Networks will provide ReMCoDS with the following:-
o A proposed single Schema Package and
o A proposed delivery schedule (cut over date/s)
The proposed package will be communicated to Market Participants for review, revision and approval. This will take place at a ReMCoWG forum.
CER/UR to approve the final Schema 2017 package contents and delivery schedule dates.
The above can be summarised in the following overleaf:-
Retail Markets Co-Ordination Design Service
Version : 1.0 Page 15 of 15 Schema 2017 Prioritisation Results
Activity Role Action Date
Rank each of the changes
1-9 with 1 being your top
priority and 1 your least
important
MPs Return to ReMCoDS by 30/11/2016
Consolidate and formulate
Co-ordinated Market
prioritised list.
ReMCoDS Within ReMCoDS 16/12/2016
Determine any action
required to get prioritised
MCRs approved by year
end.
ReMCoDSFormulate plan &
communicate by11/01/2017
Communicate outcome of
Prioritisation exercise to
Market at WG
ReMCoDSPresent at WG and
issue email by11/01/2017
Provide ESBN/NIE Networks
list of prioritised MCRs for
impact assessment.
ReMCoDSIssue to ESBN/NIE
Networks19/01/2017
ESBN/NIE
Networks/ReMCoDS
suggest proposed package
of changes based on
prioritisation and
dependencies between
MCRs. Proposed delivery
dates of changes provided
ESBN/NIE
Networks/ReMCoDSIssue to ReMCoDS by TBD
ReMCoDS ReMCoDS
MPs MPs
Co-ordinated Market
Approval of Schema
Package and delivery Date
at Forum
MarketApproves at Forum Q1
2017TBD
CER/UR approve Schema
Package and delivery Date. CER/UR Approve Q1 2017 TBD
Proposed package with
delivery dates issued to
Market for review &
comment
TBD