LATEST NEWS:
OLDER NEWS:
23/09/2023 - added Chinese Steel Sections to the CAD library.
16/01/2023 - Year Planners/Calendars for 2023 are now available for download.
09/11/2022 - New version of the Steel Bracing Design to Eurocode 3 spreadsheet released. Equal Angles database now includes the very small sections i.e. 80x80 to 20x20 angles (e.g. for designing support towers for ductwork).
09/11/2022 - New version of the Building Near Trees Foundation Design spreadsheet released. Adjusted linear function for calculating required foundation depth for Coniferous trees with Moderate water demands in soils with Medium volume change potential.
06/06/2022 - New version of the Steel Column Design to BS 5950 spreadsheet released. Properties of the 152UC sections now populate correctly from the database in the Company licensed version of this spreadsheet. The Single-User licensed version has been reved-up to suit although there is no actual change.
12/01/2022 - Year Planners/Calendars for 2022 are now available for download.
16/07/2021 - New version of the Bar Bending Schedule to BS 8666:2020 spreadsheet released. Added a button to change colour of input cells, black might be preferred for print-outs. Thanks go to Cornel at Capita for the suggestion.
05/07/2021 - New version of the Masonry Bearing (Padstone) Design to BS 5628 spreadsheet released. Compressive unit strength is no longer restricted to choices from the drop-down menu.
31/05/2021 - New spreadsheet released Bar Bending Schedule to BS 8666:2020. This supersedes the previously available BBS spreadsheet to BS 8666:2005. The new spreadsheet can automatically calculate the 'extra dimensions' introduced in BS 8666:2020 and also allows to insert or draw shape code 99 diagrams directly in the spreadsheet.
16/05/2021 - New version of the Employee Attendance Tracker spreadsheet released. Updated pre-set employee and department details in the Dashboard to avoid corrupting the charts the first time the Dashboard is opened.
13/03/2021 - New version of the U-value calculator to BS EN ISO 6946, 13370, BRE 443 spreadsheet released. Added option to overwrite the fractional area figure for timber/steel studs/rafters/joists.
01/01/2021 - Happy New Year!
17/12/2020 - New version of the Bar Bending Schedule to BS8666 spreadsheet released. When exporting schedule to an editable file, figures in parentheses will not be converted to negative values (which is the default behaviour in Excel).
30/11/2020 - Year Planners/Calendars for 2021 are now available for download.
21/09/2020 - New version of the Building Near Trees Foundation Design spreadsheet released. Updated to NHBC Standards 2020.
25/08/2020 - New version of the Masonry Wall Panel Design to Eurocode 6 spreadsheet released. Correct conditional formatting error when designing single leaf wall but moment resistance cell of second leaf was still visible (although ignored in calculations).
22/08/2020 - New version of the Timber Beam/Joist Design to Eurocode 5 spreadsheet released. Updated the spreadsheet to the latest U.K. National Annex.
12/08/2020 - New version of the Surface Water Drain and Foul Sewer Design spreadsheet released. Added more pipe sizes.
07/07/2020 - New version of the Steel Beam Design to Eurocode 3 spreadsheet released. Corrected cross-section area of UPN beams. Shear area values did not require correction and were not affected.
27/03/2020 - New version of the Project Administration spreadsheet released. Fixed issue with generating sheets when Logo image was deleted by user. Thanks go to Rob E. for spotting this issue.
15/03/2020 - New spreadsheet released: Timber Frame Wall Design to BS 5268-2 and BS 5268-6.1. For designing studs in timber frame walls and calculating racking resistance of wall panels.
23/02/2020 - New version of the Employee Attendance Tracker released. It comes wit a wide range of great new features: a Dashboard with many insightful charts; allow for length of service (i.e. accrued leave); leave can be calculated based on employee's actual start date; filter Overview by departments; option to show Employees' ID and work shift; add employee notes; add comments to leave dates (e.g. came in late today); quick import of larga employee databases; supports DMY and MDY date formatting.
12/02/2020 - this is a hello to the kids at the Springfield Library doing research on architecture and trying to understand how the internet works. Thanks for reaching out to YourSpreadsheets and good luck with your research. Hello!
02/01/2020 - New spreadsheet released: Employee Performance Tracker. Powerful tool for tracking performance and reviews of your employees, volunteers, students etc. Includes an advanced Dashboard with charts to help you see how your employees and departments are performing over time. FREE for companies with up to 10 employees.
01/01/2020 - Happy New Year everyone!
14/12/2019 - New version of the Steel Beam to Beam Endplate Connection Design to BS 5950 spreadsheet released. Updated steel section database; added extra in-spreadsheet help; extended notes at the bottom of the sheet; added endplate width detailing check; revised weld calculations including adding an extra input cell (it is now possible to specify different weld for web tension zone and web shear zone); also revised some other calculations e.g. plastic bolt force distribution calcs.
17/11/2019 - New version of the Wind Load on Solar Panels Design to SEAOC PV2 and ASCE7-10 spreadsheet released. Added extra geometry checks for panel size and height above roof.
16/09/2019 - The Crane Lift Calculator spreadsheet is now available also as a Single-User licensed spreadsheet.
11/09/2019 - Year Planners/Calendars for 2020 are now available for download.
26/08/2019 - New version of the Steel Column Design to BS 5950 spreadsheet released. Updated steel section sizes database.
26/08/2019 - New version of the Steel Beam Design to BS 5950 spreadsheet released. Added in-spreadsheet help pop-up messages. Also updated steel section sizes database and a few extra calculation steps are now visible on the print out.
25/08/2019 - New version of the Steel Beam Design to Eurocode 3 spreadsheet released. It is now possible to enter effective length greater than beam's actual length. Also updated steel section sizes database and added more options for deflection checks.
06/08/2019 - New version of the Wind on Structures Analysis to Eurocode 1 spreadsheet released. Incorporated footnote 3 from Table NA.1 in UK National Annex regarding increasing directional factor for the worst case angle within +/-45 degrees range of normal to face of building. Thanks go to Ibrahim M. for pointing this out.
20/06/2019 - New version of the Soakaway Design to BRE 365 spreadsheet released. Added pop-up messages and diagrams to make the spreadsheet even easier to use. E.g. added diagram to explain levels in soakage trial pit and how to make measurements during infiltration test. Also it is now easier to design soakaways made of modular geocellular units.
01/05/2019 - Website security update: this website now uses SSL security protocol to make your visit even more secure.
08/04/2019 - New version of the Wind on Structures Analysis to Eurocode 1 spreadsheet released. Corrected description and calculation of length of Zone C in Free-standing walls. Thanks go to David J. for pointing this out.
17/12/2018 - Special Offer to celebrate this Festive Season: buy two spreadsheets and get a third one for FREE. No longer active.
26/10/2018 - Now also offering Revit Services, if you would like to outsource Revit modeling on your next project click here.
05/08/2018 - New version of the Bar Bending Schedules Reinforcement Tonnage Summing spreadsheet released. Corrected error where xlsm files were counted twice. Thanks go to Akber Ismail of J.Reddington for pointing this out.
04/08/2018 - New version of Steel Beam to Beam Endplate Connection Design to BS 5950 spreadsheet released. Corrected minimum weld check error where provided=minimum would still yield a failure. Thanks go to Neil F. for pointing this out.
03/03/2018 - New version of Wind on Structures Analysis to Eurocode 1 spreadsheet released. Corrected exposure factor for wind direction IV which was linked to wind direction III.
06/01/2018 - New version of Employee Attendance Tracker released. Added pop-up help messages the first time Detailed View or Database View is opened.
13/11/2017 - New spreadsheet released: Masonry Freestanding Walls - Quick Spec Spreadsheet to BRE GBG 14. For designing freestanding walls and generating full and robust specification in a few clicks, even by inexperienced specifier.
07/10/2017 - Updated Premium version of Year Planners/Calendars for year 2018.
02/06/2017 - New version of Loading Schedule spreadsheet released. Corrected error when moving materials with predefined blanket loads caused values to be overwritten. Thanks go to Elena B. for spotting this error.
02/04/2017 - New version of Employee Attendance Tracker released. Corrected error where leave added for the last day in a year was not included in totals. Thanks go to James V. for pointing this out.
19/02/2017 - New version of Employee Attendance Tracker released. Leave can now be added over weekends and bank holidays. Also leave category names are now editable.
14/01/2017 - Made a small tweak to Wind on Structures Analysis to Eurocode 1 spreadsheet. Fundamental basic wind velocity was corrected for one location from 24.8 to 26.3 m/s. Thanks go to Doron R. for pointing this out.
24/10/2016 - In Masonry Bearing (Padstone) Design to BS 5628 spreadsheet added spreader length check for semi-infinite classification and changed cell formatting to make it more visible when bearing fails.
24/09/2016 - New spreadsheet released: Masonry Bearing (Padstone) Design to BS 5628. For assessing masonry wall (single leaf and cavity walls) under beam or lintel and for designing concrete padstone if masonry alone is not adequate.
31/08/2016 - New spreadsheet released: Steel Bracing Design to Eurocode 3. For designing single-bracing, x-bracing, k-bracing and v-bracing in frames up to 10 storey high.
31/08/2016 - New spreadsheet released: Steel Bracing Design to BS 5950. For designing single-bracing, x-bracing, k-bracing and v-bracing in frames up to 10 storey high.
18/08/2016 - Building Near Trees spreadsheet complies with the latest NHBC 2016 edition.
13/08/2016 - 2048 Brainteasers game is now available for iPhone. A new version of the game is released at the same time, with even more exciting and challenging levels. Game is available for Excel, iOS and Android.
07/08/2016 - If you are looking for structural engineers for your next project in UK then go to the Consulting Services section.
07/08/2016 - New spreadsheet released: Steel Portal Frame Sizing to BS 5950. For quick preliminary sizing of rafters, stanchions and haunches in portal frames. Based on Appendix A in SCI Publication P252.
31/07/2016 - Added two videos explaining how to purchase a spreadsheet and how to activate it. These are short videos with step-by-step instructions to aid with the process. These are especially recommended for users that aren't computer savvy.
17/07/2016 - New spreadsheet released: Crane Lift Calculator for the cranes by Demag, Grove, Kato, Liebherr, Tadano etc. The spreadsheet is mainly for tendering purposes but can be used by site as well. Calculate lift capacity or lift radius. Allows quick comparison of results for up to eight cranes.
04/07/2016 - Added option to quickly leave feedback or testimonial per spreadsheet. So if you have any feedback or would like to share your opinion about a particular spreadsheet to help others make an informed decision then click "provide testimonial or feedback" link under the "What People Say" section.
30/05/2016 - New FREE spreadsheet released: Employee/Student attendance tracker. Very customizable and easy to use management tool for SME (small and medium-sized enterprises) for tracking leave/vacation of your staff or students.
30/05/2016 - Added Year Planners/Calendars for 2017 and 2018.
04/04/2016 - Corrected error in coefficients for negative slopes of duopitch canopies in the Wind on Structures Analysis spreadsheet to Eurocode 1.
07/02/2016 - Extended range of Year Planners/Calendars. Now cover 91 countries.
04/11/2015 - I am proud to bring to you the first ever game by YourSpreadsheets: 2048 Brainteasers™. It is an addicting puzzle game that has more than 50 exciting levels to complete. Game is available for Excel and for Android mobile devices. The Excel version includes an Undercover Agent mode so you can play at work without being caught.
25/10/2015 - All spreadsheets are now compatible with Microsoft Excel 2016.
06/09/2015 - New spreadsheet released: Strip Footing Design spreadsheet to BS 8110.
For designing reinforced and unreinforced concrete footings subject to axial, bending moment and horizontal loads.
06/09/2015 - New spreadsheet released: Surface Water Drain and Foul Sewer Design spreadsheet.
Based on Chezy, Escritt and Colebrook-White equations.
14/04/2015 - Added around thirty latest clients' testimonials. Read these under 'What People Say' section.
28/02/2015 - New spreadsheet released: Timber Post Design spreadsheet to Eurocode 5.
Covers Timber and Glulam posts subject to axial load and/or moment in major and minor axis.
28/02/2015 - New spreadsheet released: Timber Post Design spreadsheet to BS 5268-2.
Covers Timber, Glulam and Composite posts subject to axial load and/or moment in major and minor axis.
28/02/2015 - New spreadsheet released: Steel Beam to Beam Endplate Connection spreadsheet to BS 5950.
For flush and extended endplates with moment, shear and axial load.
22/02/2015 - New spreadsheet released: Holding Down Bolts Design spreadsheet to BS5950, BS8110 and Concrete Society Advice No 05. Covers all common types of holding down bolts: cast-in, post-installed and with anchor plate.
11/02/2015 - New spreadsheet released: Windpost Design spreadsheet to BS 5950.
For designing angle and channel section steel windposts in single leaf and cavity masonry walls.
31/01/2015 - Released a new version of: Masonry Column and Beam Design spreadsheet to Eurocode 6 - Wi System.
Added reactions to simplify design of supporting structure.
17/01/2015 - Upon request added a new FREE CAD library to Knowledge Corner: UK Historical Steel Sections.
09/01/2015 - New spreadsheet released: Loading Schedule spreadsheet. For easy and quick creation of dead and imposed loading schedules. It has an extensive database of materials and their weights/densities.
04/01/2015 - New version of Bar Bending Schedule spreadsheet to IS 2502 released.
Added an option to change offset of bar shape diagrams as these were not located correctly for some users.
30/12/2014 - New spreadsheet released: Steel Beam Splice Connection Design spreadsheet to BS 5950.
Allows design of bolted cover plate splices subject to axial force, shear and moment.
30/12/2014 - New FREE spreadsheet released: Column and Wall Load Take Down spreadsheet.
Live load reduction is automatically calculated as per BS 6399-1, EC1, EC1+UK N.A.
29/12/2014 - Important Technical Advice - if drop-down menus in my spreadsheets used to work but now don't then you have installed a faulty Windows Update. To fix this you have to remove some temp files. To learn more click here.
29/12/2014 - New spreadsheet released: Masonry Column Design spreadsheet to BS 5628-1.
For designing unreinforced masonry columns and piers subject to axial/eccentric vertical loading.
16/11/2014 - Added more FREE Year Planners to the Knowledge Corner: for Australia, India, Ireland and United States.
16/11/2014 - New version of Wind on Structures Analysis Spreadsheet to Eurocode 1 (EN 1991-1-4: 2005) released. Removed error message for structures with effective height less than 1m.
11/08/2014 - Simplified navigation through the website by grouping spreadsheets in categories.
29/06/2014 - Added FREE Year Planners to the Knowledge Corner. These are elegant and easy to follow Year Planners, whenever printed out in colour or as black and white. There is a large selection of different designs for each year.
28/06/2014 - Added a new FREE CAD library with Indian steel sections: HB, SC, WB, LB, JB, MB, LC, JC, MC, MCP, Equal/Unequal Leg Angles, Pipes, Boxes, Tubes. This and other FREE CAD libraries can be found in Knowledge Corner.
18/06/2014 - new FREE spreadsheet released: Masonry Column and Beam Design to Eurocode 6 - Wi System.
This spreadsheet is for designing Wi Beams and Wi Columns which are used in laterally loaded masonry panels to replace traditional windposts and lintels. This is a simple system, easy to construct, yet very efficient. The spreadsheet was developed in conjunction with Wembley Innovation. The Wi System is CERAM tested and approved.
07/06/2014 - added imperial (ARCH) title blocks to Drawing Title Blocks for CAD section in Knowledge Corner.
31/05/2014 - added a new section to Knowledge Corner: Drawing Title Blocks for Revit. Fully automated and free for personal and commercial use. Come in various types and various sizes (A0 to A3) to suit project needs.
30/05/2014 - added imperial (ANSI) title blocks to Drawing Title Blocks for CAD section in Knowledge Corner.
29/05/2014 - added a new section to Knowledge Corner: Paper Sizes - gives paper dimensions and diagrams showing relationship between papers in the same series. This section includes ANSI, ARCH and ISO A Paper Series.
26/04/2014 - new spreadsheet released: Wind on Structures Analysis spreadsheet to Eurocode 1 (EN 1991-1-4: 2005).
For calculating wind pressure on eight types of structures, including: walls, roofs and canopies. This is an extremely powerful spreadsheet with great functionality; yet is very easy to use. All calculations are done automatically and more complex terms are explained with pop-up diagrams making it easy to complete the analysis. The spreadsheet offers wind pressure analysis per location based on simplified (for beginners or conservative designers) or complex input (e.g. structure orientation).
05/03/2014 - upon request, new version of Working Platform Design to BRE 470 Spreadsheet released. Added warning when bearing capacity factor for cohesive soil has non-standard value which is 2+pi(). This is to make sure user does not omit changing this value when switching between granular and cohesive design methods.
04/03/2014 - added a new section to Knowledge Corner: properties and capacities of scaffold members.
Covers elements like scaffold tubes, beams, couplers, boards etc.
24/02/2014 - if you are considering installing Solar Panels on your, or your client's, roof in USA then this new spreadsheet is for you: Wind Load on Solar Panels Design Spreadsheet to SEAOC PV2 and ASCE7-10. It is extremely easy to follow and no engineering knowledge is required to use it. Therefore it can be used be a regular house owner who wants to install Photovoltaic modules on his/hers roof (pitched or flat), as well as by a professional as it does all necessary calculations: required ballast weight / fixings forces / and roof loads.
16/02/2014 - Excel 2013 is now fully supported.
All single-user licensed spreadsheets were updated accordingly and now work fine on Excel 2013.
06/02/2014 - Corrected issue with displaying diagram for solar panels fixed to roof for
wind load on solar panels to BRE Digest 489 spreadsheet. There are no changes to calculations.
21/01/2014 - New spreadsheet released: Masonry wall panel design spreadsheet to Eurocode 6 (EN 1996-1-1: 2005). Allows to easily design reinforced/unreinforced single leaf and cavity walls under wind load and/or vertical permanent and variable actions (allows input of user specified eccentricities). For blockwork, brickwork and stone.
15/01/2014 - Added a Worked Example with comments on how to use R.C. shear walls design spreadsheet to BS 8110.
This will help you understand how the spreadsheet works and how to use it efficiently and correctly.
24/11/2013 - New version of Bar Bending Schedule to BS 8666 Spreadsheet released. Added custom printing window where user can chose a printer and sheets to print. Activate it by through 'Print Me' button or by pressing Ctrl+P (for standard printing options use Ribbon/Menu). Increased minimum P value for links with bents < 150 degrees.
10/11/2013 - Added two new AutoCAD add-ins to YourCAD package. One is for creating drainage drawings and auto- generating manhole schedules; the other is for creating perspective view of 2D objects making these look like if drawn in 3D.
20/10/2013 - New version of Bar Bending Schedule to IS 2502 Spreadsheet released. Following a great number of requests I am happy to bring to you this MAJOR upgrade! It is like a totally new spreadsheet! The following has been added: optimization, sorting, tagging, delivery note, editable bend and hook lengths, editable steel grades, exporting to fully editable spreadsheet, improved printing plus made a few performance upgrades.
21/09/2013 - Added two new sections to the Knowledge Corner:
a) YourLisp - a free AutoCAD add-in to manage AutoCAD lisp library better and faster.
b) Drawing title blocks for CAD software (AutoCAD, Microstation etc). Free for personal and commercial use. Come in various types and various sizes (A0 to A4), so everyone will find something that suits his/hers company best.
09/09/2013 - New version of YourEmails released!! Added customizable 'new message' notifications with powerful quick action buttons. These allow you to action e-mails without even opening Outlook, making you more efficient than ever.
Furthermore, it is now possible to search through messages saved/filed on a local or a network drive. These together with auto-sorting, quick filing, auto-labelling, suggested locations and other features, make it an ultimate e-mail solution!
16/08/2013 - Proudly introducing YourSteel - AutoCAD add-in that automates adding steelwork to your drawings.
For creating steelwork frames and details in a few clicks. It contains a large database of sections: AU, EU, UK and US.
01/08/2013 - New spreadsheet released: Foul Drainage - Pipe Sizing spreadsheet to BS EN 12056.
Easily calculate discharge stack and/or drain diameters. The spreadsheet uses Chezy, Escritt and Colebrook-White equations.
All calculations are fully automated so user only describes design circumstances. Available for Windows and MAC users.
08/07/2013 - Released an Apple Mac version of Steel Column Design Spreadsheet to BS 5950.
19/06/2013 - New spreadsheet released: Steel Beam Design Spreadsheet to AISC 360-10.
Calculations are based on LRFD method as covered by American Specification for Structural Steel Buildings.
09/06/2013 - Added tables and a free spreadsheet for converting SI to US and US to SI units.
The tables with conversion factors and the spreadsheet can be found in Knowledge Corner.
28/05/2013 - After a long break it is again possible to checkout in USD and EURO.
27/05/2013 - New version of Bar Bending Schedule Spreadsheet to BS 8666 released.
Added indication when entered length is smaller than required minimum for the given bar diameter.
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.
05/04/2013 - Proudly introducing: YourEmails - an innovative Mail Manager for Outlook. It was designed to keep your Outlook transparent, save you time and keep your Inbox size to a minimum. It will auto-sort and file your sent/received e-mails on the fly! Making these easily accessible by your team, no need to print e-mails nor keep hard copies.
20.03.2013 - What spreadsheet would you like to see next? Take part in this survey and decide what spreadsheet is developed next.
14.03.2013 - New spreadsheet released: 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. For Windows and Mac users.
02.03.2013 - Added a Mac Excel version of U-value Calculator to BS EN ISO 6946 which works on Apple computers.
This version has the same functionality as the Windows version.
10.02.2013 - New spreadsheet released: U-value Calculator to BS EN ISO 6946. For basement walls, external walls, slab-on-ground floors, suspended floors, typical floors and roofs (incl. warm roofs). Automated and easy to use tool for quick and efficient calculations of heat loss. Includes extensive material database. Can be easily used by architects, contractors, regular home owners.
24.12.2012 - Merry Christmas and a Happy New Year everyone!
30.11.2012 - New spreadsheet released: R.C. Column Design to BS 8110 Spreadsheet.
For designing columns in compression, bending or bi-axial bending. Covers braced, unbraced, short, slender columns (fixed, pinned, partially pined, cantilevers). It makes R.C. column design a very simple task, essential tool for reinforced concrete designers.
25.11.2012 - If you consider installing Solar Panels on your, or your client's, roof then this new spreadsheet is for you:
Wind Load on Solar Panels Design Spreadsheet to BRE 489. It is extremely easy to follow and no engineering knowledge is required to use it. Therefore it can be used be a regular house owner who wants to install Photovoltaic modules on his/hers roof (pitched or flat), as well as by a professional as it does all necessary calcs: required ballast weight / fixings forces / and roof loads.
07.11.2012 - A new major release: R.C. Element Design to BS 8110 Spreadsheet Package.
This is a Power Pack consisting of five spreadsheets for designing R.C. elements like columns (short or slender), beams and slabs. This Package is a major development and was designed to covers the most common elements in a reinforced concrete structure. This diversity, and the low price, makes it a very powerful and affordable tool for reinforced concrete designers.
14.10.2012 - New version of R.C. Beam Design to BS 8110 Spreadsheet released. This version includes a few functionality improvements. It is now easy to control deflection check by manually adjusting number of compression bars. Added option to limit maximum increase of tension reinforcement for deflection. Also improved bar spacing formula for economical design of wide beams.
23.09.2012 - Following feedback from several users: all spreadsheets have been revised and now Identification Numbers do not include a minus sign. This should make the activation process less confusing. Furthermore a few notes have been revised to ease following activation instructions. If you purchased a spreadsheet less than one year ago and did not upgrade to a latest version using your old Activation Key then contact me for a new Activation Key based on your revised Identification Number.
15.08.2012 - It is now possible to follow YourSpreadsheets on Twitter. Any news posted on this website will be posted on Twitter at the same time, so follow @YSpreadsheets to be up to date. It is still possible to subscribe to email updates here.
27.07.2012 - New spreadsheet released: Bore Discharge Check Spreadsheet. It is a useful and a very simple spreadsheet - because of the latter a full version can be downloaded for FREE. Company name and logo can be changed as required.
18.07.2012 - New version of Bar Bending Schedule Spreadsheet to BS 8666 released - another functionality upgrade.
It is now possible to refresh conditional formatting which in some circumstances may cause spreadsheet to slow down. If it seems to run slower then press a refresh button. Furthermore, it is now possible to export BBS to a new, editable and fully unprotected file which can be forwarded to Client etc. Added a few keyboard shortcuts for easier use - see TIPS section in 'from author' tab.
14.06.2012 - New version of Masonry Wall Panel Design Spreadsheet to BS 5628 released.
Corrected equations for free standing and simply supported at top and bottom walls.
02.06.2012 - New version of Masonry Wall Panel Design Spreadsheet to BS 5628 released.
Fixed issue with message 'wall panel not covered by BS' aborting calculations when wall type G-K was selected for inner leaf.
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.
17.04.2012 - Added information about recently developed spreadsheet for wall load take down of up to seven storey buildings. This custom spreadsheet was developed for GNC Engineering Ltd. Print screens etc. can be found in Custom Work section.
09.04.2012 - New spreadsheet released: Sum Rebar Weights per Bar Diameter Spreadsheet. This is a very powerful spreadsheet to summarize reinforcement weights per bar diameter from multiple BBS files (bar bending schedules) on a clear an easy to read schedule. This can then be used to calculate cost of 'as-built' reinforcement and compare it with estimated figures. Up to 460 BBS files can be imported. It will be especially appreciated by Quantity Surveyors, Contractors and Project Managers.
07.04.2012 - Happy Easter everyone!
30.03.2012 - Added new section in Knowledge Corner: Reinforcement Areas and Weights - this is very basic, yet very useful information like areas and weights of reinforcement depending on bar size and number of bars or bar spacing.
29.03.2012 - New version of: RC Shear Wall Design Spreadsheet to BS8110 released. Calculations the most adverse load combination with max and min safety factors. For example 1.4DL + 1.4WL and 1.0DL + 1.4WL can be used in one spreadsheet. Revised equation for calculating steel stresses while in tension - this gives more accurate and more economical results.
22.03.2012 - New spreadsheet released: Steel Column Design Spreadsheet to BS5950.
Allows to design UC and UB columns under point load and moments. Also includes class 4 slender sections.
18.03.2012 - Timber Beam/Joist Design Spreadsheet to Eurocode 5 is now also available in Dutch (Nederlands).
It is in accordance with National Annex: NEN-EN 1995-1-1/NB. This language was implemented upon a request.
17.03.2012 - New version of: Timber Beam/Joist Design Spreadsheet to Eurocode 5 released.
Now kcr is included in shear calculations to take account of possible cracks in members in bending.
11.03.2012 - New version of: Bar Bending Schedule Spreadsheet to IS 2502 released. This is a MAJOR performance and usability update. Because VBA code was completely rewritten, it now does not matter if there are 3 sheets or 30 - performance will be unaffected (previously it was very slow with more than 4 sheets). Bar shape diagrams now appear instantaneously. It takes only a second to summarize bar weights from multiple sheets. Expanded bar shape range by additional 18 shapes (50 in total).
11.03.2012 - Thanks to Samuel H. and Theo R. for help with a Dutch version of Timber Beam Design Spreadsheet to Eurocode 5 - which will be available for download in a next few days.
01.03.2012 - Upon request a Dutch version of Timber Beam Design Spreadsheet to Eurocode 5 is under development.
The translation is now complete (see screenshot) but values from Dutch National Annex have to be included to minimise user input. If you have any publication on differences between English and Dutch NA then please contact me.
25.02.2012 - Updated all Free Lite Versions of the spreadsheets.
24.02.2012 - New spreadsheet released: R.C. Beam Design Spreadsheet to BS 8110. For design of single span reinforced concrete beams. Required reinforcement is given on elevation and cross section diagram - which makes it very easy to understand.
02.02.2012 - New section added: Custom Work. It includes examples of custom spreadsheets that I have developed
for various civil and structural consultancies. If you require a new design tool then visit this section.
18.01.2012 - New version of: Masonry Wall Panel Design Spreadsheet to BS 5628 released. Upon request added option to calculate Porotherm blocks - based on Technical Report and Design Guidance by Ceram. Furthermore safety factors for materials are now separately calculated for flexure / compression.
16.01.2012 - Bar Bending Schedule Spreadsheet to IS 2502 is now also available in Hebrew ( עִבְרִית ). This language was implemented upon a request from a structural engineer in Israel.
08.01.2012 - New version of: RC Shear Wall Design Spreadsheet to BS 8110 released. Wall references can be turned on and off if required. Furthermore only references of designed walls are displayed.
03.01.2012 - New version of: Bar Bending Schedule Spreadsheet to BS 8666 released. Now when cells are merged,
for mesh or bar mark 99, then bar weight is calculated based on length given in 'overwrite length' column.
24.12.2011 - MERRY CHRISTMAS EVERYONE AND HAVE A GREAT 2012!
THANK YOU ALL FOR YOUR INTEREST IN MY SPREADSHEETS THIS YEAR AND FOR YOUR CONSTRUCTIVE FEEDBACK.
11.12.2011 - New version of: Flitch Beam Design Spreadsheet released.
Deflection of single beams is now calculated based on Emin rather than Emean.
10.12.2011 - New version of: Working Platfrom for Tracked Plant Design Spreadsheet released.
Corrected typo in word drained. No other changes.
28.11.2011 - New version of: R.C. Shear Walls Design Spreadsheet to BS 8110 released.
Added wall reference in layout. In reinforcement table added stresses (compression/tension) in wall ends.
23.11.2011 - New version of: Bar Bending Schedule Spreadsheet to BS 8666 released.
Added missing graphic for shape code 14 in shape code reference tab and reduced file size.
20.11.2011 - New spreadsheets released under one package: Attenuation Tank Design Spreadsheet
and Soakaway Design Spreadsheet. These are very useful tools for Builders and Engineers.
02.11.2011 - To celebrate my birthday first five people to click Facebook 'Like' button on the left will receive a FREE single-user license for any one spreadsheet of your choice. Once you click the Facebook 'Like' button, send me an e-mail at [email protected] - so that I know where to respond to. If you are within the first five I will reply and ask which spreadsheet you want.
20.10.2011 - NEW GREAT OFFER - purchase any Single-User licensed spreadsheet and, as one of the first 20 people,
press Facebook 'Like' button on this website and you will receive a 50% refund within two days. This means that you can have any number of Single-User licensed spreadsheets at 50% price! And also you help spread the word about this website.
23.09.2011 - New version of the Masonry Wall Panel Design Spreadsheet released. A minor typing error was corrected: units for panel's length and height are now in meters instead of millimetres.
22.09.2011 - New section added in Knowledge Corner: FREE Software for Engineers. It contains an extensive list of FREE software for engineers and connected professions. Subsections include: software for design and analysis; Cad software; construction product manufacturer's software; general office software.
07.09.2011 - New version of the Timber Beam/Joist Design Spreadsheet to Eurocode 5 released. Revised shear strength for GL28h. Timber grade strengths & modification factors are now in a pop-up window.
02.09.2011 - Added Facebook 'Like' button. You can now easily share this website with your friends.
29.08.2011 - New spreadsheet released: R.C. Shear Walls Design Spreadsheet to BS 8110. Allows to design reinforced concrete shear walls under wind plus dead load combination.
16.08.2011 - previously used domain (www.continuousbeamanalysis.com) is replaced with www.YourSpreadsheets.co.uk as this better reflects content of this website. All spreadsheets were updated to version 2.1. Also all printscreens were updated to reflect the new domain name. Most of the FREE Lite versions of the spreadsheets are still associated with the old domain: www.continousubeamanalysis.com.
12.08.2011 - New version of the Bar Bending Schedule Spreadsheet to BS 8666 released.
Upon request, now after entering shape code active cell is set to input field for length 'A'.
This is a minor update that greatly improves efficiency of the spreadsheet.
07.08.2011 - New version of the Flitch Beam Design Spreadsheet to BS 5268 released.
Improved and simplified bolt calculations.
10.07.2011 - [Offer ended 23.07.2011] 50% discount on single user license for Bar Bending Schedule Spreadsheet to IS2502 (Indian Standard). This offer is for a limited time only.
07.07.2011 - New version of the Masonry wall panel design spreadsheet to BS 5628 released.
Fixed issue with activating the spreadsheet - wrong tab was displayed until spreadsheet was saved.
19.06.2011 - New version of the Masonry wall panel design spreadsheet to BS 5628 released. 'Limiting dimension' check added. Now allows to design free standing, simply supported / fixed walls at top and bottom.
18.06.2011 - In each subsection added feedback that was received for various spreadsheets.
10.06.2011 - New spreadsheet released: Masonry wall panel design spreadsheet to BS 5628. It allows to design laterally loaded reinforced/unreinforced masonry single leaf and cavity walls.
29.05.2011 - New spreadsheet released: Flitch beam design spreadsheet to BS 5268. It allows to design timber and steel plates working as a composite material. Used where timber alone is not adequate.
22.05.2011 - New version of the Timber Beam/Joist Design to BS 5268 released. It is now possible to design the following materials: Oak, Vertically and Horizontally Glued Laminated Timber (Glulam).
21.05.2011 - New version of the Timber Beam/Joist Design to Eurocode 5 released. It is now possible to design the following materials: Oak, Glued Laminated Timber (Glulam), Laminated Veneer Lumber (LVL).
07.05.2011 - Site has been redesigned.
27.04.2011 - Speeded up activation process by adding Activation Key Request Form.
18.04.2011 - Due to interest from outside UK (like US, Australia and countries across Europe and Africa) it is now possible to check out in the following currencies: € (EUR), £ (GBP) and $ (USD).
17.04.2011 - Updated section: Typical Weights of Building Materials in Knowledge Corner.
20.03.2011 - Every FREE Lite spreadsheet has been updated to match the latest Full version.
17.03.2011 - New version of the Bar Bending Schedule spreadsheet to IS 2502 released.
To speed up printing, 'print all sheets' button added. Also bar weights on a summary page are now automatically updated. Few other general improvements.
10.03.2011 - New version of the Bar Bending Schedule spreadsheet to BS 8666 released. To speed up printing, 'print all sheets' button added. Few other general improvements.
03.03.2011 - New spreadsheet added for Project Administration. It generates admin spreadsheets (registers, issue sheets, calculation and sketch sheets) with predefined company/project data.
16.02.2011 - New section in Knowledge Corner has been added: tables with moment, shear and reaction Formulae for Rigid Frames.
05.02.2011 - Brickwork section in Knowledge Corner has been updated with Blockwork sizes.
28.01.2011 - Introduced new discount on Bar Bending Schedule to IS 2502. Now single-user license can be purchased for £3 (a limited time offer). The 50% discount for company license is now finished.
14.01.2011 - Added new sub-section in Knowledge Corner: Steel Sections Library which contains a FREE library of steelwork sections in DWG format (AutoCAD 2000). Sizes are from 'Blue Book'.
08.01.2011 - Added option to pay with € (Euro) for the new Timber beam/joist design to Eurocode 5.
02.01.2011 - New spreadsheet released: Timber beam/joist design to Eurocode 5.
It is based on the European Standard EC5, which is now in force throughout Europe.
At the same time please accept my sincere thanks for all your interest in my spreadsheets in 2010.
I trust that you find my spreadsheets helpful at work. I wish you all the best in the new year 2011.
18.12.2010 - Two new sub-sections added to Knowledge Corner:
Typical Weights of Building Materials and Reinforcement Estimates.
13.12.2010 - New section added: Knowledge Corner where various materials for structural engineers will be added. At present this section includes "brick dimensions" and "continuous beam bending tables" where moment/reaction coefficients are given for typical loading conditions of continuous beams.
27.11.2010 - New version of all spreadsheets released - cell protection in spreadsheets revised to work on older versions of Excel, like Excel 97. Also a new survey started for the bar bending schedule to IS 2502.
07.11.2010 - The price of the Bar Bending Schedule to IS 2502 is now reduced by 50% after results of the survey. Two free licenses for BBS to IS 2502 were sent to Suresh K. and Akram K. who were drawn from all these who participated in the survey. Thank you.
30.10.2010 - New version (1.2.) of Bar Bending Schedule to IS 2502 released. Added Summary Sheet with bar weights depending on bar diameter. Also improved performance of the spreadsheet.
27.10.2010 - If you want to receive a FREE Bar Bending Schedule Spreadsheet (to IS 2502) then fill in this survey and enter a draw. On the 7th November two people will be drawn from all these who will participate and FREE single user licenses for BBS spreadsheets (to IS 2502) will be sent to them.
10.10.2010 - Bar bending schedule spreadsheet to Indian Standard IS 2502 is now available for purchase. The free lite version of the spreadsheet can be downloaded here. Your comments are welcome.
07.10.2010 - Due to some difficulties in enabling macros and/or activating my spreadsheets I have now published a step-by-step guide to aid you. The guide is based on Microsoft Excel version 2007. Click here to learn how to enable macros and/or how to activate a spreadsheet for which a license was purchased on this website. Activation process has to be completed only once per computer.
28.09.2010 - Purchase process has been revised. Now after checkout you will be redirected to a page with full version of your spreadsheet(s). Download it, open it, and send shown Identification Number to [email protected]. In return you will receive an Activation Key. This process is not required for 'company licensed' versions of spreadsheets - which will be sent to you directly as an e-mail attachment.
22.09.2010 - At present, upon request, I am developing bar bending schedule in accordance with Indian Standard IS 2502. As a result completion of the punching shear reinforcement spreadsheet (in accordance with BS 8110) is postponed.
21.09.2010 - End of 50% discount on the working platform design spreadsheet.
Several licenses were sold at this low introductory price.
18.09.2010 - Working platform design spreadsheet version 1.4. is now available. Activation process is now necessary to use full version of this spreadsheet. Activation is based on an Identification Number which is unique for each computer. Activation is not required for 'company licensed' type of the spreadsheet.
Missing entries... 'Latest News' section did not exist until 18.09.2010.
September 2009 - domain www.continuousbeamanalysis.com appeared in web searches (later changed to www.YourSpreadsheets.co.uk).
23/09/2023 - added Chinese Steel Sections to the CAD library.
16/01/2023 - Year Planners/Calendars for 2023 are now available for download.
09/11/2022 - New version of the Steel Bracing Design to Eurocode 3 spreadsheet released. Equal Angles database now includes the very small sections i.e. 80x80 to 20x20 angles (e.g. for designing support towers for ductwork).
09/11/2022 - New version of the Building Near Trees Foundation Design spreadsheet released. Adjusted linear function for calculating required foundation depth for Coniferous trees with Moderate water demands in soils with Medium volume change potential.
06/06/2022 - New version of the Steel Column Design to BS 5950 spreadsheet released. Properties of the 152UC sections now populate correctly from the database in the Company licensed version of this spreadsheet. The Single-User licensed version has been reved-up to suit although there is no actual change.
12/01/2022 - Year Planners/Calendars for 2022 are now available for download.
16/07/2021 - New version of the Bar Bending Schedule to BS 8666:2020 spreadsheet released. Added a button to change colour of input cells, black might be preferred for print-outs. Thanks go to Cornel at Capita for the suggestion.
05/07/2021 - New version of the Masonry Bearing (Padstone) Design to BS 5628 spreadsheet released. Compressive unit strength is no longer restricted to choices from the drop-down menu.
31/05/2021 - New spreadsheet released Bar Bending Schedule to BS 8666:2020. This supersedes the previously available BBS spreadsheet to BS 8666:2005. The new spreadsheet can automatically calculate the 'extra dimensions' introduced in BS 8666:2020 and also allows to insert or draw shape code 99 diagrams directly in the spreadsheet.
16/05/2021 - New version of the Employee Attendance Tracker spreadsheet released. Updated pre-set employee and department details in the Dashboard to avoid corrupting the charts the first time the Dashboard is opened.
13/03/2021 - New version of the U-value calculator to BS EN ISO 6946, 13370, BRE 443 spreadsheet released. Added option to overwrite the fractional area figure for timber/steel studs/rafters/joists.
01/01/2021 - Happy New Year!
17/12/2020 - New version of the Bar Bending Schedule to BS8666 spreadsheet released. When exporting schedule to an editable file, figures in parentheses will not be converted to negative values (which is the default behaviour in Excel).
30/11/2020 - Year Planners/Calendars for 2021 are now available for download.
21/09/2020 - New version of the Building Near Trees Foundation Design spreadsheet released. Updated to NHBC Standards 2020.
25/08/2020 - New version of the Masonry Wall Panel Design to Eurocode 6 spreadsheet released. Correct conditional formatting error when designing single leaf wall but moment resistance cell of second leaf was still visible (although ignored in calculations).
22/08/2020 - New version of the Timber Beam/Joist Design to Eurocode 5 spreadsheet released. Updated the spreadsheet to the latest U.K. National Annex.
12/08/2020 - New version of the Surface Water Drain and Foul Sewer Design spreadsheet released. Added more pipe sizes.
07/07/2020 - New version of the Steel Beam Design to Eurocode 3 spreadsheet released. Corrected cross-section area of UPN beams. Shear area values did not require correction and were not affected.
27/03/2020 - New version of the Project Administration spreadsheet released. Fixed issue with generating sheets when Logo image was deleted by user. Thanks go to Rob E. for spotting this issue.
15/03/2020 - New spreadsheet released: Timber Frame Wall Design to BS 5268-2 and BS 5268-6.1. For designing studs in timber frame walls and calculating racking resistance of wall panels.
23/02/2020 - New version of the Employee Attendance Tracker released. It comes wit a wide range of great new features: a Dashboard with many insightful charts; allow for length of service (i.e. accrued leave); leave can be calculated based on employee's actual start date; filter Overview by departments; option to show Employees' ID and work shift; add employee notes; add comments to leave dates (e.g. came in late today); quick import of larga employee databases; supports DMY and MDY date formatting.
12/02/2020 - this is a hello to the kids at the Springfield Library doing research on architecture and trying to understand how the internet works. Thanks for reaching out to YourSpreadsheets and good luck with your research. Hello!
02/01/2020 - New spreadsheet released: Employee Performance Tracker. Powerful tool for tracking performance and reviews of your employees, volunteers, students etc. Includes an advanced Dashboard with charts to help you see how your employees and departments are performing over time. FREE for companies with up to 10 employees.
01/01/2020 - Happy New Year everyone!
14/12/2019 - New version of the Steel Beam to Beam Endplate Connection Design to BS 5950 spreadsheet released. Updated steel section database; added extra in-spreadsheet help; extended notes at the bottom of the sheet; added endplate width detailing check; revised weld calculations including adding an extra input cell (it is now possible to specify different weld for web tension zone and web shear zone); also revised some other calculations e.g. plastic bolt force distribution calcs.
17/11/2019 - New version of the Wind Load on Solar Panels Design to SEAOC PV2 and ASCE7-10 spreadsheet released. Added extra geometry checks for panel size and height above roof.
16/09/2019 - The Crane Lift Calculator spreadsheet is now available also as a Single-User licensed spreadsheet.
11/09/2019 - Year Planners/Calendars for 2020 are now available for download.
26/08/2019 - New version of the Steel Column Design to BS 5950 spreadsheet released. Updated steel section sizes database.
26/08/2019 - New version of the Steel Beam Design to BS 5950 spreadsheet released. Added in-spreadsheet help pop-up messages. Also updated steel section sizes database and a few extra calculation steps are now visible on the print out.
25/08/2019 - New version of the Steel Beam Design to Eurocode 3 spreadsheet released. It is now possible to enter effective length greater than beam's actual length. Also updated steel section sizes database and added more options for deflection checks.
06/08/2019 - New version of the Wind on Structures Analysis to Eurocode 1 spreadsheet released. Incorporated footnote 3 from Table NA.1 in UK National Annex regarding increasing directional factor for the worst case angle within +/-45 degrees range of normal to face of building. Thanks go to Ibrahim M. for pointing this out.
20/06/2019 - New version of the Soakaway Design to BRE 365 spreadsheet released. Added pop-up messages and diagrams to make the spreadsheet even easier to use. E.g. added diagram to explain levels in soakage trial pit and how to make measurements during infiltration test. Also it is now easier to design soakaways made of modular geocellular units.
01/05/2019 - Website security update: this website now uses SSL security protocol to make your visit even more secure.
08/04/2019 - New version of the Wind on Structures Analysis to Eurocode 1 spreadsheet released. Corrected description and calculation of length of Zone C in Free-standing walls. Thanks go to David J. for pointing this out.
17/12/2018 - Special Offer to celebrate this Festive Season: buy two spreadsheets and get a third one for FREE. No longer active.
26/10/2018 - Now also offering Revit Services, if you would like to outsource Revit modeling on your next project click here.
05/08/2018 - New version of the Bar Bending Schedules Reinforcement Tonnage Summing spreadsheet released. Corrected error where xlsm files were counted twice. Thanks go to Akber Ismail of J.Reddington for pointing this out.
04/08/2018 - New version of Steel Beam to Beam Endplate Connection Design to BS 5950 spreadsheet released. Corrected minimum weld check error where provided=minimum would still yield a failure. Thanks go to Neil F. for pointing this out.
03/03/2018 - New version of Wind on Structures Analysis to Eurocode 1 spreadsheet released. Corrected exposure factor for wind direction IV which was linked to wind direction III.
06/01/2018 - New version of Employee Attendance Tracker released. Added pop-up help messages the first time Detailed View or Database View is opened.
13/11/2017 - New spreadsheet released: Masonry Freestanding Walls - Quick Spec Spreadsheet to BRE GBG 14. For designing freestanding walls and generating full and robust specification in a few clicks, even by inexperienced specifier.
07/10/2017 - Updated Premium version of Year Planners/Calendars for year 2018.
02/06/2017 - New version of Loading Schedule spreadsheet released. Corrected error when moving materials with predefined blanket loads caused values to be overwritten. Thanks go to Elena B. for spotting this error.
02/04/2017 - New version of Employee Attendance Tracker released. Corrected error where leave added for the last day in a year was not included in totals. Thanks go to James V. for pointing this out.
19/02/2017 - New version of Employee Attendance Tracker released. Leave can now be added over weekends and bank holidays. Also leave category names are now editable.
14/01/2017 - Made a small tweak to Wind on Structures Analysis to Eurocode 1 spreadsheet. Fundamental basic wind velocity was corrected for one location from 24.8 to 26.3 m/s. Thanks go to Doron R. for pointing this out.
24/10/2016 - In Masonry Bearing (Padstone) Design to BS 5628 spreadsheet added spreader length check for semi-infinite classification and changed cell formatting to make it more visible when bearing fails.
24/09/2016 - New spreadsheet released: Masonry Bearing (Padstone) Design to BS 5628. For assessing masonry wall (single leaf and cavity walls) under beam or lintel and for designing concrete padstone if masonry alone is not adequate.
31/08/2016 - New spreadsheet released: Steel Bracing Design to Eurocode 3. For designing single-bracing, x-bracing, k-bracing and v-bracing in frames up to 10 storey high.
31/08/2016 - New spreadsheet released: Steel Bracing Design to BS 5950. For designing single-bracing, x-bracing, k-bracing and v-bracing in frames up to 10 storey high.
18/08/2016 - Building Near Trees spreadsheet complies with the latest NHBC 2016 edition.
13/08/2016 - 2048 Brainteasers game is now available for iPhone. A new version of the game is released at the same time, with even more exciting and challenging levels. Game is available for Excel, iOS and Android.
07/08/2016 - If you are looking for structural engineers for your next project in UK then go to the Consulting Services section.
07/08/2016 - New spreadsheet released: Steel Portal Frame Sizing to BS 5950. For quick preliminary sizing of rafters, stanchions and haunches in portal frames. Based on Appendix A in SCI Publication P252.
31/07/2016 - Added two videos explaining how to purchase a spreadsheet and how to activate it. These are short videos with step-by-step instructions to aid with the process. These are especially recommended for users that aren't computer savvy.
17/07/2016 - New spreadsheet released: Crane Lift Calculator for the cranes by Demag, Grove, Kato, Liebherr, Tadano etc. The spreadsheet is mainly for tendering purposes but can be used by site as well. Calculate lift capacity or lift radius. Allows quick comparison of results for up to eight cranes.
04/07/2016 - Added option to quickly leave feedback or testimonial per spreadsheet. So if you have any feedback or would like to share your opinion about a particular spreadsheet to help others make an informed decision then click "provide testimonial or feedback" link under the "What People Say" section.
30/05/2016 - New FREE spreadsheet released: Employee/Student attendance tracker. Very customizable and easy to use management tool for SME (small and medium-sized enterprises) for tracking leave/vacation of your staff or students.
30/05/2016 - Added Year Planners/Calendars for 2017 and 2018.
04/04/2016 - Corrected error in coefficients for negative slopes of duopitch canopies in the Wind on Structures Analysis spreadsheet to Eurocode 1.
07/02/2016 - Extended range of Year Planners/Calendars. Now cover 91 countries.
04/11/2015 - I am proud to bring to you the first ever game by YourSpreadsheets: 2048 Brainteasers™. It is an addicting puzzle game that has more than 50 exciting levels to complete. Game is available for Excel and for Android mobile devices. The Excel version includes an Undercover Agent mode so you can play at work without being caught.
25/10/2015 - All spreadsheets are now compatible with Microsoft Excel 2016.
06/09/2015 - New spreadsheet released: Strip Footing Design spreadsheet to BS 8110.
For designing reinforced and unreinforced concrete footings subject to axial, bending moment and horizontal loads.
06/09/2015 - New spreadsheet released: Surface Water Drain and Foul Sewer Design spreadsheet.
Based on Chezy, Escritt and Colebrook-White equations.
14/04/2015 - Added around thirty latest clients' testimonials. Read these under 'What People Say' section.
28/02/2015 - New spreadsheet released: Timber Post Design spreadsheet to Eurocode 5.
Covers Timber and Glulam posts subject to axial load and/or moment in major and minor axis.
28/02/2015 - New spreadsheet released: Timber Post Design spreadsheet to BS 5268-2.
Covers Timber, Glulam and Composite posts subject to axial load and/or moment in major and minor axis.
28/02/2015 - New spreadsheet released: Steel Beam to Beam Endplate Connection spreadsheet to BS 5950.
For flush and extended endplates with moment, shear and axial load.
22/02/2015 - New spreadsheet released: Holding Down Bolts Design spreadsheet to BS5950, BS8110 and Concrete Society Advice No 05. Covers all common types of holding down bolts: cast-in, post-installed and with anchor plate.
11/02/2015 - New spreadsheet released: Windpost Design spreadsheet to BS 5950.
For designing angle and channel section steel windposts in single leaf and cavity masonry walls.
31/01/2015 - Released a new version of: Masonry Column and Beam Design spreadsheet to Eurocode 6 - Wi System.
Added reactions to simplify design of supporting structure.
17/01/2015 - Upon request added a new FREE CAD library to Knowledge Corner: UK Historical Steel Sections.
09/01/2015 - New spreadsheet released: Loading Schedule spreadsheet. For easy and quick creation of dead and imposed loading schedules. It has an extensive database of materials and their weights/densities.
04/01/2015 - New version of Bar Bending Schedule spreadsheet to IS 2502 released.
Added an option to change offset of bar shape diagrams as these were not located correctly for some users.
30/12/2014 - New spreadsheet released: Steel Beam Splice Connection Design spreadsheet to BS 5950.
Allows design of bolted cover plate splices subject to axial force, shear and moment.
30/12/2014 - New FREE spreadsheet released: Column and Wall Load Take Down spreadsheet.
Live load reduction is automatically calculated as per BS 6399-1, EC1, EC1+UK N.A.
29/12/2014 - Important Technical Advice - if drop-down menus in my spreadsheets used to work but now don't then you have installed a faulty Windows Update. To fix this you have to remove some temp files. To learn more click here.
29/12/2014 - New spreadsheet released: Masonry Column Design spreadsheet to BS 5628-1.
For designing unreinforced masonry columns and piers subject to axial/eccentric vertical loading.
16/11/2014 - Added more FREE Year Planners to the Knowledge Corner: for Australia, India, Ireland and United States.
16/11/2014 - New version of Wind on Structures Analysis Spreadsheet to Eurocode 1 (EN 1991-1-4: 2005) released. Removed error message for structures with effective height less than 1m.
11/08/2014 - Simplified navigation through the website by grouping spreadsheets in categories.
29/06/2014 - Added FREE Year Planners to the Knowledge Corner. These are elegant and easy to follow Year Planners, whenever printed out in colour or as black and white. There is a large selection of different designs for each year.
28/06/2014 - Added a new FREE CAD library with Indian steel sections: HB, SC, WB, LB, JB, MB, LC, JC, MC, MCP, Equal/Unequal Leg Angles, Pipes, Boxes, Tubes. This and other FREE CAD libraries can be found in Knowledge Corner.
18/06/2014 - new FREE spreadsheet released: Masonry Column and Beam Design to Eurocode 6 - Wi System.
This spreadsheet is for designing Wi Beams and Wi Columns which are used in laterally loaded masonry panels to replace traditional windposts and lintels. This is a simple system, easy to construct, yet very efficient. The spreadsheet was developed in conjunction with Wembley Innovation. The Wi System is CERAM tested and approved.
07/06/2014 - added imperial (ARCH) title blocks to Drawing Title Blocks for CAD section in Knowledge Corner.
31/05/2014 - added a new section to Knowledge Corner: Drawing Title Blocks for Revit. Fully automated and free for personal and commercial use. Come in various types and various sizes (A0 to A3) to suit project needs.
30/05/2014 - added imperial (ANSI) title blocks to Drawing Title Blocks for CAD section in Knowledge Corner.
29/05/2014 - added a new section to Knowledge Corner: Paper Sizes - gives paper dimensions and diagrams showing relationship between papers in the same series. This section includes ANSI, ARCH and ISO A Paper Series.
26/04/2014 - new spreadsheet released: Wind on Structures Analysis spreadsheet to Eurocode 1 (EN 1991-1-4: 2005).
For calculating wind pressure on eight types of structures, including: walls, roofs and canopies. This is an extremely powerful spreadsheet with great functionality; yet is very easy to use. All calculations are done automatically and more complex terms are explained with pop-up diagrams making it easy to complete the analysis. The spreadsheet offers wind pressure analysis per location based on simplified (for beginners or conservative designers) or complex input (e.g. structure orientation).
05/03/2014 - upon request, new version of Working Platform Design to BRE 470 Spreadsheet released. Added warning when bearing capacity factor for cohesive soil has non-standard value which is 2+pi(). This is to make sure user does not omit changing this value when switching between granular and cohesive design methods.
04/03/2014 - added a new section to Knowledge Corner: properties and capacities of scaffold members.
Covers elements like scaffold tubes, beams, couplers, boards etc.
24/02/2014 - if you are considering installing Solar Panels on your, or your client's, roof in USA then this new spreadsheet is for you: Wind Load on Solar Panels Design Spreadsheet to SEAOC PV2 and ASCE7-10. It is extremely easy to follow and no engineering knowledge is required to use it. Therefore it can be used be a regular house owner who wants to install Photovoltaic modules on his/hers roof (pitched or flat), as well as by a professional as it does all necessary calculations: required ballast weight / fixings forces / and roof loads.
16/02/2014 - Excel 2013 is now fully supported.
All single-user licensed spreadsheets were updated accordingly and now work fine on Excel 2013.
06/02/2014 - Corrected issue with displaying diagram for solar panels fixed to roof for
wind load on solar panels to BRE Digest 489 spreadsheet. There are no changes to calculations.
21/01/2014 - New spreadsheet released: Masonry wall panel design spreadsheet to Eurocode 6 (EN 1996-1-1: 2005). Allows to easily design reinforced/unreinforced single leaf and cavity walls under wind load and/or vertical permanent and variable actions (allows input of user specified eccentricities). For blockwork, brickwork and stone.
15/01/2014 - Added a Worked Example with comments on how to use R.C. shear walls design spreadsheet to BS 8110.
This will help you understand how the spreadsheet works and how to use it efficiently and correctly.
24/11/2013 - New version of Bar Bending Schedule to BS 8666 Spreadsheet released. Added custom printing window where user can chose a printer and sheets to print. Activate it by through 'Print Me' button or by pressing Ctrl+P (for standard printing options use Ribbon/Menu). Increased minimum P value for links with bents < 150 degrees.
10/11/2013 - Added two new AutoCAD add-ins to YourCAD package. One is for creating drainage drawings and auto- generating manhole schedules; the other is for creating perspective view of 2D objects making these look like if drawn in 3D.
20/10/2013 - New version of Bar Bending Schedule to IS 2502 Spreadsheet released. Following a great number of requests I am happy to bring to you this MAJOR upgrade! It is like a totally new spreadsheet! The following has been added: optimization, sorting, tagging, delivery note, editable bend and hook lengths, editable steel grades, exporting to fully editable spreadsheet, improved printing plus made a few performance upgrades.
21/09/2013 - Added two new sections to the Knowledge Corner:
a) YourLisp - a free AutoCAD add-in to manage AutoCAD lisp library better and faster.
b) Drawing title blocks for CAD software (AutoCAD, Microstation etc). Free for personal and commercial use. Come in various types and various sizes (A0 to A4), so everyone will find something that suits his/hers company best.
09/09/2013 - New version of YourEmails released!! Added customizable 'new message' notifications with powerful quick action buttons. These allow you to action e-mails without even opening Outlook, making you more efficient than ever.
Furthermore, it is now possible to search through messages saved/filed on a local or a network drive. These together with auto-sorting, quick filing, auto-labelling, suggested locations and other features, make it an ultimate e-mail solution!
16/08/2013 - Proudly introducing YourSteel - AutoCAD add-in that automates adding steelwork to your drawings.
For creating steelwork frames and details in a few clicks. It contains a large database of sections: AU, EU, UK and US.
01/08/2013 - New spreadsheet released: Foul Drainage - Pipe Sizing spreadsheet to BS EN 12056.
Easily calculate discharge stack and/or drain diameters. The spreadsheet uses Chezy, Escritt and Colebrook-White equations.
All calculations are fully automated so user only describes design circumstances. Available for Windows and MAC users.
08/07/2013 - Released an Apple Mac version of Steel Column Design Spreadsheet to BS 5950.
19/06/2013 - New spreadsheet released: Steel Beam Design Spreadsheet to AISC 360-10.
Calculations are based on LRFD method as covered by American Specification for Structural Steel Buildings.
09/06/2013 - Added tables and a free spreadsheet for converting SI to US and US to SI units.
The tables with conversion factors and the spreadsheet can be found in Knowledge Corner.
28/05/2013 - After a long break it is again possible to checkout in USD and EURO.
27/05/2013 - New version of Bar Bending Schedule Spreadsheet to BS 8666 released.
Added indication when entered length is smaller than required minimum for the given bar diameter.
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.
05/04/2013 - Proudly introducing: YourEmails - an innovative Mail Manager for Outlook. It was designed to keep your Outlook transparent, save you time and keep your Inbox size to a minimum. It will auto-sort and file your sent/received e-mails on the fly! Making these easily accessible by your team, no need to print e-mails nor keep hard copies.
20.03.2013 - What spreadsheet would you like to see next? Take part in this survey and decide what spreadsheet is developed next.
14.03.2013 - New spreadsheet released: 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. For Windows and Mac users.
02.03.2013 - Added a Mac Excel version of U-value Calculator to BS EN ISO 6946 which works on Apple computers.
This version has the same functionality as the Windows version.
10.02.2013 - New spreadsheet released: U-value Calculator to BS EN ISO 6946. For basement walls, external walls, slab-on-ground floors, suspended floors, typical floors and roofs (incl. warm roofs). Automated and easy to use tool for quick and efficient calculations of heat loss. Includes extensive material database. Can be easily used by architects, contractors, regular home owners.
24.12.2012 - Merry Christmas and a Happy New Year everyone!
30.11.2012 - New spreadsheet released: R.C. Column Design to BS 8110 Spreadsheet.
For designing columns in compression, bending or bi-axial bending. Covers braced, unbraced, short, slender columns (fixed, pinned, partially pined, cantilevers). It makes R.C. column design a very simple task, essential tool for reinforced concrete designers.
25.11.2012 - If you consider installing Solar Panels on your, or your client's, roof then this new spreadsheet is for you:
Wind Load on Solar Panels Design Spreadsheet to BRE 489. It is extremely easy to follow and no engineering knowledge is required to use it. Therefore it can be used be a regular house owner who wants to install Photovoltaic modules on his/hers roof (pitched or flat), as well as by a professional as it does all necessary calcs: required ballast weight / fixings forces / and roof loads.
07.11.2012 - A new major release: R.C. Element Design to BS 8110 Spreadsheet Package.
This is a Power Pack consisting of five spreadsheets for designing R.C. elements like columns (short or slender), beams and slabs. This Package is a major development and was designed to covers the most common elements in a reinforced concrete structure. This diversity, and the low price, makes it a very powerful and affordable tool for reinforced concrete designers.
14.10.2012 - New version of R.C. Beam Design to BS 8110 Spreadsheet released. This version includes a few functionality improvements. It is now easy to control deflection check by manually adjusting number of compression bars. Added option to limit maximum increase of tension reinforcement for deflection. Also improved bar spacing formula for economical design of wide beams.
23.09.2012 - Following feedback from several users: all spreadsheets have been revised and now Identification Numbers do not include a minus sign. This should make the activation process less confusing. Furthermore a few notes have been revised to ease following activation instructions. If you purchased a spreadsheet less than one year ago and did not upgrade to a latest version using your old Activation Key then contact me for a new Activation Key based on your revised Identification Number.
15.08.2012 - It is now possible to follow YourSpreadsheets on Twitter. Any news posted on this website will be posted on Twitter at the same time, so follow @YSpreadsheets to be up to date. It is still possible to subscribe to email updates here.
27.07.2012 - New spreadsheet released: Bore Discharge Check Spreadsheet. It is a useful and a very simple spreadsheet - because of the latter a full version can be downloaded for FREE. Company name and logo can be changed as required.
18.07.2012 - New version of Bar Bending Schedule Spreadsheet to BS 8666 released - another functionality upgrade.
It is now possible to refresh conditional formatting which in some circumstances may cause spreadsheet to slow down. If it seems to run slower then press a refresh button. Furthermore, it is now possible to export BBS to a new, editable and fully unprotected file which can be forwarded to Client etc. Added a few keyboard shortcuts for easier use - see TIPS section in 'from author' tab.
14.06.2012 - New version of Masonry Wall Panel Design Spreadsheet to BS 5628 released.
Corrected equations for free standing and simply supported at top and bottom walls.
02.06.2012 - New version of Masonry Wall Panel Design Spreadsheet to BS 5628 released.
Fixed issue with message 'wall panel not covered by BS' aborting calculations when wall type G-K was selected for inner leaf.
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.
17.04.2012 - Added information about recently developed spreadsheet for wall load take down of up to seven storey buildings. This custom spreadsheet was developed for GNC Engineering Ltd. Print screens etc. can be found in Custom Work section.
09.04.2012 - New spreadsheet released: Sum Rebar Weights per Bar Diameter Spreadsheet. This is a very powerful spreadsheet to summarize reinforcement weights per bar diameter from multiple BBS files (bar bending schedules) on a clear an easy to read schedule. This can then be used to calculate cost of 'as-built' reinforcement and compare it with estimated figures. Up to 460 BBS files can be imported. It will be especially appreciated by Quantity Surveyors, Contractors and Project Managers.
07.04.2012 - Happy Easter everyone!
30.03.2012 - Added new section in Knowledge Corner: Reinforcement Areas and Weights - this is very basic, yet very useful information like areas and weights of reinforcement depending on bar size and number of bars or bar spacing.
29.03.2012 - New version of: RC Shear Wall Design Spreadsheet to BS8110 released. Calculations the most adverse load combination with max and min safety factors. For example 1.4DL + 1.4WL and 1.0DL + 1.4WL can be used in one spreadsheet. Revised equation for calculating steel stresses while in tension - this gives more accurate and more economical results.
22.03.2012 - New spreadsheet released: Steel Column Design Spreadsheet to BS5950.
Allows to design UC and UB columns under point load and moments. Also includes class 4 slender sections.
18.03.2012 - Timber Beam/Joist Design Spreadsheet to Eurocode 5 is now also available in Dutch (Nederlands).
It is in accordance with National Annex: NEN-EN 1995-1-1/NB. This language was implemented upon a request.
17.03.2012 - New version of: Timber Beam/Joist Design Spreadsheet to Eurocode 5 released.
Now kcr is included in shear calculations to take account of possible cracks in members in bending.
11.03.2012 - New version of: Bar Bending Schedule Spreadsheet to IS 2502 released. This is a MAJOR performance and usability update. Because VBA code was completely rewritten, it now does not matter if there are 3 sheets or 30 - performance will be unaffected (previously it was very slow with more than 4 sheets). Bar shape diagrams now appear instantaneously. It takes only a second to summarize bar weights from multiple sheets. Expanded bar shape range by additional 18 shapes (50 in total).
11.03.2012 - Thanks to Samuel H. and Theo R. for help with a Dutch version of Timber Beam Design Spreadsheet to Eurocode 5 - which will be available for download in a next few days.
01.03.2012 - Upon request a Dutch version of Timber Beam Design Spreadsheet to Eurocode 5 is under development.
The translation is now complete (see screenshot) but values from Dutch National Annex have to be included to minimise user input. If you have any publication on differences between English and Dutch NA then please contact me.
25.02.2012 - Updated all Free Lite Versions of the spreadsheets.
24.02.2012 - New spreadsheet released: R.C. Beam Design Spreadsheet to BS 8110. For design of single span reinforced concrete beams. Required reinforcement is given on elevation and cross section diagram - which makes it very easy to understand.
02.02.2012 - New section added: Custom Work. It includes examples of custom spreadsheets that I have developed
for various civil and structural consultancies. If you require a new design tool then visit this section.
18.01.2012 - New version of: Masonry Wall Panel Design Spreadsheet to BS 5628 released. Upon request added option to calculate Porotherm blocks - based on Technical Report and Design Guidance by Ceram. Furthermore safety factors for materials are now separately calculated for flexure / compression.
16.01.2012 - Bar Bending Schedule Spreadsheet to IS 2502 is now also available in Hebrew ( עִבְרִית ). This language was implemented upon a request from a structural engineer in Israel.
08.01.2012 - New version of: RC Shear Wall Design Spreadsheet to BS 8110 released. Wall references can be turned on and off if required. Furthermore only references of designed walls are displayed.
03.01.2012 - New version of: Bar Bending Schedule Spreadsheet to BS 8666 released. Now when cells are merged,
for mesh or bar mark 99, then bar weight is calculated based on length given in 'overwrite length' column.
24.12.2011 - MERRY CHRISTMAS EVERYONE AND HAVE A GREAT 2012!
THANK YOU ALL FOR YOUR INTEREST IN MY SPREADSHEETS THIS YEAR AND FOR YOUR CONSTRUCTIVE FEEDBACK.
11.12.2011 - New version of: Flitch Beam Design Spreadsheet released.
Deflection of single beams is now calculated based on Emin rather than Emean.
10.12.2011 - New version of: Working Platfrom for Tracked Plant Design Spreadsheet released.
Corrected typo in word drained. No other changes.
28.11.2011 - New version of: R.C. Shear Walls Design Spreadsheet to BS 8110 released.
Added wall reference in layout. In reinforcement table added stresses (compression/tension) in wall ends.
23.11.2011 - New version of: Bar Bending Schedule Spreadsheet to BS 8666 released.
Added missing graphic for shape code 14 in shape code reference tab and reduced file size.
20.11.2011 - New spreadsheets released under one package: Attenuation Tank Design Spreadsheet
and Soakaway Design Spreadsheet. These are very useful tools for Builders and Engineers.
02.11.2011 - To celebrate my birthday first five people to click Facebook 'Like' button on the left will receive a FREE single-user license for any one spreadsheet of your choice. Once you click the Facebook 'Like' button, send me an e-mail at [email protected] - so that I know where to respond to. If you are within the first five I will reply and ask which spreadsheet you want.
20.10.2011 - NEW GREAT OFFER - purchase any Single-User licensed spreadsheet and, as one of the first 20 people,
press Facebook 'Like' button on this website and you will receive a 50% refund within two days. This means that you can have any number of Single-User licensed spreadsheets at 50% price! And also you help spread the word about this website.
23.09.2011 - New version of the Masonry Wall Panel Design Spreadsheet released. A minor typing error was corrected: units for panel's length and height are now in meters instead of millimetres.
22.09.2011 - New section added in Knowledge Corner: FREE Software for Engineers. It contains an extensive list of FREE software for engineers and connected professions. Subsections include: software for design and analysis; Cad software; construction product manufacturer's software; general office software.
07.09.2011 - New version of the Timber Beam/Joist Design Spreadsheet to Eurocode 5 released. Revised shear strength for GL28h. Timber grade strengths & modification factors are now in a pop-up window.
02.09.2011 - Added Facebook 'Like' button. You can now easily share this website with your friends.
29.08.2011 - New spreadsheet released: R.C. Shear Walls Design Spreadsheet to BS 8110. Allows to design reinforced concrete shear walls under wind plus dead load combination.
16.08.2011 - previously used domain (www.continuousbeamanalysis.com) is replaced with www.YourSpreadsheets.co.uk as this better reflects content of this website. All spreadsheets were updated to version 2.1. Also all printscreens were updated to reflect the new domain name. Most of the FREE Lite versions of the spreadsheets are still associated with the old domain: www.continousubeamanalysis.com.
12.08.2011 - New version of the Bar Bending Schedule Spreadsheet to BS 8666 released.
Upon request, now after entering shape code active cell is set to input field for length 'A'.
This is a minor update that greatly improves efficiency of the spreadsheet.
07.08.2011 - New version of the Flitch Beam Design Spreadsheet to BS 5268 released.
Improved and simplified bolt calculations.
10.07.2011 - [Offer ended 23.07.2011] 50% discount on single user license for Bar Bending Schedule Spreadsheet to IS2502 (Indian Standard). This offer is for a limited time only.
07.07.2011 - New version of the Masonry wall panel design spreadsheet to BS 5628 released.
Fixed issue with activating the spreadsheet - wrong tab was displayed until spreadsheet was saved.
19.06.2011 - New version of the Masonry wall panel design spreadsheet to BS 5628 released. 'Limiting dimension' check added. Now allows to design free standing, simply supported / fixed walls at top and bottom.
18.06.2011 - In each subsection added feedback that was received for various spreadsheets.
10.06.2011 - New spreadsheet released: Masonry wall panel design spreadsheet to BS 5628. It allows to design laterally loaded reinforced/unreinforced masonry single leaf and cavity walls.
29.05.2011 - New spreadsheet released: Flitch beam design spreadsheet to BS 5268. It allows to design timber and steel plates working as a composite material. Used where timber alone is not adequate.
22.05.2011 - New version of the Timber Beam/Joist Design to BS 5268 released. It is now possible to design the following materials: Oak, Vertically and Horizontally Glued Laminated Timber (Glulam).
21.05.2011 - New version of the Timber Beam/Joist Design to Eurocode 5 released. It is now possible to design the following materials: Oak, Glued Laminated Timber (Glulam), Laminated Veneer Lumber (LVL).
07.05.2011 - Site has been redesigned.
27.04.2011 - Speeded up activation process by adding Activation Key Request Form.
18.04.2011 - Due to interest from outside UK (like US, Australia and countries across Europe and Africa) it is now possible to check out in the following currencies: € (EUR), £ (GBP) and $ (USD).
17.04.2011 - Updated section: Typical Weights of Building Materials in Knowledge Corner.
20.03.2011 - Every FREE Lite spreadsheet has been updated to match the latest Full version.
17.03.2011 - New version of the Bar Bending Schedule spreadsheet to IS 2502 released.
To speed up printing, 'print all sheets' button added. Also bar weights on a summary page are now automatically updated. Few other general improvements.
10.03.2011 - New version of the Bar Bending Schedule spreadsheet to BS 8666 released. To speed up printing, 'print all sheets' button added. Few other general improvements.
03.03.2011 - New spreadsheet added for Project Administration. It generates admin spreadsheets (registers, issue sheets, calculation and sketch sheets) with predefined company/project data.
16.02.2011 - New section in Knowledge Corner has been added: tables with moment, shear and reaction Formulae for Rigid Frames.
05.02.2011 - Brickwork section in Knowledge Corner has been updated with Blockwork sizes.
28.01.2011 - Introduced new discount on Bar Bending Schedule to IS 2502. Now single-user license can be purchased for £3 (a limited time offer). The 50% discount for company license is now finished.
14.01.2011 - Added new sub-section in Knowledge Corner: Steel Sections Library which contains a FREE library of steelwork sections in DWG format (AutoCAD 2000). Sizes are from 'Blue Book'.
08.01.2011 - Added option to pay with € (Euro) for the new Timber beam/joist design to Eurocode 5.
02.01.2011 - New spreadsheet released: Timber beam/joist design to Eurocode 5.
It is based on the European Standard EC5, which is now in force throughout Europe.
At the same time please accept my sincere thanks for all your interest in my spreadsheets in 2010.
I trust that you find my spreadsheets helpful at work. I wish you all the best in the new year 2011.
18.12.2010 - Two new sub-sections added to Knowledge Corner:
Typical Weights of Building Materials and Reinforcement Estimates.
13.12.2010 - New section added: Knowledge Corner where various materials for structural engineers will be added. At present this section includes "brick dimensions" and "continuous beam bending tables" where moment/reaction coefficients are given for typical loading conditions of continuous beams.
27.11.2010 - New version of all spreadsheets released - cell protection in spreadsheets revised to work on older versions of Excel, like Excel 97. Also a new survey started for the bar bending schedule to IS 2502.
07.11.2010 - The price of the Bar Bending Schedule to IS 2502 is now reduced by 50% after results of the survey. Two free licenses for BBS to IS 2502 were sent to Suresh K. and Akram K. who were drawn from all these who participated in the survey. Thank you.
30.10.2010 - New version (1.2.) of Bar Bending Schedule to IS 2502 released. Added Summary Sheet with bar weights depending on bar diameter. Also improved performance of the spreadsheet.
27.10.2010 - If you want to receive a FREE Bar Bending Schedule Spreadsheet (to IS 2502) then fill in this survey and enter a draw. On the 7th November two people will be drawn from all these who will participate and FREE single user licenses for BBS spreadsheets (to IS 2502) will be sent to them.
10.10.2010 - Bar bending schedule spreadsheet to Indian Standard IS 2502 is now available for purchase. The free lite version of the spreadsheet can be downloaded here. Your comments are welcome.
07.10.2010 - Due to some difficulties in enabling macros and/or activating my spreadsheets I have now published a step-by-step guide to aid you. The guide is based on Microsoft Excel version 2007. Click here to learn how to enable macros and/or how to activate a spreadsheet for which a license was purchased on this website. Activation process has to be completed only once per computer.
28.09.2010 - Purchase process has been revised. Now after checkout you will be redirected to a page with full version of your spreadsheet(s). Download it, open it, and send shown Identification Number to [email protected]. In return you will receive an Activation Key. This process is not required for 'company licensed' versions of spreadsheets - which will be sent to you directly as an e-mail attachment.
22.09.2010 - At present, upon request, I am developing bar bending schedule in accordance with Indian Standard IS 2502. As a result completion of the punching shear reinforcement spreadsheet (in accordance with BS 8110) is postponed.
21.09.2010 - End of 50% discount on the working platform design spreadsheet.
Several licenses were sold at this low introductory price.
18.09.2010 - Working platform design spreadsheet version 1.4. is now available. Activation process is now necessary to use full version of this spreadsheet. Activation is based on an Identification Number which is unique for each computer. Activation is not required for 'company licensed' type of the spreadsheet.
Missing entries... 'Latest News' section did not exist until 18.09.2010.
September 2009 - domain www.continuousbeamanalysis.com appeared in web searches (later changed to www.YourSpreadsheets.co.uk).