How to get hours reported in a day by resouce

[Artur Rodrigues]

Hi Guys,

I´m trying to write a VBA code to get hours reported in a day by resource. I
used TSV but that property just report hours designed to a resource. I need
to get hours reported in a day. Does anybody have an idea?



TIA,

Artur Rodrigues.

 

[Jan De Messemaeker]

Hi Arthur,

Better read the help on TimeScaleData and TimeScaleValues again because it
DOES give you the opportunity to enter data day by day - you were absolutely
oin the right track.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[Artur Rodrigues]

Ok you are right. However, TSV just work in as specific project. I need to
get all hours reported in a day. I want to check if my resources are filling
their "timesheeting" correctly.

 

[Artur Rodrigues]

Thanks Jan, but if you are talking about the option "actual work" I tried it
before. It really works in a specific project, but I´d like to take the
hours spent in all projects to check if my resources are filling the
timesheeting correctly.

TIA.

 

[Jan De Messemaeker]

Hi,

When all your projects are linked to a resource pool, and open at the same
time, you can do whatever you want.
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620

 

[John]

Artur,
I don't understand about only working with a specific project. If you
are working with multiple projects, they will either be individual or
"consolidated" in a master. In either case you can still look at all the
resources with the timescaled variable method. If the files are
separate, you will simply need to to have your code open each file and
examine the Actual Work field. If the files are consolidated in a
master, first make sure the master is fully "exploded", then use the
timescaled variable method to examine Actual Work for all the projects
in the master. I've done the latter and it works fine. It shouldn't
matter if the resources are in a common pool or not although if they are
not, the output may be rather difficult to interpret.

John

 

[Artur Rodrigues]

Maybe I did not express myself correctly. I work at a PMO that manage over
500 resources and some simultaneous projects. I need to check if my
resources are filling their hours correctly (40 hour in a week) if not, I
will send an email to his/her manager pointing the mistake.



In your suggestion it will be hard to open each project just to see it and
send an email. So, I develop by myself a SQL statement that helps me. It
takes all resources and gives me the total hour (schedule or actual) in a
week.



select
r.RES_NAME,
sum(w.WWORK_VALUE/60000) as 'Total Work'
from
MSP_WEB_WORK w,
MSP_WEB_RESOURCES r
where
w.WRES_ID = r.WRES_ID
and r.RES_EUID is not null
and w.WWORK_TYPE = 0 --- 0=scheduled, 1=actual, 2=overtime
and (getdate()-7 <= w.WWORK_FINISH and getdate()>= w.WWORK_START)
group by
r.RES_NAME

 

[John]

Artur,
I've never worked with an SQL so I have no expertise to help you in that
area. However, if the SQL approach is not working, is it possible to
create a master project that is linked to each of the separate projects?
Then you can use a Project macro to read the Actual Work from each
resource and act accordingly.

John