Enhance formula
I currently have the following formula:-
IIf([Milestone]=-1,IIf([% Complete]=100,"Complete",IIf([Baseline
Finish]=ProjDateValue("NA"),"No baseline Set!",IIf([Finish]<Date
(),"Reforecast",IIf([Number1]>5,"R",IIf([Number1]>0,"A","G"))))),"NM")
Can I extend it further to perform the following checks as well:- (ie how
big can my formula be!!)
1) Amend the formula sp that it only works on tasks flagged as milestones.
2) Using another text field to act as reporting level (say for reporting
levels 1,2,3,4 and 5) and then apply the above RAG formula but with differing
"slippage days" depending upon what Level is in the text field.
Thanks in advance
Steve Tag: how do I set up building quality assurance projects Tag: 77481
Using a macro to create a shortcut button to apply a resource flit
I want to create a shortcut button on a toolbar which instantly applies a
resource filter. Macros I have recorded so far have been recorded to go
through the whole process of applying the filter to show only tasks using one
resource, selecting the resource from the drop-down in the options box, and
clicking ok. However, when the macro is run, it only goes as far as the
options box, leaving the drop-down field blank. Tag: how do I set up building quality assurance projects Tag: 77472
Opening a project from command line, from Project Server
Hi All,
A bit of an odd question I'm afraid.
I've found that I can open a project, from project server, using the
following from the command line:
winproj.exe "<>\ProjectName.published"
I'm wondering if I can open a project though using the Project ID rather
than the name. I've tried (assuming the project Id is 112 for example):
winproj.exe "<>\112"
winproj.exe "<>112
winproj.exe "<>projectid=112"
and a bunch of other permutations, with no success.
Anyone got any ideas?
Thanks,
AndyN Tag: how do I set up building quality assurance projects Tag: 77470
Running multiple projects with MS Project
I am new to Project, and am using 2003. Our construction company typically
runs 10 to 15 projects at a time, running +/- 6 months. This is probably
pretty basic, but I have been unable to figure it out on my own .... Should
we be developing individual "files" for each project, and somehow linking
them together, or should we run one "master" schedule, and either build the
unique schedules and/or import templates into the master schedule. ALSO ...
in my experimentation, I embedded a sample project into what I called a
master schedule, regretted it, and have been unable to remove the embedded
sample project. I select the "parent" task, press delete, it warns me that
I'm deleting a taks that has subs, but I click okay, but it doesn't delete???
What's going on here? Thanks in advance. Tag: how do I set up building quality assurance projects Tag: 77468
How do I hide the non-working time on a Gantt chart?
I would like to display / print a Gantt chart that does not show the
non-working time, eg. only the hours 8am to 5pm are displayed for each day. Tag: how do I set up building quality assurance projects Tag: 77464
duration from more than one task
Hi
I'm struggling with project, What I want to do seems very basic, but it just
doesn't seem to do it
I need to have the start of a task linked to one task and the end linked to
another task. The duration is to be determined by the other 2 tasks, not
resources or an entered duration. I'm not assigning resources at all, so
they wont effect it.
I can do this by having 2 sub tasks, one being the start date and one the
end date, but that means I need 3 lines to tell a pretty simple story, I have
to change the Bar style and roll up the task to make it look like one task
not 3 when printing.
Surely there's an easyer way to do it in one task. (I have used links from
Excel to calculate the duration, but that adds an even more work)
Your help is appreciated Tag: how do I set up building quality assurance projects Tag: 77463
Format Painter Functionality in Project 2003
Does anyone know of a way to get the Format Painter button to "stick" so that
you can apply a select format to multiple cells as you can do with Excel. My
experience is that the "double-Click" function on the Fomat Painter button
does not work in Project 2003. I find that you can only paint one cell and
then you have to re-select Format Painter to do additional cells. Tag: how do I set up building quality assurance projects Tag: 77461
A Way to list the WBS number with each task in resource usage view
Hi -
Help! I am preparing a resource assignment list using the Resource Usage
View. I am copying and pasting from MS Project Resource Usage View to Excel.
I want to show for each person a list of their assignments listing WBS,
Resource Name, Remaining Work and Start date. I can get all of those columns
to show in Resource Usage View except for WBS. I can show ID from the Gantt
chart but not WBS. Is there any common field from the Gantt view that will
show in the Resource View even if I have to manually enter the WBS numbers so
I can get the WBS number to show?
Most appreciated. Tag: how do I set up building quality assurance projects Tag: 77458
Print Preview
I used to have Windows 2000, but I've upgraded to Windows XP. How can I get
my printer to show a preview of my document before it prints it
automatically? Thanks!
Wayne Tag: how do I set up building quality assurance projects Tag: 77455
Base calendar in a Master Project
It seems that when I insert a project into a Master
Project, the Base Calendar for the Master takes over. Is
there a way to specify a base calendar for a project
which will still hold when the project is inserted in a
master? ...and other inserted projects have a different
base calendar?
jlb Tag: how do I set up building quality assurance projects Tag: 77453
adjust actuals
I am a PM with every permission in the book. When I go to the Resources page
and select the adjust actuals link in the left hand pane, it brings me to the
correct page, but all the boxes are read only. How do I update my resources
taks for them through PWA? Tag: how do I set up building quality assurance projects Tag: 77449
autostart macro for microsoft project
I would like to have a macro automatically start upon opening a file. Tag: how do I set up building quality assurance projects Tag: 77448
%100 in Project 2003 and 0% complete in PWA
When tasks are updated w/ (for example) 100% completes in Project 2003 and
"published" I can understand why the same tasks in Project Web Access show
the tasks as 0% complete. My guess is that the update from the Resource
Manager (responsible to complete the task) in PWA is used to compare for
accuracy (maybe the task didn't get done). But when I look at old tasks in
PWA that were NEVER updated using PWA they eventally show as 100% complete to
match the M.S. Project 2003 schedule. Does anyone know the timetable for
when PWA uses the % complete in M.S. Project to update the PWA % complete
column? Tag: how do I set up building quality assurance projects Tag: 77445
internet host who is best
I want to make my web page live, and I am trying to pick the best host for my
business for the best cost also. This is my first web page. I have looked
on the webhostingtalk.com, searched on-line hosts, talked to alltel, yahoo,
etc. and I am just wondering if anyone out there could give me some help in
deciding who to use. I want 24/7 support/help, and I don't want my page
down, and if it must be for the host to update I want it for as short of time
as possible. I am NOT going to use a free web page host.
Any help here would be greatly appreciated.
I have one more question, how do you get the internet to detect your page in
the top 10 when it is spidering to find search results from let's say google
or yahoo?
Thanks a lot Tag: how do I set up building quality assurance projects Tag: 77429
Zoom in/out of MS Project
Can I zoom in and out of an MS Project 2003 project such that I can change
the number of rows I can see? This is not to be confused with changing the
timescale to months, weeks, days, etc. I know I can zoom in print preview,
but I want to know if it is possible to zoom in and out in the project view. Tag: how do I set up building quality assurance projects Tag: 77415
Critical Path
I have tasks that do not show up in the Critical Path but always want them to
be included. How can I force a task to be included in the Critical Path?
This is for project leaders who must manage to the critical path. Thanks! Tag: how do I set up building quality assurance projects Tag: 77412
Custom Fields to Subprojects
I have a master file where I have linked numerous subprojects to. I
have created a custom field that compares the baseline finish date with
the finish date. I would like this custom field to filter down into
the subprojects. I have been copying this custom field into every
subproject...but everytime I modify this field, I have to re-copy it to
every subproject. It's getting tedious.
is there a better way to do this? Is there someway to make the custom
field in the master file somehow automatically filter into the
subprojects?
Thanks for the help! Tag: how do I set up building quality assurance projects Tag: 77407
How to setup so Gantt view starts at project start date?
On startup, Project 2003 displays Gannt view. View does not start at project
start date though. Need to scroll to get to view. Would like to avoid this
need for scrolling. My testing shows that the Timescale format has an affect
on the amount of scrolling needed, but I have not found a way for view to
start at project start date.
Thanks Tag: how do I set up building quality assurance projects Tag: 77400
Filters Highlighting not Hiding
An MSP I've brrn given 'highlights' tasks when filters ( even auto-filters )
are applied rather than hiding the tasks - how do I change this ?
Even when I go to custom filters and use 'apply' rather than 'highlight' it
still does it - I've never come accross this before - any ideas how to change
this ?
Is it some setting within that particular MSP code ?
Thanks
PS - other MSPs work ok. Tag: how do I set up building quality assurance projects Tag: 77395
How do I send an attachment together with a task in MS Project ...
I would like to send an attachment together with a task so that individuals
who are assigned the task get the attachment at the same time when they open
their emails. I have tried to copy the attachment but I was unable to paste
into the workgroup box.
Thank you Tag: how do I set up building quality assurance projects Tag: 77393
Converting to Project Server
Hi,
I'm using Project 2003 professional, with a shared
resource pool and an integrated programme plan with linked
sub projects inserted.
I currently store al the files in PVCS (Version manager)
and check them out an run all the files from my local
directory.
I'm now looking to move to Project Server.
Will it keep all the imbedded links and is there any
general advice you can give regarding moving to Project
Server?
Thanks Tag: how do I set up building quality assurance projects Tag: 77388
Overtime
I have been working on a porject for about a month and yesterday I went to
add overtime/ hour thinking that it would atomatically calculate for any
resource that was overallocated. Clearly this did not happen and now I can't
figure out how to get the overtime to show up. I got the impression from the
help pages that you have to enter it in manually in task usage but there has
to be an easier way. I have a huge project! Please help if you can. Thank you! Tag: how do I set up building quality assurance projects Tag: 77385
Updating Table & Filter definitions in Plan and Global
I have a number of tables and filters which are shown as belonging to both
the open project AND the Global.MPT
If I update any of these definitions, are the corresponding tables/filters
updated in both project AND Global, or only one, and if so, which one?
I had a VERY nasty accident yesterday where I deleted a table definition,
and re-opened my project to find that I had lost ALL my indenting and plan
formatting. the message said something like "Cannot open the plan as the
table definition <<name>> has been deleted"
Could one of you nice people explain if an update to a table or filter
update BOTH versions of that table or filter? If this isn't the case, is
there any way to tell which one is the most recently updated, so I can copy
the updated one over the top of the old one (if you see what I mean)
Yours in terminal bewilderment...
Pete Tag: how do I set up building quality assurance projects Tag: 77382
assigning a group of people to a task
Is there a way of assigning a group of prople to a task by just
selecting a single resource ?
What we have is a team of implementers with 6 people in the team. In an
implementation any or all of them could be working on the task(s) and
need to record their time on Project Central (btw, we are still on
Project/2000). These 6 people are all in the same Group and, if
possible, I would like to be able to automatically assign them all the
task(s) without having to go through and select them one by one.
Can anyone offer any suggestions as to how this could be achieved, i'm
anticipating some form of VBA - AssignTeam with a %age assignment for
each member but not sure how best to approach.
Regards
Fred Newton Tag: how do I set up building quality assurance projects Tag: 77378
How can I produce a Project 2000 report in Word?
I'm am using Project 2000. Although I can customise the reports, I'd like to
export them to Word (or some other text file) so that I can archive them.
Saving a Project to a .csv format using a map is NOT what I want.
Mant thanks Tag: how do I set up building quality assurance projects Tag: 77371
How to track time without considering assignment units?
Hello,
I'm using MS Project Pro 2003, non enterprise version.
We are planning projets by allocating resources up to 80% (time
available for projects, excluding all organizational tasks).
We track efforts (with Actual work and Remaining work) and want a
schedule reflecting the reality.
For understaffing (less efforts produced than planned), updating
actual+remaining work, and rescheduling the planning gives good
results.
For overstaffing (more efforts produced than planned, ex: the engineer
worked 100% of his time on the task), we have to update the Actual work
in the 'Task usage' view to see the planned assignment be updated with
real efforts spent over the week. If not, we do not see the benefits of
a work advance due to an overstaffing.
Here is the problem:
Task A ends Week 1 : Actual work = 3 days
Task B follows task A: Actual work = 2 days
1/ When I input 3 days on task A, week 1, MSP delays task B to start on
week 11
2/ If I input 2 days on task B, week 1, MSP detects a schedule conflict
because it considers that task B starts at the beginning of the week,
despite the fact that the task has a 'as soon as possible' constraint
I seems like MSP spreads efforts over the tracking period, without
considering tasks sequencing...
How to track accurate efforts with MSP, when two tasks are overlapping
during the timescale period (week) ?
Any advice should be appreciated!
Regards
Laurent Breysse Tag: how do I set up building quality assurance projects Tag: 77370
Restricting resource name entry
All,
I've used Project for years, but as a very 'light-weight' user. I'm
now setting up an environment with 10-12 projects, each of 100-120
tasks, which is my biggest MS Project attempt to date.
I have a resource file (resource.mpp) with my resouce pool, and the
projects are linked to this pool. (all fine so far).
I would like to restrict the data entry on the different project task
sheets to 'valid resources only', to prevent creation of resources
like 'MM50' when what was required was resource 'MM' at 50% !
I've tried the Project Help, and usenet, but can't quite find what I
want.
(Project 2000, 9.0.2000.0224)
Any ideas?
thanks,
M. Tag: how do I set up building quality assurance projects Tag: 77368
customizing updates tab in PWA
I'm having problems recognizing tasks in the updates view, since i have tasks
with the same name in my projects. therefor i'd like to add colums to the
view such as id or summary task name.
i couldn't find the view in admin - manage views.
does anyone have any suggestions? Tag: how do I set up building quality assurance projects Tag: 77367
editing duration field number format
i would like the duration field in Project Proffesional to apear as whole
numbers.
can i customize it? Tag: how do I set up building quality assurance projects Tag: 77366
Can MSP auto adjust the % of a resource?
Lets say I have 2 8hr task assigned to the same resource. Why cant I select
both task assign a start date of feb 1 and a finish date of feb 3 and have it
make both start and stop at the same time but do 50% on each.
Instead of doing the first 8hr task then the next 8hr task.
After all I selected the start date to be the same.
Thanks for the help Tag: how do I set up building quality assurance projects Tag: 77360
How to add a gridline in gannt chart to show Deadline?
Need to add a gridline through Gantt chart deadline to show Deadline so that
it shows items that go beyond the deadline for the entire project. Is that
possible Tag: how do I set up building quality assurance projects Tag: 77359
Can I add custom detail/timescaled fields?
I need to show the percentage of Remaining Availability in the timescaled
portion of a view. Presently, Remaining Availability is shown in hours. Can
I add a custom detail/timescaled field that would show it as a percentage
((Remaining Availability / Work) x 100)? Tag: how do I set up building quality assurance projects Tag: 77357
color-code a task bar to a resource
Not one-by-one, of course: but whenever Thom is assigned a task, the work bar
is blue, whenever Bill is assigned a task the work-bar is green Tag: how do I set up building quality assurance projects Tag: 77356
How do I show all of my notes?
It seems that there is a limit on the number of characters allowed in the
notes field. How can I conveniently print lengthy notes along with all other
information desired? Thanks! Tag: how do I set up building quality assurance projects Tag: 77350
SP1: Can't set Project Start date to anything but 2005
In SP1 (build 11.1.2004.1707.15) I cannot seem to set the Start Date to
anything before January 1, 2005. Go to Project->Project Information and try
setting the start date to say November 15, 2004. Close the dialog box. Reopen
it. The year will be 2005, not 2004. If you actually change the system's date
(not a friendly thing to do) to anytime in the year 2004 it will do it. But
when you change the system date back to 2005, and open up the Project
Information box, the year will once again be 2005.
Anyone else see this? Workaround?
Thanks
Jack Tag: how do I set up building quality assurance projects Tag: 77342
Linking Resource pools back to tasks
Hello,
I'm looking at using a resource pool with schedules inserted into a
master schedule. But I'm also looking at doing some offline assignment
value changes in Excel and import this back in.
On a single schedule this is easy as I just link it to the UniqueID. But
when I use schedules inserted into other schedules the UniqueIDs all change
but Project is able to keep the assignments sorted out. Can someone tell me
what mechanism is used by MS Project in linking assignments from inserted
sub-schedules to the common resource pool. If I know this I can probably
figure out a means to do what I'm after. Alternatively someone may have a
workaround they are willing to post.
Thanks Tag: how do I set up building quality assurance projects Tag: 77341
Gantt Chart Bars Do Not Print
I'm having problems printing the Gantt chart portion of a file - the bars do
not print. I've made sure that the "Print all sheet colums" option in Page
Setup is checked. What am I doing wrong?
I'm using MS Project 2000 and printing to a HP DesignJet 750C plotter. Tag: how do I set up building quality assurance projects Tag: 77337
Scheduling Multiple Resources for a Task
Hi. I have a Fixed Unit, effort driven task ten days long. I have three
resources assigned to perform this task with varying levels of effort.
Resource one will be on the task for all 10 days, Resource 2 for three days
and Resource 3 for 7 days. I have Resource 1 scheduled for 100% Units,
resource 2 for 30% and Resource 3 for 70%. The result is that Resource 2 is
schedule for 2.4 hours of work/day for 10 days. I'd like Resource 2 to be
allocated 100% of the time for three days. What would be the best way to
accomplish this?
Thanks. Tag: how do I set up building quality assurance projects Tag: 77335
Automated RAG Status Formula
I currently have the following formula:-
IIf([Milestone]=-1,IIf([% Complete]=100,"Complete",IIf([Baseline
Finish]=ProjDateValue("NA"),"No baseline Set!",IIf([Finish]<Date
(),"Reforecast",IIf([Number1]>5,"R",IIf([Number1]>0,"A","G"))))),"NM")
Can I extend it further to perform the following checks as well:- (ie how
big can my formula be!!)
1) Amend the formula sp that it only works on tasks flagged as milestones.
2) Using another text field to act as reporting level (say for reporting
levels 1,2,3,4 and 5) and then apply the above RAG formula but with differing
"slippage days" depending upon what Level is in the text field.
Thanks in advance
Steve Tag: how do I set up building quality assurance projects Tag: 77332
Challenging PWA/Outlook Issue
This is a strange one. I have PWA 2003 integrated with Outlook 2003. This
morning a resource showed me duplicate PWA tasks her Outlook Calender. This
is bad, but whats even worse is that the duplicates were created using the
regular Outlook Calender form. She has one good PWA task in her Outlook
calendar and up to 4 duplicates that were created using the regular, 2 tab
Outlook Calender form.
Any ideas out there????? Tag: how do I set up building quality assurance projects Tag: 77331
task type
I understand the definition of the different task types (fixed duration,
fixed work, and fixed units). But, I don't see any difference in my project
plan (duration or amount of work) when I change the task type (for example
change duration to work).
Can anyone explain how these different types affect the project schedule? Tag: how do I set up building quality assurance projects Tag: 77325
Convert SureTrak to Project
I am trying to move SureTrak files to Microsoft Project. Is there any easy
way to do this?
Thanks ahead of time.
--
thanks,
askgail Tag: how do I set up building quality assurance projects Tag: 77324
Leveling Question
I'm quite new to project. Is there a way to tell project to level
assignments without splitting specific tasks? The tasks can be delayed but I
don't want them split.
Thanks,
Michael Tag: how do I set up building quality assurance projects Tag: 77305
how do i let users change dates on the web?
I want to post the project to the web server. When I do I want the users to
be able to change the dates the task acually starts and stops. How can I do
this? Tag: how do I set up building quality assurance projects Tag: 77300
Formula Assistance
Created a formula with [number 1]*[number 2]. It worked initially, but
doesn't appear to be working now. It's on a different computer than the one
the formula was created on. Any assistance in solving this problem is
greatly appreciated. Tag: how do I set up building quality assurance projects Tag: 77297
Converting Project 97 file to 2000
How Can I open an old Project 97 file in Project 2000 - I no longer have
Project 97 available either on a PC or in fact the original disks. (i.e. I
can not do the standard suggestion of saving in Project 97 as an MPX file)
Appreciate any help you can give - I have a Project urgently needing this. Tag: how do I set up building quality assurance projects Tag: 77289
How Can I open an old Project 97 file without in Project 2000
How Can I open an old Project 97 file in Project 2000 - I no longer have
Project 97 available either on a PC or in fact the original disks. (i.e. I
can not do the standard suggestion of saving in Project 97 as an MPX file)
Appreciate any help you can give - I have a Project urgently needing this. Tag: how do I set up building quality assurance projects Tag: 77288
In setting up a ms project would like information on how to setup building
"quality assurance" projects.
Re: how do I set up building quality assurance projects by davegb
davegb
Fri Jan 28 12:51:43 CST 2005
I think your question is a little too broad. You set them up the same
way as any other project. If you're looking for a template to follow,
there are people who post them sometimes. You might try a search here
and on the web.