CEE111 - Design Exs #1 - Excel Calcs

CEE111 - Design Exs #1 - Excel Calcs - 2500 253.076166...

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

View Full Document Right Arrow Icon
Given Table Material Yield E Cost Density Aluminum 35000 10200000 $1.05 0.1 18 30 $18.90 $31.50 *A 89.011791852 Stainless Steel 40000 27600000 $1.85 0.292 52.56 87.6 $97.24 $162.06 *A 240.85543678 Carbon Steel 30000 29000000 $0.40 0.284 51.12 85.2 $20.45 $34.08 *A 253.07274154 Structural Analysis Scientific Notation 1500 T 300 1000000 0 T 0.6 1500 C 180 2000 T B 2500 T Bar A Bar B Bar A Bar B Variables: Area 0.5 5.30225 Total Cost Variables: Area 0.5 3.2215 Total Cost Minimize Cost $18.90 $31.50 $176.47 Minimize Cost 97.24 162.06 $570.70 Aluminum S. Steel Constraints Calculation Constraints $*A Cost $18.90 $31.50 $10.00 <= $1,000.00 $*A Cost 97.24 162.06 $570.70 <= $1,000.00 Area 1 0 0.5 >= 0.5 Area 1 0 0.5 >= 0.5 Area 0 1 5.30225 >= 0.5 Area 0 1 3.2215 >= 0.5 B/(Area^2) 0 2500 88.9241264 <= 89.0117918517 B/(Area^2) 0 2500 240.892754 <= 240.85543678 B/Area 1500 0 3000 <= 35000 B/Area 1500 0 3000 <= 40000 B/Area 0 2500 471.497949 <= 35000 B/Area 0 2500 776.036008 <= 40000 Bar A Bar B Variables: Area 0.5 3.143 Total Cost Minimize Cost $20.45 $34.08 $117.34 C. Steel Constraints $*A Cost $20.45 $34.08 $117.34 <= $1,000.00 Area 1 0 0.50 >= 0.5 Area 0 1 3.14 >= 0.5 B/(Area^2)
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2500 253.076166 &lt;= 253.072741539 B/Area 1500 3000 &lt;= 30000 B/Area 2500 795.41839 &lt;= 30000 L A *D*A L B *D*A Cost A Cost B P cr(B) L B = 25 A x A y L A = 15 B x B y Area A Area A Area B Area B P cr P cr f y(A) f y(A) f y(B) f y(B) Area A Area B P cr f y(A) f y(B) **When using excel Solver there where difficulties for solve to calculate. Seems that changing varibles (Area -A &amp; Area - B) can not be quotients in the calculation process. Therefore, all equations where manipulated such that Area - A &amp; Area - B where a product of the coefficients. Second Page of excel shows this with different numbers (i.e smaller #'s) This made solver find the best solution for the each material.**- Best Material to choose from was carbon steel with a total cost of $117.34. With Member - A having a crossectional area of .5 in2 &amp; Member - B had a cross sectional area of 3.143 in2...
View Full Document

Ask a homework question - tutors are online