TSGC v1.3.0

TSGC (Texas State German Contests)

Supported Platforms: Windows and Mac

How to use

For Windows users:

• Download tsgc_Windows_v1.3.0.zip file from Assets.
• Unzip the .zip archive.
• Add registration files (.xlsx files) to the same folder as the tsgc.exe file (NOT "bin")
• Double click "tsgc.exe" (See note regarding Windows antivirus).

For Mac users:

• Download tsgc_Mac_v1.3.0.zip file from Assets.
• Unzip the .zip archive by double clicking.
• Add registration files (.xlsx files) to the same folder as the tsgc executable.
• Double click "tsgc" (See note regarding Mac antivirus).

Note

(You will only need to do this one time.)
The executable may be flagged by the Mac or Windows built-in antivirus.

Windows (Microsoft Defender):

1. Click "More info"
2. Click "Run anyway"

Mac:

1. Click "open" when the antivirus message pops up.
2. Then, go into Settings > Privacy & Security and scroll down to the Security section.
3. Finally, allow the application and proceed to open.

Follow the instructions on the terminal window, and all the generated files will be in a folder called "output"! 🎉

Features

• Purpose: Automates processing of German contest registration spreadsheets into formatted reports.
• Standalone App: Distributed as a Windows .exe and Mac version.
• Outputs: Generates Judge Report (Word), Master Report (Excel), and per-school student lists; adds optional alphabetized “Name | Event” lists.
• Smart Data Handling: Skips template files, finds key data dynamically, removes duplicates, and handles missing or rearranged info.

What to Expect in the Future

• Demo Videos explaining the download process and in-practice usage
• An Additional Report with a tabled view of students and their corresponding events for each school
• GUI-based script (no longer just an executable!)