Format Columns and Cells dialog - Grid tab

You use the Grid tab of the Format Columns and Cells dialog to specify the format of the cells in the right section of the resource usage view.

Click Reset to reset all of the fields in this dialog to their default values.

To access the Headers and Grid tabs of the Format Columns and Cells dialog, either:

  • Right-click the right section of the resource usage view and select Format Grid and Header.
  • On the Appearance tab of the Resource Usage Properties dialog, click Format Grid.
Field Description
Category

Select the category of information you want to format. The fields that appear to the right depend on the category that you select, as described below.

 

'General'-type cells have no specific formatting, so no fields are displayed when you select the 'General' category.

The following fields are displayed when you select the 'Number' category:

Field Description
Decimal places Select the number of decimal places to display.
Use 1000 separator Select this check box if you want to use a punctuation mark to separate thousands (for example 5,000), or clear the check box to display numbers without a thousand separator (for example 5000).
Negative numbers Specify whether you want to display negative numbers in parentheses (for example (500.23)) or preceded by a minus symbol (for example -500.23).

The following fields are displayed when you select the 'Currency' category:

Field Description
Decimal places Select the number of decimal places to display.
Currency unit Select the currency unit in which to display amounts. Amounts that have been entered in different currencies are converted into the selected currency using the exchange rates specified on the Currency Unit Properties dialog.
Negative numbers Specify whether you want to display negative numbers in parentheses (for example (500.23)) or preceded by a minus symbol (for example -500.23).

The following fields are displayed when you select the 'Effort' category:

Field Description
Decimal places Select the number of decimal places to display.
Time units Select the time unit in which to display effort.
Calendar

Select a calendar to display effort using the time unit override specific to that calendar.

 

Each calendar can specify an override for each working time unit, defining its precise length in that calendar. For example, a working week may differ in length from one calendar to another, depending on the work patterns used by the calendars.

 

If the selected calendar has no override specified, Asta Powerproject uses the override specified for the calendar of the task or bar in question; if no override is specified here, Asta Powerproject uses the default number of seconds for the selected time unit.
Duration format

Select the format in which to display effort:

  • Select Compact (4:2) to display effort using the compact abbreviations that have been specified for each time unit on the Time Unit Properties dialog (which may be characters such as exclamation marks or asterisks).
  • Select Decimal (4.00d, 4.40w) to display effort as a decimal number of the selected time unit, using the exact number of decimal places you have specified (even if these are zeroes), for example 4.60w, 11.75m or 2.00y.
  • Select Decimal (4d, 4.4w) to display effort as a decimal number of the selected time unit, using as few decimal places as possible (up to the maximum number you have specified) for example 4.6w, 11.75m or 2y.
  • Select Mixed time units (4w 2d) to display effort using a combination of time units, for example 4w 3d or 2d 11h.
Do not show time unit Select this check box to display effort without any time units, or clear the check box to display these amounts with the appropriate time units.

How do I...

  1. Select the type of information you want to format in the Category field.
  2. Specify the way in which information of that type are displayed in the remaining fields, as described in the sections below.

Select the number of decimal places to display in the Decimal places field.Select the Use 1000 separator check box if you want to use a punctuation mark to separate thousands (for example 5,000), or clear the check box to display numbers without a thousand separator (for example 5000).Specify whether you want to display negative numbers in parentheses (for example (500.23)) or preceded by a minus symbol (for example -500.23) in the Negative numbers field.

Select the number of decimal places to display in the Decimal places field.Select the currency unit in which to display amounts in the Currency unit field.Specify whether you want to display negative numbers in parentheses (for example (500.23)) or preceded by a minus symbol (for example -500.23) in the Negative numbers field.

  1. Select the number of decimal places to display in the Decimal places field.
  2. Select the time unit in which you want to display effort in the Time units field.
  3. Select a calendar in the Calendar field to display effort using the time unit override specific to that calendar.
  4. Select the format in which to display effort in the Duration format field.
  5. Select the Do not show time unit check box to display effort without any time units, or clear the check box to display these amounts with the appropriate time units.

Related Topics:

Working with dialogs

Formatting the columns, header and cells of the resource usage view