VioletTesla
New Member
- Joined
- Apr 13, 2017
- Messages
- 1
I'm an after-school educational assistant working with young kids with a focus on math. If I can figure out how to get this to work in Excel (Using the 2016 version), I'll be using these puzzles on a yearly basis (switching from addition/subtraction to multiplication/division ect.) Anyway, the puzzles are similar to Magic Squares, where every row/column/diagonal equals the same value, but for my puzzles these r/c/d values are already known, and the values aren't all the same.
My goal at the end of this would be to have the kids create their own puzzles and pass them for others to solve, giving them an understanding on all sides of the subject, and to do that, I'd like for them to be able to use an Excel book that solves for a given puzzle. The only restrictions on the puzzles would be that each value can only be from Zero to Nine, but duplicate numbers can appear in a row/column/diagonal.
Hopefully this makes sense, below are a few tables I've tried to stitch together explaining a 4x4 puzzle:
The above demonstrates how a Excel should display the information, and below I've provided the beginnings of a puzzle with that display:
Here you can see that the solution to A+4+C+9=27 [Row 1] must work together with A+8+0+M=22[Column 1] , C+G+K+9=23 [Column 3] , and A+F+K+P=23 [Diagonal 2] .
One possible solution is listed below, and my goal is to code(? write?) an Excel sheet in a way that will solve for all of the previously blank values above (represented by letters).
The closest I've gotten is to have A+4+C+9=27 and then 27-A+4+C+9 , which will give me a 14 , telling me that A+C=14 , but it doesn't solve for A or C when compared to [Column 1] or [Column 3], much less the entire grid. EXAMPLE:
Is it even possible to solve for this on Excel? Am I just too inexperienced with the program? I'd appreciate as much help as you can give, and if I can provide any more information let me know!! Thanks in advance!
My goal at the end of this would be to have the kids create their own puzzles and pass them for others to solve, giving them an understanding on all sides of the subject, and to do that, I'd like for them to be able to use an Excel book that solves for a given puzzle. The only restrictions on the puzzles would be that each value can only be from Zero to Nine, but duplicate numbers can appear in a row/column/diagonal.
Hopefully this makes sense, below are a few tables I've tried to stitch together explaining a 4x4 puzzle:
The above demonstrates how a Excel should display the information, and below I've provided the beginnings of a puzzle with that display:
Here you can see that the solution to A+4+C+9=27 [Row 1] must work together with A+8+0+M=22[Column 1] , C+G+K+9=23 [Column 3] , and A+F+K+P=23 [Diagonal 2] .
One possible solution is listed below, and my goal is to code(? write?) an Excel sheet in a way that will solve for all of the previously blank values above (represented by letters).
The closest I've gotten is to have A+4+C+9=27 and then 27-A+4+C+9 , which will give me a 14 , telling me that A+C=14 , but it doesn't solve for A or C when compared to [Column 1] or [Column 3], much less the entire grid. EXAMPLE:
Is it even possible to solve for this on Excel? Am I just too inexperienced with the program? I'd appreciate as much help as you can give, and if I can provide any more information let me know!! Thanks in advance!
