Equipment Spec Sheets Databank Dialog
EquipmentSpecSheetsDBDlg.jpg

This dialog appears by selecting Databanks } Equipment } Spec Sheets from the main menu of the application.

From this dialog you can:

1.   View the contents of the equipment specification sheets databank; you can apply filters and/or custom ordering to customize the view of the displayed list.

2.   Add a new equipment spec sheet, or delete or modify the properties of existing user-defined equipment specification sheets.

At the top of the dialog, there is a drop-down list box that dictates the equipment type for which available spec sheets will be displayed: e.g. “Centrifugal Pump”, “Nutsche Filter”, “Stirred Reactor” etc. Selecting “All Types” from the drop-down box, will include in the table the display of all spec sheets (for all equipment types). If no spec sheets from any vendor or any manufacturer have been introduced in the chosen database (“System”, “User” or both), then the table will be shown empty. If you choose to view spec sheets from Vendors only, then click on the InclExclBtn.jpg button and uncheck “Manufacturers”. Since every spec sheet listed is associated with a vendor or manufacturer, the column next to the name of the supplier mentions a “V” (for Vendor only), or an “M” (for Manufacturer only) or a “V/M” for a vendor and manufacturer. That is important to know, as equipment resources in SuperPro Designer simulation files can only be allocated to site equipment (existing equipment) or spec sheets originating from vendors or vendor/manufacturers, but not from plain manufacturers. Not having the designation of a “Vendor” (V) implies that the supplier does not directly sell its products to consumers, so their spec sheets are not directly available for allocation to equipment resources. For more information on this topic, please consult with Equipment Spec Sheets Databank.

The equipment items that are listed in the table can be sorted by type, supplier, part/model number or size. Note that the ‘Type’ option is available only when you choose ‘All Types’ as the equipment type and the ‘Size’ option is available only when you choose a single equipment type. In that case, the Apply Filter button is also available. For same-type equipment, the Apply Filter button can be used to search and display equipment that satisfy certain specifications that have been defined by the user. Clicking on this button will bring up the Equipment Search Dialog where you can specify your search criteria.

IconInfo00283.bmp 

Using the ‘Database Filter...’ DbFilterBtn00284.jpg button you may choose to display equipment specification sheets only from the ‘Designer’ database or only from the ‘User’ database or from both databases. By default, the table displays items from both databases.

►    To view or edit the properties of an equipment specification sheet included in the databank…

1.   Select the desired equipment type in the ‘Equipment Type’ list box.

2.   Select the desired database(s) from the ‘Database Filter...’ button.

3.   Select the desired equipment specification sheet from the table.

4.   If you have chosen an equipment specification sheet from the ‘Designer’ database, then you can proceed to view its properties by clicking on the View (ViewEditProperties200285.jpg) button. The Equipment Spec Sheet Properties Dialog will be displayed. This dialog presents in several tabs the property values for the selected equipment specification sheet. Notice that you cannot modify and save any values on this dialog.

5.   If you have chosen an equipment specification sheet from the ‘User’ database, or a newly added equipment specification sheet to the databank, then instead of the View (ViewEditProperties200286.jpg) button, the Edit (ViewEditProperties00287.jpg) button will appear. By clicking on this button, the Equipment Spec Sheet Properties Dialog will appear once again, only this time, you can view as well as edit and save new property values for the selected equipment specification sheet.

►    To add a new equipment specification sheet in the databank…

1.   Select the desired equipment type in the ‘Equipment Type’ list box.

2.   Click on the Add New Spec Sheet (AddNewButton00288.jpg) button. This will display the New Equipment Spec Sheet Dialog. Through this dialog, you must select a supplier and enter information provided by the supplier regarding the equipment part/model number (typically, vendors use part numbers or SKU numbers, whereas manufacturers use model numbers) and the equipment description. In addition, you may select an initialization option for the equipment specification data among the following options: you may copy the specification data from an existing site-equipment (if you are back-populating the spec sheet database from existing equipment that you have already purchased) or another equipment specification sheet, or you may use default initialization values, or you may get the data directly from a manufacturer’s equipment specification sheet (if it already exists in the database and if the new spec sheet you generate is for a “Vendor” only. Remember that “Vendor/Manufacturers” can only sell their own products and therefore you are not allowed to link one of their spec sheets to another spec sheet.

3.   Click OK to open the Equipment Spec Sheet Properties Dialog. Specify the properties of the equipment specification sheet and click OK.

IconCaution00289.bmp 

Before you add a new equipment specification sheet, make sure you have selected the correct equipment type, as this field cannot be changed later. If you add an equipment specification sheet that has the wrong equipment type, the only thing you can do is delete it and re-add it with the correct equipment type.

►    To delete an existing user-defined equipment specification sheet from the databank…

1.   Select the desired equipment type in the ‘Equipment Type’ list box.

2.   Select the equipment specification sheet that you wish to delete. If it does not reside in the ‘Designer’ database (in other words, if it either resides in the ‘User’ database, or if it is a newly added equipment specification sheet in the databank that has not been saved yet in the ‘User’ database), then the Delete (Delete00290.jpg) button will be enabled.

3.   Click on the Delete (Delete00291.jpg) button.

►    To save the changes made to the databank in the ‘User’ database…

4.   To save the changes made to the databank back into the ‘User’ database, you may either click on OK (which will close the dialog) or click on the Save Spec Sheet Records to Database (SaveToDB00292.jpg) button (which will keep the dialog open).

IconCaution00293.bmp 

Once the changes in the databank are saved into the ‘User’ database, they are irreversible. In case you change your mind about changes made, and these are not yet saved, you may cancel changes and revert to the saved databank by clicking Cancel on the dialog.

IconCaution00294.bmp 

If you make changes to a manufacturer’s spec sheet, the changes will be propagated to any vendor spec sheets linked to it. However, in order to see the propagated changes, during the same session and without exiting the dialog, you will need to save the changes made to the databank (see above). Alternatively, you can exit the dialog (which automatically commits all changes to the database) and revisit it later, then you will see all changes to the dependent vendor spec sheets.

 

See Also:

      Equipment Spec Sheets Databank