Skip to main content

Inputting Data

You will be sent an electronic spreadsheet during the week, which you are required to complete with the data recorded on your survey sheets during the survey. Only the information in Column A (Number of Occupants) needs to be inputted into the spreadsheet.

Entering the numbers

Whatever information you have marked in Column A on your survey sheets should be transferred to the relevant column on your spreadsheet. This information may only be a figure or one of the permitted characters 'L' or 'A'. Any other value will not be accepted by the spreadsheet.

Tips

  • Ensure that you enter the number '0' for empty rooms and not the letter O.
  • For rooms with a capacity of over 50, where you have recorded a percentage on your survey sheet please use the stated capacity to work out an approximate whole number of people. Record this figure on your spreadsheet and not the percentage.
  • For rooms which were over-capacity (i.e. more people than the stated capacity) enter the headcount for the room including the extra people. Once you have done this the field should automatically highlight itself to show that the figure is over-capacity. Do not record it as the number and brackets with extra people as you did on your survey sheet.
  • Do not worry about any other columns you may see on the spreadsheet as they are for our reference and you will not be allowed to edit them.