The application allows a user to define his own formula driven columns giving him the power to perform some spreadsheet like analysis or planning and also enabling him to create a variety of reports based on the columns created by him.
To define a new column to be displayed in the Attribute table view :
In the Attribute table popup, click on the Define/change/delete columns button. The Define column window appears where the existing columns and their corresponding variable names are listed on the left. These variable names are used in the formulas that specify a column's value, as explained below.
To define a new column:
click the New column button on the right hand side. A new column with default parameters is created and added to the list on the left. This column's parameters are also displayed in the panel on the right. Now you may change the name, description, formula etc.
follow the instructions here to make changes.
click the Save changes button. The changes to be saved to the local table.
click the OK button. The dialog closes and the changes are incorporated into the view.
Setting a formula: The formula defines what is to be displayed in the new column. In the formula, to refer to the a column in the Column name list on the left, use the corresponding entry in the Variable list . We give some examples below.
In the examples we assume that the variable name corresponding to Estimated Effort is c29v , to Budgeted Effort is c10v
The following formula defines a column which shows the difference between budgeted and estimated effort.
c1v - c0v
The following formula defines a column which displays Over budget for those rows where the estimated effort exceeds the budgeted effort.
if((c10v - c29v) < 0), "Over budget", "")
As a convenience, clicking on a variable name in the Variable list causes that variable name to be inserted into the Formula textfield. The formulas that can be used are described in section Formulas .
For each column defined you can also specify the output type. For output types Date and Time period , you may further choose the display format.