Org System
Club setup
Set your club’s vocabulary once — what a team is called, how the club divides, what the ranks are. It changes everywhere.
A kit fills in the names below and replaces the points catalog with one that suits that kind of club. Everything stays editable afterwards.
Names
How the club divides
Tracks
Members who pick the no-preference option are the flexible ones: the draft uses them to even out lopsided teams, and the Cup gives them the exploration bonus. Keep that option on your form.
Membership
Personality types
Members of this club see these colours on arrival. They can still switch to the plain dark or light themes for themselves.
One test for the whole club, so everyone is answering the same instrument. This link is shown wherever a type is asked for.
Plenty of clubs will want this off. With it off the draft still balances size, division and tenure, the Assistant drops its type advice, and no one is asked to hand over a personality result.
Roster source
A published-CSV link or a shared Google Sheet URL. Re-pulls on demand, so late sign-ups get picked up by hitting Refresh.
File → Download → Comma-separated values, then drop it here. Read in your browser, uploaded nowhere.
Paste rows straight from a spreadsheet: Name, Year, Track, MBTI, Lead. Headers are detected automatically.
The club’s sign-up form
The sign-up form's questions
Edit the club's own form here. Changes go straight to the live form — anyone who opens the link next sees them.
What the sign-up form has to ask
- Name — full name, one per member. Required.
- Email — leave it off any published tab.
- Year in the club — first year, or second and up. Club tenure, not academic standing. Required.
- Which division they lean toward — one option per track, plus either / no preference. Keep that last option: undecided members are what let the sort even out lopsided groups.
- MBTI type — four letters. Only if you switched it on under Club setup. Make it required and link one specific free test, or leave it off entirely.
- Leadership interest — yes/no. The draft spreads volunteers across teams.
- Anything the draft should know — optional free text. Members with a note get flagged.
Raw Google Form exports work as they are. Nothing needs reformatting.
Connecting your Google Sheet
This runs in your browser. To read a sheet directly, it has to be readable without a login.
Option A — publish just the responses
- In the response sheet, make a tab with only what the draft needs: name, year, track, MBTI, lead interest, notes. Leave emails out.
- File → Share → Publish to web, choose that tab, format CSV, Publish.
- Paste the link below.
- Unpublish when the draft is done.
Option B — link sharing
Set the sheet to Anyone with the link → Viewer and paste the normal URL.
Publishing a tab makes it readable by anyone with the link. Keep contact details off it, and unpublish when you are done — or use CSV upload, where the file never leaves your computer.
Who has signed up
Everyone with an account in this club. It fills itself as people join — this is not the draft.
The club’s form and sheet
The form members fill in and the spreadsheet its answers land in.
Clear this club’s data
Removes the roster, points and attendance for this club. Accounts and setup stay. It cannot be undone.
Take attendance
Pick the event, check who showed up, log it. Standings update immediately.
What earns points
What each action is worth. Your points update automatically as attendance is logged.
Edit anything here and standings recalculate immediately. The track setting is what makes cross-track attendance detectable, so set it honestly.
Bonuses that sit on top
Applied automatically to any action tagged with a track.
Log points
Pick the action, paste the names, add.
A CSV with a name column and an event column. Unmatched events are assigned by hand.
A published-CSV link or shared sheet URL. Refresh after each event.
Standings
Ranked on points per member, so team size does not decide the Cup.
Log
Recommended changes
Swaps that improve type balance only. Every trade is between two people of the same year, track and Lead status, so nothing else moves.
Club sign-up form
Your club's own form, filled in here. Your name and email are already in.
What is on
Set an assignment
Assignments
Who can do what
Member sees standings, their own team and their own points. Admin runs the club. Master is you — everything an admin can do, plus this page.
Anyone not on this list is a member. Add an officer by the exact Google address they sign in with.
Current roles
Clubs on this system
Each club is separate — roster, teams, points and officers. Signing up needs the club’s join code.
Treat the join code like a door code. Edit issues a new one. Clear data empties a club for a new semester; Delete removes it entirely.
Which club am I looking at?
Switching reloads the roster, points and setup for that club.
Everyone who has signed up
Every account on the system and the club it belongs to. Credentials are never shown.
Password accounts
For members who cannot use a Google account. Weaker than Google sign-in — give each person their own, never a shared login.
Set a starting password and have them change it once they are in.
What this actually protects
Hiding a button is not security, so the page does not rely on it. Every write carries the signed token Google issued to whoever is holding the page, and the Apps Script verifies that signature and re-checks the role before it touches the sheet. A member who edits the page in their browser can rearrange what they see; the shared sheet will still refuse them.