{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DM MG Sch Guide","DM MG Sch","Change Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DM MG Sch Guide","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,3,16,5],[17,2,17,5],[4,2,4,4],[5,2,5,5],[6,2,6,5],[7,2,7,5],[10,2,10,6]]}
[]
[]
[null,null,"Template Completions Notes - DMMSN - v0.5 -05/04/2019"]
[]
[]
[null,null,"1) 'This document is a template document for filling in the Schedule for Dormant Meter Migration by DCC Migration Control Centre (MCC) Team.  \n2) 'This document is a template document for filling in the SMKI Organisation Certificate Serial Numbers and /or Priority for the Meter Points mentioned on this schedule by Energy Supplier parties.\n"]
[]
[null,null,"Headings to be completed by DCC MCC Team:\n'SMSO Identifier - 3- character Identifier of SMSO.  E.g., \n       BTG - British Gas\n       CGI –  Instant Energy\n       EDM –  EDMI\n       MDS – Morrison Data Services\n       NPW – NPower\n       SCM – Secure Meters\n       TRL – Trilliant\n'Market Participant ID  - 3 or 4 character short code for Energy Participant"]
[]
[null,null,"Body to be completed by DCC MCC Team:"]
[null,null," - Enter 'MPAN' and 'MPRN' where available\n - Enter 'Not before' and 'Not after' date in DD/MM/YYYY format\n - Enter Device Serial #, Device Ids for all the Devices in that Installation (as applicable).\n - Above data can be collected from SMSO Report and Industry Registration Data."]
[null,null,"Headings to be completed by Energy Suppliers:\nEUI-64 Number - User ID"]
[]
[null,null,"Body to be completed by Energy Suppliers:\nPriority  - Mark as Y (upper case) to indicate priority\nCertificates - Provide SMKI Organisation Certificate Serial Numbers (in integer format) and Issuer Name."]
[]
[null,null,"Further Guidance and Support"]
[null,null,"- Further information on Dormant Meter Migration Schedule and Response  can be found on Migration Authorisation Mechanism document."]
[null,null,"- Please send any questions to enrolment.adoption@smartdcc.co.uk\n"]

{"sheet":"DM MG Sch","index":1,"n_rows":15,"n_cols":39,"rows_kept":15,"cut":false,"hidden":false,"merged":[[5,1,5,38],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,6,13,12],[13,13,13,17],[13,18,14,18],[13,4,13,5],[12,19,12,26],[13,19,13,20],[13,21,13,22],[12,35,12,38],[13,35,13,36],[13,37,13,38],[13,23,13,24],[13,25,13,26],[11,1,11,17],[11,18,11,38],[12,27,12,34],[13,27,13,28],[13,29,13,30],[13,31,13,32],[13,33,13,34]]}
[]
[]
[]
[]
[null,"SMETS1 Dormant Meter Migration Schedule"]
[]
[]
[null,"Name"]
[null,"SEC Party Signifier"]
[null,"Market Participant Identifier"]
[null,"SMSO:*"]
[null,"Populated by DCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Populated by Supplier"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESME",null,null,null,null,null,null,null,"GPF",null,null,null,null,null,null,null,"GSME"]
[null,"Sr. #","MPAN\n(up to 13 char)","MPRN\n(up to 10 char)","Scheduled to Migrate",null,"Device ID (GUID)",null,null,null,null,null,null,"Serial Numbers",null,null,null,null,"Priority (Y)","Supplier Certificate ID*\n(Critical - Digital Signature)",null,"Supplier Certificate ID*\n(Non-Critical - Key Agreement)",null,"Network Operator Certificate ID \n(Critical - Digital Signature)",null,"Network Operator Certificate ID \n(Non-Critical - Key Agreement)",null,"Supplier Certificate ID*\n(Critical - Digital Signature)",null,"Supplier Certificate ID*\n(Non-Critical - Key Agreement)",null,"Network Operator Certificate ID \n(Critical - Digital Signature)",null,"Network Operator Certificate ID \n(Non-Critical - Key Agreement)",null,"Supplier Certificate ID*\n(Critical - Digital Signature)",null,"Supplier Certificate ID*\n(Non-Critical - Key Agreement)"]
[null,null,null,null,"Not before","Not after","CHF","GPF","ESME","GSME","IHD","PPMID","CAD","CHF","ESME","GSME","IHD","PPMID",null,"Serial Number","Issuer Name","Serial Number","Issuer Name","Serial Number","Issuer Name","Serial Number","Issuer Name","Serial Number","Issuer Name","Serial Number","Issuer Name","Serial Number","Issuer Name","Serial Number","Issuer Name","Serial Number","Issuer Name","Serial Number","Issuer Name"]

{"sheet":"Change Log","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Version","Change Log"]
[]
[0.1,"2018-11-07","1st draft"]
[0.2,"2018-12-03","Updated with Device ID and Serial Numbers"]
[0.3,"2018-12-06","Update with Macro to create CSV to send Certificates/Priority"]
[0.4,"2018-12-20","Added Issuer Name"]
[0.5,"2019-04-05","Replaced User ID with Supplier Name"]
[0.6,"2020-05-18","VBA updated to create unique filename"]