Well, it would be easy enough to create a CSV file using a WeeWX template.
It could then be imported into Excel. Something like...
#for $month in $year.months
#if $month.outTemp.has_data
$month.dateTime.format($YM),
$month.heatdeg.sum.format($Temp,$NONE,add_label=False),
$month.cooldeg.sum.format($Temp,$NONE,add_label=False)
#end if
#end for
would produce something like this, where the columns are year month,
heating degrees, cooling degrees
2022 01, 986.2, 0.0
2022 02, 713.5, 0.0
2022 03, 579.6, 0.0
2022 04, 625.1, 0.0
2022 05, 75.0, 0.0
On Wed, May 18, 2022 at 10:11 AM PC <blaise.cacr...@gmail.com> wrote:
>
> " You haven't said what your use case is. It might be quite simple."
> You are right.
> My goal is to make statistical comparisons since the start of my surveys
> (from 2011 with a "View View" and which will be placed in another table).
> Previously, under Windows 7, I was doing these statistics in VBA ms-access
> ...
> It is already a challenge for me (former computer trainer mainly
> exclusively in Windows, Excel, Access & Cie) and now pensioner to go to
> Linux!
>
> There are also and especially comparisons to seasonal norms
> Just that is a big job that I was doing in several steps.
> And then, that is done, they are written in a table in HTML format.
>
> Le mercredi 18 mai 2022 à 18:39:32 UTC+2, tke...@gmail.com a écrit :
>
>> You haven't said what your use case is. It might be quite simple.
>>
>> For example, here is how you would calculate total heating degree-days
>> for this month in Python, using xtype. Most of the complexity is in
>> calculating the starting and stopping times:
>>
>> import time
>> import weewx.manager
>> import weewx.xtypes
>> import weeutil.weeutil
>>
>> archive_sqlite = {
>> 'database_name': '/home/weewx/archive/weewx.sdb',
>> 'driver': 'weedb.sqlite'
>> }
>>
>> start_tt = (2022, 5, 1, 0, 0, 0, 0, 0, -1)
>> end_tt = (2022, 6, 1, 0, 0, 0, 0, 0, -1)
>> start_ts = time.mktime(start_tt)
>> end_ts = time.mktime(end_tt)
>> timespan = weeutil.weeutil.TimeSpan(start_ts, end_ts)
>>
>> with weewx.manager.DaySummaryManager.open(archive_sqlite) as db_manager:
>> result = weewx.xtypes.get_aggregate('heatdeg', timespan, 'sum',
>> db_manager)
>>
>> print(result)
>>
>> On Wed, May 18, 2022 at 9:29 AM PC <blaise....@gmail.com> wrote:
>>
>>> Yes,
>>> I just looked at, it's really too complicated to implement for what I
>>> want to do.
>>> It would even be easier to calculate him himself!
>>> Besides, in French, we say "why make it simple when you can make it
>>> complicated!?"
>>> It is not complicated to calculate it once a day and store it in a small
>>> table.
>>>
>>> Le mercredi 18 mai 2022 à 18:11:34 UTC+2, PC a écrit :
>>>
>>>> Okay,
>>>>
>>>> I don't know this "xtype", I'm going to watch.
>>>> I already have the difficulty of "binding" 2 tables (see my previous
>>>> post)
>>>> One more challenge, it's pleasant!
>>>>
>>>> Le mercredi 18 mai 2022 à 18:01:45 UTC+2, tke...@gmail.com a écrit :
>>>>
>>>>> Degree-days are calculated on the fly as an xtype
>>>>> <https://github.com/weewx/weewx/wiki/WeeWX-V4-user-defined-types>
>>>>> variable.
>>>>>
>>>>> Where do you need them? For example, for a template, the total
>>>>> degree-days for a month could be calculated as $month.heatdeg.sum.
>>>>>
>>>>> If you need access from an outside application, then you'd have to use
>>>>> the xtype's Python interface.
>>>>>
>>>>> On Wed, May 18, 2022 at 8:48 AM PC <blaise....@gmail.com> wrote:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> It seems to me that DegreeDays are not stored in the table (MySQL)
>>>>>> archive.
>>>>>> Are they elsewhere? How can I get it through a third-party
>>>>>> application?
>>>>>>
>>>>>> Thank you !
>>>>>>
>>>>>> --
>>>>>> 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+...@googlegroups.com.
>>>>>> To view this discussion on the web visit
>>>>>> https://groups.google.com/d/msgid/weewx-user/2bb706a9-dcb5-4773-8f15-80df8fceafccn%40googlegroups.com
>>>>>> <https://groups.google.com/d/msgid/weewx-user/2bb706a9-dcb5-4773-8f15-80df8fceafccn%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+...@googlegroups.com.
>>>
>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/208e0c7c-4936-4342-99d6-6270f17bb4e6n%40googlegroups.com
>>> <https://groups.google.com/d/msgid/weewx-user/208e0c7c-4936-4342-99d6-6270f17bb4e6n%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/35a89231-3dc1-4148-bbaf-f887166c7607n%40googlegroups.com
> <https://groups.google.com/d/msgid/weewx-user/35a89231-3dc1-4148-bbaf-f887166c7607n%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/CAPq0zED%2Be1Q_rBSBM56RBV07AOziFq6QYbGiuZ5kyYY3guwKGw%40mail.gmail.com.
