Latest Comments:
JohnDoyle[Admin] 18 hours ago
Corrugated plates You need an XLC Pro subscription to download.
acastro06 19 hours ago
Corrugated plates can someone provide me access to a copy?
JohnDoyle[Admin] 4 days ago
Soil Gradation Plot A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 4 days 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 10 days 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] 16 days 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] 22 days 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] 22 days 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 22 days 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 1 month ago
reinforcement chair.xlsx Turan bey teshekkur edirem size.
JohnDoyle[Admin] 2 months ago
Pin and Lug.xls Just updated to xlsm format.
JohnDoyle[Admin] 2 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] 2 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] 2 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] 2 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 2 months ago
FLRPLATE.xls How can i download please someone help me
JohnDoyle[Admin] 3 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 3 months ago
GRDSLAB.xls is this available for download?
JohnDoyle[Admin] 3 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 3 months ago
Backhoe Excavator Arm Can you please discribe about equation number 91
JohnDoyle[Admin] 4 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 4 months ago
Micropile hi, can someone teach me how to download this spreadsheet?
Wilmerlacayo 4 months ago
ACI318-08 RC Beam this is a fake webpage, I can`t never download a single file. Thank you anyway.
eamb 4 months ago
web tapered grider An obsolete code of practice was utilized on this spreadsheet.
JohnDoyle[Admin] 4 months ago
Orifice Sizing A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 4 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 4 months ago
RC ELEMENTS AD V1.0.xlsx Any plans for the full version ( Updated Version) ?
oussama1492 4 months ago
Reinforced Concrete Ultimate Moment Capacity i'm very impressed by the quality of this file. Thank you!
khaldoun 5 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] 5 months ago
Honeycomb Beam & Panel Calculations See [url=/pricing/compare-subscription-plans/]this page[/url]
njmoz 5 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 5 months ago
Boring Log Thanks
shonellegleeson 5 months ago
Boring Log Thanks
JohnDoyle[Admin] 5 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 5 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] 6 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] 6 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] 6 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] 6 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] 6 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] 6 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] 6 months ago
Backhoe Excavator Arm Please read [url=https://www.excelcalcs.com/support/faqs/repository-downloads-have-name-errors]FAQ[/url]
kawayapanik 6 months ago
FRP Reinforcement of RC Beams & Slabs Why don't have strain debonding check?
rafeeg 6 months ago
JohnDoyle[Admin] 6 months ago
Fatigue A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
mikecoyle 7 months ago
mecheng 7 months ago
Fluid Jets Needed
JohnDoyle[Admin] 7 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] 7 months ago
Reinforcement Pad Calculations A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
norsam1966@ 7 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@ 7 months ago
Beam with stress.xls is there a Metric version?
andy.la.1994 7 months ago
Wind Load Eurocode 1 This is a benefit file to calculate the wind loading based on Eurocode
sandersjim96 8 months ago
Thread Stripping.xls Great tool, I used years ago but lost my copy!
mahmoudhad 8 months ago
MONORAIL.xls can any one send it to me cause it is a big need and i cant afford the subscription
DavidLevy 8 months ago
Moment and Forces in Davit Arm (reference from Dennis Moss Book) Please check your 'satisfactory' terms 1 (cell G74)
JohnDoyle[Admin] 8 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 8 months ago
JohnDoyle[Admin] 8 months 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] 8 months ago
NBC Seismic Load Calculation A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
nageeb 9 months ago
Column Design Thank you Excel class for useful applications
JohnDoyle[Admin] 9 months 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 9 months ago
Design of RCC Rectangular Beams as per IS 456-2000 excellent design calculation as per IS code
JohnDoyle[Admin] 9 months 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] 9 months 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] 9 months 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] 9 months 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] 9 months 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]
webizen 9 months ago
Analysis of gabions.xls Thanks so much!
waleedbazar 10 months ago
Car Crash Analysis Good work thank you
JohnDoyle[Admin] 10 months ago
Wind Turbine quick estimation Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 10 months ago
Pressure Vessel(2:1 ellipsoidal head type) Volume Calculation A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
kapour 11 months ago
JohnDoyle[Admin] 11 months ago
Press fit shaft-hub calc - rev . 2 Great Calculation. Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 11 months ago
Trunnion lifting lug design Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 12 months ago
web tapered grider Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 12 months ago
Donald Pile design Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
jwshelby 1 year ago
PUMPFDN - PUMP FOUNDATIONS SUPPORTED ON SOIL In the Input Data section for large pumps, I don't see an input value for Wr (rotating weight) which is needed for calculation of the dynamic forces Fov and Foh. It appears that a rotating weight of 350 is built into the formula calculation. Since Wr will vary from one pump to another it seems the input data should include Wr.
mikeb 1 year ago
basit_991 1 year ago
JohnDoyle[Admin] 1 year ago
Constant rate filtration A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
jmmandato 1 year ago
sheet pile does the spread sheet include anchored sheet pile design
pepo 1 year ago
Calculation of Modulus of Subgrade Reaction If we can trail this calculation sheet?
Pile design.xls its very good and useful
JohnDoyle[Admin] 1 year ago
Weld Check What an amazing debut calculation! This calculation covers the subject in extraordinary depth and adds enough information to explain the method perfectly. I have extended your XLC Pro subscription by 12 months by way of thanks.
davidroofier 1 year ago
JohnDoyle[Admin] 1 year ago
Calculation of Modulus of Subgrade Reaction Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]