Spreadsheet: 123287d1317503806-hlookup-water-bill
Sheet: Q2-Q8

Customer Name | Cust Type | [NAME] | Taxable | Billing Year | Gal Used | Gal Billed | Water Bill | Tax | Total [NAME] |  |  |  |  |  |  |  |  | Tax Rate | 0.035
Red Lake Chapter | NPROFIT | No | Yes | 2013 | 108300
Amity Church | NPROFIT | Yes | No | 2013 | 55160
Church of Christ | NPROFIT | Yes | No | 2013 | 32430
NM State Highway | GOV | No | No | 2013 | 95660
Spot Free Power Wash | COM | No | Yes | 2013 | 281200
CIT Apartment Complex | COM | No | Yes | 2013 | 257000
Housing Agency | GOV | No | No | 2013 | 23300
Pinon Pizza Edge | COM | No | Yes | 2013 | 81110
Department of Agriculture | GOV | No | No | 2013 | 2783000
Chevron Station | COM | No | Yes | 2013 | 1131600
O B Trailer Service | COM | No | Yes | 2013 | 360800
Red Mesa Express | COM | No | Yes | 2013 | 392600
Inscription House Irrigation | GOV | No | No | 2013 | 895300
Pure Lake Building | COM | No | Yes | 2013 | 59240
Assembly Of God Church | NPROFIT | Yes | No | 2013 | 41690
SD Natural Gas Company | COM | No | Yes | 2013 | 60870
[NAME]'s | COM | No | Yes | 2013 | 34690
Window Pebble Apartments | GOV | No | Yes | 2013 | 51790
Press City PHS | GOV | No | No | 2013 | 3031700
Crown High School | GOV | No | No | 2013 | 990000
Watsons Hall | COM | No | Yes | 2013 | 82000
Agnew Avenue Church | NPROFIT | Yes | No | 2013 | 88840
Accent Landscaping | COM | No | Yes | 2013 | 319090
American Painting | COM | No | Yes | 2013 | 332000
Sandia Oil Company Inc. | COM | No | Yes | 2013 | 148590
NAPI Block Apartments | COM | No | Yes | 2013 | 442400
WRABC | GOV | No | No | 2013 | 2020300
[NAME] | COM | No | Yes | 2013 | 76700
Pays [NAME] | COM | No | Yes | 2013 | 178300
Wellness Center Inc | COM | No | Yes | 2013 | 217700
Van's Trading Laundromat | COM | No | Yes | 2013 | 964500
Huge Industries | COM | No | Yes | 2013 | 28877
Huge Global Industries | COM | No | Yes | 2013 | 598600
[NAME] | COM | No | Yes | 2013 | 56900
Blanding Stake | NPROFIT | Yes | No | 2013 | 238200
Elmor construction | COM | No | Yes | 2013 | 80530
DNA Office Complex | NPROFIT | Yes | Yes | 2013 | 38040
Energy Resources Board | GOV | No | No | 2013 | 26250
1st Baptist Church | NPROFIT | Yes | No | 2013 | 75490
Eastmoon Petroleum | COM | No | Yes | 2013 | 27800
9-12 Laundromat | COM | No | Yes | 2013 | 1863100
Ed's Trading Post | COM | No | Yes | 2013 | 49000
Red Mesa Diner | GOV | No | Yes | 2013 | 40530
JWJ Mobile Home Park | COM | No | Yes | 2013 | 524900
Amarillo Trailer Park | COM | No | Yes | 2013 | 25200
CFK | COM | No | Yes | 2013 | 380460
[NAME] Center Inc | COM | No | Yes | 2013 | 148174
Commision of Children and Youth | GOV | No | Yes | 2013 | 737000
Veterans Center | COM | No | Yes | 2013 | 41920
Business Affairs | GOV | No | No | 2013 | 3978000
Magore High School | GOV | No | No | 2013 | 1207700
Tema Health Clinic | GOV | No | No | 2013 | 415000
Cedar School | GOV | No | No | 2013 | 479400
Chaleta Apartments | GOV | No | Yes | 2013 | 73050
Environmental Quality | GOV | No | No | 2013 | 713400
Eagle Rock Professional Building | COM | No | Yes | 2013 | 41830
Van's Trailer Court | COM | No | Yes | 2013 | 165900
Pinon Clinic X-ray | GOV | No | No | 2013 | 63200
Bulger Irrigation department | GOV | No | No | 2013 | 625200
Pic and Gun | COM | No | Yes | 2013 | 67270
Snowy PM Group | NPROFIT | Yes | No | 2013 | 83270
Pinon Housing | GOV | No | Yes | 2013 | 55000
Sunnyday Day Care | GOV | No | Yes | 2013 | 56495
PHS Irrigation | GOV | No | No | 2013 | 70600
The Nazarene Church | NPROFIT | Yes | No | 2013 | 84050
Balboo Mission | NPROFIT | Yes | No | 2013 | 118800
6-12 Trailer Court | COM | No | Yes | 2013 | 88600
[NAME] | COM | No | Yes | 2013 | 204380
[NAME] | GOV | No | No | 2013 | 122800
Springs Trading Post | COM | No | Yes | 2013 | 44320
FDIHS | GOV | No | No | 2013 | 34100
Old Peabody TC | COM | No | Yes | 2013 | 2072000
Totals