Upload your data into Envision
Early Access
This describes how to prepare the data file and then upload it to Envision
Prepare the Data File
Step 1. Download the template
From the Eptura Home, click the Download .xlsx template button to download the template file.
Remember that after you have uploaded the data into Envision this will populate the data; therefore the next time you download (and onwards) users will receive the template pre-populated with previously entered values, along with any newly added buildings. Users can update the data they had entered earlier if desired, and also input new data for any newly added buildings.
Step 2. Open the template
- From your download folder, open the file.
You will see the downloaded Excel file contains 10 columns, with 4 columns prepopulated/locked and 6 columns requiring user input.
Locked columns:
- building_id
- building_name
- total_no_of_desks
- total_no_of_rooms
Columns requiring user input:
- operational_cost_usd
- annualized_rent
- lease_end_date_yyyy-mm-dd
- total_sq_feet_area
- percent_area_of_rooms
- percent_area_of_desks
Step 3. Complete the data
When you complete the data, we have a table below that describes the columns and if you're uncertain about the values, you can leave them blank.
Make sure that ...
- None of the 10 columns are deleted or renamed.
Don't ...
- Modify any values in the pre-populated columns.
- Delete any rows/records.
- Duplicate any rows/records.
| Column Name | Description | Examples |
|---|---|---|
|
operational_cost_usd
|
It must be either a non-negative decimal or a non-negative integer. |
4234.32 7565 43534.45 |
|
annualized_rent
|
It must be either a non-negative decimal or a non-negative integer. |
4234.32 4563 |
|
lease_end_date_yyyy-mm-dd
|
It must follow the format YYYY-MM-DD, where YYYY represents the year, MM represents the month, and DD represents the day. The valid date range between 1900-01-01 to 2100-12-31. |
2029-02-14 2034-11-03 2050-12-24 2019-02-01 |
|
lease_end_date_yyyy-mm-dd
|
It must follow the format YYYY-MM-DD, where YYYY represents the year, MM represents the month, and DD represents the day. The valid date range between 1900-01-01 to 2100-12-31. |
2029-02-14 2034-11-03 2050-12-24 2019-02-01 |
|
total_sq_feet_area
|
It must be either a non-negative decimal or a non-negative integer.
|
34232.43 42534 7687.76 |
|
percent_area_of_rooms
|
Enter a value only if the total_no_of_rooms is greater than 0. The input must be either a non-negative decimal or a non-negative integer, and no percentage sign (%) must be included. The valid range between 0-100. |
21.32 54 0 100 |
|
percent_area_of_desks
|
Enter a value only if the total_no_of_desks is greater than 0. The input must be either a non-negative decimal or a non-negative integer, and no percentage sign (%) must be included. The valid range between 0-100. The sum of the percent_area_of_desks and percent_area_of_rooms must not exceed 100%. |
21.32 54 0 100 |
Step 4. Save the Data File
Before you save the file, make sure that:
- The workbook name is not changed and it remains space_cost.xlsx.
- The sheet name within the exported workbook remains space_cost.
Upload the Data File
- From Eptura Home, click the Upload button and the File Upload form displays.
- Either click the browse files and select the file OR drag and drop the space_cost.xlsx onto the form. The file will be uploaded.
If will take about 12 hours for the template data to be processed and displayed in the Envision Dashboard. Learn how to open the Envision Dashboard.