Search results for query: *

Currently reading Microsoft project 2013 - The Missing Manual and just got to the part that explains the relationship between Duration, Work & Units and I think I have got my head around it and hopefully got Project set up how I require: - Tasks are Auto Scheduled, Fixed Duration and Effort...

Yes it was using the Gantt chart view. What difference do you think it makes using the Task Form? Is it because I am using resources based on the Standard calendar to allocate work to tasks based on a 24hr calendar? Graham

Thanks Julie, Just tried changing to Auto Scheduled tasks and seems to work but I get the errors giving me the options of 'Increase/Decrease Duration' or 'Increase/Decrease Works hours worked per day' I always want the 2nd option and this is why I am using the Fixed Duration type task. Is...

I am trying to use Project as more of an indicator of Resources workload across many projects rather than actual Project Management. Therefore I have the following configuration: - 6 tasks in each project - Tasks are manually scheduled and all linked - Tasks are using a 24 hour calendar -...

Julie, Many thanks for the input and feel free to bump in at any point !! I have defined the days as 24hrs & weeks as 168 hours so the 24 hour tasks are working as 24hrs and the 365 day task is now showing as 365 days on the chart. Will the resources not be defined according to their own...

Mike, That may work but how do I stop Project from re-scheduling tasks when I change the resources that are working on it? Is this with Fixed Duration task?

Mike, I like the idea of the eHrs but my tasks are better expressed in days so I tried eDays and seems to accept it! [smile] Unfortunately I am going to struggle with the % resource and I'll explain why: The Projects are actions that are mostly happening outside of the organisation. What the...

No problem. [thumbsup2]

You mean a break in the data in Sheet2? If so then edit the formula to =IF($A1<>"",$A1=VLOOKUP($A1,Sheet1!$A$1:$A$100,1,FALSE),"") which will check for gaps in the data

Try using the Conditional Formatting as above but change the formula to the following =$A1=VLOOKUP($A1,Sheet1!$A$1:$A$100,1,FALSE) (change the 100 to whatever row you want it to go down to) This should hopefully work ! [smile]

Do you want the matching cells in each sheet comparing against each other? i.e. if Sheet1!A1 = Sheet2!A1, Sheet1!A2 = Sheet2!A2 etc ? If so then use Conditional Formatting on the cells in Sheet 2. Select all the cells you want formatting in col A, do Conditional Formatting based on a formula...

In-frequent user of Microsoft Project but I have been given the task of creating a resource management system to cover the work we carry out and thought I had it working but found lots of problems and would appreciate some advice from more knowledgeable users! Our work involves the following...

Thanks

In-frequent user of Microsoft Project but I have been given the task of creating a resource management system to cover the work we carry out and thought I had it working but found lots of problems and would appreciate some advice from more knowledgeable users! Our work involves the following...