Engineers-Excel.com


Engineering using Spreadsheets


This website shows how Excel can be used for engineering applications. Engineering students typically use software like MATLAB or MATHEMATICA during their studies in college but in the industry, most engineers only have Excel for crunching numbers. Excel is often seen as a business tool; but as this site shows, it is a powerful and versatile tool that can be used for a wide variety of engineering and numerical analysis.

Another objective of this site is to create an appreciation for the beauty of mathematics in general, and numerical analysis in particular. Mathematics is like art; it shows the power and beauty of the human imagination. It is very unfortunate that mathematics is often taught in a manner that creates dread in the students, but by showing how "difficult" mathematics can be done by simple operations in the rows and columns of a spreadsheet, it is hoped that at least a part of the fear will disappear. The "Engineering Mathematics" section on the Tools page shows how topics like algebra and calculus can be readliy understood with the aid of a spreadsheet.

Most of the tools on this site have been built using Microsoft Excel 2003. They will also work in Excel 2007 and Excel 2010.

For feedback and suggestions on this site, email mehta.nitin [AT] gmail.com.




This site featured on Microsoft's 'Office Show'

The Digital Rain Tool has been featured in an episode of 'The Office Show' produced by Microsoft. See the clip from the episode below.



Screenshots

Expecto Petronam
Lightning from a wand using the glow effect in Excel 2010 charts, see Expecto Petronam!

Filter Analysis and Simulation
A 2nd order Butterworth Filter removes high frequency noise from the input. See the tool: Filter Analysis and Simulation.



MACD
The Technical Analysis of Stocks tool creates a report from historical stock price data of a penny stock.
See more screenshots in Gallery.

Popular Picks

Modelling a drunkard's walk

A simple model of a computer's CPU

Animation using Excel Charts

How to learn Macros

Simulation of a PID Controller