[STEP1: Preparing a Calender]
Since we use calender without any modification, there's nothing we specially need to do.
- Create a empty calendar
- Add money transaction events
- Where: the money amount (e.g. 1000, -1000)
- Description: event label on the chart
- Guest can () invite others option: Cash (check), Non-cash (uncheck)
- Remember the start/end date of transaction entry
[STEP2: Creating Cashflow]
- Create a empty spreadsheet
- Find and insert the 'EGO Cashflow' script from the
Apps Script Gallery View Code below.
- Specify three fields on the first row of the active (selected) sheet
- A1: Calendar name in your calendar collection
- A2: Start date
- A3: End date
- From the top menu bar, click 'Cashflow' button and choose 'Build'
- Confirm the money transaction events were parsed and printed correctly
- Build a trend-type chart
- datasource 1: Sheet1!C1:E100
- datasource 2: Sheet1!F1:G100
- datasource 3: Sheet1!H1:H100
- Populate a chart
That's all. Enjoy it~
tag:business | tag:script | tag:calendar | tag:demo | tag:visualization |