Preventing spread allocations
When I have multiple tasks occurring on the same day I've noticed that
project tends to stretch both of them out over the entire length of the
day rather than filling out the first contiguous time slots.
This can make it very hard when trying to manually adjust daily
assignments without leveling since each time slot that has a value
allocated to it needs to be edited. Is there a way to change this
behavior so that assignments will preferentially fill up the first
available time slots?
e.g. - If I had two tasks for 4 hours each on the same day I'd like
Project to schedule one for 8-12 and once for 1-5 rather than have both
scheduled at .25hrs per 15 minutes throughout the whole day.
Thanks,
John
p.s. - I realize I could likely use predecessors to force this behavior
but in this case the tasks aren't truly linked they just happen to
overlap. Tag: invalid key 's' Tag: 110511
How do I read the Start and End Time of a Day
Can anyone help me with this problem: I would like to read the start
time and the finish time of a given day from a resource calendar using
VBA. For example, if on the 30/9/2006 the working time started at 7:00
am and finished at 5:00pm, then I would like to read 7:00am as start
and 5:00pm as end time for this day.
I can not find the vb syntax to read this. Thanks in advance.
Atish Tag: invalid key 's' Tag: 110509
Multiproject Merging
I have in MS Project 2003 standard a multiproject from 15 input single
projects.
Now I need to have only one project with the same contetns.
How can I do it not so laborious ?
Thanks
Ivan Samel Tag: invalid key 's' Tag: 110508
HOWTO have tasks without wbs code
Hi all,
I have a schedule where in the top lines I keep the contract award and
program milestones with deadlines dates. These tasks are linked (with
SS relationships) to the corresponding review activity in the network
schedule. This way I can see if I have a problem in meeting customer
predefined dates for the milestones without setting constraint dates
(that could spoil the Critical Path).
My question is how can I exclude these tasks from having a WBS code?
I saw a schedule like this in the afmc pamphlet 63-5.
Thanks you all,
Andr=E9 Tag: invalid key 's' Tag: 110507
Tasks keep moving
Hi,
When I have a few tasks all linked. If I change the start time or
duration of one of the tasks all the tasks before it will change and
the ones below wont.
What I am trying to do is move the task in the middle and then have all
the ones below move forward and not the ones before.
I hope it is clear, if not please ask.
Thanks for your help in advance. Tag: invalid key 's' Tag: 110500
How do I Lock Resource Name Field
I would like limit use of resources to only those that are listed on the
Resource Sheet. Currently, names typed incorrectly whilst in the Gantt Chart
view are saved as a new resource. How can I prevent this? Tag: invalid key 's' Tag: 110493
Setting default task types
Is there a way to set the task type (fixed work, units or duration) to a
value for all tasks entered in my plan, e.g., I'd like to set all tasks to
fixed work. I'm buildling a template for a project team and I'd like the
team's plans to default to fixed work.
Paul Peterson
Velox Consulting, LLC Tag: invalid key 's' Tag: 110491
How do I mark a task as highlighted or critical?
I realize I cannot change the font for the text in the Calendar view so now I
thought I woud attack the problem by marking the tasks as
marked/highlighted/critical/noncritical, but can't find how to do that either. Tag: invalid key 's' Tag: 110472
Linking to Excel
In general, can you link Project to Excel data such as dates and
descriptions? To what extent can you link data between the two programs. Any
help would be appreciated, JAD Tag: invalid key 's' Tag: 110469
project server 2003
Is there an evalutation edition of MS Project Server 2003 anywhere. I've
searched all over the microsoft.com and couldn't find it. Does it not exist?
TIA Tag: invalid key 's' Tag: 110468
Start-to-Finish Example
Could someone give me a few examples of the use of a Start-to-Finish
dependency?
Also, how should a successor behave if you increase the successor's
duration? I'm curious to see before and after shots. Tag: invalid key 's' Tag: 110465
Text 1 not visible in other views
Hello all,
I have what I hope is a simple question. In the Task Sheet view I have
created a column to track sales order numbers of new jobs, using text 1. When
I switch to the resourse useage sheet view and attempt to insert the Text 1
column, no data appears in the column.
I assumed that Text 1 was always the same value regardless of the sheet it
is being viewed in. Am I in left field here or am I messing up something very
simple which will make me want to beat my head against the desk?
Thanks,
Roger Tag: invalid key 's' Tag: 110463
Word document opens as "reading layout" and comes up as read only
Hi,
I have 2 problems I am hoping to get resolved:
1. I am trying to fighure out how to change the default layout of word
documents that open with the project server 2003 document library for any
project. I have gone to the "Customize Shared Documents", and attempted to
edit the template. It saves like the system took it, but when I open another
document, it shows up with the reading layout again.
2. Everytime I save a document and open it up again, it comes up as read
only. Yet I can still modify it. I did some searching and found some people
suggested that the file may be checked out by another person. So I created a
new document and was confronted with same problem again. I am the
administrator and have full access. I made sure the documents were not read
only, and had no restrictions before I uploaded them.
Any help would be appreciated...
Thanks Tag: invalid key 's' Tag: 110457
Can Project 2000 be upgraded to Project 2003?
I would like to upgrade Project 2000 to Project 2003. Can I skip XP? Can I do
it with an upgrade? My vendor is telling me I have to buy a full license of
Project 2003 -- not an upgrade. Thanks. Tag: invalid key 's' Tag: 110440
Overallocation on 8 hour days
I've been having a problem where certain resource appear to be
overallocated on days for which they are scheduled for the full amount
of their working hours. I've checked their work schedule setup from the
resources screen and even though they have 8 working hours in a day if
they're assigned more than, let's just say 6 hours, they appear as
overallocated on the Resource Graph.
The problem "appears" sporadically so I'm not sure what could be
causing it.
What should I be checking to fix this problem? Tag: invalid key 's' Tag: 110438
phone log?
I need to keep an on-going phone log of the follow-up conversations with
clients. what is recommended: database or spreadsheet. Any suggestions how
to set it up? What fields or column headings? Tag: invalid key 's' Tag: 110437
Export to Excel
I am new to MS Project. I have set up a project that has a number or
summary tasks each with a set of sub-tasks. Some of the sub-tasks also
have sub tasks.
What I want to be able to do is export tasks to Excel creating a sheet
that enables me to easily sum the number of 'work units' involved in
the project ie
Main 1 5 days
Sub 1 1 day
Sub 2 4 days
Sub 2 Sub 1 1 day
Sub 2 Sub 2 3 days
In Project it is obvious that the duration for Main 1 is the sum of the
times for Sub 1 & Sub 2 (which in turn is the sum of Sub 2 Sub 1 & Sub
2 Sub 2).
However, when this gets exported to Excel I get the following
WBS Name Duration
1 Main 1 5 days
1.1 Sub 1 1 day
1.2 Sub 2 4 days
1.2.1 Sub 2 Sub 1 1 day
1.2.2 Sub 2 Sub 2 3 days
This format makes it 'impossible' to derive the total amount of work
for project, Is there any way to isolate the figures that are actually
for work and not for summaries while still keeping the summaries in the
sheet for clarity? Tag: invalid key 's' Tag: 110435
Updating Status/Splitting Tasks
Once I update the status of my project I need to upload it to Deltek Cobra
(EVM reporting tool) to get the Earned Value metrics. Cobra requires that
all tasks that are scheduled around the status date be completed before the
status date - so they either have to be 100% complete or the task has to be
split so that one part ends before the status date and the remaining part
starts after the status date. What is the best way to do that?
Thanks for your help,
nan Tag: invalid key 's' Tag: 110434
I want to launch MS Project to open a file, run a macro then close
I need to automate the collection of metric data from multiple MS Project
files. For each MPP file, I want to launch MS Project, run a macro to save my
data, then close. So far, I have been able to call up Project with a command
like the following
"C:\Program Files\Microsoft Office2003\OFFICE11\WINPROJ.EXE"
-"E:\Documents\Metrics\MyProject.mpp"
I have no idea how to pass in a parameter to get the macro run. Can this be
done?
Also, I would prefer to run MS Project silently, so that the person running
the batch file does not see the GUI zoom into view repeatedly. Is this
possible?
--
Jane Kirby Tag: invalid key 's' Tag: 110432
land development project template
Hi, I'm using MS Project Professional and would like to get hold of a land
development project template Tag: invalid key 's' Tag: 110426
what is leveled based on day by day setting
Hi all,
When ever i try to publish project from project pro 2003, i encouter an
error in the project pro spooler: The windows user account or user name for
the affected user account conflicts with an existing account on the server.
Then when i go to resource sheet under view, there is another error
saying:The leveled should be based on day by day setting.
Please help me.
Thanks all,
CHeers! Tag: invalid key 's' Tag: 110425
Project 2003. Adding calculations into columns
I wish to add an additional column for hours. I wish it to claculate like the
Works column but to operate seperatley Tag: invalid key 's' Tag: 110418
Back Space and deleting not working properly in word
When I highlight some text and hit the backspace key in Microsoft Office Word
2003 rather then deleting the selected text the courser just moves to the
space immediately before the selected test and the text becomes unselected.
Also when I highlight text and then begin typing, rather then replacing the
highlighted text with what I'm typing it does the same thing as above then
adds my new typings before the previously selected text.
Any help on how to get this resolved is appreciated. BTW i am running XP on
a Toshiba Satellite A85 laptop if that helps. Tag: invalid key 's' Tag: 110413
Changing start date and creating formula for finish date
In Project 2003 Standard, is there a way to change the start date for a group
of existing unfinished tasks (that aren't linked or related in any way) to
today's date in one fell swoop?
Also, is there a formula that can be used to make the finish dates for
existing and new tasks to be Start date + 12 months? I think it is DateAdd,
but I cannot make it work using Tools/Customize/Fields. What settings should
be used there?
-- Tag: invalid key 's' Tag: 110412
Changing resource calendar with a 24 hour project calendar
We have a project that is set up with a 24 hour calendar and resources that
are allocated either to a 24 hour or a 12 hour calendar. If we change a
task with a 24 hour resource calendar to a 12 hour resource calendar, the
task still showed as the resource working through the night as if they were
on the 24 hr calendar.
The task is a fixed unit task.
By doing this, our critical path also changes - any ideas why?
Thanks Tag: invalid key 's' Tag: 110410
Problems with copy picture
I can not use the copy picture function or the copy picture wizard. If using
the wizard it stops on step 4 of 4. If using copy picture it says something
about a graphic filter. to check path, memory & close programs.
I have tried putting a new path no help and I have 80% free disk space and 2
gig of RAm with nothing else open.
Any help, it did work previously.\
Thanks
Kevin Tag: invalid key 's' Tag: 110405
installing microsoft offfice on another computern
When I received my microsoft office 2003 I did not receive a special code to
enter when installing program. I would like to find out how I can reteive
this information so I can install my program. Tag: invalid key 's' Tag: 110397
format proposal
im a landscaper ill like to no how to put together a formal proposal includes
martials labor phase .project time Tag: invalid key 's' Tag: 110394
Classes of days of week issue
We are creating a monstor of a plan that has multiple departments and ALL
company projects and activities -- we are using the durations only NOT
resourcing at this time. However, I am curious as to how to show some
training activities at the company. For example, if we have 7 classes that
are over a 7 week period and occupy one day a week. I have it setup under
the umbrella task of training, then seven tasks that say training1,2,3,4,etc.
and the duration is one week, BUT it is really only one day, but offered
weekly. How do I show the umbrella as seven week duration but each task has
a one day duration with 4 day "lag"?
Help.. :) Tag: invalid key 's' Tag: 110384
Can the status indicator color be changed?
In Microsoft Project 2003 - Can the color of status indicator check mark be
changed or can the background be changed? Tag: invalid key 's' Tag: 110370
actual end date should not change planned end date
I need the program to leave the dates alone, I want to see my planned VS
actual completion dates. If I enter an actual completion date it changes my
orginal planned date. It doesn't make any sense, why even bother to have an
actual completion column if it is just going to change the other column
information. This makes the program useless. I hope you start sending patches
out to fix these bugs.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=265c5254-a5eb-474f-b053-af1616fd8e68&dg=microsoft.public.project Tag: invalid key 's' Tag: 110359
actual end date should not change planned end date
I need the program to leave the dates alone, I want to see my planned VS
actual completion dates. If I enter an actual completion date it changes my
orginal planned date. It doesn't make any sense, why even bother to have an
actual completion column if it is just going to change the other column
information. This makes the program useless. I hope you start sending patches
out to fix these bugs.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=e070d1f8-e0ee-4dba-9e81-edfcf982262d&dg=microsoft.public.project Tag: invalid key 's' Tag: 110358
Create Combination View MS Project 2003 pro
Is it possible to create a combination view where the upper view is a
Gantt and the lower view is resource useage? But, I only want to see
the resources assigned to the highlighed task in the upper view.
Restated, the assignments of the highlighted task in the upper view,
filter which resources and which resouce tasks are shown the the lower
Resource Useage view.
Thanks, Denis Tag: invalid key 's' Tag: 110356
Indenting tasks and cannot outdent.
While entering tasks and sub-tasks I accidentally indent a task.
When I try to outdent the task it will not outdent. Is there any way to
outdent the task after it has been indented?
thanks,
--
RWR Tag: invalid key 's' Tag: 110352
Can't split task
I have a schedule with custom fields. I enter a start date into Start1. I
then calculate the duration1 field based on info in two other fields, (units
per day / # of days) and calculate Finish1. My Gantt bars are set up to
display these fields and it works fine. What I cannot do is right click on
the task bar to split the task. It appears to work as I try to drag the split
to where I want it but when I try and drop the split where I want it nothing
happens. Is it because I am calculating these fields? Tag: invalid key 's' Tag: 110348
How do I document days delayed due to weather?
I work in construction, and I am curious as to if you are able to enter this
type of delay in your project. Tag: invalid key 's' Tag: 110347
Number of Resources not displaying if one
I have show assignments in the options set to decimal. The number of
required resources shows correctly in brackets after the resource name except
when only one unit is required. In that case, no brackets or number of
required units shows at all. Is that just the way it is when only one unit
is required? Tag: invalid key 's' Tag: 110344
Change to MS Project needed
I created a large project, I needed to change an end date. My start date
needs to stay where it is. I get a selection box that says I have choices to
make, remove the must start on constraint or cancle the operation etc. If I
select help the help button the box that pops up is for a constarined finsih
date. The program help is crosswired. I need to be able to change the end
dates as the project changes, if we are behind schedule I need to be able to
show it. I need to turn off this garbage crosswired auto calculate move the
dates around feature. My baseline will show the original dates. Please make
this change soon. !!!
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=0a3eb08a-b855-466d-aa7f-3976122aa690&dg=microsoft.public.project Tag: invalid key 's' Tag: 110340
Struggling to get Project Data into Excel using OLE DB
I have created a data source (an ODC File) using the wizards in Excel
with Project OLEDB. The Test connection button works and when I open
the file in Internet Explorer, Office Web Components allows me to
create a PivotTable of the data. When I open it through Excel, Excel
says the query did not run or the database table could not be opened:
The connection is:
Provider=Microsoft.Project.OLEDB.11.0;User ID="";Data Source="";Project
Name=Z:\\My Documents\\H06802S.mpp;Enterprise Mode=False;Always
Load=False;Initial Catalog=Z:\\My Documents\\H06802S.mpp;Persist
Security Info=False;Enterprise RUID List="";Initial Catalog=(Default)
The Command Type is Table
The Command Text is Assignments
Does anyone know what I need to do to get this to work?
Have you got samples which do work?
Thank you.
Best Wishes, John. Tag: invalid key 's' Tag: 110339
MS-Project task automatically in Outlook calendar
I use Microsoft Project Manager. I also use Outlook. I would like to be
able to put a task in Project Manager and have it show up in the Outlook
calendar. Tag: invalid key 's' Tag: 110338
Custom Toolbars, Global.mpt and the Global Enterprise Template
Problem: Custom Toolbar reappears after deleting using organizer.
Background: We have two Project Server environments, Test and Production.
I developed a macro for a custom toolbar and made it part of global.mpt, my
local
global template. When ready to test and deploy in the Test environment, I
copied it to the TEST Global Enterprise Template (GET) using the organizer as
described here and elsewhere.
I later deleted the custom toolbar and macros from the TEST GET, but it
reappeared when I re-opened Project Pro. I deleted the custom toolbar again
using the organizer, but it would reappear in the next session. I opened
Project Pro in local mode (offline), deleted the toolbar again and it was
gone for all subsequent sessions. Good! It was gone from TEST environment,
too! However â?? argghhh! -- it reappeared when connecting to the PROD Project
Server environment. It was never copied into the PROD GET. It does not
appear in either TEST GET nor PROD GET organizer, nor in the global.mpt when
in local mode. Is there a cache copy to delete somewhere? Does Project Pro
combine the global.mpt and the GET into a cache that is subsequently loaded
into Project Pro?
BTW, a co-worker can not permanently delete the custom toolbar at all except
when in local mode. In other words, the custom toolbar reappears in both
TEST and PROD, but not local offline.
--
Steve Tag: invalid key 's' Tag: 110335
How do I get a summary of how many people (i.e. resources) I need
OK this must be simple - I cant believe that such a complex bit of software
cant do this.
I have a project, it involves using mainly people as resource, what I want
to do is to produce a simple table or graph that tells me I need 2 people in
week 1, 5 in week 2, 16 in week 3 etc, etc.... you get the idea. Its basic
resource planning and all I seem to be able to get is a badly formatted bar
chart showing over allocation.
Please help me! Tag: invalid key 's' Tag: 110330
Indenting while Importing Tasks
I have imported hierarchically indented tasks from Excel. MS project has not
identified automatically the tasks which were imported indented as
Milestones, tasks, subtasks etc. Is there a way to automatically recognize
the indented tasks ? Tag: invalid key 's' Tag: 110329
When opening a MSP project I am getting an error message "Project contains
invalid key 's'"