Pages

Search

Open Office - [discuss] excel->oocalc incompatibility leads to grading "gotchas"

Open Office - [discuss] excel->oocalc incompatibility leads to grading "gotchas"


[discuss] excel->oocalc incompatibility leads to grading "gotchas"

Posted: 19 May 2006 03:24 PM PDT

Hi Brian

I'm sorry about the problems you've had, and I'm glad (for you and the =

students) that you discovered the lower marks before it was too late.

You seem to be making three main points, that I'd like to comment on.


1. SOME CALC FUNCTIONS DIFFER FROM EXCEL FUNCTIONS
 

While many of the fuctions work the same way in both programs, there are=
=

functions and notation that do differ.

While I wouldn't like OpenOffice.org to be limited to copying Microsoft'=
s =

functions, I think you are making a good point. If you have an Excel =

spreadsheet that works fine in Excel, and you import it into Calc, you =

would normally assume that the formulas would give the same answers. =

Either the import process should convert the formulas to the equivalent =
=

Calc formulas, or a warning should be given that some formulas in the =

spreadsheet may give different answers to Excel.

Sometimes there is only a slight difference between the formulas, and th=
e =

answers would usually (but not always) be the same. It may be difficult =
to =

determine just how to convert each formula into Calc. In this case, =

changing MIN to MINA would have been appropriate, but would it always be=
=

appropriate in every spreadsheet? That is hard to know.

I'm sure this has been discussed before. Does anyone have some further =

insight?


2. THIS INCOMPATIBILITY WILL DISCOURAGE MIGRATION
 

I disagree with this point - as long as the people considering migration=
=

understand the issues. There is always a cost in migration, and usually =
a =

big part of that cost is learning to do things a new way.

I don't know how many different spreadsheet programs I've used since the=
=

DOS days. It's probably somewhere between 10 and 20. All of them deal wi=
th =

many functions in different ways.

Same goes for word processing. I used to know every function key =

combination for WordPerfect 5.1, and it hasn't helped me one bit in any =
=

word processing program. They all have different features, key =

combinations and menu structures.

But that's the great thing about OpenOffice.org. It's cross platform. Ge=
t =

to know it in Windows, and you can use it in Linux. Possibly that's a =

starting point when talking to your friends - get them to consider =

changing to OpenOffice.org and Firefox, and talk about Linux when they'v=
e =

made that change.

In fact, if you'd created your spreadsheet in OpenOffice.org for Windows=
, =

you wouldn't have had a problem using it in Linux.

In case I wasn't clear, my point is that once people migrate to =

OpenOffice.org, they will be making Calc spreadsheets with Calc formulas=
, =

not Excel spreadsheets with Excel formulas. This situation won't happen =
=

(except for possibly temporarily during the migration).


3. EXCEL'S USE OF THE MIN FUNCTION IS SUPERIOR
 

I appreciate the IMHO, and understand everyone's preferences are differe=
nt.

I don't have a strong preference here, as long as I know how the functio=
n =

will work.

But I did do a quick search in Google, and found quite a few faq's and =

tutorials explaining how to get around the way Excel does MIN. It seems =
=

that a lot of people get a minimum value of 0 when they weren't expectin=
g =

it. A blank cell somewhere was mucking up their expectation of the resul=
ts.

But everyone's different.


Thanks for your honest email, Brian. I think you're main point was numbe=
r =

1, and I think it's fairly valid.

Does anyone have suggestions of a helpful way forward?

Adrian




-- =

Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Feature Idea!

Posted: 18 May 2006 01:43 AM PDT

On Thu May 18 2006 01:54, + Rosana Mayer-Conroy wrote: 

What happens if you want to insert a "/" character in your text ?
Anyway it is already there by using Ctrl + F.

Also you can configure all of your keys to functions in "Tools" -> "Configure
-> Keyboard.

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Surprised this hasn't been on here already but....

Posted: 17 May 2006 11:38 AM PDT

Chad Smith wrote: 
 

http://en.wikipedia.org/wiki/Vaporware - that is, until a release date
is announced.
and the specific license is important, even if it is an Open Source
license, it is not necessarily compatible with the license used by OOo.
 

I had read the article at least one day before you posted the link

--
nicu
my OpenOffice.org pages: http://ooo.nicubunu.ro
Open Clip Art Library: http://www.openclipart.org
my cool Fedora wallpapers: http://fedora.nicubunu.ro/wallpapers/

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Surprised this hasn't been on here already but.... SUN HAS OPEN SOURCED JAVA

Posted: 17 May 2006 09:38 AM PDT

------=_Part_42448_10086614.1147976840063
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 5/18/06, Nicu Buculei <ro> wrote: 

Here's the direct quote from the article that I linked to in my original
email:

Sun Microsystems Inc. will make its Java software available on an 

When a company announces that they will make something open source - they
have, in effect, made it open source. So both terms are correct.

More quotes:

"We want to grow our revenue as much as possible, and that starts with 

ill 
So, if you had simply read the article, (which is why I bothered to link to
it), you would have been able to save your time and mine waiting for an
answer.

--=20
- Chad Smith
http://www.gimpshop.net/
http://www.whatisopenoffice.org/
http://www.chadwsmith.com/
Got an Intel Mac Mini? Want one?
http://minimacs.freepay.com/?r=3D29227644

------=_Part_42448_10086614.1147976840063--

[discuss] Improving Impress

Posted: 16 May 2006 01:08 PM PDT

Here is a question related to this: there are many sites online that offer
templates and clipart for OpenOffice.org. Rather than including clipart and
template and such that bloat the installer file size, why not create a place
at the www.openoffice.org website that contains these, that users can upload
content to?

I hate to use Microcrap as an example again, but they have a similar service
at http://dgl.microsoft.com that contains clipart, templates, borders, sound
clips, pictures, etc. Could such a service be created at www.openoffice.org
for the OpenOffice.org suite, but also include the ability to have users
upload content? Maybe allow downloads to anyone, but uploaders must create
an account to upload, for tracking info and such?

This would provide a central location for such material, instead of having
to search it out from the myriad of sites that offer portions of such a
service.

Thoughts, comments and ideas?


Sincerely,
Andrew Robertson
derma e(r) Natural Bodycare
Export Manager
Ph. 805-582-2710 xt. 244
Fx. 805-582-2730
net
www.dermae.net

-----Original Message-----
From: Alexandro [mailto:com]
Sent: Tuesday, May 16, 2006 3:52 PM
To: org
Subject: Re: [discuss] Improving Impress

Yes this has been brought before, a big difference is that StarOffice is
distribute on a CD so the inclusion of ClipArt don't really hit the file
size or bandwith.

On 5/16/06, Paul William Brown <com> wrote: 


--
Alexandro Colorado


---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] RFE

Posted: 16 May 2006 01:17 AM PDT

On Mon May 15 2006 17:25, + Mats Broberg wrote: 

Hi Mats,
Yes we would. You probably also want to subscribe to this mailing list to see
replies. You can subscribe to this list by sending an email to
org and reply to the confirmation request email.

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Installing British Language Module

Posted: 16 May 2006 01:14 AM PDT

On Tue May 16 2006 03:39, + Chris Hill wrote: 

It is available thru "File" -> "Wizard" -> "Install Dictionary".

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Word Templates in OO

Posted: 14 May 2006 09:28 AM PDT

Alexandro wrote:
 

Fortunately you are wrong. :-)
The wizard has a checkbox on its second page where you can select if you
want to convert documents, templates or both.

Best regards,
Mathias

--
Mathias Bauer - OpenOffice.org Application Framework Project Lead
Please reply to the list only, de is a spam sink.

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] File association

Posted: 13 May 2006 07:59 PM PDT

Am Sonntag, 14. Mai 2006 15:00 schrieb DPH: 

On the www.openoffice.org site > support, then the third link on the left.

Guido
 

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Question on the Futur of "portable openOffice"

Posted: 13 May 2006 07:59 PM PDT

------=_Part_44231_29990424.1147826982106
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Best way is to ask the developer of portable openoffice.org --- John Haller=
,
also remember that 2.0 version is bigger than the original P-OOo
http://portableapps.com/apps/office/suites/portable_openoffice

you can contribute to the project so you can get ur language developed.

On 5/14/06, KAMI <com> wrote: 

le 
t! 


--=20
Alexandro Colorado

------=_Part_44231_29990424.1147826982106--

[discuss] OpenOffice Writer: Latin text rendered in Asian font

Posted: 12 May 2006 03:26 PM PDT

Thanks. But what you typed as "?? " should actually be two spaces
in a row.

CPHennessy 提到:
 

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Memory usage and characters

Posted: 11 May 2006 10:55 AM PDT

On Thu May 11 2006 11:17, + Henk Ursinus wrote: 

As you are not subscribed you may not have seen that:
On Sun May 14 2006 20:15, Mathias Bauer wrote: 

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Annoying bug: suggestion

Posted: 11 May 2006 10:55 AM PDT

On Thu May 11 2006 14:37, + Nicolas Therrien wrote: 

Hi Nicolas
As you are not subscribed you may not have seen that:
On Fri May 12 2006 01:47, Richard wrote: 

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Possible OO component to do Publisher functions

Posted: 10 May 2006 10:34 AM PDT

On Wed, 2006-05-10 at 07:58 -0500, Donald E Cochron wrote: 

Not as far as I know.

However, the "Draw" component of OOo (OpenOffice.org) can be used for
simple desktop publishing. If you need something more advanced than
publisher, then install "Scribus" from http://www.scribus.net

If you only use Outlook for email & calendar, then Mozilla Thunderbird
and Calendar http://www.mozilla.com/thunderbird might meet your needs.

Hope this helps.

Dave

Please reply to org only.


---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] MacIntel User

Posted: 05 May 2006 01:38 AM PDT

On Fri May 5 2006 01:29, + William Charlton wrote: 

Read the doc at :
http://eric.bachard.free.fr/mac/HowTo2.0/Howto_OOo_2.0_MacOSX_english.pdf

And download OpenOffice.org from :
ftp://ooopackages.good-day.net/pub/OpenOffice.org/MacOSX/2.0.2rc4

Please reply to org only.

Normally org is the best list to ask questions about using
OpenOffice.org

--
CPH : OpenOffice.org contributor

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Visual Basic in OpenOffice.Calc

Posted: 04 May 2006 10:41 AM PDT

Thanks!


----- Original Message -----
From: "CPHennessy" <org>
To: <org>; "Vitaliy V. Dubil'"
<com.ua>
Sent: Thursday, May 18, 2006 8:31 PM
Subject: Re: [discuss] Visual Basic in OpenOffice.Calc

 
in 
are 
are 
using 

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

Microsoft Word - office starter was not working due to 'click2run' i uninstalled office starter tried downloading standard trial and it can start on that either what do i do?

Microsoft Word - office starter was not working due to 'click2run' i uninstalled office starter tried downloading standard trial and it can start on that either what do i do?


office starter was not working due to 'click2run' i uninstalled office starter tried downloading standard trial and it can start on that either what do i do?

Posted: 12 Jan 2013 10:48 AM PST

My office starter was not working because of 'click2run issue' so i uninstalled it tried downloading the trial and says theres a problem starting it. What do i do?? can i get my starter back? Thank you


i have 7 profesional. Using Word I would like to email the artical as a letter. It alwalys comes in another format

Posted: 11 Jan 2013 07:29 PM PST

I have 7  profesiional.  I want to email a letter and have it come as a letter.  not a pdf   

Word Starter 2010

Posted: 11 Jan 2013 04:16 PM PST

I cannot print a document in Word Starter 2010.  It just stays in the print queue & can't be deleted.  Please help. 

No longer able to read or open older Word (.doc) documents using Word 2010.

Posted: 11 Jan 2013 01:08 PM PST

I suspect the problem started after installing Windows updates. 

Word 2010 continues to work normally when using .docx files.  The problem is only with the older, .doc files.  When I try to open older files I am prompted to select the encoding that makes your document readable.  Nothing works.


Error messages since last update

Posted: 11 Jan 2013 01:59 AM PST

Since the most recent batch of automatic updates my wife is having problems with Word. She gets two error messages:

1. When she opens a Word document she gets this "The macro couldn't be found or has been disabled because of your Macro security settings" The documents don't contain macros and she has to click on Close on the message box a couple of times to get rid of it. I have checked that the folder is listed as a Trusted foldee. What is causing this?

2. When she opens a Word document she also gets a secomd blank document which when she closes it she gets A Visual Basic eroor message box that says Automation error. What is causing that?

 

Any help or guidance would be appreciated.

Thanks

Tony

 

Page Numbering using Page X of Y

Posted: 10 Jan 2013 06:53 PM PST

I created a document where I am using Page X of Y in the Footer. There is a separate Cover Page and seperate Table of Contents Page along with the regular text. Each of these separations are in separate sections using Section Breaks. Although I have done this the end count of the page numbers are calculated e.g. Page 1 of 8. I only want the sections with the actual documentation calculated e.g. Page 1 of 6, Page 2 of 6, etc.

 

I try to edit the fields by manually changing the numbers and that worked fine; however, when pages are added, then the count goes to e.g. Page 7 of 6,(because the manually edited ones will not change).

 

Any help in getting this sorted out is greately appreciated.

 

 

Windows 8 Missing ODBC FoxPro Files

Posted: 10 Jan 2013 03:00 PM PST

My Office 2003 and Project 2003 programs ran perfect with Windows XP Pro.  I just bought a new Dell XPS 8500 with Windows 8 Pro.  During installation both programs report the following error:  Error 1919 and ODBC error 6....missing FoxPro files.  I can not find a solution using the MS Knowledge database since none of the relevant articles address Windows 8.

 

Need help in finding a solution.

I'm having problems previewing envelopes created by a mailmerge in Word 2010 using data from Excel 2010.

Posted: 10 Jan 2013 11:51 AM PST

When I used Office 2003, I was able to create envelopes by using the mailmerge feature in Word 2003 and address data from an Excel 2003 worksheet. After the merge was completed, I was able to preview each envelope prior to printing for a final check. Now, after upgrading to Office 2010, I'm no longer able to preview the results of the merge.

My Windows 7 backup was in WPS and now with Windows 8 it's in XLP and I can not read, WHY ??

Posted: 09 Jan 2013 05:19 PM PST

My Windows 7  backup was in WPS and now with Windows 8 it's in XLP which I can not read, WHY ??

When I try typing in word it will only let me type in certain amount of letter and if I try typing in more it will delete them

Posted: 06 Jan 2013 07:13 PM PST

I am using microsoft works word processor but i have had this problem before on word. I tried copy and pasting a document and when i tried to delete a word then rewrite another it would delete letter from the other word in front to make room for it. 

Constant closing problems in Word and Excel 2010.

Posted: 06 Jan 2013 11:56 AM PST

Word 2010 crashes and restarts when closing. it asks to load changes to normal.dotx
Excel won't close and I must go to Windows task manager to end task.

Microsoft Word - Bullet format not consistent

Microsoft Word - Bullet format not consistent


Bullet format not consistent

Posted: 11 Jan 2013 07:44 AM PST

I used the bullet icon on the ribbon to start a bulleted list. Word uses bullets for the first two levels, but then starts using numbers for the third level. How do I fix this?

It looks like this:
  • Level 1 text

o   Level 2 text

1.       Level 3 text – why number and not bullet?


I've been using Word for many years, but some of its features still trip me up.

Thanks.


Removing a document in Word 2003

Posted: 11 Jan 2013 01:29 AM PST

How can I remove an entire document in Word 2003, including the reference to it?  I know how to delete the text or a page, and how to rename the document.  But I can't figure out how to get rid of the whole thing.

Also, I want to know if there is any way to configure Word so that it automatically deletes a document after it has been renamed.  As it stands now, I have two copies of each one, with different names.

I assume there is a way to do the first thing, but there may not be a way to do the second (although there should be).

How do I restrict editing but still allow access to headers and footers?

Posted: 10 Jan 2013 08:10 PM PST

I'm creating a multi-page form using many content controls. Most of the content controls are on the main body of the form. However, some of them are in the document header and footer.

When I restrict editing to filling in forms, the header and footer become unavailable for editing, so my users will not be able to access and edit those content controls.

Is there any way I can restrict editing so that users can only edit the content controls, but still allow access to the header and footer? I can't take the header and footer out and integrate them into the document, because the main body of the document will vary in size. Help! 

Formatting Current Paragraph

Posted: 10 Jan 2013 02:49 PM PST

In Word 2010 VBA, I want to change all of text in the current paragraph from Upper Case to Proper Case.

This should be simple, but I simply can't figure it out.

How is that done?

TIA

Changed cursor in Word 2003

Posted: 10 Jan 2013 10:17 AM PST

I inadvertently changed the cursor in Word 2003 from the usual vertical line to a dot. How do I return to the default vertical line?

Word 2010 - Exclamation Mark On Templates

Posted: 10 Jan 2013 09:30 AM PST

Having recently upgraded from Office 2007 to Office 2010, I have noticed that when I creat a new document from templates, in the template browser, some of the Word templates show a icon with an exclamation mark on a yellow background super imposed on the template icon. 

 

At first I thought that it simply wanted me to save them in the 2010 format, so I opened the templates and re-saved them, however this did not remove the exclamation mark.

 

The templates work normally, I am just curious as to why the exclamation mark is there.

 

Does anyone know what this means?

The "Accept all changes" in the review on the Review board no longer works

Posted: 10 Jan 2013 09:01 AM PST

I'm using MS Word Office 2010 to review text, using the "tracking changes" facility. Recently, when I wanted to accept all the changes in a document, the "Accept all changes" button didn't work and I had to manually accept over 7,000 changes. Any ideas what's happened and how I can remedy it? Many thanks - Petra

Word 2007: Repeating outline "Heading 1" when that topic spans multiple pages

Posted: 08 Jan 2013 01:19 PM PST

Hello - In Word 2007, I have a document with outline headings for which I have used the "Heading 1" and "Heading 2" styles, and using a Table of Contents field at the beginning. Most level-1 sections are very short (it's basically a detailed glossary) though some have more details. What I want to happen is, when a page break occurs within a level-1 topic, the level-1 heading to be repeated on the next page, ideally with something like "(Continued)" appended. Like so:

 

Topic 1

Subtopic 1A

Subtopic 2B

Topic 2

Subtopic 2A

<page break>

Topic 2 (continued)

Subtopic 2B

Subtopic 2C

Topic 3

...

 

To be clear - these are not table headers, nor are they page headers.  Also, I would prefer that the repeated headers due to the page breaks not appear in the TOC.  This can't be an unusual need, but I can't see any way to modify the Heading 1 style to make this happen.

 

Thanks for any advice you can give!

 

B. Meyer

Microsoft Office to Microsoft Word

Posted: 05 Jan 2013 06:27 PM PST

need help! i accidently opened a set of documents with Microsoft office which should have been open with Microsoftword now non of my documents will  convert back to word!

how can I make spell check work in Word 2010

Posted: 05 Jan 2013 04:48 PM PST

Since "upgrading" from Office 2003 to Office 2010, I find that my spell checker is not recognizing or marking misspelled words. I have tried all the suggested "fixes" offered by the 'official support page' (like File/Options/Proofing/ and checking or unchecking the appropriate boxes under "Change How Word Corrects and Formats Your Text.
Is there an actual fix for this problem? if not, I'm headed back to Office 2003, which actually works!
(The other problem I'm having is that when I try to save a document to somewhere other than "My Documents', I'm told I can't save it there because I don't have permssion". Does anyone has a fix for that one?
So far, Office 2010 is another example of how Windows/Microsoft simply does not check their software before putting it on the market and certainly doesn't respond to "why won't this work" questions.

In Word 2010 can I detach quick access tool bar of permanently view multiple rows of the bar at same time.

Posted: 05 Jan 2013 01:58 PM PST

I hate the ribbon and would like to use only the QA toolbar, which has too many icons to be viewed in 1 row.

i cannot open word 2010

Posted: 05 Jan 2013 06:02 AM PST

I can open all my other microsoft office programs but not word. When i click on word i get a pop up  message  saying save changes to computer- it doesn't matter if i  click yes or no as nothing happens. When looking at the properties for Word it says there is an incompatibility issue. Also my laptop is windows 7 and the properties of the file say Windows XP (service pack 3)

 

Please help i need to use word for my college work.

 

Thank you

Can I export a report Microsoft Project

Can I export a report Microsoft Project


Can I export a report

Posted: 06 May 2004 07:09 AM PDT

Hi Danielle,

Also, some of the reports are also available in the "Save As... ->Excel"
feature. If the one you want is not available, use the "New Map" feature
and model something that is very similar to the report you want.

-Bill

--
Bill Raymond
Microsoft Project MVP
projectnation at hotmail dot com


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


Fiscal Calendar

Posted: 05 May 2004 04:40 PM PDT

Chris --

I'm sorry but I don't understand what you are trying to do with reporting
and fiscal year. Maybe I'm just dense this morning or something. Please
give me an example and then perhaps we can help you.

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


<microsoft.com> wrote in message
news:93f501c43363$37fa5cb0$gbl... 


EVM

Posted: 05 May 2004 12:10 PM PDT

You can dispay all the earned value measure from the menu - View, Tables,
MoreTables and select any of the several earned value tables available.
Don't forget to set the status date in the project information window first.

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

"Chris" <microsoft.com> wrote in message
news:8bc701c432d4$a1926d00$gbl... 


progress during non-working times

Posted: 05 May 2004 11:51 AM PDT

Gerard's answer gave one approach. Another that I favour is to show the
Saturday work as 10 hours of Actual Overtime Work on the date it was done,
entered using the Resource Usage view. I think the calendar should show the
scheduled work time of the resource only and work performed outside of those
times is posted as overtime work, regardless of whether the resource is
actually entitled to premium OT pay or not. In line with that, to get the
costs to come out right I recommend that people who do not get premium pay
have their overtime rate entered using the same value as their regular rate
so those Saturday hours don't show up as freebies in the budget (some users
and most courseware say to set the OT rate to zero for managers and
professionals who don't actually get extra overtime pay but I don't think
that approach gives an accurate estimate of the true costs.) He's gonna get
paid for 'em, whether directly or indirectly, by taking a little "mental
health comp time" off when his schedule allows.

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

"Rocky" <microsoft.com> wrote in message
news:0c5401c432d1$f40b4730$gbl... 


Work Days vs. Calendar Days

Posted: 05 May 2004 09:39 AM PDT

OOps - forgot to add 1 day in the formula previously (what can I say, it's
late!)

DateDiff("d",[Start],[Finish]) +1

Without the 1 it gives Mon thru Fri as 4 days, not 5.

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


"Sarah M-H" <microsoft.com> wrote in message
news:8cc401c432bf$800e4e20$gbl... 


Project 2003, Open a project, display is blank

Posted: 05 May 2004 07:50 AM PDT

Thanks for your reply but someone else in the office had
the fix. I had to:

Remove the shared sites gbui://blank.htm, and
gbui://mainpage.htm.
Then download and run this fix to the registry, not sure
where they got this, Project 2003 gbui error fix.reg

Again, thanks,
Rick

 
Collaborate - 
in PWA? 
message 
blank. 
to 

first pass risk

Posted: 05 May 2004 07:07 AM PDT

And I yours.
Mark
So how does one become an MVP anyway?

--
__________________________________________________ _______
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
__________________________________________________ ______

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones
"Dale Howard [MVP]" <dale(dot)howard(at)msprojectexperts(dot)com> wrote in
message news:%phx.gbl... 
in 


Project and Outlook

Posted: 05 May 2004 06:38 AM PDT

I'm sorry to ask this but what is PWA?

Mark

--
__________________________________________________ _______
Mark Durrenberger, PMP
Principal, Oak Associates, Inc, www.oakinc.com
"Advancing the Theory and Practice of Project Management"
__________________________________________________ ______

The nicest thing about NOT planning is that failure
comes as a complete surprise and is not preceded by
a period of worry and depression.

- Sir John Harvey-Jones
"Sean" <com> wrote in message
news:com... 
Outlook tasks. However, if using the Outlook calendar is acceptable to your
client, then you can import tasks quite easily. From PWA, download the
Outlook add-in. It's a simple install. Then use the "Import New
Assignments" button on the PWA toolbar from Outlook. I suggest you change
the import timeframe from internet options, PWA tab. Don't use the PWA
range; use a more narrow range. 


Licensing Issue

Posted: 04 May 2004 04:54 PM PDT

You have a couple of options. You do need a license for every copy of
Project installed and I may be wrong but I don't think there is a way to
install a single copy on a central shared server and open it from different
workstations (probably would violate the EULA in any case). Like Office,
you will need a license for each workstation. As you describe it, if you go
with Project Standard you'll need at least 25 copies of Project, 25
licenses, since there is no way to open and view project files without it.
Another route would be 5 licenses and send or post reports and views saved
as PDF file "electronic hard-copy" to the people who only need view access.
OR, you could go with 5 copies of Project Professional (Standard doesn't
talk to Server- that's the basic difference between the two versions) for
the PM's actually modifying the project plans, Project Server as the
distribution medium (remember it also requires Windows Server, IIS, SQL
Server, etc) and Project Web Access with enough CALs for the other 20 who
need to view the plans.

Hope this helps

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



"Elizabeth" <com> wrote in message
news:854f01c43233$17acd4a0$gbl... 


hourly billed resources

Posted: 04 May 2004 04:26 PM PDT

Very good advice, and I thank you

I plan on using Project in the way you indicate - to prepare the initial budget, but in terms of tracking actual time, we have a separate application that individuals will enter their time in, and at the end of the project, we'll only bill what is agreed initially. (unless it goes out of scope of course)


----- Steve House wrote: ----

The resource assignment percentage is essentially the amount of time ove
the duration of the task that the resource actually works on it, expresse
as a percentage. If the task duration is 16 hours (2 days) and the resourc
devotes 4 man-hours of work to it over that time period, his assignmen
percentage is 4/16 or 25%. There are a variety of ways you can enter that
either mentally calculate the percentage and assign at that level or spli
the screen and specify duration and work and let Project calculate th
percentage

FYI - IMHO it is an extremely bad idea to use your billing fees as the rate
for the resources. MS Project tracks your internal costs - labour
materials, etc - to create the project deliverables, not the revenues i
might generate (if any), and the budget developed in MSP will reflect thos
internal costs to do the project's work. Consider the situation where wor
is done that is necessary to complete the project. work you have to pa
people to do, but for some reason is not billable to the client. You stil
need to account for those costs in the project budget and actuals an
Project can do this but it cannot distinguish those costs from billabl
costs. Add your overhead, profit requirements, etc, to that estimate t
come up with your bid to the client but track billable working time, bille
rates, and revenues in a separate, purpose-built, time-and-billin
accounting application. You can import and export data from Project to lin
the two but use each tool for the job it's best at



"Shane" <microsoft.com> wrote in messag
news:com.. 
need 
the effort in terms of hours so we can develop a budget based on our hourl
fees. For example, we know a task could take 4 hours to do, but because w
have to work on other client work at the same time, the task won't b
complete for 2 calendar days 



Restricting resource assignments based on max availability

Posted: 04 May 2004 12:51 PM PDT

Thanks very much Jan

 
follows: 
you assign the 
Resource Names or by 
Information) so don't 
I would go to 
and you will see 
bericht 
textbooks. I 
project. 
and 
to 

leveling?

Posted: 04 May 2004 07:26 AM PDT

Just guessing because you haven't mentioned the durations of the various
tasks but if as I suspect each overallocation occurs for less than full day
time period, leveling day-by-day will ignore it. That's what that setting
is - the smallest time increment that you want Project's the leveling engine
to worry about. If your recurring task is a staff meeting every Friday from
9 til 10, for example, and your regular task is widget waxing, schedules for
8 hours 8-5 and it happens to fall on Friday as well, leveling day-by-day
will not resolve the overallocation because the "problem time" is only 1
hour in length, less than a full day. Leveling hour-by-hour will do it and
if the meeting is a higher priority it will sit pat and the widgets task
schedule will change. If leveling can split tasks is on, the resource will
be shown working on the widgets 8 to 9, going to the meeting from 9 til 10,
and then going back to the widgets task for the rest of the day plus one
hour on Monday (still have to do a total of 8 hours of work on the widgets,
regardless, and leveling will never change the assignment percentage or the
total hours required for the task, controlling only when those hours occur).
If tasks can split is off, leveling hour-by-hour will cause the widgets
task to shift forward intact *2* hours, leaving the resource idle from 8 til
9, at the meeting from 9 til 10, then working on the widgets the rest of the
day plus 2 hours on Monday.

Hope this helps.

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


"Ben" <microsoft.com> wrote in message
news:832e01c431ec$f56d7250$gbl... 


Updating an inserted project

Posted: 04 May 2004 06:34 AM PDT

Hi Diane,

Font Colors are a part of a View
Views are saved in the file they are generated in (in this case the master)
If you want to apply this view to other (inserted) projects you have to open
both and copy the view though the organizer.

Sorry, but that's how it is.
Think of this: a project can be inserted in many masters, who each may have
their formatting..

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"Diane" <microsoft.com> schreef in bericht
news:8cbf01c432b2$728f54e0$gbl... 


Duration is in Decimals

Posted: 03 May 2004 12:31 PM PDT

Hi Christopher ,

Welcome to this Microsoft Project newsgroup :-)

You might like to see FAQ Item: 5. Default Working Hours

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

Christopher Oldcorn wrote: 


reinstallation of Office:mac v.X Microsoft Office for Mac

reinstallation of Office:mac v.X Microsoft Office for Mac


reinstallation of Office:mac v.X

Posted: 22 Mar 2007 02:42 PM PDT

On 3/22/07 5:42 PM, in article
googlegroups.com, "net"
<net> wrote:
 
In addition to all the other comments, look carefully at the key, and make
sure you don't enter eight instead of B, 6 instead of b, etc. and vice
versa

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Need Replacement Disk: Office v. X

Posted: 21 Mar 2007 12:46 PM PDT

In article <googlegroups.com>,
com wrote:
 

MS won't help you here.
Have you tried carefully cleaning the disk (with a disk cleaning spray)
and then see if you can make a copy of it? If it copies without
erroring, you should be able to use the disk. I've salvaged more than a
few disks this way.

--
To reply by email, remove the word "space"

New to MAC

Posted: 20 Mar 2007 11:53 AM PDT

In article <microsoft.com>,
JE McGimpsey <org> wrote:
 

I meant "misunderstood". Thanks for the insight. I've only maintained my
own Mac networks, so I've only had to familiarize myself with the tech
terminology on a "need to know" basis. You catch my drift, though.

--
To reply by email, remove the word "space"

Beta testing for Microsoft Office 2008 for Mac

Posted: 19 Mar 2007 03:52 PM PDT

In article <microsoft.com>,
JE McGimpsey <org> wrote:
 
That explains a lot. <g>

--
To reply by email, remove the word "space"

licensing officex for mac

Posted: 19 Mar 2007 02:34 PM PDT

I have followed the directions given. Thank you
I get the "too many user message" after I open the programs to
reestablish the preference
and I put my program code in.
Any ideas?

On Mar 19, 5:08 pm, CyberTaz <cast.net> wrote: 


Open Type font cross-platform compatibility

Posted: 19 Mar 2007 03:05 AM PDT

Thanks, Priyanka. I can try to get this info, or I can send you the
one of the fonts privately.

Paul

On Mar 20, 8:49 pm, "Priyanka Singhal" <com> wrote:
I would be especially interested to know if your font 



Purchased the wrong thing

Posted: 18 Mar 2007 11:39 PM PDT

Office 98, Office 2001, and Office X will all qualify. You don't need
to install the older program--just use the drag and drop installer and
when it asks you to point at a qualifying version, insert the old CD
into the disk drive and point there.

But an exchange would simplify your life overall.

CyberTaz wrote: 

Troubleshooting Update article: HOW INSTALLING APPLE'S UPDATESCAN RENDER YOUR MAC UNBOOTABLE AND HOW YOU CAN PREVENT IT

Posted: 18 Mar 2007 03:43 PM PDT

On 3/18/07 8:25 PM, in article phx.gbl, "Daiya
Mitchell" <org.INVALID> wrote:
 

Do you have cats?

--
Diane Ross, Microsoft Mac MVP
Entourage Help Page
<http://www.entourage.mvps.org/>
One of the top five MS Entourage resources listed on the Entourage Blog.
<http://blogs.msdn.com/entourage/>


Microsoft Office v. X for Mac 10.1.9 Update

Posted: 18 Mar 2007 02:50 AM PDT

On 3/18/07 2:50 AM, in article
googlegroups.com, "com"
<com> wrote:
 
If Comcast is the ISP provider they are having a problem with the DNS
servers. The fix is to go to the TCP/IP and enter 68.87.64.196 then on the
next line type 68.87.66.196. Click apply and go back to the Microsoft
Macoptia download page and get the update.

--
Diane Ross, Microsoft Mac MVP
Entourage Help Page
<http://www.entourage.mvps.org/>
One of the top five MS Entourage resources listed on the Entourage Blog.
<http://blogs.msdn.com/entourage/>


Still a problem- loss of Office print dialog window

Posted: 15 Mar 2007 05:55 PM PDT

Hi,

Does the freshly imaged iMac have a copy of Office 2004 on it as well as the
older Macs?

-Jim Gordon
Mac MVP




Quoting from "com" <com>, in article
googlegroups.com, on [DATE:
 

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

licensing questions

Posted: 13 Mar 2007 10:44 AM PDT

In article <googlegroups.com>,
com wrote:
 

Good luck!

--
To reply by email, remove the word "space"

updates - can't find software message

Posted: 12 Mar 2007 12:04 PM PDT

Which version of Microsoft Office are you actually using? In any of the
Office applications, click on the name of the application in the menu bar,
then choose "About [application]". Which version number do you see, 10.x.x
or 11.x.x?


On 12/3/07 21:07, in article
googlegroups.com, "net"
<net> wrote:
 

--
Michel Bintener
Microsoft MVP
Office:Mac (Entourage & Word)

***Always reply to the newsgroup.***

Word unexpectedly quits when saving

Posted: 12 Mar 2007 11:21 AM PDT

Thank you very much for the response. I'll give it a try! My luck with
this computer has been really bad, so hopefully this will work!

Office 11.4.3 update breaks entourage

Posted: 11 Mar 2007 05:00 PM PDT

.... Repairing disk permissions can't hurt either :)

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 3/11/07 8:55 PM, in article C219F31E.64D79%name, "John McGhie
[MVP - Word and Word Macintosh]" <name> wrote: