Electrical Water Heater Capacity Excel Sheet (xls)

Download free excel sheet for calculating electric water heater capacity in gallon and kilowatt. With this spreadsheet calculator you will get the storage tank capacity in gallon and the heater coil capacity in KW. There is a tab in this sheet for tables you will need in your calculations such as demand factor and hot water demand for every type of buildings.

NOTE: you will also need the hot water circulation pump calculator so as to make sure the hot water is available all the time with the optimum hot water temperature.

Electrical Water Heater Calculation

Download water heater calculator excel sheet xls

Spreadsheet password is XZSGTCTWVFTQWJT

How to size electric water heater in KW and Gallon?

1. Insert the type and number of plumbing fixtures that need hot water

2. Insert demand factor according to building type

3. Insert storage factor according to building type

4. Insert the desired desired output hot water temperature.

Now you will get the following:

• Storage tank capacity in (g)
• Heater coil capacity in (Btu/hr) or (Kw)