To learn the ways your bill of materials could get rejected, check out this document written by Silicon Expert "Common Sources of BOM Rejection". They articulate the philosophy I could not put words to when using spreadsheets instead of intelligen...
Available on Siliconexpert
External purchase
Recommended by
TechEdKirsch