To convert wind in degrees into wind direction use the formula =CHOOSE(1+ABS(ROUND(A1/45,0)),,"N","NE","E","SE","S","SW","W","NW","N") For more information see this video ua-cam.com/video/qPS-rylzKvE/v-deo.html
my data is 8760 wind data and another wind rose of the same size. when I put the data in the column by the right, iwas told id toow large please for large data like this what do I do know?
Thanks for this, found it really useful. For the benefit of anyone watching it in the future, a couple optimizations - 1) You can reorganize the columns in the pivot table by clicking on the column header, then on the bottom edge of that cell and dragging it left or right. 2) When you group, if you set the "Ending At" value to 18, it would have consolidated all those rows for you in the pivot table. 3) After doing the above, you can then make a pivot chart directly from the pivot table. This allows you to add additional filters in the pivot table and do all sorts of filtering dynamically directly in the chart to look at different slices of data, like 'what's the wind like in August vs. January, historically'
Thank you so much :) So Helpful, probably one of the most clearly articulated videos I have seen actually. I think I may actually have gotten this one now!
Thanks Karina it was helpful. So next step would be to relate these data with the pollutant concentration (Ozone), this is to know from which direction comes the Ozone high concentration.
Hello, I have a question, why do we add shells, in one table with the previous value one. I don't understand that, what's the need to add, without adding also we can do right?
I really love your explanation, thank you so much for this video! It is very easy to follow. However, I don't quite understand how you got to the conclusion that orange is the most common wind speed (5:53). And that blue is the second most common. Could someone please give me a hint?
Because the area taken up by each colour represents its occurrence, therefore those two colours (taking up the most space on the chart) represent the most common wind speeds
Hi, i have a query as we are using convertion formula for deg to naming . my wind turbine will rotate 360 deg as initial the WTG fixed to true north (North will be 0 deg) as i making absolute it seems NW (-ve value) will become NE . please correct me if iam wrong
You need to add to get them to stack up so each category goes around the previous one. If not they would be plotted over the top of each other, they would overlap and you wouldn't be able to see them properly.
The area of the colour shows how common it is. So orange and blue are more common because they cover a larger part of the plot. There is more orange and blue than any of the other colours. So the wind speed is more often 6-10 or 2-6. Whereas >18 is less common because the light blue colour is really small, you can barely see it.
You could edit the pivot table at 1:05. If you can't, create a copy and edit it like so: If you had 11 instances of calm, then type 11 under *every single* wind direction. So North would have 11 counts of calm, then south, east, west, etc.
The blank is there in my pivot table because I had some missing data so I had blank cells in my table. If you don't have any missing data you won't get the blank row.
10 m/s is 36 km/hour so 6-10 m/s is a wind of 21 to 36 km/hour. That is NOT a gentle breeze. Might the wind speeds actually be km/hour and NOT meters/second?
I'm not sure how it is in your countries, but in mine wind data from the government is given in values *0,1 m/s. The 10 therefore could actually be 1 m/s. Then again, I'm watching this because I'm making a wind rose of my local conditions over a span of 10 years, I live in a coastal region and you'd be surprised how often we get 10 m/s wind speed.
my data is 8760 wind data and another wind rose of the same size. when I put the data in the column by the right, iwas told id toow large please for large data like this what do I do know?
Try converting the data into categories first e.g. 'North', 'East', 'South' and 'West'. If you try and put the wind data as individual values into columns in a pivot table it will be too many columns for the pivot table.
To convert wind in degrees into wind direction use the formula =CHOOSE(1+ABS(ROUND(A1/45,0)),,"N","NE","E","SE","S","SW","W","NW","N")
For more information see this video
ua-cam.com/video/qPS-rylzKvE/v-deo.html
@@gavinjones7187 There is an extra comma before the "N", it should be =CHOOSE(1+ABS(ROUND(A1/45,0)),"N","NE","E","SE","S","SW","W","NW","N")
my data is 8760 wind data and another wind rose of the same size. when I put the data in the column by the right, iwas told id toow large
please for large data like this what do I do know?
Could you help me please to calculate average mean wind speed by sectors? I have all the wind speed data and direction
when I did this command some of my directions came up as 0.. any suggestions for this problem? thanks!
I am so thankful I found you. You did an awesome job explaining this. Thank you so much !! A big hug from Peru!
This is the best Dwarf metal I have ever heard. Literally brought tears to the eyes of my 17 Malaysian orphans.
Thanks for this, found it really useful. For the benefit of anyone watching it in the future, a couple optimizations -
1) You can reorganize the columns in the pivot table by clicking on the column header, then on the bottom edge of that cell and dragging it left or right.
2) When you group, if you set the "Ending At" value to 18, it would have consolidated all those rows for you in the pivot table.
3) After doing the above, you can then make a pivot chart directly from the pivot table. This allows you to add additional filters in the pivot table and do all sorts of filtering dynamically directly in the chart to look at different slices of data, like 'what's the wind like in August vs. January, historically'
Good tips, thank you!
not happening too often that I comment smth but I'm really grateful for your video..otherwise I'd never have been able to make my rose, thanks!!
Thank you so much :) So Helpful, probably one of the most clearly articulated videos I have seen actually. I think I may actually have gotten this one now!
Thanks for this, going to help a lot with my research assignment on wind analysis for runways!
thanks, finally i can enter the classroom with peace:)
Excellent video thank you so much, this helped solve a problem on the site I am working on.
Very straight to the point tutorial
wow !!! your method is fantastic and so easy to do, really thank you !!
Grateful for your video.
My problem solved in a minute. 👏
Thank you for this quick intro!
Thanks Karina it was helpful. So next step would be to relate these data with the pollutant concentration (Ozone), this is to know from which direction comes the Ozone high concentration.
Thank you very much - it helped me a lot!!
Hello, I have a question, why do we add shells, in one table with the previous value one. I don't understand that, what's the need to add, without adding also we can do right?
Thank you, saved my life
Great job, work perfectly. And also thanks for the formula.
Thank you very much for this video, very clear and helpful.
Why do you need to add B32+B21 at 2:06?
Amazing, this really helped me, thankyou!
I really love your explanation, thank you so much for this video! It is very easy to follow.
However, I don't quite understand how you got to the conclusion that orange is the most common wind speed (5:53). And that blue is the second most common.
Could someone please give me a hint?
Because the area taken up by each colour represents its occurrence, therefore those two colours (taking up the most space on the chart) represent the most common wind speeds
thank you. This presentation help me to understand Wind rose
Hi, i have a query as we are using convertion formula for deg to naming . my wind turbine will rotate 360 deg as initial the WTG fixed to true north (North will be 0 deg) as i making absolute it seems NW (-ve value) will become NE . please correct me if iam wrong
Thank you very much Karina its very helpful
Solid video. Thanks!
Any thoughts on how to automate this? (other than hiring undergrads)
Thank you, it was really helpful.
I might be dumb but why did you add at 2:00?
You need to add to get them to stack up so each category goes around the previous one. If not they would be plotted over the top of each other, they would overlap and you wouldn't be able to see them properly.
Thanks! Great tutorial!
Excellent tutorial, very clear and concise, thank you for uploading
@@karinaadcock Hi, great tutorial, but I still don't understand how to read it. why is your orange the most common one?
The area of the colour shows how common it is. So orange and blue are more common because they cover a larger part of the plot. There is more orange and blue than any of the other colours. So the wind speed is more often 6-10 or 2-6. Whereas >18 is less common because the light blue colour is really small, you can barely see it.
Thanks for making this video, very helpful
Hye, is there any method to calculate calm % in wind rose?
Thank you for making this video, this is very helpful!
My data has "Calm" as wind direction category, how will i put it here? Thank you this is a huge help!
I think you will have to assign 'calm' a numeric value in order to be able to plot it.
You could edit the pivot table at 1:05. If you can't, create a copy and edit it like so:
If you had 11 instances of calm, then type 11 under *every single* wind direction.
So North would have 11 counts of calm, then south, east, west, etc.
wonderful explanation
Simply Great....
Pasti ngerjain tugas Pak Wahyudi tekla wkwkwkwk
Very useful thanks
when i tried to group, it says "cannot group that selection"
Thanks alot
But i have only wind degree I don't know how to convert wind degree to wind direction ?
ua-cam.com/video/qPS-rylzKvE/v-deo.html
ua-cam.com/video/fqKUZO_PVS8/v-deo.html
how did you get the wind direction as E W NW SW etc.
ua-cam.com/video/qPS-rylzKvE/v-deo.html
I had to do it manually using this formula to divide the values into the directions based on angles, just change B2 to be your angle:
=IFS(OR(337
ua-cam.com/video/fqKUZO_PVS8/v-deo.html
You are perfect thank you 👏
Great help - thanks indeed
Why my (blank) didn't show up after I pivot the table?
(blank) at 1:04
The blank is there in my pivot table because I had some missing data so I had blank cells in my table. If you don't have any missing data you won't get the blank row.
@@karinaadcock thank you very much for your explanation. I get it now
why i can't group my Row labels..??
Do you have some missing data? It's probably because of that.
Awsome! Thank yous so much
thank you Karina
10 m/s is 36 km/hour so 6-10 m/s is a wind of 21 to 36 km/hour. That is NOT a gentle breeze. Might the wind speeds actually be km/hour and NOT meters/second?
I'm not sure how it is in your countries, but in mine wind data from the government is given in values *0,1 m/s. The 10 therefore could actually be 1 m/s. Then again, I'm watching this because I'm making a wind rose of my local conditions over a span of 10 years, I live in a coastal region and you'd be surprised how often we get 10 m/s wind speed.
thank you!! :))
my data is 8760 wind data and another wind rose of the same size. when I put the data in the column by the right, iwas told id toow large
please for large data like this what do I do know?
Try converting the data into categories first e.g. 'North', 'East', 'South' and 'West'. If you try and put the wind data as individual values into columns in a pivot table it will be too many columns for the pivot table.
It's not working in my exel 2010
I love you miss
the wind rose diagramm is not interpretable, if you sum up the percentages...
Can someone help me now?
Wind
awful!