Submit a Project
Rate how strongly this project drives business outcomes across 5 weighted dimensions.
📋 Project Details
🎯 Business Impact Scoring

Score each dimension 1–10. Scores are weighted to calculate a composite business priority score.

Composite Business Priority Score
Weighted across all 5 dimensions
—
📝 Additional Notes
Project Rankings
Live ranking by composite business priority score. Admins can drag to reorder.
  • 📊
    Loading rankings...

    Fetching projects from database.

Admin — Score Overrides
Review submitted projects, override scores, and manage visibility.
Project Team Category Self Score Override Final Status Actions
⏳
Loading...
Setup & Configuration
Connect your MySQL database (via the PHP API) and configure credentials.
🗄️ API Connection

If api.php is hosted in the same folder as this page, leave the default. Only change this if your API lives at a different path or domain.

🔐 Credentials
Contributor Login
Admin Login
📦 Database Setup — Run schema.sql in phpMyAdmin

This was already run for you against the PPIO database. Shown here for reference only.

CREATE TABLE IF NOT EXISTS projects (
  id           CHAR(36)     NOT NULL,
  name         VARCHAR(255) NOT NULL,
  team         VARCHAR(255) NULL,
  category     VARCHAR(100) NULL,
  description  TEXT NULL,
  timeline     VARCHAR(50)  NULL,
  effort       VARCHAR(50)  NULL,
  notes        TEXT NULL,
  scores       JSON NOT NULL,
  composite    DECIMAL(5,2) NULL,
  `override`   DECIMAL(5,2) NULL,
  final_score  DECIMAL(5,2) NULL,
  rank_order   INT NULL,
  status       VARCHAR(20)  NOT NULL DEFAULT 'pending',
  created_at   TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at   TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;