Free engineering calculators and unit convertersceo@instrumentationblog.in
Level and Tanks · Free Excel Calculator

DP Level Transmitter Range Calculator

Calculate the calibration range of a DP level transmitter for an open tank, dry leg or wet leg installation, including the head of the impulse lines below the tappings. A 5 point calibration table is generated automatically.

Excel (.xlsx)Worked exampleWorks offlineFree, no sign up

Download

  • Calculator sheet with a worked example
  • How to Use sheet with steps
  • 19 built in formulas, no macros
  • Yellow input cells, grey results
  • Calculation sign off block
  • Excel, Google Sheets and LibreOffice

Worked Example

These are the results of the example already filled in the workbook. Replace the yellow cells with your own data.

ConfigurationWet leg
Process liquid density (kg/m³)1000
Minimum level above HP tap (m)0
Maximum level above HP tap (m)3
Distance between taps, wet leg height (m)3.5
Wet leg fill density (kg/m³)1000
Transmitter below HP tap (m)0.5
Output unitmbar
LRV (mbar)−343.23
URV (mbar)−49.03
Span (mbar)294.20
Zero conditionZero elevation

Calibration points

Level (%)Level above HP tap (m)Applied DP (mbar)Output (mA)Reading
00.000−343.234.00
250.750−269.688.00
501.500−196.1312.00
752.250−122.5816.00
1003.000−49.0320.00
Advertisement

About this Calculator

Getting LRV and URV wrong is the most common commissioning fault on DP level transmitters, especially with wet legs where both values can be negative. This workbook applies the hydrostatic equation to each side of the transmitter and produces the calibration points directly.

Basis: Hydrostatic pressure P = ρ g h with standard gravity 9.80665 m/s². Heights measured from the HP tapping.

How to use

  1. Choose the configuration: open tank or dry leg, or wet leg.
  2. Enter the process density, and the minimum and maximum level measured from the HP (lower) tapping.
  3. For a wet leg enter the distance between the tappings and the fill fluid density.
  4. Enter how far the transmitter sits below the HP tap (0 if level with it).
  5. Use LRV and URV to range the transmitter; apply the DP values in the table during calibration.

Formulas used

  • DP = ρp g (h + x) − ρs g (Hs + x) for a wet leg; the second term is 0 for an open tank or dry leg.
  • LRV at minimum level, URV at maximum level; span = URV − LRV.
  • Positive LRV is zero suppression, negative LRV is zero elevation.

Related tools

Advertisement

Frequently Asked Questions

Why are the LRV and URV negative with a wet leg?

The wet leg on the LP side is taller than the liquid on the HP side for most of the range, so the DP (HP − LP) is negative.

What is zero suppression?

A positive LRV, typically because the transmitter is mounted below the lower tap with liquid filled lines.

Which density should I use?

The density at operating temperature. A change in density changes the reading in proportion.

You May Also Like

Learn more on the blog

DP level transmitter calibration: zero suppression and zero elevation

A practical guide on instrumentationblog.in that explains the engineering behind this workbook.

Read Full Article

More Excel Calculation Tools