Basic Simulator in Excel - Piston Engine

This is the most basic simulator model of a piston engine built on Excel VBA Framework.

by Kamal C Bharakhda
Excel VBA DEVELOPER & Reports Automation SpecialistFollow

3 reviews422 views|Start the discussion!|Bookmark download for free

Description
This is my first attempt to develop a Simulator within an excel using VBA. Here you can notice I have tried to customize the parameters of the internal combustion piston engine. Only two parameters as of now.

1. Moving Forward Reverse
2. Increase or Decrease the Speed

But the most important question is why in Excel only?

Because...

Excel is cheap and ubiquitous, everyone has it.
Excel is a good environment to do complex programming
As opposed to regular programming languages, Excel is a two-dimensional programming canvas
Excel has decent built-in graphics (I like using 2D scatter plots)
Excel is a matrix calculator and it’s wickedly fast
Excel has decent GUI capabilities within the program itself
Programming in Excel gives you more understanding of physical processes than “black box” type programs such as Matlab, Simulink, Octave since in Excel you build everything from basic formulas

The Idea and courage to develop these models in excel I received from Mr. George Lungu a founder of www.excelunusual.com

This Best Practice includes
1 Excel based Simulator Model