search

N0ury / dmm_util

dmm_util is a utility for interacting with Fluke 289 and 287 Series multimeters.
MIT License
15 stars 4 forks source link

9.99999999e+37 VAC values in the 289 recording #26

Closed Jaymos1 closed 2 years ago

Jaymos1 commented 2 years ago

I downloaded recording 7 and the import seems to be with some strange numbers. I attach the recording. I downloaded the same recording twice, and did a file compare, and two 670 kB files are identical.

Do you think these numbers are transmitted like this, or are misinterpreted by the software (or cable!)?

7       Battery 4       Recording       2022-02-17 09:52:01     2022-02-17 12:24:25     00:02:32:24     9143

2022-02-17 12:21:55 656.8   VAC 656.8   VAC 656.8   VAC 656.8   VAC 10  INTERVAL
2022-02-17 12:21:56 656.9   VAC 656.9   VAC 638.8   VAC 494.1   VAC 9   STABLE
Line 9000:
2022-02-17 12:21:57 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:21:59 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:22:00 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:22:02 0.0488  VAC 0.0493  VAC 0.0491  VAC 0.0488  VAC 10  INTERVAL
2022-02-17 12:22:03 0.0496  VAC 0.0496  VAC 0.0485  VAC 0.0478  VAC 10  INTERVAL
...
2022-02-17 12:22:22 0.0456  VAC 0.0456  VAC 0.0456  VAC 0.0455  VAC 10  INTERVAL
2022-02-17 12:22:23 0.0455  VAC 0.0455  VAC 0.0454  VAC 0.0454  VAC 3   STABLE
Line 9025:
2022-02-17 12:22:23 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:22:25 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:22:27 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:22:29 657.4   VAC 657.4   VAC 657.2   VAC 657.1   VAC 6   INTERVAL
2022-02-17 12:22:29 657.0   VAC 657.2   VAC 657.1   VAC 657.0   VAC 10  INTERVAL
...
2022-02-17 12:22:42 657.1   VAC 657.1   VAC 657.1   VAC 657.1   VAC 10  INTERVAL
2022-02-17 12:22:43 657.1   VAC 657.1   VAC 652.3   VAC 623.9   VAC 7   STABLE
Line 9044:
2022-02-17 12:22:44 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:22:46 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:22:47 9.99999999e+37  VAC 9.99999999e+37  VAC 0   VAC 9.99999999e+37  VAC 0   INTERVAL
2022-02-17 12:22:49 0.0508  VAC 0.0508  VAC 0.0508  VAC 0.0508  VAC 1   INTERVAL
2022-02-17 12:22:49 0.0511  VAC 0.0512  VAC 0.0506  VAC 0.0498  VAC 10  INTERVAL

These are the only anomalies in the file.

image Looking at the meter display, it seems that at the end of the recording, there are some changes to zero. That corresponds with the file. It is at those locations where the 9.99e+37 values are popping up.

I think that the 9.99999999e+37 could be at the transition between full voltage and zero - I am not sure if some unknown tokens are output in the serial string.

rec7.zip

I then went on and checked all 7 downloads done today, and also recording 4 has the same issue. I also re-downloaded that one, and the resulting file is identical. I also attach that file - it is only 41 lines.

On rec4, there are also these 9.999e+37 values, every time after a "STABLE" mark, and also every time when the measured voltage goes from high to 0 - a big delta, except in the case of line 4.

rec4.csv

N0ury commented 2 years ago

Fluke stores the value 9.99999999e+37 when there is an overload. This is normal.

Jaymos1 commented 2 years ago

ok thx

Is it an option to skip those lines by default (instead of storing) if found? This would prevent searching, finding and deleting those lines in the EXCEL sheet afterwards?

N0ury commented 2 years ago

Is it an option to skip those lines by default (instead of storing) if found? This would prevent searching, finding and deleting those lines in the EXCEL sheet afterwards?

I can add this option if you think it is useful.

Jaymos1 commented 2 years ago

I think it will be very useful, unless one should know about the "overload" of the meter. I do not think so.

The fact that it "overloads" consistently when dropping from high to almost zero (big delta) is imho a meter error which makes the graphing in Excel unnecessarily cumbersome because those have to be removed.

So, if you do not mind, please, but no hurry. I will use it if you do it.

N0ury commented 2 years ago

@Jaymos1 Hi, I have added -o option to avoid displaying such lines with get recordings Can you please check if it's what you asked for. This modification is in last commit, so you must get it first from github.

Jaymos1 commented 2 years ago

Works beautifully, thank you!