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.(adsbygoogle = window.adsbygoogle || []).push({});

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:

What else would I need to calculate temperature loss from the plate heat exchanger In Kw per hour?

- 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

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel spreadsheet calculating costs

Loading...

Similar Threads - Excel spreadsheet calculating | Date |
---|---|

Cantilever spreadsheet for dummies | Jan 30, 2014 |

Heat loss through pipes excel | Jun 25, 2012 |

HelloDoes anyone know if it's possible to run an excel file in | Apr 27, 2011 |

Formulas for ellipse at an angle, in Excel. | Nov 16, 2010 |

D'Arcy-Weisbach pressure loss in Excel | May 27, 2010 |

**Physics Forums - The Fusion of Science and Community**