Yep. That's exactly the kind of diasterous shadow system I'm talking about and a good example of how the issue is cultural as much as technical. It'd be tremendously difficult to keep all those spreadsheets telling the truth all the time. You're almost lucky nobody reads them because who knows what kind of poor decisions would get made from such a mess.
