Microsoft Excel Wind Analysis Software Program

1
Microsoft Excel Wind Analysis Software Program

• Instructions and Walkthrough
• Prepared by Matthew West, INL Renewable Energy,
  Summer Intern2005

2
Upon download, the program opens to the title
page. Read the text, then click on the Analysis
tab to proceed.
3
To help things run a little faster, select
Tools-Options.
Click on the Calculation tab, and pick Manual.
This keeps Excel from re-calculating the entire
workbook after every little change you make.
4
The first step is to paste in your wind
data. This needs to be done under the designated
headings.
A sample data set has already been included with
the analysis file.
5
To insert data when cells are blank, simply
highlight the original set, right-click your
mouse, and select Copy. Then. . .
Select the first cell under Average Speed,
right-click the mouse, select Paste Special,
then choose Values.
6
Next, site information and calculation
specifications must be defined.
Site Information-Be sure that Start Time and Stop
Time are entered with the correct format. These
should be the first and last time stamps in the
data set.
Calculation Information-Make decisions based on
the data that you have and the type of results
that you want.
This is all completed in the green cells shown
above.
7
Note the cell that asks for a power curve number.
Click on the tab labeled Power_Curves at the
bottom of the page.
8
You can also enter in your own power curve.
Simply fill in the green cells with your data.
Type in the turbine model and manufacturer here,
if desired.
Calculate the worksheet by pushing ShiftF9 on
the keyboard, then return to the Analysis sheet.
All the power curves are ordered alphabetically,
and each is assigned a number (shown at left).
Choose the curve you want, and enter the
corresponding number in the cell described on the
previous slide.
9
Once a power curve is selected, the next step is
to insert the time stamps.
These are calculated and placed into the
spreadsheet via a macro, described here.
Be sure that you have the correct data range and
increment value set. Then push Ctrld, and the
time stamps will appear.
10
Finally, push ShiftF9 to calculate all of the
cells on the Analysis sheet. This may take a few
minutes. . .
Click on Power Curve Graph tab to view the graph
of the power curve you selected.
Click on Monthly Wind Variation Graph to view the
wind speed variation over your defined period of
time.
11
For a summary of results, click on the Summary
Report tab.
Again, calculate this worksheet by pushing
ShiftF9.
Notice the space on the page where it says Drag
wind rose picture. . .
12
Double-click on the icon shown above, after you
have downloaded the executable from the website
and saved it to your computer.
Select File-Load Excel File from the drop-down
menu.
Browse until you find the name of your Excel
Analysis file. Select it and pick Open, or
double-click.
Then close the program, and reopen it with the
icon as before.
13
Next, select File-Copy from the drop down menu.
Go back to the Summary Report sheet in your file.
Right-click and select Paste.
14
The wind rose picture can be modified so that it
fits into the summary sheet.
This is done using the Picture toolbar.
You can then place the picture in the designated
square on the sheet.
Select the crop button. Then click and drag on
the white boxes around the wind rose to make
adjustments.
This page has been pre-formatted for printing.
15
Congratulations!
Back on the Analysis sheet, clear all of the data
by pushing Ctrle to run the other macro,
described here.
Note the red flags in some of the cells
throughout the spreadsheet.
To view a helpful comment, hold the mouse arrow
over the cell containing the flags
You have now completed your analysis!