Templates

Chemistry spreadsheet templates

Calculation sheets for the bench. They compute molar mass from an element count, plan stock solutions and serial dilutions, find the limiting reagent and the theoretical and percent yield of a reaction, prepare buffers with the Henderson-Hasselbalch equation, and fit a linear calibration curve to read unknown concentrations from absorbance.

Atomic weights follow the IUPAC standard atomic weights (abridged values); pKa values are typical literature values at 25 °C. Real solutions deviate from ideal behavior, so confirm critical preparations with a measurement.

TemplateChemistry

Acid-base titration curve calculator

pH at every titrant volume for a strong or weak acid titrated with NaOH, with equivalence, half-equivalence and an indicator check.

5 tabs · 1,775 formulas

TemplateChemistry

Gravimetric moisture and solids worksheet

Calculate wet sample mass, dry sample mass, water mass lost, and wet-basis moisture percentage from tare, wet, and dry weighings.

2 tabs · 306 formulas

TemplateChemistry

Laboratory stock and expiry register

Track labeled laboratory stocks, remaining quantities, expiry dates, and days to expiry at a fixed review date.

2 tabs · 186 formulas

TemplateChemistry

Mass percent solution calculator

Calculate mass percent concentration from solute and solvent masses without assuming a solution volume.

2 tabs · 186 formulas

TemplateChemistry

Molarity and solute mass calculator

Calculate solution volume in liters, required solute moles, and weighed solute mass in grams from molar mass and target molarity.

2 tabs · 306 formulas

TemplateChemistry

Reaction percent yield worksheet

Compare theoretical product mass with measured product mass and account for entered purity.

2 tabs · 186 formulas

TemplateChemistry

Serial dilution planner

Calculate the concentration after each specified dilution step using transfer and diluent volumes.

2 tabs · 246 formulas