How can report MS project costs in financial periods instead of mo

My company has finacial periods that go in weeks 4,4,5,4,4,5,4,4,5,4,4,5 etc.

How can I report proect costs in periods rather than months?

Mike
Wed Mar 09 08:27:46 CST 2005

Hi Tim,

Welcome to this Microsoft Project newsgroup :-)

You can't - Project is only a work schedueller which tracks costs, not a
financial management program. :)

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

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

Mike Glen
MS Project MVP



Tim Smith wrote:
> My company has finacial periods that go in weeks
> 4,4,5,4,4,5,4,4,5,4,4,5 etc.
>
> How can I report proect costs in periods rather than months?

John
Wed Mar 09 10:59:02 CST 2005

In article <077AE015-B6B1-48CB-B6AD-DCFB43230BCE@microsoft.com>,
Tim Smith <Tim Smith@discussions.microsoft.com> wrote:

> My company has finacial periods that go in weeks 4,4,5,4,4,5,4,4,5,4,4,5 etc.
>
> How can I report proect costs in periods rather than months?

Tim,
I take exception to Mike on this one. Your company is using a common
4-4-5 sequence. Although no version of Project supports financial
calendars, through VBA the normal Project calendar data can be converted
into 4-4-5, (or any other sequence), data. I've done it more than once.
If you would like more information, contact me direct.

Hope this helps.
John
Project MVP

Mike
Wed Mar 09 15:32:05 CST 2005

Hi John,

As you know, I'm not a vba expert so I tend to respond as such if, whatever,
can't be done in Project itself. Writing code is another ballgame and could
cost the poster a lot of money. Indeed, at a price, anything can be done
with anything by programming! I leave it to the likes of yourself to make
the contract ;) If you do if for free, then why not pass me the code and
I'll publish it in the mvp vba pages for all to see and use, then we can
refer future posters to the web site:)


Mike Glen
Project MVP




John wrote:
> In article <077AE015-B6B1-48CB-B6AD-DCFB43230BCE@microsoft.com>,
> Tim Smith <Tim Smith@discussions.microsoft.com> wrote:
>
>> My company has finacial periods that go in weeks
>> 4,4,5,4,4,5,4,4,5,4,4,5 etc.
>>
>> How can I report proect costs in periods rather than months?
>
> Tim,
> I take exception to Mike on this one. Your company is using a common
> 4-4-5 sequence. Although no version of Project supports financial
> calendars, through VBA the normal Project calendar data can be
> converted into 4-4-5, (or any other sequence), data. I've done it
> more than once. If you would like more information, contact me direct.
>
> Hope this helps.
> John
> Project MVP

John
Wed Mar 09 16:59:47 CST 2005

In article <u334N#OJFHA.2628@tk2msftngp13.phx.gbl>,
"Mike Glen" <glenATmvps.org> wrote:

> Hi John,
>
> As you know, I'm not a vba expert so I tend to respond as such if, whatever,
> can't be done in Project itself. Writing code is another ballgame and could
> cost the poster a lot of money. Indeed, at a price, anything can be done
> with anything by programming! I leave it to the likes of yourself to make
> the contract ;) If you do if for free, then why not pass me the code and
> I'll publish it in the mvp vba pages for all to see and use, then we can
> refer future posters to the web site:)
>
>
> Mike Glen
> Project MVP


Mike,
That particular code is not done for free but on the other hand it need
not cost a lot of money. But then "a lot of money" is a relative thing.
What is a lot of money to me is just a drop in the bucket to a corporate
entity.

John

John
Thu Mar 10 11:30:54 CST 2005

In article <u334N#OJFHA.2628@tk2msftngp13.phx.gbl>,
"Mike Glen" <glenATmvps.org> wrote:

> Hi John,
>
> As you know, I'm not a vba expert so I tend to respond as such if, whatever,
> can't be done in Project itself. Writing code is another ballgame and could
> cost the poster a lot of money. Indeed, at a price, anything can be done
> with anything by programming! I leave it to the likes of yourself to make
> the contract ;) If you do if for free, then why not pass me the code and
> I'll publish it in the mvp vba pages for all to see and use, then we can
> refer future posters to the web site:)
>
>
> Mike Glen
> Project MVP


Mike,
I should have provided a more definitive answer as to why I took
exception to your response. Since I think it is of general interest, I
am posting a new message on this newsgroup.

John

Mike
Thu Mar 10 12:55:04 CST 2005

No problem, John :)

Mike Glen
Project MVP




John wrote:
> In article <u334N#OJFHA.2628@tk2msftngp13.phx.gbl>,
> "Mike Glen" <glenATmvps.org> wrote:
>
>> Hi John,
>>
>> As you know, I'm not a vba expert so I tend to respond as such if,
>> whatever, can't be done in Project itself. Writing code is another
>> ballgame and could cost the poster a lot of money. Indeed, at a
>> price, anything can be done with anything by programming! I leave
>> it to the likes of yourself to make the contract ;) If you do if
>> for free, then why not pass me the code and I'll publish it in the
>> mvp vba pages for all to see and use, then we can refer future
>> posters to the web site:)
>>
>>
>> Mike Glen
>> Project MVP
>
>
> Mike,
> I should have provided a more definitive answer as to why I took
> exception to your response. Since I think it is of general interest, I
> am posting a new message on this newsgroup.
>
> John

TimSmith
Fri Mar 11 06:39:04 CST 2005

Thanks both of you! It is what I expected - not simple. However i find it
quite a shortfall of project as all our reporting here, progress the lot, is
based on period not month.

Thanks again.

"John" wrote:

> In article <077AE015-B6B1-48CB-B6AD-DCFB43230BCE@microsoft.com>,
> Tim Smith <Tim Smith@discussions.microsoft.com> wrote:
>
> > My company has finacial periods that go in weeks 4,4,5,4,4,5,4,4,5,4,4,5 etc.
> >
> > How can I report proect costs in periods rather than months?
>
> Tim,
> I take exception to Mike on this one. Your company is using a common
> 4-4-5 sequence. Although no version of Project supports financial
> calendars, through VBA the normal Project calendar data can be converted
> into 4-4-5, (or any other sequence), data. I've done it more than once.
> If you would like more information, contact me direct.
>
> Hope this helps.
> John
> Project MVP
>

John
Fri Mar 11 12:00:00 CST 2005

In article <FE155C15-EEAA-47C1-9BF5-267FDF4CAAE3@microsoft.com>,
Tim Smith <TimSmith@discussions.microsoft.com> wrote:

> Thanks both of you! It is what I expected - not simple. However i find it
> quite a shortfall of project as all our reporting here, progress the lot, is
> based on period not month.
>
> Thanks again.

Tim,
"Not simple" is a relative term. Check out the discussion in this
newsgroup on the subject of "Project capabilities". I hit quite a cord.

I think the reason Project does not have the feature built-in is that
non-standard calendars are used by only a small segment of the business
world. Adding the built-in capability to Project isn't a highly
requested feature and therefore not cost effective for Microsoft. At
least that's my opinion.

John