L
listme
http://netscan.research.microsoft.c...13/2004&searchfor=microsoft.public.excel.misc
REPORT for microsoft.public.excel.misc. Change the newsgroup name for a
different report. Netscan data is updated monthly
Newsgroup Report Data collected through: 06/13/2004 Help
Report Time Span
Day Week
Month Quarter Year
Data Analysis for: Save Search
For Date (mm/dd/yyyy)
Results for the year of 2004, up to 6/13/2004 Report that can be
posted into Newsgroup
REPORT CARD
This Period / Last Period Change From Prior Daily Average
This Period / Last Period
Messages 48745 / 85126 -43 % 133 / 233
Average Message Length 21 / 25 Lines -16 %
People 12263 / 21314 People -42 % 33 / 58
Returnees 960 / 1278 Returnees -25 % 2 / 3
Repliers 5763 / 7719 Repliers -25 % 15 / 21
1x Posters 9616 / 9616 People -33 % 26 / 39
Interactivity
Replies 34376 / 57648 -40 % 93 / 157
Unreplied Messages 1553 / 3760 -59 % 4 / 10
Neighbor Newsgroups Shared Messages % Shared
Total Neighbors 159 913 1.9 %
#1 Neighbor microsoft.public.excel.programming 415 .9 %
#2 Neighbor microsoft.public.excel 274 .6 %
#3 Neighbor microsoft.public.excel.worksheet.functions 266 .5 %
#4 Neighbor microsoft.public.excel.printing 82 .2 %
#5 Neighbor microsoft.public.excel.charting 70 .1 %
THREAD TRACKER These are the forty largest threads in this newsgroup,
ordered by the number of posts received in the time period selected. Help
No Subject Line Posts in This Period Total Posts Thread Age in Days
1 Can this be done? 42 52 205
2 List Box filled depending on value in another cell 31 31 8
3 Add A Command Button To The Menu Bar 31 31 23
4 Anniversary Date 29 29 10
5 enforcing macros 28 28 7
6 I need a help 27 27 3
7 Countif with 1+ specifics 26 26 1
8 What's wrong with the RETRY button on data validation? 26 26 7
9 Changing what Auto filter does 26 26 8
10 Why does formula automatically change to its result 22 22 8
11 Conditional Copy/Paste 22 22 15
12 =text(now(),"Mmm")-1 ? 22 22 2
13 Easy way to delete names in a workbook? 22 22 2
14 Decimal 21 21 3
15 Frank K and Bob P 21 21 1
16 Changing options permanently 21 21 4
17 zip codes 20 20 4
18 calculating time 20 20 51
19 Work menu in Excel? 20 20 3
20 Prevent leaving worksheet if in filter mode 20 20 6
21 Multiple criteria problems using COUNT 20 20 1
22 Counting time instances Challenge 19 19 4
23 Hiding data in a ExcelSheet 19 19 82
24 Summing qualifying data 19 19 8
25 copying information between Commas? 19 19 36
26 if- then question 18 18 2
27 finds and concatenate 18 18 3
28 Retrieve/Recover data following my stupidity when asked to save changes
18 18 5
29 2002 or 2003 18 18 4
30 loading data from spread sheet to oracle database 18 18 19
31 Alternative to Solver needed 17 17 4
32 Can't exit template with required fields 17 17 3
33 Can't remove a macro! 17 17 1
34 advanced comparison between columns 17 17 2
35 Workbook protection 17 17 9
36 Conditioning Format Question! 17 17 1
37 Can a macro capture this? 17 17 3
38 How to merge cells in a row, horizontally only, not vertically? 17 17 2
39 Formula Help 17 17 2
40 Entering Data to make a list? 17 17 6
Author Tracker These are the forty most consistently present authors,
ordered by the number of days each author posted in the time period
selected. Help
NO Posters Days Active Posts Replies First Seen Threads Touched Threads
Initiated Other
NGs
This Period Last Period
1 (e-mail address removed) Profile 165 362 2912 2907 04/07/2001 2277 0 19
2 (e-mail address removed) Profile 156 85 758 758 09/30/2003 639 0 9
3 (e-mail address removed) Profile 152 37 1327 1325 11/15/2003
997 1 34
4 <[email protected]> Profile 147 69 792 664
10/15/2003 668 113 1508
5 "Frank Kabel" <[email protected]> Profile 146 0 4728 4728
01/07/2004 3626 0 33
6 (e-mail address removed) Profile 142 148 1070 1069 09/06/2002 748 1 16
7 Gord Dibben <gorddibbATshawDOTca> Profile 142 10 826 825 11/28/2003
721 0 12
8 (e-mail address removed) Profile 123 266 662 660 12/05/1999 490 2 15
9 (e-mail address removed) Profile 119 239 648 647 09/05/1999 498 0 22
10 (e-mail address removed) Profile 119 27 427 426 10/15/2003 326 0 9
11 (e-mail address removed) Profile 119 242 637 635 03/22/2002 536 0 28
12 (e-mail address removed) Profile 113 297 477 476 09/15/1999 361 1 22
13 (e-mail address removed) Profile 109 265 229 229 09/05/1999 212 0 13
14 (e-mail address removed) Profile 103 206 348 348 01/03/2000 295 0 14
15 (e-mail address removed) Profile 103 297 562 562 09/28/2002 382
0 24
16 (e-mail address removed) Profile 100 117 370 370 04/09/2002 318 0 9
17 "Jason Morin" <[email protected]> Profile 93 174 282 282
02/18/2002 258 0 5
18 (e-mail address removed) Profile 93 117 239 239 12/09/2001 138 0 10
19 "JMay" <[email protected]> Profile 84 100 158 151 09/14/2002 121 7 6
20 "Bernie Deitrick" <deitbe @ consumer dot org> Profile 77 10 187 187
12/01/2003 146 0 10
21 (e-mail address removed) Profile 76 35 141 139 10/28/2003 112 1 20
22 (e-mail address removed) Profile 74 30 157 157 09/18/2000 132 0 7
23 (e-mail address removed) Profile 70 70 364 364 05/05/2003 327 0 7
24 "Jeff" <[email protected]> Profile 70 11 266 247
10/24/2003 248 15 279
25 "Earl Kiosterud" <[email protected]> Profile 70 0 224 224
01/12/2004 192 0 7
26 (e-mail address removed) Profile 66 30 172 171 10/15/2003 156 1 11
27 post_a_reply@no_e-mail.com Profile 66 149 105 105 09/14/2001 90 0 16
28 (e-mail address removed) Profile 65 222 142 141 05/17/2002 103 0 23
29 (e-mail address removed) Profile 59 220 155 154 09/06/1999 107 0 13
30 (e-mail address removed) Profile 57 55 102 102 10/08/2003 86 0 14
31 (e-mail address removed) Profile 55 0 315 313 01/13/2004
278 1 6
32 "Charlie" <[email protected]> Profile 54 3 103 99
11/21/2003 93 4 132
33 (e-mail address removed) Profile 52 80 81 80 03/31/2001 59 0 8
34 "=?Utf-8?B?TWFyayBHcmFlc3Nlcg==?="
<[email protected]> Profile 50 10 149 148 12/02/2003 122
1 3
35 "Mark" <[email protected]> Profile 50 19 81 48
10/21/2003 73 31 360
36 (e-mail address removed) Profile 49 0 131 131 03/28/2004 117 0 19
37 (e-mail address removed) Profile 46 147 83 80 07/25/2001 63 3 16
38 (e-mail address removed) Profile 46 10 71 71 09/18/2003 57 0 35
39 (e-mail address removed) Profile 45 94 90 90 10/23/1999 85 0 7
40 (e-mail address removed) Profile 43 9 117 117 11/21/2003 90 0 8
REPORT for microsoft.public.excel.misc. Change the newsgroup name for a
different report. Netscan data is updated monthly
Newsgroup Report Data collected through: 06/13/2004 Help
Report Time Span
Day Week
Month Quarter Year
Data Analysis for: Save Search
For Date (mm/dd/yyyy)
Results for the year of 2004, up to 6/13/2004 Report that can be
posted into Newsgroup
REPORT CARD
This Period / Last Period Change From Prior Daily Average
This Period / Last Period
Messages 48745 / 85126 -43 % 133 / 233
Average Message Length 21 / 25 Lines -16 %
People 12263 / 21314 People -42 % 33 / 58
Returnees 960 / 1278 Returnees -25 % 2 / 3
Repliers 5763 / 7719 Repliers -25 % 15 / 21
1x Posters 9616 / 9616 People -33 % 26 / 39
Interactivity
Replies 34376 / 57648 -40 % 93 / 157
Unreplied Messages 1553 / 3760 -59 % 4 / 10
Neighbor Newsgroups Shared Messages % Shared
Total Neighbors 159 913 1.9 %
#1 Neighbor microsoft.public.excel.programming 415 .9 %
#2 Neighbor microsoft.public.excel 274 .6 %
#3 Neighbor microsoft.public.excel.worksheet.functions 266 .5 %
#4 Neighbor microsoft.public.excel.printing 82 .2 %
#5 Neighbor microsoft.public.excel.charting 70 .1 %
THREAD TRACKER These are the forty largest threads in this newsgroup,
ordered by the number of posts received in the time period selected. Help
No Subject Line Posts in This Period Total Posts Thread Age in Days
1 Can this be done? 42 52 205
2 List Box filled depending on value in another cell 31 31 8
3 Add A Command Button To The Menu Bar 31 31 23
4 Anniversary Date 29 29 10
5 enforcing macros 28 28 7
6 I need a help 27 27 3
7 Countif with 1+ specifics 26 26 1
8 What's wrong with the RETRY button on data validation? 26 26 7
9 Changing what Auto filter does 26 26 8
10 Why does formula automatically change to its result 22 22 8
11 Conditional Copy/Paste 22 22 15
12 =text(now(),"Mmm")-1 ? 22 22 2
13 Easy way to delete names in a workbook? 22 22 2
14 Decimal 21 21 3
15 Frank K and Bob P 21 21 1
16 Changing options permanently 21 21 4
17 zip codes 20 20 4
18 calculating time 20 20 51
19 Work menu in Excel? 20 20 3
20 Prevent leaving worksheet if in filter mode 20 20 6
21 Multiple criteria problems using COUNT 20 20 1
22 Counting time instances Challenge 19 19 4
23 Hiding data in a ExcelSheet 19 19 82
24 Summing qualifying data 19 19 8
25 copying information between Commas? 19 19 36
26 if- then question 18 18 2
27 finds and concatenate 18 18 3
28 Retrieve/Recover data following my stupidity when asked to save changes
18 18 5
29 2002 or 2003 18 18 4
30 loading data from spread sheet to oracle database 18 18 19
31 Alternative to Solver needed 17 17 4
32 Can't exit template with required fields 17 17 3
33 Can't remove a macro! 17 17 1
34 advanced comparison between columns 17 17 2
35 Workbook protection 17 17 9
36 Conditioning Format Question! 17 17 1
37 Can a macro capture this? 17 17 3
38 How to merge cells in a row, horizontally only, not vertically? 17 17 2
39 Formula Help 17 17 2
40 Entering Data to make a list? 17 17 6
Author Tracker These are the forty most consistently present authors,
ordered by the number of days each author posted in the time period
selected. Help
NO Posters Days Active Posts Replies First Seen Threads Touched Threads
Initiated Other
NGs
This Period Last Period
1 (e-mail address removed) Profile 165 362 2912 2907 04/07/2001 2277 0 19
2 (e-mail address removed) Profile 156 85 758 758 09/30/2003 639 0 9
3 (e-mail address removed) Profile 152 37 1327 1325 11/15/2003
997 1 34
4 <[email protected]> Profile 147 69 792 664
10/15/2003 668 113 1508
5 "Frank Kabel" <[email protected]> Profile 146 0 4728 4728
01/07/2004 3626 0 33
6 (e-mail address removed) Profile 142 148 1070 1069 09/06/2002 748 1 16
7 Gord Dibben <gorddibbATshawDOTca> Profile 142 10 826 825 11/28/2003
721 0 12
8 (e-mail address removed) Profile 123 266 662 660 12/05/1999 490 2 15
9 (e-mail address removed) Profile 119 239 648 647 09/05/1999 498 0 22
10 (e-mail address removed) Profile 119 27 427 426 10/15/2003 326 0 9
11 (e-mail address removed) Profile 119 242 637 635 03/22/2002 536 0 28
12 (e-mail address removed) Profile 113 297 477 476 09/15/1999 361 1 22
13 (e-mail address removed) Profile 109 265 229 229 09/05/1999 212 0 13
14 (e-mail address removed) Profile 103 206 348 348 01/03/2000 295 0 14
15 (e-mail address removed) Profile 103 297 562 562 09/28/2002 382
0 24
16 (e-mail address removed) Profile 100 117 370 370 04/09/2002 318 0 9
17 "Jason Morin" <[email protected]> Profile 93 174 282 282
02/18/2002 258 0 5
18 (e-mail address removed) Profile 93 117 239 239 12/09/2001 138 0 10
19 "JMay" <[email protected]> Profile 84 100 158 151 09/14/2002 121 7 6
20 "Bernie Deitrick" <deitbe @ consumer dot org> Profile 77 10 187 187
12/01/2003 146 0 10
21 (e-mail address removed) Profile 76 35 141 139 10/28/2003 112 1 20
22 (e-mail address removed) Profile 74 30 157 157 09/18/2000 132 0 7
23 (e-mail address removed) Profile 70 70 364 364 05/05/2003 327 0 7
24 "Jeff" <[email protected]> Profile 70 11 266 247
10/24/2003 248 15 279
25 "Earl Kiosterud" <[email protected]> Profile 70 0 224 224
01/12/2004 192 0 7
26 (e-mail address removed) Profile 66 30 172 171 10/15/2003 156 1 11
27 post_a_reply@no_e-mail.com Profile 66 149 105 105 09/14/2001 90 0 16
28 (e-mail address removed) Profile 65 222 142 141 05/17/2002 103 0 23
29 (e-mail address removed) Profile 59 220 155 154 09/06/1999 107 0 13
30 (e-mail address removed) Profile 57 55 102 102 10/08/2003 86 0 14
31 (e-mail address removed) Profile 55 0 315 313 01/13/2004
278 1 6
32 "Charlie" <[email protected]> Profile 54 3 103 99
11/21/2003 93 4 132
33 (e-mail address removed) Profile 52 80 81 80 03/31/2001 59 0 8
34 "=?Utf-8?B?TWFyayBHcmFlc3Nlcg==?="
<[email protected]> Profile 50 10 149 148 12/02/2003 122
1 3
35 "Mark" <[email protected]> Profile 50 19 81 48
10/21/2003 73 31 360
36 (e-mail address removed) Profile 49 0 131 131 03/28/2004 117 0 19
37 (e-mail address removed) Profile 46 147 83 80 07/25/2001 63 3 16
38 (e-mail address removed) Profile 46 10 71 71 09/18/2003 57 0 35
39 (e-mail address removed) Profile 45 94 90 90 10/23/1999 85 0 7
40 (e-mail address removed) Profile 43 9 117 117 11/21/2003 90 0 8