Cumulus Support

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.

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.

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!

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

Rainfall

Naughty billy

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

Makes comparisons confusing.

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

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 !"

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

@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.

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

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 ..

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

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..

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.

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

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?

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