How to make a wind rose in excel

[@karinaadcock]

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 kzbin.info/www/bejne/p4G2XqWvod9-rKc

[@nyersa1]

@@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")

[@rooseveltaghabueze7862]

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?

[@alexandrum.1383]

Could you help me please to calculate average mean wind speed by sectors? I have all the wind speed data and direction

[@allieoliver9383]

when I did this command some of my directions came up as 0.. any suggestions for this problem? thanks!

[@entresaposyculebras]

I am so thankful I found you. You did an awesome job explaining this. Thank you so much !! A big hug from Peru!

[@qhurro8931]

This is the best Dwarf metal I have ever heard. Literally brought tears to the eyes of my 17 Malaysian orphans.

[@markadowdy]

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'

[@karol6322]

Good tips, thank you!

[@deceptorix]

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!!

[@BelatedCommiseration]

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!

[@David-jw7xl]

Thanks for this, going to help a lot with my research assignment on wind analysis for runways!

[@simonjonathan3359]

Very straight to the point tutorial

[@Ariqnafl]

thanks, finally i can enter the classroom with peace:)

[@borjasanchez2468]

wow !!! your method is fantastic and so easy to do, really thank you !!

[@eng.hafizhabibhabib1268]

Thank you for this quick intro!

[@JackLaniganRyan]

Excellent video thank you so much, this helped solve a problem on the site I am working on.

[@angelmayca2198]

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.

[@NS-gr9cy]

Grateful for your video. My problem solved in a minute. 👏

[@Lebon-g4o]

Thank you, saved my life

[@nicolashurtadoarroyo1538]

Great job, work perfectly. And also thanks for the formula.

[@tunelbaba]

Thank you very much - it helped me a lot!!

[@plutohopkin]

Thank you very much for this video, very clear and helpful.

[@sesshuswan]

Amazing, this really helped me, thankyou!

[@sudattasud3294]

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?

[@yellowchannel9284]

Why do you need to add B32+B21 at 2:06?

[@AsmikaHarnalinSimarmata]

thank you. This presentation help me to understand Wind rose

[@gokceertugrul6831]

Thank you very much Karina its very helpful

[@a.fatihkuloglu2931]

Thank you, it was really helpful.

[@pertoor]

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?

[@LaZy_WooD]

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

[@ElfengourAbdelhakGIS]

Thanks for making this video, very helpful

[@MurasakiCrow]

I might be dumb but why did you add at 2:00?

[@karinaadcock]

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.

[@MurasakiCrow]

Thanks! Great tutorial!

[@Freeedy]

Excellent tutorial, very clear and concise, thank you for uploading

[@cytisha]

@@karinaadcock Hi, great tutorial, but I still don't understand how to read it. why is your orange the most common one?

[@karinaadcock]

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.

[@nagachandramoulit912]

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

[@ckeil35]

Solid video. Thanks! Any thoughts on how to automate this? (other than hiring undergrads)

[@HellfireTech]

Simply Great....

[@YiBeiliang]

Thank you for making this video, this is very helpful!

[@syahirahnasuha5528]

Hye, is there any method to calculate calm % in wind rose?

[@renealfonsografhernandez8741]

Very useful thanks

[@ad3ly]

when i tried to group, it says "cannot group that selection"

[@kurapika6218]

My data has "Calm" as wind direction category, how will i put it here? Thank you this is a huge help!

[@karinaadcock]

I think you will have to assign 'calm' a numeric value in order to be able to plot it.

[@brianfong5711]

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.

[@shubhamasatkar1297]

wonderful explanation

[@jackpagla2051]

why i can't group my Row labels..??

[@schroedinger05]

Do you have some missing data? It's probably because of that.

[@chitrarai8298]

how did you get the wind direction as E W NW SW etc.

[@karinaadcock]

kzbin.info/www/bejne/p4G2XqWvod9-rKc

[@100brokensticks]

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

[@HydrographicSurveyor]

kzbin.info/www/bejne/nKKuho2FlLWJiZo

[@ramitareq2942]

You are perfect thank you 👏

[@jonvassella1076]

Great help - thanks indeed

[@youssefazergui9367]

Awsome! Thank yous so much

[@aybikebolat741]

thank you Karina

[@ramitareq2942]

Thanks alot But i have only wind degree I don't know how to convert wind degree to wind direction ?

[@karinaadcock]

kzbin.info/www/bejne/p4G2XqWvod9-rKc

[@HydrographicSurveyor]

kzbin.info/www/bejne/nKKuho2FlLWJiZo

[@haryotejo7231]

Why my (blank) didn't show up after I pivot the table?

[@haryotejo7231]

(blank) at 1:04

[@karinaadcock]

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.

[@haryotejo7231]

@@karinaadcock thank you very much for your explanation. I get it now

[@sayyyoo]

thank you!! :))

[@rooseveltaghabueze7862]

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?

[@karinaadcock]

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.

[@mirririba4783]

It's not working in my exel 2010

[@robertlawson4295]

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?

[@bastange8856]

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.

[@xdlmao7880]

Pasti ngerjain tugas Pak Wahyudi tekla wkwkwkwk

[@josejunior1521]

I love you miss

[@rukentas6867]

Can someone help me now?

[@bra1nsen]

the wind rose diagramm is not interpretable, if you sum up the percentages...

[@xillo478]

Wind

[@couchman184]

awful!