Formula Calculator

 Top  Previous  Next

 

Formula Calculator

Overview

Formula Calculator is used to define formulae. These formulae are then linked to resources, operations and components. These formulae are also used to estimate time in MCTIME, where by a formula associated with a resource is used to calculate the time of an activity to which the resource is mapped to. Formula Calculator is invoked from the Tools menu. A Project need not be loaded to invoke the Formula Calculator.

 

Figure 1:  Formula calculator
Figure 1:  Formula calculator

 

 

1: List of available Templates

2: List of available Tables

3: List of Equations

4: List of Fields

 

Templates

Creating and Deleting Templates

Figure 2:  Formula template
Figure 2:  Formula template

 

 

1.Create new template

2.New Template Details

3.Edit existing equations

 

1. Click on the “Edit” button. A Dialog Box containing Template and Equation Details should appear.

2. Click on the “New Template” button. Another Dialog Box containing the Fields for the New Template should appear.

3. Fill in the Name and the Description of the Template and click on the “OK” button. The New Template should be added to the list of existing Templates.

 

 

 

Deleting Templates

1. Click on the “Edit” button. A Dialog Box containing Template and Equation Details should appear.

2. Select the desired Template and Click on the “Delete” button. The selected Template should get deleted.

 

Selecting Available Templates and adding Equations

1. Click on the “Edit” button. A Dialog Box containing Template and Equation Details should appear.

2. Select the desired Template and the desired equation. Then, click on the

button. The selected equation will be added to the “Selected Equation” Field.

 

Equations:

Editing and Creating Equations

1. Click on the “Edit” button. A Dialog Box containing Template and Equation Details should appear.

2. Select the desired Template and the desired equation. Then click on the “Edit Equation” button to edit the selected Equation. To create a new Equation, click on the “Create Equation” button. A Wizard will appear.

3. Fill in the Name and the Description of the Equation and click on the “Next” button. The Next page of the wizard should appear.

4. Select the Fields to be added to the Equation from the Combo box. Click on “Select” button after selecting the desired field. (Only one field can be selected from the Combo Box at a time)The selected Field should be added to the list of the selected Fields.

5. To form an Equation, double click on the selected Fields and the Operators in a desired manner by double clicking on them. The selected fields and operators should be added to the “Equation” Field.

6. Check the Equation, evaluate it and click on the “OK” button. The equation should be saved against the Template and the Dialog Box should close.

Figure 3:  Equation wizard
Figure 3:  Equation wizard

 

1: Selecting New Variables

2: List of Selected Fields

3: Select the required function

4: Operator for Equation

 

Removing Equations

1. Click on the “Edit” button. A Dialog Box containing Template and Equation Details should appear.

2. Select the desired Template and Click on the Equations to be removed in the “Selected Equations” list. Then click on the “Remove Equation” button. The selected Equation should get removed.

 

Purging Equations & Associated Fields

1. Click on the “Edit” button. A Dialog Box containing Template and Equation Details should appear.

2. Click on the “Purge Equations/Fields” button. A Dialog Box as shown below should appear.

Figure 4:  Purge equations/fields
Figure 4:  Purge equations/fields

 

3. Select the type of entity to be purged using the Combo box (i.e. Equation or Fields). The corresponding sub types should appear in the associated List View.

4. Click on the Equation/Field to be purged. Then, click on the “Delete” button. A warning should appear. If the entity being deleted is a Field, then the user will be shown a list of Equations in which the Field is being used.

NOTE: If a Field is purged, then the Equation containing that Field will also get purged.

5. Click on the “OK” button. The selected Entity type should get purged.

 

Viewing Equations and Fields from available Templates

 

Figure 5:  Viewing equation fields
Figure 5:  Viewing equation fields

 

1: Viewing list of equations

2: Viewing available fields

 

• Select the Template by using combo box

• Click on View Button

 

Standard Tables

Editing or Uploading Tables

1. Click on the “Edit” button in the “Available Standard Tables” Group Box. A Wizard containing Fields for Table Name and Description should appear.

2. Fill in the Name and the Description of the table and click on the “Next” button. The next page containing fields for Uploading a “Text” File should appear.

 

Figure 6:  Editing and unloading
Figure 6:  Editing and unloading

 

NOTE: The Text File needs to CSV or comma separated value file.

 

3. Upload the required Tables and click on the “Finish” button. The selected tables should be uploaded.

4. Click on “View” button in the “Available Standard Tables” Group Box.

 

 

Calculation Process to get an Output

Generating Output by using an Equation

 

Figure 7:  Calculation results
Figure 7:  Calculation results

 

1: Equation

2: Input Values

3: Output Result

 

1. Select a Template using Combo box. The Equations corresponding to the selected Template should appear in the “Equations” List View.

2. Select the Equation to be tested. The Fields used in the Equation should appear in the “Fields” Data Grid.

3. Fill in the required values and click on the “Calculate” button. The output should be generated and should be shown at the bottom of the Dialog Box.