Data Collection in Excel

Aydude
Guest

Data Collection in Excel Jan 6, 2018 14:25:38 GMT -8

Quote

Post by Aydude on Jan 6, 2018 14:25:38 GMT -8

Hello,

I was curious to know, how can I collect historical data in a format like Excel. Basically, I'm looking for the data from all the sensors, possibly every 15 minutes or another time variable.

If anyone has done this before, please help!

Thanks,

Aydude

Aydude Guest	Data Collection in Excel Jan 6, 2018 14:28:34 GMT -8 Quote Select Post Deselect Post Link to Post Back to Top Post by Aydude on Jan 6, 2018 14:28:34 GMT -8 Otherwise, how would I be able to use DataLogger to display and store all the data?

SDL
Global Moderator

Posts: 5,655
Raspberry Pi: Yes
Other Device: PC, arduino, beagleBone

Data Collection in Excel Jan 8, 2018 6:23:00 GMT -8

Quote

Post by SDL on Jan 8, 2018 6:23:00 GMT -8

I haven't heard of anybody using the Excell format, but here is what we do. We use the Raspberry Pi DataLogger code to save to MySQL.

Check out this posting:

www.switchdoc.com/2016/08/raspberry-pi-datalogger-update-wxlink-now-supported/

BP

Aydude Guest	Data Collection in Excel Jan 9, 2018 5:31:03 GMT -8 Quote Select Post Deselect Post Link to Post Back to Top Post by Aydude on Jan 9, 2018 5:31:03 GMT -8 Hmmmm... Could I get the data possibly in a text file?

SDL Global Moderator Posts: 5,655 Raspberry Pi: Yes Other Device: PC, arduino, beagleBone	Data Collection in Excel Jan 12, 2018 6:24:04 GMT -8 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by SDL on Jan 12, 2018 6:24:04 GMT -8 Sure, just modify the software to do that. Comma delimited file would be pretty easy. BP

turbon New Member Posts: 22	Data Collection in Excel Mar 6, 2018 23:22:04 GMT -8 SDL likes this Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by turbon on Mar 6, 2018 23:22:04 GMT -8 The listen.py could be modified to save the data to a textfile or to insert it directly into mySQL. Regards

Post by Aydude on Jan 6, 2018 14:25:38 GMT -8

Post by Aydude on Jan 6, 2018 14:28:34 GMT -8

Post by SDL on Jan 8, 2018 6:23:00 GMT -8

Post by Aydude on Jan 9, 2018 5:31:03 GMT -8

Post by SDL on Jan 12, 2018 6:24:04 GMT -8

Post by turbon on Mar 6, 2018 23:22:04 GMT -8

Quick Reply