Heat Sheet Builder Excel Workbook v1.1

When our coaching staff constructed their heat sheet by hand they always wrote it up as a matrix with the heats on the vertical axis and the lanes on the horizontal axis.  This style of heat sheet matches the layout of the pool and the way the kids line up as they get ready to swim.

Now that we are doing all of our seeding using WinSwim, we no longer have the matrix style heat sheet and many of our parents have asked if we can get the heat sheet in that format.

After playing around with Crystal Reports for a while I concluded that it would easier to develop an Excel workbook to construct the heat sheet than it would be to get Crystal Reports to do it.  I am sure CR can do it but I don’t know how and I needed something this season!

image

The Excel workbook I developed consumes the output of the Custom Report Meet Heat Sheet by Event (CSV) that I developed and posted previously (make sure you download the update as I changed the report recently).

The workbook requires Excel 2007 to run.  It will actually run in Excel 2003 if you load the Office 2007 compatibility pack for Office 2003 however the sorting functions are disabled so you’ll have to do your own sorting.

There are some controls over the width and height of the cells that comprise the heat sheet and page breaks will be inserted after every three events.  They can be adjusted using Excel’s standard page break functionality.

Heat Sheet Buildervv1.1, last updated on 2009-07-06

Download a sample heat sheet which was generated with Heat Sheet Builder.

Heat Sheet Builder Samplev07-05, last updated on 2009-07-06

Download the collection of Custom Reports for WinSwim.

WinSwim Custom Reportsv07-05, last updated on 2009-07-06

This Excel workbook is free to download – there is sample data included in it, before using it I would suggest looking at the Heat Sheet CSV tab to see the format of the data once it is imported from the CSV file.

wp-SwimTeam v0.1.417 – Meet Report Shortcode

I posted wp-SwimTeam v0.1.417 this afternoon to the download page.  This update adds new functionality and fixes a few minor things which have bothered me as I found them during the season.

The big new feature is a new shortcode – wpst_meet_report.  This shortcode allows a the contents of a meet report to appear in a post or a page like this example on the wp-SwimTeam demo site.

The reports also now support hiding first and last names by only showing the initial as well as the ability to override the first name with a nickname if the swimmer’s profile has one.  The missing ability to display a map on the swim meet report has been added so the checkbox on the form is now enabled.  The reports can now display opt-in and opt-out information chronologically in the order they were added to the system as well as the previously available by name and by swimmer label.

wp-SwimTeam v0.1.406 – fixes to reports

This evening I posted a new build of wp-SwimTeam to the downloads page.  This version fixes an unusual situation where the swimmer reports would fail to work when no optional swimmer fields we defined.

I also fixed another issue with optional fields (user and swimmer) where if the number of fields in use was set to 0 in the Options settings, the system would revert to the default (5) number of fields.

Over the past week or so I have also posted a couple updates without posting an announcement.  Most of the improvements were in the reporting and SDIF generation.  Reports for Swim Meets can now include multiple meets on the same report and the SDIF options page has a new option to allow overriding the first name with the nickname when exporting the roster in SDIF format.

wp-SwimTeam v0.1.400

A quick update that fixes exactly one issue – v0.1.400 is now on the download page.  I unleashed the opt-in/opt-out system on the MacDolphins today and quickly found that having the Participation column with “Register” and “Scratch” displayed for the users was confusing as parents thought that the Register or Scratch wording indicated the statue of their swimmers.  For now I have removed the column and I will add the ability for parents to see a summary of their Registers and Scratches.

wp-SwimTeam v0.1.399 available

I just uploaded a new version of wp-SwimTeam.  It is now available on the download page.  This version fixes some issues with the Opt-In/Opt-Out functionality and fixes a pretty significant issue with User Option fields not being initialized correctly.

This build also restores the missing CSS references so any information generated by the short codes is displayed properly.

wp-SwimTeam v0.1.389 released

This evening I uploaded a new version of wp-SwimTeam.  It is available on the download page.  This version introduces a new report for swim meets.  The Swim Meet report’s most important feature is the listing of swimmers who have Opted-In or Opted-Out of a swim meet.  On the MacDolphins we call this a the Scratch List.

A parent can now indicate when their swimmers are participating (for meets defined as opt-in) or not participating (for meets defined as opt-out) on either a full meet or event basis.  The meet report will display a summary of swimmer participation based on the type of meet.

A couple of the options on the Report Form are disabled because they aren’t functional yet.  They will probably work in a day or two.

This release also introduces a new mode for Swimmer Labels – Frozen.  When Swimmer Labels are unlocked, they can be bulk assigned.  When they are locked, Swimmer Labels can be edited on a per swimmer basis but no bulk assigned.  When they are frozen, they can’t be edited at all.  I added this because I inadvertently reassigned the swimmer labels for the MacDolphins yesterday without meaning to.  Whoops.

I fixed a few other minor issues as well but nothing significant, mostly presentation of forms and such.

wp-SwimTeam v0.1.377 – Administrative Fields

I posted a new build of wp-SwimTeam this afternoon for download.  This build supports the new administrative mode for user and swimmer optional fields.  It has not had a significant amount of testing but I was able to run through quite a few scenarios and all behaved as expected.

This build also introduces a new type of optional field the NO-YES option.  This is similar to the YES-NO option but defaults to NO instead of YES.

wp-SwimTeam v0.1.376 – bug fixes for Add/Register Swimmer

In the build I posted yesterday there were a couple of bugs which prevented the auto-registration feature to work when a swimmer is added.  There was also a bug in the age verification which allowed swimmers outside of the age range to added to the system and then registered for the active season.

If you download v0.1.375 yesterday, you will want to download v0.1.376 and update the plugin.