This category hosts engineering animated models in MS Excel. Excel is particularly valuable in engineering being inexpensive and ubiquitous. In my career I managed to solve difficult engineering problems by building animated simulations where engineers using other, much more expensive software, failed. Unlike dedicated engineering software, excel is not a “black box”, which means that you develop your models from scratch using basic principles, calculations and charting. This leads to a much better understanding and control of the problem.
Excel is a great software for engineering calculations because it can combine data tables, charts and even engineering formulas under the same application.As far as civil engineering is concerned, Excel can do regular calculations such as cost estimates, schedule and cost control, and markup estimation, as well as structural calculations of reactions, stresses, strains, deflections, and slopes. Excel can deal with difficult problems, charting, and report generation.
This is the third part of a tutorial about modeling logic gates in MS Excel 2003. This first model includes no delay or loading for the gates. This section creates user defined functions for each gate and uses these functions to upgrade the model. An auxiliary macro is created which measures the speed of the model in iterations/second. The model with… Read More... "Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#3"
This is the second part of a tutorial targeted at modeling logic gates in MS Excel 2003. The first part introduced the basic logic gates,, symbols and associated logic equations. This model includes no delay or loading for the gates. The following type of gates will are described: inverter, AND, NAND, OR, NOR, XOR (exclusive or) and XNOR. The tutorial has several parts… Read More... "Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#2"
This is the first part of a tutorial (self, 2, 3) about modeling logic gates in MS Excel 2003. This first model will include no delay or loading for the gates. The following type of gates will be described: inverter, AND, NAND, OR, NOR, XOR (exclusive or) and XNOR. The tutorial will have several parts and the last part will build up… Read More... "Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#1"
This is not a tutorial but a download post for a purely animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003. Read More... "An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#4"
This is the third part of a tutorial (1, 2, self) describing the creation of an animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003. Read More... "An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#3"
This is the second part of a tutorial (1, self, 3) describing the creation of an animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003. This part creates a very simple table type model based on combinatorial logic rather than a sequential type based on registers. Despite of the fact that this… Read More... "An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#2"
This is the first part of a tutorial (self, 2, 3) describing the creation of an animated Pseudo Random Number Generator model as a Fibonacci type Linear Feedback Shift Register in MS Excel 2003. Read More... "An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#1"
This is a video preview to a previously posted ray tracing model. Read More... "An Animated Ray Tracing Model for Spherical Mirrors – video preview"
A video preview to the animated melting snow castle model. [sociallocker][/sociallocker] Read More... "The Melting Snow Castle – video preview"
This is a preview to an older animated model simulating the heat conduction in a uniform square plate. [sociallocker][/sociallocker] Read More... "A 2D Animated Heat Transfer Model – video preview"
This is a preview to an older animated model simulating the heat conduction in a uniform rod. [sociallocker][/sociallocker] Read More... "A 1D Animated Heat Transfer Model – video preview"
This is a video preview for two older models included in this blog, a static model and a dynamic model. [sociallocker][/sociallocker] [sociallocker][/sociallocker] Read More... "Two Lissajous Models – a video preview"
This is a video preview of an animated triple spring mass damper system moving in a 2-dimensional space. The model will work in all versions of excel but it will be slow in 2007 and 2010. [sociallocker][/sociallocker] Read More... "An Animated 2D Spring Oscillator – video preview"
This is a video preview of the Simple Spring-Mass-Damper System model and the Double Spring-Mass-Damper System previously presented on this blog. [sociallocker][/sociallocker] [sociallocker][/sociallocker] Read More... "Animated 1D Spring Oscillators – video preview"