YourSpreadsheets™ Margery Street

2nd Floor, 52 Marcus Hill, London

www.YourSpreadsheets.co.uk Revision
Tel: 020 7542 8734
Job No: 22668 Page: C/01

Section: GROUND FLOOR - BEAM GB2 Prepared By: DJ Date: 24/10/2018

GENERAL DATA PARTIAL SAFETY FACTORS REINFORCEMENT COVERS

Steel class: b Steel 'γms' = 1.15 Top 'ctop' [mm] = 25
Materials:
Concrete Grade 'fcu' [N/mm ] = 2
25 Concrete 'γmc' = 1.50 Side 'cside' [mm] = 25
Main Steel Grade 'fy' [N/mm2] = 500 Dead 'γf' = 1.40 Bottom 'cbtm' [mm] = 25
Loads:
Links Steel Grade 'fyv' [N/mm2] = 500 Imposed 'γf' = 1.60 Note: Covers are measured to links.

BEAM DATA REINFORCEMENT DATA ADDITIONAL OPTIONS

Beam Type: Rectangular layer T1: 3B 20 Limit spacing of links to 300mm
Top Bars: ✘
Effective Length 'L' [m] = 6.00 layer T2: centres.
Beam Width 'Bw' [mm] = 600 layer B1: 6B 32 Include beam self-weight.
Btm Bars: ✘
Beam Depth 'D' [mm] = 600 layer B2: Measured to slab soffit.
Slab Depth 'Ds' [mm] = 200 Dia.: - 8 Limit clear distance between top
Links: ✘
Moment Redistribution Factor: 1.00 Legs: 3B bars to 75mm for a poker.
Note: Layers T1 and B1 are outermost.

LOADING
Dead Imposed position
length
UDL = 50.00 50.00 kN/m from left
Partial UDL 'a' = kN/m m m
Partial UDL 'b' = kN/m m m
Point Load 'a' = 50.00 35.00 kN 5.00 m ~~~~~~
Point Load 'b' = 50.00 kN 2.00 m ~~~~~~

SUMMARY OF REACTIONS (Dead + Imposed = Total) SUMMARY OF RESULTS (Factored)

Unfactored Factored Max Applied Moment = 845.8 kNm
Left = 209.7 + 155.8 = 365.5 293.5 + 249.3 = 542.9 kN Max Applied Shear = 603.53 kN
Right = 226.3 + 179.2 = 405.5 316.9 + 286.7 = 603.5 kN Span to Effective Depth Ratio = 10.89

DETAILED RESULTS: MOMENT (ULS) 0.00

-100.00
Effective depth d / depth of N.A. x = 551 / 275 mm -200.00
Compression steel required. K = 0.186 > 0.156 -300.00
-400.00
Required area of reinforcement As = 4438 mm2/m -500.00
-600.00
Required area of reinforcement As' = 618 mm2/m -700.00
DETAILED RESULTS: SHEAR (ULS) -800.00
-900.00
Shear stress at support v = 1.64 < 4.00 N/mm2 123456781911
12
013
14
15
16
17
18
19
20
21
22
23
24
25
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
100
99
101
Design concrete shear stress vc = 0.72 N/mm2 Moment [kNm]

Av/sv for nominal links = 0.552 800.00

600.00
Max required Av/sv = 1.13
400.00
DETAILED RESULTS: SERVICABILITY (SLS) 200.00
0.00
Modification factors MFc / MFt = 1.09 / 0.81
-200.00
Service stress in reinforcement fs = 307 N/mm2 -400.00
-600.00
Permissible span to eff. depth ratio = 17.52
-800.00
Actual span to eff. depth ratio = 10.89 123456781911
12
013
14
15
16
17
18
19
20
21
22
23
24
25
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
100
99
101
Shear [kN]

REINFORCEMENT OUTPUT: LONGITUDINAL ELEVATION TYPICAL SECTION

Location of links is only indicative.

3 B20 T1 3

3 B8 @150 3 B8 @125
3 B8 @250
for 1080mm for 961mm

6 B25 B1 6 B32 B1 6 B25 B1 4

2
1
 2
4
1

Spreadsheet provided by: www.YourSpreadsheets.co.uk calculations are based on BS8110:1-1997

Version: 1.1. - FREE LITE © 2012 Damian Janicki

For latest updates and news visit: Contact me at:

www.YourSpreadsheets.co.uk info@yourspreadsheets.co.uk

General information:
Note: This spreadsheet contains macros.

The Author takes no liability for use of this spreadsheet and gives no guarantee that it is error
free.

In no event shall the Author be responsible for any special, incidental or consequential damages
whatsoever arising from the use of this spreadsheet, even if the Author has been advised of the
possibility of such damage.

This spreadsheet is a freeware and can be distributed freely but only in its original form.

Reverse-engineering, decompiling or disassembling of this spreadsheet is not allowable.

By using this spreadsheet you understand and agree with the above terms and conditions. You
also acknowledge that you do not become the owner of this spreadsheet.

Damian Janicki

This is a Free Lite Version. The full version 1.1. of the spreadsheet allows to:
- Input your company information and change logo
- Input point loads
- Change beam width

This spreadsheet is based on BS 8110:1 1997.

Changelog:
24.02.2012 - v.1.1. - official release of the spreadsheet.
© 2012 Damian Janicki