DCASK Balancer V2 LBP Simulator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	P	Q
1	Balancer Price Calculator		Download or copy to modify!		下载或复制以进行修改!
2	Sale duration	2	Days		Avg s/block	13.50		Ad hoc calculator			Capital from price calculator				Inputs	Outputs
3	Sale Rate	12,000,000	TKN/Day		Steps	72		Swap fee			TKN balance	50,000,000			Sale duration (in hours)	Total proceeds
4					Duration (hours)	48		TKN balance (pool)	50,000,000		Desired price	0.08	Type in desired price		Initial balances and weights	Unsold tokens
5	Demo video	https://vimeo.com/466075719			Duration (blocks)	12,800		USDC balance (pool)	$30,000.00		Required USDC	$37,878.75	System will find		Final weights	Price curve
6	(For V1, but similar)				Sale rate (hourly)	500,000		TKN weight	99				required amount		Sale Rate (TKN/Hr)
7								USDC weight	1				of reserve currency		Lot Size (average size of sale)
8			Start weight %	End weight %				Resulting USDC Price	$0.06				(Using TKN/weights		Swap fee
9	Initial TKN	50,000,000	99	10									from ad hoc)		Avg s/block
10	Initial USDC	$30,000.00	1	90				Resources
11								https://medium.com/balancer-protocol/a-new-paradigm-for-token-distribution-c82de13626bb
12	Lot Size	10,000	TKN		Proceeds	$260,150.00		https://medium.com/balancer-protocol/building-liquidity-into-token-distribution-a49d4286e0d4
13	Swap Fee				Unsold tokens	26,000,000
14								V1 Simulator
15	Max Price		You can enter the max price users are willing to pay here					https://docs.google.com/spreadsheets/d/1t6VsMJF8lh4xuH_rfPNdT5DM3nY4orF9KFOj2HdMmuY
16			It represents the price at which users will start buying (after the "price discovery" period)
17			And will halt buying if the price spikes above this value
18
19					TKN	USDC							SL(out); on lot size
20	Step	Blocks	Hours	TKN Price	Weights		TKN Balance	USDC Balance	Balance override		Sale rate override (tokens/day)		Slippage
21	0	0	0.00	$0.0600	99	1	50,000,000	$30,000.00	TKN	USDC			0.0101%
22	1	178	0.67	$0.0442	97.76	2.24	49,666,667	$49,999.34					0.0103%
23	2	356	1.33	$0.0366	96.53	3.47	49,333,333	$64,736.71					0.0105%
24	3	533	2.00	$0.0318	95.29	4.71	49,000,000	$76,932.28					0.0107%
25	4	711	2.67	$0.0285	94.06	5.94	48,666,667	$87,547.29					0.0109%
26	5	889	3.33	$0.0260	92.82	7.18	48,333,333	$97,051.45					0.0111%
27	6	1067	4.00	$0.0240	91.58	8.42	48,000,000	$105,715.90					0.0114%
28	7	1244	4.67	$0.0224	90.35	9.65	47,666,667	$113,714.09					0.0116%
29	8	1422	5.33	$0.0210	89.11	10.89	47,333,333	$121,165.06					0.0119%
30	9	1600	6.00	$0.0198	87.88	12.13	47,000,000	$128,154.77					0.0121%
31	10	1778	6.67	$0.0187	86.64	13.36	46,666,667	$134,747.72					0.0124%
32	11	1956	7.33	$0.0178	85.40	14.60	46,333,333	$140,993.87					0.0126%
33	12	2133	8.00	$0.0170	84.17	15.83	46,000,000	$146,932.80					0.0129%
34	13	2311	8.67	$0.0162	82.93	17.07	45,666,667	$152,596.57					0.0132%
35	14	2489	9.33	$0.0156	81.69	18.31	45,333,333	$158,011.57					0.0135%
36	15	2667	10.00	$0.0149	80.46	19.54	45,000,000	$163,199.82					0.0138%
37	16	2844	10.67	$0.0144	79.22	20.78	44,666,667	$168,179.97					0.0141%
38	17	3022	11.33	$0.0138	77.99	22.01	44,333,333	$172,967.94					0.0145%
39	18	3200	12.00	$0.0133	76.75	23.25	44,000,000	$177,577.47					0.0148%
40	19	3378	12.67	$0.0129	75.51	24.49	43,666,667	$182,020.53					0.0152%
41	20	3556	13.33	$0.0124	74.28	25.72	43,333,333	$186,307.58					0.0155%	Because sheets won't let you have multiple axes apparently!
42	21	3733	14.00	$0.0120	73.04	26.96	43,000,000	$190,447.89					0.0159%
43	22	3911	14.67	$0.0116	71.81	28.19	42,666,667	$194,449.65					0.0163%
44	23	4089	15.33	$0.0112	70.57	29.43	42,333,333	$198,320.20					0.0167%
45	24	4267	16.00	$0.0109	69.33	30.67	42,000,000	$202,066.10					0.0172%
46	25	4444	16.67	$0.0105	68.10	31.90	41,666,667	$205,693.26					0.0176%
47	26	4622	17.33	$0.0102	66.86	33.14	41,333,333	$209,207.04					0.0181%
48	27	4800	18.00	$0.0099	65.63	34.38	41,000,000	$212,612.29					0.0186%
49	28	4978	18.67	$0.0096	64.39	35.61	40,666,667	$215,913.43					0.0191%
50	29	5156	19.33	$0.0093	63.15	36.85	40,333,333	$219,114.50					0.0196%
51	30	5333	20.00	$0.0090	61.92	38.08	40,000,000	$222,219.20					0.0202%
52	31	5511	20.67	$0.0088	60.68	39.32	39,666,667	$225,230.92					0.0208%
53	32	5689	21.33	$0.0085	59.44	40.56	39,333,333	$228,152.80					0.0214%
54	33	5867	22.00	$0.0083	58.21	41.79	39,000,000	$230,987.72					0.0220%
55	34	6044	22.67	$0.0080	56.97	43.03	38,666,667	$233,738.35					0.0227%
56	35	6222	23.33	$0.0078	55.74	44.26	38,333,333	$236,407.16					0.0234%
57	36	6400	24.00	$0.0075	54.50	45.50	38,000,000	$238,996.43					0.0241%
58	37	6578	24.67	$0.0073	53.26	46.74	37,666,667	$241,508.30					0.0249%
59	38	6756	25.33	$0.0071	52.03	47.97	37,333,333	$243,944.75					0.0257%
60	39	6933	26.00	$0.0069	50.79	49.21	37,000,000	$246,307.62					0.0266%
61	40	7111	26.67	$0.0067	49.56	50.44	36,666,667	$248,598.64					0.0275%
62	41	7289	27.33	$0.0065	48.32	51.68	36,333,333	$250,819.40					0.0285%
63	42	7467	28.00	$0.0063	47.08	52.92	36,000,000	$252,971.41					0.0295%
64	43	7644	28.67	$0.0061	45.85	54.15	35,666,667	$255,056.08					0.0306%
65	44	7822	29.33	$0.0059	44.61	55.39	35,333,333	$257,074.71					0.0317%
66	45	8000	30.00	$0.0057	43.38	56.63	35,000,000	$259,028.53					0.0329%
67	46	8178	30.67	$0.0055	42.14	57.86	34,666,667	$260,918.69					0.0342%
68	47	8356	31.33	$0.0053	40.90	59.10	34,333,333	$262,746.27					0.0356%
69	48	8533	32.00	$0.0051	39.67	60.33	34,000,000	$264,512.28					0.0371%
70	49	8711	32.67	$0.0049	38.43	61.57	33,666,667	$266,217.65					0.0386%
71	50	8889	33.33	$0.0048	37.19	62.81	33,333,333	$267,863.28					0.0403%
72	51	9067	34.00	$0.0046	35.96	64.04	33,000,000	$269,449.99					0.0421%
73	52	9244	34.67	$0.0044	34.72	65.28	32,666,667	$270,978.55					0.0441%
74	53	9422	35.33	$0.0042	33.49	66.51	32,333,333	$272,449.69					0.0462%
75	54	9600	36.00	$0.0041	32.25	67.75	32,000,000	$273,864.07					0.0484%
76	55	9778	36.67	$0.0039	31.01	68.99	31,666,667	$275,222.34					0.0509%
77	56	9956	37.33	$0.0037	29.78	70.22	31,333,333	$276,525.07					0.0536%
78	57	10133	38.00	$0.0036	28.54	71.46	31,000,000	$277,772.80					0.0565%
79	58	10311	38.67	$0.0034	27.31	72.69	30,666,667	$278,966.05					0.0597%
80	59	10489	39.33	$0.0033	26.07	73.93	30,333,333	$280,105.28					0.0632%
81	60	10667	40.00	$0.0031	24.83	75.17	30,000,000	$281,190.92					0.0671%
82	61	10844	40.67	$0.0029	23.60	76.40	29,666,667	$282,223.36					0.0714%
83	62	11022	41.33	$0.0028	22.36	77.64	29,333,333	$283,202.96					0.0762%
84	63	11200	42.00	$0.0026	21.13	78.88	29,000,000	$284,130.06					0.0816%
85	64	11378	42.67	$0.0025	19.89	80.11	28,666,667	$285,004.94					0.0877%
86	65	11556	43.33	$0.0023	18.65	81.35	28,333,333	$285,827.88					0.0946%
87	66	11733	44.00	$0.0022	17.42	82.58	28,000,000	$286,599.10					0.1025%
88	67	11911	44.67	$0.0020	16.18	83.82	27,666,667	$287,318.82					0.1117%
89	68	12089	45.33	$0.0019	14.94	85.06	27,333,333	$287,987.21					0.1224%
90	69	12267	46.00	$0.0017	13.71	86.29	27,000,000	$288,604.41					0.1351%
91	70	12444	46.67	$0.0015	12.47	87.53	26,666,667	$289,170.56					0.1503%
92	71	12622	47.33	$0.0014	11.24	88.76	26,333,333	$289,685.73					0.1690%
93	72	12800	48.00	$0.0012	10	90	26,000,000	$290,150.00					0.1923%
94
95
96
97
98
99
100