Tag Archives: Primavera timesheet

The TimeControl Primavera integration link just turned 25

It’s quite a remarkable anniversary and in the busy-ness of the business it almost went unnoticed.  This summer, the anniversary of our integrated link between our TimeControl timesheet system and Primavera became 25 years old.

The first version of the integration was between TimeControl version 2 and Primavera P3 using the RA connector.  That’s some time ago.  When Primavera released TeamPlay/P3e, TimeControl was the first integration announced of any product to it.   With each version of Primavera and each version of TimeControl the link has grown.

When both products became browser-based, the TimeControl/Primavera link was there.  When Oracle-Primavera EPPM was announced, the TimeControl/Primavera link was ready.  When SOAP Web services were released, the TimeControl/Primavera link carried that new option.

TimeControl will release an updated link to Primavera in its next update that includes support for Primavera’s REST API link.

Most companies don’t last 25 years.  Not only have the Primavera and HMS team both survived, we’ve grown closer over time.  Now the TimeControl/Primavera link supports all versions of Primavera right up to the most current and, it can support multiple version and types simultaneously.  Support for Primavera Pro and Primavera EPPM can be included at the same time in the same TimeControl system.

To read the Press Release on the Primavera/TimeControl link, see: Primavera/TimeControl at 25.

To find out more about the link, see: Primavera.TimeControl.com.

The TimeControl / Primavera Link continues to evolve

The Link between TimeControl and Primavera comes from a long partnership.  In 1997, HMS and Primavera worked together to make the first link between TimeControl 2.1 and Primavera P3.  As each product has evolved, the TimeControl Link has too.  In virtually every version of TimeControl there has been some improvement or some extension of the Primavera Link.

There are numerous advantages of blending the TimeControl auditable timesheet functionality with the power of Oracle-Primavera’s project management functionality.  Key features of the link include:

  • TimeControl’s Matrix Approval Process for Labor Actuals™
  • Uploading not only hours but also Material consumption, Equipment Usage and Progress achieved (using TimeControl Industrial)
  • Missing timesheet management
  • Automated business validation rules
  • Extensive rate management with unlimited rates per resource
  • Management of vacation, sick leave, and personal time banks
  • Management of banked overtime and;
  • The free TimeControl Mobile App.

The TimeControl Link can support multiple Primavera editions and even multiple versions at one time including Primavera EPPM and Primavera Pro.  The integration to and from Primavera can be run on demand or on your own schedule.

There are numerous resources on the TimeControl.com website talking about how to integrate with Primavera and the benefits of combining Primavera with TimeControl.  Start at primavera.timecontrol.com to discover white papers, slide presentations, webcasts and more.

Timesheets costs can be a complex conversation that TimeControl is ready for

One area of functionality that has made TimeControl so popular is the level of flexibility in the Rate structure. It’s a necessary element for TimeControl because of the multi-functional nature of the product and how costs might be thought of one way for one part of the company, (for example Billing) and very differently by another part of the company (for example, Payroll).  The options for how rates are selected and then calculated are extensive and designed to fulfill as many business scenarios as possible.  Let’s look at just a few of these options:

Rate Code Types

TimeControl Rate codes are created as either Global, Resource, Individual or Non-Labor types.  For labor resources a Global-type could appear for any employee’s timesheet, a Resource-type would appear only when that employee is part of the resource referenced in the Resource code and an Individual-type could appear only for the employee specified.  Already that’s a lot of options!

Rate Codes per line item

TimeControl allows an unlimited number of rates per employee and per timesheet.  You are even allowed to have the same charge code entered more than once with each line having a different rate code.  So this can easily accommodate an employee who might fulfill one function in the morning on a task and a different function to be billed at a different rate in the afternoon.

Project Rates

Some organizations want a default project rate for each employee.  While the rate code might look like the same selection to the employee when filling in their timesheet, it could still be an individualized rate code definition because you can have more than one rate code with the same name in the Rate Table so long as it is unique by being associated to a unique employee or resource code.  Default Project Rates can be defined in the Project Table and can be constrained in the Employee Record in the Filter section.

But we don’t want to see all those rates

In each employee record, filters can be used to define which rates should appear and for which conditions.  This can define showing only certain rates at certain times.  The technique can be used to easily define rates that change at a certain time of the year or to define different rates being available for different projects or charges or other data conditions.

Calculating Rate Values

So far we’ve only talked about how you can define many rates and how to select them but what about how rate values are calculated.  For labor rates, each rate code can have multiple values.  Up to 9 values per rate are available by default.  This allows different values for different purposes to be used.  Let’s say that we define Value 1 for Internal Actual Cost.  Then we expect to pay that person that amount per hour completed.  Then we can use Value 2 for External Billing Cost.  That would allow us to calculate an invoice amount for that same value very differently.  We can use this technique to also handle things like “unbillable time” where the Billing Cost is zero but the Internal Cost is still paid for.  We can use the same techniques for Banked Overtime where the internal cost is zero but the billing cost is still invoiced.

That’s just 2 of 9 values.  Perhaps you might want to define a 3rd value as an Average Project Cost to match the cost capabilities of your project system so that costs sent by TimeControl to the project system match the values that were used for planning.

Accruals and more…

We haven’t even talked about how the Accruals Module can take timesheet data it encounters and assesses values to each employee for that time.  In this way, overall overtime or banked time or earned vacation time can be calculated and stored.  There are also options in TimeControl Industrial to cost materials consumed, equipment used and production accomplished.  TimeControl Industrial’s rate selections also supports extended rates which look through combinations of timesheet line fields to select the right rate for you.

There are so many options on how to create your own Rate definitions that we’ve made a white paper on the subject called: Creating your Rate structure in TimeControl. The same information is available in the Appendices of the TimeControl Reference Guide. You’ll find other resources on designing your TimeControl environment to suit your needs in the Resources area of the TimeControl website.

 

TimeControl 8.1 now available!

TimeControl and TimeControl Industrial version 8.1 are a major update to the TimeControl 8 family of editions with significant new and enhanced features.    We’re delighted with the new version.  You can find out more details on the website at TimeControl.com/features/latest.

Mobile Materials

tci_mobile_materials.jpg_350x281For TimeControl Industrial Users we have now added the ability to enter non-labor data from the field using the free TimeControl Mobile App.  Along with the already existing Timesheet and Crew Timesheet functionality, this version now allows material consumption, equipment usage and production accomplished to be entered into TimeControl using a mobile device.

The free TimeControl Mobile App is available on Google Play for Android devices and the Apple Store for iOS devices.

Enhanced Calendar View

Calendar_View4_300x162We’ve rewritten the Calendar View to be more useful as an operational tool as TimeControl expands with more project planning and control functionality.  The Calendar View now allows for multiple tasks per row.  Also, items which span more than one day are now made into a longer bar which we’re loving in the office!

Integration with Project for the Web

ProjectForTheWeb_300x189In TimeControl 8.1 we have added integration with Microsoft’s newest addition to its Project Family “Project for the Web” with import only integration (Microsoft doesn’t support sending data back yet).

 

A new wave of reports

TimesheetImages_240x162We’ve included numerous new reports in this version which are all templates that you can adapt to your own needs.

 

 

And so much more.

Find out all about the new version at TimeControl.com/features/latest.

If you are a TimeControl or TimeControl Industrial on premise client with a current support and maintenance agreement, you can download the new version at no additional charge at: TimeControl.com/support/updates. TimeControl Online subscribers will be notified about their updates in the coming weeks and will then be updated automatically.

TimeControl Handles Resource Assignment Progress in So Many Ways

One of the key advantages of TimeControl is its ability to update planned tasks with the actual progress.  Gantt_and_Phone_300x200We often think of managing the progress of resource assignments in the simplest of terms: I assign you to do something, you tell me when you’re done and how much time you spent.  Yet, real life presents us with so many different resource progress options.  We won’t cover the many aspects of resource assignment management here and will, instead, look at just resource assignment progress.  We’ll cover just a few of the many ways TimeControl deals with resource progress by looking at specific business challenge scenarios here.

It’s more than just hours

TimeControl has always had the ability to go beyond the hours.  In some cases, costing of resource assignment progress is critical.  TimeControl is excellent at that.  In some cases you will want to identify the work remaining (Estimate to Complete) as a percentage or hours.  In some cases you will want to distinguish the assignment progress with the task progress.  TimeControl manages that as well.  In some cases you will want to go into more detail than the task assignment and TimeControl allows for lower entries with a summarization to the task and the assignments.  In some cases, there are progress costs that are both for labor and non-labor.  TimeControl’s expense entries or, in TimeControl Industrial, materials entries can handle that.

When transferring data to a project system, the options include hours, assignment progress, task progress, and costs.

A person does the assigned work of someone else

An assignment is made in a project management system and assigned to a particular person.  It turns out that someone else now completes the assignment even though they weren’t assigned to it themselves.  How can TimeControl manage that?

This is something TimeControl has had to deal with since its infancy in 1994.  When data is transmitted back to the project management system, the project manager has a choice:

  1. Do they wish to reject actuals in this situation or;
  2. Do they wish TimeControl to create an assignment in the project management system.

The results are quite different and the best choice is dependent on your project management process and what your project managers are happiest with.

In option 1, the actuals which can find no assignment with that individual will be rejected and those rejections will appear in a log.  Then the project manager will have to go to the project management system and alter the assignments to remove the first person and insert the second person.  Then the transfer can be restarted and those previously rejected records will go through.  For some project managers this is ideal.

In option 2, there will be a new assignment created in the project management system in the associated task.  The result will be a task that has one assignment for person 1 with no progress and another assignment for person 2 with completed progress.  Project managers then have to create an exception report to highlight tasks with progress for the last week but with assignments that have no progress.  Then they will have to decide how to alter the assignments to best reflect what actually happened.

One of the things about TimeControl that is handy is that this is not a global setting.  One project manager may be more comfortable with option 1, the other with option 2.

A person does work at different rates at different times of the day

This is a common request and we are often asked why project management tools don’t offer more options with rates in their systems.  The short answer is that when you are planning, you typically don’t think of all the rate variations that are likely to appear in real life.  It’s not something that occurs because you plan for it.

Let’s say a person works on multiple projects.  On project #1, they are billed at $75 per hour. On project #2 they are billed at $60 per hour.  TimeControl handles that easily by having multiple rates.  But, you say, what if they are billed at those rates but we pay them the same internally.  Again, no problem.  Each rate code can have multiple values associated for things like Internal Cost, Billing Value, Project Average Cost, etc.

Ok, let’s say there is one project and someone is working at different rates for different situations.  For example, we cost them at one rate when the weather is good and at a hazard rate when the weather is bad.  TimeControl handles this easily.  It allows the same task to appear multiple times in the same timesheet so that you can enter values like the Rate Code or other User Defined fields for that same task.  When this information is sent back to the project system, the project manager has the option to send the costs as well or just to send the hours.   The choice depends on what the internal costing process is for the project manager and the company but TimeControl will maintain the auditable values at a detailed level no matter which option is selected.

A person works as part of a generic or role definition of resource

When looking at resource assignments in a project system, project management software vendors would love it if you only made assignments at the individual level.  This is largely due to the licensing advantage to those vendors as each individual will now have to look at the system to see their tasks and then those people will need to purchase an individual license.  That’s all understood but this method then disables one of the project management systems’ most powerful tools: resource leveling.  Resource Leveling at an individual level makes no sense.  The algorithms and concepts are most effective when we use generic or role-based resource assignments.  If we do that and leave individual assignments as a separate exercise for team leads, you can end up with a project/timesheet disconnect.

Not in TimeControl.

In TimeControl for each employee, there is an option to say what resource code that employee is associated to.  That can be an individual resource code.  That’s certainly the easiest.  But, it can just as easily be a generic or a role resource.  Then when progress from that person is recorded, it is sent to the project system not as an individual but rather as the role or generic resource, aggregated with all other employees who are defined to that role or generic resource.

A person works part of the day as one resource and another part of the day as a different resource

In this situation, we have people who have different roles in different parts of the day.  Perhaps someone is a designer in the morning and billed at one rate but will be working as a documentation specialist in the afternoon and billed at a very different rate.

TimeControl handles this with the optional “Line Item Resource”.  When activated, a user can select in their timesheet what resource code they would like associated to each line.  That leaves them as many choices as are appropriate to their situation as you wish.  When data is sent back to the project system, the resource progress will be sent back line-by-line, assignment-by-assignment with the resource codes that were chosen.

And…

Of course, we’re not done.  Sometimes it seems that there are as many resource management scenarios as there are clients and having a tool as flexible as TimeControl means we’re almost always able to adjust to accommodate a particular resource process.  Plus, for many, many, clients sometimes simplest is best and none of these more involved scenarios apply.  In this case, you can reduce or even remove resource assignment and progress management altogether.

Talk about Resource Progress are sprinkled all over the TimeControl.com site or, if you have a specific challenge you’d like to talk to us about, contact us on the Contact form.

 

 

 

De-centralized Project Management and Centralized Timesheets with TimeControl

wp_decentralized_centralized_300x383The most common notion of Enterprise Project Management (EPM) systems means that all users access a single centralized system for all related functions.  This concept became popular in the late 1990s with the rise of ERP systems.  Project Managers have been asked to store their data and adopt the centralized project management system.

Yet there are still millions and millions of individually run project management tools running on desktops or even as services in the cloud but not part of a centralized project management process.

That might be fine for each project manager but when it comes to a process that needs to be centralized like timesheets, we run into a bigger problem.  The result is that one aspect of the enterprise such as Finance insists on a timesheet for payroll for all personnel.  Another department insists on a timesheet for all users for HR to track time off and another department needs a billing timesheet for all users who contribute to billing time.  Each project manager might need to deploy their own timesheet system for their teams.

It can become chaos in a hurry.

We’ve just released a white paper that deals with this exact business challenge.  It’s called “De-centralized Project Management and Centralized Timesheets with TimeControl”.  It’s free to access and it’s available right now as part of our ongoing efforts to show how to realize the benefits of TimeControl. If you are interested in having project managers continue to use multiple systems but need to have one timesheet to bring all the actuals together for different purposes, you’ll find this paper of interest.  The white paper can be downloaded from: https://www.timecontrol.com/pdf/whitepapers/centralized_decentralized.pdf.

For more free resources on enterprise project management and enterprise timesheet systems, go to: TimeControl.com/resources.

TimeControl timesheets and Primavera project management make a winning combination

TimeControl and Primavera have a long history together.  First paired in 1997, HMS Software has ensured it’s TimeControl has had a continuous link to every version of Primavera since.  For those users who need a Primavera Timesheet that supports both financial and project processes simultaneously there is no better selection.

TimeControl includes links using direct database-to-database connections for Primavera Professional and Primavera EPPM and a Web connection link for Primavera EPPM so all the basis are covered whether Primavera and TimeControl are in the cloud or on premise.  The bi-directional link moves projects, tasks, resources assignments and progress to TimeControl then sends back hours, costs and progress.

Primavera clients who need a single timesheet to update not only the task progress in Primavera but also Payroll, Billing, Finance, Job Costing or HR use TimeControl to provide multi-purpose timesheet functionality that will allow a single point of timesheet entry and multiple corporate uses at the same time.

Some of the benefits of integrating TimeControl as your Primavera Timesheet include:

  • Automated Business Validation Rules
  • Expense tracking
  • Extensive Rate Management with unlimited rates per person and multiple values per rate
  • Management of Vacation, Sick Leave, Personal time banks
  • Crew Timesheets (with TimeControl Industrial)
  • Material consumption, Equipment usage and Production accomplished (with TimeControl Industrial)
  • Management of Banked Overtime
  • Included integration with Oracle-Primavera Pro, EPPM and many other project systems
  • The free TimeControl Mobile App for tablets and smartphones
  • Missing timesheet management
  • Multi-lingual interface
  • The Matrix Approval Process for Labor Actuals™

TimeControl is available as a subscription in the cloud or for on-premise deployment or.

HMS has a free information portal with white papers, video lessons, slide presentations and factsheets on our website at: http://primavera.timecontrol.com.

 

The new TimeControl Mobile App includes Crew Timesheets!

In the lastest updated of TimeControl, enhancements to the free TimeControl Mobile App include new functionality for Crews.  When the Mobile App links to a TimeControl Industrial  license, additional functionality becomes available.  Providing that the user has security profile access to these functions, they can now create, and edit a Crew Timesheet.  In addition, the user can Approve or Reject Crew Timesheets as part of the approval process.

The Mobile App also allows the user to Add or Remove Crew Team Members.

Field Data Collection often occurs in areas where Internet services are spotty.  If a connection is lost, the TimeControl Mobile App continues working offline until the Internet is restored and then synchronizes with the main TimeControl system.

The TimeControl Mobile App is available at no charge on the Google Play Store for Android phones and tablets and on the Apple App Store for iOS devices.

You can find out more about Crew Timesheets at: Industrial.Time
Control.com/features/crew-timesheet.

TimeControl Industrial 8 now available

With the successful launch of TimeControl 8 only a few days ago, we’ve now released TimeControl Industrial version 8.  The TimeControl 8 version already included numerous features that will be of interest to all TimeControl Industrial clients.

crew_tsentry_3There are also some features very specific to TimeControl Industrial in this edition.  Some of these include:

Crew Timesheets in TimeControl Mobile

TimeControl 8 includes the free TimeControl Mobile App and TimeControl Industrial users can, for the first, time create and edit Crew Timesheets and edit Crew members while mobile.  With nearly half of the total global workforce expected to be comprised of mobile employees by 2022, these new features in TimeControl Industrial Mobile will be welcome.

Manage Crews in TimeControl Mobile

Not only can supervisors and team leaders create crew timesheets while on the go, they can also use the TimeControl Mobile App to update team members.  A team lead who is out in the field with their crew can start their shift by updating their crew and then updating Crew Timesheet information as the day progresses no matter where they are.

Support for TimeControl Mobile when disconnected from the Internet

TimeControl Mobile has been enhanced so that if connection to the Internet is interrupted; something that can occur more frequently in remote construction sites, the App will continue functioning and will automatically syncronize with the central application as soon as a connection is re-established.

Mobile Views

The TimeControl Mobile App includes dynamic data analysis for management of all timesheet data under their control.  Instant graphics in numerous formats will enable rapid decision making based on where time is being spent.

The upgrade is available to existing on-premise clients with a current support and maintenance agreement at no additional charge from the TimeControl upgrades site at: Industrial.TimeControl.com/support/updates. TimeControl Industrial 8 will be upgraded automatically for TimeControl Online subscription clients in mid-July.

For further information, please visit Industrial.TimeControl.com or email info@hms.ca.

TimeControl case study with WHP Engineering 

We’re delighted to tell you that we have just finished collaborating with WHP Engineering on a greate case study describing how this UK-based engineering company has implemented TimeControl to improve operational efficiency in the organization.

WHP Engineering specializes in precision engineered solutions for the biotechnology, pharmaceutical and other clean process manufacturing industries.  It has grown more than 135% since 2017.

WHP has deployed TimeControl in part due to its integration with both Oracle Primavera and Sage and are delighted with the results.

“The fact that I can see what projects people are spending their hours on and what they’re delivering for those hours is crucial,” explained John Wheeler, WHP’s Engineering Manager. “If we hadn’t made the change to TimeControl, we certainly wouldn’t have the level of key business metrics that we’re getting now.”

You can read the case study in its entirety at: TimeControl.com/why-timecontrol/case-studies/whp or to see more case studies, go to: TimeControl.com/why-timecontrol/case-studies.