Abstract
Abstract: :
Purpose:Develop a spreadsheet for the analysis of the Farnsworth-Munsell 100 hue test. Methods:Using Microsoft Excel, published formulae were applied to spreadsheet format to analyze Farnsworth-Munsell 100 Hue test data. Results:Using the circular plot capabilities of Excel, the "modified polar coordinate format" of plotting color confusion can be applied. The graphic display included plotting the "polarity of axis" as an aid for major axis analysis. Comparison of previously published data show equivalent plots and error scores. Previously published programs perform less complete data analysis and examine fewer functions. The spreadsheet calculates the color vision error score with statistical comparison to published norms, "binocular error," plots the polarity transformation for the colors of Major Axis, provides data suitable for comparison of multiple patients and provides data output for use in graphics programs. Data entry has been facilitated through the use of barcodes affixed to the back of the back of the Farnsworth-Munsell 100 hue test caps. Data collection and analysis of Farnsworth-Munsell 100 hue test is essentially instantaneous. Conclusion:Use of the spreadsheet in a clinic setting for 2 years has shown that it accelerates the analysis of genetic protan and deutan, and the acquired tritan and tritanomolous errors. Plots of the transformation of the colors of Major Axis, provided ready axis classification information. The spreadsheet format overcomes many of the limitations of older programming-graphics languages (basic, or Fortran with early versions of DOS), to provide a flexible Excel-based analysis system. There is no longer a need to create program or printer specific drivers. Software copies will be available, or may be obtained via FTP://128.227.22.34, login as anonymous, with your E-mail address as the password, or login as guest, with password = eyeguest
Keywords: 362 color vision • 358 clinical laboratory testing • 385 degenerations/dystrophies