Re: How could this have been prevented/detected?
I use inspection reports, that basically look like a FAI but I add two columns. I put the low limit tolerance in column G and high tolerance limit in column H. The actual data (dimension) is checked to be between these two numbers. If the value is NOT between the two columns, the actual value cell turns red. This helps find typo's and transposed numbers.
This might help you as well as looking at numbers at high and low limits is different than looking at just a single value.
I use inspection reports, that basically look like a FAI but I add two columns. I put the low limit tolerance in column G and high tolerance limit in column H. The actual data (dimension) is checked to be between these two numbers. If the value is NOT between the two columns, the actual value cell turns red. This helps find typo's and transposed numbers.
This might help you as well as looking at numbers at high and low limits is different than looking at just a single value.
: