From 62acd54d7e0d27c056de5e7a106be803c3dc2f4e Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Thu, 20 Feb 2020 18:51:47 +0100 Subject: [PATCH] Make explain cells more flexible. --- config.js | 8 ++++---- update_sheets.js | 2 +- 2 files changed, 5 insertions(+), 5 deletions(-) diff --git a/config.js b/config.js index 51949d1..ff5520d 100644 --- a/config.js +++ b/config.js @@ -15,28 +15,28 @@ var ultimateconfig = { 'score_sheet_cols': [ 'Results!S', 'Results!T', 'Results!U' ], 'point_total_start_row': 8, 'ranking_list_start_row': 15, - 'ranking_list_explain_row': 21 + 'ranking_list_explain_cell': 'Results!S21' }, '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_row': 21 + 'ranking_list_explain_cell': 'Results!W21' }, '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_row': 21 + 'ranking_list_explain_cell': 'Results!AA21' }, '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_row': 40 + 'ranking_list_explain_cell': 'Results!W34' } }, 'explain_third_cell': 'Results!S26', diff --git a/update_sheets.js b/update_sheets.js index 7776425..f96b223 100644 --- a/update_sheets.js +++ b/update_sheets.js @@ -99,7 +99,7 @@ function publish_group_rank(response, group_name) if (tiebreakers.length != 0) { tb_str = tiebreakers.join("\n"); } - updates.push({ "range": cols[0] + config['ranking_list_explain_row'], "values": [ [ tb_str ] ]}); + updates.push({ "range": config['ranking_list_explain_cell'], "values": [ [ tb_str ] ]}); let json = { "valueInputOption": "USER_ENTERED", -- 2.39.2