December 2002
Volume 43, Issue 13
ARVO Annual Meeting Abstract  |   December 2002
Windows - Excel based Data Analysis of Farnsworth-Munsell 100 hue Color Vision test
Author Affiliations & Notes
  • BL Jordan
    Ophthalmology College of Medicine Univ of FL Gainesville FL
  • H Tabandeh
    Ophthalmology College of Medicine University of Florida Gainesville FL
  • WW Dawson
    Ophthalmology College of Medicine University of Florida Gainesvill FL
  • Footnotes
    Commercial Relationships   B.L. Jordan, None; H. Tabandeh, None; W.W. Dawson, None. Grant Identification: Support: Dr. Martin & Edith L. Horowitz Memorial Fund and Research to Prevent Blindness
Investigative Ophthalmology & Visual Science December 2002, Vol.43, 1184. doi:
  • Views
  • Share
  • Tools
    • Alerts
      This feature is available to authenticated users only.
      Sign In or Create an Account ×
    • Get Citation

      BL Jordan, H Tabandeh, WW Dawson; Windows - Excel based Data Analysis of Farnsworth-Munsell 100 hue Color Vision test . Invest. Ophthalmol. Vis. Sci. 2002;43(13):1184.

      Download citation file:

      © ARVO (1962-2015); The Authors (2016-present)

  • Supplements

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://, 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 

This PDF is available to Subscribers Only

Sign in or purchase a subscription to access this content. ×

You must be signed into an individual account to use this feature.