Welcome to Electsolve

Market Settlement & Reporting

Aggregation/Settlement and Profiling
Settlement systems are responsible for aggregating and profiling data into summary form to provide usage to system operators, electric service providers, energy regulatory bodies and other third parties requiring such information. Data is typically resolved to the hour and summarized by power regions, power zones and by meter classes. Summarized data is ultimately used to reconcile and settle energy purchases and sales before any fees are paid.
The settlement system imports Load Profiles, Loss Factors, Interval Meter Readings, Monthly Meter Readings and either aggregates OR profiles data into a common time interval typically 60 minutes. The data is then summarized by specific use region and reported for use in billing and financial settlement applications.
The MDM has a Settlement and Aggregation module. This module is designed to support the deregulated markets to report time sensitive market settlement data to the regional energy regulators. The software module is suitable for most settlement markets by means of configuration changes and the implementation of the applicable market reporting rules.
The MDM currently supports aggregating data together from multiple AMI and AMR technologies and processing this data by cycle for CIS billing processes. The MDM provides “Gap analysis” reporting which meters have reading gaps, which meters are in CIS and not in AMI, which meters are in AMI and not in CIS and other performance monitoring and reporting functions to assist utilities in tracking and monitoring the AMI performance.
The MDM provides the ability to aggregate multiple meter points commonly referred to as “totalization”. The MDM also provides the ability to derive results during extraction of data from the MDM by applying calculations on the extracted data. The MDM model fully supports auditing of changes and supports tracking of calculation changes over time.
Profiling enables the utility to utilize interval data collected from the AMI system to create load shapes for load analysis among different customer classes. If also enables de-aggregation of cycle register readings in the absence of smart metering allowing the utility to create interval data from non-interval cycle register readings utilizing load profiles generated off interval data collected from other “like” customer meters with similar electric and water usage rates. Load analysis requires accurate load profiles and the MDM supports generating load profiles for load analysis.

Validation, Editing and Estimation (VEE)

The process of Validation, Editing and Estimation (VEE) has historically been a low level process typically handled within the utilities’ customer information system (CIS) and largely intended to “throw out” anomalies for re-read or for estimation. To support new he onslaught of electric deregulation, the process of “scrubbing” data took on the label of VEE and is now tasked with a much broader scope. VEE now is relied on to not only identify data irregularities but is now tasked with correcting, and in many cases, replacing “bad” data with estimated data.


The rules for VEE vary from state to state but are all based on a similar process. Interval data (i.e. 5, 15, 30 and 60 minute) and register readings are put through a series of rigorous test to determine if the data looks correct in its’ current context, whether is looks correct when compared to historical data from the same source or whether it is missing entirely. These tests can be “tuned” to meet both unique customer needs and specific regulatory requirements.


VEE provides a number of data test that can be performed on a given target set of data. These check tests include: Spike, kVAr, Hi-Lo, Missing Data, Corrupt Data, Post-Sum, Post Spike, Post kVAr, Post Hi-Lo, Post Missing Data and Post Corrupt Data Checks.