Software for the air conditioning, ventilation and refrigeration industry
Where in the world are you?
We have compiled a large database containing climatic data suitable for airconditioning and refrigeration calculations. We use this database extensively in all of our applications and provided it at NO COST as a service to the industry. All we ask is that if you use the database you acknowledge us.
The purpose of this document is to explain how to reconfigure the database to suit your needs.
Each data field contains the following information.
The Data Files
To speed up file access, we have split the world into regions. This is where you may want to make some changes.
The regions that we selected is as follows:
+All, United States, Canada, South Africa and Africa.
"+All" is where we started. This contains the whole world data and each sub-region is a different country. However, in a big country like the USA, you would want to split the country into the States. The United States therefore becomes a region and the sub-regions are each of the states.
Open the file Regions.idx to see how to make the split.
The Actual Data
Now, the source is stored in a Comma Separated Variable (csv) text file called WorldLocations.csv. Below is an extract from somewhere in the middle of the file.
So, if you plan to make split South Africa into provinces, you will need to find all lines starting
with 101. This applies to South Africa in the countries section. Now edit the second field in the
database to reflect the province. Next, add the section in the regions.idx file as seen below.
OK, we did this one for you but if you follow this format you will be able to split any of the
regions into sub-regions.
[South Africa] +All=0 Gauteng=1
North Western Province=4
and so on...
Building the Database
The program doesn't work directly on the text files, this would be too slow. Instead, we build a file of records. The advantage is data security and speed. Each data line that we discussed above can now be read with one read statement from the program. For you to make these files, just press the Build button.
You will see a message showing how many records were created.
Viewing the data
Pressing the Test button will allow you to browse the database.
Here you can browse the complete database.
We provide this database as is with no guarantees as to its accuracy. If you find any errors, please let us know.
We are strong supporters of the work done by ASHRAE. Consequently much of the information used in our applications come from the ASHRAE Handbooks. For local country information, we did gather some info off the internet and local references. This type of information is hard to get, so if you can suggest some references to your local conditions, we would be interested.
ASHRAE 2001 Fundamentals Handbook
Carrier System Design Manual, Australia