kindly look in to the discussion:- Weird bug in MS Project 2003 Microsoft Project |
- kindly look in to the discussion:- Weird bug in MS Project 2003
- How do I set a milestone at the end of a task duration?
- Creating standard report in Project
- MSProj : Resource Usage View : why is "Text3" column is <empty>
- Project 2003 Resource loading
- high level resource reports
- Error Updating Embedded Data Objects
- Financial Week Number Shift Start
- multiple standard working time
- Updating a Project schedule through an import
- Simple Problem
- No WBS in Resource Usage view ??
- Get Report to show project name in "Who Does What & When" report
- Daily "to do" report
- Automatic date change after a value has exceeded a certain point
- How do I prevent task numbering of additional rows of same task?
- Task needs simultaneous resources
- Project saved as database vs a XML file
- Cost Field vs. Customized Cost Fields
- Project workaround for Effort-Driven Resourcing Re-Calc Issue
- Adminstrative Tasks
- Earned Value Analysis: 50/50 Technique
- Regarding IIS FTP Server
- create a view like task usage
- Project Professional 2003 Authentication
kindly look in to the discussion:- Weird bug in MS Project 2003 Posted: 03 Jan 2006 10:21 PM PST It is. What is your point? "kant" <microsoft.com> wrote in message news:com... |
How do I set a milestone at the end of a task duration? Posted: 03 Jan 2006 02:20 PM PST Format Bar Styles Look for the Milestone line In teh From and To columns replace Start by Finish HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "db8791" <microsoft.com> schreef in bericht news:com... it there |
Creating standard report in Project Posted: 03 Jan 2006 01:16 PM PST Hi Summer, Below are two potential approaches you might consider. Play around with them and discover some of the filtering options so you can set them up the way you are comfortable. -Bill My preference for generating these 'reports' is to use the Excel output feature. Here is an example: 1) Go to File->Save As...->Excel Workbook. Enter a filename, then click next and choose "Selected Data". 2) Choose "New Map" (once this process is complete, you can choose 'Use Existing Map') a) Choose "tasks" (you can play around with resources and assignments once you get the hang of this). Also, choose "Export includes Headers". Click Next. b) In the Destination Worksheet name, type "All Tasks Forecasted to Begin". c) For the filter, choose "Date Range". d) Add some fields (i.e. Name, Start and Finish) e) Click Next. f) Click "Save Map" and type a name like "All Tasks To Begin After..." g) Click "Save". h) Click "Finish". i) Find the Excel file you selected earlier and you will find the fields output the way you want. The next time you run the report, use "Selected Map" so you don't have to go thru all the steps listed above again. Also, during this process, you can modify the map and save over it (maybe you wish to add more fields, adjust date filters, etc.) Another example of this would be to use the out-of-box reports in Project Server. Modify or create a view in Project Professional and create a filter to display certain information. This example will step you through modifying the "Gantt Chart" view to create your reports. I will use the Sample #1 again. 1) From the View menu, first select "Gantt Chart". Then, also from the View menu, choose Table->Entry. 2) Add or remove any columns until the data for your report is displayed. 3) Go to View->Reports. a) You could select a report that already requests a date range, like Current Activities...->Tasks Starting Soon. b) You could also continue with the rest of these steps... 4) Choose "Custom" 5) Click "New..." and name the new report "All Tasks To Begin After...". (next time, your report will show up so you don't need to create a new one again). 6) Make sure the Table area is set to "Entry" and set the Filter to "Date Range...". Click OK. 7) Now you can Preview or Run your report. As you will notice, using out-of-box reports is not quite as flexible as using Excel. This is because the reports sometimes are difficult to fit on one page or you want to edit the data or make other modifications that are difficult unless you are using Excel. Hope this helps, -Bill -- William Raymond BLOG: http://www.mympa.org/blog.aspx "Summer" <microsoft.com> wrote in message news:com... |
MSProj : Resource Usage View : why is "Text3" column is <empty> Posted: 03 Jan 2006 10:54 AM PST Thank you Glen -- the answer is PERFECT. My PM thanks you a million, too. :-) "Mike Glen" wrote: |
Posted: 03 Jan 2006 10:51 AM PST Hi, Do files in sharepoint have a "normal" address? If yes, you can link them to a pool on any server they can "see" and that can "see" them. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Woody" <microsoft.com> schreef in bericht news:com... site: http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AU TH=23 seen at so allocations some |
Posted: 03 Jan 2006 10:50 AM PST John Thanks for the fast response. Let's see, any task might have all 4 categories or it might only have 3 or 2 categories. Also, the L (Labor) category is the only resource group that is broken out by people that needs to be summed. P, T, and C are already lumped together. To the other question, Department 2 wants to see all the labor lumped together but since C, P, and T are already one big "lump" per tasks it does not need to be broken down. Currently, P, C, and T are resources that were created along with all the employee names. So in my small example I wrote before our resource sheet shows: Mary Sally Chargebacks Travel Purchases So I think MSP cannot see that the last 3 resource entries are not people but are unique categories unto themselves. Does that help? Thank you so much for your continued help! "John" wrote: |
Error Updating Embedded Data Objects Posted: 03 Jan 2006 10:38 AM PST I had intended it to be in the powerpoint area right above Project. Mouse slipped. My appologies. -- Fred Garvin San Antonio, TX "Mike Glen" wrote: |
Financial Week Number Shift Start Posted: 03 Jan 2006 07:42 AM PST Thanks John Shifting the production week won't work in this isnatance as I'm running a pooled network with multiple projects, which will be ongoing across year ends. So come September/October next year I'd be back in the same position. Writing specialist VBA code is beyond my ability at this time and I can ill afford the time. So, exporting to Excel and converting the week numbers there was pretty much where I had got to. Clumsy, but effective! Tris "John" wrote: |
multiple standard working time Posted: 03 Jan 2006 07:40 AM PST Hi, Concretely you can do it this way: Through Tools, Change Working time, New, create the number of base calendars you need to reflect standard times in each geography (you could call them "Western Europe", "Middle East" etc.) Then in the resource sheet view, for each reaource, in the "Calendar" column, select the desired "standard". HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 <com> schreef in bericht news:googlegroups.com... |
Updating a Project schedule through an import Posted: 03 Jan 2006 07:24 AM PST Hi, On top of John's precious advice: if it is really about updating (like adding figures to work field f.i.) you will definitely need VBA. IMHO that is the route to take from the start. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Laura Guffey" <microsoft.com> schreef in bericht news:com... labor by provide the |
Posted: 03 Jan 2006 04:48 AM PST hi jan... thanks for your note. The calculation was set to manual... once i changed to augomatic everything worked fine!. thanks for help! Lloyd "Jan De Messemaeker" wrote: |
No WBS in Resource Usage view ?? Posted: 03 Jan 2006 01:39 AM PST Easy. There are THREE kinds of text fields, they are not linked to a VIEW but to an OBJECT Tasks have text fields, Resources have text fields and ASSIGNMENTS have text fields. Task usage shows Taks and assignments Resource usage shows resources and assignments (so task usage DOES NOT show resources and resource usage DOES NOT show tasks!!!) Assignment text fields thus are visible in both views. Fill a text field (f.i. by coopying from a task field) in the task usage view and it will be visible in Resource Usage and vce versa. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "kant" <com> schreef in bericht news:com... |
Get Report to show project name in "Who Does What & When" report Posted: 02 Jan 2006 01:02 PM PST Hi John, Thanks I will use that for now Bert "John" wrote: |
Posted: 02 Jan 2006 10:36 AM PST Hi Doschmo, Also, you might like to have a look at my series on Microsoft Project in the TechTrax ezine, particularly # 17 & 18 on Multiple Projects, 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 articles 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 Jan De Messemaeker wrote: |
Automatic date change after a value has exceeded a certain point Posted: 02 Jan 2006 03:28 AM PST Thanks. SO it'll have to be with vba. Laura "Jan De Messemaeker" wrote: |
How do I prevent task numbering of additional rows of same task? Posted: 02 Jan 2006 01:45 AM PST Hi M-Squared, Why not continue the description in the Name field and widen the row to show it? FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm Hope this helps - please let us know how you get on :) Mike Glen MS Project MVP Jan De Messemaeker wrote: |
Task needs simultaneous resources Posted: 01 Jan 2006 11:39 PM PST Hi, You must have assigned the machine a a material resource instead of a work resource. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "WillBuochs" <microsoft.com> schreef in bericht news:com... acheived calendar. then I be task another (or It workaround, tasks, based allocates |
Project saved as database vs a XML file Posted: 01 Jan 2006 07:40 AM PST Sorry once again. It seems that I have found the answer on my own. To associate a task with a custom cost through an Access database you need to associate the TASK_UID in the MSP_TASKS table with the NUMBER_REF_UID in the MSP_NUMBER_FIELDS. thanks anyway "glenn" wrote: |
Cost Field vs. Customized Cost Fields Posted: 31 Dec 2005 09:52 AM PST Hello, First off, thanks to you folks for responding to my sketchy question on how to handle costs in Project. I guess I forgot to mention that I am not using resources with any given pay rate and instead I am just applying a cost for material and labor and sub-totaling a cost for each task in my own custom field called 'Total Cost'. It sounds like I will need to transfer these figures into Project's 'Cost' field with a macro. In so doing, it would be my understanding that I would be able to have Project's other cost related fields such as 'BCWP', 'BCWS', 'ACWP', 'EAC', 'VAC' and other earned value fields to receive their respective values as a project's schedule moves forward. Thanks for the link to the MVP site. and Thanks for your help... "Rod Gill" wrote: |
Project workaround for Effort-Driven Resourcing Re-Calc Issue Posted: 30 Dec 2005 01:50 PM PST Hi extremetray , Welcome to this Microsoft Project newsgroup :) You might like to have a look at my series on Microsoft Project in the TechTrax ezine, particularly #10 Multiple Resource Assignments, 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 extremetray wrote: |
Posted: 30 Dec 2005 07:59 AM PST In article <com>, "Jeff Cecil" <microsoft.com> wrote: SJ Digriz, You're welcome. Just for reference, at our company each program had their own WBS that defined a structure for our Project files. An actual charge number (as used by employees on their timecards) was the next level below the WBS structure used for the program Project files. In some cases a particular task in a project file might in fact be represented by a specific charge number, but generally, the charge numbers were too low a level for tracking in Project - that's what our financial system did - and it was much better at it. In the case of support/administrative effort from functional organizations, their effort would show up in the actuals for the program but there was no specific task in a program Project file that tracked their support. That worked because their effort was generally minimal - after all, it was just support. However any significant effort on the program, including program management, program business personnel, etc. was represented by tasks in a Project file. If the effort was not readily measurable, it was shown and tracked as level-of-effort (LOE). The above approach allowed us to keep Project files at a manageable level yet had a full accounting trail for all program costs. John Project MVP |
Earned Value Analysis: 50/50 Technique Posted: 30 Dec 2005 05:35 AM PST I agree with Trevor. And I agree with John. It can balance out, it you have enough overlapping tasks. Let's take an extreme example of what can happen though. Let's say you have one long duration (3 mo.) task that starts 1 month into the project. While AV is acruing each month, we see no EV acrual on this task until month 3 (2 months after it started and the first month after it passed 50% completion). Such a task would work better if it's a 40/60 or 25/75. Other lower cost tasks will somewhat dilute this effect. But it could easity obscure some other problem EVA would normally illuminate. On a 6 mo project, that one month of inaccurate data could very easily be crucial to overall project success. This is why granularity is so important in EVA. To some extent, this problem can be minimized by doing EVA on weekly or bi-weekly basis on short projects like this. But the issue should be addressed to make sure you're getting what you need from doing your Earned Value. |
Posted: 30 Dec 2005 04:05 AM PST Hi Latha, You could try microsoft.public.vstudio.general. Good Luck and a Happy New Year:) Mike Glen Project MVP Latha wrote: |
Posted: 29 Dec 2005 04:19 PM PST In article <com>, familyman <nospam> wrote: Rob, For your reference a dynamically consolidated master, (i.e. subprojects linked to the master, which is the default), does not actually contain the subproject tasks. The master simply contains a summary line representing each subproject and a pointer to the actual independent subproject file. That's why a simple export of the master will only export data that is resident in the master itself. There are a couple of ways around this limitation. One is to separately export each subproject as you mentioned. Another is to use VBA to export all the data (master and subproject) to another application (e.g. Excel, Access, etc.). I use that method a lot. You could also use SQL directly on the Project database, although I've never done that but for reference, a description of the Project database structure can be found on your hard drive - look for projdb.htm. Yet another possibility is to create a static master. With a static master, the subproject data IS inserted directly into the master and it becomes one large independent file. However, a static master is a snapshot in time because the subprojects are no longer linked and to update, a whole new master needs to be created. External links between files, if any, are not preserved in a static master unless a special macro is used to convert them. Hope this helps. John Project MVP |
Project Professional 2003 Authentication Posted: 29 Dec 2005 01:56 PM PST Hi S, Try posting on the server newsgroup. Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm Mike Glen Project MVP SGibbs 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., 1600 Amphitheatre Parkway, Mountain View, CA 94043, United States |