<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=345831125832216&amp;ev=PageView&amp;noscript=1">
  • ISO - International Organization .jpeg

How To Build A Calibration Curve

Posted by The Metrologist on Mar 28, 2017 7:01:00 AM
The Metrologist

 

 

Calibration curves

Sometimes we need to characterize the behavior of a sensor for its measurements to be useful. This is especially true in the world of strain gages that output a millivolt signal proportional to the voltage input based on the amount of stress they are placed under. For our example, today we are going to look at creating a calibration curve for a 2 mV/V-100 PSI pressure transmitter.

Gather Data

how to build a calibration curve alliance calibration.png

First, we will apply pressure and record the output millivolt readings. We will also monitor the excitation voltage throughout the process since knowing the millivolt per volt value relies on the voltage part of the equation. We will enter this data into an excel spreadsheet, leaving column A blank because it will make the graph we will be using later easy to set up.

Calculate the mv/v

how to build a calibration curve calculate the mv alliance calibration.png

To calculate the mV/V readings we will concoct a small formula in excel to subtract the mV reading at zero PSI from the pressurized reading and divide it by the excitation voltage. This gives us our mV/V at each of the pressure test points.

Calculate zero & span

how to build a calibration curve zero span alliance calibration.png

The reported value for full-scale mV/V is simply the value we calculated for the full-scale pressure reading. To obtain the zero value divide the mV/V value by the excitation voltage.

Graphing the data

how to builda calibration curve graphing alliance calibration.png

Select the data.

how to build a calibration curve data alliance calibration.png

Insert a line graph. Having the mV/V data to the left of the pressure data saves us the step of having to flip the axis around.

 

how to build a calibration curve line alliance calibration.png

Right click on the line on the graph and click on “Add Trendline…” This will add a trendline to the graph. The default trendline is “linear,” and that matches our data well.

Calibration Curve Formula

how to build a calibration curve example alliance calibration.png

 When we added the trend line to the graph, the “format trend line” dialog will appear to the right of the screen in excel. Near the bottom check the box that says “display equation on chart.” Given the simplicity of the data we are dealing with you could choose to perform the calculation manually, but since excel will do it for me, I stick with excel. The formula will appear on the graph in the form of a y=mx+b format. Since we have the mV/V plotted on the “x” axis we can plug in our reading divided by the excitation voltage to calculate the pressure reading.

What if the function is not “linear”?

 

how to build a calibration curve non linear alliance calibration.png

Here is some data that has a curve to it when plotted. What should we do in this case?

 

how to build a calibration curve non linear trendline.png

We can go back to the “Format Trendline” dialog and choose one of the other trend line styles. In this case I chose polynomial, and it matches the data fairly well. We can compare the dotted trend line to our actual data in the chart.

How can we use this DATA?

Most modern data acquisition systems allow us to plug these formulas in and use them to interpret data from sensors. By building calibration curves for inexpensive sensors, we can use them to make measurements that might have been reserved for more expensive scalable sensors in the past.

How To Build A Calibration Curve

Technical Questions? Contact Us.

Topics: calibration

Don't Miss Another Article!

Click Here to Learn The Difference Between  Certification & Accreditation