Inserting Trend Log Data

In the example below we insert log values, both single values as well as multiple values (in the form of log tables) from a log.

The two single values;

• the total energy usage per day (lower left corner), and • the average temperature per day (lower right corner).

are used to display individual measurements and calculated values. The multiple values from the trend logs for

• the accumulated hourly energy usage, and • the outdoor temperature

are used for plotting a graph of the two processes during a day. The report presents data for “yesterday”, that is, the day before the report was generated.

Later we add

• the value units (Kwh and F for the total energy usage per day and the average temperature per day, respectively, Section 11.3.6, “Inserting a Value Unit”, on page 113), and

• a suitable descriptions for the single values (“Total usage per day” and ”Average temperature per day”, respectively, Section 11.3.7, “Inserting an Object Description”, on page 114).

The “header” Value, as shown in Fig. 11.1 (lower left and right cor- ners), is inserted automatically when inserting the values. These are not inserted manually.

We start with the total energy usage per day (lower left corner). This is a single-value from the C_UsageDCalc log which calculates and logs the total energy usage per day based on 24 daily sample values (one every hour).

TAC Vista, Technical Manual 11 Configuring Reports

To insert trend log data

1 Place the cursor in a cell. In the example, C35.

2 On the Vista Links menu, point to Insert, and then click Trend Log.

3 In the Insert Trend Log dialog box:

a Browse to the object to be used. In the example, ACME_Building-Air_Handling-RTU4-C_UsageDCalc.

b Under Show header, select whether a header1 _{should be dis-}

played or not. In the example, click No.

a Under Display attributes, select which attributes to display. In the example, select only Value.

b Under Period, select the time period for which the value(s) should be displayed. In the example, click Period and select

Yesterday.

c Click OK.

A single value is inserted together with the column legend Value. The unit and the descriptive text are added later (Section 11.3.6, “Insert- ing a Value Unit”, on page 113 and Section 11.3.7, “Inserting an Object Description”, on page 114).

Note

• The selection of “yesterday” for this specific log results in a sin- gle-value output from the log – the total energy usage during a day. If another time period is specified (or another log with

11 Configuring Reports TAC Vista, Technical Manual

112 (476) Schneider Electric Buildings AB, Feb 2011 04-00021-06-en Repeat the steps above to insert the following trend log values1_:

• The average outdoor temperature (“yesterday”). This is a sin- gle-value from the OATDCalc log which calculates and logs the average temperature per day based on 240 daily sample values (one every 6 minutes).

• Log: ACME_Building-Air_Handling-RTU4-OATDCalc • Location: cell F35.

• Show the header: No. • Display attribute: Value. • Period: Yesterday.

A single value is inserted together with the column legend Value. The unit and the descriptive text are added later (Section 11.3.6, “Inserting a Value Unit”, on page 113 and Section 11.3.7, “Insert- ing an Object Description”, on page 114).

• The accumulated hourly energy usage (“yesterday”). This is a multi-value log table from the C_UsageLog log which logs the hourly energy usage from 24 log values per day. The log is placed “outside” the report sheet since we don’t want it to be printed on the report sheet; the values are used to plot a graph. Specifying “yesterday” as the time period gives us yesterday’s 24 values to plot on the graph. Both the times and values from the log are needed to draw the graph; specifying only Value as a display attribute does not suffice. Time and Value must be used. Although it is not necessary to displaying a header (not column legend), doing so simplifies future identification and understanding of the report design.

• Log: ACME_Building-Air_Handling-RTU4-C_UsageLog • Location: cell U3.

• Display attributes: Time and Value. • Show header: Yes.

• Period: Yesterday.

• The outdoor air temperature (“yesterday”). This is a multi-value log table from the OATLog log which logs the outdoor tempera- ture every 6 minutes. The log is placed “outside” the report sheet since we don’t want it to be printed on the report sheet; the values are used to plot a graph. Specifying “yesterday” as the time period gives us yesterday’s 240 values to plot on the graph. Both the times and values from the log are needed to draw the graph; speci- fying only Value as a display attribute does not suffice. Time and Value must be used. Although it is not necessary to displaying a

1. In some cases the “values” is just a single value, due to the specified time period, for example, “yesterday” and/or the type of log being used.

TAC Vista, Technical Manual 11 Configuring Reports header (not column legend), doing so simplifies future identifica- tion and understanding of the report design.

• Log: ACME_Building-Air_Handling-RTU4-OATLog • Location: cell AA3.

• Display attributes: Time and Value. • Show header: Yes.

• Period: Yesterday.

We are now well-prepared to plot the graphs, but first we add units and descriptions to the values and the average temperature per day.