Refrigerant Charge by Line Length

Excel Formulas › HVAC & Field Service

All versions

A system holds a factory charge plus extra refrigerant for line sets longer than a baseline. Adjusted charge = factory charge + (extra feet × per-foot adder).


Quick formula: total charge for a line set:
=factory_charge + MAX(line_ft - baseline_ft, 0) * oz_per_ft
Factory charge plus the per-foot adder for line length beyond the baseline (often 15 ft).

The example

6 lb factory, 40 ft line, 15 ft base.

AB
1ItemValue
225 extra ft × 0.6 oz15 oz
3Total→ ~6.94 lb

The formula

The formula:

=factory_charge_oz + MAX(line_ft - baseline_ft, 0) * oz_per_ft // factory + extra-length adder

How it works

How it works:

  1. Start with the factory charge (in ounces; 1 lb = 16 oz).
  2. Add (line length − baseline) × per-foot adder — MAX floors it at zero.
  3. The per-foot adder comes from the equipment data plate (e.g. 0.6 oz/ft).
  4. Always weigh in the charge and verify by superheat/subcooling — never guess.

Weigh the charge, then verify — the formula is a starting point. The line-length adder gives the target charge to weigh in, but final charge is confirmed by superheat (fixed orifice) or subcooling (TXV) against the manufacturer’s spec. Overcharging and undercharging both wreck efficiency and shorten compressor life. Recover and weigh; don’t top off by gauge pressure alone. This is illustrative, not an EPA/handling procedure.

Try it: interactive demo

Live demo

Factory charge (lb), line length, baseline, oz/ft.

Add · Total

Variations

Added ounces

Extra length:

=MAX(line_ft - baseline_ft, 0) * oz_per_ft

Total in pounds

Convert oz:

=factory_charge + added_oz/16

Per-foot from data plate

If charge per total:

=total_adder_oz / extra_feet

Pitfalls & errors

Floor at zero. Short line sets add nothing — MAX.

oz vs lb. Keep units straight (16 oz = 1 lb).

Verify by SH/SC. Weigh in, then confirm by superheat/subcooling.

Practice workbook

📊
Download the free Refrigerant Charge by Line Length practice workbook
A charge sheet with the added-oz, total-lb, and per-foot variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate refrigerant charge for a line set in Excel?
Factory charge plus the length adder: =factory_charge_oz + MAX(line_ft - baseline_ft, 0) * oz_per_ft.
What's the per-foot adder?
From the equipment data plate — often around 0.6 oz/ft beyond the baseline length.
Is the calculated charge final?
No — weigh it in, then verify by superheat or subcooling against the manufacturer's spec.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: CFM airflow per ton · Cooling load & tonnage · Material with waste