A few Excel sheets I built over the years for lab and analytics work — free to use instead of sitting around unused.
| Title | Description | Download |
|---|---|---|
| Density and Molar Mass of a Gas | Experiment A01 | Download .xlsx |
| Molar Mass of an Easily Vaporizable Liquid | Experiment A02 | Download .xlsx |
| Gas Thermometer | Experiment A03 | Download .xlsx |
| Viscosity of Gases | Experiment A11 | Download .xlsx |
| Viscosity of Liquids | Experiment A12 | Download .xlsx |
| Oxidation of Iodide by Peroxodisulfate | Experiment A22 | Download .xlsx |
| Photometric Measurement of the Decay of Manganese(III) Oxalate | Experiment A23 | Download .xlsx |
| Electrical Conductivity of Aqueous Solutions | Experiment A32 | Download .xlsx |
Disclaimer: these spreadsheets were made privately, for fun, loosely inspired by my work in the pharmaceutical industry. They were rebuilt from memory in my own time. Everything here is provided as-is, with no warranty or guarantee of accuracy, completeness, or fitness for any particular purpose — use at your own risk. Some sheets are protected; if Excel asks for a password, just leave the field blank and confirm.
| Title | Download |
|---|---|
| Assay Titration by Hand | Download .xlsx |
| Dienogest — Residual Solvents | Download .xlsx |
| Dry Residue | Download .xlsx |
| Estradiol — Purity & Residual Solvents | Download .xlsx |
| Estriol — Assay & Purity | Download .xlsx |
| Insoluble Substances | Download .xlsx |
| Levonorgestrel — Purity (Impurities A,B,H,K,M,O,S,U) | Download .xlsx |
| Levonorgestrel — Purity (Impurities V,W) | Download .xlsx |
| Mobile Phase Calculator for HPLC (also available as a web tool) | Download .xlsx |
| Progesterone — Purity & Residual Solvents | Download .xlsx |
| Relative Standard Deviation (up to 12 values) | Download .xlsx |
| Residue on Evaporation | Download .xlsx |
| Testosterone — Residual Solvents | Download .xlsx |
| Triethanolamine — Purity & Assay Titration | Download .xlsx |