LiveView Formulas

Formulas let you include data in a LiveView template. You can add formulas to:

  • Add, subtract, multiply, or divide the contents of two individual cells
  • Add, multiply, or average the contents of a range of cells

To use formulas:

  1. In LiveView Template Editor, click the Formulas sub-tab.
  2. Choose one of the following fields:
    • Cell: Use this field to enable a formula for two individual cells. Then enter:
      • Cell 1 Address: Enter the cell address. The cell address displays in this field.
      • Operator: Choose the operator you want to use: +, –, *, or /.
      • Cell 2 Address: Enter the cell address. The cell address displays in this field.
    • Cell Range: Use this field to enable a formula for a range of cells. Then enter:
      • Operation: Choose average, product, or sum.
      • Cell Range: Enter the cell range (format C4:C20), or select the range of cells to include in the formula. The cell range displays in this field.
    • Insert Location: Enter the cell number.
    • Insert: Click this button to build the formula you have specified, and to add it to the cell you added to Insert Location.
  3. Repeat the previous procedure for the rest of the formulas you want to use for this Live View template.

NOTES:

  • You must "Protect Current Sheet" for formulas to be maintained and visible in the LiveView Template Editor.
  • If you want to use conditional formulas ("IF" formulas), you must first create them in Excel. To do this, you must access the template you want on the server (Program Files > Schneider Electric > Applications > LiveView > TemplateEditor >Templates Temp). Open the template in Excel and add the conditional formulas that you want. After you save the changes, the formulas will function correctly in Live View. You must copy the IF statement into every cell of the column that displays the result of the IF statement.
  • In multiple device tables that rely on formulas to display information for each device, the results column will display zeroes when that row has no device in it. To avoid this, use a formula that will display no result if there is no device in that row. In the following example, when no device is in cell A2, no results will display (no zeroes) in cell E2.