Monday, July 31, 2006

Roark's Formulas for Excel Tutorial II

Five Quick Problems - Part 2 of 5

Problem 2

Let’s extend Problem 1 (Thursday, July 27) by adding beam support and load information. Specifically, assume that the beam will be steel, 6 ft long, fixed at both ends, with a maximum concentrated load of 2000 lbf at the center. You want to determine the deflection and stress values.

Open the Roark’s Formulas for Excel Explorer and select Table A.1, Case 3 (hollow rectangular cross-section). Then select Table 8.1, Case 1d and add this to the previous case selection.



Click the Standard User Mode button to continue.

Once loaded into Excel the Worksheet looks as follows:





Now, enter the cross section dimensions in the Worksheet. Simply move to the Value column of the relevant variable and enter the data.






Neutral Axis1
Side b1.5 in
Hollow side bi1.3125 in
Side d2.75 in
Hollow side di2 in

Note the revised Excel Worksheet.




amazing 

counters
Dell Computer Deals