This is a tool to check for event conflicts in existing teams.

What is it?

This file specifies a team that participated and what their event ranks were.

Step 1: Make data. Requirements:

  • There is no header
  • All events must be stated in the A column and should be strings. Only letters will be taken into account, so "&" will be changed to "and." Uppercase/lowercase does not matter. Make sure that the way you named the event is the same as in all the other competitions.
  • All the members present in each event are stated in columns B through D, with the members on the event being in the same row as the event. There must be at least one member in each stated event. Only the member's names should be shown as strings, and only roman alphabet letters will be taken into account. Uppercase/lowercase does not matter. Make sure that the way you named the member is the same as in all the other competitions.
  • The events do not need to be in any order, and there is no max number of events.
  • Colors/formatting does not matter.

Step 2: Download CSV data.

(If you are using Google Sheets)

File -> Download -> Comma Separated Values (.csv)

What is it?

This file describes any events that might conflict at a competition (so no member can do two conflicting events at the same time).

Step 1: Make data. Requirements:

  • There is no header.
  • Not all events need to be mentioned, but there should be no repeats of the mentioned events.
  • Each row corresponds to a group of events that are in the same timeblock. Therefore, no one can do both of the events at the same time.
  • Each row is assumed to end as soon as it reaches an empty cell. Therefore, all events on each row should be stated in the first cell and leave no blank cells between until the end is reached.
  • There is no limit to row length or row number.
  • There should be no other information in the sheet.


Step 2: Download CSV data.
File -> Download -> Comma Separated Values (.csv)