RTD and Thermocouple Sensor Calibration Report Template
Compare a temperature sensor with a reference thermometer in a dry block or bath at several temperatures. The sheet calculates the error in °C and checks it against the tolerance you set.
Download
- How to Use sheet with steps
- Template sheet, blank and ready
- Example sheet, filled in
- 28 built in formulas
- A4 landscape print setup
- Works in Excel, Google Sheets and LibreOffice
Preview of the Filled Example
This is the Example sheet from the download, so you can see exactly how the completed rtd and thermocouple sensor calibration report looks.
Calibration results
| Point | Set temperature (°C) | Reference (°C) | Sensor as found (°C) | As found error (°C) | As found result | Raw value (Ω or mV) | Stable (yes/no) | Remarks |
|---|---|---|---|---|---|---|---|---|
| 1 | 0.0 | 0.02 | 0.10 | 0.08 | PASS | 100.040 | Yes | |
| 2 | 100.0 | 100.05 | 100.21 | 0.16 | PASS | 138.590 | Yes | |
| 3 | 200.0 | 199.96 | 200.30 | 0.34 | PASS | 175.980 | Yes | |
| 4 | 300.0 | 300.08 | 300.52 | 0.44 | PASS | 212.180 | Yes | Near limit |
About the RTD and Thermocouple Sensor Calibration Report
Temperature sensors cannot be adjusted, only checked. A comparison calibration against a reference thermometer in a dry block or bath shows whether the sensor still meets its class, and records raw values for diagnosis.
How to fill in this template
- Enter the sensor type and tolerance, for example IEC 60751 class A at the highest test temperature.
- Insert sensor and reference in the dry block at the same depth.
- At each set point wait for stability, then record reference and sensor readings.
- Record the raw Ω or mV value to help diagnose faults.
- Review errors and decide: accept, correct in transmitter, or replace.
What the formulas do
- Error (°C) = sensor reading − reference reading.
- PASS when |error| ≤ tolerance.
Related tools
Frequently Asked Questions
What tolerance should I use for a class A Pt100?
± (0.15 + 0.002 |t|) °C, so ± 0.35 °C at 100 °C and ± 0.75 °C at 300 °C.
Why use a reference thermometer instead of the dry block display?
The block display measures the block, not the hole the sensor is in; a reference reduces uncertainty.
Can I calibrate a thermocouple the same way?
Yes, set the tolerance from the IEC 60584 class and record mV as the raw value.
Learn more on the blog
Thermocouple calibration: 7 proven steps
A practical guide on instrumentationblog.in that explains the procedure behind this template and how engineers apply it on real plants.
Read Full Article