BLYNK
HOME       📲 GETTING STARTED       📗 DOCS       ❓HELP CENTER       👉 SKETCH BUILDER

Tutorial - Using exported Data from Superchart in MS Excel

server

#1

hi

Blynk team created a great widget we can use it to visualize the Data which is Superchart
we can attach many Virtual pins to generate a charts which is very helpful.

also we can export the data in "CSV" format , buy clicking the three dots under the superchart widget and select "export to CSV" you will receive and email from Blynk to your registered email address

in the email you will find attached CSV file for all the Vpins in your superchart

when opining it using MS excel you will find it as below

image

the Data is saved in we will find it in Unix timestamp format which is 10 digits represent the total number of seconds since midnight (GMT time) on January 1, 1970
So how can we convert it to a readable Date and time in MS excel

Below is the exact data we found after export without any edit we can see in Cell “B1” the value
“1537022340000” of timestamp which is 13 Digit but we need to use the first 10 digits only from the left
You can add the below formula in cell D1

=TEXT((LEFT(B1,10)/60/60)/24+DATE(1970,1,1)+(3/24),"DD/MM/YYY - hh:mm:ss")

if you will use it in any other similar conversion you can replace the"Timestamp Column" with your exported data , and "GMT Offset" with the number of hours from GMT to your local time zone , for example yourtime zone is +3 GMT use +(3/24) , if it is -1 GMT use -(1/24)

if you drag the formula to the reset of the rows you will get a similar result to below image

image

i hope this will be helpful to some of Blynkers here


Problem with superchart in excel cant
#2

Hello. Have you seen reporting widget?


#3

not before you asked , as i can see it has alot of option and that is great thing.
but i noticed the energy required is zero to set up , but when i run the project it shows that it will cost 2,900 energy
is this is per report run or one time payment ? is it recoverable when widget deleted ?

i will take detailed look into this widget later , thanks @Dmitriy for the continuous great work


#4

One time.

Yes.


#5

Muchas gracias, me sirvió la explicación de SuperChart Para Argentina utilice

Segundos desde 1/1/1970 =((IZQUIERDA(V7;10)/60/60)/24)+FECHA(1970; 1; 1)-(3/24)

1540500240000 17:44:00 - 25/10/2018 y la celda de la formula formato h:mm:ss - dd/mm/aaaa

Gracias, un cordial saludo desde Mar del Plata, Argentina. Eduardo Caporale.

……………………………………………………………………………
Thank you very much, the explanation helped me SuperChart For Argentina use

Seconds since 1/1/1970 =((IZQUIERDA(V7;10)/60/60)/24)+FECHA(1970; 1; 1)-(3/24)

1540500240000 17:44:00 - 25/10/2018 and the cell of the formula format h:mm:ss - dd/mm/aaaa

Thank you, cordial greetings from Mar del Plata, Argentina. Eduardo Caporale

……………………………………………………………………………………


#6

you are welcome , glad it help you