Turn off Export Map Wizard Microsoft Project |
- Turn off Export Map Wizard
- how to add a billing rate which is different from the cost rate?
- update task by email
- Custom Text Fields and Formulas
- How do I change default duration from days to hours
- task/sub task not applicable in MS Project 2000
- Consistent Display of Duration
- Make Microsoft Project work through Windows CE
- Application Error
- Problem with "Export to Excel"
- where can i find an easy to understand 'which version of project do you need' web page
- OT: Message for JulieS
- Time Calculations
- Launch MS Access from Project and open a report
- Tracking "Out of Office" Resources
- Unable to open entire project via ODBC to SQL server
- Creating a team project plan by % worked per month
- Importing and Exporting
- Heresy - how to prevent Project from calculating/changing dates
| Posted: 20 Jan 2005 02:07 PM PST Hello MEd, Quite simple : that's a VBA macro that you can record. Just add the Application.Alerts False method Gérard Ducouret Example : Sub Mapping() ' Macro Recorded 21/01/05 00:22 by Gérard Ducouret. Application.Alerts False FileSaveAs Name:="C:\Documents and Settings\PragmaAdm\Mes documents\PragmaSoft.xls", FormatID:="MSProject.XLS5", map:="Top Level Tasks list" End Sub "MED" <microsoft.com> a écrit dans le message de news:com... them I |
| how to add a billing rate which is different from the cost rate? Posted: 20 Jan 2005 12:53 PM PST Tks Julie, it worked.... partially: Before, I did not divide [Work] by 60. Now it works, although I don't understand why I should do that since [Work] is already set as hours in my project. My problem now, is that I cannot have the billing rate at the resource level and the billing budget at the task level + details at the resource level: If billing budget is a Task type custom field, I cannot use the billing rate in my formula if it is set as a Resource type custom field. If Billing budget and billing rate are both resource types, I cannot see the task details of my billing budget. In fact, I can only see the total billing budget of my resource in the Resource sheet. If Billing budget and billing rate are both task types, I cannot see the resource details of my billing budget. What I really want is to reproduce the Cost scheme, but for billing. Do you have a solution for this? Juliem ***** "JulieS" wrote: |
| Posted: 20 Jan 2005 12:19 PM PST Dear JulieS Thank you for your information, i did it the way that shows the article. Now i believe that I have a bug or something, here is my test that I did so far: "as a test I created a test project file with three task. (one day = 8 hous of work) task 1 -- 1 day -- start today task 2 -- 1 day -- start tomorrow task 3 -- 1 day -- start the day after tomorrow. Now, I assign me for those three task. I send, ONLY for the task 1, a "Request progress information..", i recieved the email myself, i type 8 hours of work to simulate that the work was complete today, I sent the update. Later i recevied the update and I update the project file. Now, when I click update project (from the email), my project file is open, BUT here is the problem, this automatization add ONE more day to the task 1, and mark 50% complete, when I supposed to mark 8 hours or 100% complete. This increment all other task since are linked. this is a bug, or not. Also, i would like to send by email, the % completed of the task, and NOT the HOURS of some day. Where i can modify that???? By the way, I installed Project Prof. 2003 instead standar 2003. Thanks, "JulieS" wrote: |
| Custom Text Fields and Formulas Posted: 20 Jan 2005 10:13 AM PST Hi Jack, Brilliant! So much more elegant than my solution. ;-) Julie "JackD" wrote: |
| How do I change default duration from days to hours Posted: 20 Jan 2005 07:55 AM PST Hello Ray : Tools / Options / Schedule / Duration is entered in... Hours Set as Default Gérard Ducouret "Ray Stevens" <com> a écrit dans le message de news:eoeExhw$phx.gbl... hours. |
| task/sub task not applicable in MS Project 2000 Posted: 20 Jan 2005 07:35 AM PST Don't know why, but that is exactly what she dpes not want to do - hence teh question for an alternative -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/index.htm 32-495-300 620 "Sarah" <com> schreef in bericht news:googlegroups.com... |
| Consistent Display of Duration Posted: 20 Jan 2005 06:45 AM PST Hi FlyingPM, <vbg> Thanks very much for the feedback . Glad to know you are back in the air - here's hoping for no more turbulence and just remember to keep your safety belt fastened! Let us know if you can help in the future. Julie "TheFlyingPM" wrote: |
| Make Microsoft Project work through Windows CE Posted: 20 Jan 2005 06:21 AM PST Hi Cory to pass feedback onto micrsoft you can send them an email at com with the name of the product in the subject line and a "detailed" explaination (ie business case type thing) of what enhancements you would like and why .... and you never know ............ Cheers JulieD "Cory" <microsoft.com> wrote in message news:com... |
| Posted: 20 Jan 2005 03:45 AM PST > >John - I created: 1.a Master File with resources to use Tom, Normally a resource pool file contains only resources (no tasks) and remains separate from the files with tasks that use the shared resources. However, one of my main test files is a configuration just like you describe. The master file has the resources and the other files are inserted subprojects. I have had no problems with this configuration for over a year. How do you build the master? There are a couple of ways to effectively insert subprojects. The preferred method is via Insert/Project although the Window/New Window method also appears to work, but I've never used it. As far as saving, long ago I got into the habit of always doing "Save As" for the master and each of the subprojects. It works for me although there is a lot of support among other users that a straight "Save" and "Save all", as you are using, is equally as effective. You may possibly have corruption in one or more of your files. Try rebuilding the files. Start by deleting the subproject from the master and then and saving it as as a .mpd (database). Then reopen the .mpd file and do a "Save As" to an .mpp. Do the same thing with each of the subprojects and then rebuild the full master by using the insert method as noted above. Hope this helps. John Project MVP |
| Problem with "Export to Excel" Posted: 20 Jan 2005 02:47 AM PST Dear all, I've got a problem with the "export to excel" facility. I want to export Actual costs spread across months. For example, I have one activity with an actual cost of £9.5 and 3 months duration. The ACWP gets exported as £9.5 PER MONTH up to the status date. The Actual Cost figure gets exported as £9.5 for the first month and then nothing for the remaining 2 months duration on this activity. What I would hope to see is the £9.5 prorated across the 3 months duration of this activity. Does anybody have any ideas here? Thanks and regards, Angus Duncan |
| where can i find an easy to understand 'which version of project do you need' web page Posted: 19 Jan 2005 11:11 PM PST Hi Julie, Unfortunately, multiple people cannot have the *same* MS Project file open for editing at the same time. (And AFAIK, not even with server.) They can use a resource pool setup and each user can have a project file with their portion of a larger project connected to the pool. Each user can then update their project file and can update the changes in assignments to the shared resource pool. The individual project files and be consolidate through the pool file as needed to view the "master project". I have a client that sucessfully used the shared pool and multiple project file setup with about 15 project managers and many more project files. I think the advantage of Project Server is the ability to allow resources (and others with sufficient access rights) who don't use MS Project to view their tasks and provide tracking information. As I am sure you know, Project Server is a whole other layer of complexity (and cost.) Hope this helps somewhat. Julie The "other other" Julie :-) "JulieD" wrote: |
| Posted: 19 Jan 2005 08:21 PM PST Hi Julie, I agree, but then, I try never to bite the hand that feeds me! Julie "JulieD" wrote: |
| Posted: 19 Jan 2005 08:13 PM PST Thanks, Jan. I'll try it. "askgail" wrote: |
| Launch MS Access from Project and open a report Posted: 19 Jan 2005 05:27 PM PST Thanks Julie, but what they want is to open a particular report in Access based on the task they are sitting on(or linking from) in Project. I'll let you know if I come up with a solution. Thanks! Marty "JulieS" wrote: |
| Tracking "Out of Office" Resources Posted: 19 Jan 2005 03:03 PM PST Doug, your email address didn't come through properly... |
| Unable to open entire project via ODBC to SQL server Posted: 19 Jan 2005 12:41 PM PST Thanks, but it is not that. It is something to do with the Workstation ID that stops MS-Project from being able to open the entire project, restricting it to an import via a map. It seems that only the workstation that created the project database via MS-Project SaveAs can open it completely. "Rod Gill" wrote: |
| Creating a team project plan by % worked per month Posted: 19 Jan 2005 11:01 AM PST At first glance, getting the total hours by task and resource, or by resource then task for that matter, is easy. What's a problem is finding the total hours the resource was scheduled to have worked on both project and non-project activity so you can compute the percentage. Honestly, I'm not sure where you're going with it or what the usefulness of these percentages might be in terms of managing projects. If you could go into a little more detail about why you're trying to produce this report, maybe there's a way to get the equivalent information for you in some other way. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "Amy" <microsoft.com> wrote in message news:com... |
| Posted: 19 Jan 2005 11:01 AM PST Hi Askgail, Glad to have helped and thanks for the feedback. Let us know if we can assist you again in the future. Julie "askgail" wrote: |
| Heresy - how to prevent Project from calculating/changing dates Posted: 19 Jan 2005 10:25 AM PST If you need to track progress etc you really have to have calculation set on. But how could you possibly enter actual data without changing the plan? A task was scheduled to start on 15 January. It actually started on 20 January. How can you record the actual data you need to track, in this case the date it began, without changing the start date? You also said you need to show dependencies. Taking for discussion the default FS link, dependencies mean, by the very definition of the word, that the start time of the successor task is dependent on the finish time of the predecessor task. There is something in the second task that uses something produced by the first and until that something exists it is physically impossible for the 2nd task to start. But in your question you seem to be saying you want to ignore that scheduling fact, that you want task 2 to be scheduled on some arbitrary date and stay there even if it means that the people who will do the work are going to show up and sit around twiddling their thumbs, waiting and wasting your money doing nothing, for the required parts or whatever to show up so they can start work. No offense intended, but this makes absolutely no business sense at all. If it is required you know what the original plan was, so that you can compare performance against plan, that is another story all together. After you create your plan and before starting to post in actuals, you save a baseline. The baseline is a snapshot of the plan and in the baseline all the original values of start and finish etc are locked in and preserved even if different values are subsequently entered in the plan or posted as actuals later on. Once you have the baseline, it is an easy task to create a Gantt chart and task table that uses the baseline values rather than the normal one that uses the scheduled values. As you enter actuals, the schedule will change but the Gantt chart you're showing isn't using those values but the locked-down baseline values instead and so will always show the static plan as originally conceived. How this has any use as a management tool is beyond me, but you certainly can do it technically. And the best advice I can give is to keep a second copy of the plan maintained as it really should be so when the boss who's requiring you to do this is fired for s****ing up the project and throwing away so many resources, you can show HIS boss how you would have done it properly and earn yourself a promotion <grin>. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs <com> wrote in message news:googlegroups.com... |
| 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 | |
