Quick interface for screening studies in Excel | Spreadsheet Synthesis

Подписаться 3,2 тыс.

Просмотров 6 тыс.

50% 1

A common task in research synthesis projects, like meta-analysis or systematic reviews, is the screening of individual studies for inclusion.
00:00:00 Here I show you how to quickly generate a screening interface with inclusion/exclusion buttons to facilitate the rapid screening of multiple studies:
00:02:38 setting up bibliographic data and spreadsheet for displaying titles/abstracts
00:09:58 adding “include” and “exclude” buttons
00:12:30 adding Visual Basic script to activate buttons to iterate studies and record screening decision
00:18:08 testing the screener on the bibliographic data
#excel
#screeners
#meta-analysis
#LajeunesseLab
cite this video (follow figshare link for dataset):
Lajeunesse, M.J. (2021): Screening studies with Microsoft Excel for systematic reviews and meta-analysis. figshare. Online resource. DOI: 10.6084/m9.figshare.14179655

Наука

Опубликовано:

14 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@kaydengill8733 2 года назад

Is there a way to add a back button for if reviewers make mistakes?

@LajeunesseLab 2 года назад

yes, follow the directions to create a button, but this time the Visual Basic code for this "backtrack" button becomes (assuming that the spreadsheet index is like in the video found in the BL2 cell): i = Range("BL2").Value Range("BL2").Value = i - 1

@LajeunesseLab 3 года назад

Hi all, thanks for watching! I have more tutorials using Excel for meta-analysis and systematic review practices, the full list is found here: @t

@nicorogervonlohengramm 2 месяца назад

Thank you so much sir 😊

@alicewautie9576 Год назад

Hi from Belgium! Very helpfull, thanks for sharing !

@muhammadrana5072 Год назад

Excellent sir, really learned a lot

@rehamsalam5277 2 года назад

I wish I had Excel skills so i understand the functions you used and so apply your method..But, I will try to copy your steps right now!

@albertocaruso9575 Год назад

thank you!

@yasmiiineee Год назад

thank you so much ! very helpful !

@LajeunesseLab Год назад

Glad it helped!

@ErickKipropRonoh 10 месяцев назад

Do you have a template? Thanks for the uploads!

@lachlanwood580 2 года назад

Great video, but i couldn't get it working on my MAC, there was no control section on developer

@xriso1437 3 года назад

This video is absotely helpful! I would like to ask if it is possible to add a colour, for ex. green for "included" and red for "excluded" studies, because in that way i think it can facilitate the identification process.

@LajeunesseLab 3 года назад

yes you can, do a right click on the button and go to 'preferences'. There you can modify the color of the button or text color

@xriso1437 3 года назад

@@LajeunesseLab Thank you very much for your response was very helpful! But when i change this settings that you referred to when i press the button of the inclusion does not display at the screen cell "include" in green colour.

@LajeunesseLab 3 года назад

@@xriso1437 Oh I see, in my first comment I thought you meant changing the button colors. Yes you can also change the color of the "INCLUDE" or "EXCLUDE" decisions by adding this additional line to the VB button code outlined in the video (below will change the color of "INCLUDE" to blue; you can modify to vbRed for the "EXCLUDE" button): Private Sub CommandButton1_click() i = Range("BL2").Value Range("BG" & i + 1).Value = "INCLUDE" Range("BG" & i + 1).Font.Color = vbBlue Range("BL2").Value = i + 1 End Sub

@xriso1437 3 года назад

Thank you very much. That works perfectly.

@harshotsai 2 года назад

@@LajeunesseLab Possible to have another guidance video from you demonstrating semi-automatic population of' exclusion reasons' when a citation is excluded (as it's imperative for most of the SLR's to provide reasoning for exclusion of citation). Thanks in advance.

@naoremanand 2 года назад

Dear can you please share any video where i have to know the basics before starting a meta analysis?

@LajeunesseLab 2 года назад

I am planning to do these types of videos, in the mean time I have a course where I conduct an entire meta-analysis from start to end: ru-vid.com/group/PLMDcoG6cxhI0JRfmuv3AwT9Sy0FQNMqCL

@zemzezeze6546 3 года назад

Super helpful, thanks!

@LajeunesseLab 3 года назад

Glad it was helpful!

@harshotsai 2 года назад

@@LajeunesseLab Possible to have another guidance video from you demonstrating semi-automatic population of 'exclusion reasons' when a citation is excluded (as it's imperative for most of the SLR's to provide reasoning for exclusion of citation). Thanks in advance.