Forum Discussion
Solved
Creating sports wrist play call sheet arm band
Hi, I coach softball and I am trying to learn how to create a play call sheet for my player's wristbands that they wear during the games. I will signal the play to the catcher and she will relay...
BigWheels8 maybe amit_bhola solution is good enough, that would be great. But for the fun of it I worked out a sheet that might be useful. you can easily print it to both show the grid and the definitions of the numbers/letters and easily change and it guarantees that every possible combination is used at least once (assuming the grid is large enough). File attached.
The answer is yes but some details are still confusing to me.
First off, lets get some conventions straight. you say row first 15, then column 1 but 15 is the title of the column and 1 is the title of the corresponding row so if you want 151 that would be column-row.
Next a question of numbers: you give 4 numbers and 5 letters which makes 20 unique combinations but the grid is 6x6 which is 36 possibilities. Do you WANT to have repeats in the grid (as shown in your image you example D3 is 151 AND 102 AND 105 AND 142). Maybe I should ask instead is if the grid will always be that 6x6? After using up all the combinations should the rest be filled in? Is it ok to fill in the rest in the same 'random' order (e.g. 100 would be same as 123 and then 110 would be same as 133 ...)? Or should the grid resize (e.g. columns would be 10 - 14 because there are 5 possible letters and rows would be 0 - 3 because 4 possible numbers but the actual location of each combination would still be randomized)?
And the MOST important question I have is if you have Excel 365 (i.e. the latest version with LET() function and dynamic arrays)? Basically type =LET and see if excel recognizes that as a function.
First off, lets get some conventions straight. you say row first 15, then column 1 but 15 is the title of the column and 1 is the title of the corresponding row so if you want 151 that would be column-row.
Next a question of numbers: you give 4 numbers and 5 letters which makes 20 unique combinations but the grid is 6x6 which is 36 possibilities. Do you WANT to have repeats in the grid (as shown in your image you example D3 is 151 AND 102 AND 105 AND 142). Maybe I should ask instead is if the grid will always be that 6x6? After using up all the combinations should the rest be filled in? Is it ok to fill in the rest in the same 'random' order (e.g. 100 would be same as 123 and then 110 would be same as 133 ...)? Or should the grid resize (e.g. columns would be 10 - 14 because there are 5 possible letters and rows would be 0 - 3 because 4 possible numbers but the actual location of each combination would still be randomized)?
And the MOST important question I have is if you have Excel 365 (i.e. the latest version with LET() function and dynamic arrays)? Basically type =LET and see if excel recognizes that as a function.
- mtarler-sorry, I confused the rows and columns. I corrected that in my post. Anyway, to answer your questions:
1. Yes, I do want to have repeat signs throughout the grid after the 20 unique combinations are used.
2. I plan on using the 6x6 grid and repeating it. The rows in the first grid I would use before the sample would be 00, 01, 02, 03, 04, 05. Followed by my example of 10, 11, 12, 13, 14, 15. Next, I would skip count and the next section will be 20, 21, 22, 23, 24, 25, etc. The first column will always be 0-5.
3. I have MS Office 2016
