Free engineering calculators and unit convertersceo@instrumentationblog.in
Calibration · Free Template

pH Analyser Calibration Record Template

Record a two point pH calibration with buffer mV readings. The sheet calculates the electrode slope as % of the Nernst value, the offset, and checks buffer verification readings.

Excel (.xlsx)Printable PDFFilled exampleFree, no sign up

Download

  • How to Use sheet with steps
  • Template sheet, blank and ready
  • Example sheet, filled in
  • 26 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 ph analyser calibration record looks.

Tag numberAT 5101
ServiceEffluent pH
Buffer temperature (°C)25
Date25 Oct 2026
Buffer 1 pH7
Buffer 1 reading (mV)−4
Buffer 2 pH4.01
Buffer 2 reading (mV)165
Measured slope (mV/pH)56.52
Slope (% of theoretical)95.5
Offset at pH 7 (mV)−4.0
Electrode conditionGOOD

Buffer verification after calibration

NoBuffer pHAnalyser reading (pH)Error (pH)Tolerance (± pH)ResultBuffer lot / expiryRemarks
17.007.010.010.05PASSL2207 / 2027 03
24.014.030.020.05PASSL2194 / 2027 01
310.019.97−0.040.10PASSL2210 / 2026 12
Verification failures:0
Advertisement

About the pH Analyser Calibration Record

pH electrodes age and coat, which reduces their slope and shifts their offset. Recording both at every calibration shows electrode health over time and when to replace it.

How to fill in this template

  1. Clean and rinse the electrode.
  2. Place it in buffer 1 (pH 7), wait for stability and record mV; repeat with buffer 2.
  3. The sheet calculates slope %, offset and electrode condition.
  4. Calibrate the analyser, then verify in buffers and record readings.
  5. Replace the electrode if slope or offset is outside limits after cleaning.

What the formulas do

  • Slope = (mV₂ − mV₁) ÷ (pH₁ − pH₂).
  • Theoretical slope = 0.198416 × (T + 273.15) mV/pH.
  • Offset at pH 7 = mV₁ + (pH₁ − 7) × slope.

Related tools

Advertisement

Frequently Asked Questions

What slope is acceptable?

Many sites accept about 90 to 105 % of theoretical; follow your procedure and the maker advice.

Why is the slope negative in mV?

Electrode voltage falls as pH rises; this sheet reports it as a positive slope.

How often should pH be calibrated?

From daily to monthly depending on the process; trend slope and offset to set the interval.

You May Also Like

Learn more on the blog

Electrical conductivity explained

A practical guide on instrumentationblog.in that explains the procedure behind this template and how engineers apply it on real plants.

Read Full Article

More Calibration Templates

All Templates and Downloads