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 [email protected] Profile 165 362 2912 2907 04/07/2001 2277 0 19
2 [email protected] Profile 156 85 758 758 09/30/2003 639 0 9
3 [email protected] 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 [email protected] 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 [email protected] Profile 123 266 662 660 12/05/1999 490 2 15
9 [email protected] Profile 119 239 648 647 09/05/1999 498 0 22
10 [email protected] Profile 119 27 427 426 10/15/2003 326 0 9
11 [email protected] Profile 119 242 637 635 03/22/2002 536 0 28
12 [email protected] Profile 113 297 477 476 09/15/1999 361 1 22
13 [email protected] Profile 109 265 229 229 09/05/1999 212 0 13
14 [email protected] Profile 103 206 348 348 01/03/2000 295 0 14
15 [email protected] Profile 103 297 562 562 09/28/2002 382
0 24
16 [email protected] 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 [email protected] 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 [email protected] Profile 76 35 141 139 10/28/2003 112 1 20
22 [email protected] Profile 74 30 157 157 09/18/2000 132 0 7
23 [email protected] 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 [email protected] 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 [email protected] Profile 65 222 142 141 05/17/2002 103 0 23
29 [email protected] Profile 59 220 155 154 09/06/1999 107 0 13
30 [email protected] Profile 57 55 102 102 10/08/2003 86 0 14
31 [email protected] 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 [email protected] 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 [email protected] Profile 49 0 131 131 03/28/2004 117 0 19
37 [email protected] Profile 46 147 83 80 07/25/2001 63 3 16
38 [email protected] Profile 46 10 71 71 09/18/2003 57 0 35
39 [email protected] Profile 45 94 90 90 10/23/1999 85 0 7
40 [email protected] 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 [email protected] Profile 165 362 2912 2907 04/07/2001 2277 0 19
2 [email protected] Profile 156 85 758 758 09/30/2003 639 0 9
3 [email protected] 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 [email protected] 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 [email protected] Profile 123 266 662 660 12/05/1999 490 2 15
9 [email protected] Profile 119 239 648 647 09/05/1999 498 0 22
10 [email protected] Profile 119 27 427 426 10/15/2003 326 0 9
11 [email protected] Profile 119 242 637 635 03/22/2002 536 0 28
12 [email protected] Profile 113 297 477 476 09/15/1999 361 1 22
13 [email protected] Profile 109 265 229 229 09/05/1999 212 0 13
14 [email protected] Profile 103 206 348 348 01/03/2000 295 0 14
15 [email protected] Profile 103 297 562 562 09/28/2002 382
0 24
16 [email protected] 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 [email protected] 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 [email protected] Profile 76 35 141 139 10/28/2003 112 1 20
22 [email protected] Profile 74 30 157 157 09/18/2000 132 0 7
23 [email protected] 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 [email protected] 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 [email protected] Profile 65 222 142 141 05/17/2002 103 0 23
29 [email protected] Profile 59 220 155 154 09/06/1999 107 0 13
30 [email protected] Profile 57 55 102 102 10/08/2003 86 0 14
31 [email protected] 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 [email protected] 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 [email protected] Profile 49 0 131 131 03/28/2004 117 0 19
37 [email protected] Profile 46 147 83 80 07/25/2001 63 3 16
38 [email protected] Profile 46 10 71 71 09/18/2003 57 0 35
39 [email protected] Profile 45 94 90 90 10/23/1999 85 0 7
40 [email protected] Profile 43 9 117 117 11/21/2003 90 0 8