How to calculate a serial dilution
Each stage receives a measured transfer from the previous solution and an amount of diluent. For the first stage, the transfer comes from stock. If volumes add and the diluent has none of the tracked solute, the mixed volume is transfer plus diluent.
Stage concentration = previous concentration × transfer volume ÷ mixed volume.
Stage dilution factor = mixed volume ÷ transfer volume.
Multiply the stage factors to get the cumulative dilution factor. This is the same solute-conservation idea as the dilution equation in OpenStax Chemistry 2e. Enter all volumes in one common unit. Concentration keeps the unit selected for stock.
Two tenfold dilutions from 100 mM stock
Mix a modeled 1 mL transfer with 9 mL diluent. The first stage is 10 mL at 10 mM. Moving 1 mL onward leaves 9 mL at 10 mM in stage one. Adding that transfer to 9 mL diluent in stage two produces 10 mL at 1 mM. The cumulative factor is 10 × 10 = 100.
Mixed volume and retained volume
Mixed volume includes everything in the stage before the next transfer. Retained volume subtracts what goes to the next stage. If there is no next transfer, the retained and mixed volumes are equal. Removing a well-mixed aliquot leaves the concentration of what remains unchanged.
Turn on the stock check to compare the first transfer with the entered stock supply. Turn on the minimum retained-volume check to see which stages fall below your threshold. The worksheet rejects a transfer larger than the modeled amount in the previous stage.
When the model applies
This worksheet assumes uniform mixing, additive volumes and a diluent free of the tracked solute. It compares the values you enter. It supplies no chemical handling, clinical dosing, organism growth or experimental validation. Use a method appropriate for your material.