Implementation of Network Meta-Analysis in Microsoft Excel by Calling BUGS Using BugsXLA Macro_Chinese Journal of Evidence-Based Medicine

Authors：

 ZENGXian-tao ^1,2 , ZHANGChao ¹ ,  DULiang ³

1. Center for Evidence-Based Medicine and Clinical Research, Taihe Hospital, Hubei University of Medicine, Shiyan 442000, China;
2. Department of Stomatology, Taihe Hospital, Hubei University of Medicine, Shiyan 442000, China;
3. Chinese Evidence-Based Medicine Center, West China Hospital, Sichuan University, Chengdu 610041, China;

Corresponding author：

DULiang, Email: duliangvip@sohu.com

Keywords：

Microsoft excel; BugsXLA; BUGS software; Network meta-analysis

DOI：

10.7507/1672-2531.20140128

Video：

Export PDF Favorites Scan Get Citation

Abstract Full text Figures/Tables Video References Cited by

BugsXLA is a Microsoft Excel add-in that facilitates Bayesian analysis of GLMMs and other complex model types by providing an easy to use interface for the BUGS package. BugsXLA macro is of good compatibility, ease to operation, smoothly running, low memory cost, and ease for data entry, extraction, and storage compared with other software which can calling BUGS to perform network meta-analysis currently. BugsXLA macro also integrates data storage and calculation. However, its function of plot drawing is very simple and only draws the density plot nowadays; Moreover, the function for calling WinBUGS is mature while is premature for calling OpenBUGS.

Citation： ZENGXian-tao, ZHANGChao, DULiang. Implementation of Network Meta-Analysis in Microsoft Excel by Calling BUGS Using BugsXLA Macro. Chinese Journal of Evidence-Based Medicine, 2014, 14(6): 765-771. doi: 10.7507/1672-2531.20140128 Copy

1.	曾宪涛, 孙竹, 汤红明. Meta分析系列之十:合格标准的制定.中国循证心血管医学杂志, 2013, 5(2):101-103.
2.	王萍, 谢蟪旭, 张绮, 等.如何在Cochrane系统评价中设计资料提取表.中国循证医学杂志, 2011, 11(3):341-345.
3.	曾宪涛, 冷卫东, 郭毅, 等. Meta分析系列之一:Meta分析的类型.中国循证心血管医学杂志, 2012, 4(1):3-5.
4.	曾宪涛, 曹世义, 孙凤, 等. Meta分析系列之六:间接比较及网状Meta分析.中国循证心血管医学杂志, 2012, 4(5):399-402.
5.	Lumley T. Network meta-analysis for indirect treatment comparisons. Stat Med, 2002, 21(16):2313-2324.
6.	Bafeta A, Trinquart L, Seror R, et al. Analysis of the systematic reviews process in reports of network meta-analyses:methodological systematic review. BMJ, 2013, 347:f3675.
7.	Greco T, Landoni G, Biondi-Zoccai G, et al. A Bayesian network meta-analysis for binary outcome:how to do it. Stat Methods Med Res, 2013, doi:10.1177/0962280213500185.
8.	曾宪涛, 张超, 郭毅. R软件R2WinBUGS程序包在网状Meta分析中的应用.中国循证医学杂志, 2013, 13(9):1137-1144.
9.	张超, 董圣杰, 曾宪涛. R软件gemtc程序包在网状Meta分析中的应用.中国循证医学杂志, 2013, 13(10):1258-1264.
10.	曾宪涛, 徐畅, 张超, 等.网状Meta分析在Stata软件中的实现.中国循证医学杂志, 2013, 13(11):1387-1391.
11.	罗杰, 张超, 曾宪涛. R软件调用OpenBUGS软件实现网状Meta分析.中国循证医学杂志, 2014, 14(4):492-496.
12.	曾宪涛, 张超, 杜亮.应用ADDIS软件实现网状Meta分析.中国循证医学杂志, 2013, 13(12):1508-1515.
13.	张超, 牛玉明, 曾宪涛. R软件nlme程序包在网状Meta分析中的应用.中国循证医学杂志, 2014, 14(3):355-360.
14.	张超, 孙凤, 曾宪涛. R调用JAGS软件实现网状Meta分析.中国循证医学杂志, 2014, 14(2):241-248.
15.	Woodward P. BugsXLA. Bayes for the Common Man. J Stat Softw, 2005, 14(5):1-18.
16.	Woodward P. Bayesian Analysis Made Simple:An Excel GUI for WinBUGS. Chapman & Hall/CRC Biostatistics Series, 2011.
17.	张超, 徐畅, 曾宪涛.网状Meta分析中网状关系图的绘制.中国循证医学杂志, 2013, 13(11):1382-1386.

1. 曾宪涛, 孙竹, 汤红明. Meta分析系列之十:合格标准的制定.中国循证心血管医学杂志, 2013, 5(2):101-103.
2. 王萍, 谢蟪旭, 张绮, 等.如何在Cochrane系统评价中设计资料提取表.中国循证医学杂志, 2011, 11(3):341-345.
3. 曾宪涛, 冷卫东, 郭毅, 等. Meta分析系列之一:Meta分析的类型.中国循证心血管医学杂志, 2012, 4(1):3-5.
4. 曾宪涛, 曹世义, 孙凤, 等. Meta分析系列之六:间接比较及网状Meta分析.中国循证心血管医学杂志, 2012, 4(5):399-402.
5. Lumley T. Network meta-analysis for indirect treatment comparisons. Stat Med, 2002, 21(16):2313-2324.
6. Bafeta A, Trinquart L, Seror R, et al. Analysis of the systematic reviews process in reports of network meta-analyses:methodological systematic review. BMJ, 2013, 347:f3675.
7. Greco T, Landoni G, Biondi-Zoccai G, et al. A Bayesian network meta-analysis for binary outcome:how to do it. Stat Methods Med Res, 2013, doi:10.1177/0962280213500185.
8. 曾宪涛, 张超, 郭毅. R软件R2WinBUGS程序包在网状Meta分析中的应用.中国循证医学杂志, 2013, 13(9):1137-1144.
9. 张超, 董圣杰, 曾宪涛. R软件gemtc程序包在网状Meta分析中的应用.中国循证医学杂志, 2013, 13(10):1258-1264.
10. 曾宪涛, 徐畅, 张超, 等.网状Meta分析在Stata软件中的实现.中国循证医学杂志, 2013, 13(11):1387-1391.
11. 罗杰, 张超, 曾宪涛. R软件调用OpenBUGS软件实现网状Meta分析.中国循证医学杂志, 2014, 14(4):492-496.
12. 曾宪涛, 张超, 杜亮.应用ADDIS软件实现网状Meta分析.中国循证医学杂志, 2013, 13(12):1508-1515.
13. 张超, 牛玉明, 曾宪涛. R软件nlme程序包在网状Meta分析中的应用.中国循证医学杂志, 2014, 14(3):355-360.
14. 张超, 孙凤, 曾宪涛. R调用JAGS软件实现网状Meta分析.中国循证医学杂志, 2014, 14(2):241-248.
15. Woodward P. BugsXLA. Bayes for the Common Man. J Stat Softw, 2005, 14(5):1-18.
16. Woodward P. Bayesian Analysis Made Simple:An Excel GUI for WinBUGS. Chapman & Hall/CRC Biostatistics Series, 2011.
17. 张超, 徐畅, 曾宪涛.网状Meta分析中网状关系图的绘制.中国循证医学杂志, 2013, 13(11):1382-1386.

Chinese Journal of Evidence-Based Medicine

Implementation of Network Meta-Analysis in Microsoft Excel by Calling BUGS Using BugsXLA Macro

Abstract Full text Figures/Tables Video References Cited by

Previous Article

Next Article

Format

Content