Msu Application Form - Download as Excel by fex67687

VIEWS: 19 PAGES: 20

More Info
									                                              How To Use This Form
        Step One:       Fill Out the following Company and Contact Information forms.
                        The information entered here will be copied to subsequent froms.

                                          COMPANY INFORMATION

 COMPANY NAME:
         ADDRESS:
               CITY:                                             STATE:                ZIP:
      TELEPHONE:                                                  FAX:
          WEBSITE:


                                           CONTACT INFORMATION

              NAME:
         ADDRESS:
               CITY:                                             STATE:                ZIP:
      TELEPHONE:                                                  FAX:
              E-mail:                                                          Date:

Would you like a paper copy of the results, in addition to the Excel file that is sent via email?     yes        no


        Step Two:       Enter varieties and appropriate information on the Alfalfa worksheet. Place a 1 in
                        the column for each location the variety will be tested in.
      Step Three:       Go to Seed List and click in cell A2. Now go to DATA click on CONSOLIDATE then
                        click on OK. Seed list will update with appropriate shipping totals.

        Step Four:      Use the (save as) comand (under file) to save the file. Insert your brand name
                        ("Comapny name" entry form.xls) in the file name.
        Step Five:      Print a copy of all worksheets for your files - Submit a copy of the Invoice to your
                        accounts payable department for payment.
          Step Six:     E-mail a copy of the new file to Tim Dietz at the following e-mail address:
                        dietzt@msu.edu
Note: To paste cultivar information from worksheet to worksheet use EDIT (copy) then EDIT (paste special (values)). This
will prevent the changing of any formatting.
COMPANY NAME:
ADDRESS:                                                                                                               2011 Michigan State Univers
CITY:   STATE:    ZIP:                                                                                                   Alfalfa Perfromance Trials
TELEPHONE:     FAX:                                                                                                       Entry Application Form
E-mail:
                                                       Fall dormancy and resistance ratings                                  Enter a one for each entry
 Office     BRAND NAME:                                                                                               East          East
Use Only                                                                                                  East     Lansing        Lansing
 Code                              Released                                                             Lansing      PLHR          PLHR
Number List variety names below:   Variety? FD WH BW Phyt. Anthr. Vert. Fusar. Aphano.        S/B Nem   Standard no insecticide insecticide
         ex): Vernal                 yes    2      1                        MR                             1




                                                                                  TOTAL ENTRIES            0            0             0




                                                                                                                   $        -
                                     1/0/00
Signature                          Date
 State University
omance Trials
ication Form

for each entry

       Lake    Thumb
       City            Chatham
     Standard Standard Standard
         1




         0       0        0




                      TOTAL FEES
2011 Invoice
                                                                       Department of Crop & Soil Sciences
          INVOICE:   Dietz                                             286 Plant & Soil Sciences
             DATE:   1/0/00                                            East Lansing, MI 48824-1325



                                                   Please make check payable to MICHIGAN STATE
BILL TO:                                           UNIVERSITY/Alfalfa Testing and mail to:

                                                        Tim Dietz
 ,                                                      286 Plant and Soil Sciences Building
                                                        Michigan State University
ATTN:                                                   East Lansing, MI 48824-1325


                      ORDER NO.     DATE SHIPPED       SHIPPED VIA           F.O.B.              TERMS
                                                                                           Submit payment
                                                                                          with entry forms by
                                                                                           March 15, 2011


     No. Entries.                    DESCRIPTION                          UNIT PRICE             TOTAL
                                2010 Performance Trials
          0          Entries for East Lansing                               $550.00              $0.00
          0          Entries for East Lansing PLHR no insecticide           $550.00              $0.00
          0          Entries for East Lansing PLHR insecticide              $550.00              $0.00
          0          Entries for Lake City                                  $550.00              $0.00
          0          Entries for Thumb                                      $550.00              $0.00
          0          Entries for Chatham                                    $350.00              $0.00


                                                                              TOTAL DUE          $0.00
          Company:
Variety              Scarified   Purity   quick   hard   germ              grams seed (if germ
                                          germ    germ   total # locations     tot.>75%)
                                                            0       0               0
                                                            0       0               0
                                                            0       0               0
                                                            0       0               0
                                                            0       0               0
                                                            0       0               0
                                                            0       0               0
                                                            0       0               0
                                                            0       0               0
                                                            0       0               0
,




    Ship To:

    Tim Dietz
    Crop Science Field Lab
    4450 Beaumont Road
    Michigan State University
    East Lansing, MI 48824
This Worksheet is for internal calculations
               Do not Print
H




H
H
Hybrid            RM      Tans    x




         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
Hybrid            RM     Tans     x
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
Hybrid            RM     Tans     x
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
Hybrid            RM     Tans     x
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
         #REF!   #REF!    #REF!   ##
Seed Treatment           #Zone     lbs. Seed
                 #REF!     #REF!     #REF! grain 1
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
Seed Treatment           #Zone     lbs. Seed
                 #REF!     #REF!     #REF! Grain 2
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
Seed Treatment           #Zone     lbs. Seed
                 #REF!    #REF!      #REF!     GR
                 #REF!    #REF!      #REF!
                 #REF!    #REF!      #REF!
                 #REF!    #REF!      #REF!
                 #REF!    #REF!      #REF!
                 #REF!    #REF!      #REF!
                 #REF!    #REF!      #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
Seed Treatment           #Zone     lbs. Seed
                 #REF!     #REF!     #REF! silage
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!
                 #REF!     #REF!     #REF!

								
To top