Copy of Copy of Impact of irep on P-Reps

	B	C	E	F	G	H	I	J	K
1			DATE	irep	totaldelegation	β2	daily reward	% of total delegation	sum % of total delegation
2	Node delegation	1000000	10/29/2019	50000	170086598.6	1.929012346	489.04	0	0
3	date node started	1/1/2020	10/30/2019	50000	170774549.8	1.929012346	487.07	0	0
4	avg % savings since start	50	10/31/2019	50000	168958603.4	1.929012346	492.30	0	0
5	date IISS 3.0 proposed	03/11/2020	11/1/2019	50000	170032655.6	1.929012346	489.19	0	0
6	avg % savings since IISS	90	11/2/2019	50000	170158301.2	1.929012346	488.83	0	0
7			11/3/2019	50000	170417644.3	1.929012346	488.09	0	0
8	Only modifie GREEN cells for the chart to work		11/4/2019	50000	170877847.2	1.929012346	486.77	0	0
9	Only modifie GREEN cells for the chart to work		11/5/2019	50000	171883525.8	1.929012346	483.93	0	0
10			11/6/2019	50000	174361164.7	1.929012346	477.05	0	0
11	add the date you started running your node (cell B3) and the approximate percentage you saved since the beginning of running the node (cell B4) until the IISS 3.0 was published. On cell B6 add the aproximate percentage of the rewards you started saving after the IISS 3.0 was published. The chart will calculate how much have you earned to reach the 5% bond delegation for a static amount of total delegation for the entire period.		11/7/2019	48957.37869	175181071.1	1.888787758	464.92	0	0
12			11/8/2019	48957.6729	175731626.4	1.888799109	463.46	0	0
13			11/9/2019	48957.31583	176774045.3	1.888785333	460.73	0	0
14			11/9/2019	48958.80023	177025491.6	1.888842601	460.09	0	0
15			11/10/2019	48955.49679	176719317	1.888715154	460.85	0	0
16			11/11/2019	48952.72974	176645953.4	1.8886084	461.02	0	0
17			11/12/2019	48952.72974	176309568.1	1.8886084	461.90	0	0
18			11/13/2019	48791.53533	178720281	1.88238948	454.17	0	0
19			11/14/2019	48792.19084	179288250	1.88241477	452.73	0	0
20			11/15/2019	48730.96328	181865831.3	1.880052596	445.76	0	0
21			11/16/2019	48590.04525	182445389	1.874615943	443.06	0	0
22			11/17/2019	48582.87086	183060632	1.874339154	441.50	0	0
23	official calculator	40860	11/19/2019	48612.99821	183638041.8	1.875501474	440.39	0	0
24	sheet calculation	39051.35	11/20/2019	48614.58579	184164557.6	1.875562723	439.14	0	0
25	error %	4.4	11/21/2019	46790.16555	184950002.3	1.80517614	420.87	0	0
26			11/22/2019	46808.97966	187871791.9	1.805901993	414.49	0	0
27			11/23/2019	46674.03221	188192516.7	1.800695687	412.59	0	0
28			11/24/2019	46686.2731	188321572.4	1.801167944	412.41	0	0
29			11/25/2019	46659.20143	188382913.4	1.800123512	412.04	0	0
30			11/26/2019	46635.772	188574997.3	1.799219599	411.41	0	0
31			11/27/2019	46635.772	188848142.9	1.799219599	410.82	0	0
32			11/28/2019	46630.0965	188851694.2	1.799000636	410.76	0	0
33			11/28/2019	46625.90595	189072630.4	1.798838964	410.24	0	0
34			11/29/2019	46465.56029	188997128.5	1.792652789	409.00	0	0
35			11/30/2019	46460.98151	189281970.3	1.792476138	408.34	0	0
36			12/1/2019	46436.39165	189495685.9	1.791527455	407.66	0	0
37			12/2/2019	46409.43528	188268055	1.790487472	410.08	0	0
38			12/3/2019	46381.47931	186998501.5	1.789408924	412.62	0	0
39			12/4/2019	46373.63457	186996248.3	1.789106272	412.56	0	0
40			12/5/2019	46372.23996	187291594.4	1.789052468	411.89	0	0
41			12/6/2019	46250.43144	187254921.7	1.784353065	410.89	0	0
42			12/7/2019	46260.63568	187058585.6	1.784746747	411.41	0	0
43			12/8/2019	46258.10388	187557268	1.78464907	410.30	0	0
44			12/9/2019	46251.27913	187442007	1.784385769	410.49	0	0
45			12/10/2019	46251.27913	179643565.4	1.784385769	428.31	0	0
46			12/11/2019	46577.41661	179448081.9	1.796968234	431.80	0	0
47			12/12/2019	46705.09483	179643367.7	1.801894091	432.51	0	0
48			12/13/2019	46558.3996	180285463.3	1.796234553	429.62	0	0
49			12/14/2019	46561.4454	180548150.9	1.79635206	429.02	0	0
50			12/14/2019	46556.06581	181123063.6	1.796144514	427.61	0	0
51			12/15/2019	46549.79136	181364300.3	1.795902444	426.98	0	0
52			12/16/2019	46524.57996	181352049.3	1.794929783	426.78	0	0
53			12/17/2019	46526.63709	182284109.6	1.795009147	424.62	0	0
54			12/18/2019	46529.22192	182586754.5	1.795108871	423.94	0	0
55			12/19/2019	46530.58116	182869751.6	1.79516131	423.29	0	0
56			12/20/2019	46526.53198	183451802.2	1.795005092	421.91	0	0
57			12/21/2019	46508.95999	184134593.1	1.79432716	420.19	0	0
58			12/22/2019	46508.95999	184343310.7	1.79432716	419.71	0	0
59			12/23/2019	46496.58822	184641485.8	1.793849854	418.92	0	0
60			12/24/2019	46489.18929	184932219	1.793564402	418.20	0	0
61			12/25/2019	46485.0958	184697106	1.793406474	418.69	0	0
62			12/26/2019	46478.62323	184969649.8	1.793156761	418.02	0	0
63			12/27/2019	46484.59322	185851122.1	1.793387084	416.09	0	0
64			12/28/2019	46476.55431	186208877.4	1.793076941	415.22	0	0
65			12/28/2019	46467.16732	186538125.2	1.792714788	414.40	0	0
66			12/29/2019	46634.64213	186878357.6	1.799176008	415.14	0	0
67			12/30/2019	46629.91774	186976549.6	1.79899374	414.88	0	0
68			12/31/2019	46614.83472	187579377.2	1.798411833	413.41	0.02063817064	0.02063817064
69			1/1/2020	46611.61408	187861031.4	1.79828758	412.76	0.02069777107	0.04133594172
70			1/2/2020	46590.71867	187236101.4	1.79748143	413.96	0.02070524228	0.062041184
71			1/3/2020	46579.8912	187125042.7	1.797063704	414.10	0.02070957359	0.08275075759
72			1/4/2020	46579.8912	187085906.4	1.797063704	414.19	0.02059328729	0.1033440449
73			1/5/2020	46575.04179	188122756.8	1.796876612	411.87	0.02053424565	0.1238782905
74			1/6/2020	46573.58005	188657740.7	1.796820218	410.68	0.02049979644	0.144378087
75			1/7/2020	46575.70259	188983385.9	1.796902106	410.00	0.02047537631	0.1648534633
76			1/8/2020	46574.41215	189203536.2	1.796852321	409.51	0.0204199743	0.1852734376
77			1/9/2020	46571.64109	189705582	1.796745413	408.40	0.02042833917	0.2057017767
78			1/10/2020	46710.70966	190194154.4	1.802110712	408.57	0.02047673974	0.2261785165
79			1/11/2020	46973.52037	190812164.5	1.812250014	409.53	0.02044141982	0.2466199363
80			1/11/2020	46966.64721	191113893.3	1.811984846	408.83	0.0204151039	0.2670350402
81			1/12/2020	46965.17972	191354268.1	1.81192823	408.30	0.02034173914	0.2873767793
82			1/13/2020	46965.19882	192044486.8	1.811928967	406.83	0.02031255261	0.3076893319
83			1/14/2020	46963.4257	192313169.1	1.811860559	406.25	0.02031907648	0.3280084084
84			1/15/2020	47059.24527	192643673.9	1.815557302	406.38	0.02026138997	0.3482697984
85			1/16/2020	47063.03395	193207706.3	1.81570347	405.23	0.02020479405	0.3684745924
86			1/17/2020	47063.03395	193748903	1.81570347	404.10	0.02015280858	0.388627401
87			1/18/2020	47061.92034	194244094.5	1.815660507	403.06	0.02009933954	0.4087267406
88			1/19/2020	46944.79951	194276137.8	1.811141956	401.99	0.02002918134	0.4287559219
89			1/20/2020	46941.25969	194941947.5	1.811005389	400.58	0.01990998043	0.4486659023
90			1/21/2020	46930.62148	196064619.9	1.810594965	398.20	0.01982765148	0.4684935538
91			1/22/2020	46934.73646	196895987.8	1.810753721	396.55	0.01976459981	0.4882581536
92			1/23/2020	46883.64821	197309107.7	1.808782724	395.29	0.0196935472	0.5079517008
93			1/24/2020	46883.3159	198019578.3	1.808769904	393.87	0.01961050139	0.5275622022
94			1/25/2020	46883.34984	198858288.1	1.808771213	392.21	0.01958177338	0.5471439756
95			1/25/2020	46876.36798	199120371.5	1.808501851	391.64	0.01952409865	0.5666680742
96			1/26/2020	46888.04265	199758316.6	1.808952263	390.48	0.01930001543	0.5859680897
97			1/27/2020	46885.00967	202064543	1.808835249	386.00	0.01922422094	0.6051923106
98			1/28/2020	46885.10718	202861635.9	1.808839012	384.48	0.01921389868	0.6244062093
99			1/29/2020	46870.14034	202905826	1.808261587	384.28	0.01912869654	0.6435349058
100			1/30/2020	46870.14034	203809599.6	1.808261587	382.57	0.01900750145	0.6625424073