The four approaches
| Web calculator | Spreadsheet formula | In-app calculator | By hand | |
|---|---|---|---|---|
| Cost | Free | Free | Varies | Free |
| Needs setup | No | Yes, once | Yes, once per vial | No |
| Remembers the vial | No | Yes, if modelled | Yes | No |
| Recalculation needed daily | Yes | No | No | Yes |
| Attached to a dose log | No | If built | Yes | No |
| Available at the vial | If a phone is to hand | Rarely | Yes | Yes |
| Error surface | Re-entry each time | The formula, written once | The setup, entered once | Every calculation |
Web calculators
A free web calculator is the right tool for a one-off question: checking a figure, sanity-testing a dilution before committing to it, or working out what a vial would look like at a different concentration. No account, no setup, immediate answer. The reconstitution calculator on this site is exactly this.
The limitation is structural rather than fixable: it is stateless. Three numbers go in every single time, and the error surface is that re-entry, the same fields typed daily, each one an opportunity to transpose a digit or misremember whether it was 2 mL or 3 mL.
Spreadsheet formulas
A formula in a spreadsheet is written once and holds. Vial parameters live in cells, the unit figure updates when they change, and the logic is visible and auditable, a genuine advantage over any tool where the arithmetic is hidden.
The risk is concentrated in that one authoring moment. A misplaced factor of a thousand in a concentration formula produces plausible-looking numbers forever, applied silently to every row. It is worth checking a formula against a hand-worked example once, at the start.
In-app calculators
An in-app calculator is set up per vial rather than per calculation. Strength and diluent volume are entered at reconstitution, and from then on the unit figure is a property of the vial rather than something derived on demand.
That changes the failure mode usefully. There is exactly one moment where an error can enter, which is the setup, and after that no re-entry, so no drift. The trade is a tool that has to be installed and, for anything beyond the free tier, paid for.
By hand
Worth mentioning because it is the fallback everyone eventually uses, and because the arithmetic is genuinely simple enough. It is also where mcg/mg slips live. If a figure is worked out by hand, the sanity check is the dose count: vial strength divided by dose should give a plausible number of doses. A 5 mg vial that appears to hold 2,000 doses has a thousandfold error in it.
Choosing
- A one-off question, or comparing dilutions. A web calculator, every time. No reason to set anything up.
- An ongoing protocol with a spreadsheet already in use. Extend the spreadsheet, and verify the formula against a hand-worked example once.
- An ongoing protocol logged on a phone. An in-app calculator, so the number stays attached to the vial and the log.
- Multiple vials at different concentrations. Anything stateful. This is where stateless re-entry reliably goes wrong.
