BRAE_433 Two way table example- excel 2003

BRAE_433 Two way table example- excel 2003 - BRAE 433...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BRAE 433 Example Problem from Class for a 2-Way Table Non-Reinforced Concrete Beam Steps 1 Create the equations for a problem (B6:D17) b (width) = 2.0 in 2 Create the column heading values to be evaluated (C15:K15) h (depth) = 4.0 in 3 Create the row heading values to be evaluated (B16:B32) l (length) = 1.0 ft 4 Reference the cell to be solved (C17) in the table at the anchor cell B23 (just type in "+C17" at B23) 4000.0 psi (compressive strength) 5 Highlight the table to be created (B23:K40) 474.3 psi (modulus of rupture) 6 Z = 2.7 in 7 Specific Wt = 145.0 8 DL (dead Load) = 8.1 #/ft 9 The table will then be automatically created. LL (live Load) = 0.0 #/ft C = 948.7 # M = 210.8 ft-# Pmax = 839.2 # P = (M – wL^2/8)/(L/4) Table of Maximum Load in Lbs to Crack a Non-Reinforced Beam h - Depth (in) 839.2 1.0 1.5 2.0 2.5 3.0 3.5 4.0 4.5 5.0 b - Width (in) 1.0 26 59 104 163 236 321 420 531 656 1.5 39 88 157 245 353 482 629 797 984 2.0 52 117 209 327 471 642 839 1,063 1,313
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online