Pages

Search

how do I add numbers from two different columns? Microsoft Project

how do I add numbers from two different columns? Microsoft Project


how do I add numbers from two different columns?

Posted: 04 Oct 2004 12:25 PM PDT


Ben,
All you need to do is set up a custom field with a formula that add the
two other fields (columns). Go to Tools/Customize/Fields and, depending
on what type of data you are using (i.e. cost, duration, number, etc.)
pick a spare field (e.g. Number1 if the columns to be added are integer
or floating point values) and hit the "formula" button on the Customize
Fields windows. Then just set up the formula you want. For example,
Number1 = [Number2] + [Number3].

Note that the formula will apply to all task rows, not just a single
task and you will need to select the appropriate roll up formula for
Summary rows on the Customize Fields window.

Hope this helps.
John

Finish Variance

Posted: 04 Oct 2004 09:47 AM PDT

As Jan said, or phrased another way, to see how you did compared to how your
originally thought you were going to do.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

"Hallie Kay" <microsoft.com> wrote in message
news:com... 


Is there a master calander for ALL projects?

Posted: 04 Oct 2004 09:12 AM PDT

You have a couple of choices. You can set up an Enterprise Global calendar
in Project Server if you are using that and want your celndar to be avaiable
to all the PMs developing projects, or, if you're not yet using server,
create a calendar (I'd suggest using a copy of the Standard calendar so you
retain the master, although you could edit the Standard if you wish) in the
current project file, could even be a blank project, that shows all the
holidays etc for a convenient time period. Then, use the Organizer on the
Tools menu to copy the customized calendar in the working project file back
into the Global.MPT template to make it available to all other projects.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Jason" <com> wrote in message
news:%phx.gbl... 


How can I apply a project plan shell or template to another, exis.

Posted: 04 Oct 2004 08:57 AM PDT

Hi Jan,

All settings. I want to "apply" the template with all calculations such as
Earned Value (we use some customer calcs and views) and custom views to an
existing workplan and resource pool. In my scenario, someone has created a
work plan without the custom settings and views. I would like to apply all
custom calcs and views to another workplan.

"Jan De Messemaeker" wrote:
 

Duration does not properly add

Posted: 04 Oct 2004 05:39 AM PDT

Durations are not additive. The duration of Testing will be the time
between when the earliest PreTest starts and the latest PreTest ends. It
will be 30 days ONLY if the subtasks occur in sequence with no overlaps or
gaps. Also check in the Tools Options Calcualtion page to make sure it's
set to Automatic - from your message, Testing should be 10 days, not 5.

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


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


Changing Dur creates a Schedule Conflict?

Posted: 04 Oct 2004 05:27 AM PDT

Posted a partial message somehow - sorry. Could you have any actuals posted
to any of the tasks that are scheduled later than the task you're trying to
change? Once an actual is entered that fixes the task to the dates where it
is posted as having taken place.

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

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


Does MS Project allow routing for approval to department heads?

Posted: 03 Oct 2004 11:23 PM PDT

You're welcome, Terecy:-)

Mike Glen
MS Project MVP


Terecy Joyce Chia wrote: 


Any way to reflect teams in Project?

Posted: 03 Oct 2004 10:34 AM PDT

I suppose you could set up two resources to indicate the
same individual, then put him in 2 different teams.

i.e. Bill-Design
and Bill-Process Engineering

Reporting would be odd - could I view a consolidated cost
report on Bill as a whole?



 

How to show Activity on Arc Network Diagram?

Posted: 02 Oct 2004 08:44 PM PDT

Don't know about other products but this is not a feature of MS Project.
Activity on Arrow diagramming is falling into disuse these days anyway.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

"Katie" <microsoft.com> wrote in message
news:37a401c4a8fb$4c3a8de0$gbl... 


tasks report

Posted: 02 Oct 2004 01:07 AM PDT

Hi,

Auto Filter, filter Name on contains "Excavation" (ore whichever)

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"raduga_fb" <microsoft.com> schreef in bericht
news:com... 
specified 
to 
tasks 
be 


MS Project/Project Server

Posted: 01 Oct 2004 01:13 PM PDT

Thank you for your time and assistance, gentlemen.



E

Pesky Approvals!!!

Posted: 01 Oct 2004 10:10 AM PDT

Allen --

There is no default method within Project Server to automatic the processing
of task updates into each project plan. The closest that you can come to
automation is for each project manager to create one or more Rules in
Project Web Access, but the PM must still click the Run Rules Now button to
process the updates. Hope this helps.

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


"Allen" <com> wrote in message
news:google.com... 


Setting resource %

Posted: 01 Oct 2004 06:42 AM PDT

Adding a bit to Julie's excellent answer ... I'm a believer that the
resource's calendar should reflect the hours that they are "on the property"
as they used to call it in the old railroad days, i.e., physically present.
So a full-time employee would have an 8 hour a day calendar, assuming
typical working conditions. A part-time working 4 hours per day would have
a calendar reflecting a 4-hour workday, etc. If a full timer was only
available to the project 4 hours a day, their calendar would still show 8
hours but their maximum availability would be 50%. This shows that in each
workday they will accomplish up to a maximum of 4 man-hours work on my
project but I'm going to let them organize their own workday and decide for
themselves which hours during the day they're going to do project stuff and
which hours will be spent on other things.

Also note, Project will never change the duration estimate for a task with
the first resource assignment, regardless of the percentage you specify. It
assumes that whatever percentage you say the resource will be working at,
that was what you had in mind when you came up with the initial duration
estimate. So a 4-day task will stay at 4 days whether you assign the
resource to it 100%, 50%, 25%, or what have you. At that first assignment
the work is calculated. If you then *modify* the assignment later, the
duration, work, or effort will get recalculated based on the task type
settings.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Pam" <microsoft.com> wrote in message
news:2d7c01c4a7bc$741a56f0$gbl... 


using projects over

Posted: 30 Sep 2004 11:39 AM PDT

THanks Jan,

The gretat majority of task dates were adjusted; a minority were not. I will
do more testing to see if I can discover why.

"Jan De Messemaeker" wrote: