Pages

Search

Importing from Excel Project Template Microsoft Project

Importing from Excel Project Template Microsoft Project


Importing from Excel Project Template

Posted: 13 Dec 2004 08:33 AM PST

Hi Trac,
Where did you get the Excel template? Without seeing the Excel template, it
is tough to know if the template can be modified with additional information.

You may import any excel spreadsheet into MS Project, but you'd have to map
the fields manually. Depending upon the number of tasks in your project, it
may be more efficient to simply copy and paste or manually enter the priority
information in to the project you imported. The name priority shouldn't be
causing the problem and when I tested a sample import, the name priority in
the Excel file just simply meant that project guessed correctly the field in
import the data into.

Hope this helps. Let us know how you get along.

Julie
"Trac Taylor" wrote:
 

Beginner Question

Posted: 13 Dec 2004 06:30 AM PST

Theoretically, resources don't have anything to do with task
dependencies. Forget the resources for the moment. Lay out your tasks
with the order they should occur worked into your dependencies. For
instance, at a high level in software development, you create the
requirements, THEN create the design, THEN generate the code, THEN test
it. After you have all of your tasks laid out and the dependencies
created where necessary (every task should have at least one
predecessor and at least one successor, even if it's start and finish
milestones - any that don't are widows or orphans), then assign
resources and amounts of effort (work). Then you can add resources and
SPLIT the amount of effort (work) between the two resources to shorten
the duration of the task.

Sarah

MS Project 2003 crashes as soon as I show it on the projector

Posted: 10 Dec 2004 08:53 PM PST

Hi Michael,
I'm afraid I don't have many other "guesses" for you. Do you know what the
overhead projector's preferred resolution is? I'd suggest setting your
screen resolution to the projector's preferred resolution, launch project and
see if project is stable. Then I would exit project, try connecting to the
overhead and try launching project again.

Hope this is of some help or someone else leaps in with the "perfect" answer.
Julie

"Michael" wrote:
 

table column header wrapping in Project Pro 2003

Posted: 10 Dec 2004 06:49 PM PST

Hi Ray,
Glad to have helped. Let us know how you get along.
Julie

"rayroberts01" wrote:
 

Help: Lag time is being added when not called for

Posted: 10 Dec 2004 01:49 PM PST

The FS link says when the earliest the sucessor can start, barring lead
times, but it could start later. One cause is that it has to wait until the
next working time - the predecessor finishes Friday at 5 and the successor
can't start until Monday because that's the next working time according the
the project calendar. Another cause might be that the calendar of the
resource assigned to the sucessor has him unavailable until some period of
time after the predecessor ends. Or it could be that leveling is set to
automatic and the resource on the sucessor is already assigned to another
task at that time slot so the task in question has to move until he's free.
There may be other ways the successor would end up starting later than the
link would otherwise have it but those are some of the most common.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

..
"Dab" <com> wrote in message
news:phx.gbl... 

Help: Moving dates for an items doen'st move dependant items

Posted: 10 Dec 2004 01:42 PM PST

Hi Dab,

I'm afraid you're not missing something, you must have overdone it.
Because Project is supposed to do exactly what you want.
There are ways to block it though, and you must have gone one of the
following paths:

- Verify whether in Project, Project Information, the option is calculate
from start date
- Verify whether in Tools, Options, Calculation, Calculation is set to
Automatic (as opposed to Manual)
- Tasks with a strong constraint like MUST start or finish do not move even
if there are 33333 predecessors; Finish no later than constraints block the
task once the constraint comes into play.
- Once a task has an Actual Start set it won't mobve any longer. Project
will change your pla, not your history (that is what actual data are about)

Make your choice... it's definitely one of those.

HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"Dab" <com> schreef in bericht
news:phx.gbl... 
question: 


Character limit in notes field

Posted: 10 Dec 2004 11:11 AM PST

In article <#phx.gbl>,
"JackD" <momokuri@gmail> wrote:
 

Jack,
No, you are not confused. Go to File/Page Setup/View tab. Just check the
box for "Print Notes".

Andy,
Trailing off in the Notes field on a view is caused either by,
characters in excess of 256 or line feeds or carriage returns in the
Notes text. If you print notes as suggested above, you shouldn't have
that problem.

Another method that I have employed is to use VBA to export the notes to
Excel. If you are interested in that, write me direct.

Hope this helps.
John

Custom Fields in the GLOBAL.MPT Template

Posted: 10 Dec 2004 09:37 AM PST

Yes. The Views and the Tables tabs show the newly created View and
Table in both the GLOBAL.MPT file and the current .mpp file. But the
Fields tab only shows my new fields in the GLOBAL.MPT file. Kinda
strange that the the Views and Tables act differently than the Fields.
Oh well...

I guess I will have to train my users to fix their older existing .mpp
files using the Organizer. I was hoping to avoid that but it sounds
like that is my only option.

Thanks for your help.
Stephen

Project Contingency

Posted: 10 Dec 2004 07:39 AM PST

Hi,

If your "date including contingencies" can be set as custom firlds (Start7
or Date4 or;..) ontask level, Format, Bar Styles, will allow you to draw any
bar between two of these dates and you will haev a graphic comparison.
The Bar Stylese of the Tracking Gantt may inspire you.
HTHdates

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"GG" <microsoft.com> schreef in bericht
news:com... 
through 
help I 


Editing the Task information dialog box

Posted: 10 Dec 2004 07:35 AM PST

Thanks John,

Splitting the window with the pane at the bottom is what I was looking for.

"John" wrote:
 

How can I calculate the npv and roi on project 2003?

Posted: 10 Dec 2004 06:57 AM PST


"John" <com> wrote in message
news:microsoft.com... 
investment 

John is right. You can calculate NPV in project, but it would require coding
the entire function from scratch in VBA. Further, you would have to find a
way to model things like revenue and depreciation which Project does not
deal with by default. I'd just use excel. The financial functions are
already predefined there.

With a little work, you can have both a schedule and financial calcs in
excel. See my excel schedule page for a starting point.

http://masamiki.com/project/Excel.htm

You could use that to model your tasks and then do some work to add costs to
it. Summing the columns would give you your monthly cash flows.

-Jack


Multiple Projectplans

Posted: 10 Dec 2004 04:36 AM PST

In article <41ba9203$bluewin.ch>,
Kay Schulz <com> wrote:
 

Kay,
You're welcome. I'm glad we could be of assistance.

John

Track material usage

Posted: 09 Dec 2004 08:07 PM PST

I agree with you that materials are infinite, but we still need to know
when to order for new material. Let me give you an example. Now i have
a schedule which spans till 2008. The tasks listed in the schedule use
these materials. But we cannot have all the materials right now. It has
to depend on the consumption, and the consumption again is not fixed.
So lets say we have 100 units in the begining, but my schedule requires
1000 units. And suppose in between some tasks require more than planned
or new task is added. In that case i need to know the actual
consumption so that i know or predict when to order for new materials
or by what date the present stock will get exhausted.
I guess that clears my actual problem.

change format of custom field

Posted: 09 Dec 2004 05:09 PM PST

Hi SeeFar,
If the custom field is a number field, it will not accept alpha characters.
Data entered into a custom field must match the data type of the field. If
the custom field is a number field, you will need to insert a Text field,
copy and paste the values from the number field and then you should be able
to add your alpha text to the numbers.

Hope this helps. Let us know how you get along.
Julie

"SeeFar" wrote:
 

Priority not rolled up from subtask

Posted: 09 Dec 2004 03:15 PM PST

Hi,

As long aas you do not assign resources to the summary tasks (which by all
means would be the fastest road to catastrophy) Leveling will ignore them
completely.
HTH

--
Jan De Messemaeker
Microsoft Project MVP
+32 495 300 620
http://users.online.be/prom-ade
"TraceyH" <microsoft.com> wrote in message
news:com... 
up 
do