This article includes a description of the parameters that can be inserted into the platform, as well as the methodology that should be followed depending on the type of variable that wants to be inserted. Moreover, the algorithm that the software follows in order to calculate all the data frequencies, will be summarised. Finally, some additional information will be provided in order to solve possible problems that might arise.
The information will be divided into the following sections:
- Parameter definition
- Available parameters in the platform
- Inserting parameters into the platform - Available frequencies
- Calculations carried out after the insertion
- Management of the inserted parameters in the platform
- Visualisation of the parameters
- Golden Rules about parameters
Parameter definition
A parameter is what allows the platform to understand which type of consumption or variable a device is monitoring. It is really important to correctly define a parameter, as alerts, visualisation of the values and other functionalities will depend on it.
It is important to understand that one device can have a lot of parameters but each of them must be unique. This means that you may have 15 parameters in one device but all of them must be distinct. Then, if a gateway sends data from 2 gas sensors, in our platform this could not be represented by one device only, as it would cause the parameter gas to be repeated. Thus, each sensor should represent a different device, and both devices would then have the parameter gas.
Available parameters in the platform
Multiple parameters are accepted in the platform. The list of all the available parameters can be found in the following spreadsheet:
Platform parameters spreadsheet
As it can be noticed, these parameters include both discrete and continuous variables. All of them are here represented by a code of 3 digits. However, when inserting data, depending on the type of variable that is being inserted, some more digits may be necessary.
Please go to section 3 to learn more about the insertion of parameters into the platform and the available frequencies for each of them.
Inserting parameters into the platform - Available frequencies
In order to understand how a parameter can be inserted into the platform, there needs to be a differentiation between discrete and continuous variables.
Instantareous variables, such as temperature or power, are usually inserted using the 3-digits number shown in the excel file of the previous section: "Available parameters in the platform".
Continuous variables, such as consumed electricity and gas, can be inserted in two different ways in the platform:
- Basic/accumulated parameter. The basic methodology implies data inserted cumulatively, i.e. every measure will be added to the previous one. This results in constantly increasing values and creates a link between the measures. This methodology is frequency-neutral, as it does not directly relate to a certain insertion frequency.
- Discrete parameter. The discrete methodology implies that every measure will directly be uploaded into the platform, despite any prior measures. Every measure inserted into the platform will be independent of the others. This methodology directly relates to a specific insertion frequency.
Inserting with the basic methodology
While inserting through the basic methodology, it is not necessary to indicate to the software which is the frequency in which data is being uploaded, as the platform itself will identify it.
If data will be inserted through the basic methodology, the representation of each parameter will be the 3 digits that are represented in the excel file of the section: "Available parameters in the platform".
When inserting data using this methodology, the software will carry out several calculations so as to determine the specific consumption for different frequencies. Please go to "Calculations carried out after the insertion" in order to learn more about these calculations.
Inserting with the discrete methodology
While inserting through the discrete methodology, it is necessary to specify to the software which is the frequency in which the data is being uploaded. Moreover, an "operation" needs to be defined so as to understand the type of variable that is being monitored.
The code for discrete values' insertion is SSSFO, in which:
- SSS corresponds to the 3-digits representing the parameter, found in the excel file of section "Available parameters in the platform".
- 'F' represents the frequency in which data is being inserted:
Frequency | F value |
Quarter-hourly | 0 |
Hourly | 1 |
Daily | 2 |
Weekly | 3 |
Monthly | 4 |
30min |
6 |
10min |
7 |
5min |
8 |
- 'O' represents the operation that will determine how the data has been discretised:
Operation | O value |
Delta | 1 |
Average | 2 |
Maximum | 3 |
Minimum | 4 |
Operation value ‘1’ is used to operate parameters of accumulated nature, such as electricity or water consumption. In these cases, the operation means that the value of the variable is the delta of that variable between two time frames, represented by the Resolution. E.g., active energy is 402, if we want to insert data as the consumption for the last 15 minutes the correct code would be 40201.
Operation values 2 to 4 are used for parameters with instantaneous nature, such as temperature or power. The operation avg, max and min represent also time interval values. E.g. power's parameter ID is 401. If we want to insert average 15min power, the parameter would be 40102.
Calculations carried out after the insertion
- 5 minutes.
- 10 minutes.
- Quarter-hourly.
- Half-hourly.
- Hourly.
- Daily.
- Weekly.
- Monthly.
Calculations for discrete data insertion
Calculations for basic data insertion
Management of the inserted parameters in the platform
Once the data has been introduced into the platform, in order to see and manage the parameters that are being introduced by the devices, you should go to Settings > Gateways (select a gateway and click to edit) > Devices > Parameters:
Once you click on Parameters, you will see the following window:
In this menu, you will be able to select and de-select all the parameters that have been received by your device.
In case you observe you are receiving a parameter that is not useful to analyse, you have two options:
- De-select this parameter, and it will no longer cost a datapoint to you.
- Derive the parameter into a more useful one, e.g. from pulses to gas volume or energy.
Visualisation of the parameters
Once all the parameters have been introduced into the platform and have been accepted by the user, it is time to visualise them in the analysis screens. Please find below a table with the parameters that can be visualised in every screen:
Screen/Parameter | Energy consumption* | Temperature | Cost | Others** |
Consumption | x | - | - | - |
Cost | x | - | x | - |
Comparison | x | - | - | - |
Comfort | - | x | - | - |
Peak demand | x | - | - | - |
By device | x | x | x | x |
Advanced Analytics | x | x | x | x |
Queries | x | x | x | x |
*Energy consumption refers to:
- Electricity consumption
- Gas (kWh, volume and normalised volume)
- Water
- Diesel (kWh and volume)
- Produced electricity
- Thermal energy (heating and cooling)
- Compressed air volume
- Liquified natural gas
- Biomass
**Please note that Power is included in the category "Others", together with Voltage and Current.
Golden Rules about parameters
- The main rule is that data inserted will prevail over data calculated.
- The second golden rule is that "discrete" data inserted will prevail over "basic" (or cumulative) data inserted.
- The third rule is that in order to apply a cost to a certain consumption, the data needs at least a 30min resolution. Cost is not stored (nor charged) as a datapoint, but calculated over a consumption.
- If discrete data is inserted outside its expected timestamp, it will be discarded. For example, if the platform expects data every 15 minutes but receives data at 13:59h instead of 14:00h, the reading will not be stored.
- Discrete data with daily frequency is expected at 00h.