Excel is well-known for its most common uses, such as financial calculations and keeping of shopping lists. There is a wide range of scientific and engineering applications for Excel, and here are links to a very small portion of these. I can’t personally vouch for the accuracy of these models. This should be part of the user’s due diligence process.
If you know of any scientific and engineering applications for Excel that should be added to this list, please leave a link in the comments section below.
Physics
– Pendulum
– Particle Analysis
– Wave
– Projectile Trajectory
– Lorenz Attractor by Timothy Bard
Physclips: Mechanics with animations and video film clips fom the School of Physics at The University of New South Wales. Not done in Excel, but it might inspire me to add more examples.
Engineering
Free Excel/VBA Spreadsheets for Heat Transfer (and Fluid Mechanics, PDE’s, Thermodynamics and Numerical Methods, too)
Professor Robert J. Ribando
School of Engineering and Applied Science
University of Virginia
Newton Excel Bach, not (just) an Excel Blog
Among other topics, Doug Jenkins covers engineering applications of Excel, including structural analysis. Here are a few of Doug’s examples:
– UDFs for trigonometric functions
– Section Properties
– UDFs for elastic analysis of concrete
Diffusion Limited Aggregation by Timothy Bard
Estimating unpumped aquifer water levels by Keith Halford
ExcelCalcs
Helping You Make and Share Calculations with MS Excel
“Download our free XLC software which gives MS Excel the capability of displaying cell formulae as mathematical equations. Your worksheets will read like text books, they’ll be easy to understand and easy to check. Download worked solutions and solved problems from our Repository or ask for help in the Forum. It’s all free, so join our community and together let’s make it grow!”
Statistics
LOESS (locally weighted scatterplot smoothing)
– LOESS Smoothing in Excel
– LOESS Utility for Excel
Deming Regression
– Deming Regression
– Deming Regression>Deming Regression Utility