Graphing Shear and Moment using singuarity function in Excel

In summary, to use the singularity function in Excel for graphing shear and moment diagrams, you will need to input data points for each type of load into separate columns and use the "Insert Function" feature to select the "SINGULARITY" function. This function allows you to specify the location and magnitude of the singularity, and you can plot the resulting curves on a graph. The singularity function can be used for any type of beam structure and there is no limit to the number of data points that can be inputted. The accuracy of the diagrams will depend on the accuracy of the data and you can export the diagrams to other software or documents.
  • #1
mingyz0403
12
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: 217
  • 2.jpg
    2.jpg
    16.2 KB · Views: 213
Physics news on Phys.org
  • #2
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: 234

FAQ: Graphing Shear and Moment using singuarity function in Excel

What is a singularity function in Excel?

A singularity function in Excel is a mathematical function that represents a discontinuity or abrupt change in a graph. It is commonly used in engineering and physics to model forces or moments acting on a structure.

How do I create a singularity function in Excel?

To create a singularity function in Excel, you will need to use the IF and ABS functions. The IF function will determine if a condition is met, and the ABS function will return the absolute value of a number. By combining these functions, you can create a singularity function that will return a value of 0 if the condition is not met, and a different value if the condition is met.

What is the purpose of graphing shear and moment using singularity function in Excel?

The purpose of graphing shear and moment using singularity function in Excel is to visualize the changes in forces or moments acting on a structure. This can help engineers and scientists to analyze the structural integrity of a system and make informed decisions about design and construction.

Can I use singularity function in Excel for non-engineering applications?

Yes, singularity function can be used for non-engineering applications as well. It can be used to model any type of discontinuity or abrupt change in a graph, such as changes in temperature, pressure, or financial data.

Are there any limitations to using singularity function in Excel?

One limitation of using singularity function in Excel is that it can only model simple discontinuities. For more complex situations, other software or mathematical methods may be required. Additionally, the accuracy of the singularity function may be affected by the size of the interval used for the graph.

Similar threads

Engineering Cantilever and encastré beams: bending moment and shear force
Replies
2
Views
2K
Engineering Statics project involving shear & moment diagram of a control arm
Replies
3
Views
1K
Engineering Shear stress problem: What decides the sign of Tau_V?
Replies
2
Views
1K
Shear and Moment Diagram Equations
Replies
2
Views
1K
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
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
3K
Find an expression for the shear stress of this figure
Replies
1
Views
2K
Engineering Need help in solving SDOF cantilever
Replies
1
Views
921

Hot Threads

Recent Insights

Back
Top