- #1

lee121

- 13

- 0

Basically a valve is passing when the heat/hot water is off and want to work out the heat loss and costs incurred due to the valve passing by using the flow rate, flow/Return temperature and 0.04p Kwh cost.

assume the following:

- Primary flow rate to the plate is 80c and the return temperature is 79.5c.
- the flow meter fitted to the Primary return is registering 700 litres per hour passing from the flow back through the return
- the cost per Kw is 0.04p per Kwh

I am trying to form a spread sheet in Excel and enter formulas to work out the maths and ultimately provide the total costs of losses due to this valve passing.

The spread sheet I have made up has all the data I think I need but for whatever reason it does not work and gives me some crazy figures.

Many thanks for any help provided