EB_test_coh

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2
3	Overview of the test cohort			Stage 0	Stage 1	Stage 2	Stage 3	Allumni
4			Funnel	171	16.8	8.4	4.2	2.1
5			Onchain tech (WEB3(DOT)+WEB2)		11.76	5.88	2.94	1.47
6			Offchain tech (WEB2 + WEB3(DOT))		5.04	2.52	1.26	0.63
7
8	Funding metrics
9		Funding, USD		Stage 0	Stage 1	Stage 2	Stage 3	Allumni
10			Onchain tech	0	6000	12000	12000	0
11			Offchain tech	0	4000	8000	8000	0
12			DOT UPS tech using bonus	0	2000	0	0	0
13			Mentor (per team (10 weeks/4+h per week))	0	0	0	1000	0
14		Conversion metrics
15			Conversion to the next stage (enter)	0	5%	50%	50%	50%
16			Enreach builders down coef	5%
17			Wating builders churn	5%
18			Onchain tech (WEB3(DOT)+WEB2)	70%
19			Offchain tech (WEB2 + WEB3(DOT))	30%
20			Onchain DOT UPS tech using bonus (percent from total)	50%
21			Offchain DOT UPS tech using bonus (percent from total)	30%
22			Blocked for better perfomance	20%
23		Total funding
24			Onchain tech		70560	70560	35280
25			Offchain tech		20160	20160	10080
26			Grand total		90720	90720	45360
27
28		Staff
29			Support per team, hours	2	3	4	5	0
30			Total support	342	50.4	33.6	21	0
31			Support staff (fulltime staff)	2.1375	0.315	0.21	0.13125	0
32		Hour rate
33			Support staff	25
34			Relations manager/coordination	40
35			Social media	25
36			Skilled copywrigther	25
37		Support staff
38			Additional Curators (USD, per review)	100
39
40
41	Funnel and growth			month_1	month_2	month_3	month_4	month_5	month_6	month_7	month_8	month_9	month_10	month_11	month_12	month_13	month_14
42		Stage_0
43			New Builders aware	60	57	54	0	0	0	0	0	0	0	0	0	0	0
44			Builders (deciding to MVP)	60	114	162	0	0	0	0	0	0	0	0	0	0	0
45		Stage_1 (1 month delay mid)
46			Onchain tech number of the teams		2.1	3.99	5.67	0	0	0	0	0	0	0	0	0	0
47			Offchain tech number of the teams		0.9	1.71	2.43	0	0	0	0	0	0	0	0	0	0
48			Onchain tech spend funding		12600	23940	34020	0	0	0	0	0	0	0	0	0	0
49			Offchain tech spend funding		3600	6840	9720	0	0	0	0	0	0	0	0	0	0
50			UPS tech using bonus		2640	5016	7128	0	0	0
51		Stage_2 (2 month delay mid)
52			Onchain tech number of the teams				1.05	1.995	2.835	0	0	0	0	0	0	0	0
53			Offchain tech number of the teams				0.45	0.855	1.215	0	0	0	0	0	0	0	0
54			Onchain tech spend funding				12600	23940	34020	0	0	0	0	0	0	0	0
55			Offchain tech spend funding				3600	6840	9720	0	0	0	0	0	0	0	0
56		Stage_3 (2 month delay mid)
57			Onchain tech number of the teams						0.525	0.9975	1.4175	0	0	0	0	0	0
58			Offchain tech number of the teams						0.225	0.4275	0.6075	0	0	0	0	0	0
59			Onchain tech spend funding						6300	11970	17010	0	0	0	0	0	0
60			Offchain tech spend funding						1800	3420	4860	0	0	0	0	0	0
61			Advisers Onchain tech						525	997.5	1417.5	0	0	0	0	0	0
62			Advisers Offchain tech						225	427.5	607.5	0	0	0	0	0	0
63		Allumni (2 month delay mid)
64			Onchain tech number of the teams								0.2625	0.49875	0.70875	0	0	0	0
65			Offchain tech number of the teams								0.1125	0.21375	0.30375	0	0	0	0
66
67			Total team funding	0	18840	35796	67068	30780	52590	16815	23895	0	0	0	0	0	0
68
69		Staff, hour rate
70			Team support (all stages), total hours	120	237	341.1	30.3	11.4	19.95	7.125	10.125	0	0	0	0	0	0
71			Program maintaince (main curator + coordinator)	80	80	80	80	80	80	80	80	80	80	0	0	0	0
72		Marketing, hour rate
73			Marketing per team, $k	0	0	0	0	0	0	0	0	0	0	0	0	0	0
74			Social media (copywrigther)	160	160	160	0	0	0	0	0	0	0	0	0	0	0
75			PR	0	0	0	0	0	0	0	0	0	0	0	0	0	0
76
77		Staff costs
78			Support staff	3000	5925	8527.5	757.5	285	498.75	178.125	253.125	0	0	0	0	0	0
79			Relations manager/coordination	3200	3200	3200	3200	3200	3200	3200	3200	3200	3200	0	0	0	0
80			Social media	4000	4000	4000	0	0	0	0	0	0	0	0	0	0	0
81			PR	0	0	0	0	0	0	0	0	0	0	0	0	0	0
82		Additional staff costs
83			2x curators	0	600	1140	1920	570	960	285	405	0	0	0	0	0	0
84
85		One-time costs
86			website + branding	3500
87			documents (copy + dis)	3500
88		Total
89			Team Funding	0	18840	35796	67068	30780	52590	16815	23895	0	0	0	0	0	0
90			Staff	10200	13725	16867.5	5877.5	4055	4658.75	3663.125	3858.125	3200	3200	0	0	0	0
91			other	7000	0	0	0	0	0	0	0	0	0	0	0	0	0
92
93			Grand total	17200	32565	52663.5	72945.5	34835	57248.75	20478.125	27753.125	3200	3200	0	0	0	0
94
95			Grand total + extra for better perfomance (only stage_2+)	17200	32565	52663.5	87534.6	41802	68698.5	24573.75	33303.75	3840	3840	0	0	0	0
96
97			Staff percent (general case)	100%	42%	32%	8%	12%	8%	18%	14%	100%	100%	0%	0%	0%	0%
98			Funding percent (general case)	0%	58%	68%	92%	88%	92%	82%	86%	0%	0%	0%	0%	0%	0%
99
100