Planilha de Cálculo Hidráulico e Gotejamento

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Inic
	
			Area	2	ha		13.09								Distancia entre mangueiras de gotejo	1	m
			Cultura	tomate											Pressão de serviço	10	mca
			Etc maximo	5	mm/dia										Vazao por metro	5	L/h
	
			CUD	90	%
								Comprimento	100	m
						116.6 mm		Desnivel	20	m
								Minimo DiaInt.		mm
								Tubo								Vazão Bomba		Tempo de irrigação
								Perda Pressao	0.1038115696	mca						m3/h		por dia	por setor
					33.2			Velocidade	0.3251153318	m/s				Setores possiveis	21	4.76		23:20	1:06	23.33
														Projeto com 1 setor	1	100.00		1:06	1:06	1.11
								Hf Filtro
					40.2		Projeto	7	mca
							Real	7	mca					N . Setores escolhido	8	12.50		8:53	1:06	8.89
	
					96.0 mm			Comprimento	30	m
								Desnivel	2	m
								Minimo DiaInt.		mm
				Hman				Tubo
				42.27	mca			Perda Pressao	0.0791422049	mca
								Velocidade	0.4796142578	m/s
			Vazão
			12.50	m3/h		3.26 cv
								Comprimento	12	m
				105.3 mm				Desnivel	3	m
								Minimo DiaInt.		mm
								Tubo
								Perda Pressao	0.0810391717	mca			Perda de pressao extra:	0	mca
								Velocidade	0.3986371864	m/s
B
F
F
Pc
Suc
				para dimensionamento da sucçao
							vazao	12.50	m3/h		0.0034722222	m3/s
					3		viscosidade	0.000001007	a 20 C					5.038014
		referenciaa					comprimento	12	m
		4		PN
		TIPO MATERIAL	DN	mca	DI (mm)	di esc.	Rug. m	di m	Vel. m/s	vel esc	Rey	f	hf	hfL	hfL esc
	1					0
	2	AÇO GALVANIZADO 2"	75	100	53	0	0.00017	0.053	1.5735582058	0	82818.8529351146	0.0284122922	0.0677235874	1.7638608344	0
	3	AÇO GALVANIZADO 3"	100	100	80.8	0	0.00017	0.0808	0.6770361055	0	54324.2475935776	0.0267937535	0.0077551425	0.2591148225	0
	4	AÇO GALVANIZADO 4"	125	100	105.3	105.3	0.00017	0.1053	0.3986371864	0.3986371864	41684.7028068478	0.0263755755	0.0020308279	0.0810391717	0.0810391717
	5	AÇO GALVANIZADO 5"	150	100	130	0	0.00017	0.13	0.261545858	0	33764.6092735467	0.0263792284	0.000708204	0.0328960745	0
	6	AÇO GALVANIZADO 6"	175	100	155.4	0	0.00017	0.1554	0.1830343167	0	28245.8121335976	0.0266110924	0.0002926986	0.0155660049	0
	7	AÇO GALVANIZADO 8"	200	100	206.5	0	0.00017	0.2065	0.1036559985	0	21256.1704869786	0.0273924698	0.0000727183	0.0048519493	0
	8	AÇO GALVANIZADO 10"	250	100	254	0	0.00017	0.254	0.0685120745	0	17281.0992344924	0.0282587968	0.0000266439	0.0021131293	0
	9	AÇO GALVANIZADO 12"	300	100	300.3	0	0.00017	0.3003	0.0490144221	0	14616.7139712323	0.0291299418	0.0000118898	0.0010888655	0
	10	AÇO GALVANIZADO 14"	350	100	351.1	0	0.00017	0.3511	0.0358569126	0	12501.8490616949	0.0300737362	0.0000056188	0.0005902108	0
	11	AÇO GALVANIZADO 16"	400	100	401.9	0	0.00017	0.4019	0.0273651945	0	10921.6203173951	0.0309881127	0.0000029459	0.0003490996	0
	12	AÇO GALVANIZADO 20"	500	100	501.3	0	0.00017	0.5013	0.0175889187	0	8756.0327260345	0.0326749687	0.0000010288	0.000149019	0
	
	
	
					diametro interno escolhido:	105.3			vel escolhida:	0.3986371864				hfL escolhido:	0.0810391717
												2
	linha	4
	
	
		AÇO GALVANIZADO 4"
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		OBS: DN = diametro nomimal, PN = pressao nominal, DI = diametro interno.
	
		Paulo: penso que somente "A" coluna a deveria aparecer na janela de calculo de perda de carga, as outras colunas poderiam ficar ocultas nesta janela.
R1
				para dimensionamento recalque 1
							vazao	12.50	m3/h		0.0034722222	m3/s
							viscosidade	0.000001007	a 20 C
							comprimento	30.00	m
		15		PN	DI
		TIPO MATERIAL	DN	mca	mm		Rug. m	di m	Vel. m/s		Rey	f	hf	hfL
	1					0
	2	TUBO PVC AGROP. 32mm	1 pol	60	29	0	0.00001	0.029	5.2557966706	0	151358.5932952094	0.0186443806	0.9060892972	27.1826789157	0
	3	PVC PN 80 DN 32	32	80	28.4	0	0.00001	0.0284	5.4802184586	0	154556.3100549674	0.0186370575	1.0055384368	30.1661531046	0
	4	PVC PN 40 DN35	35	40	35.7	0	0.00001	0.0357	3.4681519667	0	122952.3586991897	0.0188090954	0.3233254265	9.6997627946	0
	5	TUBO PVC AGROP. 40mm	1 1/2 pol	60	36.2	0	0.00001	0.0362	3.3730083026	0	121254.1217005821	0.0188259554	0.3018750394	9.0562511809	0
	6	PVC PN 40 DN 50	50	40	48.1	0	0.00001	0.0481	1.910488371	0	91255.7007393155	0.0193219298	0.0748062954	2.2441888634	0
	7	PVC PN 60 DN 50	50	60	47.3	0	0.00001	0.0473	1.9756602854	0	92799.1375382891	0.0192849435	0.0811943291	2.4358298727	0
	8	PVC PN 80 DN 50	50	80	46.7	0	0.00001	0.0467	2.0267528394	0	93991.4176779673	0.0192574165	0.0864224653	2.5926739598	0
	9	PVC PN 125 DN 50	50	125	44.9	0	0.00001	0.0449	2.1925114459	0	97759.4477853246	0.0191760922	0.104746962	3.1424088593	0
	10	PVC PN 40 DN 75	75	40	72.5	0	0.00001	0.0725	0.8409274673	0	60543.4373180838	0.0204992826	0.0102014443	0.3060433283	0
	11	PVC PN 60 DN 75	75	60	71.5	0	0.00001	0.0715	0.8646144066	0	61390.1986791758	0.0204513643	0.0109095065	0.3272851955	0
	12	PVC PN 80 DN 75	75	80	70.5	0	0.00001	0.0705	0.8893164328	0	62260.9816391642	0.0204033181	0.011677994	0.3503398196	0
	13	PVC PN 125 DN 75	75	125	69.5	0	0.00001	0.0695	0.9150923865	0	63156.8231015982	0.0203551515	0.0125130548	0.3753916444	0
	14	PVC PN 40 DN 100	100	40	97.6	0	0.00001	0.0976	0.4640180941	0	44973.3525159946	0.0216488974	0.0024366869	0.0731006064	0
	15	PVC PN 60 DN 100	100	60	96	96	0.00001	0.096	0.4796142578	0.4796142578	45722.9083912612	0.0215789359	0.0026380735	0.0791422049	0.0791422049
	16	PVC PN 80 DN 100	100	80	94.4	0	0.00001	0.0944	0.4960101488	0	46497.8729402656	0.0215085125	0.0028599829	0.0857994867	0
	17	PVC PN 125 DN 100	100	125	93	0	0.00001	0.093	0.5110561915	0	47197.8409200116	0.0214465122	0.0030729462	0.0921883872	0
	18	PVC PN 40 DN 125	125	40	120	0	0.00001	0.12	0.306953125	0	36578.3267130089	0.0225814067	0.0009046025	0.0271380756	0
	19	PVC PN 60 DN 125	125	60	118.3	0	0.00001	0.1183	0.3158384953	0	37103.9662346667	0.0225135877	0.0009685767	0.0290573009	0
	20	PVC PN 80 DN 125	125	80	116.6	0	0.00001	0.1166	0.3251153318	0	37644.9331523248	0.0224453033	0.0010381157	0.0311434709	0
	21	PVC PN 125 DN 125	125	125	114.4	0	0.00001	0.1144	0.3377400026	0	38368.8741744849	0.0223562355	0.0011373171	0.0341195142	0
	22	PVC PN 40 DN 150	150	40	144	0	0.00001	0.144	0.2131618924	0	30481.9389275074	0.0234924516	0.0003782064	0.011346193	0
	23	PVC PN 60 DN 150	150	60	142	0	0.00001	0.142	0.2192087383	0	30911.2620109935	0.0234196425	0.0004043445	0.0121303359	0
	24	PVC PN 80 DN 150	150	80	140	0	0.00001	0.14	0.2255165816	0	31352.8514682934	0.0233462976	0.000432704	0.0129811188	0
	25	PVC PN 125 DN 150	150	125	138.4	0	0.00001	0.1384	0.2307609781	0	31715.3121789095	0.0232872299	0.0004571412	0.0137142375	0
	26	PVC PN 40 DN 200	200	40	194	0	0.00001	0.194	0.1174440695	0	22625.7691008303	0.0251611499	0.0000912714	0.002738143	0
	27	PVC PN 60 DN 200	200	60	191.2	0	0.00001	0.1912	0.1209090407	0	22957.108815696	0.0250744763	0.000097815	0.00293445	0
	28	PVC PN 80 DN 200	200	80	189.2	0	0.00001	0.1892	0.1234787678	0	23199.7843845723	0.0250121295	0.000102839	0.0030851714	0
	29	PVC PN 125 DN 200	200	125	186	0	0.00001	0.186	0.1277640479	0	23598.9204600058	0.0249116019	0.000111545	0.0033463489	0
	30	PVC PN 80 DN 5"	5 pol.	80	118.6	0	0.00001	0.1186	0.3142426823	0	37010.1113453716	0.0225255894	0.0009568982	0.0287069468	0
	31	PVC PN 125 DN 5"		125	116.4	0	0.00001	0.1164	0.3262335264	0	37709.6151680505	0.022437239	0.0010466887	0.0314006616	0
	32	PVC PN 80 DN 6"	6 pol.	80	142	0	0.00001	0.142	0.2192087383	0	30911.2620109935	0.0234196425	0.0004043445	0.0121303359	0
	33	PVC PN 125 DN 6"		125	140.4	0	0.00001	0.1404	0.2242334173	0	31263.5271051358	0.0233610098	0.0004268439	0.0128053177	0
	34	AÇO GALVANIZADO 3"	75	100	73.78	0	0.00017	0.07378	0.8120022815	0	59493.0767899305	0.0270452199	0.0123313406	0.3699402181	0
	35	AÇO GALVANIZADO 4"	100	100	99.18	0	0.00017	0.09918	0.4493516527	0	44256.8986243302	0.0264288692	0.0027451817	0.0823554506	0
	36	AÇO GALVANIZADO 5"	125	100	124.58	0	0.00017	0.12458	0.2847986315	0	35233.5784681415	0.0263546344	0.000875444	0.0262633214	0
	37	AÇO GALVANIZADO 6"	150	100	149.98	0	0.00017	0.14998	0.1965023971	0	29266.5635788843	0.0265486149	0.0003487291	0.0104618721	0
	38
AÇO GALVANIZADO 7"	175	100	174.76	0	0.00017	0.17476	0.1447273064	0	25116.7269716244	0.0268741479	0.0001643378	0.004930135	0
	39	AÇO GALVANIZADO 8"	200	100	200.16	0	0.00017	0.20016	0.1103265319	0	21929.4524658327	0.0272830849	0.0000846487	0.0025394595	0
	40	AÇO GALVANIZADO 10"	250	100	250.2	0	0.00017	0.2502	0.0706089804	0	17543.5619726662	0.0281877044	0.0000286574	0.0008597209	0
	41	AÇO GALVANIZADO 12"	300	100	300.3	0	0.00017	0.3003	0.0490144221	0	14616.7139712323	0.0291299418	0.0000118898	0.0003566952	0
	42	AÇO GALVANIZADO 14"	350	100	351.1	0	0.00017	0.3511	0.0358569126	0	12501.8490616949	0.0300737362	0.0000056188	0.000168565	0
	43	AÇO GALVANIZADO 16"	400	100	401.9	0	0.00017	0.4019	0.0273651945	0	10921.6203173951	0.0309881127	0.0000029459	0.000088377	0
		AÇO GALVANIZADO 20"	500	100	501.3	0	0.00017	0.5013	0.0175889187	0	8756.0327260345	0.0326749687	0.0000010288	0.0000308646	0
	
					diametro escolhido:	96			Vel esc:	0.4796142578				hfL esc:	0.0791422049
	
		15	posiçao na linha
		PVC PN 60 DN 100
R2
				para dimensionamento recalque 2
							vazao	12.50	m3/h		0.0034722222	m3/s
							viscosidade	0.000001007	a 20 C
							comprimento	100.00	m
		20		PN	DI
		TIPO MATERIAL	DN	mca	mm		Rug. m	di m	Vel. m/s		Rey	f	hf	hfL
	1					0
	2	TUBO PVC AGROP. 32mm	1 pol	60	29	0	0.00001	0.029	5.2557966706	0	151358.5932952094	0.0186443806	0.9060892972	90.6089297189	0
	3	PVC PN 80 DN 32	32	80	28.4	0	0.00001	0.0284	5.4802184586	0	154556.3100549674	0.0186370575	1.0055384368	100.5538436819	0
	4	PVC PN 40 DN35	35	40	35.7	0	0.00001	0.0357	3.4681519667	0	122952.3586991897	0.0188090954	0.3233254265	32.3325426486	0
	5	TUBO PVC AGROP. 40mm	1 1/2 pol	60	36.2	0	0.00001	0.0362	3.3730083026	0	121254.1217005821	0.0188259554	0.3018750394	30.1875039362	0
	6	PVC PN 40 DN 50	50	40	48.1	0	0.00001	0.0481	1.910488371	0	91255.7007393155	0.0193219298	0.0748062954	7.4806295446	0
	7	PVC PN 60 DN 50	50	60	47.3	0	0.00001	0.0473	1.9756602854	0	92799.1375382891	0.0192849435	0.0811943291	8.119432909	0
	8	PVC PN 80 DN 50	50	80	46.7	0	0.00001	0.0467	2.0267528394	0	93991.4176779673	0.0192574165	0.0864224653	8.6422465325	0
	9	PVC PN 125 DN 50	50	125	44.9	0	0.00001	0.0449	2.1925114459	0	97759.4477853246	0.0191760922	0.104746962	10.4746961978	0
	10	PVC PN 40 DN 75	75	40	72.5	0	0.00001	0.0725	0.8409274673	0	60543.4373180838	0.0204992826	0.0102014443	1.0201444277	0
	11	PVC PN 60 DN 75	75	60	71.5	0	0.00001	0.0715	0.8646144066	0	61390.1986791758	0.0204513643	0.0109095065	1.0909506517	0
	12	PVC PN 80 DN 75	75	80	70.5	0	0.00001	0.0705	0.8893164328	0	62260.9816391642	0.0204033181	0.011677994	1.1677993988	0
	13	PVC PN 125 DN 75	75	125	69.5	0	0.00001	0.0695	0.9150923865	0	63156.8231015982	0.0203551515	0.0125130548	1.2513054813	0
	14	PVC PN 40 DN 100	100	40	97.6	0	0.00001	0.0976	0.4640180941	0	44973.3525159946	0.0216488974	0.0024366869	0.2436686879	0
	15	PVC PN 60 DN 100	100	60	96	0	0.00001	0.096	0.4796142578	0	45722.9083912612	0.0215789359	0.0026380735	0.2638073498	0
	16	PVC PN 80 DN 100	100	80	94.4	0	0.00001	0.0944	0.4960101488	0	46497.8729402656	0.0215085125	0.0028599829	0.285998289	0
	17	PVC PN 125 DN 100	100	125	93	0	0.00001	0.093	0.5110561915	0	47197.8409200116	0.0214465122	0.0030729462	0.3072946241	0
	18	PVC PN 40 DN 125	125	40	120	0	0.00001	0.12	0.306953125	0	36578.3267130089	0.0225814067	0.0009046025	0.090460252	0
	19	PVC PN 60 DN 125	125	60	118.3	0	0.00001	0.1183	0.3158384953	0	37103.9662346667	0.0225135877	0.0009685767	0.0968576696	0
	20	PVC PN 80 DN 125	125	80	116.6	116.6	0.00001	0.1166	0.3251153318	0.3251153318	37644.9331523248	0.0224453033	0.0010381157	0.1038115696	0.1038115696
	21	PVC PN 125 DN 125	125	125	114.4	0	0.00001	0.1144	0.3377400026	0	38368.8741744849	0.0223562355	0.0011373171	0.1137317141	0
	22	PVC PN 40 DN 150	150	40	144	0	0.00001	0.144	0.2131618924	0	30481.9389275074	0.0234924516	0.0003782064	0.0378206432	0
	23	PVC PN 60 DN 150	150	60	142	0	0.00001	0.142	0.2192087383	0	30911.2620109935	0.0234196425	0.0004043445	0.0404344529	0
	24	PVC PN 80 DN 150	150	80	140	0	0.00001	0.14	0.2255165816	0	31352.8514682934	0.0233462976	0.000432704	0.043270396	0
	25	PVC PN 125 DN 150	150	125	138.4	0	0.00001	0.1384	0.2307609781	0	31715.3121789095	0.0232872299	0.0004571412	0.045714125	0
	26	PVC PN 40 DN 200	200	40	194	0	0.00001	0.194	0.1174440695	0	22625.7691008303	0.0251611499	0.0000912714	0.0091271433	0
	27	PVC PN 60 DN 200	200	60	191.2	0	0.00001	0.1912	0.1209090407	0	22957.108815696	0.0250744763	0.000097815	0.0097815001	0
	28	PVC PN 80 DN 200	200	80	189.2	0	0.00001	0.1892	0.1234787678	0	23199.7843845723	0.0250121295	0.000102839	0.0102839046	0
	29	PVC PN 125 DN 200	200	125	186	0	0.00001	0.186	0.1277640479	0	23598.9204600058	0.0249116019	0.000111545	0.0111544964	0
	30	PVC PN 80 DN 5"	5 pol.	80	118.6	0	0.00001	0.1186	0.3142426823	0	37010.1113453716	0.0225255894	0.0009568982	0.0956898225	0
	31	PVC PN 125 DN 5"		125	116.4	0	0.00001	0.1164	0.3262335264	0	37709.6151680505	0.022437239	0.0010466887	0.104668872	0
	32	PVC PN 80 DN 6"	6 pol.	80	142	0	0.00001	0.142	0.2192087383	0	30911.2620109935	0.0234196425	0.0004043445	0.0404344529	0
	33	PVC PN 125 DN 6"		125	140.4	0	0.00001	0.1404	0.2242334173	0	31263.5271051358	0.0233610098	0.0004268439	0.0426843925	0
	34	AÇO GALVANIZADO 3"	75	100	73.78	0	0.00017	0.07378	0.8120022815	0	59493.0767899305	0.0270452199	0.0123313406	1.2331340603	0
	35	AÇO GALVANIZADO 4"	100	100	99.18	0	0.00017	0.09918	0.4493516527	0	44256.8986243302	0.0264288692	0.0027451817	0.2745181686	0
	36	AÇO GALVANIZADO 5"	125	100	124.58	0	0.00017	0.12458	0.2847986315	0	35233.5784681415	0.0263546344	0.000875444	0.0875444047	0
	37	AÇO GALVANIZADO 6"	150	100	149.98	0	0.00017	0.14998	0.1965023971	0	29266.5635788843	0.0265486149	0.0003487291	0.0348729071	0
	38	AÇO GALVANIZADO 7"	175	100	174.76	0	0.00017	0.17476	0.1447273064	0	25116.7269716244	0.0268741479	0.0001643378	0.0164337832	0
	39	AÇO GALVANIZADO 8"	200	100	200.16	0	0.00017	0.20016	0.1103265319	0	21929.4524658327	0.0272830849	0.0000846487	0.0084648651	0
	40	AÇO GALVANIZADO 10"	250	100	250.2	0	0.00017	0.2502	0.0706089804	0	17543.5619726662	0.0281877044	0.0000286574	0.0028657362	0
	41	AÇO GALVANIZADO 12"	300	100	300.3	0	0.00017	0.3003	0.0490144221	0	14616.7139712323	0.0291299418	0.0000118898	0.0011889839	0
	42	AÇO GALVANIZADO 14"	350	100	351.1	0	0.00017	0.3511	0.0358569126	0	12501.8490616949	0.0300737362	0.0000056188	0.0005618835	0
	43	AÇO GALVANIZADO 16"	400	100	401.9	0	0.00017	0.4019	0.0273651945	0	10921.6203173951	0.0309881127	0.0000029459	0.0002945901	0
		AÇO GALVANIZADO 20"	500	100	501.3	0	0.00017	0.5013	0.0175889187	0	8756.0327260345	0.0326749687	0.0000010288	0.0001028821	0
	
					diametro escolhido:	116.6			Vel esc:	0.3251153318				hfL esc:	0.1038115696
	
		20	posiçao na linha
		PVC PN 80 DN 125
CU1
					ultima
						50			100			90			50
	
	
	
	
	
	
				.2/3
					100			50			89			50
	
	
																		50
																		100
																		90
																		50
																		100
			.1/3															50
				80			50			99			50					89
																		50
																		80
																		50
																		99
																		50
																		105
																		95
		primeira																95
			105			95			95			100						100
	
			1º			.1/3			.2/3			ultimo
	
											COEFICIENCIA DE UNIFORMIDADE DE EMISSÃO:	88.24	%
Valv
CU2
	
				50		80
				100		89
				90		90
				50		90		media 25% menor		87.25
				100		95
				50		95
				89		99
				50		100
				80		100
				50		100
				99		100
				50		100
				105		100
				95		105
				95		110
				100		129
			total
			media
					media geral	98.875
	
					CUE	88.24	%