tniswong/leansheets

A tool that creates charts for Lean and Kanban based off of a Google Spread Sheet.

LeanSheets

A tool that creates Cumulative Flow, Histogram, and Control charts for Kanban systems based off of a Google Spread Sheet.

Life Cycle

1. Loads /config.json
2. Loads the Configuration from your Google Spread Sheet that you have defined
3. Fires a $broadcast event to other chart's controllers for them to draw their chart

Installing & Running

Currently there is no home for LeanSheets so you will have to clone the repo and run it locally. You'll also need a Google Spread Sheet that you can link to for LeanSheets to work. If you would like an example sheet please open an issue as I'm in the process of making one that can be the example/demo sheet.

1. Clone the following repo: https://github.com/paulsjv/leansheets

• The master branch is what you want. It's the latest version.

2. Make sure you have Nodejs installed on your system. Next run the following commands to install everything.

$> npm install
$> bower install

3. Update the ./src/config.json file to be like below (Google Sheet is the demo I'm currently working on):

{
    "configUrl": "https://docs.google.com/a/google.com/spreadsheet/ccc?key=12cvMUMnWEKynGTsyXQywvJ9drpjYAyyo0-2cnTUJSFw&usp=drive_web&gid=44020743#",
    "dataUrl": "https://docs.google.com/a/google.com/spreadsheet/ccc?key=12cvMUMnWEKynGTsyXQywvJ9drpjYAyyo0-2cnTUJSFw&usp=drive_web&gid=497466409#",
    "debugEnabled": true,
    "showAllWork": true,
    "cacheTtl": 300,
    "datePickerFormat": "mm/dd/yyyy",
    "datePickerMomentFormat": "MM/DD/YYYY",
    "queryDateMomentFormat": "YYYY-MM-DD",
    "defaultHistoricalNumberOfDays": 60
}

NOTE: The configUrl and dataUrl must be of the form https:https://docs.google.com/spreadsheet/ccc?key=&gid=. If the url is of the form https://docs.google.com/spreadsheets/d//edit#gid= then translate it into the above expected format.

4. Run the following command to install grunt-cli if you have not done so already.

   $> npm install -g grunt-cli
   

5. Run the following command to start the server.

   $> grunt run
   

Running Tests

Coming Soon