Simulation of 1-D DiffusionDescription| How it works
This app simulates diffusion process in one dimension. It makes use of the powerful conditional formatting and support for large number of colours in Excel 2007 and later. This app will not work in Excel 2003.
Download.xlsx file (16 KB)
How to UseIf a column of liquid is held in a narrow tube closed at one end and lowered into a dye, how long would it take for the dye to diffuse through the liquid? A really long time, as this simulation shows.
Key in the diffusivity and the time since lowering of the tube into the coloured cells and observe how the colours in the tube change showing how much dye has diffused into the liquid. For typical values of diffusivity in liquids, it could take YEARS for the dye to diffuse to the top!! (In this simulation, the column of liquid is assumed to be 2 cm tall.)
Also See:Batch Scheduler
Animation without Charts
Psychedelic Mandelbrot Set
Chemical Reaction Kinetics