How to draft a spreadsheet
When preparing the spreadsheet to input collected data, a few rules need to be followed in order to ease the analysis process and allow the best usability of data. Here a few hints on how to draft a spreadsheet correctly .Row:
- First row has to be filled with variables' names
- Variables' names must not start with a number
- Variables' names must not display any special characters or symbol
- Short acronym or initials can be used in order to define the variables
- A brief description can be subsequently added during data check
- The first column (A1) need to be filled with the variable ID Subject
- All columns need to display just one variable
- Always double check all fields. All field left empty are recorded as missing observations.
- Always limit the alternate use of upper case and lower case letters. Prerred choice are lower case letters
- When a numeric value is input, be sure no other symbols are added (i.e. +,?,£)
- Take notice on how decimals are indicated (comma or point)
- If the considered study is not a longitudinal study (check specific considerations in "Common Mistakes" paragraph), there cannot be two identical ID in the spreadsheet
- When the considered study is a longitudinal study, there cannot be 2 identical time of observation
- When the considered study is a longitudinal study, the combination ID + time of observation is univocal
When different cells are merged, data are read as unicum. Taken the necessity to have all variables on first row for automathic reading, cell merging results in the loss of all necessary information.
First row displays cells merging, the second has all the variables. A spreadsheet made like this:
|ID Subject||Treatment 1||Treatment 2|
when considered for the analysis will appear like that
|ID Subject||Treatment 1||X1||X2||X3||X4||Treatment 2||X5||X6||X7||X8|
When specific fields need to be highlight, don’t choose colours, because the analysis system cannot recognize them as highlighted fields. Please use the given space in check window.
will appear like that when considered for the analysis
Follow up visits
When there is the need to present follow up observations, different options are available.
Follow up visits can be recorded in different worksheetsr
Variables can be indicated with their time of record
|ID Subject||Age||Height||Weight||Menarche||Pregnancy||Blood pressure T0||Blood pressure T6||Blood pressure T12|
The same patient ID can be entered in subsequent rows, while a specific variable is indicated the specific time frame of data recording
|ID Subject||Age||Height||Weight||Menarche||Pregnancy||Blood pressure||Study Time|