MikeGillis58 Posted April 3, 2012 Share Posted April 3, 2012 APRIL 2 WSH 4 @ TBL 3 EDM 3 @ LAK 2 Link to comment Share on other sites More sharing options...
Bombastik der Teutone Posted April 3, 2012 Author Share Posted April 3, 2012 so mike.. quinn´s game was washington@carolina and the original was winnipeg@carolina i guess he meant the peg´s game so i ll count this one we allready had similar situations and i´m sure we let them guys go with such tiny mistakes further..stats will be updated soon..in a new format Link to comment Share on other sites More sharing options...
Bombastik der Teutone Posted April 3, 2012 Author Share Posted April 3, 2012 the winner of the past 3 gamedays is canuckletux with 30 points followed by tgc and trav_have with 23 points..congrats the new leader is quinn12 https://docs.google....1La0NnaVE#gid=1 Link to comment Share on other sites More sharing options...
greetingsfrombrazil Posted April 3, 2012 Share Posted April 3, 2012 Link to comment Share on other sites More sharing options...
greetingsfrombrazil Posted April 3, 2012 Share Posted April 3, 2012 1 point TOR@BUF 1-4 NYI@NJD 1-4 NYR@PHI 2-3 PIT@BOS 4-3 CAR@OTT 2-3 WPG@FLA 1-2 MIN@NSH 1-4 SJS@DAL 3-2 ANA@VAN 1-6 CBJ@PHX 1-3 Link to comment Share on other sites More sharing options...
Bombastik der Teutone Posted April 3, 2012 Author Share Posted April 3, 2012 i hope you guys like it for now..well some changes for the next season will come for sure Link to comment Share on other sites More sharing options...
Bombastik der Teutone Posted April 3, 2012 Author Share Posted April 3, 2012 TOR@BUF 2-4 NYI@NJD 3-5 NYR@PHI 4-3 PIT@BOS 2-3 CAR@OTT 2-5 WPG@FLA 3-4 MIN@NSH 2-4 SJS@DAL 3-2 ANA@VAN 1-3 CBJ@PHX 3-5 Link to comment Share on other sites More sharing options...
Canuckletux Posted April 3, 2012 Share Posted April 3, 2012 i have allready worked something out https://docs.google....MUJwNC1La0NnaVE but i have to edit some things if someone has some ideas..tell me but i guess for the playoffs..its fine Link to comment Share on other sites More sharing options...
Canuckletux Posted April 3, 2012 Share Posted April 3, 2012 Apr 2 WSH @ TBL 2-3 EDM @ LAK 2-3 Link to comment Share on other sites More sharing options...
Bombastik der Teutone Posted April 3, 2012 Author Share Posted April 3, 2012 Hey, great idea, TGC! The spreadsheet is easier for you to edit and updating the stats / merging the totals will now be easier, too. I can't really figure out the I-column (Average Points), though.... basically, it takes 1 point per game as starting value and then calculates, to which extent (in percent) you reach the goal of 1 point per game.... wouldn't it be more fitting to evaluate the average amount of points per game (Total Points / Games Played)? Else then that, I really like it! Link to comment Share on other sites More sharing options...
Bombastik der Teutone Posted April 3, 2012 Author Share Posted April 3, 2012 Hey, great idea, TGC! The spreadsheet is easier for you to edit and updating the stats / merging the totals will now be easier, too. I can't really figure out the I-column (Average Points), though.... basically, it takes 1 point per game as starting value and then calculates, to which extent (in percent) you reach the goal of 1 point per game.... wouldn't it be more fitting to evaluate the average amount of points per game (Total Points / Games Played)? Else then that, I really like it! Link to comment Share on other sites More sharing options...
Canuckletux Posted April 3, 2012 Share Posted April 3, 2012 Apr 3 TOR @ BUF 2-3 NYI @ NJD 2-3 NYR @ PHI 3-4 PIT @ BOS 3-4 CAR @ OTT 2-3 WIN @ FLO 2-3 MIN @ NSH 2-3 SJS @ DAL 3-2 ANA @ VAN 2-5 CBJ @ PHX 2-3 Link to comment Share on other sites More sharing options...
Canuckletux Posted April 3, 2012 Share Posted April 3, 2012 i did total points / total games but it allways shows me this 101,26 % insteed of 1,01 points per game..i tried some different things but its allways the same result..the only thing i can do is total points/total games / 100..then it shows me 1,01 % Link to comment Share on other sites More sharing options...
Tony Romo Posted April 3, 2012 Share Posted April 3, 2012 Toronto 2-3 buffalo Ny islanders 2-3 new jersey Ny rangers 2-3 Philadelphia Carolina 2-3 Ottawa Winnipeg 2-3 Florida Pitsburgh 3-2 Boston Minneola 2-3 Nashville San Jose 2-3 Dallas Anaheim 2-3 Vancouver Colombus 2-3 Phoenix Link to comment Share on other sites More sharing options...
Bombastik der Teutone Posted April 4, 2012 Author Share Posted April 4, 2012 I see... yeah, it's understandable now. Have you tried leaving the "average" out of the formula, i.e. "=(H2/C2)" instead of "=AVERAGE(H2/C2)"? Then it should theoretically show absolute numbers instead of percentages. Link to comment Share on other sites More sharing options...
Tony Romo Posted April 4, 2012 Share Posted April 4, 2012 Toronto 2-3 buffalo W Ny islanders 2-3 new jersey W Ny rangers 2-3 Philadelphia L Carolina 2-3 Ottawa L Winnipeg 2-3 Florida OTL Pitsburgh 3-2 Boston W Minneola 2-3 Nashville W San Jose 2-3 Dallas L Anaheim 2-3 Vancouver W Colombus 2-3 Phoenix W Link to comment Share on other sites More sharing options...
KamikazeWatermelon Posted April 4, 2012 Share Posted April 4, 2012 Apr. 3 TOR @ BUF - 2-4 - W NYI @ NJD - 2-3 - W NYR @ PHI - 3-1 - W PIT @ BOS - 2-3 - L CAR @ OTT - 3-4 - L WPG @ FLA - 2-4 - OTL MIN @ NSH - 1-3 - W SJS @ DAL - 2-3 - L ANA @ VAN - 2-3 - W CBJ @ PHX - 2-4 - W Link to comment Share on other sites More sharing options...
-Vintage Canuck- Posted April 4, 2012 Share Posted April 4, 2012 TORONTO at BUFFALO (7:00 PM EDT) NY ISLANDERS at NEW JERSEY (7:00 PM EDT) NY RANGERS at PHILADELPHIA (7:00 PM EDT) PITTSBURGH at BOSTON (7:30 PM EDT) CAROLINA at OTTAWA (7:30 PM EDT) WINNIPEG at FLORIDA (7:30 PM EDT) MINNESOTA at NASHVILLE (8:00 PM EDT) SAN JOSE at DALLAS (8:30 PM EDT) ANAHEIM at VANCOUVER (10:00 PM EDT) COLUMBUS at PHOENIX (10:00 PM EDT) Link to comment Share on other sites More sharing options...
-Vintage Canuck- Posted April 4, 2012 Share Posted April 4, 2012 TAMPA BAY at MONTREAL (7:30 PM EDT) DETROIT at ST. LOUIS (7:30 PM EDT) Link to comment Share on other sites More sharing options...
TrudeauVoter Posted April 4, 2012 Share Posted April 4, 2012 TORONTO 3 at BUFFALO 4 (7:00 PM EDT) W NY ISLANDERS 2 at NEW JERSEY 4 (7:00 PM EDT) W NY RANGERS 3 at PHILADELPHIA 4(7:00 PM EDT) L PITTSBURGH 4 at BOSTON 2(7:30 PM EDT) W CAROLINA 4 at OTTAWA 3 (7:30 PM EDT) W WINNIPEG 2 at FLORIDA 3(7:30 PM EDT) O MINNESOTA 1 at NASHVILLE 4(8:00 PM EDT) W SAN JOSE 3 at DALLAS 2(8:30 PM EDT) W ANAHEIM 2 at VANCOUVER 4 (10:00 PM EDT) W COLUMBUS 2 at PHOENIX 3(10:00 PM EDT) W Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.