New chart style in GraphMemo?

[lukaszswitaj]

Hi,

There is a screenshot of a pretty nice set of charts in Readme.md:

Is this some new way to visualize downloaded sensor data directly in the browser? The graphs drawn here look completely different: https://pvvx.github.io/ATC_MiThermometer/GraphMemo.html

[pvvx]

GraphMemo.html -> data.csv -> Exel -> Charts

[lukaszswitaj]

Forgive me, this illustration is just below the link to GraphMemo.html. It's very confusing.

By the way, maybe it's worth posting an instruction on how to convert timestamp from generated CSV files to date-time format in Calc and Excel.

[pvvx]

The csv file describes the conversion formula in the first row of the first column:
Time-Data=(A2/86400)+25569;Temp;Humi;Vbat

The timestamp in Linux format is "seconds since jan 01 1970. (UTC)".

Good charting scripts for HTTP/JS are paid. For this reason it is used https://dygraphs.com/ with the MIT license.
If you want, you can publish an improved version of charting for general use with an open license.

[evlo]

I do not understand

this is what I get on the device so date and time is correct

these are results in excel + formula I'm using

rrrr-mm-dd h:mm;@ is cell froamt, but I do have czech localisation of excel, sadly

Also If i do that without the datetime format, I do get

when current linux timestamp is 1695815354.

What am I doing wrong?

UPDATE:

raw csv downloaded file

 OfcTblTH
Time-Data=(A2/86400)+25569;Temp;Humi;Vbat
7750432;18.8;64.86;2930
7751033;18.79;64.85;2932
7751634;18.78;64.81;2933
7752235;18.76;64.75;2934
...
19539776;23.51;68.36;2923
19540377;23.73;67.81;2925
19540978;23.99;67.22;2926
19541579;24.3;66.35;2927
19542182;24.61;65.64;2814
19542782;24.98;64.43;2812
19543383;25.15;63.9;2815
1695822428;25.35;63.39;2689

So I guess I need to run GET time at least once after flashing, right?

I'm leaving the post here as it might help somebody else who is confused like me

[pvvx]

After the firmware, you need to set the clock in the thermometer - "Set time".
Instability of the time count on the thermometer.
There are already several applications for synchronizing the time on the thermometer.
Example:
ESPHome: synchronize the time once a day