ppm-55 · » project codes can be defined to enable grouping of projects » codes can allow for...

65
PPM-55: Cobra Tips & Tricks Mary M Major, Deltek

Upload: others

Post on 09-May-2020

4 views

Category:

Documents


0 download

TRANSCRIPT

PPM-55:Cobra Tips & Tricks

Mary M Major, Deltek

Topics Assignment Export/Import

Apply New Rates to Forecast Class

Summary Calendar Set

Project Preferences

Application Preferences

Zero-Out Data

Views

Calculated Results

User Fields

Quick Access Toolbar

Report Categories

Questions

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 2

Assignment Export/Import

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 3

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 4

» Cobra Budget / Forecast can be

exported into a MS Excel file

» Any or all control accounts ca be

exported

» Resource assignments can

modified within the MS Excel file

» The updated MS Excel file can be

imported back into Cobra

Assignment Export

Integration / Assignment Export

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 5

» Cobra Budget / Forecast can be

exported into a MS Excel file

» Any or all control accounts ca be

exported

» Resource assignments can

modified within the MS Excel file

» The updated MS Excel file can be

imported back into Cobra

Assignment Export

Integration / Assignment Export

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 6

Assignment Export

Can select export file result

• First Result – as defined in the

resource calculation

• Total Currency

• Another defined result

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 7

Assignment Export

Status DateClass can be changed to import

the file into a different cost class

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 8

» Cobra Budget / Forecast can be

exported into a MS Excel file

» Any or all control accounts ca be

exported

» Resource assignments can

modified within the MS Excel file

» The updated MS Excel file can be

imported back into Cobra

Assignment Import

Integration / Assignment Import

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 9

» Cobra Budget / Forecast can be

exported into a MS Excel file

» Any or all control accounts ca be

exported

» Resource assignments can

modified within the MS Excel file

» The updated MS Excel file can be

imported back into Cobra

Assignment Import

Integration / Assignment Import

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 10

Assignment Import

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 11

Assignment Import

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 12

Assignment Import

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 13

Assignment Import

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 14

Assignment Import

New Budget resource

Apply New Rates to Forecast Class

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 15

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 16

Apply New Rates to Forecast Class

Default Rate FileThe Default Rate File is

used … unless there is

a Rate File specified for

a Cost Class

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 17

Apply New Rates to Forecast Class

Cost Class settings (including

Rate File) can be copied to one

or more projects. This is a great

way to ensure that new rates are

applied to ALL projects

When copying settings on an

existing Cost Class, make sure

to check the “Allow existing … to

be replaced” option

Summary Calendar Set

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 18

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 19

» Time-phased details will display

periods with “fixed” flags only

Summary Calendar Set

Calendar / Calendar Sets

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 20

» Time-phased details will display

periods with “fixed” flags only

» A non-default Calendar Set (not

Calendar Set 00) can be

associated with a Cost Class

» Useful for long duration records

where monthly time-phasing for

out-periods is not required

Summary Calendar Set

Project Properties / Classes

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 21

Summary Calendar Set

Time-phased details display

periods based on the Cost Class’

assigned Calendar Set

Project Preferences

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 22

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 23

» The values in the “Selected”

column will display as the “default”

when running the associated

process

» If the “Secure” option is selected,

the “Selected” settings can not be

changed within the associated

process – changes must be made

in Project Preferences

» User access to “Secured” items can

be limited in EPMSA – this can be

used to “force” a process to run a

specific way every time

Project Preferences – Actual Costs

Project Properties / Preferences / Actual Costs

To identify actual costs associated with

planned and/or completed Control

Accounts/Work Packages, unselect the

“Allow … planned …” and “Allow …

completed …” options to generate the error

list; then reselect the options to post all

actual costs

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 24

» If there are LOE work packages in

Cobra that are not updated from a

schedule, this option will ensure

that LOE work packages are

opened on time

Project Preferences – Advance Calendar

Project Properties / Preferences / Advance Calendar

Project Preferences can be copied

from a project to one or many

other projects. This is useful if a

preference change needs to be

updated on all projects

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 25

» Select the projects to copy the

current Project Properties to

Project Preferences – Copy Preferences

Project Properties / Preferences / Copy Preferences

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 26

» The Project / Project Preferences

section does not have a “Secure”

column since there are no

associated processes

Project Preferences – Project

Project Properties / Preferences / Project

Application Preferences

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 27

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 28

» Project Terminology can be

modified to provide consistency

and standardization within your

organization

Application Preferences -General

Application Preferences / General

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 29

» Project Codes can be defined to

enable grouping of projects

» Codes can allow for free-form text

entry or selection from a code file

» Code files can be flat or can include

hierarchal structure

» If a code file is used, it can be

Optional or Required

Application Preferences –Project Codes

Application Preferences / Project Codes

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 30

Application Preferences – Project Codes

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 31

» Additional Note Categories can be

added to Cobra

Application Preferences –Notes

Application Preferences / Notes

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 32

» Spread Curves can be added /

modified to align resource

assignment spreads with your

organization’s standards

Application Preferences –Spread Curves

Application Preferences / Spread Curves

Zero-Out Data

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 33

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 34

» All types of time-phased data can be Zero-Out to easily fix data issues / errors

» Budget

» Forecast

» Actual

» Performance

» Zero-Out Data can be applied at various levels

» WP or CA

» Structure (WBS, OBS, etc.)

» Resource Assignment

» Entire project or a time range

Zero-Out Data

Tools / Zero-Out Data

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 35

» All types of time-phased data can be Zero-Out to easily fix data issues / errors

» Budget

» Forecast

» Actual

» Performance

» Zero-Out Data can be applied at various levels

» WP or CA

» Structure (WBS, OBS, etc.)

» Resource Assignment

» Entire project or a time range

Zero-Out Data

Tools / Zero-Out Data

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 36

Zero-Out Data

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 37

Zero-Out Data

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 38

Zero-Out Data

Actuals for the selected

period(s) are now zero

Views

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 39

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 40

ViewsBudget View

• Filtered for Budget

Cost Classes only

• Status and Cost

Class columns

moved to the left for

easier visibility

Cost Class filter includes “Cost Set” option

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 41

ViewsStatus View

• Does not include Resource

Assignments

• Includes Percent Complete

(WP) and Calculated

Percent Complete (CA)

• Filtered for In-Process and

Planned WP only

• Includes Actual and

Forecast Dates

• Includes WP / CA values

for easy reference

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 42

Save View

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 43

Manage Views

Calculated Results

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 44

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 45

» “On The Fly” basic calculations with

defined results

» The data is presented on Cobra

reports

» The data is not stored in the

database

Calculated Results

Reporting / Tools / Calculated Results

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 46

» “On The Fly” basic calculations with

defined results

» The data is presented on Cobra

reports

» The data is not stored in the

database

Calculated Results

Reporting / Tools / Calculated Results

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 47

Calculated Results

Use care with “Currency” flag – if new Calculated Result is a sub-

total, then including the base results and the new Calculated

Result will double the base results in any report totals

Simple mathematical

calculations

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 48

Calculated Results

Include “Results” on Sub-Totals

screen of Report Wizard

Include Calculated Result on

Results screen of Report Wizard

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 49

Calculated Results

User Fields

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 50

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 51

» Cobra ships with 5 of each User Fields

» Character

» Date

» Numeric

» Data can be displayed in the Spreadsheet view

» Data can be imported from a schedule or MS Excel files

» Data can be added to report tags

» Another 5 of each type of User Fields can be added to Cobra

User Fields

User Fields

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 52

User Fields

User Fields are free form –

no code file validation

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 53

User Fields

Property Tag references

User Character Field #1

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 54

User Fields

Quick Access Toolbar

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 55

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 56

» Common Cobra functions can be

displayed on the Quick Access

Toolbar

» Option to display the Quick Access

Toolbar above or below the Ribbon

» Option to minimize the Ribbon

Quick Access Toolbar

Quick Access Toolbar

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 57

Quick Access Toolbar – Backup & Restore

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 58

Quick Access Toolbar – Above / Below the Ribbon

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 59

Quick Access Toolbar – Minimize the Ribbon

Click on a Ribbon title to

expand the Ribbon

Report Categories

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 60

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 61

Report Categories

When saving a report with

project specific criteria, the

“Category” field can be

modified to allow for easier

report sorting

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 62

Report Categories – All Reports

In “All Reports” - reports can

be sorted by Category.

Project specific reports will be

grouped together

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 63

Report Categories – Report Wizard

In “Report Wizard” - reports can be filtered by

Category. Only reports with the specified

Category will be displayed

Questions?

CONFIDENTIAL © Deltek, Inc. All Rights Reserved. 64