Engineers-Excel.com

     
Engineering using Spreadsheets

Tools

Engineering Mathematics

Function Analysis: Excel tool that can plot a given function and simultaneously, its integral and first derivative.

Multifunction Plotter: Tool to plot upto 5 different functions on the same graph.

Second order ODE Solver: Tool for solving 2nd order Ordinary Differential Equations with constant coefficients.

First order ODE Solver: Tool for solving 1st order ODE of the form y' + y a(x) = b(x)

Linear Equation Solver: Tool for solving upto 20 simultaneous equations

Parametric Function Plotter: Tool for plotting parametric equations

Coupled ODE Solver: Tool for solving upto 10 coupled Ordinary Differential Equations.

Signals and Systems

Discrete Fourier Transform: Tool for analyzing the frequencies contained in a given signal. 

Bode Plot Generator: Tool for generating a Bode plot given a transfer function of the form (a+bs)e-ts/(g+hs)

Nyquist Plot Generator: Tool for generating a Nyquist plot given a transfer function of the form (a+bs)e-ts/(g+hs)

Laplace to Time Domain Converter: Tool for displaying step response of a system whose Laplace transform is (n1s + n2) / (s2 + d1s + d2)

Image Processing: Tool that runs image processing alogrithms

Production Scheduling

Batch Scheduler: Brute force tool for scheduling batches to minimize production times

Process Control

PI Control of First Order Process: Tool for analysing performance of a feedback control system consisting of a Proportional and Integral (PI) controller and a first order process

PI Control of Integrating Process: Tool for analysing performance of a feedback control system consisting of a Proportional and Integral (PI) controller and an integrating process

Ziegler Nichols Tuning Calculator: Tool to calculate the tuning paratmeters using the closed loop Ziegler Nichols tuning rules

Simulators

Little Man Computer: An animated simulation of the Little Man Computer, a model to illustrate the working of a computer CPU

Binary Coded Decimal (BCD) to 7 segment display circuit: Simulation of a circuit that takes in a Binary Coded Decimal input and decodes it to drive a 7 segment LED display

PID Loop Simulator: Simulation of a control loop consisting of a first order process with time delay and a PID controller

Art & Animation

Digital Rain: Simulation of the digital rain effect, made popular by the movie Matrix

3 Wheel Spirograph: A simulation of the spirograph toy, it can simulate 2 or 3 wheels

Mandelbrot Fractal Generator: Excel is used for an unusual application - generating images of fractals

Animated Charts:  Creating animation with Excel charts