About the Data Collection Sheet (DCS)

The Data Collection Sheet is an Excel workbook, with the required information divided across several sheets. At Condeco, we use the same DCS for both our personal space and meeting space booking solutions so you may see sheet tabs that are not relevant for your configuration, these can be ignored.

The data entered onto the DCS must adhere to the following rules:

  • The Data Collection Sheet supports the extended ASCII character set, excluding commas ( , ).
  • Do not enter commas ( , ) on the Data Collection Sheet.
  • Do not enter currency symbols in the Cost fields.

Data Collection Sheet (DCS) Excel workbook file information:

Filename: DCS Format.xlsx
Version: 4.0.070322 (March 2022)


Color-coding on the DCS

The DCS is color-coded indicating where and how to add your data.

The color of each Excel sheet tab indicates their function:

Tab color Description
Blue tabs Mandatory data for both meeting space and personal space booking solutions.
Orange tabs Data for meeting space booking solutions only.
Pink tabs Data for personal space booking solutions only.
Grey tabs Do not edit. System and information data.

The cell color in the columns on each sheet indicates where to enter data, when to select options from the dropdown lists, and which columns are automatically propagated and should not be edited.

Column color Description
Yellow cells Enter your data.
Green cells Select data from the dropdown list. Tip: You may need to scroll up a list to see the data.
Grey cells Auto-populates – do NOT edit.
Yellow/grey striped cells Auto-populates – can edit.

How to enter the data

Watch the DCS overview video to understand some important considerations to make when entering your data in the DCS workbook, and to learn some handy tips.

Click each sheet tab on the DCS and complete as described on the following pages. Guidance is also available in a text box on the right of each sheet and by clicking the red triangle at the top of each column. The DCS collects information for both meeting space and personal space booking solutions, you can ignore sheets that are not relevant for your configuration.

On the Data Collection Sheet (DCS), help is available to the right of each sheet and under the red triangle at the top of each column.

Mandatory for both personal space and meeting space booking solutions

You must enter your Country, Location, and Group information first and you must complete those sheets in this order:

Once you have entered your Country, Location, and Group information, you can complete the remaining sheets that are relevant for your configuration:

Meeting space booking solutions:

Personal space booking solutions:

The following optional sheets for personal space booking solutions should only be completed after your user data exists in Condeco:

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Please do not use this for support questions.
Condeco Support

Post Comment