You are not connected. Please login or register

Prager's Brackets 2017!

Go to page : Previous  1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next

Go down  Message [Page 2 of 10]

16Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Tue Apr 11, 2017 1:22 pm

wprager


Administrator
Administrator
Have four picks in so far (including mine). Surprisingly, Google docs spreadsheet app was able to read in my Excel spreadsheet with all the formulas and conditional formatting, and almost everything worked right away. Just a bit of a quirk that when both the picks cells and the results column are empty the formula assigns the max points; that's not how it worked in Excel. Easy fix was to put bogus data in the picks cells (HOM7). Of course that will be over-written with the actual picks once available and, of course, the results column is filled in once the series is over. The "fix" is just so that we have actual totals before all series picks are in.

17Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Tue Apr 11, 2017 1:27 pm

Flo The Action


All-Star
All-Star
wprager wrote:Have four picks in so far (including mine).  Surprisingly, Google docs spreadsheet app was able to read in my Excel spreadsheet with all the formulas and conditional formatting, and almost everything worked right away.  Just a bit of a quirk that when both the picks cells and the results column are empty the formula assigns the max points; that's not how it worked in Excel.  Easy fix was to put bogus data in the picks cells (HOM7).  Of course that will be over-written with the actual picks once available and, of course, the results column is filled in once the series is over.  The "fix" is just so that we have actual totals before all series picks are in.
There's no "if" fonction?

18Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Tue Apr 11, 2017 1:43 pm

wprager


Administrator
Administrator
Flo The Action wrote:
wprager wrote:Have four picks in so far (including mine).  Surprisingly, Google docs spreadsheet app was able to read in my Excel spreadsheet with all the formulas and conditional formatting, and almost everything worked right away.  Just a bit of a quirk that when both the picks cells and the results column are empty the formula assigns the max points; that's not how it worked in Excel.  Easy fix was to put bogus data in the picks cells (HOM7).  Of course that will be over-written with the actual picks once available and, of course, the results column is filled in once the series is over.  The "fix" is just so that we have actual totals before all series picks are in.
There's no "if" fonction?

There are *MANY* IF functions:
Code:
=+IF(LEFT($AE$12,3)=LEFT(B12,3),2+IF(RIGHT($AE12,1)=RIGHT(B12,1),1,0),0)+IF(LEFT($AE$13,3)=LEFT(B13,3),2+IF(RIGHT($AE13,1)=RIGHT(B13,1),1,0),0)+IF(LEFT($AE$14,3)=LEFT(B14,3),2+IF(RIGHT($AE14,1)=RIGHT(B14,1),1,0),0)+IF(LEFT($AE$15,3)=LEFT(B15,3),2+IF(RIGHT($AE15,1)=RIGHT(B15,1),1,0),0)+IF(LEFT($AE$16,3)=LEFT(B16,3),2+IF(RIGHT($AE16,1)=RIGHT(B16,1),1,0),0)+IF(LEFT($AE$17,3)=LEFT(B17,3),2+IF(RIGHT($AE17,1)=RIGHT(B17,1),1,0),0)+IF(LEFT($AE$18,3)=LEFT(B18,3),2+IF(RIGHT($AE18,1)=RIGHT(B18,1),1,0),0)+IF(LEFT($AE$19,3)=LEFT(B19,3),2+IF(RIGHT($AE19,1)=RIGHT(B19,1),1,0),0)

That's the function for one of the elimination round subtotal cells. That's the worst case because it has to add up the numbers for all 8 series. In Excel if the two cells were empty the if comparing left(3) returned false, but in google it returned true. Minor quirk that would only have affected intermediate results. No biggie. And, yes, I could have added one more IF to check for an empty results and/or picks cell but that would have made the above formula even more difficult to follow.

19Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Tue Apr 11, 2017 7:22 pm

wprager

wprager
Administrator
Administrator
I have five sets of picks. Where's everyone? Flea, SSF, Tim, Defence, Flo. Flea, get SensGirl to fire one out.


_________________
Hey, I don't have all the answers. In life, to be honest, I've failed as much as I have succeeded. But I love my wife. I love my life. And I wish you my kind of success.
- Dicky Fox

20Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 9:48 am

tim1_2

tim1_2
Franchise Player
Franchise Player
I will do this today.

21Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 10:34 am

wprager

wprager
Administrator
Administrator
tim1_2 wrote:I will do this today.

I'm holding you to it. Wrote your name in and entered home team in 7 for now.


_________________
Hey, I don't have all the answers. In life, to be honest, I've failed as much as I have succeeded. But I love my wife. I love my life. And I wish you my kind of success.
- Dicky Fox

22Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 12:24 pm

tim1_2

tim1_2
Franchise Player
Franchise Player
Here are my picks:

MTL 7
OTT 5

WAS 4
PIT 6

CHI 6
MIN 7

ANA 6
EDM 7

23Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 12:26 pm

Flo The Action

Flo The Action
All-Star
All-Star
You did get mine eh?

24Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 12:28 pm

Flo The Action

Flo The Action
All-Star
All-Star
tim1_2 wrote:Here are my picks:

MTL 7
OTT 5

WAS 4
PIT 6

CHI 6
MIN 7

ANA 6
EDM 7
Ottawa in 5 eh? That bold!
I predicted wash would drop the ball on at least one game. Apart from that it's pretty close to mine.

25Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 12:31 pm

tim1_2

tim1_2
Franchise Player
Franchise Player
Yeah, I feel really confident about the Sens, which of course could totally go out the window with a single loss....but for now, LET THE GOOD TIMES ROLL!!!!

26Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 12:41 pm

wprager

wprager
Administrator
Administrator
Flo The Action wrote:You did get mine eh?

I'll go check again.


.
.
.
.
.
Nope, no picks from you.


_________________
Hey, I don't have all the answers. In life, to be honest, I've failed as much as I have succeeded. But I love my wife. I love my life. And I wish you my kind of success.
- Dicky Fox

27Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 4:32 pm

wprager

wprager
Administrator
Administrator
I'm up to 7 now. In, so far, are:
Hoff-Machine
me
Cap'n Clutch
Ev
spader
tim1_2
Hobiesens

Missing in action: Flo, Flea, SSF, Defence (others as well, obviously, but I'm going by the frequent visitors).


_________________
Hey, I don't have all the answers. In life, to be honest, I've failed as much as I have succeeded. But I love my wife. I love my life. And I wish you my kind of success.
- Dicky Fox

28Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 6:34 pm

PTFlea

PTFlea
Co-Founder
Co-Founder
Montreal in 7
Ottawa in 7
Washington in 5
Pittsburgh in 6

Chicago in 6
Edmonton in 7

29Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 6:36 pm

PTFlea

PTFlea
Co-Founder
Co-Founder
Wild in 6
Anaheim in 6

30Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 7:09 pm

Oglethorpe

Oglethorpe
Veteran
Veteran
Sent mine to Prags.

31Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 7:11 pm

wprager

wprager
Administrator
Administrator
I'll update the latest entries tomorrow and post them all here.


_________________
Hey, I don't have all the answers. In life, to be honest, I've failed as much as I have succeeded. But I love my wife. I love my life. And I wish you my kind of success.
- Dicky Fox

32Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 8:39 pm

Flo The Action

Flo The Action
All-Star
All-Star
wprager wrote:
Flo The Action wrote:You did get mine eh?

I'll go check again.


.
.
.
.
.
Nope, no picks from you.

Check you emails!

33Prager's Brackets 2017! - Page 2 Empty Re: Prager's Brackets 2017! on Wed Apr 12, 2017 8:40 pm

Flo The Action

Flo The Action
All-Star
All-Star
This is what I emailed you prags.
WSH in 5
PIT in 7
MTL in 7
OTT in 6
CHI in 5
MIN in 6
ANA in 7
EDM in 6

I went on your profile and sent it via email.

Sponsored content


Back to top  Message [Page 2 of 10]

Go to page : Previous  1, 2, 3, 4, 5, 6, 7, 8, 9, 10  Next

Permissions in this forum:
You cannot reply to topics in this forum