Project 2003 - reporting synched with 15th and EOM - How?

[PistonsFan]

I'd like to be able to capture time and produce reports from MS-Project using
time intervals that synchronize with our business accounting - the 15th and
the End-of-the-Month (EOM). Any ideas? Also, how do I export data from
MS-Project that prvides daily data, i.e, Actual Work.

 

[John]

I'd like to be able to capture time and produce reports from MS-Project using
time intervals that synchronize with our business accounting - the 15th and
the End-of-the-Month (EOM). Any ideas? Also, how do I export data from
MS-Project that prvides daily data, i.e, Actual Work.

PistonFan,
Yeah but the Pistons got knocked out - now who ya gonna cheer for?

There are various methods to get the data in the form you want. Your
needs are similar to some industries that use accounting months instead
of standard calendar months. The easiest way to capture the data is with
a VBA macro but that approach is only practical if you have VBA
experience. Short of that, you could use the "Analyze timescale data in
Excel" utility/add-in found on the Analysis toolbar. I would export the
data in days and then sum up the 1st through the 15th and 16th through
EOM once the data is in Excel.

As far as getting Actual Work on a daily basis, just configure the
utility to export that field.

Hope this helps.
John
Project MVP