1: One thing that should be fairly apparent is that the 14kWh battery is too big for the 15kWh average load. It would be useful to examine the question of what the appropriate battery size should be. Also, we are trying to use the model to answer a question – you can come up with the question, but it could be ‘how cheap to batteries need to be?’, or ‘how do load profiles and tariff structures impact affordability of batteries?’ or ‘is a city with good solar irradiance better for batteries?’

2: when describing the model and its pros and cons, don’t go into details about precisely how excel does the calculation. For example you could say the model determines at each time step how much power to put into the battery or onto the grid based on the output of the solar array and the state of charge of the battery.