IARC 207 Wiki - User contributions [en]

K1 Burn

2008-08-29T22:39:12Z

137.229.71.165:

==== June 2008 Trip ====
* Download Data
* Send new program (snow sensor)
* add net radiometer

==== Problem Sensors (as of June 2008) ====
* Met Sensors look good.
* All Soil sensors are broken (animal chew primarily)
* Snow is odd but perhaps okay. [[Image:K1-snow.gif|400px]]
June 14 trip follow up: The snow arm came undone (I'm guessing time-wise early in the winter). So, the data is probably bad until we can figure something else out for this site.

=== Site Data ===
[http://www.uaf.edu/water/projects/atlas/metdata/Kougaroksites/k-burn/current-raw.html Current Data Headers]<br>
[http://www.uaf.edu/water/projects/near-real-time/rawdatafiles/atlas-k-burn Raw Data Archive]<br>
[http://www.uaf.edu/water/projects/atlas/kougarok/k1/k1.html Processed Data Archive]<br>

==== Sensors Installed at this Station ====

* 1m HMP45C Air Temperature / Relative Humidity
* 3m HMP45C Air Temperature / Relative Humidity
* 1m Wind Speed
* 3m Wind Speed / Wind Direction
* Summer Precipitation
* Net Radiation (summer only)
* Campbell Scientific SR50A Sonic Snow Depth Sensor (Added 9/2007)

=== Site To Do List ===

=== Site Log / Visits ===
Net Radiometer Q99113 Installed 6/14/2008
Positive Coefficient: 9.35 W/m^2/mV, Negative Coefficient: 11.42 W/m^2/mV
Freewave Radio DGR115W (waterproof model) 906-6020
SM192 16752
CR10X 25755
1m HMP45C Z1730124
3m HMP45C Z2830048

===2007 To do===
Bring out new wiring for the multiplexer and also precision resistors to put into the broken soil temperature slots. This is follow up to the bogus resistance being measured in the new thermistor string installed August 2008. My away from the site guess is that there's a foul up in the multiplexer wiring rather than a problem with the data logger but would be good to bring a new logger and wiring panel out just in case.

NSF Sites Notes from Bob

2008-08-20T19:50:56Z

137.229.71.165:

=Betty Pingo=
All Sensors look decent. The exception is net radiation but that will be pulled now so it doesn't really matter at present.

=West Dock=
All Sensors look decent.

=Franklin Bluffs=

=West Kuparuk=

''Soil Temperatures''

Maybe a loose wire on the multiplexer for the soil temperature sensors. Started 6/26/08 and have had some good data briefly in early August but otherwise the data is bad.

7/27/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/28/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/29/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/30/2008 -10.8 -10.8 -10.9 -11.1 -11.2 -11.7 -12.8 -14.5 -16.0 -16.4 -16.7
7/31/2008 -11.4 -11.3 -11.4 -11.5 -11.6 -12.1 -13.1 -14.7 -16.0 -16.4 -16.7
8/1/2008 -11.4 -11.2 -11.2 -11.4 -11.6 -12.2 -13.4 -14.8 -16.0 -16.4 -16.7
8/2/2008 -11.2 -11.1 -11.1 -11.3 -11.4 -12.1 -13.4 -14.8 -15.9 -16.4 -16.7
8/3/2008 -10.5 -10.2 -10.4 -11.0 -11.2 -12.1 -13.4 -14.8 -15.9 -16.4 -16.7
8/4/2008 -9.5 -9.3 -9.4 -10.0 -8.8 -10.0 -11.8 -13.6 -15.9 -16.4 -16.7
8/5/2008 -9.6 -9.4 -9.5 -10.0 -10.3 -11.2 -12.8 -14.6 -15.9 -16.4 -16.6
8/6/2008 -9.6 -9.4 -9.5 -10.0 -10.2 -11.2 -12.7 -14.5 -15.9 -16.4 -16.6
8/7/2008 -10.0 -9.9 -9.9 -10.3 -10.4 -11.1 -12.6 -14.4 -15.9 -16.4 -16.6
8/8/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!

''Meteorological''
Looks like something strange beginning on 6/25/08. Sensors begin to read correctly again on 7/30/08 and then are spotty beginning 8/11/08. Not sure the deal but my money would be on replacing the data logger, perhaps more of that lightening stuff. But, importantly, there appears to be good data mixed in with the bad so I don't think it's bear damage.

Affected sensors:
AT/RH @ 1m, 3m, 10m
Longwave Radiation
Shortwave Radiation
Battery Voltage
Panel Temperature
Precipitation
Net Radiation

NSF Sites Notes from Bob

2008-08-20T19:18:30Z

137.229.71.165:

=Betty Pingo=
All Sensors look decent. The exception is net radiation but that will be pulled now so it doesn't really matter at present.

=West Kuparuk=

''Soil Temperatures''

Maybe a loose wire on the multiplexer for the soil temperature sensors. Started 6/26/08 and have had some good data briefly in early August but otherwise the data is bad.

7/27/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/28/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/29/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/30/2008 -10.8 -10.8 -10.9 -11.1 -11.2 -11.7 -12.8 -14.5 -16.0 -16.4 -16.7
7/31/2008 -11.4 -11.3 -11.4 -11.5 -11.6 -12.1 -13.1 -14.7 -16.0 -16.4 -16.7
8/1/2008 -11.4 -11.2 -11.2 -11.4 -11.6 -12.2 -13.4 -14.8 -16.0 -16.4 -16.7
8/2/2008 -11.2 -11.1 -11.1 -11.3 -11.4 -12.1 -13.4 -14.8 -15.9 -16.4 -16.7
8/3/2008 -10.5 -10.2 -10.4 -11.0 -11.2 -12.1 -13.4 -14.8 -15.9 -16.4 -16.7
8/4/2008 -9.5 -9.3 -9.4 -10.0 -8.8 -10.0 -11.8 -13.6 -15.9 -16.4 -16.7
8/5/2008 -9.6 -9.4 -9.5 -10.0 -10.3 -11.2 -12.8 -14.6 -15.9 -16.4 -16.6
8/6/2008 -9.6 -9.4 -9.5 -10.0 -10.2 -11.2 -12.7 -14.5 -15.9 -16.4 -16.6
8/7/2008 -10.0 -9.9 -9.9 -10.3 -10.4 -11.1 -12.6 -14.4 -15.9 -16.4 -16.6
8/8/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!

''Meteorological''
Looks like something strange beginning on 6/25/08. Sensors begin to read correctly again on 7/30/08 and then are spotty beginning 8/11/08. Not sure the deal but my money would be on replacing the data logger, perhaps more of that lightening stuff. But, importantly, there appears to be good data mixed in with the bad so I don't think it's bear damage.

Affected sensors:
AT/RH @ 1m, 3m, 10m
Longwave Radiation
Shortwave Radiation
Battery Voltage
Panel Temperature
Precipitation
Net Radiation

NSF Sites Notes from Bob

2008-08-20T18:53:47Z

137.229.71.165:

West Kuparuk:

''Soil Temperatures''

Maybe a loose wire on the multiplexer for the soil temperature sensors. Started 6/26/08 and have had some good data briefly in early August but otherwise the data is bad.

7/27/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/28/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/29/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!
7/30/2008 -10.8 -10.8 -10.9 -11.1 -11.2 -11.7 -12.8 -14.5 -16.0 -16.4 -16.7
7/31/2008 -11.4 -11.3 -11.4 -11.5 -11.6 -12.1 -13.1 -14.7 -16.0 -16.4 -16.7
8/1/2008 -11.4 -11.2 -11.2 -11.4 -11.6 -12.2 -13.4 -14.8 -16.0 -16.4 -16.7
8/2/2008 -11.2 -11.1 -11.1 -11.3 -11.4 -12.1 -13.4 -14.8 -15.9 -16.4 -16.7
8/3/2008 -10.5 -10.2 -10.4 -11.0 -11.2 -12.1 -13.4 -14.8 -15.9 -16.4 -16.7
8/4/2008 -9.5 -9.3 -9.4 -10.0 -8.8 -10.0 -11.8 -13.6 -15.9 -16.4 -16.7
8/5/2008 -9.6 -9.4 -9.5 -10.0 -10.3 -11.2 -12.8 -14.6 -15.9 -16.4 -16.6
8/6/2008 -9.6 -9.4 -9.5 -10.0 -10.2 -11.2 -12.7 -14.5 -15.9 -16.4 -16.6
8/7/2008 -10.0 -9.9 -9.9 -10.3 -10.4 -11.1 -12.6 -14.4 -15.9 -16.4 -16.6
8/8/2008 #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM! #NUM!

Sept 2008 Field Trip - Emily and Ken

2008-08-20T18:45:14Z

137.229.71.165:

''Ken add stations that need conduit and bear fencing.''

[[NSF Sites Notes from Bob]]

'''Note:''' Sites are grouped by area.

== Day 1 & 2 West of Dalton Highway (White Hills Area)==
1. [[West Kuparuk met]]:
* Troubleshoot station

2. [[dfm4| DFM4 NW Kuparuk Met]] DFM4:
* '''Add Electric Fence'''
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

3. [[dfm2| DFM2 White Hills met]] Bear Damage:
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

4. [[dfm3| DFM3 North White Hills Met]]
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

5. [[dfm1| DFM1 South White Hills Met]] (if time)
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

== Day 3 and 4 (Bullen Area/Kavik Area) ==

6. [[dbm7| DBM7 Kadleroshilik Met]] DBM7 Snow Sensor:
* Check net radiometer - readings went bad after we left the site
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

7. [[dbm8| DBM8 Bullen Met]] DBM8
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

8. [[dbm4| DBM4 Sag-Ivi Met]] DBM4:
* '''Add E-Fence'''
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

9. [[dbm5| DBM5 Upper Kad Met]] DBM5:
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area
* '''Add E-Fence???'''

10. [[dbm6| DBM6 Kavik Met]]:
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

== Day 5 & 6 (Mountain Sites) ==

11. [[dbm3| DBM3 Juniper Met]] DBM3
* North fence needs another post,
* solar panel wires are exposed, needs "plates" or other protection
* install conduit
* Swap HMP45C
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

12. [[dbm1| DBM1 Accomplishment Cr Met]] DBM1 (if time)
* Swap HMP45C
* install conduit if time permits
* install solar panel plate (larger size)
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

13. [[dbm2| DBM2 Ribdon Cr Met]] DBM2 (if time)
* Swap HMP45C
* install conduit
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

Sept 2008 Field Trip - Emily and Ken

2008-08-20T18:44:58Z

137.229.71.165:

''Ken add stations that need conduit and bear fencing.''
[[NSF Sites Notes from Bob]]

'''Note:''' Sites are grouped by area.

== Day 1 & 2 West of Dalton Highway (White Hills Area)==
1. [[West Kuparuk met]]:
* Troubleshoot station

2. [[dfm4| DFM4 NW Kuparuk Met]] DFM4:
* '''Add Electric Fence'''
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

3. [[dfm2| DFM2 White Hills met]] Bear Damage:
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

4. [[dfm3| DFM3 North White Hills Met]]
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

5. [[dfm1| DFM1 South White Hills Met]] (if time)
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

== Day 3 and 4 (Bullen Area/Kavik Area) ==

6. [[dbm7| DBM7 Kadleroshilik Met]] DBM7 Snow Sensor:
* Check net radiometer - readings went bad after we left the site
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

7. [[dbm8| DBM8 Bullen Met]] DBM8
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

8. [[dbm4| DBM4 Sag-Ivi Met]] DBM4:
* '''Add E-Fence'''
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

9. [[dbm5| DBM5 Upper Kad Met]] DBM5:
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area
* '''Add E-Fence???'''

10. [[dbm6| DBM6 Kavik Met]]:
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

== Day 5 & 6 (Mountain Sites) ==

11. [[dbm3| DBM3 Juniper Met]] DBM3
* North fence needs another post,
* solar panel wires are exposed, needs "plates" or other protection
* install conduit
* Swap HMP45C
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

12. [[dbm1| DBM1 Accomplishment Cr Met]] DBM1 (if time)
* Swap HMP45C
* install conduit if time permits
* install solar panel plate (larger size)
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

13. [[dbm2| DBM2 Ribdon Cr Met]] DBM2 (if time)
* Swap HMP45C
* install conduit
* Add bark chips
* Measure distance from ground to snow sensor
* Take photos of site and snow sensor area

Main Page

2008-08-04T23:49:00Z

137.229.71.165: /* site logs and todo lists */

= WERC research sites wiki =

This is a collaborative website for people involved with WERC's research stations, in any of several different projects:

== site logs and todo lists ==
* [[all projects]] todo and site logs
* [[June 2008 Field Trip - Emily and Ken]] General ToDo List
* [[North Slope Kuparuk]]
* [[North Slope Bullen]]
* [[North Slope Foothills]]
* [[Seward Peninsula Sites]]

== WERC field books ==
* [[ken 2005 1]]
* [[ken 2005-2]]
* [[ken 2006-1]]
* [[ken 2007-1]]

== Field notes and procedures ==

* Using the [[Sontek handheld ADP]]
* Using the [[Sontek Rivercat and Toughbook]]
* Using the [[Flo-Mate]] flow meter
* Using the [[RDI StreamPro ADCP]]
* [[WERC Snow Survey Procedure]]

== Some other good things to know ==
* [[Common Instrumentation]] links
* [[Software]] we use
* [[New Person]] in the department guide
* [[Troubleshooting]] sensors etc.
* [[Common Sensor Wiring]]

--

== ''Meta-topics'' on the use & setup of the WERC wiki ==
* editing wiki pages
* [[implementing site todo lists and logs]]

Double Line Delete

2008-08-01T20:59:13Z

137.229.71.165:

Use this Macro to delete duplicate lines from the online shand data (off the WERC website). This data appears sometimes do to hiccups in the syncing stuff. So, if you run this macro here you'll delete the incomplete first line of data and keep just the complete second line.

See Bob for questions.

Sub deleter()
'
' deleter Macro
' Macro recorded 7/30/2008 by
'
'
Dim row As Long
Dim nextrow As Long
Dim curday As Double
Dim curtime As Double
Dim curdt As Double
Dim nextday As Double
Dim nexttime As Double
Dim nextdt As Double
Dim worksheetz As Integer
Dim daycol As Integer
Dim timecol As Integer
worksheetz = 2
row = 4
daycol = 6
timecol = 7
curtime = Worksheets(worksheetz).Cells(row, timecol).Value
curday = Worksheets(worksheetz).Cells(row, daycol).Value
curdt = curday + curtime / 2400
row = row + 1
Do While Worksheets(worksheetz).Cells(row, daycol).Value <> ""
nexttime = Worksheets(worksheetz).Cells(row, timecol).Value
nextday = Worksheets(worksheetz).Cells(row, daycol).Value
nextdt = nextday + nexttime / 2400
If nextdt = curdt Then
Rows(CStr(row - 1) & ":" & CStr(row - 1)).Select
Selection.Delete Shift:=xlUp
Else
curdt = nextdt
row = row + 1
End If
Loop
End Sub

Excel Macros

2008-08-01T20:35:19Z

137.229.71.165:

== Handy Code Snippets ==
This page contains links to several Excel Macros. Feel free to use or add additional ones.
* [[Save Macros in Excel]]-- a brief How-To
* [[Tool Bar Button|Create a Toolbar button]] -- a brief How-To (useful with some macros)
* [[Julian to regular date converter]]
* [[Regular Date to Julian Converter]]
* [[Calculate Daily Averages / Sums from hourly data| MicroMet Format Daily Averages]]
* [[Daily Averages 2| General Daily average Macro]]
* [[Freezing / Thawing Indices]]
* [[Double Line Delete| Line Deleter for going through online data from shand]]
* [[Cell Wrap]] -- Useful for long column headers in data spreadsheets.
* [[Data Split]] -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel

Daily Averages 2

2008-08-01T20:30:44Z

137.229.71.165:

Copy and paste the text in the box into the visual basic editor that comes with Excel. To get access to personal.xls in the visual basic editor check out this article: [[Save Macros in Excel]]

This macro and collection of subroutines creates daily averages from hourly data. It's a pretty general one. I used it originally with soil temperature strings where there are several columns of data that need to be changed from hourly to daily. So, there are a couple flags to assist with this. You can report the day if you'd like and also the number of samples in the 'daily' average for example. The first subroutine you can use to call the second one which does all the work for you.

Any questions check with Bob.

Option Explicit
Public Sub daily_avg()
Dim daycol As Integer
Dim inputcol As Integer
Dim outcol As Integer
Dim worksheetz As Integer
Dim startrow As Long
Dim outputday As Boolean
Dim outputcount As Boolean
Dim columnincr As Integer

' stuff that should be set just initially
daycol = 1
worksheetz = 9
startrow = 32
outputcount = False
outputday = True
inputcol = 3
outcol = 16
Call avg_column(daycol, inputcol, outcol, worksheetz, startrow, outputday, outputcount)
outputday = False
For columnincr = 0 To 10
inputcol = 4 + columnincr
outcol = 18 + columnincr
Call avg_column(daycol, inputcol, outcol, worksheetz, startrow, outputday, outputcount)
Next
End Sub

Public Sub avg_column(daycol As Integer, inputcol As Integer, outcol As Integer, worksheetz As Integer, startrow As Long, outputday As Boolean, outputcount As Boolean)
Dim row As Long
Dim count As Integer
Dim theday As Integer
Dim curdata As Double
Dim daysum As Double
Dim outrow As Integer

outrow = startrow
row = startrow

theday = Int(Worksheets(worksheetz).Cells(row, daycol).Value)
curdata = Worksheets(worksheetz).Cells(row, inputcol).Value
If Abs(curdata) < 6999 Then
daysum = curdata
count = 1
End If
row = row + 1
Do While Worksheets(worksheetz).Cells(row, daycol).Value <> ""
If theday = Int(Worksheets(worksheetz).Cells(row, daycol).Value) Then
' same day
curdata = Worksheets(worksheetz).Cells(row, inputcol).Value
If Abs(curdata) < 6999 Then
daysum = daysum + curdata
count = count + 1
End If
Else:
' new day, do some outputting
If outputday = True Then
' output the day
Worksheets(worksheetz).Cells(outrow, outcol).Value = theday
If count > 0 Then
' output daily average
Worksheets(worksheetz).Cells(outrow, outcol + 1).Value = daysum / count
End If
If outputcount = True Then
' output the count if the boolean is true
Worksheets(worksheetz).Cells(outrow, outcol + 2).Value = count
End If
Else:
' don't output the day
If count > 0 Then
' output daily average
Worksheets(worksheetz).Cells(outrow, outcol).Value = daysum / count
End If
If outputcount = True Then
' output the count if the boolean is true
Worksheets(worksheetz).Cells(outrow, outcol + 1).Value = count
End If
End If
outrow = outrow + 1
' okay, done outputting. Now to ingest the new data as before.
' first reset the vars.
count = 0
daysum = 0
theday = Int(Worksheets(worksheetz).Cells(row, daycol).Value)
curdata = Worksheets(worksheetz).Cells(row, inputcol).Value
If Abs(curdata) < 6999 Then
daysum = curdata
count = 1
End If

End If
row = row + 1
Loop
' drop in the stuff for the last day of year.
' new day, do some outputting
If outputday = True Then
' output the day
Worksheets(worksheetz).Cells(outrow, outcol).Value = theday
If count > 0 Then
' output daily average
Worksheets(worksheetz).Cells(outrow, outcol + 1).Value = daysum / count
End If
If outputcount = True Then
' output the count if the boolean is true
Worksheets(worksheetz).Cells(outrow, outcol + 2).Value = count
End If
Else:
' don't output the day
If count > 0 Then
' output daily average
Worksheets(worksheetz).Cells(outrow, outcol).Value = daysum / count
End If
If outputcount = True Then
' output the count if the boolean is true
Worksheets(worksheetz).Cells(outrow, outcol + 1).Value = count
End If
End If
End Sub

Excel Macros

2008-08-01T19:44:16Z

137.229.71.165:

== Handy Code Snippets ==
This page contains links to several Excel Macros. Feel free to use or add additional ones.
* [[Save Macros in Excel]]-- a brief How-To
* [[Tool Bar Button|Create a Toolbar button]] -- a brief How-To (useful with some macros)
* [[Julian to regular date converter]]
* [[Regular Date to Julian Converter]]
* [[Calculate Daily Averages / Sums from hourly data| MicroMet Format Daily Averages]]
* [[Daily Averages 2| General Daily average Macro]]
* [[Freezing / Thawing Indices]]
* [[Cell Wrap]] -- Useful for long column headers in data spreadsheets.
* [[Data Split]] -- Short Macro for splitting comma & tab separated data such as when you open a .txt file in Excel