The "exe" file is self extracting "zip file". By executing
(running)
the file, you can specify where you want the spreadsheet to appear then
select "UnZip". The default Directory is C:\RelayForLife. The *.xls file
will be extracted and placed in that directory.
The "*.zip" file is compressed using WinZip, and can
be uncompressed
using WinZip or many similar compression programs. Windows XP has this
capability built in.
New team pages are empty waiting for the
actual data to be
entered.
Within the spreadsheets, data may be
entered in blue colored
squares. Yellow colored squares are locked, and may not be changed. All
changes for these cells are updated automatically as data is entered.
People can tell if the have the latest
version if there is
a "2.6" in the top left corner of the Team Summary Page.
New in 2.6
Corrected sort problems on Team Summary and Individual Totals
Corrected Analysis Pages for Youth, Adult, New, Returning and removed regions data
Removed Region data from all pages
Added Online Collection totals
Added Fiscal Year collection totals
New in 2.2
Added New fields on the Analysis Page showing Adult and Youth team statistics
New in 2.1.9
Add new Club Award levels (National,Purple Plus, Diamond Plus, etc)
New is 2.1.8
Corrected errors in Analysis page
New in version 2.1.7
Date cells on team pages were too small - corrected
Date format was 4-digit, changed to 2
New in version 2.1.6
Added "Purple" as Team Award level
Added comment for mouse over explanation for Team
Type and Team Category on Team Summary page
New in version 2.1.5
Reduced the number of teams to 120
Corrected some sort/summary errors in Analysis pages
Added Youth/Adult team Category to Team Page
Changed Team Type, Category, and Region to "click
list" instead of requiring typed entry
Eliminated Team name and camp site sort buttons on
Team Summary
Added Team Type, Team Category, and Team Type AND
Category sort buttons on TeamSumary page
Corrected a computation error on Team pages for date
totals.
New in version 2.1.2
Added the ability to track 3 regions
independently while maintaining
the event as a whole. Before this release only 2 regions could be
tracked.
Added a Hyperlink on the team pages above the Name
entry area to move
quickly to the Registration Fees at the far right column, and another
hyperlink
to get back to the names. Enter all the names, hyperlink to the last
column
and hyperlink back to the names to speed entry of registration fees.
New in version 2.1
On Individual Totals Page, changed sort order on
Team Member Name to
Ascending. Sorts empty cells after cells with names.
On Team Summary, corrected sort order on Ave/Team member
from Ascending
to Descending (highest on top).
New in version 2.0
On Team Summary, added "Sort by Team Captain Name"
Button
On Individual totals Page, added "Sort by Team Member Name"
Button
Removed Date Analysis page which eliminates data entry lag
New in version 1.1.1:
The Registration at the far right...there's a note
above the team member
names to enter it there.
Prefilled all captain names, co-captain names, team names,
team member
names and camp site locations with a "zzz". This will allow the
alphabetical
sort to work correctly and put all the filled team names at the top
instead
of the bottom of the sheet.
The pages set so all will print correctly without any
further set up.
The Team pages print small print, but I hope the data will show well
enough.
New in Version 1.1:
Team Summary page - Sort by Team Name, Team Number,
Campsite Number,
Average Team Money
Team Summary page - corrects an error in grand total
calculation
Add pages for Luminarie, Relay Store, General Donation, and
Corporate
Sponsor turn-ins
Team Pages: Add totals for date/event turn-ins, Adds
Campsite Name
Team Data: Adds sort for Captain Name, Co-Captain name.
