Financial Week Number Shift Start

[Tris]

Is it possible to change the start the date the week number starts from as my
companies start date is differnet to MS Project?

For example MS Project says that 3rd Jan 2006 is in Week 14 while my company
Financial Calendar says it's in Week 15!

I've set the machine to have the financial year starting in October and all
our production weeks start with week one being 29th September 2005

Cheers

 

[John]

Is it possible to change the start the date the week number starts from as my
companies start date is differnet to MS Project?

For example MS Project says that 3rd Jan 2006 is in Week 14 while my company
Financial Calendar says it's in Week 15!

I've set the machine to have the financial year starting in October and all
our production weeks start with week one being 29th September 2005

Cheers

Tris,
What an odd setup. You say that your fiscal year starts in October yet
the first production week is a week earlier (i.e. last week of
September). Project does have some flexibility but not to the extent of
making sense of an inconsistent financial calendar.

Help us out here. What is the rationale for the production year starting
a week before the fiscal year?

John
Project MVP

 

[Tris]

I agreee entirely John, it took me awhile to work out why I was constantly a
week adrift!

As far as rationale goes your guess is as good as mine, but they appear to
be working on the premis that the financial year starts on the first full
week in October.

I guess one possible solution would be to add/subtract (whichever way I need
to go) to correct the shift. Is this possible?

Thanks

 

[John]

I agreee entirely John, it took me awhile to work out why I was constantly a
week adrift!

As far as rationale goes your guess is as good as mine, but they appear to
be working on the premis that the financial year starts on the first full
week in October.

I guess one possible solution would be to add/subtract (whichever way I need
to go) to correct the shift. Is this possible?

Thanks

Tris,
Well I'm glad you are as confused as I am. Your thinking may be right as
far as the corporate rationale but then not all corporate thinking is
based on logic or sound judgment - I think we can all attest to that

With basic Project, you can do one of two things. The first is to shift
the first production week to coincide with the fiscal year start. The
second is to simply live with the offset in production week numbering.
Beyond that, it will take an advanced feature of Project, namely VBA, to
re-configure the calendar to do what you want, and then the data would
need to be exported to another application (e.g. Excel) to display it in
the format you want. I did that with our company's data which was based
on a 4-4-5 accounting month calendar.

John
Project MVP

 

[Tris]

Thanks John

Shifting the production week won't work in this isnatance as I'm running a
pooled network with multiple projects, which will be ongoing across year
ends. So come September/October next year I'd be back in the same position.

Writing specialist VBA code is beyond my ability at this time and I can ill
afford the time.

So, exporting to Excel and converting the week numbers there was pretty much
where I had got to. Clumsy, but effective!

Tris

 

[John]

Thanks John

Shifting the production week won't work in this isnatance as I'm running a
pooled network with multiple projects, which will be ongoing across year
ends. So come September/October next year I'd be back in the same position.

Writing specialist VBA code is beyond my ability at this time and I can ill
afford the time.

So, exporting to Excel and converting the week numbers there was pretty much
where I had got to. Clumsy, but effective!

Tris

Tris,
You're welcome. Sometimes the brute force method is the best overall for
a particular user and I'm glad you found something that works for you.

As far as exporting to Excel, there are various methods available. For
static data, a simple export map will work (see the Project help file
for more information). For timescaled data, such as is seen in one of
the Usage views, the "analyze timescaled data in Excel" utility/add-in
found on the Analysis toolbar can be a big help. The ultimate approach
is with VBA, but then as you note, VBA isn't for everyone.

John