Planilha Dimensionamento de Tubulões Prática

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

ATENÇÃO
	Planilha de dimensionamento de fundações em tubulões
	Autoria: Diego Rafael Bieger (45) 8826-6899 biegerdiego1@gmail.com
	Planilha em versão teste. Favor atentar para as observações contidas nos comentários
	Em caso de dúvidas, sugestões e reclamações favor enviar um email para o endereço supracitado.
Dimensionamento
	Cálculo da Tensão Adminssível do Solo pelo Método Empírico
	Cota de Apoio do Tubulão	-7.00	7	Resistência do concreto (MPa)	* 20.00
	NSPT na Cota de Apoio	* 17.00	Altura do Rodapé h0 (m)	* 0.20
	σAdm (kPa)	* 500.00
Diego Rafael Bieger: Diego Rafael Bieger:
Adotar σAdm máximo de 500kPa
	f	* 0.10
	Dimensionamento de Tubulões
	Pilar	Carregamento (kN)	Alívio de Carga (kN)
JL: Diego Rafael Bieger:
Clacular o alívio manualmente e inserir o valor integral
	Dimensões dos Pilares (m)	Formato da Base	Base Circular	Base tipo Falsa Elipse	Ângulo de Inclinação (º)	Volume de Concreto (m³)
	b	l	Diâmetro da Base (m) - Db	Diâmetro do Fuste (m) - Df	Altura da Base (m) - H	Área da base (m²) - Ab
Diego Rafael Bieger: Diego Rafael Bieger:
Área necessária para a carga do pilar somente
	Novo Valor de R (m)
JL: Diego Rafael Bieger:
Inserir o valor de R já considerando um acréscimo que deve ser calculado manualmente	Novo Valor de X (m)	Excentricidade (m) - e	S (m)
Diego Rafael Bieger: Diego Rafael Bieger:
Inserir a distância entre o pilar que está sendo calculado e o pilar considerado para a Viga Alavanca.
Obs.: Caso a Viga Alavanca for inclinada, inserir o valor já corrigido (e'=e/cos Θ)
	R1 (kN)	AR1 (m²)
Diego Rafael Bieger: Diego Rafael Bieger:
Área em função de R1	A' (m²)
Diego Rafael Bieger: Diego Rafael Bieger:
Área com base nos novos valores de R e X
	Diâmetro do Fuste (m) - Df	Altura da Base (m) - H
	P1	4090	* 0.60	* 0.90	Falsa Elipse	0.0	0.0	0.0	* 8.20	* 1.30	* 2.00	* 0.90	* 4.08	* 5,247.55	* 10.50	* 10.51	* 0.85	* 2.25	50	* 9.45
	P2	3800	* 0.60	* 0.60	Falsa Elipse	0.0	0.0	0.0	* 7.60	* 1.10	* 2.15	* 0.70	* 6.70	* 4,243.33	* 8.49	* 8.53	* 0.80	* 2.20	51	* 7.93
	P7	2020	* 0.60	* 0.60	Falsa Elipse	0.0	0.0	0.0	* 4.05	* 0.70	* 2.10	* 0.30	* 5.00	* 2,148.94	* 4.30	* 4.48	* 0.70	* 2.20	57	* 5.21
	P9	3500	* 0.25	* 2.08	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	P10	3470	* 0.25	* 2.08	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	P12	4410	* 0.30	* 1.20	Circular	* 3.40	* 0.90	* 2.20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 9.10
	P13	3180	* 0.30	* 1.20	Circular	* 2.85	* 0.75	* 1.85	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 5.78
	P14	3330	* 0.44	* 0.60	Circular	* 2.95	* 0.75	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.03
	P15	4070	* 0.25	* 1.20	Circular	* 3.25	* 0.85	* 2.10	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 7.95
	P18	2660	* 0.60	* 0.60	Falsa Elipse	0.0	0.0	0.0	* 5.35	* 0.80	* 2.40	* 0.40	* 5.43	* 2,871.53	* 5.74	* 5.85	* 0.70	* 2.20	53	* 5.80
	P19	5510	* 211.53	* 0.50	* 1.40	Circular	* 3.75	* 1.00	* 2.25	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	58	* 11.61
	P21	2960	* 0.25	* 1.25	Circular	* 2.75	* 0.75	* 1.75	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 5.55
	P22	2730	* 0.25	* 1.25	Circular	* 2.65	* 0.70	* 1.70	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.86
	P23	2270	* 0.25	* 1.00	Circular	* 2.45	* 0.70	* 1.55	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.50
	P28	2570	* 0.30	* 1.00	Circular	* 2.60	* 0.70	* 1.65	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.76
	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	0.0
	PT1	800	* 0.25	* 0.60	Circular	* 1.45	* 0.70	* 0.65	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 3.17
	PT3	3840	* 0.30	* 1.20	Circular	* 3.15	* 0.85	* 2.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 7.64
	PT4	1950	* 0.25	* 0.80	Circular	* 2.25	* 0.70	* 1.35	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.15
	PT5	2500	* 128.94	* 0.60	* 0.60	Circular	* 2.50	* 0.70	* 1.60	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.60
	PT6	1540	* 1,157.55	* 0.25	* 0.90	Circular	* 1.60	* 0.70	* 0.80	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 3.32
	PT7	3750	* 443.33	* 0.50	* 0.60	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	PT8	420	* 0.25	* 1.00	Circular	* 1.05	* 0.70	* 0.35	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 2.90
	PT9	3430	* 0.30	* 1.20	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	PT10	2460	* 0.30	* 1.20	Circular	* 2.55	* 0.70	* 1.65	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.70
	PT11	3660	* 0.35	* 1.20	Circular	* 3.10	* 0.80	* 2.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.92
	PT12	3470	* 0.60	* 0.60	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	PT13	3750	* 0.60	* 0.60	Circular	* 3.10	* 0.80	* 2.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.92
	PT14	1370	* 0.50	* 0.50	Circular	* 1.90	* 0.70	* 1.05	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 3.66
	PT15	1570	* 0.50	* 0.50	Circular	* 2.00	* 0.70	* 1.15	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	* 3.79
	Circular
	Falsa Elipse
Dimensionamento (2)
	Cálculo da Tensão Adminssível do Solo pelo Método Empírico
	Cota de Apoio do Tubulão	-7.00
	NSPT na Cota de Apoio	* 17.00
	σAdm (kPa)	* 500.00
	f	* 0.10	7
	Resistência do concreto (MPa)	* 20.00
	Altura do Rodapé h0 (m)	* 0.20
	Dimensionamento de Tubulões
	Pilar	Carregamento (kN)	Alívio de Carga (kN)	Dimensões dos Pilares (m)	Formato da Base	Base Circular	Base Tipo Falsa Elipse	Ângulo de Inclinação (º)	Volume de Concreto (m³)
	b	l	Diâmetro da Base (m) - Db	Diâmetro do Fuste (m) - Df	Altura da Base (m) - H	R (m)	 X (m)	Excentricidade (m) - e	A' (m²)	Diâmetro do Fuste (m) - Df	Altura da Base (m) - H
	P1	4090	* 0.60	* 0.90	Falsa Elipse	0.0	0.0	0.0	* 1.30	* 2.00	* 0.90	* 10.51	* 0.85	* 2.25	50	* 9.45
	P2	3800	* 0.60	* 0.60	Falsa Elipse	0.0	0.0	0.0	* 1.10	* 2.15	* 0.70	* 8.53	* 0.80	* 2.20	51	* 7.93
	P7	2020	* 0.60	* 0.60	Falsa Elipse	0.0	0.0	0.0	* 0.70	* 2.10	* 0.30	* 4.48	* 0.70	* 2.20	57	* 5.21
	P9	3500	* 0.25	* 2.08	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	P10	3470	* 0.25	* 2.08	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	P12	4410	* 0.30	* 1.20	Circular	* 3.40	* 0.90	* 2.20	0.0	0.0	0.0	0.0	0.0	0.0	60	* 9.10
	P13	3180	* 0.30	* 1.20	Circular	* 2.85	* 0.75	* 1.85	0.0	0.0	0.0	0.0	0.0	0.0	60	* 5.78
	P14	3330	* 0.44	* 0.60	Circular	* 2.95	* 0.75	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.03
	P15	4070	* 0.25	* 1.20	Circular	* 3.25	* 0.85	* 2.10	0.0	0.0	0.0	0.0	0.0	0.0	60	* 7.95
	P18	2660	* 0.60	* 0.60	Falsa Elipse	0.0	0.0	0.0	* 0.80	* 2.40	* 0.40	* 5.85	* 0.70	* 2.20	53	* 5.80
	P19	5510	* 211.53	* 0.50	* 1.40	Circular	* 3.75	* 1.00	* 2.25	0.0	0.0	0.0	0.0	0.0	0.0	58	* 11.61
	P21	2960	* 0.25	* 1.25	Circular	* 2.75	* 0.75	* 1.75	0.0	0.0	0.0	0.0	0.0	0.0	60	* 5.55
	P22	2730	* 0.25	* 1.25	Circular	* 2.65	* 0.70	* 1.70	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.86
	P23	2270	* 0.25	* 1.00	Circular	* 2.45	* 0.70	* 1.55	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.50
	P28	2570	* 0.30	* 1.00	Circular	* 2.60	* 0.70	* 1.65	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.76
	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	60	0.0
	PT1	800	* 0.25	* 0.60	Circular	* 1.45	* 0.70	* 0.65	0.0	0.0	0.0	0.0	0.0	0.0	60	* 3.17
	PT3	3840	* 0.30	* 1.20	Circular	* 3.15	* 0.85	* 2.00	0.0	0.0	0.0	0.0	0.0	0.0	60	* 7.64
	PT4	1950	* 0.25	* 0.80	Circular	* 2.25	* 0.70	* 1.35	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.15
	PT5	2500	* 128.94	* 0.60	* 0.60	Circular	* 2.50	* 0.70	* 1.60	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.60
	PT6	1540	* 1,157.55	* 0.25	* 0.90	Circular	* 1.60	* 0.70	* 0.80	0.0	0.0	0.0	0.0	0.0	0.0	60	* 3.32
	PT7	3750	* 443.33	* 0.50	* 0.60	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	PT8	420	* 0.25	* 1.00	Circular	* 1.05	* 0.70	* 0.35	0.0	0.0	0.0	0.0	0.0	0.0	60	* 2.90
	PT9	3430	* 0.30	* 1.20	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	PT10	2460	* 0.30	* 1.20	Circular	* 2.55	* 0.70	* 1.65	0.0	0.0	0.0	0.0	0.0	0.0	60	* 4.70
PT11	3660	* 0.35	* 1.20	Circular	* 3.10	* 0.80	* 2.00	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.92
	PT12	3470	* 0.60	* 0.60	Circular	* 3.00	* 0.80	* 1.95	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.69
	PT13	3750	* 0.60	* 0.60	Circular	* 3.10	* 0.80	* 2.00	0.0	0.0	0.0	0.0	0.0	0.0	60	* 6.92
	PT14	1370	* 0.50	* 0.50	Circular	* 1.90	* 0.70	* 1.05	0.0	0.0	0.0	0.0	0.0	0.0	60	* 3.66
	PT15	1570	* 0.50	* 0.50	Circular	* 2.00	* 0.70	* 1.15	0.0	0.0	0.0	0.0	0.0	0.0	60	* 3.79
	Circular
	Falsa Elipse