Share
Explore

icon picker
Time series scenario modeling

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

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

⁠
Scenarios Definition
⁠
- where users could easily add their own scenarios with custom values
⁠
Time series Model
⁠
- 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
⁠
Time series Chart
⁠
- 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
0
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
⁠
Goals of this template:
Doc structure
Scenarios Definition
Time series Chart
Time series Model
Gallery
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.