Using Global Statistics Tables for Fleet Management
DECK Monitoring has released 3 new page views that can be found in the Global Statistics section within your Admin Panel. These new page views provide helpful new overviews for your full system portfolio.
These tables provide an overview of performance index, production data, and expected to actual performance from your full portfolio… unlike other tables in your Admin Panel, however, these tables can filter data using metrics of your choosing, including custom tags, system size, location, and hardware. The new Statistics Tables let you sort and search your full portfolio to group systems with matching tags, making it easier for you to manage your complete system portfolio.
You can find 3 new Statistics Table page views in Global Navigation tabs (found in black stripe at the top of every Admin Panel page). The new tables can be found in the drop-down menu under “Solar Statistics.” New table page views are titled:
- “Actual vs. Expected”
- “Performance Index”
- “Status Overview”
(The traditional Solar Statistics page view can now be found as “Classic” in this drop-down menu.)
There is a new section on the System Overview page for any location (the landing page if you click on the system name from the Map page or a Statistics page). Here you can view any existing tags (including automatic tags generated by DECK), as well as create or remove your own custom tags.
To edit or create new tags, type in the open menu box (under "add additional tags to this system"). This will prompt a drop-down menu that includes all tags you have previously added to other locations (or just hit Enter to add your text as a new tag).
Filtering using Tags
With the 3 new statistics tables (described below), you may filter the list of systems to be displayed in each table down to only systems which possess certain tags. You can filter using one tag label, or a combination of tags. For instance, you could show only locations that have a certain type of device and are in a specific zip code. Or you could choose only locations over a certain size threshold... or you can use original tags that you generate, such as "developed in 2013."
The filtering section will load at the top of each table.
When you select more than one tag, you will have the option to choose to view either systems matching any of the selected tags, or systems matching all of the selected tags.
By default, systems will be arranged in these tables by alphabetical order. But you can also sort the systems to rank from highest to lowest in any of the column values (just click on the column names at the top of the table).
Actual vs Expected Tables
The table on this page offers a way to compare the actual generation of your equipment to the predicted generation values you have entered. The tables combine various metrics:
- Columns titled "week," "month," "quarter," and "year" are rolling time windows. So the "week" column shows values for the past 7 days, the "month" column shows values for the past 30 days, etc.
- Columns titled with the phrase "to date" are fixed to calendar dates. So "week to date" would show values from the most recent Sunday at 12AM to the current day and time. "Month to date" would show values from the beginning of the current calendar month to the current day and time.
- “Actual kWh / Expected kWh” compares actual against expected kWh totals directly.
- “Actual $ / Expected $” compares actual against expected dollar value output of the systems.
Notes on Actual vs Expected Tables:
In most cases, expected generation values must be manually entered into the DECK database by the user. One exception: if you have purchased the SolarAnywhere SystemCheck extension for a system (satellite irradiance and predicted power), the software will automatically use expected generation values from this feature.
If you do not have expected generation values set in the DECK system, you will see "NA" instead of expected generation values (see below):
If you want to input expected generation values, click on the small question mark next to "NA" for any given location in your Actual vs Expected table. This will prompt the following pop-up window:
This window includes 2 links that allow you to enter expected generation values:
- Click on "enter a baseline" to enter monthly baseline generation values. This will open a window where you may directly enter a unique expected generation value for each month of the year.
- Click on "upload a csv" to input expected generation values from CSV spreadsheet data. Unlike the baseline feature, a virtual device data set supports granularity down to 15 minute intervals. (Some users choose to download historical system data for this purpose.) Clicking on "upload a csv" will prompt a the pop-up window shown below, where you can upload your CSV file and enter other values to determine how DECK software will display your expected generation data.
To set values for Expected Dollars, you must enter a Cost Allocation value on the Settings page for a system (and you must have set predicted generation values).
Performance Index Table
This table shows the performance index by month for all systems that have both generation data and weather data (irradiance and cell temp). System size must be set accurately in order for the data to be meaningful.
Note that the Performance Index may be considered as an alternative calculation of actual vs expected, but this metric accounts for available sunlight because the “expected” value in this case is calculated using irradiance and cell temp data from your on-site weather station. You will not see values in this table for systems that do not have a weather station.
Cells of the table are color coded to indicate which results are a good performance index versus a bad performance index, so it’s possible to spot at a glance which systems likely need attention. The color scheme spans from primary green (for systems with high performance index values) to primary red (for systems with low performance index values).
A word about Performance Index calculations: Performance Indices are tools commonly used to compare the projected solar system output based on the available solar resource to the actual system generation. This calculation relies on actual solar irradiance measurements, and so cannot be computed unless a weather station with a working irradiance sensor has been installed on site.
In addition to the weather station and generation meter, our Performance Index also utilizes (2) user input values that can be changed on the settings page: the DC Nameplate system size, and the “Temperature Coefficient of Power.” The calculation can be visualized this way:
Our Performance Index is a way to summarize all of the system inefficiencies in a single value. A perfect system with absolutely no losses would have a performance index of 1.0. After factoring in typical losses due to inverter inefficiencies, wiring resistance and other imperfections, a new system performing very well should yield a performance index near 0.85.
How DECK calculates your Performance Index:
The DECK Performance Index does diverge from the ISO defined Performance Ratio in two ways.
- DECK Performance Index factors in the effect of cell temperature on PV module performance.
- DECK Performance Index is based on irradiance measurements taken at the Plane of Array, and not on the Global Horizontal Irradiance.
Why does my performance index look inaccurate?
You may see inaccurate Performance Index values, such as a ratio of 1.0 or above. The leading cause of inaccurate Performance Index calculations is an error in the customer-defined system size value for your site. Please check the settings page to verify that the DC Nameplate size is correct.
Status Overview Table
This table is built in the same style as the classic Solar Statistics page view. You can see a range of helpful statistics for your systems, including the easy-to-read green “slider” graphic showing Peak kW Yesterday vs Installed kW.
New metrics added to this table include Raised Alarms, Current Irradiance, and 7-day Performance Ratio.