# Applications

## Engineering Mathematics

Calculus 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 Systems

Discrete 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

## Finance

Technical 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 Scheduling

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

## Instrumentation & Control

PI 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

## Simulators

Simulation 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).

Simulation of a Programmable Logic Controller (PLC): Simulation of a PLC running ladder logic

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 & 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 using charts