医学教育

订阅

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

Excel用于试验数据的整理3

2015-05-19 MedSci MedSci原创

Excel函数数据处理
关注

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

为了避免原始数据的录入错误，双人输入并校对不一致的值是一种有效且常用的录入方法。如何快速筛选出双人输入结果中不一致的部分是该方法实施中很重要的环节。本节利用数据有效性功能提高数据录入过程的正确性。

案例：有300例受试者，需输入纸质化验单上的受试者编号、性别、RBC计数和WBC计数的数据。

 

数据录入时可能发生的错误：记录缺失、记录重复、记录中具体的值错误输入。

Skill 1: 利用数据有效性在数据输入时把关

已知：

1. 受试者编号为13位的编码；
2. 性别取值仅可以为1或2；
3. RBC计数正常值假设为3.2-5.5（不论性别），且绝大多数人的计数值在2.5-6.0；
4. RBC计数正常值假设为4.0-10.0，且绝大多数人的计数值在2.0-14.0。

其中第1-2条不符合可直接判定数据输入错误，3-4条不符合可判定为疑似数据要求确认。

设置输入模板的“数据有效性”（文本长度）




  
效果图
 


设置输入模板的“数据有效性”（取值区间）
 


效果图

 
Skill 2: 利用删除重复项制作两个数据集的并集
  

合并受试者编号，利用删除重复项功能得到唯一记录的并集
 




Skill 3: 利用COUNTIF函数判断每一份录入的记录是否包含于并集中

=COUNTIF(A:A,G1)
 



在原数据集中筛选出COUNTIF值>=2所对应的记录，核对是否确为重复记录，并只保留一条记录；

比较两个数据集中COUNTIF值为0所对应的记录，核对是由于某一份数据的编号输入错误引起的（另一份数据中有相似的编号且其他值相等）还是由于遗漏引起的，并在原始记录中找到相应材料，按原始材料修正。
  

 

 
Skill 4: 利用删除重复项合并一致的数据，留下不一致的数据待查

经上一步整理，受试者编号完全一致后的数据

 

 

粘贴到一个工作表中，按受试者编号排序（非必须，方便后续核对），删除重复项。

 
 

查找未能成功合并的数据，并核对原始数据
 


 

利用数据有效性在数据输入时要在源头杜绝明显错误的输入，利用删除重复项制作两个数据集的并集用于比对患者号。两个数据集的比较可以选用COUNTIF函数。

学习更多内容请登陆MedSci临床研究学院（edu.medsci.cn），观看相关视频课程。同时也欢迎您下载MedSci资讯新版APP，专业更全面。

版权声明：
本网站所有内容来源注明为“梅斯医学”或“MedSci原创”的文字、图片和音视频资料，版权均属于梅斯医学所有。非经授权，任何媒体、网站或个人不得转载，授权转载时须注明来源为“梅斯医学”。其它来源的文章系转载文章，或“梅斯号”自媒体发布的文章，仅系出于传递更多信息之目的，本站仅负责审核内容合规，其内容不代表本站立场，本站不负责内容的准确性和版权。如果存在侵权、或不希望被转载的媒体或个人可与我们联系，我们将立即进行删除处理。
在此留言
评论区 (10)
#插入话题
  1. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2016-04-16 fzwish20000

    #Excel#

    0

  2. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-12-27 维他命

    #CEL#

    0

  3. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-06-23 ms24272190615788285182

    #试验数据#

    0

  4. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-05-24 jasonuclear

    收藏

    0

  5. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-05-20 chenhui888

    果然只用了百分之二

    0

  6. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-05-20 小门

    实用

    0

  7. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-05-19 Dr.LV

    太有用了

    0

  8. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-05-19 zhouanxiu

    实用

    0

  9. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-05-19 MedSci客户端网友

    实用，果断收藏

    0

  10. [GetPortalCommentsPageByObjectIdResponse(id=1971022, encodeId=79c119e1022b3, content=<a href='/topic/show?id=7787e1463b' target=_blank style='color:#2F92EE;'>#Excel#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=31, 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 Apr 16 16:18:00 CST 2016, time=2016-04-16, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=1959372, encodeId=4be119593e252, content=<a href='/topic/show?id=dbe6445416' target=_blank style='color:#2F92EE;'>#CEL#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=27, replyNumber=0, topicName=null, topicId=null, topicList=[TopicDto(id=4454, encryptionId=dbe6445416, topicName=CEL)], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=c3ff68, createdName=维他命, createdTime=Sun Dec 27 01:18:00 CST 2015, time=2015-12-27, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=2055232, encodeId=f38320552324b, content=<a href='/topic/show?id=6f9391e7414' target=_blank style='color:#2F92EE;'>#试验数据#</a>, beContent=null, objectType=article, channel=null, level=null, likeNumber=26, 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=Tue Jun 23 20:18:00 CST 2015, time=2015-06-23, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24634, encodeId=d1ec246342b, content=收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=107, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://cacheapi.medsci.cn/resource/upload/20160515/IMG57380B859AD1F1019.jpg, createdBy=2c5c1621956, createdName=jasonuclear, createdTime=Sun May 24 00:29:00 CST 2015, time=2015-05-24, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24173, encodeId=29d1241e3db, content=果然只用了百分之二, beContent=null, objectType=article, channel=null, level=null, likeNumber=93, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=121e1622385, createdName=chenhui888, createdTime=Wed May 20 08:02:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24158, encodeId=59812415859, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=75, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=00351625502, createdName=小门, createdTime=Wed May 20 00:31:00 CST 2015, time=2015-05-20, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24137, encodeId=607d2413e7f, content=太有用了, beContent=null, objectType=article, channel=null, level=null, likeNumber=71, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=http://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJUNfdk68bHutYruGyxbKDzPWH3agcmId19Yf94FiapyicN0LTg0jykhqIhjPQVdR08FGR399rBpZIg/132, createdBy=feae1624323, createdName=Dr.LV, createdTime=Tue May 19 16:59:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24133, encodeId=68b62413352, content=实用, beContent=null, objectType=article, channel=null, level=null, likeNumber=121, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=https://wx.qlogo.cn/mmopen/mONcle9pic3yz0JbjHQ7nicJU7lHMOu0Itf3Zv3VBzEvK3k4AFPBXhiaxIRNGVI33GicoRXQEjkaasjdlWKwZuwcyhDP9Jibqt5ct/0, createdBy=f1281613275, createdName=zhouanxiu, createdTime=Tue May 19 15:22:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24125, encodeId=ec5324125e3, content=实用，果断收藏, beContent=null, objectType=article, channel=null, level=null, likeNumber=68, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=null, createdBy=f0620, createdName=MedSci客户端网友, createdTime=Tue May 19 14:09:00 CST 2015, time=2015-05-19, status=1, ipAttribution=), GetPortalCommentsPageByObjectIdResponse(id=24124, encodeId=449724124c4, content=good, beContent=null, objectType=article, channel=null, level=null, likeNumber=47, replyNumber=0, topicName=null, topicId=null, topicList=[], attachment=null, authenticateStatus=null, createdAvatar=, createdBy=b64e106775, createdName=cement123, createdTime=Tue May 19 13:44:00 CST 2015, time=2015-05-19, status=1, ipAttribution=)]
    2015-05-19 cement123

    good

    0

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

相关资讯

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

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

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

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

Excel用于试验数据的整理

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

Excel用于试验数据的整理2

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

Excel表公式大全

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

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