Adding Rider Information to Race Notes Easily

Post date: Jul 6, 2015 12:19:46 AM

CrossMgr has an ability to add Race Information to the Notes screen in Properties for some time.

For example, {=EventName} substitutes the name of the event.

This capability has been extended to add detailed rider information with three new variables: "Bib", "BibList" and "BibTable". These new variable take a bib number and expand it into rider information from the Excel spreadsheet.

Consider the following example as a Note:

A warning to the following riders for improper number placement:

{=BibList 131, 122, 187}

On the web page, this will result in:

A warning to the following riders for improper number placement:

  • 131: SMITH, Reginald, ON4325, USA19930404, Cranked Up

  • 122: COOPER, Raj, ON3224, CAN19910502, Kicking Asphalt

  • 187: SKZYPCZAKM, Szymon, ON1230, POL19930501, Wibatech-Fuji

Much quicker and more accurate than retyping this information. And, if you need to correct something, just change it in the Excel sheet and regenerate the html page.

If a field is not present in the Excel sheet (for example, no UCI Code), that field does not appear in the output.

The {=Bib 131} variable makes an in-line substitution of a single bib number. For example:

Fine of $20 to {=Bib 187} for littering.

results in:

Fine of $20 to 187: SKZYPCZAKM, Szymon, ON1230, POL19930501, Wibatech-Fuji for littering.

And finally, {=BibTable 131, 122, 187} is similar to BibList, but creates a table instead of a list:

A warning to the following riders for improper number placement:

{=BibTable 131, 122, 187}

results in:

A warning to the following riders for improper number placement: