INDIA NEW GAMES APP

LAMÉ — Fencing Tournament System

LAMÉ Fencing Tournament System

DASHBOARD

TOURNAMENT OVERVIEW

Fencers

Teams

Events

Bouts Done

Complete

TOURNAMENT INFO

No tournament loaded.
Click + Tournament to begin.

EVENTS SUMMARY

No events yet.

UPCOMING BOUTS

Pool	Event	Cat	Left Fencer	Right Fencer	Status	Action

FENCERS

ATHLETE REGISTRY

All Ages U14 U17 U19 Open

All Genders Girls Boys

All Weapons Foil Épée Sabre

#	Name	Nat	Club / School / College	Age Cat	Gender	Weapon(s)	Rating	DOB	Actions

EVENTS

INDIVIDUAL & TEAM EVENTS

All Types Individual Team

All Ages U14 U17 U19 Open

All Genders Girls Boys

TEAMS

TEAM ROSTER MANAGEMENT

REGISTERED TEAMS

No teams registered.

TEAM FORMAT RULES

Touch Target	Relay Bouts	Touches/Bout	Members
45 touches	9 bouts	5 each	3 + 1 sub
15 touches	3 bouts	5 each	3 + 1 sub
10 touches	2 bouts	5 each	3 + 1 sub
5 touches	1 bout	5 each	3 + 1 sub

Select touch target when creating a Team Event. Winner is first to reach target, or highest score after time limit.

TEAM STANDINGS

No results yet.

⚔️ TEAM BOUTS

Select a team event to view fixtures.

🏆 TEAM KNOCKOUT BRACKET

Select a team event and generate the knockout bracket.

POOLS

ROUND-ROBIN PHASE

Select an individual event and generate pools.

KNOCKOUT

DIRECT ELIMINATION

LIVE SCORE

BOUT SCOREBOARD

SELECT A MATCH

—

3:00

PAUSED

—

0🟨

0🟥

—

0🟨

0🟥

NO MATCH LOADED

LIVE SCORING

BOUT CONTROL PANEL

SELECT BOUT

Event

Bout

Piste

LEFT

03:00

RIGHT

PENALTY CARDS

Fencer	🟨 Yellow	🟥 Red	⬛ Black
—	0	0
—	0	0

BOUT LOG

Waiting for bout...

RESULTS

FINAL RANKINGS & REPORTS

FINAL RANKINGS

Rank	Name	Club	Nat	Age	Gender	V	TS	TR	Ind

BOUT RESULTS

Round	Left	Score	Right	Winner

ROUND ROBIN RANKINGS

Rank	Team	Club	Age	Gender	W	L	PF	PA	Diff

MEDAL TABLE

Club / Nation	🥇 Gold	🥈 Silver	🥉 Bronze	Total

ALL EVENT RESULTS

SCHEDULE

BOUT ORDER & PISTE ASSIGNMENT

Select an event and click ⚡ Generate Order to create a bout schedule.

PROFILES

FENCER STATISTICS & HEAD-TO-HEAD

TOURNAMENT PIN (4–6 digits)

💡 Officials need: this file + add #mobile to URL + this PIN.
No app download, no internet required.

📊

Google Sheets Sync (optional)

Every score saved by officials is also sent to a Google Sheet in real-time

GOOGLE APPS SCRIPT WEB APP URL

📋 Google Sheets Setup (one-time, 5 minutes)

Go to sheets.google.com → create a new sheet
Click Extensions → Apps Script
Paste this code and click Save:

Creates 3 sheets: Scores · Pools · Standings

function doPost(e){
  try{
    var data=JSON.parse(e.postData.contents);
    var ss=SpreadsheetApp.getActiveSpreadsheet();
    var action=data.action||'score';
    if(action==='score') return handleScore(ss,data);
    if(action==='fullsync') return handleFullSync(ss,data);
    return ok('unknown action');
  }catch(err){
    return err_(err.message);
  }
}

function doGet(e){
  return ContentService
    .createTextOutput(JSON.stringify({ok:true,msg:'LAME '+new Date().toLocaleString()}))
    .setMimeType(ContentService.MimeType.JSON);
}

/* ── SCORE: insert or update a single bout row ─────────────── */
function handleScore(ss,d){
  var sh=ss.getSheetByName('Scores')||ss.insertSheet('Scores');
  var HEADERS=['Key','Timestamp','Tournament','Event','Pool','Bout#',
               'Left Fencer','Club L','Score L','Score R','Club R','Right Fencer','Winner','Status'];
  if(sh.getLastRow()===0) sh.appendRow(HEADERS);

  var key=[d.tournament,d.event,'P'+(d.pool+1),'B'+(d.bout+1)].join('|');
  var timestamp=new Date().toLocaleString('en-GB');
  var row=[key,timestamp,d.tournament||'',d.event||'',
           'Pool '+(d.pool+1),'Bout '+(d.bout+1),
           d.nameA||'',d.clubA||'',d.sa,d.sb,
           d.clubB||'',d.nameB||'',d.winner||'',d.status||'Scored'];

  // Search for existing row with same key (col A)
  var data=sh.getDataRange().getValues();
  var found=-1;
  for(var i=1;i0){
    sh.getRange(found,1,1,row.length).setValues([row]);
    colorRow(sh,found,d.sa,d.sb);
  } else {
    sh.appendRow(row);
    colorRow(sh,sh.getLastRow(),d.sa,d.sb);
  }
  autoResizeCols(sh);
  return ok('score saved');
}

function colorRow(sh,rowNum,sa,sb){
  var range=sh.getRange(rowNum,1,1,14);
  range.setBackground('#ffffff');
  if(sa>sb) sh.getRange(rowNum,7).setBackground('#d9ead3'); // green left wins
  else if(sb>sa) sh.getRange(rowNum,12).setBackground('#d9ead3'); // green right wins
  else sh.getRange(rowNum,7,1,6).setBackground('#fff2cc'); // yellow draw
}

/* ── FULL SYNC: rebuild entire tournament sheets ───────────── */
function handleFullSync(ss,d){
  syncPoolsSheet(ss,d);
  syncStandingsSheet(ss,d);
  syncLogSheet(ss,d);
  return ok('full sync done');
}

function syncPoolsSheet(ss,d){
  var sh=ss.getSheetByName('Pools')||ss.insertSheet('Pools');
  sh.clearContents();sh.clearFormats();
  var rows=[['LAMÉ FENCING — POOL RESULTS','','','','','',''],
            ['Tournament: '+d.tournament,'','Date: '+new Date().toLocaleDateString('en-GB'),'','','',''],
            []];
  (d.pools||[]).forEach(function(p){
    rows.push(['═══ POOL '+(p.poolNum+1)+' — '+p.event+' ═══','','','','','','']);
    var header=['#','Fencer','Club'];
    var fencers=p.fencers||[];
    fencers.forEach(function(f,i){header.push(String.fromCharCode(65+i));});
    header.push('V','TS','TR','Ind','Rank');
    rows.push(header);
    fencers.forEach(function(f,fi){
      var row=[fi+1,f.name||'',f.club||''];
      fencers.forEach(function(g,gi){
        if(fi===gi){row.push('—');}
        else{
          var key=[Math.min(fi,gi),Math.max(fi,gi)].join('_');
          var b=p.bouts[key];
          if(b){row.push(fi
    👆 Click code to copy
    
      Click Deploy → New Deployment → Web App
      Set Execute as: Me · Who has access: Anyone
      Click Deploy → copy the Web App URL → paste above
      From the main app: 📊 Sync to Sheets button updates all pool data any time
    
    
      📊 3 sheets auto-created:

      • Scores — every bout with update-in-place (no duplicates)

      • Pools — full grid view with V/TS/TR/rankings

      • Standings — ranked fencer list per event

📱 HOW OFFICIALS SCORE ON THEIR PHONE

No app download needed

This is a self-contained HTML file. Officials just need a phone browser — Chrome, Safari, Firefox all work. No internet required after the file is shared.

Share the file with officials

Send via WhatsApp, email, or AirDrop. Use the 📤 Share button on the Dashboard. Officials receive the same file you're using right now.

💬 WhatsApp 📧 Email 📡 AirDrop 🔗 USB / Drive

Official opens file → adds #mobile to the URL

In their browser address bar, the URL ends with .html#mobile — this activates score-entry-only mode automatically.

file:///...lame-fencing.html#mobile

Enter PIN → Select pool → Score bouts

Officials see only their score entry screen. No access to tournament setup, fencer lists, or bracket management. Scores save instantly to localStorage.

Add to Home Screen (optional but recommended)

On iPhone: Safari → Share → Add to Home Screen. On Android: Chrome → ⋮ → Add to Home Screen. Launches fullscreen like a real app — no browser chrome.

🍎 iOS Safari 🤖 Android Chrome

QUICK SHARE TO OFFICIALS

🔐

Chief Referee PIN

Locks full app — only chief referee can access tournament management

🌐

Blogspot Integration

Host app · Live scores · Auto-publish results

BLOGSPOT URL

BLOGGER API KEY (for auto-publish)

BLOG ID (from Blogger Settings → Basic)

💡 How it works:
• 📡 Push Live Scores — Updates a live-scores post on your Blogspot every time you sync. Spectators visit your Blogspot to see current standings.
• 📰 Publish Results — Creates a formatted results post with medal table, pool standings, and knockout results.
• Blogger API Key — Free from Google Cloud Console. Needed only for auto-publishing.

Attendance App Portal