Project Dashboard

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
    - Vacation Schedules on Large Projects How do you handle them - Best Vacation Schedules on Large Projects How do you handle them - is there a Best Practice I can follow from your experiences? Anyone able to offer some advice? I have a project with 80 team members. How do you hanldle scheduling vacations/time-off when planning/using MS Proj 2003. I know you can enter everyones vacation as it arises easily in Project but with 80 people I am wondering how you have accounted for it - or how you made it an easy process so that vacation does not ruin the schedule, with 80 people, that equates to a ton of time off for people over a year long project. Look forward to your comments. Tag: Project Dashboard Tag: 92593
  - 2
    - VB problem I am trying to use Jack Dahlgren's "Export to Excel" code found at http://masamiki.com/project/exporthierarchytoexcel.bas and am receiving an error on the following line of code: Set xlRow = xlRow.Offset(I, 0) I have installed the Excel library. Has the library changed making the offset command not work anymore? Thanks, Scott Hanebutt Tag: Project Dashboard Tag: 92591
  - 3
    - VB offset error from Jack Dahgren's Code I am trying to use the "Export hierarchy to Excel" code that Jack Dahgren wrote found at http://masamiki.com/project/exporthierarchytoexcel.bas. When I run it I get an error on the following line of code: Set xlRow = xlRow.Offset(I, 0) I have added the Excel library refrence. Is it possible that the library has changed and that the offset feature no longer exists or works differently? Thanks, Scott Hanebutt Tag: Project Dashboard Tag: 92590
  - 4
    - Baseline compare I have received Project schedules. But, it does not appear they have created baseline(s) nor statused the updates. Can I compare one updated schedule to another, even if no baseline was created? I am most interested in gantt bar comparison like one would do had a baeline been created. Tag: Project Dashboard Tag: 92585
  - 5
    - Resource Rate - Escalated Table Dear Sir (or Madam); Contracting to the government involves planning labor rates, under two circumstances: ON-SITE vs OFF-SITE, over an esclation schedule. For example; ON-SITE ($/hr) | 2004| 2005| 2006| 2007|2008 etc.. Engineering Scientist |59.80|61.60|63.44|65.34|67.31|... Engineering Technician |24.84|27.81|25.59|26.35|27.14|... etc. OFF-SITE ($/hr) | 2004| 2005| 2006| 2007|2008 etc.. Engineering Scientist |65.00|66.95|68.95|71.02|73.15|... Engineering Technician |27.00|27.81|28.64|29.50|30.39|... etc. These Resource Rate data presently exist in an Excel spreadsheet. Question: What's the best way to import this kind of resource info into Ms. Project?... Tag: Project Dashboard Tag: 92583
  - 6
    - Project Training We are planning to deploy a Microsoft Porject server environment, however, I want to know what type of training should give to my users and the server administrators. This will be an enterprise project and a lot of people are going to use this. Thanks for any input. Tag: Project Dashboard Tag: 92572
  - 7
    - Resource Calculations Is there an easy way to get the total amount of work hours for all resources for a given time period? For example, I would like to find out how many hours we have projected for the year 2006. Resource usage shows the total amount in the ERP regardless of what filter I apply. Also, Is there a way to export the right hand side of the Resource usage view to Excel? -- R. Shigley Thermadyne Tag: Project Dashboard Tag: 92565
  - 8
    - How to deny the 'editing' permission on the outline project category Hi all! I've a question about grants in PWA-MSP.. I've got a list of Outline Project Codes in the Enterprise Global... I've also a group of Project Managers who have to read/write their data in the projects. Not enought: i've set the group ADMINS in order to manage the outline project category. The question: it is possible to ALLOW the editing of the Outline Project Code to the ADMIN group and set it up to DENY to the PROJECT MANAGER grouop? TY!!! Andrea Tag: Project Dashboard Tag: 92564
  - 9
    - A new year Some help needed for a novice. The project I am trying to manage will run over a period of about 15 months starting on 01/12/04 - it will finish February 2006. However, a new cycle will start on 01/12/05, and I want to copy all of the details into a new schedule starting at that time. I want to keep all the tasks, durations, notes, etc, but rescheduled according to the new calendar. I will then edit the schedule to meet the requirements of the next cycle. So, I want to roll the project forward to start on a new date whilst keeping all the details intact. Any help would be much appreciated. Jim Jones Botswana Tag: Project Dashboard Tag: 92562
  - 10
    - How to hide inactive resources Hello, I am working on a project that has been going on for more than a year. Some resources have come and gone in the project and they entered actual work in the past. Is there a way for me to hide these resources that are no longer apart of this project. It would greatly reduce the number of resources lines that appear. Thanks! Tag: Project Dashboard Tag: 92559
  - 11
    - critical path Hi, I am quite new to MS Project. I am looking at eavluating my project and have viewed the critical path. My question is, how do you make a task critical? Or how does project calculate it? Thanks for your help. Tag: Project Dashboard Tag: 92557
  - 12
    - How do I unlock a fild document in microft word? I was building a document and saved it overnight. The next day I was unable to go on with my document. How do I unlock a fild locked document? I tried ctrl+F11 this does not work. Tag: Project Dashboard Tag: 92555
  - 13
    - How do I change Start Date Format to read DD_MMM_YYYY HH_MM-SS as How do I change the default view in Start and Finish Dates to read 24 hr Clock -- Shutdown Scheduler Tag: Project Dashboard Tag: 92545
  - 14
    - Pls Help - Task Duration vs. Total Calendar Time Please explain how to do the following: Show that a task takes a certain amount of time (e.g., 8 hours) BUT those 8 hours will span a 2-week period. For example, it may take 3 hours to obtain scope approvals, but I want to note that I estimate that to complete those 3 hours of work to obtain approvals will take/span 5 days (one week). Tag: Project Dashboard Tag: 92544
  - 15
    - zooming in on task pane - not gantt chart hello, I want the font in the task pane to stay at the default - 8 or 10 - however, it is too hard to see when working it in - I cannot figure out how to zoom in so that I can read each task but print it at 8 or 10 point? Thanks in advance Kimberly Tag: Project Dashboard Tag: 92543
  - 16
    - have a red x instead of chart ms project I have opened MS project and all my programs of works have red x's instead of charts Help!! Tag: Project Dashboard Tag: 92542
  - 17
    - colour code milestones in calendar view? have a long list of milestones that filtering into a calendar but need to split up those milestones by use of colour coding. currently i am only able to change the colour of the whole group of milestones and don't know how to differentiate some of them so that i can coloour then differently. Abel to change colours in gantt chart so assume there is a way to carry this out in calendar view. thank you for your time. Tag: Project Dashboard Tag: 92541
  - 18
    - How do I print the gantt only up to the project finish date? I have set my project start and finish date, but my Gantt chart prints an additional year and half past the finish date. I tried the date range in the print window, but that isn't changing it either. Does anyone know how to control this? Thanks! Tag: Project Dashboard Tag: 92540
  - 19
    - Constraint - Start no earlier than I am setting up a schedule in Project 2003. Within it are a couple of tasks that must start no earlier than Feb. 2, 2006. I have gone into the 'Advanced' tab and set them that way. Perhaps there's something fundamentally flawed about my understanding of this, but I can't see where that's reflected anywhere in the schedule. Next to the tasks are an icon indicating the constraint. But the start date of the tasks is the next day after the predecessor, as if I'd never set it. And if I look at the 'To-Do' view, I see these tasks needing to get done on the early date not the constrained date. I would have expected that Project would push the 'Start' date out to equal with the Constraint date. If it doesn't do that - and it shows up in the earlier date in reports - what good is using it? Is there some setting I have to adjust? Tag: Project Dashboard Tag: 92537
  - 20
    - Can I import custom graphical indicators? I would like to add my own custom graphical indicators to th pull-down menu in the Image column on the Graphical Indicators fo "..." dialog box (Tools > Customize > Fields > Graphica Indicators). Is this possible? How Tag: Project Dashboard Tag: 92525
  - 21
    - Microsoft Project Timescale - Week Ending vs Week Starting Has anyone developed a Week-ending report for Microsoft Project? Currently all of the timescale "timephased" data are based on Week-starting. What I am looking for is someone who has developed a macro, custom report, or mapped the internal data to a spreadsheet to create a week-ending report. For example the first week in October end on Saturday: Sun Mon Tue Wed Thu Fri Sat 25 26 27 28 29 30 1 <-- Week ending Nov 1 Microsoft project Resource Usasge report with a two-tiered timescale would put this week into the October "bucket" as the week starts Sep the 25th; 9/25-10/01 Regards Doc Tag: Project Dashboard Tag: 92523
  - 22
    - Cost per deliverable I often manage projects that deliver multiple functionalities in a single release, with multiple sponsors per release. These sponsors require progress reports for their specific deliverables. I would like to be able to link specific tasks to specific deliverables. In addition, I need to spread the cost for overhead tasks (such as project management) over the deliverables (e.g. 80%-10%-10% for three deliverables). The way I have implemented this now is by adding a "number" column and a "cost" column for each deliverable. For each task I enter the percentage that the task contributes to the deliverable. The "cost" column is calculated using [number]*[cost]. This is a very crude way of getting there. Any suggestions for a more elegant method? Thanks, -- Paul van der Spek CRM Implementation Project Manager Tag: Project Dashboard Tag: 92518
  - 23
    - Saving Reports to MS Word Hi all, this may sound repeated but once I have generated a report, is there anyway I can insert that report into a Word Document. BTW I'm using MS Project 2003. Thanks Tag: Project Dashboard Tag: 92512
  - 24
    - Work Week MSP98 (Newbie Question) Hi Folks - seems like the most basic of tasks has me challenged! I need to set every day of the month (every month) as working time. MSP98 seems to calculate the working week as 5 days regardless of what I set in the Tools>Change Working Time options. For example: 'Nov 14th 05' to 'Dec 11th 05' should be displayed as 28 days but in fact it wont even calculate that period instead changing the start date or end date, and the duration is calculated as 19 days! How can I get 100% of the month to be used as working time? Cheers and TIA -- Kahuna ------------ Tag: Project Dashboard Tag: 92511
  - 25
    - Wrap text in Microsoft Project 2000 I cannot get all of my rows to wrap text when printing. the original document when in MS Project 2000 wraps the text but when printing -or- making a .pdf, the text will not wrap. any solutions, perhaps a 'patch' -or- is there something wrong with the printer / acrobat setup??? The row heights are adjusted to properly display text description Tag: Project Dashboard Tag: 92509
- Next
  - 1
    - how to get total duration of all tasks in month, day, etc.? I want to know how I can automatically calculate the total of all activity durations in any given day, week, month, year. I now have to count down a schedule graphically, for each month, using 20 days per month max, to calculate the the total work days for the month. Example: say 5 activities are active in the month of April. Three of the 5 are active for the whole month and two are active for 10 days during the month. Thus, (3 x 20 = 60 work days) + (2 x 10 = 20 work days) = 80 work days of total activity in those 5 activities for the month of April. Does anyone know how to get Project to do this? Thxs, Joe Tag: Project Dashboard Tag: 92503
  - 2
    - Visual Basic Code I have read that there are VB scripts available for Project. I am wondering where I can find them, particularly "Export to Excel" by Jack Dahlgren. Thanks, Scott Tag: Project Dashboard Tag: 92485
  - 3
    - Critical Path - Critical Chain Tracking of Projects Critical Chain is a variation of Critical Path; it adds resource leveling to the critical path consideration. Tasks in a chain become critical if task duration or resouce availability changes would cause a delay in the project completion. When I resource level in project, the tasks do not show up in the critical path (view: Detail Gant) unless I set the task precedence. For a task group (using only one resource each task) that should be on the critical path, leveling does schedule the tasks to occur sequentially, but the group does not show up as a critical path. I would like tot Detail Gantt to show this is the critical path (or critical chain!). Thank you Tag: Project Dashboard Tag: 92484
  - 4
    - Installed Project SP2 - Still having resource baseline problem I installed SP2 for Project 2003. I thought that it would fix resource amounts being correctly rolled up after a Save Baseline for Selected task was performed. I did check the radio buttons to roll up the totals. But the Resource Usage display shows that the Work amount is correct but the total for Baseline Work is not. If I baseline the whole project it works. Our office is trying to have stagg only baseline the tasks that are affected by approved change requests instead of baseling the whole project. Did SP2 fix this and if not when is it going to be fixed? Tag: Project Dashboard Tag: 92480
  - 5
    - Can I import data from excel into project I need to import selective data from an oracle data base into MS Project. This information is downloadable through an interface that will dump it into an Excel spreadsheet. It is just raw data. I need it formatted properly for MS Project (with indentions and links). What are my options? I could possibly have the data sent to me in a different way (from the data warehouse). I need guidance. Could I create a template in project that would contain the correct format? Could I take the data directly to Project with out the Excel step? Any ideas? Tag: Project Dashboard Tag: 92478
  - 6
    - Predecessor Driven Completion I am attempting to drive completion of a task by marking the completion of its predecessor tasks. That is, given task A with predecessors 1-8, I would like task A to show incremental increases in completion % whenever I check off one of the predecessor tasks as 100% complete. Is this possible to do or could someone help me write a macro for it? Thanks! Mike Tag: Project Dashboard Tag: 92474
  - 7
    - time phased network diagram I can see how to line up the network diagram in columns of days, weeks, or months. I can't see how to label each column. Is there a way. jlb Tag: Project Dashboard Tag: 92470
  - 8
    - enable copy and paste function When I try to copy and paste, I get function disable! How do I correct this? Tag: Project Dashboard Tag: 92469
  - 9
    - PPBES and Project All of the threads I have looked at deal with Project doing projects. I am trying to use Project to look at dependencies in the PPBES. My almost totally ignorant "MS Project perspective" is that Project is round peg and PPBES is a round hole as PPBES is an ongoing process, ad infinitum. Does anyone have insight, or can point me in the direction to get some help? thanks in advance. Tag: Project Dashboard Tag: 92465
  - 10
    - Hiding Subproject summary tasks? Is there an option in MS Pro 2003 to only show some summary tasks that I want? I don't want the Project Summary Task to show so I uncheck this in Options>View. I have a massive master project with lots of subprojects and when you look at the Gannt View there are many summary tasks. I only want to show the summary tasks within the subproject (Tasks) and not the 'mini' project summary task for the overall subproject if that makes sense. If you want more info please ask. Sorry to be so inconvenient with my questions. Thanks Tag: Project Dashboard Tag: 92456
  - 11
    - No work vs. zero work- how to erase? Greetings again! When work has never been assigned to a resource on a particular day that the task usage view shows no value for that day. However, it appears that once work is assigned, it can then be zeroed out, but I can't figure out how to blank it out (meaning restoring it to the original state before work was assigned, where it wasn't zero on a particular day but rather was nothing, blank). Anyone know how? Thanks, George Tag: Project Dashboard Tag: 92451
  - 12
    - Task splitting - a process, not a parameter? Greetings! This is to check my understanding from observation of how task splitting works. (1) It would appear that when a task is split, which can only be done graphically, Project moves the work for the assigned resources from the start of split out to the end of the split-off portion of the task as you pull the split over. This achieves the same result as manually zeroing out a resource's work in the middle of a task assignment and moving it to the end. (2) Different than (for example) a delay, there is no parameter to record a split point or duration. As a result, in order to adjust a split, you must grab the task bar and move it, or fiddle with the daily work assignments. Also, there isn't a parameter that can be tested to check for a split. Does this sound about right? Thanks, George Tag: Project Dashboard Tag: 92450
  - 13
    - Find all timephased data for a particular local resource in Project 2003 Hi All, Does anybody know how to find all timephased data for a particular local resource in Project 2003? Regards, Ronen Tag: Project Dashboard Tag: 92447
  - 14
    - Colour Coding! Hi there, I have recently set up a Project in the 2003 version, to track all development jobs passing through the IT department. I have set up a customised field which has a drop down listing, of items such as , 'To Be Quoted, In Progress, On Hold, LIVE, Cancelled......etc'. What i am trying to achieve is that when i select a particular value from the drop down list, i want the relevant Gantt bar to change colour. I have tried to do this from within the 'bar styles', dialog box, but it doesn't seem to be able to cater for criteria such as 'If 'Ref Status', equal to 'LIVE', (then colour should be set to Green)! etc. Any help would be greatly appreciated. Kind Regards Nicholas J H Evans Tag: Project Dashboard Tag: 92446
  - 15
    - (Pool) resource calendar v project calendar Hi, I have a resource pool and a calendar for the resources in the pool. I want to assign a resource to a project and have the working time result from the overlap between the resource calendar and the project calendar. I know I can do this by using task calendars but is there any other way besides setting a calendar for every task in the project? TIA Zuri Tag: Project Dashboard Tag: 92445
  - 16
    - MS Project Template for PBX replacement Starting a project to replace a SIEMENS PBX. MS-Project template of project from an actual project would be useful. Tag: Project Dashboard Tag: 92439
  - 17
    - Actual work incorect in Project Pro when importing from MSP_TIMEPHASED_DATA table App Name: Microsoft Project Server 2003 We have an external process that populates the MSP_TIMEPHASED_DATA table with actual work for project plans on a weekly basis. We use the "EXT_EDITED" flags as suggested by Microsoft. I have confirmed that what we want to push into the TIMEPHASED_DATE table and what makes its way into it are in sync. The following is an example of the behavior we are noticing. I have verified that the timephased_data table contains actuals of: 1000hours for Resource A assigned to Task 1 2000 hours for Resource B assigned to Task 1 0 hours for Resource C assigned to Task 1 (this is indicated by NO rows for this specific Resource and task existing in the table). The task is set to Fixed Duration and has a Start Date of Sept 1 2005 and a Finish date of Dec 31st 2005. When the file is opened I will notice something like this: Resource A has a total of 1200 hours of Actual Work. Resource B has a total of 2100 hours of Actual Work. Resource C has a total of 900 hours of Actual Work. In addition, assume the last date actuals have been entered in is the last week of November of 2005. I will notice that end dates being extended out a couple of months and work being spread across that time. The problem is two fold. Additional actuals have been manufactured and Finish dates have changed when they should not have. If I close the file without saving (so that I don't overwrite the timephased_Data table data) and change the task to fixed work or fixed units by modifying the task_type field in the MSP_Tasks table, I notice the correct actuals when I open the file again. The dates have off course re adjusted but the total actuals and the individual values in the weeks are correct to the decimal point. I have also tried to manually replicate the issue by creating a fixed duration and entering all the data manually (work and actual work) in the timephased buckets. In this case I noticed the correct behavior where the finish date remains constand and the remaining work is re-spread accordingly. Can anyone explain this weird behavior? Thank you, Jason Elios Tag: Project Dashboard Tag: 92435
  - 18
    - Level of Effort tasks How can I set up a "Level of Effort" task that starts at the beginning of a project and ends at the end of the project and will automatically extend and contract to stay equal to the project lenght if the project lenght changes due to additional tasks, overruns, etc? The LOE task is a bucket for things like answering phone calls, misc meetings, filling out time tickets, etc. Tag: Project Dashboard Tag: 92433
  - 19
    - Import Calendar from Outlook Can you import a calendar from Outlook??? Thanks, Barb Tag: Project Dashboard Tag: 92418
  - 20
    - Converting between mpx and mpd Anyone know of any tools that will convert mpx files to mpd files and back (other than MS-P that is). I have a visual planning tool that exports in mpx and a webbase Project Management Info System that is mpd based. It would be expensive to buy everyone a copy of MS-P just to be a peice of middleware. Simon Tag: Project Dashboard Tag: 92415
  - 21
    - Hiding Resource Rates I have a Resouce Pool with 2000+ resources. It contains the hourly rates for all the resources to allow me to generate cost data from project plans. However for HR reasons I need to hide the rate information from plans that are linked to this pool. Tried a few idea's but short of having two versions of the Pool with and without rates and linking/unlinking from ALL the sub-projects when i need to do budget work (tried it and takes a couple of hours) I'm at a loss. Help Simon Tag: Project Dashboard Tag: 92414
  - 22
    - Maximum number of hours allowed per day I would like to know what is the standard used by other users when setting up a Maximum number of hours allowed per day. We were thinking of leaving it with about 16 hours (just in case), but if someone needs to enter more hours, is there a way to override that value on the fly? or the default will need to be changed?. I am just curious. Thanks in advance! Tag: Project Dashboard Tag: 92408
  - 23
    - how to test a formuala The formula i wrote isn't getting the results I thought, how do you go about debugging a formula? Tag: Project Dashboard Tag: 92405
  - 24
    - Resource Assignment and Levelling Hi, I've been using MS Project for only a little while, and used to do all levelling manually. Since my current project involves too many resources, I'd like to find better ways. I have a few questions... 1) Can MS Project assign resources from a group of resources? For example, I have 3 PLSQL programmers and 8 Java programmers. The PLSQL tasks can be completed by either one of the PLSQL developers. Is there a way to tell MS Project to select the best resource to optimize the result? 2) Our company uses multiple project plans, all linked to a master plan and a single master resource file. If I decide to use automatic levelling of my plan, will it affect the dates on the other plans? If yes, is there a way to prevent it? I don't believe the owners of the other plans would like it very much. --> Most of the resources on my plan are mine alone, but a few are shared. Tag: Project Dashboard Tag: 92399
  - 25
    - need template to handle vast information for search and rescue i need to get or develope a template/program to handle vast amount of information on volunteer workers for search and rescue HELP please Tag: Project Dashboard Tag: 92397

Does anyone know if it is possible to create a project dashboard for a single
project using project server, project web access, or project pro? If this
isn't a simple option then are there any existing tips/tricks on how one
would create a dashboard.

The purpose of the dashboard would be for statusing the project -
(controlling and reporting) as well as tracking schedule related metrics as
defined in custom fields.

Thanks in advance for the feedback --

Re: Project Dashboard by Mike

Mike
Mon Oct 31 10:56:49 CST 2005

Hi WD,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

WD wrote:
> Does anyone know if it is possible to create a project dashboard for
> a single project using project server, project web access, or project
> pro? If this isn't a simple option then are there any existing
> tips/tricks on how one would create a dashboard.
>
> The purpose of the dashboard would be for statusing the project -
> (controlling and reporting) as well as tracking schedule related
> metrics as defined in custom fields.
>
> Thanks in advance for the feedback --

RE: Project Dashboard by Mark

Mark
Mon Jan 16 12:19:03 CST 2006

Did you find an answer to your post? I am also interested in this topic.

"WD" wrote:

> Does anyone know if it is possible to create a project dashboard for a single
> project using project server, project web access, or project pro? If this
> isn't a simple option then are there any existing tips/tricks on how one
> would create a dashboard.
>
> The purpose of the dashboard would be for statusing the project -
> (controlling and reporting) as well as tracking schedule related metrics as
> defined in custom fields.
>
> Thanks in advance for the feedback --
>
>