OK, Oogie, since things are still sticky on your end let’s let this ride for now. Thankfully you managed to get your records submitted to LambPlan in spite of all the headaches. I’ll send a PDF later today with screen shots of your data arranged in a format that you may want to consider using going forward. Not to imply that my way is the only way, but it’s working. As mentioned earlier, I’ve just submitted data for my 4th LambPlan evaluation and they haven’t booted me out of NSIP yet
A few suggestions that may be helpful for others also working on a Mac should they experience difficulties using the template from LambPlan:
- If the order in which columns appear on a self-generated Excel spreadsheet are arranged to match LambPlan’s template, it will save time for Stephen as he can then drop in all of your data at once rather than pasting each column separately. For this reason, I'd insert any columns you wish to include for additional traits (Lambing Ease, etc.) to the right of those in which you've entered other data.
- Use a separate tab/sheet in your spreadsheet file for each year, i.e. all animals born in the same year on a sheet titled “2011 Drop,” etc.
- Be sure to note the date weighed for each weight entered (those columns titled WDDYY, EPDDMM, etc.).
- Go ahead and enter all lambs born for previous years if you have the data (NSIP/LambPlan does not charge you for this). The more history you can provide the better as it helps in building pedigrees and will, over time, increase the accuracies of your EBVs/FBVs.