Questions from the 2013 Modeloff awards ceremony - Page 3

Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 25 of 25

Thread: Questions from the 2013 Modeloff awards ceremony

  1. #21
    New Member
    Join Date
    Oct 2014
    Location
    india
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Questions from the 2013 Modeloff awards ceremony

     
    The Modeloff Finals and Awards Ceremony will be held at Microsoft's New York offices (1290 Avenue of the Americas, New York) at 2:00pm on sunday !

  2. #22
    New Member
    Join Date
    Nov 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: golf answer

    Hi all,

    Just discovering this board while preparing for round 2 of Model 2014. In case anyone else came across it, I thought I'd share some thoughts on the solutions 2013 excel golf challenge and to the challenge itself, as I was there.

    I believe many of the solutions presented can be improved upon.
    (1) @notmcgee: Your solution is almost exactly the same as the one I came up with, but you can improve it slightly, by removing the 0, leaving a length of 38 characters.
    =MAX(MIN($F18,H$17)-MAX($E18,H$16)+1,)
    Quote Originally Posted by notmcgee View Post
    =max(min($f18,h$17)-max(h$16,$e18)+1,0)
    (2) As some present at the competition, I would like to say that it was very clear what the challenge was and the intent of the rules, and that Peter's solution, while shorter, was not a valid one as it depended on the values entered into the inputs. While I came up with a slightly better solution that the contestants while at the competition, it wasn't until afterwards that I came up with what I believe is the best solution: =OFFSET($I$30,9-ROW(),9-COLUMN())
    Length: 33 characters
    This solution does have one trick, which is that it uses a box that is outside the input grid in order to slightly shorten the formula.
    (3) This too is one where I had a better solution than the contestants while at the competition, but not nearly as good as one I came up with after the competition. And that even that was beat by a colleague of mine, who improved it by 1 character. His solution is:
    {=SUM(N(E20:S59^2>100))}
    Length: 22 characters
    (4) I have the same solution that Nicholas Favre has, namely:
    =MAX(INT((H$17-$E19)/$F19/360+1),)
    Length: 34 characters

    As someone present at the competition, I would like to say that I loved the idea of this challenge and I thought it was very exciting, lots of fun, and clearly challenged the minds of the competitors. I especially liked that as a observer, I was able to play along with the competitors in my head. In response to other people's comments, I would like to emphasize that it was very clear what the challenge was and the intent of the rules. It was also clearly tricky to review results quickly. That said, it didn't feel like the solutions were well thought out in advance, and so even there, some of us were able to come up with better solutions than the ones presented.

    Thanks again for putting together such a great competition!!!

  3. #23
    New Member
    Join Date
    Feb 2014
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Questions from the 2013 Modeloff awards ceremony

    My answers: -
    Question 1
    =IF(AND($E18<=H$17,$F18>=H$16),MIN(H$17-$E18,H$17-H$16,$F18-H$16,$F18-$E18)+1,0)
    Question 2
    =INDEX($E$18:$H$21,ROWS(18:$21),COLUMNS(E:$H))
    Question 3
    =COUNTIF(E20:S59,">10")+COUNTIF(E20:S59,"<-10")
    Question 4
    =MAX(0,INT((H$17-$E19)/$F19/365+1))

  4. #24
    New Member
    Join Date
    Oct 2015
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: golf answer

    Quote Originally Posted by painter616 View Post
    Hi all,
    I believe many of the solutions presented can be improved upon.
    (1) @notmcgee: Your solution is almost exactly the same as the one I came up with, but you can improve it slightly, by removing the 0, leaving a length of 38 characters.
    =MAX(MIN($F18,H$17)-MAX($E18,H$16)+1,)
    Just discovering this board myself, and was checking here to see if my answer was optimal. Turns out I've improved on the best answer here for the golf challenge.

    Change the reference style to R1C1.
    "=MAX(,MIN(R17C,RC6)-MAX(R16C,RC5)+1)" 36 characters, but the checking formula is using the A1 formula to evaluate, and doesn't pick up the difference.

  5. #25
    New Member
    Join Date
    Feb 2017
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: golf answer

      
    Shorter doesn't mean more transparent and effective.
    My solution of 2nd question is:

    =INDEX($E$18:$H$21;COUNT(E18:E$21);COUNT(E18:$H18))

    Which doesn't use nor hard coded values, no cells outside the initial array - all of them are the potential source for future errors.
    Also its easy to use the same formula with the arrays of different dimensions.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com