PLANILHA DE CÁLCULO DE GALERIAS DE ÁGUAS PLUVIAIS

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

Plan1
	Planilha de Cálculo de Galeria de Águas Pluviais - Loteamento
	Projeto:	Cálculo:
Verificado:	Folha:
	Trecho	Rua	Área	Comp.
Rua
(m)	Tempo
 Conc.
(min)	Intensi.
Chuva
(mm/min)	Decliv.
Ruas
(m/m)	Vazão
Chuva
abl(l/s)	Vazão
Chuva
(l/s)	Capac.
Guias
(l/s)	Veloc.
Guias
(m/s)	YO
(m)	Soluc.
Adotada	Ext. Galeria
(m)	Cota do Terreno	Prof. do PV	Cota do PV	Decliv.
Galeria
(m/m)	Diam.
Galeria
(mm)	calc	Vazão	Veloc.
Galeria
(m/s)
	Contrib.
(ha)	Acum.
(há)	Montante
(m)	Jusante
(m)	Montante
(m)	Jusante
(m)	Montante
(m)	Jusante
(m)	Projeto
(l/s)	Galeria
(l/s)
	1	R1 - A1	0.39	0.39	120	15.08	2.57	0.004167	100.19	100.19	583.39	0.39	0.12	Sarjeta	100	99.5
	2	R8 - A2	0.39	0.78	130	2.16	3.56	0.026923	238.84	118.84	1482.96	1.00	0.08	Galeria	99.5	96
	3	R8 - A5	0.39	0.39	130	12.16	2.74	0.026923	107.04	47.04	1482.96	1.00	0.05	Galeria	99.5	96
	4	R1 - A6	0.39	0.39	120	15.08	2.57	0.004167	100.19	100.19	583.39	0.39	0.12	Sarjeta	99.5	99
	5	R7 - A7	0.39	0.78	130	2.56	3.51	0.019231	237.27	237.27	1253.33	0.85	0.13	Galeria	99	96.5
	6	R7 - A9	0.39	0.39	130	12.56	2.72	0.019231	106.06	106.06	1253.33	0.85	0.08	Galeria	99	96.5
	7	R1 - A10	0.39	0.39	120	16.56	2.49	0.0025	97.02	97.02	451.90	0.30	0.13	Sarjeta	99	98.7
	8	R5 - A11	0.39	0.78	130	15.73	2.53	0.0038461538	195.79	75.79	560.51	0.38	0.11	Galeria	98.7	98.2
	9	R5 - A20	0.36	0.36	120	12.15	2.75	0.0233333333	98.85	98.85	1380.56	0.93	0.08	Galeria	101	98.2
	10	R2 - A18	1.05	1.41	230	16.43	2.49	0.0095652174	360.78	21.94	883.93	0.60	0.05	Galeria	98.2	96
	11	R2 - A12	0.39	0.78	120	12.75	2.71	0.0141666667	301.37	181.37	1075.73	0.73	0.12	Galeria	98.2	96.5	96.7	94.5	1.5	2	0.0183333333	500	0.6181482664	240	388.26	1.98
	12	R2 - A8	0.39	1.95	120	19.31	2.35	0.0025	328.84	30.21	451.90	0.30	0.08	Galeria	96.3	96	94.5	93.9	2	2.1	0.005	1000	0.6509480446	840	1290.43	1.64
	13	R2 - A3	0.39	0.39	120	13.59	2.66	0.0083333333	103.58	0.00	825.04	0.56	0.00	Galeria	97	96
	14	R2 - A13	0.36	0.36	120	13.59	2.66	0.0083333333	95.61	0.00	825.04	0.56	0.00	Galeria	97	96
	15	R8 - A14	0.36	0.75	120	5.76	3.22	0.0083333333	354.72	114.72	825.04	0.56	0.11	Galeria	96	95	93.9	92.9	2.1	2.1	0.0083333333	1100	0.6980964919	1500	2148.70	2.26
	16	R8 - A17	0.36	0.75	120	15.76	2.53	0.0083333333	887.78	70.31	825.04	0.56	0.08	Galeria	96	95
	17	R9 - A4	0.39	0.39	130	12.34	2.73	0.0230769231	106.61	106.61	1372.96	0.93	0.08	Sarjeta	100	97
	18	R9 - A16	0.36	0.75	120	15.93	2.52	0.0083333333	197.38	77.38	825.04	0.56	0.09	Galeria	97	96
	19	R9 - A24	0.36	1.11	120	19.52	2.34	0.0083333333	281.54	41.54	825.04	0.56	0.07	Galeria	96	95	94.5	93.4	1.5	1.6	0.0091666667	500	0.4370968309	120	274.54	1.40
	20	R4 - A23	0.36	1.47	120	24.60	2.12	0.0041666667	357.72	0.00	583.39	0.39	0.00	Galeria	95	94.5	93.4	92	1.6	2.5	0.0116666667	600	0.7143602988	360	503.95	1.78
	21	R3 - A19	1.05	1.05	230	13.89	2.64	0.0260869565	276.99	36.99	1459.75	0.99	0.05	Galeria	101	95
	22	R3 - A29	0.36	0.36	120	11.80	2.77	0.0333333333	99.66	99.66	1650.09	1.11	0.07	Galeria	101	97
	23	R3 - A25	0.36	0.36	120	12.54	2.72	0.0166666667	97.95	0.00	1166.79	0.79	0.00	Galeria	97	95
	24	R5 - A30	0.36	0.36	120	12.54	2.72	0.0166666667	97.95	97.95	1166.79	0.79	0.08	Galeria	101	99
	25	R4 - A31	0.36	0.72	120	12.07	2.75	0.025	99.01	0.00	1429.02	0.96	0.00	Galeria	99	96	97.5	94.3	1.5	1.7	0.0266666667	500	0.2562707331	120	468.25	2.38
	26	R6 - A32	0.36	0.72	120	15.39	2.55	0.0083333333	91.86	0.00	825.04	0.56	0.00	Galeria	97	96	95.5	94.3	1.5	1.7	0.01	500	0.4184883547	120	286.75	1.46
	27	R6 - A26	0.36	0.36	120	13.59	2.66	0.0083333333	95.61	0.00	825.04	0.56	0.00	Galeria	97	96
	28	R4 - A27	0.36	0.72	120	15.01	2.57	0.0125	92.63	92.63	1010.47	0.68	0.09	Galeria	96	94.5	94.3	92	1.7	2.5	0.0191666667	700	0.6154860745	600	974.84	2.53
	29	R8 - A28	0.36	1.11	120	20.84	2.28	0.0041666667	81.95	0.00	583.39	0.39	0.00	Galeria	95	94.5
	30	R3 - A15	0.36	0.36	120	13.59	2.66	0.0083333333	95.61	0.00	825.04	0.56	0.00	Galeria	96	95
	31	R3 - A21	0.36	0.36	120	13.59	2.66	0.0083333333	95.61	0.00	825.04	0.56	0.00	Galeria	96	95
	32	R8 - A22	0.36	1.11	120	15.08	2.57	0.0041666667	92.48	207.20	583.39	0.39	0.17	Galeria	95	94.5	92.5	92	2.5	2.5	0.0041666667	1500	0.7073414513	2460	3477.81	1.97
	33	TOTAL	60	92	91.1	2.5	2.5	0.015	1500	0.5728416031	3780	6598.68	3.73
	34
	35
Plan2
	DADOS
	TR 	10	ANOS
	YO	0.18	METROS
	H	0.2	METROS
	n SARJ.	1.4999999999999999E-2
	n TUBO	1.7000000000000001E-2
	C	0.6
Plan3