Update the rosters for the new NM2018 sheet.

diff --git a/quickl3.js b/quickl3.js
index 1709cb7c0513bb7b95876515ddc27abcce543692..0ef871e86c54ff8aa879381112b590856d9cdb58 100644 (file)
--- a/quickl3.js
+++ b/quickl3.js
@@ -8,7 +8,8 @@ function load_l3(sheet, prefix, cb)
                let l3s = [];
                let i;
                for (i = 0; i < response.values.length; ++i) {
                let l3s = [];
                let i;
                for (i = 0; i < response.values.length; ++i) {

-                       if (response.values[i][0] === 'Number') {
+                       if (response.values[i][0] === 'Number' ||
+                           response.values[i][0] === 'Fake #') {

                                ++i;
                                break;
                        }
                                ++i;
                                break;
                        }


@@ -42,7 +43,7 @@ function load_l3(sheet, prefix, cb)
                }
                cb(l3s, sheet);
        };
                }
                cb(l3s, sheet);
        };

-       req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1uh7kr5v_hyD072b1G2tbQlhqd_8ldS_6j30CBocQ-4E/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
+       req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1VyLIS2GeohLlIRFs6c8kk6g0ZnBFXXiYNh_JROC-iZM/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');

        req.send();
 };
 
        req.send();
 };
 

diff --git a/roster.js b/roster.js
index b5dd4db5e17e7542533ad87b5466ab262a7d17c6..3524189a741c799dfb823582504f1a24b60bfcc9 100644 (file)
--- a/roster.js
+++ b/roster.js
@@ -33,7 +33,7 @@ function load_roster(sheet, cb)
                }
                cb(team_name, roster);
        };
                }
                cb(team_name, roster);
        };

-       req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1uh7kr5v_hyD072b1G2tbQlhqd_8ldS_6j30CBocQ-4E/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');
+       req.open('GET', 'https://sheets.googleapis.com/v4/spreadsheets/1VyLIS2GeohLlIRFs6c8kk6g0ZnBFXXiYNh_JROC-iZM/values/\'' + sheet + '\'!A1:J50?key=AIzaSyAuP9yQn8g0bSay6r_RpGtpFeIbwprH1TU');

        req.send();
 };
 
        req.send();
 };