Planilha Dimensionamento de Sapatas

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

Plan1
	Cálculo da Tensão Admissível do Solo pelo Método Empírico
	Cota de Apoio da Sapata	-1.00
	NSPT na Cota de Apoio	* 7.00
	σAdm (kPA)	* 140.00
	Dimensionamento de Sapatas
	Pilar	Seção (cm)	Carregamento (kN)	Alívio de Carga (kN)	Área Mínima da Sapata (m²)	Dimesões dos Pilares (m)	Dimesões das Sapatas (m)
	b	l	B	L	a	b	c	delta	raiz de delta	L1	L2
	P1	25x55	* 185.00	185	* 1.40	* 0.25	* 0.55	* 1.05	* 1.35	1	-0.30	-1.40	* 5.69	2.3853720884	1.3426860442	-1.0426860442
	P2	15x25	* 115.00	115	* 0.90	* 0.15	* 0.25	* 0.90	* 1.00	1	-0.10	-0.90	* 3.61	1.9	1	-0.9
	P3	15x25	* 140.00	140	* 1.05	* 0.15	* 0.25	* 1.00	* 1.10	1	-0.10	-1.05	* 4.21	2.0518284529	1.0759142264	-0.9759142264
	P4	15x25	* 125.00	125	* 0.95	* 0.15	* 0.25	* 0.95	* 1.05	1	-0.10	-0.95	* 3.81	1.9519221296	1.0259610648	-0.9259610648
	P5	15x25	* 95.00	95	* 0.75	* 0.15	* 0.25	* 0.80	* 0.95	1	-0.10	-0.75	* 3.01	1.7349351573	0.9174675786	-0.8174675786
	P6	12x30	* 65.00	65	* 0.50	* 0.12	* 0.30	* 0.80	* 0.80	1	-0.18	-0.50	* 2.03	1.425622671	0.8028113355	-0.6228113355
	P7	15x25	* 150.00	150	* 1.15	* 0.15	* 0.25	* 1.00	* 1.15	1	-0.10	-1.15	* 4.61	2.1470910554	1.1235455277	-1.0235455277
	P8	12x30	* 100.00	100	* 0.75	* 0.12	* 0.30	* 0.75	* 1.00	1	-0.18	-0.75	* 3.03	1.7413787641	0.960689382	-0.780689382
	P9	17x55	* 250.00	250	* 1.90	* 0.17	* 0.55	* 1.20	* 1.60	1	-0.38	-1.90	* 7.74	2.78287621	1.581438105	-1.201438105
	P10	15x50	* 265.00	265	* 2.00	* 0.15	* 0.50	* 1.25	* 1.60	1	-0.35	-2.00	* 8.12	2.85	1.6	-1.25
	P11	15x25	* 185.00	185	* 1.40	* 0.15	* 0.25	* 1.15	* 1.25	1	-0.10	-1.40	* 5.61	2.3685438565	1.2342719282	-1.1342719282
	P12	12x30	* 100.00	100	* 0.75	* 0.12	* 0.30	* 0.75	* 1.00	1	-0.18	-0.75	* 3.03	1.7413787641	0.960689382	-0.780689382
	P13	15x30	* 155.00	155	* 1.20	* 0.15	* 0.30	* 1.00	* 1.20	1	-0.15	-1.20	* 4.82	2.1960191256	1.1730095628	-1.0230095628
	P14	12x30	* 65.00	65	* 0.50	* 0.12	* 0.30	* 0.80	* 0.80	1	-0.18	-0.50	* 2.03	1.425622671	0.8028113355	-0.6228113355
	P15	15x25	* 100.00	100	* 0.75	* 0.15	* 0.25	* 0.80	* 0.95	1	-0.10	-0.75	* 3.01	1.7349351573	0.9174675786	-0.8174675786
	P16	15x25	* 190.00	190	* 1.45	* 0.15	* 0.25	* 1.15	* 1.30	1	-0.10	-1.45	* 5.81	2.4103941586	1.2551970793	-1.1551970793
	P17	15x25	* 160.00	160	* 1.20	* 0.15	* 0.25	* 1.05	* 1.15	1	-0.10	-1.20	* 4.81	2.1931712199	1.14658561	-1.04658561
	P18	15x25	* 190.00	* 11.30	184.35	* 1.40	* 0.15	* 0.25	* 1.15	* 1.25	1	-0.10	-1.40	* 5.61	2.3685438565	1.2342719282	-1.1342719282
	P19	15x25	* 176.40	176.4	* 1.35	* 0.15	* 0.25	* 0.85	* 1.70	Aplicada a condição L=2B
Diego Rafael Bieger: Diego Rafael Bieger:
Para pilares de divisa utilizar a fórmula L=2B
	* 0.82
	P20	17x55	* 210.00	210	* 1.60	* 0.17	* 0.55	* 1.10	* 1.50	1	-0.38	-1.60	* 6.54	2.5582024939	1.469101247	-1.089101247
	P21	17x50	* 415.00	415	* 3.15	* 0.17	* 0.50	* 1.65	* 1.95	1	-0.33	-3.15	* 12.71	3.5649544177	1.9474772088	-1.6174772088
	P22	15x25	* 205.00	205	* 1.55	* 0.15	* 0.25	* 1.20	* 1.30	1	-0.10	-1.55	* 6.21	2.4919871589	1.2959935794	-1.1959935794
	P23	12x30	* 60.00	60	* 0.45	* 0.12	* 0.30	* 0.80	* 0.80	1	-0.18	-0.45	* 1.83	1.3536617007	0.7668308504	-0.5868308504
	P24	15x50	* 190.00	190	* 1.45	* 0.15	* 0.50	* 1.05	* 1.40	1	-0.35	-1.45	* 5.92	2.4336187047	1.3918093524	-1.0418093524
	P25	15x50	* 265.00	265	* 2.00	* 0.15	* 0.50	* 1.25	* 1.60	1	-0.35	-2.00	* 8.12	2.85	1.6	-1.25
	P26	15x50	* 215.00	215	* 1.65	* 0.15	* 0.50	* 1.10	* 1.50	1	-0.35	-1.65	* 6.72	2.5927784325	1.4713892162	-1.1213892162
	P27	15x50	* 265.00	* 44.80	242.6	* 1.85	* 0.15	* 0.50	* 1.20	* 1.55	1	-0.35	-1.85	* 7.52	2.7427176304	1.5463588152	-1.1963588152
	P28	15x25	* 268.80	268.8	* 2.05	* 0.15	* 0.25	* 1.05	* 2.10	Aplicada a condição L=2B	* 1.01
	P29	15x25	* 150.00	150	* 1.15	* 0.15	* 0.25	* 1.00	* 1.15	1	-0.10	-1.15	* 4.61	2.1470910554	1.1235455277	-1.0235455277
	P30	12x30	* 85.00	85	* 0.65	* 0.12	* 0.30	* 0.70	* 0.95	1	-0.18	-0.65	* 2.63	1.622467257	0.9012336285	-0.7212336285
	P31	17x55	* 160.00	160	* 1.20	* 0.17	* 0.55	* 0.90	* 1.35	1	-0.38	-1.20	* 4.94	2.2236006836	1.3018003418	-0.9218003418
	P32	15x50	* 250.00	250	* 1.90	* 0.15	* 0.50	* 1.20	* 1.60	1	-0.35	-1.90	* 7.72	2.7789386463	1.5644693232	-1.2144693232
	P33	15x40	* 205.00	205	* 1.55	* 0.15	* 0.40	* 1.15	* 1.40	1	-0.25	-1.55	* 6.26	2.5024987512	1.3762493756	-1.1262493756
	P34	15x50	* 225.00	225	* 1.70	* 0.15	* 0.50	* 1.15	* 1.50	1	-0.35	-1.70	* 6.92	2.6310644234	1.4905322117	-1.1405322117
	P35	15x50	* 275.00	275	* 2.10	* 0.15	* 0.50	* 1.30	* 1.65	1	-0.35	-2.10	* 8.52	2.9193321154	1.6346660577	-1.2846660577
	P36	15x50	* 315.00	315	* 2.40	* 0.15	* 0.50	* 1.40	* 1.75	1	-0.35	-2.40	* 9.72	3.1180923655	1.7340461828	-1.3840461828
	P37	15x50	* 275.00	* 66.00	242	* 1.85	* 0.15	* 0.50	* 1.20	* 1.55	1	-0.35	-1.85	* 7.52	2.7427176304	1.5463588152	-1.1963588152
	P38	15x50	* 396.00	396	* 3.00	* 0.15	* 0.50	* 1.25	* 2.50	Aplicada a condição L=2B	* 1.22
	P39	15x40	* 165.00	165	* 1.25	* 0.15	* 0.40	* 1.00	* 1.25	1	-0.25	-1.25	* 5.06	2.25	1.25	-1
	P40	15x40	* 160.00	160	* 1.20	* 0.15	* 0.40	* 1.00	* 1.25	1	-0.25	-1.20	* 4.86	2.2051077071	1.2275538536	-0.9775538536
	P41	25x65	* 185.00	185	* 1.40	* 0.25	* 0.65	* 1.00	* 1.40	1	-0.40	-1.40	* 5.76	2.4	1.4	-1
	P42	Ø 40	* 310.00	310	* 2.35	0.0	0.0	* 1.55	* 1.55	1	0.0	-2.35	* 9.40	3.0659419434	1.5329709717	-1.5329709717
	P43	21x65	* 215.00	215	* 1.65	* 0.21	* 0.65	* 1.10	* 1.55	1	-0.44	-1.65	* 6.79	2.6064535292	1.5232267646	-1.0832267646
	P44	15x40	* 180.00	180	* 1.35	* 0.15	* 0.40	* 1.05	* 1.30	1	-0.25	-1.35	* 5.46	2.3371991785	1.2935995893	-1.0435995893
	P45	15x40	* 165.00	165	* 1.25	* 0.15	* 0.40	* 1.00	* 1.25	1	-0.25	-1.25	* 5.06	2.25	1.25	-1
	P46	15x40	* 170.00	* 33.60	153.2	* 1.15	* 0.15	* 0.40	* 0.95	* 1.25	1	-0.25	-1.15	* 4.66	2.1592822882	1.2046411441	-0.9546411441
	P47	15x40	* 201.60	201.6	* 1.55	* 0.15	* 0.40	* 0.90	* 1.80	Aplicada a condição L=2B	* 0.88