Download Milestones Professional 2004 User Manual

Calculation/Indicator SmartColumn
Calculation/Indicator SmartColumns display values and/or value-driven indicators
through these methods:
•
Multiply, divide, add, or subtract any two columns with values.
•
Multiply a column by percent complete or percent not complete.
•
Display symbols, colors, or text based on calculated values, user-entered
values from another column, or text from another column.
You can also use the results of one calculation column in another calculation, as well
as choose to show the result as a percent or add a % sign with the resulting value.
Calculation/Indicator SmartColumn examples
Calculation SmartColumn
January
February
March
All Items
10
15
14
22
26
33
14
$17,154
45
$35
$1,575
77
$35
$2,695
122
$62
$7,564
133
$40
$5,320
These numbers, which are
part of a ValueSet, are added
up in the “Units Sold” column
(a ValueSet SmartColumn).
42
19
25
Task 4
Earned value calculations
are easy to do with
Calculation/Indicator
SmartColumns.
“Total Sales” is a
Calculation/Indicator
SmartColumn that multiplies
the “Units Sold” column by
the “Price per Unit” column.
28
Task 3
33
$43
23
Task 2
35
377
20
Task 1
18
The symbols in this schedule
have numbers associated
with them (“Units Sold”).
Units Price
Total
Sold per Unit Sales
2001
Items
6-Month Earned Value Report
Project/
Phases
FY04
Jul
Aug
Sep
Oct
Q3
Nov
ACWP
Dec
BCWP
Budget
Status
Q4
Project 1
Research
$3,000
$1,185
$1,751
$2,975
$2,500
$200
$300
$300
$400
$400
$400
$175
$250
$250
$200
$598
$725
$210
$204
$400
$0
$0
$350
$0
$0
$550
Budget
This schedule multiplies
“Budget” by percent
complete to yield earned
value—“BCWP.”
Design
$2,000
Procurement
BCWP
$1,500
Production
$1,000
Testing
ACWP
Review
The values are graphed
across the schedule area
for at-a-glance status
reporting.
$500
Delivery
$0
BCWP
Budget
ACWP
Contracts review: 10-15-04
Sign Off: _________________
Earned Value greater than Cost
Cost greater than Earned Value
Cost = Earned Value
Completed Task
Status Date
Incomplete Task
The “Status” column is a
Calculation/Indicator SmartColumn which subtracts ACWP from BCWP and displays
indicator symbols accordingly, while hiding the numeric calculation results.
Indicator Symbols and SmartColumns 15-4