Version 21.1 by Mengting Qiu on 2024/09/02 16:49
Show last authors
1 **~ Table of Contents:**
2
3 {{toc/}}
4
5
6
7 = 1. Instroduction =
8
9
10 This chapter shows how to perform linear calibration.
11
12
13 = 2. Linear calibration =
14
15
16 In some case, the measurement and real value are in different range, but they are both linear, we have to calculate the real value with the measurement we can use a simple Linear Calibration.
17
18
19 == 2.1 Solve the linear relationship manually ==
20
21
22 (% style="color:blue" %)**Example:**(%%) we have a water level probe, the measurement range is 0 ~~ 10 meters, and the output is 4~~20mA, this means the when the water level is 0 meter, the output is 4mA, when the water level is 10 meters, the output is 20mA.
23
24 We can make a coordinate axis as below:
25
26 1. (% style="color:#4f81bd" %)**Y**(%%) axis is the real value, from 0~~10 meters
27 1. (% style="color:#4f81bd" %)**X**(%%) axis is the probe output , from 4~~20mA
28
29 We use two points to make the linear line: Point1(x1,y1) = (4,0), Point2(x2,y2)= (20,10).
30
31 Since the reading is linear, all (% style="color:#4f81bd" %)**probe output**(%%) and (% style="color:#4f81bd" %)**real value**(%%) is on this line, so we can calculate the real value by probe output in two steps:
32
33 * **Step1:** Get (% style="color:#4f81bd" %)**realk(Slope)**(%%) for the line:
34
35 k=(y2-y1)/(x2-x1) = (10-0)/(20-4) =10/16= 0.625
36
37 * **Step2:** Get (% style="color:#4f81bd" %)**real value( y )**(%%):
38
39 k =(y-y1)/(x-x1)  
40
41 ~-~-> y = k*(x-x1)+y1 = 0.625 * (x-4) + 0.
42
43 ~= 0.625 * (x-4)
44
45 Thus, we can introduce x-values to the already obtained equations to derive the corresponding y-values：
46
47 When x=12 mA , y=5 meters
48
49 When x=8 mA, y=2.5 meters
50
51
52 A more general formular:
53
54 (% style="color:#4f81bd" %)**Y=(y2-y1)/(x2-x1)* (x-x1) + y1**
55
56
57 Calibration Curve Schematic：
58
59 [[image:image-20240902114541-1.png||height="336" width="596"]]
60
61
62 == 2.2 Performing linear calibration curves in Excel ==
63
64
65 In addition, we can also perform calibration curves in Excel and directly obtain linear equations by statistics of X and Y values.
66
67 Citing the same example above, (% style="color:#4f81bd" %)**X**(%%) and (% style="color:#4f81bd" %)**Y**(%%).
68
69
70 === Step 1: Create chart ===
71
72
73 A simple spreadsheet with two columns: X values and Y values.
74
75 [[image:image-20240902160516-1.png||height="404" width="561"]]
76
77 * Start by selecting the data you want to plot in the chart.
78 * First, select the X-Value column cell, then press the Ctrl key, and finally click the Y-value column cell.
79
80 [[image:image-20240902160755-2.png||height="394" width="562"]]
81
82 * Go to the "Insert" TAB, navigate to the "Chart" menu, and then select the first option in the "Scatter" drop-down list.
83 * A chart will appear with the data points in the two columns.
84
85 [[image:image-20240902161202-3.png||height="453" width="824"]]
86
87 * Right-click on one of the blue dots and select the “Add Trendline” option.
88
89 [[image:image-20240902161711-4.png||height="490" width="681"]]
90
91 * A straight line will appear on the chart.
92 On the right side of the screen, the Format Trendline menu will appear. Check the boxes next to “Show formulas on chart” and “Show R-squared values on chart”.
93 The R-squared value is a statistic that tells you how well the line fits the data. The best R-squared value is 1.000, which means that every data point touches the line.
94
95 Because the ideal data example is used, the R-squared value in this case is 1. As the difference between the data points and the line increases, the R-squared value decreases, with 0.000 being the lowest possible value.
96
97 [[image:image-20240902161857-5.png]]
98
99
100
101
102 = 3. Case examples =
103
104
105 Some case for example which we can use Linear Calibration:
106
107
108 (% style="color:blue" %)**Case 1: Calibrate Microwave Radar Readling.**
109
110 The microwave radar reading might effect by the OUM(Object Under Measured), but the reading still linear. In this case, we can measure the closest(x1,y1) and the farthest point(x2,y2). Where the x is reading in platform, y is the real value. And use above method to calibrate.
111
112
113 (% style="color:blue" %)**Case 2: Calibrate the Soil EC base on SE01 soil sensor raw EC reading.**
114
115 The SE01 probe is calibrated via mineral soil. The reading for other soil will be different by still in linear, In this case, we can measure two points (x1,y1) and (x2,y2). Where the x is reading of Raw EC, y is the real EC for the soil. And use above method to calibrate
116
117
118 (% style="color:blue" %)**Case 3: use water level probe to calibrate for oil.**
119
120 Oil has different density vs water, but we can still use the immersion type water level pressure sensor to get the oil level. In this case, we can measure two points (x1,y1) and (x2,y2). Where the x is reading of water level, y is the oil level. And use above method to calibrate
121
122
123 (% style="color:red" %)**Notice for Linear Calibrate:**
124
125 1. k(Slope) is very important, We can measure more points to calculate the most accuracy k.
126 1. Make sure the mapping is linear, and choose two calibrate points as "far" as possible.
127
128

Applications

Navigation

Copyright ©2010-2024 Dragino Technology Co., LTD. All rights reserved
Dragino Wiki v2.0