Prepare the list of locations
Previous step: Step 1: Create a project
Prepare the list of locations
The following information needs to be provided for each of the locations / lines:
The columns in bolt are mandatory. All the other columns can be left blank or can be removed. In that case the default value will be considered.
Step 1: Fill in the required characteristics in the "General Information" section
Here you need to give information on the localisation of the location:
- The location name, this will be the name you will see in the results table
- The name of the brand for which you want to test the locations (in order to know which brand you can choose, the tab "Guidelines" gives a full overview)
- Country of the tested location; BE, NL, DE, FR, ES,UK... Use the official two-letter ISO country codes.
- Either address fields (address, postal code, city) or coordinates (lat, lon) must be provided (see note below).
Additional information on address fields & coordinates :
Locations must have or coordinates or either the full address fields or both. You can provide:
- either coordinates without any address information; the address fields will be found by reversed geocoding.
- or complete address fields without coordinates; these will be assigned by geocoding the indicated address, in case of low accuracy of the address, you will get notified in the following step.
- or both coordinates and address fields; the tool will always prioritise coordinates for the geographical positions.
Step 2: Fill in the required characteristics in the "Location Information" section
Here you need to give the general configuration for your locations. When you leave a cell for a characteristic in the Excel file blank, the default value will be assigned/calculated.
Remark : The required characteristics will depend on the attributes in Location Planning that take a part of your model
Below you can have an overview of which micro-environnement scores could be required:
- Micro accessibility
- Visibility
- Maturity
- Parking availability
- Interior
- ....
- Specific attributes from your own input / configuration
You can find all the micro-environment scores to fill in under the 'Guidelines' tab in the Excel file. It provides a summary of the possible characteristics for item.
For Chargeplanner users, please consult this article to find more information on the relevant characteristics for Chargeplanner. This article will walk you through the specific steps to correctly configure your charging points, ensuring that you set them up accurately and efficiently for EV planning purposes.
Step 3: Fill in the segment information
Here you can give extra information on each of the segment(s) you have in your platform (eg. Garden & Pets, DIY , Retail, etc.)
State: Enter here "Open" for each segment you want your location to be tested in (They are "Open" by default).
This is an example of how the file can be filled out:
Important remark : The number of lines to be processed per file is limited to 500.
The file is now ready!
Once you have completed the file, you are ready to go to the next step.