Task Usage View to Excel
in [Project]
|
From: Andrew Lavinsky on 8 Apr 2010 23:05 Sure you can in 2007 - I ran the Baseline Work Report, which dropped the right fields into an Excel PivotTable. I then modified the table by adding the Resources to the Rows, and the Time element to the Columns. I then removed the subtotals which seemed to be cluttering up the PivotTable. That gives me something which looks (to me at least) very close to your example below. Save it as a template, and you're off to the races. - Andrew Lavinsky Blog: http://blogs.catapultsystems.com/epm > I don't think 2007 will give me the complete view. > Name Work > Task 10 > R1 8 > R2 2 > If you know a report that captures this functionality please advise so > I can research and propose to my manager that we upgrade. > > "Andrew Lavinsky" wrote: > >> Just buy a version of 2007 as your "reporting tool." They should be >> relatively cheap to find these days with 2010 coming out. >> >> Visual Reports will do all of that. >> >> - Andrew Lavinsky >> Blog: http://blogs.catapultsystems.com/epm >>> Rod, >>> >>> Thanks for the pointer. However, as I stated in my opening post, I >>> am not a coder. I can copy and paste and get things to sometimes >>> work, but a modification is not going to work for me. Given that, I >>> am only seeking an additional application that will take the task >>> usage view, as is with timescaled data and port it over to excel. I >>> need the task list in hierarchical order with each resource listed >>> under their respected task(s) with the corresponding hours per >>> month. We port this view out to use as our proposal. If I cannot >>> find a resolution, I am afraid that mgmt will revert to trying to >>> use Excel as the scheduling tool. We both know that will be a >>> nightmare. I know that I can't be the only one who uses this view >>> for this and probably other purposes. Just trying to find out what >>> methods/tools other are using to accomplish this. Maybe the Excel >>> pros can help. >>> >>> Cheers! >>> >>> Jon >>> >>> As >>> >>> "Rod Gill" wrote: >>> >>>> Hi, >>>> >>>> If the Analyze timescaled data in Excel option doesn't do it for >>>> you then VBA is your only choice. The sample module from my book on >>>> MSDN shows how to export time phased data to Excel: >>>> >>>> http://msdn.microsoft.com/en-us/library/ee355231.aspx >>>> >>>> -- >>>> >>>> Rod Gill >>>> Microsoft MVP for Project - http://www.project-systems.co.nz >>>> Author of the only book on Project VBA, see: >>>> http://www.projectvbabook.com >>>> "JonM" <JonM(a)discussions.microsoft.com> wrote in message >>>> news:0FB959F6-1981-4D3E-AF3F-E001EB6ADDC5(a)microsoft.com... >>>> >>>>> I was wondering what other folks were using to get the task usage >>>>> view >>>>> (task >>>>> list with monthly time phased work) ported into excel. I first >>>>> started >>>>> using >>>>> the copy paste function, with a lot of clean up I might add to get >>>>> this >>>>> into >>>>> excel. Then I started printing to pdf and using able2extract to >>>>> port into >>>>> excel. I am curious what others are using. This is a must do for >>>>> my org. >>>>> I have checked the developer group and have not found anything >>>>> that >>>>> ports >>>>> the >>>>> view out exactly as it is seen in Task Usage. I am not a >>>>> programmer >>>>> so >>>>> modification is not an option for me. >>>>> I am hoping to find a companion product that will do this. >>>>> Thanks fo your inputs. >>>>> >>>>> __________ Information from ESET Smart Security, version of virus >>>>> signature database 5005 (20100406) __________ >>>>> >>>>> The message was checked by ESET Smart Security. >>>>> >>>>> http://www.eset.com >>>>> >>>> __________ Information from ESET Smart Security, version of virus >>>> signature database 5005 (20100406) __________ >>>> >>>> The message was checked by ESET Smart Security. >>>> >>>> http://www.eset.com >>>> >>>> . >>>> >> . >>
First
|
Prev
|
Pages: 1 2 3 4 Prev: Difference between using % complete and % work complete? Next: As-built Calendars |