Latest Comments:
m_isnaeni 3 days ago
Pile Pile Structural Checking cool, solved my problem
JohnDoyle[Admin] 13 days ago
Soakaway Calc. Full Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 14 days ago
Trench Soakaway A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 19 days ago
True Stress Strain Curve Generation The XLC addin is required to be installed as this uses some of the XLC functions.
tanvir_ha 19 days ago
True Stress Strain Curve Generation Hi, I downloaded the spreadsheet but looks its showing name error
billhero242 20 days ago
PIPE THICKNESS CALCULATION my i get this document
JohnDoyle[Admin] 21 days ago
Design wind load to NZS1170.2 / NZS3604 A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 21 days ago
Design of Prestressed Cable Systems A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 29 days ago
BOX CULVERT A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 1 month ago
Seimic Response of Liquid Storage Tank Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 1 month ago
sheetpile A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 1 month ago
Reinforced concrete design EC2 A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 1 month ago
Strain Calculator from Strain Gauges A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 2 months ago
FOOTINGS.xlsx As ever amazing calculation Alex!
chrislynn88 2 months ago
Pad Foundation Anyone know why I cant edit this spreadsheet?
rafique.munde 2 months ago
WIND LOAD on structural steel Eurocode 1 The sheet look too good, but is there any change or provision as per the new latest version of Standard.
JohnDoyle[Admin] 2 months ago
Timber - Beams to EC5 Amazing calculations! I have awarded a further 12 month extension to your XLC Pro subscription. Thank you for such outstanding work!
JohnDoyle[Admin] 2 months ago
Bearing Capacity in multi-layer soils Wow another staggeringly well laid out calculation. I have awarded a 12 month extension to your XLC Pro subscription!
JohnDoyle[Admin] 2 months ago
Timber - Rafters and Joists to EC5 Roger this is a phenomenal calculation! I absolutely take my hat of to you! Is is beautifully laid out and equations presented using the XLC add in. I have extended your XLC Pro subscription by 12 months by way of thanks!
JohnDoyle[Admin] 2 months ago
Loading Calculation Sheet.xlsx A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
bertsteffen1 3 months ago
IS 1893 SESIMIC CALC _ RS SPECTRA & EQUIVALENT STATIC Any chance I can download this excel file?
JohnDoyle[Admin] 3 months ago
Shear end plate design as per EN 1991-1-8 Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. I did have to take care to place the file in a trusted location to enable the macros to run but this was easily overcome.
JohnDoyle[Admin] 3 months ago
Hydraulic Calculation Drain A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
howwm 3 months ago
JohnDoyle[Admin] 4 months ago
Corrugated plates You need an XLC Pro subscription to download.
acastro06 4 months ago
Corrugated plates can someone provide me access to a copy?
JohnDoyle[Admin] 4 months ago
Soil Gradation Plot A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 4 months ago
Shear Lug Calculations BP1.xlsx Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
spvfls 4 months ago
ASME Flange Design Calculation Hi Connor. We are using this for some integral flange calcs, but it looks like several equations are hard coded to apply only to loose type flanges. Please update the calcs to work for integral flanges as well, a drop down list for cell E18 would be helpful. We noticed a few other things as well.
1. It looks like the following cells are hard coded with equations with no variables: E24, E25, E27, E38, E42, . These equations won’t be accurate for all flanges, please fix these.
2. The hub numbers (cells E25, E26, and E27) are not used in any calculations in the spreadsheet, but they are used in calculations in ASME BPVC Section VIII Division 1 Appendix 2. Can you update the calcs that should use cells E25, E26, and E27?
3. It would seem that all the cells that are controlled by calculations should be protected so they aren’t accidentally changed. Can you do that to make sure the integrity of the calculations is not compromised?
4. It would seem that D22 should be labeled as KL (for loose type) or KI (for integral type). And the parameter in C22 should reflect the same.
5. Cell E42 (tongue width) isn’t used in any equations. Is it supposed to be?
6. Longitudinal Hub Stress (E79 & E98) and Radial Flange Stress (E80 & E99) are hard coded to be zero. Tangential stress (E81 & E100) doesn’t seem to account for integral type. These equations should follow ASME BPVC Section VIII Division 1 Appendix 2, section 2.7 equations 8, 9, and 10 for integral type flanges.
7. I would also like to know if you have a validation proof that the results are accurate and per the code.
JohnDoyle[Admin] 4 months ago
U weld stress check according to RCC-M code A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 4 months ago
Detailed Bolted Joint Calculations I have uploaded an xslx version of the file as version 1.3. This should be less problematic than the xls version of the file which may open with security warnings
JohnDoyle[Admin] 4 months ago
Detailed Bolted Joint Calculations Thanks for your kind comments. The ovd() and und() functions come when you install our [url=/calcs/repository/Excel-Addins/XLC-Add-In-for-Excel/]XLC addin[/url] they are used to render the mathematical equations. I suggest you install a copy of it.
ctmerrick78 4 months ago
Detailed Bolted Joint Calculations Hi John, Thanks for the superb bit of work. I'm having trouble getting the calculation to execute as it is looking for a few functions @OVD and @UND that are unknown in my version of Office. I am using Office 365, latest version and I have worked through a load of security issues with the sheet to even get it to open up. Appreciate if you could revisit it for the latest version of Excel.
hasan_jahangirov 5 months ago
reinforcement chair.xlsx Turan bey teshekkur edirem size.
JohnDoyle[Admin] 5 months ago
Pin and Lug.xls Just updated to xlsm format.
JohnDoyle[Admin] 5 months ago
Pin and Lug - Static and Fatigue.xls Just updated the calculation it was an old xls format but it has macros so I uploaded an xlsm format file so that anyone opening the file is aware that it contains custom function macros.
JohnDoyle[Admin] 6 months ago
Pneumatic pressure test - restricted distance David I have extended your XLC Pro subscription by a further 3 months by way of thanks!
JohnDoyle[Admin] 6 months ago
Storm water Drainage Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 6 months ago
Wheel Load computation for crane girders Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
owaked@25 6 months ago
FLRPLATE.xls How can i download please someone help me
JohnDoyle[Admin] 6 months ago
BS7608 Design Life and Stress Calculation A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
chrishill565 6 months ago
GRDSLAB.xls is this available for download?
JohnDoyle[Admin] 6 months ago
Propane & Methane cooling due to pressure reduction Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
saseend 7 months ago
Backhoe Excavator Arm Can you please discribe about equation number 91
JohnDoyle[Admin] 7 months ago
Micropile Downloads are available to members with an active subscription to the site.
Subscriptions are free to contributors to the site, alternatively they can be purchased.
[url=/pricing/compare-subscription-plans]Click here for information on subscriptions.[/url]
nurmalyanah 7 months ago
Micropile hi, can someone teach me how to download this spreadsheet?
Wilmerlacayo 7 months ago
ACI318-08 RC Beam this is a fake webpage, I can`t never download a single file. Thank you anyway.
eamb 8 months ago
web tapered grider An obsolete code of practice was utilized on this spreadsheet.
JohnDoyle[Admin] 8 months ago
Orifice Sizing A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 8 months ago
Design of Steel Decking System Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
Maiwandkn91 8 months ago
RC ELEMENTS AD V1.0.xlsx Any plans for the full version ( Updated Version) ?
oussama1492 8 months ago
Reinforced Concrete Ultimate Moment Capacity i'm very impressed by the quality of this file. Thank you!
khaldoun 8 months ago
Bored Piles For The Analysis of Layered Soil.xlsx Dear Author,
would you please clarify what the (n & Cm) means in your excel sheet
JohnDoyle[Admin] 8 months ago
Honeycomb Beam & Panel Calculations See [url=/pricing/compare-subscription-plans/]this page[/url]
njmoz 8 months ago
Honeycomb Beam & Panel Calculations Hi, John how does one download this file I have registered but don't see a download button for this file like on other pages neil@uk-esc.com
shonellegleeson 8 months ago
Boring Log Thanks
shonellegleeson 8 months ago
Boring Log Thanks
JohnDoyle[Admin] 9 months ago
Weld SN Fatigue.xls Thanks Richard BS 7608:2014, Guide to Fatigue Design and Assessment of Steel Products, underwent significant revision to include new results compared with the original 1993 code of practice. However I have not got a copy of this document to review.
Details are given of the most significant changes, including:
Introduction of hot-spot stress method with guidance on FEA.
Modification of plate thickness correction allowing for welded joint proportions.
Introduction of beneficial bending stress correction.
Classification of additional weld details and re-classification of some.
Removal of edge distance criterion for welded attachments.
Revision of sea water corrosion fatigue data.
Production of new rules for bolts.
Extensive new recommendations regarding weld quality requirements.
More detailed guidance on stress calculation and the treatment of combined loading.
Review of Miner’s rule and treatment of low stresses.
Extra guidance on acceptance fatigue testing and statistical analysis of results.
Advice on the application of fracture mechanics as well as the information needed to convert the design S-N curves to curves corresponding to alternative probabilities of failure, as might be required for an assessment, or indeed for basic design in some circumstances.
richard1 9 months ago
Weld SN Fatigue.xls Its a great Spreadsheet, but I think the British Standard has a new 2014 version now with more options. The spreadsheet may need updated.
JohnDoyle[Admin] 9 months ago
Punching check as per IS-456-2000 A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks. By the way please set a username that is not your email address. This makes you vulnerable to spammers!
JohnDoyle[Admin] 9 months ago
RETAINING WALL DESIGN AS PER IS:456 A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 9 months ago
Orography Factor to BS EN 1991-1-4 and UKNA I did get some errors when opening the file do you know why?
JohnDoyle[Admin] 9 months ago
Actions from Wind to BS EN 1991-1-4 and UKNA Another great calculation I have extended your XLC Pro subscription by 3 months by way of thanks. I did have one problem opening the file - do you know the reason for this message from Excel?
JohnDoyle[Admin] 9 months ago
Orography Factor to BS EN 1991-1-4 and UKNA Wow what an amazing clear calculation. I have extended your XLC Pro subscription by 3 months by way of thanks!
JohnDoyle[Admin] 10 months ago
BEAMANAL (metric).xls The purpose of the calculation is to calculate loads on the beam. It is simple to add the stress check should you need it. The spreadsheet is protected but the password is blank so it is in place just to prevent accidental modifications.
JohnDoyle[Admin] 10 months ago
Backhoe Excavator Arm Please read [url=https://www.excelcalcs.com/support/faqs/repository-downloads-have-name-errors]FAQ[/url]
kawayapanik 10 months ago
FRP Reinforcement of RC Beams & Slabs Why don't have strain debonding check?
rafeeg 10 months ago
JohnDoyle[Admin] 10 months ago
Fatigue A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
mikecoyle 10 months ago
mecheng 11 months ago
Fluid Jets Needed
JohnDoyle[Admin] 11 months ago
Random Vibration Response analysis tool for SDOF systems A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 11 months ago
Reinforcement Pad Calculations A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
norsam1966@ 11 months ago
BEAMANAL (metric).xls unfortunately, the spreadsheet doesnt come with stress checks. can the author modify the spreadsheet to include stress checks to AISC ASD? is the spreadsheet protected?
norsam1966@ 11 months ago
Beam with stress.xls is there a Metric version?
andy.la.1994 11 months ago
Wind Load Eurocode 1 This is a benefit file to calculate the wind loading based on Eurocode
sandersjim96 11 months ago
Thread Stripping.xls Great tool, I used years ago but lost my copy!
mahmoudhad 11 months ago
MONORAIL.xls can any one send it to me cause it is a big need and i cant afford the subscription
DavidLevy 11 months ago
Moment and Forces in Davit Arm (reference from Dennis Moss Book) Please check your 'satisfactory' terms 1 (cell G74)
JohnDoyle[Admin] 12 months ago
Moment and Forces in Davit Arm (reference from Dennis Moss Book) A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
sucu 12 months ago
JohnDoyle[Admin] 1 year ago
Anchor Chair Design Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 1 year ago
NBC Seismic Load Calculation A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
nageeb 1 year ago
Column Design Thank you Excel class for useful applications
JohnDoyle[Admin] 1 year ago
Steel Beam under Uniform Load - AISC 360-16 Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
Ram1991 1 year ago
Design of RCC Rectangular Beams as per IS 456-2000 excellent design calculation as per IS code
JohnDoyle[Admin] 1 year ago
Wind Load Calculation for Ships A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 1 year ago
Humid Air water content calculations A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 1 year ago
BEARING CAPACITY CALCULATOR BY MEYERHOP AND BOYLES A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 1 year ago
AISC 2016 Base plate calculation _DG-01 Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 1 year ago
IS 1893 SESIMIC CALC _ RS SPECTRA & EQUIVALENT STATIC Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]