Baidu
map

手把手教你用Excel画动态心形图形(动态图)

2015-10-07 sky 36大数据

效果图如下   36大数据专稿,本文由36大数据-sky原创,转载必须征询作者同意,并且标注来源36大数据。 温馨提示:由于动态图文件太大,打开可能会出现缓存慢的状态,请您耐心等待……如给你带来不便,我们深感抱歉。文章末尾附Excel源文件下载。  数学历来被认为是一门枯燥无味的学科,干瘪瘪的数据和公式,让大部分人都头昏眼花。然而,当数与图结合在一起的时

效果图如下36大数据

 

36大数据专稿,本文由36大数据-sky原创,转载必须征询作者同意,并且标注来源36大数据。
温馨提示:由于动态图文件太大,打开可能会出现缓存慢的状态,请您耐心等待……如给你带来不便,我们深感抱歉。文章末尾附Excel源文件下载。

 数学历来被认为是一门枯燥无味的学科,干瘪瘪的数据和公式,让大部分人都头昏眼花。然而,当数与图结合在一起的时候,我们便会发现数学也可以是很美的。

 

图是数的一种表现形式,图之所以会“动”,本质上在于数据的变化。很多数据分析人员在处理数据的时候都会遇到这样的问题,如何在同一个图中对不同部门不同月份的销售数据或者绩效数据进行对比呢?即在同一个图表中实现同一月份不同部门间的横向比较和同一部门不同月份间的纵向比较,要解决这个问题,就要用到动态图表,不能用常规的作图方法了。在这里,我们首先要解决的一个问题是,如何才能让数据“变”?对于资深的数据分析人员来说,方法有很多,可以借助Excel的函数和窗体控件、Access、SQL,或者编程实现等。但是对于刚入门的数据分析菜鸟或者一些行政人员,只会Excel和几个函数,又不懂编程,应该如何操作呢?今天,我们一起学习如何利用Excel制作简单的动态图,用到的工具主要是”滚动条”窗体控件,案例以蕴含浪漫爱情故事的心形线为主。

 

Excel版本2007,心形线的方程为

36大数据转化为参数方程为
36大数据
 首先, 先调出“滚动条”窗体控件:点击Excel的最左上角图标;选择右下角的“Excel选项”;选择“常用”,在“在功能区显示‘开发工具’选项卡”复选框打钩,按确定;单击“开发工具”选项卡,在“控件”组中单击“插入”,再单击“窗体控件”下的“滚动条”即可。
36大数据

点击放大可看动态图

然后, 设置数据。思路:把θ的所在区间平均分为200份,然后计算(nθ)/2,通过“滚动条”,控制“n”的变化,再通过参数方程分别计算x、y的值,最后通过“散点图”作出相应图形。

1、控制“n”值变化:
选择“滚动条”—> 点击右键,选择“设置控件格式”—>点击“控制”,“单元格链接”,选择“K1”单元格,点击“确定”即可。当我们点击“滚动条”的箭头是,就看到“K1”单元格的数字发生变化了。

 

图片
36大数据

点击放大可看动态图

2、把θ的所在区间平均分为200份:

在“A1”单元格输入“步长”,在“A2”单元格输入公式“=ROW(A1)-1”,选中“A2”单元格,当指针变成黑色十字时,往下拖至“A202”;在“B1”单元格输入“θ”,“B2”单元格输入“=-2*PI()+A2*0.02*PI()”,选中“B2”单元格,当指针变成黑色十字时,往下拖至“B202”。

 

36大数据3、计算 (nθ)/2、x和y:

 

在“C1“单元格输入”(nθ)/2“,”C2“单元格输入”=$K$1*B2/2“,选中“C2”单元格,当指针变成黑色十字时,往下拖至“C202”;

 

在”D1“单元格输入”x=cos (nθ/2)“,”D2“单元格输入”=COS(C2)“,选中“D2”单元格,当指针变成黑色十字时,往下拖至“D202”;

 

在”F1“单元格输入”y=sin(nθ/2) +(cos(nθ/2))^(2/3)“,”F2“单元格输入”=SIN(C2)+((COS(C2))^2)^(1/3)“,选中“F2”单元格,当指针变成黑色十字时,往下拖至“F202”。

 

此时,我们再点击”滚动条“的箭头,会发现”C、D、F“列的数据会随着”n“值的变化而发生变化。
36大数据

点击放大可看动态图

 
4、绘制散点图:
选中空白单元格,单击”插入“选项卡—>”图表”组,点击”散点图“,选择”仅带数据标记的散点图“,得到空白的散点图。
36大数据

点击放大可看动态图

 选择空白的散点图,菜单栏出现”图表工具“选项,点击”设计“—>点击”选择数据“—>点击”添加”—>”X轴系列值“选中区域”=心形线$D$2:$D$202“,”Y轴系列值“选中区域”=心形线!$F$2:$F$202“(工作表名为“心形线”)—>连续点击两次”确定“,得到散点图草图。
36大数据

点击放大可看动态图

最后,美化图表。

选中图表中的心形轨迹,点击右键,点击”设置数据系列格式“—>点击”数据标记选项“,选中”无“—>点击”线条颜色“,选择”实线“以及个人喜好颜色,点击”确定“。
36大数据

点击放大可看动态图

选中横坐标轴,点击右键,点击”设置坐标轴格式“—>点击”坐标轴选项“设置最小值、最大值和主要刻度单位—> 点击”线型“,选择”后端线型“,点击”确定“。同理设置纵坐标轴和网格线。
36大数据

点击放大可看动态图

选中图表,单击”布局“选项卡,分别设置”图表标题“、 ”坐标轴标题“。最终得到如图一所示动态图。
下面再给出星形线和玫瑰线的动态图,如下,可按照上述方法操作得到。除此之外,还可以通过If、Vlookup、Hlookup函数和列表框窗体控件等绘制简单动态图。
图二:

36大数据

图三:36大数据


版权声明:
本网站所有内容来源注明为“梅斯医学”或“MedSci原创”的文字、图片和音视频资料,版权均属于梅斯医学所有。非经授权,任何媒体、网站或个人不得转载,授权转载时须注明来源为“梅斯医学”。其它来源的文章系转载文章,或“梅斯号”自媒体发布的文章,仅系出于传递更多信息之目的,本站仅负责审核内容合规,其内容不代表本站立场,本站不负责内容的准确性和版权。如果存在侵权、或不希望被转载的媒体或个人可与我们联系,我们将立即进行删除处理。
在此留言
评论区 (10)
#插入话题
  1. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2016-06-25 智智灵药
  2. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
  3. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2015-10-31 byzl

    原来Excel还有这么个功能啊,长见识了。

    0

  4. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2015-10-28 wodexinxi

    不错,重要的是实践和时间

    0

  5. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2015-10-25 nizongzan

    无所不能呀

    0

  6. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2015-10-25 nizongzan

    神器

    0

  7. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2015-10-25 slicer

    有用

    0

  8. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2015-10-24 qingfeiyuyu

    神器

    0

  9. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2015-10-08 gingle

    智慧

    0

  10. [GetPortalCommentsPageByObjectIdResponse(id=1959478, encodeId=1f9619594e8f7, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=78, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=a12645, createdName=智智灵药, createdTime=Sat Jun 25 19:43:00 CST 2016, time=2016-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1971024, encodeId=13e719e102467, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Mon Nov 09 02:43:00 CST 2015, time=2015-11-09, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=42095, encodeId=fc0142095a8, content=原来Excel还有这么个功能啊,长见识了。, beContent=null, objectType=article, channel=null, level=null, likeNumber=189, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=de721636603, createdName=byzl, createdTime=Sat Oct 31 20:47:00 CST 2015, time=2015-10-31, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=41651, encodeId=567041651ed, content=不错,重要的是实践和时间, beContent=null, objectType=article, channel=null, level=null, likeNumber=152, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=191d1636362, createdName=wodexinxi, createdTime=Wed Oct 28 06:38:00 CST 2015, time=2015-10-28, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40879, encodeId=63fe408e9ca, content=无所不能呀, beContent=null, objectType=article, channel=null, level=null, likeNumber=133, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:11:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40878, encodeId=84f0408e823, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=157, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ded71629504, createdName=nizongzan, createdTime=Sun Oct 25 09:10:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40848, encodeId=82b440848a4, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=125, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=0ba41656652, createdName=slicer, createdTime=Sun Oct 25 08:04:00 CST 2015, time=2015-10-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=40532, encodeId=715a4053210, content=神器, beContent=null, objectType=article, channel=null, level=null, likeNumber=74, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=f8421645238, createdName=qingfeiyuyu, createdTime=Sat Oct 24 00:19:00 CST 2015, time=2015-10-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=38069, encodeId=724f3806910, content=智慧, beContent=null, objectType=article, channel=null, level=null, likeNumber=119, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=dbaa78949, createdName=gingle, createdTime=Thu Oct 08 06:24:00 CST 2015, time=2015-10-08, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=37848, encodeId=5f1b3e848f5, content=神奇, beContent=null, objectType=article, channel=null, level=null, likeNumber=127, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Wed Oct 07 19:51:00 CST 2015, time=2015-10-07, status=1, ipAttribution=)]
    2015-10-07 Dr.LV

    神奇

    0

相关资讯

Excel用于试验数据的整理3

为了避免原始数据的录入错误,双人输入并校对不一致的值是一种有效且常用的录入方法。如何快速筛选出双人输入结果中不一致的部分是该方法实施中很重要的环节。本节利用数据有效性功能提高数据录入过程的正确性。案例:有300例受试者,需输入纸质化验单上的受试者编号、性别、RBC计数和WBC计数的数据。 数据录入时可能发生的错误:记录缺失、记录重复、记录中具体的值错误输入。Skill 1: 利用数据有效

Excel用于试验数据的整理

Excel是常用的计算表软件,可以进行各种数据的处理、统计分析和辅助决策操作。Excel中有大量的公式函数可以应用选择。今天MedSci江编辑为大家带来Excel中常用函数用于试验数据处理。分别是VLOOKUP函数的模糊匹配、相对引用和绝对引用、MAX函数的使用。案例:采集到患者的血压为原始测量值,由于统计需要,将其转化为等级资料;分级标准:效果图: 利用VLOOKUP的模糊匹配功能实现

Excel用于试验数据的整理2

在应用Excel处理临床试验数据时常会出现数据错误,常见的几种错误类型是:数据缺失、数据误填和逻辑矛盾。本文就异常数据和缺失数据的识别和填充问题,给大家简单讲述如何用Excel整理实验临床研究数据。以下是一组患者的年龄数据: 很容易看出表中出现的错误:逻辑矛盾、数据缺失、数据误填。对于这种错误如何实现自动识别,Excel表中是利用检验算法计算并标记异常值。Step 1: 制定检验策略•&

excel技巧:中文转成拼音字母(包括首字母大写)

操作过程 方法1中的函数 普通输出:=chinese2spell(A2,1) //参数为1 首字母大写:=chinese2spell(A2,0) //参数为0 去除空格:=SUBSTITUTE(chinese2spell(A2,0)," ","") 1 Public Function Chinese2Spell(sChinese As String, Optional

在线课堂:MedSci 医学工具使用技巧系列课程

临床医学研究中,不乏各种数据及图像的处理,如何更快更优的处理数据是一门技巧,MedSci特推出医学工具使用技巧系列课程,主要讲述医学软件,以及常用软件使用技巧。包括excel软件,PPT,photoshop软件,以及一些统计作图软件,文献整理软件,基因和蛋白质分析软件的使用技巧,让科研更简单。 课程连接:http://edu.medsci.cn/course/serielist-1095209.

Baidu
map
Baidu
map
Baidu
map