Kids Fencing Tournament

Google Apps Script Project Files

Project Overview

This project contains Google Apps Script files for managing kids fencing tournaments. These files are designed to be deployed to Google Sheets.

Google Apps Script Files (.gs)

KidsCode.gs

Main entry point with menu setup and onOpen/onEdit triggers

KidsConstants.gs

Configuration constants for age groups, touch limits, and pool settings

KidsPoolGeneration.gs

Pool generation logic for Mini Kid, Little Kid, and Big Kid groups

KidsBoutManagement.gs

Bout management and score tracking

KidsDEBracket.gs

Direct Elimination bracket generation and management

KidsDEBracketSeeding.gs

Seeding logic for DE brackets

KidsRankingCalculations.gs

FIE-standard ranking calculations

KidsSheetFormatting.gs

Sheet formatting utilities

KidsSheetUtilities.gs

General sheet utilities and helpers

KidsWebAppLiveScoreboard.gs

Live scoreboard web app functionality

HTML Templates

KidsLiveScoreboard.html

Live tournament scoreboard display

KidsMobileScoreInput.html

Mobile-friendly score input interface

KidsLivePoolBoxes.html

Live pool boxes display

KidsLiveDEResults.html

Live DE results display

KidsDEBracketDialog.html

DE bracket selection dialog

KidsAgeGroupRankingDialog.html

Age group ranking selection dialog

KidsAgeCategoryRankingDialog.html

Age category ranking selection dialog

Age Group Configuration

Mini Kid

Ages 6, 7, 8

Pool: 5 touches | DE: 10 touches

Little Kid

Ages 9, 10, 11

Pool: 5 touches | DE: 10 touches

Big Kid

Ages 12, 13, 14

Pool: 5 touches | DE: 15 touches

Deployment Instructions

  1. Create a new Google Sheets spreadsheet
  2. Go to Extensions > Apps Script
  3. Copy each .gs file content into new script files
  4. Copy each .html file content into new HTML files
  5. Save and reload the spreadsheet
  6. The "Kids Tournament Tools" menu will appear