Skip to content

TimePhased Assignment Table

arvati@hotmail.com edited this page Dec 31, 2016 · 4 revisions

Holds information about Assignment TimeScaleValue Object as described in TimeScaleValue Object at Project 2013 VBA reference

Spreadsheet Project Readonly Technical Documentation
Task UUID (pjTaskText30) Task.Text30 No Task.Text30 Property
Resource UUID (pjResourceText30) ResourceText30 No Resource.Text30 Property
pjTaskName Task.Name Yes Task.Name Property
pjResourceName Resource.Name Yes Resource.Name Property
StartDate TimeScaleValue.StartDate No TimeScaleValue.StartDate Property
EndDate TimeScaleValue.EndDate No TimeScaleValue.EndDate Property
Index TimeScaleValue.Index Yes TimeScaleValue.Index Property
Type TimeScaleData.Type Yes PjAssignmentTimescaledData Enumeration Assignment.TimeScaleData Method
TimeScaleUnit TimeScaleData.TimeScaleUnit Yes PjTimescaleUnit Enumeration Assignment.TimeScaleData Method
Value TimeScaleValue.Value No TimeScaleValue.Value Property

Information of TimeScaleValue is acquired using Assignment.TimeScaleData Method as described in Assignment.TimeScaleData Method at Project 2013 VBA reference.

Parameters used within Assignment.TimeScaleData Method are:

Name Description
StartDate Using value of ProjectSummaryTask.start
EndDate Using value of ProjectSummaryTask.Finish
Type As listed bellow
TimeScaleUnit PjTimescaleUnit.pjTimescaleMonths = 2 (Months)
Count Default value of 1

Currently only the following PjAssignmentTimescaledData types are used:

Enumeration Name Number
pjAssignmentTimescaledWork 8
pjAssignmentTimescaledActualWork 10
pjAssignmentTimescaledBaselineWork 16
pjAssignmentTimescaledBudgetWork 669
pjAssignmentTimescaledBaselineBudgetWork 673
pjAssignmentTimescaledCost 26
pjAssignmentTimescaledActualCost 28
pjAssignmentTimescaledBaselineCost 32
pjAssignmentTimescaledBudgetCost 670
pjAssignmentTimescaledBaselineBudgetCost 674

Clone this wiki locally