Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6
Default reports for project Please HELP

I am managing a master plan with 13 individual project plans inside. I work
for an advertising agency and these are interactive projects.

We are trying to pull a MS Project Visual Report to show total hours worked
per month by each resource working on the project. When we utilize the
Resource Work Availability Report or the Resource Work Report Summary, we
cannot figure out where the work availability number comes from? And why is
it 352 for almost all of our resources? Is it days, hours, per quarter, per
year? When I move the tab that controls the day, week, month, and year; The
report comes out with the same numbers each time? How can that be?

What is the best way to pull the following out of a project using MS Project
Report?
-total hours worked per month by each resource
-see whos working where and what theyre availability is or isnt.
-see projects that are most pressing or important at the time

Should I use Visual Reports or Create a custom report?

PLEASE HELP!!!


Time Weekly Calendar All

Data
Type Resources Work Availability Work Remaining Availability Actual Work
Work Alison 352 98.66666667 265.3333333 0
Ashlee 352 72 280 0
Bora 320 191.6666667 190.8333333 0
Clint B. 352 20 332 0
Eric W 352 118 249 0
Gabe M 352 491.8333333 48 0
Gorkem Y 352 80 272 0
Kong 352 88.5 263.5 0
Leena V 352 140 272 0
Leigh 352 20 332 0
Phase I 352 154 219.6 0
Robby 352 31.66666667 324.3333333 0
Ronny 352 104.1666667 270.8333333 0
Tommy 352 151.5 258 0
Unassigned 0 0 0 0
Work Total 4896 1762 3577.433333 0
Grand Total 4896 1762 3577.433333 0



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report Prashanthi Setting up and Configuration of Excel 0 February 18th 08 03:02 PM
Excell error "Can't find Project or Library" Project VBAProject Lost in Excel Excel Worksheet Functions 0 April 12th 07 04:42 PM
How to convert MS Project to MS Excel. I don't have MS Project. Jane Excel Discussion (Misc queries) 1 February 20th 06 10:01 PM
Creating separate reports for each Project Manager Lorie Excel Discussion (Misc queries) 4 June 15th 05 02:26 PM
reports herbzee Excel Worksheet Functions 1 February 21st 05 10:51 PM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"