Shivam Patel

seed-fund-tracking

IWRC Seed Fund Tracking Analysis

0
0
0
HTML
public
View on GitHub

IWRC Seed Fund Tracking & Analysis System

Illinois Water Resources Center (IWRC) - Comprehensive tracking and analysis of research funding, student outcomes, and project impact across fiscal years 2016-2024.

🎯 Quick Start

Open Navigation Hub - Modern, dynamic IWRC-branded interface to browse all content

✨ New: Dynamic Updates

The repository now features automatic data updates and a modern UI. See Dynamic Updates Guide for details.

# Update repository metadata after changes
python3 scripts/update_repo_metadata.py

📊 Repository Overview

This repository contains:

  • 77 projects analyzed (2015-2024)
  • $8.5 million in investment tracked
  • 304 students supported
  • 14 Illinois institutions funded

November 2025 - Major Repository Reorganization & Dynamic System

The repository has been completely reorganized with improved structure, IWRC branding, and comprehensive navigation:

✅ Clean Organization - Logical separation of deliverables, analysis, data, and assets
✅ IWRC Branding - Professional branded index pages and CSS theme
✅ Comprehensive Documentation - README.md in every major folder
✅ 45% Size Reduction - Removed 128 MB of duplicates (282 MB → 154 MB)
✅ Dynamic Updates - Automatic metadata updates and modern responsive UI
✅ Improved Navigation - Card-based navigation hubs with smooth animations

📁 Repository Structure

seed-fund-tracking/
├── index.html                    # 🏠 Main navigation hub (START HERE - Dynamic)
├── README.md                     # This file
│
├── config/                       # ⚙️ Configuration
│   └── repo-metadata.json        # Dynamic metadata for index.html
│
├── deliverables_final/           # 📊 All final outputs
│   ├── index.html                # Deliverables navigation
│   ├── 1_Executive_Reports/      # Executive summaries
│   ├── 2_Detailed_Reports/       # In-depth analysis
│   ├── 3_Data_Files/             # Excel data files
│   ├── 4_Visualizations/         # Static & interactive charts
│   └── 5_Archive/                # Historical versions
│
├── data/                         # 📁 Source and processed data
│   ├── source/                   # Original FY reports
│   ├── consolidated/             # Main tracking database
│   └── outputs/                  # Analysis results
│
├── analysis/                     # 🔬 Analysis code
│   ├── notebooks/                # 8 Jupyter notebooks
│   └── scripts/                  # 42+ Python scripts
│
├── scripts/                      # 🔧 Utility scripts
│   └── update_repo_metadata.py   # Auto-update metadata
│
├── assets/                       # 🎨 Branding and design
│   ├── branding/                 # Logos, fonts, guidelines
│   └── styles/                   # Shared CSS theme
│
└── docs/                         # 📚 Documentation (23 files)
    └── DYNAMIC_UPDATES_GUIDE.md  # Dynamic system guide

🚀 Quick Access

For Stakeholders & Leadership

For Researchers & Analysts

For Developers

📊 Deliverables Summary

Reports (6 PDFs)

Executive Reports:

  • Executive Summary (38 KB) - Program overview with key metrics
  • Fact Sheet (33 KB) - One-page impact snapshot
  • Financial Summary (22 KB) - ROI and financial analysis

Detailed Reports:

  • Detailed Analysis Report (342 KB) - Comprehensive analysis with charts
  • Project Type Analysis - 104B Only (24 KB) - Base grant breakdown
  • Project Type Analysis - All Projects (25 KB) - Complete breakdown

Visualizations (51 total)

Static Charts (36 PNGs) - Organized by category:

  • Overview (4): Investment, ROI, project trends
  • Institutions (4): Reach, funding distribution
  • Students (3): Training outcomes
  • Topics (7): Research area analysis
  • Awards (10): Award type comparisons
  • Project Types (8): Type breakdowns

Interactive Dashboards (15 HTML):

  • Core (5): ROI, detailed analysis, investment, students, timeline
  • Geographic (2): Illinois institutions maps
  • Award Types (3): Award analysis dashboards
  • Project Types (4): Interactive breakdowns

💻 Technical Setup

Prerequisites

# Python 3.8+ required
pip install pandas numpy matplotlib plotly openpyxl reportlab folium

Running Analysis

# Launch Jupyter for notebooks
jupyter notebook analysis/notebooks/

# Run specific analysis scripts
python analysis/scripts/generate_static_visualizations.py

Generating Deliverables

# Execute all notebooks in order
python analysis/scripts/execute_notebooks.py

# Generate final reports and visualizations
python analysis/scripts/generate_final_deliverables_v2.py

📖 Documentation

Core Docs

Guides

All Documentation

See docs/ folder for complete documentation (22 files)

🎨 IWRC Branding

Brand Colors

  • Primary: #258372 (Teal)
  • Secondary: #639757 (Olive)
  • Text: #54595F (Gray)
  • Accent: #FCC080 (Peach)

Typography

  • Font Family: Montserrat (Regular, Bold)
  • Headers: Bold weight
  • Body: Regular weight

See IWRC_BRANDING_GUIDELINES.md for complete specifications.

📈 Key Metrics (2015-2024)

  • Projects: 77 unique projects
  • Investment: $8,516,278 (10-year), $7,319,144 (5-year)
  • Students: 304 total trained
  • Institutions: 14 Illinois institutions
  • ROI: 3% overall return on investment

🔄 Data Updates

Update Procedure

  1. Add new FY report to data/source/
  2. Update data/processed/clean_iwrc_tracking.xlsx
  3. Run analysis notebooks in analysis/notebooks/current/
  4. Regenerate deliverables with scripts in analysis/scripts/

Current Data Coverage

  • Source: FY2016 - FY2024 (9 fiscal years)
  • Analysis Period: 2015-2024 (10-year period)
  • Last Updated: November 27, 2025

🤝 Contributing

For questions or contributions:

  1. Review documentation in docs/
  2. Check METHODOLOGY.md for analysis approach
  3. Follow IWRC branding guidelines

📞 Contact

Illinois Water Resources Center (IWRC)
University of Illinois System

📄 License

Data and analysis for Illinois Water Resources Center internal use and reporting.

Navigation: Home | Deliverables | Data | Analysis | Docs

Last Updated: November 27, 2025 | Repository Size: 154 MB | Version: 2.0 (Reorganized)

v0.3.1[beta]