Importing from Excel Project Template Microsoft Project |
- Importing from Excel Project Template
- Beginner Question
- MS Project 2003 crashes as soon as I show it on the projector
- table column header wrapping in Project Pro 2003
- Help: Lag time is being added when not called for
- Help: Moving dates for an items doen'st move dependant items
- Character limit in notes field
- Custom Fields in the GLOBAL.MPT Template
- Project Contingency
- Editing the Task information dialog box
- How can I calculate the npv and roi on project 2003?
- Multiple Projectplans
- Track material usage
- change format of custom field
- Priority not rolled up from subtask
| 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: |
| 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 |
| 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 |
| 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 |
| 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. |
| 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 |
| You are subscribed to email updates from TextNData Forums - Microsoft Project To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
