Yep. At least it was a realistic experience :)

The hardest part when working with data is often not manipulating data per se, but spending time on crap like this.