Org System
Club setup
Set your club’s vocabulary once — what a team is called and how the club divides. 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
There are no member titles. Everyone is a Member; the only split shown next to a name is the year above.
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
Everyone who signed in with Google and filled in the onboarding form — year, track, MBTI and availability come from their answers. This is the usual way to form Orgs: no export, nothing to paste.
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. 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 — 1st year or 2nd year. Required. This is the only thing shown next to a name; there are no titles.
- Track — Consulting, Case competition (FLC) or Polaris, plus not sure yet. 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.
- Availability — when they are usually free. Shown to officers next to the name when forming 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, availability, 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.
Build a team
Consulting: one team per client, two PMs, about 10–12 consultants split into initiatives. FLC: up to 4 members, up to 3 teams per event. A member can be on one consulting team and one FLC team, and sees both here.
Take attendance
Pick the event, check who showed up, log it. Each person’s commitment log updates at once.
Who was absent
Everyone on the roster who was not checked in. Look at one meeting, or across a stretch of dates to see who has missed the most.
Org Cups
An Org earns a cup every time at least 80% of its members hand an assignment in on time, and EBOD awards cups for things like bootcamp turnout. There is no leaderboard: cups are something an Org collects together, not a ranking. Your own commitment points are a private record on your Profile.
Award a cup
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 and track, so nothing else moves.
Club sign-up form
Your club's own form, filled in here. Your name and email are already in.
Add it to your home screen
One more step: put the Org System on your phone’s home screen, so it opens like an app instead of a link you have to find. It takes about 15 seconds.
What is on
Set an assignment
Give it a due date: an Org earns a cup when 80% of its members hand it in on time. Below each assignment you see who has handed in, who was late and who has not yet.
Homework tracks
Every member is tagged consulting or case comp, and only sees homework set for their track (or for both). Members drafted into either track start on it; Polaris and undecided members need a pick. Until they have one they see both kinds.
Member Drive folders
Every member has a folder in the club's Drive (the PBL account's “member folders”) with a subfolder for each assignment set for them, and what they hand in is filed there. The folders are for officers and are not shared with members. The usual “handed in” folders still get a shortcut to each file. A member's folder is made the first time they open the app; this button does everyone at once. New assignments are added to everyone's folder a few seconds after you set them.
Homework alerts
An email listing what members handed in, at most one every 10 minutes, with who, which assignment, on time or late, and a link to the file. Members never see these addresses.
Phone notifications
A notification on your phone when homework is posted for you, the evening before it is due if you have not handed it in, and when your hand-in arrives.
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.