Vial Inventory: Tracking Reconstituted Peptides Without Spreadsheet Chaos

Track four attributes per vial and the rest of your inventory becomes arithmetic: what is in it and at what strength, which diluent and how much you added, when it was first punctured, and how much volume remains. Concentration, remaining doses, and reorder timing all derive from those four.

Spreadsheets fail at this not because they lack features but because they require you to recompute derived numbers by hand every time something changes.

The vial record: four fields plus an identifier

A vial record describes a physical object, not a compound in the abstract. Two vials of the same peptide mixed differently are two different objects with different arithmetic, and your record has to treat them that way.

Lot number and expiration belong here too, carried over from the manufacturer's label before it becomes irrelevant. Once a vial is mixed, the label no longer describes its contents.

Concentration belongs to the vial, not the compound

Concentration is a property of a specific mixed vial. This is the conceptual mistake that produces most inventory confusion, because people store concentration as an attribute of the compound and then quietly reuse a stale number.

A 5 mg vial with 2 mL added is 2.5 mg/mL. The next 5 mg vial, mixed with 1 mL because that is what was left in the diluent bottle, is 5 mg/mL. If your system stores "Compound A = 2.5 mg/mL", every dose logged from the second vial is wrong by a factor of two while looking completely normal.

Storing concentration at the vial level fixes this structurally rather than through vigilance. Vitadel Protocol models it that way, and if you are checking a mix before committing it to a label, the peptide reconstitution calculator shows the concentration and per-dose volume side by side.

Remaining volume versus remaining doses

Remaining doses is remaining volume divided by dose volume, minus one for residual. Worked through end to end:

• A 5 mg vial reconstituted with 2 mL is 2.5 mg/mL.
• A 0.25 mg dose is 0.25 ÷ 2.5 = 0.1 mL, which is 10 units on a U-100 syringe.
• 2 mL ÷ 0.1 mL = 20 nominal doses.
• Subtract one for residual solution left in the vial and needle hub, and plan on 19.
• After eight logged doses, remaining volume is 2 − 0.8 = 1.2 mL, or about 11 usable draws.

Two things make this drift in practice. Air bubbles expelled during priming cost small amounts of solution, and doses given but not logged silently deplete the vial. Both are handled by logging waste as its own event type, so the record and the vial agree.

Also track it in volume, not doses, as the primary number. Doses change when a clinician changes the dose; volume does not.

Beyond-use dating versus expiration

Expiration and beyond-use dates answer different questions. The manufacturer's expiration date applies to the sealed, unmixed product under specified storage. A beyond-use date is a shorter limit assigned after mixing or first entry, and compounding standards derive it from process risk, whether the preparation is preserved, and storage temperature rather than from testing your particular vial.

Practical implications for a tracking system: store both dates, and treat the earlier one as the operative limit. Store the first-puncture timestamp, because that is the clock a beyond-use window runs on. And where the compound's own labeling states a post-reconstitution storage period, record that number per vial rather than applying one global rule to everything in the refrigerator.

Clarity, not clairvoyance, is the goal. Your record cannot tell you a vial is still good. It can tell you exactly how old it is and what is in it, which is what a pharmacist or clinician needs to answer the question.

Label the physical vial too

The vial needs to be identifiable while it is in your hand. Digital records are searchable but they are not attached to the object, and a refrigerator shelf with three similar vials is where mixups happen.

Put four things on a label: compound, concentration, first-puncture date, and the identifier that matches your record. Write it legibly with a leading zero on decimals and no trailing zeros, following the same dose-designation conventions that medication safety guidance recommends. If you use tape, put it where it will not obscure the solution, since being able to see cloudiness or particles is part of the check before every draw.

Deciding when to open the next vial

Reorder timing is a lead-time calculation, not a feeling. Convert remaining doses to remaining weeks, then compare against how long resupply takes.

If you have 11 usable draws at one per week, that is 11 weeks of supply. With a three-week lead time and a two-week buffer for problems, your reorder point is five weeks of supply remaining, which is about five draws. The signal to order arrives long before the vial looks empty.

Two adjustments matter. If a dose increase is anticipated, recompute in volume rather than doses, since a larger dose consumes the same vial faster. And if a vial's beyond-use window will expire before the volume runs out, the window is your real constraint and the reorder math should use it.

Multiple vials of the same compound

Never let two open vials of the same compound share an identity. Keep them numbered, log which one each dose came from, and finish one before opening the next unless there is a reason not to.

When a partial vial reaches its dating limit with solution remaining, the answer is disposal per local sharps and pharmaceutical waste guidance rather than stretching it or merging it into a fresh vial. Combining contents from separately entered vials is a compounding step with sterility implications, and it belongs to a pharmacist.

Why spreadsheets rot

Spreadsheets fail at vial tracking for structural reasons rather than through user error. Derived values like concentration and remaining volume have to be recalculated by hand or maintained with formulas that break when a row is inserted. There is nothing enforcing that a dose entry references a real vial. There is no reminder when a first-puncture date crosses a threshold. And the file lives somewhere you are unlikely to have open at 6 AM with a syringe in one hand.

The fix is not a better spreadsheet. It is a system where dose entries reference vials, remaining volume decrements automatically, and concentration is stored once at the vial level and never retyped.