RC Beam Design and Calculation to BS8110 Spreadsheet (www.theengineeringcommunity.org).xlsm

	A	B	C	D	F	G	H	I
1	RC Beam Design to BS8110: Part 1 & 2
2	Bending Resistance of Concrete Section				Permissible Span/Depth Ratios
3	gm for steel	1,05	#NAME?	SYED	Modification for Tension Reinforcement:
4	fy	500 N/mm2	Ast Balanced	#NAME?	Basic Ratio - from Table 3.9			26
5	fcu	25 N/mm2	z as 0.95d	527,3 mm	Design Moment M			193.1
6	Ast	5892 mm2	Calculated z	#NAME?	Moment Redistribution Ratio			1
7	b	230 mm	Valid z	#NAME?	Service Stress fs - Eq 8			#NAME?
8	d	555 mm	Mu	250,00 kNm	M/bd2			#VALUE!
9	Shear Resistance of Concrete Section				Modification Factor - Table 3.10			#NAME?
10	100Ast/bd	4,616					Permissible Span/Depth Ratio - Eq 7	#NAME?
11	vc - Table 3.8	#NAME?	Vc	#NAME?	Modification for Compression Reinforcement:
12	Shear Resistance of Concrete + Stirrups				A's provided			4910 mm2
13	fyv	460 mm2			100*A'sprovided/(bd)			3,85
14	Asv	113 mm2	Vsv	#NAME?	Modification Factor - Table 3.11			1,50
15	sv	100 mm	Vc + Vsv	#NAME?	Permissible Span/Depth Ratio - Eq 7			#NAME?
16	Shear Resistance of Concrete+Stirrups+Bent Up Bars				Extra Links and Longitudinal Steel for Torsion
17	Asb	628 mm2			Shear V	273 kN	vtu	#NAME?
18	sb	565 mm			Torsion T	87 kNm	vt min	#NAME?
19	Angle a	45 °	Calculated Vsb	#NAME?	hmin	300 mm	Induced v	2,14 N/mm2
20	Angle b	67,5 °	Valid Vsb	#NAME?	hmax	705 mm	Induced vt	#NAME?
21	d'	50 mm	Vc+Vsv+Vsb	#NAME?	x1	230 mm	#NAME?
22					y1	1210 mm	Asvtorsion links	#NAME?
23					sv used	100 mm	As longitudinal	#NAME?
24					sv max	#NAME?	#NAME?
25	NB: Shaded data is user input. All other output is template results.
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
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