Peter Bartholomew
WellKnown Member
The exercise is to evaluate the material on a chess board at a given point during play.
In the attached workbook the lower part of the sheet contains the input range 'board' that defines the current position and a set of array constants that specifies the scoring scheme.
The objective is to create an array formula that will calculate the material value for both white and black pieces (as shown in the upper part of the sheet). By way of interest, the coloured version of the board is also drawn through the use of a single array formula.
If you would prefer an alternative challenge, you might like to consider the same problem but solved using Power Query (Get and Transform) instead of array formulas. This is shown on the second worksheet which also contains a table with the scoring scheme.
Note: The attached workbook contains possible solutions to the problem but is lightly protected so that, hopefully, it will not detract from the challenge.
In the attached workbook the lower part of the sheet contains the input range 'board' that defines the current position and a set of array constants that specifies the scoring scheme.
The objective is to create an array formula that will calculate the material value for both white and black pieces (as shown in the upper part of the sheet). By way of interest, the coloured version of the board is also drawn through the use of a single array formula.
If you would prefer an alternative challenge, you might like to consider the same problem but solved using Power Query (Get and Transform) instead of array formulas. This is shown on the second worksheet which also contains a table with the scoring scheme.
Note: The attached workbook contains possible solutions to the problem but is lightly protected so that, hopefully, it will not detract from the challenge.
Attachments

30.5 KB Views: 21