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