ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
2,1OPERATING INSTRUCTIONS
2
Project
Spreadsheets to BS 8110
REINFORCED CONCRETE COUNCIL ENTER DATA IN BLUE CELLS ONLY.
3
Client
Advisory Group
Made byDatePage RED MESSAGES INDICATE ENTRY ERRORS.
4
Location
Edge Column B1 (akin to D&D)
rmw22-janv.-2685 MAGENTA INDICATES DATA FROM OTHER SHEETS.
5
COLUMN LOAD TAKE DOWN & DESIGN FOR SYMMETRICALLY REINFORCED RECT. COLUMNS BENT ABOUT TWO AXES TO BS 8110:1997CheckedRevision
Job No
 … See CDES!
6
Originated from RCC51.xls
v2,1 © 1999-2003 BCA for RCC
chg-R68
7
8
INPUT1-2
9
Location
Edge Column B1 (akin to D&D)
y
concrete density, kN/m3
24,0
10
yfgk1,40
11
Orientation
A-BxxB-C Hyfqk1,60
12
13
y
14
n/a
15
16
Level7654321
Enter a number or text in row 16 to activate the column of input
17
Dimensions
below. Deleting a Level (a cell in row 16) will "white out" that and
18
SpansCl to ClA-Bm5,005,005,005,005,005,005,00
subsequent columns and set spans to zero. Complete row 16 or
19
B-Cm5,005,005,005,005,005,005,00
copy across to get up to 10 levels. If entering text, subsequent
20
1-2m7,507,507,507,507,507,507,50hatches (###) should be overwritten.
21
n/am0,00
22
Generally, input values are carried through to the right.
23
Slab
thickness (solid)
mm175175175175175175175Overwrite if incorrect.
24
span direction,(II to) x, y or b
xxxxxxx
25
Deleting a cell (or inputting a value of 0) in columns G to P will
26
BeamswidthA-Bmm300300300300300300300"white out" values to the right which will be set at 0.
27
depth o/a
A-Bmm350350350350350350350
28
widthB-Cmm300300300300300300300
For troughed slabs use topping thickness and aggregate width
29
depth o/a
B-Cmm350350350350350350350of ribs with width of beam.
30
width1-2mm300300300300300300300 Cl = Centreline of support
31
depth o/a
1-2mm500500500500500500500
x or y = spanning II parallel to x or y, b: both or two-way spanning
32
widthn/amm0 o/a = overall: downstand beams assumed
33
depth o/a
n/amm0
34
35
Column below
(col above)These column sizes are used in CDES! etc.
In CDES! h = 300 In CDES! b = 300
36
H (ll to yy)
mm300300300300300300300
37
B (ll to xx)
mm300300300300300300300Current status is ….. OK
38
Height (fl. to floor.)
m4,004,004,004,004,004,004,00for the column at ….Bottom (Max N)
39
Please note bottom of lowest column is assumed to be fixed,
40
Level7654321
e.g. at foundation level. Double 'Height' if pinned base required.
41
Loads
(characteristic uno)
42
Slab
(inc swt.)
gkkN/m25,005,005,005,005,005,005,00swt = self weight
43
qkkN/m24,004,004,004,004,004,004,00gk = characteristic Dead load
44
qk = characteristic Imposed load
45
Beams(swt.)gkkN/mincludedincludedincludedincludedincludedincludedincludedincludedincludedincluded
46
line loads (-extra over slab loads and beam self weight)
For partitions, cladding etc
47
A-BgkkN/m5,05,05,05,05,05,05,0
48
qkkN/m0,0
49
B-CgkkN/m5,05,05,05,05,05,05,0
50
qkkN/m0,0
51
1-2gkkN/m0,0
52
qkkN/m0,0
53
n/agkkN/m0,0
54
qkkN/m0,0
55
56
At column position, other applied loads (eg loads from cantilevers)
e.g. loads from roof structures
57
GkkN (char)0,0
58
QkkN (char)0,0
59
MxxkNm (ult)0,0
60
MyykNm (ult)0,0
61
62
Loads per floor
63
FloorGkkN133,8133,8133,8133,8133,8133,8133,8
64
FloorQkkN75,075,075,075,075,075,075,0
65
Column below
GkkN8,68,68,68,68,68,68,6
66
67
OUTPUT
Column level
7 to 66 to 55 to 44 to 33 to 22 to 1Below 1
68
69
Cumulative loads in column.
70
GkkN142,5284,9427,4569,9712,3854,8997,3
Assuming beams and columns are simply supported - see
71
Redn factors OK*?QkkN75,0150,0225,0300,0375,0450,0525,0BS8110 Pt1 Cl 3.2.1.2.5
72
Qk rednfactor1,00,90,80,70,60,60,6
73
YQk red*kN75,0135,0180,0210,0225,0270,0315,0
*See BS 6399: Pt 1 1996 Cl 6.1 (e.g. storage, plant and car
74
NkN3196158861134135716291900parking loads should not be reduced)
75
Moments in column
76
about x-xMxxtopkNm112,691,791,791,791,791,791,7
77
about y-yMyytopkNm1,61,31,31,31,31,31,3
78
MxxbottomkNm91,791,791,791,791,791,7
79
MyybottomkNm1,31,31,31,31,31,3
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100