{
get_group(group_name, function(response, group_name) {
let updates = [];
- let cols = ["Results!B", "Results!C", "Results!D"];
+ let cols = ["Results!M", "Results!N", "Results!O"];
if (group_name === 'Group B') {
- cols = ["Results!F", "Results!G", "Results!H"];
+ cols = ["Results!Q", "Results!R", "Results!S"];
}
let teams = parse_teams_from_spreadsheet(response);
// Write the points total to the unsorted columns.
for (let i = 0; i < teams.length; ++i) {
- updates.push({ "range": cols[2] + (4 + i), "values": [ [ teams[i].pts ] ] });
+ updates.push({ "range": cols[2] + (10 + i), "values": [ [ teams[i].pts ] ] });
}
let tiebreakers = [];
// Write the ranking table, from scratch.
for (let i = 0; i < teams.length; ++i) {
- updates.push({ "range": cols[0] + (10 + i), "values": [ [ teams[i].rank ] ] });
- updates.push({ "range": cols[1] + (10 + i), "values": [ [ teams[i].shortname ] ] });
- updates.push({ "range": cols[2] + (10 + i), "values": [ [ teams[i].pts ] ] });
+ updates.push({ "range": cols[0] + (19 + i), "values": [ [ teams[i].rank ] ] });
+ updates.push({ "range": cols[1] + (19 + i), "values": [ [ teams[i].shortname ] ] });
+ updates.push({ "range": cols[2] + (19 + i), "values": [ [ teams[i].pts ] ] });
}
let tb_str = "";
if (tiebreakers.length != 0) {
tb_str = tiebreakers.join("\n");
}
- updates.push({ "range": cols[0] + "15", "values": [ [ tb_str ] ]});
+ updates.push({ "range": cols[0] + "25", "values": [ [ tb_str ] ]});
let json = {
"valueInputOption": "USER_ENTERED",