Infinite opportunities?  Endless problems?  Limited resources?  Talk to us!
Operations
Consulting
Software
Consulting
Publishing and
Training
Applied
Solutions
Excel add-ins
and tutorials
Charts Excel and VBA
Case Studies
VBA
tutorials
PowerPoint
Add-Ins
Miscellenia
You are on the Home/Excel/Newsgroup Statistics page
About this site

What's new

Google
Web
This Site
 

 

Statistics on postings to the more popular Excel newsgroups
Overview Reports

Monthly Statistics (number of messages, posters, new discussions, multi-posts, cross-posts, large posts, average message length, new posters)

Monthly statistics by newsgroup
(number of messages)

Day-by-day
(number of messages)

Newsreader programs (tally of posting software)

More details

Posting Frequency

Posting Frequency by Newsgroup

Initiators (those starting new threads)

Large posts (any post with more than 300 lines, whereas the average size of a post is 40 lines))

Cross-posts (postings to multiple newsgroups)

Multiple posts (the same article posted independently to multiple newsgroups)

Now includes statistics for June 2005

Are you curious about the activity level of the microsoft.public.excel.* newsgroups?
Maybe, you'd like to learn who are the more prolific posters are
Maybe you'd like to identify the program most used for postings?
How about knowing who initiates the most new discussions?'

Check out the information in the pages on the left.  And let me know what you think of this service at tushar@tushar-mehta.com

This section of the web site provides statistical analysis of postings to the more popular Excel newsgroups.  Updates to these pages will be on a monthly basis with a current goal of weekly updates.

Summary statistics cover the entire period for which data are available (June 2000 to now).  Detailed reports are trimmed to the last six months, or even 3 months.  This maintains contemporary relevance and cuts down on the already large files.

A note of caution about the October 2001 data.  Apparently, a large chunk of the data was lost.  Consequently, the numbers for October 2001 are not meaningful for any systematic analysis.  Also note that the data for September 2003 include the impact of the Swen virus. The data for May 2005 and June 2005 include -- accidentally -- statistics for the PowerPoint newsgroup.  The error has no noticeable impact on data about individuals since, for the most part, there are very few who post to both the Excel and the PowerPoint groups.

I have made every attempt to ensure the integrity of the analysis but one must keep in mind that the statistical analysis depends on the data in the headers of each posting.  Given the rather loose standards to which these headers must adhere, the statistics may not be 100% accurate.

This limitation is the same one that other organizations -- such as Google -- must also accept.  Other problems are also intrinsic to the very nature of newsgroups standards.  For example, the statistic on postings on a person-by-person basis (the Posting Frequency report) is more accurate than the same information summarized from the newsgroup-by-newsgroup report (Posting Frequency by Newsgroup).  In the latter case, it is impossible to eliminate the effect of cross-posts without making further assumptions about how to treat the data.

Finally, each of these pages might take some time to load.  They are the result of Excel's Save as Web Page... command and contain XML code.  I have no immediate intention of removing the XML code since the code expedites future updates.

 

For custom technology solutions, operations consulting, or training contact web-underscore-contact@tushar-hyphen-mehta-dot-cee-oh-em.
By accessing any page or link on this web site other than this page, you agree to the terms and conditions.

Ads from amazon.com

[Optional] Survey (current rating of site: 3.7 out of 4)  If you will take a moment to provide your comments, it will help improve the site both for you, and for other visitors.

On a scale of 4 (just what I need)
to zero (totally useless)

How do you rate the information

on this page?

  on this site?

[Optional]

Your name
Your email address
Other comments
 
Monitor page
for changes
    
   it's private  

by ChangeDetection
A comment selected at random:

 

 

Copyright © 2000-2008 Tushar Mehta.
Send comments and suggestions about the web site to webmaster@tushar-hyphen-mehta-dot-cee-oh-em
Last edited April 13, 2008