Turan Babacan's Fantastic Beam Analysis Spreadsheet

Turan Babacan has sent a new version of EXCsta2D. It has an improved user interface and results presentation. Just marvel how Turan uses Excel in such an innovative way. Turan teaches even Excel veterans new spreadsheet techniques and Excel tricks. This is truly great 2D beam analysis method and an essential download for all engineers.

Turan tells us a little about himself. "I was born in Trabzon in 1964. I am a civil engineer. I do amateur software since 1986. C + +, VB, VBA, Prolog and Fortran languages I know. From the project since 1990 I am working in the manufacturing sector. "Steel buildings, Substructure and road engineering," I'm experienced Excel is 'my hand up my arm'. I am currently working in Istanbul."

BABACAN (User)

Turan we are delighted to have such an accomplished user sharing his work on the ExcelCalcs site. Thank you.

	EXCsta.xls - 2D Frame Analysis Video
	Watch this video to see Turan Babacan's static structural analysis spreadsheet for 2D linear elastic frames in action. Computes the static deflections, reactions, internal element forces using direct stiffness methods.

Repository News

The ExcelCalcs repository continues to grow and we are delighted to receive calculations from you. Remember we reward calculation donations with free XLC Pro subscriptions.

This new worksheet was developed to help high school children understand quadratic forulae but you might find it useful yourself.
intersect_circle_line.xls

InfoJunkie65 (User)  Pre-Engineered Manufactured Structural Building Products

Infojunkies starts a discussion of manufactured structural products and a potential central location to point to various ExcelCalcs worksheets suitable and useful to such industry. He has uploaded all the following Repository items in support of his discussion:
Excel/VBA Tutorials
VBA Experiments with Abstract Data Structures
VBA Experiments with Class Objects
VBA Experiments with ACAD Script Automation
VBA Experiments Parsing ACAD DXF files
IE/POM/CAPM Automatic Explosion of Bill of Materials
CAD: Automatic generation of framing plans and elevations simple gable frame
CAD: Experiments with DesignCAD: Draw 3D framing of American Barn type structure
Dimension and Geometry of Gable Frame shed Frame Member Lengths and Bracing Lengths
Estimating: Hole punching requirements for rollformed sections

krugerprojects (User)
Uploads a new calculation:
ZI Properties of plate beam.xls

DL12345 (User) uploads a new calculation:
Cantilever Grating.xls

Solar (User)  Posts an article about More Effective Photo Voltaic Panels

Our Consultancy Projects - Test & Analysis Of Electrical Shoe Gear

Monitor electrical pick-up shoe on train in-service.


Stain gauges, accelerometers & GPS attached.


Position of shoe monitored by strain gauge on return spring.


Shock loads measured by accelerometer.


GPS record of speed profile.


GPS maps peak loads using Google maps.


Design calculations show 200 fold increase in fatigue life.


SN Curve developed for new shoe design.
 

Training Modules...

Select  your own course from the ExcelCalcs training modules.

• XLC and ExcelCalcs
  
• Bolting and mechanical fasteners
  
• Welding and joining materials
  
• Static strength and fatigue design
  
• Pins and lugs
  
• Failure criteria and biaxial stress assessment
  
• Material properties and material selection
  
• Steel and aluminium design
• Fatigue of welded structures
  
• Fracture mechanics
  
• Strain gauge or calculate?
  
• Failure Investigations
  
• Design for impact loads and dynamic effects