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...
Autores principales: | , , , , , , |
---|---|
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 |