{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dataset Information","Data Sharing Assessment","Hidden"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"comments":2,"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":"Dataset Information","index":0,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,2,6,4],[32,0,32,1],[32,2,32,4],[31,0,31,1],[18,0,18,1],[27,0,29,0],[25,0,25,1],[10,0,10,1],[11,0,11,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[12,0,12,1],[16,0,16,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[15,2,15,4],[16,2,16,4],[31,2,31,4],[18,2,18,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[13,2,13,4],[14,2,14,4],[12,2,12,4]]}
[]
[]
[]
[]
[]
[]
[null,null,"Data Sharing Assessment"]
[]
[]
[null,null,"Insert information in boxes below"]
["Dataset name:",null,"Common Information Model South Wales"]
["Dataset representation:",null,"CIM"]
["Openness Result:",null,"Open"]
["Assessment completed by:",null,"Howard Thomas"]
["Date DSA completed:",null,"2024-01-05"]
["Approved for sharing by:",null,"Phil Lawson"]
["Date of approval:",null,"2024-01-08"]
[]
["Form Completeness",null,{"$f":"'Data Sharing Assessment'!O3","v":"Complete"}]
[]
[null,null,{"$f":"'Data Sharing Assessment'!F2","v":"Initial Risk"},"Mitigation",{"$f":"'Data Sharing Assessment'!K2","v":"Residual Risk"}]
[{"$f":"'Data Sharing Assessment'!B4","v":"Privacy"},null,{"$f":"IF('Data Sharing Assessment'!L5=1,'Data Sharing Assessment'!F5,\"\")","v":"Green"},{"$f":"IF(AND(LEN(C22)>0,C22<>\"Green\"),'Data Sharing Assessment'!J5,\"\")","v":""},{"$f":"IF('Data Sharing Assessment'!L5=1,'Data Sharing Assessment'!K5,\"\")","v":"Green"}]
[{"$f":"'Data Sharing Assessment'!B6","v":"Security"},null,{"$f":"IF('Data Sharing Assessment'!L7=1,'Data Sharing Assessment'!F7,\"\")","v":"Green"},{"$f":"IF(AND(LEN(C23)>0,C23<>\"Green\"),'Data Sharing Assessment'!J7,\"\")","v":""},{"$f":"IF('Data Sharing Assessment'!L7=1,'Data Sharing Assessment'!K7,\"\")","v":"Green"}]
[{"$f":"'Data Sharing Assessment'!B8","v":"Commercial"},null,{"$f":"IF('Data Sharing Assessment'!L9=1,'Data Sharing Assessment'!F9,\"\")","v":"Green"},{"$f":"IF(AND(LEN(C24)>0,C24<>\"Green\"),'Data Sharing Assessment'!J9,\"\")","v":""},{"$f":"IF('Data Sharing Assessment'!L9=1,'Data Sharing Assessment'!K9,\"\")","v":"Green"}]
[{"$f":"'Data Sharing Assessment'!B10","v":"Negative Consumer Impact"},null,{"$f":"IF('Data Sharing Assessment'!L11=1,'Data Sharing Assessment'!F11,\"\")","v":"Green"},{"$f":"IF(AND(LEN(C25)>0,C25<>\"Green\"),'Data Sharing Assessment'!J11,\"\")","v":""},{"$f":"IF('Data Sharing Assessment'!L11=1,'Data Sharing Assessment'!K11,\"\")","v":"Green"}]
[{"$f":"'Data Sharing Assessment'!B12","v":"Other"},null,{"$f":"IF('Data Sharing Assessment'!L13=1,'Data Sharing Assessment'!F13,\"\")","v":"Green"},{"$f":"IF(AND(LEN(C26)>0,C26<>\"Green\"),'Data Sharing Assessment'!J13,\"\")","v":""},{"$f":"IF('Data Sharing Assessment'!L13=1,'Data Sharing Assessment'!K13,\"\")","v":"Green"}]
[]
["Summary","Green",{"$f":"IF(C19=\"Complete\",'Data Sharing Assessment'!P4,\"\")","v":1}]
[null,"Amber",{"$f":"IF(C19=\"Complete\",'Data Sharing Assessment'!Q4,\"\")","v":0}]
[null,"Red",{"$f":"IF(C19=\"Complete\",'Data Sharing Assessment'!R4,\"\")","v":0}]
[]
["Openness Recommendation",null,{"$f":"IF(C19=\"Complete\",IF('Data Sharing Assessment'!$M$3=9,IF(C28>=Hidden!$B$58,IF(E22=\"Green\",Hidden!$C$58,Hidden!$C$59),IF(C28>=Hidden!$B$60,IF(E22=\"Green\",Hidden!$C$60,Hidden!$C$61),Hidden!C62)),\nVLOOKUP('Data Sharing Assessment'!$M$3,Hidden!$B$52:$C$55,2,FALSE)),\"\")","v":"Open"}]
["Recommendation Notes",null,{"$f":"IF(C19=\"Complete\",IF('Data Sharing Assessment'!$M$3=9,IF(C28>=Hidden!$B$58,IF(E22=\"Green\",Hidden!$D$58,Hidden!$D$59),IF(C28>=Hidden!$B$60,IF(E22=\"Green\",Hidden!$D$60,Hidden!$D$61),Hidden!D62)),\n\"\"),\"\")","v":""}]

{"sheet":"Data Sharing Assessment","index":1,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,15,1,17],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[3,1,3,10],[5,1,5,10],[7,1,7,10],[9,1,9,10],[11,1,11,10],[15,2,15,3]]}
[]
[null,"#","Question","Guidance","Response","Initial Risk","Decision Tool Response","Guidance","Supporting Information and Notes","Mitigation Category","Residual Risk","Complete","Openness",null,"Form Completeness","Output"]
[null,0,"Does NGED own or have a legal right to publish the data?","Has NGED (or a contracted third party) has generated or collected the data?\n\nIn some cases where data has been shared with NGED by the data owner, there may be rights (via data licencing) or obligations (e.g. Environmental Information Regulations or DCUSA Embedded Capacity Registers) which provide legal grounds for publication of the dataset or derived dataset. Where a dataset combines owned and shared data this should be recorded as shared data.","Yes: Data Owner","Green",{"$f":"VLOOKUP(E3,Hidden!$B$11:$E$15,2,FALSE)","v":"Complete initial and residual risk assessment and proceed to next check"},{"$f":"VLOOKUP($E3,Hidden!$B$11:$E$15,3,FALSE)","v":""},"NGED owned data of it assets on its network and connectivity. No external datasources supplimented within the CIM model. CIM is part of IEC 61970 energy management standards.",null,"Green",{"$f":"IF(AND(E3=Hidden!B12,F3<>Hidden!$B$45,K3<>Hidden!$B$45),1,\nIF(AND(OR(E3=Hidden!$B$13,E3=Hidden!$B$14),I3<>\"\",F3<>Hidden!$B$45,K3<>Hidden!$B$45),1,0))","v":1},{"$f":"MAX('Data Sharing Assessment'!M5,'Data Sharing Assessment'!M7,'Data Sharing Assessment'!M9,'Data Sharing Assessment'!M11,'Data Sharing Assessment'!M13)","v":1},null,{"$f":"IF(SUM(L3:L14)/7=1,\"Complete\",SUM(L3:L14)/7)","v":"Complete"},"Green","Amber","Red"]
[null,"Privacy",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($O$3=\"Complete\",COUNTIF(K:K,P3)/7,0)","v":1},{"$f":"IF($O$3=\"Complete\",COUNTIF(K:K,Q3)/7,0)","v":0},{"$f":"IF($O$3=\"Complete\",COUNTIF(K:K,R3)/7,0)","v":0}]
[null,1,"Does the dataset contain personal data?","Consider if sharing this dataset infringes the General Data Protection Regulation (the GDPR) or the Data Protection Act 2018. [1]'\n\nNote: Additional guidance is given in LE5 - Data Protection Policy","No","Green",{"$f":"VLOOKUP('Data Sharing Assessment'!E5,Hidden!$B$4:$D$7,2,FALSE)","v":"Complete initial and residual risk assessment and proceed to next check"},{"$f":"IF(AND(NOT(OR(J5=\"Click Here\",J5=Hidden!$C$41)),E5=Hidden!$B$28),Hidden!$C$29,IF(J5=Hidden!$C$41,Hidden!$C$30,VLOOKUP(E5,Hidden!$B$25:$L$28,'Data Sharing Assessment'!B5+1,FALSE)))","v":""},"No, data owned by NGED.","Click Here","Green",{"$f":"IF(OR(AND(E5=Hidden!$B$5,F5<>Hidden!$B$45,K5<>Hidden!$B$45),\nAND(E5=Hidden!$B$6,I5<>\"\",F5<>Hidden!$B$45,K5<>Hidden!$B$45,NOT(J5=Hidden!$C$34)),\nAND(E5=Hidden!$B$7,I5<>\"\",F5<>Hidden!$B$45,K5<>Hidden!$B$45,NOT(J5=Hidden!$C$34))),1,0)","v":1},{"$f":"IF(OR(K5=\"Red\",J5=Hidden!$C$41),4,\nIF(J5=Hidden!$C$40,3,\nIF(J5=Hidden!$C$39,2,\nIF(K5=\"Green\",1,9))))","v":1}]
[null,"Security"]
[null,2,"Does this dataset contain information that creates an incremental security risk or exasperate an existing risk?","Consider if the dataset contains information that is not already public by another source. e.g. existing NGED reports, third party datasets (e.g. satellite imagery), etc. If an alternative source exists then consider if the NGED dataset contains more detailed data (granularity, latency, accuracy, etc.). \n\nWhere the dataset contains novel information, it should be assessed for new security issues such as: security of supply (Distribution Code - Engineering Recommendation P2), security of assets, security of people, etc. Where the dataset replicates or extends existing public datasets, consideration should be given to the incremental risk publication would create. For example, does the increased granularity of data create more risk?","No","Green",{"$f":"VLOOKUP('Data Sharing Assessment'!E7,Hidden!$B$4:$D$7,2,FALSE)","v":"Complete initial and residual risk assessment and proceed to next check"},{"$f":"IF(AND(NOT(OR(J7=\"Click Here\",J7=Hidden!$C$41)),E7=Hidden!$B$28),Hidden!$C$29,IF(J7=Hidden!$C$41,Hidden!$C$30,VLOOKUP(E7,Hidden!$B$25:$L$28,'Data Sharing Assessment'!B7+1,FALSE)))","v":""},null,"Click Here","Green",{"$f":"IF(OR(AND(E7=Hidden!$B$5,F7<>Hidden!$B$45,K7<>Hidden!$B$45),\nAND(E7=Hidden!$B$6,I7<>\"\",F7<>Hidden!$B$45,K7<>Hidden!$B$45,NOT(J7=Hidden!$C$34)),\nAND(E7=Hidden!$B$7,I7<>\"\",F7<>Hidden!$B$45,K7<>Hidden!$B$45,NOT(J7=Hidden!$C$34))),1,0)","v":1},{"$f":"IF(OR(K7=\"Red\",J7=Hidden!$C$41),4,\nIF(J7=Hidden!$C$40,3,\nIF(J7=Hidden!$C$39,2,\nIF(K7=\"Green\",1,9))))","v":1}]
[null,"Commercial"]
[null,3,"Does the dataset contain information that could damage the commercial interests of the company?","Data Best Practice Guidance described commercial information as \"Data that relates to the private administration of a business or data which was not collected as part of an obligation / by a regulated monopoly and would not have been originated or captured without the activity of the organisation\".\n\nCommercial issues could also arise due to prior data licencing which would preclude sharing the same data under different terms (e.g. exclusivity agreement, confidentiality agreement), data which is (or could be interpreted as) inconsistent with regulatory reporting or could be seen as exploiting NGED's licenced role (e.g. could undermine the Competition Act 1998 [3], Enterprise Act 2002 [4] or Enterprise and Regulatory Reform Act 2013 [5])","No","Green",{"$f":"VLOOKUP('Data Sharing Assessment'!E9,Hidden!$B$4:$D$7,2,FALSE)","v":"Complete initial and residual risk assessment and proceed to next check"},{"$f":"IF(AND(NOT(OR(J9=\"Click Here\",J9=Hidden!$C$41)),E9=Hidden!$B$28),Hidden!$C$29,IF(J9=Hidden!$C$41,Hidden!$C$30,VLOOKUP(E9,Hidden!$B$25:$L$28,'Data Sharing Assessment'!B9+1,FALSE)))","v":""},"OFGEM set requirements to publish CIM models for the Primary network, as part of \"Presumed Open Data\" initiative. CIM models are a requirement for LTDS publishing from 2024 onwards.","Click Here","Green",{"$f":"IF(OR(AND(E9=Hidden!$B$5,F9<>Hidden!$B$45,K9<>Hidden!$B$45),\nAND(E9=Hidden!$B$6,I9<>\"\",F9<>Hidden!$B$45,K9<>Hidden!$B$45,NOT(J9=Hidden!$C$34)),\nAND(E9=Hidden!$B$7,I9<>\"\",F9<>Hidden!$B$45,K9<>Hidden!$B$45,NOT(J9=Hidden!$C$34))),1,0)","v":1},{"$f":"IF(OR(K9=\"Red\",J9=Hidden!$C$41),4,\nIF(J9=Hidden!$C$40,3,\nIF(J9=Hidden!$C$39,2,\nIF(K9=\"Green\",1,9))))","v":1}]
[null,"Negative Consumer Impact"]
[null,4,"Would sharing this dataset result in a negative impact on consumers?","Consider if access to this data is likely to drive actions, intentional or otherwise, which will negatively impact the consumer. \n\nFor example, data about procurement assessment processes could drive up prices for products or services which increase costs for consumers.","No","Green",{"$f":"VLOOKUP('Data Sharing Assessment'!E11,Hidden!$B$4:$D$7,2,FALSE)","v":"Complete initial and residual risk assessment and proceed to next check"},{"$f":"IF(AND(NOT(OR(J11=\"Click Here\",J11=Hidden!$C$41)),E11=Hidden!$B$28),Hidden!$C$29,IF(J11=Hidden!$C$41,Hidden!$C$30,VLOOKUP(E11,Hidden!$B$25:$L$28,'Data Sharing Assessment'!B11+1,FALSE)))","v":""},null,"Click Here","Green",{"$f":"IF(OR(AND(E11=Hidden!$B$5,F11<>Hidden!$B$45,K11<>Hidden!$B$45),\nAND(E11=Hidden!$B$6,I11<>\"\",F11<>Hidden!$B$45,K11<>Hidden!$B$45,NOT(J11=Hidden!$C$34)),\nAND(E11=Hidden!$B$7,I11<>\"\",F11<>Hidden!$B$45,K11<>Hidden!$B$45,NOT(J11=Hidden!$C$34))),1,0)","v":1},{"$f":"IF(OR(K11=\"Red\",J11=Hidden!$C$41),4,\nIF(J11=Hidden!$C$40,3,\nIF(J11=Hidden!$C$39,2,\nIF(K11=\"Green\",1,9))))","v":1}]
[null,"Other"]
[null,5,"Are there any other concerns associated with sharing this dataset not covered above?","If there are any other issues that require mitigation before publishing your dataset that haven't been addressed by the questions above, please clearly state the reason(s) in the 'Supporting information' cell.\n\nFor example, specific legislative or regulatory barriers.","No","Green",{"$f":"VLOOKUP('Data Sharing Assessment'!E13,Hidden!$B$4:$D$7,2,FALSE)","v":"Complete initial and residual risk assessment and proceed to next check"},{"$f":"IF(AND(NOT(OR(J13=\"Click Here\",J13=Hidden!$C$41)),E13=Hidden!$B$28),Hidden!$C$29,IF(J13=Hidden!$C$41,Hidden!$C$30,VLOOKUP(E13,Hidden!$B$25:$L$28,'Data Sharing Assessment'!B13+1,FALSE)))","v":""},null,"Click Here","Green",{"$f":"IF(OR(AND(E13=Hidden!$B$5,F13<>Hidden!$B$45,K13<>Hidden!$B$45),\nAND(E13=Hidden!$B$6,I13<>\"\",F13<>Hidden!$B$45,K13<>Hidden!$B$45,NOT(J13=Hidden!$C$34)),\nAND(E13=Hidden!$B$7,I13<>\"\",F13<>Hidden!$B$45,K13<>Hidden!$B$45,NOT(J13=Hidden!$C$34))),1,0)","v":1},{"$f":"IF(OR(K13=\"Red\",J13=Hidden!$C$41),4,\nIF(J13=Hidden!$C$40,3,\nIF(J13=Hidden!$C$39,2,\nIF(K13=\"Green\",1,9))))","v":1}]
[null,6,"Is a dataset quality caveat required for end users?","Data quality is subjective. A dataset may be perfectly acceptable for one use case but entirely inadequate for another. Data accuracy can be more objective but there remain many instances where the required precision differs across use cases. Data quality should not be seen as a reason for not sharing as potential users may find the quality acceptable for their use, find ways to handle the quality issues or develop ways to solve issues which can improve the quality of the underlying data. \n\nHowever, known limitations (quality or accuracy) should be clearly documented and where there are uncertainties a robust quality disclaimer should be used.","No","Green",{"$f":"VLOOKUP('Data Sharing Assessment'!E14,Hidden!$B$4:$D$7,2,FALSE)","v":"Complete initial and residual risk assessment and proceed to next check"},{"$f":"IF(AND(NOT(OR(J14=\"Click Here\",J14=Hidden!$C$41)),E14=Hidden!$B$28),Hidden!$C$29,IF(J14=Hidden!$C$41,Hidden!$C$30,VLOOKUP(E14,Hidden!$B$25:$L$28,'Data Sharing Assessment'!B14+1,FALSE)))","v":""},"CIM Datasets built to best quality of the current model.","Click Here","Green",{"$f":"IF(OR(AND(E14=Hidden!$B$5,F14<>Hidden!$B$45,K14<>Hidden!$B$45),\nAND(E14=Hidden!$B$6,I14<>\"\",F14<>Hidden!$B$45,K14<>Hidden!$B$45,NOT(J14=Hidden!$C$34)),\nAND(E14=Hidden!$B$7,I14<>\"\",F14<>Hidden!$B$45,K14<>Hidden!$B$45,NOT(J14=Hidden!$C$34))),1,0)","v":1}]
[]
[null,"[1]","Data Protection Act 2018"]
[null,"[2]","ICO Guidance"]
[null,"[3]","Competition Act 1998"]
[null,"[4]","Enterprise Act 2002"]
[null,"[5]","Enterprise and Regulatory Reform Act 2013"]

{"sheet":"Hidden","index":2,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":true,"merged":[[8,1,8,4]]}
[]
[]
[null,"Response","Decision Tool Response","Guidance"]
[null,"Click here","","",null,null,null,"-","No","No","No"]
[null,"No","Complete initial and residual risk assessment and proceed to next check","",null,null,null,null,null,"Yes but suitably mitigated","Yes but suitably mitigated"]
[null,"Yes but mitigation in place","Capture evidence and reason for mitigation in the 'Supporting Information' column and proceed to next check.","",null,null,null,null,null,null,"No mitigation available"]
[null,"Yes mitigation required","Undertake mitigation assessment using the guidance provided. If mitigation is not possible, capture the reason in the 'Supporting Information' column.","Evaluate if the dataset still has significant value through either data redaction or the anonymisation of data.\n\nConsider whether to seek consent from the named individuals to share the data"]
[]
[null,"List of responses (question 0)",null,null,null,null,null,"Yes but mitigation in place","No"]
[null,"Response","Decision Tool Response","Guidance"]
[null,"Click here","",""]
[null,"Yes: Data Owner",{"$f":"C5","v":"Complete initial and residual risk assessment and proceed to next check"},""]
[null,"Yes: Shared Data with permission to publish","Capture evidence of permission to publish (e.g. data licence, industry code, etc.) and proceed to next check.",""]
[null,"Yes: Shared Data with legal obligation to publish","Capture evidence of obligation to publish (e.g. Legislation, Regulation, Licence, Code, etc.) and proceed to next check.",""]
[null,"No","Confirm assessment with DSO Digitalisation and Data Manager and document rational.","Please note, this check should only consider the ownership or rules relating to shared data. Any other factors which may limit the ability to publish such as personal information or security will be considered later in the form.\n\nPlease ensure you have considered:\n- Licence Obligations e.g. Long Term Development Statement\n- Code Obligations e.g. DCUSA Embedded Capacity Register\n- Legislation e.g. Environmental Information Regulations (the requirement to publish information relating to environmental issues including the delivery of energy) "]
[null,"Residual Reponse"]
[null,"Click here"]
[null,"Yes: Data Owner"]
[null,"Yes: Shared Data with permission to publish"]
[null,"Proceed to next check"]
[null,"WPD holds this data but is not the data custodian and is therefore not legally able to publish."]
[]
[null,"Guidance"]
[null,"Response",1,2,3,4,5,6]
[null,"Click here","","","","","",""]
[null,"No","","","","","",""]
[null,"Yes but mitigation in place","","","","","",""]
[null,"Yes mitigation required","Evaluate if the dataset can be modified to mitigate the issue whilst retaining significant value. Simple data manipulation techniques that could be effective include anonymisation, redaction and aggregation. \n\nIf the value of data is damaged too much by simple modifications, consider more advanced techniques such as Differential Privacy, data sharing with a more restrictive usage licence (GDPR lawful basis for processing required) or seek consent from the named individuals to share the data.\n\nThe ICO Anonymisation Code provides more information [2]","Evaluate if the dataset can be modified to mitigate the issue whilst retaining significant value. Simple data manipulation techniques that could be effective include Delay, Redaction, Aggregation, Randomisation/Noise. Consider what the act of manipulating reveals about the dataset (e.g. redacting an area of a map might indicate that it is sensitive) and ensure that the manipulation cannot be reversed. \n\nIf the value of data is damaged too much by simple modifications, consider more advanced techniques (e.g. generating synthetic data based on the source data) or data sharing with a more restrictive usage licence.\n\nNote, the issues identified in this category should relate to the contents of the dataset rather than the method of publication. The National Cyber Security Centre provide guidance which enables the safe publication and sharing of datasets whilst minimising cyber security risks. ","Evaluate if the dataset can be modified to mitigate the issue whilst retaining significant value. Consider which specific elements of the data are likely to cause issues and identify data modification techniques which can address these e.g. remove third party identifiers or reduce the precision of a specific data field. Data manipulation techniques that could be of value include: Anonymisation, Pseudonymisation, Delay, Redaction, Aggregation, Normalisation. \n\nIf the value of data is damaged too much by simple modifications, consider more advanced techniques (e.g. synthetic data) or data sharing with a more restrictive usage licence.\n\nNote, when a third party could be impacted by the publication of data care should be taken to ensure that the source data is accurate and that the issues have been successfully mitigated. Consider peer review of any data manipulation techniques.","Evaluate if the dataset can be modified to mitigate the issue whilst retaining significant value. Simple data manipulation techniques that could be effective include anonymisation, redaction, normalisation, aggregation, randomisation. \n\nIf the value of data is damaged too much by simple modifications, consider more advanced techniques such as Differential Privacy or data sharing with a more restrictive usage licence / terms and conditions which explicitly restrict certain usages.\n\nNote, in some circumstances industry governance will provide protection against consumer impacts (e.g. Licences, Codes, etc.) and this should be considered as part of the mitigation.","Evaluate if the dataset can be modified to mitigate the issue whilst retaining significant value. \n\nIf the value of data is damaged too much by modifications, consider data sharing with a more restrictive usage licence.","The primary mitigation is to provide a clear disclaimer that explains the limitations of the dataset and minimises the liability of WPD. \n\nThe WPD Network Connections Map uses the following disclaimer: \"We have developed the network capacity map to assist you with connections applications in constrained areas. The map gives a general illustration of availability constraints only and cannot be relied upon to assess the terms of connection for specific premises. Whilst we use reasonable endeavours to ensure that the network capacity map and related information is accurate, we do not warrant, and do not accept any responsibility or liability for, the accuracy or completeness of the content or for any loss which may arise from reliance on the network capacity map or related information. The terms and conditions for use of our website apply to the network capacity map and related information.\"\n\nWhere there are specific, known issues with the data, these should be clearly documented and published alongside the dataset."]
[null,null,"Please update response if a mitigation has been identified","Please update response if a mitigation has been identified","Please update response if a mitigation has been identified","Please update response if a mitigation has been identified","Please update response if a mitigation has been identified","Please update response if a mitigation has been identified"]
[null,null,"Please ensure that all mitigation options have been considered (e.g. data modification, restricted usage, restricted access) and provide justification for why these cannot be applied.","Please ensure that all mitigation options have been considered (e.g. data modification, restricted usage, restricted access) and provide justification for why these cannot be applied.","Please ensure that all mitigation options have been considered (e.g. data modification, restricted usage, restricted access) and provide justification for why these cannot be applied.","Please ensure that all mitigation options have been considered (e.g. data modification, restricted usage, restricted access) and provide justification for why these cannot be applied.","Please ensure that all mitigation options have been considered (e.g. data modification, restricted usage, restricted access) and provide justification for why these cannot be applied.","Please ensure that all mitigation options have been considered (e.g. data modification, restricted usage, restricted access) and provide justification for why these cannot be applied."]
[]
[null,null,{"$f":"IF('Data Sharing Assessment'!E5=Hidden!$B$6,\"Mitigation\",\"All\")","v":"All"},{"$f":"IF('Data Sharing Assessment'!E7=Hidden!$B$6,\"Mitigation\",\"All\")","v":"All"},{"$f":"IF('Data Sharing Assessment'!E9=Hidden!$B$6,\"Mitigation\",\"All\")","v":"All"},{"$f":"IF('Data Sharing Assessment'!E11=Hidden!$B$6,\"Mitigation\",\"All\")","v":"All"},{"$f":"IF('Data Sharing Assessment'!E13=Hidden!$B$6,\"Mitigation\",\"All\")","v":"All"},{"$f":"IF('Data Sharing Assessment'!E14=Hidden!$B$6,\"Mitigation\",\"All\")","v":"All"}]
[null,null,{"$f":"IF(C32=\"All\",COUNTA(C$34:C$41),COUNTA(C$34:C$41)-1)","v":8},{"$f":"IF(D32=\"All\",COUNTA(D$34:D$41),COUNTA(D$34:D$41)-1)","v":6},7,6,6,3]
[null,"Mitigation Type","Click here",{"$f":"C34","v":"Click here"},{"$f":"D34","v":"Click here"},"Click here","Click here","Click here"]
[null,null,"Simple Data Manipulation","Simple Data Manipulation","Simple Data Manipulation","Simple Data Manipulation","Simple Data Manipulation","Disclaimer"]
[null,null,"Advanced Data Manipulation","Advanced Data Manipulation","Advanced Data Manipulation","Advanced Data Manipulation","Advanced Data Manipulation","Disclaimer and Documentation"]
[null,null,"GDPR Lawful Basis - Consent","Restrict Usage - Public Data","Documentation","Restrict Usage - Public Data","Restrict Usage - Public Data"]
[null,null,"GDPR Lawful Basis - Other","Restrict Access - Shared Data","Restrict Usage - Public Data","Restrict Access - Shared Data","Restrict Access - Shared Data"]
[null,null,"Restrict Usage - Public Data","Mitigation not possible","Restrict Access - Shared Data","Mitigation not possible","Mitigation not possible"]
[null,null,"Restrict Access - Shared Data",null,"Mitigation not possible"]
[null,null,"Mitigation not possible"]
[null,null,{"$f":"OFFSET(Hidden!C$34,0,0,Hidden!C$33,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Hidden!D$34,Hidden!D$32,0,Hidden!D$33,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Hidden!E$34,Hidden!E$32,0,Hidden!E$33,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Hidden!F$34,Hidden!F$32,0,Hidden!F$33,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Hidden!G$34,Hidden!G$32,0,Hidden!G$33,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Hidden!H$34,Hidden!H$32,0,Hidden!H$33,1)","v":{"$error":"#VALUE!"}}]
[]
[null,"Residual Reponse",0,1,2,3,4,5,6]
[null,"Click here","Click here","Click here","Click here","Click here","Click here","Click here","Click here",1]
[null,"Green","Green","Green","Green","Green","Green","Green","Green",2]
[null,"Amber","Amber","Amber","Amber","Amber","Amber","Amber","Amber",3]
[null,"Red","Red","Red","Red","Red","Red","Red","Red",4]
[null,null,4,{"$f":"IF('Data Sharing Assessment'!E5=$B$5,2,4)","v":2},{"$f":"IF('Data Sharing Assessment'!E7=$B$5,2,4)","v":2},{"$f":"IF('Data Sharing Assessment'!E9=$B$5,2,4)","v":2},{"$f":"IF('Data Sharing Assessment'!E11=$B$5,2,4)","v":2},{"$f":"IF('Data Sharing Assessment'!E13=$B$5,2,4)","v":2},{"$f":"IF('Data Sharing Assessment'!E514=$B$5,2,4)","v":4}]
[null,null,{"$f":"VLOOKUP('Data Sharing Assessment'!$F$3,Hidden!C$45:$J$48,(8-Hidden!C44),FALSE)","v":2},{"$f":"VLOOKUP('Data Sharing Assessment'!$F$5,Hidden!D$45:$J$48,(8-Hidden!D44),FALSE)","v":2},{"$f":"VLOOKUP('Data Sharing Assessment'!$F$7,Hidden!E$45:$J$48,(8-Hidden!E44),FALSE)","v":2},{"$f":"VLOOKUP('Data Sharing Assessment'!$F$9,Hidden!F$45:$J$48,(8-Hidden!F44),FALSE)","v":2},{"$f":"VLOOKUP('Data Sharing Assessment'!$F$11,Hidden!G$45:$J$48,(8-Hidden!G44),FALSE)","v":2},{"$f":"VLOOKUP('Data Sharing Assessment'!$F$13,Hidden!H$45:$J$48,(8-Hidden!H44),FALSE)","v":2},{"$f":"VLOOKUP('Data Sharing Assessment'!$F$14,Hidden!I$45:$J$48,(8-Hidden!I44),FALSE)","v":2}]
[]
[null,1,"Open","Open"]
[null,2,"Public","Public"]
[null,3,"Shared","Shared"]
[null,4,"Closed / Shared under specific circumstances and with sufficient data protection","Closed / Shared under specific circumstances"]
[]
[]
[null,0.8,"Open","Limited residual risk remains, consider if areas of risk can be further mitigated through data modification. If this is not possible, consider if this is an acceptable level of risk to proceed with Open publication."]
[null,"08 + Privacy","Open","Limited residual risk remains, consider if areas of risk can be further mitigated through data modification. If this is not possible, consider if this is an acceptable level of risk to proceed with Open publication (subject to Data Protection Officer approval)."]
[null,0.5,"Public / Shared","Moderate residual risk remains, consider if areas of risk can be further mitigated through data modification. If this is not possible, consider if reducing the allowed use or access to the data would result in an acceptable level of risk."]
[null,"0.5 + Privacy","Public / Shared","Moderate residual risk remains, consider if areas of risk can be further mitigated through data modification. If this is not possible, consider if reducing the allowed use or access to the data would result in an acceptable level of risk (subject to Data Protection Officer approval)."]
[null,0,"Shared / Closed","Substantial residual risk remains, consider if areas of risk can be further mitigated through data modification or other techniques. If this is not possible, consider if reducing the allowed use and access to the data would result in an acceptable level of risk."]
[]
[]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]