Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

SPREADSHEETS FOR CONCRETE DESIGN TO BS 8110 and EC2 User Guide to Excel spreads

SPREADSHEETS FOR CONCRETE DESIGN TO BS 8110 and EC2 User Guide to Excel spreadsheet files for contemporary reinforced concrete design to BS 8110: Part 1, 1997 and EC2 (ENV 1992) with commentary C H Goodchild BSc, CEng, MCIOB, MIStructE R M Webster CEng, FIStructE NB This version of the User Guide may have been superseded by the publication Spreadsheets for concrete design to BS 8110 and EC2 and by the file UserGuid.pdf Foreword This publication was produced by the Reinforced Concrete Council (RCC) as part of its project 'Spreadsheets for concrete design to BS 8110 and EC2'. This project was jointly funded by the RCC and the Department of the Environment, Transport and the Regions (DETR) under its Partners in Technology scheme and was made possible by members of industry with their contributions in kind. The RCC was set up to promote better knowledge and understanding of reinforced concrete design and building technology. Its members are Allied Steel & Wire, representing the major suppliers of reinforcing steel in the UK, and the British Cement Association, representing the major manufacturers of Portland cement in the UK. Charles Goodchild is Senior Engineer for the Reinforced Concrete Council. He was responsible for the concept and management of this project and this publication. Rod Webster of Concrete Innovation & Design is principal author of the spreadsheets. He has been writing RC spreadsheets since 1984 and is expert in the design of tall concrete buildings and in advanced analytical methods. Acknowledgements The ideas and illustrations come from many sources. The help and guidance received from many individuals are gratefully acknowledged. Thanks are due to members of the project’s Advisory Group for their time and effort in helping to make the project feasible and in bringing it to fruition: S Alexander, S Alhayderi, Dr H Al-Quarra, I Baldwin, C Barker, M Beamish, A Beasley, T Bedford, G Belton, R Bhatt, R Bickerton, P Blackmore, D Blackwood, M Brady, C Buczkowski, A Campbell, Dr P Chana, G Charlesworth, L Cheng, Mr Chichger, R Collison, A Craddock, M Morton, J Curry, J Dale, H Dikme, C P Edmondson, J Elliott, I Feltham, G Fernando, M Fernando, I Francis, A Fung, P Gardner, J Gay, P Green, A Hall, N Harris, G Hill, D W Hobbs, R Hulse, M Hutcheson, A Idrus, N Imms, P Jennings, D Kennedy, G Kennedy, R Jothiraj, Dr Shaiq Khan, A King, G King, S King, K Kus, Lockhart, M Lord, B Lorimer, M Lovell, Dr Luker,J Lupton, M Lytrides, Prof I Macleod, F Malekpour, A McAtear, A McFarlane, F Mohammad, A Mole, M Morton, R Moss, B Munton, C O'Boyle, Dr A Okorie, T O'Neill, B Osafa-Kwaako, D Patel, D Penman, M Perera, B Quick, Y Rafiq, A Rathbone, M Rawlinson, P Reynolds, H Riley, N Russell, U P Sarki, T Schollar, A Stalker, A Starr, M Stevenson, B Stoker, B Treadwell, A Truby, R Turner, T Viney, Dr P Walker, B Watson, J Whitworth, C Wilby, S Wilde, A Wong and E Yarimer The RCC extends its special appreciation to: Richard Cheng, BSc, CEng, Eur Ing, FIStructE, author of the retaining wall and basement wall spreadsheets, Peter Noble for conversions and checking, and to Andy Pullen for initial studies into compatibility of spreadsheet software. Also the late Sami Khan for help with post-tensioning spreadsheets. Thanks also to Alan Tovey (Tecnicom) and Gillian Bond (Words & Pages) for editing, design and production. 97.370 v0.92 UserGuid.doc First published 2000 ISBN 0 7210 1545 X Price group F © British Cement Association 2000 Published by the British Cement Association on behalf of the industry sponsors of the Reinforced Concrete Council. British Cement Association Century House, Telford Avenue Crowthorne, Berkshire RG45 6YS Telephone (01344) 762676 Fax (01344) 761214 www.bca.org.uk All advice or information from the British Cement Association and/or Reinforced Concrete Council 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 the BCA, RCC or their subcontractors, suppliers or advisors. Users should note that all BCA software and publications are subject to revision from time to time and should therefore ensure that they are in possession of the latest version. SPREADSHEETS FOR CONCRETE DESIGN TO BS 8110 and EC2 Contents Page Introduction 3 General notes Managing the spreadsheets 5 Familiarisation 7 Using the spreadsheets 14 Assumptions made 19 Spreadsheets to BS 8110 Elements RCC11 Element Design.xls 22 RCC12 Bending and Axial Force.xls 25 RCC13 Punching Shear.xls 26 RCC14 Crack Width.xls 27 Analysis RCC21 Subframe Analysis.xls 28 Slabs RCC31 One-way Solid Slabs (A & D).xls # 29 RCC32 Ribbed Slabs (A & D).xls 31 RCC33 Flat Slabs (A & D).xls 33 Beams RCC41 Continuous Beams (A & D).xls 35 RCC42 Post-tensioned Slabs & Beams (A & D).xls 37 Columns RCC51 Column Load Take-down & Design.xls 42 RCC52 Column Chart generation.xls 45 RCC53 Column Design.xls 46 Walls RCC61 Basement Wall.xls 47 RCC62 Retaining Wall.xls 49 Stairs RCC71 Stair Flight & Landing - Single.xls 52 RCC72 Stairs & Landings - Multiple.xls 53 Foundations RCC81 Foundation Pads.xls 54 Tabular versions RCC91 One-way Solid Slabs (Tables).xls 56 RCC92 Ribbed Slabs (Tables).xls 58 RCC93 Flat Slabs (Tables).xls 60 RCC94 Two-way Slabs (Tables).xls 62 RCC95 Continuous Beams (Tables).xls 63 Spreadsheets to EC2 (ENV 1992) Eurocode 2 64 Notes regarding EC2 64 Elements RCCe11 Element design.xls 66 Analysis RCCe21 Subframe analysis.xls 68 Beams RCCe41 Continuous beams (A & D).xls 69 Administrative files 71 Readme.doc & .txt Essential information for initial use Printreg.xls Help/ information/ formatting UserGuid.doc Word file of User Guide TheFonts Folder containing fonts used in the spreadsheets: Marker.ttf Tekton~n.ttf Tekton~i.ttf References and further reading 73 Symbols 75 1 2 Notes in the text of this publication, spreadsheets are often referred to by their initial reference number rather than the full names given above # A & D = Analysis and Design INTRODUCTION This publication has been produced under the Reinforced Concrete Council’s project, ‘Spreadsheets for concrete design to BS 8110 and EC2’. It provides: • A User Guide for the spreadsheets produced under the above project • Examples of current commercial reinforced concrete design • A consensus of current commercial reinforced concrete design practice • A consensus of opinion concerning reinforced concrete design to EC2. The spreadsheets are intended to follow normal design practice and cater for the design of low- to medium-rise multi-storey concrete framed buildings. Over a number of years, the Reinforced Concrete Council has developed spreadsheets to produce cost-optimised span/depth charts(1). It was recognised that the spreadsheets could prove to be a very useful tool for all designers – equally useful to the single practitioner, larger organisations and educational establishments. Thus in 1996 a project was set up to commit reinforced concrete design to computer spreadsheet files. The project was jointly funded by the RCC and the Department of the Environment, Transport and the Regions (DETR) under its Partners in Technology scheme. It was made possible by the support and contributions of time given by individual members of industry. The project was managed by the Reinforced Concrete Council and guided by an 80-strong Advisory Group of interested parties, including consulting engineers and software houses. The spreadsheets were to be issued with publications covering their use, complete with model designs and commentary. Two issues were originally envisaged: one to BS 8110: Part 1, 1997, Structural use of concrete(2), and one to Eurocode 2, Design of concrete structures, Part 1(3). Owing to current uncertainties with the final detailed content of EC2, the number of spreadsheets to the current ENV has been curtailed. Nonetheless, it has been possible to maintain a comprehensive coverage and present the spreadsheets to EC2 with those to BS 8110 in this single-volume user guide. The design of concrete structures has been described as time consuming and costly. Computer programs are used extensively but designers are often reluctant to rely on ‘black box’ technology over which they have little knowledge or control. Computer spreadsheets, on the other hand, are user- friendly, completely transparent and very powerful, and are becoming increasingly popular in all aspects of engineering. They have powerful graphical presentation facilities and established links with other software, notably word processors. In structural engineering, they suit concrete design ideally, in that they can carry out a series of mathematical calculations and, as in design, can check whether certain conditions are met. They are an ideal medium to deal with the intricacies of concrete design. And this is where it is hoped the publication and spreadsheets will help students and inexperienced engineers grasp an understanding of reinforced concrete design. For the experienced engineer, spreadsheets allow the rapid production of clear and accurate design calculations. It is hoped that the spreadsheets will allow younger users to understand concrete design and help them to gain experience by studying their own ‘what if’ scenarios. The individual user should be able to answer their own questions by chasing through the cells to uploads/Geographie/ guide-for-spreadsheets.pdf