This Excel spreadsheet has been developed as a companion tool forthe JCRS guest editorial:
Wang L, Koch DD, HillWE,Abulafia A. Pursuing perfection in intraocular lens calculations: III. Criteria for analyzing outcomes. Journal of Cataract and Refractive Surgery2017; 43(8): 999-1002.
It will automatically generate up to 4histograms(based on up to 4 different formulas) of the predicted postoperative spherical equivalent (SEQ)numerical errors. Also shown in this figure are the percentages of eyes with prediction errors less than or equal to 0.25 D, 0.50 D,and 1.00 D; and mean numerical error (MNE), standard deviation (SD), minimal prediction error (Min), maximal prediction error (Max), mean absolute prediction error (MAE),and median absolute prediction error (MedAE).