Chemistry Calculations with Spreadsheets

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Look up atomic weights with XLOOKUP, build the molar mass of glucose row by row, then get calcium nitrate's molar mass in one SUMPRODUCT.
• Convert between mass, amount of substance and number of particles for water, table salt and carbon dioxide.
• Find the mass percent of each element in calcium carbonate, then work out the empirical formula of ascorbic acid from a lab analysis.
• For N₂ + 3 H₂ → 2 NH₃ you convert both reactant masses to moles, find the limiting reagent and the theoretical yield of ammonia.
• For five batches of limestone decomposition (CaCO₃ → CaO + CO₂) you calculate the theoretical yield, the percent yield, the overall yield and the feed needed for a target.
• Calculate the molarity of a sodium hydroxide stock solution and plan four dilutions with C₁V₁ = C₂V₂.
• Convert pressure, volume and temperature of four gas samples into atm, L and K and calculate the amount of gas with n = PV / (RT).
• Calculate pH and pOH of strong acids and bases with LOG10, find an acid's concentration from a titration endpoint and chart the titration curve.