Welcome to your premium, fully self-contained local spreadsheet dashboard. This application runs 100% locally in your web browser with no server required.
🔄 Data Orientation Detection
Toastmasters agendas and club spreadsheets are frequently built in Transposed Layout (where columns represent meetings and rows represent roles). The dashboard silently auto-detects this layout, transposes the data matrix, and maps names into roles automatically.
- Standard Layout: Row 1 holds the columns headers (e.g. Date, Toastmaster, Grammarian). Each row under it is a meeting.
- Transposed Layout: Column 1 contains role labels (e.g. Toastmaster, Timer). Columns 2 and beyond are meetings.
🏷️ Toastmasters Schema Mapping
Once detected, columns are grouped into categories to provide targeted insights:
- Speakers: Speech #1, Speech #2, Speech #3
- Evaluators: Speech Evaluators 1-3, General Evaluator
- Facilitators: Toastmaster, Topics Master, Topics Evaluator
- Support Roles: Grammarian, Um & Ah Counter, Timer
🚀 Setting Up a Desktop Launcher
To run this tool like a native desktop app, configure a shortcut depending on your OS:
Windows (.bat Launcher):
@echo off
start "" "chrome.exe" --app="%~dp0toastmasters_dashboard.html"
Save this text as launch.bat in the same folder as this file and double-click to open in a clean frameless app window.
macOS (Webloc or Automator):
- Drag the file URL from your browser address bar onto your desktop to create a
.webloc file.
- Or, open Automator, create an App, add a Run Shell Script action, and enter:
open -a "Google Chrome" --args --app="file:///path/to/toastmasters_dashboard.html".
Linux (.desktop Launcher):
[Desktop Entry]
Type=Application
Name=Toastmasters Dashboard
Exec=google-chrome --app=file:///path/to/toastmasters_dashboard.html
Icon=utilities-terminal
Terminal=false