vba - Reading and writing MS Project TimeScaleData for Resources, and Assignments -

-

i pulling projected cost excel reports , external db. part of monthly projections update project overheads. need accurately pull monthly cost write monthly cost overheads tasks.

i having trouble understanding why read , write assignment instead of directly cost resource?

read month cost resource (simplified):

dim tsvs timescalevalues dim res resource  until budgetdate > activeproject.projectfinish     each res in activeproject.resources         set tsvs = res.timescaledata(startdate:=budgetdate, enddate:=budgetdate, type:=pjresourcetimescaledcost, timescaleunit:=pjtimescalemonths, count:=1)         mymonthcost = val(tsvs(1).value)     next res     budgetdate = dateadd("m", budgetdate, 1) loop

there 1 timescalevalue in tsvs (the single month) believe i'm fine referencing tsvs(1).value instead of having increment through collection.

read month cost assignments:

do until budgetdate > laborfinishdate     each res in activeproject.resources         set asgts = res.assignments         each asgt in asgts             set tsvs = asgt.timescaledata(startdate:=budgetdate, enddate:=budgetdate, type:=pjassignmenttimescaledcost, timescaleunit:=pjtimescalemonths, count:=1)             mymonthcost = mymonthcost + val(tsvs(1).value)         next asgt     next res     budgetdate = dateadd("m", budgetdate, 1) loop

and write month overhead cost overhead task:

myoverhead = mymonthcost * myrate  set tsk = activeproject.tasks("overhead") set tsvs = tsk.assignments(1).timescaledata(startdate:=budgetdate, enddate:=budgetdate, type:=pjassignmenttimescaledcost, timescaleunit:=pjtimescalemonths)  tsvs(1).value = myoverhead

this method works me frustrated cannot work writing directly resource cost. don't understand why have read or write assignment (either task or resource) instead of directly resource itself. explain why 1 should read , write costs using assignments or if there better way using resources directly?

thanks time.

the answer assignments table contains timescaledata relates resource task (and vice versa), must write assignment related resource (or task). resource timescaledata related assignment timescaledata of resource.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more