Excel Spreadsheets for Civil and Structural Engineers

LATEST NEWS:

18/05/2013 - New spreadsheet released: Steel Beam (Historical Sections) Analysis Spreadsheet to BS 5950.
For analysing BSB and RSC (imperial sizes) mild steel sections used since 1932.

14/05/2013 - New spreadsheet released: Steel Beam Design Spreadsheet to Eurocode EC3.
Includes a large database of British and European steel sections. Available for Windows and MAC users.

02/05/2013 - New version of Wind Load on Solar Panels Design Spreadsheet (BRE) released.
Revised equation for overturning moment.

29/04/2013 - Added more American steel sections to the free CAD library (beams, channels, angles, HSS).
Also added a new free CAD library with South African steel sections. All libraries are in Knowledge Corner.

19/04/2013 - New version of U-value Calculator to BS EN ISO 6946 released.
Fixed issue with layers 6 to 10 not displaying correctly.

Click here for Older News

Who uses YourSpreadsheets:

Logos used with clients' permission.

Screenshots of available spreadsheets:

Attenuation Tank Design Spreadsheet
(to CIRIA C967: 2007):

Very easy to use spreadsheet for engineers involved in designing drainage. Allows to calculate volume of required attenuation storage to limit peak rate of run-off from development to an acceptable figure.

Bar Bending Schedule Spreadsheet
(to BS 8666: 2005):

Basic tool (one of those "must have" spreadsheets) for every engineer who is involved in concrete design in accordance with British Standard. It includes a shape code pop-up window to speed up input process. Minimum lengths are automatically filled in depending on bar size.

Bar Bending Schedule Spreadsheet
(to IS 2502: 1999):

Basic tool (one of those "must have" spreadsheets) for every engineer who is involved in concrete design in accordance with Indian Standard. It gives all shape codes, with dimensions on them, on a printout. It includes a shape code pop-up window to speed up input process. Bar shape diagrams are automatically inserted with dimensions. BBS also in Hebrew.

Bore Discharge Check Spreadsheet

A very simple and FREE spreadsheet for checking full bore discharge and water velocity for reduced bore discharge.

Building Near Trees Foundation Design
(to NHBC: 2008):

A very handy spreadsheet to determine required foundation depth when building in cohesive ground (e.g. clay) and near existing or proposed trees. Includes diagrams and site layout for ease of use. Great tool for engineers, contractors and house owners. Developed for Windows and Mac users.

Continuous Beam Analysis Spreadsheet

Spreadsheet for analyzing up to 5 span continuous beams. Ends can be simply supported, fixed or cantilevering. Results include Shear, Moment and Deflection.

Includes SI (metric) and US (imperial) units. The conversion is done by one click. Results are instant.

Flitch Beam Design Spreadsheet
(to BS 5268-2: 2002 and BS 5950-1: 2000):

Spreadsheet for designing flitch (also flitched) beams. It allows to design timber and steel plate working as a composite beam - bolted. Used where timber alone is not strong enough. Includes bolt design and four types of flitched beams. For design of softwoods, hardwoods, oak.

Masonry Wall Panel Design Spreadsheet
(to BS 5628-1: 2005 and BS 5628-2: 2005):

Spreadsheet for designing laterally loaded masonry wall panels. Allows to easily design single leaf masonry and cavity walls under wind load. For design of reinforced and unreinforced masonry single leaf and cavity walls (blockwork, brickwork and Porotherm).

Project Administration Spreadsheet

One spreadsheet that contains a range of registers, issue sheets, calculation and sketch sheets that architects, contractors, engineers etc. set up for each project at beginning of its life. All these can be generated with one click. The spreadsheet will fill in project data automatically, reducing required time to administrate a new project.

R.C. Beam Design Spreadsheet
(to BS 8110-1: 1997)

This spreadsheet allows to quickly design single span reinforced concrete beams. Checks include: Moment, Shear, Code Dependant Deflection (span over effective depth), Tension/Compression Reinforcement. Required reinforcement is displayed on elevation and cross section diagrams.

R.C. Column Design Spreadsheet
(to BS 8110-1:1997)

It makes column design a very simple task. Deals with braced, unbraced, short, slender columns. End conditions can be: free, pinned, semi-rigid, rigid. Essential tool for reinforced concrete designers.

R.C. Element Design Spreadsheet
(to BS 8110-1:1997)

This is an R.C. Spreadsheet Power Pack. It contains five spreadsheets for designing R.C. elements like columns, beams and slabs. In essence this package covers all main elements in a reinforced concrete structure, making it a very powerful tool - hence the Power Pack name.

R.C. Shear Walls Design Spreadsheet
(to BS 8110-1: 1997)

Powerful spreadsheet to design shear walls under wind plus dead load combination. Essential for stability check of reinforced concrete structure. If you spend hours calculating wall stiffnesses, ∑(kr2) etc. for reinforcement areas and concrete stresses - then this spreadsheet will reduce your design time to as little as several minutes.

Soakaway Design Spreadsheet
(to BRE Digest 365)

Calculates required soakaway size to store immediate stormwater run-off and then slowly dissipate it through infiltration into surrounding soil. Hence water is treated on site. Spreadsheet is easy to use and is recommended for civil/structural engineers, builders and regular house owners.

Steel Beam Analysis (Historical Sections)
(to BS 5950-1: 2000):

Spreadsheet for checking existing steel structures. It has a library of BSB and RSC steel sections (imperial sections) which were used in UK and overseas since 1932. Calculations are based on BS 5950 which is a common approach unless you are familiar with CP113 1948.

Steel Beam Design Spreadsheet
(to BS 5950-1: 2000):

Spreadsheet to analyse and designing simply supported Universal Columns (UC), Universal Beams (UB) or Parallel Flange Channels (PFC). It includes lateral torsional buckling check therefore is a comprehensive and an essential tool for structural engineers.

Steel Beam Design Spreadsheet
(to Eurocode 3 - EN 1993-1-1: 2005):

Spreadsheet to analyse and design simply supported British and European steel sections like UB, UC, PFC, IPE, IPN, HE, HL etc. It includes lateral torsional buckling check therefore is a comprehensive and an essential tool for structural engineers. Developed for Windows and Mac users.

Steel Column Design Spreadsheet
(to BS 5950-1: 2000):

Very useful and simplistic spreadsheet to design steel columns in what is known as 'simple structures' - so typical braced multi-storey steel frames. Available sections include Universal Columns (UC) and Universal Beams (UB).

Sum Rebar Weight per Bar Diameter

Very powerful spreadsheet to summarize reinforcement weights per bar diameter from multiple Bar Bending Schedules files on a clear an easy to read schedule. Up to 460 BBS's can be imported. Schedule can be used to calculate cost of 'as-built' reinforcement (since cost per bar diameter differs) and compare it with estimated figures. Units of weight can be either metric or imperial.

Timber Beam/Joist Design Spreadsheet
(to BS 5268-2: 2002):

Spreadsheet to design simply supported timber beams and timber joists (giving spacing per metre). For design of softwoods, hardwoods, oak, horizontally and vertically glued laminated timber (Glulam).

Timber Beam/Joist Design Spreadsheet
(to Eurocode 5 - EN 1995-1-1:2004 + A1:2008):

Spreadsheet to design simply supported timber beams and timber joists (giving spacing per metre). For design of softwoods, hardwoods, oak, glued laminated timber (Glulam) and laminated veneer lumber (LVL).

U-value Calculator (for walls, floors, roofs)
(to BS EN ISO 6946: 1997):

Automated and easy to use tool for effortless calculations of heat loss through construction elements (walls, floors and roofs). Includes a large database of materials. This spreadsheet really makes U-value calculations a quick and simple task and can be easily used by architects, builders and home owners. Developed for Windows and Mac users.

Wind Load on Solar Panels Spreadsheet
(to BRE 489: 2004):

Very easy to use spreadsheet for feasibility check of Solar Panels (Photovoltaic Panels) on a flat or pitched roof. The spreadsheet calculates required ballast weight / fixings forces / roof loads from Solar Panels.

Working Platform for Tracked Plant Design Spreadsheet (to BRE 470: 2007):

Spreadsheet to design working platform (for example piling platform for piling rig or sheet piling rig/handler). Design with and without geosynthetic reinforcement (geogrid). Two subgrade types considered: cohesive and granular. Automatically calculates soil properties.

YourSpreadsheets

Menu: