lvgangqiang's picture From lvgangqiang rss RSS  subscribe Subscribe

Design Optimization With Excel 



 
Views:  7844
Downloads:  151
Published:  February 29, 2008
 
0
save to favorite
ask author to add audio Ask author to add audio
Share plick with friends Share
mark as inappropriate Mark as inappropriate
 
Related Plicks
Hermes birkin bag

Hermes birkin bag

From: Antony7
Views: 639 Comments: 0
www.srbag.com is a Guangzhou wholesaler and we specialized in wholesaling Replica of brand name fashion like Louis Vuitton, Chanel, Prada, Hermes, Luella, Gucci at greatly discounted prices. We have teamed up with many factories in China. So you can (more)

 
Six Sigma Minitab Flow Charts

Six Sigma Minitab Flow Charts

From: babo
Views: 1208 Comments: 0

 
Important SEO Tips

Important SEO Tips

From: sravanarudra
Views: 314 Comments: 0
Website structure, web page content and links are considered to be the three important elements of search engine optimization (SEO). Of these three, website structure is often underrated not only by website owners but also by some search engine opti (more)

 
High Speed Pcb Board Design And Analysis(Cadence)

High Speed Pcb Board Design And Analysis(Cadence)

From: jane
Views: 14946 Comments: 0
Today’s High Speed PCB design challenges
Cadence PCB solution overview
Demonstration overview
Summary
Q&A

 
See all 
 
More from this user
 Computer Technology 202 Applications of Spreadsheets

Computer Technology 202 Applications of Spreadsheets

From: lvgangqiang
Views: 3593
Comments: 0

Excel VBA Programming for Solving Chemical Engineering Problems

Excel VBA Programming for Solving Chemical Engineering Problems

From: lvgangqiang
Views: 28614
Comments: 1

Introduction to EXCEL VBA Part I

Introduction to EXCEL VBA Part I

From: lvgangqiang
Views: 24479
Comments: 0

VBA教程

VBA教程

From: lvgangqiang
Views: 17031
Comments: 0

 Implementing Legacy Statistical Algorithms in a Spreadsheet Environment

Implementing Legacy Statistical Algorithms in a Spreadsheet Environment

From: lvgangqiang
Views: 3931
Comments: 0

VBA Programming for Excel

VBA Programming for Excel

From: lvgangqiang
Views: 25628
Comments: 0

See all 
 
Place your Ad here for $2.00 a month
Oracle Beehive
The only complete and open platform for integrated, secure collaboration.
 
 
 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:
 
 
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
close
Please fill out the form below. You will be asked to make your payment to Myplick (Eastar Technologies) via Paypal. Your request will be processed within 24 hours after your submission.
 
Title (max 25 characters)
Link (placed on title)
Content (max 100 characters)
You have successfully submitted your ad request. Please send your payment to ericandlei@myplick.com via PAYPAL.
Ad submission failed. Please report the problem to ericandlei@myplick.com.