excel根据数据得出公式

1 在excel中输入数据源示例：日期算力每日奖励单T奖励2020-10-15 00:00:00.000000 +08:00583899.563144244.9990.247037352020-10-16 00:00:00.000000 +08:00596284.063148939.570.249779562020-10-17 00:00:00.000000 +08:00603948.15615

慎思知行

11201人浏览 · 2021-03-06 12:38:42

慎思知行 · 2021-03-06 12:38:42 发布

1 在excel中输入数据源

示例：

日期	算力	每日奖励	单T奖励
2020-10-15 00:00:00.000000 +08:00	583899.563	144244.999	0.24703735
2020-10-16 00:00:00.000000 +08:00	596284.063	148939.57	0.24977956
2020-10-17 00:00:00.000000 +08:00	603948.156	152811.81	0.2530214
2020-10-18 00:00:00.000000 +08:00	608895.719	152780.886	0.2509147
2020-10-19 00:00:00.000000 +08:00	616010.656	152127.051	0.24695523
2020-10-20 00:00:00.000000 +08:00	621297.719	153556.497	0.24715445
2020-10-21 00:00:00.000000 +08:00	629356.188	153246.617	0.24349744
2020-10-22 00:00:00.000000 +08:00	633855.25	150962.148	0.23816502
2020-10-23 00:00:00.000000 +08:00	637435.063	136356.317	0.21391405
2020-10-24 00:00:00.000000 +08:00	646128.563	114830.029	0.17772009
2020-10-25 00:00:00.000000 +08:00	659840.938	141407.391	0.21430527
2020-10-26 00:00:00.000000 +08:00	667670.406	146658.354	0.21965681
2020-10-27 00:00:00.000000 +08:00	681182.438	138991.648	0.20404467
2020-10-28 00:00:00.000000 +08:00	692544.969	149642.523	0.21607625
2020-10-29 00:00:00.000000 +08:00	705481.344	148814.421	0.21094026
2020-10-30 00:00:00.000000 +08:00	716937.094	150936.681	0.21052988
2020-10-31 00:00:00.000000 +08:00	732401.469	159171.707	0.21732849
2020-11-01 00:00:00.000000 +08:00	740380.969	151970.494	0.20525986
2020-11-02 00:00:00.000000 +08:00	759661.719	160768.554	0.21163177