Ryan, you have infected me. The other day I was listening to another podcast and they were talking about a MOBA. Instantly, I said "MOOBAA, DOOTTAA" out loud in a droning voice. Good thing I was alone in my car and not in public.
Nick, I would like to formally request more board game talk, as I am playing board games regularly now.
Thank you, - Justin
Wednesday, August 5, 2015
Thursday, July 30, 2015
Hi Tom and Eric, I have a question. I've recently started playing boardgames at a few friendly local game stores, and I want to support them financially. I use their facilities for free week after week so I figured it's only fair that I try to buy my games there. The problem is they are a lot more expensive than online retailers. I was expecting to pay more than online, but it's kind of ridiculous how much more they are sometimes. For example, I just bought Heavy Steam for almost $30 more than I could have gotten it on Cool Stuff. That's a lot of dough. I also am trying to stick to a board game budget, which incentivizes me to go for the best deal possible. But the store is often the worst deal possible. Should I just bite the bullet and pay the extra $$$ to support the store? Or is it ok to freeload in the store without patronizing it? Or should I do a little of both? Thanks for any advice you can give.
Monday, April 27, 2015
Excel Tips
In LibreOffice Calc to get a random cell between cells B3 and B9 of Sheet1 you can do:
As the following screenshot shows, you have a range of data from A1 to A15, the Rand and Index formula can help you display the random cells in a new column. Please do as follows:

1. In the adjacent cell such as B1, enter the formula =RAND(), and press the Enter key, then copy the formula to the cell B15. And the random values will be filled with the cells. See screenshot:

2. Then in the next cell over, in this case cell C1, enter the formula =INDEX($A$1:$A$15,RANK(B1,$B$1:$B$15)).

3. Then press Enter key, and select the cell C1, drag the fill handle to cover as many cells as desired selections. And random 5 cells of range A1:A15 have been displayed in the column C. See screenshot:

=INDEX(Sheet1.B3:B9, RANDBETWEEN(1,5))
As the following screenshot shows, you have a range of data from A1 to A15, the Rand and Index formula can help you display the random cells in a new column. Please do as follows:
1. In the adjacent cell such as B1, enter the formula =RAND(), and press the Enter key, then copy the formula to the cell B15. And the random values will be filled with the cells. See screenshot:
2. Then in the next cell over, in this case cell C1, enter the formula =INDEX($A$1:$A$15,RANK(B1,$B$1:$B$15)).
3. Then press Enter key, and select the cell C1, drag the fill handle to cover as many cells as desired selections. And random 5 cells of range A1:A15 have been displayed in the column C. See screenshot:
Subscribe to:
Posts (Atom)