Prev: Best way to enter part time resources
Next: satisfaction
From: Wilson on 16 May 2008 09:10
I have a table of data. In column A, I have the names of tasks and in column
B I have their expected finish dates. I need to find only those tasks that
have the sub-string "Execute Assembly Test" (approx 107 tasks) and then
determine, based on column B (expected finish), the date that we can expect
90% of those tasks to be complete. Can anyone help me, I'd like to attempt
to do this in an efficient a way a possible.

Thanks again.


From: Trevor Rabey on 16 May 2008 10:09
First part is a piece of cake.
Just make a filter to find the tasks with the string.
Make sure the filter includes a line to exclude the summaries (Summary=no).
Then copy the finish dates of the resulting tasks and paste them into EXCEL,
where you have a whole bunch of stats functions available.
In EXCEL I would use Insert Function to set up the right function.
I leave the stats part to you.

Trevor Rabey 0407213955 61 8 92727485 PERFECT PROJECT PLANNING
www.perfectproject.com.au
"Wilson" <Wilson(a)discussions.microsoft.com> wrote in message
news:94473E82-835E-4BE3-8214-310AE4A75424(a)microsoft.com...
>I have a table of data. In column A, I have the names of tasks and in
>column
> B I have their expected finish dates. I need to find only those tasks
> that
> have the sub-string "Execute Assembly Test" (approx 107 tasks) and then
> determine, based on column B (expected finish), the date that we can
> expect
> 90% of those tasks to be complete. Can anyone help me, I'd like to
> attempt
> to do this in an efficient a way a possible.
>
> Thanks again.
>
>


From: Wilson on 16 May 2008 11:11
I was wondering why I wasn't getting any responses... I apologize, this was
supposed to be posted to the excel forum, not the MSP forum. This forum is
setup as my homepage and I simply forgot to switch over when I made the post.

Cheers.
 | 
Pages: 1
Prev: Best way to enter part time resources
Next: satisfaction