Search results

...s made using the Comment per page function can be viewed and exported into Excel by the intervention author. * You can export the comments into an Excel spreadsheet by clicking on '''Export all Comments''' at the bottom of the p

For converting columns of data in Excel: ...''' or '''Time'''. See screenshots below for the columns you will need in Excel and the formula.

For converting columns of data in Excel: ...''' or '''Time'''. See screenshots below for the columns you will need in Excel and the formula.

Sometimes in large interventions the dataset is too large to export as an excel file. In this case, you can export the data in CSV format.

...s have been randomised to can be found in the '''User Data''' worksheet in Excel. Please [[http://wiki.lifeguideonline.org/wiki/How_do_I_export_data_from_my

...will still be collected by the intervention manager and can be exported to excel.

...data. Short names are also recommended as these will be easier to view in Excel. ...eful when analysing your data because these names will be displayed in the Excel spreadsheet when you export your data. The '''Response Text''' is the respo

...you will be able to view this data in the '''User data''' worksheet of the Excel file, which you can export.

...sheets, making it easier to clean your data and download larger data sets (Excel 2010 can't cope with more than 16,384 columns so deleting empty columns hel ...nction. This will ensure that your data is saved as '''User Data''' in the Excel file, and if there are any server problems or internet outages, your data w

...tems on the page will determine the order in which the data is exported to Excel, which may be helpful when interpreting the data.

...tems on the page will determine the order in which the data is exported to Excel, which may be helpful when interpreting the data.

* File Format: Select either Excel (2007+) or CSV.

...above, you will find this variable in the '''User Details''' sheet of the Excel Spreadsheet that you export. Please [[http://wiki.lifeguideonline.org/wiki/

...data. Short names are also recommended as these will be easier to view in Excel. ...eful when analysing your data because these names will be displayed in the Excel spreadsheet when you export your data. The '''Response Text''' is the respo

...already collected will be separate (in the Intervention Manager and in the Excel spreadsheet) to the data which will be collected when end-users view the ne

...already collected will be separate (in the Intervention Manager and in the Excel spreadsheet) to the data which will be collected when end-users view the ne

* Click on '''Export''' and you can then choose to open or save the Excel files that are generated. ...ade using the Comment per page function can be viewed and/or exported into Excel by the intervention author.

* Click on '''Export''' and you can then choose to open or save the Excel files that are generated. ...ade using the Comment per page function can be viewed and/or exported into Excel by the intervention author.

* Click on '''Export''' and you can then choose to open or save the Excel files that are generated. ...already collected will be separate (in the Intervention Manager and in the Excel spreadsheet) to the data which will be collected when end-users view the ne

* File Format: Select either Excel (2007+) or Comma Separated Value (CSV).