Baidu
map

Excel用于试验数据的整理2

2015-05-14 MedSci MedSci原创

在应用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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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
  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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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 维他命
  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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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=)]
  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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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=64, 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=96, 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=180, 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=54, 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=62, 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=112, 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=122, 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=136, 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=118, 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=89, 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

相关资讯

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

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

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

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

Excel用于试验数据的整理

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

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

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

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

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

Baidu
map
Baidu
map
Baidu
map