ericoc/utilities

AI Summary: The task is to determine how to handle 'Invalid Reading' entries from the Philadelphia Water Department's water usage data. The current system stores these as 0 gallons, but the issue is that there's no way to programmatically distinguish between a true 0 gallon reading and an 'Invalid Reading' from the source data. A solution needs to be found to either detect 'Invalid Readings' reliably within the PWD system or to improve the display of the data to clearly differentiate between 0 gallon days and invalid readings.