ࡱ>  g2ɀ\pSheynerman, Paula D. Ba= ThisWorkbook=L,!8X@"1Arial1Arial1Arial1Arial1Courier1Arial1Arial1Arial1QTahoma1QTahoma1Arial1Arial1Arial1Arial1@Arial1Arial1Arial1Courier1h8Cambria1,8Calibri18Calibri18Calibri1Calibri1Calibri1<Calibri1>Calibri1?Calibri14Calibri14Calibri1 Calibri1 Calibri1Calibri1Calibri1 Calibri1Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0_) "$"#,##0.00 0.0000.0 "$"#,##0 0.00000$[$-409]dddd\,\ mmmm\ dd\,\ yyyy[$-409]h:mm:ss\ AM/PM                #  #  #  #  #  #  #  #  #  #  #  #  "  "  "  "  "  "  "  "  "  "  "  "        ff + ) , *     P  P        `            ! a>  !    d   @  D  l   `@   `   h   d   d  d     `@ @*  `@ *  @ *  @ *  `@ * "x @ *  `@ @ *  @ @* x@*  ` *  x@ *  h@ *  @*  ` *  `@*  h@*  `@ *   H      X #@2 #2  2  @ @2  @2  2  @ 2  @2  2  @ 2  @ 2   2   2   2  #X*  #x@*  #x@ *   h @ * !x@ @ *   h@@*   h@*   H*   h@ * #x @ *   h@@ * "x@ *  x@@ * "x@@ *   x @ *  "x @ *  "x@ *  P/ "x@ @ /   x@/   X/   x@/   x@@/   x/  h@@ *   h@ *  `@ @)  `@ )  `@ )  "|@ @ 2  "| @ 2  #|@ 2  #|@ 2   H2   l@2   l@ @2   l@ 2   l@ 2   h 2   L2   l@2   h@2   @2  (x 2   h 2   h 2  "|@ @2  "|@ 2  "|@ 2   l 2   h@ *   x * !x@@ *   l@@2   l@2   l@ 2   l 2  "|@ @2  "|@ 2  "|@ 2  @/ (P/  \/  H/  p@/      ( ! 8     #   (8 !  " #    # #  (    @*   H/  p/  `/ "/  @/  P/ (T/ (P/  X/  X/ ( (X/  x@@ *  p @ *  x/  p/  p@ /  x@@ )  p @ )  x@/  p@/  p / x@ @* p@ * p@ * x@@* p@* p@ * x@ @* p@ * p@ * "x@ / "x @ / x@ @* x@ * x@ * X/ x@ *  "@ * "0@ "0 @   X/     x@/ "x@ * x /  0 "x@@ *  0@  0 @ 8 8 ||T8}-}< yyyy;_(*}A}1 yyyy;_(*;_(@_) }A}2 yyyy;_(*?;_(@_) }A}3 yyyy;_(*23;_(@_) }-}4 yyyy;_(*}A}0 ayyyy;_(*;_(@_) }A}( yyyy;_(*;_(@_) }A}7 eyyyy;_(*;_(@_) }}5 ??vyyyy;_(*̙;_(@_)    }}: ???yyyy;_(*;_(@_) ??? ??? ??? ???}}) }yyyy;_(*;_(@_)    }A}6 }yyyy;_(*;_(@_) }}* yyyy;_(*;_(@_) ??? ??? ??? ???}-}> yyyy;_(*}x}9yyyy;_(*;_(??? ??? ???}-}/ yyyy;_(*}U}= yyyy;_(*;_( }A}" yyyy;_(*;_(}A} yyyy;_(*ef;_(}A} yyyy;_(*L;_(}A} yyyy;_(*23;_(}A}# yyyy;_(*;_(}A} yyyy;_(*ef;_(}A} yyyy;_(*L;_(}A} yyyy;_(*23;_(}A}$ yyyy;_(*;_(}A} yyyy;_(*ef;_(}A} yyyy;_(*L;_(}A} yyyy;_(*23;_(}A}% yyyy;_(*;_(}A} yyyy;_(*ef;_(}A} yyyy;_(*L;_(}A} yyyy;_(*23;_(}A}& yyyy;_(*;_(}A} yyyy;_(*ef;_(}A} yyyy;_(*L;_(}A}  yyyy;_(*23;_(}A}' yyyy;_(* ;_(}A} yyyy;_(*ef ;_(}A} yyyy;_(*L ;_(}A}! yyyy;_(*23 ;_( 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text % 0Good;Good  a%1 Heading 1G Heading 1 I}%O2 Heading 2G Heading 2 I}%?3 Heading 3G Heading 3 I}%234 Heading 49 Heading 4 I}% 5InputuInput ̙ ??v% 6 Linked CellK Linked Cell }% 7NeutralANeutral  e%"Normal8Normal_LEVELVUE 9Noteb Note   :OutputwOutput  ???%????????? ???;$Percent <Title1Title I}% =TotalMTotal %OO> Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`)^ Introductiono Instructions_{ Haul Input( Haul OutputANIMAL:CEC:! Credits;kv CROPGROWN:" CROPNAME;nyKST: $ MANURETYPE;lm! ncredit;%/ NCROP:RECNIT:! SPECIES;_jSTL: YIELDGOAL:8ZRx3 A@@  fManure produced each year NitrogenNutrient Requirements)Distance, Equipment and Labor InformationExtra distance to haulORLoads per AcreAcres per Load Lbs. NitrogenMilesnutrient providedn p kn rate>>shortageNAp removal rate>>p 2 yr removal rate>>p 4 yr removal rate>>p 3 yr removal ratep 3 yr removal rate>>CROP YIELDNAMECorn for grainCorn for silageSoybeansWheatOats Orchardgrass Bromegrass Clover-grassSorghum SudangrassNutrient Purchase Price Crop to be grownRecommended nitrogenSpeed of travel on roadPer hour labor cost Hours equipment operated per day Daily chargesMileage charge Fuel pricePer mile fuel consumptionPer hour fuel consumptionEquipment idle timeTractor per loadLoading time per loadLoading equipment hourly costSheepTurkeyHorseManure Haul Input Calculate number of animal units Animal TypeManure ProductionPercent SolidsNutrient ContentTons/yrGal/yrNlb/ton lb/1,000 galDairyBeefVeal Growing pig Mature hog Sow & litterGoatLayersBroilersManure Information Manure Analysis with lab results#Manure Analysis with no lab results Specie typeNumber of animal unitsTotal nitrogenAmmonical nitrogenAvailable nitrogenNutrient value of manureManure needed to supply:Transport cost per:Additional timeAdditional non-labor cost per:Comparative analysisNo manure applicationManure for nitrogen@One way total miles break even compared to commercial fertilizerAcres needed 1 yearTo meet nitrogen requirementthousand gallonston size of tanksize of spreader tanker leasespreader leasetanker per loadspreader per loadper thousand gallonsper tonsavings per thousand gallonssavings per tongallonslbs. per thousand gallons lbs. per tonthousand gallons per acre tons per acrebushels per acredollars per pounddollars per acre miles one waymiles per hourdollars per hourhours dollars per daydollars per miledollars per gallonmiles per gallongallons per mileper dayhours per loadminutes per loadper loadfor farmloadhourmile whole farmManure Haul Results lbs. per acretotal cost per acresavings per acresavings per loadsavings per hoursavings whole farmNH4-Nlb/Ton lb/1,000gal Min> Fac. Available NManure HistoryManure applied here 1 year ago? Manure applied here 2 years ago? Manure applied here 3 years ago? Animal UnitsP2O5K2O P2O5 RemovalRecommended P2O5 Recommended K2O mininutes per loadhoursLiquidSolid Sugar BeetsPotatoes Dry BeansN CreditNitrogen from previous cropCalculate N Credit Previous Crop% Stand Alfalfa, establishedAlfalfa, seedingClover, establishedClover, seedingTrefoil, established Grass HayBarley + Legume Oats + LegumeWheat + LegumeNo. of 1st group animals No. of 2nd group animals No. of 3rd group animals Ave. weight 1st groupAve. weight 2nd groupAve. weight 3rd groupYield potential Intended Crop Fertilizer Spreading Cost Soil CECpot'lP CLAlfalfaPBUPMPDDPCRPPLPDLRecommended P2O5 Calculate Recommended P2O5  Calculate Recommended K2O Soil test level (ppm) No N CreditCropsP MAXK CLKCRKPLKDLKBUKMKDDK MAX P2O5 removal  P2O5 2-year removal  P2O5 3-year removal  P205 4-year removal  Lbs. P2O5 Lbs. K2O Manure for P2O5 Removal  Manure for P2O5 2 Year Removal  Manure for P2O5 3 Year Removal  Manure for P2O5 4 Year Removal   Manure Type 3Bob Battel, MSU Extension Educator, Farm ManagementAcknowledgements:3Manure Haul - How far can I afford to haul manure? January, 2006P2O5K20Manure Information:Complete the "Calculate Animal Units" set of cells to the right, entering the numbers and average weights of various animal groups on your farm. The spreadsheet will calculate the number of animal units. It is OK to leave areas blank if you have fewer than three animal groups. uIf manure has been spread on this field in any if the past three years, enter the amount of manure spread that year. $Go to the cells to the right. If a crop that would generate a nitrogen credit was grown in this field last year, enter that crop, using the Drop Down Menu. Also, for crops other than soybeans, dry beans and grass hay, enter the percent stand. The spreadsheet will calculate a nitrogen credit.Nutrient Requirements:Nutrient Purchase Price:OEnter any per acre spreading costs if commercial fertilizers were to be spread. N Credit:Manure History:IManure Analysis with lab results and Manure Analysis with no lab results:*Distance, Equipment and Labor Information:gClick on the "Haul Output" tab for break even distances for hauling manure and a comparative analysis. VExtra Distance to Haul: Enter the distance above what you would normally haul manure. AChoose from the Drop Down Menu the livestock specie on your farm.5Using the Drop Down Menu, enter the crop to be grown.Enter the Yield Potential.Go to the cells to the right. Enter the soil test results (in ppm) for phosphorus. If soil test results are in pounds per acre, divide the results by 2 to convert to ppm.Enter the soil test results (in ppm) for potassium. If soil test results are in pounds per acre, divide the results by 2 to convert to ppm..Enter your per pound cost for N, P2O5 and K2O."#$%+,The "Haul Input" sheet is where your farm's data should be entered. Enter values in the dark green colored cells. The yellow colored cells are calculated values based on your input. Hourly ChargeEquipment chargesIChoose either "per mile" fuel consumption or "per hour" fuel consumption.CChoose either "Hourly Charge" or "Daily Charge" for tractor/tanker.This spreadsheet is based on earlier spreadsheets by Roger Betz, MSU Extension Educator, Farm Management, South West Michigan; Dr. Howard Person, MSU Extension Specialist Agricultural Engineering (retired); and Dr. Maurice Vitosh, MSU Extension Specialist, Crop and Soil Sciences (retired). The fertilizer recommendations are in Build Up/Maintenance/Draw Down format. That part of the spreadsheet is based on a spreadsheet developed by Mike Staton, MSU Extension Educator, Field Crops, Van Buren County. %Enter the CEC from soil test results.;The spreadsheet will calculate a fertilizer recommendation.GChoose from the Drop Down Menu using either "Liquid" or "Solid" manure.You can either enter your farm's manure analysis, or use default values. If you have laboratory result for manure analysis, enter them in the "Manure Analysis with lab results" cells. If you leave these cells blank, the spreadsheet will generate default values.P@ AcAAGBBC[5DDXDE^eF!.GGaHHQI I [J 8K KR 6L L {M7 Mk ^NNfOP:T!VYccjB g2ɀ "dmQn  dMbP?_*+%&?'?(?)?MCanon i70 (Copy 2)߁ odLetterBJDM,jjVT$m,`Oj,`OjVT$m,`Oj,`OjXX"DRAFTSample 1dVT$mVT$m@  VT$mCanon i70 (Copy 2)߁ odLetter:,"d??&cU"      ( ( (* ( (**** * * * * ******************D|l:::.::......................... !* *!.>@  "   7b(b(///gg g2ɀ $GpWyz  dMbP?_*+%&?'?(?)?"??&cU$     ; $&& $ $ $ $& $ $ &  $  $  $  $& $ $ $ $ $ $ $ $ $ $ $ $ $ $ $&Dl6**6666*66*6666*666666666666666 !"#& &!&"&# <***>@" 7b(b(///gg g2ɀ S+ub~  dMbP?_*+%&?'?(?)?MCanon i70 (Copy 2)߁ odLetterBJDM,jjVT$m,`Oj,`OjVT$m,`Oj,`OjXX"DRAFTSample 1dVT$mVT$m@  VT$mCanon i70 (Copy 2)߁ odLetter:,"d??&cU} } } m} } m} $} IS  h        ; ;     ; ;        ; ; ;  ; ,@    5BB I L `LBB  ML a@MBB  MMCi@D  M 6BB  PAd`Tq@ DLiquid .C):_:jBfDGDSolid *C):_:jBfD"BhOdRDLiquid  :[3DSolid  :\:["Bthousand gallons L~ mt@BB J LN~ bK@hNRDLiquid  :h3DSolid  :i:["Blbs. per thousand gallons M~ m@BB  MO~ b@hNRDLiquid  :h3DSolid  :i:["Blbs. per thousand gallons M~ mi@BB  MP~ b;@hNRDLiquid  :h3DSolid  :i:["Blbs. per thousand gallons M~ m @BB  M~ bO@hN RDLiquid  :h3DSolid  :i:["Blbs. per thousand gallons M~ ma@BB  P~ bA@h O RDLiquid  :h3DSolid  :i:["Blbs. per thousand gallons  M~ mf@ BB   W> Di@(DDDDDD  BB K LN C DLiquid AD %C):_:j Bf "^DSolid AD %C):_:j Bf ""Bh L RDLiquid  :h3DSolid  :i:["Blbs. per thousand gallons BB  MO C DLiquid AD %C):_:j" Bf "^DSolid AD %C):_:j" Bf ""Bh M RDLiquid  :h3DSolid  :i:["Blbs. per thousand gallons BB  MP C DLiquid AD %C):_:j&Bf "^DSolid AD %C):_:j&Bf ""Bh MRDLiquid  :h3DSolid  :i:["Blbs. per thousand gallons BB  MC DLiquid AD %C):_:j  Bf "^DSolid AD %C):_:j Bf ""BhM RDLiquid  :h3DSolid  :i:["Blbs. per thousand gallonsBB  PC DLiquid AD %C):_:j  Bf "^DSolid AD %C):_:j Bf ""BhM RDLiquid  :h3DSolid  :i:["Blbs. per thousand gallonsBB  LchL RDLiquid  :j3DSolid  :k:["Bthousand gallons per acreBB  MbhM RDLiquid  :j3DSolid  :k:["Bthousand gallons per acreBB  PbhP RDLiquid  :j3DSolid  :k:["Bthousand gallons per acreBB T RED@ D R BB  L$ ` S L lBB  M~ b9@ N M~ l9@BB  M% Ca@  D nC):n:y&BfDD?DD?DD?DqC):n:y&BfDD ?DD ?DD ?D"B M P7FD@!C ):k:vBfBB  M<CT@ &C):n:y BfD MBB  MID@ !D M BB  PJR@ D! P LGDCorn for silageBB # L~ dD@ Ln M~ lA@BB  M~ e? Mn P7HD@!C):n:y& BfBB  M~ e4@ MnBB U V~ f@ Po BB  L~ g@ Lp GDCorn for silageBB  N^~ h@hM RDLiquid  :[3DSolid  :\:l"Bthousand gallons ~ l.@BB Dl,D@gvufb~qpL` ! ;" # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  M&~ h&@ Nq  ~ l@_@ BB ! !M'~ !e$@ !Nr! !7!HR@!C):n:y&Bf!BB " "P(~ "h @ "Os"BB # #[#\YBB $ $L~ $e/@ $Lr$BB %M %%MBB & &M)~ &e &Mt&BB ' 'M*~ 'eA@ 'Mu'BB ( (M+~ (e@ (Mv(BB ) )P,)i )Pw)BB * **YBB + +L-~ +c@ +Lx+BB , ,O`~ ,j ,Py,BB - -X.-ZYBB . .S/~ .c@@ .Lz.BB / /Nb~ /h /Mz/BB 0 0N0~ 0h4@ 0M{0BB 1 1O1~ 1k4@ 1Pr1BB 2BB 3BB 4BB 5BB 6BB 7BB 8BB 9BB :BB ;BB <BB =BB >BB ?BB D llL4L6LLLH6LL4LLLL @ A B C D E F G H I J K L M N O P Q R @BB ABB BBB CBB DBB EBB FBB GBB HBB IBB JBB KBB LBB MBB NBB OBB PBB QBB RBB *h <x &  o :o $& w(    Bc( XPP?di]4@ JkDJږH= E<FSee "Calculate number of animal units" cell to calculate this value. < uD E~~  <(XPP?i ]4@ )nus>E} O<PEnter total number of similarly sized animals (milking cows, sows, brood cows) < N O  BP XPP?i %]4@ I8aH꿤\ 0<1Not needed for soybeans, dry beans or grass hay < 0@ " BPb( XPP?i x]4"@ ȍ4l&OVsMd# <Use drop-down menu< x~~ $ <XPP?ip n]4$@ 7y SARPmu O<PEnter total number of similarly sized animals (milking cows, sows, brood cows) < N O~~ % <((XPP?ip K]4%@  jiK"  O<PEnter total number of similarly sized animals (milking cows, sows, brood cows) < N O @ B XPP?P]4@@ CPN]{r <Mineral soils < F  A B XPP?P@]4A@ 3-ܲKf<,α <Mineral soils < F w= ] Ba( XPP?x`]4]@ MJRB'=: 3<4To convert lbs/Acre to ppm, divide lbs/Acre by 2. < 2 3 ^ Bb( XPP?xi@!]4^@ XbNKhDZD<0 3<4To convert lbs/Acre to ppm, divide lbs/Acre by 2. < 2 3 ` B(b( XPP?w^Z]4`@ |.)KvޚV <Use drop-down menu < x H a Bb( XPP?wi^i]4a@ FmM"cP <Use drop-down menu < x  b BP( XPP?wi^i]4b@ \(0SatIA@^ <Use drop-down menu < x  c B( XPP?w^]4c@ E([quLUX,X <Enter the amount of manure applied to this field one year ago. This program assumes that the same kind of manure was applied If no manure was applied, leave blank. <  9` d BP XPP?wi^]4d@ ?g`=@,ٜ+ <Enter the amount of manure applied to this field two years ago. This program assumes that the same kind of manure was applied If no manure was applied, leave blank. <  @ e B XPP?wi^]4e@  JBwc <Enter the amount of manure applied to this field three years ago. This program assumes that the same kind of manure was applied If no manure was applied, leave blank. <  *`` Bob Battel`a Bob Battel` Bob Battel` Bob Battel`$ Bob Battel`% Bob Battel`c Bob Battel`d Bob Battel`e Bob Battel`b Bob Battel`" Bob Battel` Bob Battel`@ Bob Battel`] Bob Battel`A Bob Battel` ^ Bob Battel`>@ B"B"""  1R 2QR** 7+ #+ # + #+ # Sheet1b(b(///gg@ g2ɀ  z vL  dMbP?_*+%&?'?(?)?MCanon i70 (Copy 2)߁ odLetterBJDM,jjVT$m,`Oj,`OjVT$m,`Oj,`OjXX"DRAFTSample 1dVT$mVT$m@  VT$mCanon i70 (Copy 2)߁ odLetter:,"d??&cU} ^} ^} m^} ^} ^} $ ^z) h@       ; ; ; ; ;   ; ;          ;@ ;      _KK Y  Q}_ x y wZln VZLiquid  :c5ZSolid  :d:["Bper thousand gallons̬@@yZ 3ZZZZZ Z6Z ZZZZZB_ [7qYGB@ !DZD1Z#?\:{@ ZD o|#d@ DZ_ u p}#a8@5 DZ_ {R ~q r Q_KK oO88@ 9Z ZZZZ Bl VZLiquid  :j5ZSolid  :k:["Bthousand gallons per acre#OO? DZFќ5(?0D-C6? ZDB_KK oO=l VZLiquid  :[5ZSolid  :\:["Bthousand gallonsKKK tN43333U@8ZZZZZZZ t% !?@DD0D ZDZDZD   :JD  :*D  : ""BKKK t  t"Vg߽K@ DDKKK lu VZLiquid  :e5ZSolid  :f:["Bsavings per thousand gallons lu VZLiquid  :e5ZSolid  :f:["Bsavings per thousand gallons!1H$@ DDKKK t  t#R$J@ DZKKK t  t&-wR@<D4DKKK v  v#e@ DZKKK {| {}KKK ;$I$Z@%Ze :eB  ;%I$I"R@g%Zf :fB  KKK ;f%Ze :eB ;g%Zf :fB KKK ;yy>@f%Ze :eB ;g%Zf :fB KKK =C@ DDKKK lu VZLiquid  :e5ZSolid  :f:["Bsavings per thousand gallons!U3@' DDlt &VZLiquid  :e5ZSolid  :f:["Bsavings per thousand gallons!>1-@* DDKKK t#*gBzX@  DZ t#Gp4?R@  DZKKK D#l0BZ[R||0Dza=lumpmDh ! " # $ ;% ;& ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  t& 1a@!<D4D t& x7_NZ@!<D4D KKK !v#!B@ DZ !v#!\z@* DZ!KKK "{"} "z"|KKK ;#p۶mۖB@^%Zg :gB # ;#$I$?'%Zh :hB # #KKK ;$h%Zg :gB $;$ %Zh :hB $$KKK ;%^%Zg :gB %;%e%Zh :hB %%KKK &ܶm۶m@/D l& &VZLiquid  :[5ZSolid  :\:["Bthousand gallons&=<@ D l& )VZLiquid  :[5ZSolid  :\:["Bthousand gallons&KKK 't'kD@(D&D0D#ZD$ZD%ZD#  :JD$  :*D%  : ""B 't'7A@(D&D0D#ZD$ZD%ZD"  :JD$  :*D&  : ""B'KKK (t"(bݢvXF@) DD' (t"(|.NII@) DD'(KKK l)u )VZLiquid  :e5ZSolid  :f:["Bsavings per thousand gallons!)m$y&@ D(D&l)u 0VZLiquid  :e5ZSolid  :f:["Bsavings per thousand gallons!)U#@e D(D&)KKK *t#*vmpL@+ D)Z *t#*6ZiH@+ D)Z*KKK +t&+!T@,<D4D* +t&+_wQ@,<D4D*+KKK ,v#,"~9@ D)Z ,#,0 @ D)Z,KKK -{S-} -yU-|KKK .s~.eoaV=@1ZZ'Z&D4<Z"Z,ZZ Z/Z"Z$D4<Z) "Z(ZZ)BZZ+Z(Z Z!D4<Z1D4Z0< .s~.foaf6@.ZZ'Z&D4<Z"Z,ZZ Z/Z"Z$D4<Z) "Z(ZZ)BZZ+Z(Z Z1D4Z0<.KKK /t%/Y$kb%E@D.<D4 /t%/Y$kb%@@0<D.D4/KKK l0u 0VZLiquid  :[5ZSolid  :\:["Bthousand gallons#0Y^x@2 D.Zl0uY 4VZLiquid  :[5ZSolid  :\:["Bthousand gallons#0E%@2 D.Z0KKK 1t(1eoaV@0D.Z 1t(1foaf@ D.Z1KKK 2v#2rpP @/ D0Z 2v#2`n ߧ@1 D0Z2KKK 3T3KKK 64O D@_% <ZZ Z. 44KKK /5@Cwt@ ZZD4< 55KKK 6KKK 7KKK 8KKK 9KKK :KKK ;KKK <KKK =]]] >]]] ?]]] DlDhDMx0ha$$$$$$$$$@ A B C D E F G H I J K L M N O P)Q)R)S)T)U)V)W)X)Y)Z)[) \) ]); ^) _)  @]]] A]]] B]]] C]]] D]]] E]]] F]]] G]]] H]]] I]]] J]]] K]]] L]]] M]]] N]]] O]]] P]]] Q]]] R]]] S]]] T]]] U]]] V]]] W]]] X]]] Y]]] Z]]] [__________]]] [\ [ [[a@eZ[D@Z[R@Z.[@@?@@( \__________]]] \] \ \ \ \7 \8\ \9 \: \@?@@( ]__________]]] ]^ ] ] ] ] ] ]; ]<] ]= ] ] ]= ] ] ]!]"? ]#?]$? ]%@ ]&( ^__________]]] ^_ ^ ^^a@hD[O^t@d9Z  ZZZZBO^qqf@d9Z  ZZ ZZB^ ^> ^ ^? ^ ^!@ ^"? ^#@ ^$? ^%@ ^&? ^'( _` _ _O_۶m۶A@a9Z  ZZZZ BO_T@`9Z ZZZZBO_1 0 CF@`9Z  ZZ ZZB _ _@_.@<@ؓ@$@_ffffff@_@D@1@_ ffffff@@_!@(@A@>@$_%@_&_%_j%% LLL_&33333s8@`%_&_j&& LLL _'(DK l$$$$$$$$$$$$$$$$$$$$$$$$$$$D`) a) b) c) d) e) f) g) h) i) j) k) l) m) n) o) p)q)r)s)t)u)v)w)x)y) `a ` `W`۶m۶Q@bAZ  ZZZZ BW`d@aAZ  ZZZZBW`1 0 CV@aAZ  ZZ ZZB ` `A0`&@d@ @@@@#@@`@@` C@`! @8@?>@$`%fffff%@`&_%`&(\B@a%_& `'( ab a aWaH$IZ@s&AZ  ZZZZ BWan@bAZ  ZZZZBWa%I$I`@bAZ  ZZ ZZB a aBa'@d@@@affffff!@a@j@"@@B@a!@a fffffB@~ a!@a"~ a#>@a$a%p= ףp@a&_%a&b%_& a'( bc b bWb۶m۶a@AZ  ZZZZ BWbt@AZ  ZZZZBWb1 0 Cf@AZ  ZZ ZZB b bCb@@bffffff"@Bb@@@T@@@@:@?A@$b%)@b&_%b&GzF@c%_& b'( cd c cc cDcp@D@cffffff"@Bc@@@L@v@v@@:@?A@$c%fffff)@c&_%c&G@d%_& c'( de d d~ d!dPr D[D^!d8XZ D[D^ d dEdؘ@l@dffffff"@Bd0@@X@M@@@@:@?A@$d%333333*@d&_%d&fffff&G@e%_& d'( ef e e!e$I$Z@ D[D_!eD D[D_!eyy>@ D[D_ e e2BeІ@<@9@6@@3@@@@T@@!e"~ e#?e$e%@%@e&_%e&f%_& e'( fg f f!f%I$I"R@ D[D`!f^ D[D`!faa, D[D` f fFBf@@Ĩ@6@@@@|@@@!f"~ f#?f$f%%@f&_%f&g%_& f'( gh g g!gp۶mۖB@# D[Da!gi$ D[Da!g$I$IM% D[Da g gGgffffff#@<g@@9@T@7@@Z@ W@J@:@!g"~ g#>@g$g%QA@g&_%g&h%_& g'( hi h h!h$I$?# D[Db!h r$ D[Db!hbaY% D[Db h hH*hx@@9@@@)@hfffff`@hfffffP@h t@:@!h"~ h#>@h$h%(\B@h&_%h&i%_& h'( iji i3$i@@@9@@@@ifffff0@i@`U@`Q@1@!i"~ i#A@i$i%QK9@i&_%i&j%_& i'( jk j j jj j4jffffff @j@5@@jffffff@j"@@jffffff2@j B@@!j"~ j#4@j$j%Gz@j&_%j&l_& j'( kl k k~ k2k( l l l!l@P@m (Zl l l,l( m m m+m@J@n(?Zm m m m= m m m m m m m m m m m! m" m# m$ m% m& m'( nm n n~ n>@n n9nb@n#CDn  #  BKn f@n5Dn ;(\?Dn Bn.@B@.@$@Vnn@ZDn $DnZC Dn BZnnDDnZ ZDnDn B$C Dn Bn@nZZnZn ZZn B$HZZnZZnZZnZnZn Bn@nnny -B,n \@n%K@Zn ;@>@4@"n#n&n#Xny## NCL 4LC?CC L Bn$@on$Jny$$ @LC CLL B$C L Bn%n#mCDnDn! CDn2 B$8C Dn C Dn CDnDn!Dn" Bn&@n$n&ny&& -B n'n( ol o o+o@J@o(?Zo o9o9@o#CDo  #  BKof@o5Do 9)\ @Do Bo.@t@.@$@Voo@ZDo $DoZC Do BZooDDoZ ZDoDo B$C Do BoD@oZZoZo ZZo B$HZZoZZoZZoZoZo BoD@on,o \@o%K@Zo @4@"o#o&n#o$pn$o%R@o#mCDoDo! CDo B$8C Do C Do CDoDo!Do" Bo&R@o$n& o'o( p p+p@@@p?Zp p9pD@p#CDp  #  (B5ppDp  Bp.@T@.@$@Vpp@ZDp $DpZC Dp BZppDDpZ ZDpDp B$C Dp Bp$@pZZpZp ZZp B$HZZpZZpZZpZpZp Bp$@pn,p \@p%K@Zp a@>@4@"p#p&n#p$A@qn$p%p#p%wpw%%mCLL CL2 B$8C LC LCLLL Bp&A@p$n& p'p( q q+q@J@q(?Zq q9q4@q#CDq  #  B?q[@q)Dq Dq Bq.@@`@.@$@Vqq@ZDq $DqZC Dq BZqqDDqZ ZDqDq B$C Dq Bq@0@qZZqZq ZZq B$HZZqZZqZZqZqZq Bq@0@qn,q \@q%K@Zq t@>@4@"q#q&n#q$T@rn$q%q#p%q&T@q$n& q'q( r r~ r4@r r9rN@r#CDr  #  <BKr43333P@r5Dr *HzG?Dr Br9@O@.@$@Vrr@ZDr $DrZC Dr BZr/@rDDrZ ZDrDr B$C Dr BrrZZrZr ZZr B$HZZrZZrZZrZrZr Br/@rn,r \@r#K@Zr B@>@4@"r#r&n#r$"@r%n$r%sp%r&"@r$n& r'r( s s~ sD@s s9sY@s#CDs  #  dBAsD@s+Ds ?Ds Bs.@?.@$@Vss@ZDs $DsZC Ds BZssDDsZ ZDsDs B$C Ds Bs @sZZsZs ZZs B$HZZsZZsZZsZsZs Bs @sn,s \@s#K@Zs 3@>@4@"s#tn#s$@u#n$s%w%p%s&@[n& s's( t t+t@E@t?Zt t9t @t#CDt  #  B5ttDt  Bt9@*@.@$@Vtt@ZDt $DtZC Dt BZtPt@tDDtZ ZDtDt B$C Dt BttZZtZt ZZt B$HZZtZZtZZtZtZt BtPt@tn,t \@t#K@Zt I@I@"t#un#t$t&n$t%L@s%p%t&L@s$n& t't( u u+u@E@u?Zu u9u |@u#CDu  #  BKu`h@u5Du Du,333333? BuN@*@D@9@Vu`@u@ZDu $DuZC Du BZuuDDuZ ZDuDu B$C Du BuuZZuZu ZZuK B$HZZuZZuZZuZuZu Bu`@un,u \@u%K@Zu O@>@4@"u#u&n#u$/@t$n$u%vp%u&/@.n& u'u( v v+v@E@v?Zv v9v@v#CDv  #  BAv Y@v+Dv 333330@Dv Bv.@1@.@$@Vvv@ZDv $DvZC Dv BZvvDDvZ ZDvDv B$C Dv Bvj@vZZvZv ZZv B$HZZvZZvZZvZvZv Bvj@vn,v \@v#K@Zv O@>@4@"v#wn#v$8@v&n$v%t%p%v&8@u$n& v'v(w w 9w@w#CDw  #  B;wY@w%Dw  Dw Bw.@*@.@$@Vww@ZDw $DwZC Dw BZwwDDwZ ZDwDw B$C Dw BwPd@wZZwZw ZZw B$HZZwZZwZZwZwZw BwPd@wn,w \@w$K@Zw I@>@4@"w#xn#w$@w#n$w%w&p%w&@v$n& w' w(x x!9x@x#CDx  #  BAx> ףpH@x+Dx )\ @Dx Bx4@*@.@$@Vxx@ZDx $DxZC Dx BZxPt@xDDxZ ZDxDx B$C Dx BxxZZxZx ZZx B$HZZxZZxZZxZxZx BxPt@xn,x \@x%K@Zx C@$@I@"x#x$n#x$yn$x%@x#mCDxDx! CDx< B$8C Dx C Dx CDxDx!Dx" Bx&@n& x'!x(y y"9y @y#CDy  #  BAyb@y+Dy 2@Dy B~ y.@yffffff@y.@$@Vyy@ZDy $DyZC Dy BZyyDDyZ ZDyDy B$C Dy ByL@yZZyZy ZZy B$HZZyZZyZZyZyZy ByL@yn,y \@y#K@Zy M@>@4@"y#y&n#y$@y%n$y%`mCDyDy! CDy2 B$8C Dy C Dy CDyDy!Dy" By&@y$n& y'"y(8@AXiiuDn{_J@Uka0 " $o !o &>@ [[ \^\\\^\\ ]^]^^^^^ 6>Z Z337 Sheet2b(b(///gg Oh+'0HPd  Bob BattelSheynerman, Paula D.Microsoft Excel@N@,m p@S*՜.+,0HP X`hp x I  Introduction Instructions Haul Input Haul OutputANIMALCECCredits CROPGROWN CROPNAMEKST MANURETYPENCROPRECNITSPECIESSTL YIELDGOAL  Worksheets Named Ranges   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FWorkbook NSummaryInformation(DocumentSummaryInformation8