- Excel Desktop Client new !
Often an optomization problem involves finding a 'best' output by conducting a search through the space of possible inputs.
For a single-input problem the task is straightforward:
As more tries are recorded, the new input 'guesses' can be chosen closer in value to those that produced the most optimal outputs during the prior attempts.
For multiple inputs the problem space expands exponentially, gaining insight about an optimal solution requires a brute-force search involving many runs with many input combinations.
Parametric studies allow a long list of varying inputs be submitted at one time. Processing may be prolonged but—for example—the User may complete other tasks while the results are written to a database for later retrieval. EASA lets you do 'slow' things in the background.
In this example, above, we take an Excel spreadsheet with a list of Length, Thickness and Uniform Load values and run a version of the Cantilever Plate Tutorial EASAP that has been modified to take multiple-run or 'parametric study' inputs. Results from each run are written to a database.
The EASAP requires the User select a loads file(
plate_loads.xlsx in this example) then click Upload.
The parametric inputs populate the table. Individual inputs for each run
can be added, deleted or modified via the 'Edit' tab.
Please download and unzip: http://help.myeasa.com/6_0/resources/Parametric_Plate.zip
We now have:
The database has been 'restored'.
Now we import Parametric_Plate.easap.
Now we configure the database and driver on the EASA Server
The settings in this file will help configure EASA Server database connection, below.
The main table will be empty until the 'loads' spreadsheet has been uploaded.
The table will be populated with length,thickness and uniform load inputs.
Select a row and click 'Edit' to modify the values from Excel.
'Submit' begins the lengthy process of running each of the eighty runs.
A POLL REQUEST EVENT updates a counter showing the fraction of completed runs.