The documents in this file were developed by a team of PFR biometricians, with some based on work that has been developed over 20 years or more.
For more information, contact Ruth Butler at Ruth.Butler@plantandfood.co.nz

This file containes seven documents:

Three are Excel templates
PFR_Research_Template_SimpleExperiment.xltx
    For single trial, measurements taken at one level (usually 'Plot') only
PFR_Research_Template_MultiExperiment.xltx
    For multiple related trial, measurements taken at one level (usually 'Plot') only
PFR_Research_Template_MultiScale.xltx
    For single trial, measurements taken at more than one level (such as 'Plot', 'Plants within Plots)

To use, open the template file in Excel, then save it as a standard excel file (*.xlsx).

There are two documents with Guidance on using spreadsheets and also the templates:
  Good_practices_spreadsheets.pdf
  Guide_to_using_templates.pdf

And two documents with info on several of the most useful Excel tools:
  Key_skills_for_managing_data_in_Excel_2013.pdf
  Guide_to_pivot_tables_in_Excel_2013.pdf

