couple of rookie questions Microsoft Project |
- couple of rookie questions
- Office Update
- What is name of files providing Project VBA Help?
- Calculate % duration
- Gantt chart disappeared
- Summary Fields not Re-calculating correctly.
- View Resource Assignments
- Easy Question: Gantt bar split by . . .
- synching predecessor and successor dates based on F-S link
- looping task relationship
- Project server2003 trial
- Poor performance during tasks adding
- Extracting MSP_TIMEPHASED_DATA via ODBC connection to SQL Server
- New user needing advice
- Creating a shift work calendars
- Estimated Time to Complete (ETC) in MSP = Estimated Duration?
Posted: 04 Jul 2004 05:25 PM PDT Forget it I figured it out. |
Posted: 04 Jul 2004 05:07 PM PDT Hi Mike i've only got project 2003 on this machine so would be surprised if this wasn't the case :) Cheers JulieD "Mike Glen" <glenATmvps.org> wrote in message news:phx.gbl... |
What is name of files providing Project VBA Help? Posted: 02 Jul 2004 11:33 AM PDT Jack, Terrific. I was searching for *.hlp files ... didn't occur to me (as I slap my head!) to check for *.chm files. Thanks very much. rms JackD wrote: |
Posted: 02 Jul 2004 11:33 AM PDT That's what I was saying - in MS Project "% Complete" IS "% Duration" and is based on the duration worked compared to the total duration required. % Work Complete and % Physical Complete are two other fields, completely different. Perhaps I'm failing to see what you're trying to do here. Are you trying to compute the % complete that should have been reached by a certain date in order to compare it to the % complete that actually was reached by that date as an indicator if the project is on time? Not trying to be stubborn, I'm just concerned that you're coming up with a fancy number that will be useless or even misleading in terms of actually managing the project. If I'm guessing right as to what you're actually hoping to accomplish, that is, getting an indicator of whether the project is on time, the SPI, Schedule Performance Index, in the Earned Value fields does exactly that simply by displaying the field and you can have it calculated for any arbitrary status date, not just the current date. Summary tasks are a different critter from regular tasks in that much of their data is derived on the fly from their component sub-tasks rather than being stored in a field. In order to get your number fields to come out for the summaries, in the custom fields dialog turn on the "roll up to summary" radio button. The problem with your concept for summaries is that there values are not straight sums. I have a summary task that has 5 subtasks with 1, 2, 3, 4, and 5 day durations starting Monday. They are all linked start to start and are all scheduled to start the same day. The sum of the durations is 15 days yet the duration of the summary task is 5 days. The start of the summary is the earliest starting subtask while its finish is its latest ending subtask. It's now Thursday. What should your calculated "% duration" field show and what is its signifigance whether the project is on time since it doesn't take into account whther or not work that was scheduled has actually been accomplished? -- Steve House [MVP] MS Project Trainer/Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "ChrisO" <microsoft.com> wrote in message news:com... posting is misleading. All I want is a "% duration" column, but my problem is with the summary level tasks where "start" and "end" seem to come out as zero. For summary tasks do you know what variables I should access to obtain the start and end dates displayed on the Gantt chart view? Date]-[Start])/([Finish]-[Start]))*100) to find a setting or similar to get MS Project to do this automatically using an existing field. using custom fields which works at task level but not for summary level, where start and finish come out as 0. anything. |
Posted: 02 Jul 2004 11:19 AM PDT What sometimes happens is that you accidently drag the border between the task table window on the left and the Gantt timescale window on the right all the way to the right-hand side of the screen. Move your mouse slowly to the right of the screen and look for it to change into the 2-pointed arrow, Click and drag to the left and see what happens. -- Steve House [MVP] MS Project Trainer/Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "Don" <microsoft.com> wrote in message news:25bd801c46061$2c8d52d0$gbl... |
Summary Fields not Re-calculating correctly. Posted: 01 Jul 2004 10:05 PM PDT Luis, Thanks for posting, but I have to say I can't see the problem occurring on my Project 2002. Exactly what is the custom field type/name you are using? rms com wrote: |
Posted: 01 Jul 2004 12:00 PM PDT Janet, Ok, sorry I don't know anything about Web Access. Hopefully someone else can help. John |
Easy Question: Gantt bar split by . . . Posted: 01 Jul 2004 10:30 AM PDT Hi Jeremy. Better to send me the project - zip it up and email it to me. Mike Glen Project MVP "JeremyE" <microsoft.com> wrote in message news:com... the working calendar (1 day = 4.8 hours) and I changed the default working day to be from 12:12 pm to 5 pm to force the 4.8 hour day. Let me know if you need more info, but this is the only task doing it. If you want, I can email screen shots or whatever you would like. any in with 1 Tuesday. |
synching predecessor and successor dates based on F-S link Posted: 01 Jul 2004 09:54 AM PDT Ah yes. Forgot that one... Mark -- __________________________________________________ _______ Mark Durrenberger, PMP Principal, Oak Associates, Inc, www.oakinc.com "Advancing the Theory and Practice of Project Management" __________________________________________________ ______ The nicest thing about NOT planning is that failure comes as a complete surprise and is not preceded by a period of worry and depression. - Sir John Harvey-Jones "Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message news:%23zVgvj$phx.gbl... a the |
Posted: 01 Jul 2004 07:31 AM PDT Mark, Thanks for your reply. After making this query, I started remembering how I did this years ago. Your solution is definitely worakable, but part of the problem is that the developers are actually working on some of the code while the testers are testing, and vice versa. So doing a series of tasks as you suggest leaves availability in their schedules they don't really have. What we did before was to give the 2 tasks a SS+lag relationship, to reflect that test starts a few days, usually, after coding. Most of the time, they end at nearly the same time. Since you can only have one relationship between tasks in MS Project, you can't use a link to reflect this. Instead, I copy the finish date of coding and "paste link" it into testing. This way, if the process takes longer than planned, I just add duration to coding and testing extends out accordingly. BTW, this also avoids cluttering up the schedule with a plethora of code/test tasks, hard to tell apart from one another unless you also put in some text saying which code/test cycle this is. That in itself can be a lot of data entry. There is always many different ways of working around such problems in Project. Am always interested in other's solutions. David G. Bellamy Bellamy Consulting Durrenberger" <com> wrote in message news:<uC#phx.gbl>... |
Posted: 01 Jul 2004 04:13 AM PDT Have you taken the EPM tour at http://www.ms-answers.com/epm/home.aspx? Regards Mark Brownlee Orbisoft Task Manager 2005 Support mbrownlee -AT- Orbisoft.com www.orbisoft.com ** New! Orbsifoft Task Manager 2005 Group Task/ Project Management Software. Download the FREE, fully-functional 45-Day trial at www.orbisoft.com "The easiest and most comprehensive task manager I have seen." "Roger Knight" <microsoft.com> wrote in message news:2461a01c45f5c$5fe241f0$gbl... |
Poor performance during tasks adding Posted: 01 Jul 2004 01:30 AM PDT Hi, I am going to experiment your solution and it seems quite powerful...but the database structure seems quite complicated, so I'm reading carefully the "pjdb.htm" file. I wonder if and where I can find routines already written in order to add tasks or anything else to speed up my work. Any suggestion? Thanks for your precious help! Gabriele it (Gabriele) wrote in message news:<google.com>... |
Extracting MSP_TIMEPHASED_DATA via ODBC connection to SQL Server Posted: 30 Jun 2004 06:57 PM PDT Hi, I haven't ever finished extracting from the database because I felt the calendar data needed to be taken into account, so gave up on it and used other solutions. Either creating a copy of the data or using oledb from .mpp files, or when using Project Server: using the MSP_VIEW tables. Why is hourly refresh no good, especially if the schedule is only updated once a week or less? -- For VBA posts, please use the public.project.developer group. For any version of Project use public.project For any version of Project Server use public. project.server Rod Gill Project MVP For Microsoft Project companion projects, best practices and Project VBA development services visit www.projectlearning.com/ "WGHayes" <com.au> wrote in message news:40e8c339$adelaide.on.net... cant but actual requirements |
Posted: 30 Jun 2004 06:18 PM PDT Hi, I'm not an expert on Server but to my knowledge, no. Several people can update a project (with or without Server) but not simultaneously. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/index.htm 32-495-300 620 "Mark 123" <com> schreef in bericht news:xF2Fc.6204$xtra.co.nz... ************************************************** ************************** ************************************************** ************************** to management and and resource Global know Access templates), to |
Creating a shift work calendars Posted: 30 Jun 2004 06:16 PM PDT Hi Tony, Welcome to this Microsoft Project newsgroup :) You might like to have a look at my series of Microsoft Project lessons in the TechTrax ezine, particularly Lesson 12 - Working Pattern, at this site: http://tinyurl.com/2xbhc (Perhaps you'd care to rate it 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 "Tony Shoebridge" <microsoft.com> wrote in message news:2398001c45f09$1108cbb0$gbl... |
Estimated Time to Complete (ETC) in MSP = Estimated Duration? Posted: 30 Jun 2004 09:38 AM PDT Hi, You can find it in the "Remaining cost" field. Gérard Ducouret [Project MVP] PragmaSoft ® - Paris "JLE" <microsoft.com> a écrit dans le message de news:com... for |
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 |