irrigation-bucket-test-calculator-5nov23 Dairy farm and Roundhill Pivots.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP
1		Irrigation Depth Testing Calculator: Centre Pivot
2
3		Instructions To use this calculator for measuring the depth of irrigation applied from a centre pivot, you first need to take some measurements out by the irrigator. You will need some buckets or containers (all the same size) and a measuring jug. All the instructions are outlined in DairyNZ's "Irrigation DIY Evaluation". Once you have the data follow the steps stated and enter data into the green boxes as labelled below. This input data will generate the depth and uniformity of the irrigation applied. Flow rate and timing measurements are required to assess application rate.
4
5
6
7		Step 1:		What is your target irrigation depth for water applied to land?																					5		mm
8
9		Step 2:		Choose the shape of your buckets?												Circular				Square or Rectangular	Step 3:			What size is inside the top of your buckets?										Diameter		255	mm
10																				Circular
11		Step 4:		How long did it take for the irrigator to pass across the buckets?												10	Min	30	Sec		Step 5:			What was the total length of pivot to the last tower (from centre)?														310		Metres
12
13		Step 6:		What unit was the flow rate of the irrigator measured with?												L/second				m³/hour	Step 7:			What was the average flow rate of water to the irrigator?														14		L/second
14																				L/second
15	Step 7:	Step 8:		What was the wetted width of the sprinklers on the pivot?												12		Metres
16																				L/second
17		Step 9:			How much liquid is in each bucket? Start from centre of the pivot and work outwards
18
19
20
21
22
23
24
25
26
27
28
29
30
31		Buckets starting from the centre of the pivot and working outwards
32		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40
33		245	240	245	245	245	250	235	240	240	240	240	240	240	245	245	230	235	240	240	260	260	250	250	250	245	250	250	250	250	255	240	255	250	250	250	255	245	250	250	245
34		ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml	ml
35			Only fill in boxes for buckets used. Zero values will not be calculated.
36
37
38
39
40
41
42		Step 10:			Read the Average Applied Depth, Maximum Application Depth, and Distribution Uniformity.
43
44					Average Depth of Irrigation Applied													4.82		mm
45
46					Maximum Depth of Irrigation Applied													5.09		mm
47
48					Average Application Rate at 2/3 pivot length (Flow Rate Method: Steps 5,6,7)													18.06		mm/hour
49
50					Average Application Rate at full pivot length (Flow Rate Method: Steps 5,6,7)													27.10		mm/hour
51
52					Average Application Rate (Stop Watch Method: Step 4,8)													22.94		mm/hour
53
54					Distribution Uniformity (LQ)													0.97
55
56
57	Disclaimer: DairyNZ Limited endeavours to ensure that the information in this publication is accurate and current. However, we do not accept liability for any error or omission. The information that appears in this publication is intended to provide the best possible dairy farm management practices, systems and advice that DairyNZ has access to. It may be subject to change at any time, without notice. DairyNZ Limited takes no responsibility whatsoever for the currency and/or accuracy of this information, its completeness or fitness for purpose.
58
59
60
61
62	Version 3: February 2015																																								Page 1
63
64		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	32	33	34	35	36	37	38	39	40
65		5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5
66		4.797288558	4.69938471	4.797288558	4.797288558	4.797288558	4.895192406	4.601480861	4.69938471	4.69938471	4.69938471	4.69938471	4.69938471	4.69938471	4.797288558	4.797288558	4.503577013	4.601480861	4.69938471	4.69938471	5.091000102	5.091000102	4.895192406	4.895192406	4.895192406	4.797288558	4.895192406	4.895192406	4.895192406	4.895192406	4.993096254	4.69938471	4.993096254	4.895192406	4.895192406	4.895192406	4.993096254	4.797288558	4.895192406	4.895192406	4.797288558
67		4.797288558	4.69938471	4.797288558	4.797288558	4.797288558	4.895192406	4.601480861	4.69938471	4.69938471	4.69938471	4.69938471	4.69938471	4.69938471	4.797288558	4.797288558	4.503577013	4.601480861	4.69938471	4.69938471	5.091000102	5.091000102	4.895192406	4.895192406	4.895192406	4.797288558	4.895192406	4.895192406	4.895192406	4.895192406	4.993096254	4.69938471	4.993096254	4.895192406	4.895192406	4.895192406	4.993096254	4.797288558	4.895192406	4.895192406	4.797288558
68		4.797298558	4.69940471	4.797318558	4.797328558	4.797338558	4.895252406	4.601550861	4.69946471	4.69947471	4.69948471	4.69949471	4.69950471	4.69951471	4.797428558	4.797438558	4.503737013	4.601650861	4.69956471	4.69957471	5.091200102	5.091210102	4.895412406	4.895422406	4.895432406	4.797538558	4.895452406	4.895462406	4.895472406	4.895482406	4.993396254	4.69969471	4.993416254	4.895522406	4.895532406	4.895542406	4.993456254	4.797658558	4.895572406	4.895582406	4.797688558
69			4.69938471					4.601480861	4.69938471	4.69938471	4.69938471	4.69938471	4.69938471	4.69938471			4.503577013	4.601480861
70		LQ	Ave Depth	LQ Ave Depth
71		4.69955221	4.816869327	4.66022317
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