NSFW+ rewards - Google Sheets

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	Constants
2	REWARD_POOL	Use 50% of reward pool allocation	50,000,000
3	REWARD_PHASE_COUNT	Duration of reward program (months)	24
4	REFERRAL_FAN_REWARD	Condition: When referrer spends 50 USD	5	1156
5	REFERRAL_CREATOR_REWARD	Condition: Must KYC, Creator must earn 100 USD, Be active for a month	75	17337
6
7	CREATOR_USAGE_REWARD	Condition: Secret, calculated and claimable at end of phase	??
8	FAN_USAGE_REWARD	Condition: Secret, calculated and claimable at end of phase	??
9						N_REFERRALS_CREATORS	3
10	USAGE_REWARD_ALLOCATION	Optimised for usage over referrals	60.00%			N_REFERRALS_FANS	5
11	REFERRAL_REWARD_ALLOCATION		40.00%
12	REFERRAL_TOKEN_REWARD		20,000,000	10815
13	USAGE_TOKENS_REWARD		30,000,000
14
15	Assumptions
16			Phase A	Phase B	Phase C	Phase D	Phase E	Phase F
17	NSFW+_PRICE	Price of NSFW+ during phase	0.004326	0.006489	0.009734	0.014600	0.021900	0.032851
18	PHASE_TOTAL_REWARDS (NSFW+)	Total tokens allocated for phase	6,250,000	6,250,000	12,500,000	12,500,000	6,250,000	6,250,000	50,000,000
19	REWARD_POOL_VALUE (USD)	Theoritical USD value of phase	27,037.50	40,556.25	121,668.75	182,503.13	136,877.34	205,316.02	713,958.98
20	REWARD_DURATION_MONTHS	Duration of phase	3	3	6	6	3	3	24
21	PHASE_REWARDS_PCM (NSFW+)	Tokens per month of phase (indication)	2,083,333	2,083,333	2,083,333	2,083,333	2,083,333	2,083,333	12,500,000
22	REWARD_VALUE_PCM (USD)		9,013	13,519	20,278	30,417	45,626	68,439	187,291
23	Estimates (Monthly)
24	MAX_POSTING_INCENTIVES_PAYABLE (USD)	Maximum posting incentives PCM	5,408	8,111	12,167	18,250	27,375	41,063
25	MAX_REFERRALS_PAYABLE (USD)	Maximum referrals we can pay for (Fan+Creator) PCM	3,605	5,408	8,111	12,167	18,250	27,375
26	FANS_PCM	Max referrals (Fan only)	361	541	811	1217	1825	2738
27	CREATORS_PCM	Max referrals (Creator only)	24	36	54	81	122	183
28	Breakdown (Phase)
29	PHASE_POSSIBLE_FANS		1082	1622	4867	7300	5475	8213	28558
30	PHASE_POSSIBLE_CREATORS		72	108	324	487	365	548	1904
31
32	Example as a referrer
33	Referring creators	Tokens earned if referring {n} creators	52011	34674	23116	15411	10274	6849	142335
34	Referring fans	Tokens earned if referring {n} fans	5779	3853	2568	1712	1142	761	15815
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