Production of temperature control system with Raspberry Pi and ESP32 (1)
Beginning
The products I handle at my place of employment are so severe that they become defective even if the temperature fluctuates by 2 to 3 degrees Celsius. We have more than 10 thermometers in the three rooms used for work and manage them 24 hours a day.
I made similar software before making this system, but I didn't think about data import in particular. Because there was work to collect temperature and humidity data once a week and put it together in Excel, which was troublesome. We will make a new version with Raspberry Pi and ESP32 that integrates temperature and humidity collection → recording → display → analysis.
Overview
Using Raspberry Pi as a server, SHT31 was attached and placed in each position
Sends temperature and humidity from the ESP32 to the Raspberry Pi.
Use a browser and Excel to display.
The browser only displays the current temperature and humidity and update time for each position. Previous versions of this also displayed graphs, but I don't see them all the time, so Since it is sufficient for the current situation to notify only when there is an abnormality, the minimum information will be displayed.
Excel imports SQLite data directly from VBA so that graphs can be updated automatically. In the previous version, this was exported as a CSV file one by one. It was difficult to copy and paste, so I unified it.
For me, the work of extracting a CSV file from software and copying and pasting it into Excel is I don't think it's smart to use macros.
Download the extension file that runs SQLite in Excel from the following reference site. Link
By using this extension file, you can bring data directly from the database to an Excel sheet.
Get the parts you need
Beta version must be made by yourself. So I can't buy M5Stack because of my budget. Except for the temperature / humidity sensor, we make it with cheap parts (; ∀;)
Necessary parts
Raspberry Pi B +
I will use the one that was at home. ESP32 I bought it on Amazon. Link
SHT31 temperature / humidity sensor module
I bought it at Akizuki Denshi. Link
Universal board 6x8 cm
I bought it on Amazon. Link
100 μf electrolytic capacitor
Use the one that suits your home.
Battery box
I bought it on Amazon. Link
AA batteries
I will use the one I bought properly.
ssd1306 (OLED organic display)
I bought it on Amazon. Link
Jumper wire
I bought it on Amazon. Link
2.1mm DC jack female
I bought it at Akizuki Denshi. Link
2.1mm DC jack male
I bought it at Akizuki Denshi. Link
What kind of parts do you need? Next time, I will design before the parts come.