Customizing Fields and calculations

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
    - Sheduling delivery and installs I've done some searching but didn't find anything that spoke specifically to what I'm trying to do. I'm using Project 2003. My main question is related to equipment delivery and the best way to deal with it. Here are the particulars: 1) We have ordered the equipment from the vendors, they have given us delivery dates. 2) For some of the equipment the vendors are installing it, so the dates on when they will be here are fixed. 3) For the equipment we are installing ourselves, work obviously can't begin until the equipment arrives. I've seperated the items into summary tasks, each with several sub tasks (including delivery). An example is below: Storage 12 days Wed 6/6/07 Thu 6/21/07 SAN Arrives 0 days Wed 6/6/07 Wed 6/6/07 SAN Implementation 4 days Mon 6/18/07 Thu 6/21/07 I've set the arrival task as a milestone. In this case both the constrain dates are set to "Start no earlier than". Is this the best way to approach this? Tag: Customizing Fields and calculations Tag: 121951
  - 2
    - How do I make column width wide enough to view all levels I have a large project file that goes to ~30 subtask levels. As a result the text in the subtask is not visible unless I select the row, then it is visible in the text line but not in the column with all other tasks. How can I change the degault width of 128 characters? Tag: Customizing Fields and calculations Tag: 121945
  - 3
    - Changing duration inhibited by Cost Resource's "inherent" duration I have Project 2007, and have put together a file using multiple Work Resources and Cost Resources. Some tasks have both types assigned to them, with hours assigned to the Work resources and dollar values assigned to the cost resources. The problem arises when I edit the duration of the task. If I lengthen a given task, all is well. If I shorten it, the "entry" table of the Gantt chart shows that the duration has been shortened, but it still maintains the same start and end dates and the same visual bar length -- both of which conflict with the new duration. I traced the problem to show up on the Task Usage view with Summary Table, where it shows that yes indeed, the duration and start and end dates have been correctly adjusted for the Work Resources, but not for the Cost Resources, which maintain their original start and end dates. These are the dates for the task as set prior to resource assignment. Manually shortening those dates in this view fixes the problem. However, it more or less eliminates the ability to visually manipulate the Gantt chart bars, look at resource allocation leveling, etc, since the bar length does not correspond to the task durations. Task settings are basically fixed-duration, non-effort-driven, prorated accrual. Is there a toggle that I'm missing to allow the Cost Resources to stop inhibiting normal task duration editing? Thanks Tag: Customizing Fields and calculations Tag: 121944
  - 4
    - Incorrect calculations in custom fields I've created a custom cost field that represents the total value of a deliverable and a second custom cost field that calculates the revenue earned to date based on the % of work completed. It uses a formula that calculates [total value]*[%WorkComplete] and is supposed to display the product in the revenue earned to date field. However, none of the products are accurate when I do the calculations manually and in most cases are off quite significantly (thousands of dollars). Is there a reason why this field is not calculating properly? example: Work % Complete = 65% Total Value = $18,200.00 Revenue earned to date is calculated to be: $4,732.00 (Should be $11830.00) Thanks for your help. Sherri Revenue earned to date should be $1000, but will show up as Tag: Customizing Fields and calculations Tag: 121942
  - 5
    - basic question I'm training myself here from the ground up so forgive the simple question. Just have to make sure I'm understanding this correctly. Could someone please explain the difference between a task and a project type in an enterprise custom field? I've made several task fields successfully and seen how they report task by task. I don't understand where the project field shows up (and ultimately, if this is related to how fields are reported in PWA although I know this isn't a PWA board!) Thank you so much. Naomi Tag: Customizing Fields and calculations Tag: 121941
  - 6
    - Filter that will not go away At some point in time my Project became stuck on "Filter for Critical" and regardless of what view or filter I am on when I dave and exit everytime I open the project it is on Filter for Critical. How can I clear that filter so when the file is opened it displays all tasks? Thanks, Rich Tag: Customizing Fields and calculations Tag: 121934
  - 7
    - Fixed Works/Flexible Resource Units Project 2003, SP2 question: I set up a task of fixed work. Work is set at 40 hours. I enter Resource A at 50%, Project figures out it will take two weeks at 4hrs a day and sets the duration to 10d. All is good. I then enter Actual Work for Resource A. Let's say A works only 2 hours on the first day instead of the alloted 4 hrs. Project then calculates out that Resource A will need to work those other two hours on day 11. Is there anyway to tell Project to leave the duration at 10 and increment the units, at least until a resource hits 100% units. I guess the same holds going the opposite way. If a resource works 8 hours instead of 4, rather than pulling in the duration by a day, I'd rather Project change the units from 50% to 40% (or whatever the correct calculation would be to keep work at 40 hrs and duration at 10 days. Thanks in advance for the help. Tag: Customizing Fields and calculations Tag: 121933
  - 8
    - Resource Allocation. I have several tasks all available to start at the same time, all requiring the same resource. They are summary tasks, with sub tasks below. Once I start subtask1, I want to continue using the resource until I have finished the last subtask for the summary. If I assign the resource at the summary level, I am told that the resource is overallocated, and that the overallocation cannot be resolved. I can skip the allocation of that resource, or just stop leveling. Why won't the resource be allocated to one of the tasks, and then allocated to the other task when the first task is complete? -- CDR Tag: Customizing Fields and calculations Tag: 121929
  - 9
    - Let Task duration change by changing Task finish date Hi, Is there a way to let the duration of a task automatically change when you change the task finshish date. E.g. Task 1 starts on Mon 1st and finishes on the Fri 12th = 10 days duration. I then chnage the end date to the Fri 19th. By default project puts a constraint on the end date, keeps the duration at 10 days and moves the start date to Mon 8th. I would rather it kept Mon 1st and extended the task to 15 days duration. Thanks for your time Tag: Customizing Fields and calculations Tag: 121926
  - 10
    - How to get formulas working in a custom field? I am trying to have a column which lists a number. I am trying to add a formula to this column, which multiplies % work completed (a percentage) with Approved hours (a custom duration field). It is coming out with some very strange figures and I don't know why. Any ideas? Tag: Customizing Fields and calculations Tag: 121924
  - 11
    - Consolidating into a summary schedule I have a series of independent detailed schedules (approx 10) each schedule contains up to 1000 tasks. My client has asked if I can create a summary schedule based selected items from these individual schedules. Is there an automatic way to extract the detail from the individual schedules into the single summary schedule. Thanks in advance Phil Tag: Customizing Fields and calculations Tag: 121923
  - 12
    - Creating reusable components I am trying to find a better way to manage a repeatable project process. Each time we implement a project, we may or may not use every element of a master project plan. For sake of establishing a common communications framework, let's say a full-blown project consists of level 1 elements A,B,C,D,E,F and G. A short project might only consist of elements A, D and G. Some projects might add element B or C. It seems that there would be a way to create A through G in a palette that I could drag and drop onto the canvas (Visio?) to create the individual project plans. Then I could fill in the details for resources, costs, etc. with the resultant output. Otherwise, I have to take the 650 line item master project plan I've created and delete everything that I don't need for each project. Task view seems to be the only way to really do this. I've looked at Network view, but it doesn't seem geared to do what I'm looking for, but it might just be inexperience with Network view. I'm currently working with Project 2003, but I can get 2007 if this is better fleshed out. Worse case scenario is to get one of my programmers to create a Visio <-> Project interface. (If that's possible.) Thanks! Tag: Customizing Fields and calculations Tag: 121917
  - 13
    - Programming in Visual Studio 2005 for Microsoft Project Ask me please! Whether there is a possibility to write the program for MSProject on Visual Studio 2005, not using built in editor Visual Basic in Microsoft Project. Tag: Customizing Fields and calculations Tag: 121916
  - 14
    - Customizing fields - how to get durations to add up? I have added a column in my gantt chart view on the left. I used a duration field, so I can record approved hours. I have manually added these in for the sub-tasks, but I wondered why they didn't add up automatically for the task total? Should I use a different field type for this? It seems I can only apply a formula to the whole field, rather than just the few places where it needs to add up the hours. Any help appreciated. Tag: Customizing Fields and calculations Tag: 121910
  - 15
    - How can i add by groups? How can I add resources by group rather than by name? In the resource sheet I have set the group names by each resource. Tag: Customizing Fields and calculations Tag: 121909
  - 16
    - Problem with resource scheduling Hello, Suppose we create the following 3 tasks and assign resources A and B in the following way: - Task A1, Work=16h, Resources A (100%) and B (100%). - Task A2, Work=8h, Resource A (100%), Ancestor=Task A1. - Task B1, Work=8h, Resrouces A (100%) and B (100%). What I would expect is: - A is assigned 8h of Task A1 on Day 1. - B is assigned 8h of Task A1 on Day 1. - A is assigned 8h of Task A2 on Day 2. - B is assigned 8h of Task B1 on Day 2. So the project finishes in 2 days! However what happens is the following: - A is assigned 8h of Task A1 on Day 1 -> ok! - B is assigned 8h of Task A1 on Day 1 -> ok! - A is assigned 8h of Task A2 on Day 2 -> ok! - B is assigned 4h of Task B1 on Day 2. - A is assigned 4h of Task B1 on Day 3. So the project takes 3 days instead. Any idea why? Thank you! Giannis Tag: Customizing Fields and calculations Tag: 121903
  - 17
    - How do I change the time scale display & reflect in PWA Hi! Just wondering.. I need to change the display of gantt chart timescale in my project (remove time scale breakdown of weekls in the bottom most tier and use weeks or months) and same settings should apply on the Project Web Access (PWA) once I publish it.. I tried saving and publishing the project with new settings on the timescale but it did not reflect on the PWA. How can I do it? Is it possible that the display will only apply in 1 project? By the way, I am using MS Project 2003.. Kindly advise me... Thanks! Tag: Customizing Fields and calculations Tag: 121901
  - 18
    - project 2007 encounters problem prior to changing timescale I have created a schedule in project 2000 ( timescale:months/weeks). When I open it in 2007 version, it displays the timescale in months/days. When I righclick on the on the timescale and click on timescale, before even opening, it pops a message saying microsoft encountered some problems and need to close. Any ideas? Tag: Customizing Fields and calculations Tag: 121889
  - 19
    - Going from IE 7.0 back to 6.0 - having problem with Pekin Insuranc I recently uninstalled the IE7 update and went back to IE6 as my computer was running slow - Now I'm having troubles with Pekin Insurance Website - once I'm logged in I have to hold downthe Shift button evertime I click on somthing - Anyone know of the fix for this? -- Thanks, Stacey Tag: Customizing Fields and calculations Tag: 121885
  - 20
    - Percent complete isn't being updated in the task level from subtasks I don't know if this is a bug in the project or not, After I put 100% complete in the subtasks, the task percent completed still stays at 0% which is very strange. Tag: Customizing Fields and calculations Tag: 121873
  - 21
    - Resource Usage: Theoretical vs. Practical I have a problem estimating correct billable hours for a resource from the Resource Usage view in a Project plan. Let us look at the tasks for resource X per following example: Task ID Task Gantt Chart ---------- ----------- 1/15 1/31 14 A |=============| 2/10 20 B |==========| 2/15 2/28 25 C | =============| 3/5 3/20 37 D |===================| As per project task needs resource X is not required from 2/10-2/15 and from 2/28-3/5. However, in actual practice the resource will be at client's site from 1/15 to 3/20, for which I will be billing the client. I cannot extend tasks B and C to finish on 2/14 and 3/4 respectively just to ensure resource X is continuously used, because this will extend the project time-line due to downstream dependencies with other tasks in the project. Is there a practical way to represent resource requirement continuously in a project plan without affecting the project time-line? Tag: Customizing Fields and calculations Tag: 121870
  - 22
    - Resource Assignment - Backwards Good morning peers. Using Project2003. Project Manager has assigned a group of people to work a project- Resource A is available 50%, Resource B is available 25%, etc. They will divide themselves among "n" simultaneous tasks and get done what they can. The total amount of allowed work is given by the period of performance and the %units. We should assume these are Level of Effort tasks. If 4 tasks are in play today, then resouce A will work 1 hour on each task, resource B will work 0.5 hrs. Task start/finishes are different for each task in play. A large group of tasks is assigned and every one of them will have the same resource assignments -- A and B. I have "n" tasks. I would like to be able to select all these tasks and tell project: "Assign A and B to all these tasks such that they are not overloaded while keeping all the same dates." I can make the tasks fixed duration, etc. That is, I want Project to determine the correct units% day by day so A & B are not overloaded. So on any given day, I will have "n" tasks in play. The total allocation of A is not to exceed 50% of their time (4 hours among "n" tasks) and B is 25% (2 hours) among the same "n" tasks. "Tomorrow", "n" becomes a new number "m" because there are a new set of tasks in play (most of which are the same as yesterday). Now I want to divide up A and B using the same rules. The task durations are typically 5 days to 3 weeks (variable) and I need to load the resources so that are not overloaded on any given day. After making these assignments, I will need to return to the PM to verify staffing plan and if there is a sufficeint amount of hours assigned to each task to allow the work to be done. If not, he will either need more people or more duration which is going to be a customer driven decision. Am I asking it to do too much? Should I be putting on my VBA hat and attacking it that way, or hasn't my Starbucks coffee kicked in yet this morning? Tag: Customizing Fields and calculations Tag: 121863
  - 23
    - trigger flag when overallocated hello, I have created a schedule for the Field Services Group. I need something to let me know when I overallocate someone right away. Like when I am trying to schedule them in and they are already allocated for that time slot. Is there a flag that could be triggered which could let me know they are overallocated and why they are overallocated? Thank you Tag: Customizing Fields and calculations Tag: 121861
  - 24
    - Calendar View Under one project, we are working on three tasks simultaneously. I would like each task to show up in a different bar color in Calendar view. From reading previous Q@A's it seems I could do this by assigning task definitions arbitrarily as highlighted, external, marked, etc.(options available in Calendar view for designating bar color). My question is: Where can I assign these task types that are compatible with the options in formatting the bar colors in calendar view. Several of the answers said go do this, but where/how? Thank you. Tag: Customizing Fields and calculations Tag: 121860
  - 25
    - How to Generate "Smaller" PDFs Hey guys, I'm on a Mac and my producer has been sending me PDFs of his Gantt charts and they just devour my machine - each page has to build, layer after layer. They remind of incredibly hi-rez Adobe Illustrator files and they just peg my CPU, to the point that I find them almost unusable. Is there a way for him to create smaller PDFs via Project? I'm guessing that the PDFs he's creating have a ton of information embedded within, but all we really need are glorified screen shots. Thanks in advance. Tag: Customizing Fields and calculations Tag: 121857
- Next
  - 1
    - how do I ask for all work that needs to be worked on in the next . can I say today plus 10 days? Tag: Customizing Fields and calculations Tag: 121856
  - 2
    - Resource Usage: Theoretical vs. Practical I have a problem estimating correct billable hours for a resource from the Resource Usage view in a Project plan. Let us look at the tasks for resource X per following example: Task ID Task Gantt Chart ---------- ----------- 1/15 1/31 14 A |=============| 2/10 20 B |==========| 2/15 2/28 25 C | =============| 3/5 3/20 37 D |===================| As per project task needs resource X is not required from 2/10-2/15 and from 2/28-3/5. However, in actual practice the resource will be at client's site from 1/15 to 3/20, for which I will be billing the client. I cannot extend tasks B and C to finish on 2/14 and 3/4 respectively just to ensure resource X is continuously used, because this will extend the project time-line due to downstream dependencies with other tasks in the project. Is there a practical way to represent resource requirement continuously in a project plan without affecting the project time- line? Rgds Srini Tag: Customizing Fields and calculations Tag: 121855
  - 3
    - Importing from Excel - Supposed to be Simple... I'm working how to import Actual Cost by Task from a table in Excel into MSP. What I'm working towards is an Excel tool to track and summarize project costs by task, and then be set up to easily pull updated Actual Cost by Task into MSP. I'm getting nowhere with the Wizard. I've built a two-field source table in Excel that looks like this (this is all test data being worked in a sandbox MSP file): Unique ID Actual Cost 2 $100.00 5 $100.00 6 $100.00 7 $100.00 8 $100.00 9 $100.00 10 $100.00 (etc for 75 or so total records) I've tried all sorts of paths through the Wizard, none of which work. The closest I got was with Merging (Prim Key = Unique ID) with Headers a few lines changed but most did not, and I can't figure out why. Any suggestions or examples of how this actually works would be appreciated. Many thanks, Galen Tag: Customizing Fields and calculations Tag: 121852
  - 4
    - Activities format Hi My fellows: I understand that Project identify WBS structure. My question is if is possible to preassign text format depending to the WBS level. For example, I want to pre set arial bold 12 to every level #2 WBS. Is that possible? Thanks, Ignacio Tag: Customizing Fields and calculations Tag: 121851
  - 5
    - Urgent: Check in Issue (2007) Hello All I am using Project 2007 vesion. Yesterday I was working on a project stored on project server. I will be able to make the changes and publish the projects without any problem. Today when I try to open it is giving me following error You have this project open read-write in another session. To open this project read-write, you must close the project in the other session or check in the project using Project Web Access. I am certain that I do not have the project open in another session. I also checked in "Force Check-in Enterprise Objects ", but there is nothing to check-in. I also reviewed http://www.projectserverexperts.com/Shared%20Documents/checkinprojectsandresources.htm, but there is nothing on 2007. Is there any way to do made the changes at back end?, I am comfortable with sql server. Can any one guide me on this? regards Ashish Tag: Customizing Fields and calculations Tag: 121843
  - 6
    - Percent completed doesn't get updated in the task level after changing in the subtasks If I put 100% in the subtask level for percent completed, task still stays at 0%, may be a Microsoft bug! Tag: Customizing Fields and calculations Tag: 121842
  - 7
    - Leveling Enterprise Resources Hi, we are in a multimedia company with many projects in hand, each on is published to th server, i need to level the resources working o these projects what are you suggestions? we are using ms project 2003 and the project server 2003 along with project web access as the interface. thanks -- asale ----------------------------------------------------------------------- asaleh's Profile: http://forums.techarena.in/member.php?userid=2588 View this thread: http://forums.techarena.in/showthread.php?t=75167 http://forums.techarena.i Tag: Customizing Fields and calculations Tag: 121840
  - 8
    - Using XSL to create a report to display both Task and Resource dat How do I use XSL to create a report that displays both Task data and Resource data in a single row? And how do I know what the the 'local-name()' is for other fields that I may want to include in a report I create? The following XSL file will display only Task data, but I also want to include Resource data, like Resource Initials. <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:template match="/"> <HTML> <BODY BGCOLOR="aliceblue"> <DIV><CENTER> <H2>Unfinished Tasks</H2> <TABLE BORDER="2"> <TR> <TH>ID</TH> <TH>Name</TH> <TH>Defect</TH> <TH>% Complete</TH> <TH>Due</TH> </TR> <xsl:for-each select="//*[local-name()='Task']">  <xsl:if test="*[local-name()='ID'][.>156]"> <xsl:if test="*[local-name()='ID'][.<194]"> <xsl:if test="*[local-name()='OutlineLevel'][.='4']">  <xsl:if test="*[local-name()='Milestone'][. = '0']">  <xsl:if test="*[local-name()='Summary'][. = '0']">  <xsl:if test="*[local-name()='PercentComplete'][. != 100]">  <TR> <TD><xsl:value-of select="*[local-name()='ID']"/></TD> <TD><xsl:value-of select="*[local-name()='Name']"/></TD> <TD><xsl:value-of select="*[local-name()='Notes']"/></TD> <TD><xsl:value-of select="*[local-name()='PercentComplete']"/></TD> <TD><xsl:value-of select="substring(*[local-name()='Finish'],0,11)"/></TD> </TR> </xsl:if> </xsl:if> </xsl:if> </xsl:if> </xsl:if> </xsl:if> </xsl:for-each> </TABLE> </CENTER></DIV> </BODY> </HTML> </xsl:template> </xsl:stylesheet> Tag: Customizing Fields and calculations Tag: 121833
  - 9
    - No hover tooltips In Project 2003 professional, no tooltips are showing when hovering over bars, links or information... any ideas?? (project screentips are turned on btw) many thanks Steve Tag: Customizing Fields and calculations Tag: 121830
  - 10
    - NewFile & cloning If cloning is possible in MSOffice Picture Manager plz tell how. Also how to open a new file in Picture Manager.Thanks Tag: Customizing Fields and calculations Tag: 121829
  - 11
    - Enterprise Resource Pool Problem I have added a new resource pool in the Enterprise Resource Pool. It is already reflected on the Project Web Access (PWA) under Manage Users and Resource Center but when a Project Manager tries to create a new blank project and clicks Tools > Build team from Enterprise.. a project manager cannot see the new resource added even if the settings made by the admin is to display all team members for every project manager regardless of what group.. Kindly help me.. Thanks! Tag: Customizing Fields and calculations Tag: 121819
  - 12
    - Using Generic Resource - Project 2002 I am familiar with implementing a generic resource by simply giving a resource a generic name (Programmer, Analyst, etc..) and assigining that generic name to whatever task is appropriate. In due course, one has the option of replacing the generic resource name with a specifc resource name. I note in the resource information dialogue box, two check boxes which remain unhighlighted. The are the Generic and Inactive check boxes. There seems to be no information in the MS-Project Help. None the less, I am given to believe that there are better ways to signify that a resource is generic. Can anyone explain these two check boxes and how they might be used? Any ideas you may have to help with alternate ways to track generic resources is also appreciated. Tag: Customizing Fields and calculations Tag: 121818
  - 13
    - Multiple Windows of Project Simple Question...I think Does anyone know how configure Project so that even though you have an existing project open you and open another one and it appears in a seperate window? This would allow for toggleing back and fourth? Thanks Tag: Customizing Fields and calculations Tag: 121809
  - 14
    - Analysis toolbar Hello, I have MSP 2003 + SP2. One of my clients can't see the analysis toolbar. Any Idea ? Perl Tag: Customizing Fields and calculations Tag: 121791
  - 15
    - Where to find Project documentation The Project team often gets questions about where to find various kinds of Project documentation -- such as for end-users, administrators, developers, or how to find Project downloads, support and KB articles. The article Project Server 2007: Getting Started with a New Platform for Developers ( http://msdn2.microsoft.com/en-us/library/bb456485.aspx#officepj2007platform__documentation ) is updated and includes a new section about Project documentation The update also includes new information about using datasets in event handlers, and using a SharePoint add-in to check the trace logs for Project Server and Windows SharePoint Services. The Project Developer Portal ( http://msdn2.microsoft.com/en-us/office/aa905469.aspx ) is also updated, to match the recent SDK refresh. --Jim Tag: Customizing Fields and calculations Tag: 121790
  - 16
    - Calculate Date in Project Plan I need help calculating Dates in Project where milestone events will be repeated throughout the project. As an example: I have a project plan to clean up all garages on my street. The milestone event is the Street Address *3504 *and each task will occur at a set number of days for each Street Address. 3504 is set to begin on *6/1/07*. - Order Paint 3 week lead time *(5/11/07) = 6/1/07 - 21 days* - Order Brooms 2 week lead time *(5/18/07) = 6/1/07 - 14 days* - Order Mops 1 week lead time *(5/25/07) = 6/1/07 - 7 days* And I want everything to *arrive at 3504 on 6/1/07*. HOW DO I ENTER A FORMULA TO CALCULATE THE 5/11/07, 5/18/07 AND 5/25/07 DATES?[/B] THE PLAN CANNOT BE BUILT USING PREDECESSORS AS MANY EVENTS WILL BE RUNNING CONCURRENT WITH THE START DATE BEING THE ONLY PREDECESSOR. NOW FOR THE TRICKY PART. . . THE PLAN SHOULD NOW BE UPDATED BY COPYING ALL OF THE ROWS FROM 3504 TO THE NEW ADDRESSES 3507 WITH A START DATE OF 7/1/07 AND EVENTUALLY 8217 WITH A START DATE OF 2/27/09. [B]THE ARRIVAL DATES SHOULD AUTO POPULATE FOR STREET ADDRESSES 3507 AND 8217 BY ONLY CHANGING THE START DATE. Any help is greatly appreciated, Keith -- Keith ------------------------------------------------------------------------ Keith's Profile: http://forums.techarena.in/member.php?userid=25734 View this thread: http://forums.techarena.in/showthread.php?t=751232 http://forums.techarena.in Tag: Customizing Fields and calculations Tag: 121785
  - 17
    - Level resources Hello, I assigned a resource with 100% availability to 2 tasks. Task A: duration = 2 days with priority 600 Task B: duration = 2 days with prioriy 500 For each task the resource assigned to 50% so I don't have an overallocation problem. The resource updated actual time for the first task, the update was 8 hourse instead of 4 hours. This update was only for the first day. At the other days he hasn't updated yet. At the Gantt I can see that the Max unit equal to 100%, so I understand this is the pick. At the Resource usage I see 50% for each day except for the specific day. Now, I'm trying to level. The result is Task B start after task A finish. I thought the project will schedule them together from the second day. Where is the problem ? Thanks Perl Tag: Customizing Fields and calculations Tag: 121783
  - 18
    - Project 2007 standard installation problem After about 2/3 of the installation it hangs up and then I get an error message 1317 that says it cannot create the folder C:\Program Files\Common Files\Microsoft Shared\MSEnv. Verify that the path exists in your system and that you have sufficient permissions to update it. I can browse to the directory but it frequently causes explorer to stop responding. When I checked the properties it was originally read only and eliminated that check mark. I am also logged in as an administrator. Any help? Thanks, Steve Tag: Customizing Fields and calculations Tag: 121782
  - 19
    - Global Template NOT linking I go in and change the enterprise global template, close out, and then open Project back up. The default template never reverts to the enterprise global template but rather the original default table. I'm automatically connected to the server so I don't know what the issue is. Any ideas? -JC Tag: Customizing Fields and calculations Tag: 121779
  - 20
    - overtime calculations I am using Project Standard 2003. I have salaried employees that work overtime on tasks, and I do not want Project to calculate a cost associated with those hours, nor do I want Project to shift the schedule when I add overtime hours. Is this possible? -- Thanks. Confused Tag: Customizing Fields and calculations Tag: 121772
  - 21
    - RAG Status Indicators I remember in previous plans I have worked on, there has been a custom field (flag I think) which represented the current status of each non-summary task in the form of a RAG Status and also it varied the symbol (Circle or a square) depending upon whether or not the work had began. The only problem being that I can't remember the formulae and options to which I set this up as it was quite a while ago....can anyone assist me please? Thanks Lee Anderson Tag: Customizing Fields and calculations Tag: 121767
  - 22
    - strange bcwp computation when multiple resources assigned Hi - I'm having trouble understanding how BCWP (EV) is computed when multiple resources are assigned. Can anyone help? -- Pat Tag: Customizing Fields and calculations Tag: 121763
  - 23
    - How do I add the "remaining work" field to custom resource usage . MS Project 2003 I need to be able to run a cross-tab report, but using "remaining work" rather then work, actual work, etc. I cannot seem to add this field, even though I would assume that it is held on the same table. Tag: Customizing Fields and calculations Tag: 121759
  - 24
    - Who Does What Report I would like to create a report for each of the guys working on my project that shows: 1) their tasks, 2) when they need to finish each task 3) how many hours I think each task should take. This will help them plan their workload. The closest report is the "Who Does What" report - but there are aspects of the report I don't like. 1) (most important), it doesn't put the tasks in order by date. I have tried to "sort by finish" in the "sort" tab, but it doesn't have any effect on the report. 2) it has too many columns - can I hide some of the columns? 3) I want one report for each person - not a combined report - how can I do that? So perhaps there is a completely different, creative way I can get at the data I want. Suggestions anyone? Thanks, Judy -- Judy Tag: Customizing Fields and calculations Tag: 121758
  - 25
    - In project 2003 can muliple resources be shown in resource graph ? I am trying to display histograms for several resources in the same view simultaneously. I can do this by exporting resource usage chart into Excel and using the graphs package. However, I was wondering if anyone knows of a way of doing this in Project 2003 without having to export the information ? Thanks, Hutch Tag: Customizing Fields and calculations Tag: 121757

I created a custom field for Revenue.

It's a simple calculation of 70*Actual_Work. However, actual work has the
hrs designator in their so in order for this calculation to be correct I have
to use another field and take the hrs designator out of the field.

Is there any way to use Actual work the way it is with the hrs designator in
their with the formula. I don't want to have to create a whole new field than
remove the hrs designator for this simple calculation.

Thanks

Top

RE: Customizing Fields and calculations by JimAksel

JimAksel
Wed May 23 16:32:00 CDT 2007

A custom field such as Cost1 or Text1 works just fine.
Insert a Cost1 field (column). Right click on it.
Select Customize Fields
Select Formula
70*[Acutal Work]/60

Why the 60? Work is stored in minutes by MS Project, it may be displayed
differently but is stored in minutes. So, a conversion is needed and will
change depending on the units displayed in the Actual Work column. A more
robust solution would be possible if you tested on the units for display and
then picked your coversion accordingly.
--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

"Bud" wrote:

> I created a custom field for Revenue.
>
> It's a simple calculation of 70*Actual_Work. However, actual work has the
> hrs designator in their so in order for this calculation to be correct I have
> to use another field and take the hrs designator out of the field.
>
> Is there any way to use Actual work the way it is with the hrs designator in
> their with the formula. I don't want to have to create a whole new field than
> remove the hrs designator for this simple calculation.
>
> Thanks

Top