Heat Loss and Heating Pipe Diameter Calculation: Guide and Excel
In order to reach the correct pipe diameter in a heating project, first the design heat loss of the space and then the terminal and circuit flow rate are determined. This guide explains the order of the account and at what point Excel tools can be used.
Account order and technical controls
Files are a helpful calculation tool; Results should be checked against project conditions, applicable standards and manufacturer technical data. The following sequence explains why input data is important.
1. Determine space heat loss
Exterior design temperature, target indoor temperature, wall, window, roof and floor areas and thermal permeability values are the initial inputs. The general approach for conduction losses is to evaluate each structural element based on U, A and temperature difference. Air leakage and ventilation effects are also calculated; The relevant TS EN 12831 method is taken as basis.
2. Transfer the design capacity to the terminal
Space heat loads are connected to terminal elements such as radiators, underfloor heating, air handling unit coils or fan-coils. The heat that the same terminal can deliver at different round-trip temperatures may differ. Compare design regime with temperature conditions in manufacturer data.
3. Change from flow rate to pipe diameter
Approximate water flow rate in water heating circuits can be found in m³/h with the formula Q(kW) × 0.86 / ΔT(K); The final calculation is updated according to water properties and operating temperature. Pipe diameter selection is made by evaluating the flow rate, inner diameter, allowed speed and critical circuit pressure loss.
4. Verify pump head
Heating collector, distribution pipe, valve, heat exchanger and terminal losses are collected on the critical circuit. In a closed hydronic circuit, building height is not directly added as a friction load; minimum filling and expansion pressure are controlled separately. The selected pump curve is evaluated at both design flow rate and part load.
5. Use Excel template carefully
Input temperatures, building envelope, loads, pipe material and circuit distances to the Excel file must be processed correctly. A template's calculation method and compliance with the standard are not guaranteed regardless of the project. Results should be further validated with the standard version used, instrument data, and field conditions.
6. Project and test outputs
Design heat loss table, device list, column/hydraulic diagram, pump duty point, valve selection and commissioning measurements must be consistent with the calculation. A diameter table taken from an Excel file alone does not replace the application project.
Frequently asked questions
Is the heating pipe diameter selected only from the kW value?
No. Circuit temperature difference, water flow rate, inner diameter, pressure loss and valve equipment are controlled together.
Is the result given by the pipe diameter calculation table sufficient?
This could be a pre-sizing tool; must be verified with critical line calculation and manufacturer/field data.
Spreadsheets should be validated against actual field data.
Application should not be made based solely on the results of the table without correctly entering the materials, equipment, working pressure, fluid properties and field elevations.
Account and resource verification record
This guide explains the general technical approach. The standard version, design value and method to be applied must be verified by the engineer in charge for the actual project. The formulas in the downloadable calculus files have not undergone independent engineering verification in this release update; It cannot be used in place of an approved project account or official report.
The source, unit, acceptance, publication used and result control of the input should be kept together in the accounting record. It is not assumed that the formula will give the same result if the unit of the inputs is changed. A sample result is not a statement of capacity or suitability for the actual facility.
| control area | Registration |
|---|---|
| input | Field measurement / project / manufacturer data and unit |
| Method | Relevant current publication and scope |
| Conclusion | Independent control and limitations |
| Approval | Actual review record of the project manager |
Content update: 16.10.2026. Technical method and project approval is a separate verification process from this date information.