I have about 5 hours of coding time into this and just wanted to share my progress thus far. The picture below only shows the v1.0 of the reporting gui and the static image doesn't do it justice. You can zoom in and out of the graph, remove data points, show the setpoints, or even change the timeframes all without page reloading. The cost figures are real and as exact as I'd think you could get.
The system runs via php/mysql.
The system is very lean(only about 400 lines of code for everything) and very fast.
[attachment=0]Untitled2.png[/attachment]
