Page 114 - Water Loss Control

96 Cha pte r Ei g h t

such as Excel work sheets or Access databases, however these products have size
limitations, Excel (Pre 2007) can hold only 58,000 rows of information and Access can
store only 2 GB of data.
In many cases, good accurate data may not be available and the operator will have
to make a decision as to whether to use the questionable data or estimations or not. In
many cases it is better to do something rather than stop and do nothing. In this case, we
should be sure to note that the data was questionable or estimated and the operator’s
assessment of what should be done to improve this in future audits and how the data
should be used this time round.
The following section discusses good data management techniques.

8.2 Data Collection Worksheet
One of the first things we must do before starting to download field loggers and record-
ers is decide on the key factors, which we will be analyzing and assign relevant mea-
surement units and decimal places to each of the parameters. For example, in most
audits we will be measuring flow, measuring pressure, analyzing volumes, measuring
levels, and accounting for time periods.
Some of the units, which we might assign, are in the following section.
8.2.1 Flow

Metric
• Cubic meters per second
• Cubic meters per hour
• Liters per second
• Mega liters per day

U.S. Customary
• U.S. gallons per minute
• Imperial gallons per minute
• U.S. gallons per hour
• Imperial gallons per hour
• U.S. Kgallons per day
• Imperial Kgallons per day
• U.S. millions of gallons per day (mgd)
• Imperial millions of gallons per day (mgd)
• Cubic feet per second
• Cubic feet per hour
• Cubic feet per day
• Acre feet per day