Spreadsheet: 11a177d5-5f98-45f2-bfe1-b64228f60bec
Sheet: Design

LAVERS RANCH VINEYARD DESIGN
Field Constraints:
 | Crop: Wine Grapes
 | Location: Glenville, Ca
 | Crop Spacing |  | 8 | ft by | 6 | ft
 | Field Size: | 2 separate field
 |  | Field A | 13.4 | acres
 |  | Field B | 19 | acres
 | Vineyard row runs NE to SW
 | [NAME] = |  | 0.34 | inches/day
 | Assuming 40% crop coverage
 |  | Kc = | 0.7
 | [NAME]
 | Irrigation
 |  | 24 | hours | 7 | days
1. [NAME] ET rate
 | [NAME] |  | inches/day in May from CIMIS Spatial Data
 | [NAME]
 | Peak Et = Eto * Kc
 | Peak ET |  | inches/day
 |  | * Assume 10% increase with drip
 | Peak ET |  | inches/day
2. Estimate GPH/vine needed
 |  | inches/day
 |  | hours/day
 |  | days/week
 |  | ft by |  | ft Vine spacing
 |  | Sq. ft Vine spacing area
 |  | GPM/vine (net)
 |  | GPH/vine (net)
 | * Assuming perfect timing, and no over-irrigation at "driest" point during
 |  | peak ET. With drip irrigation, the percent spray loss is zero
 | * Use DU of 0.8 so that as the systems deteriorates with time, there will be
 |  | less chance of under-irrigation on a portion of the field
 | 0.8 | DU (assumed)
 |  | GPH/Vine (gross)
3. Estimate the Number of Emitters/Vine:
Soil Type |  |  | Additional Lateral Movement for Drip
 |  |  | Radius (ft)
Coars Sand |  |  | 0.5 - 1.5
Fine Sand |  |  | 1.0 - 3.0
[NAME] |  |  | 3.0 - 4.5
Heavy Clay |  |  | 4.0 - 6.0
 | *The soil type for the field is a sandy loam so use an additional 3.0 ft
 |  | Diameter | 6 | ft
 | With one emitter/vine on this soil, the wetted volume
 | Wetted Volume |  |  | ft2
 | [NAME] |  |  | ft2
 | % Wetted Volume |  |  | %
 | This does not meet the necessary requirement of 60% wetted soil volume.
 | * 2 Emitters will be used per vine as specified in the picture below
4.) Examine the Number of Irrigation Blocks Needed:
 | * First the proper emitter must be selected. The objective is to select an emitter that
 | operates ata reasonable pressure (generally between 13 - 25 psi) and which provides
 | the correct application in the selected number of hours.
 | * Use DNCP12 - Wdpkr PC, 1/2 GPH (#2)
 | 0.5 | GPH/emitter
 | Pressure Range from 10-70 psi
 | 2 | emitter per vine
 | 18 | inch emitter spacing from center of vine
 | Field A
 |  |  | acres
 |  |  | ft2
 |  |  | ft2 Vine spacing area
 |  |  | Number of Vines
 |  |  | Number of Emitters
 |  |  | GPH, Field Flow Rate
 |  |  | GPM, Field Flow Rate
 | Field B
 |  |  | acres
 |  |  | ft2
 |  |  | ft2 Vine spacing area
 |  |  | Number of Vines
 |  |  | Number of Emitters
 |  |  | GPH, Field Flow Rate
 |  |  | GPM, Field Flow Rate
5.) Design Block Sizes for each field
 | Field A |  |  |  | Field B
 | Block 1 | Block 2 | Block 3 | Block 4 | Block 5 | Block 6 | Block 7 | Block 8 | Block 9 | Block 10
Area, ft2 | 141895 | 143113 | 150094 | 142430 | 142743 | 146385 | 141070 | 134502 | 136067 | 126889
Area, acre
Vine Spacing Area, ft2
Emitters per Vine
GPH per emitter
Vines per Block
GPH per Block
GPM per Block
 |  | * 16 ft road seperates each block
 | Block Layout
6.) Analysis of Longest Lateral for [NAME]
 |  | Field B
 |  | Block 6
 | Min. P, PSI
 | [NAME]. P, PSI
 | Change in P, PSI
 |  | *Values found using 0.72" [NAME], see block appendix for more details.
 | * Block 6 has the longest run length with 1531 feet downhill with a change in elevation of 10 feet.
 | * From the specifications given by Netafim for the WPC 0.5 emitter, it will succesfully supply 0.5 GPH for a range
 | of pressure from about 5 psi to 50 psi.
 | *Therefore the pressure through the lateral can not decrease below 5 psi.
 | * Netafim drip [NAME] will be used with an inside diameter of 0.72 inches
7.) Analysis of Location of Sub-mainline for Block 6
 | By placing the sub-mainline somewhere in the field some of the flow will be moving uphill rather than down.
 | By analyzing the total field, if the sub-mainline is placed |  |  |  |  |  |  | feet from the top of the field
 | Uphill |  |  |  | Downhill
 | Length |  | feet |  | Length |  | feet
 | * The sub-mainline will be placed after the 197th emitter.
8.) Analysis of Sub-mainline [NAME] for Each Block
 | Field A |  |  |  | Field B
 | Block 1 | Block 2 | Block 3 | Block 4 | Block 5 | Block 6 | Block 7 | Block 8 | Block 9 | Block 10
Sub-Main Length, ft
Min. P, PSI
[NAME]. P, PSI
Average P, PSI
GPM
Change in P, PSI
 | * See block appendix for more details
 | *Adjusting pressure regulator to 25 psi will provide sufficient pressure for each block.
Pipe Specs | Field A |  |  |  | Field B
 | Block 1 Pipe Length (ft) | Block 2 Pipe Length (ft) | Block 3 Pipe Length (ft) | Block 4 Pipe Length (ft) | Block 5 Pipe Length (ft) | Block 6 Pipe Length (ft) | Block 7 Pipe Length (ft) | Block 8 Pipe Length (ft) | Block 9 Pipe Length (ft) | Block 10 Pipe Length (ft)
Class 160 IPS 2", ID = 2.193" | 381 | 96 | 115 | 71 | 491 | 0 | 81 | 50 | 553 | 365
Class 200 IPS 1.5", ID = 1.72" | 364 | 259 | 699 | 313 | 179 | 122 | 539 | 184 | 154 | 254
Total Length (ft)
9.) Analysis of Mainline Size
 | 150 | C-value for PVC ID > 5"
 | 145 | C-value for PVC 1.5" < = ID < =  5"
 | 140 | C-value  for PVC < 1.5"
 | 20 | feet, Total Elevation Drop
 | 2339.9 | feet, Length of mainline
 |  | ft/ft, Change in Elevation
 | Chg. Elev = Length * ft/ft (elevation change worst case)
 | Chg. P = Chg. Elev + Hf
Section 1
 | Length ft | Pressure PSI | GPM | Pipe ID, in | Velocity, ft/sec | C-Value | Hf (psi) | Chg. Elev (psi) | Chg. P (psi)
Inlet | 0 | 38 | 205 | 4.224
1 | 20 |  |  | 4.224
2 | 20 |  |  | 4.224
3 | 20 |  |  | 4.224
4 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
Block 1 inlet | 4.8 |  |  | 4.224
 | 15.2 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
Block 2 inlet | 4 |  |  | 3.284
 | 16 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
 | 20 |  |  | 3.284
Block 3 inlet | 12.7 |  |  | 2.193
 | 7.3 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
Block 4 inlet | 19.9 |  |  | 2.193
 | Min, P |  | PSI
 | [NAME], P |  | PSI
 | Avg. P |  | PSI
 | 150 | C-value for PVC ID > 5"
 | 145 | C-value for PVC 1.5" < = ID < =  5"
 | 140 | C-value  for PVC < 1.5"
 | 15 | feet, Total Elevation Drop
 | 2339.9 | feet, Length of mainline
 |  | ft/ft, Change in Elevation
Section 2
 | Length ft | Pressure PSI | GPM | Pipe ID, in | Velocity, ft/sec | C-Value | Hf (psi) | Chg. Elev (psi) | Chg. P (psi)
Inlet | 0 | 38 | 265 | 5.221
1 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
 | 20 |  |  | 5.221
Block 5 inlet | 18.7 |  |  | 5.221
 | 1.3 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
Block 7 inlet | 16 |  |  | 4.224
 | 4 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
Block 6 inlet | 2.8 |  |  | 4.224
 | 17.2 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
 | 20 |  |  | 4.224
Block 8 and 10 inlet | 17.8 |  |  | 2.193
 | 2.2 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
 | 20 |  |  | 2.193
Block 9 inlet | 15.7 |  |  | 2.193
 | Min, P |  | PSI
 | [NAME], P |  | PSI
 | Avg. P |  | PSI
Mainline [NAME]
PVC PIPE Specification |  | Pipe ID (in) | Section 1 length (ft) | Section 2 length (ft)
Class 125 psi. SDR 35, 5" |  | 5.221 | 0 | 1559
Class 125 psi. SDR 35, 4" |  | 4.224 | 1141 | 1742
Class 125 psi. SDR 35, 3" |  | 3.284 | 360 | 0
Class 160 psi IPS, 2" |  | 2.193 | 828 | 538
 |  | Total (ft)
10.) Frost Protection Design
 | *NO GUARANTEE OF EFFECTIVENESS CAN BE PROVIDED
 | Using Wade Rain Pulsator:
 |  | 2 | GPH, pressure compensating
 |  | 15 | Psi operating pressure
 |  | 24 | inch wide spray
 |  | 15 | feet, spray length
 |  | 12 | feet, recommended spacing
 |  | 155 | Mesh Minimum required filtration
Analysis of Frost Protection Sub-mainline [NAME] for Each Block
 | Using Wade Rain 2 GPH pulsators spaced at every other vine requires the same amount of water as does the drip system.
 | Therefore another sub-mainline will be placed in adjacent to and same size as the drip sub-mainline.
 | The frost protection and drip system will be the same set up except that the frost protection will use a higher pressure
 | setting on the adjustable pressure regulator to prevent the pulsators from plugging.
 | Adjusting the pressure regulator to 35 psi will provide sufficient pressure for each block.
11.) Filtration System
 | The filtration system must be designed for the worst situation and since the water supply
 | comes from both a well and surface supplies the filtration must be designed to handle the surface
 | water contaminates. This design requires media tanks to sufficiently filter the moderately dirty
 | water. ** A common rule of thumb is to remove all particles larger than 1/7 of the microsprayer
 | orifice diameter.
 | Maximum flow rate |  |  | GPM
 | Orifice diameter = |  | 0.09 | inches |  | [NAME]
 | Min. removed particle diameter = |  |  | inches |  | [NAME]
[NAME] and Equivalent Openings (Burt, 2007)
 |  |  |  | Media Selection Table
Media # | Media Type |  |  | Mean Effective Media [NAME] ([NAME]) |  |  | Mean Filtration Capacity (@ 15-25 GPM/sq. ft)
12 | Round [NAME] |  |  | 1.3 |  |  | 0.16 - 0.15 mm |  |  |  | 90 - 70 mesh
16 | Round [NAME] |  |  | 0.65 |  |  | 0.12 - 0.15 |  |  |  | 125 - 100
8 | Crushed Granite |  |  | 1.5 |  |  | 0.11 - 0.15 |  |  |  | 140 - 100
12 | Crushed Silica |  |  | 1.2 |  |  | 0.11 |  |  |  | 140 - 130
20 | Round [NAME] |  |  | 0.5 |  |  | 0.11 |  |  |  | 140 - 130
11 | Crushed Granite |  |  | 0.78 |  |  | 0.08 - 0.11 |  |  |  | 200 - 140
16 | Crushed Silica |  |  | 0.7 |  |  | 0.08 - 0.10 |  |  |  | 200 - 150
20 | Crushed Silica |  |  | 0.47 |  |  | 0.06 - 0.08 |  |  |  | 250 - 200
 | Use #16 Crushed Silica
Recommended vertical media tank sizes for emitter and row crop drip systems ([NAME], 2007)
Irrigation System Flow Rate, GPM
Moderate [NAME] |  | Moderately Heavy Dirt Load |  |  | Number and [NAME] ([NAME])  of Tanks
50 |  | 35 |  |  | 2 - 18"
100 |  | 75 |  |  | 3 - 18"
150 |  | 105 |  |  | 3 - 24"
175 - 275 |  | 122 - 192 |  |  | 3 - 30"
276 - 425 |  | 193 - 299 |  |  | 4 - 30"
426 - 575 |  | 300 - 399 |  |  | 4 - 36"
576 - 775 |  | 400 - 539 |  |  | 3 - 48"
776 - 1025 |  | 540 - 719 |  |  | 4 - 48"
1026 - 1275 |  | 720 - 899 |  |  | 5 - 48"
1275 - 1525 |  | 900 - 1069 |  |  | 6 - 48"
1526 - 1675 |  | 1070 - 1170 |  |  | 7 - 48"
 | Use 3 - 48" Tanks
12.) Estimated Pressure Loss When Filters Are Dirty
 | A typical value of friction loss through a well designed filtration system is 7.0 psi
 | Filtration SummarY:
 |  | 3 | 48" Tanks
 |  | #16 | Crushed Silica
 |  | 7 | psi loss when filters are dirty
13.) Pump TDH Requirement
 | Pressure @ u/s pt. of segment [NAME] (pump outlet) |  |  |  |  | = | 38 | [NAME]
 | plus media filter loss when dirty |  |  |  |  | = |  | [NAME]
 | plus Emergency screen loss |  |  |  |  | = | 0.5 | [NAME]
 | *plus minor losses |  |  |  |  | = | 6 | [NAME]
 | minus Pump inlet pressure |  |  |  |  | = | n/a
 |  |  |  |  | TDH | = |  | [NAME]
 |  |  |  | System GPM |  | = |  | GPM
 | * Minor losses include: check valves, set valves, risers, pressure regulators, elbows, etc.
 | One should always check with the specific valve manufacturer to determine as many valve
 | loss components as possible