ABCDEFGHIJ
1
NameRoll MechanismValueAttendant
Target Number
2
StepsHow it works!
3
1Type persons name in first column "Name"
4
2If a person buys multiple tickets, then put their name in multiple times one after the other
5
3The sheet will automatically make them a roll between 0-999
6
4Select the values generated and copy them. DON'T PASTE YET!
7
5Left click the next empty cell in the value column.
8
6Right click the cell. Go to "Paste special" then "Paste values only"
9
7Congratulations! Their rolls are recorded. Repeat as necessary for all other tickets.
10
8Once a roll is recorded in the Value column, the Roll Mechanism column goes blank!
11
8aIf you need to clear the sheet: Only delete values in the "Name" and "Value" column!
12
13
RAND function properly simulates the ingame roll system as they both
14
follow a uniform distribution (i.e. all values have the same probability of occurring)
15
16
17
StepsHow to determine winner!
18
1Select columns A through C
19
2Click Data, then go to "Sort Range"
20
3Checkmark the "Data has header row" box
21
4Change "Sort by" from "Name" to "Value"
22
5Change Sort from A --> Z to Z --> A.
23
5aZ --> A sorting puts the largest number at the top.
24
6If the target value is below 500, then keep it at A --> Z
25
7If done correctly, the highest value will be near the top and the column headers will not move.
26
8Scroll down until you find values close to the target number, then determine the winner.
27
28
But Leggerless, I have multiple items!
29
30
Oh, that's fine. Go to the sheets tab, right click the main sheet, then click "Duplicate"
31
Do this for however many items you are raffling off!
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100