Create a custom time scale?

[Jeanders]

My goal... in the Task Usage view I would like to see Work (hours)
distributed by my company's accounting months (vice calendar months).

These accounting months have specific start and stop dates that do not align
with the standard calendar month start and stop dates.

I am looking for a solution that allows me to create a customer time scale
and is resident within MS Project.

I have heard that there are some 2nd party plug-in tools that will meet this
need. However, I would like to avoid using a 2nd party tool if at all
possible.

Thanks in advance.

 

[Jan De Messemaeker]

Hi,

I wonder.
IMHO you can only program that in a more versatile tool like Excel but it
wil take MUUCCHH programming I'm afraid

 

[John]

My goal... in the Task Usage view I would like to see Work (hours)
distributed by my company's accounting months (vice calendar months).

These accounting months have specific start and stop dates that do not align
with the standard calendar month start and stop dates.

I am looking for a solution that allows me to create a customer time scale
and is resident within MS Project.

I have heard that there are some 2nd party plug-in tools that will meet this
need. However, I would like to avoid using a 2nd party tool if at all
possible.

Thanks in advance.

Jeanders,
Unfortunately the only way to get Project data in accounting month
format is to use a VBA procedure and export to Excel (as Jan eluded to).
I am not aware of any third party add-ins that do this but I could be
wrong. I have done it twice myself, once at my company and once for a
client. Both instances were for a 4-4-5 accounting month sequence.

Now, my fellow MVPs will probably roll their eyes at this, but if you
only need limited data (e.g. monthly data for a project that spans two
years or less), you could potentially use spare fields in Project to
display the accounting month data. But again, this will require a rather
sophisticated VBA procedure to create the accounting month data.

John
Project MVP

 

[Jan De Messemaeker]

Hi Jophn,

I will stop rolling my eyes if you could at least tell me which spare fields
you talk about

 

[John]

Hi Jophn,

I will stop rolling my eyes if you could at least tell me which spare fields
you talk about

Jan,
I was thinking of the 30 spare text fields and of course they will be
different depending on which view type is being used - task, resource,
or combination.

John

 

[Jan De Messemaeker]

Hi John,

Yes but neither of them can be timescaled, that is my rolling eye movement.
When answering, you make it sound as igf timescaled values can exist for
custom fields.
Greetings,

 

[John]

Hi John,

Yes but neither of them can be timescaled, that is my rolling eye movement.
When answering, you make it sound as igf timescaled values can exist for
custom fields.
Greetings,

Jan,
You misunderstand. I did not imply that spare fields could be
timescaled, but, user generated timescale values (e.g. accounting month
data created via VBA), CAN be placed in spare fields. In effect then,
timescaled values CAN exist in spare fields. And no, I'm not just
playing with words, I was simply suggesting that custom timescaled data
can be display directly in Project on a limited basis.

If the user needs a full complement of custom timescaled data values,
then the best approach is an export to Excel (or equivalent).

John

 

[Jeanders]

John/Jan...

Thanks guys!!! I got it. I am going to export to excel then I can do
whatever I want with the data.

Cheers.

Joshua

 

[John]

John/Jan...

Thanks guys!!! I got it. I am going to export to excel then I can do
whatever I want with the data.

Cheers.

Joshua

Joshua,
You're welcome.
John