摘要 |
PROBLEM TO BE SOLVED: To solve problems in which the arrangement of problems has to be arranged on a space accurately and easily in order to identify a correct answer value, and in difficult problems, correct answer candidate values of remaining blank cells are assumed as temporary correct answer values and trials have to be repeated, and therefore the answer by manual labor requires time.SOLUTION: An "answer table" of 9 times 9 cells of problems and a "sub-cell table" for automatically displaying correct answer candidate values of 9 cells every cell are provided on the Excel. A new correct answer value is input in the "problem table", and when removed from the "sub-cell table" of remaining blank cells where the numeric value may not become the correct answer value, the correct answer candidate value becomes one in some blank cell and it becomes the correct answer value of the cell. The problem where the correct answer candidate values may not become one on the way due to few hints is repeatedly subjected to answer processing by setting the correct answer candidate value remaining in the blank cell as a temporary correct answer value. The processing is completed when all cells contain numeric values and the numerical total is 405 for confirmation, and an answer progress is displayed on the screen. The series of processing is programmed by the Excel.SELECTED DRAWING: Figure 1 |