{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MA Template Guidance","MA Template","Change Log","Data List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"MA Template Guidance","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,2,17,5],[4,2,4,4],[5,2,5,5],[6,2,6,5],[7,2,7,5],[10,2,10,6],[16,3,16,5]]}
[]
[]
[null,null,"Template Completions Notes - MA - v0.6 - 05/04/2019"]
[]
[]
[null,null,"1) 'This document is a template document for filling in the Migration Authorisation by Responsible Supplier .  \n"]
[]
[null,null,"Headings to be completed by Energy Suppliers:\n1. EUI-64 Number - User ID\n2.  CommissionedByDCC - Yes or NO\n3. SMSO Identifier from the below list. CSV picks up the 3 character value \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"]
[]
[null,null,"Body to be completed by Energy Suppliers:"]
[null,null," - Enter 'MPAN' and 'MPRN' where available\n - Enter 'Migrate on' or 'Migration Week' (must be Monday) date in DD/MM/YYYY format. CSV picks up in YYYYMMDD format.\n- Enter Priority  - Mark as Y (upper case) to indicate priority\n- Enter Certificates - Provide SMKI Organisation Certificate Serial Numbers in decimal(Integer) format."]
[]
[]
[]
[]
[null,null,"Further Guidance and Support"]
[null,null,"- Further information on Migration Authorisation  can be found on Migration Authorisation Mechanism document."]
[null,null,"- Please send any questions to enrolment.adoption@smartdcc.co.uk\n"]
[]
[]
[]
[null,"DCC Public"]

{"sheet":"MA Template","index":1,"n_rows":12,"n_cols":27,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,25,10,26],[9,7,9,14],[9,15,9,22],[9,23,9,26],[5,1,5,26],[10,7,10,8],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,6],[10,9,10,10],[10,11,10,12],[10,13,10,14],[10,15,10,16],[10,17,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24]]}
[]
[]
[]
[]
[null,"SMETS1 Migration Authorisation",null,null,null,null,null,null,"DCC Public"]
[]
[]
[null,"User ID (EUI-64):*"]
[null,"Commissioned by DCC:*"]
[null,"SMSO:*",null,null,null,null,null,"ESME",null,null,null,null,null,null,null,"GPF",null,null,null,null,null,null,null,"GSME"]
[null,null,"MPAN*\n(upto 13 char)","MPRN*\n(upto 10 char)","Migrate on\n(DD/MM/YYYY)","Migration Week *\n( Monday)\n","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,null,null,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":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Version","Change Log"]
[]
[0.1,"2018-11-07","1st draft"]
[0.2,"2018-12-03","Updated with Certificate in Integer format"]
[0.3,"2018-12-06","Update with Macro to create CSV to send Certificates/Priority"]
[0.4,"2018-12-06","Updated Macro"]
[0.5,"2018-12-19","Included Issuer name"]
[0.6,"2019-04-05","Updated following consultation review comment"]
["0.6a","2020-01-06","Code updated to ensure SMSO codes are populated correctly in the filename of the resultant MA , ensuring that SMSO codes match what is contained in MIS, correcting error that occurred when a single fuel site was entered and ensured that three letter SMSO code was in the resultant MA file created."]
[]
["DCC Public"]

{"sheet":"Data List","index":3,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["SMSOs"]
["British Gas"]
["CGI"]
["EDMI"]
["Morrison Data Services"]
["Npower"]
["Secure Meters"]
["Trilliant"]
[]
["CommissionedbyDCC"]
["YES"]
["NO"]