Jump to content


Welcome to BrainDen.com - Brain Teasers Forum

Welcome to BrainDen.com - Brain Teasers Forum. Like most online communities you must register to post in our community, but don't worry this is a simple free process. To be a part of BrainDen Forums you may create a new account or sign in if you already have an account.
As a member you could start new topics, reply to others, subscribe to topics/forums to get automatic updates, get your own profile and make new friends.

Of course, you can also enjoy our collection of amazing optical illusions and cool math games.

If you like our site, you may support us by simply clicking Google "+1" or Facebook "Like" buttons at the top.
If you have a website, we would appreciate a little link to BrainDen.

Thanks and enjoy the Den :-)
Guest Message by DevFuse
 

Photo
- - - - -


  • Please log in to reply
9 replies to this topic

#1 dini

dini

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 18 June 2009 - 11:58 AM

Hi to all of you, I'm new here...
Can somebody help me how to fill in these numbers to this chess board?
I attach the file below, name ChessBoard.xls.
Thanks.

Attached Files


  • 0

#2 dev08

dev08

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 18 June 2009 - 12:18 PM

can u please rephrase the problem.....i am not able to get the problem fully.....:)
  • 0

#3 dini

dini

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 18 June 2009 - 12:30 PM

Hi dev08,
Can you see its pattern? If you do, please continue the board/table for columns 201,202,203, and so on...
Thx.

Edited by dini, 18 June 2009 - 12:36 PM.

  • 0

#4 Pero

Pero

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 18 June 2009 - 12:53 PM

I still don't get it! :blush: :huh:
  • 0

#5 ecky999

ecky999

    Newbie

  • Members
  • Pip
  • 15 posts

Posted 18 June 2009 - 01:43 PM

I see what you want with the chess board, but i need help understanding the pattern on the top 4 rows of data. email me at ecky999@hotmail.com with that pattern (or how it is mathematically deduced) and i believe i can make it for as many columns as you want.
  • 0

#6 Wlado

Wlado

    Junior Member

  • Members
  • PipPip
  • 76 posts

Posted 18 June 2009 - 02:05 PM

Wow, it's pretty complex, screw that! :D
  • 0

#7 ecky999

ecky999

    Newbie

  • Members
  • Pip
  • 15 posts

Posted 18 June 2009 - 02:10 PM

or if you want me to only supply you with a formula to fill in the "chess board", change Excel to use R1C1 reference (tools, options, general tab, check the R1C1 reference style) then use this formula on all squares throughout the chess board:

=IF(OR(R3C=RC2,R4C=RC2,R5C=RC2,R6C=RC2),ROW()-7,"")

this formula will use 4 data rows at the top and fill in the pattern that you have shown.

by the way, this doesn't seem much like a puzzle that belongs on this group.
  • 0

#8 Glycereine

Glycereine

    Senior Member

  • Members
  • PipPipPipPip
  • 1909 posts

Posted 18 June 2009 - 11:24 PM

by the way, this doesn't seem much like a puzzle that belongs on this group.


That's because I think it's his homework -_-
  • 0

#9 dini

dini

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 19 June 2009 - 09:00 AM

Hi too to you guys,
I only remapped 4 data rows at the top to the chess board below. I don’t know for sure its pattern. Here’s my observations to 4 data rows at the top:
1). So many numbers have difference = 10,20, and or 30 diagonally and or vertically (am I correct using the word “difference”?).
Example
1 on row a column 1 diagonally has difference = 30 to 31 on row d column 4.
40 on row d column 1 diagonally has difference = 10 to 30 on row c column 2, and diagonally has difference = 20 to 20 on row b column 3.
30 on row c column 2 vertically has difference = 10 to 40 on row d column 2.

2). Also so many numbers in the same row also have difference = 4 to its next forty columns.
Example
15 on row b column 2 has difference = 4 to 11 on row b column 42.
33 on row d column 41 has difference = 4 to 37 on row d column 81.

But not all of the numbers have difference = 10, that’s why I don’t know how to calculate it. I think this could use increment of abscissa that not linear with the increment of ordinate, abscissa can be ordinate and vice versa to the next how many column, in parallelogram direction...???

Thx.

Edited by dini, 19 June 2009 - 09:08 AM.

  • 0

#10 phillip1882

phillip1882

    Senior Member

  • Members
  • PipPipPipPip
  • 765 posts

Posted 20 June 2009 - 01:29 PM

if the pattern was more regular i might be inclined to "solve" this puzzle. you just took what looks to be a random set of numbers and then put all 1's on row 1, all 2's on row 2, etc. and then ask us to fill in the rest. the rest of what? the chess board? well that's easy just make row 1 all 1's row 2 all 2's etc. if your asking us to find some pattern in the random numbers i would have to decline. just do a random number generator. if you honestly believe there to be a pattern then it should be simple enough to program one in. in any case, this isn't the type of thing that belongs here.
  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users