Solved

MS Project  : finish date on Gantt chart.

Posted on 2000-04-12
13
587 Views
Last Modified: 2012-06-27
I prepared a schedule in Excel
My boss requests to move it to MS Project 98
I copied and pasted the Excel data to Project, column by column to the appropriate one.
But the gantt chart do not include the finish date. If I change manually the finish date to itself, the gantt chart includes it.
What's wrong and how can I fix it?
I don't want to change all finish dates manually.

Thank you for your help
0
Comment
Question by:FIT
  • 7
  • 2
  • 2
  • +2
13 Comments
 

Author Comment

by:FIT
ID: 2707777
Adjusted points from 100 to 150
0
 

Author Comment

by:FIT
ID: 2708581
Adjusted points from 150 to 200
0
 

Author Comment

by:FIT
ID: 2708582
This seems to be a hard question...
Should I really do it manually?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 5

Expert Comment

by:nfroio
ID: 2708731
>>But the gantt chart do not include the finish date.

Did you add a finish date column to the chart through Project? and it did not calculate the proper finish dates?

>>If I change manually the finish date to itself, the gantt chart includes it.

Could you elaborate on this?

>>What's wrong and how can I fix it?

What is your overall baseline? Do you have everything at the proper leveling for Project to calculate properly?

Please fill us in alittle more on where you are, and we should be able to help you out.

nfroio
0
 

Expert Comment

by:tchafin
ID: 2708913
I built a schedule in EXCEL after reading your question and found that after copying the column, select just the first cell in Project 98 and then paste in the Task name then copy your column with your start date and paste it to the Start Date in Project 98.  Doing them one at the time, and only selecting the first cell in Project. Project 98 will take into account weekends if any of the days fall on the weekend and it will adjust your dates accordingly.  It will also put a "Task cannot finish earlier than... constraint" on each one of your tasks.

Good Luck
0
 

Author Comment

by:FIT
ID: 2710898
Hi.
In Excel, I've 232 task rows.
I'll explain how to reproduce my problem, just with 2 task rows (+ 1 heading row) :

Tasks   Start End
Task 1  17/4  21/4
Task 2  24/4  28/4

I then open a new Project file and using the "entry" view, I paste XL A2:A3 to the first cell of "Task name" column. As a border effect, I get duration 1 day, start = today, finish = today.
Then I paste B2:B3 to the first cell of "start". I get the right start dates, duration is kept to 1 and the finish dates are set equal to the relative start dates.
Then I paste C2:C3 to the first cell of "finish". The Finish dates are now correct BUT:
* durations are set to 4 (they should be both 5)
* on the gantt chart, both bars go from mondays to thursdays, while 17/4 and 28/4 are both fridays.

That's what I mean by "do not include the finish date."

When I select (in Project) the finish date of a single task and choose the same date on the calendar pop-up,
1- a wizzard asks me if I want to link - choosed "without adding a link"
2 - duration is corrected to 5 days (as it has to be)
3 - the gantt bar goes from monday to friday (also correct)

As both start and finish dates remain the same, I do not understand why duration and bars are different.

I would like you to explain how I could do to have correct durations and bars on the charts without changing manually every finish date... with itself!

Thank you for your help.
0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2710924
You wrote: "But the gantt chart do not include the finish date. If I change manually the finish date to itself, "

Could you explain a little more how you reset the date exactly ?

I think this is an important piece of information.

I don't have Project myself, but am thinking of doing something on the Excel-side.

Cheers
Calacuccia

0
 
LVL 3

Accepted Solution

by:
DFI earned 200 total points
ID: 2710978
Hi FIT

It is actually a matter of internal storing of date values in the relative applications.
Inserting a date in Excel stores it as a DateTime value, on that date, at midnight (13/4/2000 0:00:00)
In Project,
* the start date is stored with a default (updatable - see below) start time (13/4/2000 8:00 - without seconds)
* the finish date is stored with a default finish time (13/4/2000 17:00)

When you paste the start date to MSP, the start time is corrected to the start time of the day
When you paste the finish date, it keeps the initial time value (i.e. midnight, from Excel) As if you planned free overtime.
As so, you do not plan to work on the normal working hours of your "last day", so the duration is 1 day behind.

You have first to know what are the default start and end time settings in your Project file :
* Tools/Options/Calendar.
* Read "default start time" and "default end time" values. Mine are 8:00 and 17:00
* Cancel

Then in Excel, write those values in cells and write formulas to add the start time to the start date and add the finish time to the finish date.

Example (copy/pasted yours and adapted):

Tasks   Start  End   8:00      17:00
Task 1  17/4   21/4  =B2+$D$1  =C2+$E$1
Task 2  24/4   28/4  =B3+$D$1  =C3+$E$1

If you copy
* D2:D3 to "start" column instead of B2:B3
* E2:E3 to "finish" instead of C2:C3,
duration and gantt should be what you are expecting.

Have fun with Project!

d:o)
0
 
LVL 17

Expert Comment

by:calacuccia
ID: 2710987
Boy, does my comment look stupid now :-)

I did not see your comment, FIT, when sending mine.
0
 

Author Comment

by:FIT
ID: 2711038
#@§$£ù&# company proxy server!
0
 

Author Comment

by:FIT
ID: 2711064
calacuccia,
maybe you have a huge connection time today, too ;)

DFI,
I'll test your solution. See you soon.

FIT
0
 

Author Comment

by:FIT
ID: 2711132
That's it!
Thank you very much for your help!
0
 
LVL 3

Expert Comment

by:DFI
ID: 2711690
You are welcome!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question