Prev: Indicator on resource availability, in MS Project Professional
Next: Solution Starter: Scrum for Project 2003
From: D Pingger on 19 May 2008 02:09
WHOA!!!!!!

Thanks for nosing in, John!!!!!

What a simple answer! Yes, I made the fix and it now works. I only had the
column formated as a number; changed it to a % format and everything works.

This board rocks because of experts like Julie and You!

Thanks again for caring about users problems like me.

DPingger

"John" wrote:

> In article <6E032E06-8609-433D-AEB6-A8E12ABB654E(a)microsoft.com>,
> D Pingger <DPingger(a)discussions.microsoft.com> wrote:
>
> > Hi JulieS,
> >
> > I tried just importing the % complete field (deleted the other two fields
> > from the file) and it still wouldn't do it. Hmmmmm. I'm way stumped now.
> >
> > Help!?!?!?!?!
> >
> > DPingger
>
> DPingger,
> Pardon me for nosing in. How is the percent complete value expressed in
> Excel? If it is just a number, (i.e. 60 for 60%), Project will not
> recognize that format and will import 0%. However, if it is expressed in
> Excel as a percent or decimal, (i.e. 60% or .6), then it will be
> imported.
>
> John
> Project MVP
> >
> > "JulieS" wrote:
> >
> > > Hi D Pingger,
> > >
> > > What other data are you importing? It may be possible that you have
> > > data being imported which conflicts with the % complete. For example,
> > > if you try to import % complete but also import actual and remaining
> > > duration, the percent complete field is going to be recalculated by
> > > the actual and remaining duration values.
> > >
> > > Percent complete = (actual duration/duration)*100
> > >
> > > I hope this helps. Let us know how you get along.
> > >
> > > Julie
> > > Project MVP
> > >
> > > Visit http://project.mvps.org/ for the FAQs and additional information
> > > about Microsoft Project
> > >
> > > "D Pingger" <DPingger(a)discussions.microsoft.com> wrote in message
> > > news:0F2EC29E-AE67-4A1D-8CAF-3F7ECED8E6B4(a)microsoft.com...
> > > > In 2003, I'm updating data using an excel spreadsheet but for some
> > > > reason,
> > > > the %complete value doesn't import back in. Is there something I'm
> > > > missing?
> > > >
> > > > I use the import wizard and mapping.
> > > >
> > > > Help!
> > > >
> > > > TIA
> > > > DPingger
> > >
> > >
> > >
>
From: JulieS on 19 May 2008 08:16
You're most welcome D Pingger. And thanks for the "nose" in John --
great catch :-)

Julie

"D Pingger" <DPingger(a)discussions.microsoft.com> wrote in message
news:D8355C0A-167B-4DFB-9F8E-3C45001E394E(a)microsoft.com...
> WHOA!!!!!!
>
> Thanks for nosing in, John!!!!!
>
> What a simple answer! Yes, I made the fix and it now works. I only
> had the
> column formated as a number; changed it to a % format and everything
> works.
>
> This board rocks because of experts like Julie and You!
>
> Thanks again for caring about users problems like me.
>
> DPingger
>
> "John" wrote:
>
>> In article <6E032E06-8609-433D-AEB6-A8E12ABB654E(a)microsoft.com>,
>> D Pingger <DPingger(a)discussions.microsoft.com> wrote:
>>
>> > Hi JulieS,
>> >
>> > I tried just importing the % complete field (deleted the other
>> > two fields
>> > from the file) and it still wouldn't do it. Hmmmmm. I'm way
>> > stumped now.
>> >
>> > Help!?!?!?!?!
>> >
>> > DPingger
>>
>> DPingger,
>> Pardon me for nosing in. How is the percent complete value
>> expressed in
>> Excel? If it is just a number, (i.e. 60 for 60%), Project will not
>> recognize that format and will import 0%. However, if it is
>> expressed in
>> Excel as a percent or decimal, (i.e. 60% or .6), then it will be
>> imported.
>>
>> John
>> Project MVP
>> >
>> > "JulieS" wrote:
>> >
>> > > Hi D Pingger,
>> > >
>> > > What other data are you importing? It may be possible that you
>> > > have
>> > > data being imported which conflicts with the % complete. For
>> > > example,
>> > > if you try to import % complete but also import actual and
>> > > remaining
>> > > duration, the percent complete field is going to be
>> > > recalculated by
>> > > the actual and remaining duration values.
>> > >
>> > > Percent complete = (actual duration/duration)*100
>> > >
>> > > I hope this helps. Let us know how you get along.
>> > >
>> > > Julie
>> > > Project MVP
>> > >
>> > > Visit http://project.mvps.org/ for the FAQs and additional
>> > > information
>> > > about Microsoft Project
>> > >
>> > > "D Pingger" <DPingger(a)discussions.microsoft.com> wrote in
>> > > message
>> > > news:0F2EC29E-AE67-4A1D-8CAF-3F7ECED8E6B4(a)microsoft.com...
>> > > > In 2003, I'm updating data using an excel spreadsheet but for
>> > > > some
>> > > > reason,
>> > > > the %complete value doesn't import back in. Is there
>> > > > something I'm
>> > > > missing?
>> > > >
>> > > > I use the import wizard and mapping.
>> > > >
>> > > > Help!
>> > > >
>> > > > TIA
>> > > > DPingger
>> > >
>> > >
>> > >
>>


From: John on 19 May 2008 10:46
In article <D8355C0A-167B-4DFB-9F8E-3C45001E394E(a)microsoft.com>,
D Pingger <DPingger(a)discussions.microsoft.com> wrote:

> WHOA!!!!!!
>
> Thanks for nosing in, John!!!!!
>
> What a simple answer! Yes, I made the fix and it now works. I only had the
> column formated as a number; changed it to a % format and everything works.
>
> This board rocks because of experts like Julie and You!
>
> Thanks again for caring about users problems like me.
>
> DPingger
D Pingger,
Let's see, we band together as MVPs to help the users and you say that
we rock. I guess that makes us a rock band :-)

You're welcome. Sometimes I just get lucky.

John
Project MVP
>
> "John" wrote:
>
> > In article <6E032E06-8609-433D-AEB6-A8E12ABB654E(a)microsoft.com>,
> > D Pingger <DPingger(a)discussions.microsoft.com> wrote:
> >
> > > Hi JulieS,
> > >
> > > I tried just importing the % complete field (deleted the other two fields
> > > from the file) and it still wouldn't do it. Hmmmmm. I'm way stumped now.
> > >
> > > Help!?!?!?!?!
> > >
> > > DPingger
> >
> > DPingger,
> > Pardon me for nosing in. How is the percent complete value expressed in
> > Excel? If it is just a number, (i.e. 60 for 60%), Project will not
> > recognize that format and will import 0%. However, if it is expressed in
> > Excel as a percent or decimal, (i.e. 60% or .6), then it will be
> > imported.
> >
> > John
> > Project MVP
> > >
> > > "JulieS" wrote:
> > >
> > > > Hi D Pingger,
> > > >
> > > > What other data are you importing? It may be possible that you have
> > > > data being imported which conflicts with the % complete. For example,
> > > > if you try to import % complete but also import actual and remaining
> > > > duration, the percent complete field is going to be recalculated by
> > > > the actual and remaining duration values.
> > > >
> > > > Percent complete = (actual duration/duration)*100
> > > >
> > > > I hope this helps. Let us know how you get along.
> > > >
> > > > Julie
> > > > Project MVP
> > > >
> > > > Visit http://project.mvps.org/ for the FAQs and additional information
> > > > about Microsoft Project
> > > >
> > > > "D Pingger" <DPingger(a)discussions.microsoft.com> wrote in message
> > > > news:0F2EC29E-AE67-4A1D-8CAF-3F7ECED8E6B4(a)microsoft.com...
> > > > > In 2003, I'm updating data using an excel spreadsheet but for some
> > > > > reason,
> > > > > the %complete value doesn't import back in. Is there something I'm
> > > > > missing?
> > > > >
> > > > > I use the import wizard and mapping.
> > > > >
> > > > > Help!
> > > > >
> > > > > TIA
> > > > > DPingger
> > > >
> > > >
> > > >
> >
First  |  Prev  | 
Pages: 1 2
Prev: Indicator on resource availability, in MS Project Professional
Next: Solution Starter: Scrum for Project 2003