An Arduino UNO based room-climate logger with SD-card
- Adafruit Arduino datalogging shield with RTC writing measured data in CSV format to a SD-Card
- CJMCU-811 CO2/TVOC sensor (disabled and replaced by SCD30)
- SCD30 Sensirion CO2/temperature/humidity sensor module
- BME280 humidity/temperature/barometer sensor (used only for pressure since SCD30 was added)
- HM3301 Seeed PM2.5 dust detection laser sensor
- LDR light sensor
- SSD1306 128x64 OLED Display 0,96"
- Push button to toggle display on/off
- Everything put together into and onto a nice yellow EURO-BOX housing
- DCF77 time signal (currently deactivated)
It's a bit painful to insert comma-separated values from a CSV file - especially if you are in a country where your PC and your software (like MS Office) is not running under US locals. Below is way to fix that problem. The easiest but more radical solution is to just to set your "Region" to e.g. English (United States) in Windows.
- Excel > Data > From Text/CSV
- Import "LOGGERnn.CSV"
- The preview shows that the commas are missing e.g. in values of temperature, humidity or pressure if your office is not running under "US-locals"
- To fix that go to Import dialog window and choose "Transform Data" to open the "Power Query Editor"
- In "Power Query Editor" window set locals to "English (United States)" via "File > Options and Settings > Query Options > Regional Settings"
- Close "Power Query Editor" and proceed with step 1. (I don't know why but I have to change the locals in "Power Query Editor" every time I start Excel)
- The preview shows now the commas correctly
- Click "Close & Load"
- Your values appear now properly in Excel including commas for temperature, humidity and pressure
- Mark colum A (datetime) and select "Format cells"
- Choose "Time" and select "13:30:55" (if you keep the date, drawing the diagrams will not work)
- Mark e.g colum A (datetime) first(!) and colum C (temp) second(!) and go to Insert > Insert Line or Area Chart
- A nice diagram with the name of the selected second colum is drawn over time