Advertisement

Member Login

Who's Online

We have 33 guests and 8 members online

Enter Amount:


Total Downloads

150922
Home arrow Featured Authors arrow John Doyle

John Doyle (Mechanical Engineer)

I was born in 1965 and I have spent all my life as a mechanical engineer. As a student in the early 1980’s I was lucky enough to work for a very progressive engineering company who were pioneering computational techniques for design. I recall being given a 10 inch thick program listing for the SAP finite element program and told “debug this it’s not working”. There I was introduced to ‘Visicalc’ the world’s first spreadsheet. Despite its clunky screen display is was immediately clear that this tool would be essential for engineers.

Back in those days engineering calculations were written in pencil on gridded calculation sheets. As the office junior I would be given the calculations of senior engineers to check. I was amazed to see all the seemingly irrelevant maths I learned at college could be harnessed to become cranes, windmills and bridges I saw being made in the workshops.

I wrote XLC and launched www.ExcelCalcs.com in March 2007 to bring together the tradition of engineering calculations with the productivity benefits of the spreadsheet and the internet. I work as a consultant and over the years I have generated hundreds of classical engineering calculations on spreadsheets. The calculations cover analysis of railway vehicles, construction equipment, oil and gas plant, cranes and mechanical items for theme parks. These could easily have been forgotten on some old hard drive but, using XLC to transform the spreadsheet into an easily readable form and by publishing them on the ExcelCalcs site, my calculations have been given a new lease of life.

 
DownloadedTotal DownloadsAverage RatingRepository Download
2010 Feb. 265This file is located in the Stress folder. SCF circular shaft with keyseat.xlsx
2010 Feb. 199This file is located in the Beams folder. Light-weight Composite Beam Design
2010 Feb. 196This file is located in the Plates folder. Composite Panel Calculations.xlsx
2010 Feb. 1520473This file is located in the Add-Ins folder. XLC addin for MS Excel
2010 Jan. 288This file is located in the Bolts and Threads folder. Screwjack effects of wear on thread stripping load
2010 Jan. 272This file is located in the Miscellaneous folder. Adhesive Wear Rate Between Two Metals
2010 Jan. 27984This file is located in the Add-Ins folder. XLC CalcSheet.XLT
2010 Jan. 2614This file is located in the Fatigue folder. Crane Designer's Fatigue Design
2010 Jan. 2618This file is located in the Fatigue folder. Stress Life Fatigue.xls
2010 Jan. 268This file is located in the Fatigue folder. Roymech's Fatigue Calculator
2009 Nov. 22552This file is located in the Bolts and Threads folder. Thread Stripping.xls
2009 Nov. 164This file is located in the Motion folder. Generalised Motion Solver.xls
2009 Oct. 146This file is located in the Links folder. Fiberdownload
2009 Oct. 1348This file is located in the Bolts and Threads folder. Quick and Dirty Bolt Sizing Calculation.xls
2009 Sep. 1654This file is located in the Coordinates folder. Andy Pope's Excel Charts
2009 Aug. 260This file is located in the Misc. Topics folder. bills_conversions.xls
2009 Aug. 2534This file is located in the Structural Details folder. Astronautic Structures Manual (On-Line)
2009 Jun. 1928This file is located in the Misc. Topics folder. Gannt.xls
2009 Jun. 1915This file is located in the Misc. Topics folder. In-cell Graphs.xls
2009 Jun. 04328This file is located in the Misc. Topics folder. Consistent units V0001.xls
2009 Jun. 01680This file is located in the Links folder. changeunits
2009 May. 0725This file is located in the Structural Details folder. SemiCircular Tension Fitting.xls
2009 May. 0633This file is located in the Pins and Joints folder. Pin and Lug - Static and Fatigue.xls
2009 May. 0136This file is located in the Machines folder. Excavator Arm.xls
2009 Apr. 2852This file is located in the Miscellaneous folder. Interference Fit Joints.xls
2009 Apr. 28148This file is located in the Structural Details folder. Stress in a plate due to a point load.xls
2009 Apr. 2857This file is located in the Structural Details folder. Angle type tension fitting.xls
2009 Apr. 2839This file is located in the Structural Details folder. Channel type tension fitting.xls
2009 Apr. 01169This file is located in the Pins and Joints folder. Pin and Lug.xls
2009 Feb. 2686This file is located in the Areas folder. LineSec.xls
2009 Feb. 11117This file is located in the Buckling folder. Secant Formula.xls
2009 Feb. 0677This file is located in the Links folder. SageMath Note Book
2008 Oct. 03559This file is located in the Piping folder. Colebrook_White.xls
2008 Sep. 24135This file is located in the Coordinates folder. Equilibrium of three forces in a plane.xls
2008 Sep. 1795This file is located in the Links folder. AppsPro's XY Chart Labeler
2008 Aug. 22145This file is located in the Coordinates folder. Line between two point and perpendicular distance to third point.xls
2008 Aug. 14278This file is located in the Electricity folder. Solar panel costing.xls
2008 Jul. 18228This file is located in the Adhesives folder. Bonded Lap Joint.xls
2008 Jul. 08189This file is located in the Miscellaneous folder. Stress in a rotating disk.xls
2008 Jun. 25128This file is located in the Conduction folder. Simple 1D conduction.xls
2008 Jun. 24159This file is located in the Maths folder. Mike Hadden's Excel and Maths Files.
2008 May. 29890This file is located in the Piping folder. piping_design_info.xls
2008 May. 04142This file is located in the Coordinates folder. ellipse.xls
2008 Apr. 30905This file is located in the Bolts and Threads folder. Bolt spacing and edge distances.xls
2008 Apr. 15263This file is located in the Single DOF folder. Forced Vibration of a single degree of freedom system.xls
2008 Apr. 141185This file is located in the Pins and Joints folder. Clevis and lug design V0001.xls
2008 Mar. 11563This file is located in the Areas folder. AISC 13.0 Properties Viewer.xls
2008 Mar. 06151This file is located in the Welds folder. WELDGRP Metric.xls
2008 Feb. 142187This file is located in the Add-Ins folder. xxxExpiredxxx XLC 01_08 Installation.zip
2008 Feb. 11373This file is located in the Contact folder. Contact Stress Sphere.xls
2008 Jan. 22391This file is located in the Stress folder. Biaxial Stress Assessment.xls
2008 Jan. 08171This file is located in the Fatigue folder. EC3 Fatigue Damage in Steel Welds.xls
2008 Jan. 08123This file is located in the Fatigue folder. Fatigue Damage in Steel Welds.xls
2008 Jan. 03516This file is located in the Finite Element folder. Taki FE Spreadsheet 03 - elastica.xls
2008 Jan. 03241This file is located in the Finite Element folder. Taki FE Spreadsheet 02 - bolted_joint_070506.xls
2008 Jan. 03401This file is located in the Finite Element folder. Taki FE Spreadsheet 01 - truss_070505.xls
2007 Dec. 10440This file is located in the Materials folder. Material Selection in Mechanical Design.xls
2007 Dec. 09448This file is located in the Beams folder. CurvedBeams.xls
2007 Dec. 09381This file is located in the Beams folder. EC3 Calculations V0001.xls
2007 Dec. 06176This file is located in the Fatigue folder. Fatigue Damage in Aluminium Welds.xls
2007 Dec. 06293This file is located in the Materials folder. True Stress True Strain.xls
2007 Nov. 30294This file is located in the Materials folder. Carbon Equivalent.xls
2007 Nov. 216This file is located in the Materials folder. Shodor Weblink - Behavior of metallic materials
2007 Oct. 29523This file is located in the Plates folder. Rectangular plate loaded with circular load at centre.xls
2007 Oct. 262373This file is located in the Add-Ins folder. xxxEXPIREDxxx XLC 09_07 Installation.zip
2007 Oct. 011008This file is located in the Links folder. Dennis Kirks Engineering Calculations
2007 Sep. 26564This file is located in the Miscellaneous folder. Scissor Lift Mechanism.xls
2007 Sep. 26125This file is located in the Beams folder. Point load on propped cantilever V0001.xls
2007 Sep. 161146This file is located in the Welds folder. gowelding.com Weld Calculations
2007 Sep. 161049This file is located in the Beams folder. beams.xls
2007 Sep. 12300This file is located in the Links folder. asap utilities
2007 Sep. 07980This file is located in the Buckling folder. Flat plate buckling.xls
2007 Aug. 31427This file is located in the Buckling folder. curved plate buckling stress.xls
2007 Aug. 30268This file is located in the Coordinates folder. Circle through three points.xls
2007 Jul. 16203This file is located in the Welds folder. Welded Square Base Plate.xls
2007 Jul. 05613This file is located in the Bolts and Threads folder. BoltedJoint.xls
2007 Jun. 251147This file is located in the Vessels folder. Basic Pressure Vessel Stress.xls
2007 Jun. 22382This file is located in the Bolts and Threads folder. Power Screw.xls
2007 Jun. 21378This file is located in the Maths folder. transformation matrix.xls
2007 Jun. 04449This file is located in the Maths folder. simultaneous equations.xls
2007 May. 293207This file is located in the Add-Ins folder. xxxEXPIREDxxx XLC 06_07 Installation.zip
2007 Apr. 271042This file is located in the Add-Ins folder. xxxEXPIREDxxx XLC 05_07 Installation.zip
2007 Apr. 192082This file is located in the Add-Ins folder. xxxEXPIREDxxx XLC Beta Installation.zip
2007 Mar. 08459This file is located in the Maths folder. www.vbnumericalmethods.com
2007 Mar. 07615This file is located in the Links folder. yakpol
2007 Mar. 07728This file is located in the Links folder. EngineeringSpreadsheets
2007 Mar. 06252This file is located in the Maths folder. www.vertex42.com
2007 Feb. 16604This file is located in the Links folder. XlXtrFun Extra Functions for Microsoft Excel
2007 Jan. 24194This file is located in the Welds folder. Weld throat calculation from plate stress V0001.xls
2007 Jan. 24170This file is located in the Welds folder. Weld line assessment - C shaped V0001.xls
2007 Jan. 24191This file is located in the Welds folder. Weld line assessment - 2 vertical welds V0001.xls
2007 Jan. 24287This file is located in the Welds folder. Weld line assessment - 2 horizontal welds V0001.xls
2007 Jan. 24100This file is located in the Beams folder. UDL on simply supported and guided beam V0001.xls
2007 Jan. 2464This file is located in the Beams folder. UDL on propped cantilever V0001.xls
2007 Jan. 2493This file is located in the Beams folder. UDL on guided cantilever V0001.xls
2007 Jan. 24180This file is located in the Beams folder. UDL on cantilever V0001.xls
2007 Jan. 24105This file is located in the Beams folder. UDL on built in beam V0001.xls
2007 Jan. 24265This file is located in the Beams folder. UDL on a propped cantilever V0001.xls
2007 Jan. 2472This file is located in the Torsion folder. Torsion - Solid square section V0001.xls
2007 Jan. 24130This file is located in the Torsion folder. Torsion - Solid rectangular section V0001.xls
2007 Jan. 2465This file is located in the Torsion folder. Torsion - Solid elliptical section V0001.xls
2007 Jan. 24139This file is located in the Torsion folder. Torsion - Solid circular section V0001.xls
2007 Jan. 2464This file is located in the Torsion folder. Torsion - Solid Triangular section (equilateral) V0001.xls
2007 Jan. 2471This file is located in the Torsion folder. Torsion - Isosceles Triangle V0001.xls
2007 Jan. 2464This file is located in the Torsion folder. Torsion - Hollow, thin-walled section of uniform thickness V0001.xls
2007 Jan. 2450This file is located in the Torsion folder. Torsion - Hollow elliptical section, outer and inner boundaries similar ellipses V0001.xls
2007 Jan. 24186This file is located in the Torsion folder. Torsion - Hollow concentric circular section V0001.xls
2007 Jan. 2482This file is located in the Torsion folder. Torsion - Eccentric hollow circular section V0001.xls
2007 Jan. 2483This file is located in the Torsion folder. Torsion - Circular shaft with opposite sides flattened V0001.xls
2007 Jan. 2487This file is located in the Torsion folder. Torsion - Circular segmental section V0001.xls
2007 Jan. 24166This file is located in the Torsion folder. Torsion - Circular sector V0001.xls
2007 Jan. 2467This file is located in the Convection folder. Time to heat shaft to a given temperature V0001.xls
2007 Jan. 24342This file is located in the Bolts and Threads folder. Tightening torque calculation for screw V0001.xls
2007 Jan. 2499This file is located in the Conduction folder. Thermal conductivity calculation V0001.xls
2007 Jan. 2430This file is located in the Beams folder. Temperature effect on simply supported beam V0001.xls
2007 Jan. 2476This file is located in the Beams folder. Temperature effect on simply supported and guided beam V0001.xls
2007 Jan. 2474This file is located in the Beams folder. Temperature effect on propped cantilever V0001.xls
2007 Jan. 2475This file is located in the Beams folder. Temperature effect on guided cantilever V0001.xls
2007 Jan. 2482This file is located in the Beams folder. Temperature effect on cantilever V0001.xls
2007 Jan. 24106This file is located in the Beams folder. Temperature effect on built in beam V0001.xls
2007 Jan. 2460This file is located in the Combined folder. Surface temperature convection coefficient and emissivity of a person in the room V0001.xls
2007 Jan. 241517This file is located in the Fluid Mechanics folder. Surface shear stress in parallel flow over a flat plate V0001.xls
2007 Jan. 2469This file is located in the Radiation folder. Surface radiation example V0001.xls
2007 Jan. 24117This file is located in the Conduction folder. Steady state heat transfer conduction plus convection V0001.xls
2007 Jan. 24220This file is located in the Welds folder. Static load capacity of the transverse-loaded fillet welds V0001.xls
2007 Jan. 24303This file is located in the Welds folder. Static load capacity of the parallel loaded fillet welds V0001.xls
2007 Jan. 2437This file is located in the Conduction folder. Size and surface temperature of a cubical freezer V0001.xls
2007 Jan. 24492This file is located in the Single DOF folder. Single DOF Dynamics - Spring with attached mass V0001.xls
2007 Jan. 24104This file is located in the Conduction folder. Simple 1D thermal conductivity calculations V0001.xls
2007 Jan. 24266This file is located in the Shafts folder. Shear stress in hollow shaft V0001.xls
2007 Jan. 24220This file is located in the Shafts folder. Shear stress and angle of twist of shaft under torsion V0001.xls
2007 Jan. 24160This file is located in the Shafts folder. Shaft stress and deflection V0001.xls
2007 Jan. 24257This file is located in the Shafts folder. Shaft design V0001.xls
2007 Jan. 24174This file is located in the Pins and Joints folder. S-hook design V0001.xls
2007 Jan. 24276This file is located in the Buckling folder. Rod buckling V0001.xls
2007 Jan. 24424This file is located in the Beams folder. Reinforced concrete calculation V0001.xls
2007 Jan. 2480This file is located in the Stress folder. Reinforced circular hole in a wide plate - axial tension V0001.xls
2007 Jan. 2446This file is located in the Combined folder. Rectangular verses triangular cooling fin effectiveness V0001.xls
2007 Jan. 2487This file is located in the Stress folder. Rectangular hole with round corners in an infinate plate - axial tension V0001.xls
2007 Jan. 24103This file is located in the Radiation folder. Radiation solar flux on earth V0001.xls
2007 Jan. 24112This file is located in the Combined folder. Radiation and convection heat transfer to large surroundings V0001.xls
2007 Jan. 24111This file is located in the Miscellaneous folder. Punch Press shaft power and torque V0001.xls
2007 Jan. 24147This file is located in the Areas folder. Property Of Sections - Wide flange beam with equal flanges V0001.xls
2007 Jan. 2477This file is located in the Areas folder. Property Of Sections - Very thin annulus V0001.xls
2007 Jan. 2475This file is located in the Areas folder. Property Of Sections - Triangle V0001.xls
2007 Jan. 24101This file is located in the Areas folder. Property Of Sections - Trapezoid V0001.xls
2007 Jan. 24128This file is located in the Areas folder. Property Of Sections - Tee Section V0001.xls
2007 Jan. 2461This file is located in the Areas folder. Property Of Sections - Square V0001.xls
2007 Jan. 2484This file is located in the Areas folder. Property Of Sections - Solid semi-circle V0001.xls
2007 Jan. 2460This file is located in the Areas folder. Property Of Sections - Solid ellipse V0001.xls
2007 Jan. 2472This file is located in the Areas folder. Property Of Sections - Solid Circle V0001.xls
2007 Jan. 2485This file is located in the Areas folder. Property Of Sections - Segment of a solid circle V0001.xls
2007 Jan. 2468This file is located in the Areas folder. Property Of Sections - Sector of a solid circle V0001.xls
2007 Jan. 24126This file is located in the Areas folder. Property Of Sections - Sector of a hollow circle V0001.xls
2007 Jan. 2485This file is located in the Areas folder. Property Of Sections - Regular Polygon V0001.xls
2007 Jan. 2498This file is located in the Areas folder. Property Of Sections - Rectangle V0001.xls
2007 Jan. 2429This file is located in the Areas folder. Property Of Sections - Parallelogram V0001.xls
2007 Jan. 2489This file is located in the Areas folder. Property Of Sections - Isosceles Triangle V0001.xls
2007 Jan. 2490This file is located in the Areas folder. Property Of Sections - Hollow semi-ellipse with constant wall thickness V0001.xls
2007 Jan. 2440This file is located in the Areas folder. Property Of Sections - Hollow ellipse constant wall thickness V0001.xls
2007 Jan. 24105This file is located in the Areas folder. Property Of Sections - Hollow ellipse V0001.xls
2007 Jan. 2441This file is located in the Areas folder. Property Of Sections - Hollow Regular Polygon V0001.xls
2007 Jan. 24176This file is located in the Areas folder. Property Of Sections - Hollow Rectangle V0001.xls
2007 Jan. 24138This file is located in the Areas folder. Property Of Sections - Hollow Circle V0001.xls
2007 Jan. 2489This file is located in the Areas folder. Property Of Sections - Equilateral Triangle V0001.xls
2007 Jan. 24113This file is located in the Areas folder. Property Of Sections - Equal-Legged Angle V0001.xls
2007 Jan. 24120This file is located in the Areas folder. Property Of Sections - Diamond V0001.xls
2007 Jan. 24303This file is located in the Areas folder. Property Of Sections - Channel Section V0001.xls
2007 Jan. 24288This file is located in the Bolts and Threads folder. Power screw calculations V0001.xls
2007 Jan. 2471This file is located in the Convection folder. Power required to overcome drag force at a given velocity V0001.xls
2007 Jan. 2486This file is located in the Beams folder. Point moment simply supported and guided beam V0001.xls
2007 Jan. 24113This file is located in the Beams folder. Point moment on simply supported beam V0001.xls
2007 Jan. 2492This file is located in the Beams folder. Point moment on propped cantilever V0001.xls
2007 Jan. 2495This file is located in the Beams folder. Point moment on guided cantilever V0001.xls
2007 Jan. 24143This file is located in the Beams folder. Point moment on cantilever V0001.xls
2007 Jan. 24124This file is located in the Beams folder. Point moment on built in beam V0001.xls
2007 Jan. 24288This file is located in the Beams folder. Point load on simply supported beam V0001.xls
2007 Jan. 24145This file is located in the Beams folder. Point load on guided cantilever V0001.xls
2007 Jan. 24251This file is located in the Beams folder. Point load on cantilever V0001.xls
2007 Jan. 24216This file is located in the Beams folder. Point load on built in beam V0001.xls
2007 Jan. 24268This file is located in the Structural Details folder. Plates straps and rivets V0001.xls
2007 Jan. 2485This file is located in the Stress folder. Off- Centre Circular hole in a member of rectangular cross section-axial tension V0001.xls
2007 Jan. 2488This file is located in the Stress folder. Off- Centre Circular hole in a member of rectangular cross section- in plane bending V0001.xls
2007 Jan. 2472This file is located in the Stress folder. Off Centre Elliptical hole in a member of rectangular cross section - axial tension V0001.xls
2007 Jan. 24280This file is located in the Materials folder. Material non-linearities S304L V0001.xls
2007 Jan. 2493This file is located in the Combined folder. Mass and heat transfer - evaparation V0001.xls
2007 Jan. 24139This file is located in the Combined folder. Heat transfer in cooling fins V0001.xls
2007 Jan. 2450This file is located in the Conduction folder. Heat transfer in a pan V0001.xls
2007 Jan. 2494This file is located in the Combined folder. Heat transfer coefficient between sphere and air stream V0001.xls
2007 Jan. 24111This file is located in the Combined folder. Heat transfer by conduction and convection - electrical circuit analogy V0001.xls
2007 Jan. 2462This file is located in the Combined folder. Heat loss through single pane of glass V0001.xls
2007 Jan. 2480This file is located in the Conduction folder. Heat loss through single glass pane V0001.xls
2007 Jan. 2456This file is located in the Conduction folder. Heat loss through insulated food container V0001.xls
2007 Jan. 2477This file is located in the Conduction folder. Heat loss through freezer walls by condiction V0001.xls
2007 Jan. 24153This file is located in the Combined folder. Heat loss through a composite wall of three materials V0001.xls
2007 Jan. 24177This file is located in the Combined folder. Heat loss in duct V0001.xls
2007 Jan. 2477This file is located in the Combined folder. Hand experiencing convection heat transfer with moving air and water V0001.xls
2007 Jan. 2449This file is located in the Radiation folder. Emissivity of spherical interplanetary probe V0001.xls
2007 Jan. 24102This file is located in the Stress folder. Elliptical hole in an infinite plate in plane stress V0001.xls
2007 Jan. 24104This file is located in the Combined folder. Effect of wind chill V0001.xls
2007 Jan. 2467This file is located in the Radiation folder. Effect of solar flux.xls
2007 Jan. 2462This file is located in the Conduction folder. Effect of co-ordinate system on thermal gradient calculations V0001.xls
2007 Jan. 2454This file is located in the Convection folder. Drag force in air flow V0001.xls
2007 Jan. 24355This file is located in the Fatigue folder. Crack in a thin plate V0001.xls
2007 Jan. 2476This file is located in the Conduction folder. Compare thermal resistance of three walls V0001.xls
2007 Jan. 2472This file is located in the Convection folder. Compare convection coefficients for the water and air flow V0001.xls
2007 Jan. 24141This file is located in the Stress folder. Circular hole in an infinite plate - plane stress V0001.xls
2007 Jan. 2480This file is located in the Stress folder. Circular hole in an infinite plate - out-of-plane bending V0001.xls
2007 Jan. 2482This file is located in the Stress folder. Central Elliptical hole in a member of rectangular cross section - in plane bending V0001.xls
2007 Jan. 24120This file is located in the Stress folder. Central Elliptical hole in a member of rectangular cross section - axial tension V0001.xls
2007 Jan. 24105This file is located in the Stress folder. Central Circular hole in a member of rectangular cross section- out of plane bending V0001.xls
2007 Jan. 2469This file is located in the Stress folder. Central Circular hole in a member of rectangular cross section- Elastic stress, in-plane bending V0001.xls
2007 Jan. 24108This file is located in the Stress folder. Central Circular hole in a member of rectangular cross section- Elastic stress, axial tension V0001.xls
2007 Jan. 2468This file is located in the Convection folder. Cartridge heater - Heater power - Convection coefficients in air V0001.xls
2007 Jan. 24755This file is located in the Welds folder. Calculate Fillet Weld stress from parent plate stresses V0001.xls
2007 Jan. 24267This file is located in the Ropes and Cables folder. Cable Sagging Level Span V0001.xls
2007 Jan. 24439This file is located in the Ropes and Cables folder. Cable Sagging Inclined Span V0001.xls
2007 Jan. 24176This file is located in the Convection folder. Annual cost of heat loss through pipes.xls
2007 Jan. 11557This file is located in the Finance folder. www.businessfunctions.com

A total of 219 unique files.

Your uploads account for 51% of all site downloads.