Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2016, 03:53 PM
sooghtac sooghtac is offline Rebaseline process and data verification Windows 7 64bit Rebaseline process and data verification Office 2013
Novice
Rebaseline process and data verification
 
Join Date: Feb 2016
Posts: 3
sooghtac is on a distinguished road
Default 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
Attached Files
File Type: xlsx MS Project Forum example.xlsx (109.6 KB, 17 views)
File Type: docx Rebaseline instructions.docx (378.4 KB, 16 views)
File Type: zip Schedule.zip (904.7 KB, 13 views)
Reply With Quote
  #2  
Old 02-13-2016, 12:30 PM
JulieS JulieS is offline Rebaseline process and data verification Windows 7 64bit Rebaseline process and data verification Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 02-14-2016, 02:35 PM
sooghtac sooghtac is offline Rebaseline process and data verification Windows 7 64bit Rebaseline process and data verification Office 2013
Novice
Rebaseline process and data verification
 
Join Date: Feb 2016
Posts: 3
sooghtac is on a distinguished road
Default 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.
Reply With Quote
  #4  
Old 02-15-2016, 08:23 AM
JulieS JulieS is offline Rebaseline process and data verification Windows 7 64bit Rebaseline process and data verification Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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/
Reply With Quote
  #5  
Old 02-15-2016, 03:42 PM
sooghtac sooghtac is offline Rebaseline process and data verification Windows 7 64bit Rebaseline process and data verification Office 2013
Novice
Rebaseline process and data verification
 
Join Date: Feb 2016
Posts: 3
sooghtac is on a distinguished road
Default

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
Reply With Quote
  #6  
Old 02-16-2016, 07:20 AM
JulieS JulieS is offline Rebaseline process and data verification Windows 7 64bit Rebaseline process and data verification Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

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.
Attached Files
File Type: xlsx Schedule report.xlsx (26.0 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rebaseline process and data verification Process Automation saurabhlotankar Excel Programming 10 06-03-2015 05:50 PM
Rebaseline process and data verification Outlook process not closing Alan.bailey Outlook 2 02-12-2015 08:56 AM
Rebaseline process and data verification 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
Rebaseline process and data verification anti-spam with email verification bighorse Outlook 2 09-24-2007 06:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:17 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft