Fields in Formulas

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - day one How do I start a project on month one , day one and progress thru day two , day three etc.? Tag: Fields in Formulas Tag: 60109
  - 2
    - Saving Backups How can I create a backup for some of the project plans (each their own indvidual mpp file), but not have it so all of them are required to generate a backup? Currently, we have gone to Fil Save A Tool General Option (and checked the box) Always create backu This function makes it so every file that is saved using Microsoft Project 2002 has a backup created. This is not ideal for our situation, and we would like to individually select the Project files (mpp files) that have a backup created. Any advice would be appreciated! Thanks Justin Tag: Fields in Formulas Tag: 60104
  - 3
    - Combining Multiple Projects Is there a way to combine multiple Projects so that they intertwine their dates without being dependent on one another? I need to be able to see what is happening per week for all the projects without linking the projects. I am using Project 2000, and would appreciate any help! Tag: Fields in Formulas Tag: 60100
  - 4
    - How to see if there are activities planned for the next week hello I have more than 400 tasks, and have difficutlty in seeing what are the activities that are planned for the next period via the calendar view. Are there better alternatives? I am also interested in knowing what are the tasks that have already slipped, are there ready views/reports templates available? thanks Tag: Fields in Formulas Tag: 60094
  - 5
    - test Jason Wu ¡Ä ¡Ä¦à. ¥ß^¨^¥ßìá)¡« Tag: Fields in Formulas Tag: 60092
  - 6
    - Project Server CAL 2002 v. 2003 compatibility Background ========== The office is using MS-Project 02. Question ======== Can the CAL within MS-Projet 02 be used with Project 03. If not, what would be the motivation to move to Project 03? Thanks Ray gatorbackATyahoo.com Tag: Fields in Formulas Tag: 60081
  - 7
    - Units and how they work Could some one please clarify units. If you are writing a scope or doing work and have allocated 1 full day then do you allocate the assigned resource as 100%. And if you have two people working on the task does mean you allocate 50% each resource for that one full day. And finally if you are to work on a task but only spend 2 hours out of the full day allocated how do you put that down in units. Regards Anthony Moore Tag: Fields in Formulas Tag: 60074
  - 8
    - Feedback Wanted: ALM Tool Integration with MS Project Our product roadmap has integration with MS Project as a key priority. If you have interest in leveraging the power of MS Project with broader application life cycle management tools, we would like to hear your thoughts. Active! Focus (AF) is an application life cycle management tool designed to be straightforward to use and affordable. AF 2.0 is currently in development and will manage: Project level information (including charter, start date, due date, priority, customer). Project Artifacts ----------------- Events - the key milestones or life cycle phases of the project. Tasks - project tasks, the work to be done. Requirements - the content or definition of what is to be delivered. Change Requests - proposals to alter agreed upon aspects of the project. Defects - information concerning where the software does not perform as specified in the requirements. Issues - items that are hindering the progress of the project. Risks - items with the potential to hinder the progress of the project. (for more information on Active! Focus version 1.5, see http://www.xapware.com/ActiveFocus.htm) As we look at integration with MS Project, we see the following linkages: AF Project information should map to MS Project Information. AF Events & Tasks should map to MS Project milestones and tasks. The remaining information would not be present in MS Project. By bringing Active! Focus and MS Project together, it is our intent to give the project team a more complete project management solution. While MS Project is an excellent tool for managing schedules and timelines, it does not provide a mechanism for managing Requirements, Change Requests, Defects, Issues and Risks. Areas that may be critical to project success, but often aren't managed as they should be. But we also recognize that maintaining similar information in a plethora of tools does not improve productivity. We see AF + MS Project as a powerful solution to this problem. Currently we are looking for input on what integration should enable you to do. In the near future, we will be looking for people interested in testing Active! Focus and MS Project integration. Questions: 1) Does the mapping of information look appropriate to you? 2) What does integration mean to you? How would you expect the two products to work together? 3) Do you know of any other tool like Active! Focus that already integrates with MS Project? --------------- Steven B. Beebe Xapware Technologies, Inc. Driving Development Success (719)360-6820 Tag: Fields in Formulas Tag: 60070
  - 9
    - Ms Project 2002 Certification Practce exams Hi, I am studying for the Project 2002 MS expert exam but can't find ONE SINGLE practice exams can someone help me out ?? If no one can help me out can someone at least tell me if any of the server stuff is on the exam or is it strictly Project...thanks in advance MV Tag: Fields in Formulas Tag: 60069
  - 10
    - Total hrs I base all my tasks (and projects) on hourly inputs. All the tasks are defined and scheduled before resources are assigned. How can I get a total of hrs on a project. If all tasks are linked, the duration works out, but when tasks start to overlap the duration is not accurate for the total hours. I've found how to get total costs after resources are assigned, but it seems like there should be a simple way to get a sum of hours of all the tasks. Thanks AGAIN!! Mike Tag: Fields in Formulas Tag: 60057
  - 11
    - Spell Checking one only Task Is there a method to use the built-in spell checker of MS Project that will check only only task or word ? The way MS Profject 2002 seems to operate is to begin at the top of the file every time and work its way down every time. Is there way to execute the spell check routine that would only check the word in question ? Thanks, KMD Tag: Fields in Formulas Tag: 60053
  - 12
    - Colour of font of resource initials on task bar Hello, 1. Is it possible to manually set the Gannt Chart Bar Text font colour for particular resource initials? For example, if a resource is unknown (unnnamed) but the TYPE is known, say, CDeveloper, then if I set Resource Initials to "?CDev", can I change the Bar Text Font COlour to RED to highlight the particular resource is not yet identified? 2. Can I automate 1. above? So that if the resource initial contains a question mark, Say "?CDev" or "?NetEng" then this is displayed on the Gannt chart using RED font. Once I know my specific resource then I change to the actual initials, say "CRL" and either automatically, or by running a macro, the BAr Text turns to Black from Red? Thanks Clive Tag: Fields in Formulas Tag: 60051
  - 13
    - Rollup resource usage by summary task How can I produce a report or view that sums up resource usage/work by summary task. For proposals and for accounting I need to rollup total hours PER resource per summary task. For instance I have a project plan with four summary tasks, Envisioning, Planning, Programming and Stabilization, each with a number of subtasks and multiple resouces assigned. In a report I need to indicate how many hours for team lead are in each of the summary tasks, and likewise for programmer1, p2, project manager, etc. I also need to produce cost by resource by summary task as well. I would really like to define a canned report that I can run each time I make a change to a project or develop a new on. I spend way too much time doing this work with a calculater. Help! Tag: Fields in Formulas Tag: 60043
  - 14
    - Resource over-allocation I hope my ignorance isn't too annoying, but you guys have been very helpful to this newbie.... Anyway -- I've found some options to check for, and "level" resource over-allocation "after the fact", but I'm wondering if there is a setting that would "not allow" a resource to be assigned to a task during a conflicting period in which the resource was already assigned to another task? Mike Tag: Fields in Formulas Tag: 60037
  - 15
    - Working with summary tasks Can anyone give me a pointer for usage of MS Project 2002? The problem is this: I have an overall task, "Overall 1", to which I don't associate any duration. It is present just to keep things organized logically. I assign that task to "Resource A", just for ownership. Once again, there is no explicit work for "Resource A" to perform. Underneath "Overall 1", I have "Subtask 1" and "Subtask 2", which do have durations associated with them. Also, I assign one of them to "Resource A" and "Resource B". When I go to look at the Resource Usage View to see if my resources are overbooked, it looks like "Resource A" is overbooked, because it treats "Overall 1" as a real task that needs to be performed. That is not what I meant by assigning ownership of it to "Resource A". There must be an easy way to tell Project to not treat this as a task, but I haven't found it yet. Any thoughts? Tag: Fields in Formulas Tag: 60036
  - 16
    - Scheduling Only With Duration Remaining Is it possible to get MS Project to only bother scheduling the remaining duration of tasks. So if I say a 4 day task is 50% complete, then it will simply schedule 2 days. At the moment if I have three tasks, A 4 days, B 4 days and C 4 days, and I say B is 50% complete it will show on the gant B with a line half way through it, but it is stil taking up four days on the schedule, when it should only take up 2. In other words, I want to be able to use project without bothering to enter actuals - all I am interested in is out-standing work. Thanks in advance. Tag: Fields in Formulas Tag: 60035
  - 17
    - a new task changes the start date on a previous task When I'm building a plan and specify a duration of 3 work days for example, it would set the start finish as Jan 1-3 (hypothetical). If I then do another task that's 5 work days using the same resource, project starts this task on Jan 1 and the first task pushes out to Jan 6. If it matters, I resource at 80% (not 100%) and this is setup in the project server. I don't want to have predecessors established when the resource is the only constraint, however, I want the first task to be completed prior to moving to the next task. I can prioritize the plan but as it gets bigger this becomes difficult to manage. If anyone can help it would be appreciated. Thanks, Dave Tag: Fields in Formulas Tag: 60034
  - 18
    - Question On Columns? I just started using 2003 Professional, our next steps will be to evaluate 2003 Server. I went through the Project Standard 2003 Demo http://www.microsoft.com/office/project/prodinfo/demo.msp and my Manager likes the "Schedule Status" Field. (He likes the Colors? Well is seems that there is no Column called "Schedule Status" Does anyone know how to turn this field on? or is this a VB add on? Thank Happy New Yea Ed S. Tag: Fields in Formulas Tag: 60031
  - 19
    - Building a Budget I want to be able to build my entire budget in project including the consultants travel expenses, airfare, hotel, rental car, etc. Thank you! Tag: Fields in Formulas Tag: 60030
  - 20
    - Installing Project 2003 At the beginning of the installation I get the message = "...cannot be installed when another instance of .... is already present. ..... remove the previous instance using Add/Remove ... from the Control Panel. Previous version was already removed and I have deleted all references to Project from the Registry and cannot find any of the Project files in C:\Program Files. Not under Office11 directory or anywhere else. This should install - but, I get the above message every time I try to install. Project does not even show up in the Control Panel of files to Remove Microsoft KB has several articles on the subject, but none of them was helpful Tag: Fields in Formulas Tag: 60027
  - 21
    - Visual C++ Runtime Err On start up of Project 2k2 I am running Windows XP Pro on a Domain with Full Windows Update Patches applied I have Full Office XP Pro w/Front Page installed (2k2 version) with Full Officeupdate patches applied. I have Visio 2k2 installed. I have Project 2k2 Installed. (Performed Custom installation with Full Packages selected for installation) Issue: All applications except Project 2k2 runs fine. On opening Project I get this error. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Microsoft Visual C++ Runtime Library X Runtime Error! Program: C:\Program Files\Microsoft Office\Office10\WINPROJ.EXE abnormal program termination [OK] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I tried opening Project in its Safe mode (starting project with CTRL key held but same problem occurs). I have tried uninstalling Project and reinstalling but still same issue. After pressing the OK button or X in corner, Project closes. How do I fix? Any solutions? Tried Technet but no luck. Thanks Tag: Fields in Formulas Tag: 60024
  - 22
    - Project Server 2002 v. Project Server 2003 Is there a spreadsheet out there that lists a side-by-side feature set of PS2002 and PS2003? I would like to understand what the difference is between the two functionally. Thanks, Raymond gatorback@yahoo.com Tag: Fields in Formulas Tag: 60023
  - 23
    - Where are the report template files? I have Project 2003 installed on XP. Does anyone know where the template files are for the built-in reports? Do they exist and can one actually modify them? Tag: Fields in Formulas Tag: 60021
  - 24
    - Is there a way to see all tasks for all projects on a single calendar in Outlook? With Project Pro 2003 + Project Server 2003, is there a way to see all tasks for all projects on a single calendar in Outlook? Let's say that I have 50 projects going. I would like a way to have all tasks for all 50 projects show in a single calendar that resides in a public folder on my Exchange 2003 server. Thanks! -- Jim Tag: Fields in Formulas Tag: 60020
  - 25
    - error in Project 2003 Pro - upgrade database I have one Business Unit running Project Server 2002 with a couple of projects as a proof of concept. I recently upgraded another employee to Project 2003 Professional and he is having some trouble doing updates and edits on server based projects. He receives an error when doing updated that the servers database needs to be upgraded to 2003. Can anyone provide me with some guidance on if I should either upgrade the database or downgrade the one user of 2003 to 2002. Thanks in advance. Jim Tag: Fields in Formulas Tag: 60019
- Next
  - 1
    - Resource Graph display Is there a way to an entire group of resources in the resource graph? I know I can filter for the group, but I still have to manually switch each resource. I would like to view all the resources that fall in that group in the graph - possible? Thanks in advance Shawn Tag: Fields in Formulas Tag: 60014
  - 2
    - Missing Analysis Toolbar I am trying to export "timephased project data to Microsoft Excel". According to the Project Help, I need to use the Analysis toolbar to do this. When I go to View->Toolbars, I do not have an entry for Analysis. Can someone please tell me how I can display the Analysis toolbar? Did I miss something when installing Project? Thanks. Tag: Fields in Formulas Tag: 60013
  - 3
    - Assigning resources working time - rotation I'm having trouble assigning resources to a project plan - I'm trying to show 2 personnel that will rotate every two weeks with two other personnel over the course of a year. Each team of 2 alternates shifts (night/day). What is the best way to accomplish this? Do I need to manually set a working time for each resource for the entire duration of the project? I wanted to just set up the same resource with 4 available units, but I'm thinking each one may have to be individually set-up to plan for this rotation. Any help is greatly appreciated. Tag: Fields in Formulas Tag: 60012
  - 4
    - Digital Dashboards in Project Hello All In researching digital dashboards, it has lead to some confusion on my part. Some articles that I have read on digital dashboards for MS Project EPM state that you can build the software with Office XP Developement Toolkit and other articles have stated that it requires a different program called Digital Dashboard Toolkit. Both are from Microsoft; can someone help me sort out this mess Thanks Again Tag: Fields in Formulas Tag: 60010
  - 5
    - Paste Specials When copying MS Project 2002 cell to clipboard and "paste special" the info into Excel spreadsheet, sometimes it works and sometimes it doesn't. When it doesn't work, I get an "invalid name" error, but checking the name on the ones that work verses the ones that do not work, I can not see any apparent error. Anyone else experience this? Help would be appreciated. Thanks. Tag: Fields in Formulas Tag: 60009
  - 6
    - Recurring tasks How to I create a recurring tasks in Project '02? I am going nuts trying to work this out. Thanks! ~MVA~ Tag: Fields in Formulas Tag: 60006
  - 7
    - Teing tasks I have a problem with tieing tasks together.I have several summary tasks,each of them has a set of common subtasks which are internally chained.This way the poject may finish soon but the related subtasks are not done joined to each other,and so the summary task takes long and the duration is much more than the work,and besides I want the related sub tasks be done serial. As this is my urgent need,I will be very pleased if you kindly respond me ASAP. Thanks. . Tag: Fields in Formulas Tag: 60002
  - 8
    - Summary Task Costs used in Timescaled I am using Project 2002 and am doing a very simple fixed cost schedule (no resources) for purposes of cash flow. I have loaded fixed costs onto summary tasks (and not the indented tasks below each), but when I analyze timescled data in Excel, the costs I have loaded on the summary level do not spread if I have detail tasks beneath them (indented). I am trying to get a cummulative and fixed costs graph but the summary costs are not coming across. Is there a way around this or a setting I am missing? Thanks in advance. Tag: Fields in Formulas Tag: 60000
  - 9
    - Linking to SAP Hello In one of the Greenfield project in petrochemical industry, we want to link the MS - Project to "SAP" I want to know whether it is possible to do this? 1. If yes then how to do this 2. What MS - Project version is required to be purchased Thanking in advance & Regard Tag: Fields in Formulas Tag: 59997
  - 10
    - Handling data from MSProject Actually, I am doing project called Integrating Project Management tool. Inwhich I need to integrate Msproject2000 with my application. I am doing in Jsp but i don't know how to handle the data from Msproject2000. I import the data to SQL Server but it didn't imported properly. So I need a help how to handle the data for MSproject 2000. Is there is any ODBC driver available for msproject 2000. But i don't want to import the data to MSExcel. So i need to handle the data from the MsProject without using any backend.Is it possible? If possible give me the ideas thanks for regardin Tag: Fields in Formulas Tag: 59996
  - 11
    - Desperately need help opening an old file i have an old project file from around 1998 made on project for macintosh. can anyone help open it and convert it to a current project format? Tag: Fields in Formulas Tag: 59991
  - 12
    - Resource Allocation I want to allocate one resource to one project in which he should not be spending more than 2 hours per day. While assigning the task to the resource I am setting the units to 25% because we work eight hours. This however does not allocate the resource across five days if there are five task on which the resource is to work. Instead what it does is it allocates the user for 2 hours same time on the same day for all five days. The duration I have specified for this task is 2 hours where as work is only of 2 hours Any solutions? Devendra Tag: Fields in Formulas Tag: 59984
  - 13
    - Expanding/Minimizing Is there a quick easy way to expand or minimize all summaries in a project with one command. Tag: Fields in Formulas Tag: 59973
  - 14
    - Linking Actual Tasks vs Summary Tasks Are there any underlying pitfalls or advantages with regard to linking summary tasks as opposed to linking the sub-tasks from summary to summary. I started to think linking summaries might not be a good idea, but couldn't come up with a logical reason to convince myself of that. Mike Tag: Fields in Formulas Tag: 59971
  - 15
    - Project 2003 vs PMW... Hi, Yes I know PMW from ABT has disappeared under this specific form. I disconnected for the last 5 years from the project management tools and I saw that Project 2003 seems to have received several improvements which seem to close at least partially the gap with PMW. I was wondering if someone knowing PMW could confirm if the resource driven planning as in PMW and the tracking separated from the planning are properly supported now in Project 2003? Thanks in advance and kind regards, François Tag: Fields in Formulas Tag: 59970
  - 16
    - problems when editing MS Project files I have a laptop with Windows XP Pro, Office XP Pro and MS Project 2000. All software is in English language. Now I have a partner with MS Project 2000 in Dutch (Windows and Office are the same versions/language as mine). When he is reading my files several settings (line headers, etc.) are in Dutch instead of English. How can we permanently change it so that he can read/edit my file with the same formats (Language, Date, etc.) I sent to him? Do we have to install an English Version of MS Project or is there a possiblity to switch between two languages? Thanks in advance! Regards and nice Christmas! Sascha Tag: Fields in Formulas Tag: 59962
  - 17
    - Relatoive Task Time Can a task's hours be based upon another task's hours? We use a standard template for all new projects. We use a formula that says "for every programming hour there are 1.5 Qa hours involved". Is there a way that I can say the task hours is 150% of it's predecessor's hours? TIA, Tag: Fields in Formulas Tag: 59961
  - 18
    - Update timesheet in Project Server Hello, I'm trying to update a timesheet in Project Server, and having some difficulty. I have multiple tasks assigned to a particular team member within a project. When they open their timesheet, they can enter actual work and remaining work for some of these tasks, but not for all of the tasks. In fact, they can not even type data in the ActiveX control for some of these tasks. (I've specified that resources update actual and remaining time via PWA). I've tried the same thing as the administrator, using the Adjust Actuals function, with the same result. The cells in the ActiveX control for these tasks are grayed out, where others allow entry. Has anyone seen this type of behavior before? Tag: Fields in Formulas Tag: 59957
  - 19
    - Project Professional 2003 - Reporting capabilities I as told that Microsoft had bought software from a company called JeTech (2-3 years ago)who was a Microsoft partner for companion products. I believe that JeTech changed their name to eLabor and was bought by ADP - EXCEPT for the reporting package piece. I was told that portion of the package was bought by Microsoft. It was a terrific reporting application and made MS Project an even better tool, with incredible reporting capabilites. I therefore went out and bought MS Project Professional 2003 to get that reporting enhancement ... but alas, it is basically the same what was in 2000. Does anyone know anything about the incorporation of the JeTech software into MS Project and if so, which product it is in, so that I can buy it ? Thanks, Randy ----------- Tag: Fields in Formulas Tag: 59951
  - 20
    - Hyperlinking How do you insert multiple hyperlinks into a project (individual line item)? I'm currently using Project 2002 Professional and when I insert a second hyperlink, it just replaces my original one. The help file indicates that hyperlinks can be inserted into any text field (i.e. text1- text30); however, only one hyperlink/text field. Doesn't this mean that I can insert a hyperlink into text1 and then another into text15? The help file also states that one can insert multiple hyperlinks into the notes field. I have succeeded in inserting excel files into the notes, but not a real hyperlink. What I want to accomplish is the ability to change the color of a word in one of my text1- text30 fields and to make that word a hyperlink. Is this asking too much? Thanks. Tag: Fields in Formulas Tag: 59949
  - 21
    - compatibility between 2002 and 2003 Are there any compatibility issues between project 2002 and project 2003? Just need to make sure I can have both running. We are not using project server so that will not be an issue. Thank you, Tag: Fields in Formulas Tag: 59948
  - 22
    - Starting Fiscal Month/Year on Dec 21? Is it possible to start the fiscal month / year on a date other than the 1st of the month? My companies work periods (for example) run from Dec 21, 2003 to Jan 24, 2004 for the fiscal month of January, 2004. I have tried setting the fiscal calendar, but it does not provide a means to set the specific date Would I have to create a macro? I have experience in VB (don't let my co-workers know, they would want me to actually work for a change). Tag: Fields in Formulas Tag: 59947
  - 23
    - How to have non-project people view? How do I have a file so non-project users can view? Tag: Fields in Formulas Tag: 59945
  - 24
    - Update project information I am interested in how you have managed to create and update project information in project server. I can not see a way doing this via PDS web service interfaces. We are trying to write somewhat similiar solution to Project/Siebel that would provide users with standard web forms to collect the project data, projects would then be created and updated based on templates, and finally the reports would be generated. We are able to create project by using ProjectCreate PDS method (still do not know how to create projects based on templates, what you've clearly achieved in this sample), but had no luck with updating the project/tasks information. Please give us some pointers. Thank You Regards, Tom Tajiæ Avtenta.SI Team Tag: Fields in Formulas Tag: 59940
  - 25
    - how to export a report to Excel Hi, anyone know how I can export a report to Excel? thanks, Stuart Tag: Fields in Formulas Tag: 59936

I want to customize task field Cost1 as Billable Amount
using the formula = (Actual Work * Int. Cost), where Int.
Cost is resource field Cost1. In other words, can you
access resource fields in a customized task field formula?

Re: Fields in Formulas by John

John
Fri Jan 02 14:56:45 CST 2004

I tried; I couldn't.

You are probably considering the easy case: one resource per task. Because
multiple resources per task are possible, the calculations become too
complex to easily implement. You might want to look at some VBA code.

JLB, PMP

"Andrew" <anonymous@discussions.microsoft.com> wrote in message
news:01e201c3d16c$477b4540$a401280a@phx.gbl...
> I want to customize task field Cost1 as Billable Amount
> using the formula = (Actual Work * Int. Cost), where Int.
> Cost is resource field Cost1. In other words, can you
> access resource fields in a customized task field formula?
>

Re: Fields in Formulas by JackD

JackD
Mon Jan 05 12:41:02 CST 2004

Not without using VBA. You will have to write a macro for this.
I have some information on writing macros and using custom formulas at my
website
http://masamiki.com/project

"Andrew" <anonymous@discussions.microsoft.com> wrote in message
news:01e201c3d16c$477b4540$a401280a@phx.gbl...
> I want to customize task field Cost1 as Billable Amount
> using the formula = (Actual Work * Int. Cost), where Int.
> Cost is resource field Cost1. In other words, can you
> access resource fields in a customized task field formula?
>