To better understand this tutorial it is advisable to take a look at the following template which has been already filled up with an example of project. You can find it here.
- To have an existing account in DEXCell Energy Manager. If you still don't have an account you can learn how to create it here.
- To be a SuperAdmin user. You can find more information about how to configure users here.
- To have at least one Gateway created, if you don't have it, you can create one as explained here.
- It is recommended to have your prices configured. See how to configure a price here ;)
- To have a portfolio of sites that you want to in-bulk.
Step 1: Fill up the template
Our template consists in an Excel file that you should complete with all the information you want to in-bulk. The file is obtained when you export your account as explained in here. If you export an empty account then you'll get an empty file that you could use as template. The file contains the following sheets to be completed:
As you may know, DEXCell Energy Manager allows you to establish a hierarchy order of your locations in a form of tree as it can be seen in the following image.
The scope of this sheet is to correctly insert the hierarchy of your locations and their data. You can take a look at the filled template provided above in where the hierarchy tree displayed in the image is implemented as example. To do that, keep in mind the following tips:
- Make sure to use a unique LOCATION KEY. The LOCATION KEY is a code that is internally used to determine the structure of your hierarchy tree.
- Remember to add the LOCATION KEY of the hierarchy parent of your location. In other words, the code to identify the location you have above. If you leave blank the Hierarchy Parent cell, then the location will be automatically assigned to the first level, i.e to the location created by default in your account.
- Pay attention to the comments below each parameter on the template. There are cases such as the Country or the Activity_tag that should be typed down exactly as specified in the sheet Designations.
DEXCell Energy Manager needs all your gateways to be already created in your account in order to in-bulk your portfolio of buildings. If you hadn't create your gateways you can learn how to do it here.
The purpose of the Device sheet is to track how your devices are connected to which gateways and to which locations. In a similar manner as in the Locations tab, the DEVICE KEY is linked to a GATEWAY KEY and finally is assigned to a LOCATION KEY.
Keep in mind that:
- This time the GATEWAY KEY is an existing parameter since your gateways need to be previously registered. You can find your gateway key in Settings -> Gateways.
- Once you found the GATEWAY KEY, it is advisable to fill up the rest of the row and then copy/paste the row as many times as devices has the gateway. After that, complete the empty cells with the information of the devices belonging to that gateway.
- Note that if the device tracks a consumption of a certain supply, then the POD number should be inserted.
Reference devices are very important to better organize your data in the analysis section, especially for a large portfolio of buildings. Our in-bulk template allows you to easily define your reference devices without going through the manual process.
The Reference Devices sheet is quite similar to the Devices one, actually, the first 3 columns can be directly copy pasted from Devices. The only difference is that you should introduce the LOCATION KEY and the Reference meter type of the devices that you want to use as reference.
All the supplies of your portfolio of buildings must be inserted in the sheet Supplies. If you are not familiar on how DEXCell Energy Manager allows you to manage your supplies you can find more information here. Note that a supply is identified by the POD NUMBER which is a unique ID provided by your supplier.
Make sure to type down the ENERGY SOURCE, THE COUNTRY and the METER COUNTRY exactly as specified in Designations.
Our template has 5 additional sheets, each one for a specific type of contract available in DEXCell Energy Manager, so you can easily introduce all your contracts during the in-bulk. If you need more information about the contracts in DEXCell Energy Manager you can find it here. The information requested depends mainly on the type of contract, however, in general terms each contract:
- Requires a CONTRACT KEY, which will be used for DEXCell Energy Manager to identify the contract.
- Must have a POD NUMBER, which is used to link the contract to a specific supply.
- Must have a PRICE KEY from a previously defined price in your DEXCell Energy Manager account. You can get the price key from one of your prices in Settings -> Supplies and prices -> Prices
As example, the following image shows the sheet for electricity contracts.
Step 2: Send us the template
To upload your file you should send it to us at email@example.com and our support team will insert it for you.