Skip to Content
Last modified by Mengting Qiu on 2024/09/02 17:23
From version 7.1
edited by Mengting Qiu
on 2024/09/02 14:14
Change comment: There is no comment for this version
To version 8.1
edited by Mengting Qiu
on 2024/09/02 14:40
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -15,6 +15,10 @@
15 15  
16 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 17  
18 +
19 +== 2.1 Solve the linear relationship manually ==
20 +
21 +
18 18  (% 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.
19 19  
20 20  We can make a coordinate axis as below:
... ... @@ -55,7 +55,18 @@
55 55  [[image:image-20240902114541-1.png||height="479" width="851"]]
56 56  
57 57  
62 +== 2.2 Performing linear calibration curves in Excel ==
58 58  
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 +
68 +
69 +
70 +
71 +
72 +
73 +
59 59  = 3. Case examples =
60 60  
61 61  
... ... @@ -83,5 +83,4 @@
83 83  1. Make sure the mapping is linear, and choose two calibrate points as "far" as possible.
84 84  
85 85  
86 -
87 87