WELCOME TO THE NSIP DATA ENTRY FORMS Version 3.1, May 2003 Welcome! Welcome to the newest version of the NSIP Data Entry Spreadsheet! Version 3.1 contains a few additions and changes from Version 3.0. However these changes are relatively minor, and the look and feel is very similar to Version 3.0. Version 3.0 is a major revision from version 2.0. It has dozens of new features that will make it easier and faster for you to enter data. The file is also smaller, so it will transmit faster across the Internet and will fit easily onto a floppy disk. This version gives you many more rows to add your data (700 rows in each form). It uses bright colors to identify cells with many types of errors, missing data, and typos --questionable cells will turn red or lavendar as soon as you enter the data. The macros work faster, and we've also added a few reference columns for lamb weights that give you information about lamb ages and average daily gains as you enter the weights. As always, we at NSIP strive to make it easy and efficient for you to enter your data, so you can receive your EPDs and use them for your genetic selections and marketing. Changes in Version 3.1 from Version 3.0 Added column in M-L-F Form for recording Codon 171 results for the genetic susceptibility to Scrapie. Added a fifth LIV code (LIVABILITY code) to record lamb deaths from two weeks of age until weaning. After weaning, any lambs that leave the flock can be identified by the DIS code (DISPOSITION code). Added column in M-L-F Form for recording "Ram Out" dates -- particularly useful for flocks that follow an accelerated lambing program. For Katahdin and Dorper breeds, added a column to record the Purebred % of their breeding animals for their "Breeding-Up" programs. Added a field to record "breed" at the top of the M-L-W Form. The reference lists of Code Value have been updated. The entire reference list of Code Values now prints on two pages. Help Help for these NSIP Data Entry Forms comes in four flavors: (1) Cell Comments Some cells -- especially column headings and top data entry cells -- contain little red triangles in their upper right-hand corners. When you pass your cursor over these cells, you'll see a pop-up comment. Try This (2) Help Buttons Useful Utility Macros At the top of the data entry screens, you'll see a couple of shaded cells with useful topics. Move your cursor over these cells (don't click), and you'll see helpful commentary about these topics. Like This: Data (Don't Click) Validation (3) Cell Validation Notes When you select some data entry cells, you will see useful information about the data that is necessary for that cell, or about why that cell turns red or lavendar. Data Like This: (Click Validation in Cell) Note Your can even "grab" the note with your cursor and move it around the screen. Try it! (4) Help Sheet The last worksheet in this file is a HELP sheet. Here you will find information on various useful topics, such as the "Paste Special" command, etc. You can go to it by clicking on the "Help" tab at the bottom of the screen or by clicking on a macro button, if available. Click on this button ===> to go to the Help Sheet Software Required This spreadsheet was designed in Excel 2000, as part of Microsoft Office 2000. It was designed and tested on a Windows machine running the Windows 98 Operating System. It has also been tested successfully with Excel 97. If you have any earlier versions of Excel for Windows, some of the features may not run properly. Macintosh users -- use the latest version of Microsoft Office for the Mac. If you other spreadsheets, like QuattroPro or Microsoft Works, please check with your NSIP Data Coordinator for assistance. These other software packages will allow data entry, but some Excel features do not translatewell to these other spreadsheets. Macros Macros are automated procedures that can help you do repetitive tasks. You can use them by clicking on any of the buttons on the various worksheets. The different worksheets have different macros that you can use. A few general utility macros are listed on this Instructions worksheet. An alternative method of running these macros is to go to the top pull-down menus, selecting "TOOLS / MACRO / MACROS", and choosing the macro that you want to use and then clicking on the "RUN" button. The following Macros have been created for this Workbook: General Utility Macros Buttons on this Instructions Worksheet Enter Key = Right Changes "Enter" key to move cursor to the right. Enter Key = Down Changes "Enter" key to move cursor downwards. M-L-W Form Macros Macro Buttons on the Mating-Lambing-Weaning Form Add Row for a Lamb Inserts a new row below current row for twins & triplet lambs. Also copies the ewe information from the original row to the new row. Copy Flock Info to PWW-Wool Form Copies Producer Name, etc from M-L-W form to the PWW-Wool form Copy NSIP Flock ID to Columns Copies NSIP Flock # (xx-xxx-xxx) into the last columns in both data entry forms Note: all the "Sort" macros will keep your data together (i.e. all the data in a row is moved as a single unit). Sort All Breeding Animals by Eartag Sorts all adult stock by Column A (eartag), lowest on top. Sort Ewes by Age (oldest on top) Sorts all adult stock by Columns D (sex) & then E (birth date), oldest on top. Sort Ewes by Age (youngest on top) Sorts all adult stock by Columns D (sex) & then E (birth date), youngest on top. Sort All Breeding Animals by DIS code Sorts all adult stock by Column F (DISposal Code), B-D-S. Ignores blank cells. Sort Lambs by Eartag Sorts all lambs by Column Q (lamb eartag), lowest on top. Sort Lamb by Age Sorts all lambs by Columns P (lambing date), oldest on top. PWW-Wool Form Macros Macro Buttons on the PostWeaning Weight & Wool Form Sort Animals by Eartag Sorts all animals by Column A (eartag), lowest on top. Sort Animals by DIS code Sorts all animals by Column E (DISposal Code), lowest on top. Copy Flock Info to PWW-Wool Form Copies Producer Name, etc from M-L-W form to the PWW-Wool form Copy NSIP Flock ID to Columns Copies NSIP Flock # (xx-xxx-xxx) to end columns in both data entry forms Screen Size Screen size and magnification depend on YOUR situation -- i.e. the size and resolution of your monitor, and your eyesight and working preferences, etc. These cannot be set up in advance or all computers and all people. Please feel free to change magnification as necessary to make data entry easy as possible. You may need to resize the window and choose a proper magnification. On my machine, I've used 75% magnification for data entry forms. On your machine, these settings may be different. Freeze Panes You'll notice that on the two data entry worksheets, the upper part of the screen and the two left-hand columns (Columns A & B) do not move when you scroll to the right or down. This is designed like this so that you can enter data and always know which animal that you are working on. Error Checking There are three types of error checking procedures in these data-entry worksheets: (1) Red or Lavendar Cells Some cells contain a simple error checking device: the cell turns red or lavendar if the data is incorrect, unusual, or missing. Other cells are red to remind you to enter data.. They will change color when you enter the data into them. Like This: or (2) Data Validation As You Enter Data Some cells have a validation data entry checker that prevents you from entering data incorrectly. This occurs in cells that require dates, certain code entries, and some other cells. Example: The following cell requires capital letter R or E. Enter any other number into this cell ===> (3) You There are a few major issues that you have to check carefully yourself -- these worksheets will not detect them. For example, incorrect eartags or registration numbers. Please examine your information carefully. One time-honored rule still applies: "Measure twice, cut once." NOTE: The built-in error checking procedures in these worksheets are NOT completely exhaustive error-checking routines, but they will catch some of the common typos and improper values. NSIP Codes For reference, all the standard NSIP codes (DIS, MGT, LIV, REAR, SEX, FACE, and FOLD) are listed in the worksheet called "Code Values". You can print this worksheet on your own printer for a convenient reference. In many cells, the relevant NSIP codes are conveniently listed in the Validation Notes that pop up when you click on the cell. Protected Cells & Adding Animals Some areas in each worksheet are "protected" -- which means that you cannot input data into those cells or change them in any way. The data cells, however, are not protected. You can use the Tab key to move through the data entry cells, and even to go from the end of one row to the beginning of the next row. Both the Mating-Lambing-Inventory Form and the PostWeaning Weight & Wool Form are formatted for 700 animals. If you need to add more animals to any of these forms, you will have to insert rows in the middle of the data area. Mating-Lambing-Weaning Form Add Row for a Lamb Inserts a new row below current row for twins & triplet lambs. Also copies the ewe information from the original row to the new row.