M
Matt Dunphy
I would like to preface the following post by saying that I realize
Project is not the ideal solution for invoicing, but we're kind of
using it like that, and I'm going to have to find a better way of doing
what I'm doing this week.
At this point, to get monthly actuals for each project, I'm opening
each Project in Professional, analyzing timescaled data to Excel,
removing tasks with zero hours, and printing the tasks that have
actuals entered, i.e.
Analyze -> Entire Project -> Actual Work ->
I realize that in order to do this efficiently, I'm going to have to
automate the process, because most of the stuff I'm clicking or
deleting could be handled by a pretty straightforward script. It would
be greatly helpful though if I had a decent starting point... even if
it's just something that gives me an idea of how to duplicate the above
process in VBA. I would actually need something broader, basically
scanning each project on the server for actuals amongst the timescaled
data.
The ideal end result would be a worksheet in Excel for each project,
showing actual hours only in those tasks where time has been entered
between a start and end date, with a "Monthly Total" of that project's
actuals.
Any help would be greatly appreciated, thanks!
--Matt Dunphy
Project is not the ideal solution for invoicing, but we're kind of
using it like that, and I'm going to have to find a better way of doing
what I'm doing this week.
At this point, to get monthly actuals for each project, I'm opening
each Project in Professional, analyzing timescaled data to Excel,
removing tasks with zero hours, and printing the tasks that have
actuals entered, i.e.
Analyze -> Entire Project -> Actual Work ->
From 11/01/04 to 11/30/04, Units: Months -> No Graph Please -> Finish.
I realize that in order to do this efficiently, I'm going to have to
automate the process, because most of the stuff I'm clicking or
deleting could be handled by a pretty straightforward script. It would
be greatly helpful though if I had a decent starting point... even if
it's just something that gives me an idea of how to duplicate the above
process in VBA. I would actually need something broader, basically
scanning each project on the server for actuals amongst the timescaled
data.
The ideal end result would be a worksheet in Excel for each project,
showing actual hours only in those tasks where time has been entered
between a start and end date, with a "Monthly Total" of that project's
actuals.
Any help would be greatly appreciated, thanks!
--Matt Dunphy