Engineering Graphing Shear and Moment using singuarity function in Excel

AI Thread Summary
The discussion focuses on using the singularity function to calculate shear and moment in Excel. The user is struggling with the calculations, particularly when X is greater than 6, where the expected shear force is 30 kips, but Excel shows 48 kips instead. Assistance is requested to clarify the calculation process and identify potential errors in the equations used. The user believes their approach is correct for values of X less than 6. Accurate calculation and graphing of shear and moment using the singularity function in Excel are essential for resolving the discrepancies.
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: 263
  • 2.jpg
    2.jpg
    16.2 KB · Views: 259
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: 274
Thread 'Have I solved this structural engineering equation correctly?'

Thread 'Have I solved this structural engineering equation correctly?'

Hi all, I have a structural engineering book from 1979. I am trying to follow it as best as I can. I have come to a formula that calculates the rotations in radians at the rigid joint that requires an iterative procedure. This equation comes in the form of: $$ x_i = \frac {Q_ih_i + Q_{i+1}h_{i+1}}{4K} + \frac {C}{K}x_{i-1} + \frac {C}{K}x_{i+1} $$ Where: ## Q ## is the horizontal storey shear ## h ## is the storey height ## K = (6G_i + C_i + C_{i+1}) ## ## G = \frac {I_g}{h} ## ## C...
View full post »

Similar threads

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

Hot Threads

Recent Insights

Back
Top