Calculating Custom fields Microsoft Project |
- Calculating Custom fields
- HELP for old 95 user with Resources for 2003
- How do some of the column relationships work?
- mail merge
- Error in Project calculation?
- Formatting cells for word wrap
- Help on Custom Formulas
- Creating TBD dates with in MSP
- saving export map
- How to see all notes on screen at one time
- Compatibility between MS Project 2000 and 2003
- Conditional Task
| Posted: 09 Jun 2004 12:20 PM PDT On top of this, you may encounter problems when one calculated field refers to another. Imagine what happens when one calculates before the other. I suggest that you write the formula for C so that it is independent of A and B. For example if: A = [Finish]-[Start] B = [Baseline Finish] - [Baseline Start] then I'd write C so that: C = 100*([Finish]-[Start])/([Baseline Finish] - [Baseline Start]) -Jack "JulieS" <microsoft.com> wrote in message news:1a77801c44e70$15bf51a0$gbl... |
| HELP for old 95 user with Resources for 2003 Posted: 09 Jun 2004 11:04 AM PDT options and the schedule decimal crashed and I have but I had to get the Resources software I can't get the actual crew size. How number for the Resource |
| How do some of the column relationships work? Posted: 09 Jun 2004 08:48 AM PDT Jack, Thanks for the lead but I am looking for some sort of diagram or a design doc. I have been using MS Project for about 5 years now and I am aware of how the fields work but at times I would input some updates and Project goes and makes some obscure changes like if I update the % complete and the end date Project changes my duration from 4 days to 1.67. Now in the past I didn’t really care I went back and manually changed it back to what it was supposed to be. But now I took a position where the front end of the project is driven by an excel spreadsheet and tracking the overall progress is done in Project. So before I can link all the cells and have the inputs updated by several team members I want to understand some of MSP calculation methods. I would appreciate any additional help "JackD" wrote: |
| Posted: 09 Jun 2004 05:52 AM PDT Cathy, I suggest posting this request in microsoft.public.word newsgroup. This newsgroup is for Microsoft Project which is a scheduling software. -Jack "cathy" <microsoft.com> wrote in message news:com... merge, can anyone help thanks. |
| Posted: 08 Jun 2004 01:53 PM PDT Thanks a lot, Sarah The split view that you suggest is indeed a great way to work and have the best overview of all parameters. I also like to add the Work column up in the Gantt part. I can see the logic applied by Project is indeed the way you describe. The "fixed work" is fixed also at resource level rather than only at task level (which is what I expected). "Sarah" <com> wrote in message news:google.com... | Jerry, | | When you're going to make changes like this to your schedule, I would | suggest that you split the screen and show the Resource Work view of | the Task Form on the bottom part, with the Gantt Chart on the top. | Select the task in the Gantt, then in the bottom you can adjust the | resources individually. If you initially have one resource assigned at | 100% for 16 hours, then add another resource without making any other | changes, Project assumes that the two resources will split the work, | so each gets 8 hours. Then you tell Project that the second resource | is only available 25% of the time, so Project schedules that resource | at 2 hours per day. The 8 hours then takes that resource 4 days to | accomplish. | | Sarah | | > | "Jerry" <com> a écrit dans le message de | > | news:phx.gbl... | > | > I am new to Project, and it might be my lack of knowledge, but: | > | > | > | > If I have a task (fixed work, effort driven) of 16 hours work, and | > assign | > | > 1 person 100%, MS Project correctly calculates duration of 2 days. | > | > If I add a second person at 100%, duration is (correctly) set to one | > day. | > | > But if I assign first person 75%, and the other 25%, the duration | > | > is 4 days! Should be 2, shouldn't it? A bug? |
| Formatting cells for word wrap Posted: 08 Jun 2004 01:35 PM PDT Hello Hall, You can do it for the whole project : select the whole project with a mouse click on the grey square at the top left of the project sheet. Then do the same way that you did for a single row : drag the bottom line downward with the mouse. Gérard Ducouret [Project MVP] PragmaSoft ® - Paris "Hall" <org> a écrit dans le message de news:phx.gbl... |
| Posted: 08 Jun 2004 01:16 PM PDT "RTG Manager" <microsoft.com> wrote in message news:com... formulas, such as ProjDateDiff and Date Diff? Nothing appears in the online help or the manual (Inside Out Project 2003). Besides the help that Gerard mentioned you can find a couple of common questions and answers here: http://masamiki.com/project/customfieldFAQ.htm -Jack |
| Creating TBD dates with in MSP Posted: 08 Jun 2004 11:51 AM PDT Rob, Thanks for the note. But if you saw my original post the problem is that the plan is scheduled for 2 years and all tasks are identified but the LOE’s are not. So in the project plan I need to put a “TBD†Thanks for any additional help. "AK" wrote: |
| Posted: 08 Jun 2004 11:42 AM PDT Jeff, Yes, you can. With a small VBA procedure that you can write by automatic recording : Tools / Macro / Record new macro Do the job as usual... Tools / Macro / Stop recording Gérard Ducouret [Project MVP] PRagmaSoft ® - Paris <microsoft.com> a écrit dans le message de news:19b2a01c44d98$0c2fe650$gbl... |
| How to see all notes on screen at one time Posted: 07 Jun 2004 10:04 PM PDT Martin, The method Rod suggested will work fine as long as there are no line feeds in the Notes text or the total number of characters in the Notes field is 256 characters or less. If there are line feeds or more than 256 characters, you will need to either manually copy and paster, use an export map, or create a VBA macro to get the complete text of the Notes field to another application (e.g. Word, Excel, etc.). John |
| Compatibility between MS Project 2000 and 2003 Posted: 07 Jun 2004 04:06 PM PDT Haven't tested that, but haven't heard of any problems. The worst Project 2003 standard problem has been that on some PC's you've been unable to out some tasks. There is however a hotfix for that problem now if you encounter it. -- 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/ "JulieD" <net.au> wrote in message news:%phx.gbl... 2003 2003 |
| Posted: 04 Jun 2004 08:07 AM PDT IMHO, a project schedule is just that - a plan of what you are actually going to do. So how to handle the contingency scenario? Decide whether it is most likely that you'll need to restore one or more servers or not and build your plan based on that assumption, but with the understanding that you may have to modify it later if circumstnaces evolve differently. Same sort of idea as planning to drive from point A to point B via C but with an alternate route through D in mind if road construction forces a detour enroute. -- Steve House [MVP] MS Project Trainer/Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "Day Tripper" <microsoft.com> wrote in message news:185fb01c44a45$99e77c20$gbl... |
| 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 | |
