Spreadsheet: 194661d1353286244-dependent-dropboxes-which-can-select-multiple-entries-book1eg-1-
Sheet: Sheet1

[NAME] | PERMIT NO | IMPORTER | EXPORTER | COUNTRY | COMMODITY | BREED | TOTAL # DOSES | #  DOSES/ BREED | ARRIVAL DATE | Overall Compliance (1=NOT COMPLIANT) | Compliant in all aspects (port opinion) | Consignment correctly addressed | bond store to AQIS office | Delivery (1=noncompliant) | Failure of 72 hr fresh/chilled notification - fresh semen | Incorrect or invalid permit no. | Health Cert not signed & stamped as required | Health Cert inconsistent with IP or consignment | DOCUMENTATION (non compliance = 1) | Full ID not stated - eg breed, herd/studbook no, ear tag, brand or microchip | Date/s of semen collection/s not stated | Straw Identification on docs inadequate | Date of entry into pre-entry isolation not stated | Date of entry to collection centre not stated | Testing - incorrect dates | Testing - incorrect test | Comments on testing (eg which disease) | Shipping container not sterilized as per IP | Laboratory reports not submitted (where required) | VET CERT | Tamper seals not present or damaged or inconsistent with docs | Presence of non-certified material in container e.g. semen extender | Uncertified, unlabelled or mislabelled straws present in consignment | INSPECTION | Other | OTHER2 | regions | Type of NC | EUROPEAN REGIONSregion | WORLD REGIONS (EUROPE GEN)
 |  |  |  | Canada | bovine semen |  | 21809 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | USA | equine semen |  | 2635 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | USA | canine semen |  | 18994 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | USA | bovine semen |  | 12484 |  |  |  | YES AFTER FOLLOW UP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Lab reports submitted |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | CANADA | bovine semen |  | 9600 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | Canada | Canada
 |  |  |  | Canada | bovine embryo |  | 9600 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | Canada | Canada
 |  |  |  | USA | equine semen |  | 20945 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | USA | canine semen |  | 13380 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | Canada | canine semen |  | 9550 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | Canada | Canada
 |  |  |  | USA | bovine semen |  | 4500 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | USA | bovine semen |  | 9275 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | USA | bovine embryo |  | 9600 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | USA | USA
 |  |  |  | CANADA | bovine semen |  | 4400 |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SE |  | Canada | Canada