9e2b362b08d98f124730f55fcff4254d97fcb158
brianlee
  Thu Oct 16 12:12:58 2025 -0700
Adding UCLA, MiNND, WUSTL spreadsheet link clicks on milestone mermaid chart

diff --git src/hg/cirm/gateway/htdocs/sspsygeneTimeline.html src/hg/cirm/gateway/htdocs/sspsygeneTimeline.html
index 1032a536bdb..adf7691e575 100755
--- src/hg/cirm/gateway/htdocs/sspsygeneTimeline.html
+++ src/hg/cirm/gateway/htdocs/sspsygeneTimeline.html
@@ -20,34 +20,36 @@
   </div>
   <a name="ADGC1"></a>
   <!-- Start of ADGC1 Henry Gantt Chart-->
   <div class="cirm-page-title back-light-blue"><h5 class="cirm-page-title-text">ADGC 1 UCLA Chart</h5></div>
   <div class="row">
     <div class="col-md-12">
     <pre class="mermaid">
     gantt
     dateFormat  YYYY-MM-DD
     axisFormat  %Y-Q%q
     title       ADGC1  UCLA
 
 
     section Grant Year                                                                           
     Start Grant Year 2     :milestone, m1, 2024-03-31, 0d                                       
-    Start Grant Year 3     :milestone, m1, 2025-03-31, 0d                                       
+    Start Grant Year 3     :milestone, year3_ucla, 2025-03-31, 0d                                       
     Start Grant Year 4     :milestone, m1, 2026-03-31, 0d                                        
     Start Grant Year 5     :milestone, m1, 2027-04-01, 0d
 
+    click year3_ucla href "https://docs.google.com/spreadsheets/d/1Ml_UXDHE4UZo2kjLp1aZLa0KxLtLSnVi/edit?gid=1138387919#gid=1138387919"
+        
     section AIM 1 
     Generate stable clonal iPSC lines for additional 25 gene mutations in KOLF2.2J and CIRM (BATCH B)    :        t3, 2024-04-01, 2024-09-30
     QC of Capstone  lines to date pending    : t4, 2024-04-01, 39w
     Generate and QC stable clonal iPSC lines for additional 65 gene mutations in KOLF2.2J and CIRM   :    t6, after t3, 52w
     QC of all generated lines to date pending   :   t7, after t3, 78w
     Share 20 BATCHA gene edited iPSC lines (10 NPD genes x 2 iPSC backgrounds)   :  t8, after t4, 26w
     Share  180 BATCH B+C  gene edited iPSC lines (90 NPD genes x 2 iPSC backgrounds)  : t10,  after t8, 39w
     Troubleshoot and perform 2nd attempt of difficult KO genes :  t11, after t10, 13w
 
     section AIM 2
     Quantify proliferation rates of NPCs from 10 Capstone iPSC clonal lines  : t5, after t1, 26w       
     Quantify proliferation rates of NPCs from all  iPSC clonal lines from all batches    : t9, after t4, 52w
     Bulk RNA-seq profiles (4 replicates per gene  x (10 NPD iPSC lines + 2 controls) x 1 background (KOLF2.2J) iPSC background lines; fastq))  :  t20, after t2, 52w
     Submit data from first capstone experiment (KOLF2.2J background)  :crit, t22, after t20, 13w
     Bulk RNA-seq profiles ((4 replicates per gene  x (10 NPD iPSC lines + 2 controls) x 1 background (CIRM line) iPSC background lines; fastq)) :  t21, after t3, 39w
@@ -100,34 +102,36 @@
     </div>
   </div>
   <a name="ADGC2"></a>
   <!-- Start of ADGC2 Henry Gantt Chart-->
   <div class="cirm-page-title back-light-blue"><h5 class="cirm-page-title-text">ADGC2 MiNND timeline</h5></div>
   <div class="row">
     <div class="col-md-12">
       <pre class="mermaid">    
         gantt
         dateFormat  YYYY-MM-DD
         axisFormat  %Y-Q%q
         title       ADGC2  MiNND
 
         section Grant Year
         Start Grant Year 2     :milestone, m1, 2024-03-31, 0d
-        Start Grant Year 3     :milestone, m1, 2025-03-31, 0d
+        Start Grant Year 3     :milestone, year3_minnd, 2025-03-31, 0d
         Start Grant Year 4     :milestone, m1, 2026-03-31, 0d
         Start Grant Year 5     :milestone, m1, 2027-04-01, 0d
 
+        click year3_minnd href "https://docs.google.com/spreadsheets/d/1GNrJaIjs6nPlFY4j2AlZSlTDf2-mi17d/edit?gid=1137576441#gid=1137576441"
+        
         section Aim 1
         Generated 217 new lines including 10 NTC (total 332 lines). We generated iNs from 180 lines.  :done, IIt1, 2024-04-01, 2025-04-01
         Production of 72 iPSC lines on average per quarter (3 batches of 23 gene mutations + 1 NTC) :   IIt2, after IIt1,13w
         Production of 72 iPSC lines on average per quarter (3 batches of 23 gene mutations + 1 NTC) :   IIt3, after IIt2,13w
         Production of 72 iPSC lines on average per quarter (3 batches of 23 gene mutations + 1 NTC) :   IIt4, after IIt3,13w
         Production of 72 iPSC lines on average per quarter (3 batches of 23 gene mutations + 1 NTC) :   IIt5, after IIt4,13w
 
         section Aim 2
         Submitted scRNA-seq data for 157 lines to the DRACC. : done, IIt6, 2024-04-01,52w
         Submit scRNA-seq data for 72 edited lines (3×23 gene mutations + 1 NTC) from last quarter. :crit,   IIt7, after IIt6,13w
         Submit scRNA-seq data for 72 edited lines (3×23 mutations + 1 NTC) & L1-L3 datasets (fastq, RDS, Excel) from last year. :crit,   IIt8, after IIt7,13w
         Submit scRNA-seq data for 72 edited lines (3×23 mutations + 1 NTC) & L1-L3 datasets (fastq, RDS, Excel) from last quarter. :crit,   IIt9, after IIt8,13w
         Submit scRNA-seq data for 72 edited lines (3×23 mutations + 1 NTC) & L1-L3 datasets (fastq, RDS, Excel) from last quarter.  :crit,   IIt10, after IIt9,13w
         Submitted 113 lines morphometrics imaging data. :done, IIt11, 2024-04-01,52w
         Submit Imaging of 72 iPSC lines (3×23 mutations + 1 NTC) & prior quarter L1-L3 :crit,   IIt12, after IIt11,13w
@@ -383,33 +387,35 @@
   <div class="row">
     <div class="col-md-12">
       <pre class="mermaid">
         gantt
         dateFormat  YYYY-MM-DD
         axisFormat  %Y-Q%q
         title       ADGC7  Washington Univ. St Louis - WUSTL
 
         section Grant Year
         Start Grant Year 2     :milestone, m1, 2024-03-31, 0d
         Start Grant Year 3     :milestone, m1, 2025-03-31, 0d
         Start Grant Year 4     :milestone, m1, 2026-03-31, 0d
         Start Grant Year 5     :milestone, m1, 2027-04-01, 0d
 
         section WUSTL Reporting Year
-        End WUSTL Reporting Year 1      :milestone, m1, 2025-12-31, 0d
+        End WUSTL Reporting Year 1      :milestone, year1_wustl, 2025-12-31, 0d
         End WUSTL Reporting Year 2      :milestone, m1, 2026-12-31, 0d
 
+        click year1_wustl href "https://docs.google.com/spreadsheets/d/1ae4bX4Ful2AWlqzeH_JOo4jFssmEsojd/edit?gid=1888128068#gid=1888128068"
+
         section Aim 1
         L0, L1 Data from last quarter submitted, and 3 more lines collected : crit, milestone, ADGC7_E_12, 2025-12-31, 0d
         L0, L1 Data from last quarter submitted, and 4 more lines collected : crit, milestone, ADGC7_F_12, 2026-03-31, 0d
         L2, L3 from prior L0,L1 data submitted : crit, milestone, ADGC7_F_13,  2026-03-31, 0d
 
         section Aim 2
         Home Cage Behavior L0-L1 Data to DRACC for lines 1-2 : crit, milestone, ADGC7_C_17, 2025-07-01, 0d
         Home Cage Behavior L0-L1 Data to DRACC for line 3-4 : crit, milestone, ADGC7_D_17, 2025-09-30, 0d
         Home Cage Behavior L0-L1 Data to DRACC for lines 5-7 : crit, milestone, ADGC7_E_17, 2025-12-31, 0d
         Home Cage Behavior L3 Data to DRACC for lines 1-2 : crit, milestone, ADGC7_D_18, 2025-09-30, 0d
         Home Cage Behavior L3 Data to DRACC for line3-4 : crit, milestone, ADGC7_E_18, 2025-12-31, 0d
         Home Cage Behavior L3 Data to DRACC for lines 5-7 : crit, milestone, ADGC7_F_18,  2026-03-31, 0d
         Home Cage Behavior L4 Data to DRACC for lines 1-2 : crit, milestone, ADGC7_E_19, 2025-12-31, 0d
         Home Cage Behavior L4 Data to DRACC for lines 3-4 : crit, milestone, ADGC7_F_19,  2026-03-31, 0d
         IB & SI L0 Data to DRACC for lines 1-2 : crit, milestone, ADGC7_C_20, 2025-07-01, 0d