Menu:

Share this website with your friends on Facebook



Feature added late 2011
IMPORTANT: to cease misuse of title 'Engineer' by fixers/handymen/technicians etc. fill in this e-petition: http://epetitions.direct.gov.uk/petitions/6271. This will restrict 'Engineer' title to those with an engineering degree.


LATEST NEWS:

17.05.2012 - Somehow I managed to get myself involved with development of a completely unrelated website: www.YourInvitations.net. If you have a moment then please support it by visiting and clicking Facebook like button. Thanks!

20.04.2012 - Added information about recently developed spreadsheet for timber wall design (including wall load take down) in accordance with BS 5268. This custom spreadsheet was developed for GNC Engineering Ltd. See Custom Work section.
Next will be a similar spreadsheet but in accordance with Eurocode 5 - this spreadsheet will be available for purchase.
  
Click here for Older News
On this website you will find Excel spreadsheets for Architects, Contractors, Civil and Structural Engineers. Its content is under intensive development so check regularly, or subscribe to the newsletter, to stay up to date with the latest releases. See below for a list of currently available spreadsheets.

I hope you will find these spreadsheets as useful at work as I do,
Damian Janicki   BEng MSc DIC CEng MIStructE


  - Attenuation Tank Design spreadsheet to CIRIA C697;
  - Bar Bending Schedule spreadsheet to British Standard BS 8666;
  - Bar Bending Schedule spreadsheet to Indian Standard IS 2502;
  - Continuous Beam Analysis spreadsheet;
  - Flitch Beam Design spreadsheet to BS 5268 and BS 5950;
  - Masonry Wall Panel Design spreadsheet to BS 5628-1&2;
  - Project Administration spreadsheet;
  - R.C. Beam Design spreadsheet to BS 8110;
  - R.C. Shear Walls Design spreadsheet to BS 8110;
  - Soakaway Design spreadsheet to BRE Guidelines;
  - Steel Beam Design spreadsheet to BS 5950;
  - Steel Column Design spreadsheet to BS 5950;
  - Steel Column Design spreadsheet to Eurocode 3 (comming soon);
  - Sum Rebar Weights per Bar Diameter spreadsheet;
  - Timber Beam/Joist Design spreadsheet to BS 5268;
  - Timber Beam/Joist Design spreadsheet to Eurocode 5;
  - Working Platform for Tracked Plant Design spreadsheet to BRE Guidelines.

  - FREE Library of Steelwork Sections in DWG format (AutoCAD).
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.

Comes with Soakaway Design Spreadsheet.
Picture
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.
Picture
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.
Picture
Continuous Beam Analysis Spreadsheet

Spreadsheet for analysing 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.
Picture
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.
Picture
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).
Picture
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), Compression Reinforcement. Required reinforcement is displayed on elevation and cross section diagrams.
Picture
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.

Comes with Attenuation Tank Spreadsheet.
Picture
Steel Beam Design Spreadsheet
(to BS 5950-1: 2000):

Spreadsheet to analise 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.
Picture
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 Weights per Bar Ø Spreadsheet

Very powerful spreadsheet to summarize reinforcement weights per bar diameter from multiple BBS files on a clear an easy to read schedule. Up to 460 Bar Bending Schedules 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.
Picture
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).
Picture
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).
Picture
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.