Running bulk regression analysis on meters
The Bulk Regression Modeler - Meters report enables you to perform bulk regression analysis on weather metrics for a selected range of meters, based on a few predefined parameters. The regression analysis in the report works the same way as the meter regression analysis dashboard, with the advantage of running the analysis in bulk.
Before you begin
- Link the location to a valid weather station with up-to-date weather data, or sufficient data for the historical period that the regression analysis is run on
- Under location settings, configure the location's Base HDD and Base CDD temperatures in Celsius
- Under location settings, configure the location's nonworking days if any exist
About this task
For more information about the regression analysis tool, prerequisites, and creating a regression model, see the related link.
Both system administrators and general users of the platform can run the report in Commit To Save mode.
Similar to any regression analysis tool, it is time consuming and computational intensive to perform regression analysis in auto fit mode. In auto fit mode, the tool must try out many combinations of Base HDD and Base CDD values to find a best fit. Generally it is expected that the report times out if the number of meters that are required for regression analysis exceeds 300. Therefore, run the report for a smaller set of data each time, for example, for a Group only rather than for the whole organization. The performance improves substantially if you can predetermine and supply the Base HDD and Base CDD values for each location, rather than using the auto fit method.
You can run the report in two modes, which are View Only mode and Commit To Save mode. In Commit To Save mode, regression results for applicable meters are saved into the platform together with the relevant HDD and CDD metric changes that are required for weather normalization reporting. The report can be output only as an email attachment in CSV format in both modes.
When you run the report in Commit To Save mode, the regression result and the relevant HDD and
CDD metric changes are saved into the platform. When you run the report in View Only mode, the
meters are marked as To Be Applied
.
Entity | Attributes |
---|---|
Meter settings | Slope for HDD*, Slope for CDD*, Base Load for Working Day, Base Load for Holiday, R2, Regression Results, Regression Base Period |
Location Settings | HDD Base Temperature, CDD Base Temperature |
HDD and CDD Stats | HDD and CDD stats for the location are recompiled if any meter in the location has its result
equal to Applied . This is necessary because the calculation of HDD and CDD values
relies on the Base HDD and Base CDD values, which might have been changed as part of the
exercise. |