Pages

Search

Restrict entry Microsoft Project

Restrict entry Microsoft Project

Restrict entry

Posted: 11 Jul 2005 10:55 AM PDT

Thanks Reid,

As one Reid to another couldn't some VBA be written to restrict that? We
would like to restrict the PM from changing the total 'Work' or 'Duration' by
direct changes and only have then enter 'time to complete' on the task line
when reporting time to extend or complete early a task.

Does that make sense?

Jim

"Reid McTaggart" wrote:
 

How do I make overdue dates change colour

Posted: 11 Jul 2005 08:37 AM PDT


This NG deals with MS Project, not Excel. The Excel group is
"microsoft.public.excel"

Rita wrote: 

Project schedule consolidation

Posted: 10 Jul 2005 04:19 PM PDT


Hi Max,

Welcome to this Microsoft Project newsgroup :)

You might also like to have a look at my series on Microsoft Project in the
TechTrax ezine, particularly #17 & 18 on Multiple Project s, 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 article 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

Max Currentus wrote: 

Scheduling field techs

Posted: 10 Jul 2005 03:59 PM PDT

It depends - if those field techs are doing identifiable and quantifiable
tasks in a project environment, sure. If they're doing ongoing line of
business service calls, not really. The key is whether there is a
schedulable piece of work with a concrete start and stop time at which point
it can be said it's been done for all time.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs

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

How do I set up traffic light indicators in a Gantt chart?

Posted: 10 Jul 2005 05:49 AM PDT


You're welcome, icabar, and thanks for the compliment :-)

Mike Glen
MS Project MVP


icabar wrote: 

Cost in a Date Range

Posted: 09 Jul 2005 07:14 AM PDT

Hi,

Excellent news!
(Forgive me if I repeat things you might already know)
Alt+F11 brings you to the VB Editor
One of the toolbar icons is "Object Browser"Open it, look for
Timescaledvalues object and TimescaleData method
If you're oinly interested in data on task level (as opposed to the more
detailed assignment level) the heart of your procedure could look like this
Set TSV =
mytask.timescaledata(mytask.start,mytask.finish,pj tasktimescaledcumulativeco
st, _
pjtimescaledays,1)
......
'Search for the position of start and end dates in the Timescalevalues
'I call them B and F

mytask.cost2=TSV(F).value-TSV(B-1).value

OK?

Greetings




De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Peter" <com> schreef in bericht
news:#$phx.gbl... 
out 
3 
for 
de 
filter 
cost 

flexible range of occurence of a recurring task

Posted: 08 Jul 2005 09:51 AM PDT

Hi Pinocchio,

Sorry, not that I am aware of. In testing, even after adding additional
tasks and editing the summary recurring task, it does not pick up the new
project end date. I had to manually change the end date to equal the new
end date of the project.

There may be a way through VBA but I am afraid that is outside of my skill
range.

Perhaps another person(s) have a better idea.

Hope this helps.

Julie

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

Project Tasks as Outlook Tasks

Posted: 08 Jul 2005 08:57 AM PDT

Hio,

Allocatus has an option to show them as tasks OR appointments
At least in their documentation (part of which I translated)

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

Link my Project calendar my Outlook calendar

Posted: 08 Jul 2005 07:34 AM PDT

Maurice, that's awesome - does exactly what I want it to. Many many thanks.

Can I run a report in Projects to find a circular relationship?

Posted: 08 Jul 2005 07:02 AM PDT

I found one summary task with a successor. Removed the the link and the
project began to calculate one again.
Catfish Thanks JDM

"Jan De Messemaeker" wrote:
 

Is it normal to have many base calendars defined?

Posted: 08 Jul 2005 02:13 AM PDT

I tell my students that they should create a base calendar for each major
shift group and legal jurisdiction in which their project takes place. Here
in Canada, for example, the province of Ontario has different legal holidays
from the province of Quebec so if my project has resources in both
jurisdictions, I'll need at least one base calendar for each. If we work
around the clock, I'll need a base calendar for my day-shift workers,
another one for the swing-shift workers, and yet another for the folks on
graveyard. So now we're up to 6. I'd pick one of those calendars, the one
that is most generic, covers the majority of the workers involved in this
specific project, or even the nominal work hours at the project's
headquarters and make it the Project Calendar. Remember one of the basic
uses of the Project base calendar is to answer the question of "if I have a
task that can start Monday at 10am and will take 24 hours to complete, what
date and time will it finish?" Since work, hence progress, can only take
place when the resources are there to do it, the calendar is crucial to
determining which of the minutes during the 24-hour clock-day will buy you
some progress towards completion.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs


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

enterprise resource

Posted: 08 Jul 2005 12:02 AM PDT

Gerard --

Thanks for the kind compliment! :)

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


"Gérard Ducouret" <fr> wrote in message
news:phx.gbl... 

Enterprise fields VS Views

Posted: 07 Jul 2005 03:46 PM PDT

Angel --

Out of curiosity, what are you trying to accomplish? The Microsoft Project
Data Model governs the behavior of task, resource, and assignment fields.
Here's how the Data Model works:

Task fields are displayed in task Views, Tables, Filters, and Groups.
Resource fields are displayed in resource Views, Tables, Filters, and
Groups.
Assignment fields are only displayed in the Task Usage or Resource Usage
views.

Hope this helps.

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


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

Hold out on entering dates?

Posted: 07 Jul 2005 02:56 PM PDT

90% of all projects are date critical but that doesn't mean you should
figure the dates outside of Project and pump them in as user input.
Remember that Project's reason for existence is to calculate the start and
finish dates of the tasks within your project. I like to think of it as
"you don't tell Project the dates you're going to work, it tells you the
dates you both SHOULD work and will BE ABLE to work." The fancy views and
Gantt charts are just frosting on a piece of schedule calculation software
but are not the reason it exists or the reason to use it.

When you enter dates in the Start and Finish columns for your tasks, the
Start date entry sets a "Start No Earlier Than" constraint and that says
that under no circumstances will the task ever be scheduled to start earlier
than that date. BUT it can be pushed later than that date no problem. The
same for entering a date in the Finish column - it sets a "Finish No Earlier
Than" constraint. If you enter both dates, the constraint is determined by
the last date entered.

Tasks can only happen when the predecessors and resources come together so
that everything required to do the work is in place. You might have a
commitment on 1/1/05 but the promise of delivery is not in itself enough to
make it happen - there are a myriad of other things that have to happen for
it all to come together on the 1st. Project's job is to take the was you
organized the work at the moment and tell you if you'll finish on schedule
or not. If not, it tells you the date you will hit the way things are
presently organized and a model that will let you experiment with changing
the organization - rearranging resources, for example - to come up with a
strategy that WILL have it hit the promised dates.

The hard dates you mention should be entered as deadlines. Project will
monitor them and tell you if the plan as you have presently entered it will
meet them or not. In the best of all possible worlds, you'd build the plan
in Project BEFORE agreeing to the commitment dates with the customer, prior
to negotiating the contracts, using the project schedule to determine what
is realistic and doable before promising the moon, but most of the time we
don't have that luxury unless you're lucky enough to work for a
project-driven company that has learned the wisdom of that approach.

I'm sure you feel that your situation is unique and you can't work the way
we suggest but believe me, it's not. If you try building the plan by
entering specific dates on which the tasks will take place it will be a
miracle if you end up with a usable schedule. I have yet to see an example
of such an approach that didn't end up with a "wishful thinking" plan that
bore no resemblance to what actually happened in reality when the project
was worked. Often it's a waste of the time spent building it because the
resulting plan was useless for real world work scheduling, failing to allow
proper progress monitoring, or to alert for emerging problems. Trust us,
you'll have a far better shot at hitting those "must hit" commitment dates
if you try it our way - we've been there before.
--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs



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

Are calendars related to each others?

Posted: 07 Jul 2005 02:48 PM PDT

Very, very clearly put!
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Pinocchio" <com> schreef in bericht
news:phx.gbl... 
just 
calendar 
time. 

How to take care interruption to a task?

Posted: 07 Jul 2005 12:12 PM PDT

Work and duration are totally different measures even though both are
counted using the same units. Duration is *defined* as the total possible
working time between when the task starts and when it finished, regardless
of whether work is actually taking place continuously thoroughout that time
or not. Therefore you can't change the finish date and have the duration
not change for the same reason that you can't say 7 minus 4 equals 2, it's
simply not mathematically correct. On the other hand, work is the portion
of that time actually being converted into useful output. So if your finish
date changes, the duration MUST change because that's simply what duration
IS, the time between start and finish but Work can remain constant even as
the finish date changes. The resource is just working on that task at a
lower average rate with the new finish date. In your example, the task
duration started out as three days and the resource was working at 100%,
doing 3 day's work over the course of 3 days duration. Now the finish date
is pushed back by 2 days because the resource's work on it is interrupted.
He's still generating the same 3 days worth of output. So now he's doing 3
days of work over 5 days of duration for an effective effort units
percentage of 60%

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


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

VB - Toggling the outline indent

Posted: 07 Jul 2005 10:41 AM PDT

Leo,
You cannot use a named argument in an "if" test. DisplayNameIndent" is a
named argument to the OptionsView function. There is no property in the
object model called "DisplayNameIndent", so you can't use it to check the
state of the name indent.

In fact, there is currently no property in the Project object model that
corresponds to the field in the dialog box. Check out the following article
for a list of the fields in the dialog box that DO have properties associated
with them:

http://www.microsoft.com/technet/scriptcenter/topics/office/manage/project/projectvi.mspx

Best you can do is set the value using the OptionsView method, and set some
other variable or custom property to keep track of its state. Good luck!

Kevin

"Leo" wrote:
 

Template timelines starting at week -12

Posted: 07 Jul 2005 09:23 AM PDT

Hi Debbie,

DateDiff("ww", [Date1],[Date2], 1)

interval = "d" for Days, "ww" for weeks....
Replace Date1 and Date2 by any date field.
firstdayofweek = 1 for Sunday; 2 for Monday (optional)

Hope this helps,

Gérard Ducouret

"Debbie G" <microsoft.com> a écrit dans le message de
news:com... 
Can 
and 
tasks 
MS 
can 

Import data

Posted: 07 Jul 2005 09:19 AM PDT

Both. As needed - and programmatically. As to format - that is also what
I need to know - in order to import the data - how do I format the transfer?

"Brian K - Project MVP" wrote:
 

calendar & custom fields

Posted: 07 Jul 2005 07:43 AM PDT

Hi,

Format, Bar Styles, Text Field(s)
HTH

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

Reporting to Non-project users

Posted: 07 Jul 2005 06:47 AM PDT

Hi,

I don't understand.
I don't have Adobe, but I use one of these free pdf things called cutepdf
and it works.
PDF printers are supposed to print the same you would have on paper aren't
they?
Does it work on paper?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"spidersinthekitchen" <microsoft.com>
schreef in bericht
news:com... 
range. 
the 
about 
sheet 
to 
Ideally 
have 
am 
I 

How to force project not to split a task over multiple days

Posted: 07 Jul 2005 02:14 AM PDT


You're welcome, and good luck! :-)

Mike Glen
MS Project MVP


latearrival wrote: 

messy gantt charts and ordering tasks

Posted: 06 Jul 2005 10:13 PM PDT


You're welcome, Gemma :-)

Mike Glen
MS Project MVP


gemma wrote: 

Comparing resource names in VBA

Posted: 06 Jul 2005 04:12 PM PDT

In article <com>,
Kevin Towers <microsoft.com> wrote:
 

Kevin,
First, let me answer your last question. Visual Basic has several
methods that can be used to compare strings. The best method to use
depends on what kind of strings (i.e. whole string, middle characters,
single character, etc.) are being compared. I use the Instr Function
quite often but I also use a simple If statement (e.g. If t.Text1 =
"bob" Then).

I haven't studied your code thoroughly but on the surface it seems a
little backward. The resource loop and task loops are not helping each
other. The outer loop will go through all resources, not just those that
are assigned to each task. In effect, if the runtime error didn't occur,
Flag5 will be set true for all tasks (or at least those tasks with
resource assignments). I don't think this was your intent. I agree with
Brian's response. Loop through the tasks and look at the assignment
property when comparing.

Also, I thought you wanted to look for a particular resource who was
assigned to all tasks in a given date range. If so, some type of input
is needed from the user to specify which resource. For this I would use
an InputBox Function.

Finally, without actually testing your code, I suspect the runtime error
occurs because normally there are no assignments on Summary Lines. When
the inner loop goes through the tasks the first one is likely to be a
Summary line and hence there is no resource name associated with the
task.

Hope this helps.
John
Project MVP

Project Server has returned error code -1

Posted: 06 Jul 2005 04:11 PM PDT

Ups! Sorry
Project Server 2003 in English
and the error its send when update task from Microsoft Outlook Calendar

"Mike Glen" wrote: