Actually, using Analyse Data In Excel IS very easy. You can select specific activities, the whole project,individual resources etc. Once the raw data is in Excel, you can manipulate the data as you wish. Ok, it might not always automatically do everything your heart desires, but no software ever does. In less than ten minutes, Ive been able to produce stacked-histograms for 30+ resources. Ultimately, you have to consider what information is genuinely useful. Just because the software can give you the same information in 5000 different ways, it doesnt mean that it is of any great use. My analogy is the use of automatic windscreen-wipers on some cars. Basically, they are f***ing useless. Ive never yet found them making the decision to start and stop at the time I would want them. So, just because something can be done, it doesnt mean it is of any real benefit.
You may also want to try downloading a trial copy of DecisionEdge from www.decisionedge.com which has some great reporting features that are far better than MSP2007.
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
The best way is via the "Analysis" toolbar. You can "Analyse Data In Excel". Very simple, very straightforward. MSP/Excel does all the work for you, formats the data and generates the graph.
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
I also use Jayas method.
Just copy and paste from the Task Usage view into excel and produce curves
View > Task Usage Sheet...Somehoow equal to the Tabular > Resource loading comment in P3
Regards
Venkat
Hi Alexandre,
Actually, using Analyse Data In Excel IS very easy. You can select specific activities, the whole project,individual resources etc. Once the raw data is in Excel, you can manipulate the data as you wish. Ok, it might not always automatically do everything your heart desires, but no software ever does. In less than ten minutes, Ive been able to produce stacked-histograms for 30+ resources. Ultimately, you have to consider what information is genuinely useful. Just because the software can give you the same information in 5000 different ways, it doesnt mean that it is of any great use. My analogy is the use of automatic windscreen-wipers on some cars. Basically, they are f***ing useless. Ive never yet found them making the decision to start and stop at the time I would want them. So, just because something can be done, it doesnt mean it is of any real benefit.
Cheers.
James.
You may also want to try downloading a trial copy of DecisionEdge from www.decisionedge.com which has some great reporting features that are far better than MSP2007.
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au
Hi,
unfortunately it is not SO easy and straightforward as James says; but hes right when saying it is tje ONLY way to do what you want with MSP 2003
S curves is a good reason to upgrade to MSP 2007
Alexandre
Hi Shane,
The best way is via the "Analysis" toolbar. You can "Analyse Data In Excel". Very simple, very straightforward. MSP/Excel does all the work for you, formats the data and generates the graph.
HTH.
James.