By default, the database uses US Customary Units. It can be changed, See the section Changing the unit system in an existing database <https://www.weewx.com/docs/5.0/custom/database/#change-unit-system> in the Customizing Guide.
If your humidity (observation type 'outHumidity') has strange values, then your sensor must be emitting strange values. See the wiki article *Cleaning up old 'bad' data <https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data>*. Be sure to set StdQC values to prevent it happening again in the future. Times in WeeWX are in Unix Epoch Time, which must be converted into the native Excel date+time representation. Sorry, I don't know how to do this --- I almost never use Excel. All I can suggest is a Google search. On Fri, Mar 1, 2024 at 5:13 AM Thomas Hackler <thackle...@gmail.com> wrote: > Hello, > I started playing with a copy of weewx.sdb to open it as a csv file to > work with the data in Excel. I used the DB Browser for SQLite to export the > data to csv, this worked. > If I look on the data in the DB browser and in Excel for my temperatures > they look really strange. I expect Celsius and it seems to be Fahrenheit? > Now I see that in my weewx.conf under [StdConvert] target_unit = US, so I > should change it now in "METRIC", right ? > I guess I have to convert my temps in Excel from Fahrenheit to Celsius for > my old data.... > > The other values for humidity etc. show partially very high values like > 4,7e+14.or 870 for example (maybe it is 87.0 in reall). > > The other problem is that I am not able to convert the datetime into a > right time format in Excel to see time and date ? Maybe you can help me > here? > I tried different options like Unicode, Windows, US-ASCII etc. in Excel > for the import with no success. > Thanks! > Regards > Thomas > > -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to weewx-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/c82346f7-6dee-4f85-b156-ee1ac5e0632cn%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/c82346f7-6dee-4f85-b156-ee1ac5e0632cn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zECjhrAmXCNDJp5s5L_Ozs-joCs%3DhhGpc4AyC-N8v-eO-A%40mail.gmail.com.
