Hi Caroline,
Despite spending hours reading your help tools and tutorials I am still no wiser on how to make the CSV files from the BOM in Australia import successfully into weather tool and do their thing.
I do not see the correlation between the left and right columns of the import dialogue and the info from BOM and that component is not explained to me.As I am doing a lot of work in this field and can access many BOM CSV data files the ability to be able to make the local info work in weather tool would be great
.Any ideas
Regards john brodie

BOM
Hi John,
Can you please send me your BOM file?
I am unfamiliar with it but will give it a shot.
Cheers,
Olivier
BOM DATA
Hi Olivier,
I responded in the Weather tool forum with the info from the BOM records.
john brodie
VIM Consulting
Construction and sustainability management
bom files
Hi Olivier,
Just wondering of you got my CSV files from BOM?
john brodie
VIM Consulting
Construction and sustainability management
BOM
Hi John,
I have received your file, but unfortunately, it isn't an hourly data file...
See my post here.
Cheers,
Olivier
weather data
Hi Olivier
I thank you for your assistance.What I have done is contact the BOM and they have sent me a sample of hourly weather data available from a broad range of sites.I was wondering whether you could have a look at it an see if it is usable info.If it is let me know if the format is ok etc.If it is worth it I can buy a whole lot of the info and hopefully with a bit of assistance form you feed into the Weather tool.I will attach the sample file and you can let me know your thoughts
john brodie
VIM Sustainability
Construction and sustainability Consultants
BOM
Hi John,
Yes! this will work, BUT you are still missing the solar radiation data...darn...you've got pretty much everything else...so, it all depends if you want to spend the money and not get the radiation - which would have an impact on the design of course...you may be able to add these as "synthetic data" in the Weather Tool if you have some type of data on hand...or we could work it out so that we use the same radiation data as another .wea file that is close by...you have the cloudiness, so that could work okay i suppose...a bit of gymnastic here and there...but the import shouldn't be all that bad as the BOM are coma delimited, so they are fast to import in Excel...
If you can get your hands on a Aus. BOM Hourly Data file (.LST file), I think the Weather Tool could recognize it automatically...
Let me know your thoughts...
Olivier
bom weather chart files
Hi Olivier,
Thanks once again for your efforts.I am still mystified by the response form the BOM but have attached their latest response to see if you can understand it.
Have a look and let me know your thoughts.
Lesley from BOM says:
"Half Hourly solar data is only available from our surface based stations (refer to map with attached data sample). Satellite derived daily totals are available using any BOM station.
I cannot include the half hourly solar data with the metar half hourly/hourly data as it comes from different tables. Solar data are in Solar time.
Data are ASCII, comma delimited
I currently run data for a client who gets daily totals, single file output, last 7 days, sample also attached."
Any queries please contact the undersigned.
Kind Regards
John Brodie
VIM Sustainability.
Construction and Sustainability Consultants.
Mob: 0401 84 8888
Ph: +61 2 9517 4899
Fax: +61 2 9517 1223
http://www.vim.net.au
'Sustainability is Survivability'
ABN 7504 8239 242
john brodie
VIM Consulting
Construction and sustainability management
MORE BOM
Hi Olivier,
Sorry it seems I sent through copies of the same thing.
I have attached what maybe some other stuff of importance from BOM
john brodie
VIM Consulting
Construction and sustainability management
BOM
Hi John,
The sample solar radiation I you sent me was a daily one, so i could not include that in the previous data. I could not use the Half Hourly data either
I do not know what the LST type of file the Weater tool refers to. If you go to Open > Fixed Format > open any file > You can see under the Custom Format drop down menu the Aus. BOM Hourly Data (LST) file format.
Something must be out there since squ1 got quite a bit of cities with radiation data processed into .wea files...I just don't know where they have gotten them from.
I am attaching the sample test .wea file from the first file you had sent me. Everything else is there, albeit just for the one month your data was for.
Sorry I cannot be of more help.
Olivier
weather tool
Hi Olivier,
Thanks for your help in the weather files matter mate.I don't really understand the issue and haven't had time to sit down and go though it slowly right now.Your assistance was much appreciated.Maybe you could show me how to load the information we do have into the Weather Tool .That might help me understand the latest issue.One query I don't an answer to is the PMV Tool.Do you know how to save it and copy it to a word doc or similar with printing it out then scanning it.It seems impossible to just save it or copy it over to another document.
Any advice would be appreciated
Kind Regards
John Brodie
PMV Tool
Hi John,
You can go to the FILEat the top of the window.
It allows you to save it or copy it.
If you copy, you can then paste onto another document such as .doc; however, it does not copy the graph, just the data.
You know, it could be easy enough to do a Print Screen and paste that into a .doc
Hope that helps.
Best,
Olivier
weather data
Hi Olivier,
Thnaks for your help on the pmv chart
I am keen to understand how to import that weather info I sent you into Weather tool.
The instructions on the site are too hard to decipher epscially considering ithe BOM is in a different format.I know we dont have all the info but even with the stuff we had if I am able to understand how to do that I might be able to do something to play around with the cloud cover and stuff we do have as you suggested to mimic solar radiation.The other info you said the BOM stuff has is important for my reports though so it would be good to understand how to import it into Weather Tool
Are you able to advise here ? Thanks mate.
john brodie
VIM Consulting
Construction and sustainability management
BOM in Weather Tool
Hi John,
Sorry for the delay, I have been away for a little while...
Have you noticed the new tutorial on how to import BOM?
Have a look at the wiki.
I have not gone through it myself.
I have to catch up on a few things.
Let's discuss later.
Cheers,
olivier
More on Australian weather data...
Just a quick update for those of you who have been following this discussion thread about Australian Weather data and WeatherTool.
John recently sent me a CSV data file for the city of Port Kembla, containing monthly weather data values. Unfortunately, this kind of data is not particularly useful, at least not by itself. WeatherTool deals exclusively with hourly weather data - the monthly summaries you can see in WeatherTool are derived from hourly data.
However, this monthly weather data can be useful when hourly data is not available for your specific geographic location. In this instance, you would use the available hourly data from the nearest weather station, and then moderate this data with the monthly data for the specific location. For instance, under the Monthly Data tab, you can enter the respective monthly values for the specific location, and then this will alter the hourly values in order to create the specified average value. This is known as synthesised data, because it has been derived through interpolation, rather than actual recorded values.
As it turns out, the vast majority of solar radiation data in Australia is synthesised data. The Bureau of Meteorology derive almost all of their solar radiation data from satellite recordings, rather than 'on the ground'. They then run this data through a whole bunch of algorithms to generate daily solar radiation values. Hence, they don't actually record hourly values in specific locations.
However, in 1978, an initiative by the National Energy Research Development and Demonstration Council (NERDDC) resulted in 'real' hourly solar radiation values being recorded for approximately 60 sites around Australia. Though even around 20 of these sites use synthesised data.
I also understand that recent solar radiation recordings by BOM are not as accurate as they should be, due to calibration issues between ground monitoring stations and the satellite derived data. More information regarding this can be found at the following links :
I've been advised that the Bureau is currently looking into recording hourly values for solar radiation, but they're not quite there yet.
So while most of the weather data available from BOM can be used in WeatherTool, another source for hourly solar radiation data is required. I've found two companies that can supply this :
I spoke to a person named Trevor at ACADS-BSG - the hourly solar radiation data they have is essentially the data collected by NERDDC, and can be supplied in a CSV format compatible with Ecotect. They also supply all of the weather data as supplied by BOM, so it's possible to purchase everything from them, instead of from two different sources.
I haven't spoken to anyone at Energy Partners, but I understand from a colleague that they were commissioned to provide all of the weather data used in the AccuRATE analysis engine. Thus, they should be able to supply data in a similar format to the climate zones used by AccuRATE.
Alternatively, it is possible to estimate your own hourly solar radiation values from the BOM daily totals. I found the following table in Sun, Wind & Light: Architectural Design Strategies (2nd Edition) by GZ Brown and Mark DeKay :
Being for temperate climates in the Southern Hemisphere. If you you break down the daily total values from BOM using these percentages, you could then enter this as hourly solar radiation data into WeatherTool. The not so good news is that you would have to do this manually, and you would also have to account for the calibration discrepancies that exist in the BOM data, as described above.
Regarding BOM data in general, it looks like they no longer use the LST format as listed in WeatherTool - instead, the data is supplied simply as a CSV or TXT file. However, Square One Research is working on an importer for Weather Tool that will allow you to automatically import BOM data, rather than having to do it manually as described in the wiki tutorial here.
I hope this helps to clarify some of the issues faced when trying to import Australian weather data into WeatherTool. If you still need additional help, I am happy to provide any assistance I can, as long you don't mind if any weather data files we create together can be uploaded to the SQU1 wiki and shared with other users.
Kind regards,
sid.
sid thoo architect
ABWA (No. 2142)
BOM 2 WT
Hi Sid,
Thanks a lot for the research! This is very useful info.
I have never created synthetic data in WT although I know possible. Will give it a go soon to try it.
Cheers,
Olivier
Thanks
Hi Sid and others,
Thanks a million, I was really worried about this problem jeopardising my entire undergrad thesis.
With a grateful sigh of relief,
Regards,
Paul