Importing actual work RRS feed

  • Question

  • Are to import Acutal work per resource using timephase data, so we know who has been working on a task, how long, and when. The setup of each Project looks as below. (Sorry for Spelling Materialproduction incorrect). What happens if someones starts working with a task Before the task starts? Is this tricky to solve? (Probably need to explain more what we are after?)

    Saturday, August 30, 2014 8:07 AM


All replies

  • Anders,

    Import to or from where? For example, are you trying to import data from another application (e.g. Excel) into Project?

    And yes, it is very tricky to have a resource start working on a task for before the task starts, but let's look at an example. Let's assume you have some type of timekeeping data in another application (e.g. Excel). In your Project file you have a task that is scheduled to start on a Tuesday. However, the resource who is assigned to that task is available and actually started working on the task on Monday so that's how he entered his time in Excel. When you import that time to the Project file, the actual start date will be Monday and the task start date will be automatically updated to agree with the actual start date.


    Saturday, August 30, 2014 3:28 PM
  • John, are getting the data directly from a database accessing the exact number of minutes each resource has been working, on which day and on which tasks. And yes when entering values on dates that are Before the task should start the task start date follows and Changes. But if you look at the image in the first post what will happen if assembly starts Before painting is finished, according to the link the assembly must not start Before. Will setting the actual start override the start and move the start anyway?

    Kind regards //Anders

    Saturday, August 30, 2014 9:23 PM
  • It seems easiest to just import data into the resource actual work field using the timescaledata object. Trust that Fixed duration is not very suitable to use for the tasks then, works much better with fixed work or fixed unit. Is there Another way which is better to use to import actual work hours into Project or is this the best way? Just curious so we do it correct from the beginning.

    Kind regards //Anders

    Saturday, August 30, 2014 10:15 PM
  • The VBA timescaledata method works exactly the same way as when you manually enter actual hours for a day in the task or resource Usage view.

    Rod Gill
    Author of the one and only Project VBA Book

    • Marked as answer by AT_lamnea Sunday, August 31, 2014 6:40 AM
    Saturday, August 30, 2014 10:34 PM
  • Rod, ok did also find a useful tip about adding work for saturdays and sundays as an exctract from your book. Hope that we will be able to make a good import function, it would be very helpful for us. Today we just throw in the total number of hours in the acutal work field for the task and then Project split the time between the Resources, has been working fine so far but now we want to be able to follow the actual start working hours and finish more in detail for each task.

    This seems to be a simple and good way. Is this the way you would recommend to import data?

    Sorry for referring to another post but as an VBA expert you did not happen to see the post:

    "Problem with status report-chart colours Changes"

    Do you may know a way of programatically change the colors of a piechart in a report using VBA?

    Thanks and kind regards //Anders

    Sunday, August 31, 2014 6:49 AM