Insight Reports and Macros for Expiration Dates

In this session on 7/27/2021, learn about Insight Reports and Running Macros focused on expiration dates and continuing reviews. Understand the impact of IRBNet Insight Reports, accessing them, and utilizing Microsoft Excel macros for formatting. Dive into how to request and receive Insight Reports from IRBNet to enhance your work. Explore the guidance documents available for maximizing the benefits of these reports.

• Reports
• Macros
• Expiration Dates
• IRBNet
• Insight

ttre Follow

Uploaded on Feb 17, 2025 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.

Presentation Transcript

1. Dial in: 1 404 397 1596 Access Code: 199 606 - 7259 Slides in Handout Tab VAIRRS How-To Series 3 Insight Reports and Running Macros Focused on Expiration Dates and Continuing Reviews 7/27/2021

2. Dial in: 1 404 397 1596 Access Code: 199 606 - 7259 Slides in Handout Tab Presenters Office of Research Protections, Policy, and Education Goldschmitt and Associates Angela Foster PM/COR, VAIRRS and VAEDA Department of Veterans Affairs Office of Research Protections, Policy, and Education (ORPP&E) 810 Vermont Avenue, NW Washington, DC 20420 Phone: (202)-443-5822 Email: angela.foster@va.gov Nelson Vasconcelos Senior Management Analyst Goldschmitt and Associates LLC Phone: (410)336-4299 Email: nvasconcelos@goldschmitt.com 2

3. Dial in: 1 404 397 1596 Access Code: 199 606 7259 Slides in Handout Tab Overview of Session An overview of IRBNet Insight Reports and how they can impact your work Accessing Insight Reports Live Demo of Macros Active Projects Project Expiration Review Process Feedback Q&A 3

4. Dial in: 1 404 397 1596 Access Code: 199 606 - 7259 Slides in Handout Tab Poll Question #1 Have you used an Excel macro in your work? (Please answer question in the pop-up window in WebEx) 4

5. Dial in: 1 404 397 1596 Access Code: 199 606 - 7259 Dial in: (415) 655-0060 Access Code: 812-008-474 Slides in Handout Tab Slides in Handout Tab IRBNet Insight Reports IRBNet Insight Reports provide a detailed set of data extracts from VAIRRS Provide unique and timely views of operations at all VHA sites that are online in IRBNet ORPPE is developing a series of Microsoft Excel macros that format the Insight reports into a more user-friendly format 5

6. Accessing the Insight Reports IRBNet can send the reports that best fit your needs on a regular basis (daily, weekly, bi-weekly, etc.) To request the reports, email GovSupport@irbnet.org and let them know which reports you d like and how often you d like to receive them Refer to the VAIRRS SharePoint portal for supporting documents IRBNet Insight Reporting Guide Getting the Most out of Insight Reports Guidance Document 6

7. Live Demo 7

8. Poll Question #2 Which Insight Reports do you currently use? How can macros make those reports easier to use? (Please type your answer in the pop-up window in WebEx) 8

9. Important Links and Documents VAIRRS SharePoint Portal: VA Innovation and Research Review System (VAIRRS) - Getting the Most out of Insight Reports- June 2020 - All Documents (sharepoint.com) Includes the following documents: IRBNet Insight Reporting Guide Getting the Most Out of Insight Reports Guidance Document Macro File (updated as new macros are created) Recording and Slides from this Webinar VA Innovation and Research Review System (VAIRRS) - Home (sharepoint.com) VAIRRS Home Page Recording of the previous webinar, VAIRRS How To Series 2: Getting the Most Out of Insight Reports 9

10. User Support Questions regarding Insight Reports (Receiving the reports, how they are used, etc.): email GovSupport@irbnet.org Questions regarding opening Insight Reports and using the macros: email Nelson Vasconcelos at nelson.vasconcelos@va.gov 10

11. Availability of Recording A recording of this session and the associated handouts will be available on ORPP&E s Education and Training website approximately one-week post-webinar An archive of this and other webinars can be found here: https://www.research.va.gov/programs/orppe/education/webi nars/archives.cfm 11

12. Q&A Please type any questions you may have in the Q&A box. We will try to answer everyone s questions before the close of the hour. 12