schedule for each sheet in the Excel Workbook.
represents a condominium building project. The Excel worksheet
(shown below the schedule), includes:
the type of
contract (hook up gas, cabinets, ...)
(used) to date
% of work
calculates the % of money remaining and compares it to the %of
The % of
work remaining and % of money remaining are displayed as a pie symbol.
indicator" column gives a quick way of telling whether the
subcontract is in trouble (red), doing ok (yellow) or doing very
well (green). The colors are based on how the % of work
remaining compares to the % of money remaining.
The schedule (click the schedule image for a
If you would like to try this
here to download a zip file which contains:
MilestonesOLEExcelExample2.xls - The Excel
spreadsheet with data and program
ExcelTemplate2.mtp - The
Milestones Professional template used by the program
(This download is recommended
for those familiar with Visual Basic and Microsoft Excel).