Planilha rede de esgoto Finalizada

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

MODELO
	PLANILHA DE CÁLCULO - REDE de ESGOTO
	Cidade:	POP.	985	Nº de pessoas por Economia	K1	1.2
	Loteamento:	Consumo	200	Litros por dia por pessoa	K2	1.5
	K(Manning)	0,010	Coef. Rugosidade (Manning)
	C(Retorno)	0.80	Coef. Retorno (QEsgoto/QAgua)
	Q inf	0.5	Vazão de infiltração (l/s/Km)	Assinatura / CREA
	TRECHO	L	COTA TERRENO	COTA COLETOR	Q inf	Q mont.	 Q trecho	 Q jus	Q adot.	DECLIV.	DIAMETRO (m)	V real	H / D	TENSÃO	 RECOBRIMENTO
	PV A	PV B	( m )	montante	jusante	montante	jusante	( l / s )	( l / s )	( l / s )	( l / s )	( l / s )	( m / m )	calc.	adot.	( m / s )	( % )	( Pa )	A	B
	PS1	PV1	40	102.0	102.10	100.95	101,05	0.048	0	0.14	0.14	1.5	0,005	0.072	0.100	0.60	75	1.25	0.95	0.95
	PS2	PV2	40	102.0	101.97	100.95	100.92	0.048	0	0.14	0.14	1.5	0,005	0.072	0.100	0.60	75	1.25	0.95	0.95	 
	PV2	PV4	40	101.97	101.95	100.92	100.9	0.048	0,28	0.14	0.42	1.5	0,005	0.072	0.100	0.60	75	1.25	0.95	0.95
	PV1	PV4	40	102.1	101.95	101.5	101.35	0.048	0,42	0.14	0.56	1.5	0.005	0.072	0.100	0.60	75	1.25	0.60	0.60
	PS3	PV3	55	102.10	102	101.5	101.4	0.048	0	0.19	0.19	1.5	0.005	0.072	0.100	0.60	75	1.25	0.60	0.60
	PV3	PV6	40	102.00	101.94	100.95	100.9	0.048	0,75	0.14	0.89	1.5	0.005	0.072	0.100	0.60	75	1.25	0.95	0.95
	PV4	PV6	55	101.95	101.94	100.9	100.89	0.048	0,89	0.19	1.08	1.5	0,005	0.072	0.100	0.60	75	1.25	0.95	0.95
	PS4	PV5	40	102.0	101.98	100.95	100.93	0.048	0	0.14	0.14	1.5	0.005	0.072	0.100	0.60	75	1.25	0.95	0.95
	PV5	PV8	40	101.98	101.95	100.93	100.9	0.048	1,22	0.14	1.36	1.5	0.005	0.072	0.100	0.60	75	1.25	0.95	0.95
	PV6	PV8	40	101.94	101.95	100.9	100,8	0.048	1,36	0.14	1.50	1.5	0,005	0.072	0.100	0.60	75	1.25	0.94	0.95
	PS5	PV2	55	102.30	101.97	101.25	100.92	0.048	0	0.19	0.19	1.5	0.006	0.07	0.100	0.65	75	1.50	0.95	0.95
	PS6	PV4	55	102.30	101.95	101.25	100.9	0.048	0	0.19	0.19	1.5	0.0063	0.07	0.100	0.67	75	1.57	0.95	0.95
	PS7	PS8	55	102.3	102.2	101.25	101.15	0.048	0	0.19	0.19	1.5	0.005	0.072	0.100	0.60	75	1.25	0.95	0.95
	PS8	PV6	55	102.20	101.94	101.15	100.89	0.048	0	0.19	0.19	1.5	0.0047	0.073	0.100	0.58	75	1.18	0.95	0.95
	PS8	PV7	40	102.2	102.15	101.15	101.1	0.048	2,26	0.14	2.40	2.4	0.004	0.075	0.100	0.30	75	1.00	0.95	0.95
	PV7	PV8	55	102.15	101.95	101.1	100.9	0.048	2,4	0.19	2.60	2.6	0.004	0.076	0.100	0.52	75	1.00	0.95	0.95
	PV8	PV9	50	101.95	101.89	100.9	100.84	0.048	2.60	0.17	2.76	2.8	0.004	0.076	0.100	0.52	75	1.00	0.95	0.95
	PS9	PV9	55	102	101.89	100.95	100.84	0.048	0	0.19	0.19	1.5	0,005	0.072	0.100	0.60	75	1.25	0.95	0.95
	PV9	PV10	112	101.89	101.7	100.84	100.68	0.048	2.95	0.39	3.34	3.34	0,004	0.078	0.100	0.48	75	1.00	0.95	0.90