| suitable merge key Posted: 07 Nov 2004 08:51 PM PST i have 3 sheet in excel file. the first sheet contains task information and
the merge key is task id . the second one contains resource information and
the merge key is resource id . the last one contains assignment
information.it has task name field, resource name field ,resource id field ,
task id field ,and work field. what is the suitable merge key for assignment.
i want to import the data at the same time.
"Rob Schneider" wrote:
|
| 2 questions - Project 2000 - Work scheduled is half of duration an Posted: 07 Nov 2004 10:28 AM PST You're welcome, Monica. Let us know if you get it fixed - good luck! :-)
Mike Glen
MS Project MVP
Monica wrote:
|
| analyze time scaled data in excel Posted: 07 Nov 2004 01:44 AM PST Hi Parastoo ,
Welcome to this Microsoft Project newsgroup :-)
There are three palces where you can change the date format and when you go
between software programs they must be the same. So:
1. Control Panel - find the Regional and Language Options, which is
probably set up for your country and note the Date format set up for your
computer.
2. Excel - select all the columns containing dates and go to
Format/Cells/Date and select the same format.
3. Project - Tools/Options.../ View tab and select the same Date format.
However, it is possible that the date format for your country is not
available in Project. If this is so, then you will have to accept an
alternative in Project and then reset Excel to match. If that still doesn't
work, you may have to select a different setting for your Region.
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
mousavi wrote:
|
| Project 98 - Installing? Posted: 06 Nov 2004 03:01 PM PST You're welcome, Sapper, and thanks for the feedback :-)
Mike Glen
MS Project MVP
Sapper wrote:
|
| Can I do this in project? Posted: 06 Nov 2004 09:01 AM PST You can do it in Project but it seems like hunting flies with an elephant
gun to me. I have a task that will take 20 man-hours of work. I want to
complete it by Christmas, 7 weeks from now. I work on average 40 hours per
week, 8 hours per day. There are 35 working days, 280 working hours
between now and Christmas. Therefore I need to spend 20/35 hours per day or
something between 30 and 45 minutes a day working on it. That's exactly the
same calculation Project does but at this scale of complexity I don't need
hundreds of dollars worth of software to do it. At this level all you need
is a calendar, pencil, and scratch paper; a middle-tech solution would be
the Outlook calendar and Windows calculator; or you can go really high-tech
and use Excel.
If you do want to use Project anyway, perhaps so you get the pretty Gantt
chart pictures, you'd list yourself as a resource (the only resource?) in
the resource sheet and input the tasks and the durations within which you'd
like to complete them. Split the screen and mark the tasks fixed duration.
Assign yourself to the tasks as the resource working them. Enter the work
estimate for the task and Project will calculate the percentage of your
working time you'll need to devote to accomplish that much work within the
duration specified. To play with the date, switch the task type to fixed
work and when you edit duration Project will recalculate the effort, the
percentage of your time, accordingly. If you look at the resource sheet and
see your name listed in red, it means you've scheduled yourself for more
total work in a day than your calendar says you want to do overall.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
"Keith Henderson" <keithatdvsolutions.teevee> wrote in message
news:phx.gbl...
|
| How do I limit Outline Number to exclude level 1? Posted: 05 Nov 2004 12:02 PM PST Didn't quite say you couldn't input your own numbers - that's what the WBS
code in the Project, WBS is for. You can name level 1 task AAA, or 100, or
antythhing you choose. But what you can't do is display the WBS for some of
the tasks in a view without displaying it for others. The display of a
given field, ie, column in a table, is either on for all of the tasks in a
view or for none of them. That means no matter what code you use, all the
tasks in the view will show their codes if any of them do. You still can't
have some of them at outline level 1 displaying your custom WBS code and
others at level 1 not showing it.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
"MOE Ken" <microsoft.com> wrote in message
news:com...
|
| Display Predecessor and Successor Task Names Posted: 05 Nov 2004 10:56 AM PST Hi
one method i use when the blue lines just get all too confusing is to format
the gantt bar chart to show the predecessor numbers on the left and the
successor numbers on the right (format / bar styles - text tab) and then i
turn off the arrows (format / layout). It's a bit of a pain having to hunt
for the predecessors / successors by number but it's a lot easier than
trying to follow the lines!
Cheers
JulieD
"tdbcalif" <microsoft.com> wrote in message
news:com...
|
| Is Project worth it? Posted: 05 Nov 2004 09:58 AM PST Excellent discussion! As I put it to my classes - you don't need to
understand all the tricks and techniques of a professional writer to know
all there is to know about using MS Word but to use Project effectively you
also need to understand the discipline of professional project management.
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
"JLB" <microsoft.com> wrote in message
news:com...
|
| Using effort-driven work, want durations and dates calculated....with no slacking! Posted: 05 Nov 2004 08:36 AM PST Hi Julie,
The full link is in the Links and Downloads page:
http://www.mvps.org/project/links.htm .
I think I'll add the full link to the Tiny one as it seems the Tiny one is
unreliable.
Thanks for your input
Mike
JulieD wrote:
|
| Schedule Posted: 04 Nov 2004 01:15 PM PST Hi
if you assign to meetings to the same resource, whether it be a room or a
person, then it will show in red in the resource sheet (known as
"overallocated") to see why a resource is overallocated you can use the
resource allocation view.
However, Project won't WARN you that you're trying to overallocate a
resource in the assignment stage.
Hope this helps
Cheers
JulieD
"Iconoclast" <com.ph> wrote in message
news:phx.gbl...
|
| Multiple Work Calendars and Duration Posted: 03 Nov 2004 02:04 PM PST The base unit of duration is the minute. "Days" are allowed in user input
and display for convenience but are converted to and from hours, thus
minutes, according to the conversion factor on the Tools Options Calendar
page. If it helps, start thinking of "day" as meaning "workday," a single
normal 8-hour work shift, rather than a calendar day and when estimating
durations think in terms of the number of shifts the tasks will require.
Thus a one calendar day task lasting 24 hours start-to-finish, starting
Monday at 8am and finishing Tuesday at 8am, takes 3 8-hour shifts or 3
consecutive workdays to complete. If entering and keeping track of the
tasks is becoming too complicated, start estimating work efforts in hours to
begin with.
You say you are hoping for duration to be equal to the physical number of
calendar days. Sorry, you just can't have that. Project time is measured
in either elapsed time or duration time. Elapsed time is the sort of time
watches and conventional calendars measure. The month of November has 30
days, 720 hours. But duration is specifically defined as the number of
working time units between two points (see PMBOK definitions) and any
non-working time is explicitly excluded from the measure. In the US and
assuming a normal 8 hour workday, the month of November has 20, 21, or 22
work days (22 weekdays minus 1 or 2 day Thanksgiving holiday) giving it a
duration of 160, 168 hours, or 174 hours depending on where you are.
I'd suggest examining your 24 hour calendar resources to see if that's
really accurate. The 24 hour calendar means that once the resource starts
work, that specific individual worker doesn't take a break until the work is
done, regardless of whether the task takes hours, days, weeks, or even
months to complete. People just don't do that.
I'll bet what you're thinking here is that you have, say, a group of 10
welders, some on days, some of swing, some on graveyard with a base calendar
of the 24 hour calendar assigned to the group. You have a welding task that
will take one person 24 hours to do so you're putting 1 day shift, 1 swing
shift, and 1 graveyard guy on it, each one relieving the guy before him and
working until the task is done. There are all kinds of problems with that -
calendar problems are one but also resource allocation and tracking max
allocations as well. I'd suggest a possible better way is to have 3
separate resource listings - Day Shift Welders, max 400%, base calendar
8am-5pm; Swing Shift Welders, max 300%, base calendar 3pm-12mid; Night Shift
Welders, max 300%, base calendar 11pm-8am. You have a task that will take
24 man-hours work and you need to get it done in one continuous stretch of
work going on steadily from start to finish so it gets done ASAP. Enter the
task with 3 days duration. Use the split screen to assign the resources.
Enter all three resources -- Day, Swing, & Grave -- with an assignment of
100% meaning one guy from each of the 3 shifts and give them 8 hours work
each. Duration will still be 3 days, ie, 3 shifts, but the task will go
24/7 until done and take 1 calendar day in the schedule.
Hope this helps
--
Steve House [MVP]
MS Project Trainer/Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs
"Jens" <microsoft.com> wrote in message
news:com...
|
| primavera format Posted: 02 Nov 2004 11:09 AM PST P3 will read .mpx, but not .mpp. The newer programs that have replaced P3
will read both .mpx and .mpp. And also with the ability to tailor the data
when importing. (Data can even be stored inside the Primavera database and
be part of a value-added bigger environment, whil being used as "normal" by
MS-P.) Which doesn't help if it has to be P3, I know.
If you can convert it to .mpx, the client may accept it, although there's a
lot more potentially to even P3 data so that depends on their detailed
requirements.
"Ed" <microsoft.com> wrote in message
news:com...
|
| Interim tasks: tasks that span a flexible gap Posted: 02 Nov 2004 10:44 AM PST Thanks! This was just the information I was looking for.
Out of curiosity, what is the internal updating approach for links? I
noticed that changes aren't always immediately reflected after moving
controlling tasks, but may be postponed until several tasks have been
manipulated.
JulieS wrote:
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---
|
