Skip to content

Latest commit

 

History

History
55 lines (37 loc) · 2.06 KB

README.md

File metadata and controls

55 lines (37 loc) · 2.06 KB
Raw

Excel Visual Basic for Applications Pharmacy Functions Library

Purpose and Features

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

Installation

Before reading the following instructions, please read the Privacy Policy and EULA.

  1. To install, download 'RxFxLibrary Add-In 1.5.xlam'
  2. Click the 'Developer' tab
  3. Click the 'Excel Add-ins' button
  4. Click the 'Browse...' button, and find the location of the file. The custom menu will be located under the 'Formulas' tab.

Compatibility

Microsoft Excel 2010+

List of Current Functions:

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

Sample Images