...
An excel template is attached here. It provides predefined tables and graphs for team members to update with new values on a quarterly basis. Excel provides an easy path to exporting the graphs as PNGs/GIFs through the file / save as web publishing wizard. The resullting files are copied to the measures locker in AFS, where they can be copied into Drupal by the production@mit.edu team.. The team production team wants to be notified of the new files by receiving an email of the mockup2.htm file produced by Excel.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
|
...
How To Release a New Version
The graphs on the web page are generated from Excel with its Save As Web feature. As part of creating an html replica of the worksheet page, png and gif renditions of the graphs are copied to a folder related to the excel workbook. We send the htm file to production@mit.edu and ask them to integrated the newly produced graphics into Drupal in the right places for display on the page.
To update the excel worksheet, download a copy of the workbook mockup2.xlsx from the IS&T Measures wiki page to a local folder on your machine. Open it in excel and update data tables until you're done. Then put the book back. If you are adding a new time period, you want to copy all but the oldest up a line, then update the newest label and data. This rolls the oldest data off of the table and out of the chart. See Rob if you don't what this would mean.
The measures locker in AFS is the target location for the graphics files. On a PC running afs, mount /afs/athena/project/measures as M: and file save as web the worksheet to M:\pfm2010\mockup2.htm. Email the resulting report to production; they will follow the embedded links to the graphics source files. They will use the png version.for greater color depth (32 bits instead of 8 for gif). See http://web.mit.edu.ezproxyberklee.flo.org/measures/pfm2010/mockup2.htm for the latest export of the worksheet and graphs.
Finally, upload the mockup2.xlsx back into the wiki with the Browse and Attach buttons.
(Sadly there is no record-locking on the spreadsheet, but past versions are archived and can be retrieved if there is a collision.)
Metrics Definitions and Means of Production
Definitions
These pages describe all the necessary assumptions about each measure, along with the default "story", current target value, issuss and assumptons that provide nuanced understanding of the thing.
...