Pages

Search

Excel Help Forum - Excel General: Enter a team name in a cell on one sheet > automatically load stats form anot...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Enter a team name in a cell on one sheet > automatically load stats form another sheet
Hi there, I'm trying find a way of entering a team name in one cell on one sheet, for it to then automatically load the stats from the teams own spreadsheet. Not entirely sure if its possible, but excel seems to never fail. See attached spreadsheet... Any help is much appreciated.

Excel Help Forum - Excel General: Help can excel do this? change the values in a table using a function??????

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Help can excel do this? change the values in a table using a function??????
Hi Im a bit of an excel newbie and im trying to do something that i cannot find a solution for that is probably quite simple for you guys on here. I have a table it only has 2 columns, the first colum contains locations(20 in total) and each location has a numerical value in column 2. In my excel...

Excel Help Forum - Excel General: Using Multiple MATCH Tables on 1 spreadsheet

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Using Multiple MATCH Tables on 1 spreadsheet
Hello Experts, Here is my situation ... I created a MATCH table to assist in creating production standards for a particular piece of machinery in my company. It matches the first 2 criteria nicely and provides me with the correct match information in the following columns. I also use a...

Excel Help Forum - Excel General: How do I color rows alternately? Not 1 row after the other, but depending on ...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How do I color rows alternately? Not 1 row after the other, but depending on column data
I have some sales data with orders and item details listed in a excel worksheet. The order # is listed in column A, and the items for that order are listed in column B. A single order can contain many items :) I want all rows in one order to be colored the same, and the next order to be colored...

How to make multiple department scurity step by step in project server 2002 Microsoft Project

How to make multiple department scurity step by step in project server 2002 Microsoft Project


How to make multiple department scurity step by step in project server 2002

Posted: 13 Apr 2004 09:48 PM PDT

Jumadi --

I am assuming that project managers in Department A need to be able to see
all of the Department A projects, and that Department B project managers
need to be able to see all of the Department B projects. If this is the
case, then your Project Server administrator will need to do the following
in order to make this scenario work properly:

1. Remove the project managers in both departments from the Project
Managers group
2. Create two new Categories called something like "DeptA Projects" and
"DeptB Projects" and manually select the projects viewable in each Category
(there is no automatic way to make this happen)
3. Create two new Groups called something like "DeptA Managers" and "DeptB
Managers" and add the project managers to their respective Group
4. Add the "DeptA Projects" category to the "DeptA Managers" group and add
the add the "DeptB Projects" category to the "DeptB Managers" group
5. Each time a new project is added to the Project Server database, you
will need to manually add the project in either the ProjectA Projects or
ProjectB Projects category

Hope this helps.

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


"Jumadi" <microsoft.com> wrote in message
news:196a601c421db$baf30660$gbl... 


Analysis Toolbar

Posted: 13 Apr 2004 05:02 PM PDT

Thanks for this. 
it 

Reports Menu from "Command buttons"?

Posted: 13 Apr 2004 01:58 PM PDT

Hello John,
Yes this can be done. My work around is quiet lengthy so
Please email me direct.
Cheryl 

Task filters - criteria

Posted: 13 Apr 2004 01:54 PM PDT



--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
"John Castle" <microsoft.com> schreef in bericht
news:1c0b701c42199$82a8ccf0$gbl... 


Project 2002 vs 2003 Comparisons

Posted: 13 Apr 2004 01:16 PM PDT

Hi ...

Came across this document ... seems to fit the bill ...

www.projectgroup.com/Shared%20Documents/
Downloads/Demos/Whatsnew.doc -

Cheers

Regards Johnkat
 
MSP 2002 Pro and 2003 Pro! Anyone have any clue if such a
document exists? Microsoft's web sites are really getting
clugged up with all kinds of useless information! 

Calendar - Standard vs. 6.5 hour

Posted: 13 Apr 2004 11:06 AM PDT

I think the Project Calendar should reflext the work schedule of a generic
"typical" resource so in your case I'd go along with the notion that the 6.5
hour calendar should be used. You did remember to take into account
lunches, etc as non working time didn't you? Also, set the days per week
and hours per day in the Options Calendar page to agree with the Project
Calendar

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

"JAckie" <com> wrote in message
news:1933701c42182$04d157f0$gbl... 


Observation about leveling and summary tasks with resource assignments

Posted: 13 Apr 2004 08:44 AM PDT

well observed but this is not really any sort of revelation.
while you are at it, don't bother to link the summaries either.
no links, no resources, simple life.

"Aren Cambre" <smu.edu> wrote in message
news:google.com... 


Benefits of one project per file

Posted: 12 Apr 2004 02:16 PM PDT

Well, as I said, it's just my opinion/view ... not hard and fast rules
.... I'll elaborate:

1. File Size: when files get too big, hard to email and handle, take
longer to open and close and (heaven forbid) when they get corrupted or
otherwise fail less is lost that requires fixing (backups essential).
2. File Complexity: too much data (tasks) in a project file make it
hard for user to use, especially when unconnected/unrelated information
is clogging up things. Smaller files helps with people who are reluctant
or don't want to use Project (for whatever reason) by keeping the data
need focused on things they *do* or *should* care about (given their
project responsibilities).
3. Organsiation: splitting up files to match the organisation allows me
to "divvy-up" the project files in line with how the work is allocated.
People can work on their own piece of the project without interfering
other pieces, either on line via the network, or remotely and
collaborate by exchanging project files via email.

Re "with one project in one file, can I do things with it that I can't
do when there are multiple files" ... can't think of anything really
since even with many individual files, you can put them any or all of
them into a master file and from that perspective they are one and the same.

No matter whether you have fewer big files, or more smaller files, you
still have to watch versioning and insure old files don't over-write new
files (if that how you are exchanging). A process or method to check
in/out files helps a lot.

Hope this is useful to you. Let us know.

rms




Conrad Santiago wrote: 

gbui ??????

Posted: 12 Apr 2004 02:06 PM PDT

Project 2002 & 2003 views, tables and charts are actually web components
inside Internet Explorer inside Project... convoluted, but true.
This means that in order for Project to display the "plain old" gantt chart
for instance, the web page for setting this up must be loaded in the web
browser inside Project.
This page is found inside a dll normally installed in the path <C:\Program
Files\Common Files\Microsoft Shared\Microsoft Office Project
11\1033\PJINTL.DLL>
(on my machine, running Pj2003.)
This page is accessed using the "gbui://mainpage.htm" setting found under
Tools/Options/Interface and the Project Guide settings.
Actually, the default is "gbui://mainpage.htm" but you could use your own
page - check out the MSDN pages for rolling your own Project Guides -
especially the Project2002 dev. pages.

If you're having "gbui" trouble, try copying a known-to-be-working version
of the PJINTL.DLL from another computer/CD to your machine.

--

/Lars Hammarberg
www.camako.se
MSProject Premier Partner



"KH" <microsoft.com> wrote in message
news:16fe601c420d2$03c43db0$gbl... 


Server

Posted: 12 Apr 2004 12:09 PM PDT

Jorge:

No, the collaborative features (issues, risks, and
documents) are available through project server only.
Just an fyi, the risks feature doesn't search for or
identify risks analytically; instead, it allows you to
notify project members of a risk.

Hope this helps!

----------------------
Sean Pales
EPM Solutions Group
Bennett Adelson
www.bennettadelson.com
 
only 

Help Date formula for Flag field

Posted: 12 Apr 2004 11:24 AM PDT

Glad I could help. Good luck with it!

-Jack


"Steve" <com> wrote in message
news:phx.gbl... 
picture 
difference 
flag1 


Tracking Gantt - Compare to Interim Values?

Posted: 11 Apr 2004 02:00 PM PDT

Hello John,

Yes, you can. Display the Tracking Gantt, then :
Format / Bar Styles...
Go down so that you find the "Baseline" grey bar. You can change the From Baseline Start To : Baseline Finish by
From Baseline Start1 (or x) To Baseline Finish1(or x).
Hope this helps,

Gérard Ducouret


"John Castle" <microsoft.com> a écrit dans le message de news:1b19001c42008$15499eb0$gbl... 

Reports to Word

Posted: 11 Apr 2004 01:59 PM PDT

But not "reports" AFAIK.

Hope this is useful to you. Let us know.

rms



Donna wrote: 

Col Moves

Posted: 11 Apr 2004 01:58 PM PDT

I don't have P2000 installed any more.

In P2003 you can do that in both task and resource views.

On Sun, 11 Apr 2004 13:58:39 -0700, John Castle
<microsoft.com> wrote:
 



--

The best way to schedule non-dependant tasks

Posted: 11 Apr 2004 10:56 AM PDT

Hi,

This is fortunately absolutely unnecessary.
Even with the option "from start" Project calculates Latest start and finish
dates.
You just have to insert them as a column to make them visible.

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
Project Management Consultancy
Prom+ade BVBA
32-495-300 620
"David" <microsoft.com> schreef in bericht
news:com... 
can start each task and finish as early as possible. One way to to this is
to schedule the project task from the finish date. Go to Project, Project
Information, Schedule from:. drop down: Project Finish Date. Now just enter
your tasks along with the duration. Project will determine Finish Date from
the longest task duration and adjust the other task dates to start as late
as possible. 


Working with Shifts

Posted: 09 Apr 2004 04:56 PM PDT

You're on the right track with your first approach but IMHO went wrong with
a fundamental error regarding the nature of a task in a project plan. A
task is a discrete, measurable package of physical work that has a definite
observable start and ending time. It's duration is the actual amount of
time between when it starts and ends. Where I think you (and many others,
you're not alone) went wrong is you used "duration" to mean the limits
between when it *could* take place and not a prediction of when it *will*
take place. If I have a task that will take one day of work that must be
done sometime between Monday and Friday of next week, it is a one-day
duration task with a Friday deadline, NOT a 5-day task with a MFNLT
constraint of Friday. You went on to say you did this because you didn't
know which shift would be available to do it. The problem with that is the
function of the project manager is to *designate* when it will be done - you
look at when the predecessor task will be done, let's say it finishes at 2pm
Tuesday and thus the task in question can start anytime after that. You go
to the swing shift foreman and tell him to assign someone to the task
Tuesday evening. Note he doesn't tell you when he's scheduled someone, you
tell him when he needs to schedule them.

So in your example, your task is 6 hours duration and has one resource
assigned 100% (NOT 300%, that screws up your work estimates and budget by
showing the task requiring and costing 18 man-hours work when it should only
be 6). If that resource is a day shift worker the task will be scheduled
duration the day. If that works well from the project objectives, fine. If
the predecessor finished at 2pm the previous day and you need the task in
question really to begin asap, then assign it to a swing resource instead
and it will move up closer to when the predecessor ended. Then you go to
the foreman/manager, whoever is the person that has the functional authority
over the workers and tell them they need to assign a worker to do the work
starting at such and such a time from whichever shift that you've decided is
best for the project schedule.


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


"mmaxwell" <microsoft.com> wrote in message
news:com... 
too...actually I logged on to see if any new posts have been added on the
subject. 
(resources) to a task MS Project requires that ALL resources work on that
task. For instance, I assigned 3 shifts (24 man hours) to a task that only
required 6 man hours to complete. I wanted all 3 shifts to be "available" to
work because I wasn't sure which one would actually do the work when it was
time. What I have observed, and would like a solution too is this, Project
assigned each shift 1/3 of the work...or 2 hours. 1st shift worked on the
task from 8-10 am then did nothing. 2nd shift worked from 4-6 pm and then
did nothing. 3rd shift worked from midnight to 2 am then did nothing. A task
that should have taken 3/4 of a single shift had a duration of one full day. 
resource to the task. I used the resource "Tech" and assigned him at 300%
(or 3 people) and left the working hours set at the default. It is NOT
perfect but it is a close approximation. If anyone else has any idea how to
accurately handle resources that work shifts, please let us know.


Project Standard 2003 Evaluation Download

Posted: 09 Apr 2004 01:07 PM PDT

a

How do I create a customized task ID that maintains consecutive number for filte

Posted: 09 Apr 2004 12:04 PM PDT


Hung,
To do that you will have to use a spare field (e.g. Number1) and fill in
the numbers after the filter is applied.

John

opening project from database is VERY slow

Posted: 09 Apr 2004 06:00 AM PDT

When I open the database with Access, it opens normally (a few
seconds). The problems actually appears only with Project.

Rob Schneider <net.net> wrote in message news:<phx.gbl>... 

Turn off scheduling messages

Posted: 09 Apr 2004 05:26 AM PDT

So you did this and it still isn't working?

Is it the planning wizard that's giving you problems?
You can turn off the planning wizard by going Tools,
Options, General tab. Clear the planning wizard check
boxes.

Hope this helps! If not, please repost.

---------------------------
Sean Pales
EPM Solutions Group
Bennett Adelson
www.bennettadelson.com
 
boxes. 
to my duration cell whenever I increase the duration on a
task that has a resource. It asks me the same questions
every time and I don't need it. 
slowing down the opening of my MSWord 2003, waiting on
some macro to open. How do I disable this? 

Proj view in Word

Posted: 08 Apr 2004 08:46 PM PDT

Len:

If you're using Project '03, use the Copy Picture to
Office Wizard button on the Analysis toolbar. Just a
thought!

Good Luck!

---------------------------
Sean Pales
EPM Solutions Group
Bennett Adelson
www.bennettadelson.com
 
Word? I require high level summary reports in my
document, and would prefer to Clipboard&Paste, but am
prepared to print to file if required. A linked OLE would
of course be the bees knees. 

How much difference between Project 2002 and 2003?

Posted: 08 Apr 2004 04:21 PM PDT

If you are going from Proj2002 Standard to Proj2003 Standard you will find
very little difference.
The list below shows this (and one could argue that the export timephased
data is not a new feature)
Personally even though I could upgrade easily (my company has a license for
both) I'm still using 2002.
Proj2003 Standard has some bugs (most notably a problem with indentation) so
you will need to install a hotfix for it as well.

-Jack



"Sean" <com> wrote in message
news:1a74f01c41e37$42173bf0$gbl... 


Project & Outlook Integration

Posted: 08 Apr 2004 02:06 PM PDT

Sean - I have had issues integrating project 2000 with
outlook 2002. Project team members have run WGsetup.exe
and receive task assignments I have initiated in project
via teamassign. However, the MS project help states the
following "Double-click a TeamAssign message to open it.
When you accept the assignment and reply to the message,
the task is added to your task list in Microsoft
Outlook." The task is not being added to users outlook
tasks. Any suggestions?
 

Microsoft Project and Web Access

Posted: 08 Apr 2004 12:27 PM PDT

I GOT IT WORKING FINALLY... thanks for all your help 
still 

prohibiting 
all 

Printing breaks

Posted: 08 Apr 2004 06:41 AM PDT

You're welcome, Brian :-)

Mike Glen
MS Project MVP

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


Excel Help Forum - Excel General: Conditional Format for Peak Flow Meter -COPD

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Conditional Format for Peak Flow Meter -COPD
I need to conditional format Air Flow grid according to the color scale shown. Posting the reading places the number correctly but the color format is lost. These meters are used for people suffering from COPD and a spreadsheet would be most helpful. Thanks for your help.

Excel Help Forum - Excel General: How to add 1 to a calculated cell if a range of cells are not empty?

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to add 1 to a calculated cell if a range of cells are not empty?
This is difficult to describe. I am trying to calculate "Projected yearly gross". The gross is divided by the number of accumulated weeks. So, if we are only 10 weeks into the fiscal year then the gross amount is divided by 10. Currently, I am altering the cell by changing the number each week by...