BRAE_433 Two way table example- excel 2003

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

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

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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Ask a homework question - tutors are online