Tools

Engineering Mathematics

Function Analysis: Excel tool that can plot a given function and simultaneously, its integral and first derivative. A nice tool for learning single variable calculus.

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

Parametric Function Plotter: Tool for plotting parametric equations

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

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

Coupled ODE Solver: Tool for solving upto 10 coupled Ordinary Differential Equations. This tool can also be used for solving Differential Algebraic Equations and Partial Differential Equations.

Sequences and Series: Tool for plotting upto 1000 terms of a sequence and the corresponding series.

Linear Equation Solver: Tool for solving upto 20 simultaneous equations

Non-linear Equation Solver: Tool for finding multiple real solutions of a non-linear equation

Simultaneous Non-linear Equation Solver: This is a template that uses the Solver tool in Excel to solve a set of non-linear equations

Descriptive Statistics: This tool is a dynamic version of the Descriptive Statistics and histogram tools provided in Excel's Analysis ToolPak .

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)

Bode Plot using Complex Functions: Tool for generating a Bode plot for a rational polynomial transfer function upto order 5

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 (n₁s + n₂) / (s² + d₁s + d₂)

Filter Analysis and Simulation: Tool for study of first and second order filters in the time and frequency domains

Image Processing: Tool that runs image processing alogrithms

Finance

Technical Stock Analysis: Tool for analysing historical stock data using Moving Average Convergence Divergence (MACD) plots

Returns from non-periodic cash flows: Template for calculating the internal rate of return (IRR) and net present value (NPV) of an investment that generates non-periodic cash flows. Calculations are updated automatically when new data is added

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

Simulation of On Off Control: Simulation of a control loop consisting of a first order process with time delay and an On Off controller (also known as Bang-Bang controller).

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

Simulation of a Model Predictive Controller: Simulation of an MPC on a first order process with time delay

Oscilloscope / Function Generator Simulator: Simulation of a single channel analog Oscilloscope connected to a Function Generator

Simulation of Diffusion in 1 Dimension: Simulation of a dye diffusing up a liquid column. This tools works in Excel 2007 or later (will not work in Excel 2003).

Art & Animation

Expecto Petronam!: Lightning from a wand created using the glow effect in Excel 2010 charts. Inspired by the Harry Potter series :)

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

Psychedelic Mandelbrot Set: Conditional Formatting features of Excel 2007 and later are used to create these beautiful fractals

Animated Charts :  Creating animation with Excel charts

Animation without Charts : Creating animation without Excel charts