|
Post by hotfuzz1980 on Jan 1, 2022 17:33:33 GMT -5
I like this concept and is something I have been contemplating doing myself. With two kids now, my time is more limited but with so many great cards to use I think this method might be the best balance, especially for someone like me that wants to do a territory style. Any chance you might be willing to share that spreadsheet? I’m always looking for a good spreadsheet to use with the game. If not I understand. I went ahead and did a copy/paste of my sheet without any results or rosters filled in - but this should let you see the layout. docs.google.com/spreadsheets/d/1c0f5B9sqt8v9xICWjkJ6wrLnnX2PxptiN_EcBoGu_gs/edit?usp=sharingThis is very cool..thanks for sharing!
|
|
|
Post by "Dr Death" Ric Anderson on Jan 1, 2022 23:19:22 GMT -5
This is really awesome. How to you randomly choose who gets the world title shots?
|
|
|
Post by jobber83 on Jan 2, 2022 0:09:41 GMT -5
This is really awesome. How to you randomly choose who gets the world title shots? I have a formula in excel that I uses that randomly selects a wrestler. It should work the same in Google Sheets. I’ll share the formula if anyone wants it. I posted it somewhere here before as well.
|
|
|
Post by throwingtoasters on Jan 2, 2022 1:04:24 GMT -5
Great stuff jobber83. Would love to see more. Love this kind of stuff.
|
|
|
Post by jobber83 on Jan 2, 2022 11:50:33 GMT -5
Here is the formula for the random selection:
=INDEX($A$103:$A$109,RANDBETWEEN(1,COUNTA($A$2:$A$100)),1)
1. What you will want to do is take the above formula and go to your "free agents" tab on your sheet.
2. Have your free agents listed in column "A". Depending on the number of cards you have you might be filling out names from column A row 2 for awhile, but just edit the numbers in the above formula for the cells you've filled out. For example, if you have 56 extra wrestlers, you would fill out the names in Column A, starting in row 2 and going all the way down to row 57 when you've entered all the names. If you have 100 extra wrestlers, then you would start at Column A row 2 and go down to row 101...whatever row you start and stop at is what you will enter for the ($A$2:$A$xxx) section of the formula
3. Once you've entered all extra wrestlers/free agent names on your list, then go to a new column (this could be column B to column Z - however you choose to lay it out is up to you) and enter the formula.
4. Once entered, the formula will auto populate a name and you can keep refreshing the cell the formula is in for a new name each time.
Hopefully that helps. I'm not the best at explaining things articulately, so I hope it made sense, if it doesn't shoot me your questions or maybe someone else on here can explain a little more clearly than me if there is any confusion.
|
|
|
Post by jobber83 on Jan 2, 2022 11:51:26 GMT -5
Great stuff jobber83 . Would love to see more. Love this kind of stuff. Thanks Toasterboy! I just found your channel on YouTube, so I have been enjoying your Memphis fed matchcards on there!
|
|
|
Post by LAWraith on Jan 2, 2022 12:32:14 GMT -5
jobber83 that's a pretty neat formula there. Good job. My excel spreadsheet is why I still play the game lol.
|
|