WIND EROSION EQUATION Introduction to the Spreadsheet

1
WIND EROSION EQUATIONIntroduction to the
Spreadsheet
Mike Sporcic State Agronomist, NM
2
The Good Old Days
3
The Good Old Days cont.
4
Then came the PC age

• About 1997 a wise NRI specialist in the SO gave
  me the use of a laptop.
• I also attended the West Agronomy Consortium
  meeting in Portland (1997), where Dave Lightle
  told me of Tom Keeps effort to computerize WEQ.
• It was the back half of the model I am presenting
  to you today.

5
The Future is WEPS

• By 200? we will move to WEPS

6
Introduction WEQ Excel Spreadsheet

• Cover NAM Circular 2 changes
• Changes to Ridge Roughness
• Show data files needed to run
• Discuss limitations of the sheet
• Quick intro to the Excel spreadsheet
• Demo how to edit and make changes
• Answer Questions

7
Spreadsheet History

• Started as a North Plains spreadsheet by Tom
  Keep, Ag Engineer (Calc sheet only)
• Then Circular 2, NAM amendment Sept. 12, 1997
  adding the need for additional calculations
• SGe calculations added, 1998
• Input data linked to lookup formulas, 1998
• Krd-Ridge Roughness formulas added, 1998

8
Circular 2 Changes

• I adjustment for Irrigated
• -Above 134 no adjustment
• -Less than I134, reduce one I class
• -IF - Irr. factor reduces Erosive Wind Energy
  (EWE) for mgt period
• Random Roughness (Krr) combined with Ridge
  Roughness (Krd)

9
Circular 2 Changes Cont.

• Must know Irrigation Type
• Consumptive Use (CU) for the Crop
• Number of irrigation for the mgt period

10
ADJUSTMENTS TO I

• Irrigation adjustment (IF)
• -supporting data is limited
• -reduction observed in the field
• -adjustment applies to all soils except fine
  and very fine sands
• -Not for Is gt 134

11
EWE IRRIGATION ADJUSTMENT

• Effects of wet soil is accounted for by adjusting
  the EWE for the mgt period
• Bare wet soil remains non-erodible
• 1 day for coarse textured soils
• 2 days for medium textured soils
• 3 days for fine textured soils
• See sheet WEGtab for table

12
ADJUSTMENTS TO I - IRRIGATION
13
Krr RANDOM ROUGHNESS FACTOR

• Raises threshold wind speed at which erosion
  begins (Somewhat more than the 13 miles/hr at 1
  ft of height
• Provides some sheltered area among clods where
  moving soil can be trapped
• Spreadsheet reduces RR (clodsize) by one half
  after 15 days.

14
Krr RANDOM ROUGHNESS FACTOR

• Non-oriented surface roughness
• Cloddiness
• Usually created by tillage implements
• Values represented as standard deviation of
  roughness heights
• Use RUSLE Handbook 703 Pictures
• Must tie predicted roughness to new tillage

15
Random Roughness - Krr
16
Random Roughness, 0.25
17
Random Roughness, 0.40
18
Random Roughness, 0.65
19
Random Roughness, 0.75
20
Random Roughness, 0.85
21
Random Roughness, 1.05
22
Random Roughness, 1.60
23
Random Roughness, 1.70
24
Random Roughness, 2.15
25
Ridge Roughness- Krd

• Revised NAM has new tables
• Based on I values and Preponderance
• I values 134 and greater have own curve
• As Preponderance goes down, high complexity, (we
  do not know where the wind will come from), Krd
  goes up (the ridge is less effective)
• Krd can be lower than 0.5 now

26
Krr Ridge Roughness
27
Irrigation Input Requirements

• Need to know when water is applied, this includes
  pre-plant irrigation and post harvest irrigation.
• This is calculated in days so circle irrigation
  is a challenge.
• Drip irrigation also poses a problem. Need to
  estimate the of surface wet. I suggest we use
  only about 1/3 of the irrigation days. If it
  takes 3 irrigations in a period consider using
  only 1 day instead.

28
Circle Irrigation
This is one irrigation for this circle. It
takes 96 hours for this irrigation.
Suggest that one day would be correct.
Day 3-24 hrs
Day 4-24 hrs
(1 day x 1/4 of field x 4 days to cover field
1)
Day 1-24 hrs
Day 2-24 hrs
Is this one day or four days?
29
Field Width

• Width for use of the Speadsheet means the short
  side of the field or average short side of a
  polygon.
• A square field would use the side length.

30
Field Width vs Unsheltered Distance
Field Width
31
Field Width vs Unsheltered Distance

• The Excel Spreadsheet is able to determine the
  correct L using the Width of the field only.

32
Computer Requirements

• Need 486/33 min.
• 586 is better
• Windows 95, 98, NT, or XP
• Excel version 8.06
• 16 mg of RAM or better
• File name WEQ vs 8.06.xls
• Input shaded cells and pull down arrows

33
INSTR sheet
Read this sheet first.

• Wind Erosion Model Worksheet Legend
• -Definitions
• Describes input data and column headings
• New-Krd, Krr, IF, No of Irr, Yield adjustment,
  and TWF

34
Res WKS sheetRequired Inputs

• Operation Dates
• Crop Names
• Operations
• Percent Flat Residue
• Number of irrigation per mgt period
• Other data
• -Name, Tract, Loc, C, I, Field Width, LW
  ratio, Tillage Dir, Field Dir, Irr (y/n), etc.

35
Calc sheet

• Detailed calculations by Mgt Period
• Note Krd, Krr, and IF factors added here
• No inputs needed or allowed

36
Data Tables

• Crop table
• -Changes need to be made if clients crops are
  not listed or the values do not make since. Call
  the state agronomist to make the changes.
• Tillage table
• -Residue reduction with allowances for
• speed and type of residue tilled
• -Random roughness tied to tillage
• -Again if you think a change is necessary, call
  the state agronomist.

37
Data Tables cont.

• Climate data, the wind direction, EWE, and
  Preponderance are listed as available in NM
• Select the closes site to the field.

38
Summary

• If you can calculate residue reduction and
  understand irrigation, everyone can operate this
  program.
• State Agronomist must set up wind data (climate
  file), crop data, and operation (tillage) files
  before it can be used in a new state.
• Local CUs for all irrigated crops are needed.
  See the FOTG.

39
Limitations

• We can not change tillage direction in each mgt
  period.
• Files are large. First five columns can be saved
  to a smaller file.
• No preset templates, they can be made and saved
  for later use.
• It does not allow for crusting (no I factor
  adjustment for a period of crusting.

40
Limitations

• Need to know Irrigation and CU of the crops
• Do not have good growth curves for some crops
• Do not have SGe curves for all crops both green
  and dry
• There is no residue decomposition routine (like
  RUSLE has) through the mgt period
• There is no Krr degradation routine (like RUSLE
  has) Krr will be reduced to 0.25 after 15 days
  in a period.

41
Where to get more information

• Call me if you have trouble.
• Mike Sporcic, michael.sporcic_at_nm.usda.gov,
  505-761-4424
• Website for SCI and WEQ http//www.nm.nrcs.usda.go
  v/technical/tech-notes/agro.html

Were Done
42
Questions Short Demo