I'm putting together a season long football pool. 1 team vs 16 opponents. I need to randomly generate 0-9 each week across 16 columns and 16 rows with a center square filled numbers 1-100. This must be simple. If you're smarter than me. Help?
brentkuckkan wrote:I'm putting together a season long football pool. 1 team vs 16 opponents. I need to randomly generate 0-9 each week across 16 columns and 16 rows with a center square filled numbers 1-100. This must be simple. If you're smarter than me. Help?
TIA
I am not following this.
Are you saying that you want a matrix of 16 X 16 filled with random numbers ranging from 1:9, that is 256 numbers from 0-9 (seems unlikely) or;
You want a 16 X 16 matrix with the column and row names consisting of the 1:9 random numbers with the actual matrix consisting of numbers from 1:100. If this latter one, you only have 100 number and 256 cells. How do you wan to fill in the values for those cells?
The center matrix is 10x10 consisting of 1-100 in order. These numbers correspond to the names of the people in the pool. Extending vertically from the top will be 16 rows of 10 columns with each row representing one game/one opponent. Every number 0-9 (representing the last digit in the opponents score) must be used and used only once. Each row must be randomly different. Extending from the right of the center matrix will be 16 columns 10 rows high with each column representing one game/the Packers. Every number 0-9 (representing the last digit in the Packers score) must be used and used only once. 320 numbers will be generated. 100 numbers filled in order. Essentially one 16x10 matrix vertically and one 16x10 matrix horizontally joined by a 10x10. All I really need to know is if there is a way to generate 0-9 randomly and exclusively across 10 cells up and down and across. The link provided doesn't seem to answer my question.
brentkuckkan wrote:The center matrix is 10x10 consisting of 1-100 in order. These numbers correspond to the names of the people in the pool. Extending vertically from the top will be 16 rows of 10 columns with each row representing one game/one opponent. Every number 0-9 (representing the last digit in the opponents score) must be used and used only once. Each row must be randomly different. Extending from the right of the center matrix will be 16 columns 10 rows high with each column representing one game/the Packers. Every number 0-9 (representing the last digit in the Packers score) must be used and used only once. 320 numbers will be generated. 100 numbers filled in order. Essentially one 16x10 matrix vertically and one 16x10 matrix horizontally joined by a 10x10. All I really need to know is if there is a way to generate 0-9 randomly and exclusively across 10 cells up and down and across. The link provided doesn't seem to answer my question.
-
Now I have a better idea of what you want. No the link did not answer the question unfortunately. I don't see any easy way to enforce unique choices there.
Is the attached file what you want? Not done in Calc but if it looks like what you want perhaps a better Calc expert can figure out how to do it. Otherwise I can send you the code and links to the software that I used to produce it. Actually I produced three matrices and pasted them together in Calc.
BTW, if the 1:100 is in the wrong order, you should be able to do a copy > Paste Special > Transpose to rearrange it.
Yes! Exactly. Awesome. Thank You! Now, um, uh, is there any way I could get a second one? Or perhaps even better just the instructions on how to do it?
brentkuckkan wrote:Yes! Exactly. Awesome. Thank You! Now, um, uh, is there any way I could get a second one? Or perhaps even better just the instructions on how to do it?
No problem. Attached is a second one.
I'll PM you with some detailed instructions. It is acually very simple to do, just not something a spreadsheet is set up to do easily.
RANK can generate the required sets of numbers. See attached. It will generate new sets each time the file is opened or if you make changes to cells. To stop that, either save a copy as PDF (File > Export to PDF) or remove the formulas (select cells, Edit > Copy, then Edit > Paste Special, unchecking Paste All, and checking all the boxes except Formulas. Then save the non-formula file using a different name (File > Save As). Open the original file to generate further sets.