Project
Spreadsheets to BS 8110
Client
Advisory Group
ocation
!CBP "ypical #loor Colu$n B%
The Concrete Centre
Ma Made by
r$& .,"!/,A Ch Chec2ed
P+,C-.,G S-!A/ to BS8110(00 4riginated 6ro$
RCC13.xls
MA MA"!/.AS
v4.9 on CD
C4+M,
© 2006-10 TCC
6cu ,?$$( 6yv ,?$$( lin2 9 $$ steel class B D. D.M!,S.4,S A $$ B $$ G $$
70 00 10
S"A"+S A.D D!S.G,
%00 00 1(
! # -
$$
4 4AD.,G
(*7 15:10
0
0
%%*):1
$$
787 7: 75*:)
S SAB
t ult +D h
2, 2,?$( $$
(
d; dy ave d
/! /!S+"S e= > %%*):1 2, At col: 6ace v $a; > 7:8** ,?$$(
P/4.D! P/4.D! .,S .,S single single leg Peri$eter 1 Peri$eter ( Peri$eter % 0 0 0 0 0 0
15 B10 E 1* (0 B10 E (80 %0 B10 E ()0 0 0 0 0 0 0
$$ $$
$$ $$
Date
Page
%1'May'(01) /evision
chg
(* 3ob ,o
'
/58
egend
10 '0 100
vc > At 1:d peri$eter v > At %d %d per peri$ i$et eter er v > : (%7 6ro$ col 6ace 8) 6ro$ col 6ace *70 6ro$ col 6ace 0 0 0 0 0 0
Plan
As; $$(?$ %5( Asy $$(?$ %*08 ave As 0:*8% < 0:)%7* 1:0885 0:8 0:8*5 *5
,?$$@ ,?$$( ,?$$(
"able %:8
Project
Spreadsheets to BS 8110
Client
Advisory Group
ocation
Colu$n B(
The Concrete Centre
Made by
r$& !DG! Chec2ed
P+,C-.,G S-!A/ to BS8110(00 4riginated 6ro$ /CC1%:;ls v7:* on CD
MA"!/.AS
6cu ,?$$( 6yv ,?$$( lin2 9 $$ steel class A D.M!,S.4,S A $$ B $$ D $$
4AD.,G
SAB
t ult +D h
2, 2,?$( $$
70 00 8
S"A"+S A.D D!S.G,
(00 (00 0
! # G -
$$
0
0
((% 17:70 (0
d; dy ave d
/!S+"S e= > %1(:( 2, At col: 6ace v $a; > (:7* ,?$$(
P/4.D! .,S single leg Peri$eter 1 Peri$eter ( 0 0 0 0 0 0 0
C4+M,
F (005'10 "CC
5 -8 E 1* 8 -8 E (10 0 0 0 0 0 0 0
$$ $$ $$
$$ $$ $$
Page
%1'May'(01) /evision
chg
%0 3ob ,o
'
/58
egend
1) '0 100 100 1%**
(0) 18) 1*)
As; $$(?$ (010 Asy $$(?$ 100 ave As 0:)7 <
vc > At 1:d peri$eter v > At (:(d peri$eter v > : *8 6ro$ col 6ace (75 6ro$ col 6ace 0 0 0 0 0 0 0
Date
Plan
0:80%( 0:*%0% 0:5*
,?$$@ ,?$$( ,?$$(
"able %:8
Project
Spreadsheets to BS 8110
Client
Advisory Group
ocation
Colu$ns A1 D1 A D
The Concrete Centre
Made by
r$&
P+,C-.,G S-!A/ to BS8110(00
C4/,!/ Chec2ed
4riginated 6ro$ /CC1%:;ls v7:* on CD
C4+M,
MA"!/.AS
F (005'10 "CC
6cu ,?$$( 6yv ,?$$( lin2 9 $$ steel class A D.M!,S.4,S A $$ B $$ C $$ D $$
70 00 8
S"A"+S A.D D!S.G,
700 (0 0 0
! # G -
$$
$$
'0 '(0 100 100
4AD.,G
()(:0 15:10
0
0
%0
$$
(1 1* (0
t ult +D
2,?$
h
$$
SAB
2, (
(0
d; dy ave d
/!S+"S e= > %70:0 2, At col: 6ace v $a; > (:*10 ,?$$(
P/4.D! .,S single leg Peri$eter Peri$eter Peri$eter Peri$eter Peri$eter
1 ( % 7 0 0 0 0
5 8 5 )
-8 -8 -8 -8 -8
E E E E E 0 0 0 0
170 1( () (5 (5
$$ $$
$$ $$
Date
Page
%1'May'(01) /evision
chg
%1 3ob ,o
'
/58
egend
As; $$(?$ (010 Asy $$(?$ (010 ave As 0:*8% <
vc > At 1:d peri$eter v > At 7:d peri$eter v > : 10( 6ro$ col 6ace (5 6ro$ col 6ace 710 6ro$ col 6ace 57 6ro$ col 6ace )1): 6ro$ col 6ace 0 0 0 0
Plan
0:8585 1:58 0:))71
,?$$@ (
,?$$
,?$$(
"able %:8
Project
Spreadsheets to BS 8110
Client
Advisory Group
ocation
An e;a$ple
The Concrete Centre
Made by
r$& /!'!,"/A," Chec2ed
P+,C-.,G S-!A/ to BS8110(00 4riginated 6ro$ /CC1%:;ls v7:* on CD
MA"!/.AS
C4/,!/
F (005'10 "CC
6cu ,?$$( 6yv ,?$$( lin2 9 $$ steel class A D.M!,S.4,S A $$ B $$ C $$ D $$
70 00 10
S"A"+S A.D D!S.G,
%0 %0 0 0
! # G -
$$
4AD.,G
77):0 17:70
0
0
SAB
t ult +D
2,?$
h
$$
2, (
(0
d; dy ave d
/!S+"S e= > 8:8 2, At col: 6ace v $a; > (:%7 ,?$$(
P/4.D! .,S single leg Peri$eter 1 Peri$eter ( 0 0 0 0 0 0 0
8 -10 E (( 10 -10 E (7 0 0 0 0 0 0 0
$$ $$ $$
$$ $$ $$
Date
Page
%1'May'(01) /evision
chg
%( 3ob ,o
'
/58
egend
'1( '7( (0 (0 *1:5
(0( 180 1*1
As; $$(?$ (80 Asy $$(?$ (80 ave As 1:% <
vc > At 1:d peri$eter v > At (:(d peri$eter v > : * 6ro$ col 6ace (%* 6ro$ col 6ace 0 0 0 0 0 0 0
Plan
0:*871 1:1)%8 0:*(0*
,?$$@ ,?$$
(
,?$$(
"able %:8
Project
Spreadsheets to BS 8110
ocation
!CBP "ypical #loor Colu$n B%
.,"!/,A C4+M,
P+,C-.,G S-!A/ to BS8110(00
Made by r$&
4riginated 6ro$ /CC1%:;ls v7:* on CD
F (005'10 "CC
Date
3ob ,o /58 %1'May'1)
D!"A.!D CAC+A".4,S e=?t
1:100
C/.".CA P!/.M!"!/S Per ,o a 1 )07:5( ( 105:*%) % 170*:( 7 1)51:5( (11%:8) 5 (755:18) ) (818: 8 %1)0:81( -ole 6ace 0 Col 6ace 0 ., /!J+./!M!,"S Per ,o v 1 ( % 7 5 ) 8 -ole 6ace Col 6ace
1:0885 0:))15 0:8*5 0:75** 0:%87% 0:%1*1 0:(5)7 0:((78 7:8*8* 7:8*8*
., P!/.M!"!/S Per ,o a 1 (%7:8) ( 8):18) % *%*: 7 1(*1:81( 1577:1( 5 1**5:7%) ) (%78:) 8 ()01:05( * %0%:%)
enhance$ent 6actor
.nternal )(%) 100: 1(8)7 15*(: 1811 (1%(*: (7178 (5*55: 1500 1500
deduct )1( 1005 1(** 1*% 188) (180 (7)7 ()5) 1( 1(
Asv (8(0 %*11 00( 50*% )18 8()5 *%5) 1078
.nternal %7)* 5(*): *115 11*%7: 17)% 1))1: (0%*0 (%(08: (50()
"otal ,o
35.90
49.80
0.00
0.00
0.00
0.00
0.00
ocation 1:0 (:( %:00 0:00 0:00 0:00 0:00 0:00
0.00
deduct %(1 517 *08 1(0( 17* 1)8* (08( (%)5 (55*
lin2 leg area )8: -ole deduction H I!S !,C4S!D A/!AS #inal Per ,o .nternal 6525 1 3.263 9050 ( 6.310 11575 % 10.349 14100 7 15.381 16624 21.406 19149 5 28.424 21674 ) 36.435 24199 8 45.440 1475 -ole 6ace 0.150 1475 Col 6ace 0.150
d d d d d d d d
#inal
&ithin BandH 0 0 0 0 0 0 0 0
,o
3158
16
5683
20
8208
30
10733
18
13258
22
15783
26
18308
28
20833
32
23358
36
c0 > 0:)050
Spacing 1* (80 ()0 * 500 50 50 50 57
Project
Spreadsheets to BS 8110
ocation
Colu$n B(
!DG! C4+M,
P+,C-.,G S-!A/ to BS8110(00 4riginated 6ro$ /CC1%:;ls v7:* on CD
Made by r$& F (005'10 "CC
Date
3ob ,o /58 %1'May'1)
D!"A.!D CAC+A".4,S e=?t
1:7000
C/.".CA P!/.M!"!/S Per ,o a 1 (*: ( 77%:( % *1 7 )%8:) 885: 5 10%7:( ) 118( 8 1%(*:) -ole 6ace ) Col 6ace 0 ., /!J+./!M!,"S Per ,o v 1 ( % 7 5 ) 8 -ole 6ace Col 6ace
0:*%0% 0:5* 0:%*5 0:7%%% 0:%% 0:(*7* 0:(75( 0:(05 1:)7)* (:788
., P!/.M!"!/S Per ,o a 1 *8: ( (75:( % %*7 7 71:) 58*: 5 8%):( ) *8 8 11%(:) * 1(80:
enhance$ent 6actor
Choose 188( (7)% %057 %5 7(75 78%) 7(8 501* 1000 )00
.nternal %157 7%75 (8 5)10 )8*( *0)7 10(5 117%8 1700 800
Asv %00 %*% 7*( *( 5*1 )*1 8*0 **0
.nternal 188 ())0 %*( 1%7 5%15 )7*8 8580 *85( 11077
"otal ,o
5.97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Choose 10*7 158 (()5 (85) %78 707* 7570 (%1 8((
lin2 leg area 0:% -ole deduction H I!S deduct ((5 %0 %7) %*0 7%( 7)7 15 * 100 )
#inal
1656
2168
2717
3265
3814
4363
4912
5461 900 643
&ithin BandH
ocation 1:0 (:( 0:00 0:00 0:00 0:00 0:00 0:00
c0 > 0:80%(
1
d d d d d d d d
deduct 11% 1*8 (8( %%% %)5 718 750 0( 77
!,C4S!D A/!AS Per ,o !dge D 1 0.431 ( 0.753 % 1.162 7 1.659 2.242 5 2.913 ) 3.672 8 4.517 -ole 6ace 0.114 Col 6ace 0.040
0 0 0 0 0 0 0
#inal
,o
981
6
1487
8
1994
9
2534
11
3082
13
3631
15
4180
17
4729
19
5278
20
Spacing 1* (10 (7 (0 ( ( (50 (50 ()
Project
Spreadsheets to BS 8110
ocation
Colu$ns A1 D1 A D
C4/,!/ C4+M,
P+,C-.,G S-!A/ to BS8110(00
Made by r$&
3ob ,o /58
Date
%1'May'1)
4riginated 6ro$ /CC1%:;ls v7:* on CD
F (005'10 "CC
D!"A.!D CAC+A".4,S e=?t 1:(00 enhance$ent 6actor lin2 leg area 0:% -ole deduction H I!S C/.".CA P!/.M!"!/S Per ,o a .nternal !dge C !dge D Corner Choose 1 %0): %)50 ((80 (1%0 1(5 1(5 ( 751:( 7**0 (8* ()7 1)(: 1)(: % 51 5((0 %10 %%50 1880 1880 7 )58:) )70 71( %*) (18): (18): *((: 8580 7)70 7*0 (7* (7* 5 10)5:( **10 % (0 (80(: (80(: ) 1(%0 11170 *)0 8(0 %110 %110 8 1%8%:) 1(%)0 58 57% %71): %71): -ole 6ace ( 100 110 1000 )00 )00 Col 6ace 0 1%00 100 *00 50 50 !,C4S!D A/!AS Per ,o Corner 1 0.394 ( 0.613 % 0.878 7 1.191 1.551 5 1.958 ) 2.412 8 2.914 -ole 6ace 0.117 Col 6ace 0.100
., /!J+./!M!,"S Per ,o v Asv 1 1:5* 5)% ( 1:%% ()0 % 1:0*) ()0 7 0:*1( %1* 0:))7 %5) 5 0:555 71 ) 0:)8 757 8 0:05 1( -ole 6ace (:)7 Col 6ace
., P!/.M!"!/S Per ,o a .nternal !dge C !dge D 1 10(: (1(0 1750 1%10 ( (5:( %%0 (0) 1*( % 710 780 (5*0 (70 7 5%:) 810 %%0 %1 )1): )070 %*(0 %))0 5 8)1:( 8()0 7% 7%8 ) 10( *00 10 000 8 11)8:) 10)%0 )5 51 * 1%%(: 11*50 5%80 5(%0
(:*10
Corner Choose 8 8 115(: 115(: 17)0 17)0 1))): 1))): (08 (08 (%*(: (%*(: ()00 ()00 %00): %00): %%1 %%1
deduct (88 %*1 77) 7*8 7* 500 5( )0% 100 8%
#inal 977
1182
1433
1690
1946
2202
2458
2715 600 567
&ithin "otal ,o ocationBandH 1:0 d 13.4 1 (:( d 5.4 1 %:00 d 5.4 1 %:) d 6.3 1 7:0 d 0 0.0 0:00 d 0 0.0 0:00 d 0 0.0 0:00 d 0 0.0 c0 > 0:8585
deduct 1( (7 %) 7%0 781 %( 8% 5% 585
#inal
,o
703
6
908
8
1113
5
1348
6
1604
7
1860
8
2117
8
2373
9
2629
10
Spacing 170 1( () (5 (5 (5 %00 (* (*0
Project
Spreadsheets to BS 8110
ocation
An e;a$ple
/!'!,"/A," C4+M,
P+,C-.,G S-!A/ to BS8110(00
Made by r$&
4riginated 6ro$ /CC1%:;ls v7:* on CD
F (005'10 "CC
3ob ,o /58
Date
%1'May'1)
D!"A.!D CAC+A".4,S e=?t
1:(00
enhance$ent 6actor
C/.".CA P!/.M!"!/S Per ,o a 1 (85: ( 7(*:) % )% 7 )15:( 8*: 5 100(:) ) 1175 8 1(8*:( -ole 6ace 0 Col 6ace 0 ., /!J+./!M!,"S Per ,o v 1 ( % 7 5 ) 8 -ole 6ace Col 6ace
1:1)%8 0:*(0* 0:)78 0:5%)0 0:788 0:7801 0:7(7* 0:%)*7 (:%%8 (:%%8
., P!/.M!"!/S Per ,o a 1 *: ( (%8:) % %8( 7 (:( 558: 5 811:) ) * 8 10*8:( * 1(71:
.nternal %5*( 78%8 *87 )1%0 8()5 *7(( 1058 11)17 1700 1700
Corner %11* %*)8: 78%8 5*): 5) )715: 8()5 *1%: 1700 1700
Asv 7%( 7) 55( ))) 8*% 1008 11(% 1(%8
.nternal (157 %%10 775 50( 5)78 )8*7 *070 10185 11%%(
"otal ,o
5.50
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Corner 1*)% (8%(: %5*( 71: 711 5()0: )1%0 )*8*: 887*
lin2 leg area )8: -ole deduction H I!S !,C4S!D A/!AS #inal deduct Per ,o .nternal 5* 1 0:8( 2460 857 ( 1:75% 3115 105* 3769 % (:(%8 1()% 4424 7 %:1)) 17)8 5079 7:(81 158% 5734 5 :78 188) 6389 ) 5:*80 (0*( 7044 8 8:)5 (0 -ole 6ace 0:1(% 1150 (0 Col 6ace 1150
d d d d d d d d
deduct %85 *1 )*5 1000 1(0 1710 1517 181* (0(7
0.405
0.608
0.852
1.137
1.463
1.830
2.238
2.687
0.123 0.123
&ithin BandH
ocation 1:0 (:( 0:00 0:00 0:00 0:00 0:00 0:00
Corner
c0 > 0:*871
0 0 0 0 0 0 0 0
#inal
,o
1587
8
2241
10
2896
13
3551
15
4206
17
4861
19
5516
22
6171
24
6825
26
Spacing (( (7 (70 (0 (50 ()0 (50 (5 ()0
Disclaimer All a'vice or in,or%ation ,ro% MPA-7"e Concrete Centre is inten'e' ,or t"ose &"o &ill evaluate t"e si+ni,icance an' li%itations o, its contents an' ta#e resonsibility ,or its use an' alication. 6o liability /inclu'in+ t"at ,or ne+li+ence ,or any loss resultin+ ,ro% suc" a'vice or in,or%ation is accete' by MPA-7"e Concrete Centre or its subcontractors> suliers or a'visors. ?sers s"oul' note t"at all MPA-7"e Concrete Centre so,t&are an' ublications are subect to revision ,ro% ti%e to ti%e an' t"ey s"oul' t"ere,ore ensure t"at t"ey are in ossession o, t"e latest version. 7"is srea's"eet s"oul' be use' in co%liance &it" t"e acco%anyin+ ublication ?ser ;ui'e RC !rea's"eetsE v4 available ,ro% 7"e Concrete Centre &&&.concretecentre.co%8rc'esi+n 7el F44 /012) 000
Status of spreadsheet Public release version.
This spreadsheet is shareware but may not be used for commercial purposes until the user has registered with The Concrete Centre using the licence validation form available on The Concrete Centre website www.concretecentre.com/rcdesign
Revision history RCC13 unching Shear
Date
Version
Action
!ie /#@
10-May-12
RCC13 v4.9
Correction to 5no lin#s re(uire'5 state%ent &"en V bet&een Vc an' Vc0.
404
13-Jul-11
RCC13 v4.
!lab t"ic#ness $ 200%% allo&e' &"en no lin#s re(uire'.
43
20-Jun-11
RCC13 v4.)
*ailure %essa+es a''e' ,or slab t"ic#ness $ 200%%.
43
2-May-11
RCC13 v4.
arnin+s a''e' &"en certain entry cells le,t blan# /rat"er t"an ero.
433
21-*eb-11
RCC13 v4.
Correction to "ole 'euction on D;. ;eo%etry errors no& invali'ate results on B67R6AG an' D; a+es.
433
1-ct-10
RCC13 v4.4
Correction to lin# lateral sacin+ ,or re-entrant colu%ns.
44
21-!e-10
RCC13 v4.3
Correction to 'islay o, 56o lin#s re(uire'5.
43
23-Jun-10
RCC13 v4.2
B%rove%ent to nu%bers o, lin#s at eri%eters %ore t"an3' ,ro% colu%n ,ace.
42
2)-May-10
RCC13 v4.1
Correction to re'uction o, eri%eters ,or "oles at certain locations.
4)
30-Mar-10
RCC13 v4.0
Re-ba'+e' as 7CC8Mineral Pro'ucts Association.
49
-Jan-10
RCC13 v3.12
A'ust%ent to lin# sacin+ on B67R6AG an' D; a+es /nu%ber o, lin#s re(uire' unc"an+e'.
40
22-Ar-09
RCC13 v3.11
6o lin# solutions +iven &"en 'esi+n invali'.
41
2)-Au+-0
RCC13 v3.10
n"ance' &arnin+s /re' ,or%attin+ a''e' &"en v : 2vc.
4
-Au+-0
RCC13 v3.9
Colu%n ,ace s"ears correcte' on D; s"eet.
43
1-Jun-0
RCC13 v3.
Di,,erence bet&een vc &it" an' &it"out lin#s "i+"li+"te'.
431
2-May-0
RCC13 v3.)
C"an+e to 'erivation o, v%a< at colu%n ,ace.
430
21-May-0
RCC13 v3.
Main steel ercenta+e li%ite' to 3=.
41
11-*eb-0
RCC13 v3.
Correction to v%a< at 5'+e Dets5 21.
41
-Jan-0
RCC13 v3.4
Dislay o, vc correcte' &"en no lin#s re(uire'.
41
11-!e-0)
RCC13 v3.3
Correction to colu%n ,ace s"ear on D; a+e.
414
H
21-Au+-0
RCC13 v3.2
/4008' li%ite' to 0.) outsi'e lin# area.
414
2-Jun-0
RCC13 v3.1
v3 release. Pa+e nos> ?ser ;ui'e an' re+istration 'etails a%en'e'.
41)
21-ct-0
RCC13 v3.0
?'ate' to 200 versions o, @!110 @!
444
2-Ar-04
RCC13 v2.
Correction to eri%eter 'e'uction ,or lar+e "oles.
412
-Au+-03
RCC13 v2.
?'ate' to May 2002 a%en'%ent to @! 110 ,or%ulae ,or vc.
409
14-Mar-03
RCC13 v2.4
Correction to "ole 'e'uctions on R67RA67 s"eet.
40
1-*eb-03
RCC13 v2.3
Correction to "ole 'e'uctions on D; s"eet.
41)
21-Jan-03
RCC13 v2.2
D7R lo+o relace' by D7B.
402
3-Dec-02
RCC13 v2.1
*i< ,or error &"en no "oles.
421
11-ct-02
RCC13 v2.0
Version 2 en"ance%ents
421
2)-*eb-02
RCC13 V1.3
Colu%n ,ace eri%eter c"an+e' on 5'etail5 s"eets.
404
1-*eb-02
RCC13 V1.2
B%rove' routine ,or eri%eter re'uction 'ue to a'acent "oles.
40)
1)-Au+-00
RCC13 v1.1
Re' &arnin+ i, B67R6AGEM14 ne+ative.
310
3-Au+-99
RCC13 v1.0
*irst ublic release. Bnclu'es b version co%%ents
309
