Balancer Deposits BPT Out & Price Impact.xlsx

	A	B	C	D	E	F	G	H	I	O
1	Balancer Price Impact Simulator - Providing Liquidity (Deposits)
2
3	Pool Traits
4	Pool Traits
5		Ticker	Token Balance (B)	Token Weight (W)	Swap Fee (%)	# of Pool Tokens
6	Token 1	BAL	5470646.00	0.8000	2	2941879.903
7	Token 2	WETH	7947.22	0.2000	Fill in the blue cells with the necessary pool traits. The balance is the number of tokens & weight which can be taken from the Pool composition on the UI. The swap fees are also available on the Balancer site. Please see Balancer Bites related documentation to see the underlying pool mechanics outlined. Outputs will appear in white cells. Feel free to give us feedback on our tools packages. We love to improve!
8	Token 3
9	Token 4
10	Token 5
11	Token 6
12	Token 7
13	Token 8
14	Total Weight			1.0000
15	Units				BPT	BPT	BPT	BPT	Impact Due to
16		Ticker		Token Weight (W)	Spot Price	Individual Value	Net Single Deposit	Proportional Entry	Token Excess
17	Token 1	BAL		0.8000	0.43020587	0	0	59.22837057	0
18	Token 2	WETH	1.00	0.2000	74.03546321	74.03546321	59.22837057	14.80709264	0.8
19	Token 3			0.0000	0	0	0	0	0
20	Token 4			0.0000	0	0	0	0	0
21	Token 5			0.0000	0	0	0	0	0
22	Token 6			0.0000	0	0	0	0	0
23	Token 7			0.0000	0	0	0	0	0
24	Token 8			0.0000	0	0	0	0	0
25	Pool Traits - Post Addition				Total BPT	74.03546321		74.03546321
26	Pool Traits - Post Addition
27					BPT	Initial Invariant	New Invariant	Invariant Ratio	Actual Amount
28		Ticker	Token Balance (B)	Token Weight (W)	Spot Price				BPT
29	Token 1	BAL	5470646.00	0.8000	0.4302166704	245714.5592	245714.559239148000	1
30	Token 2	WETH	7948.21	0.2000	74.02438489	6.026193691	6.026342912741	1.000024762
31	Token 3		0.00	0.0000	0	0	1.000000000000	1
32	Token 4		0.00	0.0000	0	0	1.000000000000	1
33	Token 5		0.00	0.0000	0	0	1.000000000000	1
34	Token 6		0.00	0.0000	0	0	1.000000000000	1
35	Token 7		0.00	0.0000	0	0	1.000000000000	1
36	Token 8		0.00	0.0000	0	0	1.000000000000	1
37								Total	72.84723848
38								Price Impact	0.01604939949
39								Price Impact (%)	1.604939949
40
41
42										1
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