I need an excel file created that can take tank input parameters (dimensions, wall thickness, material,insulation, roof,), along with monthly climatic data, existing tank contents temperature, feeding of new material and temperature, and output a monthly heating required.
The tank will be operated in a semi-continuous batch fed manner (portion of the volume removed and the same volume added). The calculations must take into account heat required to maintain the existing temperature, and heat required to increase the temperature of material being added.
Tanks can have flat roof or hemisphere dome (I can input dome volume as it may vary)
Must be formatted in a logical manner and all in SI units (m, C, kWh etc).