Leaderboard

function updateLeaderboard() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const dataSheet = ss.getSheetByName(“Team Scorecard”);
const leaderboardSheet = ss.getSheetByName(“Leaderboard”) || ss.insertSheet(“Leaderboard”);

// Clear leaderboard
leaderboardSheet.clear();
leaderboardSheet.appendRow([“Team”, “Total Points”]);

// Get data
const data = dataSheet.getRange(“A2:F21”).getValues();
const teamScores = {};

data.forEach(row => {
const team = row[0];
const points = Number(row[5]);
if (team) {
teamScores[team] = (teamScores[team] || 0) + points;
}
});

// Write leaderboard
Object.entries(teamScores).forEach(([team, score]) => {
leaderboardSheet.appendRow([team, score]);
});
}