Export Usage

 

Content:

Basic requirement for the export

  • Advanced analytics subscription (contact Sales if you wish a demo)

  • Sensors for each workspace to be analysed (Room, Desk, Huddle)

Where does the data come from

The data for the export comes from the Sensors. We analyse only occupancy-data on working days between the working hours (These can be changed in the building details). Data outside this period is currently not taken into account. We calculate the usage of a workspace per day, if the sensor has times without occupation which are less than 15' we calculate it as occupied for the hole period. (e.g. usage between 8:00 until 9:00 and from 9:10 to 10:00 the usage for this period is 2h / if the break is from 9:00 to 9:20 the usage would be 1h 40')

How to export the data

  1. Navigate to the Export section in the Portal (you need to Workspace-Manager or Admin to have access):

    image-20240425-084606.png
  2. Select the month you would like to export (Only one month at the time possible)

  3. Click to Export, your browser will download the .CSV file to your download folder

What is in the export

If you open the .csv you will get a list of all the spaces description details in Column G, each day of the month will be numbered.

  • Workspace ID = ROOMZ unique ID of the workspace

  • WorkspaceName = the name from the workspace (set in myOrganisation on the Portal)

  • WorkspaceType = What is this workspace, could be: ROOM; Desk or Huddle

  • WorkspaceTag = Tags set to the workspace

  • BuildingName = The name of the building (set in myOrganisation on the Portal)

  • FloorName = The name of the floor (set in myOrganisation on the Portal)

  • WorkingHours = The maximum hours per day of the workspace, the working hours can be set in the building settings.

  • Date ex. 1.4.2024 = you will see here the number of hours a workspace is used (rounded to two decimal places)

    • If the field is empty: we do not have correct sensor data for this day

      • No sensor is connected with this workspace

      • Could be because of a Network issue, the sensor will buffer the information and send it with the next communication. The calculation will be done later

    • If the field is a 0: the Workspace was not used in this day.

If you are using Microsoft Excel to view the .csv, you may have strangely displayed special charts. This is a known issue of Excel, and it is easy to solve by following the following page: Opening CSV UTF-8 files correctly in Excel

Â