Implementation of Automated Calculation of Free and Bioavailable Testosterone in Epic Beaker Laboratory Information System. Journal of pathology informatics Chung, M. C., Gombar, S. n., Shi, R. Z. 2017; 8: 28

Abstract

Automated calculations by laboratory information system (LIS) are efficient and accurate ways of providing calculated laboratory test results. Due to the lack of established advanced mathematical functions and equation logic in LIS software, calculations beyond simple arithmetic functions require a tedious workaround. Free and bioavailable testosterone (BT) calculations require a quadratic solver currently unavailable as ready to use the function on most commercial LIS platforms. We aimed to develop a module within the Epic Beaker LIS to enable automatic quadratic equation solving capability and real-time reporting of calculated free and BT values.We developed and implemented an advanced calculation module from the ground up using existing basic calculation programming functions in the Epic Beaker LIS. A set of calculation variables were created, and mathematical logic and functions were used to link the variables and perform the actual quadratic equation based calculations. Calculations were performed in real-time during result entry events, and calculated results populated the result components in LIS automatically.Free and BT were calculated using instrument measured results of total testosterone, sex hormone binding globulin, and/or serum albumin, by applying equations widely adopted in laboratory medicine for endocrine diseases and disorders. Calculated results in Epic Beaker LIS were then compared and confirmed by manual calculations using Microsoft Excel spreadsheets and scientific calculators to have no discrepancies.Automated calculations of free and BT were successfully implemented and validated, the first of such implementation for the Epic Beaker LIS platform, eliminating the need of offline manual calculations, potential transcription error, and with improved turnaround time. It may serve as a model to build similarly complex equations when the clinical need arises.

View details for PubMedID 28828199

View details for PubMedCentralID PMC5545775