Animator wrote:But what's the bottom line of the question? How to verify a grid easily, as a human...
1 2 3 | 3 8 4 | 7 8 9 1190
4 5 6 | 8 6 9 | 1 3 3 962 1022 1148 1010
7 8 9 | 1 1 5 | 4 4 6 1028
-------+-------+-------
2 3 1 | 5 6 4 | 8 9 7 1022
5 6 4 | 8 9 7 | 2 3 1 1022 1022 1022 1022
8 9 7 | 2 3 1 | 5 6 4 1022
-------+-------+-------
3 1 2 | 6 4 5 | 9 7 8 1022
6 4 5 | 9 7 8 | 3 1 2 1022 1022 1022 1022
9 7 8 | 3 1 2 | 6 4 5 1022
1 1 1 1 1 1 1 1
0 0 0 1 0 9 0 0 0
2 2 2 4 5 9 2 1 2
2 2 2 2 2 8 2 0 2
Animator wrote:Both of you are incorrect...
Calculate 4² + 5² + 6², then calculate 2² + 3² + 8². The result is the same, meaning that the sequence 4 5 6 can be replaced with 2 3 8. (I'm pretty sure there are other combinations aswell, but I only care about one, since that prooves my point)
An example (incorrect) grid:1 2 3 | 2 3 8 | 7 8 9
4 5 6 | 7 8 9 | 1 2 3
7 8 9 | 1 2 3 | 4 5 6
-----------------------
5 6 4 | 8 9 7 | 2 3 1
2 3 1 | 3 8 2 | 8 9 7
8 9 7 | 2 3 1 | 5 6 4
-----------------------
6 4 5 | 9 7 8 | 3 1 2
3 1 2 | 8 2 3 | 9 7 8
9 7 8 | 3 1 2 | 6 4 5
Animator wrote:That wasn't very clear...
But, do you really believe a human will go to the process of calculating all those things just to verify if the grid is correct?
Then it would be easier just to look at each individual number and see if it occures on/in every row, column and box
2 3 7 | 2 3 4 | 7 8 9
2 3 4 | 7 8 9 | 1 5 6
7 8 9 | 1 5 6 | 2 3 4
-----------------------
3 7 2 | 3 4 2 | 8 9 7
3 4 2 | 8 9 7 | 5 6 1
8 9 7 | 5 6 1 | 3 4 2
-----------------------
7 2 3 | 4 2 3 | 9 7 8
4 2 3 | 9 7 8 | 6 1 5
9 7 8 | 6 1 5 | 4 2 3
2 3 7 | 2 3 4 | 7 8 9 1064
2 3 4 | 7 8 9 | 1 5 6 1022 1064 1022 1022
7 8 9 | 1 5 6 | 2 3 4 1022
-------+-------+-------
3 7 2 | 3 4 2 | 8 9 7 1064
3 4 2 | 8 9 7 | 5 6 1 1022 1064 1022 1022
8 9 7 | 5 6 1 | 3 4 2 1022
-------+-------+-------
7 2 3 | 4 2 3 | 9 7 8 1064
4 2 3 | 9 7 8 | 6 1 5 1022 1064 1022 1022
9 7 8 | 6 1 5 | 4 2 3 1022
1 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0
6 6 6 2 2 2 2 2 2
4 4 4 2 2 2 2 2 2
Animator wrote:I was too lazy to do the calculations myself so I wrote a program, which proofes that the sum, and the sum of the square are not sufficient.
And here is a grid to prove it (1 5 6 = 2 3 7):2 3 7 | 2 3 4 | 7 8 9
2 3 4 | 7 8 9 | 1 5 6
7 8 9 | 1 5 6 | 2 3 4
-----------------------
3 7 2 | 3 4 2 | 8 9 7
3 4 2 | 8 9 7 | 5 6 1
8 9 7 | 5 6 1 | 3 4 2
-----------------------
7 2 3 | 4 2 3 | 9 7 8
4 2 3 | 9 7 8 | 6 1 5
9 7 8 | 6 1 5 | 4 2 3
If you really want to do it in Excel, then there is an easier way to flag the incorrect ones.
Use conditional formatting, in each cell you add the condition, and as condition, you count the number of times (there is a function like that) the cell's value occures in the row, column and box. If it is more then one you add the formatting, else you don't.
Animator wrote:I'm pretty sure your method will always works (or atleast when the input is limited to 1-9)
Animator wrote:What I'm wondering about at the moment is if it is possible to fool 1³ + 2³ + 3³ ...
Francisco wrote:So, for me I won't change my method of checking grids up, Because the 1st rule I use is not the Excel it's my mind...
scrose wrote:Animator wrote:I'm pretty sure your method will always works (or atleast when the input is limited to 1-9)
I think my method will also work when the input is something other than 1 through 9. For example, in a 2x5 grid ...
scrose wrote:The gist of my method is by identifying which numbers have been used. This is easiest to explain when using 2 as a base. ...
scrose wrote:Animator wrote:What I'm wondering about at the moment is if it is possible to fool 1³ + 2³ + 3³ ...
My guess is no.
So, to start with, we are looking for a³ + b³ = e³ + f³ where 1 <= a < b <= 9 and 1 <= e < f <= 9 and a <> e, a <> f, b <> e, b <> f. I couldn't find any {a,b,e,f} to satisfy these constraints.
scrose wrote:Francisco wrote:So, for me I won't change my method of checking grids up, Because the 1st rule I use is not the Excel it's my mind...
I'm impressed! For me, in my head, it is easier to scan a row/column/block for duplicates than try to make sure the sum is 45. You must be quite fast at doing sums in your head.