From 007efa1462d402147a75a59169e5ad4db74e1c69 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Thu, 20 Feb 2020 18:53:34 +0100 Subject: [PATCH] =?utf8?q?Make=20the=209=E2=80=9313rd=20ranking=20list=20a?= =?utf8?q?ctually=20start=20on=209.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- config.js | 12 ++++++++---- update_sheets.js | 2 +- 2 files changed, 9 insertions(+), 5 deletions(-) diff --git a/config.js b/config.js index ff5520d..3a52e64 100644 --- 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 f96b223..a9dcfe5 100644 --- 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 ] ] }); } -- 2.39.2