New answers tagged

1

After every match, only the ranks of the two players change. So, instead of calculating the rank of every player after a match, just calculate the new rank of the players. The trick is, say Alice played Bob, you need to find the last time Alice played and her rank at that time, as well as the last time Bob played and his rank at that time. This spreadsheet ...


3

There is a way to do it, however it can be a bit complicated and requires a unix web host with php 5, so be warned. Step 1 The first thing you have to do is add the maker channel. You do this the same way you'd add any other channel, by clicking "channels" at the top of the page and searching for it, then clicking on it and pressing the "add channel" ...


2

Yes, you can do all of this with Google Apps Script, though it's a pretty large project that arguably should not be someone's first project with GAS. Here is an overview of methods involved, with pointers to documentation. Select a range of cells in a row: getRange. Create a graph based on that range of cells including key and labels: see Embedded Chart ...



Top 50 recent answers are included