Changing calculation of total cost

Project seems to only allow calculating a total cost based on what is entered
in a fixed-cost per field task and other resource usage cost fields.
I need to add two custom fixed-cost fields per task (billable capital and
non-billable capital). How can I change how total cost is calculated?

Jan
Sat Oct 08 02:59:15 CDT 2005

Hi,

Only through VBA I'm afraid. None of the cost foields can be accessed by a
formula.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Jumpinjackflash" <Jumpinjackflash@discussions.microsoft.com> schreef in
bericht news:ED582724-A4D8-436C-9B13-F32714449DEC@microsoft.com...
> Project seems to only allow calculating a total cost based on what is
entered
> in a fixed-cost per field task and other resource usage cost fields.
> I need to add two custom fixed-cost fields per task (billable capital and
> non-billable capital). How can I change how total cost is calculated?

hberkis
Thu Oct 20 10:33:21 CDT 2005

Do you have any references that would discuss what would be involved in using
VBA to change the Total Cost calculation?

"Jan De Messemaeker" wrote:

> Hi,
>
> Only through VBA I'm afraid. None of the cost foields can be accessed by a
> formula.
> HTH
>
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> http://users.online.be/prom-ade/
> +32-495-300 620
> "Jumpinjackflash" <Jumpinjackflash@discussions.microsoft.com> schreef in
> bericht news:ED582724-A4D8-436C-9B13-F32714449DEC@microsoft.com...
> > Project seems to only allow calculating a total cost based on what is
> entered
> > in a fixed-cost per field task and other resource usage cost fields.
> > I need to add two custom fixed-cost fields per task (billable capital and
> > non-billable capital). How can I change how total cost is calculated?
>
>
>

John
Thu Oct 20 12:45:32 CDT 2005

In article <B9928908-B2CB-4B2C-B0B3-0BC90DC838B0@microsoft.com>,
"hberkis" <hberkis@discussions.microsoft.com> wrote:

> Do you have any references that would discuss what would be involved in using
> VBA to change the Total Cost calculation?
>
>

hberkis,
I'm not sure what kind of references you are looking for but here are a
couple. First, if you do not have any VBA experience but are willing to
learn, go to our MVP website at: http://www.mvps.org/project/links.htm
and click on the link at the bottom of the page for, "Project 98 Visual
Basic Environment Training Materials". Even though it says it is for
Project 98, it is equally applicable to all current versions of Project.

For some good examples of VBA, try fellow MVP, Jack Dahlgren's website
at: http://masamiki.com/project/macros.htm

Beyond those, you can always post to the developer newsgroup - we
generally like to address VBA and other developer questions there.

John
Project MVP