Hi,
Can anybody recommend an add-on for MS Project that facilitates executive management reporting please? Key requirements being:
-Produce visually simple Gantt timelines comparable to a PowerPoint presentation rather than the standard MS Project Gantt timeline functionality.
-Be able to...
Hi,
I have multiple Excel workbook files stored in the same folder location, each workbook file has one worksheet with a table of data. Every table in each of the workbooks is in a consistent format (so the columns are in the same order with the same data type).
Is anyone able to advise on a...
Hi,
I have multiple Excel workbook files stored in the same folder location, each workbook file has one worksheet with a table of data. Every table in each of the workbooks is in a consistent format (so the columns are in the same order with the same data type).
Is anyone able to advise on a...
Hi,
Does anyone know of a reasonably priced planning workshop tool out there? I am looking for something that is particularly good for initial brain-storming planning sessions to replace the 'large sheet of paper on the wall with post-its' approach.
So it would allow:
- The quick creation of...
Hi,
I have created a view in MS Project 2013 that shows tasks grouped by Resource Name (via Views / Group By) similar to the standard 'Resource' Group By option. This works fine as long as there is only one Resource Name in the Resource Name column.
However, if there are multiple names in the...
Hi,
I have a MSP programme plan that imports data from a large Excel spreadsheet and updates the task/milestone lines using an import map. These lines are grouped in the Excel doc by the project they relate to, with approx 200 projects.
The Excel doc is basically a flat file, and does not...
Hi,
Can anyone help with a suggestion for the following please? I apologise in advance for the long mail!
I have a 'Milestone Exception Data' table in Excel that lists milestones (one per row) and gives Start / Finish dates for each milestone. There is also a column that shows days delay for...
Hi,
I have set up some imports to take project plan data from an EPM data extract in Excel into an MSP plan, so that dates automatically update from the EPM data extract. End result is to show a high level roadmap with key dependencies in MSP.
I am encountering two issues though, and wondered...
Hi,
I have a large MS Project file (9mb) with different views. Is there a way (other than screen-print into Word / PowerPoint) that I can export / copy a selected gantt-chart view from MS Project (e.g. the timelines / milestone icons etc) so I can send to other people to view?
The key...
Hi,
I am having problems with conditional formatting in Excel 2010. I want the format of a cell (column B) to change based on the value in column A.
In column B, I am using the Conditional Formatting / New Rule / Formula to determine which cells to format option, and inserted the formula...
Hi,
Slightly strange question but does anyone know of an alternative to the standard critical path analysis method (i.e. tasks - duration - dependencies - network diagram).
I am creating a programme plan, so by its very nature it does not have all the detailed tasks and dependencies in. Many...
Hi,
I have created a view and assigned a filter to it. The filter is very simple and designed to only show selected milestones, using a Flag column to show rows where the Flag value = Yes (i.e. is a selected milestone). Normal Tasks / other milestones should be hidden (Flag = No).
However...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.