I am using a Superchart to plot an airconditioner’s evaporator temperature and the compressor current. Working great !
Hardware used is a ESP32. The blynk Timer is set to push data ( DegC & Amps) once every 10 seconds.
I recently left it running for about 7 hours. Then I exported the data and got it via my Mail ID. When I opened I found the following
- I got two files - one for each channel.
- The number of records was very low - only 808 records in each. Whereas I should have got 7 hr x 60 minutes x 6 records = 2520. Not sure what happened to the rest.
- I think the date/time stamp is a Epoch type. When i use this formula (millisValue*0.001/86400+DATE(1970,1,1) to decode it in Excel I get values which do not exactly tally with the actual time frame…
Kindly help to understand this and whether my expectation is right ??