Two-way Solid Slabs (www.theengineeringcommunity.org).xlsm

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1																OPERATING INSTRUCTIONS
2	Project	Spreadsheets to BS 8110 & EC2								REINFORCED CONCRETE COUNCIL						ENTER DATA IN BLUE CELLS ONLY.	TABLE 3.16 Algorithm
3	Client	Advisory Group								Made by		Date		Page		RED MESSAGES INDICATE ENTRY ERRORS.	2	0	0	1	1
4	Location	32nd floor - corner panel						F to G: 1 to 2		RMW		12-janv.-2026		130		SINGLY REINFORCED SECTIONS ONLY.		1	1		1	1
5		2-WAY SPANNING INSITU CONCRETE SLABS to BS 8110:1997 (Table 3.14)								Checked		Revision		Job No		Adjacent Panels must Comply with 3.5.3.5 (a)	0,66	0,66	0,66	0,66	0,66	0,66
6		Originated from RCC94.xls on CD © 1999 BCA for RCC								chg		-		R68
7																	Ly/Lx =	6,0000	Nd =	2	g =	0,5934
8	DIMENSIONS				MATERIALS						STATUS	Fails on MAX SPACING,				�
9	short span, lx	m	2,00		fcu	N/mm²	40	gc =	1,50		F				G	�	T	@
10	long span, ly	m	12,00		fy	N/mm²	460	gs =	1,05			Edge 1				�				CORNERS
11	h	mm	250		Density	kN/m³	23,6			1						Ly/Lx > 2				1	2	3	4
12	Top cover	mm	20		(Normal weight concrete)				Plan				Lx = 2 m			�				1	1	0	0
13	Btm cover	mm	20							Edge 4					Edge 2	�				1	2	1	0
14	LOADING characteristic					EDGE CONDITIONS										Enter Grids at L9,P9,K11 & K18
15	Self weight	kN/m²	5,90			Edge 1	D	C = Continuous								�
16	Extra dead	kN/m²	1,50			Edge 2	D	D = Discontinuous				Ly = 12 m				�
17	Total Dead, gk	kN/m²	7,40	gf=	1,40	Edge 3	C									�
18	Imposed, qk	kN/m²	5,00	gf=	1,60	Edge 4	C			2						�
19	Design load, n	kN/m²	18,36		See Figure 3.8 and clauses 3.5.3.5-6							Edge 3				�
20																�
21			SHORT		LONG		EDGE 1		EDGE 2		EDGE 3		EDGE 4		BS8110
22	MAIN STEEL		SPAN		SPAN		Free		Free		Continuous		Continuous		Reference		SHORT SPAN	LONG SPAN	EDGE 1	EDGE 2	EDGE 3	EDGE 4
23	ßs		0,093		0,034		0,000		0,000		0,124		0,045		Table 3.14
24	M	kNm/m	6,8		2,5		0,0		0,0		9,1		3,3
25	d	mm	222,0		208,0		225,0		208,0		222,0		208,0
26	k'		0,156		0,156		0,156		0,156		0,156		0,156
27	k		0,003		0,001		0,000		0,000		0,005		0,002			�	0	0	0	0	0	0	0
28	Z	mm	210,9		197,6		213,8		197,6		210,9		197,6		3.4.4.4
29	As req	mm²/m	74		29		0		0		98		38			�
30	As min	mm²/m	325		325		325		325		325		325		Table 3.25	�	0	0	0	0	0	0	0	0
31	As deflection	mm²/m	74		29		~		~		~		~			�
32	Ø	mm	16		12		10		12		16		12			Choose Bar Øs Here
33	Layer		B 1		B 2		T 1		T 2		T 1		T 2			Choose Layering
34	@	mm	2700		3900		225		325		600		325			�	0	0	0	0	0	0	0	0
35	As prov	mm²/m	74		29		349		348		335		348
36	=	%	0,034		0,014		0,155		0,167		0,151		0,167		%	�	0	0	0	0	0	0	0	0
37	S max	mm	682		636		685		636		682		636		Clause	REDUCE BAR SIZE - SHORT SPAN	1	1	0	0	0	0	2	SHORT SPAN
38	Subclause		(a)		(a)		(a)		(a)		(a)		(a)		3.12.11.2.7
39	DEFLECTION
40	fs		304		305		0		0		90		34		Eqn 8
41	Mod factor		1,938												Eqn 7
42	Perm L/d		50,38			Actual L/d	9,01	As enhanced 0,0% for deflection control							Table 3.10	�	0
43
44	TORSION STEEL				BOTH EDGES DISCONTINUOUS				ONE EDGE DISCONTINUOUS								Corner	1	2	3	4
45	Ø	mm	10		X		Y		X		Y						Top X	349	349	335	335
46		As req	mm²/m		349	325				325					3.5.3.5		Top Y	348	348	348	348
47		As prov T	mm²/m				348		335		348						disc	1	2	1	0
48		Additional As T req	mm²/m		0		0		0		0						2 X	5000	349	5000	5000	349
49		As prov B	mm²/m		74		29		74		29						2 Y	5000	348	5000	5000	348
50					Bottom steel not curtailed in edge strips at free edges												1 X	349	5000	335	5000	335
51																	1 Y	348	5000	348	5000	348
52	SUPPORT REACTIONS (kN/m char uno)					(See Figure 3.10)						Sum ßvx =	1,223		Table 3.15		Requd	325	325	325	0
53			EDGE 1		EDGE 2		EDGE 3		EDGE 4			Sum ßvy =	0,660
54			1, F-G		G, 2-1		2, F-G		F, 2-1						equations
55	ßv		0,489		0,264		0,734		0,396						19 & 20
56	Dead	kN/m	7,24		3,91		10,86		5,86
57	Imposed	kN/m	4,89		2,64		7,34		3,96
58	Vs	kN/m	18,0		9,7		27,0		14,5
59	OUTPUT/SUMMARY
60			SHORT		LONG		EDGE 1		EDGE 2		EDGE 3		EDGE 4
61		PROVIDE	SPAN		SPAN		1, F-G		G, 2-1		2, F-G		F, 2-1
62	MAIN STEEL		T16 @ 2 700 B1		T12 @ 3 900 B2		T10 @ 225 T1		T12 @ 325 T2		T16 @ 600 T1		T12 @ 325 T2
63
64	ADDITIONAL		0		CORNER 2		CORNER 3		CORNER 4
65	TORSION STEEL		0		G1		G2		F2							REINFORCEMENT DENSITY
66	X direction		0							placed in edge strips						18,9 kg/m³	No	0	0	0	0
67	Y direction		0														No	0	0	0	0
68
69	CHECKS		BAR Ø		SINGLY		MIN		MAX			GLOBAL
70	Lx > Ly		< COVER		REINFORCED		SPACING		SPACING		DEFLECTION	STATUS
71	OK		OK		OK		OK		FAILS		OK	Fails on MAX SPACING,
72
73
74									MAX SPACING,
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100