• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Ten Six Consulting

Project and Earned Value Management, Primavera P6 & Deltek Cobra & Acumen Services

703-910-2600
  • Training
    • Primavera P6 Training
    • Deltek Training
    • Microsoft Project Training
    • Project Management Training
    • Earned Value Management Training
    • Open Training Class Dates
    • Customized Video Training Classes
  • Consulting
    • Project Management
      • Assessments and Health Checks
      • Organizational Change Management
      • Project Governance
      • Project Management Tool Selection
      • Risk Analysis Services
      • Scheduling Services
      • Project Management Staff Augmentation
    • Project Management Office (PMO)
      • PMO Pulse Check
      • PMO Implementation Planning
      • PMO Organization Change Management
      • PMO Project Manager Leadership Development
      • PMO Planning Best Practices
      • PMO Scheduling Best Practices
      • PMO Enterprise Tool Training
      • Program Manager Challenges
    • Earned Value Management
      • EVMS RFP Support
      • EVMS Assessments
      • Earned Value Management Tool Selection
      • EVMS System Description and Process Development
      • Integrated Baseline Review (IBR) Preparation and Conduct
      • EVM Certification Support
      • Integrated Master Schedule (IMS) Health Check
      • Action Plan Development for Progress Assessment Reviews
      • Earned Value Data Analysis and Reporting
      • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
      • EVMS Staff Augmentation
    • Risk Management
      • Risk Management Support and Consulting
      • Risk Management Maturity Assessment® (RMMA)
      • Risk Management Checkup Services (RMCS®)
      • Risk Management Training and Workshops
    • Portfolio Management
      • IT Portfolio Management
      • Corporate Governance Portfolio Management
      • Product Portfolio Management
      • Public Sector Portfolio Management
      • New Product Development Portfolio Management
    • ISO 21500 Assessment
  • Software
    • Primavera P6
      • Primavera P6 Application Consulting
      • Primavera P6 BI Publisher Services
      • Primavera P6 Technical Consulting
      • Primavera P6 Integration
      • Primavera P6 Knowledge Transfer, Mentoring and Coaching
      • Primavera P6 Staff Augmentation
    • Primavera Unifier
    • Deltek Cobra
      • Deltek Cobra Application Consulting
      • Deltek Cobra Knowledge Transfer, Coaching and Mentoring
      • Deltek Cobra Integration
      • Deltek Cobra Staff Augmentation
    • Microsoft Project
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
      • Microsoft Project to Primavera P6 Conversion Service
  • Blog
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • About Ten Six
  • Contact Us

Primavera P6 and Displaying Activity Table Ordinal Date Columns

You are here: Home / Primavera P6 / Primavera P6 and Displaying Activity Table Ordinal Date Columns

June 20, 2016 By TheP6Pro

Primavera P6 has a feature for displaying ordinal dates on the Gantt chart. No such equivalent feature is available to display ordinal date columns in the activity table. Let’s investigate a somewhat involved but viable approach to populating an activity column with ordinal dates.

Ordinal dates are a way of measuring your schedule time in a series, e.g. 1, 2, 3, 4 … This is particularly useful during the project initial planning stage when the schedule start date and deadline may not be known. Primavera P6 Professional still requires a project planned start for schedule creation even though your actual start date is unknown.

Primavera P6 does, however, provide a way to present your Gantt chart using calendar ordinal dates in lieu of actual calendar dates. Unfortunately, no such feature is apparent for defining calendar ordinal dates in an activity’s table column. There are approaches for displaying a column of ordinal dates in the activities table.

One such approach attempts to employ the tools global change feature. The negative of the global change approach is that the global change tool computes activity start and finish dates based on working days and not calendar days; weekends are not accounted included. This is not good, but we are not without hope. There is a way to implement Microsoft Excel to assist in populating an activity table column with calendar ordinal dates, i.e. ordinal dates that include weekends. Yes, this technique requires you export data to Excel, but you will achieve your goal of fully presenting your schedule to stakeholders without confusing matters with pseudo project calendar start and finish dates.

This article describes how to utilize both Primavera P6 Professional and Microsoft Excel in support of displaying project activity calendar start and finish ordinal date columns.

We begin with our demonstration project schedule in Figure 1.

P6 - Displaying Activity Table Ordinal Date Columns Figure 1Figure 1

The Gantt chart is displaying ordinal dates. The ordinal start is the project start date and the ordinal interval is day. For instructions for how to display ordinal calendar dates on the Gantt chart refer to the following blog “Primavera P6 Professional and Ordinal Gantt Chart Date“.

Our activity table, however, is displaying the calendar start and finish dates of each activity, which may confuse stakeholders whom have not specified a project start and deadline. Let’s proceed and present how to populate an activity table column with calendar ordinal dates.

We begin by creating user defined fields (UDF) for our ordinal calendar start and finish date activity table columns. Select Enterprise | User Defined Fields from the top drop down menu. In the UDF dialog select activities from the top drop down menu and add both UDF_Finish_Day and UDF_Start_Day UDFs with an integer data type, Figure 2.

P6 - Displaying Activity Table Ordinal Date Columns Figure 2Figure 2

Great! Now remove the start and finish day columns and add UDF_Start_Day and UDF_Finish_Day columns to the activities table, Figure 3.

P6 - Displaying Activity Table Ordinal Date Columns Figure 3Figure 3

Looks good, but we do not want the summary values on the work breakdown structure (WBS) elements, so toggle off ‘show group totals’ in the ‘Group and Sort’ dialog. Your activities table will now look similar to Figure 4.

P6 - Displaying Activity Table Ordinal Date Columns Figure 4Figure 4

Let’s continue with the export procedure. Select File | Export and toggle Spreadsheet – (XLS), Figure 5.

P6 - Displaying Activity Table Ordinal Date Columns Figure 5Figure 5

In the Export Type dialog toggle Activities, Figure 6; we do not need to worry about Activity Relationships.

P6 - Displaying Activity Table Ordinal Date Columns Figure 6Figure 6

In Projects to Export dialog, Figure 7, we check the appropriate project.

P6 - Displaying Activity Table Ordinal Date Columns Figure 7Figure 7

Next we add a ‘Calendar Days’ template in the Select Template dialog, Figure 8, and choose the appropriate activity options, Figure 9.

P6 - Displaying Activity Table Ordinal Date Columns Figure 8Figure 8
P6 - Displaying Activity Table Ordinal Date Columns Figure 9Figure 9

Note the project name and location the file will export to, Figure 10.

P6 - Displaying Activity Table Ordinal Date Columns Figure 10Figure 10

Finish the export. The export produces the Microsoft Excel file displayed in Figure 11.

P6 - Displaying Activity Table Ordinal Date Columns Figure 11Figure 11

Now we edit the Excel file. Delete the ‘Activity Status’, ‘Activity Name’, and ‘Delete This Row’ columns. Insert the project start date in cell G1. In cell E3, enter the formula C3-$G$1 and copy down the column, leaving activity A1030 ‘project completion date’ cell empty. In cell F5 and below enter the formula displayed in the spreadsheet, Figure 12.

P6 - Displaying Activity Table Ordinal Date Columns Figure 12Figure 12

The formula for these cells is listed in the formula bar. The MOD portion of this formula accounts for the last 8-hour period on the finish day. Our schedule is assigned a 5-day by 8-hour per day calendar. Without this formula this final 8-hour workday period would compute to 0.33 or 8/24. In our formula we multiply the remainder by 24/8 to specify that each 8-hour period is 1-day. This formula should work as well for half day work efforts.

As per Figure 13, 14, and 15 import the XLS file.

P6 - Displaying Activity Table Ordinal Date Columns Figure 13Figure 13
P6 - Displaying Activity Table Ordinal Date Columns Figure 14Figure 14
P6 - Displaying Activity Table Ordinal Date Columns Figure 15Figure 15

The schedule with populated activity table columns UDF_Start_Day and UDF_Finish_Day is in Figure 16.

P6 - Displaying Activity Table Ordinal Date Columns Figure 16Figure 16

In Figure 17, we edit the UDF_Start_Day column heading with the new title ‘ordinal start day’.

P6 - Displaying Activity Table Ordinal Date Columns Figure 17Figure 17

The final schedule is displayed in Figure 18.

P6 - Displaying Activity Table Ordinal Date Columns Figure 18Figure 18

Summary

When your project start date and deadline are unknown it makes sense to present the Primavera P6 schedule to stakeholders using the ordinal calendar dates. We say ‘calendar’ ordinal dates to indicate that weekends are included in our computations, and not just work days.

Our Microsoft Excel export/import approach allows us to update the activity start and finish dates with the appropriate calendar ordinal start and finish dates. One may also be interested in listing the start week or month of activities. I would again recommend the use of Excel for this computation instead of the global change tool.

Primary Sidebar

  • This field is for validation purposes and should be left unchanged.
  • Facebook
  • LinkedIn
  • Twitter

Categories

  • Deltek Acumen
  • Deltek Cobra
  • Earned Value Mgmt
  • Microsoft Project
  • PMO
  • Primavera P6
  • Project Management
  • Risk Management

Archives

Footer

Upcoming Classes

Primavera P6 Professional Fundamentals

Primavera P6 EPPM Fundamentals

Primavera P6 EPPM Administrator

Oracle Primavera P6 BI Publisher Fundamentals Training Class

EVMS Training

Deltek Cobra Fundamentals Training

Deltek Cobra Advanced Training Class

Deltek Acumen Fuse Training Class

Copyright © 2021 · Ten Six Consulting, LLC · 703.910.2600

  • Training
    ▼
    • Primavera P6 Training
    • Deltek Training
    • Microsoft Project Training
    • Project Management Training
    • Earned Value Management Training
    • Open Training Class Dates
    • Customized Video Training Classes
  • Consulting
    ▼
    • Project Management
      ▼
      • Assessments and Health Checks
      • Organizational Change Management
      • Project Governance
      • Project Management Tool Selection
      • Risk Analysis Services
      • Scheduling Services
      • Project Management Staff Augmentation
    • Project Management Office (PMO)
      ▼
      • PMO Pulse Check
      • PMO Implementation Planning
      • PMO Organization Change Management
      • PMO Project Manager Leadership Development
      • PMO Planning Best Practices
      • PMO Scheduling Best Practices
      • PMO Enterprise Tool Training
      • Program Manager Challenges
    • Earned Value Management
      ▼
      • EVMS RFP Support
      • EVMS Assessments
      • Earned Value Management Tool Selection
      • EVMS System Description and Process Development
      • Integrated Baseline Review (IBR) Preparation and Conduct
      • EVM Certification Support
      • Integrated Master Schedule (IMS) Health Check
      • Action Plan Development for Progress Assessment Reviews
      • Earned Value Data Analysis and Reporting
      • WBS Guidelines for Government Acquisition Programs (MIL-STD 881D)
      • EVMS Staff Augmentation
    • Risk Management
      ▼
      • Risk Management Support and Consulting
      • Risk Management Maturity Assessment® (RMMA)
      • Risk Management Checkup Services (RMCS®)
      • Risk Management Training and Workshops
    • Portfolio Management
      ▼
      • IT Portfolio Management
      • Corporate Governance Portfolio Management
      • Product Portfolio Management
      • Public Sector Portfolio Management
      • New Product Development Portfolio Management
    • ISO 21500 Assessment
  • Software
    ▼
    • Primavera P6
      ▼
      • Primavera P6 Application Consulting
      • Primavera P6 BI Publisher Services
      • Primavera P6 Technical Consulting
      • Primavera P6 Integration
      • Primavera P6 Knowledge Transfer, Mentoring and Coaching
      • Primavera P6 Staff Augmentation
    • Primavera Unifier
    • Deltek Cobra
      ▼
      • Deltek Cobra Application Consulting
      • Deltek Cobra Knowledge Transfer, Coaching and Mentoring
      • Deltek Cobra Integration
      • Deltek Cobra Staff Augmentation
    • Microsoft Project
      ▼
      • Building an Integrated Master Schedule (IMS)
      • Integrating Microsoft Project with Deltek Cobra
      • Migrating From Microsoft Project To Oracle Primavera P6
      • Microsoft Project to Primavera P6 Conversion Service
  • Blog
    ▼
    • Deltek Acumen
    • Deltek Cobra
    • Earned Value Mgmt
    • Microsoft Project
    • PMO
    • Primavera P6
    • Project Management
    • Risk Management
  • Clients
  • About Ten Six
  • Contact Us