Spreadsheet-based algorithm for objective assessment of depth of focus from defocus curves

Purpose: To describe and clinically evaluate a spreadsheet-based algorithm for reproducible depth-of-focus (DoF) calculation, incorporating rule-based continuity detection derived from defocus-curve topology. Setting: Humanitas Clinical and Research Center, Rozzano, Milan, Italy. Design: Methodological description with retrospective clinical validation. Methods: The algorithm identifies dioptric crossings of a predefined logMAR threshold by locating bracketing points and applying linear interpolation. Validation involved analyzing defocus curves (−4.0 to +1.5 diopters [D] in 0.50-D steps) from monofocal pseudophakic eyes and comparing automated results with manual measurements by 2 experienced operators. Logic was implemented to classify continuous and discontinuous (multimodal) profiles and flag out-of-range data. Results: 30 pseudophakic eyes implanted with monofocal intraocular lenses were included. DoF ranged from 1.10 to 3.17 D (mean 1.92 ± 0.47 D). Agreement between the algorithm and the 2 operators was high, with mean differences of −0.01 D (SD 0.08) and 0.00 D (SD 0.05), respectively. The interoperator difference was 0.01 D (SD 0.09). Mean absolute error was Conclusions: The proposed method ensures objective and reliable DoF quantification by minimizing subjective interpretation and manual workload. Although clinical validation focused on monofocal profiles, the topology-based continuity logic provides a structured approach for analyzing complex curve profiles. A template spreadsheet is provided for implementation.