none
Custom weekly report RRS feed

  • Question

  • Hello all

    I'm seeking for building a personal report in Project.

    I'm using shared resources through a dedicated mpp file. This file is used by other PMs to planify their own project and I'd like to use the shared resources file as a ''workload management tool''.

    My purpose is to have a weekly review of the global workload asked by PMs through their mpp files.

    So I'd like to build an excel in which the information below will be reported :

    Week number (mandatory)

    Ressource name (mandatory)

    Task assigned (mandatory)

    Project (nice to have)

    Workload (mandatory)

    Start date (mandatory)

    End date (mandatory)

    Does anybody has already worked on such a report and could help me ?

    Thks in advance and please apologize for my bad english (I m french :-))

    Thursday, January 26, 2012 1:24 PM

Answers

  • Nico --
     
    Using the default capabilities of Microsoft Project, you could open the shared resource pool file, display the Resource Usage view, insert the Project column to the left of the Resource Name column, and then zoom out to Months Over Weeks in the timescale.  That would approximate what you would like to see in your Excel report.
     
    However, if you really want to see this report in Excel, the only way to do that is to write a macro using the VBA programming language.  Rod Gill�??s book in Microsoft Project VBA is an excellent resource, with tutorials on how to export Microsoft Project data to Excel using VBA.  You can purchase his book at the following URL:
     
     
    Hope this helps.
     
    PS �?? Do not apologize for your English.  You write English well, my friend!

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, January 26, 2012 1:34 PM
    Moderator

All replies

  • Nico --
     
    Using the default capabilities of Microsoft Project, you could open the shared resource pool file, display the Resource Usage view, insert the Project column to the left of the Resource Name column, and then zoom out to Months Over Weeks in the timescale.  That would approximate what you would like to see in your Excel report.
     
    However, if you really want to see this report in Excel, the only way to do that is to write a macro using the VBA programming language.  Rod Gill�??s book in Microsoft Project VBA is an excellent resource, with tutorials on how to export Microsoft Project data to Excel using VBA.  You can purchase his book at the following URL:
     
     
    Hope this helps.
     
    PS �?? Do not apologize for your English.  You write English well, my friend!

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, January 26, 2012 1:34 PM
    Moderator
  • Hello Dale

    Thanks for your prompt reply. I agree with you the report shown by project is the one I'm looking for.

    As I have no skill in VBA for MSP it looks hard to me to develop this script.

    However I will have a look on this solution and keep you posted.

     

    Thanks again ! 

    Thursday, January 26, 2012 3:53 PM
  • Nico --
     
    You are welcome for the help, my friend!
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, January 26, 2012 4:07 PM
    Moderator