Desarrollo de una hoja de cálculo del impedimento auditivo usando Microsoft EXCEL

Abstract

In daily clinical practice, the results of audiometric tests often need to be converted into the percentage of hearing impairment in order to prepare health reports or to provide information requested by patients. Until now, manual systems have been used to calculate this percentage. To simplify and add precision to this calculation, we developed a spreadsheet using Microsoft Excel software and the American Academy of Otolaryngology's formula to determine hearing handicap. Compared with other systems, our spreadsheet provides two main advantages. First, it corrects the intrinsic problem of the original formula, which gives negative results in the presence of normal audiometries (values under 25dB) or results over 100 in the case of severe hypoacusis (values over 90dB). The second advantage is that there is no need to specify the best ear in order to calculate the global hearing handicap, thus avoiding the introduction of two values and saving 20% of the overall calculation time. In conclusion, we consider that the Excel spreadsheet, adapted for the evaluation of hearing handicap, could save time and be more accurate than manual methods, thus reducing the possibility of making mistakes.