Data checking macro

Colleagues, I suspect I'm not the only one who has, over the years had the experience of spending a week (or more) on an analysis only to find important errors in the data set. I'm hoping for some feedback on what people do to try to find these errors (short of spending a week on an incorrect data set). To start the discussion, I've put on the Next Level web site (www.NextLevelSolns.com/downloads) an Excel macro that I've used, with some success to find errors. My experience is that most errors, at least those that are hard to find, are in the dosing specification. This macro makes histograms of: Each covariate DVs Dose Amts Dose Times (after expanding the ADDL doses) Interdose interval (after expanding the ADDL doses) - time from each to the previous Dose to DV time (after expanding the ADDL doses) - time from each observation to the previous dose Currently this macro is limited to 12 covariates, could be increased easily if there is interest. It also isn't CMT specific, that is all doses are just listed, without regard to CMT, same with DVs. I might fix this someday. As usual, this is an entirely in my own self-interest, looking for better ways to find problems in data sets, so please give feedback or ideas. Mark