Restrict entry Microsoft Project |
- Restrict entry
- How do I make overdue dates change colour
- Project schedule consolidation
- Scheduling field techs
- How do I set up traffic light indicators in a Gantt chart?
- Cost in a Date Range
- flexible range of occurence of a recurring task
- Project Tasks as Outlook Tasks
- Link my Project calendar my Outlook calendar
- Can I run a report in Projects to find a circular relationship?
- Is it normal to have many base calendars defined?
- enterprise resource
- Enterprise fields VS Views
- Hold out on entering dates?
- Are calendars related to each others?
- How to take care interruption to a task?
- VB - Toggling the outline indent
- Template timelines starting at week -12
- Import data
- calendar & custom fields
- Reporting to Non-project users
- How to force project not to split a task over multiple days
- messy gantt charts and ordering tasks
- Comparing resource names in VBA
- Project Server has returned error code -1
| Posted: 11 Jul 2005 10:55 AM PDT Thanks Reid, As one Reid to another couldn't some VBA be written to restrict that? We would like to restrict the PM from changing the total 'Work' or 'Duration' by direct changes and only have then enter 'time to complete' on the task line when reporting time to extend or complete early a task. Does that make sense? Jim "Reid McTaggart" wrote: |
| How do I make overdue dates change colour Posted: 11 Jul 2005 08:37 AM PDT This NG deals with MS Project, not Excel. The Excel group is "microsoft.public.excel" Rita wrote: |
| Project schedule consolidation Posted: 10 Jul 2005 04:19 PM PDT Hi Max, Welcome to this Microsoft Project newsgroup :) You might also like to have a look at my series on Microsoft Project in the TechTrax ezine, particularly #17 & 18 on Multiple Project s, at this site: http://tinyurl.com/2xbhc or this: http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23 (Perhaps you'd care to rate the article before leaving the site, :) Thanks.) FAQs, companion products and other useful Project information can be seen at this web address: <http://www.mvps.org/project/> Hope this helps - please let us know how you get on :) Mike Glen MS Project MVP Max Currentus wrote: |
| Posted: 10 Jul 2005 03:59 PM PDT It depends - if those field techs are doing identifiable and quantifiable tasks in a project environment, sure. If they're doing ongoing line of business service calls, not really. The key is whether there is a schedulable piece of work with a concrete start and stop time at which point it can be said it's been done for all time. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "jbiasella" <microsoft.com> wrote in message news:com... |
| How do I set up traffic light indicators in a Gantt chart? Posted: 10 Jul 2005 05:49 AM PDT You're welcome, icabar, and thanks for the compliment :-) Mike Glen MS Project MVP icabar wrote: |
| Posted: 09 Jul 2005 07:14 AM PDT Hi, Excellent news! (Forgive me if I repeat things you might already know) Alt+F11 brings you to the VB Editor One of the toolbar icons is "Object Browser"Open it, look for Timescaledvalues object and TimescaleData method If you're oinly interested in data on task level (as opposed to the more detailed assignment level) the heart of your procedure could look like this Set TSV = mytask.timescaledata(mytask.start,mytask.finish,pj tasktimescaledcumulativeco st, _ pjtimescaledays,1) ...... 'Search for the position of start and end dates in the Timescalevalues 'I call them B and F mytask.cost2=TSV(F).value-TSV(B-1).value OK? Greetings De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Peter" <com> schreef in bericht news:#$phx.gbl... out 3 for de filter cost |
| flexible range of occurence of a recurring task Posted: 08 Jul 2005 09:51 AM PDT Hi Pinocchio, Sorry, not that I am aware of. In testing, even after adding additional tasks and editing the summary recurring task, it does not pick up the new project end date. I had to manually change the end date to equal the new end date of the project. There may be a way through VBA but I am afraid that is outside of my skill range. Perhaps another person(s) have a better idea. Hope this helps. Julie "Pinocchio" <com> wrote in message news:phx.gbl... |
| Project Tasks as Outlook Tasks Posted: 08 Jul 2005 08:57 AM PDT Hio, Allocatus has an option to show them as tasks OR appointments At least in their documentation (part of which I translated) -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "mobileindy" <microsoft.com> schreef in bericht news:com... the the up show up if |
| Link my Project calendar my Outlook calendar Posted: 08 Jul 2005 07:34 AM PDT Maurice, that's awesome - does exactly what I want it to. Many many thanks. |
| Can I run a report in Projects to find a circular relationship? Posted: 08 Jul 2005 07:02 AM PDT I found one summary task with a successor. Removed the the link and the project began to calculate one again. Catfish Thanks JDM "Jan De Messemaeker" wrote: |
| Is it normal to have many base calendars defined? Posted: 08 Jul 2005 02:13 AM PDT I tell my students that they should create a base calendar for each major shift group and legal jurisdiction in which their project takes place. Here in Canada, for example, the province of Ontario has different legal holidays from the province of Quebec so if my project has resources in both jurisdictions, I'll need at least one base calendar for each. If we work around the clock, I'll need a base calendar for my day-shift workers, another one for the swing-shift workers, and yet another for the folks on graveyard. So now we're up to 6. I'd pick one of those calendars, the one that is most generic, covers the majority of the workers involved in this specific project, or even the nominal work hours at the project's headquarters and make it the Project Calendar. Remember one of the basic uses of the Project base calendar is to answer the question of "if I have a task that can start Monday at 10am and will take 24 hours to complete, what date and time will it finish?" Since work, hence progress, can only take place when the resources are there to do it, the calendar is crucial to determining which of the minutes during the 24-hour clock-day will buy you some progress towards completion. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "Pinocchio" <com> wrote in message news:%phx.gbl... |
| Posted: 08 Jul 2005 12:02 AM PDT Gerard -- Thanks for the kind compliment! :) -- Dale A. Howard [MVP] Enterprise Project Trainer/Consultant http://www.msprojectexperts.com http://www.projectserverexperts.com "We wrote the book on Project Server" "Gérard Ducouret" <fr> wrote in message news:phx.gbl... |
| Posted: 07 Jul 2005 03:46 PM PDT Angel -- Out of curiosity, what are you trying to accomplish? The Microsoft Project Data Model governs the behavior of task, resource, and assignment fields. Here's how the Data Model works: Task fields are displayed in task Views, Tables, Filters, and Groups. Resource fields are displayed in resource Views, Tables, Filters, and Groups. Assignment fields are only displayed in the Task Usage or Resource Usage views. Hope this helps. -- Dale A. Howard [MVP] Enterprise Project Trainer/Consultant http://www.msprojectexperts.com http://www.projectserverexperts.com "We wrote the book on Project Server" "Angel" <microsoft.com> wrote in message news:com... |
| Posted: 07 Jul 2005 02:56 PM PDT 90% of all projects are date critical but that doesn't mean you should figure the dates outside of Project and pump them in as user input. Remember that Project's reason for existence is to calculate the start and finish dates of the tasks within your project. I like to think of it as "you don't tell Project the dates you're going to work, it tells you the dates you both SHOULD work and will BE ABLE to work." The fancy views and Gantt charts are just frosting on a piece of schedule calculation software but are not the reason it exists or the reason to use it. When you enter dates in the Start and Finish columns for your tasks, the Start date entry sets a "Start No Earlier Than" constraint and that says that under no circumstances will the task ever be scheduled to start earlier than that date. BUT it can be pushed later than that date no problem. The same for entering a date in the Finish column - it sets a "Finish No Earlier Than" constraint. If you enter both dates, the constraint is determined by the last date entered. Tasks can only happen when the predecessors and resources come together so that everything required to do the work is in place. You might have a commitment on 1/1/05 but the promise of delivery is not in itself enough to make it happen - there are a myriad of other things that have to happen for it all to come together on the 1st. Project's job is to take the was you organized the work at the moment and tell you if you'll finish on schedule or not. If not, it tells you the date you will hit the way things are presently organized and a model that will let you experiment with changing the organization - rearranging resources, for example - to come up with a strategy that WILL have it hit the promised dates. The hard dates you mention should be entered as deadlines. Project will monitor them and tell you if the plan as you have presently entered it will meet them or not. In the best of all possible worlds, you'd build the plan in Project BEFORE agreeing to the commitment dates with the customer, prior to negotiating the contracts, using the project schedule to determine what is realistic and doable before promising the moon, but most of the time we don't have that luxury unless you're lucky enough to work for a project-driven company that has learned the wisdom of that approach. I'm sure you feel that your situation is unique and you can't work the way we suggest but believe me, it's not. If you try building the plan by entering specific dates on which the tasks will take place it will be a miracle if you end up with a usable schedule. I have yet to see an example of such an approach that didn't end up with a "wishful thinking" plan that bore no resemblance to what actually happened in reality when the project was worked. Often it's a waste of the time spent building it because the resulting plan was useless for real world work scheduling, failing to allow proper progress monitoring, or to alert for emerging problems. Trust us, you'll have a far better shot at hitting those "must hit" commitment dates if you try it our way - we've been there before. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "bob" <com> wrote in message news:com... |
| Are calendars related to each others? Posted: 07 Jul 2005 02:48 PM PDT Very, very clearly put! -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Pinocchio" <com> schreef in bericht news:phx.gbl... just calendar time. |
| How to take care interruption to a task? Posted: 07 Jul 2005 12:12 PM PDT Work and duration are totally different measures even though both are counted using the same units. Duration is *defined* as the total possible working time between when the task starts and when it finished, regardless of whether work is actually taking place continuously thoroughout that time or not. Therefore you can't change the finish date and have the duration not change for the same reason that you can't say 7 minus 4 equals 2, it's simply not mathematically correct. On the other hand, work is the portion of that time actually being converted into useful output. So if your finish date changes, the duration MUST change because that's simply what duration IS, the time between start and finish but Work can remain constant even as the finish date changes. The resource is just working on that task at a lower average rate with the new finish date. In your example, the task duration started out as three days and the resource was working at 100%, doing 3 day's work over the course of 3 days duration. Now the finish date is pushed back by 2 days because the resource's work on it is interrupted. He's still generating the same 3 days worth of output. So now he's doing 3 days of work over 5 days of duration for an effective effort units percentage of 60% HTH -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "Peter" <microsoft.com> wrote in message news:com... |
| VB - Toggling the outline indent Posted: 07 Jul 2005 10:41 AM PDT Leo, You cannot use a named argument in an "if" test. DisplayNameIndent" is a named argument to the OptionsView function. There is no property in the object model called "DisplayNameIndent", so you can't use it to check the state of the name indent. In fact, there is currently no property in the Project object model that corresponds to the field in the dialog box. Check out the following article for a list of the fields in the dialog box that DO have properties associated with them: http://www.microsoft.com/technet/scriptcenter/topics/office/manage/project/projectvi.mspx Best you can do is set the value using the OptionsView method, and set some other variable or custom property to keep track of its state. Good luck! Kevin "Leo" wrote: |
| Template timelines starting at week -12 Posted: 07 Jul 2005 09:23 AM PDT Hi Debbie, DateDiff("ww", [Date1],[Date2], 1) interval = "d" for Days, "ww" for weeks.... Replace Date1 and Date2 by any date field. firstdayofweek = 1 for Sunday; 2 for Monday (optional) Hope this helps, Gérard Ducouret "Debbie G" <microsoft.com> a écrit dans le message de news:com... Can and tasks MS can |
| Posted: 07 Jul 2005 09:19 AM PDT Both. As needed - and programmatically. As to format - that is also what I need to know - in order to import the data - how do I format the transfer? "Brian K - Project MVP" wrote: |
| Posted: 07 Jul 2005 07:43 AM PDT Hi, Format, Bar Styles, Text Field(s) HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Amy" <microsoft.com> schreef in bericht news:com... view? |
| Reporting to Non-project users Posted: 07 Jul 2005 06:47 AM PDT Hi, I don't understand. I don't have Adobe, but I use one of these free pdf things called cutepdf and it works. PDF printers are supposed to print the same you would have on paper aren't they? Does it work on paper? -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "spidersinthekitchen" <microsoft.com> schreef in bericht news:com... range. the about sheet to Ideally have am I |
| How to force project not to split a task over multiple days Posted: 07 Jul 2005 02:14 AM PDT You're welcome, and good luck! :-) Mike Glen MS Project MVP latearrival wrote: |
| messy gantt charts and ordering tasks Posted: 06 Jul 2005 10:13 PM PDT You're welcome, Gemma :-) Mike Glen MS Project MVP gemma wrote: |
| Comparing resource names in VBA Posted: 06 Jul 2005 04:12 PM PDT In article <com>, Kevin Towers <microsoft.com> wrote: Kevin, First, let me answer your last question. Visual Basic has several methods that can be used to compare strings. The best method to use depends on what kind of strings (i.e. whole string, middle characters, single character, etc.) are being compared. I use the Instr Function quite often but I also use a simple If statement (e.g. If t.Text1 = "bob" Then). I haven't studied your code thoroughly but on the surface it seems a little backward. The resource loop and task loops are not helping each other. The outer loop will go through all resources, not just those that are assigned to each task. In effect, if the runtime error didn't occur, Flag5 will be set true for all tasks (or at least those tasks with resource assignments). I don't think this was your intent. I agree with Brian's response. Loop through the tasks and look at the assignment property when comparing. Also, I thought you wanted to look for a particular resource who was assigned to all tasks in a given date range. If so, some type of input is needed from the user to specify which resource. For this I would use an InputBox Function. Finally, without actually testing your code, I suspect the runtime error occurs because normally there are no assignments on Summary Lines. When the inner loop goes through the tasks the first one is likely to be a Summary line and hence there is no resource name associated with the task. Hope this helps. John Project MVP |
| Project Server has returned error code -1 Posted: 06 Jul 2005 04:11 PM PDT Ups! Sorry Project Server 2003 in English and the error its send when update task from Microsoft Outlook Calendar "Mike Glen" wrote: |
| 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 | |
