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.

xlsx

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.

↓ Download
xls

Terminal 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.

↓ Download
xls

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.

↓ Download
xlsx

Simulated Damped Oscillations

Generates displacement–time curves for underdamped, critically damped, and overdamped systems. Adjustable damping constant — compare regimes and see energy lost per cycle.

↓ Download
xls

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.

↓ Download
xls

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.

↓ Download
xls

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.

↓ Download
xls

Integer Dice Decay

A spreadsheet analogue of the classic dice experiment — demonstrates how random individual events produce smooth exponential decay in aggregate.

↓ Download
xlsx

Decay 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.

↓ Download
xlsx

Radioactive Background Exposure Charts

Sources and proportions of background radiation exposure. Good for contextualising dose and discussing natural vs artificial sources.

↓ Download
xls

UK 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.

↓ Download
xls

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.

↓ Download
xls

Binding Energy Curve (Complete)

A more comprehensive binding energy dataset with additional nuclides and a fuller range of mass numbers. Useful for comparing specific isotopes.

↓ Download
xlsx

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