HyperStudy

HS-4415: Optimization Study of a Landing Beam Using Excel

HS-4415: Optimization Study of a Landing Beam Using Excel

 Previous topic Next topic Expand/collapse all hidden text  

HS-4415: Optimization Study of a Landing Beam Using Excel

 Previous topic Next topic JavaScript is required for expanding text JavaScript is required for the print function  

This tutorial demonstrates how to perform an optimization study in which the input variables are entered and the output responses are calculated in a Microsoft Excel spreadsheet.  The Excel spreadsheet LandingBeamCalc_Public.xls file can be found in <hst.zip>/HS-4415/ and copied to your working directory. To watch a demonstration video of this tutorial, click here.

The objective is to find the cross-sectional dimensions of a tapering I- beam at its three sections that minimize the total cross-sectional area while meeting the margin of safety requirements for buckling, crippling, and combined bending and shear under ten loadcases.

The spreadsheet used here contains a page with the initial design and separate pages for crippling, buckling, and combined bending and shear calculations.

hmtoggle_plus1greyStep 1: Create a Matrix Input that HyperStudy Can Evaluate
1.In Excel, open the LandingBeamCalc_Public.xls spreadsheet.
2.Review the information, and locate the columns that contain the input variables and output responses.
Note:When creating a Spreadsheet model for HyperStudy on a Mac or Windows platform, variable labels should only contains English characters, or a combination of English characters and numbers.

 
hmtoggle_plus1greyStep 2: Perform the Study Setup
1.Start HyperStudy.
2.To start a new study, click File > New from the menu bar, or click files_new_hst2 on the toolbar.
3.In the HyperStudy – Add dialog, enter a study name, select a location for the study, and click OK.
4.Go to the Define models step.
5.Add a Spreadsheet model by dragging-and-dropping the LandingBeamCalc_Public.xls file into the work area.

The Solver input file column displays hst_input.hstp, this is the name of the solver input file HyperStudy writes during any evaluation. The Solver execution script column now displays SpreadSheet_HST.

hs_4415_drag_drop_model

6.Optional. If a firewall prompt dialog appears, click Allow.
7.Click Import Variables. The LandingBeamCalc_Public.xls spreadsheet opens.
8.In the Excel - HyperStudy dialog, click Yes to begin selecting input variables.

hs_1035_excel_dialog

9.In the spreadsheet, select the cells AA_w1, AA_w2, and AA_w3 in Section AA, along with their corresponding values.

hs_6040_1a

10.In the Excel - HyperStudy Input Selector dialog, click OK.
11.Select the following:
•Section AA: AA_h1 and AA_h2
•Section CC: CC_w1, CC_w2, CC_w3
•Section CC: CC_h1, CC_h2
•Section EE: EE_w1, EE_w2, EE_w3
•Section EE: EE_h1, EE_h2
12.Click Cancel to stop selecting input variables from the spreadsheet.
13.In the Excel - HyperStudy dialog, click Yes to begin selecting output responses.
14.In the spreadsheet, select the cell AA_MS_BS in Section AA, along with its corresponding value.

hs_6040_2a

15.In the Excel - HyperStudy Output Selector dialog, click OK.
16.Select the following:
•Section AA: AA_MS_C
•Section AA: AA_MS_B
•Section CC: CC_MS_BS
•Section CC: CC_MS_C
•Section CC: CC_MS_B
•Section EE: EE_MS_BS
•Section EE: EE_MS_C
•Section EE: EE_MS_B
•Area ACE value from cell C10 (illustrated in the image below):

ace

17.Click Cancel to stop selecting output responses from the spreadsheet. Fifteen input variables and ten output responses are imported from the LandingBeamCalc_Public.xls spreadsheet.
18.Go to the Define Input Variables step.
19.Review the input variable's lower and upper bound ranges.
20.Go to the Specifications step.

 
hmtoggle_plus1greyStep 3: Perform the Nominal Run
1.In the work area, set the Mode to Nominal Run.
2.Click Apply.
3.Go to the Evaluate step.
4.Click Evaluate Tasks. An approach/nom_1/ directory is created inside the study directory. The approaches/nom_1/run__00001/m_1 sub-directory contains the sse_output.csv file, which is the results file of the nominal run.
5.Go to the Define Output Responses step.

 
hmtoggle_plus1greyStep 4: Add an Optimization Approach and a Run Optimization
1.In the Explorer, right-click and select Add Approach from the context menu.
2.In the HyperStudy - Add dialog, select Optimization and click OK.
3.Go to the Select Input Variables step.
4.Review the input variable's lower and upper bound ranges.
5.Go to the Select Output Responses step.
6.Click Add Objective.
7.In the HyperStudy - Add dialog, add one objective.
8.Define the objective.
a.Set Type to Minimize.
b.Set Apply On to Area ACE (r_10).

hs_1810_objective1

9.Click the Constraint tab.
10.Click Add Constraint.
11.In the HyperStudy - Add dialog, add nine constraints.
12.Define Constraint 1 through Constraint 9 by selecting the options indicated in the image below from the Apply On, Bound Type, and Bound Value columns.

hs_4415_constraints

13.Click Apply.
14.Go to the Specifications step.
15.In the work area, set the Mode to Sequential Quadratic Programming (SQP).
Note:Only the methods that are valid for the problem formulation are enabled.
16.Click Apply.
17.Go to the Evaluate step.
18.Click Evaluate Tasks to launch the optimization.

 
hmtoggle_plus1greyStep 5: View the Iteration History of the Optimization
1.Click the Iteration Plot tab to monitor the evolution of the objective function and constraints vs. the iterations.
2.Using the Channel selector, select Constraint 1 through Constraint 9. The Optimization iteration history of the constraints is plotted.

1100_iteration_history

 

 

 

See Also:

HS-1810: Post Proceesing with HyperStudy

HyperStudy Tutorials