请选择 进入手机版 | 继续访问电脑版
爱气象,爱气象家园! 

气象家园

 找回密码
 立即注册

QQ登录

只需一步,快速开始

新浪微博登陆

只需一步, 快速开始

搜索
查看: 17996|回复: 17

excel 最简单画风向玫瑰 详细步骤

[复制链接]

新浪微博达人勋

发表于 2016-7-23 09:59:19 | 显示全部楼层 |阅读模式

登录后查看更多精彩内容~

您需要 登录 才可以下载或查看,没有帐号?立即注册 新浪微博登陆

x
一、首先找到你想要画的时间段的风向数据,我是用十分钟平均的,每天有24个数据。一个月的数据=24*31(/30/29/28)。
二,然后计算出每个风向的频率,要先把度数换算成风向,换算表如下,下面给出公式。A2:AE25是数据范围

QQ图片20160723094722.png
N     =(COUNTIF(A2:AE25,">=0")-COUNTIF(A2:AE25,">=11.26")+COUNTIF(A2:AE25,">=348.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
NNE  =(COUNTIF(A2:AE25,">=11.26")-COUNTIF(A2:AE25,">=33.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
NE  =(COUNTIF(A2:AE25,">=33.76")-COUNTIF(A2:AE25,">=56.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
ENE  =(COUNTIF(A2:AE25,">=56.26")-COUNTIF(A2:AE25,">=78.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
E =(COUNTIF(A2:AE25,">=78.76")-COUNTIF(A2:AE25,">=101.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
ESE =(COUNTIF(A2:AE25,">=101.26")-COUNTIF(A2:AE25,">=123.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
SE =(COUNTIF(A2:AE25,">=123.76")-COUNTIF(A2:AE25,">=146.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
SSE =(COUNTIF(A2:AE25,">=146.26")-COUNTIF(A2:AE25,">=168.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
S =(COUNTIF(A2:AE25,">=168.76")-COUNTIF(A2:AE25,">=191.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
SSW =(COUNTIF(A2:AE25,">=191.26")-COUNTIF(A2:AE25,">=213.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
SW =(COUNTIF(A2:AE25,">=213.76")-COUNTIF(A2:AE25,">=236.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
WSW =(COUNTIF(A2:AE25,">=236.26")-COUNTIF(A2:AE25,">=258.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
W =(COUNTIF(A2:AE25,">=258.76")-COUNTIF(A2:AE25,">=281.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
WNW =(COUNTIF(A2:AE25,">=281.26")-COUNTIF(A2:AE25,">=303.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
NW =(COUNTIF(A2:AE25,">=303.76")-COUNTIF(A2:AE25,">=326.26"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
NNW =(COUNTIF(A2:AE25,">=326.26")-COUNTIF(A2:AE25,">=348.76"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
C =(COUNTIF(A2:AE25,"静风"))/(COUNT(A2:AE25)+COUNTIF(A2:AE25,"静风"))
就得到了各个风向对应的频率了,然后
三、选择这两列数据,插入图表,就能得到了风向玫瑰图啦,是不是这是最简单的方法
N0.038978495
NNE0.248655914
NE0.376344086
ENE0.142473118
E0.047043011
ESE0.021505376
SE0.009408602
SSE0.016129032
S0.016129032
SSW0.00672043
SW0.00672043
WSW0.004032258
W0.010752688
WNW0.017473118
NW0.01344086
NNW0.021505376
C0.002688172

QQ图片20160723095952.png















密码修改失败请联系微信:mofangbao

新浪微博达人勋

发表于 2016-7-29 17:23:08 | 显示全部楼层
呵呵,还不错,楼主辛苦了
密码修改失败请联系微信:mofangbao
回复 支持 1 反对 0

使用道具 举报

新浪微博达人勋

发表于 2016-7-23 16:23:51 | 显示全部楼层
赞!简单实用
密码修改失败请联系微信:mofangbao

新浪微博达人勋

发表于 2016-7-23 22:18:43 | 显示全部楼层
赞赞赞~\(≧▽≦)/~
谢谢楼主分享
密码修改失败请联系微信:mofangbao

新浪微博达人勋

发表于 2016-7-28 10:04:36 | 显示全部楼层
很实用啊!!!!!!
密码修改失败请联系微信:mofangbao
回复

使用道具 举报

新浪微博达人勋

发表于 2016-7-28 10:13:37 | 显示全部楼层
谢楼主分享啊~~
密码修改失败请联系微信:mofangbao

新浪微博达人勋

发表于 2016-7-28 15:02:39 | 显示全部楼层
很实用,感谢楼主分享
密码修改失败请联系微信:mofangbao

新浪微博达人勋

发表于 2016-7-29 14:02:27 | 显示全部楼层
很实用,感谢楼主分享
密码修改失败请联系微信:mofangbao

新浪微博达人勋

发表于 2016-8-15 14:56:29 | 显示全部楼层
谢谢分享
密码修改失败请联系微信:mofangbao
回复

使用道具 举报

新浪微博达人勋

发表于 2017-5-20 16:32:58 | 显示全部楼层
666666666666666
密码修改失败请联系微信:mofangbao
您需要登录后才可以回帖 登录 | 立即注册 新浪微博登陆

本版积分规则

Copyright ©2011-2014 bbs.06climate.com All Rights Reserved.  Powered by Discuz! (京ICP-10201084)

本站信息均由会员发表,不代表气象家园立场,禁止在本站发表与国家法律相抵触言论

快速回复 返回顶部 返回列表