Patient satisfaction and predictable refractive outcome in cataract surgery depends on accurate biometry and, as part of the validation process, it is advisable to ensure that any discrepancy in predicted intra-ocular lens (IOL) power between the two eyes is consistent with the difference in refraction [1].

We present here a spreadsheet developed for use in our local ‘Complex Biometry Clinic’, which accepts referrals where there is difficulty performing measurements or concern over their accuracy, including a significant discrepancy in lens power [2].

A 1 mm difference in axial length (AL) is known to result in ~2.35 dioptre (D) difference in refractive spherical equivalent, while a 1.0D difference in average keratometry (K) equates to a 1.0D difference in refraction, if vertex distance is ignored. Also, a difference of 3.0D in predicted lens power tends to reflect a 2.0D difference in pre-cataract refraction [3]. Our software uses these values to evaluate biometric accuracy, giving a colour-coded outcome.

Biometric and refractive data are entered: axial length, keratometry, spectacle refraction and predicted IOL power for emmetropia. It is important to enter the oldest available ‘pre-cataract’ refraction, as asymmetrical index myopia can influence results. The software calculates the predicted difference in refraction given the AL and K readings and compares this with the actual difference in spectacle refraction. The expected difference in IOL power for a patient with this difference in refraction is then compared with calculated IOL values.

For display purposes a nominal colour-coded outcome is generated for each of the two values, with green indicating a difference of less than 1.0, yellow between 1.0 and 2.0 and red greater than 2.0 (Fig. 1). If both values are green (less than 1.0) it indicates that there is a close match between the refraction, biometric values and predicted lens power for each eye. Higher values indicate that further assessment is warranted.

Fig. 1
figure 1

a a patient with 8.0D difference in IOL power accounted for by the difference in biometric values and consistent with refractive status, and b a patient with 2.5D difference in IOL power but probable error in biometric measurements

Current NICE guidelines [4] do not discuss methods of assessing the accuracy of lens power calculations, although the earlier Royal College ones [5] included various criteria for repeating biometry. These defined limits for AL and K readings and for the maximal acceptable difference between eyes, advising repeat measurements if values lay outside the range. However, biometry may still be correct in such cases and in these situations our software offers a rapid and easy method for validating results.

In conclusion, the spreadsheet presented here provides a useful supplementary method for assessing the accuracy of biometry, particularly in cases of anisometropia where the predicted lens power differs between eyes.