#### Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#3

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.

Skip to content
# Excel Unusual

## Science, Engineering, Games in Excel

#
Basic tutorials

#### Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#3

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.

Read More >>
#### Introduction to Digital Electronics – a Simplified Model for Logic Gates – part#1

Read More >>
#### An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#2

Read More >>
#### An Animated Linear Feedback Shift Register (LFSR) as a Pseudo Random Pattern Generator in Excel 2003 – Part#1

Read More >>
#### A Basic Planetary System – video preview

Read More >>
#### Moment of Force and Torque Calculation

Read More >>
#### Newton Generalized Treatment

Read More >>
#### How Do They Fly? – an intuitive look into lift generation and flight stability

Read More >>
#### VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #2

Read More >>
#### VertX – a Very Useful Macro for Extracting the Vertex Coordinates of Freeforms – part #1

Read More >>
#### Excel Drawing – creating graphical object data

Read More >>
#### Introduction to Anaglyph Stereoscopy in Excel – part #5: adding a joystick to control the yaw and pitch rates of the 3D cube

Read More >>
#### Introduction to Anaglyph Stereoscopy in Excel – part #4: worksheet implementation of a stereoscopic cube

Read More >>
#### Introduction to Anaglyph Stereoscopy in Excel – part #3: a few analogies and the derivation of the stereoscopic 3D-2D perspective conversion formulas

Read More >>
#### Introduction to Anaglyph Stereoscopy in Excel – part #1: a more efficient composite rotation in the 3D Cartesian space

Read More >>
#### The Easy Way of Solving Systems of Linear Equations in Excel – using the INVERSE() spreadsheet function

Read More >>
#### MDETERM() & MINVERSE() – two important Excel spreadsheet functions for matrix manipulations

Read More >>
#### TRANSPOSE() & MMULT() – two important Excel spreadsheet functions for matrix manipulations

Read More >>

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.

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.

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.

Since not everybody has Excel and more and more people are on the dumbed down new versions (2007 and 2010) I am presenting these previews to give the readers a feel of the real speed and feel of some of the models in older Excel versions (in this case 2003). This preview refers to an older model.

This is an addition to a previous post, introducing the reader to different ways of calculating the moment of a force and the torque of a couple. This information will be useful in aircraft dynamics models.

Most of people have heard of Newton’s second law, mass, moment of inertia or the definition of the acceleration both linear and angular. The stuff presented here is elementary (9th grade), yet it is generally not properly understood. What happens when one applies a bunch arbitrary forces on an arbirtarily shaped body? The resultant force vector produces a linear acceleration while the resultant torque produces a resultant angular acceleration around…

Have you ever wondered why the flight attendants of a half empty airliner talk people into moving to the front half of the plane? Have you ever wondered why a flying wing can fly without a tail or why the stability of some of these flying wing can be controlled only by computer? Or why a 12 pack stored in at the back of a Cessna can make the plane unstable……

The first macro created in this section of the tutorial improves on the previously developed macro by correcting the up-down orientation of the shape, referencing the shape position to the coordinate of the first drawn point and closing the shape by repeating the coordinates of the first point at the end of the table. A last macro is then created which can retrieve multiple shape vertex coordinates, placing them in a table…

Using autoshape freeforms is a very easy way to duplicate object outlines from pictures. It is convenient to create a freeform and once created, its vertices (points) can be edited with without difficulty. Aditional points can be inserted and others can be deleted. This is a tutorial about a series of macros which allow the extraction of freeform vertex coordiantes to a worksheet range in Excel. These coordinates can be later employed to create 3D wireframe…

This tutorial will introduce the reader to creating simple drawings in Excel by using the “Freeform” auto shape. Later on, we will be able to convert this data in x-y-z vertex information for various models by using a macro.

In this section, a joystick is added to the model which controlls the yaw rate and the pitch rate (not the angles!) of the stereoscopic cube. This joystick was used before in a dedicated tutorial and in the flight simulator tutorial. Its importance in future models can not be underestimated, hence I decided to cover this virtual device again. Use your 3D glasses while running the mkodel.

This is the final part of the anaglyph stereoscopy tutorial. This part deals with the prectical implementation of the concepts and formulas discussed before to create a 3D cube. You need 3D glasses to notice the stereoscopic effect. 0

This section of the tutorial gives few more real life applications of the stereoscopic vision and also derives the stereoscopic 3D-2D perspective conversion formulas. These formulas are based on the approximation that the that both right and left eyes observe the same v-coordinate.

I made a stereoscopic model in October last year, however, choosing the wrong colors (red and blue on a black background, the effect was very weak (if any). This series was suggested to me last week by one of the guests here on the website, Don L. (thanks Don!), who sent me his stereoscopic cube. I opened the model, put on my goggles and his cube literally popped out of the…

This brief tutorial explains how to calculate the solution vector of a system of linear equations using the Excel spreadsheet function MINVERSE() which calculate the inverse of a matrix.

This is a brief tutorial showing how to calculate the determinant of a matrix and the inverse of a matrix using two special spreadsheet functions MDETERM() and MINVERSE().

This is a tutorial introducing two important matrix manipulation spreadsheet functions in Excel: the matrix transposition function TRANSPOSE() and the matrix multiplication function MMULT(). These functions are a bit harder to use than the regular spreadsheet functions in the sense that the result is a matrix and a matrix cell range is treated by the program as a unity (you cannot change the formula since you cannot operate on a single cell). There are some…