Pages

Search

Field Definitions Microsoft Project

Field Definitions Microsoft Project

Field Definitions

Posted: 25 Apr 2005 11:19 AM PDT

Thanks Mike.

"Mike Glen" wrote:
 

Is there a limit to the number of custom calendars you can create?

Posted: 25 Apr 2005 11:14 AM PDT

Following specifications and limits are supported when you run Microsoft
Office Project 2003 on Microsoft Windows 2000 Professional SP3 or Windows XP,
although actual limits and performance speed depend on your computer's
configuration. Note that out of memory errors may occur before you reach the
listed limits.

Attribute Maximum
Base calendars unlimited
Resources per project 1 million


"patcapps" wrote:
 

Spreadsheet like view showing work by resource per task

Posted: 25 Apr 2005 10:29 AM PDT

Hi JLDN,
Welcome to this Microsoft Project newsgroup :-)

I think you could use either the Resource or Task Usage views and export the
data to Excel You could use the Analyse Timescale Data in Excel wizard on
the Ayalysis toolbar. Or use the direct procedure written in the days of
Project 98 but still works in 2003. Please see FAQ Item: 10. Exporting to
Excel.

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
Project MVP



JLDN wrote: 

Resource Loading not totalling correctly

Posted: 25 Apr 2005 10:21 AM PDT

Hi,

Don't forget that when the task is Effort Driven, adding a resource does not
result in more work; instead teh work on the task is divided between the
resources.
If you want an additional resource to result in additional work, go to Task
Information, Advanced Tab, check out Effort Driven.
HTH

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

Project 2003 Projects - Trying to report on Progress, not working

Posted: 25 Apr 2005 10:20 AM PDT

hi Mike,

I would suggest use the Group By box to separate the completed and
incomplete tasks. In the incomplete tasks section, scroll up to the date to
which work is complete and use the rest of the Gantt Chart for the
presentation.

Regards,
Haris
-----------


"Mike S." wrote:
 

Merge Fields in Excel Import

Posted: 25 Apr 2005 09:40 AM PDT

I am both exporting and importing from the report master, so as you said, i
should be ok. I have been using 3 fields combined into a single field as my
merge key. I just tried again using the unique id field as the merge key and
still got the same results. Anything else you can think of?

"JackD" wrote:
 

Resource usage report problem

Posted: 25 Apr 2005 08:39 AM PDT

Hi Dave,

Sorry to say this, but I can also reproduce the exact problem you note in
both Project 2002 SP-1 and Project 2003 SP-1. I know that is of little or
no help. When I experiment it appears the last page of the report resorts
to showing the "hours" label after material resources. I have tried editing
the report in a number of different ways and cannot still resolve the
problem.

The best answer I have been able to arrive at is to print the resource usage
view (with the filter Resource-material) applied and skip the report
completely.

Hope this helps.

JulieS
"Dave" <microsoft.com> wrote in message
news:com... 

entering a cost for a project

Posted: 25 Apr 2005 03:58 AM PDT

When I enter a cost in excess of $1,million, the cell becomes #######, how
do I correct that?

"Turki Ben Sumih" wrote:
 

make 25 cycles of 3 tasks

Posted: 25 Apr 2005 03:13 AM PDT

Oooops - I missed the 3 tasks - sorry. So modify what I said by creating
all 3 tasks and then select them all before filling down.

Mike Glen
Project MVP




Mike Glen wrote: 

Project Function

Posted: 24 Apr 2005 11:12 PM PDT

DearJulieS, thank you so much for helping me,
I actually did the customized field using the
ProjDurConv([Duration],pjMonths) formula in the project level BUT when i open
a project in the MS project the customized field gives me ERROR ! and when i
add this field to the project web access view, the field in the project
center gives me 0 for each project !
dears, can you help me solving this issue?

Thanks and Best regards

"JulieS" wrote:
 

Master Project - Multiple Projects

Posted: 24 Apr 2005 01:01 PM PDT

Hi,

There isn't a read only option, just a Link option. Deselecting link copies
all tasks and leaves no link to corrupt anything with to the file.

When recording the macro, record inserting all projects: the macro then
needs to be run once to create a new consolidation.

For safest results:
1) Copy all files to a backup folder
2) Crete a new file to hold the macro: save as Consolidation MacroV1.mpp
3) Record a macro and for the first step create a new file
4) Record inserting all projects making sure the link option is deselected
every time.
5) Select File, Save as and save the master (EG as Master 20050425.mpp)
6) Stop recording and close
7) Press Alt+F11 to display the Visual Basic Editor
8) Press Ctrl+R to display the project window (should already be displayed)
9) Brows the macro project and open the Modules folder. Double-Click Module1
to open your recorded macro
10) Edit the Save as statement at the end to delete the file name. When
running the macro it will now prompt you for the name.
11) Close the VBA editor
12) Save the macro project
13) Press Alt+F8 and select then run your recorded macro

You should now have ended up with a new consolidation!!
Repeat weekly:)

--

Rod Gill
Project MVP


"Arthur MacLeod" <net> wrote in message
news:OhJU$phx.gbl... 

resource scheduling question

Posted: 24 Apr 2005 09:18 AM PDT

Hi,

How do you do that, you ask.
Tools, Change Working time, select the resource's calendar
Select M ffor all Mondays, enter new shift tiome(s) in the small windows
below right.
Same for other days of the wek.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"SHOHMAN" <microsoft.com> schreef in bericht
news:com... 
person 
that 
calendar. 
working 
in 
morning. 
as 36 
8-13 
mean 
8am 
on 
hours. 
applied in 
to 
hours. 
M, 

viewing actual work in a specific date range

Posted: 23 Apr 2005 03:43 PM PDT

In article <com>,
Eric H <microsoft.com> wrote:
 

Eric,
Off hand I can't think of any easy way to get the information you want
but there are a couple methods you might try. First, use the "analyze
timescale data in Excel" utility to export Actual Work from the Task
Usage view from Project Start up through the latest date of interest.
Once the data is in Excel formulas can be applied to segregate out the
cumulative Actual Work within the data range of interest.

A slightly more elegant way does not require the use of Excel but does
require the use use of VBA. With a macro, the desired data can be
extracted and placed into a spare field for each task and/or the project
as a whole. A view that includes the spare field then can be printed or
distributed electronically. Actually the VBA code for this isn't very
complex. If you have a little experience with VBA, give it a try. Or if
you need some help, re-post and we can get you started.

Hope this helps.
John
Project MVP

stuck task -- won't indent further

Posted: 22 Apr 2005 03:38 PM PDT

No. It can however happen if you have filters applied or the tasks sorted.
Select the filter All tasks
Select Project, Sort, Sort by ID

There was a problem with Project 2003 Standard not outdenting, but the SR
fixed it.

--

Rod Gill
Project MVP


"Eric H" <microsoft.com> wrote in message
news:com... 

1 line is a 400 line gantt chart won't show. why?

Posted: 22 Apr 2005 01:14 PM PDT

I also assume the task filter applied is All Tasks?

--

Rod Gill
Project MVP


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

Linking in combination windows

Posted: 22 Apr 2005 12:23 PM PDT

In article <com>,
"RoseC" <microsoft.com> wrote:
 

RoseC,
I assume you want to be able to drag a link between tasks in the
combination view much like can be done between subprojects in a master
file. However if the Predecessors field is displayed I question whether
the drag method is any easier or quicker than simply entering the Task
ID into the Predecessors field. What's the benefit?

John
Project MVP

html column headings

Posted: 22 Apr 2005 10:28 AM PDT

Hi Mike,

That's my guess. It was about the only way I could connect an HTML column
heading to anything in project. We'll see if my "reading between the lines"
of the question was correct ;-).

Julie

"Mike Glen" <glenATmvps.org> wrote in message
news:eFn$phx.gbl... 

Need leveling advice...

Posted: 22 Apr 2005 07:39 AM PDT

Thanks - I had just looked at the task that had the overallocated resource
and hadn't considered downline successors


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


"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message
news:phx.gbl... 

Resource VacationView

Posted: 22 Apr 2005 07:23 AM PDT

If you know any VBA, I've also created a module that exports that
information to Excel. My module was designed to export one month at a
time and then open an Outlook message with the Excel file attached and
populate all applicable resource addresses to mail the calendar to them
for validation. If you know enough about VB code, you could probably
modify it for your purposes. If you would like the code, please email
me directly at kikos AT nationwide DOT com.

SarahK

Exporting from Project

Posted: 22 Apr 2005 04:49 AM PDT

Thanks for the response John,

The file is completely open. I can save it in MPP, MDB, etc but when I save
it in a format for which you have an export map, the save button grays out.
I suppose I'll attribute it to an MSProject "Quirk". I have several files
that this happens to and the only way I've found to fix it is to rebuild the
files from scratch...so far!

Sandra

"John" wrote:
 

how do i download microsoftword?

Posted: 22 Apr 2005 12:10 AM PDT

There is no downloadable version of Word or the Office Suite. You'll need
to visit you favourite local computer shop or online software merchant and
purchase a retail package. You can review your various options at the MS
Office website, www.microsoft.com/office.

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


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

VBA References for MS Project

Posted: 22 Apr 2005 12:09 AM PDT

I've started a series of notes on using Project VBA here:
http://zo-d.com/blog/archives/project_management/microsoft_project/programming/index.html

I'm going to try to post something today on working with task dependencies.
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..
"John" <com> wrote in message
news:microsoft.com... 
with 

how do you run a view that shows an Outlook style order of day?

Posted: 21 Apr 2005 11:54 PM PDT

Thanks all for the info re: putting in specific hours. Very helpful -- both
the specific route to doing so and the commentary on how I should try to
avoid constraining Project. That leads to a larger issue: the boss
doesn’t get this concept of a software program telling him why something was
"late". He doesn’t want to look at fancy Gantt charts, etc. He says
Project/ Shmoject --he says just have deliverable ready on such and such
a date, and show him how I spent his money â€" down to the last dollar â€" and
my time â€" down to the 15 minute interval. The last thing he says he wants
to look at is some fancy program telling him how his request can’t be
done.He sets deadlines every few days. These deliverables cannot float
around just because Project says they need to -- they have to be done.
Period. At an exact time. Also -- meetings with upper management I have to
put into the project schedule and I have to be there at exactly that time â€"
not 5 minutes late, but exactly at that time. I'm probably crazy but i'm
trying to use MS Project for all of my project management needs -- from
the planning to the reporting of real, actual, precise numbers of where
real time and money were spent -- again down to the 15 minute interval and
to the last dollar Plus i don't want my life schedule in different places
-- MS PRoject for this one project , OUtlook for my appointments and phone
calls. Ideally I want one place for all my project and time management
needs. am i crazy?



"Rod Gill" wrote:
 

running a date range filter on Actual Work

Posted: 21 Apr 2005 11:48 PM PDT

Thanks again Gill for the help. I checked it out --now is there a way under
Resource Usage to see the tasks for each Resource not left aligned but still
in outline view of the Gantt Chart? Otherwise its very hard to read what
happened by that resource on that particular day. Is there a way to make a
pretty report from that information to show to boss and client? Thanks
again.



"Rod Gill" wrote:
 

Predecessors are not updating

Posted: 21 Apr 2005 10:49 PM PDT

Hi Susie,

Welcome to this Microsoft Project newsgroup :)

You might like to make sure in Tools/Options.../Schedule tab that "Autolink
inserted or moved tasks" is unchecked.

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



Susie wrote: