Pt100 and Pt1000 Resistance Table Generator
Generate an IEC 60751 resistance table for Pt100 or Pt1000 sensors, with class A and class B tolerance at each temperature, and convert a measured resistance back to temperature.
Download
- Calculator sheet with a worked example
- How to Use sheet with steps
- 278 built in formulas, no macros
- Yellow input cells, grey results
- Calculation sign off block
- Excel, Google Sheets and LibreOffice
Worked Example
These are the results of the example already filled in the workbook. Replace the yellow cells with your own data.
Resistance table
| Temperature (°C) | Resistance (Ω) | Class A tolerance (± °C) | Class B tolerance (± °C) | Class A band (± Ω) | Class B band (± Ω) | R ÷ R0 | Notes |
|---|---|---|---|---|---|---|---|
| −50 | 80.306 | 0.25 | 0.55 | 0.099 | 0.218 | 0.80306 | |
| −40 | 84.271 | 0.23 | 0.50 | 0.091 | 0.198 | 0.84271 | |
| −30 | 88.222 | 0.21 | 0.45 | 0.083 | 0.177 | 0.88222 | |
| −20 | 92.160 | 0.19 | 0.40 | 0.075 | 0.157 | 0.92160 | |
| −10 | 96.086 | 0.17 | 0.35 | 0.067 | 0.137 | 0.96086 | |
| 0 | 100.000 | 0.15 | 0.30 | 0.059 | 0.117 | 1.00000 | |
| 10 | 103.903 | 0.17 | 0.35 | 0.066 | 0.136 | 1.03903 | |
| 20 | 107.793 | 0.19 | 0.40 | 0.074 | 0.155 | 1.07794 | |
| 30 | 111.673 | 0.21 | 0.45 | 0.081 | 0.174 | 1.11673 | |
| 40 | 115.541 | 0.23 | 0.50 | 0.089 | 0.193 | 1.15541 | |
| 50 | 119.397 | 0.25 | 0.55 | 0.096 | 0.212 | 1.19397 | |
| 60 | 123.242 | 0.27 | 0.60 | 0.104 | 0.230 | 1.23242 |
… and 34 more rows in the download.
About this Calculator
Technicians need Pt100 values constantly when checking sensors and simulating inputs. This workbook generates the IEC 60751 table with tolerances, for Pt100 or Pt1000, and converts resistance back to temperature.
Basis: IEC 60751 Callendar Van Dusen equation: R = R0 (1 + A t + B t² + C (t − 100) t³), C used below 0 °C only. A = 3.9083 × 10⁻³, B = −5.775 × 10⁻⁷, C = −4.183 × 10⁻¹².
How to use
- Enter R0: 100 for Pt100 or 1000 for Pt1000.
- Read resistance, tolerances and Ω bands at each temperature.
- Enter a measured resistance to get the temperature (0 °C and above).
- Print the table as a field reference.
Formulas used
- R = R0 (1 + A t + B t²) for t ≥ 0 °C; add C (t − 100) t³ below 0 °C.
- Class A: ± (0.15 + 0.002 |t|) °C; class B: ± (0.3 + 0.005 |t|) °C.
- Inverse for t ≥ 0: t = (−A + √(A² − 4B (1 − R/R0))) ÷ 2B.
Related tools
Frequently Asked Questions
What is the resistance at 100 °C?
138.506 Ω for Pt100 and 1385.06 Ω for Pt1000.
Why is the C term only below 0 °C?
IEC 60751 defines the curve with A and B above 0 °C and adds C below 0 °C.
Can I use this for Pt500?
Yes, enter R0 = 500.
Learn more on the blog
What is an RTD and how it works
A practical guide on instrumentationblog.in that explains the engineering behind this workbook.
Read Full Article