Engineering MathematicsCalculus of a Single Variable: Excel application that plots a given function and simultaneously, its integral and first derivative
Multifunction Plotter: Application to plot upto 5 different functions on the same graph.
Parametric Function Plotter: Application for plotting parametric equations
First order ODE Solver: Application for solving 1st order ODE of the form y' + y a(x) = b(x)
Second order ODE Solver: Application for solving 2nd order Ordinary Differential Equations with constant coefficients.
Coupled ODE Solver: Application for solving upto 10 coupled Ordinary Differential Equations. This app can also be used for solving Differential Algebraic Equations and Partial Differential Equations.
Sequences and Series: Application for plotting upto 1000 terms of a sequence and the corresponding series.
Linear Equation Solver: Application for solving upto 20 simultaneous equations
Non-linear Equation Solver: Application 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: Dynamic version of the Descriptive Statistics and histogram tools in Excel
Signals and SystemsDiscrete Fourier Transform: Application for analyzing the frequencies contained in a given signal.
FIR Filter Analysis: Application for computing the frequency response of an FIR filter with upto 30 coefficients
Bode Plot Generator: Application for generating a Bode plot given a transfer function of the form (a+bs)e-ts/(g+hs)
Bode Plot using Complex Functions: Application for generating a Bode plot for a rational polynomial transfer function upto order 5
Nyquist Plot Generator: Application for generating a Nyquist plot given a transfer function of the form (a+bs)e-ts/(g+hs)
Nichols Plot Generator: Application for generating a Nichols plot given a transfer function of the form (a+bs)e-ts/(g+hs)
Laplace to Time Domain Converter: Application for displaying step response of a system whose Laplace transform is (n1s + n2) / (s2 + d1s + d2)
Filter Analysis and Simulation: Application for study of first and second order filters in the time and frequency domains
Image Processing: Application that runs image processing alogrithms
FinanceTechnical Stock Analysis: Application 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 SchedulingBatch Scheduler: Brute force application for scheduling batches to minimize production times
Instrumentation & ControlPI Control of First Order Process: Application 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: Application for analysing performance of a feedback control system consisting of a Proportional and Integral (PI) controller and an integrating process
Ziegler Nichols Tuning Calculator: Application to calculate the tuning paratmeters using the closed loop Ziegler Nichols tuning rules
RGA Calculator: Application to work out the Relative Gain Array used in multivariable control design
Instrument Loop Drawings: Application for generating instrument loop drawings in PDF format
Data Sheets: Application for generating instrument datasheets in PDF format. The template can be modified to generate data sheets for other devices or products
Instrument Callibration Chart: Generates a callibration table and chart for instrument transmiiter callibration and loop check
Excel OPC Client: Application for getting real time data into Excel using OPC
SimulatorsSimulation of a logic circuit for alarming: An animated simulation of a boolean circuit that generates audio and visual alarms
Little Man Computer: Simulation of the Little Man Computer (LMC) Model of a 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.
Simulation of Pendulum Waves
Art & AnimationExpecto 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 using charts