Re: Bad Data Input/High System Utilisation.
@SD3
Some organisations use XML for data transfers internally or with suppliers and customers. The XML must be declared valid against a pubished schema, and that can be written into a contract. It should cope with the kind of input errors that you describe.
No, people don't write XML, software does. Excel can be provided with a template, designed by an XML guru, so you type in to a sensible form that will bellyache if you get it wrong, and then export the rigorous data.
Or so I understand. I have experimented with XML but not used it for real.