ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
4.0TRUE1Useage3
2
Project
Spreadsheets to EC2
The Concrete Centre5Supports1,25CrowdsCOffice
3
Client
Advisory Group
Made by Date PageDwellingA
4
Location
Worked Examples: Main beam Grids C to J
rmw25-sept.-26266OfficeB
5
WIDE BEAM ANALYSIS & DESIGN to EN 1992-1 : 2004
Checked Revision Job NoRoofH
6
Originated from TCC43.xls
v4.0 on CD © 2003-26 TCC
chg-FB625ShoppingD
7
StorageE
8
MATERIALS.Errors on 'MAIN'
COVERS (to links)
USAGE'MAIN'0'SPANS'Vehicle > 30kNG
9
fck35N/mm²dg (mm)20Wk (mm)Top0,4Top cover27mm√000Vehicle ≤ 30kNF
10
fyk400N/mm²gs1,15Wk (mm)Btm0,3Btm cover27mmCheck fyk101B
11
fywk400N/mm²gc1,50Δc,dev10Side cover27mm√001
12
Steel classABay width5000mm√000
13
SPANSL (m)h (mm)bw (mm)hf (mm)Typebeff (mm)
LOADING PATTERN
Type = T, L or R(ectangular)beff maxL0000L0Sup beff
14
SPAN 1 5,5003901200125T2600minmax√2632358000011941277
15
SPAN 2 8,0003901200125T2900DEAD1,251,25√2967503600CHECKS231302452
16
SPAN 3 8,5003901200125T3000IMPOSED0,001,50√307555780'MAIN'2452
17
SPAN 4 4,0003901200125T2700BS EN 1990: (6.10b)√276040000331292451
18
SPAN 5
REBAR LAYERING
√0002451
19
SPAN 6
Support steel
√000413531741
20
in alt layer ?N√01741
21
SUPPORTSABOVE (m)H (mm)B (mm)End CondBELOW (m)H (mm)B (mm)End Cond
Can be K(nife), C(antilever) or E(ncastre) in column C
0501200
22
Support 13,750300300F3,750300300F√End100
23
Support 23,750300300F3,750300300F√BrittleInt10600
24
Support 33,750300300F3,750300300F√partitions?Int100
25
Support 43,750300300F3,750300300F√Int10700
26
Support 53,750300300F3,750300300F√010
27
Support 6√000
28
Support 7√000
29
Usage: Office With brittle partitions00
30
LOADING DIAGRAM
0
31
0
32
0
33
0
34
0
35
0
36
0
37
LOADING
UDLs (kN/m²) PLs (kN) Position (m)
Office usage√00
38
DeadImposedPositionLoadedDeadImposedPositionLoaded00
39
Span 1LoadLoadfrom leftLengthSpan 4LoadLoadfrom leftLength0
40
UDL 63,030,0~~~~~~~~~~UDL63,030,0~~~~~~~~~~√0
41
PL 1 ~~~~~PL 1~~~~~√0
42
PL 2 ~~~~~PL 2~~~~~√
43
Part UDL Part UDL√
44
Span 2Span 5√
45
UDL 63,030,0~~~~~~~~~~UDL~~~~~~~~~~√
46
PL 1 25,025,04,00~~~~~PL 1~~~~~√
47
PL 2 ~~~~~PL 2~~~~~√
48
Part UDL Part UDL√
49
Span 3Span 6√
50
UDL 63,030,0~~~~~~~~~~UDL~~~~~~~~~~√
51
PL 1 ~~~~~PL 1~~~~~√
52
PL 2 ~~~~~PL 2~~~~~√
53
Part UDL Part UDL√
54
55
REACTIONS (kN)
56
SUPPORT 1234500
57
ALL SPANS LOADED
245,2952,51078,4889,1117,40,00,0
58
MAX ULTIMATE
278,6952,51078,4889,1169,40,00,0
59
Characteristic Dead
126,1471,4558,1446,759,40,00,0
60
Max Imposed80,8232,9273,5211,363,50,00,0
61
Min Imposed-22,375,8131,244,4-34,70,00,0
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