{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Supporting Information","NectariAddinForExcelProperties","Party Details Form"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":1,"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":"Supporting Information","index":0,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[[6,1,9,14],[11,1,11,14],[12,1,21,14],[22,1,22,14],[23,1,29,14],[55,1,62,14],[31,1,31,14],[32,1,38,14],[39,1,39,14],[40,1,52,14],[54,1,54,14]]}
[]
[null,"EMR Party Registration and Amendment"]
[]
[]
[]
[]
[null,"The EMR Party Registration and Amendment form provides details of EMR Party to the Settlement Services Provider, EMR Settlement Ltd, to enable the provision of accurate calculations and charging. This page details what should be provided and how it is used to support settlement. Please note that this forms only covers Suppliers and Capacity Providers."]
[]
[]
[]
[]
[null,"Company Details"]
[null,"As a party involved in EMR Settlement, we require basic company details to identify the party with which we are liasing. This includes a Great Britain address to issue legal notices if the company is not primarily located in Great Britain.\n\nWe ask that parties identify a unique party code to avoid incorrect feeds of information. This is known as the EMR Party ID. For parties that have already acceded to the BSC, their BSC Party ID will become their EMR Party ID (and the EMR Party ID will become a party's BSC Party ID if they accede at a later point)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Backing Data"]
[null,"As part of our services, we provide invoices/credit notes and the supporting calculation data (backing data) to enable a party to validate their charges/payments. We have developed two ways of sharing backing data: via email or through the Data Transfer Network (DTN). If selected, emailed backing data will be sent to the company email addresses. If DTN is selected, we request that the EMR Party provides a single MPID on behalf of the party (as EMR only interacts at the party level)."]
[]
[]
[]
[]
[]
[]
[]
[null,"Financial Details"]
[null,"We have provided the space for two different bank accounts, allowing an EMR Party to separate payments from credit cover. By default we will use the Primary account details for all payments if no other details are supplied. IBAN and SWIFT/BIC are  required for international bank accounts but will be used to validate non-international accounts. As a minimum we require one account (specified in this form as 'Primary')."]
[]
[]
[]
[]
[]
[]
[null,"Contact Details"]
[null,"We request at least one central email/mailbox address for a party that will be sent invoices, notifications and backing data, if selected. In addition, we request contact details (email/telephone should be different for each) for three individuals as a minimum: a Primary Party Authority and two Financial Authorities in line with EMR authorisation requirements. Where these cannot be provided, please provide supporting rationale and indicate if the constraint is likely to change over time. An individual will only be able to hold one Authorised Role.  \n\nWhen adding a new person or amending an existing person please select the appropriate authorisation role. Deleting a person will set their role to Unauthorised Contact.\n\nFurther information can be found in the EMR Authorisations guidance available on the EMRS website."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Recorded by"]
[null,"To ensure that the details in this form are accurate, we request that this form is returned using PDF and signed (electronic signatures are acceptable but must be date stamped and within the signature, have the name of the person and the email address N.B. this is standard functionality within Adobe Acrobat) by a Primary Party Authority, who should be a Company Director/Company Secretary and the completed spreadsheet should be returned from their email address to contact@emrsettlement.co.uk.\n\nWhere Financial Details are being amended please return via a dual-signed request on letter headed paper."]

{"sheet":"NectariAddinForExcelProperties","index":1,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["0","CatalogNickname","EnvironmentKey","ReferenceName","DimensionsForGroupBy","DrillDownProfiles"]

{"sheet":"Party Details Form","index":2,"n_rows":90,"n_cols":22,"rows_kept":90,"cut":false,"hidden":false,"merged":[[72,9,72,12],[73,9,73,12],[67,9,67,12],[68,9,68,12],[69,9,69,12],[70,9,70,12],[71,9,71,12],[63,7,63,8],[64,9,64,12],[63,9,63,12],[65,9,65,12],[66,9,66,12],[64,7,64,8],[65,7,65,8],[66,7,66,8],[69,7,69,8],[70,7,70,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[67,7,67,8],[68,7,68,8],[77,1,78,15],[4,1,4,11],[1,1,1,11],[11,5,11,8],[12,5,12,8],[10,11,10,14],[11,11,11,14],[12,11,12,14],[6,4,6,5],[10,2,10,4],[11,2,11,4],[12,2,12,4],[10,5,10,8],[13,11,13,14],[14,11,14,14],[15,11,15,14],[48,4,48,6],[32,5,32,6],[16,2,16,4],[16,5,16,8],[44,10,44,12],[45,10,45,12],[46,10,46,12],[47,10,47,12],[48,10,48,12],[16,11,16,14],[17,11,17,14],[44,4,44,6],[45,4,45,6],[24,5,26,8],[14,2,14,4],[15,2,15,4],[31,7,31,8],[28,5,28,6],[28,7,28,8],[18,5,18,6],[19,5,19,6],[18,7,19,7],[29,5,29,8],[89,2,90,2],[83,8,84,8],[85,8,86,8],[87,8,88,8],[89,8,90,8],[83,2,84,2],[79,1,79,15],[85,2,86,2],[87,2,88,2],[46,4,46,6],[47,4,47,6],[81,1,82,15],[52,4,52,6],[53,4,53,6],[54,4,54,6],[55,4,55,6],[56,4,56,6],[52,10,52,12],[53,10,53,12],[54,10,54,12],[55,10,55,12],[56,10,56,12]]}
[]
[null,"EMR Party Registration and Amendment Form"]
[]
[]
[null,"For full usability, please view and complete this in Excel. For certain information, further detail can be found via the question marks. Alternatively please see the 'supporting information' page for further details on the requested information. Coloured boxes indicate mandatory fields."]
[]
[null,null,"Form Type",null,"Please select from list",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BSC/EMR",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incoming International",false]
[null,null,"Company Details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Credit Cover International",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Same as incoming",false]
[null,null,"Company Name",null,null,null,null,null,null,"?","Address",null,null,null,null,"?",null,null,null,null,null,false]
[null,null,"Company registration number",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"EMR Party Type",null,null,"Please select from the list",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,null,"Do you have a BSC ID or EMR Party ID already?"]
[null,null,"If yes please enter it in the box below, if not then please suggest one"]
[null,null,{"$f":"IF(AND(E7=\"New Registration\",V7=TRUE),\"EMR Party ID\",IF(OR(E7=\"Amendment\",V7=TRUE),\"EMR Party ID\",\"Suggested EMR Party ID\"))","v":"Suggested EMR Party ID"},null,null,null,null,null,null,"?","Postcode"]
[null,null,null,null,null,null,null,null,null,null,"Country"]
[null,null,"CFD ID",null,null,null,null,"Only required for CFD Generator"]
[null,null,"CFD Contract Signature Date"]
[]
[]
[null,null,"Settlement Information"]
[]
[null,null,"Primary company email (maximum 6)",null,null,null,null,null,null,"?"]
[]
[]
[]
[null,null,"Accounts Payable email",null,null,null,null,null,null,"?"]
[null,null,"Telephone"]
[]
[null,null,"Channel for backing data",null,null,"Please select from list",null,{"$f":"IF(F32=\"Please select from list\",\"\",IF(F32=\"DTN\",\"Please enter MPID\",\"All backing data will be sent to Company Email(s) specified\"))","v":""},null,"?"]
[null,null,"Market Participant ID (MPID)",null,null,null,null,null,null,"?"]
[]
[null,null,"Channel for CMVRN Notifications / Notification of loading of self-submitted Metered Data",null,null,"Please select from list",null,null,null,"?","?"]
[]
[]
[]
[null,null,"Financial details"]
[]
[null,null,"Primary bank account",null,null,null,null,"?","Credit Cover return account"]
[null,null,null,null,null,null,null,null,"Same as Primary?"]
[]
[null,null,"International Account?",null,null,null,null,null,"International Account?"]
[null,null,"Bank Name",null,null,null,null,"?","Bank Name",null,null,null,null,"?"]
[null,null,"Account Number",null,null,null,null,null,"Account Number"]
[null,null,"Sort Code",null,null,null,null,null,"Sort Code"]
[null,null,"IBAN",null,null,null,null,"?","IBAN",null,null,null,null,"?"]
[null,null,"SWIFT BIC",null,null,null,null,"?","SWIFT BIC",null,null,null,null,"?"]
[]
[null,null,"Existing Bank Details (please complete if making an amendment to Financial Details"]
[]
[null,null,"Bank Name",null,null,null,null,null,"Bank Name"]
[null,null,"Account Number",null,null,null,null,null,"Account Number"]
[null,null,"Sort Code",null,null,null,null,null,"Sort Code"]
[null,null,"IBAN",null,null,null,null,null,"IBAN"]
[null,null,"SWIFT BIC",null,null,null,null,null,"SWIFT BIC"]
[]
[]
[]
[null,null,"Contact details"]
[null,null,"Please see G4 - EMR Settlement Authorisations for privileges afforded to each role"]
[null,null,"As a minimum, we require one primary party authority, and 2 finance authorities."]
[null,null,"Action","First Name","Last Name","Job title","Telephone","Email",null,"Authorisation Role"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[null,null,"Please select from list"]
[]
[]
[]
[null,"Please sign this form by either printing it or by using an electronic signature (see Supporting Information for guidance) and then return to contact@emrsettlement.co.uk in PDF format. In both cases please return an excel version of the form."]
[]
[null,"By signing below you are confirming that all sections are complete and correct to your knowledge"]
[]
[null,"Recorded by (Please ensure this is a person listed on the Companies House website. If amending details it should be signed by a Primary Party Authority, Finance Authority or Operating Authority. Where bank details are being amended two authorised signatories, Primary Party Authority or Finance Authority, are required.):"]
[]
[null,null,"Name:",null,null,null,null,null,"Name:"]
[]
[null,null,"Position:",null,null,null,null,null,"Position:"]
[]
[null,null,"Signature:",null,null,null,null,null,"Signature:"]
[]
[null,null,"Date:",null,null,null,null,null,"Date:"]