Welcome to the Cumulus Support forum.

Latest Cumulus MX release v3.0.0 build 3050 - 1 May 2019.
Legacy Cumulus 1 release v1.9.4 (build 1099) - 28 November 2014

See the Wiki for downloading either version.

Yet Another Dayfile Reader (PHP)

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

User avatar
billy
Posts: 53
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Oregon WMR200
Operating System: RPi jessie
Location: Perth, Australia

Re: Yet Another Dayfile Reader (PHP)

Post by billy » Mon 29 Jul 2019 7:04 am

For the perhaps one (?) other person who might be interested in this, the cell colouring has been sorted. I decided to use different colours for day, monthly total and running total values, given they have different meanings and of course ranges.

A big thank you to the beteljuice, not just for the code but also the ease of deciphering the logic.

Annotation 2019-07-29 145337.png
You do not have the required permissions to view the files attached to this post.

User avatar
beteljuice
Posts: 2710
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: ex XP SP3 - now W10 laptop grr
Location: Dudley, West Midlands, UK

Re: Yet Another Dayfile Reader (PHP)

Post by beteljuice » Mon 29 Jul 2019 8:43 am

billy wrote:I modified my code to display running averages Totals in the monthly summary table.

... you have discarded daily averages altogether :?

Edit: How old is the version you are modifying - your data cells are right justified.
Image
......................Imagine, what you will KNOW tomorrow !

User avatar
billy
Posts: 53
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Oregon WMR200
Operating System: RPi jessie
Location: Perth, Australia

Re: Yet Another Dayfile Reader (PHP)

Post by billy » Mon 29 Jul 2019 12:28 pm

Thanks for pointing out the error - yes, I meant totals, not averages!
beteljuice wrote:
Mon 29 Jul 2019 8:43 am
... you have discarded daily averages altogether
Daily rainfall has such a strongly skewed distribution - at least where I live :) - that it does not lend itself well to using the average as a summary statistic.
beteljuice wrote:
Mon 29 Jul 2019 8:43 am
How old is the version you are modifying - your data cells are right justified.
The version of the dayfile reader came from Mark a couple of years ago but I think it forked from your standard some years before that. It has the advantage of getting the data from a SQL version of the dayfile. Yes, the values could be placed horizontally better in the cells - I hadn't given that any thought before but it's pretty obvious now you have pointed it out - but I would prefer not to centre the entire text string per se. Aligning them on the decimal point or right align (as they are now but indented further to the left) would be better. Not sure what flexibility there is in html? I realized after I threw in my support for the upgrade, that without incorporating SQL capacity it would be of limited benefit to me!

Phil23
Posts: 192
Joined: Sat 16 Jul 2016 11:59 pm
Weather Station: Davis Vantage Pro2 Plus
Operating System: Win7 Pro
Location: Australia

Re: Yet Another Dayfile Reader (PHP)

Post by Phil23 » Mon 29 Jul 2019 8:08 pm

billy wrote:
Mon 29 Jul 2019 12:28 pm
Daily rainfall has such a strongly skewed distribution - at least where I live :) - that it does not lend itself well to using the average as a summary statistic.
That was my initial thoughts on wanting to change it. EVT though, I see the benefit in seeing both daily averages & totals.

Looking at my current figures, I'm making the assumption that I need about 2.2mm of daily rainfall to balance the EVT losses & have any chance of the lawn coming back to life in Spring.

So based on that, I'm hitting it with the sprinklers once of twice a week in an attempt to deliver what is a bit above the EVT loss.
Don't know how appropriate that is, but am keeping an eye on the fact that I could get it too wet.
(And getting some strange looks from MrsC as I run sprinklers with water meters attached...….).

EVT
EVT.JPG

Rainfall
Rain.JPG
You do not have the required permissions to view the files attached to this post.
Image

User avatar
beteljuice
Posts: 2710
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: ex XP SP3 - now W10 laptop grr
Location: Dudley, West Midlands, UK

Re: Yet Another Dayfile Reader (PHP)

Post by beteljuice » Mon 29 Jul 2019 9:38 pm

Naughty billy :cry:

Should have told everyone you aren't using the 'standard' distro.

Makes comparisons confusing.
Image
......................Imagine, what you will KNOW tomorrow !

User avatar
billy
Posts: 53
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Oregon WMR200
Operating System: RPi jessie
Location: Perth, Australia

Re: Yet Another Dayfile Reader (PHP)

Post by billy » Tue 30 Jul 2019 12:38 am

:oops: Apologies - I’m still on L-plates. Maybe I should have posted this elsewhere?

User avatar
beteljuice
Posts: 2710
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: ex XP SP3 - now W10 laptop grr
Location: Dudley, West Midlands, UK

Re: Yet Another Dayfile Reader (PHP)

Post by beteljuice » Tue 30 Jul 2019 1:17 am

billy wrote:Maybe I should have posted this elsewhere?
No - here is fine and proper (there is no thread for sql versions)

It's just that if you are non-standard, screen shots especially can be misleading, and everyone starts saying "Mine doesn't look like that !" :mrgreen:

Or if you post with a problem, I know if it's me or not :roll:

@everyone

the beteljuice is currently ratifying the rainfall colour key.
Everything is the same colours but as we are introducing Month totals etc. the gradients will be proportionately the same,
ie. a light rain day / month will be the same (light) colour, and a heavy rain day / month will be the same (dark) colour.
Image
......................Imagine, what you will KNOW tomorrow !

User avatar
billy
Posts: 53
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Oregon WMR200
Operating System: RPi jessie
Location: Perth, Australia

Re: Yet Another Dayfile Reader (PHP)

Post by billy » Tue 30 Jul 2019 5:56 am

thanks for the explanation. I have spent an hour in the naughty corner and learnt the lesson (hopefully) and not be sent there again.

User avatar
beteljuice
Posts: 2710
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: ex XP SP3 - now W10 laptop grr
Location: Dudley, West Midlands, UK

Visual testing ....

Post by beteljuice » Tue 30 Jul 2019 11:54 am

O.K. ... feedback please..

the beteljuice needs less bleary eyes and brain viewpoint.

Herewith proposed new release.

Seasons corrected.
Rainfall / EVT / Windrun in year section now all have month totals and overall month averages.
Together with above, colour graduations for day / month etc. are proportional as described a few posts above.

I need people to double-check ALL possible data / views / units - 'cos the beteljuice is in sleep mode (and about to see the nurse, was the consultant yesterday - headspin)

TEST PAGE

Thanks in advance ..
Image
......................Imagine, what you will KNOW tomorrow !

User avatar
PaulMy
Posts: 1922
Joined: Sun 28 Sep 2008 11:54 pm
Weather Station: Davis Vantage Pro 2+ w/Envoy USB
Operating System: Windows-8
Location: Komoka, ON Canada
Contact:

Re: Yet Another Dayfile Reader (PHP)

Post by PaulMy » Tue 30 Jul 2019 2:26 pm

I've looked at the Rainfall, EVT and Wind Run pages and that seems very good. I do like the year/month totals.

This exercise ;) has made me look at my dayfile.txt and found a few issues causing *Incomplete dataset.
I've fixed EVT for Jan 1, 2019 as it appears a year-end rollover caused the huge negative (using the Jan19log).
Also fixed EVT for June 6, 2019 as something went bad when I shut down the VP2 Plus when moving from previous home and relocated at the new home later in the evening.
Wind run for June 6 is also zero due to that same moving, causing *Incomplete dataset. - Zeros treated as null !.
I've uploaded the edited dayfile.txt with the correct EVT

There are also some *Incomplete dataset in previous years and have not yet looked and see if I can fix those.

Enjoy,
Paul

Mapantz
Posts: 598
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 10 x64
Location: Dorset - UK
Contact:

Re: Yet Another Dayfile Reader (PHP)

Post by Mapantz » Tue 30 Jul 2019 8:20 pm

Yes. I have looked through it and it all looks fine & dandy to me.

I've just got to wait and see if Mark tinkers with the SQL version now.. :lol:
Image

Phil23
Posts: 192
Joined: Sat 16 Jul 2016 11:59 pm
Weather Station: Davis Vantage Pro2 Plus
Operating System: Win7 Pro
Location: Australia

Re: Visual testing ....

Post by Phil23 » Tue 30 Jul 2019 8:41 pm

beteljuice wrote:
Tue 30 Jul 2019 11:54 am
O.K. ... feedback please..

Herewith proposed new release.

Seasons corrected.
Can't really pass an opinon on that, being that I'm in the Southern Hemishere.
Having our season start in December seemed Ok to me, but would need to view it with a September start to pass comment.

Would mean though that a "year" would contain 4 months of 2018 & 8 months of 2019 etc.
Making the Season name something more like 2018/19...

And just one other observation & feedback, (knowing for well how much the Beteljuice enjoys change for the sake);
While showing my pages off to friends etc, I've been asked twice, what's that? "Sigma", means total.....

"Ahhhhh" is the reply.
(They usually understand though that Excel was a Hyundai car down here).

Cheers.
Image

User avatar
beteljuice
Posts: 2710
Joined: Tue 09 Dec 2008 1:37 pm
Weather Station: None !
Operating System: ex XP SP3 - now W10 laptop grr
Location: Dudley, West Midlands, UK

Re: Yet Another Dayfile Reader (PHP)

Post by beteljuice » Tue 30 Jul 2019 9:13 pm

phil23 wrote:While showing my pages off to friends etc, I've been asked twice, what's that? "Sigma", means total.....
Tsk billy ... you've been delving into the code.

It's a language option - it can be whatever you want.

Edit: Some other European languages favour capital Theta for Avg.
phil23 again wrote:... but would need to view it with a September start to pass comment.
By Your Command ... Southern Hemisphere
Last edited by beteljuice on Thu 01 Aug 2019 4:52 am, edited 1 time in total.
Image
......................Imagine, what you will KNOW tomorrow !

User avatar
billy
Posts: 53
Joined: Mon 30 Nov 2015 10:54 am
Weather Station: Oregon WMR200
Operating System: RPi jessie
Location: Perth, Australia

Re: Yet Another Dayfile Reader (PHP)

Post by billy » Wed 31 Jul 2019 1:37 pm

Billy :? In the land of oz we are called Bruce ;)

and just to clarify, the sample mean in the world of statistics (ie an estimated average) is traditionally symbolized by "x-bar" - ie an "x" with a bar across the top. Not sure if the forum fonts can cope with this?

berwickw
Posts: 4
Joined: Mon 22 Jul 2019 9:14 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 7

Re: Yet Another Dayfile Reader (PHP)

Post by berwickw » Wed 31 Jul 2019 9:08 pm

beteljuice,

Changes look great. I know I am late to the party, in fact I’ve only jumped on Cumulus in the past fortnight but whilst your making changes, is there a chance to include the following rainfall information:

1. Number of “wet days” for the month (number of days where rainfall is > 0)
2. In the summary section, Average number of “wet days”

Thx and love the work

Post Reply