Pages

Search

Excel Help Forum - Excel General: Need help with having excel return custom algorithm results

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
Need help with having excel return custom algorithm results
I have looked into several different ways of solving this and have not been able to identify a solution as of yet. I have attached an example of the kind of data sets that I am working with as well as an example of the algorithm which I am currently using to analyze these data. The information is...

Excel Help Forum - Excel Charting & Pivots: Stacked and Solid Columns in one chart

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
Stacked and Solid Columns in one chart
Dear Forum, I would like to show on the same chart a stacked column (Columns: E,F and G. Rows: 6,7 and 8), just like the one shown on the chart attached. With a solid column next to it (Columns: E,F and G. Row: 9) Please see excel attached. Thank you!

Excel Help Forum - Excel General: bad connection?

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
bad connection?
has anyone else been having problems trying to stay connected to EF these past few days?. often, when i click on something, it takes ages to load, and then just crashes

Windows 7 - Folders view bug

Windows 7 - Folders view bug


Folders view bug

Posted: 16 Feb 2010 07:40 AM PST

On 16/02/2010 16:08 SC Tom wrote:
 

Thanks, I'll give it a try.

--
F


D partition empty...want to add to C partition

Posted: 16 Feb 2010 06:41 AM PST

On Tue, 16 Feb 2010 11:10:55 -0500, Yousuf Khan
<yahoo.com> wrote:
 

The way I read it, he has a single 750 GB drive that currently
contains two partitions. He wants to eliminate the second partition
and expand the remaining partition to use the entire disk space.

Re-addressing messages

Posted: 15 Feb 2010 06:50 PM PST



"FiOS-Dave" <zz> wrote in message
news:hlejeq$nhu$aioe.org... 
I found a good batch modifying program called (guess what) BFM.ZIP - Batch
Modifying Program.
It took me all of about 6 minutes to use it to modify the FROM: address on
all 65 messages.
Unfortunately, this does not cause WLM to send them using that FROM:
address.
There must be another location that is storing the account information
because I see no
other reference to it in the .EML files.
Almost ready to give up and modify them one at a time...

Dave

Frank and Alias

Posted: 15 Feb 2010 02:11 PM PST

On Mon, 15 Feb 2010 16:11:52 -0600, Nunya wrote:
 

Yes - too bad their parents don't provide proper supervision.

alias the lying POS *COWARD*!

Posted: 15 Feb 2010 10:48 AM PST

John Smith <com.INVALID> wrote in
news:hldglg$ud$eternal-september.org:
 

Your wasting your time.

Frank is a childish bore who's entire existance on Usenet is to stalk and
attack Alias.


Win Live issue

Posted: 15 Feb 2010 09:45 AM PST

"news.eternal-september.org" <net> wrote in message
news:hlchk5$g84$eternal-september.org... 

system restore then
--
John the West Ham fan

com
<><




Swapping between wireless and wired networking

Posted: 15 Feb 2010 08:51 AM PST

On 2/15/2010 10:51 AM, Orc wrote: 

Just so you don't feel left out, you're not the only one that's noticed
this same behavior. This happens with my laptop as well and it didn't
happen with Windows XP. So I Googled WIndows 7 network priority and
came across this:

1. Click the Start Button
2. Right Click "Network" and then left Click Properties
3. From the "Network And Sharing Center" window click "Change Adapter
Settings"
4. On the "Network Connections" window, press the ALT key on your
keyboard to bring up
the menu bar
5. Click the "Advanced" menu and then "Advanced Settings"
6. In the "Advanced Settings" window you will see the "Adapters and
Bindings" tab and under
"Connections" you will see the order they are in, you can use the
arrows to the side to
move the connection priority up and down.

Now reboot, and after the pc has restarted your wired lan card will have
a higher priority over the wireless card. Both will still connect, but
the wired lan card will get all the network traffic when it's network
cable is plugged in.

--

Roy Smith
Windows 7 Home Premium

Timestamp: Tuesday, February 16, 2010 1:56:01 PM

Excel Help Forum - Excel General: Need help with having excel return custom algorithm results

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
Need help with having excel return custom algorithm results
I have looked into several different ways of solving this and have not been able to identify a solution as of yet. I have attached an example of the kind of data sets that I am working with as well as an example of the algorithm which I am currently using to analyze these data. The information is...

Microsoft Word - How can I eliminate a gap that appears between the end of footnote text and the bottom of page?

Microsoft Word - How can I eliminate a gap that appears between the end of footnote text and the bottom of page?


How can I eliminate a gap that appears between the end of footnote text and the bottom of page?

Posted: 27 Oct 2012 07:44 AM PDT

My footnotes are suddenly not going to the bottom of the page.  There is a space now between the footnote text and the bottom of the page.  This happened after I deleted a footnote that was strangely appearing twice.  I inserted it again and now I have a formatting problem that affects all footnotes.  I have gone into paragraph and style.  When I turn on the formatting marks I notice a large paragaph sign next to the line that is aotomatically inserted above the footnotes.  I wonder if has something to do with that formatting  which I don't know how to access.

I would appreciate any help

Thankd

Word 2013: Accessing own document styles

Posted: 27 Oct 2012 04:27 AM PDT

Hello,
how do I access my own document styles? If I click on "New", I only see Program-Styles, but not my own. I changed the paths in the Program-Options to my folders. In Word 2010 it works without problems.
Regards,
Carl

Word and Powerpoint 2003 mathematical symbols

Posted: 27 Oct 2012 02:08 AM PDT

How can I insert matrix notation in Word and Powerpoint 2003?

 

Thanks,

Jimmy See

just recently downloaded 2010 starter. When I try to print the paper comes out without print. Same problem with word pad

Posted: 26 Oct 2012 02:51 PM PDT

My starter 2010 and word pad will not print. Paper comes out without print. Ink ok

Error: Cannot open existing normal.dot

Posted: 26 Oct 2012 11:34 AM PDT

I have a Windows7 machine with Office Pro 2003 installed. Wednesday it locked up and I had to restore to a saved restore point. Since then, opening any Word document (or Outlook, which uses Word) give the message:

 

Word cannot open the existing Normal.dot...

 

If I proceed past the warning, it says that the file is locked by another user (there is of course no other user!) and it will only open read-only. On closing Word it attempts to save the changed (!?) Normal.dot, and errors out whether I say yes or no.

 

I've reinstalled Office to no avail.

 

Any suggestions for a frustrated Access MVP working way outside his comfort zone?

 

WORD - Administrator - add-ins

Posted: 26 Oct 2012 10:46 AM PDT

I have a notebook with Windows 7, IE9, Office 2010 and all the latest updates.  I am the sole user and I am an Administrator. When I attempt to remove add-ins and toolbars I get an error message that only an Administrator has these rights.  I am the Administrator!

Word table split over two pages

Posted: 26 Oct 2012 10:41 AM PDT

I have a table that is split between two pages. Is there a way to have the header row appear at the top of page 2?

I just printed about 2,300 labels using word 2010. Most are wrong ZIP code prints with out the "0" 2730 should be 02730

Posted: 26 Oct 2012 10:02 AM PDT

how the h... do I get ZIP codes to print properly?

Archiving files onto dvds. Now a Thumbs .db file in each folder and now I cannot amend the disc.

Posted: 26 Oct 2012 05:13 AM PDT

I have been archiving old files onto dvds.  Last time I tried to access the files, there was a Thumbs .db file in each folder and now I cannot amend the disc.  How can I remove the db files and prevent this happening again?  Many thanks.

Text marked with "do no check spelling or grammar" was skipped

Posted: 26 Oct 2012 05:05 AM PDT

 

I am using Word 2007

I have reviewed all the posted answeres & tried all the suggestions... no luck.

 

While working trying to fix this problem I did have a two instances when spell check

picked up errors, but only for the immediate misspelled work -- and because I was

trying so many things.. I don't remember what I did to "fix" it. But it only fixed that

one word - not the rest in the document, nor any of my attempts worked on future

documents.

 

I believe I have covered all the bases that have been suggested ---I have gone into "proof", "language," & "style"

 

I have no idea why I am having this problem --- everything was fine two days ago!?!

 

PLEASE HELP

 

thank you!

Help with printing 2003 document using 2010 ...

Posted: 25 Oct 2012 02:52 PM PDT

Hi, 

Has anyone experienced problems printing a Word 2003 document in Word 2010 that contains an imported PNG graphic?

I created a Word 2003 template and e-mail this document to a client. The imported graphic was placed in the header of the Word 2003 document similar to a watermark. However, when my client tries to print this document, the image does not print.

Thanks in advance for your help.

Best regards,
Greg

Word 2010 & Speech Recognition to apply Style Headings

Posted: 25 Oct 2012 02:12 PM PDT

System: Windows Ultimate 64x

Software: Word 2010 & Speech Recognition

 

I've just setup speech recognition, worked through a part of the tutorial, and then began dictating into Word and love the results! However, probably because I haven't made the time to complete the tutorial just yet, I am unable to apply Style Headings to selected text.

How do I use speech recognition to apply a Word style heading to selected text?

Thanks,

Buck

 

Macro Programming: Creating a Variable Name

Posted: 25 Oct 2012 06:56 AM PDT

I would like to create a variable name from text and other information contained in variables. I could do this in another language but cannot discover how to do it in VBA. I have some code below. In my document I have bookmarks and variables with the same name. When the user clicks on an area of the document, I want to test to see if the bookmark is in that area, and if it is, display a message box with some help text. As you can see in the code below, I am looping through to test for all bookmarks and I would like to create the appropriate bookmark name from the variable indices and some text.

I tried the command CVar but that just changes the type of variable, not the variable name.

Right now my message box says "BatTip21111" and I would like it to say "Define standy and fully off." Any ideas? TIA.

 

Dim BatTip1111 As String
Dim BatTip1112 As String

BatTip1111 = "Define standby and fully off."
BatTip1121 = "e.g., oxygen rich areas, corrosive, materials or liquids, MRI, high electromagnetic fields"

For i = 1 To 5
    For j = 111 To 999
        If ActiveDocument.Bookmarks.Exists("BatTip" & j & i) Then 'Ensure bookmark exists
            If Selection.InRange(ActiveDocument.Bookmarks("BatTip" & j & i).Range) Then
                strBatTip = ???("BatTip" & j & i)
                MsgBox strBatTip, vbOKOnly, "Battery Section Tips"
                Exit Sub
            End If
        End If
    Next
Next

French characters not displayed correctly in Word 2007

Posted: 24 Oct 2012 09:43 PM PDT

I have Word 2007. The Windows keyboard language is set to have both the US English and Canada French keyboards with the Canada French keyboard to be the default input device. My understanding is that the Office Language settings is for proofing tools and the such in the office suite. Either way it is set to Canada French. Results are the same even if I have only the Canada French keyboard listed.

When using Wordpad, Notepad or another non-Office application, clicking ^a will result in the proper â. Yet when you are Word (or Excel or Outlook) typing the same ^a results in ^^a being displayed. Similarly typing 'e should result in è but instead you get ''e displayed. Similar result for the other accented characters such as a, i, o, u, etc.

Pre-pending the CTRL key to the key sequence will give the desired results in Word (or Excel or Outlook) but should only be required if using a US English keyboard. Not when using a French keyboard and it has worked in the past without the CTRL key in the sequence.

Results matrix

     Key sequence             Office application result             non-Office application result
           ^a                                       ^^a                                                  â
            'e                                        ''e                                                    è
       CTRL + ^a                                â                                                    a
       CTRL + 'e                                 è                                                    e

Any thoughts on this would be greatly appreciated.

Thanks, Jason

Can't open Word File because of end tag/start tag mismatch error

Posted: 23 Oct 2012 10:27 PM PDT

I get the following message when I try to open a word document that I prepared for weeks: 
The name in the end tag element must match the element type in the start tag
Location: Part: word/document.xml, Line: 2, Column: 16257916

I've googled and read a few threads here and i think it requires xml experts to fix it. I am hoping if anyone can help me fix it as i've prepared this documents which is of about 70 pages and with lots of diagrams for a really long time and i desperately need it.
Here's the document, i've uploaded to two spaces so that you can download it more conveniently: 
4shared: http://www.4shared.com/file/QlYdTKEK/Anatomy.html
Thank you very much for your help.

Word 2007 randomly stops working when trying to close or save a document.

Posted: 22 Oct 2012 01:12 PM PDT

When trying to close and/or save a Word 2007 document, Word randomly stops working.  I have reloaded Office Pro 2007 3 times and made sure all updates have been installed but still haven't resolved the issue.

Word 2010 freezes when trying to save (problem corrected once but back again)

Posted: 21 Oct 2012 06:53 PM PDT

Last time I found directions to fix the problem on a random site, it worked for a week or two, but it's back again. The directions I've seen on this site (supposedly from tech support), I couldn't find the file/key in question to follow through with the instructions, but regardless others respondents said it didn't work anyways. I could try to find those other directions again, but obviously I'd rather have a long-term fix.

When typing this problem into Google, this appears to be a common issue. I can't imagine why a company like Microsoft will not address this problem in a clear and efficient manner (since it's been around for at least a couple weeks now), and instead is basically telling their customers to go find another company for all future purchases. 

How do I change font size in MS2010 labels?

Posted: 21 Oct 2012 02:55 PM PDT

I am running  Microsoft 2010. How di I change the label size?

How do I set up my word documents to have a book look?

Posted: 21 Oct 2012 01:25 PM PDT

http://s1211.photobucket.com/albums/cc422/kewlkitty123/?action=view&current=SSofStory.

I set up one of my documents to look like this, but it was a long time ago and I can't remember how to do it anymore? Any one have a clue? Please I really need to know.

Hyperlinks in WORD (Word only. I can do it in Excel)

Posted: 21 Oct 2012 12:38 PM PDT

How can you highlight complete document and remove all hyperlinks at once.

Can't open Word files directly

Posted: 20 Oct 2012 09:25 PM PDT

Hi everyone, 

Firstly, I have Microsoft Word Starter pre installed in my computer. 

Then I downloaded MS Office 2010 trial and recently uninstalled it bcos it expired. Now I couldnt double click on the word document to open it. (when i did this b4 i installed MS trial, it opens with MS Word Starter) Instead I have to open Word Starter first, then open the file from there. 

It didnt work when I tried to right click on the word file and choose the default program to open it as MS Word Starter. It's like, when i choose MS Word Starter, it automatically becomes 'open with' 'MS Office Virtualisation Handler'.

Anyone knows how to solve this, so i can open my word files directly? 

Bug in MS Word 2010 "Can't Preview"

Posted: 20 Oct 2012 08:09 PM PDT

The bug in MS Word that you can't preview a Word document while in Word is a big issue.  If it is not fixed in 2010 I don't expect it to be fixed in the next version.

i need product key to use trial microsoft office and home

Posted: 20 Oct 2012 01:55 PM PDT

i am down loading micro soft office and home free down load trail 60 days and i need a product key to activate software

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

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
[SOLVED] 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.

Microsoft Works - Works 6.0 Label Start Position

Microsoft Works - Works 6.0 Label Start Position


Works 6.0 Label Start Position

Posted: 30 May 2004 07:36 PM PDT

Hi Kevin. Since it appears that the label printing will always start in
outer Row 1 , I then created "dummy" data base records for the number of
labels I wanted to skip. These records were at the beginning of my data base
and contained info that I knew would not print. Worked great but hopefully
someone will come up with a better solution.

Dannie

"Kevin James - MSMVP Works" <org> wrote in message
news:#phx.gbl... 
Rows. 
sheet 
can 
of 


htmldemo.wdb

Posted: 29 May 2004 08:54 PM PDT

Thanks Kevin.
Both links expired.
Thanks for your effort.

"Kevin James - MSMVP Works" <org> wrote in message
news:phx.gbl... 
the 


Works 6.0 Labels

Posted: 29 May 2004 07:12 PM PDT

Kevin, Thanks. Worked like a charm the first time.
Dan

"Kevin James - MSMVP Works" <org> wrote in message
news:phx.gbl... 

BUT I 


cannt get my computer to take it;'s pass code

Posted: 29 May 2004 05:54 PM PDT

"B's" and "8's" look very much alike as well.

Melissa


"augusta" <microsoft.com> wrote in message
news:152ff01c4466c$89fedc90$gbl... 


outlook express does not see word

Posted: 29 May 2004 12:26 PM PDT

Free spell checker:
http://fileforum.betanews.com/detail.php3?fid=1040780059
--
Jim Pickering, MVP-Outlook Express
Please reply only to newsgroup.


"oldcrusty" <net> wrote in message
news:%phx.gbl... 

2004 Works Suite Streets & Trips

Posted: 28 May 2004 06:25 PM PDT

Hi Kim,

Am pleased to read the information was helpful.

Ken

"Kim" <microsoft.com> wrote in message
news:14c6801c4452d$f75b57e0$gbl...
Hi Ken,
Thanks so much for the info. I used the second option and
was able to completely reinstall the MS Works Suite. I
wish I'd found this website sooner! I would've saved
myself lots of time and aggrivation! Thanks again! :)
Kim

 
one references 
US;242323 
message 


Works Suite 2004 / Office XP Service Pack 3 (SP3)

Posted: 28 May 2004 04:07 PM PDT

Hi,

Thanks Kevin, that worked fine. Just a bit confusing
wirh it being called an Office XP (SP3) upgrade when you
have Office 2000 installed along with Word 2002.

Yhanks .. Norman 
Update site 
installation. 
FamilyID=85af7bfd-6f69-4289-8bd1-
eb966bcdfb5e&displaylang=en 
Word 
now 
pack 
2000 
http://www.btinternet.com/~kevin.james1/index.htm 

Cannot open MS Works Calendar

Posted: 28 May 2004 09:25 AM PDT

Hi Frank,

You may make backups of your Calendar data :

Works: How to Backup Calendar Information in Various Formats
http://support.microsoft.com/?kbid=246703

You may also wish to keep a copy of this file:

Works Calendar: Description of the Mswkscal.wcd File
http://support.microsoft.com/?kbid=263971

HTH,


In news:14c0301c4450b$02b41690$gbl,
Frank C. <net> typed: 

--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works) 1999-2004
Website & FAQ: http://www.btinternet.com/~kevin.james1/index.htm






invalid name

Posted: 27 May 2004 04:54 PM PDT

What version of Works do you have?

In my Works 6, it accepts " " (quote space quote) in a date formatted field. But you
might try "' (no space) and see if that works.

As for H2:L2 did you use SUM(H2:L2)? You can just put the range in the formula, you also
need to tell Works what to do with the range.

--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm


"Troy" <net> wrote in message
news:1402201c44445$fded3530$gbl... 


Cannot Register

Posted: 26 May 2004 11:26 PM PDT

Hi John,

Perhaps: How and When to Contact Microsoft Customer Service
http://support.microsoft.com/default.aspx?scid=kb;en-us;295539

Ken

<microsoft.com> wrote in message
news:1550401c446aa$391f1720$gbl...
Kevin:
Thanks for your help, but it just ended up taking me back
to the exact same error message (after I clicked
on "Works 7.0" from the page you gave me the link to.)
And I can't find anywhere on that page to contact
Microsoft to let them know (other than "feedback," which
probably isn't the right place.)
 
sp 
Works 
sp 
http://www.btinternet.com/~kevin.james1/index.htm 
message 
error 
840981 
to 
next 
with 


What's included in Works 7.0?

Posted: 24 May 2004 08:52 AM PDT

Works Suite 2004 has both Works 7 and Word
Jeff
"Mikael Nørrelund Andersen" <dk> wrote in message
news:40b21a09$0$18703$dk.telia.net... 


Works Suite 2004 Birthdays Sync

Posted: 23 May 2004 01:23 PM PDT

Hi Peter,

Perhaps this knowledge base article addresses your query....

All the birthdays appear on January 1 in Calendar when you use Works 7.0 to
import birthdays from the Windows Address Book
http://support.microsoft.com/default.aspx?scid=kb;en-us;837925

Ken

"Peter" <microsoft.com> wrote in message
news:10da101c44103$db281140$gbl...
The software claims to synchronise the works calender
birthdays with the windows adress book. If I do activate
a birthday in the adress book, works calender attempts to
synchronise, but gets it all wrong. In works, the
Birthdays are generally set to the first of January.
Of course, I can set birthdays independtly in works. But
why should I do all the entering twice.

Any ideas how to coax works to get the right dates?


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...