Create VCEP Alert/Priority Variant Tracker Reports for Approved VCEPs

[dazzariti]

Discussed on Feb 14 to be announced on Feb 15 CDWG Leadership call

Report Submitter tab has been updated https://docs.google.com/spreadsheets/d/1bADskBcobHTmmXungY09beWPDEa1nqM-PP__86yGVj0/edit?usp=sharing

Approved VCEP list:

ACADVL Variant Curation Expert Panel Brain Malformations Variant Curation Expert Panel Cardiomyopathy Variant Curation Expert Panel CDH1 Variant Curation Expert Panel Cerebral Creatine Deficiency Syndromes Variant Curation Expert Panel DICER1 and miRNA-Processing Gene Variant Curation Expert Panel Familial Hypercholesterolemia Variant Curation Expert Panel FBN1 Variant Curation Expert Panel Glaucoma Variant Curation Expert Panel Hearing Loss Variant Curation Expert Panel Hereditary Breast, Ovarian and Pancreatic Cancer Variant Curation Expert Panel InSiGHT Hereditary Colorectal Cancer/Polyposis Variant Curation Expert Panel (have not submitted to ClinVar yet) Lysosomal Storage Disorders Variant Curation Expert Panel Malignant Hyperthermia Susceptibility Variant Curation Expert Panel Mitochondrial Disease Nuclear and Mitochondrial Variant Curation Expert Panel Monogenic Diabetes Variant Curation Expert Panel Myeloid Malignancy Variant Curation Expert Panel Phenylketonuria Variant Curation Expert Panel Platelet Disorders Variant Curation Expert Panel PTEN Variant Curation Expert Panel RASopathy Variant Curation Expert Panel Rett and Angelman-like Disorders Variant Curation Expert Panel TP53 Variant Curation Expert Panel

[larrybabb]

@dazzariti is this the same as #19?

[dazzariti]

19 was intended to be for all VCEPs not just the approved ones submitting to ClinVar - I created this new one today as a short term task based on our discussion at this morning's meeting

[larrybabb]

@dazzariti All of the above reports should be ready for use. Please check to make sure you can "refresh" each one. and check out the "How To Use" help window. They are here

[dazzariti]

@larrybabb The "How to Use" still runs a script and asks for permission - is that the intent? We could just link the How to Document there if that's easier.

[larrybabb]

Does it ask every time? or just the first time a new user clicks it? If it does it every time then there must be some permission on the google doc that is causing it (guessing).

On Wed, Feb 15, 2023 at 10:09 AM dazzariti @.***> wrote:

@larrybabb https://github.com/larrybabb The "How to Use" still runs a script and asks for permission - is that the intent? We could just link the How to Document there if that's easier.

— Reply to this email directly, view it on GitHub https://github.com/clingen-data-model/clinvar-google-sheets/issues/22#issuecomment-1431520296, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHKEG5HQQSLNVM7KY3B7P3WXTWR3ANCNFSM6AAAAAAU34BSOA . You are receiving this because you were mentioned.Message ID: @.***>

-- Larry Babb Principal Software Engineer Clinical Genome Resource I clinicalgenome.org http://www.clinicalgenome.org Broad Institute of MIT and Harvard @.***

[dazzariti]

It was just many clicks to run the script but then I didn't need to do it again. Just to confirm, this text will automatically refresh if the linked Google doc is updated?

[larrybabb]

It should. Here's how it works. In the google doc under the File:Share menu I selected publish

then I copied that link into the script that displays the published version of the google doc in the google sheet's "How To Use" function

Since I checked the "Automatically republish when changes are made" option it should update the published link I use as soon as you make changes.

If someone messes with the publish options on that doc then we might have issues.