Spreadsheet: 108054d1305153643-average-if-type-of-function-sample-file
Sheet: Sheet1

 |  |  | Pump
 | Well [NAME] | Well # | Test |  |  |  | Well [NAME] | Amount | Average GPM
East
 | ANDREWS | 48A | 700 |  |  |  | [NAME] | 44 | 340.027027027027 | 285.9318181818182
 | ANDREWS | 58A | 580 |  |  |  | Cache Creek | 8
 | ANDREWS | 59A | 630 |  |  |  | DBE | 7
 | ANDREWS | 62A | 750 |  |  |  | Hydro | 14
 | ANDREWS | 67A | 680 |  |  |  | Pacific Coast | 7
 | ANDREWS | 68C |  |  |  |  | RoadRunner | 19
 | ANDREWS | 69A | 700 |  |  |  | WSE | 32
 | ANDREWS | 69C |  |  |  |  | Existing | 8
 | ANDREWS | 74E |  |  |  |  | Total | 139
 | ANDREWS | 65E
 | ANDREWS | 71E
 | CACHE CREEK | 55D
 | CACHE CREEK | 75B/69E
 | DBE | 40A | 200
 | DBE | 41A | 700
 | DBE | 47A | 690
 | DBE | 54A | 620
 | DBE | 56D
 | EXISTING | 49E | 400
 | EXISTING | 63C | 923
 | EXISTING | 72B | 465
 | EXISTING | 72D | 525
 | EXISTING | 72E | 550
 | EXISTING | 73B | 590
 | EXISTING | 73E | 520
 | EXISTING | 74B | 630
 | HYDRO | 48B | 730
 | HYDRO | 48E | 700
 | PACIFIC COAST | 54C
 | PACIFIC COAST | 55E
 | PACIFIC COAST | 66A
 | ROADRUNNER | 52C
 | ROADRUNNER | 56E
 | ROADRUNNER | 64D/57D
 | ROADRUNNER | 70B
 | ROADRUNNER | 58B
 | WSE | 48D
 | WSE | 52A | 425
 | WSE | 54B
 | WSE | 55A | 650
 | WSE | 69B
North
 | ANDREWS | 33A | 255
 | ANDREWS | 35B | 150
 | ANDREWS | 95E | 400
 | ANDREWS | 18A | 550
 | ANDREWS | 18C | 300
 | ANDREWS | 34A | 300
 | ANDREWS | 34C | 350
 | ANDREWS | 35C | 150
 | ANDREWS | 7A | 310
 | ANDREWS | 95B | 300
 | ANDREWS | 95D | 425
 | CACHE CREEK | 16E
 | CACHE CREEK | 18E
 | CACHE CREEK | 26D | 375
 | CACHE CREEK | 32A
 | CACHE CREEK | 32C
 | CACHE CREEK | 6C
 | DBE | 26A | 520
 | DBE | 8A | 600
 | HYDRO | 26C | 400
 | HYDRO | 8D | 550
 | ROADRUNNER | 14D
 | ROADRUNNER | 15A
 | ROADRUNNER | 25C
 | ROADRUNNER | 25D
 | ROADRUNNER | 33C
 | WSE | 16A | 400
 | WSE | 16D
 | WSE | 17A | 650
 | WSE | 18B | 550
 | WSE | 23D
 | WSE | 25A | 285
 | WSE | 35A | 200
 | WSE | 95C | 300
SW
 | ANDREWS | 84A | 580
 | ANDREWS | 85A | 500
 | ANDREWS | 86A | 400
 | ANDREWS | 87A | 365
 | ANDREWS | 89A | 500
 | HYDRO | 85B | 450
 | HYDRO | 85E | 550
 | HYDRO | 86B | 400
 | HYDRO | 86E | 360
 | HYDRO | 89C | 427
 | HYDRO | 90A | 424
 | HYDRO | 93A | 460
 | HYDRO | [NAME] | 431
Chism
 | ANDREWS | 102A | 80
 | ANDREWS | 102E | 80
 | ANDREWS | 103A | 68
 | ANDREWS | 103E
 | ANDREWS | 104A | 200
 | ANDREWS | 104C | 171
 | ANDREWS | 105C | 300
 | ANDREWS | 105D | 250
 | ANDREWS | 105E | 139
 | ANDREWS | 106A | 106
 | ANDREWS | 108A | 315
 | ANDREWS | 108C | 59
 | ANDREWS | 109A
 | ANDREWS | 110D | 218
 | ANDREWS | 113B/109E | 189
 | ANDREWS | 113D | 272
 | ANDREWS | 113E/115C | 259
 | HYDRO | 123D | 205
 | HYDRO | 126C | 115
 | PACIFIC COAST | 120D
 | PACIFIC COAST | 120E
 | PACIFIC COAST | 124B
 | PACIFIC COAST | 126B
 | ROADRUNNER | 105A | 400
 | ROADRUNNER | 110A | 220
 | ROADRUNNER | 112B | 285
 | ROADRUNNER | 112C | 262
 | ROADRUNNER | 113A | 252
 | ROADRUNNER | 113C
 | ROADRUNNER | 117A | 125
 | ROADRUNNER | 122D | 130
 | ROADRUNNER | 123B
 | WSE | 108D | 285
 | WSE | 109C | 170
 | WSE | 111A | 130
 | WSE | 112A | 239
 | WSE | 112E | 234
 | WSE | 115A
 | WSE | 115E
 | WSE | 116A | 146
 | WSE | 116E | 250
 | WSE | 118A | 95
 | WSE | 118B | 120
 | WSE | 119A | 300
 | WSE | 119D | 110
 | WSE | 120B
 | WSE | 120C
 | WSE | 121B
 | WSE | 122A | 154
 | WSE | 123A | 300
 | WSE | 126A | 150