This document is to provide a manual for
reporting via Excel
spreadsheets to the Water Commissioner for Summit County (Troy
Winegard as of
calendar year 2019)
Before the spreadsheet can be filled out, the
person running
the ditches must record data on each visit to the head gates. This
does not have
to be done on a daily or even weekly basis but each visit should
record. Anytime there
is a change in the reading, the
reason for the change should be noted. For example, when the head
gate is turned
on; when the flow is increased or decreased; off for repairs; on
after repairs
etc. Another reason is just that the flow into the flume has
dropped because
there is not enough water getting diverted.
Date also has to be recorded. Time of day does not.
Readings are reported as follows:
The reading on this gauge is 0.22, not 2.2. In
general there
should be no numbers greater than 1.0 in the readings.
There are three ditches on Ruby Ranch. The
southern most is the Sawmill, the middle is the Ruth, and the
northern most is the Ruby. These instructions will use the Ruth as
an example.
There will be a spreadsheet called
WaterDiversions_RubyRanch_template.xls
If the reporting is for calendar year 2019,
copy this file
to
WaterDiversions_RubyRanch_2019.xls
and edit this file for the year 2019.
You always want to start with the template file because of the way
the cells in the spreadsheet are linked to each other, and when
you enter a change in the Flume reading for a specific day, the
link for that day purposely breaks.
Here is what the Ruth looks with no data
entered:
After these three cells are changed, then you have to put the
date entries in. These entries will always go under the Gauge and
Comments column. No other columns will be touched.
Here is an example of what the 2018 Ruth looks like filled in:
Do this for each of the three ditches and then email to
troy.wineland@state.co.us
That is all there really is to this.
I am also providing the 2018 spreadsheet here so you can see one
completely filled out:
WaterDiversions_RubyRanch_2018.xls
This page maintained by Don Samuels
This page last updated 08/13/2019