Skip to main content

Emerald Blog

Stories, Tips And Tricks From Our Team’s Experiences With Primavera Since 1995

Moving Time in Team Member - EASY

When you are working on a project and you move from Project into Support, sometimes it is hard to decide the exact cutoff point for the project team to start charging to the new support project. I had a problem the other day where I needed to decide the end date and cut over. The client selected a date a few weeks before we had thought we were going to cut it off after she checked her budgets and we realized we were going to go over.

So I had to go back to look through the timesheets we had submitted in Team Member to get the time reallocated before sending it into our QuickBooks where we invoice from.

P6 TOOLS – PART OF YOUR COMPANY DIGITAL TRANSFORMATION?

Hearing a lot about ‘digital transformation’ lately? Digital transformation can be defined as the acceleration of business activities, processes, competencies and models to fully leverage the changes and opportunities of digital technologies and their impact in a strategic and prioritized way.

What elements are included in your digital transformation plan? Can your team afford to ignore new technological advancements? Planning a strategic and prioritized path forward to fully leverage changes and opportunities in digital technology can have a very positive return on investment. The digital transformation for a company varies from company to company and can be a large project encompassing many different elements depending on said company and its current state.

Here's an example of leveraging changes and opportunities new technologies can provide. Say your team uses Primavera P6 for Project Management, yet doesn't use P6-Loader, P6-QA Tool, CAPPS or TAPS (barcode updating), and P6-Calculator for any efficiency gains, are you getting the best out of the tool. In many surveys conducted over the years by Oracle and Primavera, P6 is highly underutilized with 100% of clients using P6 for scheduling, 60-70% for resource management and only 30-40% for cost management and earned value analysis.

Emerald Associates specifically designed our productivity tools to address pain points users commonly encounter when using P6 so you can do better managing your projects and get more out of the project team.

P6-Loader

  • Automates manual data entry through the secure import and export of most data elements between Primavera P6 and Microsoft Excel.
  • Allows for the controlled extract and upload of data at the global and project level and eases the challenge of manipulating your project data by leveraging the spreadsheet functionality of Excel.
  • Goes above and beyond the built-in import and export functionality in Primavera P6. It has also become a desired replacement for the outdated Primavera SDK (Software Development Kit). Now, with version 4 being cloud enabled, it is quickly becoming a desired tool to help with migrating to the cloud efficiently. With close to 1 Billion of transactions pushed through the system, it is making teams worldwide more productive.

P6-QA

  • Removes the burden of manual schedule and business process analysis by automatically identifying deficiencies in Primavera P6 schedules based on scheduling best practices, industry standards, and user introduced business process requirements.
  • It is unlike other third party Primavera schedule validation tool because it seamlessly integrates directly into Primavera P6 itself, allowing for the improvement of project management skills and scheduling quality in real-time. The P6-QA tool can be run at a preset interval such as weekly or monthly, or on an as-needed frequency to maximize your P6 schedulers’ ability to self-critique and ensure effective quality control.
  • When your resident engineering team is your frontline reviewers, this tool makes their role much easier and more efficient saving you a lot of time getting your contractors schedules reviewed, critiqued and hopefully approved so you know if the project is still on track without an expensive team doing a lot of analysis. When you are reviewing schedules every few weeks on a project this is significant in time savings as well as the time freed up to address any issues on the project.

CAPPS

  • Lets the remote users and likely non P6-Experts to get the project updates into P6 from wherever they are and whenever they have a moment. This means waiting for updates once a month is a thing of the past. Taking 2 weeks every month to get your portfolio updated is a thing of the past. Real-time statusing is doable with variances and deviations able to be highlighting and interjected into the schedule as they are happening making your forecasting, change management and claims avoidance mush more effective.

TAPS

  • The Turnaround Progressing System; it uses barcode scanning technology to eliminate the need for lengthy manual data entry when updating your Oracle Primavera P6 schedules. Simply use a barcode scanner to find, start, update or cancel any activity within the schedule in two quick scans.
  • Status updates can be done 75% faster while increasing your team's accuracy, since there's no chance of manual data entry errors. The first scan finds the task and the second scan starts, finishes, and statuses the task with any of the percent complete types available in Primavera P6.
  • The progressing flexibility along with the ability to calculate and report Earned Value at the resource assignment level makes TAPS a strategic enhancement for all Primavera P6 users.

P6-Calculator

  • Performs calculations that are traditionally unavailable in Primavera P6.
  • Automatically performs calculations on data in P6 to present information to users that would otherwise be difficult for them to see, improving visibility and digestibility of complex P6 data and enabling better decision making.

All of the above tools are available on the Oracle Cloud Marketplace.

This is just one small example of an opportunity to leverage the changes and opportunities of digital technologies and claim the positive rewards of their impact. Help your team work smarter, not harder by empowering your team with the best tools!

Are You Tracking Ideas? Are Approved Ideas Easily Translated into Project Proposals?

Ideas in Oracle Prime:

Use Oracle Prime to create ideas: capture, evaluate, and process the ideas for new initiatives and business endeavors.

Ideas are processed using a submission and approval workflow. Prime Projects provides a default workflow for processing ideas, or you can create a customized workflow. First the idea creator creates an idea and specifies the idea's business case. When an idea contains sufficient information, the creator can submit the idea for further processing by routers and owners.

DOTs and Emerald Associates - We Can Make Your Job Easier

Emerald Associates is well known in the US and Canada for our homegrown add-on tools for Primavera P6. We have assisted numerous companies in many diverse areas to get the most out of their P6 software. You may wonder how our tools can assist in the Department of Transportation (DOT) field to get more done in P6 with less time while still providing useful data to your stakeholders and remaining good stewards of the public's funds. Our tools will help you do more work in less time, so that your project management group has more time to analyze and perfect their schedules.

P6-QA and the Project Scheduler

Manually wading through a schedule and looking for errors is time consuming and prone to human error. Not only that, it's boring. No one wants to do it, but you need to check your schedule for errors!

Even worse then working through your own schedule for errors, is slogging through a contractor's. When you don't know how they have built the schedule, it can take days to make sure things hold together. Some of our clients have several layouts, reports and even special access databases and outside tools to do this which is very time consuming, error prone and boring.

Finding Setting Up or Changing Resource Availability in P6 a Struggle?

We have all experienced at one point or another how tedious (and time consuming) setting or changing resource availability can be in the P6 resource dictionary. Particularly for an example like the one we will walk through where you are setting up or adjusting turnaround resources and the weekend rule happens to be ½ crews.

P6-Loader can ease the pain of these types of tasks.

Global Calendars – Exactly Which Projects Are Using Each Calendar?

In P6, identifying each specific project using each of the Global Calendars in a concise, fast, easy to use manner is challenging. Some may think this is not necessary very often, but in my experience, it has been quite the opposite!

Is this functionality already handled in Primavera P6, Client or Web? A very good question - let’s have a look.

Do You Need EV Calculated at the Resource Level?

You are correct; out-of-the-box P6 does not calculate Earned Value (EV) at the resource assignment level. It only runs EV at the activity level which is fine for a start, but what to do when you need to 'dig deeper' and analyze crew performance? You can't use Global Change to calculate the resource assignment EV because the activity percent complete isn't available in the Global Change list of fields.

A very simple option is to use TAPS to input your schedule updates. TAPS is P6 updating using barcodes (plus additional functionality). By using TAPS, updates are faster and more accurate giving you (and your team) more time for schedule analysis. Yes, TAPS runs EV calculations at the resource level.

P6-Loader Usage Sheets Revolutionize P6 Database Maintenance

When you have a large number of users in your P6 database, it is surprising how quickly that database can get “clogged up” with a lot of unwanted data. This happens even when using Sandbox databases, restricting privileges and every other trick you have thought of; long time P6 users know what I am talking about.

P6-Loader - Easy Moving of Pre-Turnaround Work to the Turnaround Window

On every Turnaround there are Pre-Turnaround activities that do not get done prior to the actual Turnaround and need to be moved into the Turnaround phase of the schedule.

The challenge is how to record actual hours earned in the PRE phase vs the TA phase, since a large number of these activities already have earned hours associated with them. Simply moving the activities would decrease the reporting of hours in PRE and create earned hours in TA for work that was actually done in PRE.

This can be done simply and quickly with P6-Loader.

A Guide to P6 Archiving - Part 2

Archiving P6 Project Data and the Question of Location

This is part 2 of a series of blogs discussing best practices of P6 archiving. In Part 1 we discussed the question of time:

  • How long should you keep a P6 project file?
  • How do you track the date to archive your P6 project?

Now we will discuss the question of location.

archive project data

A Guide to P6 Archiving - Part 1

Archiving P6 Project Data and the Question of Time

We get asked on a regular basis what the best way to archive P6 data is.

  1. How long should a project file be kept?
  2. What should be done with the project files when that time period has expired?
  3. Where should they be kept?
  4. How can we retrieve if we need them, especially with upgrades?

In this blog series, we’ll look at some of the options available to a P6 user and discuss the question of time.

Archiving P6 Project Data and the Question of Time

What Is Happening With My Magic Quadrant Investor Map?

A Look Inside Oracle Primavera Portfolio Management Graphical Analysis

Last week I logged in to my Oracle Primavera Portfolio Management environment and found that my items were in the wrong quadrants. Rather than having current tasks in my upper quadrants and future tasks in my lower ones, all my tasks were being broadcast as low priority and ending up at the bottom of the quadrant.

OPPM Magic Quadrant1