|
|
 |
|
|
|
Microsoft® Project Version 2002 Inside Out
|
|
|
Author |
|
Teresa S. Stover
|
|
|
Pages |
1008
|
|
Disk |
1 Companion CD(s)
|
|
Level |
Int/Adv
|
|
Published |
08/14/2002
|
|
ISBN |
9780735611245
|
|
ISBN-10 |
0-7356-1124-6
|
|
Price(USD) |
$44.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Index
Special Characters
24 hours calendar, 159
4PM Web site, 881
A
abbreviations for task duration time period units, 131
absolute, in project triangle, 232
absolute column references, 661
accelerating finish dates, 234
accepting
assignments, 476, 499, 518
changes, from external tasks, 418
changes, in Web Access team collaboration, 478
task updates, 522
tasks, 519
tasks, in Web Access, 519, 532
Access
copying from, 436
copying from, maintaining column order, 437
databases, importing, 441
databases, saving projects as, 697
datasheet view, opening, 436
pasting from, 437
pasting lists from, 437
viewing Project database in, 791
accessing
e-mail team collaboration, 476
enterprise accounts, 554
enterprise data, with Web Access, 557
hidden toolbar buttons, 643
lookup tables, quickly, 633
macros, with keyboard shortcuts, 667
project information, 85
Project Manager account, in Web Access, 524
Project Server database, 770, 793
project-wide settings, 674
resource availability graphs, 579
Software Development Kit, 466
SQL server data, 431
toolbar buttons, hidden, 643
Web Access account, 530
Account Properties dialog box, 821
accounts
enterprise, accessing, 554
Project Manager (see Project Manager account)
Project Server, adding, 560
Project Server, creating, 516
Project Server, naming, 560
Project Server, setting as default, 560
Project Server, vs. Windows User, 560
Web Access, accessing, 530
Web Access, setting up, 509
accrual, fixed cost, 226
Accrue At field, 847
accruing costs, 224
activating
enterprise features, 819
next project window, keyboard shortcut for, 883
other pane in combination view, keyboard shortcut for, 883
previous project window, keyboard shortcut for, 883
Project, 806
Project, over the Internet, 806
split bar, keyboard shortcut for, 883
UserForms, 759
Active Directory
adding resources from, 195
inserting resources from, 490
Active View bar, switching views with, 86
ActiveX controls, 763
adding to Toolbox, 763
common properties, 763
registering, 763
type libraries, 763
Actual Cost field, 829
actual cost of work performed, 357
actual costs
comparing to planned, 217
for overtime, 829
viewing, 354
actual duration, 299
Actual Duration field, 840
Actual Finish field, 834
Actual Fixed Cost field, 829
Actual Overtime Cost field, 829
Actual Overtime Work field, 840
Actual Start field, 834
Actual Work field, 840
actuals, 283
entering, 293, 300
entering, allowing time for, 293
entering, detail necessary when, 293
entering, with timesheets, 305
most recent date reported, 835
stopping automatic recalculation after entering, 314
tracking, 294
ACWP, 357, 382
ACWP field, 829
adapting
base calendars, 160
base calendars, from Standard, 179
templates, 678, 681
Add method, 707
Before argument, 709
Name argument, 709
adding
ActiveX controls, to Toolbox, 763
assignment delay, 263
authors, to projects, 690
baseline fields, to tables, 287
code modules, to projects, 748
code, to UserForms, 758
columns, to tables, 611
commands, to menus, 650
commands, to toolbars, 643
company name, to administrative installation point, 811
controls, to UserForms, 757
detailed information to resources, 181
documents, to document libraries, 527, 543
e-mail addresses, for e-mail team collaboration, 488
effort-driven fields, to task sheets, 248
enterprise resources, to project teams, 578
external task fields, to tables, 417
field information, to DAPs, 788
fields, to Field Name list, 612
fields, to forms, 653
fields, to formulas, 618
fields, to tables, 182
fields, to task tables, 418
fields, to timesheets, 294
filter tests, 628
form buttons, 654
functions, to formulas, 618
generic resources, to project plans, 573
group boxes, to forms, 655
group dividers, to toolbars, 645
groups, to Web Access, 511
issues, 527, 543
items to View menu, 760
leveling delay, 263
Marked field, to Gantt charts, 592
material resources, 176
menus, to menus, 650
menus, to toolbars, 643
notes, for resources, 185
optional features, 807, 808
Overallocated column to task sheets, 255
Priority field, to task sheets, 269
programs, 706
progress lines, 295
progress lines, to Gantt charts, 317
Project Server accounts, 560
project summary information, to projects, 690
project summary task row, 240, 313
project summary task, to Gantt chart, 230
Regular Work field, to Resource Usage view, 265
resource fields, 182
resource fields, to Resource Sheet, 182
resource initials, 181
resources, 247
resources, automatically, 165
resources, from Active Directory, 195
resources, from address book, 169, 194, 468
resources, from distribution lists, 169
resources, from Excel, 169
resources, from Outlook Contacts list, 469
resources, from Project Server, 195
resources, in Assign Resources dialog box, 193
resources, manually, 166
resources, when assigning, 193
resources, to decrease duration, 247
resources, to projects, 165
resources, to tasks, 206, 261
resources, to tasks, drawbacks of, 249
resources, with Project Guide, 171
resources, without e-mail addresses, 469
scope, to projects, 241
search criteria, 691
servers, to SharePoint Team Services, 514
subjects, to projects, 690
subproject-related fields, to task/resource sheets, 395
tables, to DAPs, 789
task type, to task sheet, 248
tasks, to baselines, 284
templates, to Templates dialog box, 679
text, to forms, 654
timephased fields, to timesheets, 606
timesheet fields, 606
titles, to projects, 690
toolbar buttons, 642
trusted sites, 822
users, in Web Access, 510
watches, 753
Additional Controls dialog box, 738
address book
adding group of resources from, 194
adding resources from, 169
building resource list from, 468
distribution list, adding resources from, 169
groups, adding resources from, 169
inserting resources from, 468, 490
Address Book dialog box, 500
adjusting
assignments, 261
assignments, to reduce costs, 252, 326
assignments, to reduce resource costs, 253
column width, in timesheets, 607
costs, 320
costs, to balance resource workloads, 253
critical tasks, 242
network diagrams, for page breaks, 599
project plans, 282
project plans, 231-32, 309, 320
project triangle, 232
projects, 309
resource availability, 260
resource settings, to bring in finish date, 246
resource workloads, 327
resources, 164
reviewing results of, 277
row height, in tables, 605
schedules, 311
schedules, to balance resource workloads, 253
schedules, to reduce costs, 252, 325
scope, to balance resource workloads, 253
scope, to bring in finish date, 248
task assignments, by leveling, 273
task calendars, 245
task dependencies, 243
views, for printing, 340
administering
e-mail team collaboration, 487
enterprise features, 554
enterprise projects, 555
Project Server, 508
Web Access, 815
administrative closure, 683
administrative installation points
adding company name to, 811
creating, 811
advanced search, 691
aliases, creating for custom fields, 616
aligning
column field information, 110
column titles, 110
network diagram boxes, 598
timesheet data, 606
allocation, resource, 248
reviewing, 329
viewing, 255, 260
allowing task delegation, 520
altering. See modifying
analyzing, 281
cost overruns, 356
cost performance data, in Excel, 378
costs, 250
costs, with earned value, 381
earned value (see earned value analysis)
linked series of tasks, 137, 236
multiple projects, with Portfolio, 580
paths, for least flexibility, 137, 236
portfolios (see Portfolio Analyzer)
progress, 311
progress, with earned value, 381
project performance, 682
project status, 311
projects, 369 (see also project analysis)
resource workloads, 254
schedules, with Excel, 370
variances, 320, 381
with enterprise features, 547
anchor cells, 450
anonymous resources, 167
apostrophes in VBA, 666
appending
data to active project, when importing, 442
Outlook tasks, to task list, 465
task lists, 456
Application event procedures, 748-49
Application object, 708
AppMinimize method, 708
application property, 707
application settings, 771
applications
copying from, 436
copying to, 431
embedding objects from, 440
embedding to, 438
exchanging data with, 429
hyperlinking from, 448
hyperlinking to, 447
linking between, 443
linking from, 445
pasting from, checking data formats before, 436
server (see server applications)
for team collaboration, choosing, 475
applying
AutoFilter, 120
base calendars, to resources, 178-79
base calendars, to tasks, 160
Baseline table, to task sheet, 286
built-in work contours, to assignments, 215
Calendar view layout, automatically, 603
constraints, 150
Constraints Date table, 150
Cost table, 321
data templates, to network diagram boxes, 596
Earned Value table, 384
export filters, 374
filters, 316, 324
filters, to task sheets, 316
Resource Allocation view, 331
Schedule table, to task sheet, 235
tables, 166
tables, to Resource Sheet, 182
task calendars, 160
task dependencies, 142
Task Entry view, 153, 432
Tracking Gantt, 313
Usage table, 437
Variance table, 314
views, quickly, 589
work contours, 216
Work table, 328
Work table, to Resource Usage view, 331
AppMinimize method, 708
archiving
budget records, 683
lessons learned reports, 684
project plans, 569, 679
arguments, 709
Cancel, 709
in functions, 714
named, 724, 725
named, order to specify in, 725
optional, 725
Step, 718
arranging
table information, 114
tasks, in Calendar view, 603
windows, 124
workspace, 121
arrays, 712
declarations, 712
dimensions, 712
dimensions, 0-based, 712
increasing upper bound, 729
As Late As Possible constraint, 147
deadlines and, 156
As Soon As Possible constraint, 147
Ask A Question box, 22
Assign Resources dialog box, 192
adding new resources in, 193
adding resource information from, 194
Available To Work check box, 198
displaying, 194
Filter By box dimmed, 198
keeping open, 193
meeting resource criteria with, 195
opening, keyboard shortcut for, 884
overallocated resources and, 255
assigning
base calendars, to resources, 179
base calendars, to tasks, 160
graphical indicators, to nonsummary rows, 620
half-time resources, to tasks, 191
keyboard shortcuts, to macros, 667
macros, to toolbar buttons, 645
material resources, to tasks, 203-4
multiple work resources, to tasks, 193
outline codes, 635
outline codes, to resources, 182
overtime, 264
passwords, 700-701
programming tasks, 197
resources, 164, 261, 302
resources, in subprojects, 396
resources, simultaneously with adding, 193
resources, to multiple tasks, 191
task ID numbers, 776
tasks, 190
tasks, criteria for, 195
tasks, in Web Access, 515
tasks, to duplicate resources, 167
tasks, to multiple resources, 201
tasks, to resources, 165, 189
units (see assignment units)
values, to variables, 711, 755
Web Access users, to groups, 512
work resources, 192
work resources, to tasks, 189, 192
writing tasks, 197
assignment costs, 218, 227
in Resource Usage view, 227
reviewing, 227
in Task Usage view, 227
assignment delay, 262
adding, 263
vs. lag time, 144
vs. leveling delay, 274
Assignment Delay field, 840
Assignment field, 862
assignment fields, 826
assignment information category in databases, 84
Assignment Information dialog box, 202-3
opening, keyboard shortcut for, 884
updating actual work in, 305
Assignment reports, 358
assignment tables, 771
assignment units, 189, 191
checking, 247
maximum, for half-time resources, 191
vs. maximum units, 191
percentage of, keeping constant (see Fixed Units task type)
specifying per-time period, 204
updating, 246
Assignment Units field, 855
assignment views, 85
assignments, 189, 477
accepting, 476, 499, 518
adjusting, 261
adjusting, by leveling, 273
adjusting, to reduce costs, 252, 326
adjusting, to reduce resource costs, 253
applying built-in work contours to, 215
applying cost rate tables to, 224
applying work contours to, 216
automatically including in Outlook task list, 477
cost rate tables, applying to, 224
cost, total scheduled, 614, 831
costs (see assignment costs)
creating, 192
date scheduled to begin, 839
declining, 476, 499
delaying, 262, 263
delaying all, 262
delaying individual, 263
detailed information, viewing, 202
double-clicking, 202
editing, in subprojects, 395
entering actual work completed by, 305
exporting, 379
fields, 826
filtering, with resources, 195
finish date, originally planned, 834
grouping, 622 (see also groups)
grouping, by task, 518
leveling, 268
moving, 261
note indicators, 526
overtime, total cost, 832
percent work complete, entering, 303
publishing, 295, 490-91, 516-17
publishing changes to, Unconfirmed indicator, 495
publishing, notification when, 518
publishing, revising default note for, 492
receiving, from project manager, 497
report, running, 333
republishing, 496
resending, 496
reshaping work for, 216
resource (see resource assignments)
resource, filtering within date range, 195
resource, reviewing, 254
resources, total costs for, 228
responding to, 497
scheduling, automatically, 268
sending to resources, 476
sending to team members, 490
setting options, in Web Access, 519
start date, planned, 834
status, updating, 499
tables, 771
unique IDs, 851
units (see assignment units)
updating multiple, 303
viewing, by resource, 96, 202
viewing, by task, 96, 201
viewing, in Web Access, 531, 542
Web Access, reviewing, 531
work, keeping constant, 213
Assignments table, 781
associating
macros, with toolbar buttons, 668
resources, with project teams, 578
assumptions
cost, checking, 252
schedule, checking, 242
authentication method, choosing in Web Access, 510
authors
adding to projects, 690
modifying, 776
searching by, 691
Auto Data Tips option, 753
AutoFilter, 120
applying, 120
creating filters with, 630
tests, saving, 631
turning off, 120
automatic
cost calculation, turning off, 308
recalculation, stopping after entering actuals, 314
recalculation, turning off, 268
task updating, 291
automatically
adding resources, 165
adjusting row height, in tables, 605
applying Calendar view layout, 603
backing up projects, 699
detecting Project Server connection state, 821
including assignments in Outlook task list, 477
saving projects, 698
saving projects, turning off prompt for, 699
automating, 762, 765
tasks (see macros)
with library references, 765
with VBScript, 766
without library references, 766
availability
filtering resources by, 197
material resources and, 198
resource (see availability, resource)
availability, resource, 173, 246
adjusting, 260
considering, 190
specifying, 175, 189 (see also assignment units)
specifying over time, 174
Availability table, 781
Available From field, 834
Available To field, 834
average, calculating, 619
avoiding overwriting, when pasting, 437
B
BAC, difference between EAC. See VAC
BAC field, 829
background color for groups, modifying, 622
backing up
projects, 699
projects, automatically, 699
projects, where to save, 700
restoring from, 700
backups
naming, 700
opening, 700
restoring, 700
where to save, 700
balancing. See also leveling
resource workloads, 253, 327, 333
resource workloads, by adjusting scope, 253
resources and tasks, 231
workload, automatically, 267
Bar command, vs. Bar Styles command, 591
bar styles
formatting, 603
modifying for tasks, 603
Bar Styles command vs. Bar command, 591
Bar Styles dialog box, 590, 599, 603
opening quickly, 590
bars, Calendar
changing appearance of, 603
choosing fields for, 603
modifying styles for certain tasks, 603
viewing task names in, 603
bars, Resource Graph, 599
Base Calendar field, 847
base calendars, 159, 177
24 hours calendar, 159
adapting, 160
adapting from Standard, 179
assigning to resources, 179
assigning to tasks, 160
changing, 59
changing, for multiple resources, 180
copying, 179
creating, 179
creating custom, 160
creating for resources, 178
naming, 179
night shift calendar, 159
as project calendar, 61
Baseline Cost field, 830
Baseline Duration field, 840
Baseline Finish field, 834
Baseline Start field, 834
baseline table, 103, 286
Baseline Work field, 841
Baseline1-10Cost field, 830
Baseline1-10Duration field, 841
Baseline1-10Finish field, 835
Baseline1-10Start field, 835
Baseline1-10Work field, 841
baselines, 43, 282, 310
adding tasks to, 284
clearing, 291
comparing costs with, 321
comparing to current schedule, 283, 312
copying start/finish dates to, from interim plans, 290
duration, vs. scheduled, 842
for earned value analysis, specifying, 382
empty fields, 287
fields, adding to tables, 287
fields, populating, 287
finish dates, 834
interim, 614
Last Saved date, 288
monitoring schedules with, 312
multiple, 288
plans, 289
rebaselining, 289
reviewing, 286
reviewing, in chart, 90
reviewing resource workloads with, 327
reviewing, with Baseline table, 286
reviewing, with Tracking Gantt, 286
rolling up, 285
saved, adding tasks to, 284
saving, 283-84, 300
saving, multiple, 288
saving, vs. saving project plans, 283
specifying which to use for earned value analysis, 382
task duration in, 840
working with, 289
BCWP, 356, 382
difference between BCWS (see SV)
BCWP field, 830
BCWS, 356, 382
difference between BCWP (see SV)
BCWS field, 830
Before argument, 709
best-case scenarios
creating, for task durations, 135
viewing, 90
binding classes, to objects, 749
binding, early, 711, 728
Bit data type, 778
bookmarks, 755
Boolean data type, 711, 778
vs. Variant, 710
Boolean fields. See yes/no fields
Boolean variables, 712. See also yes/no fields
borders for network diagram boxes, changing, 598
bottom-down cost estimating, 218
Box Styles dialog box, 596
boxes, network diagram. See also network diagrams
aligning, 598
applying data templates to, 596
borders, modifying, 598
changing fields in, 596
displaying tasks as (see network diagrams)
formatting, 596-97
formatting layout, 598
positioning manually, 598
styles, modifying, 596
branching object models, 743
breaking
code, into multiple lines, 727
links, between resource pools and sharer files, 410
projects, into subprojects, 394
breakpoints, 751
clearing, 751
temporary, 752
toggling, 751
bringing in finish dates, 234, 240-41, 311, 319
by adding resources, 247
by adjusting resource settings, 246
by adjusting scope, 248
with task durations, 244
browsers, opening DAPs in, 790
Budget report, 355
generating, 229
printing, 229
budget-constrained projects, 249
budgeted at completion, 357
budgeted costs of work performed. See BCWP field
budgeting, 218
budgets. See also costs
buffer, reserving, 251
correcting overruns, 325
extra, what to do with, 251
maintaining, 231
more than costs, 251
realigning costs with, 325
records, archiving, 683
report, 250
sources of, 233
status, reviewing, 324
status, running reports on, 325
buffer
reserving, 251
scheduling (see slack)
building
custom reports, 363
digital dashboards, 466-67
project teams, with enterprise resource pool, 573
project teams, with Team Builder (see Team Builder)
resource list, from address book, 468
S-Curve graphs, 380
subwebs, for SharePoint Team Services, 513
built-in resource filters, 119, 197
built-in resource groups, 117
built-in task filters, 118
built-in task groups, 116
built-in templates, 675-76
built-in work contours, 215
Button Editor dialog box, 645
buttons
form, adding, 654
menu, modifying, 643
toolbar (see buttons, toolbar)
buttons, toolbar
accessing hidden, 643
adding, 642
adding images, 670
assigning macros to, 645
copying images, 645
creating, 668
customizing, 670
deleting, 645
editing image, 645
editing images, 648
failure to remove, 644
modifying images, 648
pasting images, 645
rearranging, 644
removing, 644
removing custom, 644
resetting, 645
saving custom, 648
buyoff, stakeholder. See stakeholder buyoff
C
calculated fields, 617
calculated filters, 628
calculating
automatic, turning off, 268, 275
averages, 619
cost variances, 321
critical paths, for subprojects, 397
earned value, 324
filters, 628
fields, 617
group values, 619
leveling, 272
leveling delay, 262
multiple critical paths, 239
necessary resources, 168
options for, 302
PERT, 136
project information, in Excel, 370
schedule change effects, 320
schedules, 236
schedules, with Critical Path Method (see CPM)
scheduling changes, keyboard shortcut for, 886
slack, for tasks, 236
summary values, 619
task duration, 201
task duration, for split tasks, 266
task duration, most probable, 134
tasks, percentage complete, 296
variances, 310
variances, for finish dates, 312
variances in schedules, 282
work variances, 327
calendar, resource. See resource calendars
Calendar table, 781
calendar tables, 771
Calendar view
bars, changing appearance of, 603
bars, choosing fields for, 603
bars, modifying styles for certain tasks, 603
bars, viewing task names in, 603
customizing, 603
formatting, 603
layout, modifying, 603
modifying, 603
previous month, previewing, 603
subprojects in, 393
tasks, arranging in, 603
tasks, displaying as many as possible, 603
timescale, modifying, 603
work days, displaying, 603
calendars, 61
base (see base calendars)
base, for resources, 847
modifying, 200
options, troubleshooting, 135
resource (see resource calendars)
tables (see calendar tables)
calling
functions, with subroutines, 714
methods, that return values, 709
methods, with parentheses, 709
methods, without parentheses, 709
Can Level field, 862
Cancel argument, 709
Cancel buttons in forms, 654
cancelling events, 709
carriage returns in VBA, 725
Case Else statements, vs. explicit constructions, 717
Case statements, 717
Cash Flow report, 229, 354
printing, 229
cash flow report, 250
categories
in databases (see databases)
of reports, 343
cells
anchor, 450
Excel workbook, formatting, 378
changes
accepting, from external tasks, 418
accepting, in Web Access team collaboration, 478
saving, in Web Access, 537
changing
author name, 776
base calendars, for multiple resources, 180
box styles, in network diagrams, 596
Calendar, 200
Calendar view, 603
Calendar view layout, 603
Calendar view timescale, 603
column headings, 605
column width, 110
columns, 109, 610
combination views, 100
constraints, 149
constraints, all, 243
constraints, in Gantt Chart view, 149
constraints, to flexible constraints, 243
constraints, with Project Guide, 150
critical path, 234
critical task slack amount, 235
custom field values, 617
decimal digits, in databases, 779
default resource working time, 178
default view, 85
design-time properties, 735
duration, remaining, 299
durations, 245
enterprise global template, 565
external predecessors, link type, 414
external tasks, including changes in project plan, 418
field formats, in Resource Graph, 602
fields, in network diagram boxes, 596
filter test order, 629
filters, 624
Fixed Duration tasks, 213
Fixed Unit tasks, 213
Fixed Work tasks, 213
form location, 652
Gantt bar appearance, 590
Gantt bar height, 595
Gantt bar text, 593
Gantt bar text, for all Gantt bars, 593
Gantt bar text style, 183
Gantt bars, 90
Gantt bars, for individual tasks, 591
global template, 674
gridlines, in Gantt charts, 595
group background color, 622
group font, 622
group heading rows, 622
groups, 621
library search order, 738
link lines between tasks, 595
link type, for external predecessors, 414
lookup table values, 634
macro toolbar buttons, 670
maximum units, 260
menu buttons and text, 643
milestone marker bar style, 158
network diagram box borders, 598
network diagram layout, 598
network diagrams, 596
pay rates, at specific time, 223
pivot tables, 380
priority, for multiple tasks at once, 269
project plans, 776 (see also project plans, adjusting)
projects, 310
report font, 345
report page setup, 344
resource assignments, 206
resource assignments, in resource pools, 409
resource availability graph, field based on, 199
resource calendars, 178, 260
Resource Graph, 599
Resource Graph bars, 599
Resource Graph, information included in, 602
resource names, in Resource Sheet view, 167
resource work amounts, 252
resource-specific information, 408
row height, 612
row height, in tables, 605
schedules, effect on project triangle, 242
schedules, with task types, 211
scheduling, 154
scope, 276
scope, getting approval for, 277
settings, globally, 674
status date, 302
subprojects, to read-only, 396
table definitions, 610
table header rows, 612
tables, 108
tables, in sheet views, 604
task arrangement, in Calendar view, 603
task bar styles, 603
task dependencies, 145, 244
task dependency link types, 244
task duration, 128, 211
task duration, in Gantt charts, 132
task durations, 245
task priority, 269
task types, 213, 214
task units, 211
template storage location, 681
Templates folder location, 681
text, in forms, 654
timephased field order, in timesheets, 606
timescale column width, 608
timescale for resource availability graphs, 200
timescale, for Resource Graph view, 255
timescale, in Gantt charts, 607
toolbar button images, 648
toolbar location, 646
toolbar properties, 645
toolbars, 639
UserForm defaults, 757
UserForm fonts, 757
UserForm titles, 757
VBProject object properties, 739
view content, 586
view formats, 596
view order, in combination views, 586
view order, in View menu, 587
views, 586
Web Access security categories, 513
work amount, 211, 252
Work Overbudget filter, 624
working time, 133
working times calendar, 135
workweek, 133
Char data type, 778
Chart Wizard, 380
charting
projects, vs. tracking, 282
S-Curves, 380
charts
creating, in Excel, 380
legends, displaying, 381
objects (see objects)
placing, 381
portions of (see objects)
Work Breakdown Structure, 447
checking
assignment units, 247
cost assumptions, 252
data formats, before pasting, 436
for duplicate resources, 168
for filtering, 121
finish dates, 241
fixed costs, 252
leveling results, 274
maximum units, 246
project plans, 231
project results (see project plans)
resource availability, in resource pools, 408
resource calendar, for assigned resource, 246
resource rates, 252
schedule assumptions, 242
scheduling controls, 242
slack, 262
task calendars, 245
task dependencies, 243
task type, 248
tasks, for least flexibility, 137, 236
checking in
enterprise projects, 550, 568, 693
project plans, 550
projects, 569
checking out
enterprise global template, 564, 566
enterprise projects, 568
files, while connected to server, 569
generic resources, 574
project files, 687
checking spelling, keyboard shortcut for, 885
child objects, 708
choosing
data types, 730
export filters, 374
graphical indicators, 620
macro storage location, 660
procedure storage location, 747
Resource Graph values, 600
class modules
creating, 748
inserting, 749
classes
binding to objects, 749
default member, finding, 744
members, listing, 744
cleaning up Project Server database, 514, 816
Clear Baseline dialog box, 291
clearing
baselines, 291
breakpoints, 751
interim plan fields, 291
leveling, 272, 274, 275
library check boxes, 738
object references, 728
Client Access Licenses, 514
closing
connections to external objects, 729
contracts, 683
keyboard shortcut for, 883
program window, keyboard shortcut for, 883
project window, keyboard shortcut for, 883
projects, 682
projects, postmortems, 683
resource availability graphs, 200
Table Definition dialog box, 611
code
adding to UserForms, 758
Auto Data Tips option, 753
blank lines in, 726
bookmarks, 755
breaking into multiple lines, 727
breakpoints, 751
clearing breakpoints from, 751
Definition command, 756
event, writing, 749
formatted, 726
indenting, 726
Last Position command, 756
line continuation character, 727
masks, 632
modularizing, 726
modules, 748
readability, improving, 726
running on start, 760
running to cursor, 752
scratch pad for (see Immediate window)
self-documenting, 712, 720
self-documenting, and constants, 725
stepping out of, 752
stepping over, 752
testing, 754
tracing, 752
trapping errors, 730
underscores in, 727
watches (see watches)
writing efficient, 728
Code field, 858
code masks, 632
code modules, 748
Code window
controls, 736
Full Module View button, 736
Objects box, 736
Procedure View button, 736
Procedures/Events box, 736
codes
for resources, entering, 181
outline (see outline codes)
codes, outline, 196, 631
assigning, 635
assigning to resources, 182
code masks (see code masks)
controlling values, 633
creating lookup table for, 631
custom, assigning values for, 635
custom, defining, 567
custom, renaming, 632
custom, setting up, 632
customizing, 585, 631, 632
defining settings for, 633
demoting entries in, 634
filtering by, 635
format, identifying, 635
grouping by, 635
grouping resources by, 635
grouping tasks by, 635
invalid, eliminating, 631
length, specifying, 632
maximum length, 631
promoting entries in, 634
renaming, 632
resource, 579
resource, custom, 580
restricting to lookup table, 633
separators, defining, 632
setting up, 631
sorting by, 635
templates, 632
coding. See also code; VBA
comments, 721
conventions, 720
easily understood, 720
formatting, 726
naming conventions, 721, 723
placeholder commas, 725
trapping errors, 730
Collaborate menu, 476, 480
Collaborate toolbar, 480, 516
displaying, 516
collaborating. See also team collaboration
with e-mail (see e-mail team collaboration)
collaboration
options, setting, 515, 520
publishing all information, 521
team (see team collaboration)
collaboration method, 294
collections, 707
Add method, 707
child objects, 708
Count property, 707
Item property, 707
parent objects, 708
color, background, modifying for groups, 622
Column Definition dialog box, 108-9, 489
opening, keyboard shortcut for, 884
columns, 775
absolute references, 661
absolute references to, in macros, 661
adding to tables, 108
data type in, changing when exporting numeric data, 378
deleting, 109, 183
dragging, 110
field information, aligning, 110
field information, changing, 110
headers, copying data without, 433
headings, double-clicking, 604
headings, modifying, 605
headings, renaming, 110, 616
hiding, 109, 183, 438
inserting, 155, 182, 437, 489
inserting, in resource sheets, 395
inserting in tables, 108
inserting, in tables, 611
inserting, in task sheets, 248, 395
modifying, 109, 610
moving, 110, 611
redisplaying, 109
references, in macros, 665
removing, 612
removing from tables, 109
renaming, 109
resizing, 110
resizing, in sheet views, 604
in Schedule table, moving, 235
selecting, 110
Task Name, 613
task name, invisible, 613
in timescales, modifying width, 608
in timesheets, resizing, 607
titles, aligning, 110
width, modifying, 110
combination views, 99
changing view order in, 586
creating, 100, 588
customizing, 586
focus, 101
modifying, 100
printing, 340
Resource Allocation, 100
splitting windows without, 123
switching views from, 257
Task Entry, 100
turning into single views, 101
combined resources, 191
procedures, reasons not to, 726
projects, into consolidated projects, 399
resources, into one resource, 173
comma-delimited text files, saving projects as, 697
commands
accessing hidden, 643
adding, to menus, 650
adding, to toolbars, 643
displaying, as text only, 645
dragging to new locations, 651
menu, viewing all, 643
rearranging on menus, 651
removing from menus, 651
comments
adding to resources, 185
in code, 721
compiling, in Web Access, 526
in macros, 666
viewing, 526
communicating
with reports, 338
with Web Access (see Microsoft Project Web Access)
communication, 475. See also team collaboration
determining types of, 339
importance of, 339
management (see communications management)
plan, 505
plan, implementing, 338, 530
planning, 339
vehicles for, 339
communications management, 339
Outlook and, 471
with Web Access, 505
company name, adding to administrative installation point, 811
comparing
baselines, to current schedule, 283, 312
costs, actual vs. planned, 217
costs, with baselines, 321
Excel information (see pivot tables)
fields, with filter tests, 628
project plans, to current progress, 309
projects, in portfolio view, 550
compilers, VBA, 728
compiling
comments, in Web Access, 526
status reports, text-based, 522
complete Project installation, 803
Complete Through field, 835
completed tasks
importing from Outlook, 466
viewing, 352
Completed Tasks report, 352
components, installing specific, 800
comprehensive views of project information. See portfolios
compressing duration, 245
conditional statements, 715
conditions
search, 691
testing for large number of, 717
configuring Project Server, 509
Confirmed field, 864
confirmed task durations
vs. estimated, 130
multiple, changing from estimated, 132
confirming passwords, 701
conflicts
preventing, 402
scheduling, 152
task duration, 234
connecting
to DAPs, 784
to data sources, 783
to Project Server, 812
Project Server, with Outlook, 469
Project, to Project Server, 820
projects, to DAPs, 790
connections
to external objects, closing, 729
SharePoint Team Services, setting up, 513
testing, 560
consolidated projects, 399
creating, 399
inserting projects into, 399
vs. master projects, 399
saving, 400
structure of, 399
temporary, vs. permanent, 399
consolidated resources, 191
constants, 712, 725
creating, 726
naming, 725
self-documenting code and, 725
String, 712
vbCrLf, 725
Constraint Date field, 835
Constraint Dates table, 103
Constraint Type field, 847
constraints, 147
applying, 150
As Late As Possible, 147
As Late As Possible, and deadlines, 156
As Soon As Possible, 147
associated with dates, 148
changing, 149
changing, all at once, 243
changing, for multiple tasks, 151
changing, in Gantt Chart view, 149
changing, with Project Guide, 150
Constraints Date table, applying, 150
vs. deadlines, 155
default, 147
deleting, 151
filtering tasks by, 153
flexible, 147, 151
grouping tasks by, 153
inflexible, 148, 152
list of, 148
moderately flexible, 151
range of dates for, 151
reviewing, 153
reviewing, for tasks, 242
sorting by, 242
sorting tasks by, 153
task dependencies and, 151
task dependencies, conflict with, 152
types, 147
types, when applied, 147
viewing for critical tasks only, 243
consumable supplies. See material resources
Contact field, 859
Contacts list, Outlook, adding resources from, 469
Contains Exactly test, 627
Contains test, 627
contouring
built-in, applying, 215
resource assignments, 214
contractors
cost, considering, 190
hiring, 219
contracts, closing, 683
controlling, 281
costs, 218, 326
costs, and earned value analysis, 326
outline code values, 633
projects, 369
Resource Graph, information included in, 602
schedule changes, with task types, 211
schedules, 320
controls
adding to UserForms, 757
associated with Code window, 736
scheduling, checking, 242
converting
Microsoft Excel formats, 460
pasted data into tables, in Word, 433
projects, for exporting, 442
projects, into resource pools, 406
projects, to enterprise projects, 569
coordinating Issues List, with team collaboration, 482
copies, opening projects as, 687
Copy Picture dialog box, 439
copying, 431, 637. See also pasting
base calendars, 179
between other applications, 423
between Project and Excel, 450
between projects, 419
between projects, with Organizer, 425
custom text fields, 421
customized elements, 637
customized elements, to global template, 636
customized elements, with Organizer, 618
data, without column headers, 433
elements, between projects, 638
elements, renaming when, 425
elements, to global template, 424, 637
fields, 422
fields, between projects, 421
fields, overwriting when, 423
formatting when, 437
forms, 652
formulas, between projects, 618
from Access, 436
from Access, maintaining column order, 437
from other applications, 436
from outside applications, 433
into Project, 433
keyboard shortcut for, 885
lists, 437
objects, 451
objects, into Project, 451
pictures, 439
project customizations, 423
resource information, between projects, 420
resource information, to resource pools, 404
resource names, 421
Resource Usage view, into Excel, 433
resources, from Excel workbook, 169
setting up data before, 436
start/finish dates into interim plans, 290
tables, 610
task information, between projects, 420
task names, 421
Task Usage view, into Excel, 433
tasks, 443
templates, 680
timephased information, into Excel, 433
timesheets, to Excel, 434
to Excel, 431
to other applications, 431
toolbar button images, 645
toolbars, 646
toolbars, to global template, 647
views, 587
with Organizer, 423
worksheets, 450
worksheets, into Project, 450
worksheets, to Excel, 451
correcting
budget overruns, 325
schedules, 319
cost accrual method, 224
cost estimating, 217
bottom-down, 218
top-down, 218
Cost field, 614, 831
cost management, 218
budgeting, 218
cost control, 218
cost estimating, 217-18
resource planning and, 218
Cost Per Use field, 831
cost performance, reviewing with earned value analysis, 322
Cost Rate Table field, 847
cost rate tables, 222
applying, to assignments, 224
specifying which to use, 224
Cost Rates table, 781
cost reports, 250, 354
budget report, 250
Cash Flow report, 250
cost, resource
planning, 217
reducing, 253
reducing, by adjusting assignments, 253
reviewing, 228
Cost table, 103, 106
applying, 321
viewing, 321
Cost Variance field, 825, 831
cost-related resource fields, 182
Cost1-10 field, 831
costs
accrual method (see cost accrual method)
accrual methods, viewing, 354
actual, comparing to planned, 217
actual, for overtime, 829
adjusting, 320
adjusting, to balance resource workloads, 253
analyzing, 250
analyzing, with earned value, 381
as most important factor, 249
assignment (see assignment costs)
for assignments, total scheduled, 614, 832
assumptions, checking, 252
assumptions, rechecking, 325
automatic calculation, turning off, 308
changes to, planning for, 326
comparing, with baselines, 321
controlling, 326
controlling, and earned value analysis, 326
Cost table, applying, 321
cumulative, 601
cumulative, for all tasks, 831
cutting, 249
data, 378
decreasing, by cutting scope, 276
entering manually, 308
estimating (see cost estimating)
filtering, for specific amount, 251
filtering resources by, 228
filtering tasks by, 230
fixed (see fixed costs)
grouping resources by, 228
less than budget, 251
listing resources in order of, 356
listing tasks in order of, 355
management (see cost management)
monitoring, 320
multiple, setting for resources, 222
overhead, 614
overruns, analyzing, 356
overtime, total scheduled, 835
for non-resource tasks, 834
per-use, 221
per-use, setting for work resources, 219
per-use, specifying, 221
performance, 322
performance data, analyzing in Excel, 378
planned (see planned costs)
planning, 217
point in time when incurred, 224
project, monitoring, 320
prorated, 224
rate tables (see cost rate tables)
reducing, 249, 325
reducing, by adjusting assignments, 252, 326
reducing, by adjusting schedule, 252
reducing, by adjusting schedules, 325
for remaining work, 835
reports, 250, 354
reports, running, 325
resource (see resource costs)
reviewing totals, 321
setting, for material resources, 221
setting, for work resources, 219
sorting projects by, 228
sorting resources by, 228
sorting sheet views by, 250
sorting tasks by, 230
source of, 218
specifying different for different times, 222
status, running reports on, 325
task, 217, 225, 228
task, as currently scheduled, 357
task, estimating, 357
task, original, 356
task, reviewing, 250
timephased, 227
total planned, viewing, 230
tracking, 354, 614
updating, 282
updating, manually, 308
variances, 357, 381 (see also Cost Variance field)
variances, calculating, 321
variances, evaluating with earned value calculations, 321
variances, reviewing, 321
variances, tracking, 218
viewing, 249
Count property, 707
counter variables, 718
CPI field, 853
CPM, 236
CPM method, 137
crashing schedules, 245
Create New Base Calendar dialog box, 160
Created field, 835
creating, 447
administrative installation points, 811
aliases, for custom fields, 616
Application event procedures, 748-49
assignments, 192
base calendars, 179
base calendars, custom, 160
base calendars, for resources, 178
base calendars, from Standard, 179
calculated fields, 617
charts, in Excel, 380
class modules, 748
combination views, 588
consolidated projects, 399
constants, 726
custom forms, 652
custom reports, 363
customized elements, before using, 588
DAPs, 782
data templates, 597
digital dashboards, 467
document libraries, 527, 543
drop-down list, for custom fields, 567
duration buffer, 130
enterprise projects, 560-61
event procedures, for UserForms, 759
Excel workbooks, 377
fields, 614
filters, 197, 627
filters, interactive, 629
filters, with AutoFilter, 630
filters, with multiple tests, 628
forms, 651-52
Gantt bar styles, for flagged tasks, 592
Gantt bar styles, for multiple conditions, 592
Gantt bars, 591
Gantt charts, with Gantt Chart Wizard, 589
generic resources, 574
graphical representations (see Microsoft Visio)
groups, 623
hyperlinks, for resources, 186
interactive filters, 629
issues, 526, 543
keyboard shortcuts, 650
lookup tables, 633
lookup tables, for outline codes, 631
macros, 659, 745
macros, intuitive, 662
master projects, 391
menus, 649-50
multiple critical paths, 239
note labels, 461
PivotChart reports, 780
PivotTable reports, 780
procedures, 747
Project event procedures, 750, 760
Project Server accounts, 516
Project Server accounts, timing of, 819
project templates, 672, 679
projects, from existing projects, 678
projects, with templates, 676
resource filters, 627
resource groups, 623
resource pools, 402
resource pools, from existing projects, 403
resources, in Assign Resources dialog box, 193
resources, when assigning, 193
scenarios for task durations, 135
schedules, 128
SharePoint team Web sites, 482
status reports, in Web Access, 538
tables, 613
tables, quickly, 610
task dependencies, 140
task dependencies, automatically, 141
task dependencies, multiple simultaneously, 140
task dependencies, with Project Guide, 141
task filters, 627
task groups, 623
task sheets, 370
tasks, in Web Access, 519, 534
tasks, options in Web Access, 534
templates, 679
to-do lists, 535
toolbar buttons, 668
toolbars, 641, 646
UserForms, 756
value lists, 567
views, 586, 588
views, with Web Access, 772
Web Access security categories, 513
Web Access users, 817
Web Parts, 482
windows, 124
work resource assignments, 192
criteria
for assigning tasks, 195
leveling, 268
search, adding, 691
searching for resources by, 196
Critical field, 863
critical paths, 234
accelerating, 234
calculating multiple, 239
changing, 234
creating multiple, 239
displaying multiple, 239
highlighting, 236
highlighting, with Gantt Chart Wizard, 237
identifying, 234
method for determining, 137, 236
multiple, displaying, 239
reviewing, 315
shortening, 240, 242-43, 245
shortening, by adding resources, 247
tasks in (see critical tasks)
viewing, 315
viewing, for individual subprojects, 397
viewing, in Gantt chart, 236
viewing, in master projects, 397
Critical Path Method, 137, 236
critical tasks, 234
adjusting, 242
constraints for, viewing, 243
definition, changing, 235
filtering for, 239, 246, 348
filtering task sheets for, 241, 315
finish dates and, 242
grouping by, 238
overallocating resources to, 248
resources assigned to, viewing, 246
reviewing, 315
shortening sequence of, 242
showing only, 241
slack, lack of, 235
slippage, lack of, 235
viewing details, in Gantt charts, 238
viewing durations for, 245
Critical Tasks report, 348-49
editing, 349
filtering, 349
printing, 348
cross-project links, 412
removing, 419
reviewing, 416
updating, 418
updating automatically, 419
crosstab reports, 365
crosstab tables. See pivot tables
CSV files, opening in Project, 697
cumulative costs
displaying, on Resource Graph, 601
for tasks, 833
Cumulative Cost field, 831
Cumulative Percent Complete field, 853
Cumulative Work field, 841
currency fields, 827
Actual Cost (see Actual Cost field)
Actual Fixed Cost (see Actual Fixed Cost field)
Actual Overtime Cost (see Actual Overtime Cost field)
ACWP (see ACWP field)
BAC (see BAC field)
Baseline Cost (see Baseline Cost field)
Baseline1-10Cost (see Baseline1-10Cost field)
BCWP (see BCWP field)
BCWS (see BCWS field)
Cost (see Cost field)
Cost Per Use (see Cost Per Use field)
Cost Variance (see Cost Variance field)
Cost1-10 (see Cost1-10 field)
Cumulative Cost (see Cumulative Cost field)
CV (see CV field)
EAC (see EAC field)
Fixed Cost (see Fixed Cost field)
Overtime Cost (see Overtime Cost field)
Remaining Cost (see Remaining Cost field)
Standard Rate (see Standard Rate field)
SV (see SV field)
VAC (see VAC field)
Current Activity reports, 350
current information, 310
current project plans, 283
current schedule, comparing with baseline, 283
cursors, running code to, 752
custom forms, 651
creating, 652
defining, 652
displaying, 656
opening, 656
custom menus
adding to toolbars, 643
naming, 643
sharing, 649
custom Project installation, 800
custom resource outline codes, 580
custom settings, globalizing. See global template
custom text fields, copying, 421
custom toolbar buttons, saving, 648
custom toolbars
missing, 647
removing buttons on, 644
sharing, 649
Custom AutoFilter dialog box, 630
Custom Field tables, 781
custom fields, 614, 869
Cost1-10 (see Cost1-10 field)
creating aliases for, 616
Date1-10 (see Date1-10 field)
defining options for, 567
defining skill sets with, 197
drop-down list, creating, 567
Duration1-10 (see Duration1-10 field)
in enterprise projects, 556, 561, 565-66
Finish1-10 (see Finish1-10 field)
Flag1-20 (see Flag1-20 field)
global template and, 548
graphical indicators for, 619
importing formulas from, 618
in MSP_PROJECT database, 826
number possible, 869
Number1-10 (see Number1-10 field)
OutlineCode1-10 (see OutlineCode1-10 field)
renaming, 616
specifying values for, 616
Start1-10 (see Start1-10 field)
storage location, 826
Text1-30 (see Text1-30 field)
using existing values in, 617
values, modifying, 617
custom filters, creating with AutoFilter, 630
Custom Form Editor, 652
custom outline codes
assigning values for, 635
filtering resources by, 636
filtering tasks by, 636
grouping resources by, 635
grouping tasks by, 635
renaming, 632
sorting resources by, 636
sorting tasks by, 636
customizable elements
copying, 637
copying, between projects, 638
copying, to global template, 637
deleting, 637
list of, 637
renaming, 637
Customize Enterprise Fields dialog box, 566
Customize Fields dialog box, 615
Customize Forms dialog box, 652, 656
Customize Group By dialog box, 635
Customize Tool dialog box, 645
customized elements
copying, 423, 637
copying to global template, 636
creating before using, 588
removing, 639
renaming, 639
restoring to default, 640
sharing, 636
customized toolbars, sharing, 639
customizing, 585
assignment field order, in team collaboration, 477
Calendar view, 603
column headings, 605
combination views, 586
data in enterprise projects, 548
digital dashboards, 482
e-mail team collaboration, 476
enterprise fields, 565-66
enterprise project analysis, 548
enterprise projects, 548, 556
fields, 112, 613, 615
filters, 197, 624
forms, 651
Gantt bars, 590
Gantt bars for individual tasks, 591
Gantt charts, 589
groups, 620, 621
legends, 342
macro toolbar buttons, 670
menus, 649, 650
menus in Web Access, 528
outline codes, 585, 631-32
portfolios, 550
preformatted reports, 364
Project, 641
projects, 585
reports, 363
resource calendars, 178
resource fields, 615
Resource Graph, 602
resource working times (see resource calendars)
single pane views, 587
software, with macros (see macros)
standard views, 586
tables, 610, 612
task fields, 615
tasks in Web Access, 534
team collaboration solutions, 482
templates in Web Access, 528
timescale tiers, 608
timescales, 607
timesheets, 294
timesheets, in Web Access, 525
toolbars, 641-42
toolbars, quickly, 644
tracking view, 301
usage views, 605
user interface, 641
view formatting, one view at a time, 596
views, 586
Web Access, 478, 527, 816
Web Access views, 527
cutting
costs, 249
costs, by adjusting assignments, 252
costs, by adjusting schedule, 252
keyboard shortcut for, 885
resource costs, 253
scope, to reduce costs, 326
tasks, impact on project plan, 232
CV field, 832
CV Percent field, 853
Next
Last Updated: August 13, 2002
|
