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

05/08/2011

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. [sociallocker][/sociallocker]

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

05/07/2011

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.

#### Introduction to Anaglyph Stereoscopy in Excel – part #2: the principles of creating and viewing 3D pictures

05/06/2011

This tutorial explains the basic principles of creating and displaying anaglyph pictures.

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

05/04/2011

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…

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

04/24/2011

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]

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

04/13/2011

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]

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

04/11/2011

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…

#### A 2D Random Walk Animation Tutorial

03/26/2011

This tutorial explains how to build two animated random walk models, one where the particle is confined to square grid and one where the particle is free to step in any direction. The first model is adequate for modeling particle movement in solids while the second is more fit for modeling particle diffusion motion in fluids. [sociallocker][/sociallocker]

#### Animated Heat Transfer Modeling for the Average Joe – part #4

03/20/2011

This is the last tutorial of the series and it shows how to implement the previously derived formulas into a spreadsheet model. The spreadsheet formulas, the macros and charting of the dynamic data is explained. [sociallocker][/sociallocker]

#### Animated Heat Transfer Modeling for the Average Joe – part #3

03/19/2011

This section shows how to model heat transfer in a linear bar by dividing it in elementary sections in which the basic linear equations introduced in the previous tutorials can be used.