Constant Rate Infusion (CRI)

Excel Formulas › Veterinary & Pet Care

All versions

A CRI delivers a drug continuously at a dose per kg per hour. The amount of drug added to the fluid bag is back-calculated from the dose, weight, and how long the bag should last.


Quick formula: drug to add to the bag:
=dose_per_kg_hr * weight_kg * hours / drug_conc
Total drug over the bag's run time (dose × weight × hours) divided by concentration gives the mL of drug to add.

The example

2 µg/kg/min context shown as mg/hr.

AB
1ItemValue
2Dose × wt × hrstotal drug
3÷ concentration→ mL to add

The formula

The formula:

=dose_per_kg_hr * weight_kg * hours / drug_conc_mg_ml // total drug ÷ concentration

How it works

How it works:

  1. Total drug needed = dose/kg/hr × weight × hours the bag runs.
  2. Divide by the drug concentration (mg/mL) for the volume of drug to add.
  3. Keep units consistent — convert µg to mg and minutes to hours first.
  4. Set the fluid pump rate so the bag empties over the intended hours.

Educational use only — not veterinary or medical advice. Dosing, fluid rates, and protocols must be set and verified by a licensed veterinarian for the individual patient. Always double-check against the drug label and a current formulary.

Try it: interactive demo

Live demo

Dose (mg/kg/hr), weight, hours, drug mg/mL.

Drug · Add

Variations

Total drug (mg)

Before volume:

=dose_per_kg_hr * weight_kg * hours

µg/kg/min to mg/kg/hr

Unit convert:

=ug_kg_min * 60 / 1000

Pump rate

Bag ÷ hours:

=bag_volume_ml / hours

Pitfalls & errors

Unit conversions. µg→mg (÷1000) and min→hr (×60) before the formula.

Bag run time. Match the pump rate so the bag lasts the intended hours.

Not advice. CRIs must be calculated and checked by a veterinarian.

Practice workbook

📊
Download the free Constant Rate Infusion (CRI) practice workbook
A CRI sheet with the total-drug, unit-convert, and pump-rate variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate a CRI in Excel?
Total drug over the run, divided by concentration: =dose_per_kg_hr * weight_kg * hours / drug_conc_mg_ml gives the mL of drug to add to the bag.
How do I convert µg/kg/min to mg/kg/hr?
Multiply by 60 and divide by 1000: =ug_kg_min * 60 / 1000.
How do I set the pump rate?
Divide the bag volume by the intended hours: =bag_volume_ml / hours.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Drug dose by body weight · IV fluid rate · Health unit conversions