Prev: Difference between using % complete and % work complete?
Next: As-built Calendars
From: Andrew Lavinsky on 7 Apr 2010 13:05
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
>>
>> .
>>


From: JonM on 7 Apr 2010 15:00
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
> >>
> >> .
> >>
>
>
> .
>
From: Rod Gill on 7 Apr 2010 17:29
There isn't a tool that does this, but Project 2003's Export Timephased Data
to Excel utility gets close. Your only solution is VBA if Project 2007's
Visual Reports does not work.

The Timephased code in book provides most of what you need. Contact me
offline if you want me to program a solution for you.

Rod.Gill AT project-systems DOT co DOT nz
--

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:6CCB94B3-73B6-49C9-8430-D017FA35750A(a)microsoft.com...
> 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
>> >>
>> >> .
>> >>
>>
>>
>> .
>>
>
> __________ Information from ESET Smart Security, version of virus
> signature database 5008 (20100407) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>

__________ Information from ESET Smart Security, version of virus signature database 5008 (20100407) __________

The message was checked by ESET Smart Security.

http://www.eset.com



From: JonM on 8 Apr 2010 15:36
Rod,
This is what I had suspected. Microsoft reports gives you almost the all
the information to pull this together, but not quiet.

I find it surprising that Microsoft hasn't made this available. I have
worked at several different small businesses and they all try to use the
Microsoft products to do proposals and schedule tracking as well as EVMS.
And at all of these companies we have had to resort to the copy, paste and
then all the formatting in MS Excel to make the data useful.

It would seem to me that Microsoft would develop this add in so that the MS
Proj data would would integrate smoothly into Excel providing a complete
solution.

During my searches on the various news groups I have seen numerous posts
pertaining to this.

Hopefully in the future this will be accomplished by someone.

"Rod Gill" wrote:

> There isn't a tool that does this, but Project 2003's Export Timephased Data
> to Excel utility gets close. Your only solution is VBA if Project 2007's
> Visual Reports does not work.
>
> The Timephased code in book provides most of what you need. Contact me
> offline if you want me to program a solution for you.
>
> Rod.Gill AT project-systems DOT co DOT nz
> --
>
> 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:6CCB94B3-73B6-49C9-8430-D017FA35750A(a)microsoft.com...
> > 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
> >> >>
> >> >> .
> >> >>
> >>
> >>
> >> .
> >>
> >
> > __________ Information from ESET Smart Security, version of virus
> > signature database 5008 (20100407) __________
> >
> > The message was checked by ESET Smart Security.
> >
> > http://www.eset.com
> >
> >
> >
>
> __________ Information from ESET Smart Security, version of virus signature database 5008 (20100407) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
> .
>
From: Rob Schneider on 8 Apr 2010 16:00
Rod's offered his help. An opportunity not to be missed, I think.


--rms

www.rmschneider.com




On 08/04/10 20:36, JonM wrote:
> Rod,
> This is what I had suspected. Microsoft reports gives you almost the all
> the information to pull this together, but not quiet.
>
> I find it surprising that Microsoft hasn't made this available. I have
> worked at several different small businesses and they all try to use the
> Microsoft products to do proposals and schedule tracking as well as EVMS.
> And at all of these companies we have had to resort to the copy, paste and
> then all the formatting in MS Excel to make the data useful.
>
> It would seem to me that Microsoft would develop this add in so that the MS
> Proj data would would integrate smoothly into Excel providing a complete
> solution.
>
> During my searches on the various news groups I have seen numerous posts
> pertaining to this.
>
> Hopefully in the future this will be accomplished by someone.
>
> "Rod Gill" wrote:
>
>> There isn't a tool that does this, but Project 2003's Export Timephased Data
>> to Excel utility gets close. Your only solution is VBA if Project 2007's
>> Visual Reports does not work.
>>
>> The Timephased code in book provides most of what you need. Contact me
>> offline if you want me to program a solution for you.
>>
>> Rod.Gill AT project-systems DOT co DOT nz
>> --
>>
>> 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:6CCB94B3-73B6-49C9-8430-D017FA35750A(a)microsoft.com...
>>> 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
>>>>>>
>>>>>> .
>>>>>>
>>>>
>>>>
>>>> .
>>>>
>>>
>>> __________ Information from ESET Smart Security, version of virus
>>> signature database 5008 (20100407) __________
>>>
>>> The message was checked by ESET Smart Security.
>>>
>>> http://www.eset.com
>>>
>>>
>>>
>>
>> __________ Information from ESET Smart Security, version of virus signature database 5008 (20100407) __________
>>
>> The message was checked by ESET Smart Security.
>>
>> http://www.eset.com
>>
>>
>>
>> .
>>
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: Difference between using % complete and % work complete?
Next: As-built Calendars