]> git.sesse.net Git - pkanalytics/blobdiff - ultimate.js
Make more CIs for globals.
[pkanalytics] / ultimate.js
index 0c44658adcdd30a1b99ca2b45b696e5c2600aa12..04e9bad802479d3a2a44566eb937c0a3572931f3 100644 (file)
@@ -11,6 +11,17 @@ fetch('ultimate.json')
    .then(response => response.json())
    .then(response => { global_json = response; process_matches(global_json, global_filters); });
 
+function format_time(t)
+{
+       const ms = t % 1000 + '';
+       t = Math.floor(t / 1000);
+       const sec = t % 60 + '';
+       t = Math.floor(t / 60);
+       const min = t % 60 + '';
+       const hour = Math.floor(t / 60) + '';
+       return hour + ':' + min.padStart(2, '0') + ':' + sec.padStart(2, '0') + '.' + ms.padStart(3, '0');
+}
+
 function attribute_player_time(player, to, from, offense) {
        let delta_time;
        if (player.on_field_since > from) {
@@ -27,14 +38,16 @@ function attribute_player_time(player, to, from, offense) {
        }
 }
 
-function take_off_field(player, t, live_since, offense) {
-       if (live_since === null) {
-               // Play isn't live, so nothing to do.
-       } else {
-               attribute_player_time(player, t, live_since, offense);
-       }
-       if (player.on_field_since !== null) {  // Just a safeguard; out without in should never happen.
-               player.field_time_ms += t - player.on_field_since;
+function take_off_field(player, t, live_since, offense, keep) {
+       if (keep) {
+               if (live_since === null) {
+                       // Play isn't live, so nothing to do.
+               } else {
+                       attribute_player_time(player, t, live_since, offense);
+               }
+               if (player.on_field_since !== null) {  // Just a safeguard; out without in should never happen.
+                       player.field_time_ms += t - player.on_field_since;
+               }
        }
        player.on_field_since = null;
 }
@@ -47,7 +60,17 @@ function add_cell(tr, element_type, text) {
 }
 
 function add_th(tr, text, colspan) {
-       let element = add_cell(tr, 'th', text);
+       let element = document.createElement('th');
+       let link = document.createElement('a');
+       link.style.cursor = 'pointer';
+       link.addEventListener('click', (e) => {
+               sort_by(element);
+               process_matches(global_json, global_filters);
+       });
+       link.textContent = text;
+       element.appendChild(link);
+       tr.appendChild(element);
+
        if (colspan > 0) {
                element.setAttribute('colspan', colspan);
        } else {
@@ -152,6 +175,7 @@ function process_matches(json, filters) {
        for (const player of json['players']) {
                players[player['player_id']] = {
                        'name': player['name'],
+                       'gender': player['gender'],
                        'number': player['number'],
 
                        'goals': 0,
@@ -162,9 +186,11 @@ function process_matches(json, filters) {
                        'num_throws': 0,
                        'throwaways': 0,
                        'drops': 0,
+                       'was_ds': 0,
+                       'stallouts': 0,
 
                        'defenses': 0,
-                       'interceptions': 0,
+                       'callahans': 0,
                        'points_played': 0,
                        'playing_time_ms': 0,
                        'offensive_playing_time_ms': 0,
@@ -215,6 +241,7 @@ function process_matches(json, filters) {
                let our_score = 0;
                let their_score = 0;
                let handler = null;
+               let handler_got_by_interception = false;  // Only relevant if handler !== null.
                let prev_handler = null;
                let live_since = null;
                let offense = null;  // True/false/null (unknown).
@@ -224,30 +251,69 @@ function process_matches(json, filters) {
                let point_num = 0;
                let game_started = null;
                let last_goal = null;
+
+               // The last used formations of the given kind, if any; they may be reused
+               // when the point starts, if nothing else is set.
+               let last_offensive_formation = null;
+               let last_defensive_formation = null;
+
+               // Formations we've set, but haven't really had the chance to use yet
+               // (e.g., we get a “use zone defense” event while we're still on offense).
+               let pending_offensive_formation = null;
+               let pending_defensive_formation = null;
+
+               // Formations that we have played at least once this point, after all
+               // heuristics and similar.
+               let formations_used_this_point = new Set();
+
                for (const [q,p] of Object.entries(players)) {
                        p.on_field_since = null;
                        p.last_point_seen = null;
                }
                for (const e of match['events']) {
-                       // TODO: filter events
-
                        let t = e['t'];
                        let type = e['type'];
                        let p = players[e['player']];
 
                        // Sub management
+                       let keep = keep_event(players, formations_used_this_point, last_pull_was_ours, filters);
                        if (type === 'in' && p.on_field_since === null) {
                                p.on_field_since = t;
+                               if (!keep && keep_event(players, formations_used_this_point, last_pull_was_ours, filters)) {
+                                       // A player needed for the filters went onto the field,
+                                       // so pretend people walked on right now (to start their
+                                       // counting time).
+                                       for (const [q,p2] of Object.entries(players)) {
+                                               if (p2.on_field_since !== null) {
+                                                       p2.on_field_since = t;
+                                               }
+                                       }
+                               }
                        } else if (type === 'out') {
-                               take_off_field(p, t, live_since, offense);
+                               take_off_field(p, t, live_since, offense, keep);
+                               if (keep && !keep_event(players, formations_used_this_point, last_pull_was_ours, filters)) {
+                                       // A player needed for the filters went off the field,
+                                       // so we need to attribute time for all the others.
+                                       // Pretend they walked off and then immediately on again.
+                                       //
+                                       // TODO: We also need to take care of this to get the globals right.
+                                       for (const [q,p2] of Object.entries(players)) {
+                                               if (p2.on_field_since !== null) {
+                                                       take_off_field(p2, t, live_since, offense, keep);
+                                                       p2.on_field_since = t;
+                                               }
+                                       }
+                               }
                        }
 
+                       keep = keep_event(players, formations_used_this_point, last_pull_was_ours, filters);  // Recompute after in/out.
+
                        // Liveness management
                        if (type === 'pull' || type === 'their_pull' || type === 'restart') {
                                live_since = t;
                        } else if (type === 'catch' && last_pull_was_ours === null) {
                                // Someone forgot to add the pull, so we'll need to wing it.
-                               console.log('Missing pull on ' + our_score + '\u2013' + their_score + ' in ' + match['description'] + '; pretending to have one.');
+                               console.log(match['description'] + ' ' + format_time(t) + ': Missing pull on ' + our_score + '\u2013' + their_score + '; pretending to have one.');
                                live_since = t;
                                last_pull_was_ours = !offense;
                        } else if (type === 'goal' || type === 'their_goal' || type === 'stoppage') {
@@ -256,51 +322,57 @@ function process_matches(json, filters) {
                                                continue;
                                        }
                                        if (type !== 'stoppage' && p.last_point_seen !== point_num) {
-                                               // In case the player did nothing this point,
-                                               // not even subbing in.
-                                               p.last_point_seen = point_num;
-                                               ++p.points_played;
+                                               if (keep) {
+                                                       // In case the player did nothing this point,
+                                                       // not even subbing in.
+                                                       p.last_point_seen = point_num;
+                                                       ++p.points_played;
+                                               }
                                        }
-                                       attribute_player_time(p, t, live_since, offense);
+                                       if (keep) attribute_player_time(p, t, live_since, offense);
 
                                        if (type !== 'stoppage') {
+                                               if (keep) {
+                                                       if (last_pull_was_ours === true) {  // D point.
+                                                               ++p.defensive_points_completed;
+                                                               if (type === 'goal') {
+                                                                       ++p.defensive_points_won;
+                                                               }
+                                                       } else if (last_pull_was_ours === false) {  // O point.
+                                                               ++p.offensive_points_completed;
+                                                               if (type === 'goal') {
+                                                                       ++p.offensive_points_won;
+                                                               }
+                                                       }
+                                               }
+                                       }
+                               }
+
+                               if (keep) {
+                                       if (type !== 'stoppage') {
+                                               // Update globals.
+                                               ++globals.points_played;
                                                if (last_pull_was_ours === true) {  // D point.
-                                                       ++p.defensive_points_completed;
+                                                       ++globals.defensive_points_completed;
                                                        if (type === 'goal') {
-                                                               ++p.defensive_points_won;
+                                                               ++globals.defensive_points_won;
                                                        }
                                                } else if (last_pull_was_ours === false) {  // O point.
-                                                       ++p.offensive_points_completed;
+                                                       ++globals.offensive_points_completed;
                                                        if (type === 'goal') {
-                                                               ++p.offensive_points_won;
+                                                               ++globals.offensive_points_won;
                                                        }
                                                }
                                        }
-                               }
-
-                               if (type !== 'stoppage') {
-                                       // Update globals.
-                                       ++globals.points_played;
-                                       if (last_pull_was_ours === true) {  // D point.
-                                               ++globals.defensive_points_completed;
-                                               if (type === 'goal') {
-                                                       ++globals.defensive_points_won;
-                                               }
-                                       } else if (last_pull_was_ours === false) {  // O point.
-                                               ++globals.offensive_points_completed;
-                                               if (type === 'goal') {
-                                                       ++globals.offensive_points_won;
+                                       if (live_since !== null) {
+                                               globals.playing_time_ms += t - live_since;
+                                               if (offense === true) {
+                                                       globals.offensive_playing_time_ms += t - live_since;
+                                               } else if (offense === false) {
+                                                       globals.defensive_playing_time_ms += t - live_since;
                                                }
                                        }
                                }
-                               if (live_since !== null) {
-                                       globals.playing_time_ms += t - live_since;
-                                       if (offense === true) {
-                                               globals.offensive_playing_time_ms += t - live_since;
-                                       } else if (offense === false) {
-                                               globals.defensive_playing_time_ms += t - live_since;
-                                       }
-                               }
 
                                live_since = null;
                        }
@@ -314,8 +386,10 @@ function process_matches(json, filters) {
 
                        // Point count management
                        if (p !== undefined && type !== 'out' && p.last_point_seen !== point_num) {
-                               p.last_point_seen = point_num;
-                               ++p.points_played;
+                               if (keep) {
+                                       p.last_point_seen = point_num;
+                                       ++p.points_played;
+                               }
                        }
                        if (type === 'goal' || type === 'their_goal') {
                                ++point_num;
@@ -329,13 +403,13 @@ function process_matches(json, filters) {
                        if (type === 'pull') {
                                puller = e['player'];
                                pull_started = t;
-                               ++p.pulls;
+                               if (keep) ++p.pulls;
                        } else if (type === 'in' || type === 'out' || type === 'stoppage' || type === 'restart' || type === 'unknown' || type === 'set_defense' || type === 'set_offense') {
                                // No effect on pull.
                        } else if (type === 'pull_landed' && puller !== null) {
-                               players[puller].pull_times.push(t - pull_started);
+                               if (keep) players[puller].pull_times.push(t - pull_started);
                        } else if (type === 'pull_oob' && puller !== null) {
-                               ++players[puller].oob_pulls;
+                               if (keep) ++players[puller].oob_pulls;
                        } else {
                                // Not pulling (if there was one, we never recorded its outcome, but still count it).
                                puller = pull_started = null;
@@ -343,7 +417,7 @@ function process_matches(json, filters) {
 
                        // Offense/defense management
                        let last_offense = offense;
-                       if (type === 'set_defense' || type === 'goal' || type === 'throwaway' || type === 'drop') {
+                       if (type === 'set_defense' || type === 'goal' || type === 'throwaway' || type === 'drop' || type === 'was_d' || type === 'stallout') {
                                offense = false;
                        } else if (type === 'set_offense' || type === 'their_goal' || type === 'their_throwaway' || type === 'defense' || type === 'interception') {
                                offense = true;
@@ -351,17 +425,19 @@ function process_matches(json, filters) {
                        if (last_offense !== offense && live_since !== null) {
                                // Switched offense/defense status, so attribute this drive as needed,
                                // and update live_since to take that into account.
-                               for (const [q,p] of Object.entries(players)) {
-                                       if (p.on_field_since === null) {
-                                               continue;
+                               if (keep) {
+                                       for (const [q,p] of Object.entries(players)) {
+                                               if (p.on_field_since === null) {
+                                                       continue;
+                                               }
+                                               attribute_player_time(p, t, live_since, last_offense);
+                                       }
+                                       globals.playing_time_ms += t - live_since;
+                                       if (offense === true) {
+                                               globals.offensive_playing_time_ms += t - live_since;
+                                       } else if (offense === false) {
+                                               globals.defensive_playing_time_ms += t - live_since;
                                        }
-                                       attribute_player_time(p, t, live_since, last_offense);
-                               }
-                               globals.playing_time_ms += t - live_since;
-                               if (offense === true) {
-                                       globals.offensive_playing_time_ms += t - live_since;
-                               } else if (offense === false) {
-                                       globals.defensive_playing_time_ms += t - live_since;
                                }
                                live_since = t;
                        }
@@ -386,70 +462,149 @@ function process_matches(json, filters) {
                                last_pull_was_ours = null;
                        }
 
+                       // Formation management
+                       if (type === 'formation_offense' || type === 'formation_defense') {
+                               let id = e.formation === null ? 0 : e.formation;
+                               let for_offense = (type === 'formation_offense');
+                               if (offense === for_offense) {
+                                       formations_used_this_point.add(id);
+                               } else if (for_offense) {
+                                       pending_offensive_formation = id;
+                               } else {
+                                       pending_defensive_formation = id;
+                               }
+                               if (for_offense) {
+                                       last_offensive_formation = id;
+                               } else {
+                                       last_defensive_formation = id;
+                               }
+                       } else if (last_offense !== offense) {
+                               if (offense === true && pending_offensive_formation !== null) {
+                                       formations_used_this_point.add(pending_offensive_formation);
+                                       pending_offensive_formation = null;
+                               } else if (offense === false && pending_defensive_formation !== null) {
+                                       formations_used_this_point.add(pending_defensive_formation);
+                                       pending_defensive_formation = null;
+                               } else if (offense === true && last_defensive_formation !== null) {
+                                       if (should_reuse_last_formation(match['events'], t)) {
+                                               formations_used_this_point.add(last_defensive_formation);
+                                       }
+                               } else if (offense === false && last_offensive_formation !== null) {
+                                       if (should_reuse_last_formation(match['events'], t)) {
+                                               formations_used_this_point.add(last_offensive_formation);
+                                       }
+                               }
+                       }
+
+                       if (type !== 'out' && type !== 'in' && p !== undefined && p.on_field_since === null) {
+                               console.log(match['description'] + ' ' + format_time(t) + ': Event “' + type + '” on subbed-out player ' + p.name);
+                       }
+                       if (type === 'catch' && handler !== null && players[handler].on_field_since === null) {
+                               // The handler subbed out and was replaced with another handler,
+                               // so this wasn't a pass.
+                               handler = null;
+                       }
+
                        // Event management
-                       if (type === 'catch' || type === 'goal') {
+                       if (type === 'goal' && handler === e['player'] && handler_got_by_interception) {
+                               // Self-pass to goal after an interception; this is not a real pass,
+                               // just how we represent a Callahan right now -- so don't
+                               // count the throw, any assists or similar.
+                               //
+                               // It's an open question how we should handle a self-pass that is
+                               // _not_ after an interception, or a self-pass that's not a goal.
+                               // (It must mean we tipped off someone.) We'll count it as a regular one
+                               // for the time being, although it will make hockey assists weird.
+                               ++p.goals;
+                               ++p.callahans;
+                               handler = prev_handler = null;
+                       } else if (type === 'catch' || type === 'goal') {
                                if (handler !== null) {
-                                       ++players[handler].num_throws;
-                                       ++p.catches;
+                                       if (keep) {
+                                               ++players[handler].num_throws;
+                                               ++p.catches;
+                                       }
                                }
 
-                               ++p.touches;
+                               if (keep) ++p.touches;
                                if (type === 'goal') {
-                                       if (prev_handler !== null) {
-                                               ++players[prev_handler].hockey_assists;
-                                       }
-                                       if (handler !== null) {
-                                               ++players[handler].assists;
+                                       if (keep) {
+                                               if (prev_handler !== null) {
+                                                       ++players[prev_handler].hockey_assists;
+                                               }
+                                               if (handler !== null) {
+                                                       ++players[handler].assists;
+                                               }
+                                               ++p.goals;
                                        }
-                                       ++p.goals;
                                        handler = prev_handler = null;
                                } else {
                                        // Update hold history.
                                        prev_handler = handler;
                                        handler = e['player'];
+                                       handler_got_by_interception = false;
                                }
                        } else if (type === 'throwaway') {
-                               ++p.num_throws;
-                               ++p.throwaways;
+                               if (keep) {
+                                       ++p.num_throws;
+                                       ++p.throwaways;
+                               }
                                handler = prev_handler = null;
                        } else if (type === 'drop') {
-                               ++p.drops;
+                               if (keep) ++p.drops;
+                               handler = prev_handler = null;
+                       } else if (type === 'stallout') {
+                               if (keep) ++p.stallouts;
+                               handler = prev_handler = null;
+                       } else if (type === 'was_d') {
+                               if (keep) ++p.was_ds;
                                handler = prev_handler = null;
                        } else if (type === 'defense') {
-                               ++p.defenses;
+                               if (keep) ++p.defenses;
                        } else if (type === 'interception') {
-                               ++p.interceptions;
-                               ++p.defenses;
-                               ++p.touches;
+                               if (keep) {
+                                       ++p.catches;
+                                       ++p.defenses;
+                                       ++p.touches;
+                               }
                                prev_handler = null;
                                handler = e['player'];
+                               handler_got_by_interception = true;
                        } else if (type === 'offensive_soft_plus' || type === 'offensive_soft_minus' || type === 'defensive_soft_plus' || type === 'defensive_soft_minus') {
-                               ++p[type];
+                               if (keep) ++p[type];
                        } else if (type !== 'in' && type !== 'out' && type !== 'pull' &&
                                   type !== 'their_goal' && type !== 'stoppage' && type !== 'restart' && type !== 'unknown' &&
                                   type !== 'set_defense' && type !== 'goal' && type !== 'throwaway' &&
-                                  type !== 'drop' && type !== 'set_offense' && type !== 'their_goal' &&
+                                  type !== 'drop' && type !== 'was_d' && type !== 'stallout' && type !== 'set_offense' && type !== 'their_goal' &&
                                   type !== 'pull' && type !== 'pull_landed' && type !== 'pull_oob' && type !== 'their_pull' &&
-                                  type !== 'their_throwaway' && type !== 'defense' && type !== 'interception') {
-                               console.log("Unknown event:", e);
+                                  type !== 'their_throwaway' && type !== 'defense' && type !== 'interception' &&
+                                  type !== 'formation_offense' && type !== 'formation_defense') {
+                               console.log(format_time(t) + ": Unknown event “" + e + "”");
+                       }
+
+                       if (type === 'goal' || type === 'their_goal') {
+                               formations_used_this_point.clear();
                        }
                }
 
                // Add field time for all players still left at match end.
-               for (const [q,p] of Object.entries(players)) {
-                       if (p.on_field_since !== null && last_goal !== null) {
-                               p.field_time_ms += last_goal - p.on_field_since;
+               const keep = keep_event(players, formations_used_this_point, last_pull_was_ours, filters);
+               if (keep) {
+                       for (const [q,p] of Object.entries(players)) {
+                               if (p.on_field_since !== null && last_goal !== null) {
+                                       p.field_time_ms += last_goal - p.on_field_since;
+                               }
                        }
-               }
-               if (game_started !== null && last_goal !== null) {
-                       globals.field_time_ms += last_goal - game_started;
-               }
-               if (live_since !== null && last_goal !== null) {
-                       globals.playing_time_ms += last_goal - live_since;
-                       if (offense === true) {
-                               globals.offensive_playing_time_ms += last_goal - live_since;
-                       } else if (offense === false) {
-                               globals.defensive_playing_time_ms += last_goal - live_since;
+                       if (game_started !== null && last_goal !== null) {
+                               globals.field_time_ms += last_goal - game_started;
+                       }
+                       if (live_since !== null && last_goal !== null) {
+                               globals.playing_time_ms += last_goal - live_since;
+                               if (offense === true) {
+                                       globals.offensive_playing_time_ms += last_goal - live_since;
+                               } else if (offense === false) {
+                                       globals.defensive_playing_time_ms += last_goal - live_since;
+                               }
                        }
                }
        }
@@ -624,19 +779,20 @@ function make_table_general(players) {
                rows.push(header);
        }
 
-       for (const [q,p] of Object.entries(players)) {
+       for (const [q,p] of get_sorted_players(players)) {
                if (q === 'globals') continue;
                let row = document.createElement('tr');
-               let pm = p.goals + p.assists + p.hockey_assists + p.defenses - p.throwaways - p.drops;
+               let pm = p.goals + p.assists + p.hockey_assists + p.defenses - p.throwaways - p.drops - p.was_ds - p.stallouts;
                let soft_pm = p.offensive_soft_plus + p.defensive_soft_plus - p.offensive_soft_minus - p.defensive_soft_minus;
                let o_efficiency = make_efficiency_ci(p.offensive_points_won, p.offensive_points_completed, z);
                let d_efficiency = make_efficiency_ci(p.defensive_points_won, p.defensive_points_completed, z);
-               add_3cell(row, p.name, 'name');  // TODO: number?
+               let name = add_3cell(row, p.name, 'name');  // TODO: number?
                add_3cell(row, pm > 0 ? ('+' + pm) : pm);
                add_3cell(row, soft_pm > 0 ? ('+' + soft_pm) : soft_pm);
                add_3cell_ci(row, o_efficiency);
                add_3cell_ci(row, d_efficiency);
                add_3cell(row, p.points_played);
+               row.dataset.player = q;
                rows.push(row);
        }
 
@@ -669,19 +825,24 @@ function make_table_offense(players) {
                add_th(header, '%OK');
                add_th(header, 'Catches');
                add_th(header, 'Drops');
+               add_th(header, 'D-ed');
                add_th(header, '%OK');
+               add_th(header, 'Stalls');
                add_th(header, 'Soft +/-', 6);
                rows.push(header);
        }
 
+       let goals = 0;
        let num_throws = 0;
        let throwaways = 0;
        let catches = 0;
        let drops = 0;
-       for (const [q,p] of Object.entries(players)) {
+       let was_ds = 0;
+       let stallouts = 0;
+       for (const [q,p] of get_sorted_players(players)) {
                if (q === 'globals') continue;
                let throw_ok = make_binomial_ci(p.num_throws - p.throwaways, p.num_throws, z);
-               let catch_ok = make_binomial_ci(p.catches, p.catches + p.drops, z);
+               let catch_ok = make_binomial_ci(p.catches, p.catches + p.drops + p.was_ds, z);
 
                throw_ok.format = 'percentage';
                catch_ok.format = 'percentage';
@@ -700,20 +861,26 @@ function make_table_offense(players) {
                add_3cell_ci(row, throw_ok);
                add_3cell(row, p.catches);
                add_3cell(row, p.drops);
+               add_3cell(row, p.was_ds);
                add_3cell_ci(row, catch_ok);
+               add_3cell(row, p.stallouts);
                add_3cell(row, '+' + p.offensive_soft_plus);
                add_3cell(row, '-' + p.offensive_soft_minus);
+               row.dataset.player = q;
                rows.push(row);
 
+               goals += p.goals;
                num_throws += p.num_throws;
                throwaways += p.throwaways;
                catches += p.catches;
                drops += p.drops;
+               was_ds += p.was_ds;
+               stallouts += p.stallouts;
        }
 
        // Globals.
        let throw_ok = make_binomial_ci(num_throws - throwaways, num_throws, z);
-       let catch_ok = make_binomial_ci(catches, catches + drops, z);
+       let catch_ok = make_binomial_ci(catches, catches + drops + was_ds, z);
        throw_ok.format = 'percentage';
        catch_ok.format = 'percentage';
        throw_ok.desired = 0.9;
@@ -721,7 +888,7 @@ function make_table_offense(players) {
 
        let row = document.createElement('tr');
        add_3cell(row, '');
-       add_3cell(row, '');
+       add_3cell(row, goals);
        add_3cell(row, '');
        add_3cell(row, '');
        add_3cell(row, num_throws);
@@ -729,7 +896,9 @@ function make_table_offense(players) {
        add_3cell_ci(row, throw_ok);
        add_3cell(row, catches);
        add_3cell(row, drops);
+       add_3cell(row, was_ds);
        add_3cell_ci(row, catch_ok);
+       add_3cell(row, stallouts);
        add_3cell(row, '');
        add_3cell(row, '');
        rows.push(row);
@@ -747,16 +916,24 @@ function make_table_defense(players) {
                add_th(header, 'OOB pulls');
                add_th(header, 'OOB%');
                add_th(header, 'Avg. hang time (IB)');
+               add_th(header, 'Callahans');
                add_th(header, 'Soft +/-', 6);
                rows.push(header);
        }
-       for (const [q,p] of Object.entries(players)) {
+
+       let defenses = 0;
+       let pulls = 0;
+       let oob_pulls = 0;
+       let sum_sum_time = 0;
+       let callahans = 0;
+
+       for (const [q,p] of get_sorted_players(players)) {
                if (q === 'globals') continue;
                let sum_time = 0;
                for (const t of p.pull_times) {
                        sum_time += t;
                }
-               let avg_time = 1e-3 * sum_time / p.pulls;
+               let avg_time = 1e-3 * sum_time / (p.pulls - p.oob_pulls);
                let oob_pct = 100 * p.oob_pulls / p.pulls;
 
                let ci_oob = make_binomial_ci(p.oob_pulls, p.pulls, z);
@@ -775,10 +952,44 @@ function make_table_defense(players) {
                } else {
                        add_3cell(row, 'N/A');
                }
+               add_3cell(row, p.callahans);
                add_3cell(row, '+' + p.defensive_soft_plus);
                add_3cell(row, '-' + p.defensive_soft_minus);
+               row.dataset.player = q;
                rows.push(row);
+
+               defenses += p.defenses;
+               pulls += p.pulls;
+               oob_pulls += p.oob_pulls;
+               sum_sum_time += sum_time;
+               callahans += p.callahans;
+       }
+
+       // Globals.
+       let ci_oob = make_binomial_ci(oob_pulls, pulls, z);
+       ci_oob.format = 'percentage';
+       ci_oob.desired = 0.2;  // Arbitrary.
+       ci_oob.inverted = true;
+
+       let avg_time = 1e-3 * sum_sum_time / (pulls - oob_pulls);
+       let oob_pct = 100 * oob_pulls / pulls;
+
+       let row = document.createElement('tr');
+       add_3cell(row, '');
+       add_3cell(row, defenses);
+       add_3cell(row, pulls);
+       add_3cell(row, oob_pulls);
+       add_3cell_ci(row, ci_oob);
+       if (pulls > oob_pulls) {
+               add_3cell(row, avg_time.toFixed(1) + ' sec');
+       } else {
+               add_3cell(row, 'N/A');
        }
+       add_3cell(row, callahans);
+       add_3cell(row, '');
+       add_3cell(row, '');
+       rows.push(row);
+
        return rows;
 }
 
@@ -797,7 +1008,7 @@ function make_table_playing_time(players) {
                rows.push(header);
        }
 
-       for (const [q,p] of Object.entries(players)) {
+       for (const [q,p] of get_sorted_players(players)) {
                if (q === 'globals') continue;
                let row = document.createElement('tr');
                add_3cell(row, p.name, 'name');  // TODO: number?
@@ -808,6 +1019,7 @@ function make_table_playing_time(players) {
                add_3cell(row, Math.floor(p.field_time_ms / 60000) + ' min');
                add_3cell(row, p.offensive_points_completed);
                add_3cell(row, p.defensive_points_completed);
+               row.dataset.player = q;
                rows.push(row);
        }
 
@@ -837,7 +1049,7 @@ function make_table_per_point(players) {
                add_th(header, 'Hockey assists');
                add_th(header, 'Ds');
                add_th(header, 'Throwaways');
-               add_th(header, 'Drops');
+               add_th(header, 'Recv. errors');
                add_th(header, 'Touches');
                rows.push(header);
        }
@@ -847,9 +1059,9 @@ function make_table_per_point(players) {
        let hockey_assists = 0;
        let defenses = 0;
        let throwaways = 0;
-       let drops = 0;
+       let receiver_errors = 0;
        let touches = 0;
-       for (const [q,p] of Object.entries(players)) {
+       for (const [q,p] of get_sorted_players(players)) {
                if (q === 'globals') continue;
 
                // Can only happen once per point, so these are binomials.
@@ -868,12 +1080,13 @@ function make_table_per_point(players) {
                add_3cell_ci(row, ci_hockey_assists);
                add_3cell_ci(row, make_poisson_ci(p.defenses, p.points_played, z));
                add_3cell_ci(row, make_poisson_ci(p.throwaways, p.points_played, z, true));
-               add_3cell_ci(row, make_poisson_ci(p.drops, p.points_played, z, true));
+               add_3cell_ci(row, make_poisson_ci(p.drops + p.was_ds, p.points_played, z, true));
                if (p.points_played > 0) {
                        add_3cell(row, p.touches == 0 ? 0 : (p.touches / p.points_played).toFixed(2));
                } else {
                        add_3cell(row, 'N/A');
                }
+               row.dataset.player = q;
                rows.push(row);
 
                goals += p.goals;
@@ -881,7 +1094,7 @@ function make_table_per_point(players) {
                hockey_assists += p.hockey_assists;
                defenses += p.defenses;
                throwaways += p.throwaways;
-               drops += p.drops;
+               receiver_errors += p.drops + p.was_ds;
                touches += p.touches;
        }
 
@@ -890,12 +1103,21 @@ function make_table_per_point(players) {
        let row = document.createElement('tr');
        add_3cell(row, '');
        if (globals.points_played > 0) {
-               add_3cell_with_filler_ci(row, goals == 0 ? 0 : (goals / globals.points_played).toFixed(2));
-               add_3cell_with_filler_ci(row, assists == 0 ? 0 : (assists / globals.points_played).toFixed(2));
-               add_3cell_with_filler_ci(row, hockey_assists == 0 ? 0 : (hockey_assists / globals.points_played).toFixed(2));
-               add_3cell_with_filler_ci(row, defenses == 0 ? 0 : (defenses / globals.points_played).toFixed(2));
-               add_3cell_with_filler_ci(row, throwaways == 0 ? 0 : (throwaways / globals.points_played).toFixed(2));
-               add_3cell_with_filler_ci(row, drops == 0 ? 0 : (drops / globals.points_played).toFixed(2));
+               let ci_goals = make_binomial_ci(goals, globals.points_played, z);
+               let ci_assists = make_binomial_ci(assists, globals.points_played, z);
+               let ci_hockey_assists = make_binomial_ci(hockey_assists, globals.points_played, z);
+               ci_goals.desired = 0.5;
+               ci_assists.desired = 0.5;
+               ci_hockey_assists.desired = 0.5;
+
+               add_3cell_ci(row, ci_goals);
+               add_3cell_ci(row, ci_assists);
+               add_3cell_ci(row, ci_hockey_assists);
+
+               add_3cell_ci(row, make_poisson_ci(defenses, globals.points_played, z));
+               add_3cell_ci(row, make_poisson_ci(throwaways, globals.points_played, z, true));
+               add_3cell_ci(row, make_poisson_ci(receiver_errors, globals.points_played, z, true));
+
                add_3cell(row, touches == 0 ? 0 : (touches / globals.points_played).toFixed(2));
        } else {
                add_3cell_with_filler_ci(row, 'N/A');
@@ -925,13 +1147,16 @@ function open_filter_menu() {
        menu.style.left = rect.left + 'px';
        menu.style.top = (rect.bottom + 10) + 'px';
 
-       add_menu_item(menu, 0, 'match', 'Match (any)');
-       add_menu_item(menu, 1, 'player_any', 'Player on field (any)');
-       add_menu_item(menu, 2, 'player_all', 'Player on field (all)');
-       // add_menu_item(menu, 'Formation played (any)');
+       add_menu_item(global_filters, menu, 0, 'match', 'Match (any)');
+       add_menu_item(global_filters, menu, 1, 'player_any', 'Player on field (any)');
+       add_menu_item(global_filters, menu, 2, 'player_all', 'Player on field (all)');
+       add_menu_item(global_filters, menu, 3, 'formation_offense', 'Offense played (any)');
+       add_menu_item(global_filters, menu, 4, 'formation_defense', 'Defense played (any)');
+       add_menu_item(global_filters, menu, 5, 'starting_on', 'Starting on');
+       add_menu_item(global_filters, menu, 6, 'gender_ratio', 'Gender ratio');
 }
 
-function add_menu_item(menu, menu_idx, filter_type, title) {
+function add_menu_item(filterset, menu, menu_idx, filter_type, title) {
        let item = document.createElement('div');
        item.classList.add('option');
        item.appendChild(document.createTextNode(title));
@@ -943,13 +1168,49 @@ function add_menu_item(menu, menu_idx, filter_type, title) {
 
        menu.appendChild(item);
 
-       item.addEventListener('click', (e) => { show_submenu(menu_idx, null, filter_type); });
+       item.addEventListener('click', (e) => { show_submenu(filterset, menu_idx, null, filter_type); });
 }
 
-function show_submenu(menu_idx, pill, filter_type) {
+function find_all_ratios(json)
+{
+       let ratios = {};
+       let players = {};
+       for (const player of json['players']) {
+               players[player['player_id']] = {
+                       'gender': player['gender'],
+                       'last_point_seen': null,
+               };
+       }
+       for (const match of json['matches']) {
+               for (const [q,p] of Object.entries(players)) {
+                       p.on_field_since = null;
+               }
+               for (const e of match['events']) {
+                       let p = players[e['player']];
+                       let type = e['type'];
+                       if (type === 'in') {
+                               p.on_field_since = 1;
+                       } else if (type === 'out') {
+                               p.on_field_since = null;
+                       } else if (type === 'pull' || type == 'their_pull') {  // We assume no cross-gender subs for now.
+                               let code = find_gender_ratio_code(players);
+                               if (ratios[code] === undefined) {
+                                       ratios[code] = code;
+                                       if (code !== '4 F, 3 M' && code !== '4 M, 3 F' && code !== '3 M, 2 F' && code !== '3 F, 2 M') {
+                                               console.log('Unexpected gender ratio ' + code + ' first seen at: ' +
+                                                           match['description'] + ', ' + format_time(e['t']));
+                                       }
+                               }
+                       }
+               }
+       }
+       return ratios;
+}
+
+function show_submenu(filterset, menu_idx, pill, filter_type) {
        let submenu = document.getElementById('filter-submenu');
        let subitems = [];
-       const filter = find_filter(filter_type);
+       const filter = find_filter(filterset, filter_type);
 
        let choices = [];
        if (filter_type === 'match') {
@@ -966,6 +1227,48 @@ function show_submenu(menu_idx, pill, filter_type) {
                                'id': player['player_id']
                        });
                }
+       } else if (filter_type === 'formation_offense') {
+               choices.push({
+                       'title': '(None/unknown)',
+                       'id': 0,
+               });
+               for (const formation of global_json['formations']) {
+                       if (formation['offense']) {
+                               choices.push({
+                                       'title': formation['name'],
+                                       'id': formation['formation_id']
+                               });
+                       }
+               }
+       } else if (filter_type === 'formation_defense') {
+               choices.push({
+                       'title': '(None/unknown)',
+                       'id': 0,
+               });
+               for (const formation of global_json['formations']) {
+                       if (!formation['offense']) {
+                               choices.push({
+                                       'title': formation['name'],
+                                       'id': formation['formation_id']
+                               });
+                       }
+               }
+       } else if (filter_type === 'starting_on') {
+               choices.push({
+                       'title': 'Offense',
+                       'id': false,  // last_pull_was_ours
+               });
+               choices.push({
+                       'title': 'Defense',
+                       'id': true,  // last_pull_was_ours
+               });
+       } else if (filter_type === 'gender_ratio') {
+               for (const [title, id] of Object.entries(find_all_ratios(global_json)).sort()) {
+                       choices.push({
+                               'title': title,
+                               'id': id,
+                       });
+               }
        }
 
        for (const choice of choices) {
@@ -980,7 +1283,7 @@ function show_submenu(menu_idx, pill, filter_type) {
                if (filter !== null && filter.elements.has(choice.id)) {
                        check.setAttribute('checked', 'checked');
                }
-               check.addEventListener('change', (e) => { checkbox_changed(e, filter_type, choice.id); });
+               check.addEventListener('change', (e) => { checkbox_changed(filterset, e, filter_type, choice.id); });
 
                subitem.appendChild(check);
                subitem.appendChild(document.createTextNode(choice.title));
@@ -1004,8 +1307,8 @@ function show_submenu(menu_idx, pill, filter_type) {
 }
 
 // Find the right filter, if it exists.
-function find_filter(filter_type) {
-       for (let f of global_filters) {
+function find_filter(filterset, filter_type) {
+       for (let f of filterset) {
                if (f.type === filter_type) {
                        return f;
                }
@@ -1013,8 +1316,19 @@ function find_filter(filter_type) {
        return null;
 }
 
-function checkbox_changed(e, filter_type, id) {
-       let filter = find_filter(filter_type);
+// Equivalent to Array.prototype.filter, but in-place.
+function inplace_filter(arr, cond) {
+       let j = 0;
+       for (let i = 0; i < arr.length; ++i) {
+               if (cond(arr[i])) {
+                       arr[j++] = arr[i];
+               }
+       }
+       arr.length = j;
+}
+
+function checkbox_changed(filterset, e, filter_type, id) {
+       let filter = find_filter(filterset, filter_type);
        if (e.target.checked) {
                // See if we must add a new filter to the list.
                if (filter === null) {
@@ -1022,12 +1336,12 @@ function checkbox_changed(e, filter_type, id) {
                                'type': filter_type,
                                'elements': new Set([ id ]),
                        };
-                       filter.pill = make_filter_pill(filter);
-                       global_filters.push(filter);
+                       filter.pill = make_filter_pill(filterset, filter);
+                       filterset.push(filter);
                        document.getElementById('filters').appendChild(filter.pill);
                } else {
                        filter.elements.add(id);
-                       let new_pill = make_filter_pill(filter);
+                       let new_pill = make_filter_pill(filterset, filter);
                        document.getElementById('filters').replaceChild(new_pill, filter.pill);
                        filter.pill = new_pill;
                }
@@ -1035,9 +1349,9 @@ function checkbox_changed(e, filter_type, id) {
                filter.elements.delete(id);
                if (filter.elements.size === 0) {
                        document.getElementById('filters').removeChild(filter.pill);
-                       global_filters = global_filters.filter(f => f !== filter);
+                       inplace_filter(filterset, f => f !== filter);
                } else {
-                       let new_pill = make_filter_pill(filter);
+                       let new_pill = make_filter_pill(filterset, filter);
                        document.getElementById('filters').replaceChild(new_pill, filter.pill);
                        filter.pill = new_pill;
                }
@@ -1046,30 +1360,18 @@ function checkbox_changed(e, filter_type, id) {
        process_matches(global_json, global_filters);
 }
 
-function make_filter_pill(filter) {
+function make_filter_pill(filterset, filter) {
        let pill = document.createElement('div');
        pill.classList.add('filter-pill');
        let text;
        if (filter.type === 'match') {
                text = 'Match: ';
 
-               // See if there's a common prefix.
-               let num_matches = filter.elements.size;
-               let common_prefix = null;
-               if (num_matches > 1)  {
-                       for (const match_id of filter.elements) {
-                               let desc = find_match(match_id)['description'];
-                               if (common_prefix === null) {
-                                       common_prefix = desc;
-                               } else {
-                                       common_prefix = find_common_prefix(common_prefix, desc);
-                               }
-                       }
-                       if (common_prefix.length < 3) {
-                               common_prefix = null;
-                       }
+               let all_names = [];
+               for (const match_id of filter.elements) {
+                       all_names.push(find_match(match_id)['description']);
                }
-
+               let common_prefix = find_common_prefix_of_all(all_names);
                if (common_prefix !== null) {
                        text += common_prefix + '(';
                }
@@ -1114,11 +1416,67 @@ function make_filter_pill(filter) {
                        text += find_player(player_id)['name'];
                        first = false;
                }
+       } else if (filter.type === 'formation_offense' || filter.type === 'formation_defense') {
+               const offense = (filter.type === 'formation_offense');
+               if (offense) {
+                       text = 'Offense: ';
+               } else {
+                       text = 'Defense: ';
+               }
+
+               let all_names = [];
+               for (const formation_id of filter.elements) {
+                       all_names.push(find_formation(formation_id)['name']);
+               }
+               let common_prefix = find_common_prefix_of_all(all_names);
+               if (common_prefix !== null) {
+                       text += common_prefix + '(';
+               }
+
+               let first = true;
+               let sorted_formation_id = Array.from(filter.elements).sort((a, b) => a - b);
+               for (const formation_id of sorted_formation_id) {
+                       if (!first) {
+                               ktext += ', ';
+                       }
+                       let desc = find_formation(formation_id)['name'];
+                       if (common_prefix === null) {
+                               text += desc;
+                       } else {
+                               text += desc.substr(common_prefix.length);
+                       }
+                       first = false;
+               }
+
+               if (common_prefix !== null) {
+                       text += ')';
+               }
+       } else if (filter.type === 'starting_on') {
+               text = 'Starting on: ';
+
+               if (filter.elements.has(false) && filter.elements.has(true)) {
+                       text += 'Any';
+               } else if (filter.elements.has(false)) {
+                       text += 'Offense';
+               } else {
+                       text += 'Defense';
+               }
+       } else if (filter.type === 'gender_ratio') {
+               text = 'Gender: ';
+
+               let first = true;
+               for (const name of Array.from(filter.elements).sort()) {
+                       if (!first) {
+                               text += '; ';
+                       }
+                       text += name;
+                       first = false;
+               }
        }
 
        let text_node = document.createElement('span');
        text_node.innerText = text;
-       text_node.addEventListener('click', (e) => show_submenu(null, pill, filter.type));
+       text_node.addEventListener('click', (e) => show_submenu(filterset, null, pill, filter.type));
        pill.appendChild(text_node);
 
        pill.appendChild(document.createTextNode(' '));
@@ -1128,7 +1486,7 @@ function make_filter_pill(filter) {
        delete_node.addEventListener('click', (e) => {
                // Delete this filter entirely.
                document.getElementById('filters').removeChild(pill);
-               global_filters = global_filters.filter(f => f !== filter);
+               inplace_filter(filterset, f => f !== filter);
                process_matches(global_json, global_filters);
 
                let add_menu = document.getElementById('filter-add-menu');
@@ -1154,6 +1512,25 @@ function find_common_prefix(a, b) {
        return ret;
 }
 
+function find_common_prefix_of_all(values) {
+       if (values.length < 2) {
+               return null;
+       }
+       let common_prefix = null;
+       for (const desc of values) {
+               if (common_prefix === null) {
+                       common_prefix = desc;
+               } else {
+                       common_prefix = find_common_prefix(common_prefix, desc);
+               }
+       }
+       if (common_prefix.length >= 3) {
+               return common_prefix;
+       } else {
+               return null;
+       }
+}
+
 function find_match(match_id) {
        for (const match of global_json['matches']) {
                if (match['match_id'] === match_id) {
@@ -1163,6 +1540,15 @@ function find_match(match_id) {
        return null;
 }
 
+function find_formation(formation_id) {
+       for (const formation of global_json['formations']) {
+               if (formation['formation_id'] === formation_id) {
+                       return formation;
+               }
+       }
+       return null;
+}
+
 function find_player(player_id) {
        for (const player of global_json['players']) {
                if (player['player_id'] === player_id) {
@@ -1192,6 +1578,109 @@ function keep_match(match_id, filters) {
        return true;
 }
 
+function find_gender_ratio_code(players) {
+       let map = {};
+       for (const [q,p] of Object.entries(players)) {
+               if (p.on_field_since === null) {
+                       continue;
+               }
+               let gender = p.gender;
+               if (gender === '' || gender === undefined || gender === null) {
+                       gender = '?';
+               }
+               if (map[gender] === undefined) {
+                       map[gender] = 1;
+q              } else {
+                       ++map[gender];
+               }
+       }
+       let all_genders = Array.from(Object.keys(map)).sort(
+               (a,b) => {
+                       if (map[a] !== map[b]) {
+                               return map[b] - map[a];  // Reverse numeric.
+                       } else if (a < b) {
+                               return -1;
+                       } else if (a > b) {
+                               return 1;
+                       } else {
+                               return 0;
+                       }
+               });
+       let code = '';
+       for (const g of all_genders) {
+               if (code !== '') {
+                       code += ', ';
+               }
+               code += map[g];
+               code += ' ';
+               code += g;
+       }
+       return code;
+}
+
+function filter_passes(players, formations_used_this_point, last_pull_was_ours, filter) {
+       if (filter.type === 'player_any') {
+               for (const p of Array.from(filter.elements)) {
+                       if (players[p].on_field_since !== null) {
+                               return true;
+                       }
+               }
+               return false;
+       } else if (filter.type === 'player_all') {
+               for (const p of Array.from(filter.elements)) {
+                       if (players[p].on_field_since === null) {
+                               return false;
+                       }
+               }
+               return true;
+       } else if (filter.type === 'formation_offense' || filter.type === 'formation_defense') {
+               for (const f of Array.from(filter.elements)) {
+                       if (formations_used_this_point.has(f)) {
+                               return true;
+                       }
+               }
+               return false;
+       } else if (filter.type === 'starting_on') {
+               return filter.elements.has(last_pull_was_ours);
+       } else if (filter.type === 'gender_ratio') {
+               return filter.elements.has(find_gender_ratio_code(players));
+       }
+       return true;
+}
+
+function keep_event(players, formations_used_this_point, last_pull_was_ours, filters) {
+       for (const filter of filters) {
+               if (!filter_passes(players, formations_used_this_point, last_pull_was_ours, filter)) {
+                       return false;
+               }
+       }
+       return true;
+}
+
+// Heuristic: If we go at least ten seconds without the possession changing
+// or the operator specifying some other formation, we probably play the
+// same formation as the last point.
+function should_reuse_last_formation(events, t) {
+       for (const e of events) {
+               if (e.t <= t) {
+                       continue;
+               }
+               if (e.t > t + 10000) {
+                       break;
+               }
+               const type = e.type;
+               if (type === 'their_goal' || type === 'goal' ||
+                   type === 'set_defense' || type === 'set_offense' ||
+                   type === 'throwaway' || type === 'their_throwaway' ||
+                   type === 'drop' || type === 'was_d' || type === 'stallout' || type === 'defense' || type === 'interception' ||
+                   type === 'pull' || type === 'pull_landed' || type === 'pull_oob' || type === 'their_pull' ||
+                   type === 'formation_offense' || type === 'formation_defense') {
+                       return false;
+               }
+       }
+       return true;
+}
+
 function possibly_close_menu(e) {
        if (e.target.closest('#filter-click-to-add') === null &&
            e.target.closest('#filter-add-menu') === null &&
@@ -1203,3 +1692,52 @@ function possibly_close_menu(e) {
                add_submenu.style.display = 'none';
        }
 }
+
+let global_sort = {};
+
+function sort_by(th) {
+       let tr = th.parentElement;
+       let child_idx = 0;
+       for (let column_idx = 0; column_idx < tr.children.length; ++column_idx) {
+               let element = tr.children[column_idx];
+               if (element === th) {
+                       ++child_idx;  // Pad.
+                       break;
+               }
+               if (element.hasAttribute('colspan')) {
+                       child_idx += parseInt(element.getAttribute('colspan'));
+               } else {
+                       ++child_idx;
+               }
+       }
+
+       global_sort = {};
+       let table = tr.parentElement;
+       for (let row_idx = 1; row_idx < table.children.length - 1; ++row_idx) {  // Skip header and globals.
+               let row = table.children[row_idx];
+               let player = parseInt(row.dataset.player);
+               let value = row.children[child_idx].textContent;
+               global_sort[player] = value;
+       }
+}
+
+function get_sorted_players(players)
+{
+       let p = Object.entries(players);
+       if (global_sort.length !== 0) {
+               p.sort((a,b) => {
+                       let ai = parseFloat(global_sort[a[0]]);
+                       let bi = parseFloat(global_sort[b[0]]);
+                       if (ai == ai && bi == bi) {
+                               return bi - ai;  // Reverse numeric.
+                       } else if (global_sort[a[0]] < global_sort[b[0]]) {
+                               return -1;
+                       } else if (global_sort[a[0]] > global_sort[b[0]]) {
+                               return 1;
+                       } else {
+                               return 0;
+                       }
+               });
+       }
+       return p;
+}