Method of Joints Truss Analysis Matrix Method using MS Excel

[@ll-tr7hh]

you saved me A LOT of trouble

[@DRabvyas]

Thanks much for your appreciation.

[@jordanz6592]

So by using excel you can change the location of the load of the 10kN by moving it on the second matrix and it will then solve the load from said joint

[@alexeyvoronin4651]

This approach will work only for statically determinate truss. What about undetermined truss?

[@DRabvyas]

Correct. One would have to use different method for statically indeterminate trusses. I do not intend to make that video as there were already few videos out there for statically indeterminate trusses when I had uploaded this video.

[@alexeyvoronin4651]

@@DRabvyas I am looking for good example of how to solve undetermined truss on computer. Maybe you can refer me to one. i was not able to find. Only those solved by human.

[@DRabvyas]

@@alexeyvoronin4651 kzbin.info/www/bejne/i4Syp6h3o8SjqsU Hope this helps.

[@prasads56]

I got a singular matrix for a symmetric truss.... What should I doo now?

[@DRabvyas]

Not sure. Maybe you have two rows that are nearly identical or one is multiple of other.

[@prasads56]

@@DRabvyas its a 16 joint truss...and i have 32 square size matrix.... Its so hard to input all values but at last i got zero as determinant..🤗😑😑

[@DRabvyas]

@@prasads56 Your matrix entry/calculations are in error or that your truss is defective. Sorry, I cannot help you more at this juncture, and advise you to consult with your instructor.

[@abokalil111]

did you have a reference for this problem that i can use

[@DRabvyas]

No, I created this problem myself. However, if you are looking for a recommendation, I recommend the textbook, Engineering Mechanics: Statics, 2nd edtion by Plesha, Gray, and Costanzo (McGraw-Hill).

[@diegofqmc3141]

Dear Mr Anand... What happen if the matrix is singular? What do we have to do?

[@DRabvyas]

If matrix is singular, either you have an error in your calculations, or that your truss is statically indeterminate. If the latter is true, the truss can no longer be assumed to be rigid, and concepts of deformation of the member will have to be employed (which is typically beyond the scope of a course in Statics/Engineering Mechanics at most universities). Hope this helps.

[@diegofqmc3141]

@@DRabvyas Thank you so much for your help... It helps me a lot. I made a mistake in my calculations, I could solve the system. I would like to ask if I can use this method in or order to calculate a Tridimensional Truss? Do I have to chance only the size of the matrix?

[@DRabvyas]

@DIEGO QUIZANGA For a 3-D truss (assuming it is not statically indeterminate), you have 3 equations at each joint resulting from the static force balance. An example of such a problem is to be found in the textbook on Statics by Plesha, Gray, and Costanzo , 2nd edtion, page 402 (McGraw-Hill publication). You can use the matrix method in that case as well, except that matrix will have more variables (so more rows and columns)

[@emustafov]

Mr.Anand how exacly did you got the stiffnes matrix?

[@DRabvyas]

Erdoan Musatfov Thank you for your interest and question.This is not stiffness matrix, just coefficient matrix resulting from the force balance equations at each joint of the truss without regard for material properties.

[@robbiegolds1234]

@@DRabvyas But with this information now you can

[@ZulTakHensem]

@@DRabvyas sir. Which method is efficient for solving trusses by using excel?

[@DRabvyas]

@@ZulTakHensem Depends on what you need to determine. If it is force in very few members, you are better off using method of sections. On the other hand, if you need to find forces in all members, use method of joints. If you need to tinker around with how change in loading will change forces, use the matrix method shown here. For anything else (like stresses and strains), it is best to use Finite Element Analysis based methods.

[@ZulTakHensem]

@@DRabvyas thank you sir. I dont expect you gonna reply this very quick 😆

[@HerbstundSturm]

Could you use this for a 3d-truss too?

[@DRabvyas]

Thank you for the question. Yes, provided that the truss is statically determinate and the static equilibrium equations in 3-D are deduced correctly.

[@tharunsankar4926]

oh definitely, just define your origin point, the angles associated by it. But note that you might have to do some Euler Rotations to obtain the global matrix like what Anand did. (You could avoid all of it by picking the right origin axis)

[@preciousartual895]

sir, what if the result of det(A) is #### what would I do?

[@DRabvyas]

Please stretch/elongate that cell for MS Excel to reveal actual numbers. You might have to add more decimal places using one of the buttons in the ribbon above the spreadsheet.

[@preciousartual895]

@@DRabvyas sorry sir, i mean the result is VALUE!

[@DRabvyas]

@@preciousartual895 Please refer to MS Excel help on how to use the command, "mdeterm". I am afraid there might be an error in execution somewhere. Hope this helps and best wishes for success.

[@preciousartual895]

Thank you sir.

[@DRabvyas]

@@preciousartual895 You are welcome!

[@amrounesalah8706]

tres bonne video merci pour le partage

[@DRabvyas]

Merci beaucoup pour votre appréciation (Pardon my French, I used Google Translate)

[@Iifesteal]

Very helpful vid, thanks

[@DRabvyas]

Thank you for the appreciation. I am glad you found it helpful.

[@bradleyscott9436]

Absolute legend!

[@DRabvyas]

Thank you!

[@maufrance4888]

Hello Mr. Anand Vyas, hope you can help me in my excel project which involves method of joints in a differently shaped truss. I'm hoping I could reach to you privately. Hoping for your reply. Your help will be greatly appreciated . thank you

[@mahmoudalfitory835]

it is a nise way thank you*************

[@DRabvyas]

+Mahmoud Alfitory Thank you for your appreciation. I hope it helped.

[@diflection1]

Looking good!

[@DRabvyas]

The purpose of my video-clips is to give just enough to inspire others to do more with what is provided, or to ignite thinking. If you have learnt it well, you will not need others to tell you whether your answers or methods are right or wrong. Best wishes for your future explorations.