 Hello, this is a video demo of the Common Evaluation Mythology CDA tool. The tool is filled in, populated with an example so that it can enable us to do the walkthrough. The main three sections of the tool are listed here in the guidance tab, as well as the legend, the key to the cell formatting, as well as a link to the user guide of the tool for more detailed guidance around how to populate this tool. The three main sections we have is essentially the first one is the input section, which includes a number of tabs in there which will go through one by one and explain the purpose of each. This is where the user populates the tool with the main cost and benefits. The analysis and insight section, this is where all the outputs and reporting metrics are being included. And the last section, the background calculation section, doesn't require inputs or interaction by a user. This is where some of the background calculations are being made. The user should only populate the yellow cells. Some of them are dropdowns and have purple outline. All the other cells are either fixed, their calculations or they are auto populated by a macro. These are the blue formatted cells. Costs and benefits should be inputted in 2018-19 prices, and costs should be entered as positive values whilst benefits or avoided costs should be entered as negative values. So this is essentially the first guidance tab. The purpose of the CDA tab acts as a placeholder for the user to describe the investment decision drivers, the aim of the investment decision and any kind of condition of the assets. And then we begin with the main input section where the first tab is the control tab. This is where the user can select the reference year for discounting and indexing. This is a dropdown selection. The start year of the analysis, this case is 2020. The next dropdown selection here refers to how the tool calculates the exceedance of the baseline. The baseline here in this tool is the reinforcement option. So that can be done by the user entering load and load growth, peak load I should say, or exceedance can be entered directly by the user. So that's the alternative selection. For now for this example we use peak load entries. The last selection here is with regards to how the flexibility cost is populated. So these can either be calculated using an assumed availability cost or relating to the volumes of exceedance. Or again the user could input all annual flex costs directly. Again for this example we use flex costs being calculated from required flexibility volumes. The next table here on the right enables the user to name and define the scenarios they want to look at as well as the strategies. They could look at over and above the baseline reinforcement strategy. They could look at flexibility for example or efficiency or any other strategies up to 10 different strategies. And then also they can consider up to 10 different scenarios. In this case we've filled in a best use scenario as well as the four best scenarios, but these really can be any types of scenarios the user deems appropriate. So up to 10 scenarios and up to 10 strategies that can be considered. The configuration table essentially takes up information summarized. It gives us the number of up to 10 configurations we have. In this case we're considering the flexibility strategy under five different scenarios. The best view and the four best scenarios. So we have five different configurations, which is a single strategy considered under five different scenarios. In case the flexibility strategy is only appropriate up to a specific point in time. This can be reported by the user in column E of this table. This is the last date at which the strategy can be effective. In this example we've assumed that flexibility can be a credible strategy indefinitely. But a limit can be imposed to that as appropriate by the user. And column F summarizes the name of each configuration. And column C summarizes, as you can see, strategy of flexibility under all of the five different scenarios we have defined. The next section here refers to the baseline strategy, the reinforcement strategy. This will become clear when we look at the next tab, the baseline reinforcement tab. This is essentially a selection by the user on which scenarios would be deriving the baseline assumptions of when reinforcement is needed. So this is a dropdown, this selects the number of the scenarios that is, in this example, the first scenarios, that's the best use scenario. This means essentially that the exedence profile of the best use scenario, when exedence becomes positive, that here defines in this example when flexibility or reinforcement will be required. Once this tab is filled in with the selections of scenario names and strategy names, the user should click the update configurations button here. And this reorganizes the input tabs to take into account, for example, the fact that the baseline exedence will be calculated either directly or via click load, as well as the input type of the flexibility cost, whether it's calculating volumes or whether it's inputted directly. The second button right here, the step to calculating the benefit should be used after the cost and benefit are filled in in the remaining of the input section. So we would come back to this and click it once everything else is filled in before we can go into the next section and look at the outputs. The next tab, the baseline reinforcement tab is where all the relevant inputs for reinforcement are added. The intervention start here is 2023 in this example, because previously we've selected the best use scenario to define when reinforcement is required. So we have in this example included a peak network load projection profile for each of the scenarios right here. And the assets capacity we've defined as 30 MBA. So the year under best view that this capacity is exceeded is defined as the intervention start here. So we can see here that for best view, this happens in 2023. And then the cost and the profile of reinforcement and the upfront topics that is to be preferred if flexibility would be used that can be inserted in these roles. And then relative to the capacity is then calculated in these roles here. Then the costs and the profile of reinforcement and upfront topics that is to be preferred if flexibility would be used that can be inserted in these role items here. The breakdown can be populated or the total cost can be added in a single row. The flex volume and cost inputs tab, and this would look different if we had selected the direct flexibility cost to be added by the user. In this case, because we have selected the flex volume to be driving the flexibility cost. We see this tab. So here we can define an availability price and a utilization price per megawatt per hour. And then we go on to define the volumes that drive that. We could make an assumption in terms of the price trend for availability in the future. If we believe that that's my change with the development of the market. So that assumption can be made in row 11 here. And any other fixed costs that are related to flexibility strategy can be included in the next few rows for each of the strategies and scenarios we have defined previously. So these are any upfront costs that would be incurred regardless of the duration of the strategy, as well as any annual fixed costs for the duration of the flexibility strategy. These two are then being picked up by the tool and summarized in the output tab. The availability volumes can be defined a bit further down. So that's where the user can define the average capacity of availability that would be procured each year for each of the strategies and scenarios, as well as making an assumption of hours per day that the availability would be acquired days per year. So that drives the volumes and that links up to the availability price that is defined at the top. The same with the utilization price and volumes rows 78 to 82. That's where the user can define the expected annual volume of utilization as dispatched. So these inputs here drive the annual cost of flexibility. The flex cost summary tab essentially takes those inputs and provides a summary table. So we have a summary of the upfront costs, the annual fixed costs, and then the utilization and availability costs, totals summarized here. The table at the bottom of this tab allows for any availability cost savings from multi-year flexibility procurement. If the user wants to make this assumption, if they have some information from the market that will support availability price discounts, if the contracts are more than one year, for example. They can include this assumption in the table here. The next tab allows for the kind of incentives or penalties and societal impacts to be also taken into account. This should look similar to the existing DNO real CBA tool. So we could input losses impact, we could input emissions impacts, customer interruption impacts, customer needs lost. This works in the same way as in the real CBA in the sense that the user can input the volume, the annual volume of, for example, CMLs. That would be assumed under each of the strategies. And the tool calculates, uses the incentive value to calculate the monetized value of that. So these are picked up again by the tool and reported for each of the strategies in the output style. The fixed input style again, they should look similar to the real CBA tool. This is where the user can define the capitalization rates, the WAC. It is pre-populated with the relevant discounting rates, asset life, and some of the inputs that are used to monetize the societal impact such as cost per fatality or non-fatal injury, the CIs and CMLs, losses, etc. For working tabs, the last tab in the input tab, this allows the user to provide any workings of background assumptions that drive the rest of the input tab, some of the inputs that they populate the tool with. This would help with transparency or potentially submitting to off-gen and providing background calculations and assumptions. So this is the input section. Once we fill in all of the required costs and benefits, we would come back to the control tab to click the calculate benefits button here, the screen button. And then that allows us to go into the insight and reporting section to look at the outputs. The first tab presents the benefit by strategy. These are summarized in the two tables at the top. The first one provides the optimal reinforcement deferral duration in terms of years by strategy and scenario. And the other table on the right provides the MPV that's relevant for that optimal reinforcement deferral duration. The first table presents the benefits of deferral by a number of years. So the row here at the top signifies for how many years of deferral the results the MPVs are presented. So for one year of deferral, we would have 46,000 of benefits under flexibility, under scenario of best view, in this example. Under two years of deferral, that would increase to about 75,000 and that increases up until the fourth year of deferral. So that's why this is a green formatted cell here because it identifies the maximum value of deferral for this specific strategy under this scenario. You can see then this starts to fall for more years of deferral than before. The next table below shows the residual benefit after the initial deferral. So for one year of deferral, we see that the benefit would be 46,000 and the residual value compared to the maximum that the user could get, which is 103,000 is 56. And then if we look at two years of deferral, the MPV benefit of that is 75,000 in this example and the residual benefit after the initial deferral of two years compared to the maximum that they could get is 27,000. And so on and so forth for all the remaining strategies and scenarios. So the overall benefit is summarized in the last table. So that includes the initial benefits from the X year of deferrals and the residual. So for flexibility under best view, you can see this is 103,000 up to four years of deferral and then that falls and becomes negative eventually. The Insight and Reporting tab provides an additional level of analysis. First, it summarizes what we've already seen in the previous tab in the sense that it summarizes, it lists all the strategies and scenarios. It gives you the optimal length of deferral of the baseline of reinforcement and the MPV that's associated with that. This also provides the optimal initial flexibility contract length for each of the strategies. This at the moment looks like it's the same across all strategies because we haven't assumed any discount for longer contract lengths. If we had taken that assumption, this table summary would take that into account and provide us with the optimal initial flexibility contract length. And then that provides the MPV that would be locked in by the initial contract if we were to go with, for example, with two years of flexibility contract to begin with. And the residual MPV after that initial flexibility contract length. And this is all summarized in the two charts below. Next we have, we present an analysis of these results in terms of the least worst regret method to support the user in considering regret under the different scenarios. So this provides for the considers all the scenarios and all the strategies and considers the MPV and turns it into regret for each number of deferral years. And then that calculates the worst regrets by strategy. In this case, we are considering only one strategy, the flexibility strategy. So that identifies the worst regrets and the results are summarized here in terms of the calculated least worst regrets by strategy. In this case, it's flexibility strategy for one year. And the last piece of analysis in this tab uses the weighted average methods. This involves a few more assumptions by the user but arguably a simpler methods of assessing uncertainty under scenarios. This requires an assumption of the probability of each of the scenarios that we are considering in this case we're considering five different scenarios. We were to, for example, assume that each has an equal probability of out turn. We can see what the weighted average MPVs are for the flexibility strategy. And the summary table here at the bottom provides the maximum expected benefits by strategy according to the probabilities that we've defined. And again, this is for flexibility for one year. The last tab in the output section provides a little bit more analysis in terms of the ceiling price of flexibility. This would only work if the user defines the flexibility volumes in terms of availability and utilization in this tab. If we were to assume that if the user would select that the flexibility costs are inputted directly, then the ceiling price calculation can't be done within the tool. So essentially what the ceiling price calculation does is it takes all other costs relating to the flexibility strategies fixed apart from the availability price. And the user calculates essentially at which availability price their flexibility options no longer more optimal than the reinforcement option. And the user can define the increments of availability price that the tool cycles through to find the maximum ceiling price. And a maximum value for the tool to consider. You can see here that for some of these strategies where flexibility is the preferred. Because we have defined the maximum of 3,000 pounds for availability price it returns that at the maximum ceiling price. So defining the steps here and then clicking the blue button top would return the maximum availability price. And just for reference we're also linking the utilization price that's being assumed by the user. So this is the outputs section. The last section of the tool is the backend where essentially the background calculations are made. You can see that the baseline and configuration tabs look very similar to the real CBA tool. These take the cost and benefits as inputted by the user pass them through the depreciation treatment totics treatment and provides the MPV of the cost and benefits. And these are then linked back up back out to the output tabs. But essentially the message is that this section doesn't require any input or manipulation by the user. All the calculations are being done within the tool automatically. And again for any kind of more detailed guidance for using this tool you can go back to the guidance tab and double click on this icon here. And go through the detailed user guides that comes together with the CBA tool. Hope this has been useful and thank you.