Custom baseline fields

[Mike Einhorn]

Hello,

I have created a custom table which includes extra cost columns for each
task. I use these columns to direct enter material and travel costs. I then
have another cost column which totals the labor ([COST] column and these
other cost columns.

I would like to save this subtotaled column as a baseline since it
represents my total cost for that task.

Is there any way to add additional fields to the original 9 baseline fields
available? I can't seem to find a way to do this and it would be very
helpful.

Thanks

 

[Rod Gill]

No there isn't. You will need to manually copy the values into another Cost
column. You can do this in one go by click the column title to select it
then copy.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Hello,

I have created a custom table which includes extra cost columns for each
task. I use these columns to direct enter material and travel costs. I
then
have another cost column which totals the labor ([COST] column and these
other cost columns.

I would like to save this subtotaled column as a baseline since it
represents my total cost for that task.

Is there any way to add additional fields to the original 9 baseline
fields
available? I can't seem to find a way to do this and it would be very
helpful.

Thanks

__________ Information from ESET Smart Security, version of virus
signature database 4888 (20100222) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4888 (20100222) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Mike Glen]

Hi Mike,

Welcome to this Microsoft Project newsgroup

If you want this as a baseline cost, then I presume you've estimated all these costs in advance when you created the schedule and saved the baseline. If this is the case, then just put the total into Fixed Cost column. This will then appear in the Baseline Fixed Cost column. If it is not the case, then these accrued expenses cannot possibly be part of the original baseline and thus should be totalled and entered at the end of each task.

FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials



Hello,

I have created a custom table which includes extra cost columns for each
task. I use these columns to direct enter material and travel costs. I then
have another cost column which totals the labor ([COST] column and these
other cost columns.

I would like to save this subtotaled column as a baseline since it
represents my total cost for that task.

Is there any way to add additional fields to the original 9 baseline fields
available? I can't seem to find a way to do this and it would be very
helpful.

Thanks

 

[Roland67]

Mike,

Not sure why you have extra fields but suspect it's to keep the values
separated for reporting purposes.

I would suggest you create a Material based resource such as "Travel",
"Materials", "ODC", etc to capture these costs (hourly rate of $1). Then you
can include these resources on the task as a true resource w/values. Project
will then track all the individual costs in the Resource views therein
allowing you to sort and filter on types of resources (Labor vs Material).
You can also easily filter, replace, and adjust costs on the Task views.

By applying this technique the costs will be included in the baseline values
for tracking purposes.

 

[Mike Einhorn]

Thanks to all for the welcome and the replies.

Originally I did try the approach of adding ODCs as resources but I found it
a bit cumbersome and not as direct. With the modified COST columns I can
enter them directly for each task as a single entry right on an entry table.

I first tried the idea using the FIXED COST column but I found that in the
program that is tied to the cost column so if you put a number in there it
adds it to the COST column.

What does seem to work is a take on Rod's suggestion. I inserted another
COST column where I just cut and paste my inital totaled estimate for each
task (TOTAL = LABOR + MATERIAL +TRAVEL). This becomes my baseline. I also
added another COST column which takes the difference between the current
TOTAL column and the baseline COST column I just created.

This gives me exactly what I need (until the next program reiview I am sure)

Thanks All!