 open networks at ENA. Just a quick reminder on some housekeeping rules. If you aren't already on mute please make sure you are setting yourself to mute to avoid any background noise. And also we'll be taking questions by the chat function so please feel free to share any questions as we go along using the chat facility. Next slide please Dan. So as you know our session today is about the DSO implementation plan so we had this we had a workshop previously in September. A number of you provided us feedback on how we can actually improve the tool so the session today is about you know playing back some of your comments demonstrate to you how we're taking them forward. We would encourage you to participate today and share your views. I think we'd be keen to hear whether or not the changes that we're making are helping to address your comments and feedback. So we've just got a we've just got an agenda here on our slide so I'll just kind of set a little bit of context give you a bit more background and then I'll hand over to DNVGL to kind of demonstrate the changes that we are making. We've got Q&A at the end on the agenda but as I said before feel free to just drop your questions in the chat and we can pause and address some of them for you. Next slide please Dan. Just as a reminder so as you know we first published our DSO roadmap in July so the DSO implementation plan is a key deliverable for us in open networks so the DSO roadmap provides a consolidated view of outcomes from all the different work streams and open networks and it provides some visibility of actions that the networks are undertaking to deliver those eight functions for distribution system operation. Next slide please. So we had a workshop in September last year and maybe did a demo of the DSO roadmap tool and a number of you provided us some feedback on how we can improve the tool. So the feedback that you provided can broadly be categorized into four different headings that you can see on the screen here. A number of you gave us suggestions on how we can improve the readability of the tool so as the tool is at the moment there are a number of pop-up windows that provide further information on the different activities and steps that we've got. A number of you said that the text wasn't very readable on it and some of you also said that the option to copy paste text from that wasn't available. So the next category of feedback was around search so a lot of you said that the option to basically like look for particular things using keywords isn't really there so you asked for a search function and then there was some feedback around data extraction so a number of you said you would like to access the underlying data that's feeding into the roadmap and have it in a more accessible form and then the final set of comments were around the visibility of data that we have in the roadmap. So as the tool currently is you can see individual company level information across all of the steps and actions that are coming through from open networks but the feedback was to kind of extend that and make that applicable to all of the actions that we have in the roadmap. So yeah so those are the four key areas and we've been considering that feedback and next slide please Dan. So we've worked that into our scope of works for this year. I think as some of you may know we have published our work plan for this year and we are consulting on it at the moment so the consultations open until first of March. So in terms of how we're taking this feedback forward we've got two iterations planned for this DSO implementation plan for this year first one in quarter one so as part of this we will make the accessibility improvements that you've suggested for the tool and will enable data extraction and then for the second iteration in quarter three we will then look to increase the granularity of the data and make all data visible at a company level and then we've got an additional activity in December where we will undertake an independent audit and will publish the findings of that. So that's everything from me in terms of just setting the context I'll now hand over to DNVGL. Yes thank you Farina. So my name is Afik Gasmussen. I'm a director at DNVGL for those of you who don't know me and indeed together with my colleague Jeroen who's also on the call. We've worked with the ENA and the member organizations to develop the original roadmap last year and also we've over the past month or so developed the enhancement as Farina has set out. So we've created within the tool that we use that's the Tableau software. We've created a search function a data extraction functionality and indeed an enhancement of the way. So if we presented information replacing those pop-up windows that weren't sort of too effective with another solution. So my colleague Jeroen will take you through. I think you have a presentation stand by Jeroen. So he'll explain to you what we've done and show you and then we can take some questions or thoughts in terms of how we deliver this. Jeroen I think you'd need to make Jeroen a presenter now if I'm not mistaken. Yeah I'll share my screen. Good morning everybody. Thank you for the opportunity of being able to show what we've done with your feedback and how we would like to how we intend to use that to improve the experience. Let me share my screen one moment. Okay as I said we've been working on three elements of your feedback on data extraction. The alternative for pop-up to improve readability and a search function. I'll take you through them one by one and I would also like to give you the opportunity to respond to that at the same time. Okay first of all data extraction. The feedback we got was that some of you would like to have to say the raw data to make your own analysis on the information that is contained into the roadmap. So what we've done is developed an extraction tool to allow the data that is available in the roadmap to download that as an Excel file. And actually the file contains three sheets. A front page with with an introduction but also an explanation of what the data fields contain. Then the second bit, the second sheet is a sheet that contains all the data on the aggregated steps which is basically the information you see on the roadmap itself. And then there's also the individual monitoring or individual reporting data that for some steps is being made available. So in more detail well basically all the data that is available in and visible in the roadmap can also be downloaded. And well here you see the details of all the data. I don't think it would make any sense to go through the individual fields. And I said that the data is made available in an Excel sheet and it contains probably for most of you a very boring set of information but then data analysts would love it and will extract their own information from this. With the update that Freena was referring to end of March this data will become available for you to download and play with. Before I continue to the next functions are there any questions about this functionality? I'm not sure that people have audio available to ask questions. So I guess perhaps if I've understood you can type in a question if there is any and then we can pick it up. Maybe we maybe we move on and we'll see at the end if there's questions coming in and then we step back to the topic. Good then our progress. Then you gave us feedback about the pop-up window in the original version of the roadmap. For some there were issues with readability. So what we did was we replaced the pop-up window with a window in the bottom of the screen. So rather than showing the information in a pop-up we used a small area of the screen to display basically the same information and at the same time we removed the information which was provided on perceived complexity as we got the feedback that didn't add too much value. Again let me quickly show what how this worked out. So this is a view on the new version of the updated version of the roadmap. So if you would go to the roadmap on the roadmap level rather than having a pop-up if you click on one of the bars in the bottom of the screen you'll find the same information that used to be in the pop-up but now as a part of the screen. The very same way of displaying information is on a function level and on an activity level there already used to be a function to display the reporting data and in addition we have now also included the information on the individual steps in an area of the screen. So hopefully this improves the readability as requested. Again if there are any questions on this at this stage then please let me know. Remarks. I've got one question in the chat from Gemma so her question is where exactly in the ENA website will the data be available for download? So we've got two options so we will make this data available in our resource library as you've seen we've got a new ENA website but what we will also do is in this actual roadmap itself in the about tab we can put a link to make sure it's it's accessible from there as well. Yeah I think that's that's an excellent idea we'll we'll make sure that that is implemented as well. Okay so no further questions then I would like to go on with presenting the last edition we made which is a search function to improve search across the entire roadmap. We added an additional sheet on the roadmap the search field and that will allow for a text search in step by step name is step description and some additional selection criteria to further drill down to the the specific information that's being looked for. So basically the result window will look very similar to the activity window with that restriction that will only display information that's in that that's meeting the the search text requirements. So there's a search box included which allows to enter a text. If you select a step it will display exactly the same information as it would in the activity tab to find more detailed information about the step and additionally to to to reduce the number of results search results it's possible to either select a specific function or to select organize steps that are delivered by a specific organization. Again let me quickly demonstrate what this would look like. So in the roadmap you would go to the search window and rather than have an overview of the steps that relates to specific function and activity it will give you a very long list of all steps in all functions and all activities and that can be the number can be reduced by by entering a specific search text. For example if I would be interested in all non-DSO type of related steps I could enter non-DSO and that would give me an overview of all steps that relate to non-DSO services and again by selecting a specific step it will give me some more detailed information about that step. If the number of search results would be too large I could further reduce the search results by either selecting a specific function or looking at a specific organization. For example if I would go to a DNO it will give me all only those steps that would be performed by a DNO. So that's how we have implemented the search function Yeah that's basically on a nutshell all the enhancements we have developed based on your feedback and I would be very interested to learn whether this meets your expectations and is perceived as improvements. I don't see any questions coming in remember if you want to ask a question you can type it in in the meeting chat at least you have one endorsement of the of the improvements for the pop-up window thank you Helen that's good to know here we go questions coming in let's see so there are a couple of questions um first question is will there be an api for approved third-party systems to access the data? No there's no it's not for seeing that there will be an api for for accessing the data so however if the data is stored on the DNA website as in excel most data extraction tools for data analytic tools would be able to to access that in an automated way so effectively I would say the way the data can be accessed would be very equal to to having an access to an api. Thanks Helen we've got another question about how often the data is updated for each field so we're updating the DSO roadmap every six months so the first one being at the end of March and then the next one will be at the end of quarter three another question from Tony will the file be csv as xlsx has row limits so is that a csv format? Okay we propose to use an excel or xlsx formats rather than csv I know there are row limits but the the number of rows in the data extraction easily fits into the limitations of excel while csv does not allow to have multiple sheets and that that's a functionality that is provided by excel so that's why we suggest to use xlsx rather than csv. Okay thanks I don't think we've got any other questions at this point we'd encourage people to just share their views as well if you think you know whether or not this is kind of meeting you know the original comments that you provided or if there's a better way we could be doing some of this so I think the suggestion from Tony is that csv's are better for system access I think that's something we can maybe take away and have a think about to see how that might fit in with the structure of what we have. I would say that from a technical point of view providing both options is probably technically feasible it will just require some more maintenance efforts on the ena site. Okay so yeah we can definitely take that away and and see how we can maybe provide both because I think with excel with people like who might be wanting to look at data across multiple tabs they might prefer that but yeah we'll take that away and see if we can provide both. Okay so there is another question as well from Tony is there a beta site available do you have the url so we've got the DSO roadmap live so this is the one we published in July last year we can share a link to that but I don't think we've got a test link for basically like the tool with the enhancements that we're discussing today. Yeah I will discuss with you Farina and see if we can make it available if ena would prefer to have to do so. Okay thanks Seon I think that's all the questions should we move on to the next one and I think people can type any other questions or comments or thoughts in the chat as we go along. I think this concludes the VGL spot at this stage is that correct? As far as I know we don't have unless there are more questions there's nothing more to present. Okay well I think you can see it's presenting and then you can take over again. Yep so thanks for presenting that so in terms of next steps we're basically going to be considering some of the comments that you've provided today you know those have been quite helpful see how we can work them in for our next update so we will be publishing the next version of the DSO roadmap towards the end of March so that will have all of these accessibility improvements and if people have any further thoughts or any comments um you know feel free to share them with us on opennetworks.energynetworks.org so that's that's everything from us today are there any final thoughts or any final comments no it doesn't look like it all right well thank you everyone for joining us and thank you again for the feedback if you've got any further thoughts you know then feel free to share them with us. Okay thank you bye