test it by feeding in wrong data, wrong format, negative, extra blanks, capitals, full stops, 6 decimal places, fractions, bad links, circular reference. Everything that the normal user will do at some point. When you have demonstrated your system can cope with the above; then pull the plug and see how long it takes to recover.