lvgangqiang's picture
From lvgangqiang rss RSS  subscribe Subscribe

Design Optimization With Excel 



 

 
 
Views:  12289
Downloads:  307
Published:  February 29, 2008
 
6
download

Share plick with friends Share
save to favorite
Report Abuse Report Abuse
 
Related Plicks
Search Engine Optimization Beijing

Search Engine Optimization Beijing

From: search40
Views: 43 Comments: 0

 
Pay Per Rank SEO- Excellent SEO Optimization (3)

Pay Per Rank SEO- Excellent SEO Optimization (3)

From: David52Swank
Views: 39 Comments: 0

 
Topoptimizer - Trustable System Optimizer Utilities Suite

Topoptimizer - Trustable System Optimizer Utilities Suite

From: jmk1955
Views: 35 Comments: 0
75% Comm!specially:we Will Ensure That Software Aff Do Not Lose Orders. Because Of Differences In The Web Browser Will Cause Lost Sales.so,believe Us And Feel Free To Visited Our Web:http://hotlinkcycler.com/t/22512
System (more)

 
The Importance of SEO Optimization in Website Design

The Importance of SEO Optimization in Website Design

From: needlesense74
Views: 19 Comments: 0
The Importance of SEO Optimization in Website Design
 
Pay Per Rank Search Engine Optimization- Perfect SEO Marketing

Pay Per Rank Search Engine Optimization- Perfect SEO Marketing

From: Jennifer691Baltazar
Views: 40 Comments: 0

 
Professional SEO Services - MOS SEO

Professional SEO Services - MOS SEO

From: viralseoservices
Views: 989 Comments: 3
MOS SEO Services is a leading SEO services company based in Tulsa, Oklahoma, providing white hat search engine optimization, social media optimization and Internet marketing services.
 
See all 
 
More from this user
Ulli Stein Das Beste

Ulli Stein Das Beste

From: lvgangqiang
Views: 5132
Comments: 0

the World's Huge Objects I

the World's Huge Objects I

From: lvgangqiang
Views: 3296
Comments: 0

IB Oslo Sept 2006 final

IB Oslo Sept 2006 final

From: lvgangqiang
Views: 2248
Comments: 0

Apple’s Leopard OS

Apple’s Leopard OS

From: lvgangqiang
Views: 2501
Comments: 1

地球日的省思

地球日的省思

From: lvgangqiang
Views: 3121
Comments: 0

 软件设计模式 ( 二 )

软件设计模式 ( 二 )

From: lvgangqiang
Views: 3575
Comments: 0

See all 
 
 
 URL:          AddThis Social Bookmark Button
Embed Thin Player: (fits in most blogs)
Embed Full Player :
 
 

Name

Email (will NOT be shown to other users)

 

 
 
Comments: (watch)
plicker basheerakhan (2 years ago)
nice...
plicker Anonymous (4 years ago)
You can do this in Google Docs now too! http://googledocs.blogspot.com/2009/06/solve-feature-lets-you-solve.html
 
 
Notes:
 
Slide 1: Design Optimization With Excel Terrence L. Chambers, PhD., P.E.
Slide 2: Intro to Excel  Naming Cells  Entering Formulas  Comment Boxes
Slide 3: Intro to Optimization  Modeling and Analysis  Analysis vs. Design  Defining the Optimization Problem  Concepts of the Design Space  How do Optimization Algorithms Work?  Some Cautions About Optimization  Overall View of the Design Process
Slide 4: Design of Two-bar Truss Load, P Thickness, t Diameter, d Height, h Base, b
Slide 5: Analysis Model weight   2dt ( B / 2) 2  h 2  IB / 2) 2  h 2 stress  2tdh  2 E (d 2  t 2 ) bucklingstress  8[( B / 2) 2  h 2 ] P[( B / 2) 2  h 2 ]3 / 2 deflection  2tdh 2 E
Slide 6: Analysis vs. Design Analysis Variables In Analysis Model Analysis Functions Out
Slide 7: Optimization  Minimize Weight  By Changing: height and diameter  Such that:    Stress <= 100 ksi Stress <= Buckling Stress Deflection <= 0.25 in.
Slide 8: Design Space
Slide 9: Intro to Excel Solver  Solver Parameters Dialog Box  Solver Options Box  Solver Results Box  Two-bar Truss Tutorial
Slide 10: Solver Parameters Box
Slide 11: Solver Constraint Box
Slide 12: Solver Results Box
Slide 13: Solver Answer Report
Slide 14: Solver Options Box
Slide 15: Discrete Variables  Two-bar Truss Discrete Example
Slide 16: Linear Programming  Machining Problem Example
Slide 17: Intro to Excel VBA Programming  User-Defined Function Tutorial  Recording Macros Tutorial  Contour Plot Macro Example  Jacobian Program Example
Slide 18: Summary  Review of Basic Excel Skills  Intro to Optimization  Intro to Excel Solver  Solving Problems with Discrete Variables  Solving Linear Programming Problems  Intro to Excel VBA Programming

   
Time on Slide Time on Plick
Slides per Visit Slide Views Views by Location