Engineering Graphing Shear and Moment using singuarity function in Excel

Click For Summary
SUMMARY

The discussion focuses on calculating and graphing the singularity function for shear and moment in Excel. The user reports discrepancies in shear force calculations, specifically noting that while the expected value is 30 kips for X > 6, Excel outputs 48 kips. The conversation highlights the need for accurate equation formulation and proper application of the singularity function in Excel to achieve correct results.

PREREQUISITES
  • Understanding of singularity functions in structural analysis
  • Proficiency in Microsoft Excel, particularly with graphing tools
  • Basic knowledge of shear and moment diagrams
  • Familiarity with engineering mechanics concepts
NEXT STEPS
  • Research the application of singularity functions in structural analysis
  • Learn advanced Excel graphing techniques for engineering applications
  • Explore troubleshooting methods for Excel calculations
  • Study shear and moment diagram construction for various loading conditions
USEFUL FOR

Structural engineers, civil engineering students, and anyone involved in analyzing shear and moment in beams using Excel.

mingyz0403
Messages
12
Reaction score
1
Homework Statement
By Using singuarity function and Excel, plot shear and moment diagrams of the beam.
Relevant Equations
Shear and moment singuarity function
I had found the singuarity function for the shear and moment. I have a hard time calculating the singuarity function and graphing it using excel. Can anyone explain how to calculate singuarity function and graphing it using excel?

Many thanks for your help
 

Attachments

  • 1.jpg
    1.jpg
    25.5 KB · Views: 276
  • 2.jpg
    2.jpg
    16.2 KB · Views: 275
Physics news on Phys.org
This is what I have done so far. Everything seems correct When X<6. When X>6, the calculation is wrong.The Shear force should be 30 kips. However, in Excel it was 48 kips.Could anyone tell what is wrong with my equation?

Many thanks for your help.
 

Attachments

  • 3.jpg
    3.jpg
    71.9 KB · Views: 284

Similar threads

Bending Stress and Shear Stress
  • · Replies 2 ·
Replies
2
Views
3K
How Do I Draw This Shear and Moment Diagram?
  • · Replies 12 ·
Replies
12
Views
1K
Engineering Cantilever and encastré beams: bending moment and shear force
  • · Replies 2 ·
Replies
2
Views
3K
Engineering Statics project involving shear & moment diagram of a control arm
  • · Replies 3 ·
Replies
3
Views
2K
Engineering Shear stress problem: What decides the sign of Tau_V?
  • · Replies 2 ·
Replies
2
Views
2K
Shear and Moment Diagram Equations
  • · Replies 2 ·
Replies
2
Views
2K
Engineering Transverse shear stress calculation in non-slender built up members
  • · Replies 6 ·
Replies
6
Views
2K
Engineering Calculating shear center for a "skewed" I beam
  • · Replies 1 ·
Replies
1
Views
2K
Engineering Instantaneous Center of Rotation (Polplan in german) and STATICS
  • · Replies 1 ·
Replies
1
Views
2K
Engineering Calculating Shear and Tensile force in a rivet at an angle
  • · Replies 1 ·
Replies
1
Views
3K