I Import the data from excel file to msp file. type of all the task is fixed
duration.but after importing the duration of some of the them is changed? for
example 1 day converted to 0.38 day.
--
PM

Re: import by Steve

Steve
Tue Oct 26 07:56:41 CDT 2004

Fixed duration refers to what happens whem you edit resource assignments and
has little to do with importing. Take a look at the Calendar Options page
(Tools Options menu) - the "hours per day" setting determines how many hours
of duration will be considered "1 day".

--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

"parastoo mousavi" <parastoomousavi@hotmail.com> wrote in message
news:73747E9D-50BC-4924-9EFF-DEE8AB5122FF@microsoft.com...
>I Import the data from excel file to msp file. type of all the task is
>fixed
> duration.but after importing the duration of some of the them is changed?
> for
> example 1 day converted to 0.38 day.
> --
> PM



Re: import by parastoomousavi

parastoomousavi
Wed Oct 27 00:45:02 CDT 2004

in my calendar & default calender , each working day contains 10 hours and
each week contains 6 working days . the duration of special task is 1 day &
total work that is assigned to this task is 7 hours.(the assigned work of
each resource on this task is one hour). my task type is fixed duration. but
after importing ; the duration of task is converted to 0.3 days and all
assigned resource unit is 100%. but when i import data manually , this
problem doesn't accure.
thanks in advance

"Steve House [MVP]" wrote:

> Fixed duration refers to what happens whem you edit resource assignments and
> has little to do with importing. Take a look at the Calendar Options page
> (Tools Options menu) - the "hours per day" setting determines how many hours
> of duration will be considered "1 day".
>
> --
> Steve House [MVP]
> MS Project Trainer/Consultant
> Visit http://www.mvps.org/project/faqs.htm for the FAQs
>
> "parastoo mousavi" <parastoomousavi@hotmail.com> wrote in message
> news:73747E9D-50BC-4924-9EFF-DEE8AB5122FF@microsoft.com...
> >I Import the data from excel file to msp file. type of all the task is
> >fixed
> > duration.but after importing the duration of some of the them is changed?
> > for
> > example 1 day converted to 0.38 day.
> > --
> > PM
>
>
>

Re: import by Steve

Steve
Wed Oct 27 06:56:03 CDT 2004

There's a bunch of things here I find confusing. First of all you said "in
my calendar and the default calendar" but that's not the hours per day I'm
talking about. In the menu find Tools / Options / Calendar. On that setup
page you'll find "Hours per day" "Hours per week" and "Days per month"
entries. Those fields control how a duration is, say, 3 days, is turned
into hours for storage. Changing the entries on that page DOES NOT change
your working time calendar but they are the conversion factors used to
convert the various valid units of duration to and from hours. You can
think of it as the Options determine how MANY hours you're talking about
when you say "1 day" while the working time calendar determines WHICH hours
out of the 24 count as working hours. If you have it set to 8 hours per day
and enter a task with a duration of "1 day" you'll find the task runs from
8am to 5pm using the default calendar. If you then change the "hours per
day" entry to 7 hours, changing nothing else, and look that task, you'll
find the duration will now read 1.14 days even though the times are still
8am to 5pm for 8 hours of work. That's because you've change the definition
of the number of hours called a "day" but that does not change the number of
hours the task will require.

Work and duration are not the same thing. Work measures the effort required
while duration measures the time it takes. Your 7 hours of work would
require a duration of 1 hour if all 7 resources are assigned 100% and work
together, 7 hours duration if they work at 100% but in sequence for 1 hour
each, 5 days duration if they work in sequence but at only around 18%
effort, or any number of other combinations.

There are so many factors involved with both with the specifics of the file
you're importing the data from and the project you're appending the data
into that it's hard to say just exactly what's going on from the information
you've provided. If you want to email the files to me I'd be happy to take
a look and see what I can figure out.


--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs



"parastoo mousavi" <parastoomousavi@hotmail.com> wrote in message
news:396E1830-C460-45A4-97E3-17962D5CA453@microsoft.com...
> in my calendar & default calender , each working day contains 10 hours and
> each week contains 6 working days . the duration of special task is 1 day
> &
> total work that is assigned to this task is 7 hours.(the assigned work of
> each resource on this task is one hour). my task type is fixed duration.
> but
> after importing ; the duration of task is converted to 0.3 days and all
> assigned resource unit is 100%. but when i import data manually , this
> problem doesn't accure.
> thanks in advance
>
> "Steve House [MVP]" wrote:
>
>> Fixed duration refers to what happens whem you edit resource assignments
>> and
>> has little to do with importing. Take a look at the Calendar Options
>> page
>> (Tools Options menu) - the "hours per day" setting determines how many
>> hours
>> of duration will be considered "1 day".
>>
>> --
>> Steve House [MVP]
>> MS Project Trainer/Consultant
>> Visit http://www.mvps.org/project/faqs.htm for the FAQs
>>
>> "parastoo mousavi" <parastoomousavi@hotmail.com> wrote in message
>> news:73747E9D-50BC-4924-9EFF-DEE8AB5122FF@microsoft.com...
>> >I Import the data from excel file to msp file. type of all the task is
>> >fixed
>> > duration.but after importing the duration of some of the them is
>> > changed?
>> > for
>> > example 1 day converted to 0.38 day.
>> > --
>> > PM
>>
>>
>>



Re: import by parastoomousavi

parastoomousavi
Sat Nov 06 23:09:03 CST 2004

when i import the data by selecting " as a new project " in the import mode
of import wizard , this problem accurs ( 1 day converted to 0.3day) , but
when i import the data by selecting " merge the data into the active project
" this problem doean't accure. why?

"Steve House [MVP]" wrote:

> There's a bunch of things here I find confusing. First of all you said "in
> my calendar and the default calendar" but that's not the hours per day I'm
> talking about. In the menu find Tools / Options / Calendar. On that setup
> page you'll find "Hours per day" "Hours per week" and "Days per month"
> entries. Those fields control how a duration is, say, 3 days, is turned
> into hours for storage. Changing the entries on that page DOES NOT change
> your working time calendar but they are the conversion factors used to
> convert the various valid units of duration to and from hours. You can
> think of it as the Options determine how MANY hours you're talking about
> when you say "1 day" while the working time calendar determines WHICH hours
> out of the 24 count as working hours. If you have it set to 8 hours per day
> and enter a task with a duration of "1 day" you'll find the task runs from
> 8am to 5pm using the default calendar. If you then change the "hours per
> day" entry to 7 hours, changing nothing else, and look that task, you'll
> find the duration will now read 1.14 days even though the times are still
> 8am to 5pm for 8 hours of work. That's because you've change the definition
> of the number of hours called a "day" but that does not change the number of
> hours the task will require.
>
> Work and duration are not the same thing. Work measures the effort required
> while duration measures the time it takes. Your 7 hours of work would
> require a duration of 1 hour if all 7 resources are assigned 100% and work
> together, 7 hours duration if they work at 100% but in sequence for 1 hour
> each, 5 days duration if they work in sequence but at only around 18%
> effort, or any number of other combinations.
>
> There are so many factors involved with both with the specifics of the file
> you're importing the data from and the project you're appending the data
> into that it's hard to say just exactly what's going on from the information
> you've provided. If you want to email the files to me I'd be happy to take
> a look and see what I can figure out.
>
>
> --
> Steve House [MVP]
> MS Project Trainer/Consultant
> Visit http://www.mvps.org/project/faqs.htm for the FAQs
>
>
>
> "parastoo mousavi" <parastoomousavi@hotmail.com> wrote in message
> news:396E1830-C460-45A4-97E3-17962D5CA453@microsoft.com...
> > in my calendar & default calender , each working day contains 10 hours and
> > each week contains 6 working days . the duration of special task is 1 day
> > &
> > total work that is assigned to this task is 7 hours.(the assigned work of
> > each resource on this task is one hour). my task type is fixed duration.
> > but
> > after importing ; the duration of task is converted to 0.3 days and all
> > assigned resource unit is 100%. but when i import data manually , this
> > problem doesn't accure.
> > thanks in advance
> >
> > "Steve House [MVP]" wrote:
> >
> >> Fixed duration refers to what happens whem you edit resource assignments
> >> and
> >> has little to do with importing. Take a look at the Calendar Options
> >> page
> >> (Tools Options menu) - the "hours per day" setting determines how many
> >> hours
> >> of duration will be considered "1 day".
> >>
> >> --
> >> Steve House [MVP]
> >> MS Project Trainer/Consultant
> >> Visit http://www.mvps.org/project/faqs.htm for the FAQs
> >>
> >> "parastoo mousavi" <parastoomousavi@hotmail.com> wrote in message
> >> news:73747E9D-50BC-4924-9EFF-DEE8AB5122FF@microsoft.com...
> >> >I Import the data from excel file to msp file. type of all the task is
> >> >fixed
> >> > duration.but after importing the duration of some of the them is
> >> > changed?
> >> > for
> >> > example 1 day converted to 0.38 day.
> >> > --
> >> > PM
> >>
> >>
> >>
>
>
>