Event Data Utility A list of all of the events that occurred during and 12 months prior to the study - Cust Event Note Customer The events experienced by each customer during and 12 months prior to the study - Billing Data Customer Monthly billing information for each customer during and 12 months prior to the study - Time Series Customer Hourly energy usage data for each customer during and 12 months prior to the study - Document Files Utility Copies of all applicable documents relevant to the study (e.g., tariff sheets, marketing collateral, etc.) Evaluation Data Utility List of the recipient’s evaluation efforts -
-- -- HasUtilityControl The control technology given to this group has utility control BOOLEAN Options: YES NO -- -- ControlTechDescr Description of control technology given to this group -- RequiresEligibleAMI Assignment to this group requires AMI BOOLEAN Options: YES NO -- Assignment to this group requires minimum amount of historical usage BOOLEAN Options: YES NO -- RequiresEligibleTariff Assignment to this group requires customer to currently be on an eligible tariff rate BOOLEAN Options: YES NO -- Assignment to this group requires customer to currently have an eligible type of internet access BOOLEAN Options: YES NO age
NonResSqFt Non-residential customer’s response to square feet INTEGER [SQFT] NonResFTEmployees Non-residential customer’s response to full time employees INTEGER [COUNT] NonResBusinessValue Non-residential customer’s response to business value INTEGER [$/YEAR] Non-residential customer’s response to electricity’s share of the budget DECIMAL [ANNUAL
a recipient has concerns about reporting census block data, LBNL will work with that recipient to determine the most appropriate level of geographic identifier (e.g., census block group, zip code, etc.). ProjectID* The SGIG project ID number ENUM BillCycleID* Unique bill cycle identifier. There should be one entry per customer per month. BillCycleStartDate* Date that this bill cycle started for this customer DATE -- -- BillCycleEndDate Date that this bill cycle ended for this customer DATE -- -- BillCycleAmount Monthly electricity bill amount in $ DECIMAL BillCycleAllInRate The all-in volumetric retail rate, in $/kWh, that is applicable for this customer during this billing cycle. This includes electricity commodity charges (e.g., fuel costs), transmission and distribution DECIMAL [$/kWh]
footnote at the end of the table for definitions) -- -- Power (Not Required) Power in kW for this customer at this time [kW] -- -- PowerAccumulationType (Not Required) The way in which this power data is accumulated ENUM -- -- PowerFactor (Not Required) The Power Factor for this customer at this time -- -- (Not Required) The way in which this power factor data is accumulated ENUM
-- -- TariffRate The tariff rate stated on the utility tariff sheets, in $/kWh, that is applicable for this customer during the time indicated by the DateTimeStamp (i.e., excluding monthly customer charges and excluding all trackers and/or riders). [$/kWh] -- -- PageViews Number of page views and for data on the website for this customer during the time indicated by the DateTimeStamp INTEGER -- -- PCTSetPoint The temperature set by the customer on their PCT during the time indicated by the DateTimeStamp (leave blank if the customer’s PCT was not set by the customer at this time and/or the set point was not collected by the utility). [C] -- -- UtilityPCTSetPoint The temperature set by the utility on this customer’s PCT during the time indicated by the DateTimeStamp (leave blank if the [C]