Need Timephased Data in 6-Hour Intervals for Task and Summary Task (Baseline, Forecast, Actual)

Aspose.Tasks Product Family
1

Dear Aspose Support Team,

We are planning to purchase the Aspose.Tasks library for our .NET-based project management application. However, before proceeding, we would like to ensure that it meets a critical requirement related to timephased data retrieval.

Our Requirements

  1. Retrieve timephased data for each task in 6-hour intervals for the following types:
  • Baseline
  • Forecast
  • Actual
  1. Retrieve timephased data for summary (parent) tasks in 6-hour intervals for:
  • Baseline
  • Forecast
  • Actual

Current Implementation Using Microsoft Interop

We are currently using the Microsoft Interop library and retrieving the required timephased data using the following method:

task.TimeScaleData(
    StartDate: dteStart, 
    EndDate: dteEnd, 
    Type: PjTaskTimescaledData.pjTaskTimescaledWork, 
    TimeScaleUnit: PjTimescaleUnit.pjTimescaleHours, 
    Factor: 6
);

This provides timephased data in 6-hour blocks such as:

  • 06:00–12:00
  • 12:00–18:00
  • 18:00–00:00
  • 00:00–06:00

This output is available at both the individual task level and the summary task level.

Sample File and Expected Output

If needed, we can provide:

  • A sample Gantt (.mpp) file
  • A comparison of expected 6-hour interval timephased values for a summary task (baseline, forecast, and actual)

Our Goal

We would like to know:

  • Can Aspose.Tasks provide the same level of granularity (6-hour intervals) for baseline, forecast, and actual work as Microsoft Interop?
  • Can we retrieve this data at both task and summary task levels?
  • If not available out-of-the-box, is there a recommended workaround or upcoming support for this feature?

Looking forward to your guidance and technical assistance before we proceed with licensing.

Best regards,
Imran Khan Pathan
Sr, Tech Lead

2

Yes, can you attach the files please so we can check that our API can suit the requirements.

3

Sample.zip (548.8 KB)

Hello,

I have attached the files. The zip contains the sample mpp file and calculated baseline, forecast and actual data in 6hrs interval for summary level task and individuals tasks.

Let me know if you need more details in our requirements.

4

@ikhan.pathan ,
we`ll investigate the requirements and return with the answer.

5

@ikhan.pathan ,
the attached sample file doesn’t contain actual work for tasks with UniqueId = 1000, 1001, 1002:

Screenshot_1.png1164×384 25.4 KB

Can you clarify how “Actual Hrs” column in the attached spreadsheet is calculated?

Aspose.Tasks for .NET have ResourceAssignment.GetTimephasedWork method, it calculates work by timephased data in the specified interval. It can be used to sum the corresponding work and calculate Task’s works in the needed intervals:

string dir = "";
var project = new Project(dir + "Sample1.mpp");

var task = project.RootTask.Children.GetByUid(1000);
var start = new DateTime(2025, 4, 2, 18, 0, 0);
var finish = new DateTime(2025, 4, 3, 0, 0, 0);

var actualWorkSum = TimeSpan.Zero;
var remainingWorkSum = TimeSpan.Zero;
var baselineWorkSum = TimeSpan.Zero;
foreach (var assignment in task.Assignments)
{
    var actualWork = assignment.GetTimephasedWork(start, finish, TimephasedDataType.AssignmentActualWork);
    actualWorkSum += actualWork;

    var remainingWork = assignment.GetTimephasedWork(start, finish, TimephasedDataType.AssignmentRemainingWork);
    remainingWorkSum += remainingWork;
                
    var baselineWork = task.Assignments[0].GetTimephasedWork(start, finish, TimephasedDataType.AssignmentBaselineWork);
    baselineWorkSum += baselineWork;
}

Console.WriteLine("Task's actual work: " + actualWorkSum);
Console.WriteLine("Task's remaining work: " + remainingWorkSum);
Console.WriteLine("Task's baseline work: " + baselineWorkSum);

We found that GetTimephasedWork is not working properly for baseline work.
It will be fixed in the next release.

6

@ikhan.pathan
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): TASKSNET-11505

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

7

When you are planning to fix and release this issue?

8

@ikhan.pathan ,
the issue is resolved and will be released in version 25.7.

9

The issues you have found earlier (filed as TASKSNET-11505) have been fixed in this update.

Download link