Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 11-11-2010, 09:48 AM
projectman projectman is offline actuals vs estimates Windows XP actuals vs estimates Office 2003
Novice
actuals vs estimates
 
Join Date: Nov 2010
Posts: 13
projectman is on a distinguished road
Default

in the tracking table I only see the task name. even when I move the vertical bar to the right.
Reply With Quote
  #17  
Old 11-11-2010, 09:57 AM
Kimberly Kimberly is offline actuals vs estimates Windows 7 actuals vs estimates Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

You might as well make a custom table then. View > Table > More tables... New

Give the table a name and use the drop-downs to add 'Name' plus the 7 other fields.

In the upper right-corner, check the box to 'Show in menu'.
Reply With Quote
  #18  
Old 11-11-2010, 09:59 AM
projectman projectman is offline actuals vs estimates Windows XP actuals vs estimates Office 2003
Novice
actuals vs estimates
 
Join Date: Nov 2010
Posts: 13
projectman is on a distinguished road
Default

okay

I will try that and let you know how I make out

thanks for all of the help so far
Reply With Quote
  #19  
Old 11-11-2010, 12:15 PM
projectman projectman is offline actuals vs estimates Windows XP actuals vs estimates Office 2003
Novice
actuals vs estimates
 
Join Date: Nov 2010
Posts: 13
projectman is on a distinguished road
Default

I have the fileds entered into the task in the order that you seggested. do I need to do a baseline save in orer for the info in these fields to stick?
Reply With Quote
  #20  
Old 11-11-2010, 01:27 PM
projectman projectman is offline actuals vs estimates Windows XP actuals vs estimates Office 2003
Novice
actuals vs estimates
 
Join Date: Nov 2010
Posts: 13
projectman is on a distinguished road
Default

Kimberly

I tried your suggestion and I could not get the actuals to agree with what I was putting in.
the example I used

I have the calandar set to a 6 hour work day.
baseline start 11/01/10 baseline finish 11/03/10 baseline work 18
actual start 11/01/10 act finish 11/02/10 actual hours 9

if I enter the act start of 11/01/10 and the act finish of 11/02/10 and the act work at 9, the act work changes to 12 and the % comp is 100. if I change the act work back to 9, the act finish goes to NA and the % comp goes to 75.
I am beginning to think that project can't do estimates verus actual tracking.
Reply With Quote
  #21  
Old 11-11-2010, 03:32 PM
Kimberly Kimberly is offline actuals vs estimates Windows 7 actuals vs estimates Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Don't give up already! This is not a typical use of Project, and it is taking me some time to figure out what you are doing, but I do believe it will work fine. I think you do not use the difference between work and duration, but for your purposes they are the same thing.

Try this:

Change the fields.
Get rid of all fields that contain the word "Work"
Instead add fields so they're in this order:
Name, Baseline Start, Baseline Finish, Baseline Duration, Actual Start, Actual Duration, % Comp, Actual Finish

See if you can enter the baselines (you can enter the Baseline Dur as 18h) and then the ActualStart and then ActualDuration (9h) and project will calculate the rest.
Reply With Quote
  #22  
Old 11-12-2010, 11:27 AM
projectman projectman is offline actuals vs estimates Windows XP actuals vs estimates Office 2003
Novice
actuals vs estimates
 
Join Date: Nov 2010
Posts: 13
projectman is on a distinguished road
Default

Kimberly
this seems to be working. I will add this to my project sheet that has all the tasks that I am tracking. I have been working with a test sheet for now.

it is not that I was giving up, it is just that I have been working onn this for a couple of weeks. first it was the problem where only a certain amount of data in the notes field was getting exported when I created the excel sheet for this project. I was working with someone to get a macro together that would export all of the information in the notes field.

then I had this problem.

I do have a couple of questions.
1) does the order of the fields in the sheet matter? in two of your responses, you mention to enter the fields in a certain order.

2) I have created the fields and entered the data in the tracking table. is this where I do all of the editing to the tasks when it comes to the dates and durations? is the entry table just for entering the tasks for the first time and adding any fields that do not pertain to dates and durations.

again
thanks for all of the help that you have given me on this.

3) when the boss and I were taking about this, he was talking about baselines being done on a monthly basis so thet we can track the progress from 1 month to another. since I am using the baseline fields to hold the estimate information, this will screw this all up , won't it? if he wants to baseline, how would we handle this?
Reply With Quote
  #23  
Old 11-13-2010, 09:37 AM
Kimberly Kimberly is offline actuals vs estimates Windows 7 actuals vs estimates Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

1. I doubt it, as long as Actuals are entered last. I specified the order so you would do Actuals last, and also hoping that if it did do any recalculations, it would do the same there as on my test machine.

2. It is my belief that you can use any table for anything. My understanding is that under all the pretty interface, the data is stored in just one enormously wide table. When you specify a particular "table", all you are actually specifying is which pre-arranged bunch of columns you want to work with. So modify away, use any table or a home-made, I don't see why it would matter.

3. I think that manually entering the baseline numbers has eliminated the need to use the command to set baselines.
Reply With Quote
  #24  
Old 11-15-2010, 07:23 AM
projectman projectman is offline actuals vs estimates Windows XP actuals vs estimates Office 2003
Novice
actuals vs estimates
 
Join Date: Nov 2010
Posts: 13
projectman is on a distinguished road
Default

Kimberly

okay, i guess that is it. I will start to add all of tasks that we have been tracking on our excel sheet into the project sheett and we will see how it goes

again thanks for all of the help on this
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 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