Document
HPAI Livestock Non-NAHLN Lab Reporting Results Template
ICR 202406-0579-002 · OMB 0579-0494 · Object 143830901.
This document may belong to an older filing. More recent activity for OMB 0579-0494:
Document Viewer [xlsx]
Document Metadata
| File Type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
|---|---|
| File Title | HPAI Livestock Non-NAHLN Lab Reporting Results Template |
| Author | Moxey, Joseph - MRP-APHIS |
| Last Modified By | Calc |
| File Modified | 2024-06-21 |
| File Created | 2026-07-14 |
| Conversion State | complete |
Extracted Text
Paperwork Reduction Act OMB Approved 0579-XXXX, expires XX/XXXX According to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a valid OMB control numb information collection is 0579-XXXX. The time required to complete this information collection is estimated to average 2 hours per response, including the time for reviewing instructions, searching existing d needed, and completing and reviewing the collection of information. LabName LabPhoneNumber nformation unless it displays a valid OMB control number. The valid OMB control number for this the time for reviewing instructions, searching existing data sources, gathering and maintaining the data LabAccessionNr FADReferralNr ProgramOid AnimalorHerdID Species OtherSpeciesName FieldSpecimenID SpecimenType OtherSpecimenType DateCollected DateSpcmnRcvd DateTested TestType TestResult TestInterp PremID PremAddr PremCity PremState OwnerName SubFirstName SubLastName SubPhone Comments Instructions What to report: When to report: Where to report: How to report: Note: If there is a validation issue with the data submitted (e.g. more than one attachment, wrong form, or data Please make the changes and resubmit the spreadsheet as soon as possible by replying to that email, or send ag Enable Editing Enable Content Navigate to the "Data" tab and input information into the required fields, which are marked with double u For the following fields, please select from the provided dropdown options (dropdown arrow located to rig Notes & Tips Each column name is accompanied by a note, symbolized by a red triangle in the top right corner. Hovering over the column name will reveal a definition for that particular column. Cells initially appear in a light gray color. As you begin to input data into a row, the row’s color will change This color will persist until all necessary fields are completed. These required fields are indicated by double underlines beneath their column names. Methods for Copying same values down columns (for example, with dropdowns) 1. Drag Fill Handle 2. Double Click Fill Handle 3. Copy and Paste 4. Using the Fill Command Column Name Descriptions LabName LabPhoneNumber LabAccessionNr FADReferralNr ProgramOid AnimalorHerdID Species OtherSpeciesName FieldSpecimenID SpecimenType OtherSpecimenType DateCollected DateSpcmnRcvd DateTested TestType TestResult TestInterp PremID PremAddr PremCity PremState OwnerName SubFirstName SubLastName SubPhone Comments All positive influenza A test results with accompanying sample information collected Monday through Sun Report weekly - by 17:00 each Monday Send completed spreadsheet to [email protected] Use only this specified spreadsheet template. Submit only one spreadsheet per email; do not attach multip s a validation issue with the data submitted (e.g. more than one attachment, wrong form, or data validation issues) a retur he changes and resubmit the spreadsheet as soon as possible by replying to that email, or send again to HPAI.Results@usd If applicable, must click the "Enable Editing" button to enter new data on sheet. If applicable, must click the "Enable Content" button for data-checks to operate. Yellow strip at top. he "Data" tab and input information into the required fields, which are marked with double underlines. wing fields, please select from the provided dropdown options (dropdown arrow located to right of cell): Program OID Species (If ‘Other’ is selected, please input the species name in the subsequent column) Specimen Type (If ‘Other’ is selected, please input the specimen type in the subsequent column) Test Type TestInterp PremState name is accompanied by a note, symbolized by a red triangle in the top right corner. r the column name will reveal a definition for that particular column. appear in a light gray color. As you begin to input data into a row, the row’s color will change to white. l persist until all necessary fields are completed. ed fields are indicated by double underlines beneath their column names. Copying same values down columns (for example, with dropdowns) - Click on the cell that contains the value you want to copy. - Move your cursor to the bottom-right corner of the cell until it changes to a small black cross. - Click and drag the fill handle down the column to the desired end cell. ck Fill Handle - This method works if you have data in an adjacent column. - Click on the cell that contains the value you want to copy. - Move your cursor to the bottom-right corner of the cell until it changes to a small black cross. - Double-click the fill handle and Excel will automatically fill the value down to the last row of your adjace - Click on the cell that contains the value you want to copy. - Press `Ctrl+C` to copy the cell. - Select the range of cells in the column where you want to paste the value. - Press `Ctrl+V` to paste the value into the selected cells. Fill Command - Click on the cell that contains the value you want to copy. - Select the range of cells in the column where you want to paste the value. - Go to the `Home` tab, in the `Editing` group, click `Fill`, and then click `Down`. me Descriptions The official name of your laboratory. The contact phone number for your laboratory. Your laboratory's accession number for the case. A State or Federal case number that accompanied the submission. This is an identifier for the disease (AI), use the value in the dropdown. The unique identifier for the animal or herd being tested. The species of the animal being tested. Dropdown If "Other" was chosen for Species, please enter your species name here. A unique identifier, such as a barcode, applied to the specimen. The type of specimen collected for testing (e.g., blood, tissue). Dropdown If "Other" was chosen for SpecimenType, please enter your specimen type name here. The date the samples were collected, when available. The date when the specimen was received by your lab. The date when the testing was performed. The type of test performed on the specimen. Dropdown The result of the test The interpretation of the test result. Dropdown The national premises identifier for the location where the samples were collected. The address for the location where the samples were collected. The city of the location where the samples were collected. The state of the location where the samples were collected. Dropdown The name of the owner of the animal or herd. The first name of the submitter (person who submitted the specimen). The last name of the submitter. The phone number of the submitter. Any additional information or comments related to the test.