Go Back   Trackpads Community > General Discussions > Computer and Technology > Microsoft Applications

Microsoft Applications Discussions about Windows and other MS Products such as Office

Reply
 
LinkBack Thread Tools
Old 06-16-2004, 19:22   #1 (permalink)
april
Civilians

 
Default entered field vs. calculated field

I'm confused about the difference between the two. The microsoft help file has the following definition:
- Entered field is a field in which you may type or edit information.
- calculated field is a field in which the value is determined by the Project base don other fields. Project may recalculate the value automaically or when you specify

Are start and end date entered fields or calculated fields? if I have two tasks a and b with FS dependency, does that make the dates for task b calculated fields?

The reason I'm asking is because I'm having problems importing project data from another file format. The help file suggests that only information in "entered field" can be imported. I created a project and specified a project start date. The imported file (in xml format) is identical to this project, with only difference being that all planned dates (starting from the project start date) were shifted by 3 days. All task durations and dependencies were preserved. When importing the file and merging it with the existing project, isntead of getting the updated project plan, I ran into conflicts with sub-tasks and none of dates for the sub-tasks were moved as a result. I don't understand how this would happen, even if project ignored all other date fields in the import file and used only project start date during the import/merge, the calculated task dates should be the same as what I had in my import file?
 
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Trackpads Information
Click to Visit
Old 06-16-2004, 19:22   #2 (permalink)
Steve House
Civilians

 
Default Re: entered field vs. calculated field

Task Start and Finish date fields are a mixed type that can be either
calculated or entered directly. Normally they all *should* be calculated
rather than entered but Project does allow you to enter them if you wish.
If you do, it sets a Start No Earlier Than constraint when a start date is
entered and a Finish No Earlier Than constraint when a finish date is
supplied. Try re-importing but remove the Start and Finish date fields from
the import mapping.

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



"april" <anonymous@discussions.microsoft.com> wrote in message
news:61E19630-52C8-46FE-9BF5-15AEAAC19A28@microsoft.com...
> I'm confused about the difference between the two. The microsoft help file

has the following definition:
> - Entered field is a field in which you may type or edit information.
> - calculated field is a field in which the value is determined by the

Project base don other fields. Project may recalculate the value
automaically or when you specify
>
> Are start and end date entered fields or calculated fields? if I have two

tasks a and b with FS dependency, does that make the dates for task b
calculated fields?
>
> The reason I'm asking is because I'm having problems importing project

data from another file format. The help file suggests that only information
in "entered field" can be imported. I created a project and specified a
project start date. The imported file (in xml format) is identical to this
project, with only difference being that all planned dates (starting from
the project start date) were shifted by 3 days. All task durations and
dependencies were preserved. When importing the file and merging it with the
existing project, isntead of getting the updated project plan, I ran into
conflicts with sub-tasks and none of dates for the sub-tasks were moved as a
result. I don't understand how this would happen, even if project ignored
all other date fields in the import file and used only project start date
during the import/merge, the calculated task dates should be the same as
what I had in my import file?


 
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-16-2004, 19:23   #3 (permalink)
april
Civilians

 
Default Re: entered field vs. calculated field

Hi Steve,

What if the Planned Start Date is intentional? In some cases, a subsequent task does not need to immediately start even though the dependency requires that it has to at least wait for the previous task to finish before it can start. The "start no earlier than" constraint is not necessarily the only sceneario here but it could be one of the reasons that a planned delay is set in the schedule. Does that mean I cannot properly import and merge with existing project file when dates are entered in schedule on purpose?

On a second note, I did I noticed that the "Start No Earlier Than" constraint can be removed once the late activity has started with actual start date and % of completion.

Thanks,
april
 
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 06-16-2004, 19:25   #4 (permalink)
Steve House
Civilians

 
Default Re: entered field vs. calculated field

Remember the basic purpose of MS Project is not to accept as its input a
schedule you have come up with elsewhere but rather taking as input what
needs to be accomplished and the assets you have to do it with, it then
calculates and gives you the optimal schedule you can have. You don't tell
it when tasks *will* take place, rather it tells you when tasks *can* take
place and schedules them so as to give you a completed project in the
shortest possible time. IMHO, a "Start No Earlier Than" constraint is
appropriately used when some condition external to the project makes it
impossible for the task to start as early as Project would otherwise
schedule it. The example I use in classes is filming a movie and we need to
shoot at a certain location. We're ready to shoot that scene in mid-June
but the owners of the location have said that under no circumstances can we
come on the property to begin setup until after the July 4th holidays.
Hence we'd use a SNET constaint to move the task out to the first date we
could work on it. If you do need a planned delay - waiting for parts
delivery after an order is placed or waiting for a contract to be approved,
for example - you still don't designate the start date for successor task -
instead you use a lag time inserted in the link to create the necessary
delay between the two tasks. That way if the predecessor is pushed back,
the successor is pushed back a like amount and the required delay between
them is preserved. Or perhaps the resource that will work on the task isn't
available until after a certain date. Even then, you don't directly
designate the date the task will be scheduled on. Instead you input the
information about when the resources are available and Project will schedule
tasks accordingly when you assign the resources to them, only placing them
on dates where the resources required will be there to work on them.


"april" <anonymous@discussions.microsoft.com> wrote in message
news:8B6307E0-31B7-48E5-AE68-4B699BC16475@microsoft.com...
> Hi Steve,
>
> What if the Planned Start Date is intentional? In some cases, a subsequent

task does not need to immediately start even though the dependency requires
that it has to at least wait for the previous task to finish before it can
start. The "start no earlier than" constraint is not necessarily the only
sceneario here but it could be one of the reasons that a planned delay is
set in the schedule. Does that mean I cannot properly import and merge with
existing project file when dates are entered in schedule on purpose?
>
> On a second note, I did I noticed that the "Start No Earlier Than"

constraint can be removed once the late activity has started with actual
start date and % of completion.
>
> Thanks,
> april



 
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot - Calculated field sanshah01@yahoo.com Microsoft Applications 1 04-09-2005 16:00
Calculated Field Overide? =?Utf-8?B?U3RldmUgU2NvdHQ=?= Microsoft Applications 3 01-14-2005 15:00
Pivot table- Calculated Field Gwen Microsoft Applications 2 01-03-2005 23:00
Else expression in calculated field doesn't suppress zeros Andrew K Microsoft Applications 1 06-16-2004 19:58
calculated field Ben Microsoft Applications 1 06-16-2004 18:30


Community Information
Options
Quick Options
Trackpads Non-Commercial Ad
Copyright Information Click to Visit
Time
Server Time
All times are GMT -4. The time now is 18:43.
Copyright
Copyright Information
The header is based off of work by Vipixel.com and modified by this site. Trackpads and the Trackpads Logo are both Registered Trademarks of Jason Edwards and cannot be used without prior written permission.  The only exception is as a link back to this site. Trackpads is a private website run by a small legion of volunteers, 3 dogs, 12.5 cats and an army of small, super smart, bio-engineered mice with pointy hats and tutu's. Search Engine Friendly URLs by vBSEO 3.2.0 RC7
Archive Links
Archive Links
Page generated in 1.32849 seconds with 19 queries