Hello to all!
I would like to use an ESP8266-12E to send 2 sensors data to PC and display that in excel. An FSR sensor (MF01A-N-221-A11) is connected to an AN input of PIC18F46K22, and a heart rate/oximeter sensor (MAX30100) is connected to I2C port of PIC. That mcu is connected to ESP-8266 with TX , RX and RESET.
Data are sent with WIFI to PC and displayed in real time in excel . Is there a code example to make the project? To read MAX30100 sensor, and to convert sensors data to CSV file-displaying in real time to pc in excel, are most important for now. Any info I hope will helps. Thanks.
Basil
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
A few thoughts. The FSR - does that need a Op Amp?
The other devices will all work with the right protocols.
Why such a mega chip? There are 16f181xx that will do what you want.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
FSR sometimes needs an op-amp, but in that case not. Only a conversion of input voltage to full scale force (kgr). I need that chip (TQPF44), because I'll use many pins for other I/O connections and for minimum space..mainboard with PIC18F46K22 and ESP8266 will be mobile powered by a lithium-polymer battery. I made the code to send data to ESP8266..I would like to have your opinion on how to send sensors data to pc and display that in excel in real time, and on how to read and get data of MAX30100.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is the sensor data a series of fixed data points, where the there is always the same number of data points to transfer? So, the fixed data points make a data packet to be transferred.
Does it matter is you loose a data packet ( a fixed data points) ? Or, do you require the data packet to be reset if a data packet is lost ?
Does it matter is data packet is corrupted? So, is it acceptable to data data points in a data packet that are corrupted during transmission.
Answers to the above questions will determine if 'send data and hope it gets there', or 'data packets with sequential numbering with ack/nak' is required'.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
No, it's not critical to loose data packet ..I need an average data measurement displayed to PC in excel tables..with no data interrupts for more than 100ms.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Does it have to beExcel ? When Data Visualisation tools exist?
But, you want data to be sent with WIFI to PC and displayed in real time in excel . How? where it PIC attached? Attached to WIFI how?
When the data arrives in Excel. Do have an add-in or a VBA program to read the data stream? How is the data stream presented? Via files? or real time? How?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello to all!
I would like to use an ESP8266-12E to send 2 sensors data to PC and display that in excel. An FSR sensor (MF01A-N-221-A11) is connected to an AN input of PIC18F46K22, and a heart rate/oximeter sensor (MAX30100) is connected to I2C port of PIC. That mcu is connected to ESP-8266 with TX , RX and RESET.
Data are sent with WIFI to PC and displayed in real time in excel . Is there a code example to make the project? To read MAX30100 sensor, and to convert sensors data to CSV file-displaying in real time to pc in excel, are most important for now. Any info I hope will helps. Thanks.
Basil
A few thoughts. The FSR - does that need a Op Amp?
The other devices will all work with the right protocols.
Why such a mega chip? There are 16f181xx that will do what you want.
FSR sometimes needs an op-amp, but in that case not. Only a conversion of input voltage to full scale force (kgr). I need that chip (TQPF44), because I'll use many pins for other I/O connections and for minimum space..mainboard with PIC18F46K22 and ESP8266 will be mobile powered by a lithium-polymer battery. I made the code to send data to ESP8266..I would like to have your opinion on how to send sensors data to pc and display that in excel in real time, and on how to read and get data of MAX30100.
Is the sensor data a series of fixed data points, where the there is always the same number of data points to transfer? So, the fixed data points make a data packet to be transferred.
Does it matter is you loose a data packet ( a fixed data points) ? Or, do you require the data packet to be reset if a data packet is lost ?
Does it matter is data packet is corrupted? So, is it acceptable to data data points in a data packet that are corrupted during transmission.
Answers to the above questions will determine if 'send data and hope it gets there', or 'data packets with sequential numbering with ack/nak' is required'.
No, it's not critical to loose data packet ..I need an average data measurement displayed to PC in excel tables..with no data interrupts for more than 100ms.
Take a look at https://youtu.be/odvFBgfSwqg?t=378
Does it have to beExcel ? When Data Visualisation tools exist?
But, you want data to be sent with WIFI to PC and displayed in real time in excel . How? where it PIC attached? Attached to WIFI how?
When the data arrives in Excel. Do have an add-in or a VBA program to read the data stream? How is the data stream presented? Via files? or real time? How?
3 sensors are connected to PIC18F46K42..data transferred to PC from ESP8266 with WIFI... with connection to WLAN, ESP8266 acts as a server and PC as client. data converted to .CSV and imported to excel . to input data stream in excel, I'll use the feature data streamer . with setup of this feature is possible to display data in real time...
https://i.ytimg.com/vi/rvL0ut5phmM/hq720.jpg?sqp=-oaymwEcCNAFEJQDSFXyq4qpAw4IARUAAIhCGAFwAcABBg==&rs=AOn4CLBeFVm6oal3Hk96XG_-uxb49w4jkw