医学教育

订阅

MedSci主页 / 所有栏目 / 医学教育

Excel用于试验数据的整理2

2015-05-14 MedSci MedSci原创

Excel函数数据处理
关注

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

在应用Excel处理临床试验数据时常会出现数据错误，常见的几种错误类型是：数据缺失、数据误填和逻辑矛盾。本文就异常数据和缺失数据的识别和填充问题，给大家简单讲述如何用Excel整理实验临床研究数据。

以下是一组患者的年龄数据：

 

很容易看出表中出现的错误：逻辑矛盾、数据缺失、数据误填。

对于这种错误如何实现自动识别，Excel表中是利用检验算法计算并标记异常值。

Step 1: 制定检验策略

• 出生年月中的数据应为有效的年份和月份（月份仅可取1-12，年份可以根据数据本身的属性予以限定）
• 填入的年龄和通过出生年月计算得到的值应相等
• 不应有空白单元格

Step 2: 通过条件格式计算和标记

① 首先简单判断一下出生年月列数据的属性
② 选中数据，查看菜单中的对其方式按钮是否有高亮的
③ 如有高亮的，按一下带有高亮的按钮取消高亮
④ 格式取消后，右对齐的为数值或日期型的数据，左对齐的为文本型的

 

利用条件格式标记非数字单元格的格式

 










=INT((TODAY()-B2)/365)<>C2

 

Step 3: 通过IF函数来填充异常值



 =IF(C2="",INT((TODAY()-B2)/365),"")

更多内容请登陆MedSci临床研究学院（edu.medsci.cn），观看相关课程。同时也欢迎下载MedSci医学APP，大量医学工具随时调用。

版权声明：
本网站所有内容来源注明为“梅斯医学”或“MedSci原创”的文字、图片和音视频资料，版权均属于梅斯医学所有。非经授权，任何媒体、网站或个人不得转载，授权转载时须注明来源为“梅斯医学”。其它来源的文章系转载文章，或“梅斯号”自媒体发布的文章，仅系出于传递更多信息之目的，本站仅负责审核内容合规，其内容不代表本站立场，本站不负责内容的准确性和版权。如果存在侵权、或不希望被转载的媒体或个人可与我们联系，我们将立即进行删除处理。
在此留言
评论区 (10)
#插入话题
  1. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2016-03-26 fzwish20000

    #Excel#

    0

  2. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-08-03 pine007

    建议多些免费学习内容

    0

  3. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-06-25 fatalmelanie

    有用

    0

  4. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-11-11 维他命

    #CEL#

    0

  5. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-10-07 ms24272190615788285182

    #试验数据#

    0

  6. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-05-18 yydlt

    多讲讲！

    0

  7. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-05-17 huaxipanxing

    看看

    0

  8. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-05-17 hbwang006

    实用

    0

  9. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-05-15 JinFish

    赞，收藏

    0

  10. [GetPortalCommentsPageByObjectIdResponse(id=1971021, encodeId=630a19e102192, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=33, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=7146, encryptionId=7787e1463b, topicName=Excel)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=bcaa382, createdName=fzwish20000, createdTime=Sat Mar 26 04:28:00 CST 2016, time=2016-03-26, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=34092, encodeId=218d34092ae, content=建议多些免费学习内容, beContent=null, objectType=article, channel=null, level=null, likeNumber=65, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=4b531630898, createdName=pine007, createdTime=Mon Aug 03 09:13:00 CST 2015, time=2015-08-03, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=29029, encodeId=4fa829029c7, content=有用, beContent=null, objectType=article, channel=null, level=null, likeNumber=163, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=2be01625436, createdName=fatalmelanie, createdTime=Thu Jun 25 16:50:00 CST 2015, time=2015-06-25, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959367, encodeId=4e6d195936e59, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=32, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Wed Nov 11 08:28:00 CST 2015, time=2015-11-11, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055231, encodeId=59222055231ad, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=35, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=91774, encryptionId=6f9391e7414, topicName=试验数据)], attachment=null, authenticateStatus=null, createdAvatar=https://thirdqq.qlogo.cn/qqapp/1103841572/656F31B644588474D1C46903A7F84373/100, createdBy=4e842500199, createdName=ms24272190615788285182, createdTime=Wed Oct 07 22:28:00 CST 2015, time=2015-10-07, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24001, encodeId=de8a2400162, content=多讲讲！, beContent=null, objectType=article, channel=null, level=null, likeNumber=95, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=yydlt, createdTime=Mon May 18 07:51:00 CST 2015, time=2015-05-18, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23907, encodeId=c7752390e05, content=看看, beContent=null, objectType=article, channel=null, level=null, likeNumber=103, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=ee0d1618732, createdName=huaxipanxing, createdTime=Sun May 17 20:02:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23833, encodeId=450e2383395, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=102, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Sun May 17 16:28:00 CST 2015, time=2015-05-17, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23569, encodeId=a75c2356914, content=赞，收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=92, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=36b41624922, createdName=JinFish, createdTime=Fri May 15 07:31:00 CST 2015, time=2015-05-15, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=23544, encodeId=098323544a4, content=很实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=73, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=hbwang006, createdTime=Thu May 14 23:00:00 CST 2015, time=2015-05-14, status=1, ipAttribution=)]
    2015-05-14 hbwang006

    很实用

    0

以上为热门评论，梅斯医学App还有更多内容

相关资讯

Excel异常数据和缺失数据的识别和填充

Excel异常数据和缺失数据的识别和填充

Excel对连续变量进行等级化处理

Excel对连续变量进行等级化处理

Excel用于试验数据的整理

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

Excel表公式大全

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

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

如何使用excel实现完全随机化？

样本要想能代表总体，一个重要的原则就是随机化，通过随机抽样，就可以实现样本的较好的代表性。唯一需要注意的是随机不等于随便。比如，要从班里的50人中 选择20人测量身高，如何选择？这就关系到随机的问题。当然有一些类似于抓阄等方法，但是如果不是以班作为总体，而是以学校为总体，想知道整个学校的学生 的身高。那抓阄等手工方法就麻烦了。完全随机设计是最常用的设计方案，为了避免临床医生将随机等同于随意，我