Download a master spreadsheet to your local computer first. You can choose from ods of xlsx formats. Available as howtoturbinewindpower3.ods.zip or as howtoturbinewindpower3.xlsx.zip
Copy the master spreadsheet to a new file for the news site. I use
libreoffice format (.ods) as my master spreadsheet so this would be
E.g.:-
cp howtoturbinewindpower3.ods myturbinewindpower4.ods
Now I open the new myturbinewindpower4.ods for editing.
In browser open the globalwindatlas.info In the Search... field paste your latitude , longitude e.g. "61.123456,22.123456" The map will show wind speed map with a marker at your latitude and longitude.
On the map click on the 10m control to select a tower height of 10m. The map will redraw and change colours because the wind is slower at 10m than 100m.
Hover the cursor exactly over the map central marker and note the mean wind speed as displayed on the windspeed colour scale. In my case this was 3.38 m/s. Enter this into spreadsheet in cell C2.
Click exactly on the map central marker to create user marker at this same latitude and longitude. The result will be a blue place marker balloon at this point and a 3km by 3km square box around the place marker. An info panel on the right hand side will now show 3 info tabs labelled "Area Data", "Temporal Data" and "Energy Yield". Click on "Temporal Data". On this tab select your timezone, in my case "UTC+2" The sub pane on this "Temporal Data" tab will be showing "Wind Speed Variability" at 100m. Don't worry about the 100m. It can't be changed and speed is already normalised to 1 so is correct for all lower heights.
On this "Wind Speed Variability" pane, click the "next" button until you see the line graph of "Monthly" variation whuch has wind speed index on Y-axis and month number on X-axis. Hover over the points on this graph and enter the y-axis values into the spreadsheet starting at month 1 which is Jan and will be entered into cell C52 (in my case 0.95). Continue for other months e.g. month 2 which is Feb is entered into cell C53 (in my case 0.97) until columns C52 to C63 are filled.
Save spreadsheet. Relax. You have customised the wind speed variability!. You can admire the results in the "Wind Energy by Month" graph below!
On another browser tab open PVGIS calculator. Just below the map, PVGIS accepts separate latitude ( 61.123456 ) and longitude ( 22.123456 ) fields to search for your site so paste these in separately, then press the Go! button. You should see quite a nice map with a place marker balloon already marked at your latitude, longitude. The default tab of "PERFORMANCE OF GRID-CONNECTED PV" is already shown.
Tick the checkbox "Optimise Slope and Azimuth" and then press button "Visualise Results". A monthly chart of energy will be shown along with other data. Feel free to experiment with the field "Installed Peak PV Power [kWp]" depending on your budget (in my case 7kWp). Re-press "Visualise Results".
This "Monthly energy output from fix-angle PV system" pane has "PV Energy output [kWh]" on Y-axis and month name on X-axis. Hover over the points on this graph and enter the y-axis values into the spreadsheet starting at month 1 which is Jan and will be entered into cell G52 (in my case 65.63). Continue for other months e.g. month 2 which is Feb is entered into cell G53 (in my case 235.35) until columns G52 to G63 are filled. It does not matter what kWp solar array you chose (does not need to be 90k) as these values will be summed and normalised to calculate the solar index for each month which is valid for any solar array size.
The solar part of the spreadsheet actually uses PVOUT in cell C4 (in my case 780 kWh/kWp) obtained from a solar energy density map separately obtained. If you wanted to use the PVGIS results instead you can reverse engineer PVOUT as cell G64/yourkWp = (in my case 5983.52/7 = 854.78) reflecting a lower system loss. This reverse engineering has been done for you with answer in cell G67 if you have put your kWp (7) in cell C5. Copy the value of G67 by hand as number not formula to PVOUT (cell C4) as this is a normalised constant density for the site and should not change if you later change C5 to have a larger array.