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 model… Read More... "MDETERM() & MINVERSE() – two important Excel spreadsheet functions for matrix manipulations"
Flight Simulator Tutorial #2 – basic airplane positioning, control surfaces and turn dynamics
This is the second part of a tutorial explaining the creation of an “in-cockpit” flight simulator (versus the remote control simulator) model in Excel 2003. This section introduces some basic piloting background and nomenclature. A Basic Flight Simulator in Excel #2 – airplane positioning, control surfaces and turn dynamics by George Lungu – This tutorial explains the basics of airplane… Read More... "Flight Simulator Tutorial #2 – basic airplane positioning, control surfaces and turn dynamics"
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 the… Read More... "TRANSPOSE() & MMULT() – two important Excel spreadsheet functions for matrix manipulations"
Flight Simulator Tutorial #1 – the joystick and a ground mesh
This is the first section of a tutorial explaining how to build a 3D flight simulator in Excel. This part deals with creating a joystick and a triangular ground mesh. The joystick model was explained in a previous post from January 2011 and the ground mesh was already used in the 3D roller-coaster. [sociallocker][/sociallocker] A Basic Flight Simulator in Excel #1 – using… Read More... "Flight Simulator Tutorial #1 – the joystick and a ground mesh"
Spectral Analysis – a Fourier transform tutorial – part #5
This part of the tutorial demonstrates the Fourier transform operation in a few cases of periodic and non-periodic signals, such as an AM signal, an FM signal, a rectangular non repetitive signal and a cardinal sine signal. The last slide contains an application to the scaling property of the Fourier transform on a non-repetitive time signal. It actually shows that… Read More... "Spectral Analysis – a Fourier transform tutorial – part #5"
Spectral Analysis – a Fourier transform tutorial – part #4
The previous sections explains the creation of a discrete Fourier transform model in Excel. This section and the following one will use the model to calculate and chart the Fourier transform in several cases of periodic and non-periodic signals. [sociallocker][/sociallocker] A Fourier Transform Model in Excel, part #4 by George Lungu – This is a tutorial about the implementation of… Read More... "Spectral Analysis – a Fourier transform tutorial – part #4"