Maghammer: My Personal Data Warehouse (osmarks.net)

I was assigned years and years ago to build a mathematical model of building energy use as a function of environmental parameters and part of that involved averaging temperatures at a weather station where it turned out a very negative number was used for “no reading” and if you tried averaging without knowing this you’d get some pretty crazy results.