UCL Logo
Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


A one column grid is the most common kind of grid structure used and is the simplest to reference in the condition logic. Grid coordinates, $X;Y, are used to specify a cell or multiple cells of a grid. See Table 2. Grid Coordinates for more details. In Example 11 below, you can reference the grid as a whole because the question states that the answer is for any of the sub-questions B2a-s. Implicit in the grid logic is that each cell answer is considered to be an || OR, so in this example any of the answers could equal 3 rather than an && AND which would mean all answers must be 3. Please refer to Example 16 as to how to reference grid cells using the AND comparator. 

Also note that, 'Otherwise go to section C.' is added on to the condition text as there is no suitable position to enter it as a statement.

Example 11 Questionnaire: ALSPAC


Child’s Behaviour and Abilities

Questionnaire layout:


Archivist view (alspac_99_cba):


Archivist view (ncds_02_sc_2):


Grid cell referencing

Conditions range in complexity within questionnaires . Sometimes conditions have complex condition logic, for example, when the logic refers to axes in a question grid, as shown in Example 16 below:and sometimes need to reference specific cells within a grid. When referencing several cells in a grid at once, each of the grid cells in the logic is effectively compared with an OR e.g. if the logicqc_A3 != 1 was used for the example below, to cover all grid cells, it would effectively be qc_A3$1;1 != 1 || qc_A3$1;2 != 1 || qc_A3$1;3 != 1. This would mean that any of the options could not equal 1, but we need all of the options not to equal 1. Therefore, each cell has to be referenced individually qc_A3$1;1 != 1 && qc_A3$1;2 != 1 && qc_A3$1;3 != 1 with AND in between.

Example 16 Questionnaire: ALSPAC Parent Adult Learning 2004