## Modeling atomic diffusion and polymerization – coding an Excel animated model

part#1 part#2 part#3 part#4Continue Reading

## Electric Motor & Air Compressor Excel Animation – Dynamic simulation demo/preview

This is a model I made quite some years back to model the stability of an air compressor driven by an electric motor. The purpose was also to try to select the motor parameters, transmission ratios, energy loss in the flexible couple. I will make the Excel file available at a later date.Continue Reading

## About the Speed of Spreadsheets #2

This is the second post on Excel speed. This has serious implications in creating usable Excel animations. The first part benchmarked the calculation speed of Excel 2003 versus Excel 2007 for various size arrays of formulas. This part analyzes the effect of formula complexity on the spreadsheet speed. About the speed of animated models in MS Excel – part #2Continue Reading

## About the Speed of Spreadsheets #1

This post considers several aspects about improving the speed of spreadsheets in both MS Excel 2003 and 2007. It has significant effects on animations in MS Excel. In this first part, a “stopwatch” macro is described which, when incorporated in any of calculation loop, can measure the frequency your loop is executed. In this first part of the tutorial theContinue Reading

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

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 whichContinue Reading

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

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 worksheetContinue Reading

## Excel Drawing – creating graphical object data

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. [sociallocker][/sociallocker] Drawing in Excel – part #1 – an introduction tocreating freeform type autoshapes – On this blog we will soon need toContinue Reading

## Cosmos Naive – a very basic demo of anaglyph stereoscopy with sprites in Excel

Reach out for your 3D goggles because this is a representation of the Cosmos through the eyes of a 5-year old. The model displays a few objects at various depths and move two of them back and forth on a chart to demonstrate the stereoscopic effect. Though very simplistic it is an excellent example of anaglyph stereoscopy in action showing youContinue Reading

## A Solver for Systems of Linear Equations in Excel

This is a linear system of equations solver in Excel. The size of the system is programmable by the user from 2 to 20 which means, depending on the setting selection, the model can instantly find the solution of linear systems starting from 2 equations and 2 unknowns up to 20 equations and 20 unknowns. It uses the following built-inContinue Reading

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

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. [sociallocker][/sociallocker] Solving linear systems of equations in Excel – the easy way by George Lungu – This is a tutorial showing an easy and convenient method of solving moderate size systemsContinue Reading

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

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(). [sociallocker][/sociallocker] MDETERM() & MINVERSE() – two important Excel spreadsheet functions for matrix manipulations by George Lungu – Using Excel built-in matrix operation functions might improve calculation efficiency but it definitely makes modelContinue Reading

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

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 theContinue Reading

## Playing Sounds in Excel Using VBA – part #2

This section explains how to create a compound sound effect from elementary sounds. In the first example (two macros), the sound is played in a loop which is a native internal loop within the “PlaySound” function (using the flag option: SND_LOOP = &H8). A second function (the “Beep” function) creates a tone generator with adjustable frequency and play time. The Beep functionContinue Reading

## Playing Sounds in Excel Using VBA – part #1

This tutorial is an introduction to VBA sound playing macros in Excel. The sound effects can be used in various scientific and engineering models or in games. It first shows the general syntax of a sound playing macro and few sources of downloading free .wav sound files. The first demo macro plays a short sound a single time and theContinue Reading