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.
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.
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
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 (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
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
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
Animation without Charts : Creating animation without Excel charts