From: Steinar H. Gunderson <sgunderson@bigfoot.com>
Date: Thu, 20 Feb 2020 17:51:47 +0000 (+0100)
Subject: Make explain cells more flexible.
X-Git-Url: https://git.sesse.net/?p=ultimatescore;a=commitdiff_plain;h=62acd54d7e0d27c056de5e7a106be803c3dc2f4e;hp=0830813a9a0a59443b1a068e217bf9524f82052e

Make explain cells more flexible.
---

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",