Started with Texas rebate program for game development, you have to track and report those costs. So Redfly wanted to track project costs.
People get source, work, check in (mostly working) code. So maybe SCM activity is a gauge of work.
Use perl script to get info from P4 and put into a MySQL database – files, revs, changelists.
Could use Excel PivotTables to get percent worked on each project each week by each person. Graph in Excel to see if we were crunching or working effectively.
Graph of commits roughly corresponds to known events like crunch, project hold, and team methodology. However, sounds fairly speculative. Even motivation and promotions.
You can’t tell if someone is working hard, just what they are (probably) working on and relative effects of changed. Even down to assets