Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
Creating separate reports for each Project Manager | Excel Discussion (Misc queries) | |||
reports | Excel Worksheet Functions |