Skip to main content

Computer based approach to graphical analysis: A Microsoft Excel application

1 May 2003


This Graphical Analysis program was designed using both Microsoft Excel and Visual Basic for Applications. The primary purpose for the creation of this program was to provide both the optometric student and the established clinician with a quicker, more efficient, and flexible means of utilizing traditional reserve-demand systems of case analysis for educational, clinical and research purposes. Presently, the complete application of graphical analysis and comfort criteria is largely confined to academic settings since it can be unacceptably time consuming. In the fast paced world of modem vision care, it is understandable why many case analysis systems have been largely ignored or forgotten. Granted, some analysis of optometric data and application of comfort criteria can be applied without using difficult calculations; however, it is the belief of the author that a more comprehensive use of analysis systems will be possible in clinical settings via the utilization of this and other computer based systems of analysis. In fact, it is proposed that the conscientious student and practitioner will be able to utilize the tools contained in this program to arrive at more informed management decisions in shorter amounts of time. By simply entering examination data, the clinician/student is allowed to view an instant graphical plot of the patient's data as well as calculations of Sheard's, Percival's and Saladin's comfort criteria. In addition, there is a separate section designed for the use of Pratt's criterion via both graphical and numerical methods. For the student, this program provides an effective means for learning the relationships of accommodation and vergence and exploring the theories behind lens and prism therapy in the alleviation of nonstrabismic binocular vision disorders. For the established clinician, this program provides an efficient means of determining data reliability, quickly calculating possible lens and/or prism prescriptions, and electronically archiving analyzed patient data.


Files are restricted to Pacific University. Sign in to view.