The CDP™ workbooks are the Microsoft Excel workbooks in which the domain specific calculations have to be made. The CDP™ workbooks are an integral part of the activity and the Concurrent Design process. The CDP™ supports Microsoft Excel 2010 files, with the extension “xls” as well as “xlsm” files.
The CDP™ workbooks have added functionality which makes it possible to incorporate them in the CDP™.
The CDP™ workbooks can be managed in domain file stores and stored on a connected data source (CDP4™ or OCDT servers).
In this section an introduction is given on the setup and management of CDP™ Workbooks in the CDP4™.
The CDP™ workbooks can contain three different types of sheets
The CDP4™ workbooks have added functionality which makes it possible to incorporate and use them in the CDP™. When the CDP4™ is installed, a CDP4™ ribbon is added to Microsoft Excel through the CDP4 Office Add-in. Any normal Microsoft Excel workbook can be turned into a CDP4™ workbook. This is done by logging in and rebuilding the workbook for a particular engineering model, representing a particular domain. Parameters and subscriptions are available and can be edited through these workbooks. Several interactions between the engineering model and the workbooks are possible as well, e.g. subscribing to parameters or deleting existing subscriptions.
The Parameters sheet of a workbook are necessary for the CDP4™ workbooks to work properly. This sheet is the actual interfaces with the rest of the system. This sheet allows the values of parameters and subscriptions, including all their corresponding possible combinations of overrides, option-dependencies and state-dependencies, to flow into and out of a workbook.
This sheet is automatically rebuilt by the CDP™ every time a user requires this. The rebuild action will be performed based on the latest available information in the CDP™ server. Predetermined columns should be edited by the users to reflect the changes in their domain. When these columns are edited these changes still need to be communicated to the CDP™ server, otherwise the next rebuild will overwrite these changes. Editing the other columns of the Parameters sheet is of no use, the changes are not communicated to the CDP™ server and will therefore be lost with the next rebuild.
Within an engineering model, options can be created to explore different solution directions. From the various modelling concepts, such as including or excluding element definitions from specific options and differentiating values for parameters by setting option dependency or using overrides, a resulting CDP™ Product Tree can be calculated for each specific option. These Product Trees are given in the CDP™ Workbook after rebuilding, representing the subset of the engineering model that is relevant for and used by a domain. Given are the owned parameters and subscriptions with their resulting values corresponding to their place within the Product Tree. Their place is made clear by inclusion of information on their containing design objects, the top element (which is the only element definition in any Product Tree) and its underlying element usages.
In this way, the generated option sheets provide a way for the user to access the required design information as specified by him that is connected to a particular option. This makes this information accessible in an understandable way, as a basis for further processing in calculations or different representations. All the information that is represented on the generated option sheets is given as-is on the moment it has been generated. This information cannot be edited. Changes to the underlying structure as well as to the values that are given on this sheet are managed by the appropriate browsers, either in the CDP4™ Client or in the Workbook, or through the Parameters sheet. To reflect these changes on the generated option sheets, these will have to be updated.
The Parameters sheet and the generated Options sheets are thus getting their information from the CDP4™ server or other connected data source, and can always be restored again. To perform Concurrent Design, users can add any number of additional Excel worksheets as Calculation sheets in their CDP4™ Workbook as domain modelling space.
Any changes made to the Calculation sheets in the CDP™ Workbook, including adding new sheets, are only stored in the CDP™ workbook as a physical file in the CDP4™ server using the domain file store, so changes to these will be lost if the workbook is not saved and uploaded in the correct way or is deleted.
Last modified 3 years ago.