More Help Setting up School Homework Project

[Joeboo]

Hi Prasad ,

I think for now that VBA is a huge can of worms. haha , I think what I
want is sortof simple. I'm shocked that I'm the only one who's asked for
it before....


Julie,

Thanks I've read thru that chunk of code and Understand it a bit more.
I'm reading up on how to make the [actual start ] populated . and I'm
having a bit of trouble with it.

are there any fields that are populated by simply the network diagram?


for the output. I just want a number showing the number of days,
instead of the calendar date.

right now my Network diagram looks ghetto , I've printed it out. but
have crossed out the numbers generated by MSP and have hand written them
in. haha .

I can email you the project file if you have time to help me more

 

[JulieS]

Hi Joeboo,

My comments are inline below.

"Joeboo" wrote in message >

I'm reading up on how to make the [actual start ] populated . and
I'm
having a bit of trouble with it.

[Julie] Actual start shouldn't be populated until you've finished
planning the project, saved a baseline, and transistion from
planning into the execution phase of the project. The actual start
is most easily populated (in my opinion) by showing the Tracking
table applied to the task sheet (left side of the Gantt or Tracking
Gantt view.) I'm not sure what you are trying to calculate through
the formula so it's tough to advise further. What are you trying to
calculate? Are you still working on changing the format of the
start date and finish date to show numbers or is this something
else?

If you are trying to show numbers which count the number of days
from the beginning of the project, try the formulas below:

To calculate the number of days the Start of a task is from the
Project start date, add the following formula to a text field:

ProjDateDiff([Project Start],[Start])/[Minutes Per Day]

To calculate the number of days a finish date is from the Project
start date, use the following formula in another text field:

ProjDateDiff([Project Start],[Finish])/[Minutes Per Day]

Without the "7Day" calendar, it will count working days. If your
intention is to show this in the network diagram, you do not want to
count non-working time.

are there any fields that are populated by simply the network
diagram?

[Julie] The network diagram doesn't "populate" fields per se. The
network diagram is just a view showing data from the project file.
If you've entered the task name and duration, Project calculates the
task start and finish date. As you add more tasks to the network
diagram, all the start dates will be the same, the start date of the
project. You then create the links (predecessor/successors) and
project recalculates the start and finish dates.

for the output. I just want a number showing the number of days,
instead of the calendar date.

[Julie] What output? The result of the your formula? Try the
formulas above and see if that is what you are looking for.

right now my Network diagram looks ghetto , I've printed it out.
but
have crossed out the numbers generated by MSP and have hand
written them
in. haha .

[Julie] See if the formulas above calculate what I think you are
looking for. Create a new style in the network diagram and add the
fields you've calculated. See if that helps.

I can email you the project file if you have time to help me more

[Julie] Try the formulas first and let us know if that works. Feel
free to post back with questions.

Joeboo

<snip>