User:Betsumei/Character Picker
Jump to navigation
Jump to search
If you're like me, you've got a whole lot of alts and not a whole lot of decision making ability. Sure, you could roll dice to see whose turn it is to get played today, but that's too random; maybe you want to make it a weighted chance?
Good news! It's possible with just your spreadsheet application of choice and a minimum of data entry.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Lookup | Odds | Name | Level | Weight |
| 2 | =B2[1] | =E2/$E$5[2] | Character 1 | 50 | =MAX((51-D2),1) |
| 3 | =A2+B3 | =E3/$E$5[2] | Character 2 | 5 | =MAX((51-D3),1) |
| 4 | =A3+B4 | =E4/$E$5[2] | Character 3 | 15 | =MAX((51-D4),1) |
| 5 | =SUM(B2:B4)[3] | =SUM(E2:E4)[4] | |||
| 6 | |||||
| 7 | Selection is: | =VLOOKUP(rand(),$A$2:$C$16,3,true)[5] |
Just add as many lines fashioned after rows 3-4 as you need (row 2 is a bit unique because there's no data above it), and the VLOOKUP function will pick a character for you. Use whatever formula you want in column E to determine the relative weights of characters; I chose to make the weight based on how many levels they have to gain.
- ↑ If the mismatch bothers you, put a zero in A1 and set this one to =A1+B2.
- ↑ 2.0 2.1 2.2 Replace $E$5 with the cell reference to the sum of the weights.
- ↑ This isn't strictly necessary, but if it comes up with an answer other than 100% something is wrong.
- ↑ Edit this formula's range to include all the weights.
- ↑ Replace $C$16 with the cell reference to the last entry in the name column.