© 2000 Chris Buczkowski
REINFORCED CONCRETE WOR FOR MICROSOFT EXCEL
CONTENTS Areas of Reinforcement
Minimum and Maximum Reinforce
Spacing of Longitudinal Bars
Columns Beams Slabs Walls
Links in Beams Mesh Reinforcement Ultimate Anchorage and Laps Anchorage bond stress design
Notes
Bends and Hooks
About
Minimum radius of bends
Registration details
THIS IS AN UN
Other spreadsheets: BAR SCHEDULE FOR EXCEL 97 Bar Schedule for Excel 97 is a spreadsheet for the scheduling of steel for the reinforcement of concrete. The spreadsheet has been developed to comply with BS 4466 : 1989 and Amendment No. 1 published published 28 February February 1990. The aim of the spreadsheet is to reduce the time taken to produce a bar schedule, reduce arithmetical errors, reduce scheduling errors, increase compliance with the BSI specified format for bar scheduling and, eventually, become the basis for electronic data interchange. The latest version of Bar Schedule may be downloaded from : http://www.structural-engineering.fsnet.co.uk
Other spreadsheets: WIND DESIGN WORKBOOK This spreadsheet implements the full Standard Method of calculating wind loads for buildings in accordance with BS 6399 : Part 2 : 1997. This method is suitable for buildings up to 100m high. The workbook contains spreadsheets which can be printed as complete calculation pages. It also contains spreadsheets which can be used as design aids, useful for hand calculations or checking designs. For Engineers new to the code, the spreadsheet can prove an invaluable teaching aid.
FREE SP REINFOR An interactive sheet for det det c
ISS A must for every offi document/drawing issue s your co The latest versions http://www.structur
The latest version of W ind Design Workbook may be downloaded from : http://www.structural-engineering.fsnet.co.uk
BOOK Version 1.0
ent
Click on a item
EGISTERED COPY
EADSHEETS !! EMENT AREAS rmining areas of reinforcement for oncrete.
E SHEET e, a simple but presentable heet that can be customised with pany's name. may be downloaded from : al-engineering.fsnet.co.uk
Steel Reinforcement Areas Cross sectional area of number of bars (mm²) Bar Size (mm)
Number of Bars 1
2
3
4
5
6
7
8
9
6
28
57
85
113
141
170
198
226
254
8
50
101
151
201
251
302
352
402
452
10
79
157
236
314
393
471
550
628
707
12
113
226
339
452
565
679
792
905
1018
16
201
402
603
804
1005
1206
1407
1608
1810
20
314
628
942
1257
1571
1885
2199
2513
2827
25
491
982
1473
1963
2454
2945
3436
3927
4418
32
804
1608
2413
3217
4021
4825
5630
6434
7238
40
1257
2513
3770
5027
6283
7540
8796
10053
11310
50
1963
3927
5890
7854
9817
11781
13744
15708
17671
225
250
Cross sectional area of bars per metre (mm²/m) Bar Size (mm)
Bar Spacing (mm) 50
75
100
125
150
175
200
6
565
377
283
226
188
162
141
126
113
8
1005
670
503
402
335
287
251
223
201
10
1571
1047
785
628
524
449
393
349
314
12
2262
1508
1131
905
754
646
565
503
452
16
4021
2681
2011
1608
1340
1149
1005
894
804
20
6283
4189
3142
2513
2094
1795
1571
1396
1257
25
9817
6545
4909
3927
3272
2805
2454
2182
1963
10723
8042
6434
5362
4596
4021
3574
3217
40
12566
10053
8378
7181
6283
5585
5027
50
19635
15708
13090
11220
9817
8727
7854
32
Cross sectional area of bars in pairs per metre (mm²/m) Bar Size (mm)
Bar Spacing (mm) 50
75
100
125
150
175
200
225
250
6
1131
754
565
452
377
323
283
251
226
8
2011
1340
1005
804
670
574
503
447
402
10
3142
2094
1571
1257
1047
898
785
698
628
12
4524
3016
2262
1810
1508
1293
1131
1005
905
16
5362
4021
3217
2681
2298
2011
1787
1608
20
8378
6283
5027
4189
3590
3142
2793
2513
9817
7854
6545
5610
4909
4363
3927
12868
10723
9191
8042
7149
6434
16755
14362
12566
11170
10053
2094
1795
1571
1396
1257
25 32 40 16 12
6283
4189
3142
2513
Home Enter area (mm²):
10
11
0
12
283
311
339
503
553
603
785
864
942
1131
1244
1357
2011
2212
2413
3142
3456
3770
4909
5400
5890
8042
8847
9651
12566
13823
15080
19635
21598
23562
Enter area (mm²):
275
300
2000
400
103
94
71
183
168
126
286
262
196
411
377
283
731
670
503
1142
1047
785
1785
1636
1227
2925
2681
2011
4570
4189
3142
7140
6545
4909
Enter area (mm²):
275
300
1200
400
206
188
141
366
335
251
571
524
393
823
754
565
1462
1340
1005
2285
2094
1571
3570
3272
2454
5849
5362
4021
9139
8378
6283
1142
1047
785
Spacing of Longitudinal Bars Maximum distance between bars in tension Table 3.28
Beams Slabs
Clear horizontal distance between bars according to % redistribution (mm) ƒy
gm
N/mm²
steel 1.05 1.05
460 460
cl 3.12.11.2.4
As req
As prov
mm²
mm²
300
300
% red +/0 0
ßb 1 1
ƒy
clear distance 152 484
Clear distance between bars in tension ƒy ßb gm % red N/mm² steel +/250 1.15 0 1
N/mm²
(mm)
460
200
no
N/mm²
clear distance
156
300
ƒs
Minimum clear distance between bars Minimum distance between vertically spaced bars
Minimum distance between horizontally spaced bars
mm
bar size aggregate size spacer bar size
25 20 14
Slabs h
mm
bar size aggregate size minimum distance
16 20 25
Home
Clear spacing between bars As 100As/bd d (mm)
(mm²/m)
175 550 0.31 further check required!
clear distance 525
Note: For slabs, if % redistribution is not known, use 15% for supports and 0% for spans.
Reinforcement Links in Beams General Use Minimum shear links in beams bv
d
ƒyv
mm
mm
N/mm²
steel
400
250
1.05
Asv
sv
mm
500 no. of legs
mm²
mm
10
2
157
225
mm
375
400
bar size
m
max sv = 0.75d
Link reinforcement in beams, Asv/sv (mm²/mm) Bar Size (mm)
Minim
Asv =Total area of legs (mm²) s v =Spacing of links (mm)
bv
no. of legs =
2
Spacing of Links (mm) 50
75
100
125
150
175
200
225
250
6
1.13
0.75
0.57
0.45
0.38
0.32
0.28
0.25
0.23
8
2.01
1.34
1.01
0.80
0.67
0.57
0.50
0.45
0.40
10
3.14
2.09
1.57
1.26
1.05
0.90
0.79
0.70
0.63
12
4.52
3.02
2.26
1.81
1.51
1.29
1.13
1.01
0.90
16
8.04
5.36
4.02
3.22
2.68
2.30
2.01
1.79
1.61
Lateral spacing of equally s aced le s beam breadth, b v (mm) effective depth, d (mm) side cover (mm) link bar size (mm) no. of legs leg spacing (mm) Leg spacing OK
400 350 30 10 3 165
Lateral spacing of legs No tension bar to be more tha Each alternate compression b No compression bar to be furt restrained bar.
Special Situations Minimum links for compression reinforcement compression reinforcement ? NO bar sizes (mm) max spacing smallest largest link 7 190 16 25
Laps with limited cover Are both lapped bars NO greater than 20mm ? cover bar sizes (mm) max (mm) smallest spacing link 25 32 8 200
Home
um shear links, Asv/sv ƒyv
m
Asv/sv
N/mm²
steel
250
1.05
0.67
Enter Asv/sv :
0.74
275
400
300
0.21
0.19
0.14
0.37
0.34
0.25
0.57
0.52
0.39
0.82
0.75
0.57
1.46
1.34
1.01
n 150mm from a leg. ar to be supported by a leg. er than 150mm from a
Ultimate Anchorage and Lap Lengths General Use Anchor
Tension lap factors Bar
Bar size
Clear
location
(mm)
distance
top
25
125
btm
25
100
Factor
Cover
side
top/btm
corner
ƒcu N/mm²
30
2
2
35
40
1.4
1.4
m
steel 1.05
Tension anchorage &
40
1.4 x tension lap 2.0 x tension lap Compression anchora
Equivalent diameters for pairs of bars (mm) Bars
Bar size (mm)
1st bar
12
2nd bar
10
Compression lap leng
Equivalent diameter
Anchorage and
15.6
ƒcu N/mm²
steel
35
1.05
m
Tension anchorage & 1.4 x tension lap 2.0 x tension lap
Note: Minimum laps are 15 x bar size or 300mm, whichever is the greater. For fabric, minimum lap is 250mm.
Compression anchora Compression lap leng
Special Situations Anchorage and lap lengths (mm)
Anchor
in beams where minimum links have not been provided
ƒcu Bar size m mm N/mm² steel 35 1.05 12 Tension anchorage & lap length 1.4 x tension lap 2.0 x tension lap Compression anchorage length Compression lap length
ƒcu m N/mm² steel 35 1.05 Tension anchorage & 1.4 x tension lap 2.0 x tension lap Compression anchora Compression lap leng As required (mm²)
Reinforcement type
250 432 604 863 345 432
460 794 1111 1587 635 794
Anchorage bond stress design Ultimate anchorage bond stress bond coefficient, ß 0.5
Table 3.26 Val Bar type
strength of concrete, ƒ cu Ultimate bond stress, ƒ bu
35 2.96
Design anchorage bond stress Strength of reinforcement 460 safety factor for steel, gm 1.05 As required (mm²)
208
As provided (mm²)
226
Force F s (kN) Anchorage length, l (mm) effective bar size, ø e (mm)
81.1 600 16
bond stress, ƒ b (N/mm²)
2.69
Plain bars Bars in beams where minimum links have not been provided Type 2: deformed bars Fabric
Home
Bars
age and lap lengths (mm) Bar size mm 12
Reinforcement type
Cover 6
15
8
20
10
25
250
460
Fabric
12
30
432
445
342
16
35
604
623
479
20
40
863
889
684
25
45
ge length
345
353
275
32
50
th
432
441
343
40
55
50
60
lap length
lap lengths as multiple of bar size Bar size mm any lap length
ge length th
Reinforcement type 250
460
Fabric
36
38
29
51
52
40
72
75
57
29 36
30 37
23 29
ge and lap lengths (mm) for bars not at full stress
Bar size mm 16 lap length
ge length th 750
Reinforcement type 250 460 432 445 604 623 863 889 345 353 432 441 As provided (mm²)
ues of bond coefficient ß bond coefficient, ß
Fabric 342 479 684 275 343 1000
bars in tension
bars in compresssion
0.28
0.35
0.28
0.35
0.5 0.65
0.63 0.81
Bends and Hooks bar size d 6 8 10 12 16 20 25 32 40 50
bar size d 6 8 10 12 16 20 25 32 40 50
Minimum former radii, bend and Grade 250 bars r n h 12 100 100 16 100 100 20 100 100 24 100 110 32 100 150 40 100 180 50 130 230 64 160 290 80 200 360 100 250 450
Bends Grade 250 bars y x 94 112 93 117 91 121 89 125 85 133 81 141 107 182 130 226 163 283 204 354
hook allowances Grade 460 bars r n 18 100 24 100 30 100 36 100 48 100 60 110 100 180 128 230 160 280 200 350
Grade 460 bars y x 91 115 88 120 85 125 82 130 76 140 80 160 128 253 164 324 197 397 247 497
bar size d 6 8 10 12 16 20 25 32 40 50
Designed Bends bar size mm 32
Minimum radius of bends, r ab ƒy ƒcu m N/mm² N/mm² mm 75 250 1.05 30
h 100 100 110 140 180 220 350 450 560 700
r mm 185
y1 71 61 52 52 72 83 109 135 166 208
Grade 250 ba x1 89 85 82 88 120 143 184 231 286 358
Home
Enter grade and bar size: 460 bar size 16 (mm)
reinforcement grade
Hooks rs u 36 48 60 72 96 120 150 192 240 300
y1 58 44 40 56 68 80 122 158 195 244
Grade 460 bars x1 82 76 80 104 132 160 247 318 395 494
u 48 64 80 96 128 160 250 320 400 500
Minimum and Maximum Reinforcement Columns
Beams
Areas of reinforcement for rectangular columns (mm²) width, b (mm) 300 Number Minimum depth, h (mm) 300 of bars bar size Minimum 360 4 11
Areas for recta width, b (mm) depth, h (mm) Minimum, (ƒy=250)
Maximum Maximum at laps
Minimum, (ƒy=460) Maximum tension Max. compression
5400 9000
6 8
34 38
Links in columns bar sizes (mm) smallest largest link 7 16 25
max spacing 190
Side reinforce breadth ƒy b N/mm² 300 460
Laps with limited cover Are both lapped bars greater than 20mm ? cover (mm) 25
bar sizes (mm) smallest link 32 8
NO
Slabs
max spacing 200
Minimum areas of width, b (mm) depth, h (mm) Minimum (ƒy=250) Minimum (ƒy=460)
Walls Areas of vertical reinforcement (mm²/m) bar size Spacing thickness, h (mm) 250 (mm) (mm) Minimum 1000 10 150 Maximum 10000 25 75
Minimum areas of horizontal reinforcement thickness, h (mm) 250 bar size Spacing vertical bar size 25 (mm) (mm) Minimum (ƒy=250) 750 8 125 Minimum (ƒy=460)
625
10
250
Home
of reinforcement gular beams (mm²) 300 bar size 500 (mm) 360 10 300 6000 6000
12 32 32
Number of bars 5 3 8 8
ent in beams bar size Spacing (mm) (mm) 16 250
einforcement for slabs (mm²) 1000 bar size Spacing 225 (mm) (mm) 540 10 125 293
10
250
Reinforcing Fabric BS4483 Fabric
Mesh size nominal pitch of wires Main Cross mm
mm
Diameter of wire Main
Cross
mm
mm
Cross section area Nominal per metre width mass Main Cross mm²
mm²
kg/m²
Square mesh A393
200
200
10
10
393
393
6.16
A252
200
200
8
8
252
252
3.95
A193
200
200
7
7
193
193
3.02
A142
200
200
6
6
142
142
2.22
A98
200
200
5
5
98
98
1.54
B1131
100
200
12
8
1131
252
10.9
B785
100
200
10
8
785
252
8.14
B503
100
200
8
8
503
252
5.93
B385
100
200
7
7
385
193
4.53
B283
100
200
6
7
283
193
3.73
B196
100
200
5
7
196
193
3.05
C785
100
400
10
6
785
70.8
6.72
C636
100
400
9
6
636
70.8
5.55
C503
100
400
8
5
503
49
4.34
C385
100
400
7
5
385
49
3.41
C283
100
400
6
5
283
49
2.61
D98
200
200
5
5
98
98
1.54
D49
100
100
2.5
2.5
49
49
0.77
Structural mesh
Long mesh
Wrapping mesh
Home No. of sheets per tonne
15 22 22 40 57 8 11 15 20 24 29 13 16 21 26 34 57 113
NOTES FOREWORD This spreadsheet is intended for use by reinforced concrete detailers and designers. It pr to rapidly determine answers to the many questions that reinforced concrete design and could be looked on as an electronic book with an index followed by pages containing ma calculator has a specific task to perform. The Reinforced Concrete Workbook also acts a user of the various requirements to be observed. The concept of the workbook is that each table remains independent of the others. No ca tables. This increases the amount of input but should speed usage as the user does not outside of the table they are using.
SETUP This spreadsheet has been formatted using Arial, Arial Black, Symbol and Tahoma truety been optimised for a screen resolution of 1027x768 HiColor (16 bit) using large fonts. Use the Zoom button on the toolbar to reduce or enlarge the display to suit your compute permanently store your new settings. Recommended zoom settings are as follows: Screen resolution 800x600 with large fonts: 67% Screen resolution 800x600 with small fonts: 85% Screen resolution 1024x768 with large fonts: 85% Screen resolution 1024x768 with small fonts: 105%
KEY INFORMATION Microsoft Excel This spreadsheet has been developed for use in Microsoft Excel 97 (v8.0) on the Micros system. British Standard Specification (BSI) This spreadsheet has been developed to comply with BS 8110 : Part 1 : 1997 and BS 44 published 28 February 1990. Support Registered users may obtain support for this spreadsheet from:
[email protected] Additional Information Refer to the accompanying README.TXT file for additional information. USING REINFORCED CONCRETE WORKBOOK The following colour key is a guide to using the full calculation page spreadsheets. Input required. Computed output
24
Remove value Error/ Alert
Message
Clear cell contents To clear the contents of a cell, right click your mouse on the cell and then click Clear Con
m
STEEL
This is the partial safety factor for strength of materials for steel reinforcement. The sprea following options to suit their particular requirements. gm = 1.15 BS 8110 : Part 1 : 1985
BS 8110 : Part 1 : 1997
gm
= 1.05
SHORT CUTS Entering Numerical Data Expressions may be entered in place of numbers in cells requiring numerical input. e.g. the relevant cell. Enter the following: =4+8*3 - This expression evaluates to 28. You wi double click on the cell or if you have the formula bar showing (go to View menu and clic
Home ovides the user with the means etailing raise. This spreadsheet y individual calculators. Each s an aide memoir, reminding the lculations are linked to other ave to search for input cells
pe fonts. The spreadsheet has
r. Use the Save button to
ft Windows 95 operating
6 : 1989 and Amendment No. 1
tents.
dsheet user is provided with the
o enter an expression, select ill see the expression if you Formula Bar).
REINFORCED CONCRETE WORK FOR MICROSOFT EXCEL Version Version 1.0 Please ensure you have the latest version of this software, which may be downloaded from the internet via this hyperlink : http://www.structural-engineering.fsnet.co.uk Click the Connect button to go to the web site. If you have comments, suggestions, bug reports or require information, please email:
Copyright
[email protected]
© 2000 Chris Buczkowski. All rights reserved.
Registration
¤ UNREGISTERED COPY F
Single User Licence:
£20
Company multiple-user licence:
£20 per copy installed
Delivery will be by attachment to an email. To order a registered copy, please send a cheque payable to 'C. Buczkowski' to the following address: 6 Stanhope Court, 53-55 Stanhope Road, North Finchley, LONDON N12 9DZ (Tel/fax : 020-8445 9438) You should include your e-mail and postal address and a contact telephone number. Also include the name you require the spreadsheet registered to (30 characters maximu
Licence for Use and Distribution This spreadsheet is NOT a public domain program. It is copyrighted by the Author*. Thi Kingdom copyright law and also by international treaty provisions. The Author grants you evaluation purposes for an indefinite period. You may not use, copy, rent, lease, sel disassemble, otherwise reverse engineer, or transfer this software except as provid unauthorised use shall result in immediate and automatic termination of this licence. All are reserved to the Author. You may copy and distribute the unregistered version unaltered, without further permission. The readme.txt file must accompany copies of the * The Author is Chris Buczkowski.
Disclaimer THIS SOFTWARE IS PROVIDED FOR EVALUATION ONLY, ON AN "AS IS" BASIS. THE AUTH RELATING TO THIS SOFTWARE, WHETHER EXPRESSED OR IMPLIED, INCLUDING BUT WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. THE FOR ANY INDIRECT, CONSEQUENTIAL, OR INCIDENTAL DAMAGES ARISING OUT OF THE SOFT WARE, EVEN IF T HE AUT HOR HAS BEEN ADVISED OF T HE POSSIBILIT Y OF SU PERSON USING THE SOFTW ARE BEARS ALL RISK AS TO THE QUALITY AND PERF ALTHOUGH EVERY EFFORT HAS BEEN MADE TO ENSURE THE ACCURACY OF THIS PR THE RESULTS FOR THEMSELVES.
Acknowledgements Thank you to Dr Shaiq U.R. Khan BEng (Civil), MEng, PhD, PE, CEng, FIStructE for his during the development of this software. He may be contacted by email on shaiq@techn
OOK Home
R EVALUATION ¤
).
software is protected by United a licence to use this software for l, modify, decompile, unprotect, d in this agreement. Any such ights not expressly granted here of this spreadsheet, completely preadsheet.
R DISCLAIMS ALL WARRANTIES NOT LIMITED TO ANY IMPLIED UTHOR* SHALL NOT BE LIABLE USE OR INABILITY TO USE SUCH H DAMAGES OR CLAIMS. THE RM ANCE OF T HE SOFT WARE. GRAM, USERS SHOULD VERIFY
ncouragement and comments uk.com