Custom pharmacy functions enabling a user to calculate patient metrics, lab values, and drug dosing. With the Pharmacy Function Library, you can perform commonly used clinical pharmacy calculations. See a full list of the functions below.
If you are using this for clinical practice, please make sure you are using the correct units (metric vs US). All functions have been tested against multiple online calculators and hand calculations. Please use the functions at your own risk.
Documentation on all functions is located on the wiki in this repository.
If you do not see a specific function you need, please contact EszopiCoder at pharm.coder@gmail.com
Before reading the following instructions, please read the Privacy Policy and EULA.
- To install, download 'RxFxLibrary Add-In 1.5.xlam'
- Click the 'Developer' tab
- Click the 'Excel Add-ins' button
- Click the 'Browse...' button, and find the location of the file. The custom menu will be located under the 'Formulas' tab.
Microsoft Excel 2010+
Height and Weight
- Body Mass Index (BMI)
- Body Surface Area (BSA); Du Bois and Mosteller
- Ideal Body Weight (IBW); Devine
- Adjusted Body Weight (AdjBW); Devine
- Lean Body Weight (LBW)
- Ideal Body Weight under 60 inches (IBW); Baseline, BMI, Hume
Renal
- Creatinine Clearance (CrCl); Cockcroft-Gault and Salazar-Corcoran
- Estimated Glomerular Filtration Rate (eGFR); CKDEPI and MDRD
Diabetes
- Correction Factor Dosing
- Carbohydrate Counting Dosing
Pediatrics
- Adjusted Age (Corrected Age)
- Estimated Glomerular Filtration Rate (eGFR); Bedside-Schwartz
- Growth Chart Percentiles
Kinetics (Coming soon!)
- Vancomycin dosing
- Aminoglycoside dosing
