#1
|
|||
|
|||
Rebaseline process and data verification
Hi there,
New to the forum.. and need some help. We've been rebaselining projects for years and downloading into an excel sheet that captures the data into a graph displaying cumulative original baseline, cumulative % complete, and rebaseline schedule when required. I didn't write the procedure on baselining, however my team assure me they're the same as the past 2 years but only has the graphs recently showing the re-baseline not looking correct. If you rebaseline a schedule, it should pull through actuals to date. If you have a look at the attachment I have, you will notice the rebaselined schedule drops off in November quite significantly not following the % complete. I've included the original and rebaseline data and copy of schedule. I've also included our instructions. Hopefully someone is able to identify what is going wrong! Thanks in advance |
#2
|
|||
|
|||
I'm afraid I don't follow. Your directions look fine and I see the most recent baseline is Baseline saved on Feb 1. All tasks with the exception of tasks 35 & 36 have both baseline starts and baseline finishes. Baseline 2 also saved on Feb 1 does not have baselines for any 100% complete tasks - which is what I would expect given the directions.
What data are you looking for? Can you be more specific about "you will notice the rebaselined schedule drops off in November quite significantly not following the % complete". There is no baseline % Complete. |
#3
|
|||
|
|||
More detail
Once we re-baseline, we download the budget work report in US date time then paste it into the graph tab Column C5 of the example originally attached.
The idea is to then create an s-curve showing original, revised and the actuals completed. The actuals are manually input by Project Managers from the total % complete from the schedule. If you view the s-curve graph, you will notice that the re-baseline is not similar to the % complete line item from November. This seems to indicate that the actuals are not being pulled through correctly on the work book. Are we running the work book correctly using the budget workbook in weeks? As mentioned previously, this s-curve graph worked fine with re-baselines and appears from approx. November things have changed. We not longer use Project Server due to the complications, however I can't see that being a problem. Hope I've clarified your queries. |
#4
|
|||
|
|||
Sorry, I'm not seeing what you report. When I open the Schedule.mpp file and create the Budget Work Visual report - I see data through Week 41 in 2016.
There have been some ongoing issues with Timescaled data. Are you up to date with patches to Project 2013? The latest version if 15.0.4797.1000 See: https://blogs.technet.microsoft.com/...pport/p/msp13/ |
#5
|
|||
|
|||
Hi there,
Yes on pretty much the latest January 15.0.4787.1000. Unfortunately I work for a very large company so have to wait for the install patch. Is anyone on the latest able to try for me? Hoping my instructions are now clear. Thanks |
#6
|
|||
|
|||
I have stepped through creating the Baseline work report. As I stated earlier - I see full data. I've attached the Excel spreadsheet.
The report pulls Baseline Work, Baseline1 Work, Baseline 2 work. I didn't step through the entire process of creating the S-curves - just grabbing the data out of Project. That part works fine. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Process Automation | saurabhlotankar | Excel Programming | 10 | 06-03-2015 05:50 PM |
Outlook process not closing | Alan.bailey | Outlook | 2 | 02-12-2015 08:56 AM |
seprate process data from main master list | Santhosh AMASL | Excel | 1 | 01-12-2015 09:33 AM |
Configuration process problem | Dunn2009 | Outlook | 0 | 10-02-2009 02:38 AM |
anti-spam with email verification | bighorse | Outlook | 2 | 09-24-2007 06:44 PM |