Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2014, 08:32 AM
theWizardAKQ theWizardAKQ is offline project for projected vs physical Windows 7 64bit project for projected vs physical Office 2007
Novice
project for projected vs physical
 
Join Date: Jan 2014
Posts: 2
theWizardAKQ is on a distinguished road
Default project for projected vs physical

Hi everyone! I'm new to the form and have searched for an answer to my question to no avail, so decided to post a questions for what I'm struggling with. I use MSP 2007, I have a simple schedule but I need to track/calculate planned vs actual and I don't want % complete to go back and change my "planned" units automatically. I included a sample I use in Excel now. Basically all tasks actual were either over or under planned, but all work is 100% complete. Is there anyway to pull this off using projects?



Thanks in advance!

See attached PDF. Thanks
Attached Files
File Type: pdf sample.pdf (72.0 KB, 10 views)
Reply With Quote
  #2  
Old 01-23-2014, 12:16 PM
JulieS JulieS is offline project for projected vs physical Windows 7 64bit project for projected vs physical Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Yes. You should model the work in Project, entering tasks, durations, relationships, resources (as you are tracking work and cost). Then before you start supplying actual data - save a baseline. The original baseline data:baseline start, baseline finish, baseline work, baseline cost, baseline duration) will then not be changed by entering actuals. Project will calculate variance - work, cost, start, finish, and duration for you.
Reply With Quote
  #3  
Old 01-23-2014, 04:11 PM
theWizardAKQ theWizardAKQ is offline project for projected vs physical Windows 7 64bit project for projected vs physical Office 2007
Novice
project for projected vs physical
 
Join Date: Jan 2014
Posts: 2
theWizardAKQ is on a distinguished road
Default

JulieS - You got me on the right track for sure! Thanks!!!
Reply With Quote
  #4  
Old 01-24-2014, 06:16 AM
JulieS JulieS is offline project for projected vs physical Windows 7 64bit project for projected vs physical Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome. Feel free to post back with further questions as needed.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
project for projected vs physical complete % and physical complete % ketanco Project 3 05-25-2012 08:19 AM
project for projected vs physical Separate projected view vs. PC view possible? frank14612 PowerPoint 3 02-19-2012 02:43 AM
Connectivity issue of Project Professional with Project Server kashif Project 0 03-27-2009 06:37 AM
Error 9571 when opening Project Server from Project Pro mona Project 0 04-24-2007 07:50 AM
Different % complete in Project Center & View a Project mikaelbelchior Project 1 01-25-2006 12:56 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:48 PM.


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