-
Notifications
You must be signed in to change notification settings - Fork 0
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 |
- Home
- Instalation
- References
-
Documentation
-
Tables Sincronized
- [Project Table](Project Table)
- [Tasks Table](Tasks Table)
- [Assignments Table](Assignments Table)
- [Resources Table](Resources Table)
- [Task Dependencies Table](Task Dependencies Table)
- [TimePhased Assignment Table](TimePhased Assignment Table)
- [TimePhased Task Table](TimePhased Task Table)
- [TimePhased Resource Table](TimePhased Resource Table)
-
Tables Sincronized