![]() |
Re: Ontario/Quebec Rankings
After weeks 5 and 6, it looks like this. Note: I made it so that totals were calculated only on a teams first two chronological events but still showed the amount of points they would have earned at the third (unless your third was ABCA), which means that for several teams at ONTO2, and all ON teams at ABCA except 4001, those events didn't count.
Code:
Rank Team ONTO QCMO NHMA NYRO NYNY PAPI ONWA MABO ONTO2 MELE OHCL ABCA TotalInterestingly, several teams made the cut while only attending one event, and several more would have made the cut on a single event's points, despite attending more than one. I suspect though, that the cutoff is artificially low due to having less events than a true district system. |
Re: Ontario/Quebec Rankings
I think you missed second events for both 2200 and 2386 who both attended the Pinetree Regional in Maine - week 6. Why not show the Calgary points for the other teams that attended Calgary - 771, 1305 and 1334?
|
Re: Ontario/Quebec Rankings
781 also attended Buckeye, which I don't think was listed. It was their third event though, so it doesn't matter for points.
|
Re: Ontario/Quebec Rankings
I updated it to add 2200/2386 at MELE, and also added the points for 771, 1305, and 1334 at ABCA.
I noticed in checking though, that I'd screwed up all the points for 2nd picks, (inadvertently giving them the reverse of what they deserved, so #8 alliance second pick received 1 pt instead of 8, and #1 alliance second pick received 8pts instead of 1). Because of how I built my spreadsheet, fixing this isn't easy. Working on a fix, will post again when fixed, though it shouldn't change standings too much. |
Re: Ontario/Quebec Rankings
Fixed. Also, added 781 @ OHCL for interest. Interestingly enough, 4343 was one of the teams most negatively affected by my error.
|
| All times are GMT -5. The time now is 07:37. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi