-
I have met data in an Excel format. Can I use it in WRPLOT View?
-
Is there a way to modify the WRPLOT code for my special case?
1. What formats of data can I use in WRPLOT View?
WRPLOT View accepts a number of different standard meteorological data formats such as SCRAM, SAMSON and CD-144. The accepted data formats are described in the WRPLOT View Help under the Met File Formats section. Examples of the various formats are available in the folder WRPLOT_Samples inside your installation directory and you can also download free samples of SCRAM, CD 144, and SAMSON formats at www.webmet.com
2. I have met data in an Excel format. Can I use it in WRPLOT View?
Not directly, but you will be able to convert your Excel formatted data to an acceptable WRPLOT View format. You can use the Import Surface Data from Excel utility to convert data that is contained in a Microsoft Excel file to an hourly surface data file in the SAMSON format. The SAMSON output from the Import from Excel utility is accepted by WRPLOT View.
3. I received an “invalid integer” error message when I selected the Import button in the Import from Excel utility. What does “invalid integer” mean?
Most occasions, this is the result of an issue with the format of meteorological data in Excel. Consider double checking the following:
1) Have your cells been properly formatted from the beginning to end of the file? For example, the month of February should be written as 2 or 02, not as –02-, Feb, or 0.2.
2) The Import from Excel utility is expecting an HOURLY data file. Missing dates and times will not be imported.
3) Text cannot be imported.
4) Negative values are not accepted. A wind direction of 315 degrees must be written as 315 degrees, not –45 degrees.
5) Wind direction must be written as whole degrees. A value of 315.5 degrees is not accepted.
6) The maximum amount of data, which can be imported from an Excel file, is 5 years (approximately 43,800 lines).
4. What columns of data does WRPLOT read?
WRPLOT View checks only the date, time, wind speed and wind direction of met data files. In the case of SAMSON files, WRPLOT View is also reads the precipitation data, so a rain rose can be created.
5. How does WRPLOT View handle missing data?
If your met data file has missing or incomplete data, WRPLOT View will generate a list of errors displayed in the List of Incomplete/Missing Hours and the hours containing those data will not be imported. The data from those hours will not be used to generate the wind rose.
6. Why do I get different frequency distributions than what is shown WRPLOT View when I sort the full wind direction data in another program such as Excel?
SCRAM, CD-144, and SAMSON met data is only measured in tens of degrees. As a result, when you import wind direction the last digit of the direction value is truncated (i.e. 4 in 134) in order to write to SCRAM format. When WRPLOT View reads in any SCRAM data, it has a random seed generator (the same one that is used by the EPA for such purposes) to generate a value for the third digit. This prevents a bias for certain categories of wind direction data. As a result, it is possible that some of the fringe wind direction values can get categorized differently. This explains the slight difference in the frequency counts when you use the non-truncated data. For more information on this Randomize feature, please see Randomize in the help menus.
7. Does WRPLOT View randomize wind directions?
Yes. WRPLOT View applies a Randomize feature to met data in the SCRAM and CD-144 formats. For more information on this Randomize feature, please see Randomize in the help menus.
8. Can I change the wind speed classes in wind rose plots?
Yes. You can modify the wind speed classes using the Wind Classes dialog. The default wind speed classes correspond to those in the U.S. EPA WRPLOT program.
9. What about calm wind definition?
Wind speeds up to and including 1 knot (0.51444 m/s) are considered to be calm. Calm winds are not shown on the wind rose plots because they have no direction. However, they are recorded in the "Calm Winds Frequency" count in the Data File Info panel of the Met Data Information tab.
10. Can I save my Wind Rose Plot to a file?
You can save your wind rose plot as a bitmap or an enhanced metafile. A metafile can be inserted into any Windows program (Word, Excel, etc). A bitmap is smaller and less detailed than a metafile. To save the Wind Rose Plot to a file, click on the Save to File button in the Print Preview dialog.
11. In printing the Wind Rose Plot, I selected the cross-hatch fills. However, in the printout all the fills were solid black. When I selected the color fills, it worked well, printing shades of gray. What is the problem?
This problem is due to your computer's printer driver. When you press Print in WRPLOT View, the program sends a message to the Printer Driver, which then sends a message to the Printer. When you select the color fills, the printer driver tells the printer to print shades of gray. When you select the cross-hatching, the printer driver tells the printer to print cross-hatching. Some printer drivers don't know how to make the printer do this and the printer therefore simply prints solid black. You can solve this problem by ensuring you have the most updated drivers for you printer.
12. Is there a way to modify the WRPLOT code for my special case?
We suggest converting your data to a tab or space delimited format and importing this file to Microsoft Excel. Then using the Import from Excel utility will allow you create a meteorological data format, which is compatible with WRPLOT View.
Knowledgebase |
|
|
|
|
|
|
You must be in current maintenance to login. |
|
 |
|
 |
|
|
|
 |
|
|
|
 |
|
|
 |
|||
|
|||
 |
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
