Cargando…

A Microsoft-Excel-based tool for running and critically appraising network meta-analyses—an overview and application of NetMetaXL

BACKGROUND: The use of network meta-analysis has increased dramatically in recent years. WinBUGS, a freely available Bayesian software package, has been the most widely used software package to conduct network meta-analyses. However, the learning curve for WinBUGS can be daunting, especially for new...

Descripción completa

Detalles Bibliográficos
Autores principales: Brown, Stephen, Hutton, Brian, Clifford, Tammy, Coyle, Doug, Grima, Daniel, Wells, George, Cameron, Chris
Formato: Online Artículo Texto
Lenguaje:English
Publicado: BioMed Central 2014
Materias:
Acceso en línea:https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4195340/
https://www.ncbi.nlm.nih.gov/pubmed/25267416
http://dx.doi.org/10.1186/2046-4053-3-110
_version_ 1782339295763234816
author Brown, Stephen
Hutton, Brian
Clifford, Tammy
Coyle, Doug
Grima, Daniel
Wells, George
Cameron, Chris
author_facet Brown, Stephen
Hutton, Brian
Clifford, Tammy
Coyle, Doug
Grima, Daniel
Wells, George
Cameron, Chris
author_sort Brown, Stephen
collection PubMed
description BACKGROUND: The use of network meta-analysis has increased dramatically in recent years. WinBUGS, a freely available Bayesian software package, has been the most widely used software package to conduct network meta-analyses. However, the learning curve for WinBUGS can be daunting, especially for new users. Furthermore, critical appraisal of network meta-analyses conducted in WinBUGS can be challenging given its limited data manipulation capabilities and the fact that generation of graphical output from network meta-analyses often relies on different software packages than the analyses themselves. METHODS: We developed a freely available Microsoft-Excel-based tool called NetMetaXL, programmed in Visual Basic for Applications, which provides an interface for conducting a Bayesian network meta-analysis using WinBUGS from within Microsoft Excel. . This tool allows the user to easily prepare and enter data, set model assumptions, and run the network meta-analysis, with results being automatically displayed in an Excel spreadsheet. It also contains macros that use NetMetaXL’s interface to generate evidence network diagrams, forest plots, league tables of pairwise comparisons, probability plots (rankograms), and inconsistency plots within Microsoft Excel. All figures generated are publication quality, thereby increasing the efficiency of knowledge transfer and manuscript preparation. RESULTS: We demonstrate the application of NetMetaXL using data from a network meta-analysis published previously which compares combined resynchronization and implantable defibrillator therapy in left ventricular dysfunction. We replicate results from the previous publication while demonstrating result summaries generated by the software. CONCLUSIONS: Use of the freely available NetMetaXL successfully demonstrated its ability to make running network meta-analyses more accessible to novice WinBUGS users by allowing analyses to be conducted entirely within Microsoft Excel. NetMetaXL also allows for more efficient and transparent critical appraisal of network meta-analyses, enhanced standardization of reporting, and integration with health economic evaluations which are frequently Excel-based.
format Online
Article
Text
id pubmed-4195340
institution National Center for Biotechnology Information
language English
publishDate 2014
publisher BioMed Central
record_format MEDLINE/PubMed
spelling pubmed-41953402014-10-14 A Microsoft-Excel-based tool for running and critically appraising network meta-analyses—an overview and application of NetMetaXL Brown, Stephen Hutton, Brian Clifford, Tammy Coyle, Doug Grima, Daniel Wells, George Cameron, Chris Syst Rev Methodology BACKGROUND: The use of network meta-analysis has increased dramatically in recent years. WinBUGS, a freely available Bayesian software package, has been the most widely used software package to conduct network meta-analyses. However, the learning curve for WinBUGS can be daunting, especially for new users. Furthermore, critical appraisal of network meta-analyses conducted in WinBUGS can be challenging given its limited data manipulation capabilities and the fact that generation of graphical output from network meta-analyses often relies on different software packages than the analyses themselves. METHODS: We developed a freely available Microsoft-Excel-based tool called NetMetaXL, programmed in Visual Basic for Applications, which provides an interface for conducting a Bayesian network meta-analysis using WinBUGS from within Microsoft Excel. . This tool allows the user to easily prepare and enter data, set model assumptions, and run the network meta-analysis, with results being automatically displayed in an Excel spreadsheet. It also contains macros that use NetMetaXL’s interface to generate evidence network diagrams, forest plots, league tables of pairwise comparisons, probability plots (rankograms), and inconsistency plots within Microsoft Excel. All figures generated are publication quality, thereby increasing the efficiency of knowledge transfer and manuscript preparation. RESULTS: We demonstrate the application of NetMetaXL using data from a network meta-analysis published previously which compares combined resynchronization and implantable defibrillator therapy in left ventricular dysfunction. We replicate results from the previous publication while demonstrating result summaries generated by the software. CONCLUSIONS: Use of the freely available NetMetaXL successfully demonstrated its ability to make running network meta-analyses more accessible to novice WinBUGS users by allowing analyses to be conducted entirely within Microsoft Excel. NetMetaXL also allows for more efficient and transparent critical appraisal of network meta-analyses, enhanced standardization of reporting, and integration with health economic evaluations which are frequently Excel-based. BioMed Central 2014-09-29 /pmc/articles/PMC4195340/ /pubmed/25267416 http://dx.doi.org/10.1186/2046-4053-3-110 Text en Copyright © 2014 Brown et al.; licensee BioMed Central Ltd. http://creativecommons.org/licenses/by/4.0 This is an Open Access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly credited. The Creative Commons Public Domain Dedication waiver (http://creativecommons.org/publicdomain/zero/1.0/) applies to the data made available in this article, unless otherwise stated.
spellingShingle Methodology
Brown, Stephen
Hutton, Brian
Clifford, Tammy
Coyle, Doug
Grima, Daniel
Wells, George
Cameron, Chris
A Microsoft-Excel-based tool for running and critically appraising network meta-analyses—an overview and application of NetMetaXL
title A Microsoft-Excel-based tool for running and critically appraising network meta-analyses—an overview and application of NetMetaXL
title_full A Microsoft-Excel-based tool for running and critically appraising network meta-analyses—an overview and application of NetMetaXL
title_fullStr A Microsoft-Excel-based tool for running and critically appraising network meta-analyses—an overview and application of NetMetaXL
title_full_unstemmed A Microsoft-Excel-based tool for running and critically appraising network meta-analyses—an overview and application of NetMetaXL
title_short A Microsoft-Excel-based tool for running and critically appraising network meta-analyses—an overview and application of NetMetaXL
title_sort microsoft-excel-based tool for running and critically appraising network meta-analyses—an overview and application of netmetaxl
topic Methodology
url https://www.ncbi.nlm.nih.gov/pmc/articles/PMC4195340/
https://www.ncbi.nlm.nih.gov/pubmed/25267416
http://dx.doi.org/10.1186/2046-4053-3-110
work_keys_str_mv AT brownstephen amicrosoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT huttonbrian amicrosoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT cliffordtammy amicrosoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT coyledoug amicrosoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT grimadaniel amicrosoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT wellsgeorge amicrosoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT cameronchris amicrosoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT brownstephen microsoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT huttonbrian microsoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT cliffordtammy microsoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT coyledoug microsoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT grimadaniel microsoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT wellsgeorge microsoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl
AT cameronchris microsoftexcelbasedtoolforrunningandcriticallyappraisingnetworkmetaanalysesanoverviewandapplicationofnetmetaxl