The University is now keen to develop your plans outlined in task $1$ and would like you to consider how each renewable energy system could be integrated so they work together to meet the university demand. To help with this, a size $($Kw rating$)$ has been proposed in the table below for the $3$ RETs.

i$.$ To help explain how each RET could be connected together with the university$$s energy system needs, use an Excel spreadsheet to calculate from the RET Kw size, to determine the output of each renewable system in terms of monthly power, energy and financial value as laid out below. Also find the total RET output and compare with the University$$s monthly kWh demand $($i$.$e$.$ find the difference$).$ Provide an image of your spreadsheet results.

ii$.$ Briefly discuss if the proposal will meet the total consumption of the University by comparing monthly$/$total kWh from $3$ RETs against the needs of the University. As the timing of renewable energy availability may not match demand, you should briefly describe what months the university is likely to be importing and from the grid.

iii. You have also been asked to re$-$run your spreadsheet with new RET sizes $($adjust their Kw rating as appropriate$)$ that you think might be a better energy mix. Provide an image of your spreadsheet results.Guidance: The format and analysis approach for $3$ common RETs are shown below; this approach could

also be used for other RETs. Include a copy of your spreadsheet so that formulas can be checked

Note: Actual monthly 'capacity factor' varies depending on the season, please use the following: For Wind:

Nov$-$Feb $=30\%$ and Mar$-$Oct $=25\%,$ and for Solar: Sep$-$Nov$=8\%,$ Dec$-$Feb $=3\%,$ Mar$-$May $=13\%,$Jun$-$Aug$=16\%.$

The CHP $300Kw$ rating is its fuel input requirement and not its electrical rating$\backslash$table$[[$Wind$,,,,$Solar,,,,Biomass,,,$],[,$turbine,,,,PV$,,,=75\%,AD,,],[$Eff$==90\%,$size Kw$,,,$Eff$=100\%,$size Kw$,,,$Eff$=35\%,$size Kw$,,],[500,,,,250,,,,300,,],[$Estimated$,$Average,Monthly,Monthly,Estimated,Average,Monthly,Monthly,Estimated,Average,Monthly,Monthly$],[$CapxEff$,kw,$kwh$,$Value,Capxeff,$kw,$kwh$,$Value,Capxeff,$kw,$kwh$,$Value$]]$

$\backslash$table$[[,,,,,$Base load,$+$ Day load,Peak load$],[,,,,,0$:$00-24$:$00,9$:$00-18$:$00,9$:$00-18$:$00$