Skip to content

An Arduino UNO based room-climate SD card logger with display measuring C02, laser dust detection, temperature, humidity, pressure...

License

Notifications You must be signed in to change notification settings

irq777/CLIMAX2001

Repository files navigation

CLIMAX2001

An Arduino UNO based room-climate logger with SD-card

Exel CSV Import

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.

  1. Excel > Data > From Text/CSV
  2. Import "LOGGERnn.CSV"
  3. 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"
  4. To fix that go to Import dialog window and choose "Transform Data" to open the "Power Query Editor"
  5. In "Power Query Editor" window set locals to "English (United States)" via "File > Options and Settings > Query Options > Regional Settings"
  6. 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)
  7. The preview shows now the commas correctly
  8. Click "Close & Load"
  9. Your values appear now properly in Excel including commas for temperature, humidity and pressure

Draw Exel diagrams

  1. Mark colum A (datetime) and select "Format cells"
  2. Choose "Time" and select "13:30:55" (if you keep the date, drawing the diagrams will not work)
  3. Mark e.g colum A (datetime) first(!) and colum C (temp) second(!) and go to Insert > Insert Line or Area Chart
  4. A nice diagram with the name of the selected second colum is drawn over time

About

An Arduino UNO based room-climate SD card logger with display measuring C02, laser dust detection, temperature, humidity, pressure...

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages