CALIBRATION OF SWOFFER 2100 VELOCITY METER--SAMPLE CALIBRATION SPREADSHEET
(Note:  This is a "dummy" spreadsheet without formulas behind the cells, for reference purposes on the Streamkeepers website.)
Text Box: Instructions: Copy (not move) this sheet (Edit/Move or Copy Sheet) to the end of the other sheets. Then unprotect it (Tools/Protection), label the tab according to the date of the calibration, and enter the data in the yellow boxes. All other boxes will be filled automatically. Mark the bags containing the rotors, indicating their calibration numbers and whether they are spares or primaries. Then set new calibration numbers into flow meters (see below).
DATE: 1/4/2005  
SITE: Flagstone Motel  
TESTERS: Josey Paul, Steve Bengtson
RUN LENGTH (FT): 20  
Replicate
Flow meter owner/# SK1 SK2 SK3 OPI CCD SK3
Rotor/prop unit # 7 2 8 4 5 9 2 1 1 2 5
4 @ slow speed: 299 355 341 279 337 335 318 386 326 322 329
  332 356 355 293 356 338 379 332 372 386 348
  312 358 344 318 320 292 280 349 283 313 324
  352 361 347 333 350 296 380 358 366 338 360
mean of slow runs 323.75 357.5 346.75 305.75 340.75 315.25 339.25 356.25 336.75 339.75 340.25
4 @ fast speed: 350 339 327 341 348 346 358 364 360 364 365
  378 296 324 345 358 357 380 374 374 371 355
  350 335 331 340 362 348 362 365 353 360 356
  383 337 347 349 362 350 376 372 373 373 360
mean of fast runs 365.25 326.75 332.25 343.75 357.5 350.25 369 368.75 365 367 359
Mean for all runs 344.5 342.125 339.5 324.75 349.125 332.75 354.125 362.5 350.875 353.375 349.625
Mean for 10' run 172.25 171.0625 169.75 162.375 174.5625 166.375 177.0625 181.25 175.4375 176.6875 174.8125
Calibration #: 172 171 170 162 175 166 177 181 175 177
Primary/Spare P S P S P S S P S P
Coefficient of variation between replicate "mean for all runs": 349.625 (Spreadsheet will enter this value for you from the values entered above.)
... and initial "mean for all runs" for that rotor: 349.125 (Put the cursor after the "=" sign and then click in the appropriate cell.)
… equals 1.414*ABS(DIFFERENCE/SUM) = 0.001 (Spreadsheet will calculate for you.)
(Coefficient of variation should be <=0.01 for desired precision level.)
Text Box: SETTING NEW CALIBRATION NUMBERS INTO FLOW METERS: After performing the calibration check, note which rotor/prop unit is to be the primary for each meter. Then reset the calibration number on the meter with the number of its primary, following manufacturer's instructions. (Briefly, unscrew the black screw under the "Feet/Cal Adjust" mark; turn the dial to "Calibrate"; use a small flat-headed screwdriver to adjust the set screw inside the chamber, until the number is the number of that meter's primary rotor; turn off the meter and rescrew the black screw.)
[LAST MODIFIED 1/4/05]