Latest Comments:
JohnDoyle[Admin] 2 days ago
Semi-elliptical head calculator Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 6 days ago
API 650 OIL STORAGE TANK DESIGN CALCULATION Most spreadsheet are filled out with values. This shows that the calculation has been used and is working with representative values. In this respect it is a working copy as it is an xlsx file and not a template file with an xltx extension. Is there something specific you are worried about. If so can you direct us to the area of concern. The file author will receives a copy of all comments raised here and generally they will answer questions if they are able to do so.
abcnc2002 7 days ago
API 650 OIL STORAGE TANK DESIGN CALCULATION Just downloaded the spreadsheet and it seems to have been filled out and commented.
I am wondering if the version I downloaded is not a template anymore but a working copy of some kind.
The spreadsheet seems to have been tampered with.
JohnDoyle[Admin] 9 days ago
Keyed Shaft Design & Strength Analysis (ANSI B17.1) A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 9 days ago
AISC360-16 RHS Welding check Thanks for another contribution and enjoy your free lifetime subscription by way of thanks!
JohnDoyle[Admin] 9 days ago
DESIGN FOR ISOLATED FOOTING WITH BIAXIAL BENDING A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
scm12345678 22 days ago
Single Angle Bending with Torsion how can I download this spreadsheet?
mutazjabar 1 month ago
JohnDoyle[Admin] 2 months ago
Pin and Lug - Static and Fatigue.xls I have corrected an error in the calculation of dimension 'b'. This is now correct. Please note that this file contains macros and needs to be trusted before opening otherwise you will see #NAME! errors.
JohnDoyle[Admin] 2 months ago
Pin and Lug.xls I noticed an error in the calculation of dimension 'b'. This has been corrected.
JohnDoyle[Admin] 2 months ago
Pipe Expansion Loop Calculations A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
DavidLevy 2 months ago
Pipe Expansion Loop Calculations Pipe & Nozzle Dim - cell B6 is not protected from non standards NPS like 9', 4.5' etc. Same apply tp D6 schedule. Recommend to choose from pull menu.
JohnDoyle[Admin] 2 months ago
Air compressor power calculator Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks.
woled 2 months ago
Weibull Slope for Fatigue Statistical Analysis I have updated the calculation, but I am not sure if it went through. In the updated Excel file, you can get the probability of a survival graph or at a point.
hventura 2 months ago
API 650 OIL STORAGE TANK DESIGN CALCULATION It is a very practise the calculation system ,
JohnDoyle[Admin] 2 months ago
Rectangular tank under hydrostatic pressure A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 2 months ago
ASME Shell/Pipe wall thickness calculation Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 2 months ago
PLATE CONNECTION A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 2 months ago
RAS 117 A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 2 months ago
slab design ACI 318-14 Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 3 months ago
Beams - shear, moment and displacement A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 3 months ago
API PADEYE Design ExcelCalcs is a club whose members share an interest in making calculations with MS Excel. Members submit calculations which are reviewed by us and published if we think they will be of use to our community. We charge members an annual subscription fee for access to all calculations on the site. Alternatively we award subscriptions in return for contributions to the site. The subscription charge covers site administration, site development and hosting costs. We offer 50% discounts to academic members and free membership to site contributors. We show calculation previews to show what each calculation contains but we do not sent out calculations for trial purposes.
nguyen 3 months ago
API PADEYE Design I can't download this file, You clould tell me how to download them
olorap 3 months ago
CRANE GIRDER DESIGN BS5950 There is a problem in Section G for Girder Selection. When selecting the Girder, plate and or Channel, when you select the GIRDER WITH CHANNEL or RESET buttons an error message comes up stating 'Cannot run macro 'OVERHEAD+TRAVELLING+CRANE+DESIGN+(BS+5950).xlsm'Button14_Click'. The macro may not be available in this workbook or all macros may be disabled.
Thus unable to reset the runway geometry for the configuration entered and thus cannot proceed beyond this point for the analysis. Can you advise or rectify.
JohnDoyle[Admin] 3 months ago
AISC Base plate for compression Updated description.
JohnDoyle[Admin] 3 months ago
Angle Section Properties Description updated.
JohnDoyle[Admin] 3 months ago
column design BS 5950 Updated calculation description.
JohnDoyle[Admin] 3 months ago
WIND LOAD on structural steel Eurocode 1 Updated calculation description.
JohnDoyle[Admin] 3 months ago
CRANE GIRDER DESIGN BS5950 Updated calculation description.
JohnDoyle[Admin] 3 months ago
Steel Angle Lintel Design Updated calculation description.
lgm 3 months ago
P M interaction curve for RCC column Quite impressive Nice job!
JohnDoyle[Admin] 3 months ago
Anchorage Bolt at Truss Support Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 3 months ago
Roof Purlin Design to BS En 1993 A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
imsale20. 5 months ago
Weld SN Fatigue.xls Thanks John for the spreadsheet. It is definitely useful.
I also think the BS7608 needs to be reviewed and updated as per the current revision. 1993 is pretty outdated. Also noted that class X is missing data.
Thanks anyway.
JohnDoyle[Admin] 5 months ago
PRESSURE VESSEL SHELL DESIGN CALCULATION Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
JohnDoyle[Admin] 5 months ago
API 650 OIL STORAGE TANK DESIGN CALCULATION A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 5 months ago
Cyclone air sampler XLC.xlsx A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks. Sorry this calculation was uploaded in 2015... I'm afraid we didn't get round to reviewing it.
JohnDoyle[Admin] 5 months ago
Determination of Stormwater Peak Flow in a Catchment Area A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 5 months ago
Torsion Check for Steel Beam-CISC A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
hadar 5 months ago
JohnDoyle[Admin] 5 months ago
Pin and Lug.xls Expansion of the calculation description.
JohnDoyle[Admin] 5 months ago
Fillet Weld Capacity I must apologise I failed to review this calculation when submitted back in Jan 2023. I have awarded a free XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 5 months ago
One way Slab A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks. Good luck with your studies!
JohnDoyle[Admin] 6 months ago
Wind Enclosure Classification (ASCE 7 - 16) A really nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 6 months ago
ASCE710W - ASCE 7-10 CODE WIND ANALYSIS PROGRAM Thanks for updating the calculation Dave. I trust you are enjoying your free lifetime membership in recognition of the good work you have posted here!
JohnDoyle[Admin] 6 months ago
Footing Bending Stress Calculation A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 6 months ago
Pile Pile Structural Checking A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
m_isnaeni 6 months ago
Pile Pile Structural Checking cool, solved my problem
JohnDoyle[Admin] 7 months 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] 7 months ago
Trench Soakaway A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 7 months ago
True Stress Strain Curve Generation The XLC addin is required to be installed as this uses some of the XLC functions.
tanvir_ha 7 months ago
True Stress Strain Curve Generation Hi, I downloaded the spreadsheet but looks its showing name error
billhero242 7 months ago
PIPE THICKNESS CALCULATION my i get this document
JohnDoyle[Admin] 7 months 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] 7 months 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] 7 months ago
BOX CULVERT A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 7 months 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] 7 months ago
sheetpile A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 7 months ago
Reinforced concrete design EC2 A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 7 months 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] 8 months ago
FOOTINGS.xlsx As ever amazing calculation Alex!
chrislynn88 8 months ago
Pad Foundation Anyone know why I cant edit this spreadsheet?
rafique.munde 8 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] 9 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] 9 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] 9 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] 9 months ago
Loading Calculation Sheet.xlsx A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
bertsteffen1 9 months ago
IS 1893 SESIMIC CALC _ RS SPECTRA & EQUIVALENT STATIC Any chance I can download this excel file?
JohnDoyle[Admin] 9 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] 9 months ago
Hydraulic Calculation Drain A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
howwm 9 months ago
JohnDoyle[Admin] 10 months ago
Corrugated plates You need an XLC Pro subscription to download.
acastro06 10 months ago
Corrugated plates can someone provide me access to a copy?
JohnDoyle[Admin] 10 months ago
Soil Gradation Plot A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 10 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 10 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] 10 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] 10 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] 10 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 10 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 11 months ago
reinforcement chair.xlsx Turan bey teshekkur edirem size.
JohnDoyle[Admin] 12 months ago
Pin and Lug.xls Just updated to xlsm format.
JohnDoyle[Admin] 12 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] 12 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] 12 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] 12 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 1 year ago
FLRPLATE.xls How can i download please someone help me
JohnDoyle[Admin] 1 year 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 1 year ago
GRDSLAB.xls is this available for download?
JohnDoyle[Admin] 1 year 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 1 year ago
Backhoe Excavator Arm Can you please discribe about equation number 91
JohnDoyle[Admin] 1 year 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 1 year ago
Micropile hi, can someone teach me how to download this spreadsheet?
Wilmerlacayo 1 year ago
ACI318-08 RC Beam this is a fake webpage, I can`t never download a single file. Thank you anyway.