• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

112 years to finish Chandoo's hurdle

F

fred

Member
https://docs.google.com/open?id=0B1Yt3Yl95LuPUnY5R1VMNWQ1eDg


OK. it is obviously i'm hopeless in sports and here is the excuse not to hit the gym any time soon (or any time at all!).


But I'm curious how come I only made 18 errors (i know I only made one) but took 112 years to finish the hurdle?


And it does look like I'm traveling back from the future to ask this question. ;P


(Disclaimer: I did nothing to Chandoo's file other than trying out the hurdle for the very first time.)
 
May be it is a bug. I thought I coded it pretty tight. Can you tell me which version of Excel (language too) you are using?

Also, did you mess with system clock or something?
 
Hi Chandoo,


I tried lots of Combination, and Finally got the In-correct Result.. :)

(i know I only made one)
Click to expand...

after click on RESET , Don't Click on Start, Just select the E26(hetch10) then Alt+Down.. and ... all other things to reach END.. You have a perfect 112 Years

[pre]
Code: 
Time taken		3554021256.000 secs
Penalties		18
Total Time		3554021274.000 secs[/pre]

Its perfect [code]=CONVERT(3554021256,"sec","yr") 112 Years..

And thats is

[code][valDuration] = [endTime] - [startTime] + ([penaltyTotal] / 24 / 60 / 60)

where [StrartTime] is 1/1/1990 and [endTime] is Now()[/code]..

Which is =Exact(3554021256.000,[endTime] - [startTime])[/code]


Its something like, someone from Audience Jump in the Hurdle Track.. and start Jumping..


BTW.. 13 Sec 0 Penalty.. Thanks Man..
 
@SirJB7

Hi, myself!

So long...

And then the gossips go around talking about my addiction to Carlsberg beer... They don't realize that it is the ideal lubricant for the phalanges, do they? Otherwise perhaps I would end with 112 years too.

Regards!
 
Thanks for the detailed bug find Debraj. I added [isGameOn] condition so that Second sheet is shown only when you are in play mode. This should fix it. I have uploaded the file here: http://img.chandoo.org/contests/excel-hurdles-challenge-v1.xlsm
 
hi all, just returned from a weekend break. so I see Debraj had found the bug. :)


I was using Excel 2010 and I'd never try to break such an elaborate model Chandoo has built. But bugs somehow always find me.


A little side story, in one of my old college class there was a jar with red beads(minority) and white beads (majority) and a filter that can hold 50 beads at a time (forgot what the name of the test was). In my first trial scooping up the beads in the jar and I got 19 red beads out of 50. After some computation the professor said this game has been played for 30+ years and never had anyone being able to get beyond 3 standard deviation and I was his first student to hit beyond 3 std deviation in this game. And in front of the class he said he's going to write to other professors, in other universities who uses this game, to demonstrate the notion that hitting beyond 3 std deviation is in fact possible.


I don't remember the details of the game or the name of the game. it's just something about real life application of standard deviation and averages.


:)
 
btw, I have updated my link to make it available for all to download.


https://docs.google.com/open?id=0B1Yt3Yl95LuPUnY5R1VMNWQ1eDg
 
You must log in or register to reply here.
Back
Top