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: Column: Data input

COMMON MISTAKES

Cell merge.

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
ID Subject Age Height Weight Menarche Pregnancy Age Height Weight Menarche Pregnancy
                     
                     
                     
                     
                     

when considered for the analysis will appear like that

ID Subject Treatment 1 X1 X2 X3 X4 Treatment 2 X5 X6 X7 X8
Age Height Weight Menarche Pregnancy Age Height Weight Menarche Pregnancy
                     
                     
                     
                     
                     

Colours

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.

This spreadsheet

ID Subject Age Height Weight Menarche Pregnancy Age Height Weight Menarche Pregnancy
                     
                     
                     
                     
                     

will appear like that when considered for the analysis

ID Subject Age Height Weight Menarche Pregnancy Age Height Weight Menarche Pregnancy
                     
                     
                     
                     
                     

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 worksheets

r

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
000014             T0
000014             T6
000014             T12