// 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 ] ] });
}
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",
let score2 = response['values'][row - 1][cols[2]];
let game_name = game[4];
let game_name2 = game_name.replace("Semi", "semi");
+ let game_day = game[7];
+ if (game_day === undefined) {
+ game_day = 7; // Sunday.
+ }
let range = {
"sheetId": ultimateconfig['score_sheet_index'],
// Game.
updates.push({
"range": "Playoffs!A" + (game_num + 32) + ":J" + (game_num + 32),
- "values": [ [ team1, team2, score1, score2, "", "", "", 7, response['values'][row - 1][1].replace(".",":"), game[6] ] ]
+ "values": [ [ team1, team2, score1, score2, "", "", "", game_day, response['values'][row - 1][1].replace(".",":"), game[6] ] ]
});
// Team codes.
};
possibly_update_oauth_key(function() {
post_json('https://sheets.googleapis.com/v4/spreadsheets/' + ultimateconfig['score_sheet_id'] + '/values:batchUpdate?key=' + ultimateconfig['api_key'], json, function(response) {
- get_group('Group L', function(response_l) { publish_group_rank(response_l, 'Group L'); });
+ get_group('Playoffs 9th-13th', function(response_l) { publish_group_rank(response_l, 'Playoffs 9th-13th'); });
}, current_oauth_access_token);
post_json('https://sheets.googleapis.com/v4/spreadsheets/' + ultimateconfig['score_sheet_id'] + ':batchUpdate?key=' + ultimateconfig['api_key'], meta_json, function(response) {}, current_oauth_access_token);
});