No video :(

How to make a wind rose in excel

Подписаться 46 тыс.

Просмотров 167 тыс.

50% 1

In this video I show you how to make a wind rose in excel. I have wind direction and wind speed data which I put into a pivot table and then I use a radar chart to make a wind rose.
A wind rose graph is used to show the distribution of wind speed and wind direction for a time period at a particular location.
---------------------------------------------------------------------------------
If you want to see how I changed my wind direction in degrees into wind direction categories watch this video:
• How to change wind in ...
This video is part of a playlist: Daily cycles of ozone concentrations • Daily cycles of ozone ...
---------------------------------------------------------------------------------
#exceltutorials #excelpivottables #excelcharts
SUBSCRIBE: goo.gl/c46YPs
VIDEO INFO: This data is related to my university dissertation.

Опубликовано:

6 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 84

@karinaadcock 6 лет назад

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qPS-rylzKvE.html

@nyersa1 5 лет назад

@@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 5 лет назад

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 5 лет назад

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

@allieoliver9383 2 года назад

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

@entresaposyculebras 7 месяцев назад

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

@markadowdy 4 года назад

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 2 года назад

Good tips, thank you!

@qhurro8931 Год назад

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

@user-wz3oc8zo9i Месяц назад

Thank you, saved my life

@deceptorix 4 года назад

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

@angelmayca2198 6 лет назад

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.

@muhammadariqnaufal9570 5 лет назад

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

@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?

@simonjonathan3359 5 лет назад

Very straight to the point tutorial

@BelatedCommiseration 6 лет назад

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 4 года назад

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

@user-xi9jf2bq9e 11 месяцев назад

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

@borjasanchez2468 4 года назад

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

@eng.hafizhabibhabib1268 3 года назад

Thank you for this quick intro!

@NS-gr9cy 4 года назад

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

@sesshuswan Год назад

Amazing, this really helped me, thankyou!

@pertoor 3 года назад

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?

@zaccdwan8799 3 года назад

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

@nicolashurtadoarroyo1538 4 года назад

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

@HellfireTech Год назад

Simply Great....

@plutohopkin 3 года назад

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

@AsmikaHarnalinSimarmata 4 года назад

thank you. This presentation help me to understand Wind rose

@xdlmao7880 4 месяца назад

Pasti ngerjain tugas Pak Wahyudi tekla wkwkwkwk

@gokceertugrul6831 3 года назад

Thank you very much Karina its very helpful

@aybikebolat741 3 года назад

thank you Karina

@ckeil35 Год назад

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

@shubhamasatkar1297 3 года назад

wonderful explanation

@nagachandramoulit912 2 года назад

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

@a.fatihkuloglu2931 4 года назад

Thank you, it was really helpful.

@ElfengourAbdelhakGIS 5 лет назад

Thanks for making this video, very helpful

@rooseveltaghabueze7862 5 лет назад

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 5 лет назад

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.

@renealfonsografhernandez8741 2 года назад

Very useful thanks

@yellowchannel9284 Год назад

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

@syazaezzatibintibaidrulhis9913 Год назад

Why cannot group the wind speed?

@shantodas8184 Год назад

same problem. did you find any solution?

@YiBeiliang 6 лет назад

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

@kurapika6218 5 лет назад

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

@karinaadcock 5 лет назад

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

@brianfong5711 4 года назад

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.

@jonvassella1076 5 лет назад

Great help - thanks indeed

@syahirahnasuha5528 4 года назад

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

@ramitareq2942 6 лет назад

You are perfect thank you 👏

@youssefazergui9367 4 года назад

Awsome! Thank yous so much

@robertlawson4295 4 года назад

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 4 года назад

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.

@jackpagla2051 4 года назад

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

@schroedinger05 4 года назад

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

@ramitareq2942 6 лет назад

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

@karinaadcock 6 лет назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qPS-rylzKvE.html

@HydrographicSurveyor 6 лет назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fqKUZO_PVS8.html

@sayyyoo 4 года назад

thank you!! :))

@MurasakiCrow 6 лет назад

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

@karinaadcock 6 лет назад

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 6 лет назад

Thanks! Great tutorial!

@Freeedy 6 лет назад

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

@cytisha 5 лет назад

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

@karinaadcock 5 лет назад

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.

@haryotejo7231 5 лет назад

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

@haryotejo7231 5 лет назад

(blank) at 1:04

@karinaadcock 5 лет назад

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 5 лет назад

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