Hello
I am trying to build a lightweight setup to log temperature and humidity data using a basic sensor module (like DHT11 or BME280)& a microcontroller (ESP8266/Arduino). I want to collect the data over several days; then analyze trends using minimal software. Ideally, I would like to export the data in a CSV format for further analysis in Excel / similar tools.
My main concern is how to set this up so it’s easy for non-technical users to maintain including how to structure the data for easy review, possibly with conditional formatting / summary tables. Bonus if I can keep it low power and avoid cloud platforms. Any tips on components, libraries / scripts that could make this workflow smoother would be great.
Also; while testing formatting and automation ideas in Excel, I came across some excel Interview questions that made me rethink how I set up formulas and data tables so if you have any Excel tricks related to logging or automation, I would love to hear them too!
Thank you !!