Trends
The Load trends tab is on the right hand panel.
Load Trends Tab
Load Trends show time series aggregated smart meter data for any part of the distribution network. The following types of trend displays are available:
- Daily profiles of the top 'n' max/min days,
- Load over time, and
- Load duration.
The load can be expressed in kW, kVAr, kVA or, for conductors, Amps.
When combined with rating information for conductors and transformers, it's possible to easily identify overloaded assets of this type anywhere in the network.
How They Work
Load trends are generally only available in the Network Explorer if your organisation has complete, or nearly complete, smart meter penetration and 30 minute interval (or less) power or energy data, and this is made available from the meter data management system for ingestion by the Energy Workbench.
The load trends are calculated by summating all smart meter load data downstream of the asset from which the trend was requested, for the number of days needed to satisfy the type of trend requested. For a max/min trend display, this will be all available historical data, unless a From-To date range is selected, which will limit the search to the days in the specified From-To date. For load-over-time and load duration trends, all smart meter data in each day in the specified From-To date range will be summated.
In the Energy Workbench, the interval between smart meter load data samples is 30 minutes, with Max/Min and date range trend displays drawing a straight line between each 30 minute load data point to form a continuous trend line. Each data point represents the summated load at that sample time for all smart meters connected to customers found in the downstream trace. To improve responsiveness, the load data for all customers connected to transformers is pre-aggregated for each 30 minute sample interval, so that load requests in the HV network will use the aggregated load values for the transformer, rather than tracing into the LV network and looking for smart meter load data on individual customers.
This aggregated load can be cached in memory, depending on how the Energy Workbench has been deployed for your organisation. When this is done, the load trends will be very performant for trends in the HV network - returning most results in a few seconds. If the load data is not cached in memory, the results can take a lot longer to be returned.
When a load trend is requested on any of the LV network, only the load data on that portion of the LV network that is traced will be included. The individual load points cannot be cached in memory as the amount of memory that would be required would be too large in practical terms, and so load trend requests for LV only network can take somewhat longer than the HV load requests that can use the in-memory cache. For this reason, limiting the date range of these trends to days of interest is highly recommended.
Smart meters typically report real energy values for each interval in kilowatt hours (kWh). Energy is expressed in kilowatt hours, so for a 30 minute energy reading (half of one hour) the average power (kW) for that 30 minute interval can be found by multiplying the energy by 2. The Power Factor for individual smart meters is generally not available, and so the real power (kVA) is calculated by multiplying the real power (kW) by a user entered power factor. When dealing with conductors, the current is calculated using the number of phases present on the conductor and the operating voltage.
Invoking a load trend.
Load trends are invoked from an icon on the pop up menu for each asset, or alternatively from an icon in a downstream trace panel. When the trend is invoked, the right hand screen panel will open, showing the trend tab. This panel can be resized by dragging the left hand panel edge left or right. The default trend displayed is the "Max/Min" trend. This can be changed to a "Date Range" trend by selecting this option in the "Mode" drop down.
More than one trend can be compared concurrently on the same axis by selecting multiple traces from the "Selected Traces" list. This is explained in more detail below.
Max/Min Trends
This shows a set of 'n' trend lines for a 24 hour period. The number of trend lines shown will be the number specified in the "Limit", with the default number being 5. The x axis of the trend represents a 24 hour time period, with 48 intervals - each one representing the average load for the previous 30 minute time slot.
The algorithm to determine the maximum and minimum load days ranks each day in the historical date range being considered according to the highest load value of the aggregated smart meter data for that day - the peak value. The maximum demand days are the days with maximum peak value within the day. The minimum demand days are the days with the lowest peak values within the day.
Each trend line on the "Max Demand" graph represents one of the top 'n' maximum demand load days. Each trend line on the "Min Demand" graph represents one of the 'n' minimum demand load days.
If a "From" and "To" date is not provided, all available days with load data in the past will be considered.
The screen shot below shows a Max/Min load trend that has been invoked from a switch.
Date range trends
As the name suggests, a date range trend provides a continuous load trend downstream of the selected asset, for the specified date range. As with the Max/Min trend, the load can be expressed in kVA or kW for all assets, and for conductors, it can also be expressed in Amps, using the operating voltage of the conductor.
The pen colour of the trend can be changed by changing the colour of its corresponding trace in the "Traces" tab of the right hand panel. The pen colour of the trend follows the colour of the trace on the map, allowing you to easily understand which part of the network is covered by the trend.
A typical date range trend is provided in the illustration below.
In some cases, there will be gaps in the trend display - this indicates there is no data available for those dates. This can happen because either there was no smart meter data available, or because some days have been removed from the historical record by your system administrator for performance and storage reasons, as they did not have any load that was "of interest" to most people, that is, not a high or low demand day.
Load trends of aggregated smart meter data should in theory be close to the values reported by SCADA or other forms of telemetry - however in practice there may be missing smart meter data for a portion of the network being examined, or there can be mapping issues between the smart meter data and the GIS supply points they connect to. For this reason, its always a good idea to compare the load data from other telemetered sources too ensure the smart meter trends are providing acceptably accurate results. Once that is done, you can be reasonably confident the load trends will give you accurate data anywhere along the feeder.
The aggregated smart meter trends are always provided against the networks normal state. This means if you are comparing, for instance, a load value obtained from SCADA with a load trend in the network explorer obtained from smart meter data, and the network was in an abnormal switched state at the time, you will see differences in the load trends. The smart meter derived trends effectively remove the impact of changing switch states in the network.
Real and Reactive Power, and Current
Additional tabs allow for the display of trends of Reactive Power, Apparent Power and Current. These will only provide trend lines if either
- Reactive power is supplied by the Energy Workbench server for each time interval, or
- A default power factor is supplied.
The default power factor can be entered via "Trend Settings", as illustrated in the screen shot below. If this setting is used, any missing reactive power in a time slot supplied by the Energy Workbench will be filled by applying the user supplied power factor to the real (Active) power. It will not overwrite any reactive power supplied by the Energy Workbench.
Ratings trend lines
A rating trend line will be shown for transformers and conductors, where the rating is available.
In the case of transformers, the rating line will only be shown on the Apparent Power(kVA) tab, because transformer ratings are expressed in kVA.
In the case of conductors, the rating line will only be shown on the Current(Amps) tab, because conductor ratings are expressed in Amps. The current is calculated taking into consideration the operating voltage and phasing of the conductor.
The screen shot below shows two maximum demand load trends, with a single value of maximum demand for each conductor, and showing the ratings for each.
The calculation of Current is only as good as the accuracy of the underlying network model - if the operating voltage or phase is not correct, the trend line for Current will be incorrect
The screen shot below shows two maximum demand load trends, with a single value of maximum demand for each transformer, and showing the ratings for each.
Load duration curves
Immediately below the Date Range trend display is a load duration curve (LDC). An (LDC) is a graphical representation that plots the magnitude of electrical load (y-axis) against the duration (x-axis) for which it is equaled or exceeded, arranged in descending order from highest to lowest. It transforms chronological demand data into a format that highlights capacity requirements and usage. Unlike the date range trend, which shows the chronological order of load, the LDC does not show when a specific load occurs, only how long it lasts.
In many situations, you may notice a date range trend has periods of time where there is reverse power flow, that is, negative load. In these cases, the LDC still provides an indication of how much time the load is negative, and how much time at each negative value, however the percentage figure provided on the x-axis for negative load figures should be calculated as 100 minus the percentage value on the x-axis.
The screen shot below shows a typical load duration curve, immediately below the date range trend is was calculated from.
Comparing trends
Both the Max/Min and date range trends allow more than one trend to be displayed on the same trend axis. This is achieved by selecting more than one trace from the "Selected Traces" dropdown. In the screen shot below, two date range trends are being compared for two separate reclosers.
