Reports folder: Difference between revisions

m
Minor resequencing of page
m (Minor resequencing of page)
{{Template:Version badge Mx}}{{Version badge 1}}This page applies to both flavours.
{{Template:WorkInProgressBanner}}[[Category:Cumulus MX]][[Category:Cumulus Files]][[Category:MX txt Files]][[Category:Cumulus 1]]
 
 
=Introduction=
All flavours of Cumulus software include in their release distribution, a sub-folder called '''Reports'''. Please note that it starts with a capital letter, whilst (for Cumulus 1 and 2, all; for MX, most) other folders have totally lower case names.
 
=Optional functionality=
In enhancement request 44 (for Cumulus 1, the enhancement register is no longer available), someone asked Steve Loft to consider producing some monthly, and yearly Climate reports using the weather data that Cumulus software processed, and making comparisons against 20 year normals for that sort of area. These reports are generated and stored in the '''Reports''' folder ''if you choose to turn on the NOAA report option'' in the configuration settings ({{Version badge 1}}in Cumulus 1 see [[Cumulus_Screenshots#Configuration_Menu_Screens|Configuration_Menu_Screens]], [[File:Badge vMx.png]]see [[MX_Administrative_Interface#NOAA_report_settings|NOAA_report_settings]] in MX).
 
The generation of files to be stored in this folder is optional functionality:
 
{| class="wikitable" border="1"
== A brief history of these reports ==
|-
!style="width:150px" | Cumulus MX
!style="width:600px" | MX settings
! style ="width:5px" | .
!style="width:150px" | Cumulus 1.9.x
!style="width:600px" | configuration menu
|-
| switch this functionality on by selecting '''NOAA Settings''' in the ''Settings'' menu. The various settings are explained [[Cumulus.ini#Optional_Report_Settings|here]]. (In image "month specification" is abbreviated to "MS")
| [[File:NOAA settings.png| 500 px]]
|
| switch this functionality on by selecting '''NOAA setup''' from the ''Configuration'' menu.
| [[File:Cumulus_Configuration_Menu.png]]
|}
 
Cumulus 1, 2, and MX, generate climatological reports for both Monthly and Yearly periods.
 
= NOAA style Report Naming =
The reports were first added to Cumulus 2 after someone asked, in enhancement request 44, if Cumulus software could copy what a rival weather software package ('''Weatherlink''') did and output some climatological reports.
 
The report name has to change as the current period (month or year) changes, so Reports must be named using date formatting. For MX, this means all parts of the file name for the report must be understandable when processes by a C# date format parse. The legacy Cumulus uses Delphi to interpret the file name.
Steve Loft did some investigation, and found that Ken True had implemented the Weatherlink reports in his Saratoga suite, so Steve Loft took that as his starting point (see [https://cumulus.hosiene.co.uk/viewtopic.php?f=20&t=5689 Steve's post on the Cumulus Support Forum] for more details).
 
In practice this means that the capital letter "M" is the basis for identifying month (e.g. MM is a 2 digit month number), lower case "y" are repeated to indicate the number of digits to be used to represent the year, and any fixed text is enclosed by quotes to be treated as a literal.
These Saratoga reports were based on climatological reports ([https://forecast.weather.gov/product.php?site=CRH&product=CLA&issuedby=AST annnual report] and [https://forecast.weather.gov/product.php?site=CRH&product=CLM&issuedby=AST monthly report]), issued by The US National Oceanic and Atmospheric Administration's National Weather Service (the reason why Steve Loft decided to use NOAA in the naming of the reports).
Microsoft Operating Systems use file extensions (that by default are hidden) to indicate file types, so all report names must end with the literal ".txt" toconfirm to the operating system that the report is a text file.
 
Steve Loft had abandoned work on Cumulus 1 at the time he worked on this enhancement request, so the first implementation was in Cumulus 2 as Steve was developing that at the time.
 
==The prefix literal==
Subsequently, Steve Loft abandoned Cumulus 2, so his NOAA report design was added to Cumulus 1, this was in version 1.9.2 (build 1004) released in July 2011.
 
The monthly reports have a fixed prefix literal of "NOAAMO". It might appear from the settings page that this can be edited, but Cumulus is hard coded to expect this.
When Steve Loft first started work on [[Cumulus 3 (MX) beta documentation|Cumulus 3 (MX) beta]], he initially did NOT include this climate report functionality, but it was added subsequently to Cumulus MX, attempting to copy the legacy Cumulus look (but with newly invented calculations).
 
The yearly reports have a fixed prefix literal of "NOAAYR". It might appear from the settings page that this can be edited, but Cumulus is hard coded to expect this.
=Additional Information for NOAA reports =
 
Although double quotes are shown round each literal, Cumulus accepts single or double quotes to be used to define a literal for these report names.
Steve Loft (do searches for "NOAA" and for "Degree Days" in the Cumulus 1 sub-forum for more details on key points shown below):
 
Be aware that a regenerated report for a past period might not be quite as accurate as the report that Cumulus can generate as part of end of day processing. The original report will use figures processed during the preceding day, while a regenerated report has to recalculate them (unless accurate figures are in dayfile.txt). Such differences may be seen for average temperature, average wind speed, dominant direction, and the heating and cooling degree days, because Cumulus has to calculate those as it goes along, it can't do it retrospectively.
 
==The date modifier between the literals==
Any changes you make to settings, such as units, or thresholds for heating/cooling degree days, may make earlier lines in these reports incompatible with later lines. The legacy Cumulus does not recalculate earlier information according to latest settings.
 
The default selected by Steve Loft is '''MMyyyy''' and '''yyyy''' respectively (expressed in a way that suits both Cumulus 1 and MX) so the inserted part is all numerical. Here is a table showing the main alternative options for date modifier, and how they look with the fixed literal prefix and the text file type literal suffix as required for the box in settings.
==Monthly Reports==
 
The report viewer in both the legacy Cumulus and the current MX release will accept all options shown here. However, the [[New Default Web Site Information|default website]] in current MX releases will only accept the default settings.
For each day, a monthly report includes (in references to dayfile.txt, field numbering is based on the date as field 1, although for day just ended these figures are also in yesterday.ini):
#Average temperature (taken from what Cumulus has just calculated to put into [[Dayfile.txt|field 16 of daily summary log file]]
#Highest daily temperature and time (taken from fields 7 and 8 of the daily summary log)
#Lowest daily temperature and time (taken from fields 5 and 6 of the daily summary log)
#[[Heat/cold degree days|Heating degree days]] (taken from field 41 of the daily summary log)
#[[Heat/cold degree days|Cooling degree days]] (taken from field 42 of the daily summary log)
#Daily Rainfall (taken from field 15 of the daily summary log)
#[[Wind_measurement|Average Wind Speed]] (calculated from field 17 of daily summary log, by dividing by 24 - the number of hours in a day)
#Highest daily average wind speed and time (taken from fields 18 and 19 of the daily summary log)
#Dominant Direction (taken from field 40 of the daily summary log)
 
In the summary line below the daily rows (note information is not taken from [[Month.ini|parameters in month.ini]]:
* the arithmetic average is calculated, and shown, for Mean Temp column and Wind Speed column
* the total is calculated, and shown, for the Rain column
* the highest figure in column above is found, and shown, for all columns headed High or Low
** the number in time columns represents the day number where the High/Low figure shown was reported
 
In the climate summary:
#There are 4 thresholds for temperature, and the number of days blow or above is indicated
#the wettest day is indicated, and counts of days with rain above certain thresholds is shown
 
Note that the '''Heat Base''' and '''Cool Base''' shown are those in force the day the report was generated, and may not have been the setting when the individual Heating Degree Days and Cooling Degree Days were stored in dayfile.txt.
 
 
==Annual Report==
 
The annual report has a number of tables. Within each table a line appears for each month available for the year.
 
For the current month, the information is available in [[Month.ini|parameters in month.ini]]. Although MX retains old copies of that log file, it does not access them, instead all the parameters are recalculated for older lines.
 
===Temperature table===
 
Each line repeats some of the information appearing in the summary line of the respective monthly report.
 
In the settings, you can enter a month by month normal for temperature, and this report calculates, and shows, the divergence from that normal.
 
In the summary line:
* for the the Mean Max, Mean Min, and Dep. From Norm columns, the figure shown is the arithmetic average of figures above
* for the mean column,
** in recent MX releases, the figure shown is the mean of all entries for this year in [[Dayfile.txt|field 16 of daily summary log file]]
** in early MX releases and the legacy Cumulus, the figure shown is the arithmetic average of figures above
* totals of figures above are shown for the Heat Deg Days, Cool Deg Days, and Max/Min comparisons with thresholds
 
===Precipitation table===
 
Similar to previous table, information shown represents monthly figures and divergences from normal. All should be self-explanatory. The month with most rain is shown in the summary line.
 
===Wind Speed table===
 
The simplest table, it shows average and highest for each month, together with dominant direction for each month. The summary line is based on the information in each column.
 
==Development notes==
 
===Cumulus 1===
 
Information taken from support forum posts by Steve Loft:
*The NOAA report takes the figures from dayfile.txt. If you did a 'create missing' in the dayfile.txt editor with a version before 1.9.4 build 1083, that "Create Missing" action would have stored the figures the wrong way round in dayfile.txt, and hence any NOAA report including those days created by "Create Missing" would have the wrong figures for those days.
* for obsolete versions up to 1.9.4 build 1085 only: The average wind speed used for NOAA reports and 'This period' type screens was, by a bug, based on midnight to midnight days regardless of rollover time in use. (It is calculated on generation of report or screen from standard log file entries).
*From build 1086, the calculation is based on the rollover time being used.
* For all Cumulus 1 versions, and the MX versions below 3.4.4: the yearly average temperature is calculated from summing monthly maximum and monthly minimum values and dividing by number of values in calculation.
 
===MX===
 
Information taken from support forum posts by Mark Crossley:
*For release versions 3.0.0 to 3.4.3, on yearly reports, the annual, average temperature was calculated as the mean of the averages for each month above, and so not identical to the average of daily means, because months vary in length
**The divergence was particularly significant in say March, when the reported average was based on 31 days in January, 28 days in February and a few days in March.
* From version 3.4.4 the annual average temperature is calculated using the integrated method based on every temperature reading processed (it is actually the average calculated from all daily means stored in daily summary log for this year).
 
= NOAA style Report Naming =
 
== The format used for naming reports==
 
The monthly reports have a name in this format '''"NOAAMO"...".txt"'''. The yearly reports have a name in this format '''"NOAAYR"...".txt"'''. This format with 4 double quotes in all cases is used both in the NOAA settings screen and in the [[Cumulus.ini_(Cumulus_1)#Section:_NOAA|[NOAA] section of Cumulus.ini_(Cumulus_1)]].
 
It is between the double quotes where I have placed '...' that Cumulus expects us to use the date output modifiers described. Note that the double quotes must be used at each of the places where they are shown when you define your report naming in the NOAA Settings screen of either Cumulus 1 or MX. The default selected by Steve Loft is '''MMyyyy''' and '''yyyy''' respectively (expressed in a way that suits both Cumulus 1 and MX) so the inserted part is all numerical. Here is a table showing the main alternative options, for more details about these selectors see the [[Webtags#List_of_allowed_modifiers|table below]] as there are obviously a lot more options.
 
{| class="wikitable" border="1"
 
If you migrate from Cumulus 1 (where case does not matter) to Cumulus MX (where case does matter), from version 3.3.0 onwards the NOAA default monthly name if it reads "NOAAMO'mmyy'.txt" (MX believes "mm" '''means minutes''', not month) is changed into "NOAAMO'MMyy'.txt" (which works on both Cumulus 1 and MX).
 
 
=A brief history of these reports =
 
The reports were first added to Cumulus 2 after someone asked, in enhancement request 44 (the enhancement register is no longer available), if Cumulus software could copy what a rival weather software package ('''Weatherlink''') did, and output some climatological reports for both Monthly and Yearly periods.
 
The idea was to present the weather data that Cumulus software processed, with analysis against various thresholds, and comparison against climate normals; these are figures based on averaging ten to thirty year past periods, i.e. periods as defined by World Meteorological Organisation (WMO).
 
Steve Loft did some investigation, and found that Ken True had implemented the Weatherlink reports in his Saratoga suite, so Steve Loft took that as his starting point (see [https://cumulus.hosiene.co.uk/viewtopic.php?f=20&t=5689 Steve's post on the Cumulus Support Forum] for more details).
 
These Saratoga reports were based on climatological reports ([https://forecast.weather.gov/product.php?site=CRH&product=CLA&issuedby=AST annnual report] and [https://forecast.weather.gov/product.php?site=CRH&product=CLM&issuedby=AST monthly report]), issued by The US National Oceanic and Atmospheric Administration's National Weather Service (hence why Steve Loft decided to use NOAA in the naming of the reports).
 
Steve Loft was developing Cumulus 2 at the time, so NOAA reports were implemented in that. Subsequently, Steve Loft abandoned Cumulus 2, and his NOAA report design was subsequently added to version 1.9.2 (build 1004) released in July 2011. Steve Loft did not include this report functionality in his [[Cumulus 3 (MX) beta documentation|Cumulus 3 (MX) beta]].
 
Mark Crossley added these reports to MX at release 3.1.0, using the same layout and same report naming as the legacy, but he had to reinvent the calculations.
 
=Daily report update=
 
In the end-of-day process, Cumulus output the monthly and yearly reports for the day that has just ended. This means when a new month, or new year, starts, the report is only available from the second day.
 
Although Steve Loft never shared his code for Cumulus 1, he did hint that his software retained content for the current reports, and that the daily update built on the existing report, just adding the new line, and updating the summary. Consequently, it seems his reports were constructed from very accurate data as each line was being made as data was read from the weather station during the day. He warned "Be aware that a regenerated report for a past period might not be quite as accurate as the report that Cumulus can generate as part of end of day processing", confirming that the processes for originally producing the report and for subsequently regenerating past reports were different. For regenerating past reports, all the data for the reports was calculated from processing [[Standard log files|standard log file]] entries (these hold periodic spot values that typically miss any extremes). Steve also warned that for reports produced normally (in end of day process) you would make the lines incompatible by any changes you make to settings, such as thresholds. The legacy Cumulus does not recalculate earlier information according to latest settings, but it shows the latest thresholds as if they apply to all information on the report.
 
The average wind speed used for NOAA reports was, by a bug, based on midnight to midnight days regardless of rollover time in use, for any reports produced by versions up to 1.9.4 build 1085 only:
*From 1.9.4 build 1086, the calculation is correctly based on the rollover time being used.
 
Mark Crossley does share the source code for MX, this shows that MX creates the monthly and yearly reports afresh each day, reading information from [[dayfile.txt]] for past days. If you change threshold settings for degree days in MX, that only affects subsequent daily summary log entries, so again although the report shows the latest thresholds, these might not apply to all information on the report. Mark's monthly report uses:
#Daily [[average temperature]] (depends on release)
#Highest daily [[Temperature_(and_humidity)_measurement|temperature]] and time (taken from fields 7 and 8 of the daily summary log)
#Lowest daily temperature and time (taken from fields 5 and 6 of the daily summary log)
#[[Heat/cold degree days|Heating degree days]] (taken from field 41 of the daily summary log)
#[[Heat/cold degree days|Cooling degree days]] (taken from field 42 of the daily summary log)
#Daily Rainfall (taken from field 15 of the daily summary log)
#[[Wind_measurement|Average Wind Speed]] (calculated from field 17 of daily summary log, by dividing by 24 - the number of hours in a day)
#Highest daily average wind speed and time (taken from fields 18 and 19 of the daily summary log)
#Dominant Direction (taken from field 40 of the daily summary log)
 
For releases 3.1.0 to 3.11.4, daily average temperature is taken from field 16 of daily summary log file
From release 3.12.0, there is a choice between that integrated average (calculated from every temperature reading processed), and the WMO average based on limited manual observations (here calculated from adding fields 5 and 7, then dividing by 2)
 
For all flavours of Cumulus, the summary at the base of the monthly report is calculated as follows:
* the arithmetic average is calculated, and shown, for Mean Temp column and Wind Speed column
* the total is calculated, and shown, for the Rain column
* the highest figure in column above is found, and shown, for all columns headed High or Low
** the number in time columns represents the day number where the High/Low figure shown was reported
* There are 4 thresholds for temperature, and the number of days below or above that threshold is counted
* For each rain threshold, a count is made of days with rainfall above that figure
 
 
=Annual Report=
 
The annual report has a number of tables. Within each table a line appears for each month available for the year.
 
That line repeats some of the information appearing in the summary line of the respective monthly report.
 
 
==Temperature table==
 
In the settings, you can enter a month by month normal for temperature, and this report calculates, and shows, the divergence from that normal.
 
In the summary line:
* for the the Mean Max, Mean Min, and Dep. From Norm columns, the figure shown is the arithmetic average of figures above
* for the mean column,
** from release 3.4.4, the figure shown is the mean of all entries for this year in [[Dayfile.txt|field 16 of daily summary log file]]
** in earlier MX releases, and the legacy Cumulus, the figure shown is the arithmetic average of figures above
* totals of figures above are shown for the Heat Deg Days, Cool Deg Days, and Max/Min comparisons with thresholds
 
==Precipitation table==
 
Similar to previous table, information shown represents monthly figures and divergences from normal. All should be self-explanatory. The month with most rain is shown in the summary line.
 
==Wind Speed table==
 
The simplest table, it shows average and highest for each month, together with dominant direction for each month. The summary line is based on the information in each column.
 
Note: the annual average wind speed, from release 3.4.4 is the mean of all entries for this year in [[Dayfile.txt|field 18 of daily summary log file]]; but for the legacy Cumulus, and for releases 3.1.0 to 3.4.3, the figure shown is the arithmetic average of figures above
 
=Format of reports=
 
All reports are pure text files. However, they contain more than just A to Z, 0 to 9, and punctuation. The additional symbol characters included in the report mean that it is important that the report and whatever is being used to view it are set to use the same set of character codes, the way that binary representations of characters are made depends on encoding.
 
== Encoding ==
Remember, most modern web pages (including the standard web templates provided with latest releases of both flavours of Cumulus) use UTF-8 encoding. The only problem is MX was not defaulting to this for NOAA reports in earlier releases (default changed in 3.10.0).
 
When Steve Loft started writing Cumulus to run in a Microsoft environment,he selected the character set now defined as iso-8859-1 which was used by Microsoft products at the time like Excel, Notepad. So Steve ensured all [[:Category:Cumulus Files|Cumulus Files]] used that encoding. Subsequently, Steve Loft discovered that modern web pages use UTF-8 encoding.
=== Why does encoding matter?===
 
In April 2014, Steve introduced the choice in Cumulus 1 of either ISO-8859-1 encoding (as he used originally) or UTF-8 encoding (what he migrated his web page templates to) for these reports. For backwards compliance, the default encoding for reports selected by Steve Loft is his original ISO-8859-1 encoding, but his recommendation strongly expressed was that users should switch to UTF-8.
If you have problems with a web page not displaying the '''°''' symbol correctly, it will be because the character set encoding is either not declared or not consistent.
 
NOAA reports could be viewed externally using Microsoft Notepad (in the past, that defaulted to iso-8859-1 encoding) so Cumulus users were happy with reports in the default encoding.
 
In Cumulus 1, NOAA reports could be viewed by a selection from the '''View''' menu. This internal viewer could look up which encoding had been selected, and therefore could ensure the reports were displayed correctly.
 
===Consistency for encoding===
 
To add just a little more detail here, if you choose to implement a web page to display these Cumulus reports, then the HTML of the web page to display the report, the JavaScript that selects which report to show, and inserts the report into the HTML, and the report itself '''must all use the same encoding''', otherwise you will not get characters like the degree symbol ° displaying correctly.
 
Steve Loft's software packages did not supply a web page for viewing these reports on web servers. However, when third party web pages for viewing the reports were made available, people started seeing strange characters in their reports. The authors of the new web pages could choose which encoding to use, but found whichever they selected, some potential users had their reports encoded with the other!
 
===How did MX complicate encodings?===
 
MX initially complicated the issue.
 
It provided a web page for displaying reports (/CumulusMX/interface/noaayearreport.html), as part of its admin interface. This web page includes <tt><meta charset="utf-8"></tt> to set the encoding.
 
For releases 3.1.0 to 3.9.6, MX maintained consistency with the legacy Cumulus by having the default encoding for reports set at ISO-8859-1. On the web page for NOAA settings (/CumulusMX/interface/noaasettings.html), the hint made no mention that the default encoding was inconsistent with the viewer!
 
From release 3.10.0, MX has made UTF-8 encoding the default for these reports, and the default web pages provided, from that release onwards, include one for showing reports. Further consistency improvements are made from release 3.12.0.
 
=== What encoding does my web page use?===
 
Put simply, most modern web pages start with this:
<pre>
The last line there shows how the original web templates (designed by Beth Loft) used the ISO 8859-1 character set. Consequently, the original NOAA reports used ISO-8859-1 encoding and for compatibility with this original setting, the default encoding for NOAA reports is unchanged despite the mismatch with web pages, because Cumulus 1 does not contain any web page to display NOAA reports.
 
===How does MX complicate encodings?===
MX complicates the issue, the admin interface does include a web page for displaying reports, (/CumulusMX/interface/noaayearreport.html). This web page includes <tt><meta charset="utf-8"></tt>, but the defaults prior to using the web page for editing NOAA settings (/CumulusMX/interface/noaasettings.html) include not using "utf-8" building in an inconsistency because there is nothing in the hints on that page to help you select reasonable settings!
===Consistency for encoding===
To add just a little more detail here, if you choose to implement a web page to display these Cumulus reports, then the HTML of the web page to display the report, the JavaScript that selects which report to show, and inserts the report into the HTML, and the report itself '''must all use the same encoding''', otherwise you will not get characters like &deg; displaying correctly.
 
===When did Cumulus 1 change?===
In April 2014, Steve introduced the choice in Cumulus 1 of either ISO-8859-1 encoding (as he used originally) or UTF-8 encoding (what he migrated his web page templates to) for these reports. For backwards compliance, the default selected by Steve Loft is his original ISO-8859-1 encoding, but his recommendation strongly expressed was that users should switch to UTF-8. This choice with the former as default, but the latter as recommended, remains unchanged in MX. The encoding for NOAA reports can be selected on the NOAA Settings screen of either Cumulus 1 or MX, and you are as Steve says strongly advised to reverse the setting.
 
===Relevance to Extra Web Files===
Before I go into any more technical detail, this same advice of selecting "UTF-8" applies to any choices on the '''Extra web files''' in MX (or Files tab of internet settings in Cumulus 1).
 
===TECHNICAL BIT===
5,838

edits