Executive Director's Report June 2001 =========================== July 17, 2001 By Ian MacEachern (execdir@freenet.carleton.ca) Contents: 1. Status Report 2. Administration & Funding 3. Member Services and Future Initiatives 4. System Administration Appendices A Chart showing Registration Donations B Chart showing Renewal Donations C Chart showing Membership Activity 1. Status Report ================ a) Key Indicators: May. June. % | June. % 2001 2001 Inc/Dec | 2000 Inc/Dec ~~~~~~~ ~~~~~~~~ ~~~~~~~ | ~~~~~~~~ ~~~~~~~ 1. Number of members: 7,184 7,235 0.7% | 9,079 -20.3% 2. Donation Revenue: $16,093 $14,195 -11.7% | $12,703 11.7% 3. Percentage donating: 64.7% 86.6% 33.8% | 77.6% 10.3% 4. Average Donation: $ 34.90 $ 32.85 - 5.8% | $ 32.99 - 0.4% b) Top Priorities ~~~~~~~~~~~~~~ (1) Projects - HRDC WebMail - Development phase (business plan) - HRDC - Thin Client - implementation phase - IC Smart Capital - modify and sign partner agreement (2) Renewal numbers (3) System reliability - Resolve modem problems (3com RAS 1500's) c) Top Priorities - Sysadmin ~~~~~~~~~~~~~~~~~~~~~~~~~ (1) HRDC WebMail - migrate web server and evaluate webmail prototype (2) SPAM - research possible solutions to this on-going problem (3) Work with 3com getting RAS 1500 problems solved 2. Administration & Funding =========================== a) Donation Data - New Registrations ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The number of new members was slightly better than budget in June with 106 new members joining. Revenue was over budget as well at $1,829. Percentage of donors was 78.3%. The situation on a year-to-date basis remains the same as last month, with some 866 new members exceeding the forecasted 588 (+47%), donating a total of $10,601 or 1.8% less than the $10,800 budgeted. (See Appendix "A") b) Donation Data - Renewals ~~~~~~~~~~~~~~~~~~~~~~~~ The number of renewals in June was 393; well above (+33%) the predicted 295. Of these, 88.8% donated a total $14,195, well above our forecast of $12,911 (+9.9%). Year-to-date renewals continue to be strong in numbers but not in revenue. 3,002 members have renewed so far this year, compared to our forecast of 2,500 (+20.1%) Renewal donations year-to-date total $91,739 vs. a budget figure of $109,335 (-16.1%). (See Appendix "B") c) Membership Activity: ~~~~~~~~~~~~~~~~~~~~ Membership rose this month: now standing at 7,235, an increase of 0.7%. The year-to-date decline is some 330 members or about 4.4% since January 1, 2001. (See Appendix "C") This may be due to archiving being turned off while Sheila was away on holidays. d) Sponsorship, Homepage Data and Information Providers: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ No changes in IP web pages in the month 3. Member Services and Future Initiatives ========================================== a) Projects ~~~~~~~~ (i) Industry Canada - SmartCapital: I met with our Smart Capital counterpart at OCRI. We've agreed on a course of action to revise the entire statement of work for the project. This will result in delaying the signing of the contribution agreement. Extended Access II - City of Ottawa: City of Ottawa IT staff rep has indicated no new progress on the project. Thin Client Expansion I am contacting partners to obtain required donations of software for the service expansion. This is a little more difficult because of the delays in the initial implementation of the service (HRDC Thin Client). WebMail I have met with iPlanet (a Sun Microsystems / Netscape alliance) and e-pals.com to obtain a donation of the required software for this service. Initial conversations appear to be positive. Proposals have been put forward and further conversations will take place once the proposals have been reviewed. (ii) HRDC (Office of Learning Technology): Thin Client Rebel.com has been contracted to start the implementation of the Thin Client project. Comgate Engineering will be contracted to do documentation and testing for the project. (iii) HRDC (Office of Learning Technology): WebMail Continuing the development of relationships with potential partners. The prototype is being evaluated. The development stage of the project calls for NCF to submit a Business plan together with a proposal for full funding. This is to occur shortly after the final report is due on July 15, 2001. b) 3com RAS 1500 Access Servers ~~~~~~~~~~~~~~~~~~ 3com has replicated our problem in their labs but has not yet a solution. Andre is continuing to work with them on this issue. c) Renewals ~~~~~~~~ Work on projects has resulted in the analysis of the membership database and determining the effect of the disruption in the automated renewal letter e-mail process earlier this year to be delayed. 4. System Administration ======================== a) HRDC WebMail ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ See the note in 3(a)(iii) above. The files System architecture needs to be modified and cleaned up before we proceed with the planned changes for an updated webserver. Once all files and importantly, the webroot, the search engine as well as the configuration of software redirects and virtual servers currently being served by the production webserver have been moved to freenet9, the Apache server currently running there in test mode will be implemented as the main web server. b) SPAM ~~~~ More and more members are being inundated with SPAM. Andre is researching methods we can use to combat it. Unfortunately the user identification system in use at the NCF makes us particularly easy targets. Blanket SPAM removal solutions run the risk of stopping legitimate e-mail from being delivered to the intended recipient. c) 3com RAS 1500 Problems ~~~~~~~~~~~~~~~~~~~~ See the note in above 3(c) above. ----------------------------------------------------------------------- Appendix A Registration Donations ~~~~~~~~~~~~~~~~~~~~~~ No. No. % Of Avg. Avg. New Budget Regist Memb $ Budget Regist Donat'n Memb. (No.) Var Donate Donate Amount ($) Var Donat'n All New ~~~~~ ~~~~~ ~~~ ~~~~~~ ~~~~~~ ~~~~~~~ ~~~~~~~ ~~~ ~~~~~~~ ~~~~~~~ Oct. 201 400 -50% 103 51.2% $ 2,047 $ 4,000 -49% $38.83 $19.09 Nov. 260 400 -35% 100 38.5% $ 2,305 $ 4,000 -42% $40.00 $15.38 Dec. 114 400 -72% 65 57.0% $ 1,794 $ 4,000 -55% $61.54 $35.09 ~~~~~ ~~~~~ ~~~~ ~~~~~ ~~~~~~ ~~~~~~~ ~~~~~~~ ~~~~ ~~~~~~ ~~~~~~ YTD'99 2,521 4,200 -40% 1,198 47.5% $28,153 $42,000 -33% $23.50 $11.17 Avg'99 210 350 -40% 100 47.5% $ 2,346 $ 3,500 -33% $23.50 $11.17 2000 Jan. 162 98 65% 73 45.1% $ 1,743 $ 2,500 -30% $23.88 $10.76 Feb. 191 98 - 64 - 2,021 $ 2,500 - - - Mar. 153 98 - 92 - 2,871 $ 2,500 - - - Apr. 115 98 - 66 - 1,620 $ 2,500 - - - May. 112 98 - 59 - 1,707 $ 2,500 - - - Jun. 122 98 - 51 - 1,368 $ 2,500 - - - Jul. 114 98 - 59 - 1,508 $ 2,500 - - - Aug. 137 98 - 55 - 1,691 $ 2,500 - - - Sep. 128 98 - 60 - 1,751 $ 2,500 - - - Oct. 115 98 - 66 - 1,773 $ 2,500 - - - Nov. 107 98 - 61 - 1,667 $ 2,500 - - - Dec. 111 98 - 69 - 1,842 $ 2,500 - - - Jan01 186 98 - 83 - 2,252 $ 1,800 - - - Feb01 141 98 - 88 - 1,996 $ 1,800 - - - Mar01 159 98 - 82 - 2,172 $ 1,800 - - - Apr01 120 98 - (19m) 45 - 784 $ 1,800 - - - May01 154 98 - (19m) 66 - 1,568 $ 1,800 - - - Jun01 106 98 - (16m) 83 - 1,829 $ 1,800 - - - Jul01 98 - - $ 1,800 - - - Aug01 98 - - $ 1,800 - - - Sep01 98 - - $ 1,800 - - - Oct01 98 - - $ 1,800 - - - Nov01 98 - - $ 1,800 - - - Dec01 98 - - $ 1,800 - - - Appendix B Renewal Donations ~~~~~~~~~~~~~~~~~ No. % Of Avg. Renwl No. Budget Renwl Renwl $ Budget Renwl Donate Renwl (No.) Var Donate Donate Amount ($) Var Donatn All Ren ~~~~~ ~~~~~~ ~~~ ~~~~~~ ~~~~~~ ~~~~~~~ ~~~~~~~ ~~~ ~~~~~~~ ~~~~~~~ Oct. 320 309 4% 207 64.7% $ 4,843 $ 6,300 -23% $23.40 $15.13 Nov. 268 314 -15% 292 109% $ 7,886 $ 6,400 23% $27.01 $29.43 Dec. 405 387 5% 339 83.7% $ 11,200 $ 7,900 42% $33.04 $27.65 ~~~~~ ~~~~~~ ~~~ ~~~~~ ~~~~ ~~~~~~~~ ~~~~~~~~ ~~~~ ~~~~~~ ~~~~~~ YTD'99 6,587 8,892 -26% 5,554 84% $149,521 $181,400 -18% $26.92 $22.70 AVG'99 549 741 -26% 463 84% $ 12,460 $ 15,117 -18% $26.92 $22.70 Jan. 741 580 28% 441 60% $ 13,453 $ 14,800 -9% $30.51 $18.16 Feb. 899 549 - 520 - 19,069 $ 14,000 - - - Mar. 738 647 - 667 - 22,097 $ 16,500 - - - Apr. 598 588 - 430 - 17,358 $ 15,000 - - - May. 501 412 - 344 - 11,745 $ 10,500 - - - Jun. 374 208 - 334 - 11,335 $ 5,300 - - - Jul. 277 157 - 251 - 8,912 $ 4,000 - - - Aug. 214 129 - 215 - 5,948 $ 3,300 - - - Sep. 223 78 - 244 - 4,633 $ 2,000 - - - Oct. 182 106 - 178 - 5,031 $ 2,700 - - - Nov. 298 208 - 296 - 7,467 $ 5,300 - - - Dec. 339 482 - 291 - 10,579 $ 12,300 - - - Jan01 674 395 - 460 - 18,874 $ 17,266 - - - Feb01 451 468 - 364 - 13,597 $ 20,465 - - - Mar01 405 443 - 441 - 17,015 $ 19,399 - - - Apr01 521 473 -(83m) 338 - 13,533 $ 20,674 - - - May01 558 426 -(89m) 395 - 14,525 $ 18,620 - - - Jun01 393 295 -(94m) 349 - 14,195 $ 12,911 - - - Jul01 155 - - $ 6,779 - - - Aug01 113 - - $ 4,924 - - - Sep01 122 - - $ 5,323 - - - Oct01 133 - - $ 5,813 - - - Nov01 117 - - $ 5,119 - - - Dec01 210 - - $ 11,001 - - - Appendix C Membership Activity ~~~~~~~~~~~~~~~~~~~ |Member | Current |To line| Actual |Ratio |Number Forecast Number Forecast Number Number # of % inc. | |Of New No. of Members No. of Members Members Members -dec. |Lns :1 |Members New Memb Renewed Renewed Un-arch Archvd ~~~~~~~ ~~~~~~ |~~~~~~~|~~~~~~~ ~~~~~~~~ ~~~~~~~ ~~~~~~~~~~~~~~ ~~~~~~~ 1999 Oct. 10,669 -4.0% |213 50| 201 400 320 309 8 652 Nov. 10,600 -0.6% |213 50| 260 400 268 314 268 597 Dec. 10,325 -2.6% |213 48| 114 400 405 387 22 411 2000 Jan. 10,005 -3.1% |213 47| 162 98 741 580 13 323 Feb. 9,992 - - - 191 98 899 549 1 217 Mar. 9,924 - - - 153 98 738 647 24 195 Apr. 9,739 - - - 115 98 598 588 19 329 May. 9,345 - - - 112 98 501 412 10 506 Jun. 9,079 - - - 122 98 374 208 12 454 Jul. 8,678 - - - 114 98 277 157 20 515 Aug. 8,344 - - - 137 98 214 129 26 506 Sep. 8,091 - - - 128 98 223 78 28 415 Oct. 7,972 - - - 115 98 182 106 8 252 Nov. 7,755 - - - 107 98 298 208 17 325 Dec. 7,590 - - - 111 98 339 482 3 303 Jan01 7,565 - - - 186 98 674 395 0 211 Feb01 7,495 - - - 141 98 451 468 14 223 Mar01 7,393 - - - 159 98 405 443 5 82 Apr01 7,259 - - - 120 98 521 473 3 255 May01 7,184 - - - 154 98 558 426 31 250 Jun01 7,235 - - - 106 98 393 295 25 88 -- *** Ian MacEachern, Executive Director *** National Capital Freenet / Libertel de la Capitale nationale tel. (613) 520-2600 ext. 8024 -or- fax (613) 520-3524