Pages

Search

Enhance formula Microsoft Project

Enhance formula Microsoft Project

Enhance formula

Posted: 28 Jan 2005 06:09 AM PST

In article <com>,
"Steve Scott" <microsoft.com> wrote:
 

Steve,
Formulas can be made as complex as you can stand but keep in mind the
limitations of using a formula in a custom field. The formula can only
work on data relating to an individual task, the more complex the
formula the more likely it will contain a logic error, and formulas only
work on tasks in the Project file where they reside. Formulas are also
quite limited in what they can do (i.e. available functions).

Whey trying to exercise multiple decisions that may involve data
elements from many tasks, (or resource or assignments), VBA is the way
to go. The same complex formula used in a custom field can be easily
broken into smaller elements making it easier to understand and
troubleshoot. A macro stored in your Project Global can be used to
operate on any Project file. If you do not have any experience with VBA,
we will be happy to help you either directly or through suggestions for
learning VBA yourself.

I know I didn't directly answer you question. When I see someone trying
to develop a complex formula my inclination is to suggest a better
alternative.

John
Project MVP

Using a macro to create a shortcut button to apply a resource flit

Posted: 28 Jan 2005 02:09 AM PST

Hello, Blue!

You can't always record your filtering - it's better to record yourself
creating and applying a filter, then you can use the code you get to create
filters for other resources, too.

Remember to use the test "contains" and not "equals", to pick up where a
task is allocated to more than one resource.

Hope this helps

Pete



Sub FilterDaveChow()
FilterEdit Name:="Dave Chow", TaskFilter:=True, _
Create:=True, OverwriteExisting:=True, FieldName:="Resource Names",
Test:="contains", _
Value:="Dave Chow", ShowInMenu:=False, ShowSummaryTasks:=True
FilterApply Name:="Dave Chow"
End Sub


"Blue Giraffe" wrote:
 

duration from more than one task

Posted: 27 Jan 2005 04:49 PM PST

In article <#phx.gbl>,
"Steve House [MVP]" <send.hotmail.com> wrote:
 

Steve,
Actually you probably can create the equivalent of a hammock task with
the link lines showing, but it would take some VBA code to do so
(although I've never tried it). But, I agree with your your second
paragraph. A lot of things can be done with project, it doesn't mean
they all make good sense.

John

A Way to list the WBS number with each task in resource usage view

Posted: 27 Jan 2005 02:11 PM PST

Hi Lisa,

This macro should copy the WBS values into the assignments' Text1 field that
can be shown in any Usage view:

Sub CopyWBS
Dim Job as task
Dim Whodunit as assignment
for each job in activeproject.tasks
if not job is nothing then
for each whodunit in job.assignments
whodunit.text1=job.wbs
next whodunit
end if
next job
end sub

HTH


--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"DTScheduler" <microsoft.com> schreef in bericht
news:com... 
Excel. 
columns 
Gantt 
so 

Base calendar in a Master Project

Posted: 27 Jan 2005 01:33 PM PST

Hi jlb,

PMFJI, but I am puzzled when you say that the master project calendar seems
to take over the scheduling for the subprojects. When I work with inserted
subprojects with different base calendars they maintain the base calendar
definition from each subproject. True the nonworking time *display* in the
Gantt chart defaults to the Master Project nonworking time but each task
schedule (including changes in start time, finish time and nonworking time)
is following its base calendar.

As John notes, any tasks added to the master will default to the base
calendar for the master.

Hope this helps. Let us know how you get along.
Julie

"jlbreyer" wrote:
 

%100 in Project 2003 and 0% complete in PWA

Posted: 27 Jan 2005 12:17 PM PST

Scott --

Whenever the PM receives, approves, and processes task updates into the
Microsoft Project plan, he/she should also click Collaborate - Publish - All
Information to "push" the latest schedule changes to every area of PWA. Is
this your current process?

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
"We wrote the book on Project Server"


"Scott" <microsoft.com> wrote in message
news:com... 

Custom Fields to Subprojects

Posted: 27 Jan 2005 07:31 AM PST

In article <googlegroups.com>,
"Terry" <com> wrote:
 

Terry,
I "preach" the use of VBA a lot on this newsgroup because I hate to see
users struggle with something that can be accomplish very simply with a
little VBA code. You'd be amazed at what can be done with VBA.

John

How to setup so Gantt view starts at project start date?

Posted: 27 Jan 2005 06:29 AM PST

Hi MoJo,

Glad to have helped and thanks for the feedback. Let us know if we can
assist you again.

Julie

"MoJo" wrote:
 

Updating Table & Filter definitions in Plan and Global

Posted: 27 Jan 2005 03:59 AM PST

Ah, now I see. Nope, no affiliation other than I use their products. I
don't frequently see MS employees in this ng. When they do appear in others
their comments are usually followed by legal disclaimers about "implied
warranties" etc.
No offense taken ;-)
Julie

"Peter Rooney" wrote:
 

assigning a group of people to a task

Posted: 27 Jan 2005 03:47 AM PST

Hi Fred,

Welcome to this Microsoft Project newsgroup :-)

Why not call the group, say,"Workers", make their Max. Units 600% and then
just assign a Worker to each task.

FAQs, companion products and other useful Project information can be seen at
this web address: <http://www.mvps.org/project/>

Hope this helps - please let us know how you get on :-))

Mike Glen
MS Project MVP



Fred wrote: 

How can I produce a Project 2000 report in Word?

Posted: 27 Jan 2005 03:27 AM PST

Hi

the only option when it comes to "saving the acutal reports" is to print
them to a pdf file - you can use adobe acrobat (not the reader) or a free /
cheap one like www.pdf995.com (which is what i use)

Cheers
JulieD

"PoshDog" <microsoft.com> wrote in message
news:com... 

How to track time without considering assignment units?

Posted: 27 Jan 2005 02:52 AM PST

Hi,

I'm ok with your definition: the status date is the date when a status
is done on a project: actual work and remaining work are only valid for
this status date. We do a project status during the week as soon as
actuals and estimates to complete are available from our time tracking
tool. The status date is the last friday.

What I was missing was a way to manage tasks AHEAD of the status date:
- do I have to spread extra work on past work, and how?
- how do I see the project gain of time and the final milestone
advance?

I solved these questions by properly configuring the calculation
options of ms project (please see my other post)
Anyway, thanks for your help !

Restricting resource name entry

Posted: 27 Jan 2005 01:42 AM PST

Jan,
apologies... something funny going on with Google.

thanks for the assistance. This is exactly what I was looking for.
great !,

Michael

customizing updates tab in PWA

Posted: 27 Jan 2005 01:03 AM PST

yair o --

The only way to get extra columns to show up in the Updates page in PWA is
to add them as extra published fields in each project. To do so, open each
project and do the following:

1. Click Tools - Customize - Published Fields
2. Select the extra fields you want from the list on the left and copy them
to the list on the right
3. Click the OK button
4. Click Collaborate - Publish - Republish Assignments
5. Click OK

You should also ask your Project Server administrator to add these
additional fields to the Timesheet view if you are using Project Server
2003. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
"We wrote the book on Project Server"


"yair o" <microsoft.com> wrote in message
news:com... 

Can MSP auto adjust the % of a resource?

Posted: 26 Jan 2005 08:43 PM PST

OK, thanks again for the info!!!!

"Steve House [MVP]" wrote:
 

How to add a gridline in gannt chart to show Deadline?

Posted: 26 Jan 2005 08:27 PM PST

Use the drawing tools to put a vertical line in the plan and in the line
properties lock it to the date. A better way than a vertical line would be
to insure you have a final "Project Complete" milestone and all dependency
link paths terminate on it - while not every task in a project will have a
predecessor necessarily, every one will have a successor - if nothing else,
the Project Finished milestone. Then set a deadline (Task Information,
Advanced tab) on the finish milestone. Now MSP will "red flag" if you're
going past the deadline. You could carry it farther and put a deadline on
all the tasks in the plan if you like but I don't think that would be
particularly valuable.

--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

"microbus73" <microsoft.com> wrote in message
news:com... 

color-code a task bar to a resource

Posted: 26 Jan 2005 04:31 PM PST

Hi Thomas,

Welcome to this Microsoft Project newsgroup :-)

You might like to see FAQ Item: 37 - Custom Fields in Tables. FAQs,
companion products and other useful Project information can be seen at this
web address: http://www.mvps.org/project/

Hope this helps - please let us know how you get on :-)

Mike Glen
Project MVP


net wrote: 

How do I show all of my notes?

Posted: 26 Jan 2005 03:37 PM PST

You're welcome Sarah. Glad to have helped and thanks for the feedback. Let
us know if we can assist again.

Julie

"Sarah" wrote:
 

SP1: Can't set Project Start date to anything but 2005

Posted: 26 Jan 2005 01:21 PM PST

You are welcome.
Thanks for posting back your results.

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..
"AllBackJack" <microsoft.com> wrote in message
news:com... 
date 
same 
to 
and 
system's 
it. 

Gantt Chart Bars Do Not Print

Posted: 26 Jan 2005 12:27 PM PST

You're welcome, Elle :-)

Mike Glen
MS Project MVP





Elle wrote: 

Scheduling Multiple Resources for a Task

Posted: 26 Jan 2005 12:03 PM PST

Dale,

Thanks for the help...I have a follow-up question. For the task below; what
would be the best way to track progress? In my case, Resource 3 completed
20% of her work, resource 1 & 2 have not completed any. I went into the view
you showed me and reduced the remaining hours for Resource 3 by 20% but for
the overall task, the % complete still shows zero. Is there a way to have
Project automatically calculate the overall % complete based on the remaining
work for a resource or do I need to manually calculate the overall % complete
based on a 20% completion for Resource 3?

"Dale Howard [MVP]" wrote:
 

Convert SureTrak to Project

Posted: 26 Jan 2005 09:07 AM PST

Thanks Jack. I tried using the mpx, but didn't get any consistent results.
I have tried exporting into Excel and then moving into Project and am able to
get some results. Thanks for the encouragement.
askgail

"JackD" wrote:
 

Leveling Question

Posted: 26 Jan 2005 08:09 AM PST

In addition to the other comments. since you want some tasks to split and
others not to, do the leveling in several passes, selecting the tasks to be
leveled in the current pass and using "Level Selevcted Tasks" instead of
leveling the entire project.

--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

"Michael" <com> wrote in message
news:com... 

how do i let users change dates on the web?

Posted: 26 Jan 2005 07:51 AM PST

Bill at HP --

You must add the Actual Start and Actual Finish fields to the list of
published fields in each project using Tools - Customize - Published Fields.
Be sure and select the "Let resource change field" option for both fields
and then click OK. You must then publish each project using Collaborate -
Publish - Republish Assignments. After doing this, your Project Server
administrator should add these two fields to the Timesheet view in PWA.
Lastly, you should teach your team members how to use these fields properly
while entering progress in their timesheet. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
"We wrote the book on Project Server"


"Bill at HP" <Bill at microsoft.com> wrote in message
news:com... 

Converting Project 97 file to 2000

Posted: 26 Jan 2005 06:29 AM PST

In article <OOnVaF#phx.gbl>,
"Mike Glen" <glenATmvps.org> wrote:
 

Andrew,
First I'd like to hear your response to Mike's question. If you have
additional files for conversion, feel free to e-mail them. My address is
in the header.

John