calculating beam bending and shear calculation by using excel

[bakalinlinz]

How to use microsoft excel to perform analysis for a simply support beam with a point load imposed on it?

span 12m, point load 3kN, position of point load 5m

Input : length, distance to load and the point load

Output :distance from load to end, left reaction, right reaction and the max moment

wat formula should i insert in order to find all the output while the input is manupulating variables?

[Andy Pope]

Check out this blog
http://newtonexcelbach.wordpress.com/

[chanduvba]

Hi,

I want to create a Macro for extracting inventory data from another excel workbook/sheet. I should be able to submit a item number and that should give out the entire row. How do I create a macro? Please help.

Thanks,
Chanduvba

[arlu1201]

Chanduvba,

Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.