Make the 9–13rd ranking list actually start on 9.

diff --git a/config.js b/config.js
index ff5520d7849f66f84bc577bdf93c9ff4b411a858..3a52e64861feeb045d5d1273e4ed62f264d7df8f 100644 (file)
--- a/config.js
+++ b/config.js
@@ -15,28 +15,32 @@ var ultimateconfig = {
                        'score_sheet_cols': [ 'Results!S', 'Results!T', 'Results!U' ],
                        'point_total_start_row': 8,
                        'ranking_list_start_row': 15,
-                       'ranking_list_explain_cell': 'Results!S21'
+                       'ranking_list_explain_cell': 'Results!S21',
+                       'rank_offset': 1
                },
                'Group B': {
                        // Rank, name, points.
                        'score_sheet_cols': [ 'Results!W', 'Results!X', 'Results!Y' ],
                        'point_total_start_row': 8,
                        'ranking_list_start_row': 15,
-                       'ranking_list_explain_cell': 'Results!W21'
+                       'ranking_list_explain_cell': 'Results!W21',
+                       'rank_offset': 1
                },
                'Group C': {
                        // Rank, name, points.
                        'score_sheet_cols': [ 'Results!AA', 'Results!AB', 'Results!AC' ],
                        'point_total_start_row': 8,
                        'ranking_list_start_row': 15,
-                       'ranking_list_explain_cell': 'Results!AA21'
+                       'ranking_list_explain_cell': 'Results!AA21',
+                       'rank_offset': 1
                },
                'Playoffs 9th-13th': {
                        // Rank, name, points.
                        'score_sheet_cols': [ 'Results!S', 'Results!T', 'Results!U' ],
                        'point_total_start_row': null,
                        'ranking_list_start_row': 34,
-                       'ranking_list_explain_cell': 'Results!W34'
+                       'ranking_list_explain_cell': 'Results!W34',
+                       'rank_offset': 9
                }
        },
        'explain_third_cell': 'Results!S26',

diff --git a/update_sheets.js b/update_sheets.js
index f96b223a83054a4b732369c1cac52ed0f90c07dd..a9dcfe53c15942b83faa82a4903a0b1e5a827a8d 100644 (file)
--- a/update_sheets.js
+++ b/update_sheets.js
@@ -90,7 +90,7 @@ function publish_group_rank(response, group_name)
        // Write the ranking table, from scratch.
        for (let i = 0; i < teams.length; ++i) {
                let row = config['ranking_list_start_row'] + i;
-               updates.push({ "range": cols[0] + row, "values": [ [ teams[i].rank ] ] });
+               updates.push({ "range": cols[0] + row, "values": [ [ teams[i].rank + config['rank_offset'] - 1] ] });
                updates.push({ "range": cols[1] + row, "values": [ [ teams[i].mediumname ] ] });
                updates.push({ "range": cols[2] + row, "values": [ [ teams[i].pts ] ] });
        }