A Microsoft Excel Approach to Reduce Errors and Increase Efficiency in Systematic Searching

References

• Briscoe, Simon. “A Review of the Reporting of Web Searching to Identify Studies for Cochrane Systematic Reviews.” Research Synthesis Methods 9, no. 1 (2018): 89–99. doi:10.1002/jrsm.1275
   PubMed Web of Science ®Google Scholar
• Koffel, Jonathan B. “Use of Recommended Search Strategies in Systematic Reviews and the Impact of Librarian Involvement: A Cross-Sectional Survey of Recent Authors.” PLoS One 10, no. 5 (2015): e0125931. doi:10.1371/journal.pone.0125931
   PubMed Web of Science ®Google Scholar
• Murphy, Susan A., and Catherine Boden. “Benchmarking Participation of Canadian University Health Sciences Librarians in Systematic Reviews.” Journal of the Medical Library Association 103, no. 2 (2015): 73–78. doi:10.3163/1536-5050.103.2.003
   PubMed Web of Science ®Google Scholar
• Institute of Medicine. Finding What Works in Health Care: Standards for Systematic Reviews. Washington, DC: The National Academies Press, 2011.
   Google Scholar
• Rethlefsen, Melissa L., Ann M. Farrell, Leah C. Osterhaus Trzasko, and Tara J. Brigham. “Librarian Co-Authors Correlated with Higher Quality Reported Search Strategies in General Internal Medicine Systematic Reviews.” Journal of Clinical Epidemiology 68, no. 6 (2015): 617–626. doi:10.1016/j.jclinepi.2014.11.025
   PubMed Web of Science ®Google Scholar
• Spencer, Angela J., and Jonathan D. Eldredge. “Roles for Librarians in Systematic Reviews: A Scoping Review.” Journal of the Medical Library Association 106, no. 1 (2018): 46–56. doi:10.5195/JMLA.2018.82
   PubMed Web of Science ®Google Scholar
• Gore, Genevieve C., and Julie Jones. “Systematic Reviews and Librarians: A Primer for Managers.” Partnership: The Canadian Journal of Library and Information Practice and Research 10, no. 1 (2015): 16. doi:10.21083/partnership.v10i1.3343
   Google Scholar
• Bullers, Krystal, Allison M. Howard, Ardis Hanson, William D. Kearns, John J. Orriola, Randall L. Polo, and Kristen A. Sakmar. “It Takes Longer than You Think: Librarian Time Spent on Systematic Review Tasks.” Journal of the Medical Library Association 106, no. 2 (2018): 198–207. doi:10.5195/JMLA.2018.323
   PubMed Web of Science ®Google Scholar
• Foster, Margaret J. “PIECES Workbook: A Guide to Developing, Conducting, & Reporting Reviews.” (October 2015). Accessed December 5, 2019. https://tinyurl.com/fosterpiecesworkbook.
   Google Scholar
• O’Connor, Annette M., Guy Tsafnat, Stephen B. Gilbert, Kristina A. Thayer, Ian Shemilt, James Thomas, Paul Glasziou, and Mary S. Wolfe. “Still Moving toward Automation of the Systematic Review Process: A Summary of Discussions at the Third Meeting of the International Collaboration for Automation of Systematic Reviews (ICASR).” Systematic Reviews 8, no. 1 (2019): 57. doi:10.1186/s13643-019-0975-y
   PubMed Web of Science ®Google Scholar
• Van der Mierden, Stevie, Tsaioun Katya, André Bleich Cathalijn, and H. C. Leenaars. “Software Tools for Literature Screening in Systematic Reviews in Biomedical Research.” Altex 36, no. 3 (2019): 508–517. doi:10.14573/altex.1902131
   PubMedGoogle Scholar
• Koster, Jan. “PubMed PubReMiner.” (2014). Accessed December 5, 2019. https://hgserver2.amc.nl/cgi-bin/miner/miner2.cgi.
   Google Scholar
• Cushing/Whitney Medical Library. Yale University. “Yale MeSH Analyzer.” (2019). Accessed December 5, 2019. http://mesh.med.yale.edu/.
   Google Scholar
• Stansfield, Claire, Alison O’Mara-Eves, and James Thomas. “Text Mining for Search Term Development in Systematic Reviewing: A Discussion of Some Methods and Challenges.” Research Synthesis Methods 8, no. 3 (2017): 355–365. doi:10.1002/jrsm.1250
   PubMed Web of Science ®Google Scholar
• Smalheiser, Neil R., Can Lin, Lifeng Jia, Yu Jiang, Aaron M. Cohen, Clement Yu, John M. Davis, Clive E. Adams, Marian S. McDonagh, and Weiyi Meng. “Design and Implementation of Metta, a Metasearch Engine for Biomedical Literature Retrieval Intended for Systematic Reviewers.” Health Information Science and Systems 2, no. 1 (2014): 1. doi:10.1186/2047-2501-2-1
   PubMedGoogle Scholar
• Bond University Institute for Evidence-Based Healthcare, “The Systematic Review Accelerator.” n.d. Accessed December 5, 2019. sr-accelerator.com.
   Google Scholar
• Clark, Justin, Matt Carter, David Honeyman, Gina Cleo, Yvonne Auld, D. Booth, P. Condron, C. Dalais, S. Dern, B. Linthwaite. “The Polyglot Search Translator (PST): Evaluation of a Tool for Improving Searching in Systematic Reviews: A Randomised Cross-over Trial.” The 25th Cochrane Colloquium, Edinburgh, United Kingdom, 2018. Accessed December 5, 2019. https://abstracts.cochrane.org/2018-edinburgh/polyglot-search-translator-pst-evaluation-tool-improving-searching-systematic-reviews
   Google Scholar
• Bramer, Wichor M., Gerdien B. de Jonge, Melissa L. Rethlefsen, Frans Mast, and Jos Kleijnen. “A Systematic Approach to Searching: An Efficient and Complete Method to Develop Literature Searches.” Journal of the Medical Library Association 106, no. 4 (2018): 531–541. doi:10.5195/JMLA.2018.283
   PubMed Web of Science ®Google Scholar
• Bramer, Wichor M., Melissa L. Rethlefsen, Frans Mast, and Jos Kleijnen. “Evaluation of a New Method for Librarian-Mediated Literature Searches for Systematic Reviews.” Research Synthesis Methods 9, no. 4 (2018): 510–520. doi:10.1002/jrsm.1279
   PubMed Web of Science ®Google Scholar
• Sampson, Margaret, and Jessie McGowan. “Errors in Search Strategies Were Identified by Type and Frequency.” Journal of Clinical Epidemiology 59, no. 10 (2006): 1057. e1–1057. e9. doi:10.1016/j.jclinepi.2006.01.007
   Web of Science ®Google Scholar
• Franco, Juan V. A., Virginia Garrote, Camila Micaela, Escobar Liquitay, and Valeria Vietto. “Identification of Problems in Search Strategies in Cochrane Reviews.” Research Synthesis Methods 9, no. 3 (2018): 408–416. doi:10.1002/jrsm.1302
   PubMed Web of Science ®Google Scholar
• Salvador-Oliván, José Antonio, Gonzalo Marco-Cuenca, and Rosario Arquero-Avilés. “Errors in Search Strategies Used in Systematic Reviews and Their Effects on Information Retrieval.” Journal of the Medical Library Association 107, no. 2 (2019): 210–221. doi:10.5195/jmla.2019.567
   PubMed Web of Science ®Google Scholar
• Microsoft. “TEXTJOIN Function.” 2016. https://web.archive.org/web/20160915021304/https://support.office.com/en-us/article/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c.
   Google Scholar
• Microsoft. “TEXTJOIN Function.” 2019. https://support.office.com/en-us/article/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c.
   Google Scholar