Sandaysoft

Just seems that you have complicated a reasonably simple task - by combining readings from two stations how do you know which is accurate? This discussion has been had before - at least by using a single stations data, even if it is wrong at some part of the scale, it would be consistently wrong. But once you start utilising data from 2 (or more stations) you now effectively have corrupt data (this is why even the BoM use both cylinder and electronic rainfall readings - the electronic - tipping bucket - readings are used for instant readout and rainfall intensity, but the 'official' figures are always taken from cylinders because of their accuracy compared to electronic - they are never combined. Same with temperature readings).

_________________
Punctuation is the difference between 'Let's eat, grandma' and 'Let's eat grandma'

This how I do it. mostly using old station

Temp:
min: adjust depending on temp, use extra station over winter
max: leave it as it is

Hum:
min:leave it as is
Max: add 6 per cent

Pressure: use newer station, measures down 0.1 rather than rounded

wind: use old station,better

rain:ignore electronic for daily figures

everything else uses the new station and Cumulus

This way, I use the better figures to get good results, after testing ages ago and I have sticked with this.

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com

Have to say though doing a static 6% adjustment (or for min temp adjust 'as necessary') implies that only the maximum readings (or whichever) are wrong whereas it is more likely a sliding scale eg humidity correct at 10%, 6% out at 90% - what would you do if the max is 50%? You can't reliably add 6% making it 53% - the other side of this is what if the min humidity is 50% - do you leave it or alter it (it can't be right for one and not the other).

Obviously what you are doing is up to you but it appears by making adjustments like this you are over-complicating it and, let's face it, it is only a home station !

_________________
Punctuation is the difference between 'Let's eat, grandma' and 'Let's eat grandma'

No that not right.
Daytime temps are fine.
Night time temps are out, so I fix those.

Min humidity is fine
Max humidity I fix up. if its above 70 it works fine. very rarely is it below that. if it is it doesn't bother me.

Of course it is a sliding scale, but by fixing the daily extremes, I avoid that tricky bit. In winter it can be 2 to 3 warmer than it is. And because I made a set system it doesn't ruin it. It not that complicated. Web sites to my mind are more complicated.

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com

OK lately I been working on this. I created a new page http://localweatherdata.0glo.com/manualmonthlydata.htm , with a little trouble getting the extra file to work, added a menu with the first month linked, added a iframe. Thanks to GraemeT with some general instructions. I have created a new spread sheet designed for the web site as a more compact and simple set of tables for each month. I uploaded the current month as a test. I have included a link to a file giving more information about the recordings.

I did the iframe, and that works fine. However it does not show the graphs, and what with the code below the pages. The link to current month I put at the top, how can I get it open in the iframe. That link opens on a new page and that works fine, but it would be nice to put in the iframe, but I might work better to forget the iframe because you can see more of the table with out a iframe on a seperate page. Some comments might help.

I would appreciate help with this.Thanks.

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com

You could crunch the width of the data table by using short day / month names and using 24h times

To put contents into an IFrame just give it a name and the links use target=

http://www.w3schools.com/html5/tryit.as ... frame_name

_________________

......................Imagine, what you will KNOW tomorrow !

Thanks for the advice beteljuice.

I created the spreadsheet last year, when I transferred from paper records. I did not have had any aim to make them available on the web and the size did not matter. The Bad thing is that I need to keep it small if I use a Iframe. I have to give that some thought, maybe forget the iframe. But I had this system as simple as possible, where I take the figures from the station which records it as 12 hour time and that makes it quick and easy. All my records since 2009 have been recorded in 12 hour time so it would be too late to convert all reading to a new type of reading.

Now to change things too much, it would cause it to get complicated. This is because the spreadsheet is a more basic version of the real spreadsheet, with data that I am not going to publish, mainly comparsions to bureau readings. In the real spreadsheet I enter the figures from the station, then this spreasheet contains links to that other spreadsheet. So to change the time format I would have to change the format in the real spreadsheet, which I think will cause more trouble.

Its a good idea compressing it, but even it that it all won't fit in. I would do it if didn't cause much trouble. But I could easily shorten the days on the left, but I do like the long format, But thanks for your comments.

Edit: If you click on the link at the top for the current month it displays on a page on its own and thats works fine, or maybe I should make the iframe wider so more fits in.

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com

I also seem to be having a problem with uploading the file. I had some mistakes in the file, but I can't get it to show the newer one, even though I uploaded the new file. It uploads on filezilla worked fine, but the site shows the old file. The average, min and max at the bottom of the page was not correct.

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com

I still getting trouble with the file on the site. I save the htm copy to upload and that is correct locally but when I view on the site its the same old one, not the updated one. I might try it all over again tomorrow with a different file name ( I have saved as FG Measurements 2012.2 simple) and I will see if I can solve this.

On the site it also seems all the text on all web pages are now smaller than before, I don't know why.

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com

I finally have solved this after do the new page all over again. I know why it would not update, because when I uploaded the new file, I only uploaded the htm file but I forgot to upload the ...files folder, which contains the sheets of the spreadsheets (I did upload the folder to start with but with the updated file I forgot to do it) and because I did not upload that it still showed the old table.

About the iframe, I discarding the idea using the iframe with the monthly tables, it will not fit all the contents in. So the monthly tables are accessed from a menu above the iframe and the tables are shown on a seperate page all by its self and thats fits it in well. But I am still going to use the iframe, but I created a smaller file to show today and yesterday as just a quck reference if you do not want to look at the proper table, like the today and yesterday pages of the Cumulus data, but the monthly table from the menu is like the Cumulus page for this year.

I will in the future add the older months to the menu. I glad I sorted that out. The page is here: http://localweatherdata.0glo.com/manualmonthlydata.htm

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com

Hmmm you've posted the link so comments about the page(s) are obviously asked for, so...

A number of things wrong -

The borders of the top table and lines between the tables extend well beyond the actual table and data to the right - either something is missing or it isn't programmed correctly.

Why keep repeating the table heading - 'Recent min and max' - at the top of EVERY table? Redundant and uses a lot of screen space unnecessarily.

Everything is left justified - on a (now standard) wide screen display this means everything is displayed between aorund 20% and 50% of the LHS of the screen. Makes the screen look awkward.

Headings - M24, N24, ON, OD,MI, Ma - what are they supposed to mean? Obviously you know but the user doesn't...

Sroll bars within scroll bars within scroll bars - why? Sorry - looks messy and complicated. Doesn't allow the user to control both sets (in the iFrame) with a scroll wheel (which then defeats the purpose of using scroll wheels on that page). The way you have it set out you actually have 3 sets of scroll bars - two within the iFrame plus the browser scroll bar as well - it makes it difficult to know which one to use to browse through data.

Recent FG Daily Measurements - I presume you are referring to Ferny Grove - don't assume the user knows FG might mean this. And then the data is displayed as XML instructions - no data.

Screen says 'Last Updated 25/2/12' - when? At midnight, 9am, midday??? You then confuse things with the statement the data is a summary of manual data for today and yesterday 'updated at the end of most days' Example - given that it is now 4pm in QLD, if the max of 23.4 at 12:50pm actually for today, Sunday or leftover from yesterday?

In the code itself - what is the purpose of this coding:



It is spanning spaces - and, looking at the code, there is a LOT (and I mean huge amounts) of code that simply do nothing but place empty, blank, rows and cells on the screen.
Have to ask - why are you insisting on iFrames? Good screen presentation should allow the user to see what you want them to see in a single screen without having to scroll either vertically or hrizontally (your window(s) has both horizontal and vertical scroll bars). Better to either group various readings together on a single, sstandard table-like display, use tabs (if possible) and just change the data with the display. No scrolling, no having to look all over the screen. If done properly (loaded from data files) you can load all the data into memory variables when the page is loaded and refresh rates for the different data displays (temperatures, wind, pressure etc) can be almost instantaneous when the data changes.

Matt - please - take this as constructive - I do a lot of editing of books (both technical and novels) and this sort of thing stands out like a sore thumb to me. These are all points you can improve your pages from, so take it that way and not as being, in any way, destructive.

_________________
Punctuation is the difference between 'Let's eat, grandma' and 'Let's eat grandma'

Matt,
I'm glad to see you're making progress.

Stephen,
This is about what you can expect for a spreadsheet that's been saved as HTML by Excel or Word. You get all sorts of stuff that means nothing at all to a human, not to mention totally non-w3c compliant. But if you then load it in an iframe, you separate it from the rest of the page, making the host page more readable.

That said, Matt's target was to display his spreadsheet data in a web page and I see he's achieved that quite satisfactorily.

_________________
Graeme.
http://weather.gktnet.com/cumulus/index.htm

I did it in Excel and until I upload it I don't know how it could look. But I can fit that it you don't like it.


Fair enough, it was enough to get it working, but a good point.



OK, so should it be in the middle of the iframe, I don't know until I create the htm, ends up different to the spreadsheet.



I knew that would be the case, so that I can make the spreadsheet as compact as possible. That is why I wrote a file at the link "click here for Click here for more information about these measurements" and that will explain that. It might be detailed but I wanted to fully explain it.



Yes that the way the iframe has come out, I know little about iframes.

Again that is mentioned in the instructions file and yes that is Ferny Grove. I have wondering why all the code at the end is there for.



I create the tables from the weather station at the end of each day. So it was last updated last night, the 25th and that is today is for 24th and yesterday for 23rd. At the end of the day, the readings taken for the whole of that day. Is that clear. I could add when I update it, but it is at the end of the day (ie post 6pm).


Like what Graeme said, I did not create the code, I saved as htm file to display, that my aim, unless you think there is a better way to display the data. To fit it in a iframe, I had to seperate the tables into several tables. Now on the page there is the following. 1) the menu of tables- ie at the moment is "2012 Feb" because this is the first table so far, 2) the link to more information and c) the more basic version (today and yesterday) of the the monthly tables in the above menu placed in the iframe, so you think that should be on a seperate table on another page like the monthly tables in the menu above.

Your comments are very good, thanks and will act on them.

And Graeme thanks for you comments.

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com

Matt,
I'm sure there are ways of coaxing Excel to produce less garbage withing it's generated html, but I've never looked into it, since I only use it to chart my past rainfall results.
You can probably 'fine tune' the spreadsheets themselves to help things along too.

Cheers for now.

_________________
Graeme.
http://weather.gktnet.com/cumulus/index.htm

I could fine tune them, because I never intended to publish them as that not so important.

Edit: Btw what you think needs to be fine tuned. Thanks

_________________
Regards, Matt of Brisbane, Australia
Web Site: http://www.localweatherdata.0glo.com