How It Works
This calculator works in 4 steps.
Paste or upload the records
Paste rows from a spreadsheet or upload a CSV file.
Map the columns
Match columns to name, C₁, C₂, V₂, and units.
Run the batch
The calculator solves each row and flags errors.
Export the results
Download CSV or print a worklist with totals.
The Formula
The formula applies C₁V₁ = C₂V₂ to every row and sums volumes by material.
V₁ᵢ = C₂ᵢ × V₂ᵢ / C₁ᵢV_dᵢ = V₂ᵢ − V₁ᵢΣ V₁ᵢ for rows sharing a stock- i:
- Row index
- C₁ᵢ / C₂ᵢ:
- Stock and target for row i
- V₂ᵢ:
- Final volume for row i
A batch of 6 records returns stock volumes from 1 mL to 50 mL, with total diluent of 932 mL across all rows.
Conversion Table
The conversion table shows a 6-row sample batch with stock and diluent volumes per row (shared concentration unit per row).
| Record | Stock (C₁) | Target (C₂) | Final volume | Stock volume | Diluent |
|---|---|---|---|---|---|
| Buffer A | 10 | 1 | 500 mL | 50 mL | 450 mL |
| Buffer B | 5 | 1 | 250 mL | 50 mL | 200 mL |
| Std 1 | 1,000 | 50 | 100 mL | 5 mL | 95 mL |
| Std 2 | 1,000 | 10 | 100 mL | 1 mL | 99 mL |
| Reagent X | 100 | 2 | 50 mL | 1 mL | 49 mL |
| Reagent Y | 20 | 0.5 | 40 mL | 1 mL | 39 mL |
What Is the Batch Dilution Calculator?
The Batch Dilution Calculator is a tool that processes many dilution records at once, from a pasted list or an uploaded CSV file, and returns stock and diluent volumes for every row. Each row carries its own stock, target, and volume.
Batch processing saves time when a day's work includes dozens of solutions. The calculator validates each row, flags impossible rows (target above stock), sums the total stock and diluent per material, and exports the result as CSV or a printable worklist.
Common Uses
There are 5 main uses of this calculator.
Daily preparation lists
Technicians compute all solutions for the day at once.
Standard sets
Analysts compute full calibration sets from one list.
LIMS exports
Users process records exported from a LIMS.
Core facility orders
Core labs process customer reagent orders.
Production schedules
Plants compute batches across a production week.