As
previously posted, most physicians, staff, and volunteers at AHS and affiliate organizations are or have already switched to using Microsoft 365 (M365) web apps, and these web apps function differently in some ways than the desktop versions. Up to now, many clinical calculators commonly used in Connect Care workflows run Excel macros that are based on desktop Excel files. Unfortunately, these calculators do not work when opened in the web app version of Excel.
Starting October 14, 2025, the calculators listed below - used for weight-based medication dosing, fluid calculations, and titration protocols for pediatric patients (under 18 years old) - will transition to web-accessible versions, to ensure compatibility across devices. Users will no longer need to download or store local copies, and should delete any locally saved copies of the old versions. Prescribers can access the web-based calculators via the sidebar (details below).
Calculators Moving to Web-based Versions
- Provincial: D10% Pediatric DKA Calculator; D12.5% Pediatric DKA Calculator; LHMF Calculator; NEONATAL potassium chloride calculator
- Calgary:
- NICU: Emergency Medications and Controlled Intubation Calculator; Multiple Dextrose Infusions, Set TFI and Glucose Infusion Rate Calculator
- Pediatric: Emergency Medication Calculator - ED; Emergency Medication Calculator - General ED / UCC; Extended Interval Aminoglycoside Dosing Calculator; Glucose Infusion Rate Calculator; Potassium Administration Calculator
- PICU: Code Sheet; Tube Feed Catch Up Calculator
- Covenant: Emergency Drug Calculator
- Edmonton:
- NICU: David Schiff Emergency Drug Calculator; Fluid Management Calculator; Total Fluid Intake and Glucose Infusion Rate Calculator; Y-site Glucose Calculator
- NICU PCE/SCH NICU: Emergency Drug Calculator
- NICU/PICU: Intranasal Emergency Drug Calculator
- Stollery: Dialysate & Replacement Labels; ECMO Flow Calculator; PICU Emergency Drug Calculator; PICU Transport Meds Calc Sheet
How to Access
- Prescribers can access the new web-based versions of the above calculators by navigating to the Sidebar Summary, clicking on "Scores" (top of sidebar, middle of right column), and selecting the applicable calculator (click the camera icon below for a screenshot). Note the above listed calculators are all pediatric and will only show for patients under the age of 18.
- The calculator will open in a private browser window, where details can be entered to complete the calculation (example screenshot below).
- If required, print by pressing Ctrl + P after the calculation is complete.
- Note: Nurses/Respiratory Therapists/Unit Clerks can access the calculators via their Universal or ED Learning Home Dashboard (under “Patient Care Resources”).
Having Trouble with an Excel Calculator?
If you use an Excel-based calculator that no longer works after the switch to M365 and/or does not have a web-based version available, we need your help to ensure continued access. This may be an issue particularly with shared "thin client" workstations that only run Connect Care and not other desktop applications.
If your calculator is missing or not functioning, submit a request using
this Insite form. Include the following in your request:
- An unlocked version of the Excel calculator file
- Where it was previously accessed
- A brief description of its clinical use case
Once your request is submitted, your calculator will be converted into a supported web-based version, reviewed for accuracy and clinical relevance, and linked from Connect Care.
