Related Experiment Video
Updated: Feb 24, 2026
Author Spotlight: Advances in Evaluating Human Lung Epithelial Cells' Response to Metal-Organic Frameworks
Published on: May 26, 2023
Implementation of Automated Calculation of Free and Bioavailable Testosterone in Epic Beaker Laboratory Information
Michael C Chung1, Saurabh Gombar1,2, Run Zhang Shi2
1Stanford Health Care, 300 Pasteur Drive, Palo Alto, CA 94304, USA.
Background:
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.
Materials And Methods:
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.
Results:
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.
Conclusions:
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.
