Generate Weighted Objectives Table

Overview

This helper generates a Weighted Objectives Study Table as a Microsoft Excel spreadsheet.

For a detailed guide on performing trade studies, see the PDF document in the RhapsodyPowerPack/Doc folder.

Applicable To	Weighted Analysis
Menu Entry	Power Pack  Generate Weighted Objectives Table
Demonstration	Watch the Video

Operation

The helper gathers potential solutions based on <<compares>> relationships to Solutions and their SolutionPart relationships to Alternatives:

If any data is missing, for example Weighted Objective MOEs with no weight or Alternative MOEs with no values, these are reported, and the generation is aborted.

If the data is sufficient then a Microsoft Excel spreadsheet of the results is generated:

· The file is named from the Weighted Analysis from which it was launched.

· The file is generated into the _rpy folder of the current project.

· The file is added as a Controlled File to the package that owns the Weighted Analysis.

· Cells in the spreadsheet contain calculations and so the data cells may be manually modified to try them out without changing the Rhapsody model.