- #1
lee121
- 13
- 0
Can anyone tell me how to work out the Kw usage of a plate heat exchanger using Primary and return flow rates when no demand for hot water or heating is needed; assuming 0.04p per Kwh is charged.
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:
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
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