Home › Shop › Refrigeration Cooling Load Calculation
Excel tool

Refrigeration Cooling Load Calculation

How big a refrigeration plant does this room need, and how much of the load comes from the product, the walls and the door?

Refrigeration cooling load of a cold room or process enclosure: product cooling (chilling, freezing, sub-cooling, respiration), wall transmission from insulation thickness, door infiltration and internal loads in a 24 hour profile, with peak, average and design load in kW and TR, compressor power, condenser heat and brine flow.

USD 39 one-time purchase

  • Excel workbook (.xlsx), no macros, version v1.0
  • Excel 2010 or later, Windows and Mac
  • Instant download after payment; updates to this major version included
  • Single-user licence; team and site options
  • Refund if it does not work as described or has an error we cannot fix: contact support within 14 days of purchase — full refund policy
Refrigeration Cooling Load Calculation — sample pages

What it does

Product load

Up to 4 products: chilling, freezing, sub-cooling and optional respiration heat, with each product's share.

Transmission

Up to 4 surfaces from insulation thickness and conductivity, with film coefficients and an outside temperature per surface.

Doors and infiltration

Door openings by a published doorway exchange-flow method with humidity, passages and open time, plus air changes for other leakage.

Internal loads

People, lighting, motors, evaporator fans and defrost heat, each over its own hours.

24-hour profile

Peak hour, average load and load factor, and the plant capacity for your compressor run hours, in kW and TR.

Compressor and brine

Indicative compressor power and condenser heat from your COP or a Carnot fraction, and the chilled water or brine flow.

Built for engineers

  • Visible formulas — nothing hidden, so you can check every step.
  • Fully referenced — methods from the standard references, checked against their published worked examples.
  • Safe to share — sheets are protected against accidental edits, with an open password so you can still customise.
  • Built-in input checks — clear warnings for impossible inputs and values outside typical ranges.

For engineering estimates; verify against site data. Code-based methods are aligned with the publicly documented procedure; they are not a licensed reproduction or a certification.

Preview the workbook

An illustration of the sheet layout of this workbook, not a screenshot of calculated results. Select the image to enlarge it. For questions before you buy, email [email protected].

Refrigeration Cooling Load Calculation Excel workbook sample pages
Layout illustration (not a results screenshot).

Specification and checks

FormatExcel workbook (.xlsx), no macros
Versionv1.0
Works inExcel 2010 or later, Windows and Mac
UnitsSI, US and British, mixed freely
IncludesGuide tab with method and references, calculator, print-ready report
Checked againstAn independent Python model: the workbook was recalculated and compared with it in 153 runs: the default case, all 24 combinations of the selectors, 20 unit-system variants with every input and result unit switched, 29 valid edge cases and 79 blocked or invalid-input cases (blank, zero, negative, text and impossible inputs give a clear message and blank results, never an error value). 6,364 values compared, worst relative difference 1.9e-11, 0 formula errors.
Free versionTry the free humid air psychrometric calculator

Compatibility, licence and support

FileExcel workbook (.xlsx), no macros, version v1.0; works in Excel 2010 or later on Windows and Mac. Sheets are protected against accidental edits, with an open password so you can customise.
LicenceSingle user. A team licence (up to 5 named users) is 3 × the shop price; site licences on request — licence terms.
UpdatesUpdates to this major version are included; download them again from the link in your receipt.
SupportEmail [email protected] with your order number — questions on the method, your inputs or your results are welcome.
RefundsIf the tool does not work as described, or has an error we cannot fix, email [email protected] with your order number within 14 days of purchase and we will refund you in full. Refunds are not offered for a change of mind once a file has been downloaded. Read the full refund policy.