We are happy to release a much-requested feature, Data Library. The purpose of the Data Library is to give you easy access to all parameters calculated for substations on a monthly or yearly basis. The view is built to be very configurable and enable efficient export to Excel or csv. Data Library is replacing Substation Data List which was a very limited proof of concept for the same functionality.
On the top of the view, there are a number of options for configuring the set of data that is viewed in the table.
Use the year and month selector to select what year or month to view. In the year dropdown, you can also select “Rolling 12 months” which is the last 12 calendar months with complete data. So today (2021-12-23) this represents the time period from 2020-12-01 to 2021-11-30.
Manage Columns brings up an interface for selecting what parameters are shown and in what order.
The list to the left shows the columns you have selected to be viewed in the table. The same list also represents how the columns will be ordered. You can drag and drop to change the order if you want.
Not all data is available for every time period. In the example above, a specific month (Feb 2020 is selected). Design heat load (among other data) is grayed out since this analysis is only done for full years and Rolling 12 months. You can hover over the ?-symbol to see what time periods the data is available for.
When you are happy with your selection of data, click on Confirm and you will be presented with a table matching your selected data.
You can click on the column titles to sort the table. In the example, the table is sorted so that the substations with the highest return temperatures are on top.
The table is split into multiple pages and you can use the navigation in the bottom right to jump between the pages. Sorting and exporting always apply to the full table, not only the page you are viewing.
Like all of the web app (that is not a dashboard or an explicit view of one substation or cluster), you can use the filter. This can be useful if you for example only want to view or export a table for a specific customer, grid area or substations with high return temperatures.
When you are happy with the table you have created, click on the Export List button in the top right. This brings up options for comma- or dot-separated csv as well Excel. For csv, if you should use comma or dot as decimal separator depends on what software you will import the csv to, check what options it has for interpreting signs as column and decimal separators.
Grid Area is not displayed correctly for all customers. We are working on a fix for this.