Alan, re the chart. I'd say the spreadsheet had some lingering background formulas that the data entry person wasn't aware of. I had several flower pot dishes outside that had at least an inch water each. Not accurate for sure but an indicator. I think it rained for 2 hrs at 85023.
You use Wunderground.com, right? Do you use a weather station near you?