How do you create an excel macro report?

How do you create an excel macro report?

As GENEActiv outputs raw data, you are able to carry out analysis using any type of software, including Matlab & R free packages. You can also use Excel macro reports; we provide some standard reports free for you to use – you can download these from our sister site, https://open.geneactiv.org. In order to use them please follow the instructions below:

  1. Download the data from your device using the GENEActiv software (data extractor tab – see instruction manual for more details).  This will talk you through how to covert and analyse the data.  Once you have converted the data into a .csv epoch file, open up the Excel macro report
  2. Click ‘Import data’ (this is the data you will have downloaded off the device) and insert the .csv epoch file (e.g. 60 seconds) and click Ok.
  3. Click ‘Generate graphs’.  Once the graphs have been generated, you will see a number of tabs along the bottom row of the Excel page – e.g. (‘Front page’, Day graphs, ‘Night graphs’), each displaying the relevant graph.
  4. The report has now been generated and is able to be printed.