Common use of Spreadsheet Data Format Clause in Contracts

Spreadsheet Data Format. The Spreadsheet format is a simplified derivation of the Green Button XML format. The spreadsheet format allows Submeter MDMAs to transfer in one file EV Submeter data for multiple submeters and multiple days. The spreadsheet includes field headers with the following titles and meeting. The spreadsheet shall be transmitted in CSV file format. Customer UUID Assigned by IOU after a Registered Submeter MDMA completes the Customer enrollment with the IOU. Interval Duration Duration of data interval for the Read Quantity represented in seconds. Interval Duration is either “0900” for 15 minute intervals or “3600” for 60 minute intervals. Interval Duration is specified by the IOU based on the Primary Meter’s unit of measure and/or the IOU’s Subtractive Billing processes. Read Date & Time Date & Time for the start (beginning) of the data interval. Read Date & Time is expected to be at the top of the hour for 60 minute intervals (e.g., UTC Time equivalent of 10:00 am, 11:00 am, ), or on the quarter hour for 15 minute intervals (e.g., UTC Time equivalent of 10:15 am, 10:30 am, 10:45 am, 11:00 am). A read Date & Time record is required for every interval every day, even when the Read Quantity is zero. (Formatted UTC Time, see terms and definitions ) Read Quantity Interval value in Watt hours. (Formatted Decimal 12/6 with zero padding on the right, and none on the left) Date Processed Date the data was loaded into the spreadsheet by Submeter MDMA. (Formatted UTC Time, see terms and definitions ) Below is an example of the spreadsheet file: (UTC Seconds in the example represent UTC Time)