SETI Statistics Spreadsheet

30 May 2002. Berkeley have changed their stats page addresses. To change the address for your team edit the data query on the 'web data' page. I will not be making further changes to the spreadsheet.

v1.27 is current

This spreadsheet allows you to monitor the SETI statistics of each member in a SETI team. It shows many statistics including:

Average WU per day
Average CPU dedication
History over past 10 weeks
Predictions over forthcoming weeks
Distribution of team members

The spreadsheet calculates averages over weekly periods, as opposed to the standard SETI stats which are averages since joining. This allows it to reflect weekly changes in each users machine setups.

It also allows building of custom charts, where you select what users you wish to include and what data to present. This helps to give you a clear idea of how each users' setup compares.

When you download this spreadsheet you need to set up your timezone. You also need to update the statistics from the Berkeley web site at least once a week. You only have to click on a button to do this as the spreadsheet contains macros to update.

Some of the spreadsheet operations can take a long time to complete, especially if your team has many members, so you must be patient.

Why the SETI Statistics Spreadsheet?

Since all the data is held in a spreadsheet users are able to add to the spreadsheet in their own way by adding extra formulas or charts which build on the existing data. Also, the SETI statistics spreadsheet contains the full source code for its macros, so if you know VB you can even add extra macros.

Download

If you're interested click below. Current version is v1.27 (31 July 2001)

stats_skz.zip (270k)

There is a USA mirror site for people who have trouble downloading from tripod (check file version before downloading)

The spreadsheet requires Excel 97 or higher

If you want you can look at some example graphs before hand

The spreadsheet has been loaded with data from the Skzdalimit SETI team from 12 September - 18 February 2001. Later I may make seperate history updates available which can be imported into the spreadsheet.

Upgrading

You can upgrade from v1.20 to a later version by exporting all history data from your existing spreadsheet and then importing it into the new spreadsheet. The export/import functions can be found on the config page

Versions 1.24 and above have a group stats page which, to be fully populated, requires extra data that is not recorded by versions 1.23 or lower. Therefore, if you import data from a spreadsheet v1.23 or lower it will take one week of new readings before the group stats page will be populated.

Users whose teams have users whose names contain any quotes (") will not be able to upgrade by exporting and importing the data; they will have to start a new sheet from scratch.

History

Improvements over v1.27 from v1.26 - released 31 July 2001
	Doesn't include a 'User Profile' user (due to Berkeley's new changes)
Improvements over v1.26 from v1.25 - released 15 June 2001
	Now talks to new iosef server for web stats.
Improvements over v1.25 from v1.24 - released 7 March 2001
	Fixed Problem of 'application defined or object defined error' appearing for sheets with less than 1 weeks worth of data. This would affect just about all users wanting to start a new team history from scratch.
	Now import/export handles user names with quotes in. Before this would have produced a 'corrupt file' message on import.
	Shows 10 week rank-within-group history for each user, and supports rank history charts.
Improvements over v1.24 from v1.23 - released 18 Feb 2001
	Now if the workbook used for new charts is closed, new charts will be still be added to the same (new) workbook, provided the name of the workbook does not change.
	Supports removal of member name prefixes.
	A new Distribution page with 'Member WU Total Distribution' and 'Member WU/day Distribution' (similar to those on the Team Lamb Chop stats page).
	Some problems with file import now fixed.
	Charts now created on new chart sheets, as opposed to new worksheets
	A new group overall statistics page, giving details of daily and weekly overall WU production.
	Dates in d-mmm-yy format to avoid American/UK confusion.
	A new data quality analysis page, to tell you if you are updating stats frequently enough, or if there are gaps in your historical data.
Improvements over v1.23 from v1.22 - released 27 Dec 2000
	Import from file works first time when importing data for a different team
Improvements over v1.22 from v1.21 - released 12 Dec 2000
	wu/day and CPU dedication charts now display data from left to right rather than right to left.
	wu/day and CPU dedication charts now have default time format of date, rather than relative week. Relative week is still supported.
Improvements over v1.21 from v1.2 - released 30 Nov 2000
	Web update works after clearing all data
	Handles blank user names
Improvements over v1.2 from v1.1 - released 29 Nov 2000
	Now includes import/export functions to ease any future upgrades
	Minor tidy ups and a few extra useful dates displayed
Improvements over v1.1 from v1.0 - released 27 Nov 2000
	history data was corrupted when new users joined, and some users had already left
	Handles better usernames which appear twice in the group stats
v1.0 was first release - released around 20 Nov 2000