|  | InforShell Trend View

Spreadsheet Matrix Calculation
- Operation Overview

Matrix Formula Entry

Matrix Feature Overview Opening Trend View Spreadsheet Entering Data |  | Specifying Calculation Output Cell Specifying Matrices and Composing Formula Nested Matrix Operation Example

Matrix Feature Overview

The TrendView spreadsheet provides the following six common matrix operations: m_determ( ), calculate matrix determinant. m_inverse( ), calculate inverse matrix. m_minus( ), subtract two matrices to find difference. m_mult( ), multiply two matrices to find product. m_plus( ), add two matrices to find sum. m_transp( ), calculate matrix transpose. |  | Requirements of TrendView matrix functions: The largest matrix size supported is 50 x 50. Addition and subtraction require the two matrices to have same dimensions. Multiplication (M1 x M2) requires the multiplicand's (M1) number of columns to be same as multiplier's (M2) number of rows. Inverse and determinant operations require matrix to be a square matrix. Operations cannot be performed on a matrix that contains empty cells or strings. If a result doesn't exist, the corresponding output cell(s) will be empty. When making matrix calculations, function can be nested.

Return to Top

Opening Trend View Spreadsheet Double-click TrendView.exe from the folder it is stored. Under "File", select "New" to open a blank spreadsheet or select "Open" to access an existing spreadsheet or text file. Entering Data Double-click a cell using the left mouse button Enter data using the keyboard. Press the Tab key, cursor will move to the cell on the right; Press the Enter key, cursor will move to the cell below; Each cell can store a maximum of 500 letters or numbers. |  | Figure 1: Entering Data

Return to Top

Specifying Calculation Output Cell Choose a cell to store the calculation result, and double-click with the left mouse button The selected cell's reference will be visible in the Target Cell Box to the upper left of the tool bar Note: If the calculation result is a matrix, it will also fill necessary cells to the lower right area of the your specified cell. |  | Figure 2: Specifying calculation output cell

Return to Top

Specifying Matrices and Composing Formula

Under the "Stats & Matrix Functions" drop down menu you can find the following functions: m_determ( ) (Determinant), m_inverse( ) (Inverse), m_minus( ) (Subtraction), m_mult( ) (Multiplication), m_plus( ) (Addition), and m_transp( ) (Transpose). Below are ways to enter target matrices and functions into the spreadsheet.

Specifying matrices first, then functions One matrix operation: Specify output cell (double-click) Select all the cells of the input matrix Go to "Stats & Matrix Functions" drop down menu and select desired function, e.g. "m_transp( )" Click "=" button on the Tool Bar or press Enter key to calculate Two matrix operation: Specify output cell (double-click) Select all cells of the first matrix Hold down "Ctrl" key and then select all cells of the second matrix Go to "Stats & Matrix Functions" drop down menu and select desired function, e.g. "m_mult( )" Click "=" button on the Tool Bar or press Enter key to calculate |  | Specifying functions first, then matrices One matrix operation: Specify output cell (double-click) Go to "Stats & Matrix Functions" drop down menu and select desired function, e.g. "m_transp( )" In the "User Math Formula Edit Box" click between parentheses to put cursor there, i.e. "m_transp( | )" Select upper left cell of matrix Hold down "Ctrl" and select lower right most cell of matrix Click "Get cells" button on the Tool Bar The "User Math Formula Edit Box" will be updated, e.g. m_transp(R1C1?R3C3) Change question mark to colon, i.e. m_transp(R1C1:R3C3) Click "=" button on the Tool Bar or press Enter key to calculate Two matrix operation: Specify output cell (double-click) Go to "Stats & Matrix Functions" drop down menu and select desired function, e.g. "m_plus( )" In the "User Math Formula Edit Box" click between parentheses to put cursor there, i.e. "m_plus( | )" Select upper left cell of the first matrix Hold down "Ctrl" and select: lower right most cell of first matrix, upper left cell of second matrix, lower right most cell of second matrix Click "Get cells" button on the Tool Bar The "User Math Formula Edit Box" will be updated, e.g. m_plus(R1C1?R3C3?R1C4?R3C6) Change question mark to colons (express range of a matrix) and commas (separate two matrices), e.g. m_plus(R1C1:R3C3,R1C4:R3C6) Click "=" button on the Tool Bar or press Enter key to calculate

Return to Top

Nested Matrix Operation Example Example: find A / B, where A & B are matrices Since A / B = A x Inverse(B), the calculation can be done by nested functions: m_mult(A, m_inverse(B)). Step 1, specify multiplication operation Specify output cell to be R8C1 Select cells R1C1 to R1C4 From "Stats & Matrix Functions" drop down menu select "m_mult( )" Formula box will show m_mult(R1C1:R1C4,?:?) Step 2, specify inverse operation Select cells R3C1 to R6C4 In the formula box highlight the "?:?" part from m_mult(R1C1:R1C4,?:?) From "Stats & Matrix Functions" drop down menu select "m_inverse( )" Formula box will show m_mult(R1C1:R1C4,m_inverse(R3C1:R6C4)) Click "=" button or press Enter key to calculate Result (including formula) will be available in the specified output cells. |  | Figure 3: The m_mult(R1C1:R1C4,m_inverse(R3C1:R6C4)) calculation result

Return to Top