Excel Sheet Download 11540 | 35723 Item Download 2022-07-05 09-25-03

Partial file snippet.

Sheet 1: Lodi Worksheet

	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		

		

		Sample Irrigation Scheduling Worksheet - Lodi, CA
		

		

		

		

		

		

		

		

		

	
	
		

		

		ETo and precipitation are the averages of daily data from 1984 to 2003. 
		

		

		

		

		

		

		

		

		

	
	
		

		

		Data  from the Lodi (CIMIS #42) and West Lodi (#166) weather stations
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Formulas are all present; simply input your numbers in the blue-colored columns.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Assumptions
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		1. Leaf Water Potential trigger was reached July 8th.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		2. Harvest Date was October 1.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Date
		A =            Historical Etoa
		B =                Crop Coefficientb 
		C =                A x B:      Potential Water Use
		D =           RDI Coefficientc
		E =                  Soil Contribution
		F =      Effective Rainfalld 
		G =                       [(C x D) - E - F]:             Net Irrigation Requirement
		H =     Emission Uniformitye 
		I =             G/H:Gross Irrigation Amount
		J =            Vine Spacingf
		K =                 (I x J x .623):      Gallons per Vine/ Period
		L =               Average Application Rate
		M =               (K/L):       Hours of PREDICTED Irrigation Time
		

		

		

		

		

		

		

		

	
	
		Period
		Inches/Period
		Kc
		(in)
		RDI %
		(in)
		(in)
		(in)
		(%)
		(in)
		(sq feet)
		(gal/week)
		(gph/vine)
		(hours)
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Jly 8-14
		1.82
		0.68
		1.24
		0.5
		0.2
		0
		0.42
		92
		0.45
		77
		21.8
		0.96
		22.7
		

		

		

		

		

		

		

		

	
	
		Jly 15-21
		1.720
		0.68
		1.17
		0.5
		0.2
		0
		0.38
		92
		0.42
		77
		20.1
		0.96
		20.9
		

		

		

		

		

		

		

		

	
	
		Jly 22-28
		1.692
		0.68
		1.15
		0.5
		0.2
		0
		0.38
		92
		0.41
		77
		19.6
		0.96
		20.4
		

		

		

		

		

		

		

		

	
	
		Jly 29 to Aug 4
		1.676
		0.68
		1.14
		0.5
		0.2
		0
		0.37
		92
		0.40
		77
		19.3
		0.96
		20.1
		

		

		

		

		

		

		

		

	
	
		Aug 5-11
		1.626
		0.68
		1.11
		0.5
		0.2
		0
		0.35
		92
		0.38
		77
		18.4
		0.96
		19.2
		

		

		

		

		

		

		

		

	
	
		Aug 12-18
		1.556
		0.68
		1.06
		0.5
		0.2
		0
		0.33
		92
		0.36
		77
		17.2
		0.96
		17.9
		

		

		

		

		

		

		

		

	
	
		Aug 19-25
		1.494
		0.68
		1.02
		0.5
		0.2
		0
		0.31
		92
		0.33
		77
		16.1
		0.96
		16.7
		

		

		

		

		

		

		

		

	
	
		Aug 26 to Sept 1
		1.448
		0.68
		0.98
		0.5
		0.2
		0
		0.29
		92
		0.32
		77
		15.2
		0.96
		15.9
		

		

		

		

		

		

		

		

	
	
		Sept 2-8
		1.368
		0.68
		0.93
		0.5
		0.2
		0
		0.27
		92
		0.29
		77
		13.8
		0.96
		14.4
		

		

		

		

		

		

		

		

	
	
		Sept 9-15
		1.225
		0.68
		0.83
		0.5
		0.2
		0
		0.22
		92
		0.24
		77
		11.3
		0.96
		11.8
		

		

		

		

		

		

		

		

	
	
		Sept 16-22
		1.171
		0.68
		0.80
		0.5
		0.2
		0
		0.20
		92
		0.22
		77
		10.3
		0.96
		10.8
		

		

		

		

		

		

		

		

	
	
		Sept 23-29
		1.054
		0.68
		0.72
		0.5
		0.2
		0
		0.16
		92
		0.17
		77
		8.3
		0.96
		8.6
		

		

		

		

		

		

		

		

	
	
		Sept 30 to Oct 6
		0.974
		0.68
		0.66
		1
		

		0
		0.66
		92
		0.72
		77
		34.5
		0.96
		36.0
		

		

		

		

		

		

		

		

	
	
		Oct 7-13
		0.883
		0.68
		0.60
		1
		

		0
		0.60
		92
		0.65
		77
		31.3
		0.96
		32.6
		

		

		

		

		

		

		

		

	
	
		Oct 14-20
		0.779
		0.68
		0.53
		1
		

		0
		0.53
		92
		0.58
		77
		27.6
		0.96
		28.8
		

		

		

		

		

		

		

		

	
	
		Oct 21-27
		0.660
		0.68
		0.45
		1
		

		0
		0.45
		92
		0.49
		77
		23.4
		0.96
		24.4
		

		

		

		

		

		

		

		

	
	
		Oct 28 to Nov 3
		0.540
		0.68
		0.37
		1
		

		0.32
		0.05
		92
		0.05
		77
		2.4
		0.96
		2.5
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Total
		

		

		14.75
		

		2.40
		

		5.96
		

		6.47
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		a http://wwwcimis.water.ca.gov/cimis  or
		

		 http://ucipm.ucdavis.edu   
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		b Crop Coeficient calculated based on 40%  midday land surface shaded (0.68)
		

		

		

		

		

		

		

		Gallons per vine applied though harvest = 
		191.3
		

		

		

		

		

		

		

		

		

		

	
	
		c Regulated Deficit is 50% (0.5)
		

		

		

		

		

		

		

		

		

		Hours of irrigation time through harvest = 
		

		

		199.3
		

		

		

		

		

		

		

		

	
	
		d Effective rainfall is calculated from actual rainfall. Calculations are not shown on this sheet.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		e Under deficit irrigation, Irrigation Efficiency is assumed equal to Emission Uniformity.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		e spacing 7 x 11 ft = 77 ft sq.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet lodi worksheet sample irrigation scheduling ca eto and precipitation are the averages of daily data from to cimis west weather stations formulas all present simply input your numbers in bluecolored columns assumptions leaf water potential trigger was reached july th harvest date october a historical etoa b crop coefficientb c x use d rdi coefficientc e soil contribution f effective rainfalld g net requirement h emission uniformitye i ghgross amount j vine spacingf k gallons per period l average application rate m kl hours predicted time inchesperiod kc sq feet galweek gphvine jly aug sept oct nov total httpwwwcimiswatercagovcimis or httpucipmucdavisedu coeficient calculated based on midday land surface shaded applied though regulated deficit is through rainfall actual calculations not shown this under efficiency assumed equal uniformity spacing ft...

Related files

Share

Help

		Sample Irrigation Scheduling Worksheet - Lodi, CA
		ETo and precipitation are the averages of daily data from 1984 to 2003.
		Data from the Lodi (CIMIS #42) and West Lodi (#166) weather stations

Formulas are all present; simply input your numbers in the blue-colored columns.
Assumptions
1. Leaf Water Potential trigger was reached July 8th.
2. Harvest Date was October 1.
Date	A = Historical Etoa	B = Crop Coefficientb	C = A x B: Potential Water Use	D = RDI Coefficientc	E = Soil Contribution	F = Effective Rainfalld	G = [(C x D) - E - F]: Net Irrigation Requirement	H = Emission Uniformitye	I = G/H:Gross Irrigation Amount	J = Vine Spacingf	K = (I x J x .623): Gallons per Vine/ Period	L = Average Application Rate	M = (K/L): Hours of PREDICTED Irrigation Time
Period	Inches/Period	Kc	(in)	RDI %	(in)	(in)	(in)	(%)	(in)	(sq feet)	(gal/week)	(gph/vine)	(hours)


Jly 8-14	1.82	0.68	1.24	0.5	0.2	0	0.42	92	0.45	77	21.8	0.96	22.7
Jly 15-21	1.720	0.68	1.17	0.5	0.2	0	0.38	92	0.42	77	20.1	0.96	20.9
Jly 22-28	1.692	0.68	1.15	0.5	0.2	0	0.38	92	0.41	77	19.6	0.96	20.4
Jly 29 to Aug 4	1.676	0.68	1.14	0.5	0.2	0	0.37	92	0.40	77	19.3	0.96	20.1
Aug 5-11	1.626	0.68	1.11	0.5	0.2	0	0.35	92	0.38	77	18.4	0.96	19.2
Aug 12-18	1.556	0.68	1.06	0.5	0.2	0	0.33	92	0.36	77	17.2	0.96	17.9
Aug 19-25	1.494	0.68	1.02	0.5	0.2	0	0.31	92	0.33	77	16.1	0.96	16.7
Aug 26 to Sept 1	1.448	0.68	0.98	0.5	0.2	0	0.29	92	0.32	77	15.2	0.96	15.9
Sept 2-8	1.368	0.68	0.93	0.5	0.2	0	0.27	92	0.29	77	13.8	0.96	14.4
Sept 9-15	1.225	0.68	0.83	0.5	0.2	0	0.22	92	0.24	77	11.3	0.96	11.8
Sept 16-22	1.171	0.68	0.80	0.5	0.2	0	0.20	92	0.22	77	10.3	0.96	10.8
Sept 23-29	1.054	0.68	0.72	0.5	0.2	0	0.16	92	0.17	77	8.3	0.96	8.6
Sept 30 to Oct 6	0.974	0.68	0.66	1		0	0.66	92	0.72	77	34.5	0.96	36.0
Oct 7-13	0.883	0.68	0.60	1		0	0.60	92	0.65	77	31.3	0.96	32.6
Oct 14-20	0.779	0.68	0.53	1		0	0.53	92	0.58	77	27.6	0.96	28.8
Oct 21-27	0.660	0.68	0.45	1		0	0.45	92	0.49	77	23.4	0.96	24.4
Oct 28 to Nov 3	0.540	0.68	0.37	1		0.32	0.05	92	0.05	77	2.4	0.96	2.5

Total			14.75		2.40		5.96		6.47
a http://wwwcimis.water.ca.gov/cimis or		http://ucipm.ucdavis.edu
b Crop Coeficient calculated based on 40% midday land surface shaded (0.68)								Gallons per vine applied though harvest =			191.3
c Regulated Deficit is 50% (0.5)										Hours of irrigation time through harvest =			199.3
d Effective rainfall is calculated from actual rainfall. Calculations are not shown on this sheet.
e Under deficit irrigation, Irrigation Efficiency is assumed equal to Emission Uniformity.
e spacing 7 x 11 ft = 77 ft sq.

Related files

Share

Share to social media

Help

Login Area