Pages

Search

Formula Question using Calendar Microsoft Project

Formula Question using Calendar Microsoft Project

Formula Question using Calendar

Posted: 30 Aug 2005 08:51 AM PDT

If you want calendar days, just use some simple math.

IIf([Finish]-[Current Date]>180,"More than 6 months",IIf([Finish]-[Current
Date]>90,"More than 3 months",IIf([Finish]-[Current Date]>0,"within 3
months","overdue")))

Only use the calendar if you want to calculate days according to Project's
calendars, otherwise it is simple subtraction. Note that order is important.
The statement will stop at the first condition that is satisfied.
--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html



"Marc" <microsoft.com> wrote in message
news:com... 
which 
weekends 
is. 
Calendar])/10560>=6,"Due 

Resource across projects

Posted: 30 Aug 2005 01:47 AM PDT

Hi Helen,

Why Sad? If you knew the kind of questions I myself asked here 6 years ago..
I never felt sad about that!

A la prochaine..

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Helen" <microsoft.com> schreef in bericht
news:com... 
line 
and 
us 
absence, 
make 
worked 
that 

Tracking Purchased Costs and Project Labor

Posted: 29 Aug 2005 07:47 PM PDT

Hi,

TASKS can have material resources and material resources can have per unit
costs.
You can have totals of labour costs PLUS material cost on tasks, roll them
up into summary tasks, etc.
BUT you cannot have material cost and labour cost separately.
HTH

(IMHO for AXAPTA you need about 50 times the learning effort than for
Project)

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

Revised Target (Finish) Dates

Posted: 29 Aug 2005 02:12 PM PDT

Adding on Jan De Messemaeker's suggestions, you may also:
1. Click on the Split Task button
2. Drag the unfinished part of the task to the resource return date

or

1. Select the task
2. Tools> Tacking> Update Project Plan
3. Select the second option (Replan uncompleted work so it starts) and
select the date when the resource returns
4. Select Selected Tasks and OK

Hope that help.

--
Stéphane Dubé, M.Sc. Adm.A.
GO Project Management
www.go-project.com
514-912-7765


"toast88" wrote:
 

Import Dates and Duration from Excel

Posted: 29 Aug 2005 01:52 PM PDT

Here is what I am trying to do:

I have an excel sheet with 5 columns, task ID, task name, start date,
duration, and another text field. When i try to import the data into MS
project I go to the import wizard and merge data, I have the ID field as the
primary key. all the fields import OK into project except the start date and
duration. basically nothing changes on these 2 fields in MS project. for
example, if the start date for the task is 1/2/06 and i try to overwrite it
with 1/31/06 from excel, after the import is complete the date is still
1/2/06 (nothing changes). The task name comes across alright so does the text
field.

"Steve House [Project MVP]" wrote:
 

Text fields with <CR> <LF>

Posted: 29 Aug 2005 01:49 PM PDT

OK. It's just that I copy some text to Textn variables using VBA. If the
original text contains special characters such as <CR>, <LF>, <TAB> then I
get an error message.

I got round my problem by using the following line(s):

Str=replace(Str,vbCr,";")
Str=replace(Str,vbLf,";")
Str=replace(Str,vbTab,";")
Task1.Text6 = Str

It is a bit heavy but works. The special characters become ";"

Thanks again
Kamil

"JackD" wrote:
 

Open project files in read-only by default?

Posted: 29 Aug 2005 09:26 AM PDT

This looks promising, I'll pass it on! Thanks!

"Dale Howard [MVP]" wrote:
 

Consolidated Resources

Posted: 28 Aug 2005 07:13 PM PDT

Thanks for your help. I am able to see the names now.
--
ECD


"Jan De Messemaeker" wrote:
 

Model for Litigation Matters

Posted: 28 Aug 2005 06:25 PM PDT

Haris:

Thank you for the insights and links.
--
Craig


"Haris Rashid" wrote:
 

Constraining Specific Tasks Exclusive of Other Work

Posted: 27 Aug 2005 10:34 PM PDT

Hello John & Harris,

Thanks to both of you for two very thoughtful suggestions. I found both
methods to make sense with my limited knowledge and will probably try both of
them out to determine which works best for my specific situation.

Thanks,
Allen

"Haris Rashid" wrote:
 

Why is Project so RUBBISH

Posted: 27 Aug 2005 02:04 PM PDT


Hi Jason,

Welcome to this Microsoft Project newsgroup :)

You might like to have a look at my series on Microsoft Project in the
TechTrax ezine at this site: http://tinyurl.com/2xbhc or this:
http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23
(Perhaps you'd care to rate the articles before leaving the site, :)
Thanks.)

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

Brian K - Project MVP wrote: 

Multiple milestone within a specific task

Posted: 27 Aug 2005 12:55 PM PDT

That would be several distinct tasks. I know you don't want to do it but
the work involved in development is quite different from the work done, for
example, in testing. A proper task breakdown takes it to the level of
detail where a signle task is one block of work done by one skill set
resulting in one deliverable. Milestones are also distinct tasks, the
"gates" that occur at the end of performance activities. So the proper
model in your situation is a minimum of a summary task with at least 6
sub-tasks indented under it. In the real world, each of the perofrmance
subtasks would probably be a summary in its own right with a number of
component activities detailed out indented underneath it. The rule of thumb
is that if the duration of a single task exceeds 80 hours you probably need
to break it down further. You need to get to the level that a single task
represents ONE thing done by ONE person or team working together. You've
called this a "software package" - at the very least each component part of
the package would be a separate task or series of tasks.

A: Software Package Development
1: Develop Software
2: Development Complete (milestone)
3: Test Software
4: Testing Complete (milestone)
5: Rewrite Software
6: Debug Complete (milestone)
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


"Jason Cocking" <com> wrote in message
news:deqgfs$8bc$dmz.ncs.ea.ibs-infra.bt.com... 

How do I setup a supply chain?

Posted: 27 Aug 2005 09:53 AM PDT

Haris Rashid wrote:
 

it might be a little premature to say that Project Server will serve this
persons needs. I agree that they should look into it but all we have right
now is two very (VERY) limited paragraphs giving a 100,000 foot view of
their situation. A true solution would be down around 100 feet. There is a
TON of detail needed before anyone should feel comfortable saying that any
application WILL provide the solution this customer needs. Be careful.

--
Brian K - Project MVP
http://www.projectified.com
--
Senior Trainer - Electronic Arts
--
QuantumPM Associate
http://www.quantumpm.com

MS Project - Manage several hundred projects that have the same sc

Posted: 26 Aug 2005 08:09 PM PDT

Rod,

What about reports covering all locations? Is 1) the only one that can
accomplish this as all locations would be located in one file?

Also, what about using Project in its Enterprise mode? Several (remote)
people would need access to Project. Are there any limitations to 1), 2) or
3) when using Enterprise?

..........Rick

"Rod Gill" wrote:
 

Customizing Calculations

Posted: 25 Aug 2005 01:18 PM PDT

If I understand your question I believe the solution is in how you enter the
type of change to get desired result. Remembering the formula D(uration) *
U(nit) = W(ork) you fix one variable, change a second variable (e.g. work)
and Project calculates the third variable.

In your case is sounds like you you want Fix Work, not Duration, (e.g.
prevent it from changing) change the Duration so the Project recalculates
Units for you.

Hope this helps.



"taylordelo" wrote: