Graphing Shear and Moment using singuarity function in Excel

• Engineering
• mingyz0403
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.
mingyz0403
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?

Attachments

• 1.jpg
25.5 KB · Views: 189
• 2.jpg
16.2 KB · Views: 183
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?

Attachments

• 3.jpg
71.9 KB · Views: 211

1. 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.

2. 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.

3. 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.

4. 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.

5. 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.

• Engineering and Comp Sci Homework Help
Replies
2
Views
992
• Engineering and Comp Sci Homework Help
Replies
2
Views
2K
• Engineering and Comp Sci Homework Help
Replies
2
Views
1K
• Engineering and Comp Sci Homework Help
Replies
3
Views
1K
• Engineering and Comp Sci Homework Help
Replies
1
Views
872
• Engineering and Comp Sci Homework Help
Replies
6
Views
1K
• Engineering and Comp Sci Homework Help
Replies
8
Views
2K
• Engineering and Comp Sci Homework Help
Replies
2
Views
1K
• Engineering and Comp Sci Homework Help
Replies
1
Views
2K
• Engineering and Comp Sci Homework Help
Replies
1
Views
666