ABCDEFIJKLMNOPQRSTUVWXYZ
1
variablesoutputs/calcsvariables
2
Total allocation (USD)$100,000formulas
3
Allocation value (USD)$1,000.00constants
4
Tickets & amount to be collected
5
Winning tickets100.00
6
constantsTicket needed to cover probability const.77.00
7
Tranche 0 (early adopters) minimal DAO treshold500Tickets deficit/excess23.00
8
Tranche 1 minimal DAO treshold2000Suggested allocation value (USD)$1,298.70
9
Tranche 2 minimal DAO treshold3000Exact amount collected$100,000
10
Tranche 3 minimal DAO treshold5000
11
Tranche 4 minimal DAO treshold10000
12
Participantselligibleparticipaiting
13
Tranche 0 winning chances1.0%Early adopters12311000
14
Tranche 1 winning chances2.0%tranche 1640502
15
Tranche 2 winning chances3.5%tranche 2549429
16
Tranche 3 winning chances6.0%tranche 3151117
17
Tranche 4 winning chances10.0%tranche 4371311
18
Total number of participants29422359
19
20
Probability progression
21
T1 -> T0 probability progression200%
22
T2 -> T0 probability progression350%
23
T3 -> T0 probability progression600%
24
T4 -> T0 probability progression1000%
25
26
27
Winning ticketscalculatedadjusted
28
Number of winning tickets (t0) 1014
29
Number of winning tickets (t1) 1115
30
Number of winning tickets (t2) 1620
31
Number of winning tickets (t3) 812
32
Number of winning tickets (t4) 3235
33
34
Actual chances of winning (t0) - check1.00%1.40%
35
Actual chances of winning (t1) - check2.19%2.99%
36
Actual chances of winning (t2) - check3.73%4.66%
37
Actual chances of winning (t3) - check6.84%10.26%
38
Actual chances of winning (t4) - check10.29%11.25%
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