I would like to create a table with Coronavirus case counts for the state of Utah in the United States. I have a table with two columns: a date column and a column of total new cases for that day in my state. I would like Org to generate a third column that is a cumulative sum of all the previous case counts.
The output should look like this:
|------------------+----+-----|
| <2020-02-27 Thu> | 0 | 0 |
| <2020-02-28 Fri> | 1 | 1 |
| <2020-02-29 Sat> | 0 | 1 |
| <2020-03-01 Sun> | 0 | 1 |
| <2020-03-02 Mon> | 0 | 1 |
| <2020-03-03 Tue> | 0 | 1 |
| <2020-03-04 Wed> | 1 | 2 |
| <2020-03-05 Thu> | 1 | 3 |
| <2020-03-06 Fri> | 2 | 5 |
| <2020-03-07 Sat> | 2 | 7 |
| <2020-03-08 Sun> | 1 | 8 |
| <2020-03-09 Mon> | 0 | 8 |
| <2020-03-10 Tue> | 1 | 9 |
| <2020-03-11 Wed> | 3 | 12 |
| <2020-03-12 Thu> | 5 | 17 |
| <2020-03-13 Fri> | 6 | 23 |
| <2020-03-14 Sat> | 13 | 36 |
| <2020-03-15 Sun> | 11 | 47 |
| <2020-03-16 Mon> | 8 | 55 |
| <2020-03-17 Tue> | 22 | 77 |
| <2020-03-18 Wed> | 13 | 90 |
| <2020-03-19 Thu> | 31 | 121 |
| <2020-03-20 Fri> | 27 | 148 |
| <2020-03-21 Sat> | 33 | 181 |
| <2020-03-22 Sun> | 69 | 250 |
| | | |
|------------------+----+-----|
#+TBLFM: $3=$2+@-1$3
But when I run C-u C-c *
to recompute the entire table line by line, that generates the error:
row descriptor -1 leads outside table
Also, I would appreciate if anyone knows how to plot this data using gnuplot or perhaps just an ascii plot.