﻿ Trend View - Data and math formula entry
 InforShell
 Trend View Math Formula and Supporting Features - Operation Overview

 Data & Math Formula Entry Opening Trend View Spreadsheet Entering Data Specifying Calculation Output Cell Specifying Input Cells and Composing Formula Displaying Calculation Result Using Math or Statistics Functions Using "If( )" Condition Distinction Between Addition and Summation Functions Using "count_if( )" Functions Using "sum_if( )" Functions Supporting Features Formula Status and Red/Green Corner Marker Deleting Calculation Result Transferring Formula to Multiple Rows/Columns Modifying Input Data Viewing Input Cells of Current Result Locking and Releasing a Row/Column's Position Adjusting Cell Size and Text Wrapping Saving Trend View Spreadsheet File

 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 file. Double-click a cell using the left mouse button Enter data using the keyboard. Press the Tab key, cursor will move to the cell to 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

 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 spreadsheet's upper left Target Cell Box. Figure 2: Specifying calculation output cell

 Displaying Calculation Result Using the same addition example above, after "R1C1+R1C2+R2C1+R2C2+R3C3" is shown in the "User Math Formula Edit Box" Click "=" button on the Tool Bar or press "Enter" on the keyboard Calculation result (including formula) will be written into the target cell. Figure 4: Displaying calculation result

 "Or" operation For example, to set "If R1C2 - R3C1<0 Or R1C2 - R3C1>10 , then evaluate R2C3, otherwise evaluate R3C3", the "if" formula can be written as if(R1C2 - R3C1<0, R2C3, if(R1C2 - R3C1>10, R2C3, R3C3 ) ) "And" operation For example, to set "If R1C2 - R3C1 not equal 0 and R1C2 - R3C1 not equal 10, then evaluate R2C3, otherwise evaluate R3C3", the "if" formula can be written as if(R1C2 - R3C1<> 0, if(R1C2 - R3C1<>10, R2C3, R3C3 ), R3C3 )

 Using "count_If( )" Syntax count_if( C1:Cn, "if") C1:Cn is the range of cells you want to evaluate. For example, C1:Cn can be written as R1C1:R1C4 or R1C1, R1C2, R1C3, R1C4. "if" is the criteria that defines which cells will be counted. It be a number or text, for example "=32", "29<=", "pencils" (double quotes are required) or a formula e.g. sin(R1C2). When searching for strings, the "*" can be used as wildcard. Example (1) Suppose R1C1:R1C4 contain the following data: 100, 200, 300, 400. count_if(R1C1:R1C4,">=200") equals 3 count_if(R1C1:R1C4,"200<=") equals 3 (2) Suppose R1C1:R1C4 contain the following text: aaa, abc, ccc, ddd. count_if(R1C1:R1C4,"ccc") equals 1 count_if(R1C1:R1C4,"a*") equals 2 (3) Suppose R1C1:R1C4 contain the following data: 100, 200, 300, 400. count_if(R1C1,R1C2,R1C3,R1C4,"!=200") equals 3

 Using "sum_If( )" Syntax sum_if( C1:Cn, "if", N1:Nn) C1:Cn is the range of cells you want to evaluate. For example, C1:Cn can be written as R1C1:R1C4 or R1C1, R1C2, R1C3, R1C4. "if" is the criteria that defines which cells will be counted. It can be a number or text, for example "=32", "29<=", "pencils" (double quotes are required) or a formula e.g. sin(R1C2). When searching for strings, the "*" can be used as wildcard. N1:Nn is the range of cells to sum. For example, N1:Nn can be expressed as R1C1:R1C4 or R1C1, R1C2, R1C3, R1C4. The cells in N1:Nn are summed only if their corresponding cells in C1:Cn satisfy the "if" criteria. Note C1:Cn and N1:Nn should have the same notation (both comma delimited or both as a range). Example (1) Suppose R1C1:R1C4 contain the following data: 100, 200, 300, 400. R2C1:R2C4 contain the following data: 10, 40, 80, 70. sum_if(R1C1:R1C4,">=200",R2C1:R2C4) equals 190 sum_if(R1C1:R1C4,"200<=",R2C1:R2C4) equals 190 (2) Suppose R1C1:R1C4 contain the following text: aaa, abc, ccc, ddd. R2C1:R2C4 contain the following data: 7000, 10000, 21000, 28000. sum_if(R1C1:R1C4,"ccc",R2C1:R2C4) equals 21000 sum_if(R1C1:R1C4,"a*",R2C1:R2C4) equals 17000 (3) Suppose R1C1:R1C4 contain the following data: 100, 200, 300, 400. R2C1:R2C4 contain the following data: 10, 40, 80, 70. sum_if(R1C1,R1C2,R1C3,R1C4,"!=200",R2C1,R2C2,R2C3,R2C4) equals 160

 Viewing Input Cells of Current Result To view input cells to a calculation result, users can Double-click the calculation output cell; Click "View cells" button on the Tool Bar; Cells participating in the calculation will be shown using a blue border. Figure 9: Viewing input cells of calculation result

 Locking and Releasing a Row/Column's Position If it is desirable to have a row or column's display position be fixed in the window (e.g. title row), and not shift when users are scrolling through the remaining cells, users can Right-click the heading cell of this row/column to lock its position. Right-click again (a locked row/column's heading cell) to release. Figure 10: Locking title row's display position.

 Adjusting Cell Size and Text Wrapping To adjust the height/width of a particular row/column, users can: Left-click at the bottom/right edge of the row/column's heading cell, when the size adjustment cursor appears, adjust size by dragging the edge. To enable text wrapping in a particular cell, increase the cell's row height using the method above. Figure 11: Adjusting row/column size.