Skip to content
SpreadsheetWeb
FeaturesPricingBlogCustomersEnterpriseGallery
Sign up for freeSign In
FeaturesPricingBlogCustomersEnterpriseGallery
Sign up for freeSign In

Building performance demo

Heat Load Calculator

Estimate whole-building heating and cooling loads from envelope, glazing, climate, infiltration, and internal gains using a live SpreadsheetWeb model.

Configure the building ↓

Live workbook model

Build a whole-house load scenario

Start with the published example, then adjust the building and design conditions. Valid changes recalculate automatically.

Unit systemIP uses feet, square feet, degrees Fahrenheit, and Btu/h. SI uses metres, square metres, degrees Celsius, and watts. Values are converted when you switch.
Choose Custom to use the design-condition fields below, or select an illustrative workbook preset.

Changing unit systems converts the current values while retaining unrounded canonical values to prevent toggle drift.

01

Building profile

Define the size, infiltration, occupancy, and altitude.

The conditioned floor area served by the system. Enter square feet in IP or square metres in SI.
The average floor-to-ceiling height used with floor area to estimate conditioned volume.
Estimated complete air replacements per hour caused by infiltration. Lower values describe tighter buildings.
The typical number of people whose sensible and latent heat gains are included.
Site elevation above sea level. The workbook uses it when estimating air-pressure effects.
02

Design conditions

These six values drive the workbook only when the Custom preset is selected.

The desired indoor dry-bulb temperature used for the winter design condition.
The desired indoor dry-bulb temperature used for the summer design condition.
The target indoor summer moisture level, expressed as relative humidity.
The outdoor dry-bulb temperature used to estimate the design heating load.
The outdoor dry-bulb temperature used to estimate the design cooling load.
The outdoor summer moisture level used in the latent cooling calculation.
03

Internal gains and allowances

Account for people, plug loads, ducts, sizing allowance, and supply-air difference.

Sensible heat released indoors by appliances and plug loads, entered in watts.
Sensible heat released indoors by lighting, entered in watts.
Heat from each person that raises air temperature, shown in Btu/h (IP) or watts (SI).
Moisture-related heat from each person, shown in Btu/h (IP) or watts (SI).
Additional percentage allowed for heat gained or lost through the duct system.
Additional percentage applied by the workbook as a sizing allowance.
Temperature difference between room air and supply air used to estimate required airflow.
04

Opaque envelope assemblies

Choose each construction, enter its area, and optionally override the workbook R-value.

#Construction The envelope construction selected from the workbook library. Its thermal resistance is used unless you provide an override.Area The exposed surface area of this assembly, entered in square feet (IP) or square metres (SI).R override Leave blank to let the workbook derive thermal resistance from the selected construction. Enter a value only to override it.R used The thermal resistance the workbook actually uses after applying the construction default or your override.UA Overall heat-transfer coefficient multiplied by area. Lower UA means less conductive heat flow through that assembly.
1——
2——
3——
4——
5——
6——
7——
8——
05

Glazing by orientation

Enter window and skylight area, U-factor, and solar heat gain coefficient (SHGC).

OrientationArea The window or skylight area facing this orientation, in square feet (IP) or square metres (SI).U-factor Rate of heat transfer through glazing. Lower U-factor means better insulation.SHGC Solar heat gain coefficient: the fraction of incident solar heat transmitted through the glazing, from 0 to 1.Solar gain factor The workbook's orientation-specific solar load factor before glazing area and SHGC are applied.
North—
East—
South—
West—
Horizontal (skylight)—

Workbook results

Estimated design loads

Calculated from the published SpreadsheetWeb model using the current configuration.

Waiting for a valid model
Heating load The total design heating rate estimated by the workbook from envelope and infiltration losses plus allowances.—
Cooling load The total sensible and latent design cooling rate estimated by the workbook.—
Cooling capacity The cooling load expressed as nominal equipment capacity. This is an illustrative workbook result, not equipment-selection advice.—
Required airflow The estimated supply airflow required at the entered supply-air temperature difference.—

Heating breakdown Shows how conduction, infiltration, ducts, and other workbook terms contribute to the total heating load.

Adjust a value to calculate the load.

Cooling breakdown Shows how envelope, solar, infiltration, people, appliances, and lighting contribute to the total cooling load.

Adjust a value to calculate the load.

View calculation details
Heating calculation Workbook line items behind the heating total, including temperature difference and heat-transfer terms.
Waiting for results.
Cooling calculation Workbook line items behind the sensible and latent cooling total.
Waiting for results.
Sizing metrics Derived capacity, sensible-heat ratio, airflow, and area-normalized metrics reported by the workbook.
Waiting for results.

Connecting to the live workbook…

Powered bySpreadsheetWeb
i

Demonstration only

This calculator is provided solely to demonstrate the capabilities of the SpreadsheetWeb platform. Its results are illustrative and may omit factors required by applicable codes, standards, site conditions, or professional practice. Do not use this demo or its results for HVAC sizing, engineering, construction, purchasing, safety, compliance, financial, or other decisions. It is not a Manual J calculation or a substitute for an assessment by a qualified professional. Independently verify all inputs and results. This demo is provided “as is,” without warranties of accuracy, completeness, or fitness for a particular purpose. To the fullest extent permitted by law, SpreadsheetWeb and Pagos, Inc. are not responsible for decisions, losses, damages, or other consequences arising from use of or reliance on this demo.

A concise model

What the workbook combines

  • EnvelopeOpaque assemblies, glazing area, U-factor, and SHGC.
  • ClimateWinter, summer, humidity, altitude, and infiltration.
  • Internal loadsPeople, appliances, lighting, ducts, and sizing allowance.

Build from your spreadsheet

Convert My Excel Model to a Web App

Explore more examples in the gallery or talk with the SpreadsheetWeb team about your application.

Sign-up for a free accountView more demos

Product

FeaturesGalleryCustomersDevelopers & APITemplates

Solutions

IndustriesMarketingHuman ResourcesFinanceSales

Use Cases

Online CalculatorsSales QuotingTimesheet AppsScored QuestionnairesSearch ApplicationsReporting Applications

Support

User GuideTraining VideosCase StudiesTips

Resources

BlogExcel ApplicationsExcel Tips & TricksExcel FormulasExcel MacrosExcel Templates

About

About UsContact UsServices

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use -

FacebookXLinkedIn