DESCRIPTION OF UPPER PENTICTON CREEK FILES WITH ALL DAILY DATA FOR A STATION IN ONE FILE
Last edit 8 November 2019  Dave Spittlehouse 


readme file edited 19 February 2021 R.D. Moore
 - file names changed to those used in the repository, along with other minor edits
# ===============================================================================================================

Daily data as Excel spreadsheets for all of a station's record

File name structure: met_dly_px.xlxs (px is the station name)

met_dly_p1_raw.xlxs : 22 August 1991 to 6 October 2019. Data as recorded at p1 with gap filling from p3, p4 and pj. 
met_dly_p1_reference.xlxs : 
      1 September 1983 - 6 October 2019. Data adjusted from p0 for Sept 1983 to Feb 1991.
      As recorded at p1 until 2006 with gap filling from p3, p4 and pj and then adjusted pj temperature 
      and wind speed to acount for influence of growing trees on the measurements.
met_dly_p3.xlxs : 22 August 1991 to 31 August 2009 with gap filling from p1
met_dly_p5.xlxs : 1 January 1996 to 6 October 2019 with gap filling from p1
met_dly_pb.xlxs : 22 July 1999 to 16 October 2019 with gap filling from p1, pj and pc
met_dly_pc.xlxs : 1 September 1999 to 16 October 2019 
met_dly_pj.xlxs : 22 October 2005 to 16 October 2019 with gap filling from p1
met_dly_pk.xlxs : 21 September 2017 to 6 October 2019 no gap filling 

Each spreadsheet has the following worksheets:

 - Data worksheet: Daily data gap measured and gap filled where necessary. Monthly and annual pivot tables. 
 - Monthly worksheet: Monthly data from pivot table in Data and calculation of monthly Hargreaves reference 
   evaporation and climatic moisture deficit.  
 - MGraphs worksheet: Graphs of monthly data
 - AGraphs worksheet: Graphs of annual data
 - Meta worksheet: Measurements, explanation of gap filling and calculations

See the individual annual daily files for original data and information not included in these files (e.g., wind direction).
Contact D. Spittlehouse for access to annual files.

Measurements vary by site and by year at a site

Daily data:

 - Incident solar radiation (MJ/m2/d) for clearcut sites (p1, p3, pb, pj and pk)
 - Reflected solar radiation (MJ/m2/d) for clearcut sites (p1, pb, pj and pk)
 - Average air temperature ~2.5 m (C)
 - Maximum air temperature ~2.5 m (C)
 - Minimum air temperature ~2.5 m (C)
 - Average relative humidity ~2.5 m (%)
 - Minimum relative humidity ~2.5 m (%)
 - Average wind speed ~3 m (m/s) for clearcut sites (p1, p3, pb, pj and pk)
 - Daily maximum  wind speed ~3 m (m/s) for clearcut sites (p1, p3, pb, pj and pk)
 - Daily precipitation (mm) for clearcut sites (p1, p3, pb, pj and pk)
 - Snow depth at end of day (2400) (mm)
 - Snow pack temperature (C)
 - Average Infra red surface temperature (C)
 - Maximum Infra red surface temperature (C)
 - Minimum Infra red surface temperature (C)
 - 0.005 m average soil temperature (C)
 - 0.2 m average soil temperature (C) (Not pk)
 - 0.5 m average soil temperature (C)
 - Afternoon vapour pressure (kPa) calculated from Tmax and RHmin
 - Daily maximum vapour pressure deficit (kPa) calculated from Tmax and RHmin

Monthly and annual calculations:

 - Averages, totals and extremes of daily data
 - Albedo for clearcut sites (p1, pb and pj)
 - Monthly Hargreaves reference evaporation (mm) for clearcut sites (p1, p3, pb, pj and pk)
 - Monthly Climatic moisture deficit (mm) for clearcut sites (p1, p3, pb, pj and pk)