Latest Comments:
muruchem 12 days ago
Shell and Tube Heat Exchanger MMT hi sir i need this calculation sheet , i cant found download option, please mail me the excel sheet
cpburgess 16 days ago
Open Channel Flow Calculations si units would have made it great
cpburgess 16 days ago
ElasticFrames-Roark.xlsx should have SI units
AmeerMansour 18 days ago
Wood Column DesignNDS2005 LRFD is there a possible way to try it?
Thugyee 24 days ago
anhen1990 24 days ago
JohnDoyle[Admin] 28 days ago
EN 1993 bracing design - angle bracing to gusset Thanks for your contribution I have awarded a 3 month extension to your XLC Pro subscription by way of thanks. [Admin]
yvsajitesh 31 days ago
SLABLESS STAIR DESIGN How to download this Slabless Staircase Design Document
ALEXTHAINESE 1 month ago
BOLT FORCE DISTRIBUTION _ CIRCULAR PATTERN how many claculation i need to upload to get a life time subscription ??
JohnDoyle[Admin] 1 month ago
Connections EC3 A nice debut calculation! I have awarded a three month XLC Pro subscription by way of thanks.
JohnDoyle[Admin] 1 month ago
ACI-318'14 Beam Design [ Flexural,Shear,Torsion and Deflection ] (Imperial/Metric) A rather gorgeous debut calculation I have awarded a three month XLC Pro subscription by way of thanks.
infostar 1 month ago
StormSewer.xls Thanks for creating the tool. While using the tool, I have noticed that the time of concentration formula seems to be not working. Perhaps, I am missing something. Please let me know, if you have detailed instructions to follow or an updated version of this tool that you can share. Thanks, Aravind
Juanchis 1 month ago
Composite Micromechanics IS this for just Unidirectional composites or plain weave?
JohnDoyle[Admin] 2 months ago
Triple Arm Excavator Design You need a paid site subscription to download this calculation.
JohnDoyle[Admin] 2 months ago
Bolt length calculator 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
Stresses in Beams - Multiple Scenarios A nice debut calculation I have awarded a three month XLC Pro subscription by way of thanks.
Gopala9872 2 months ago
DAVIT ARM There seems to be an error in Bending stress calculation for Davit arm . Please check formula in cell J81.
sagun53 3 months ago
DESIGN OF COLUMN FOOTING ACCORDING TO CSA A23.3-14 i have done the free subscription but couldnot download the xlm file
brownden 3 months ago
Analysis of gabions.xls I have the same issue as Ian. The file wont run
bdstructural 3 months ago
DESIGN OF WALL FOOTING ACCORDING TO CSA A23.3-14 Where is the download? I registered in the hope of getting this spreadsheet.
phuongnq 3 months ago
guygardnerharris 3 months ago
Backhoe Excavator Arm Apologies for the multiple comments: coding bug on the webpage!
guygardnerharris 3 months ago
Backhoe Excavator Arm Dear John ... I downloaded and opened the Excel file, but I immediately got #NAME issues, because the formulae reference other sources (see screenshot).
Could you please adjust this within the spreadsheet itself, or perhaps forward the referenced files?
Many thanks in advance!
JohnDoyle[Admin] 3 months ago
BOLT FORCE DISTRIBUTION _ CIRCULAR PATTERN A nice debut calculation I have awarded a three month XLC Pro subscription by way of thanks.
Analysis of gabions.xls Hi There. The equation for Ka is returning a #NAME error and I think its due to the OVD/UND terms not being recognised. I have installed XLC and entered the correct release code, urned XLC Auto on so it should be updating.
Analysis of gabions.xls Hi there. The equation for Ka returns an #NAME error, and I thinks its to do with the OVD/UND functions. I have installed XLC and inserted the correct release code, so it should be working OK. The equations look OK. Is there something I'm missing?
ghazard@bakerco.com 3 months ago
Flat Plate Natural Frequency Calculator Dear Author of ExcelCalcs,
You have a very nice program which I am using for determining the natural frequency of flat plates. Questions 1 - 4 have been answered by John Doyle, however I'm curious about responses to questions 5, 6 and 7 below and would appreciate guidance from you on these points.
5. What is the meaning of a1, a2, b1, b2, c and d? Do a1, a2, b1 and b2 signify the dimensions of a generalized polygon with different dimensions a1, a2, b1 and b2?
>>> John Doyle writes, 'I am also unclear on this please raise a comment with the author on the download page.'
6. What is the meaning of “c” and “d”? They appear to the be midpoints in both dimensions of the plate, but I’d like to verify this interpretation.
>>> John Doyle writes, 'I am also unclear on this please raise a comment with the author on the download page.'
7. If a1, a2, b1 and b2 are dimensions of a polygon having different dimensions for all 4 sides, then how are these 4 values inputted into the Plate Frequency Calculator in cells B5:6?
>>> John Doyle writes, 'I am also unclear on this please raise a comment with the author on the download page.'
Thank you in advance,
Gary Hazard
mustafakeskiin 3 months ago
Calculator for assessment of coldformed steel structures to AS4600 Have prepared a blog post with general information on setting up MS Excel environment for using my spreadsheets. Activating the add-in, updating the links, and making modifications which may be caused by using other versions of Excel. The spreadsheets are created in Excel 2003, the post is based on opening fil
TAMIM 4 months ago
mustafakeskiin 4 months ago
abbaszaida 4 months ago
Triple Arm Excavator Design how can I download the file to amend the data if possible sent me by email abbaszaida@gmail.com thanks regards abbas khan
ihabsorour 5 months ago
Concrete Box Culvert analysis and Design Dears,
I have one question, is the relation between the vehicular load distribution and the depth of fill is considered on this Excel sheet?
JohnDoyle[Admin] 5 months ago
ACI 318-14M BASE PLATE DESIGN I have extended your XLC Pro subscription by three months by way of thanks.
JohnDoyle[Admin] 5 months ago
Lifting Lug I have extended your XLC Pro subscription by three months by way of thanks.
JohnDoyle[Admin] 5 months ago
Base Slab and Crack Width I have extended your XLC Pro subscription by three months by way of thanks.
JohnDoyle[Admin] 5 months ago
ASME Flange Design Calculation I have extended your XLC Pro subscription by three months by way of thanks.
JohnDoyle[Admin] 5 months ago
Crane runway design based on DIN standard I have extended your XLC Pro subscription by three months by way of thanks.
teckert11 5 months ago
BOLTGRP.xls Alex- are you able to update based on LRFD?
teckert11 5 months ago
WELDGRP.xls alex- are you able to update the sheet to include LRFD?
serseri 5 months ago
civibra 5 months ago
Steel Angle Member thanks for sharing this sheet
teckert11 5 months ago
Steel Angle Member David- are you able to updated the spreadsheet to allow the use of 50 ksi?
JohnDoyle[Admin] 6 months ago
Plane Truss Analysis Great debut calculation! I have extended your XLC Pro subscription by three months by way of thanks.
JohnDoyle[Admin] 6 months ago
Rotary Intersection Analysis and Design - Transportation Engineering I have extended your XLC Pro subscription by three months by way of thanks.
JohnDoyle[Admin] 6 months ago
XLC Add-In for Excel See Support > FAQs > How to configure XLC in the XLC Pro mode
kspiroff 7 months ago
XLC Add-In for Excel Have subscribed to XLC Addin. How do I get the XLC Release Code?
ATomanovich 7 months ago
MOVLOADS.xls In my MOVLOADS.xls spreadsheet, for the case of 2 equal moving loads with the spacing being 0.586*L, there are 2 possible positions for the pair of wheels to produce the maximum moment. Depending of the results of the MATCH and VLOOKUP commands that were utilized, sometimes the first position is found and other times the second position is found. The spreadsheet was not always correctly matching the “x” distance from the left end with the appropriate wheel load, either P1 or P2. This has now been corrected for the special case of 2 moving loads, whether the 2 loads are equal or unequal, and the current version is 1.3.
ATomanovich 7 months ago
PUMPFDN - PUMP FOUNDATIONS SUPPORTED ON SOIL In my PUMPFDN.xls spreadsheet workbook, it was pointed out to me that there were a couple of typo errors in comment boxes on page 2 of the “Large Pump” worksheet. While I was at it, I also added a quick calculation off of the main calculation sheet to the right to convert horsepower to torque.
ATomanovich 7 months ago
AISC 14.1 Properties Viewer.xls In my AISC 14.1 Properties Viewer.xls spreadsheet, it was brought to my attention that the drop down pick box in Cell N18 for double angles was not formatted correctly to include the entire list of shapes that was included off to the right of the main page. This has now been corrected and the current version is 1.1.
joreilly86 8 months ago
CSA A23.3-14 Concrete Column Interaction Diagram Worksheet is protected by password, I can't change anything.
bichmai08 8 months ago
jcvaladez 8 months ago
Machine Foundation Analysis and Design HOLA, BUEN DIA. ME INTERESA ADQUIRIR ESTA HERRAMIENTA EN EXCEL. COMO PUEDO CONSEGUIRLA?
deolatkomo 8 months ago
Concrete Box Culvert analysis and Design I HAVE JUST RENEWED MY EXCELCALCS SUBSCRIPTION FOR XLC ADD-IN AND ACTIVATED WITH THE RELEASE CODE SENT TO MY PROFILE. BUT MY CONCRETE BOX CULVERT ANALYSIS AND DESIGN ISN'T DISPLAYING FORMULAS AND NUMBERS OR FIGURES AGAIN IN THE CELLS. EVEN AFTER I RE-DOWNLOADED THE SPREADSHEET THRICE AND RESET MY XLC, I AM STILL EXPERIENCING MEANINGLESS GRAPHIC FONT DISPLAYS. PLEASE I NEED ADVICE TO MAKE MY SPREADSHEET XLC FUNCTION AGAIN.
Kalkulus 8 months ago
Kalkulus 8 months ago
RC SHEAR WALL A&D Great work. Makes life easier and better in analysis and design.
tkt 8 months ago
XLC Add-In for Excel where can i get a spreadsheet related to geotechnical problems?, like bearing capacity, settlement etc.
fbennettst666 8 months ago
cristovive122581 9 months ago
Cantilever Slab Analysis & Design-ACI Hello, I'm working in a this slab cantilever for a balcony but everything is in m and mm how can i used this spreadsheet for USA standards
ss_99_ss_9@yahoo.com 9 months ago
CORBEL DESIGN I hope to get the Corbel analysis and design 1.0
farhan_saleh 9 months ago
Elastomeric Bearing Design sir how to calculate the stiffness of pot bearings. if someone have any idea then please help me.
Maiwandkn91 9 months ago
Capacity Calculation Hi sorry for the late reply, it requires xlxtrfun adding to work..
qq1544550 10 months ago
tekpekurede 10 months ago
Spiral Staircase design Any text book reference for this calculation. I will be glad to get a reference of PDF file of literature. Many thanks
tekpekurede 10 months ago
Spiral Staircase design How is the Inner Radius calculated? I can not see anywhere on the design for the number of risers. Is the output independent of the number of risers? What does Floor Finish indicate?
catman13 11 months ago
Two-Way Slab Design to BS 8110 This is an excelent spreadsheet
catman13 11 months ago
Reinforced Concrete Pad Footing AS3600 Compliant I found this to be just what i was looking for
Thanks
catman13 11 months ago
Soil Bearing Capacity Calculation This is an excelent spreadsheet
catman13 11 months ago
Spread Footing_v1.04.xls This is an excelent spreadsheet
ss_99_ss_9@yahoo.com 11 months ago
CORBEL DESIGN good prog
ahmedhammad 1 year ago
US Steel Sheet Pile Design I would like to have it seems very interesting
white0910 1 year ago
Backhoe Excavator Arm Excavator+Arm is not updating. Kindly send the procedure for updating the sheet...Thanks in advance
Lucibostina 1 year ago
Kroll K25000 Tower Crane In order to work properly, the excel needs Technic fonts. I've uploaded the fonts to the link below
Copy Technic.ttf into Control Panel\Appearance and Personalisation\Fonts.
Link : https://ufile.io/yauahcwh
popphol 1 year ago
Column Buckling Very interesting
Mark Melamed 1 year ago
ASCE 7-10 Ch30 Part 2 Components and Cladding Simplified Method I do have XLC installed, please correct me, if I'm wrong, but I still have the same problem with 'NAME' instead of solutions.
Mark Melamed 1 year ago
ASCE 7-10 Ch30 Part 2 Components and Cladding Simplified Method This spread sheet is unusable due to error: 'NAME' in most cells, please correct to make it useful.
Mark Melamed 1 year ago
ASCE 7-10 Ch28 Method 2 - Simple Diaphragm Low-Rise Buildings This spreadsheet has errors: 'NAME' in certain cells, which makes it unusable>
Mark Melamed 1 year ago
Beam on elastic foundation If all loads are uplifts, what would anchor this beam to the ground, if its weight is less than combined effects of uplift loads?
Fouad 1 year ago
Tom Deiters 1 year ago
Honeycomb Beam & Panel Calculations Hello John,
I recently ran across a problem where the honeycomb panel was composed of different upper and lower face sheet thicknesses, for instance, upper face sheet was 1.27mm lower face sheet was .635mm. The upper face will be in compression whilst the lower is in tension. To create a minimum weight panel the face sheets were optimized. This occurs on Embraer floor panels. This creates a bit of an analysis challenge. Can you offer a suggestion?
Cheers,
Tom
tekpekurede 1 year ago
Appendix D - Anchor Bolt Anchorage Can I get this file in SI units?
gmamani 1 year ago
McCabe Thiele.xls Hola! Como lo puedo bajar?
yosso 1 year ago
Re-bar Schedule Great work. Mind if I convert the sheet from metric to non-metric?