Project Spreadsheets to EC2 The Concrete Centre

Client Advisory Group Made by Date Page

Location Cores at level 1 DISTRIBUTION OF MOMENTS rmw 08-Feb-2017 201
SHEAR WALL LOAD DISTRIBUTION to BS EN 1992-1: 2004 Checked Revision Job No
Originated from TCC63.xls Version 4.0 on CD 2003 - 2017 TCC chg - FB625

BUILDING DIMENSIONS
Length, L (m) = 35.25
Width, W (m) = 22.1

CORE LOCATIONS
x1 (m) = 2
y1 (m) = 2.5
x2 (m) = 5.25
y2 (m) = 18.2
x3 (m) = 25.34
y3 (m) = 3.75
x4 (m) = 29.85
y4 (m) = 17.2

CORE DIMENSIONS (mm)
Core 1 Core 2 Core 3 Core 4
overall, B&D 2400 3600 3600 1800 3600 1800 2400 3600
opening 1, a1 & b1 200 250 300 250 250 300 0
opening 2, a2 & b2 1300 250 250 850 300 1400
opening 3, a3 & b3 2500 250 250 2750
opening 1, c1 & d1 1900 900 3000 1550 600 1350 1000 3000
opening 2, c2 & d2 2150 1000 1900 1550 1000 3000
opening 3, c3 & d3 1900 900 600 1300

CORE PROPERTIES
X bar mm 1112.5 1800.0 1819.3 1200.0
Y bar mm 1800.0 1217.6 700.3 1800.0
Ixx m 4
4.398 0.561 0.803 4.831
Iyy m 4
2.233 3.511 3.580 0.707

DISTRIBUTION OF LATERAL MOMENTS
Torsional eccentricities ex = -259.5 mm
ey = 408.5 mm

Proportions of lateral M
Core 1 Core 2 Core 3 Core 4
NS M from stiffness 41.52% 5.30% 7.58% 45.60%
NS M from torsion 0.87% 0.08% -0.10% -0.85%
NS total 42.39% 5.38% 7.48% 44.75%
EW M from stiffness 22.26% 35.00% 35.69% 7.05% 4

EW M from torsion -1.11% 2.34% -1.69% 0.47%

EW total 21.15% 37.34% 34.00% 7.52%
 Project Spreadsheets to EC2 The Concrete Centre
Client Advisory Group Made by Date Page
Location Cores at level 1 CORE STRESS DISTRIBUTION rmw 08-Feb-2017 202
SHEAR WALL LOAD DISTRIBUTION to BS EN 1992-1: 2004 Checked Revision Job No

Originated from TCC63.xls Version 4.0 on CD 2003 - 2017 TCC chg - FB625

ACTIONS (characteristic) CORE No 1 Area Centroid Inertia

x 1112 4.398
3.07
Total NS wind M = 12000 kNm Mxx = 5086.76 kNm y 1800 2.233
Total EW wind M = 7520 kNm Myy = 1590.25 kNm
fck = 30 MPa
(locations relative to bottm left corner of core)
VERTICAL LOADS 0 = 0.7 fyk = 500 MPa
x y Dead Imposed 2 = 0.3 eel class B
Load 1 125 1800 637.5 153 mm & kN
Load 2 2275 650 285 76.5 mm & kN
Load 3 1200 100 202 20 mm & kN
Load 4 1200 1200 202 20 mm & kN Combinations considered
Load 5 1200 2400 202 20 mm & k 1/2 1.25Gk + 1.5Qk + 0.5Wk 1.25Gk + 1.05Qk + 1.5Wk
Load 6 1200 3500 202 20 mm & k 3/4 1.0Gk + 1.5Qk + 0.5Wk 1.0Gk + 1.05Qk + 1.5Wk
Load 7 2275 2950 285 76.5 mm & k 5/6 1.35Gk + 1.05Qk + 0.5Wk 1.0Gk + 0.3Qk + 1.5Wk
Load 8 mm & kN

ULS VERTICAL LOADS

Comb 1 Comb 2 Comb 3 Comb 4 Comb 5 Comb 6
Load 1 1025.6 956.7 867.0 798.2 1021.3 683.4
Load 2 470.6 436.2 399.8 365.3 465.1 308.0
Load 3 282.2 273.2 232.0 223.0 293.7 208.0
Load 4 282.2 273.2 232.0 223.0 293.7 208.0
Load 5 282.2 273.2 232.0 223.0 293.7 208.0
Load 6 282.2 273.2 232.0 223.0 293.7 208.0
Load 7 470.6 436.2 399.8 365.3 465.1 308.0
Load 8 0.0 0.0 0.0 0.0 0.0 0.0 LOCATIONS of loads & stress checks

CORE STRESSES (gross - ignoring reinforcement)

CHECK STRESSES at locations relative to bottm left corner of core Compessive Tensile
x y Wall b Comprn Tension As req 5.181 3.674 3.738 5.545
mm mm mm MPa max MPa max mm2/m
Location 1 125 360 250 4.510 2.855 1642
Location 2 125 3240 250 4.510 2.855 1642
Location 3 240 3500 200 4.847 3.177 1462
Location 4 2160 3500 200 5.176 3.266 1503
Location 5 2275 3240 250 4.856 2.932 1686
Location 6 2160 100 200 5.176 3.266 1503
Location 7 1680 2400 200 2.719 0.870 400
Location 8 1680 3500 200 4.627 2.778 1278
.
REINFORCEMENT 5.181 3.674 3.738 5.545
Critical Bar Spacing As prov = Min horiz MAX STRESSES AT PERIMETER (MPa)
in mm mm, EF mm /m 2
% steel
Location 1 tension 16 240 1676 0.670 B10 @ 375
Location 2 tension 16 240 1676 0.670 B10 @ 375 Max spacing ok
Location 3 tension 16 275 1462 0.731 B8 @ 275
Location 4 tension 16 265 1517 0.759 B8 @ 250 Min spacing ok
Location 5 tension 16 235 1711 0.684 B10 @ 350
Location 6 tension 16 265 1517 0.759 B8 @ 250 Max steel ok
Location 7 tension 8 250 402 0.201 B8 @ 500 If walls are slender or have out-of-plane
Location 8 tension 16 310 1297 0.649 B8 @ 300 moments, use with TCC53.
Coordinates used in diagrams
LOCAL CORE PLANS
Core 1 0 3600 x scaling
0 2400 y scaling
x 0 0 2400 2400 0 250 250 2150
y 0 3600 3600 0 0 200 1100 1100
Core 2 0 1800 x scaling
0 3600 y scaling
x 0 0 3600 3600 0 300 300 3300
y 0 1800 1800 0 0 0 1550 1550
Core 3 0 1800 x scaling
0 3600 y scaling
x 0 0 3600 3600 0 250 250 850
y 0 1800 1800 0 0 250 1600 1600
Core 4 0 3600 x scaling
0 2400 y scaling
x 0 0 2400 2400 0 0 0 1000
y 0 3600 3600 0 0 300 3300 3300
NS GRIDS
x 1112.5 1112.5 1800 1800 1819.3 1819.3
y 0 3600 0 1800 0 1800
EW GRIDS
x 0 2400 0 3600 0 3600
y 1800 1800 1217.6 1217.6 700.32 700.32
GLOBAL PLAN
0 22100 x scaling
0 35250 y scaling
x 0 0 35250 35250 0
y 0 22100 22100 0 0
Core 1 2000 2000 4400 4400 2000 2250 2250 4150
2500 6100 6100 2500 2500 2700 3600 3600
Core 2 5250 5250 8850 8850 5250 5550 5550 8550
18200 20000 20000 18200 18200 18200 19750 19750
Core 3 25340 25340 28940 28940 25340 25590 25590 26190
3750 5550 5550 3750 3750 4000 5350 5350
Core 4 29850 29850 32250 32250 29850 29850 29850 30850
17200 20800 20800 17200 17200 17500 20500 20500
NS GRIDS
x 3112.5 3112.5 7050 7050 27159 27159
y 1500 7100 17200 21000 2750 6550
EW GRIDS
x 1000 5400 4250 9850 24340 29940
y 4300 4300 19100 19100 4650 4650
SHEAR CENTRE
x 17885 17885 15385 20385
y 8141.5 13141 10641 10641
SELETED CORE
0 3600 x scaling
0 2400 y scaling
x 0 0 2400 2400 0 250 250 2150
y 0 3600 3600 0 0 200 1100 1100
VERTICAL LOADS
1112 1112
0 3600 -554.5 4155 0 4155
0 2400 -518.1 2955 0 2955
1800 1800
STRESSES LEFT scaling factor 100
Comp 0 -518.1 -486.8 -455.6 -424.4 -393.2 -361.9 -330.7
Tens 0 367.36 336.13 304.91 273.68 242.45 211.23 180
y 0 0 180 360 540 720 900 1080
STRESSES RIGHT
Comp 2400 2955 2923 2892 2861 2830 2798 2767
Tens 2400 2026 2057 2089 2120 2151 2182 2214
STRESSES TOP
Comp 3600 4118 4106 4094 4082 4070 4058 4046
Tens 3600 3233 3246 3260 3273 3286 3300 3313
x 0 0 120 240 360 480 600 720
STRESSES BTM
Comp 0 -518.1 -506.1 -494.2 -482.3 -470.3 -458.4 -446.5
Tens 0 367.36 353.93 340.5 327.07 313.63 300.2 286.77
CHECK LOCATIONS
125 125 240 2160 2275 2160 1680 1680
360 3240 3500 3500 3240 100 2400 3500
2150 250 250 250 2400 2400 250 250
200 200 1300 2300 2300 1300 1300 2500

3300 300 0 0 0 0 0 0
0 0 0 0 0 0 0 0

850 250 850 850 2750 2750 850 2750

250 250 250 1800 1800 250 250 250

1000 0 1400 1400 2400 2400 1400 0

300 300 300 3300 3300 300 300 0

1200 1200
0 3600

0 2400
1800 1800

4150 2250 2250 2250 4400 4400 2250 2250

2700 2700 3800 4800 4800 3800 3800 5000
8550 5550 5250 5250 5250 5250 5250 5250
18200 18200 18200 18200 18200 18200 18200 18200
26190 25590 26190 26190 28090 28090 26190 28090
4000 4000 4000 5550 5550 4000 4000 4000
30850 29850 31250 31250 32250 32250 31250 29850
17500 17500 17500 20500 20500 17500 17500 17200
31050 31050 17625 17625
16200 21800 0 22100

28850 33250 0 35250

19000 19000 11050 11050

2150 250 250 250 2400 2400 250 250

200 200 1300 2300 2300 1300 1300 2500

-299.5 -268.2 -237 -205.8 -237 -268.2 -299.5 -330.7 -361.9 -393.2
148.77 117.55 86.319 55.092 86.319 117.55 148.77 180 211.23 242.45
1260 1440 1620 1800 1980 2160 2340 2520 2700 2880

2736 2705 2673 2642 2673 2705 2736 2767 2798 2830
2245 2276 2307 2338 2307 2276 2245 2214 2182 2151

4035 4023 4011 4017 4031 4045 4059 4072 4086 4100
3327 3340 3354 3348 3336 3324 3312 3299 3287 3275
840 960 1080 1200 1320 1440 1560 1680 1800 1920

-434.5 -422.6 -410.7 -417.5 -431.2 -444.9 -458.6 -472.3 -486 -499.7
273.34 259.91 246.48 251.75 264 276.16 288.37 300.57 312.78 325
250 2150 2150 250
3400 3400 2500 2500

0 0 0 0
0 0 0 0

2750 3350 3350 2750

1550 1550 250 250

0 0 0 0
0 0 0 0

2250 4150 4150 2250

5900 5900 5000 5000
5250 5250 5250 5250
18200 18200 18200 18200
28090 28690 28690 28090
5300 5300 4000 4000
29850 29850 29850 29850
17200 17200 17200 17200
 250 2150 2150 250
3400 3400 2500 2500

-424.4 -455.6 -486.8 -518.1 0

273.68 304.91 336.13 367.36
3060 3240 3420 3600 3600

2861 2892 2923 2955 2400

2120 2089 2057 2026

4113 4127 4141 4155 3600

3263 3251 3238 3226
2040 2160 2280 2400 2400

-513.4 -527.1 -540.8 -554.5 0

337.19 349.4 361.6 373.81
National Annex values
EC2 Ref Function Value
Table 2.2 c 1.5 concrete
Table 2.2 s 1.15 steel TABLE A1.1 EN1990 0 1 2
3.1.6 (1)P cc 0.85 strength factor - flexure Crowds 0.7 0.7 0.6
9.6.2 (1) As,vmin 0.002 min vertical steel Dwelling 0.7 0.5 0.3
9.6.2 (1) As,vmax 0.04 max vertical steel Office 0.7 0.5 0.3
9.6.3 (1) As,hmin 0.001 min horizontal steel Roofs 0 0 0
9.6.3 (1) As,hmin 25% min horizontal steel Shopping 0.7 0.7 0.6
EN 1990 G,sup 1.35 dead load factor Snow 0.5 0.2 0
EN 1990 G,inf 1 dead load factor Storage 1 0.9 0.8
EN 1990 Q 1.5 imposed load factor Traffic, 30 to 160kN 0.7 0.5 0.3
EN 1990 0.925 Gk modification factor Traffic<=30kN 0.7 0.7 0.6
Wind 0.5 0.2 0
Disclaimer
All advice or information from MPA-The Concrete Centre is intended for those who will evaluate the significance and limitations of
its contents and take responsibility for its use and application. No liability (including that for negligence) for any loss resulting from
such advice or information is accepted by MPA-The Concrete Centre or its subcontractors, suppliers or advisors. Users should
note that all MPA-The Concrete Centre software and publications are subject to revision from time to time and they should
therefore ensure that they are in possession of the latest version.

This spreadsheet should be used in compliance with the accompanying publication 'User Guide RC Spreadsheets: v4' available
from The Concrete Centre www.concretecentre.com/rcdesign Tel +44 (0)1276 606800

Status of spreadsheet 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
Public release version on The Concrete Centre website www.concretecentre.com/rcdesign

Revision history TCC63 Core Wall Design

Date Version Action Size (kB)
25-Mar-10 TCC63 v 4.0 Updated to revised UK National Annex 688
8-Jun-09 TCC63 v2 Correction to distribution of lateral loads from global torsion. 682
20-Dec-07 TCC63 v1 First beta release. 645