Presented at the Computers on the Farm Conference, January 6-7, 1999
Keeping Field Records Using a Spreadsheet
Keith and Jan Koenig



                      19__ FIELD RECORDS (FldRcrd)
    DATE/TIME
    FIELD #
    CROP                       YIELD
    
    CHEMICALS
    RATE
    
    COMMENTS
    
    WIND/TEMP

    DATE/TIME
    FIELD #
    CROP                       YIELD
    
    CHEMICALS
    RATE
    
    COMMENTS
    
    WIND/TEMP

    DATE/TIME
    FIELD #
    CROP                       YIELD
    
    CHEMICALS
    RATE
    
    COMMENTS
    
    WIND/TEMP

    DATE/TIME
    FIELD #
    CROP                       YIELD
    
    CHEMICALS
    RATE
    
    COMMENTS
    
    WIND/TEMP




    Field #                  1 ACRES
    Field Name
                 1996 CROP FIGURES          1997 CROP FIGURES
    
    COSTS
         SEED   $0.00 /BAG                 $0.00 /BAG
                    0 BAGS           $0        0 BAGS           $0
         FERT                        $0                         $0
         CHEM   $0.00 /ACRE                   ERR/ACRE
                    1 ACRES          $0        0 ACRES          $0
    INTRST       9.25 % AT 9 MOS            9.25 % AT 9 MOS
             (on seed, fert, ch      $0 (on seed, fert, ch      $0
    DRYING      $0.00 /ACRE                $0.00 /ACRE
    STORAGE         0 ACRES          $0        0 ACRES          $0
    FUEL            0 GAL/ACRE                 1 GAL/ACRE
                      /GAL           $0    $1.00 /GAL           $0
        LABOR   $0.00 /ACRE                $0.00 /ACRE
    MACH                             $0                         $0
    
    
    TOTAL COSTS                      $0                         $0
    
    INCOME
    EST $       $0.00   /BUSHEL            $0.00   /BUSHEL
    
    BUSHELS         0 BU/ACRE              $0.00 BU/ACRE
    PER ACRE
    TOTAL           0 BUSHELS                  0 BUSHELS
    BUSHELS
    TOTAL/EST INCOME                 $0                         $0
    
    
    
    MARGIN APPLIED TO RENT           $0                         $0
    
    MARGIN PER ACRE                  $0                         $0
    
    RENT                             $0                         $0
    
    BREAKEVEN PRICE ($/BU)           ERR                        ERR
    
    PROFIT                           $0                         $0
         w/out LABOR&RENT
    BREAKEVEN PRICE                  ERR                        ERR
         w/out LABOR&RENT
    

    
    Field #         0        0 ACRES
    Field Nam       0
                 1996 CROP FIGURES          1997 CROP FIGURES
                             0                          0
    FERTILIZER                                   BUGGY          $0
    34-0-0          0 #s/Ac                    0 #s/Ac
                 $204 /TON           $0    $0.10 /LBS           $0
    46-0-0          0 #s/Ac                    0 #s/Ac
                 $276 /TON           $0    $0.12 /LBS           $0
    Lime            0 #s/Ac                    0 #s/Ac
                   $0 /LBS           $0    $0.00 /LBS           $0
    Total                            $0                         $0
    
    Zinc
    
    Copper
    
    Total
    




    
    Field #         0        0 ACRES
    Field Nam       0
                 1996 CROP FIGURES          1997 CROP FIGURES
                             0                          0
    CHEMICALS
    Sutan           0 PTs/Ac                   0 PTs/Ac
                  $16 /GAL           $0      $16 /GAL           $0
    Atrazine     0.00 QTs/Ac                0.00 QTs/Ac
                  $12 /GAL           $0      $12 /GAL           $0
    ACT             0 OZs/Ac                   0 OZs/Ac
                  $90 /GAL           $0      $90 /GAL           $0
    Squadron        0 PTs/Ac                   0 PTs/Ac
                  $65 /GAL           $0      $65 /GAL           $0
    Lasso           0 QTs/Ac                   0 QTs/Ac
                  $23 /GAL           $0      $23 /GAL           $0
    RoundUp         0 QTs/Ac                   0 QTs/Ac
    Ultra         $51 /GAL           $0      $51 /GAL           $0
    2-4-D           0 PTs/Ac                   0 PTs/Ac
    Ester         $15 /GAL           $0      $15 /GAL           $0
    Beacon          0 PKTs/Ac                  0 PKTs/Ac
                  $26 /OZ            $0      $26 /OZ            $0
    Crop            0 QTs/Ac                   0 QTs/Ac
    Oil            $4 /GAL           $0       $4 /GAL           $0
    
    TOTAL                             0                          0