A new off$-$grid greenfield development including $1000$ new homes is being planned. You have been tasked to determine the optimum number of renewable energy installations to power the community. You are to determine how many wind turbines $($WTs$),$ how many solar voltaic panels $($SVPs$)$ and how many biogas reactors $($BG$)$ are to be built to meet the energy needs of the town. You need to tell the planners the best number for each device to install to meet their energy needs based on their expected demand and the availability of renewable resources in their area. At the end of your report, you will be able to recommend the number of WTs$,$ SVPs and BGs they should build. Part $1$: Optimisation You will minimise the cost of energy $($COE$,$ $ month$-1)$ shown in Equation $1$ in order to determine the best number for each of the technologies to install. You will formulate a model, determine the feasibility and present a solution considering the COE Equation $1$ and the following relevant information. Where COE is the cost of energy $($$ month$-1),$ Pi is the production cost of energy type i $($$ unit$-1$ month$-1),$ Ni is the number of units of energy type i $($units$),$ Ei is the energy supply per unit of energy type i $($MWh unit$-1$ month$-1),$ and TE is the total demand of energy required $($MWh month$1).$ The data required is in Table $1.$ The production costs are a simplified cost relating to the capital, operating and maintenance costs per entire unit of each energy producing device, including the solar panels$/$wind blades and tower, generator, battery storage and auxiliary parts.There are additional considerations when using renewable energy. Namely, solar exposure, wind speeds and biomass availability, which vary throughout the year. To incorporate these additional considerations, you need to know that the existing availability of solar and wind are shown in Table $2.$ It has already been determined that a maximum of $10$ biomass units is feasible based on local agricultural plans.To determine the availability of solar power requires the solar radiation value in the table above $($kW m$-2$ d$-1),$ the area of each panel $(2$ m$2)$ and the number of panels per installation $(22).$ To determine the availability of wind power requires the wind speed $($m$/$s$),$ and a wind conversion factor of $21$ kWs m$-1.$ You may assume that $1$ BG unit produces $2\mathrm{.}9$ MWh month$-1$ unit$-1.$ You need to use this information to determine the possible quantities of energy available from each source per month to find the best arrangement of technologies across the year. Part $2$: Simulation You may see that across the different months that when you perform the optimisation in Part $1,$ a different number of units for each type of power generation system is selected. You now need to determine a realistic suggestion of how many of each device to recommend to your client, knowing that you can only recommend one solution. Create a simulation to test different scenarios to assist you to inform your client. Your simulation should be able to demonstrate that your technology choice can meet the energy demands of the community every month of the year. Part $3$: Numerical integration and differentiation Perform further analysis to better understand the COE for Energyland. $$ What is the annual COE based on your recommendations? How does this support your recommendation? $$ At what times of the year does the COE change the fastest and the slowest? Include the values of how quickly these changes occur. How does this support your recommendation? COE$=\frac{({\displaystyle \underset{i=1}{\overset{3}{}}}(P_i{N}_i)(E_i{N}_i))}{TE}$

Table $1$: Data for Energyland.

There are additional considerations when using renewable energy. Namely, solar exposure, wind

speeds and biomass availability, which vary throughout the year. To incorporate these additional

considerations, you need to know that the existing availability of solar and wind are shown in

Table $2.$ It has already been determined that a maximum of $10$ biomass units is feasible based on

local agricultural plans.

Table $2$: Solar and wind resources in Energyland. both tables have been supplied in the image.

The task is to create part $1,2,3$ in excel. Write a step by step process of how you would set this up in Microsoft excel.