燃油油位稳定 [英] Fuel Level Stabilization

问题描述

我正在研究燃油液位传感器模块。我们有一个燃油液位传感器浸入燃油箱。传感器每10秒发送一次更新。电压从0到5不等，其中0表示油箱空，5表示油箱已满。

目前我正在努力稳定我从电池接收的电压传感器。由于车辆行驶时发生了很多波动，我无法稳定图表。



目前我按以下方式获取图表：

当前图表



但我想要的图形如下：

必填图


我想消除第一张图中发生的波动。

以下是我收到的数据。请下载并在MS Excel 2007中打开它。（相信我它不是病毒。）

下载Excel文件



请帮助。

展望未来的有用逻辑。



先谢谢。

Linto。

Hi,

I am working on Fuel Level Sensor module. We have a Fuel Level Sensor which is dipped into the fuel tank. The sensor sends the update in each 10 seconds. The volt varies from 0 to 5, wherein 0 means 'Fuel tank is Empty' and 5 means 'Fuel tank is Full'.
Currently I am working on to stabilize the voltage that I am receiving from the sensor. Since there is a lot of fluctuation happening while the vehicle is moving, I am not able to stabilize the graph.

Currently I am getting the graph in the following manner:
Current Graph

But I want the graph something like this:
Required Graph

I want to remove the fluctuation happening in the 1st graph.
Below is the data that I am receiving. Please download and open it in MS Excel 2007.(Trust me it is not a virus.)
Download Excel File

Please help.
Looking ahead for a helpful logic.

Thanks in Advance.
Linto.

推荐答案

使用移动平均值：它将最后的N点相加并给出它们的平均值，而不是直接使用数据点。你仍然会有一些波动，但它应该被最小化，你可能需要使用样本大小来获得正确的阻尼因素。



BTW ：如果您想要向人们显示之前和之后图片，请尝试确保使用相同的数据集，或者至少相似 - 您的两个示例甚至不使用相同的时间刻度！

Use a moving average: it sums the last "N" points and gives the average of those, rather than using the datapoints directly. You will still get some fluctuation, but it should be minimised, and you will probably need to play with the sample size to get the right "damping" factor.

BTW: If you want to show people "before" and "after" pictures, try to make sure that you use the same dataset, or at least similar - your two examples don't even use the same timescale!

这篇关于燃油油位稳定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！