I created a free Google Sheets tool that provides fair, nuanced evaluation of contributions.
The problem it solves:
GitHub: “Developer A has 1,913 additions” → appears to be top contributor
This tool: “Developer A: 1,810 pts (40% features, 32% bug fixes, 10% testing)” → shows actual work composition and value
Smart features: • Automatically excludes starter code and library imports • Skips merge commits (no credit for just combining branches) • Minimum line thresholds prevent gaming • Tracks net changes (editing same lines repeatedly doesn’t inflate score) • Uses GitHub username to prevent duplicate entries
Use cases: CS course grading, team analytics, recognizing diverse contribution types beyond just code
Free, open source, runs entirely in Google Sheets (no installation).
https://github.com/kyliemckinleydemo/github-contribution-tra...