Cash flow income -customisation of fields

[johnson]

Hi everyone,
I am executing work as a contractor.I have customised fields to determine
the value of work done which becomes due from the client as under in task
fields:
Work item as per BOQ(bill of quantities)- Text 1
Item rate as per work item in BOQ-number 1
Units of work item-text 2
BOQ quantity against the task-number2
Planned Value of work- number 6=BOQ qty x Item rate
Actual value of work done=% work complete(not customised ) x Planned value
of work
The planned value of work is the forecasted value of work against each task
which is the amount likely to be obtained from the client. I want to forecast
this amount monthwise over the duration of the project. Since the project is
being updated every week the the planned vlaue of work is avaialble in Gantt
chart against each task.I want to make it avialable montwise. I tried to make
it avaialble in task usage view by a VBA as given below:
Sub CopyTaskFieldVOWDToAssignment()
Dim t As Task
Dim ts As Tasks
Dim A As Assignment
Set ts = ActiveProject.Tasks
For Each t In ts
If Not t Is Nothing Then
For Each A In t.Assignments
'change the following line to use
'for a different custom field
A.Number6 = t.Number6
Next A
End If
Next t
End Sub
This is not available in task usage view against the task . I would like to
make it avalaible in a time phased view so that I can forecast the sales
income over different time periods - monthwise or weekwise.
I am presently stuck . Can anyone help? I am using professional 2003 with
server.
Johnson

 

[Jan De Messemaeker]

Hi,

I'm sorry, there is no way to show a custom field as timescaled.
Maybe you could use some field that is not bother ing the rest of your
calculations (I think of Actual Cost for instance).
But then again, you cannot create a timescaled value through a formula.
Hope this helps,