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. 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 user defined functions proves to be much slower than the model using plain built-in spreadsheet functions.