Cost Calcs

[koolkat]

Is there a column that you can insert that shows how many days into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10 days. Half way
through his task the cost will be $2500; is there a column that shows this?
I want to see daily the accumulitive cost.

 

[Jim Aksel]

You want to use baselines and earned value to get our "Planned Value". In
earned values terms this is called BCWS (Budgeted Cost of Work Scheduled).

Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project Information)
Now update your Remaining Work, Actual Work and Remaining Duration. This
will calculate your %Complete and %Work Complete.

To determine how many days you are in to a task, use a spare duration or
text column such as (Duration1) or (Text1). Right click on the field column
and choose Customize Fields. In the dialog that opens, you want to specify
"Formula" and then enter:

ProjDateDiff([Start],[Status Date])

This will give you the difference betweent the start date of the task and
the status date. However, there is some additional work to do (and I will
leave that as an ecercise for the poster....)

You will need to surround this formula in an If statement becuase you will
also want to exclude posting values when the start date is passed the status
date (future work) and then the task is already finished (Finish<Status Date).

If you look at my blog and browse the papers on Percent Complete, I give you
some formulas that you may be able to adapt to your purpose. Link is below.


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[koolkat]

Jim,

I'm checking out your blog, thank you. But is there a way to do formulas
using Current (Today's) Date?

You want to use baselines and earned value to get our "Planned Value". In
earned values terms this is called BCWS (Budgeted Cost of Work Scheduled).

Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project Information)
Now update your Remaining Work, Actual Work and Remaining Duration. This
will calculate your %Complete and %Work Complete.

To determine how many days you are in to a task, use a spare duration or
text column such as (Duration1) or (Text1). Right click on the field column
and choose Customize Fields. In the dialog that opens, you want to specify
"Formula" and then enter:

ProjDateDiff([Start],[Status Date])

This will give you the difference betweent the start date of the task and
the status date. However, there is some additional work to do (and I will
leave that as an ecercise for the poster....)

You will need to surround this formula in an If statement becuase you will
also want to exclude posting values when the start date is passed the status
date (future work) and then the task is already finished (Finish<Status Date).

If you look at my blog and browse the papers on Percent Complete, I give you
some formulas that you may be able to adapt to your purpose. Link is below.


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Is there a column that you can insert that shows how many days into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10 days. Half way
through his task the cost will be $2500; is there a column that shows this?
I want to see daily the accumulitive cost.

 

[koolkat]

Nevermind I got it...Current Date...lol. Thanks for your help!

You want to use baselines and earned value to get our "Planned Value". In
earned values terms this is called BCWS (Budgeted Cost of Work Scheduled).

Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project Information)
Now update your Remaining Work, Actual Work and Remaining Duration. This
will calculate your %Complete and %Work Complete.

To determine how many days you are in to a task, use a spare duration or
text column such as (Duration1) or (Text1). Right click on the field column
and choose Customize Fields. In the dialog that opens, you want to specify
"Formula" and then enter:

ProjDateDiff([Start],[Status Date])

This will give you the difference betweent the start date of the task and
the status date. However, there is some additional work to do (and I will
leave that as an ecercise for the poster....)

You will need to surround this formula in an If statement becuase you will
also want to exclude posting values when the start date is passed the status
date (future work) and then the task is already finished (Finish<Status Date).

If you look at my blog and browse the papers on Percent Complete, I give you
some formulas that you may be able to adapt to your purpose. Link is below.


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Is there a column that you can insert that shows how many days into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10 days. Half way
through his task the cost will be $2500; is there a column that shows this?
I want to see daily the accumulitive cost.

 

[Jim Aksel]

Or use Now() .... that seems to get the software's attention too.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Nevermind I got it...Current Date...lol. Thanks for your help!

You want to use baselines and earned value to get our "Planned Value". In
earned values terms this is called BCWS (Budgeted Cost of Work Scheduled).

Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project Information)
Now update your Remaining Work, Actual Work and Remaining Duration. This
will calculate your %Complete and %Work Complete.

To determine how many days you are in to a task, use a spare duration or
text column such as (Duration1) or (Text1). Right click on the field column
and choose Customize Fields. In the dialog that opens, you want to specify
"Formula" and then enter:

ProjDateDiff([Start],[Status Date])

This will give you the difference betweent the start date of the task and
the status date. However, there is some additional work to do (and I will
leave that as an ecercise for the poster....)

You will need to surround this formula in an If statement becuase you will
also want to exclude posting values when the start date is passed the status
date (future work) and then the task is already finished (Finish<Status Date).

If you look at my blog and browse the papers on Percent Complete, I give you
some formulas that you may be able to adapt to your purpose. Link is below.


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Is there a column that you can insert that shows how many days into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10 days. Half way
through his task the cost will be $2500; is there a column that shows this?
I want to see daily the accumulitive cost.

 

[Rob Schneider]

There is a function provided by Project called now() which does as it
says on the tin.

--rms

www.rmschneider.com

Jim,

I'm checking out your blog, thank you. But is there a way to do formulas
using Current (Today's) Date?

You want to use baselines and earned value to get our "Planned Value". In
earned values terms this is called BCWS (Budgeted Cost of Work Scheduled).

Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project Information)
Now update your Remaining Work, Actual Work and Remaining Duration. This
will calculate your %Complete and %Work Complete.

To determine how many days you are in to a task, use a spare duration or
text column such as (Duration1) or (Text1). Right click on the field column
and choose Customize Fields. In the dialog that opens, you want to specify
"Formula" and then enter:

ProjDateDiff([Start],[Status Date])

This will give you the difference betweent the start date of the task and
the status date. However, there is some additional work to do (and I will
leave that as an ecercise for the poster....)

You will need to surround this formula in an If statement becuase you will
also want to exclude posting values when the start date is passed the status
date (future work) and then the task is already finished (Finish<Status Date).

If you look at my blog and browse the papers on Percent Complete, I give you
some formulas that you may be able to adapt to your purpose. Link is below.


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Is there a column that you can insert that shows how many days into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10 days. Half way
through his task the cost will be $2500; is there a column that shows this?
I want to see daily the accumulitive cost.

 

[koolkat]

hey Jim,

I have my formulas working but is there is a way when you indent that the
parent task sums up the values as it does for other built-in functions?
For example I have a formula built for Cost6 but the parent task doesn't add
up all of Cost6.

You want to use baselines and earned value to get our "Planned Value". In
earned values terms this is called BCWS (Budgeted Cost of Work Scheduled).

Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project Information)
Now update your Remaining Work, Actual Work and Remaining Duration. This
will calculate your %Complete and %Work Complete.

To determine how many days you are in to a task, use a spare duration or
text column such as (Duration1) or (Text1). Right click on the field column
and choose Customize Fields. In the dialog that opens, you want to specify
"Formula" and then enter:

ProjDateDiff([Start],[Status Date])

This will give you the difference betweent the start date of the task and
the status date. However, there is some additional work to do (and I will
leave that as an ecercise for the poster....)

You will need to surround this formula in an If statement becuase you will
also want to exclude posting values when the start date is passed the status
date (future work) and then the task is already finished (Finish<Status Date).

If you look at my blog and browse the papers on Percent Complete, I give you
some formulas that you may be able to adapt to your purpose. Link is below.


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Is there a column that you can insert that shows how many days into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10 days. Half way
through his task the cost will be $2500; is there a column that shows this?
I want to see daily the accumulitive cost.

 

[JulieS]

Hello koolkat,

Right click on the Cost6 field and select "Customize fields". In
the Customize fields dialog box, under "Calculation for group or
summary rows" select Rollup and Sum.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

hey Jim,

I have my formulas working but is there is a way when you indent
that the
parent task sums up the values as it does for other built-in
functions?
For example I have a formula built for Cost6 but the parent task
doesn't add
up all of Cost6.

You want to use baselines and earned value to get our "Planned
Value". In
earned values terms this is called BCWS (Budgeted Cost of Work
Scheduled).

Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project Information)
Now update your Remaining Work, Actual Work and Remaining
Duration. This
will calculate your %Complete and %Work Complete.

To determine how many days you are in to a task, use a spare
duration or
text column such as (Duration1) or (Text1). Right click on the
field column
and choose Customize Fields. In the dialog that opens, you want
to specify
"Formula" and then enter:

ProjDateDiff([Start],[Status Date])

This will give you the difference betweent the start date of the
task and
the status date. However, there is some additional work to do
(and I will
leave that as an ecercise for the poster....)

You will need to surround this formula in an If statement becuase
you will
also want to exclude posting values when the start date is passed
the status
date (future work) and then the task is already finished
(Finish<Status Date).

If you look at my blog and browse the papers on Percent Complete,
I give you
some formulas that you may be able to adapt to your purpose.
Link is below.


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Is there a column that you can insert that shows how many days
into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10
days. Half way
through his task the cost will be $2500; is there a column that
shows this?
I want to see daily the accumulitive cost.

 

[Jim Aksel]

With Column Cost6 selected, right click. Select Customize Fields...
You can select how to handle calucations for Group and Summary Task Rows in
the dialog box by choosing "Roll up": Your choices are SUM, MAX, MIN,
Average, Average of first sublevel.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

hey Jim,

I have my formulas working but is there is a way when you indent that the
parent task sums up the values as it does for other built-in functions?
For example I have a formula built for Cost6 but the parent task doesn't add
up all of Cost6.

You want to use baselines and earned value to get our "Planned Value". In
earned values terms this is called BCWS (Budgeted Cost of Work Scheduled).

Assign Costed Resources to detail tasks
set a baseline (Tools/Tracking/Set Baseline)
set the status date (Project/Project Information)
Now update your Remaining Work, Actual Work and Remaining Duration. This
will calculate your %Complete and %Work Complete.

To determine how many days you are in to a task, use a spare duration or
text column such as (Duration1) or (Text1). Right click on the field column
and choose Customize Fields. In the dialog that opens, you want to specify
"Formula" and then enter:

ProjDateDiff([Start],[Status Date])

This will give you the difference betweent the start date of the task and
the status date. However, there is some additional work to do (and I will
leave that as an ecercise for the poster....)

You will need to surround this formula in an If statement becuase you will
also want to exclude posting values when the start date is passed the status
date (future work) and then the task is already finished (Finish<Status Date).

If you look at my blog and browse the papers on Percent Complete, I give you
some formulas that you may be able to adapt to your purpose. Link is below.


--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

Is there a column that you can insert that shows how many days into a task
you are? Also one for cost?
For example if I have a person at $500/day on a task for 10 days. Half way
through his task the cost will be $2500; is there a column that shows this?
I want to see daily the accumulitive cost.