MV90 spreadsheet export

IEE includes an MV-90 Lotus Spreadsheet export adapter to provide flexibility for interfacing with multiple business systems.

Use the following procedure to configure a task template:

Go to System Operations > Task Management > Task Templates.
Use the dropdown menu to select the Task Type and Task Template. (Click Add to create a new task template. For more information, see Adding task templates.)
Configure the Task specific parameters. These parameters are defined after step 5 of this procedure.
Configure the Common task template parameters. For more information, see Task template parameters.
Click Save.

Task specific parameters:

Entity Type

Defines the entity that IEE builds the export file or report around. Entity type supports all main configuration entities. The valid values are as follows:

service point
account
meter
data routing program
monitoring data program

In a task template, select the entity type from the dropdown menu and click Search to find the specific ID. Click the appropriate row in the search results and click OK to add the ID to the task template.

Entity ID

Defines which specific entity (service point, customer, account, premise, meter) to include in the export. This parameter is unavailable unless you select the group or default options next to entity type. The Entity ID name changes depending on the entity type parameter. Entity IDs are also known as Node IDs.

Time Period

Defines the time span of the data to include in the task for exports, reports, and other tasks. Some common time periods include: Today, Yesterday, Month, Month to Date, Week, Week to Date, Year, and Year to Date.

Start Date

Defines the first day from which to include data in the task.

Tip: Defines the date to start the baseline calculation. Use this parameter to indicate how far back your baseline is needed. Typically, this is the first day of operation or recovery period. If this value is not properly set, it may default to the beginning of time, and Like Days may calculate as far back as historic data is available. This will overwhelm the LikeDayAlgorithmDate table and lead to slower processing.

End Date

Defines the last day from which to include data in the task. To include the full 24 hours of the last day, the task will be scheduled with an adjusted End Date (that is, adding one day to the End Date entered in the task parameter).

Time Zone

Defines the time zone that corresponds to the time period and start/end dates you select in the task template.

For Rate Event Report, the time zone format is PacificUS, PacificUSNoDst, and EasternUS.
For TOU Schedules, the IDs cannot start with a numeric character. For example, "400_TOUSchedule" is not a valid ID. Instead, name the ID "TOUSchedule_400".

All Data Since Last Export

Determines whether the export file contains all data since the last export on cycle ran.

Version of Data

Select a version of data to export. The valid values are as follows.

Current Version. Exports the current version of data for the time period.
Version Date. Exports the most recent version of data for the time period as of the specified Version date and time.
Significance. Exports the most recent version of data for the selected Significance type. Significance types are created by IEE administrators, some Significance types are billing, load research, settlements, or other purposes.

Spreadsheet Format

Defines the MV-90 spreadsheet export format. Select either Day Per Row, Interval Per Row, or Summary Per Row.

Export Directory

Defines the directory where IEE places the file containing exported data. Accept the IEE default file path or click Search to browse to a directory. This parameter supports the standard IEE macros. Reference as ($ExportDirectory) when configuring a task. Exported data is generated by an export task template or an export API.

Export File Name

Defines the export file name. You can enter a unique file name or accept the default. This parameter supports the standard IEE macros.

Output Time Zone

Defines the time zone to use in the export file, report, or other task. If you omit this parameter, IEE uses the time zone of each service point.

Update Last Read Date

Determines whether IEE updates the cycle data end time at the end of the export. This parameter prevents IEE from automatically picking up a new date range when a user manually exports a file.

Field Delimiter

Defines the type of delimiter to insert between data fields in the export file.

Interval Length

Defines the number of minutes to use for intervals in exported data, in the absence of a specified value for exports and workgroups data. Instead of specifying an interval length here, you can check As Metered. If you select As Metered, then the Interval Length option is inactive.

Rolling Interval

Defines the length of time over which to average the demand, and allows you to smooth demand. Rolling demand may be required for billing purposes. For example, if the export is for billing, and the customer contract specifies billing on a 60 minute rolling demand for data that is metered in 15 minute intervals, set the Rolling Interval Length to 60. When you export the data, there is an interval value every 15 minutes. However, the value is an averaged demand value over 60 minutes that ends at the timestamp for each 15 minute interval. In this case, the averaged intervals are the current interval plus the three previous intervals.

Allow Chopping

Determines whether IEE should export data if the interval length is larger than was defined in the Interval Length parameter. Select Allow Chopping to export the data despite its longer interval length; allow it to be chopped. Clear this box to exclude intervals with interval lengths exceeding the Interval Length parameter.

Number of Decimals

Defines the number of decimal places to include in the values within the exported data.

Export Partial

Defines whether IEE should export data if it only exists for part of the date range. Select True to export readings even if there is only partial data. Select False to disable this feature. The default is False.

Unit Scaling

Determines if IEE outputs all values to the same scale. If you omit this parameter, IEE uses "None". The valid values are as follows.

None
Units
KiloUnits
MegaUnits

Output Usage

Defines whether to export all data using demand or consumption units. The valid values are as follows:

Raw. Export readings as they are stored, with no conversion.
Consumption. Export readings after UCE converts them to consumption values.
Demand. Export readings after UCE converts them to demand values.

The UOM must be set correctly for UCE to make these conversions. If you omit this parameter or if the UOM cannot be converted to consumption or demand, IEE passes through the raw values.
Pulse. Export readings in pulses. With this setting, IEE converts the engineering units data into pulses using the correct multipliers for the period being exported. This functionality can be used if the receiving system is expecting data in pulses.

External System

Defines any external system to which IEE configuration data can be associated. In many places this parameter provides you with the dropdown menu to select from the external systems configured in the External System table.

Use Error Rollback Logic

Determines whether an error causes IEE to exclude other related information from the export. Select True to exclude the entire account from the export if IEE finds an error for a channel. Select False to include the rest of the account despite an error in the channel.

Use Integer Readings

Determines whether IEE exports readings as integer or decimal values. This system setting also controls whether the export file includes column headings. Select True to export readings as integer values and include column headings. Select False to export readings as decimal values and not include column headings.

Update Cycle Data End Time

Determines whether IEE updates the cycle data end time at the end of the export. This parameter prevents IEE from automatically picking up a new date range when a user manually exports a file. If you use this parameter, you should also enter a Schedule ID.

Overwrite Existing File

Defines the way the export should continue if the export file already exists. The valid values are as follows:

Merge. Merges the new file into the old file.
Overwrite. Replaces the old file.
Unique. Appends a sequence number to generate a unique file name.

Max Items Per File

When the Overwrite Existing File parameter is set to Merge, the Max Items Per File parameter defines the maximum number of export items that are merged into each export file before IEE creates a new export file.

For example, setting the Max Items Per File parameter value to 100 causes IEE to create an export file when the first file item export finishes. The first file item and the next 99 file items are merged into the export file. When the 101st item export completes, it causes IEE to create a new export file, where the 101st item export and the next 99 items exports are merged.

Add Nonexistent Channels

Determines whether IEE exports empty “place holder” channels on the MV-90 Spreadsheet Export for any non-existent channels. The default value is No. Select Yes to enable this feature.

Acct Service Pt Channel

Defines the type of channel associated with the account service point to export. The valid values for this parameter are defined in the Account Service Point Channel Reason table. Common reasons are as follows:

Billing
Marketing
Load Research
None
Non-Billing

Only Export Data of These Validation Statuses

Defines the validation statuses to include in export data. Select the check boxes to limit the exported data to only those values with particular validation statuses. IEE includes three validation slots, and you can define validation statuses for each slot. Clear the check box to export all validation statuses.

Which Channel

A measurement of the energy delivered to the customer. Channels allow different units to be measured at the same service point. Examples of channels measured at a service point include kWh, kW, and Kvarh.

Aggregate on Export

Determines whether IEE eliminates separate aggregation tasks that would normally run before the export. Reducing the number of tasks generated on an automated C&I cycle improves performance and reduces the overall cycle processing completion time. Run aggregation on stored formula channels, which store the data and then export the aggregated data in the results. If the export does not run because of some other condition such as 'Export partial = false', then no aggregation takes place.

A channel that holds data calculated from a formula. The data can be regularly or irregularly spaced data.

Which ID

Determines which IEE configuration ID to write to the recorder ID field in the export file. The default value is the service point ID if the selected ID is not available.

Channel Selection Grid

Determines whether to add a row to the channel selection grid. Click Add Row to create a new row. Use the dropdown lists to select the type of data to include in the report. To delete a row, select the row and click Delete Row.

This grid acts as a filter for the data you want to export. The grid may contain any combination of items. If the grid contains any items, then data must meet the criteria for at least one of these rows to be included in the export.

For example, if you click Add Row and select Register from the Channel Type dropdown list, IEE only exports register channel data. If you click Add Row, select Interval from the Channel Type dropdown list and select Received from the Power Flow dropdown list, IEE only exports interval data received by the utility. If you add two rows to the grid, one for register channel and one for interval channel, IEE exports both register channel data and interval channel data.