Sensitivity Analysis

From SysCAD Documentation
Jump to navigation Jump to search

Navigation: User Guide ➔ Getting Started ➔ Example Projects ➔ Sensitivity Analysis

Example Reports
Project Report Flowsheet Report Project Criteria Report Sensitivity Analysis Default Reports

Related Links: Excel Reports

File Location

This file is stored in ..\SysCADXXX\Examples\01 Reports\Sensitivity Analysis.xlsm

Brief Description

This is an example Excel Report using COM Automation for sensitivity analysis. It allows user to set up a large number of test cases, when the run sensitivity macro is executed, it uses COM to run through the cases without further user input.

As is, this file is used to test the sensitivities of TWO variables.

  1. User can define the test value range for the two variables and the number of test cases to be analysed, the macro will fill in the test case inputs based on the parameters specified.
  2. User can use one of the macro to run one, multiple or all the test cases.

NOTES:

  • This file is currently set up to run up to 100 cases, but user can extend this value by modifying the workbook and VBA code.
  • User can add in other input variables, but the input values will need to be entered manually as they are not handled by the VBA code as is.
  • The case results and Graph results may need modifying if extra variables are being reported.
  • The COM Automation will try to access the report files using the "exact" path name. Therefore, if user places this file in a synced drive, the actual the path of the file could be altered, and therefore prevents the reports from working. If the COM automation is not working for you, check if the file is stored in a sync drive such as OneDrive, if so, move it out of the sync drive onto the local drive and try again.

Worksheets

Main

  • This worksheet contains instruction on how to run the analysis, please read those carefully.
  • Use the "Browse Project" button or manually enter the project path (full path is required).
  • User may use the "Clear All Results" macro button to clear all results on the "CaseResults" worksheet. Useful for project change, where existing results are no longer valid.
  • When one of the "Run" macro (3a to 3c) is executed, it will automatically start up SysCAD, load the specified project and run the number of cases specified.
  • All fields in blues with white background are user input fields.
  • Before running the analysis, please make sure the User Inputs and Model outputs are set up correctly on Cases and CaseResults worksheets respectively.

Cases

  • This is the Case inputs worksheet, all fields in blues with white background are user input fields.
How to input user values For Sensitivity Analysis of two variables: (Use the Run Sensitivity Button on the Main Tab to run this)
Button Small 1.png Define how many variations for the primary variable and enter the value in Cell C2.
Button Small 2.png The primary variable range is entered in Cells C9 and D9.
Button Small 3.png Base on these inputs, the VBA code will enter the values in Row 9, starting from Case 1.
Button Small 4.png Define how many variations for the secondary variable and enter the value in Cell C3.
Button Small 5.png The secondary variable range is entered in Cells C11 and D11.
Button Small 6.png Base on these inputs, the VBA code will enter the values in Row 11, starting from Case 1.
Button Small 7.png The Case1 Report is a SetTagList Report, as shown in Cell E6, the subsequent reports are SetTagListOffset reports. (The image below shows the Report for Case2)
Button Small 8.png If user wants to use this workbook for a different project, please ensure the correct SysCAD Tags are entered cells E9 and E11. (Also change the description on cells B9 and B11 to match the tags.)
ExcelExample8.png
NOTES:
  1. If the Case input values do not update, check the calculation options in Excel, use Calculate Now or change to calculate Automatically on change.
  2. User may add extra input variables to E12 (and rows below, there is no limit for this, just insert the required number of rows).
    • Please adjust the "SysCAD_SetTagList" function parameters in E6 to accommodate the additional tags.
    • For these additional tags, user will need to manually add the input values for each case as they will not be "auto-adjusted" by this worksheet.
  3. This worksheet uses conditional formatting to display "unused" cases in light grey font.

CaseResults

  • This is the Case results worksheet
Button Small 1.png SysCAD TagList report for Case1 is Column C
Button Small 2.png User wanting to adapt this report for their use should change these SysCAD tags.
Button Small 3.png For extra tags, just insert new rows.
Button Small 4.png SysCAD TagList Offset report for Case2 onwards.
ExcelExample8c139.png

NOTE:

  1. This worksheet uses conditional formatting to display "unused" cases in light grey font.
  2. The results on this worksheet can be cleared by pressing the "Clear All Results" button on the "Main" worksheet.
  3. The "unused cases" results can be cleared by the "Clear Un-used Results" button on the "Statistics" worksheet.

Plots

  • This is an optional tab, it creates graphs for the results from the CaseResults worksheet.

Statistics

  • This is an optional tab, it creates statistic information for the results from the CaseResults worksheet.
  • Press "Clear Un-used Results" button to make sure the calculations are performed using valid case results.

Customisation Tips

  1. Adding Inputs: Refer to the Cases worksheet for guidance. The instructions and notes clearly indicate where to insert additional input variables. You may expand the input list to suit your analysis requirements.
  2. Expanding Outputs: The output tag list is fully customisable. Simply update the list to include any additional variables you wish to monitor during the sensitivity analysis.
  3. Adjusting List Lengths: Both input and output list lengths are defined by the user. Ensure that the search length is equal to or greater than the number of variables specified. This will help avoid truncation and ensure all variables are processed correctly.
  4. Adding Extra Worksheets: You may include additional worksheets in the same workbook to generate more detailed reports. For example, adding a worksheet with a stream report for Case1 using the following tag table function: SysCAD_TagTable(Case1,H,200,30). When SysCAD runs the macro for Case1, it will search the entire workbook for matching report names and include all relevant worksheets.
    • There is no limit to the number of reports you can include in the workbook, making this method highly flexible and suitable for more complex scenarios.
Retrieved from "https://help.syscad.net/index.php?title=Sensitivity_Analysis&oldid=84281"