Irrigation Time Calculator_Landscape, Trees and Vegetables.xlsm

	A	B	C	D	E	F	H	J	L	N	P	R	T	V	X	Z	AB	AD	AG	AH	AI	AJ	AK	AL	AN	AO	AP	AQ	AR	AT	AU	AV	AW
1	Stn Id	Stn Name	CIMIS Region	Month	Month Year	Total ETo (mm)	Total Precip (mm)	Avg Sol Rad (W/sq.m)	Avg Vap Pres (kPa)	Avg Max Air Temp (C)	Avg Min Air Temp (C)	Avg Air Temp (C)	Avg Max Rel Hum (%)	Avg Min Rel Hum (%)	Avg Rel Hum (%)	Avg Dew Point (C)	Avg Wind Speed (m/s)	Avg Soil Temp (C)			Reference Evapotranspiration

2	171	Union City	San Francisco Bay	2	Feb-01	44.88	106.68	133	0.9	14.7	5	9.7	91	52	70	4.3	1.9	9.9			Wet	Moderate	Dry				Wet	Moderate	Dry
3	171	Union City	San Francisco Bay	3	Mar-01	91.15	46.74	199	1.1	18.7	7.3	12.6	95	56	77	8.7	1.7	13.5				ETo						ETo		Type of year
4	171	Union City	San Francisco Bay	4	Apr-01	114.32	54.36	256	1	16.9	6.3	11.5	91	54	73	6.7	2	14.5			0.2	median	0.8				0.2	median	0.8	Dry
5	171	Union City	San Francisco Bay	5	May-01	172.8	3.3	317	1.2	24.8	10.8	17.4	89	43	64	10.7	2	19.7		Month	(mm/month)	(mm/month)	(mm/month)			Month	(in/month)	(in/month)	(in/month)	Moderate
6	171	Union City	San Francisco Bay	6	Jun-01	173.8	0	344	1.3	24.3	11.5	17.6	89	46	67	10.9	2.1	22.5		1	#NUM!	37	39	31		1	#NUM!	1.5	1.6	Wet
7	171	Union City	San Francisco Bay	7	Jul-01	159.58	0	301	1.4	23.1	13.2	17.3	88	57	73	12.4	2.2	22.9		2	41	51	56	28		2	1.6	2.0	2.2
8	171	Union City	San Francisco Bay	8	Aug-01	136.23	0	284	1.5	23.5	13.3	17.3	90	57	76	13	2.1	22.2		3	74	85	92	31		3	2.9	3.4	3.6		Dry	Moderate	Wet
9	171	Union City	San Francisco Bay	9	Sep-01	112.12	0	227	1.4	23	11.8	16.6	92	53	74	11.9	1.7	20.2		4	105	113	121	30		4	4.2	4.5	4.8	High	0.9	0.8	0.7
10	171	Union City	San Francisco Bay	10	Oct-01	84.43	13.2	158	1.5	23.4	9.1	16	91	49	72	10.6	1.5	17.7		5	128	136	151	31		5	5.0	5.4	6.0	Moderate/Medium	0.6	0.5	0.4
11	171	Union City	San Francisco Bay	11	Nov-01	20.4	71.63	104	1.7	23.7	2.8	7.6	77	49	85	3.6	1.3	14.5		6	149	153	161	30		6	5.9	6.0	6.3	Low	0.3	0.2	0.1
12	171	Union City	San Francisco Bay	12	Dec-01		164.34	72	0.5	15.3	-4.8	-0.4	73	48	73	-4.7	1.5	10.9		7	155	160	167	31		7	6.1	6.3	6.6	Very Low	0.1	0.075	0.05
13	171	Union City	San Francisco Bay	1	Jan-02		26.42	99	0.3	15.1		-9.2	82	58	80	-10.7	1	9.3		8	136	142	148	31		8	5.4	5.6	5.8
14	171	Union City	San Francisco Bay	2	Feb-02		44.46	145	0.8	15.1	-4.7	0.2	80	45	86	-1.2	1.2	10.5		9	108	113	118	30		9	4.2	4.4	4.7
15	171	Union City	San Francisco Bay	3	Mar-02	43.63	56.65	198	1.1	18.1	5.8	10.8	91	49	75	6.8	1.8	12.5		10	72	81	85	31		10	2.8	3.2	3.3
16	171	Union City	San Francisco Bay	4	Apr-02	105.83	13.21	225	1.1	18.3	8.9	13.1	92	58	75	8.7	2	16.1		11	39	44	47	30		11	1.5	1.7	1.8
17	171	Union City	San Francisco Bay	5	May-02	142.55	0	295	1.2	19.5	9.3	13.9	92	55	74	9.3	2.1	17.9		12	28	30	35	31		12	1.1	1.2	1.4
18	171	Union City	San Francisco Bay	6	Jun-02	154.65	0	314	1.4	22.1	11.5	16.1	91	57	74	11.3	2	20.9			#NUM!	1146	1219	365			#NUM!	45	48
19	171	Union City	San Francisco Bay	7	Jul-02	169.1	0	314	1.5	24.2	13.1	18	91	54	73	12.9	2	22.4
20	171	Union City	San Francisco Bay	8	Aug-02	142.12	7.62	263	1.5	24.4	12.6	17.7	92	53	74	12.7	1.8	21
21	171	Union City	San Francisco Bay	9	Sep-02	119.48	12.96	226	1.4	25.7	11.8	18	92	44	69	12.1	1.5	19.8
22	171	Union City	San Francisco Bay	10	Oct-02	82.42	23.62	160	1.2	21.9	9	14.9	93	48	72	9.5	1.3	16.6
23	171	Union City	San Francisco Bay	11	Nov-02	46.47	82.04	109	1.1	19.6	6.4	12.4	95	49	74	7.7	1.1	13.1			Precipitation
24	171	Union City	San Francisco Bay	12	Dec-02	29.83	171.7	70	1	15.5	6	10.4	96	62	82	7.3	1.5	10.7			Dry	Moderate	Wet				Dry	Moderate	Wet
25	171	Union City	San Francisco Bay	1	Jan-03	35.58	38.35	92	1.2	17.2	6.7	11.4	98	66	85	8.9	0.9	11.5				ETo						ETo
26	171	Union City	San Francisco Bay	2	Feb-03	51.36	48.52	132	0.9	16.4	4.4	10.3	94	50	72	5.3	1.2	11.3			0.2	median	0.8				0.2	median	0.8
27	171	Union City	San Francisco Bay	3	Mar-03	95.33	31.49	201	1.1	18.2	7.3	12.7	92	52	73	7.9	1.7	14.5		Month	(mm/month)	(mm/month)	(mm/month)			Month	(in/month)	(in/month)	(in/month)
28	171	Union City	San Francisco Bay	4	Apr-03	99.15	93.98	217	1	16.7	7.3	12	92	54	72	7.2	1.9	15.4	Jan	1	13	44	116	31		1	0.5	1.7	4.6
29	171	Union City	San Francisco Bay	5	May-03	136.74	49.03	272	1.2	20.8	9.8	14.9	91	53	72	9.8	1.9	18.5	Feb	2	16	53	106	28		2	0.6	2.1	4.2
30	171	Union City	San Francisco Bay	6	Jun-03	150.69	0	294	1.4	22.9	12	17.1	89	54	70	11.4	2.1	20.6	Mar	3	24	56	93	31		3	1.0	2.2	3.7
31	171	Union City	San Francisco Bay	7	Jul-03	166.84	0	303	1.5	25.4	12.8	18.4	91	50	71	12.9	1.8	22.4	Apr	4	12	42	71	30		4	0.5	1.7	2.8
32	171	Union City	San Francisco Bay	8	Aug-03	148.39	0	277	1.6	24.9	14.3	18.8	91	53	73	14	2	22.4	May	5	0	3	38	31		5	0.0	0.1	1.5
33	171	Union City	San Francisco Bay	9	Sep-03	112.88	0	214	1.5	25.5	13.1	18.8	92	50	70	12.8	1.7	20.6	Jun	6	0	0	1	30		6	0.0	0.0	0.0
34	171	Union City	San Francisco Bay	10	Oct-03	86.93	0	171	1.3	23.5	9.8	15.9	92	46	71	10.3	1.2	17.7	Jul	7	0	0	0	31		7	0.0	0.0	0.0
35	171	Union City	San Francisco Bay	11	Nov-03	40.02	33.78	100	1	16.5	4.8	10.9	95	55	77	7	1.1	12.7	Aug	8	0	0	1	31		8	0.0	0.0	0.0
36	171	Union City	San Francisco Bay	12	Dec-03	27.53	113.02	68	1	14.8	5.8	10.1	96	61	82	7.1	1.3	10.9	Sep	9	0	0	11	30		9	0.0	0.0	0.4
37	171	Union City	San Francisco Bay	1	Jan-04	30.36	43.94	78	0.9	13.7	4.5	9.1	95	62	80	5.8	1.1	9.7	Oct	10	0	12	38	31		10	0.0	0.5	1.5
38	171	Union City	San Francisco Bay	2	Feb-04	45.22	103.38	110	1	17.4	5.3	10.4	94	55	76	6.2	1.5	10.9	Nov	11	25	45	65	30		11	1.0	1.8	2.6
39	171	Union City	San Francisco Bay	3	Mar-04	94.64	16.51	189	1.1	21.8	7.3	14.3	93	46	69	8.6	1.4	15.4	Dec	12	34	105	150	31		12	1.3	4.1	5.9
40	171	Union City	San Francisco Bay	4	Apr-04	125.16	4.32	242	1.1	21.4	8.9	14.7	87	43	64	7.6	1.7	18.1			126	359	690	365			5	14	27
41	171	Union City	San Francisco Bay	5	May-04	140.9	100.58	278	1.3	20.9	10.8	15.5	91	53	72	10.4	2	19.5			0.125546	0.358740	meters
42	171	Union City	San Francisco Bay	6	Jun-04	153.09	0	303	1.4	21.7	12.1	16.8	91	57	73	11.9	2.1	21.3				100	Sq. meters	1000 sf ft
43	171	Union City	San Francisco Bay	7	Jul-04	159.91	0	306	1.8	24.5	15.1	19.7	97	58	77	14.6	2.1	23.3				12.5546	cubic meters
44	171	Union City	San Francisco Bay	8	Aug-04	143.37	0	267	1.6	24.5	14.4	18.7	91	56	74	13.9	1.9	22.4
45	171	Union City	San Francisco Bay	9	Sep-04	124.53	0	234	1.4	26.1	11.2	18.3	92	40	65	11.3	1.5	19.8							500	Gallons	1.875	Cubic meters
46	171	Union City	San Francisco Bay	10	Oct-04	70.94	88.13	144	1.2	20.9	8.8	14.6	93	51	74	9.7	1.3	16.7							1000	Gallons	3.75	Cubic meters
47	171	Union City	San Francisco Bay	11	Nov-04	44.99	25.15	108	1	16.9	5.4	11.2	92	52	72	5.8	1.1	12.6
48	171	Union City	San Francisco Bay	12	Dec-04	34.87	120.67	84	0.9	15.3	4.2	9.2	95	56	78	5.3	1.2	9.6
49	171	Union City	San Francisco Bay	1	Jan-05	33.15	80.01	91	0.9	13.8	3.4	8.2	96	64	84	5.7	1.1	9.1
50	171	Union City	San Francisco Bay	2	Feb-05	40.76	94.48	106	1.1	16.8	6.9	11.6	94	57	77	7.5	1.1	11.7
51	171	Union City	San Francisco Bay	3	Mar-05	80.24	109.73	169	1.1	18.9	7.6	13	92	49	72	8	1.5	14.1
52	171	Union City	San Francisco Bay	4	Apr-05	110.83	46.22	242	1	18.4	7.1	12.8	91	51	70	7.5	1.8	14.9
53	171	Union City	San Francisco Bay	5	May-05	131.3	40.64	263	1.3	20.5	11.4	15.7	90	58	74	11	1.9	18.9
54	171	Union City	San Francisco Bay	6	Jun-05	150.96	0	313	1.3	21.3	11.9	16.4	89	55	71	11.2	2.1	20.9
55	171	Union City	San Francisco Bay	7	Jul-05	169.24	0	320	1.5	25.1	13.4	18.5	90	52	72	13.3	1.5	22.7
56	171	Union City	San Francisco Bay	8	Aug-05	149.5	0	286	1.5	24.7	12.3	17.6	92	50	72	12.5	1.7	21.4
57	171	Union City	San Francisco Bay	9	Sep-05	111.55	0.27	238	1.3	22.3	10.9	16	92	52	74	11.2	2	19
58	171	Union City	San Francisco Bay	10	Oct-05	83.61	10.41	176	1.2	21.5	8.8	14.8	93	51	73	10	1.3	16.6
59	171	Union City	San Francisco Bay	11	Nov-05	47.86	44.2	106	1.1	19.2	6.3	12.2	94	50	74	7.6	1.1	13.3
60	171	Union City	San Francisco Bay	12	Dec-05	28.74	124.47	68	1.1	15.8	5.8	10.9	94	60	79	7.4	1.3	11.3
61	171	Union City	San Francisco Bay	1	Jan-06	37.75	79.51	97	1	15.3	4.6	9.9	95	57	78	6.2	1.2	10.7
62	171	Union City	San Francisco Bay	2	Feb-06	55.19	5.84	145	0.9	17.2	4.2	10.3	93	47	72	5.4	1.3	11.1
63	171	Union City	San Francisco Bay	3	Mar-06	70.46	90.18	162	0.9	14.7	5.6	10	92	52	73	5.2	1.8	11.6
64	171	Union City	San Francisco Bay	4	Apr-06	87.66	72.64	198	1.1	17.6	8.4	12.9	90	57	74	8.3	1.6	14.8
65	171	Union City	San Francisco Bay	5	May-06	144.07	6.1	280	1.2	21.5	10.3	15.5	90	50	69	9.8	1.9	18.4
66	171	Union City	San Francisco Bay	6	Jun-06	146.47	0	289	1.3	23.7	12.7	15.4	90	53	72	12	1.9	20.9
67	171	Union City	San Francisco Bay	7	Jul-06	167.55	0	293	1.5	27	14.4	19.9	87	46	66	13.1	1.8	22.3
68	171	Union City	San Francisco Bay	8	Aug-06	135.85	0	256	1.4	23.5	12.4	17.2	90	53	72	12.2	1.8	21.1
69	171	Union City	San Francisco Bay	9	Sep-06	105.11	0	208	1.3	23.4	11	16.4	91	48	71	11	1.5	19.2
70	171	Union City	San Francisco Bay	10	Oct-06	71.88	16.51	146	1.1	21.5	8	14.4	91	45	68	8.2	1.2	16.2
71	171	Union City	San Francisco Bay	11	Nov-06	36.29	57.65	90	1.1	17.6	6.3	11.9	94	56	78	8.2	1	13.8
72	171	Union City	San Francisco Bay	12	Dec-06	33.06	58.42	75	0.8	15.3	2.9	8.5	93	49	73	3.8	1.1	9.4
73	171	Union City	San Francisco Bay	1	Jan-07	42.43	18.54	102	0.7	14.2	1	7.1	91	43	68	1.2	1.1	7.5
74	171	Union City	San Francisco Bay	2	Feb-07	38.87	116.32	102	1	15.2	6.1	10.5	92	57	77	6.5	1.4	11.4
75	171	Union City	San Francisco Bay	3	Mar-07	91.65	50.8	190	1	19.2	6	12.5	92	50	71	7.3	1.5	13.7
76	171	Union City	San Francisco Bay	4	Apr-07	105.34	77.47	221	1	18.5	7.6	12.7	90	51	70	7.4	1.8	15.4
77	171	Union City	San Francisco Bay	5	May-07	131.96	92.21	259	1.1	20.2	9.5	14.6	88	51	68	8.5	2	18.5
78	171	Union City	San Francisco Bay	6	Jun-07	144.96	0	283	1.3	22.1	10.7	16.1	89	52	70	10.5	2	20.5
79	171	Union City	San Francisco Bay	7	Jul-07	144.92	0	268	1.5	23.5	13.7	17.9	88	56	73	12.9	2	22.2
80	171	Union City	San Francisco Bay	8	Aug-07	143.19	0	271	1.5	24.2	13.3	18.3	88	50	69	12.4	1.8	21.7
81	171	Union City	San Francisco Bay	9	Sep-07	102.32	24.39	191	1.4	23.2	12.2	16.9	90	48	70	11.6	1.6	20.1
82	171	Union City	San Francisco Bay	10	Oct-07	72.53	71.89	148	1.2	20.7	8.6	14.2	92	49	72	9.1	1.3	16.4
83	171	Union City	San Francisco Bay	11	Nov-07	43.63	33.02	105	1	18.9	5.7	11.6	93	47	72	6.7	1	13.5
84	171	Union City	San Francisco Bay	12	Dec-07	34.97	64.52	80	0.8	13.7	3.1	8.5	90	50	71	3.3	1.1	9.7
85	171	Union City	San Francisco Bay	1	Jan-08	27.64	158.5	67	0.8	12.8	3.9	8.1	93	59	78	4.3	1.3	8.9
86	171	Union City	San Francisco Bay	2	Feb-08	50.55	56.89	123	0.9	15.8	4.3	9.7	92	51	74	5.1	1.4	10.5
87	171	Union City	San Francisco Bay	3	Mar-08	90.21	22.61	189	0.9	17.2	5.2	10.9	89	46	68	5.2	1.6	13.1
88	171	Union City	San Francisco Bay	4	Apr-08	118.52	22.35	242	0.9	18.5	6.2	12.1	86	44	64	5.4	1.9	15.2
89	171	Union City	San Francisco Bay	5	May-08	124.08	0	268	1.1	20.6	9.6	14.7	86	49	66	8.2	1.9	18.4
90	171	Union City	San Francisco Bay	6	Jun-08	160.65	0	315	1.2	23.7	10.7	16.7	86	45	64	9.4	1.8	21
91	171	Union City	San Francisco Bay	7	Jul-08	155.63	0	283	1.4	23.8	13.1	17.6	89	53	71	12.1	2	22.5
92	171	Union City	San Francisco Bay	8	Aug-08	141.13	0	256	1.4	24.7	13.1	18	89	50	70	12.4	1.8	22.3
93	171	Union City	San Francisco Bay	9	Sep-08	113.28	0	210	1.3	25.5	11.5	17.6	89	42	66	10.9	1.5	20.7
94	171	Union City	San Francisco Bay	10	Oct-08	81.33	9.14	152	1.1	23.5	8.5	15.3	89	39	64	8.3	1.1	17.1
95	171	Union City	San Francisco Bay	11	Nov-08	38.48	45.97	93	1.2	18.9	8	12.9	93	57	78	9	0.9	14.5
96	171	Union City	San Francisco Bay	12	Dec-08	30.09	69.6	78	0.8	13.4	2.6	7.8	93	57	79	4.3	0.9	9.5
97	171	Union City	San Francisco Bay	1	Jan-09	39.42	39.62	94	0.8	16.5	2.8	8.8	91	47	71	3.6	0.8	9.2
98	171	Union City	San Francisco Bay	2	Feb-09	41.24	125.99	106	0.9	15.5	5.6	10.2	91	54	74	5.7	1.2	10.8
99	171	Union City	San Francisco Bay	3	Mar-09	83.88	43.94	177	1	16.7	6.6	11.3	89	49	70	6	1.5	13.9
100	171	Union City	San Francisco Bay	4	Apr-09	113.75	2.79	232	1	18.8	7.6	12.9	86	46	65	6.2	1.7	16.7