The work I've been doing for the last week, trying to massage somebody else's data to make a square peg fit into a round hole, turned out to be a complete and utter waste of time. The data is shit, corrupted and inconsistent and I have just informed the person who gave it to me that it is so. I could say that I hope he doesn't hate me for it, but honestly, that would be a lie.