Share
Explore

icon picker
Time series scenario modeling

How to use Coda to create dynamic time series models with simple scenario evaluation

Goals of this template:

I was wondering how Coda might be used for dynamic + time series + scenario modeling, as I was pondering how I might go about building a Coronavirus public policy decision making tool (a holistic view of public policy choices that balance health system risk vs economic risk).
Thanks to some quick help from the Coda staff, I think this approach would actually scale really nicely. The Coda benefits would be that it could allow for an interactive published website model, where users could easily add their own scenarios, and have the model automatically compute and compare outputs.
image.png

Doc structure

- where users could easily add their own scenarios with custom values
- houses the model logic. I've created a simple exponential function here. But could easily be adapted to have more columns, or more interdependent tables
- Uses Coda's capable charting features to visualize the underlying data.
Model!
button would run all of the data generation "at the push of a button".
Scenarios Definition
Scenario
Start_Date
End_Date
Initial data
BTN_Create_Time
1
Scenario A
04/05/2020
25/05/2020
1.2
+
2
Scenario B
04/05/2020
25/05/2020
1.15
+
3
Your Scenario
+
There are no rows in this table
3
Count
Model!
|
Build Model
Clear Rows

Scenario matches:
Blank
Time series Chart
1


Time series Model
1
Date
Scenario
Data
1
04/05/2020
Scenario A
1
2
05/05/2020
Scenario A
1
3
06/05/2020
Scenario A
2
4
07/05/2020
Scenario A
2
5
08/05/2020
Scenario A
2
6
09/05/2020
Scenario A
3
7
10/05/2020
Scenario A
4
8
11/05/2020
Scenario A
4
9
12/05/2020
Scenario A
5
10
13/05/2020
Scenario A
6
11
14/05/2020
Scenario A
7
12
15/05/2020
Scenario A
9
13
16/05/2020
Scenario A
11
14
17/05/2020
Scenario A
13
15
18/05/2020
Scenario A
15
16
19/05/2020
Scenario A
18
17
20/05/2020
Scenario A
22
18
21/05/2020
Scenario A
27
19
22/05/2020
Scenario A
32
20
23/05/2020
Scenario A
38
21
24/05/2020
Scenario A
46
22
25/05/2020
Scenario A
55
23
26/05/2020
Scenario A
66
24
04/05/2020
Scenario B
1
25
05/05/2020
Scenario B
1
26
06/05/2020
Scenario B
2
27
07/05/2020
Scenario B
2
28
08/05/2020
Scenario B
2
29
09/05/2020
Scenario B
2
30
10/05/2020
Scenario B
3
31
11/05/2020
Scenario B
3
32
12/05/2020
Scenario B
4
33
13/05/2020
Scenario B
4
34
14/05/2020
Scenario B
5
35
15/05/2020
Scenario B
5
36
16/05/2020
Scenario B
6
37
17/05/2020
Scenario B
7
38
18/05/2020
Scenario B
8
39
19/05/2020
Scenario B
9
40
20/05/2020
Scenario B
11
41
21/05/2020
Scenario B
12
42
22/05/2020
Scenario B
14
43
23/05/2020
Scenario B
16
44
24/05/2020
Scenario B
19
45
25/05/2020
Scenario B
22
46
26/05/2020
Scenario B
25
There are no rows in this table
46
Count
Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.