Displaying timephase data for custom fields

[Jumpinjackflash]

How can you display timephase data for custom fields?
For example, we need to track two costs for each task: billable capital and
non-billable capital. If I add two custom cost fields to capture each of
these, how can show timephased data in the task usage view?

 

[Mike Glen]

Hi Jumpinjackflash ,

Welcome to this Microsoft Project newsgroup

This cannot be done from within Project.

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

 

[John]

How can you display timephase data for custom fields?
For example, we need to track two costs for each task: billable capital and
non-billable capital. If I add two custom cost fields to capture each of
these, how can show timephased data in the task usage view?

Junpin,
Wait a minute, we discussed this same issue with you last week (unless
there is more than one "Jumpinjackflash"). What part didn't you believe?
Re: "Custom Field Formulas" posted on 10/4/05.

John
Project MVP

 

[JackD]

John,

You said you could do it using multiple fields. I happen to think that is an
unrealistic solution so Jumpin, the answer from me is:

NO you can't have and display timescaled custom fields within Project. It
just is not possible.

 

[John]

John,

You said you could do it using multiple fields. I happen to think that is an
unrealistic solution so Jumpin, the answer from me is:

NO you can't have and display timescaled custom fields within Project. It
just is not possible.

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
.

Guys,
Without getting into another long discussion on philosophy, Jumpin's
question was, "How can you display timephase data for custom fields?" He
(or she) didn't ask if it was easy, practical, realistic, or with any
other qualifier. I think you will have to agree I answered the question
and I think you will also have to agree that I indicated in my first
responses that to do so was NOT easy or convenient (i.e. requires VBA
and special algorithms).

Are we to assume in our replies that the user is limited in their scope
of thinking or in what they are willing to do? I hope not. Years ago the
Project "experts" at my company said you couldn't do accounting month
data with Project. Then I wrote a macro to do it. In my view, Microsoft
provides VBA with its applications so the user can extend the
functionality to meet their needs - whatever those needs might be -
practical or impractical.

If a poster is "put off" by a response that is complex or difficult to
implement, that's fine, accepting or rejecting our advice is their
prerogative. Unless the difficult method is the only way to get there I
always try to offer several options from simple to advanced. Some may be
crazy, zany, or out in left field, but it gives the user a choice. I
believe most people like choices - perhaps I'm wrong - I accept that. In
the current case of Junpin's original post, he/she in fact asked about
the level of difficulty with a VBA solution so I didn't get the feeling
that I was out of line or leading them down a rosy path. However, what I
did get a little torqued about is that Jumpin posted the same question
again after you, me, Jan had already provided a thread of
answers/comments.

John