Soil Testing Results 2021-23.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Summary of All Sites
2	Site
3	All
4	Soil Analysis	Units	Normal Range	Summary Average (all sites)	Test Rating Average (all sites)
5	1:1 Soil pH	NA	6.5-7.2	8.091	Strongly Alkaline
6	1.1 Soluble Salts (EC)	mmho/cm	0.8-1.2	0.504	Low
7	Excess Lime	est. based on CO2 released (characterizing lime qualitatively)	NORMAL	HIGH (Calcium Carbonate, Calcareaus Soil)			no calcium carbonate- calcarius soil
8	Organic Matter LOI	%	1.6-3	3.175	High
9	kCl Nitrate-N	ppm	11-25	10.967	Medium
10	M-3 Phosphate (P)	ppm	11-15	18.533	High
11	N-H4-AC Potassium	ppm	161-220	390.5	Very High
12	DTPA Zinc (Zn)	ppm	0.9-1.2	8.45	Very High
13	DTPA Iron (Fe)	ppm	5.1-15	11.308	Optimum		KEY
14	DTPA Manganese (Mn)	ppm	3.1-6	5.9	Optimum		Higher value than normal
15	DTPA Copper (Cu)	ppm	0.5-0.8	1.258	High		Normal value
16	Hot Water Extraction Boron (B)		0.9-1.5	1.067	Optimum		Lower value than normal
17	% Sand, % Silt, % Clay,Texture Feel, Texture by Hydrometer	# of sites with categorization	Clay: 6 Sandy:9 Loam: 11
18
19
20			Aggregate Site Location
21															Averaging Function	Median Function
22	Soil Analysis	Units	Enrique's Yard	Singing Arrow-L	Singing Arrow-V	Wilson	Le Jardin Verde	Loma Linda 1	Loma Linda 2	Loma Linda 3	Loma Linda 4	ECM 1	ECM 2	ECM 3	[=Average(C:N)]	[=Median(C:N)]	Low Normal Range	High Normal Range	Soil Analysis	Units
23	1:1 Soil pH		8.2	8.2	8.2	7.4	7.7	8.3	8.3	8.4	8.4	7.8	8	8.2	8.091666667	8.2	6.5	7.2	1:1 Soil pH
24	1.1 Soluble Salts (EC)	mmho/cm	0.05	0.3	0.3	1.5	2	0.2	0.5	0.4	0.3	0.1	0.2	0.2	0.5041666667	0.3	0.8	1.2	1.1 Soluble Salts (EC)	mmho/cm
25	Excess Lime	est. based on CO2 released	VERY HIGH	VERY HIGH	VERY HIGH	HIGH	VERY HIGH	HIGH	HIGH	HIGH	HIGH	NONE	LOW	HIGH			NORMAL	NORMAL	Excess Lime
26	Organic Matter LOI	%	2.9	1.9	1.9	5.2	6.2	1.2	0.6	1	0.9	7.1	6.6	2.6	3.175	2.25	1.6	3	Organic Matter LOI	%
27	kCl Nitrate-N	ppm	13	3.3	3.3	1	97	2	3	3	2	2	2	0	10.96666667	2.5	11	25	kCl Nitrate-N	ppm
28	M-3 Phosphate (P)	ppm	3	53.7	53.7	3	5	31	6	13	8	12	17	17	18.53333333	12.5	11	15	M-3 Phosphate (P)	ppm
29	N-H4-AC Potassium	ppm	413	165	165	896	783	271	196	362	162	245	436	592	390.5	316.5	161	220	N-H4-AC Potassium	ppm
30	DTPA Zinc (Zn)	ppm	6.1	20.7	20.7	4.3	6	1.9	0.7	1	1	15.3	16.5	7.2	8.45	6.05	0.9	1.2	DTPA Zinc (Zn)	ppm
31	DTPA Iron (Fe)	ppm	2.2	39.9	39.9	5	3.7	4.9	3.2	3.3	3.4	15.7	8	6.5	11.30833333	4.95	5.1	15	DTPA Iron (Fe)	ppm
32	DTPA Manganese (Mn)	ppm	2	14.2	14.2	10.8	3.3	2.4	1.2	1.1	2.9	7.7	4.8	6.2	5.9	4.05	3.1	6	DTPA Manganese (Mn)	ppm
33	DTPA Copper (Cu)	ppm	0.6	3.9	3.9	0.6	0.5	0.6	0.3	0.5	0.3	1.5	1.3	1.1	1.258333333	0.6	0.5	0.8	DTPA Copper (Cu)	ppm
34	Hot Water Extraction Boron (B)		0.7	0.5	0.5	0.8	0.7	0.9	1.6	1.1	1	1.6	1.6	1.8	1.066666667	0.95	0.9	1.5	Hot Water Extraction Boron (B)
35	% Sand, % Silt, % Clay,Texture Feel, Texture by Hydrometer		Clay Loam	Clay	Clay Loam	Sandy Clay Loam	Sandy Clay Loam	Sandy Loam	Sandy Loam	Sandy Loam	Sandy Loam	Sandy Loam	Sandy Loam	Sandy Clay Loam
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100