Interactive Excel simulations for exploring physics concepts — collected from various sources, some home-made. Open in Excel or Google Sheets and adjust the parameters to see the physics respond in real time.
Mechanics & Motion
Stopping Distances
Models thinking distance, braking distance, and total stopping distance as a function of speed. Explore the non-linear relationship and the effect of reaction time.
↓ DownloadTerminal Velocity — Parachute Simulation
Simulates a falling parachutist with adjustable mass, drag coefficient, and canopy area. Shows approach to terminal velocity and the step-change when the parachute deploys.
↓ DownloadOscillations & Waves
Spring Energy Simulation
Models kinetic and potential energy of a mass on a spring through a full oscillation cycle. Useful for visualising energy exchange in SHM and verifying conservation of energy.
↓ DownloadSimulated Damped Oscillations
Generates displacement–time curves for underdamped, critically damped, and overdamped systems. Adjustable damping constant — compare regimes and see energy lost per cycle.
↓ DownloadThermal Physics
Cooling and Insulation Simulation
Models Newton's law of cooling with adjustable initial temperature, ambient temperature, and cooling constant. Compare insulated and uninsulated objects and fit to real calorimetry data.
↓ DownloadElectricity & Magnetism
Coils on an Electromagnet
Simulates the magnetic field strength of a solenoid as turns and current vary. Explore B ∝ nI and the effect of a ferromagnetic core.
↓ DownloadNuclear Physics & Radioactivity
Half-Life Simulation
Models exponential radioactive decay with adjustable decay constant. Plots N vs t and ln(N) vs t so students can extract the half-life graphically.
↓ DownloadInteger Dice Decay
A spreadsheet analogue of the classic dice experiment — demonstrates how random individual events produce smooth exponential decay in aggregate.
↓ DownloadDecay Series Simulation
Simulates a chain of radioactive decays (parent → daughter → granddaughter). Shows how each nuclide's activity grows and falls — useful for discussing secular equilibrium.
↓ DownloadRadioactive Background Exposure Charts
Sources and proportions of background radiation exposure. Good for contextualising dose and discussing natural vs artificial sources.
↓ DownloadUK Radiation Exposure Data
Real UK population data on annual radiation doses broken down by source — radon, medical, cosmic, food. Useful for quantitative discussions of risk and dose.
↓ DownloadNuclear Structure
Binding Energy Curve (2021)
Plots binding energy per nucleon against mass number. Annotates the iron-56 peak, nuclides suitable for fusion, and nuclides suitable for fission.
↓ DownloadBinding Energy Curve (Complete)
A more comprehensive binding energy dataset with additional nuclides and a fuller range of mass numbers. Useful for comparing specific isotopes.
↓ DownloadAstrophysics
Radio Telescope Data
Signal intensity data from a radio telescope observation. Process the data to reconstruct a basic intensity map, linking to resolution, wavelength, and aperture synthesis.
↓ Download