Good morning everyone, I'm doing a design and use several external sensors, temperature sensor, humidity sensor... I wanted to ask if it is possible to use these values and put them in an Excell sheet and then make graphs.
The device is located in a place where there is no internet so I should save the values and every 1 or 2 months I go to download them. Does anyone know how to do this? Do I need an external memoir? Is there a special command that does this operation?
This is a common Arduino project for which it is very well suited. Since you intend to retrieve the values once a month or so, the obvious solution is to record the data to on-board SD card. The magic commands are
myfile.print(data);
and
myfile.print(",")
and thereby accumulated as a .csv file which may be read directly into Excel.
The file(s) may be eventually retrieved by extracting the card or simply downloaded to a phone via Bluetooth.
There are datalogging and filedumping examples included with the SD library. You will probably have an on-board RTC, and you can also use that to name files by date.
Okay thank you very much, I'll go buy a module to put a micro SD external and try to save the data
If I have to save data for 1 year, do I write 10 values 4 times a day, is a 1 Gb memory enough?
