We'll initially need to get some flags and other bits of information ready.

The operational line we can take from our earlier work in the operations tab.

We've got an interest during construction flag. What this shows is when a project is allowed to or can charge its interest not to its P&L but pour it into the CapEx and so it's gonna end up on the balance sheet as part of PP&E and then it will be depreciated later.

We can get that by taking 1 and minusing whether the project's operational. And the reason that works is because whenever the project is operational, it is no longer the CapEx period and vice versa.

When we do our pricing later, for example, for CapEx, we could point that at the operations tab. But just for convenience, let's grab inflation index and put it on this page as well.

One of the easiest to understand uses of cash is CapEx. We're going to be spending money, we're going to be spending money getting wind turbines ready and we're going to be initially getting 20% and then 80% of the capacity sorted. And that will lead to spending in those years. And you can see there's a little, almost like a table here, and this is an area where we can get a little calculation going because we would like the CapEx as a total, and then we're going to build up effectively a base account later on once we've worked out how much that's gonna cost us. Initially what we've got to do is just work out how many megawatts we're going to prepare in each year. And really what we've got to do is we've got to make sure that the first year is 20% and the second year is 80%. And then in other years it doesn't say anything at all.

That might be quite tempting to do just with a simple link or maybe even a hard code. But we would like to show how you might do this if it were a more complicated model and you maybe had three or more years or different phasing or something like that. And so we will use an index and because we're using an index, we'll probably have to use an IF error as well.

We're going to put the percentages here and let's start with doing an index. We're going to have the index as the possible percentages and lock those so they don't move around. And then we're going to have the guiding principle for the index being a year, which we actually haven't populated yet.

Now, if we let that happen, you can see we got strange results. And this is actually worth seeing because if you get strange results with an index, you probably ended up with a zero somewhere and it kind of interprets that as wanting to return the entire array.

If we populate this by adding in year one and then pulling that forwards, you can see that started to work a bit better. And that's because it's taking position one vertically in the index. We don't care about the horizontal part of the index, and so we don't need anything in that second location. However, if we pull that to the right, it quickly falls over and that's because there is no third position in the index. And so it's throwing an error error. We need to wrap this in an IF error.

Previously we put an n/a. Now if we put an n/a now, it will probably end up doing strange things. We really do want it to say zero now. If we pull that to the right, that's doing what we want, where it's ramping up in terms of the construction, and then we are not spending anything afterwards because we've fallen outside of the index. And if our index changed or we decided to have it bigger, we'd probably have it on another tab. But we've now got the equipment to make that flexible. We can now multiply the max megawatts by the installed megawatts and we get our installed capacity. And this is a major step towards CapEx because this is the amount of CapEx that will happen during the year because our CapEx is priced off a megawatt.