Admin Panel
Louisville Cricket Club
Access via
yoursite.html#admin · Default password: cricket2026Incorrect password. Try again.
Admin Panel
Louisville Cricket Club
Not connected to Sheets
Content
- 🏠 Dashboard
- 🏆 Post Result
- 📰 News
- 📅 Schedule
- 📊 Standings
- 🎉 Events
- 🤝 Sponsors
- 🏟️ Leagues
- 👥 Board
- ⚙️ Settings
Setup
Dashboard
Post a Match Result
Quick Post Result — most common after-match task
All Results
| Date | Match | Score | W/L | MOM | Actions |
|---|
News Articles
Add New Article
All Articles
| Date | Title | Category | Actions |
|---|
Match Schedule
Add Match
All Fixtures
| Date | Match | Venue | Division | Actions |
|---|
Standings
Update standings after each round. NRR = (runs scored per over) − (runs conceded per over) across all matches.
Edit Standings Table
| Team | P | W | L | NR | Pts | NRR | Row Color | Del |
|---|
Events
Add Event
All Events
| Month | Day | Title | Type | Actions |
|---|
Sponsors
Add Sponsor
All Sponsors
| Name | Tier | Actions |
|---|
Leagues
Add League
All Leagues
| Name | Format | Status | Our Teams | Season | Actions |
|---|
Board of Directors
Add Board Member
Board Members
| Name | Role | Actions |
|---|
Settings
Google Sheets Integration
How to set up (5 minutes):
1. Create a Google Sheet with these tabs:
2. File → Share → Publish to web → Each sheet → CSV format → Publish
3. Copy the spreadsheet ID from the URL (the long string between
4. Paste it below and click Test Connection
1. Create a Google Sheet with these tabs:
News Schedule Results Standings Events Sponsors Board2. File → Share → Publish to web → Each sheet → CSV format → Publish
3. Copy the spreadsheet ID from the URL (the long string between
/d/ and /edit)4. Paste it below and click Test Connection
Expected column headers per sheet:
News:
Schedule:
Results:
Standings:
Events:
Sponsors:
Board:
Leagues:
News:
date, title, excerpt, category, iconSchedule:
date, time, league, team, home, away, venue, isHome (isHome = TRUE or FALSE)Results:
date, league, team, home, hScore, away, aScore, won, mom (won = TRUE or FALSE)Standings:
team, league, p, w, l, nr, pts, nrr, cls (cls = pos-1, pos-2, pos-rel, or blank)Events:
mo, dy, title, desc, badge, lblSponsors:
name, tier (tier = platinum/gold/silver/bronze)Board:
name, roleLeagues:
name, format, status, ourTeams, season, startDate, endDate, description, link1Label, link1Url, link2Label, link2Url
Club Configuration
Apps Script URL Auto-sync to Sheets
Once set, every save in the Admin Panel automatically updates your Google Sheet. See the
louisville-cricket-apps-script.gs file for setup instructions.Change Admin Password
Data Management
Export JSON = full backup. Export CSV = copy data into your Google Sheet tabs. Clear local data = revert to hardcoded defaults.