Excel tool for DP type level and density transmitter calibration range calculation

An Excel calculation tool for differential pressure (DP) can be highly useful for various aspects of level measurement, including open and closed level, interface liquid level, and density measurement when using a DP transmitter with the hydrostatic method.

Here are some key uses of such a tool for finding the calibration range of a DP transmitter:

• Excel provides for precise differential pressure calculations using the hydrostatic method.
• The tool can determine the predicted DP for different level and density data by inputting important information such as fluid densities, heights, and specific gravities. This precision is critical for calculating the DP transmitter’s calibration range.
• Excel allows you to study and evaluate many scenarios. Users can simulate alternative operating conditions and evaluate the appropriate DP range by modifying input parameters such as fluid densities, heights, or specific gravities.
• This aids in comprehending the range of DP values required to appropriately cover various measurement conditions.
• Users can visualize the link between DP and level/density data using Excel’s graphing tools. This graphical representation aids in estimating the DP transmitter’s operational range.
• Excel makes sensitivity analysis easier by allowing users to change specific parameters and see how they affect the calibration range.
• Users can test the sensitivity of the DP transmitter to changes in parameters such as fluid densities, heights, or specific gravities by varying these parameters. This analysis aids in identifying potential sources of error and factors that may affect the calibration range.

Excel file – DP type level transmitter calibration range calculation

The excel file consists of several sheets with various calculation applications, which are listed below.

1. Sheet No. 1 for Open Tank Level Measurement – Installed Transmitter in Open Tank
2. Sheet No. 2 for Closed Tank Level Measurement – Installed Transmitter in Closed Tank with Dry Leg
3. Sheet No. 3 for Closed Tank Level Measurement  – Transmitter Installed in Closed Tank with Wet Leg
4. Sheet 4 for Liquid Density Measurement – Transmitter Installed in an Open Tank With Constant Level
5. Sheet No. 5 for Liquid Density Measurement – Transmitter Connected to an Open Tank With Varying Levels
6. Sheet No. 6 for liquid interface level measurement – Transmitter Installed in Open Tank With Constant Overflow
7. Sheet No.7 for measuring liquid interface levels – Transmitter Installed in Closed Tank With Wet Leg

Download link

You can obtain the Microsoft Excel spreadsheet for DP type level transmitter calibration range calculation by using the URL that is provided below.