X-posted to .excel.programming, .misc, .charting, .worksheet.functions

These Excel groups, indeed all the "microsoft.public" groups are available
via the Communities web interface, "WebNews"

http://www.microsoft.com/communities...s/default.aspx

- and via NTTP newsreaders, eg Outlook Express, Windows Mail, Firefox. Most
of the numerous web mirrors, eg Google-groups, can be considered as NTTP.
(In passing, some of the mirrors tend to give a misleading impression they
host these groups themselves.)

Currently, possibly since 13-Oct, most if not all NTTP posts are not being
made visible to WebNews. So anyone posting on WebNews probably will not see
replies from NTTP posters.

NTTP posters seem to be able to see WebNews posts.

A clue as to how the post was sent is to look at the headers, if you see the
following it's probably WebNews and the poster may not see your reply.
X-Newsreader: Microsoft CDO for Windows 2000

Regards,
Peter T (MVP)

This seems to happen about once a month.

--
Biff
Microsoft Excel MVP


"Peter T" <peter_t@discussions wrote in message
...
X-posted to .excel.programming, .misc, .charting, .worksheet.functions

These Excel groups, indeed all the "microsoft.public" groups are available
via the Communities web interface, "WebNews"

http://www.microsoft.com/communities...s/default.aspx

- and via NTTP newsreaders, eg Outlook Express, Windows Mail, Firefox.
Most of the numerous web mirrors, eg Google-groups, can be considered as
NTTP. (In passing, some of the mirrors tend to give a misleading
impression they host these groups themselves.)

Currently, possibly since 13-Oct, most if not all NTTP posts are not being
made visible to WebNews. So anyone posting on WebNews probably will not
see replies from NTTP posters.

NTTP posters seem to be able to see WebNews posts.

A clue as to how the post was sent is to look at the headers, if you see
the following it's probably WebNews and the poster may not see your reply.
X-Newsreader: Microsoft CDO for Windows 2000

Regards,
Peter T (MVP)

"T. Valko" wrote in message:

This seems to happen about once a month.

and it lasts a week each time?

Regards,
Peter T

The duration varies from hours to several days. A week is unusual.

I noticed the problem just about when you noted it and posted this general
heads up message:

http://groups.google.com/group/micro...9e17260?hl=en#

--
Biff
Microsoft Excel MVP


"Peter T" <peter_t@discussions wrote in message
...

"T. Valko" wrote in message:

This seems to happen about once a month.

and it lasts a week each time?

Regards,
Peter T

On Oct 20, 2:32*am, "T. Valko" wrote:
The duration varies from hours to several days. A week is unusual.

I noticed the problem just about when you noted it and posted this general
heads up message:

http://groups.google.com/group/micro...isc/browse_thr...

--
Biff
Microsoft Excel MVP

"Peter T" <peter_t@discussions wrote in message

...





"T. Valko" *wrote in message:

This seems to happen about once a month.

and it lasts a week each time?

Regards,
Peter T- Hide quoted text -

- Show quoted text -

So what about the innocent question I posted (successfully I was told)
in the name of Weatherman on Sunday, concerning arbitrary X axes used
by Excel when I mix column and scatter on the same chart? Does this
mean it may have been answered somewhere and I can't see it?

Confused!

Weatherman

"Weatherman" wrote in message
news:dc181316-65e8-480c-860b-
"
So what about the innocent question I posted (successfully I was told)
in the name of Weatherman on Sunday, concerning arbitrary X axes used
by Excel when I mix column and scatter on the same chart? Does this
mean it may have been answered somewhere and I can't see it?

Confused!

Weatherman
"

I can't see any new threads from "Weatherman" on 19-Oct to any of the 4
groups I cross posted this to. Looks like you posted this through
google-groups which is effectively NTTP. If you had posted similarly it
should have got through and you should have been able to see all replies.

Which excel group did you post to, what sender name, and what was the
subject line. Also how did you post (eg via google-groups).

People posting through Webnews (see link in my OP) will probably not have
seen replies sent via NTTP. That's irritating both for them (not that
they'll know) and for those who have taken the trouble to reply.

Recently it seems that old NTTP are starting to trickle through to WebNews.
At least some have arrived but many still missing.

Regards,
Peter T

But Sunday was 18th, not 19th, though I still can't spot anything obvious.

And by NTTP, I assume you mean NNTP?
--
David Biddulph

"Peter T" <peter_t@discussions wrote in message
...
"Weatherman" wrote in message
news:dc181316-65e8-480c-860b-
"
So what about the innocent question I posted (successfully I was told)
in the name of Weatherman on Sunday, concerning arbitrary X axes used
by Excel when I mix column and scatter on the same chart? Does this
mean it may have been answered somewhere and I can't see it?

Confused!

Weatherman
"

I can't see any new threads from "Weatherman" on 19-Oct to any of the 4
groups I cross posted this to. Looks like you posted this through
google-groups which is effectively NTTP. If you had posted similarly it
should have got through and you should have been able to see all replies.

Which excel group did you post to, what sender name, and what was the
subject line. Also how did you post (eg via google-groups).

People posting through Webnews (see link in my OP) will probably not have
seen replies sent via NTTP. That's irritating both for them (not that
they'll know) and for those who have taken the trouble to reply.

Recently it seems that old NTTP are starting to trickle through to
WebNews. At least some have arrived but many still missing.

Regards,
Peter T

What is the best way (or ways) to read and post to this newsgroup?

I ordinarily use groups.google.com/group/
microsoft.public.excel.programming,
but it seems to have its problems, too.

How does one use Firefox?

Brian

Hi David,

Right on both counts, clearly you've got a much better eye for detail than
me <g

Regards,
Peter T

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
But Sunday was 18th, not 19th, though I still can't spot anything obvious.

And by NTTP, I assume you mean NNTP?
--
David Biddulph

"Peter T" <peter_t@discussions wrote in message
...
"Weatherman" wrote in message
news:dc181316-65e8-480c-860b-
"
So what about the innocent question I posted (successfully I was told)
in the name of Weatherman on Sunday, concerning arbitrary X axes used
by Excel when I mix column and scatter on the same chart? Does this
mean it may have been answered somewhere and I can't see it?

Confused!

Weatherman
"

I can't see any new threads from "Weatherman" on 19-Oct to any of the 4
groups I cross posted this to. Looks like you posted this through
google-groups which is effectively NTTP. If you had posted similarly it
should have got through and you should have been able to see all replies.

Which excel group did you post to, what sender name, and what was the
subject line. Also how did you post (eg via google-groups).

People posting through Webnews (see link in my OP) will probably not have
seen replies sent via NTTP. That's irritating both for them (not that
they'll know) and for those who have taken the trouble to reply.

Recently it seems that old NTTP are starting to trickle through to
WebNews. At least some have arrived but many still missing.

Regards,
Peter T

Brian -

In the past I have used Outlook Express on Windows XP.

Now I use its replacement, Windows Mail on Windows Vista.

I can't recall ever having any problems with either one.

- Mike
http://www.MikeMiddleton.com


"Brian Murphy" wrote in message
...
What is the best way (or ways) to read and post to this newsgroup?

I ordinarily use groups.google.com/group/
microsoft.public.excel.programming,
but it seems to have its problems, too.

How does one use Firefox?

Brian

Actually Brian it was you that alerted me to this ng problem when you
pointed out a few days ago nothing from an entire thread had appeared in
WebNews.

I thought google groups was working OK but looks like Weatherman's post
didn't make it. However *searching* google groups hasn't worked correctly
for most of this year.

I hesitate to recommend a "best way". I use mainly Outlook Express in WinXP
and occasionally Windows Mail in Vista. I don't have Firefox but assume
you'd set up a news account in pretty much the same way -

Tools, Accounts, Add, News....
This sets up a new "account", in particular need to add as Server -
"msnews.microsoft.com" without quotes

complete other fields as required, display name, address (eg
" or if happy your full address (I include mine
disguised in the reply-to field).

After adding the account you should see "msnews.microsoft.com" as a folder,
select that, then find and subscribe to your favourite groups.

Regards,
Peter T


"Brian Murphy" wrote in message
...
What is the best way (or ways) to read and post to this newsgroup?

I ordinarily use groups.google.com/group/
microsoft.public.excel.programming,
but it seems to have its problems, too.

How does one use Firefox?

Brian

Firefox is not a newsreader, it's a web browser. You could use it to access
Google, just as you can use any other web browser.
The news reader from the mozilla stable is Thunderbird.

Many of us use Outlook Express, but it's a matter of preference.
--
David Biddulph

"Brian Murphy" wrote in message
...
What is the best way (or ways) to read and post to this newsgroup?

I ordinarily use groups.google.com/group/
microsoft.public.excel.programming,
but it seems to have its problems, too.

How does one use Firefox?

Brian

"David Biddulph" wrote in message news:4addcf55

Firefox is not a newsreader, it's a web browser. The news reader from the
mozilla stable is Thunderbird.

Pointing out my misinformation yet again!

Regards,
Peter T

It's always asking Google such questions, but (as always) treat the answer
with caution depending on the source.
--
David Biddulph

"Peter T" <peter_t@discussions wrote in message
...
"David Biddulph" wrote in message news:4addcf55

Firefox is not a newsreader, it's a web browser. The news reader from
the mozilla stable is Thunderbird.

Pointing out my misinformation yet again!

Regards,
Peter T

I use Thunderbird, a dedicated mail/news (NNTP) client. I don't use it
at all for mail, but it beats OE/WM and any of the web interfaces.
Especially the Microsoft web interface, which has always been a joke.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



David Biddulph wrote:
Firefox is not a newsreader, it's a web browser. You could use it to access
Google, just as you can use any other web browser.
The news reader from the mozilla stable is Thunderbird.

Many of us use Outlook Express, but it's a matter of preference.

Any chance anyone can help me with this question.
I dont want to double post and I am not getting any reposnse

Ok I Have a bonus stucture,
It goes on (12) 4 week cycles and and sales have to increase over the period
to hit
loest level of bonus.
Ok to make it real easy, lets so
Cola colb colc cold cole
colf colg
Period / low produciton / bonus /mid produciton /bonus /High production / b
1 100 $10 bonus, 100 <5000 $20 bonus 1000
$30 b
2 200
3


and lets say that sheet 2 A1= the period # and b2= the sales $
Pelase advsie


Hi, try this,
=IF(Sheet2!$B$2Sheet1!B2,IF(Sheet2!$B$2<Sheet1!D2 ,Sheet1!C2,IF(Sheet2!$B$2<Sheet1!F2,Sheet1!E2,Shee t1!G2)),"Lowest Level not Achieved")

Also make sure in your columns "Low", "Mid" and "High" that you put the
upper limit of that category's sales requirement e.g.

LOW MID HIGH
100 500 1000

If this helps please click "Yes"
<<<<<<<<<<<

" wrote:




so close,
But that two varible on sheet two;
A1 the periof of the bonus
b2 the amount on $ need to achieve the bonus.

this function works great for period 1, but there are 12 peiod.
morover a1 has text 1st, 2nd, 3rd and on...

The tbl arrey Sheet
col a; the period
col b, the lowest bonus scale
col c, the bonus amount

col d, the middle bonus scale
col e, the bonus amount
col f, the highest bonus scale
col g, the bonus amount

The tble woudl look like this
1st $3250 b$500 $4500 b$1000 $7500 b$2000
2nd$5000 b$500 $7000 b$1000 $10000 b$2000
3rd $600 b$500 $8000 b$1000 $14000 b$ 2000
and on

"BSc Chem Eng Rick" wrote:


"Gary''s Student" wrote:




"T. Valko" wrote:

This seems to happen about once a month.

--
Biff
Microsoft Excel MVP


"Peter T" <peter_t@discussions wrote in message
...
X-posted to .excel.programming, .misc, .charting, .worksheet.functions

These Excel groups, indeed all the "microsoft.public" groups are available
via the Communities web interface, "WebNews"

http://www.microsoft.com/communities...s/default.aspx

- and via NTTP newsreaders, eg Outlook Express, Windows Mail, Firefox.
Most of the numerous web mirrors, eg Google-groups, can be considered as
NTTP. (In passing, some of the mirrors tend to give a misleading
impression they host these groups themselves.)

Currently, possibly since 13-Oct, most if not all NTTP posts are not being
made visible to WebNews. So anyone posting on WebNews probably will not
see replies from NTTP posters.

NTTP posters seem to be able to see WebNews posts.

A clue as to how the post was sent is to look at the headers, if you see
the following it's probably WebNews and the poster may not see your reply.
X-Newsreader: Microsoft CDO for Windows 2000

Regards,
Peter T (MVP)




.

A long time ago I used OE. For at least the past several years I've
been using Google's front end. But the search problems over the past
several months have me looking for something that works. Searching
the group archives with confidence is a top priority for me.

It used to be OE would only "search" what you had downloaded locally,
that led to my using Google.

I guess I should give OE on XP another look, since that is what I use
for email.

What does Thunderbird do when searching? Does it search on a server
somewhere?

Brian

Brian -

As far as I know, T-bird also only searches what's been downloaded.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Brian Murphy wrote:
A long time ago I used OE. For at least the past several years I've
been using Google's front end. But the search problems over the past
several months have me looking for something that works. Searching
the group archives with confidence is a top priority for me.

It used to be OE would only "search" what you had downloaded locally,
that led to my using Google.

I guess I should give OE on XP another look, since that is what I use
for email.

What does Thunderbird do when searching? Does it search on a server
somewhere?

Brian

David,

I am sending this post using OE's newsreader, which I just now setup.

When you want to do a thorough search for posts on some topic or by some
person, do you use OE or something else?

Thanks,

Brian


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Firefox is not a newsreader, it's a web browser. You could use it to
access Google, just as you can use any other web browser.
The news reader from the mozilla stable is Thunderbird.

Many of us use Outlook Express, but it's a matter of preference.
--
David Biddulph

"Brian Murphy" wrote in message
...
What is the best way (or ways) to read and post to this newsgroup?

I ordinarily use groups.google.com/group/
microsoft.public.excel.programming,
but it seems to have its problems, too.

How does one use Firefox?

Brian

I thought you were going to use Thunderbird, looks like you are using OE!

If you have downloaded both headers and messages, in OE do Ctrl-Shift-F. But
note posts get removed after about 3 months, though you could copy them to
another folder beforehand.

Otherwise google's advanced search still almost works if you fully qualify
the group
http://groups.google.co.uk/groups/advanced_search
eg Group: microsoft.public.excel.programming

wildcards both ends, eg *excel*, no longer works reliably at all

(tip courtesy of Dave Peterson)

Regards,
Peter T

"Brian" wrote in message
...
David,

I am sending this post using OE's newsreader, which I just now setup.

When you want to do a thorough search for posts on some topic or by some
person, do you use OE or something else?

Thanks,

Brian

OE is the only email program I've ever used. Until a couple months
ago when I had to switch to Outlook 2007 at my day job. Through the
years, I've very become very comfortable using OE, besides its various
quirks. I really wish OE would allow you to edit subjects and delete
attached files as easily as Outlook. Doing this externally with a
text editor gets the job done, but is a drag. I may eventually switch
to Outlook at home, too.

If thunderbird can edit subjects and delete attachment, I'd give it a
look.

Brian

That's a great tip. I thought the advanced search page was gone.
I see it's also accessible via
http://groups.google.com/groups/advanced_search

When I got OE to download all headers and messages, it was about 17000
messages going back to July 2009.
Is there a way to get older messages downloaded?

Brian


Otherwise google's advanced search still almost works if you fully qualify
the grouphttp://groups.google.co.uk/groups/advanced_search
eg Group: microsoft.public.excel.programming

wildcards both ends, eg *excel*, no longer works reliably at all

(tip courtesy of Dave Peterson)

Regards,
Peter T

Brian Murphy wrote:
OE is the only email program I've ever used. Until a couple months
ago when I had to switch to Outlook 2007 at my day job. Through the
years, I've very become very comfortable using OE, besides its various
quirks. I really wish OE would allow you to edit subjects and delete
attached files as easily as Outlook. Doing this externally with a
text editor gets the job done, but is a drag. I may eventually switch
to Outlook at home, too.

If thunderbird can edit subjects and delete attachment, I'd give it a
look.

Brian

Folks -- (not just you, Brian), you do realize the availability of
usenet messages has /nothing/ to do with the application (Thunderbird,
Firefox, IE, OE, Windows Mail, Opera, XNews, etc...) you use to view
them and /everything/ to do with how well your news service propagates
messages and aggregates news messages from other news services, right?

IME subscription news services perform better than ISPs. YMMV.

And if you use the internet to access usenet, e.g., Google Groups or an
MS website, your view of usenet will be limited to how well those sites
collect their news feed.

I just tried using the advanced search page to search specifically
this group, and the search results were messed up. Some were not even
for this group. I wonder what the heck is going on at Google? I'd
hope that if someone were really working the problem, it would get
fixed. Do they even know about the problems?

I see it's also accessible via http://groups.google.com/groups/advanced_search

Brian