Grafico de granulometria

Vista previa del material en texto

Planilha1
			Peneiras	Abertura (mm)	Solo retido (g)	Solo retido 	Solo retido acumulado (g)	Solo retido acumulado	Material que passa %
						%		%
			Nº 04	4.75	0.2	0.04%	0.2	0.04%	99.96%
			Nº 08	2.38	13.1	2.67%	13.3	2.71%	97.29%
			Nº 16	1.18	64.8	13.22%	78.1	15.94%	84.06%
			Nº 30	0.6	122.7	25.04%	200.8	40.98%	59.02%
			Nº 50	0.3	129.7	26.47%	330.5	67.45%	32.55%
			Nº 100	0.15	112.2	22.90%	442.7	90.35%	9.65%
			Nº 200	0.075	37.9	7.73%	480.6	97.96%	2.04%
			Fundo		8.4	1.71%	489	99.80%	0.20%
				IEe= k*IE
		Índice esclerométrico médio (IE)		Índice esclerométrico médio efetivo (IEe) K=1,038		Coeficiente de variação 
		(valor obtido de cada área)		1.038
		1	26	26.988
		2	26	26.988
		3	30	31.14
		4	24	24.912
		5	20	20.76
		6	26	26.988
		7	30	31.14
		8	26	26.988
		9	22	22.836
		10	32	33.216
		11	28	29.064
		12	26	26.988
		13	24	24.912
		14	32	33.216
		15	30	31.14
		16	30	31.14
			432	448.416
		Média (x)	28.026
Curva granulométrica 
4.75	2.38	1.18	0.6	0.3	0.15	7.4999999999999997E-2	4.08E-4	2.7141999999999999E-2	0.159387	0.40979500000000002	0.67448900000000001	0.90346899999999997	0.97959099999999999	0.99795900000000004	4.75	2.38	1.18	0.6	0.3	0.15	7.4999999999999997E-2	0.99959200000000004	0.972858	0.84061300000000005	0.59020499999999998	0.32551099999999999	9.6531000000000006E-2	2.0409E-2	2.0409999999999998E-3