Make explain cells more flexible.

diff --git a/config.js b/config.js
index 51949d139227cf5786c95eea758b734f4eb6dc37..ff5520d7849f66f84bc577bdf93c9ff4b411a858 100644 (file)
--- 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 7776425146c700e58de0e2d61a32c977a2ebdddd..f96b223a83054a4b732369c1cac52ed0f90c07dd 100644 (file)
--- 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",